TXTAXTRAN – Tax Transaction

System: Tax (TX)
Prefix: TXD
Primary key: COMPANY, TAX-CODE, TRANS-IDENT
Fields: 46
Updated by: 68 programs
Referenced by: 4 programs

TXTAXTRAN is the Tax Transaction table in Lawson Tax (prefix TXD). It is indexed by COMPANY, TAX-CODE, TRANS-IDENT (TXDSET1); alternate indexes: TXDSET2, TXDSET4 and TXDSET6. It is related 1:1 to APAPIHIST, APCOMPANY, APINVOICE, APVENMAST, ARCOMP, CUCODES, CUSTDESC, GLMASTER and 5 more. It is updated by AP125, AP126, AP170, AP180, AP181, AP190, AP193, AP195 and 60 more and referenced by TX130, TX204, TX221 and TXBD.2. The table has 46 fields, 4 indexes and 13 documented relations.

About TXTAXTRAN

The Tax Transactions file contains all tax transaction records that have been created for the Tax system by the Accounts Payable, Accounts Receivable, Billing, Cash Ledger, and Cash Receipts systems. Tax transaction records update this file when an Accounts Payable, Accounts Receivable, Cash Ledger, or Employee Advance and Expense transaction with a tax distribution is released, interfaced with a released status, or converted with a released status, or when a released Billing invoice with a non-Vertex tax distribution is printed.

Fields (46)

