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 BL122 BL123 BL290 BL80.1 BL81.1
UPDATED BY
BL120 BL130 BL20.1 BL20.3 BL21.2 BL21.5
BL29.1 BL29.2 BL320 BL520 BL820 BL92.1
BL940 BL96E OE114 OE129 OE30.1 OE30.2
OE30.3 OE30.4 OE30.5 OE30.6 OE30.7 OE30.9
OE310 OE330 OE830 OE950
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
OIT-COMPANY Numeric 4 BL120 BL130
Company The company number represents an BL20.1 BL20.3
established company and is entered on BL21.2 BL21.5
all function codes. BL29.1 BL29.2
BL520 BL820
BL92.1 BL940
BL96E OE114
OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OIT-INVC-PREFIX Alpha 2 BL120 BL130
Invoice Prefix This field contains the invoice prefix BL20.1 BL20.3
that is assigned from either the company BL21.2 BL21.5
or process level, depending on the BL29.1 BL29.2
invoice-level option chosen. BL520 BL820
BL92.1 BL940
BL96E OE114
OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OIT-INVC-NUMBER Numeric 8 BL120 BL130
Invc Number This field contains the invoice number BL20.1 BL20.3
assigned by the system. Invoice numbers BL21.2 BL21.5
are assigned at the company or process BL29.1 BL29.2
level, depending on an invoice-level BL520 BL820
option on the company file. BL92.1 BL940
BL96E OE114
OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OIT-LINE-NBR Numeric 6 BL120 BL130
Line Number Displays the system sequence number BL20.1 BL20.3
indicating which line on the invoice the BL21.2 BL21.5
tax is being calculated for. BL29.1 BL29.2
BL520 BL820
BL92.1 BL940
BL96E OE114
OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OIT-SEQ Numeric 3 BL120 BL130
Sequence Number The tax record sequence number. BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 BL940
BL96E OE114
OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OIT-PROD-TAX-CAT Alpha 15 BL120 BL130
Product Tax Category A classification of items for BL20.1 BL20.3
determining taxes using the Vertex BL21.2 BL21.5
system in Order Entry system or the cash BL29.1 BL29.2
receipts programs in the Cash Ledger BL520 BL820
system. BL92.1 BL940
BL96E OE114
OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OIT-TAX-ID Alpha 20 BL120 BL130
Tax ID This field contains the tax ID or BL20.1 BL20.3
registration number. BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 BL940
BL96E OE114
OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OIT-TAX-CODE Alpha 10 BL120 BL130
Tax Code A user-defined tax code representing BL20.1 BL20.3
the tax authorities this ship-to pays BL21.2 BL21.5
sales tax to. Must be a valid tax code BL29.1 BL29.2
record. BL520 BL820
BL92.1 BL940
BL96E OE114
OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OIT-TAX-RATE Percent 7.5 (Percent) BL120 BL130
Tax Rate The tax rate. BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 BL940
BL96E OE114
OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OIT-TAX-AMT-CURR Signed 15.2 BL120 BL130
Tax Amount Currency This is the tax amount in billing BL20.1 BL20.3
currency. BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 BL940
BL96E OE114
OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OIT-TAX-AMT-BSE Signed 15.2 BL120 BL130
Tax Amount Base This is the tax amount in company base BL20.1 BL20.3
currency. BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 BL940
BL96E OE114
OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OIT-TAX-ACCT-UNIT Alpha 15 BL120 BL130
Tax Accounting Unit This is the general ledger account unit BL20.1 BL20.3
that will be credited when the invoice BL21.2 BL21.5
tax is posted to the General Ledger BL29.1 BL29.2
system. This will be debited for return BL520 BL820
credit memos. BL92.1 BL940
BL96E OE114
OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OIT-TAX-ACCOUNT Numeric 6 BL120 BL130
Tax Account This is the general ledger account BL20.1 BL20.3
number that will be credited when the BL21.2 BL21.5
invoice tax is posted to the General BL29.1 BL29.2
Ledger system. This will be debited for BL520 BL820
return credit memos. BL92.1 BL940
BL96E OE114
OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OIT-TAX-SUB-ACCT Numeric 4 BL120 BL130
Tax Subaccount This is the general ledger subaccount BL20.1 BL20.3
number that will be credited when the BL21.2 BL21.5
invoice tax is posted to the General BL29.1 BL29.2
Ledger system. This will be debited for BL520 BL820
return credit memos. BL92.1 BL940
BL96E OE114
OE129 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950
OIT-TRAN-TAXABLE Signed 15.2 BL120 BL130
Taxable Amount Required if a Tax Code is entered. BL20.1 BL20.3
This is the taxable amount the tax BL21.2 BL21.5
amount was derived from. BL29.1 BL29.2
BL520 BL820
BL92.1 BL940
OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE830 OE950
OIT-BASE-TAXABLE Signed 15.2 BL120 BL130
Base Taxable Amount This field displays the taxable amount BL20.1 BL20.3
of the line in company base currency. BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 BL940
OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE830 OE950
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
BL320 BL520
BL80.1 BL81.1
BL820 BL92.1
BL940 BL96E
OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
...
OITSET2 COMPANY BL121 BL122
INVC-PREFIX BL123 BL290
INVC-NUMBER BL80.1 OE114
TAX-CODE
LINE-NBR
SEQ
OITSET3 COMPANY
INVC-PREFIX
INVC-NUMBER
LINE-NBR
TAX-CODE
SEQ
OITSET4 COMPANY
INVC-PREFIX
INVC-NUMBER
TAX-CODE
PROD-TAX-CAT
LINE-NBR
SEQ
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
|