Lawson Insight Technical Documentation |
|
OEINVCTAX
OEINVCTAX FILE
Invoice Taxes
This file stores the tax records assessed when processing an order or
invoice. These records store the invoice and invoice line being taxed, the tax
code used, and the rate of the tax, as well as the amount of the tax in both
company base currency and billing currency.
REFERENCED BY
BL121 BL123 BL290 BL80.1 BL81.1 TX101
UPDATED BY
BL120 BL122 BL130 BL20.1 BL20.3 BL21.2
BL21.5 BL29.1 BL29.2 BL320 BL520 BL820
BL92.1 OE114 OE129 OE30.1 OE30.2 OE30.3
OE30.4 OE30.5 OE30.6 OE30.7 OE30.9 OE310
OE330 OE530 OE830
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
OIT-COMPANY Numeric 4 BL120 BL122
Element: Company Identifies the AP company if the BL130 BL20.1
resource type = V. Identifies the HR BL20.3 BL21.2
company if the resource type = E. It is BL21.5 BL29.1
blank for type A, P or Q resources. BL29.2 BL520
BL820 BL92.1
OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
OIT-INVC-PREFIX Alpha 2 BL120 BL122
Element: Invoice PrefixThis field contains the invoice prefix BL130 BL20.1
that is assigned from either the company BL20.3 BL21.2
or process level, depending on the BL21.5 BL29.1
invoice-level option chosen. BL29.2 BL520
BL820 BL92.1
OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
OIT-INVC-NUMBER Numeric 8 BL120 BL122
Element: Invc Number This field contains the invoice number BL130 BL20.1
assigned by the system. Invoice numbers BL20.3 BL21.2
are assigned at the company or process BL21.5 BL29.1
level, depending on an invoice-level BL29.2 BL520
option on the company file. BL820 BL92.1
OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
OIT-LINE-NBR Numeric 6 BL120 BL122
Element: Line Number Displays the system sequence number BL130 BL20.1
indicating which line on the invoice the BL20.3 BL21.2
tax is being calculated for. BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
OIT-SEQ Numeric 3 BL120 BL122
Element: Sequence NumbeThe tax record sequence number. BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
OIT-PROD-TAX-CAT Alpha 15 BL120 BL122
Element: Product Tax CaA classification of items for BL130 BL20.1
determining taxes using the Vertex BL20.3 BL21.2
system in Order Entry system or the cash BL21.5 BL29.1
receipts programs in the Cash Ledger BL29.2 BL520
system. BL820 BL92.1
OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
OIT-TAX-ID Alpha 20 BL120 BL122
Element: Tax ID This field contains the tax ID or BL130 BL20.1
registration number. BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
OIT-TAX-CODE Alpha 10 BL120 BL122
Element: Tax Code A user-defined tax code representing BL130 BL20.1
the tax authorities this ship-to pays BL20.3 BL21.2
sales tax to. Must be a valid tax code BL21.5 BL29.1
record. BL29.2 BL520
BL820 BL92.1
OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
OIT-TAX-RATE Percent 7.5 (Percent) BL120 BL122
Element: Chrg Rate The tax rate. BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
OIT-TAX-AMT-CURR Signed 18.2 BL120 BL122
Element: Intl Amt This is the tax amount in billing BL130 BL20.1
currency. BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
OIT-TAX-AMT-BSE Signed 18.2 BL120 BL122
Element: Intl Amt This is the tax amount in company base BL130 BL20.1
currency. BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
OIT-TAX-ACCT-UNIT Alpha 15 BL120 BL122
Element: Accounting UniThis is the general ledger account unit BL130 BL20.1
that will be credited when the invoice BL20.3 BL21.2
tax is posted to the General Ledger BL21.5 BL29.1
system. This will be debited for return BL29.2 BL520
credit memos. BL820 BL92.1
OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
OIT-TAX-ACCOUNT Numeric 6 BL120 BL122
Element: Account This is the general ledger account BL130 BL20.1
number that will be credited when the BL20.3 BL21.2
invoice tax is posted to the General BL21.5 BL29.1
Ledger system. This will be debited for BL29.2 BL520
return credit memos. BL820 BL92.1
OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
OIT-TAX-SUB-ACCT Numeric 4 BL120 BL122
Element: Subaccount This is the general ledger subaccount BL130 BL20.1
number that will be credited when the BL20.3 BL21.2
invoice tax is posted to the General BL21.5 BL29.1
Ledger system. This will be debited for BL29.2 BL520
return credit memos. BL820 BL92.1
OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
OIT-TRAN-TAXABLE Signed 18.2 BL120 BL122
Element: Intl Amt Required if a Tax Code is entered. BL130 BL20.1
This is the taxable amount the tax BL20.3 BL21.2
amount was derived from. BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
OIT-BASE-TAXABLE Signed 18.2 BL120 BL122
Element: Intl Amt BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
OIT-TAX-LEVEL Alpha 1 BL120 BL122
Element: Tax Level 1 = State BL130 BL20.1
2 = County BL20.3 BL21.2
3 = City BL21.5 BL29.1
4 = District BL29.2 BL520
5 = GST BL820 BL92.1
6 = PST OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
OEINVCTAX FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
OITSET1 COMPANY BL120 BL121
INVC-PREFIX BL122 BL123
INVC-NUMBER BL130 BL20.1
LINE-NBR BL20.3 BL21.2
SEQ BL21.5 BL29.1
TAX-CODE BL29.2 BL290
TAX-LEVEL BL320 BL520
BL80.1 BL81.1
BL820 BL92.1
OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE310 OE330
...
OITSET2 COMPANY BL121 BL122
INVC-PREFIX BL123 BL290
INVC-NUMBER BL80.1 OE114
TAX-CODE
LINE-NBR
SEQ
TAX-LEVEL
OITSET3 COMPANY
INVC-PREFIX
INVC-NUMBER
LINE-NBR
TAX-CODE
SEQ
TAX-LEVEL
OITSET4 COMPANY
INVC-PREFIX
INVC-NUMBER
TAX-CODE
PROD-TAX-CAT
LINE-NBR
SEQ
TAX-LEVEL
OEINVCTAX FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Oecompany OECOMPANY Required
OIT-COMPANY -> OEC-COMPANY (OECSET1)
Oeinvcline OEINVCLINE Required
When OIT-LINE-NBR > Zeroes
And OIT-SEQ = Zeroes
OIT-COMPANY -> OIL-COMPANY
OIT-INVC-PREFIX -> OIL-INVC-PREFIX
OIT-INVC-NUMBER -> OIL-INVC-NUMBER
OIT-LINE-NBR -> OIL-LINE-NBR
Oeinvcmisc OEINVCMISC Required
When OIT-LINE-NBR > Zeroes
And OIT-SEQ > Zeroes
OIT-COMPANY -> OIM-COMPANY
OIT-INVC-PREFIX -> OIM-INVC-PREFIX
OIT-INVC-NUMBER -> OIM-INVC-NUMBER
OIT-LINE-NBR -> OIM-LINE-NBR
OIT-SEQ -> OIM-SEQ
Oeinvoice OEINVOICE Required
OIT-COMPANY -> OEI-COMPANY
OIT-INVC-PREFIX -> OEI-INVC-PREFIX
OIT-INVC-NUMBER -> OEI-INVC-NUMBER
Txtaxcode TXTAXCODE Required
OIT-COMPANY -> TAC-COMPANY
OIT-TAX-CODE -> TAC-TAX-CODE
|