 |
Lawson Insight Technical Documentation |
|
TXTAXTRAN FILE
Tax Transaction
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.
REFERENCED BY
TX204 TX220 TX221 TX130
UPDATED BY
AP170 AP180 AP181 AP190 AP193 AP30.2
AP30.4 AP32.2 AP520 API1.1 API2.1 AR115
AR124 AR190 AR20.1 AR21.1 AR21.2 AR21.3
AR24.1 AR29.2 AR30.1 AR30.2 AR30.4 AR42.1
AR42.2 AR42.7 AR43.1 AR560 AR570 AR575
AR580 BRIP.1 CB10.1 CB180 CB191 CB20.1
CB30.1 CB500 DT180 DT181 EE135 EE35.1
EE35.2 EE520 TX04.1 TX100 TX120 TX125
TX300 TX804
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
TXD-COMPANY Numeric 4 AP170 AP180
Company The company number. The company must AP181 AP190
already be defined in the General Ledger AP193 AP30.2
system. AP30.4 AP32.2
AP520 API1.1
API2.1 AR115
AR124 AR190
AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR29.2
AR30.1 AR30.2
AR30.4 AR42.1
AR42.2 AR42.7
AR43.1 AR560
AR570 AR575
AR580 BRIP.1
CB10.1 CB180
CB191 CB20.1
CB30.1 CB500
DT180 DT181
EE135 EE35.1
EE35.2 EE520
TX04.1 TX804
TXD-TAX-CODE Alpha 10 AP170 AP180
Tax Code A user-defined code representing tax AP181 AP190
information. You must have already AP193 AP30.2
defined the tax code using TX01.1 (Tax AP30.4 AP32.2
Code Master). AP520 API1.1
API2.1 AR115
AR124 AR190
AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR29.2
AR30.1 AR30.2
AR30.4 AR42.1
AR42.2 AR42.7
AR43.1 AR560
AR570 AR575
AR580 BRIP.1
CB10.1 CB180
CB191 CB20.1
CB30.1 CB500
DT180 DT181
EE135 EE35.1
EE35.2 EE520
TX04.1 TX804
TXD-TRANS-IDENT Numeric 10 AP170 AP180
Transaction ID A system-assigned, internal transaction AP181 AP190
number. The system uses the transaction AP193 AP30.2
ID to keep tax transactions unique. AP30.4 AP32.2
AP520 API1.1
API2.1 AR115
AR124 AR190
AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR29.2
AR30.1 AR30.2
AR30.4 AR42.1
AR42.2 AR42.7
AR43.1 AR560
AR570 AR575
AR580 BRIP.1
CB10.1 CB180
CB191 CB20.1
CB30.1 CB500
DT180 DT181
EE135 EE35.1
EE35.2 EE520
TX04.1 TX804
TXD-SYSTEM-CD Alpha 2 AP170 AP180
System Code This field indicates on which system AP181 AP190
the transaction originated. AP193 AP30.2
AP = Accounts Payable AP30.4 AP32.2
AR = Accounts Receivable AP520 API1.1
BL = Billing API2.1 AR115
CB = Cash Ledger AR124 AR190
CR = Cash Receipts AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR29.2
AR30.1 AR30.2
AR30.4 AR42.1
AR42.2 AR42.7
AR43.1 AR560
AR570 AR575
AR580 BRIP.1
CB10.1 CB180
CB191 CB20.1
CB30.1 CB500
DT180 DT181
EE135 EE35.1
EE35.2 EE520
TX04.1 TX804
TXD-VEND-CUST Alpha 9 (Right Justified) AP170 AP180
Vendor or Customer The vendor or customer number the tax AP181 AP190
ID transaction was created for. AP193 AP30.2
AP30.4 AP32.2
AP520 API1.1
API2.1 AR115
AR124 AR190
AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR29.2
AR30.1 AR30.2
AR30.4 AR42.1
AR42.2 AR42.7
AR43.1 AR560
AR570 AR575
AR580 BRIP.1
CB10.1 CB180
CB191 CB20.1
CB30.1 CB500
DT180 DT181
EE135 EE35.1
EE35.2 EE520
TX04.1 TX804
TXD-TAX-ID-NBR Alpha 20 AP170 AP180
Tax ID The tax identification or registration AP181 AP190
number of the company the tax AP193 AP30.2
transaction was created for. AP30.4 AP32.2
AP520 API1.1
API2.1 AR115
AR124 AR190
AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR29.2
AR30.1 AR30.2
AR30.4 AR42.1
AR42.2 AR42.7
AR43.1 AR560
AR570 AR575
AR580 BRIP.1
CB10.1 CB180
CB191 CB20.1
CB30.1 CB500
DT180 DT181
EE135 EE35.1
EE35.2 EE520
TX04.1 TX804
TXD-PROD-TAX-CAT Alpha 15 AP170 AP180
Product Tax Category A product tax category lets you group AP181 AP190
items to determine the tax rate by item AP193 AP30.2
grouping. For example, you can tax an AP30.4 AP32.2
item grouping so that it is taxable in AP520 API1.1
one state but not another. API2.1 AR115
AR124 AR190
You define a product tax category in AR20.1 AR21.1
the Inventory Control system. AR21.2 AR21.3
AR24.1 AR29.2
AR30.1 AR30.2
AR30.4 AR42.1
AR42.2 AR42.7
AR43.1 AR560
AR570 AR575
AR580 BRIP.1
CB10.1 CB180
CB191 CB20.1
CB30.1 CB500
DT180 DT181
EE135 EE35.1
EE35.2 EE520
TX04.1 TX804
TXD-INVOICE Alpha 22 AP170 AP180
Invoice Number The invoice number associated with the AP181 AP190
tax transaction. AP193 AP30.2
AP30.4 AP32.2
AP520 API1.1
API2.1 AR115
AR124 AR190
AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR29.2
AR30.1 AR30.2
AR30.4 AR42.1
AR42.2 AR42.7
AR43.1 AR560
AR570 AR575
AR580 BRIP.1
CB10.1 CB180
CB191 CB20.1
CB30.1 CB500
DT180 DT181
EE135 EE35.1
EE35.2 EE520
TX04.1 TX804
TXD-SUFFIX Numeric 3 AP170 AP180
Invoice Suffix The transaction suffix number AP181 AP190
associated with the tax transaction. AP193 AP30.2
This field represents the occurrence AP30.4 AP32.2
value of the transaction. AP520 API1.1
API2.1 AR115
AR124 AR190
AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR29.2
AR30.1 AR30.2
AR30.4 AR42.1
AR42.2 AR42.7
AR43.1 AR560
AR570 AR575
AR580 BRIP.1
CB10.1 CB180
CB191 CB20.1
CB30.1 CB500
DT180 DT181
EE135 EE35.1
EE35.2 EE520
TX04.1 TX804
TXD-CANCEL-SEQ Numeric 4 AP170 AP180
Cancel Sequence A sequence number that is assigned when AP181 AP190
an accounts payable distributed invoice AP193 AP30.2
is canceled. The first sequence AP30.4 AP32.2
assigned is 9999. AP520 API1.1
API2.1 AR115
AR124 AR190
AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR29.2
AR30.1 AR30.2
AR30.4 AR42.1
AR42.2 AR42.7
AR43.1 AR560
AR570 AR575
AR580 BRIP.1
CB10.1 CB180
CB191 CB20.1
CB30.1 CB500
DT180 DT181
EE135 EE35.1
EE35.2 EE520
TX04.1 TX804
TXD-DIST-COMPANY Numeric 4 AP170 AP180
Distribution Company The company number used to post tax AP181 AP190
transactions. The company must have AP193 AP30.2
been already defined in the General AP30.4 AP32.2
Ledger system. AP520 API1.1
API2.1 AR115
AR124 AR190
AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR29.2
AR30.1 AR30.2
AR30.4 AR42.1
AR42.2 AR42.7
AR43.1 AR560
AR570 AR575
AR580 BRIP.1
CB10.1 CB180
CB191 CB20.1
CB30.1 CB500
DT180 DT181
EE135 EE35.1
EE35.2 EE520
TX04.1 TX804
TXD-TAX-ACCT-UNIT Alpha 15 AP170 AP180
Tax Accounting Unit The general ledger accounting unit AP181 AP190
associated with the tax transaction. You AP193 AP30.2
must have already defined the accounting AP30.4 AP32.2
unit in the General Ledger system. AP520 API1.1
API2.1 AR115
AR124 AR190
AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR29.2
AR30.1 AR30.2
AR30.4 AR42.1
AR42.2 AR42.7
AR43.1 AR560
AR570 AR575
AR580 BRIP.1
CB10.1 CB180
CB191 CB20.1
CB30.1 CB500
DT180 DT181
EE135 EE35.1
EE35.2 EE520
TX04.1 TX804
TXD-TAX-ACCOUNT Numeric 6 AP170 AP180
Tax Account The general ledger account number AP181 AP190
associated with the tax transaction. You AP193 AP30.2
must have already defined the account in AP30.4 AP32.2
the General Ledger system. AP520 API1.1
API2.1 AR115
AR124 AR190
AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR29.2
AR30.1 AR30.2
AR30.4 AR42.1
AR42.2 AR42.7
AR43.1 AR560
AR570 AR575
AR580 BRIP.1
CB10.1 CB180
CB191 CB20.1
CB30.1 CB500
DT180 DT181
EE135 EE35.1
EE35.2 EE520
TX04.1 TX804
TXD-TAX-SUB-ACCT Numeric 4 AP170 AP180
Tax Subaccount The general ledger subaccount number AP181 AP190
associated with the tax transaction. You AP193 AP30.2
must have already defined the subaccount AP30.4 AP32.2
in the General Ledger system. AP520 API1.1
API2.1 AR115
AR124 AR190
AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR29.2
AR30.1 AR30.2
AR30.4 AR42.1
AR42.2 AR42.7
AR43.1 AR560
AR570 AR575
AR580 BRIP.1
CB10.1 CB180
CB191 CB20.1
CB30.1 CB500
DT180 DT181
EE135 EE35.1
EE35.2 EE520
TX04.1 TX804
TXD-NAME Alpha 30 (Lower Case) AP170 AP180
Vendor or Customer The name of the vendor or customer the AP181 AP190
Name tax transaction was created for. AP193 AP30.2
AP30.4 AP32.2
AP520 API1.1
API2.1 AR115
AR124 AR190
AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR29.2
AR30.1 AR30.2
AR30.4 AR42.1
AR42.2 AR42.7
AR43.1 AR560
AR570 AR575
AR580 BRIP.1
CB10.1 CB180
CB191 CB20.1
CB30.1 CB500
DT180 DT181
EE135 EE35.1
EE35.2 EE520
TX04.1 TX804
TXD-VOUCHER-NBR Alpha 10 AP170 AP180
Voucher The voucher number associated with the AP181 AP190
tax transaction. Vouchers are used by AP193 AP30.2
the Purchase Order system. AP30.4 AP32.2
AP520 API1.1
API2.1 AR115
AR124 AR190
AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR29.2
AR30.1 AR30.2
AR30.4 AR42.1
AR42.2 AR42.7
AR43.1 AR560
AR570 AR575
AR580 BRIP.1
CB10.1 CB180
CB191 CB20.1
CB30.1 CB500
DT180 DT181
EE135 EE35.1
EE35.2 EE520
TX04.1 TX804
TXD-TAX-PNT-DATE Numeric 8 (yyyymmdd) AP170 AP180
Tax Point Date The date at which the system calculated AP181 AP190
sales tax. AP193 AP30.2
AP30.4 AP32.2
AP520 API1.1
API2.1 AR115
AR124 AR190
AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR29.2
AR30.1 AR30.2
AR30.4 AR42.1
AR42.2 AR42.7
AR43.1 AR560
AR570 AR575
AR580 BRIP.1
CB10.1 CB180
CB191 CB20.1
CB30.1 CB500
DT180 DT181
EE135 EE35.1
EE35.2 EE520
TX04.1 TX804
TXD-INVOICE-DTE Numeric 8 (yyyymmdd) AP170 AP180
Invoice Date The transaction date associated with AP181 AP190
the tax transaction. AP193 AP30.2
AP30.4 AP32.2
AP520 API1.1
API2.1 AR115
AR124 AR190
AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR29.2
AR30.1 AR30.2
AR30.4 AR42.1
AR42.2 AR42.7
AR43.1 AR560
AR570 AR575
AR580 BRIP.1
CB10.1 CB180
CB191 CB20.1
CB30.1 CB500
DT180 DT181
EE135 EE35.1
EE35.2 EE520
TX04.1 TX804
TXD-POST-DATE Numeric 8 (yyyymmdd) AP170 AP180
General Ledger The general ledger posting date AP181 AP190
Posting Date associated with the tax transaction. AP193 AP30.2
AP30.4 AP32.2
AP520 API1.1
API2.1 AR115
AR124 AR190
AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR29.2
AR30.1 AR30.2
AR30.4 AR42.1
AR42.2 AR42.7
AR43.1 AR560
AR570 AR575
AR580 BRIP.1
CB10.1 CB180
CB191 CB20.1
CB30.1 CB500
DT180 DT181
EE135 EE35.1
EE35.2 EE520
TX04.1 TX804
TXD-TRAN-CURRENCY Alpha 5 AP170 AP180
Tax Transaction The currency of the transaction AP181 AP190
Currency associated with the tax transaction. The AP193 AP30.2
currency must be valid in the Currency AP30.4 AP32.2
system. AP520 API1.1
API2.1 AR115
AR124 AR190
AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR29.2
AR30.1 AR30.2
AR30.4 AR42.1
AR42.2 AR42.7
AR43.1 AR560
AR570 AR575
AR580 BRIP.1
CB10.1 CB180
CB191 CB20.1
CB30.1 CB500
DT180 DT181
EE135 EE35.1
EE35.2 EE520
TX04.1 TX804
TXD-TRAN-INV-AMT Signed 15.2 AP170 AP180
Invoice Amount The amount of the transaction in the AP181 AP190
currency of the transaction. AP193 AP30.2
AP30.4 AP32.2
AP520 API1.1
API2.1 AR115
AR124 AR190
AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR29.2
AR30.1 AR30.2
AR30.4 AR42.1
AR42.2 AR42.7
AR43.1 AR560
AR570 AR575
AR580 BRIP.1
CB10.1 CB180
CB191 CB20.1
CB30.1 CB500
DT180 DT181
EE135 EE35.1
EE35.2 EE520
TX04.1 TX804
TXD-TRAN-TAXABLE Signed 15.2 AP170 AP180
Taxable Amount The taxable amount of the transaction AP181 AP190
in the currency of the transaction. AP193 AP30.2
AP30.4 AP32.2
AP520 API1.1
API2.1 AR115
AR124 AR190
AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR29.2
AR30.1 AR30.2
AR30.4 AR42.1
AR42.2 AR42.7
AR43.1 AR560
AR570 AR575
AR580 BRIP.1
CB10.1 CB180
CB191 CB20.1
CB30.1 CB500
DT180 DT181
EE135 EE35.1
EE35.2 EE520
TX04.1 TX804
TXD-TRAN-TAX-AMT Signed 15.2 AP170 AP180
Tax Amount The tax amount for the tax transaction AP181 AP190
in the currency of the transaction. AP193 AP30.2
AP30.4 AP32.2
AP520 API1.1
API2.1 AR115
AR124 AR190
AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR29.2
AR30.1 AR30.2
AR30.4 AR42.1
AR42.2 AR42.7
AR43.1 AR560
AR570 AR575
AR580 BRIP.1
CB10.1 CB180
CB191 CB20.1
CB30.1 CB500
DT180 DT181
EE135 EE35.1
EE35.2 EE520
TX04.1 TX804
TXD-TRAN-ND Numeric 1 AP170 AP180
Transaction Number The number of decimal places defined AP181 AP190
of Decimals for the transaction currency associated AP193 AP30.2
with the tax transaction. AP30.4 AP32.2
AP520 API1.1
API2.1 AR115
AR124 AR190
AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR29.2
AR30.1 AR30.2
AR30.4 AR42.1
AR42.2 AR42.7
AR43.1 AR560
AR570 AR575
AR580 BRIP.1
CB10.1 CB180
CB191 CB20.1
CB30.1 CB500
DT180 DT181
EE135 EE35.1
EE35.2 EE520
TX04.1 TX804
TXD-BASE-INV-AMT Signed 15.2 AP170 AP180
Base Invoice Amount The amount of the transaction in the AP181 AP190
company base currency. AP193 AP30.2
AP30.4 AP32.2
AP520 API1.1
API2.1 AR115
AR124 AR190
AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR29.2
AR30.1 AR30.2
AR30.4 AR42.1
AR42.2 AR42.7
AR43.1 AR560
AR570 AR575
AR580 BRIP.1
CB10.1 CB180
CB191 CB20.1
CB30.1 CB500
DT180 DT181
EE135 EE35.1
EE35.2 EE520
TX04.1 TX804
TXD-BASE-TAXABLE Signed 15.2 AP170 AP180
Base Taxable Amount The taxable amount of the transaction AP181 AP190
in the company base currency. AP193 AP30.2
AP30.4 AP32.2
AP520 API1.1
API2.1 AR115
AR124 AR190
AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR29.2
AR30.1 AR30.2
AR30.4 AR42.1
AR42.2 AR42.7
AR43.1 AR560
AR570 AR575
AR580 BRIP.1
CB10.1 CB180
CB191 CB20.1
CB30.1 CB500
DT180 DT181
EE135 EE35.1
EE35.2 EE520
TX04.1 TX804
TXD-BASE-TAX-AMT Signed 15.2 AP170 AP180
Total Tax Amount The tax amount of the tax transaction AP181 AP190
in the company base currency. AP193 AP30.2
AP30.4 AP32.2
AP520 API1.1
API2.1 AR115
AR124 AR190
AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR29.2
AR30.1 AR30.2
AR30.4 AR42.1
AR42.2 AR42.7
AR43.1 AR560
AR570 AR575
AR580 BRIP.1
CB10.1 CB180
CB191 CB20.1
CB30.1 CB500
DT180 DT181
EE135 EE35.1
EE35.2 EE520
TX04.1 TX804
TXD-BASE-ND Numeric 1 AP170 AP180
Base Number Of The number of decimal places defined AP181 AP190
Decimals for the company base currency. AP193 AP30.2
AP30.4 AP32.2
AP520 API1.1
API2.1 AR115
AR124 AR190
AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR29.2
AR30.1 AR30.2
AR30.4 AR42.1
AR42.2 AR42.7
AR43.1 AR560
AR570 AR575
AR580 BRIP.1
CB10.1 CB180
CB191 CB20.1
CB30.1 CB500
DT180 DT181
EE135 EE35.1
EE35.2 EE520
TX04.1 TX804
TXD-TAX-RATE Percent 7.5 (Percent) AP170 AP180
Tax Rate The tax rate that the system used for AP181 AP190
the transaction. AP193 AP30.2
AP30.4 AP32.2
AP520 API1.1
API2.1 AR115
AR124 AR190
AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR29.2
AR30.1 AR30.2
AR30.4 AR42.1
AR42.2 AR42.7
AR43.1 AR560
AR570 AR575
AR580 BRIP.1
CB10.1 CB180
CB191 CB20.1
CB30.1 CB500
DT180 DT181
EE135 EE35.1
EE35.2 EE520
TX04.1 TX804
TXD-ACCRUAL-FL Alpha 1 AP170 AP180
Accrual Flag Accrual flags determined how tax was AP181 AP190
applied to invoices, whether as invoiced AP193 AP30.2
or accrued (noninvoiced). AP30.4 AP32.2
I = Invoiced AP520 API1.1
A = Accrued API2.1 AR115
AR124 AR190
AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR29.2
AR30.1 AR30.2
AR30.4 AR42.1
AR42.2 AR42.7
AR43.1 AR560
AR570 AR575
AR580 BRIP.1
CB10.1 CB180
CB191 CB20.1
CB30.1 CB500
DT180 DT181
EE135 EE35.1
EE35.2 EE520
TX04.1 TX804
TXD-PROC-LEVEL Alpha 5 AP170 AP180
Process Level The process level associated with the AP181 AP190
tax transaction. You define process AP193 AP30.2
levels in the Accounts Receivable, AP30.4 AP32.2
Accounts Payable, and Billing systems. AP520 API1.1
API2.1 AR115
AR124 AR190
AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR29.2
AR30.1 AR30.2
AR30.4 AR42.1
AR42.2 AR42.7
AR43.1 AR560
AR570 AR575
AR580 BRIP.1
CB10.1 CB180
CB191 CB20.1
CB30.1 CB500
DT180 DT181
EE135 EE35.1
EE35.2 EE520
TX04.1 TX804
TXD-CURR-RATE Signed 13.6 AP170 AP180
Currency Exchange The currency exchange rate used to AP181 AP190
Rate convert a nonbase currency transaction AP193 AP30.2
amount to the company base currency. AP30.4 AP32.2
AP520 API1.1
API2.1 AR115
AR124 AR190
AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR29.2
AR30.1 AR30.2
AR30.4 AR42.1
AR42.2 AR42.7
AR43.1 AR560
AR570 AR575
AR580 BRIP.1
CB10.1 CB180
CB191 CB20.1
CB30.1 CB500
DT180 DT181
EE135 EE35.1
EE35.2 EE520
TX04.1 TX804
TXD-STATUS Numeric 1 AP170 AP180
Tax Transaction This field indicates whether the tax AP181 AP190
Update Status transaction has been updated by running AP193 AP30.2
TX100 (Tax Analysis Report). AP30.4 AP32.2
0 = Created AP520 API1.1
1 = Reported API2.1 AR115
AR124 AR190
AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR29.2
AR30.1 AR30.2
AR30.4 AR42.1
AR42.2 AR42.7
AR43.1 AR560
AR570 AR575
AR580 BRIP.1
CB10.1 CB180
CB191 CB20.1
CB30.1 CB500
DT180 DT181
EE135 EE35.1
EE35.2 EE520
TX04.1 TX100
TX804
TXD-MANUAL-FL Alpha 1 AP170 AP180
Manual Fl This field indicates whether the tax AP181 AP190
transaction was created manually or not. AP193 AP30.2
Y = Yes AP30.4 AP32.2
N = No AP520 API1.1
API2.1 AR115
AR124 AR190
AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR29.2
AR30.1 AR30.2
AR30.4 AR42.1
AR42.2 AR42.7
AR43.1 AR560
AR570 AR575
AR580 BRIP.1
CB10.1 CB180
CB191 CB20.1
CB30.1 CB500
DT180 DT181
EE135 EE35.1
EE35.2 EE520
TX04.1 TX804
TXD-INPUT-OUTPUT Derived
Input Output 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 Derived
Vend Cust Name
TXD-VAT-REG-CTRY Alpha 2 AP170 AP180
Vat Reg Ctry The country component of the VAT AP181 AP190
Registration Number. This field, AP193 AP30.2
together with the Registration Number AP30.4 AP32.2
for the company on the tax transaction. AP520 API1.1
API2.1 AR115
AR124 AR190
AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR29.2
AR30.1 AR30.2
AR30.4 AR42.1
AR42.2 AR42.7
AR43.1 AR560
AR570 AR575
AR580 BRIP.1
CB10.1 CB180
CB191 CB20.1
CB30.1 CB500
DT180 DT181
EE135 EE35.1
EE35.2 EE520
TX04.1
TXD-VAT-REG-NBR Alpha 12 AP170 AP180
Vat Reg Nbr The number component of the VAT AP181 AP190
Registration Number. This field together AP193 AP30.2
with the Registration Country field make AP30.4 AP32.2
up the VAT Registration Number. AP520 API1.1
API2.1 AR115
AR124 AR190
AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR29.2
AR30.1 AR30.2
AR30.4 AR42.1
AR42.2 AR42.7
AR43.1 AR560
AR570 AR575
AR580 BRIP.1
CB10.1 CB180
CB191 CB20.1
CB30.1 CB500
DT180 DT181
EE135 EE35.1
EE35.2 EE520
TX04.1
TXD-TAX-USAGE-CD Alpha 10 AP170 AP180
Tax Usage Cd The tax usage coe for the vendor. This AP181 AP190
filed is required if the AP Company AP193 AP30.2
inidcates that VAT reporting required. AP30.4 AP32.2
AP520 API1.1
API2.1 AR115
AR124 AR190
AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR29.2
AR30.1 AR30.2
AR30.4 AR42.1
AR42.2 AR42.7
AR43.1 AR560
AR570 AR575
AR580 BRIP.1
CB10.1 CB180
CB191 CB20.1
CB30.1 CB500
DT180 DT181
EE135 EE35.1
EE35.2 EE520
TX04.1
TXD-INV-CRD-IND Alpha 1 AP170 AP180
Inv Crd Ind Specified whether the transaction on AP181 AP190
which the tax was entered as an invoice AP193 AP30.2
or a credit memo. AP30.4 AP32.2
I = Invoice AP520 API1.1
C = Credit Memo API2.1 AR115
AR124 AR190
AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR29.2
AR30.1 AR30.2
AR30.4 AR42.1
AR42.2 AR42.7
AR43.1 AR560
AR570 AR575
AR580 BRIP.1
CB10.1 CB180
CB191 CB20.1
CB30.1 CB500
DT180 DT181
EE135 EE35.1
EE35.2 EE520
TX04.1
TXD-TAX-YEAR Numeric 4 AP170 AP180
Tax Year The tax year for which the calendar was AP181 AP190
defined. AP193 AP30.2
AP30.4 AP32.2
AP520 API1.1
API2.1 AR115
AR124 AR190
AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR29.2
AR30.1 AR30.2
AR30.4 AR42.1
AR42.2 AR42.7
AR43.1 AR560
AR570 AR575
AR580 BRIP.1
CB10.1 CB180
CB191 CB20.1
CB30.1 CB500
DT180 DT181
EE135 EE35.1
EE35.2 EE520
TX04.1 TX120
TXD-TAX-PERIOD Numeric 2 AP170 AP180
Tax Period The tax period of the specified year. AP181 AP190
AP193 AP30.2
AP30.4 AP32.2
AP520 API1.1
API2.1 AR115
AR124 AR190
AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR29.2
AR30.1 AR30.2
AR30.4 AR42.1
AR42.2 AR42.7
AR43.1 AR560
AR570 AR575
AR580 BRIP.1
CB10.1 CB180
CB191 CB20.1
CB30.1 CB500
DT180 DT181
EE135 EE35.1
EE35.2 EE520
TX04.1 TX120
TXD-SOURCE Alpha 1 AP170 AP180
Source The source of the transaction. Input or AP181 AP190
output. Input transactions are Accounts AP193 AP30.2
Payable. Output transactions are AP30.4 AP32.2
Accounts Receivable. AP520 API1.1
I = Input = AP API2.1 AR115
O = Output = AR AR124 AR190
AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR29.2
AR30.1 AR30.2
AR30.4 AR42.1
AR42.2 AR42.7
AR43.1 AR560
AR570 AR575
AR580 BRIP.1
CB10.1 CB180
CB191 CB20.1
CB30.1 CB500
DT180 DT181
EE135 EE35.1
EE35.2 EE520
TX04.1
TXD-PURCH-SALE-RPT Alpha 1 TX125
Purch Sale Rpt Indicates whether a VAT Purchase and
Sales report is required.
TXD-CANCEL-FL Alpha 1
Cancel Flag Indicates whether this reason code is
valid in order cancellation.
TXTAXTRAN FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
TXDSET1 COMPANY This index is used to keep tax AP170 AP180
TAX-CODE transactions unique. AP181 AP190
TRANS-IDENT AP193 AP30.2
AP30.4 AP32.2
AP520 API1.1
API2.1 AR115
AR124 AR190
AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR29.2
AR30.1 AR30.2
AR30.4 AR42.1
AR42.2 AR42.7
AR43.1 AR560
AR570 AR575
...
TXDSET2 COMPANY This index is used to access tax TX120 TX125
TAX-CODE transactions for a specific company and
SYSTEM-CD tax code.
TAX-PNT-DATE*
VOUCHER-NBR KeyChange
TRANS-IDENT
TXDSET4 COMPANY KeyChange, Duplicates TX130
TAX-YEAR
TAX-PERIOD
SYSTEM-CD
TRANS-IDENT
TXDSET6 COMPANY
INVOICE
TAX-CODE
PROD-TAX-CAT
TRANS-IDENT
TXTAXTRAN FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
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 TXD-ACCT-BY-CODE = "Y"
TXD-COMPANY -> TAC-COMPANY
TXD-TAX-CODE -> TAC-TAX-CODE
|