Column = COBOL field name without the TXD- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / column	Type	Description & values	Updated by
`TXD-COMPANY` PK COMPANY	Numeric 4	The company number. The company must already be defined in the General Ledger system.	AP125, AP126, AP170, AP180, AP181, AP190, AP193, AP20.1 +52 more
`TXD-TAX-CODE` PK TAX_CODE	Alpha 10	A user-defined code representing tax information. You must have already defined the tax code using TX01.1 (Tax Code Master).	AP125, AP126, AP170, AP180, AP181, AP190, AP193, AP20.1 +52 more
`TXD-TRANS-IDENT` PK TRANS_IDENT	Numeric 10	A system-assigned, internal transaction number. The system uses the transaction ID to keep tax transactions unique.	AP125, AP126, AP170, AP180, AP181, AP190, AP193, AP20.1 +52 more
`TXD-SYSTEM-CD` SYSTEM_CD	Alpha 2	This field indicates on which system the transaction originated. `AP` Accounts Payable `AR` Accounts Receivable `BL` Billing `CB` Cash Ledger `CR` Cash Receipts `BR` Billing and Revenue	AP125, AP126, AP170, AP180, AP181, AP190, AP193, AP20.1 +52 more
`TXD-VEND-CUST` VEND_CUST	Alpha 9 (Right Justified)	The vendor or customer number the tax transaction was created for.	AP125, AP126, AP170, AP180, AP181, AP190, AP193, AP20.1 +52 more
`TXD-TAX-ID-NBR` TAX_ID_NBR	Alpha 20	The tax identification or registration number of the company the tax transaction was created for.	AP125, AP126, AP170, AP180, AP181, AP190, AP193, AP20.1 +52 more
`TXD-PROD-TAX-CAT` PROD_TAX_CAT	Alpha 15	A product tax category lets you group items to determine the tax rate by item grouping. For example, you can tax an item grouping so that it is taxable in one state but not another. You define a product tax category in the Inventory Control system.	AP125, AP126, AP170, AP180, AP181, AP190, AP193, AP20.1 +52 more
`TXD-INVOICE` INVOICE	Alpha 22	The invoice number associated with the tax transaction.	AP125, AP126, AP170, AP180, AP181, AP190, AP193, AP20.1 +52 more
`TXD-SUFFIX` SUFFIX	Numeric 3	The transaction suffix number associated with the tax transaction. This field represents the occurrence value of the transaction.	AP125, AP126, AP170, AP180, AP181, AP190, AP193, AP20.1 +52 more
`TXD-CANCEL-SEQ` CANCEL_SEQ	Numeric 4	A sequence number that is assigned when an accounts payable distributed invoice is canceled. The first sequence assigned is 9999.	AP125, AP126, AP170, AP180, AP181, AP190, AP193, AP20.1 +52 more
`TXD-DIST-COMPANY` DIST_COMPANY	Numeric 4	The company number used to post tax transactions. The company must have been already defined in the General Ledger system.	AP125, AP126, AP170, AP180, AP181, AP190, AP193, AP20.1 +52 more
`TXD-TAX-ACCT-UNIT` TAX_ACCT_UNIT	Alpha 15	The general ledger accounting unit associated with the tax transaction. You must have already defined the accounting unit in the General Ledger system.	AP125, AP126, AP170, AP180, AP181, AP190, AP193, AP20.1 +52 more
`TXD-TAX-ACCOUNT` TAX_ACCOUNT	Numeric 6	The general ledger account number associated with the tax transaction. You must have already defined the account in the General Ledger system.	AP125, AP126, AP170, AP180, AP181, AP190, AP193, AP20.1 +52 more
`TXD-TAX-SUB-ACCT` TAX_SUB_ACCT	Numeric 4	The general ledger subaccount number associated with the tax transaction. You must have already defined the subaccount in the General Ledger system.	AP125, AP126, AP170, AP180, AP181, AP190, AP193, AP20.1 +52 more
`TXD-NAME` NAME	Alpha 30 (Lower Case)	The name of the vendor or customer the tax transaction was created for.	AP125, AP126, AP170, AP180, AP181, AP190, AP193, AP20.1 +52 more
`TXD-VOUCHER-NBR` VOUCHER_NBR	Alpha 10	The voucher number associated with the tax transaction. Vouchers are used by the Purchase Order system.	AP125, AP126, AP170, AP180, AP181, AP190, AP193, AP20.1 +52 more
`TXD-TAX-PNT-DATE` TAX_PNT_DATE	Numeric 8 (yyyymmdd)	The date at which the system calculated sales tax.	AP125, AP126, AP170, AP180, AP181, AP190, AP193, AP20.1 +52 more
`TXD-INVOICE-DTE` INVOICE_DTE	Numeric 8 (yyyymmdd)	The transaction date associated with the tax transaction.	AP125, AP126, AP170, AP180, AP181, AP190, AP193, AP20.1 +52 more
`TXD-POST-DATE` POST_DATE	Numeric 8 (yyyymmdd)	The general ledger posting date associated with the tax transaction.	AP125, AP126, AP170, AP180, AP181, AP190, AP193, AP195 +52 more (list truncated in source)
`TXD-TRAN-CURRENCY` TRAN_CURRENCY	Alpha 5	The currency of the transaction associated with the tax transaction. The currency must be valid in the Currency system.	AP125, AP126, AP170, AP180, AP181, AP190, AP193, AP20.1 +52 more
`TXD-TRAN-INV-AMT` TRAN_INV_AMT	Signed 18.2	The amount of the transaction in the currency of the transaction.	AP125, AP126, AP170, AP180, AP181, AP190, AP193, AP20.1 +52 more
`TXD-TRAN-TAXABLE` TRAN_TAXABLE	Signed 18.2	The taxable amount of the transaction in the currency of the transaction.	AP125, AP126, AP170, AP180, AP181, AP190, AP193, AP20.1 +52 more
`TXD-TRAN-TAX-AMT` TRAN_TAX_AMT	Signed 18.2	The tax amount for the tax transaction in the currency of the transaction.	AP125, AP126, AP170, AP180, AP181, AP190, AP193, AP20.1 +52 more
`TXD-TRAN-ND` TRAN_ND	Numeric 1	The number of decimal places defined for the transaction currency associated with the tax transaction.	AP125, AP126, AP170, AP180, AP181, AP190, AP193, AP20.1 +52 more
`TXD-BASE-INV-AMT` BASE_INV_AMT	Signed 18.2	The amount of the transaction in the company base currency.	AP125, AP126, AP170, AP180, AP181, AP190, AP193, AP20.1 +52 more
`TXD-BASE-TAXABLE` BASE_TAXABLE	Signed 18.2	The taxable amount of the transaction in the company base currency.	AP125, AP126, AP170, AP180, AP181, AP190, AP193, AP20.1 +52 more
`TXD-BASE-TAX-AMT` BASE_TAX_AMT	Signed 18.2	The tax amount of the tax transaction in the company base currency.	AP125, AP126, AP170, AP180, AP181, AP190, AP193, AP20.1 +52 more
`TXD-BASE-ND` BASE_ND	Numeric 1	The number of decimal places defined for the company base currency.	AP125, AP126, AP170, AP180, AP181, AP190, AP193, AP20.1 +52 more
`TXD-TAX-RATE` TAX_RATE	Percent 7.5 (Percent)	The tax rate that the system used for the transaction.	AP125, AP126, AP170, AP180, AP181, AP190, AP193, AP20.1 +52 more
`TXD-ACCRUAL-FL` ACCRUAL_FL	Alpha 1	Accrual flags determined how tax was applied to invoices, whether as invoiced or accrued (noninvoiced). `I` Invoiced `A` Accrued	AP125, AP126, AP170, AP180, AP181, AP190, AP193, AP20.1 +52 more
`TXD-PROC-LEVEL` PROC_LEVEL	Alpha 5	The process level associated with the tax transaction. You define process levels in the Accounts Receivable, Accounts Payable, and Billing systems.	AP125, AP126, AP170, AP180, AP181, AP190, AP193, AP20.1 +52 more
`TXD-CURR-RATE` CURR_RATE	Signed 14.7	The currency exchange rate used to convert a nonbase currency transaction amount to the company base currency.	AP125, AP126, AP170, AP180, AP181, AP190, AP193, AP20.1 +52 more
`TXD-STATUS` STATUS	Numeric 1	This field indicates whether the tax transaction has been updated by running TX100 (Tax Analysis Report). `0` Created `1` Reported	AP125, AP126, AP170, AP180, AP181, AP190, AP193, AP20.1 +52 more (list truncated in source)
`TXD-MANUAL-FL` MANUAL_FL	Alpha 1	This field indicates whether the tax transaction was created manually or not. `Y` Yes `N` No	AP125, AP126, AP170, AP180, AP181, AP190, AP193, AP20.1 +52 more
`TXD-INPUT-OUTPUT` INPUT_OUTPUT	Derived	This field indicates whether the tax applied to the transaction was an input or output tax. Input taxes are paid by the company through the Accounts Payable system. Output taxes are collected by the company through the Accounts Receivable system.	—
`TXD-VEND-CUST-NAME` VEND_CUST_NAME	Derived	—	—
`TXD-VAT-REG-CTRY` VAT_REG_CTRY	Alpha 2	The country component of the VAT Registration Number. This field, together with the Registration Number for the company on the tax transaction.	AP125, AP126, AP170, AP180, AP181, AP190, AP193, AP20.1 +52 more
`TXD-VAT-REG-NBR` VAT_REG_NBR	Alpha 12	The number component of the VAT Registration Number. This field together with the Registration Country field make up the VAT Registration Number.	AP125, AP126, AP170, AP180, AP181, AP190, AP193, AP20.1 +52 more
`TXD-TAX-USAGE-CD` TAX_USAGE_CD	Alpha 10	The tax usage code for the vendor. This field is required if the AP Company indicates that VAT reporting is required.	AP125, AP126, AP170, AP180, AP181, AP190, AP193, AP20.1 +52 more
`TXD-INV-CRD-IND` INV_CRD_IND	Alpha 1	Specified whether the transaction on which the tax was entered as an invoice or a credit memo. `I` Invoice `C` Credit Memo	AP125, AP126, AP170, AP180, AP181, AP190, AP193, AP20.1 +52 more
`TXD-TAX-YEAR` TAX_YEAR	Numeric 4	The tax year for which the calendar was defined.	AP125, AP126, AP170, AP180, AP181, AP190, AP193, AP20.1 +52 more
`TXD-TAX-PERIOD` TAX_PERIOD	Numeric 2	The tax period of the specified year.	AP125, AP126, AP170, AP180, AP181, AP190, AP193, AP20.1 +52 more
`TXD-SOURCE` SOURCE	Alpha 1	The source of the transaction. Input or output. Input transactions are Accounts Payable. Output transactions are Accounts Receivable. `I` Input = AP `O` Output = AR	AP125, AP126, AP170, AP180, AP181, AP190, AP193, AP20.1 +52 more
`TXD-PURCH-SALE-RPT` PURCH_SALE_RPT	Alpha 1	Indicates whether a VAT Purchase and Sales report is required.	TX125
`TXD-TAX-FLAG` TAX_FLAG	Alpha 1	This is the flag which indicates to the system whether this transaction has been interfaced into the Tax Report files or not. " " = Not Interfaced `I` Interfaced	TX101
`TXD-CANCEL-FL` CANCEL_FL	Alpha 1	—	—

