OEINVCTAX – Invoice Taxes
- System
- Billing (BL)
- Prefix
OIT- Primary key
COMPANY,INVC-PREFIX,INVC-NUMBER,LINE-NBR,SEQ,TAX-CODE,TAX-LEVEL- Fields
- 17
- Updated by
- 1 program
- Referenced by
- 1 program
OEINVCTAX is the Invoice Taxes table in Lawson Billing (prefix OIT). It is indexed by COMPANY, INVC-PREFIX, INVC-NUMBER, LINE-NBR, SEQ, TAX-CODE, TAX-LEVEL (OITSET1); alternate indexes: OITSET2, OITSET3 and OITSET4. It is related 1:1 to OECOMPANY, OEINVCLINE, OEINVCMISC, OEINVOICE and TXTAXCODE. It is updated by WH20.7 and referenced by TX101. The table has 17 fields, 4 indexes and 5 documented relations.
About OEINVCTAX
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.
Fields (17)
Column = COBOL field name without the OIT- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
OIT-COMPANY PKCOMPANY | 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 PKINVC_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 PKINVC_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 PKLINE_NBR | Numeric 6 | Displays the system sequence number indicating which line on the invoice the tax is being calculated for. | WH20.7 |
OIT-SEQ PKSEQ | Numeric 3 | The tax record sequence number. | WH20.7 |
OIT-PROD-TAX-CATPROD_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-IDTAX_ID | Alpha 20 | This field contains the tax ID or registration number. | WH20.7 |
OIT-TAX-CODE PKTAX_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-RATETAX_RATE | Percent 7.5 (Percent) | The tax rate. | WH20.7 |
OIT-TAX-AMT-CURRTAX_AMT_CURR | Signed 18.2 | This is the tax amount in billing currency. | WH20.7 |
OIT-TAX-AMT-BSETAX_AMT_BSE | Signed 18.2 | This is the tax amount in company base currency. | WH20.7 |
OIT-TAX-ACCT-UNITTAX_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-ACCOUNTTAX_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-ACCTTAX_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-TAXABLETRAN_TAXABLE | Signed 18.2 | — | WH20.7 |
OIT-BASE-TAXABLEBASE_TAXABLE | Signed 18.2 | — | WH20.7 |
OIT-TAX-LEVEL PKTAX_LEVEL | Alpha 1 | —
| WH20.7 |
Indexes (4)
Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
OITSET1 | COMPANY, INVC-PREFIX, INVC-NUMBER, LINE-NBR, SEQ, TAX-CODE, TAX-LEVEL | Primary | 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 | — |
Relations
One to one (5) — lookups and parents
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| 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 |
Programs
Updated by (1)
- WH20.7 Substitute Location
Referenced by (1)
- TX101 Journal File Create