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