Indexes (4)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

Index	Keys	Flags	Used in
`TXDSET1`	`COMPANY`, `TAX-CODE`, `TRANS-IDENT`	Primary	AP125, AP126, AP170, AP180, AP181, AP190, AP193, AP20.1 +22 more (list truncated in source)
`TXDSET2`	`COMPANY`, `TAX-CODE`, `SYSTEM-CD`, `TAX-PNT-DATE*`, `VOUCHER-NBR`, `TRANS-IDENT`	KeyChange	TX120, TX125
`TXDSET4`	`COMPANY`, `TAX-YEAR`, `TAX-PERIOD`, `SYSTEM-CD`, `TRANS-IDENT`, `TAX-CODE`	KeyChange	TX130, TX222
`TXDSET6`	`COMPANY`, `INVOICE`, `TAX-CODE`, `PROD-TAX-CAT`, `TRANS-IDENT`		AP195, AP30.2, TX222

Relations

One to one (13) — lookups and parents

Relation	Table	Rules	Condition	Field map
Apapihist	APAPIHIST	Not Required	Valid When TXD-SYSTEM-CD = "AP"	`TXD-COMPANY` → `AH1-COMPANY`, `TXD-VEND-CUST` → `AH1-VENDOR`, `TXD-INVOICE` → `AH1-INVOICE`, `TXD-SUFFIX` → `AH1-SUFFIX`, `TXD-CANCEL-SEQ` → `AH1-CANCEL-SEQ`
Apcompany	APCOMPANY	Not Required		`TXD-COMPANY` → `CPY-COMPANY`
Apinvoice	APINVOICE	Not Required	Valid When TXD-SYSTEM-CD = "AP"	`TXD-COMPANY` → `API-COMPANY`, `TXD-VEND-CUST` → `API-VENDOR`, `TXD-INVOICE` → `API-INVOICE`, `TXD-SUFFIX` → `API-SUFFIX`, `TXD-CANCEL-SEQ` → `API-CANCEL-SEQ`
Apvendmast	APVENMAST	Required	When TXD-SYSTEM-CD = "AP"	`CPY-VENDOR-GROUP` → `VEN-VENDOR-GROUP`, `TXD-VEND-CUST` → `VEN-VENDOR`
Arcomp	ARCOMP	Not Required		`TXD-COMPANY` → `ACO-COMPANY`
Cucode	CUCODES	Required		`TXD-TRAN-CURRENCY` → `CUC-CURRENCY-CODE`
Custdesc	CUSTDESC	Not Required	Valid When TXD-INPUT-OUTPUT = I	`ACO-CUST-GROUP` → `CUD-CUST-GROUP`, `TXD-VEND-CUST` → `CUD-CUSTOMER`
Glmaster	GLMASTER	Not Required		`TXD-COMPANY` → `GLM-COMPANY`, `TXD-TAX-ACCT-UNIT` → `GLM-ACCT-UNIT`, `TXD-TAX-ACCOUNT` → `GLM-ACCOUNT`, `TXD-TAX-SUB-ACCT` → `GLM-SUB-ACCOUNT`
Glsystem	GLSYSTEM	Required		`TXD-COMPANY` → `GLS-COMPANY`
Txcodemast	TXCODEMAST	Required		`TXD-TAX-CODE` → `TCM-TAX-CODE`
Txcompany	TXCOMPANY	Required		`TXD-COMPANY` → `TXC-COMPANY`
Txtaxcode	TXTAXCODE	Required	When TXC-ACCT-BY-CODE = "Y"	`TXD-COMPANY` → `TAC-COMPANY`, `TXD-TAX-CODE` → `TAC-TAX-CODE`
Txtxtrnbod	TXTXTRNBOD	Not Required, Delete Cascades		`TXD-COMPANY` → `YCI-COMPANY`, `TXD-TAX-CODE` → `YCI-TAX-CODE`, `TXD-TRANS-IDENT` → `YCI-TRANS-IDENT`

