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 |
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. |
|
|
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. |
|
|
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. |
|
|
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. |
|
|
OIT-SEQ Element: Seq | Numeric 3 The tax record sequence number. |
|
|
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. |
|
|
OIT-TAX-ID Element: Tax Id | Alpha 20 This field contains the tax ID or registration number. |
|
|
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. |
|
|
OIT-TAX-RATE Element: Chrg Rate | Percent 7.5 (Percent) The tax rate. |
|
|
OIT-TAX-AMT-CURR Element: Intl Amt | Signed 18.2 This is the tax amount in billing currency. |
|
|
OIT-TAX-AMT-BSE Element: Intl Amt | Signed 18.2 This is the tax amount in company base currency. |
|
|
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. |
|
|
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. |
|
|
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. |
|
|
OIT-TRAN-TAXABLE Element: Intl Amt | Signed 18.2 |
|
|
OIT-BASE-TAXABLE Element: Intl Amt | Signed 18.2 |
|
|
OIT-TAX-LEVEL Element: Tax Level | Alpha 1 1 = State 2 = County 3 = City 4 = District 5 = GST 6 = PST |
|
NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
OITSET1 |
COMPANY INVC-PREFIX INVC-NUMBER LINE-NBR SEQ TAX-CODE TAX-LEVEL |
|
| ||||||||
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 |
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | |||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Oecompany | OECOMPANY |
Required
| |||||||||||||||||||||||||||
Oeinvcline | OEINVCLINE |
Required
| |||||||||||||||||||||||||||
Oeinvcmisc | OEINVCMISC |
Required
| |||||||||||||||||||||||||||
Oeinvoice | OEINVOICE |
Required
| |||||||||||||||||||||||||||
Txtaxcode | TXTAXCODE |
Required
|
All trademarks and registered trademarks are the property of their
respective owners.