OEINVCTAX

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.
UPDATED BY
TX101 WH20.7

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
OIT-COMPANY
Element: Company
Numeric 4
Identifies the AP company if the resource type = V. Identifies the HR company if the resource type = E. It is blank for type A, P or Q resources.
WH20.7
OIT-INVC-PREFIX
Element: Invc Prefix
Alpha 2
This field contains the invoice prefix that is assigned from either the company or process level, depending on the invoice-level option chosen.
WH20.7
OIT-INVC-NUMBER
Element: Invc Number
Numeric 8
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.
WH20.7
OIT-LINE-NBR
Element: Line Nbr
Numeric 6
Displays the system sequence number indicating which line on the invoice the tax is being calculated for.
WH20.7
OIT-SEQ
Element: Seq
Numeric 3
The tax record sequence number.
WH20.7
OIT-PROD-TAX-CAT
Element: Prod Tax Cat
Alpha 15
A classification of items for determining taxes using the Vertex system in Order Entry or the cash receipts programs in Cash Management.
WH20.7
OIT-TAX-ID
Element: Tax Id
Alpha 20
This field contains the tax ID or registration number.
WH20.7
OIT-TAX-CODE
Element: Tax Code
Alpha 10
A user-defined tax code representing the tax authorities this ship-to pays sales tax to. Must be a valid tax code record.
WH20.7
OIT-TAX-RATE
Element: Chrg Rate
Percent 7.5 (Percent)
The tax rate.
WH20.7
OIT-TAX-AMT-CURR
Element: Intl Amt
Signed 18.2
This is the tax amount in billing currency.
WH20.7
OIT-TAX-AMT-BSE
Element: Intl Amt
Signed 18.2
This is the tax amount in company base currency.
WH20.7
OIT-TAX-ACCT-UNIT
Element: Acct Unit
Alpha 15
This is the general ledger account unit that will be credited when the invoice tax is posted to General Ledger. This will be debited for return credit memos.
WH20.7
OIT-TAX-ACCOUNT
Element: Account
Numeric 6
This is the general ledger account number that will be credited when the invoice tax is posted to General Ledger. This will be debited for return credit memos.
WH20.7
OIT-TAX-SUB-ACCT
Element: Sub Acct
Numeric 4
This is the general ledger subaccount number that will be credited when the invoice tax is posted to General Ledger. This will be debited for return credit memos.
WH20.7
OIT-TRAN-TAXABLE
Element: Intl Amt
Signed 18.2
WH20.7
OIT-BASE-TAXABLE
Element: Intl Amt
Signed 18.2
WH20.7
OIT-TAX-LEVEL
Element: Tax Level
Alpha 1

1 = State
2 = County
3 = City
4 = District
5 = GST
6 = PST
WH20.7


OEINVCTAX FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
OITSET1 COMPANY
INVC-PREFIX
INVC-NUMBER
LINE-NBR
SEQ
TAX-CODE
TAX-LEVEL
TX101 WH20.7
OITSET2 COMPANY
INVC-PREFIX
INVC-NUMBER
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
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Oecompany OECOMPANY Required
OIT-COMPANY->OEC-COMPANY (OECSET1)
Oeinvcline OEINVCLINE Required
When OIT-LINE-NBR >Zeroes
AndOIT-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
AndOIT-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


File created: Thu Jun 09 11:09:35 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.