Programs

Updated by (68)

AP125 Batch Release
AP126 Mass Invoice Release
AP170 Payment Closing
AP180 Bill of Exchange Cashing Update
AP181 Bill of Exchange Statement Update
AP190 Invoice Reinstatement
AP193 Recurring Invoice Update
AP195 Period Closing
AP20.1 Basic Invoice
AP20.2 Taxed Invoice
AP20.3 Detail Invoice
AP20.4 Invoice Line Detail
AP20.5 Multiple Invoice
AP20.7 Distributions
AP21.1 View Distributions
AP23.1 Transit Invoice Entry
AP25.1 Batch Control
AP25.2 Batch Review
AP26.1 Invoice Release
AP27.1 Single Invoice Release
AP30.2 Distribution Adjustments
AP30.4 Invoice Cancel
AP520 Invoice Interface
API1.1 Add Invoice
API2.1 Add Invoice
ARLL.1 AR Transaction Interface
BRIP.1 Invoice Print Program
CB10.1 Cash Receipt Deposit
CB150 Mass Release
CB180 Cash Ledger Void Update
CB191 Bank Statement Close
CB20.1 Bank Transaction Entry
CB30.1 Reconciliation Variance Adjustment
CB45.1 EFT/CC Extract Entry
CB46.1 Returned Payment Entry
CB500 Bank Transaction Interface
CB543 Receipts Load
CB544 Returned Payment Load
EE135 Mass Employee Release
EE35.1 Advance Release
EE35.2 Expense Release
EE520 Expense Interface
MA41.1 Add-On Cost Detail - Purchase Order
MA41.2 Add On Cost Lookup
MA41.4 Miscellaneous Add-On Cost
MA41.7 AOC Approval Entry
MA42.2 Memo Line AOC Detail
MA43.1 Invoice Line Detail - Purchase Order
MA43.2 Purchase Order Lookup
MA44.1 Invoice Line Detail - Purchase Order
MA44.2 Invoice Line Detail- Service
MA61.1 Match Invoice Approval
MA64.9 PO Cost Message Accept Upload
MA66.2 Invoice Message - Details
MA66.3 Purchase Order Cost Review Message
MA70.1 Invoice Unmatch
MA75.1 PO Invoice Cancel
MAI1.1 Invoke for MAMATCH Object
TX04.1 Tax Transaction
TX100 Tax Analysis Report
TX101 Journal File Create
TX120 Value Added Tax Return Report
TX125 Purchase and Sales Report - Belgium
TX220 Vendor, Customer Tax Audit
TX222 Tax Reconciliation Report
TX300 Tax History Purge
TX804 Tax Transaction Conversion
WH20.7 Substitute Location

Referenced by (4)

TX130 European Community Sales Report
TX204 Tax Transaction Listing
TX221 Tax Transaction Audit
TXBD.2 TX BOD Inquiry