|
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 WH20.7
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
WH20.7
OIT-INVC-PREFIX Alpha 2 BL120 BL122
Element: Invc Prefix This 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
WH20.7
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
WH20.7
OIT-LINE-NBR Numeric 6 BL120 BL122
Element: Line Nbr 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
WH20.7
OIT-SEQ Numeric 3 BL120 BL122
Element: Seq The tax record sequence number. BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
WH20.7
OIT-PROD-TAX-CAT Alpha 15 BL120 BL122
Element: Prod Tax Cat A classification of items for BL130 BL20.1
determining taxes using the Vertex BL20.3 BL21.2
system in Order Entry or the cash BL21.5 BL29.1
receipts programs in Cash Management. BL29.2 BL520
BL820 BL92.1
WH20.7
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
WH20.7
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
WH20.7
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
WH20.7
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
WH20.7
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
WH20.7
OIT-TAX-ACCT-UNIT Alpha 15 BL120 BL122
Element: Acct Unit This is the general ledger account unit BL130 BL20.1
that will be credited when the invoice BL20.3 BL21.2
tax is posted to General Ledger. This BL21.5 BL29.1
will be debited for return credit memos. BL29.2 BL520
BL820 BL92.1
WH20.7
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 General Ledger. BL21.5 BL29.1
This will be debited for return credit BL29.2 BL520
memos. BL820 BL92.1
WH20.7
OIT-TAX-SUB-ACCT Numeric 4 BL120 BL122
Element: Sub Acct 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 General Ledger. BL21.5 BL29.1
This will be debited for return credit BL29.2 BL520
memos. BL820 BL92.1
WH20.7
OIT-TRAN-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
WH20.7
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
WH20.7
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 WH20.7
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
TX101 WH20.7
OITSET2 COMPANY BL121 BL122
INVC-PREFIX BL123 BL290
INVC-NUMBER BL80.1
TAX-CODE
LINE-NBR
SEQ
TAX-LEVEL
OITSET3 COMPANY
INVC-PREFIX
INVC-NUMBER
LINE-NBR
TAX-CODE
SEQ
TAX-LEVEL
OITSET4 COMPANY BL121 BL122
INVC-PREFIX BL123 BL290
INVC-NUMBER BL80.1
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
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
|