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