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 AP30.2 AP30.4
AP32.2 AP520 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 AR82.1 BL122
CB10.1 CB180 CB191 CB20.1 CB30.1 CB500
DT180 DT181 EE135 EE35.1 EE35.2 EE520
MA530 MA540 PBIP.1 PO31.1 TX04.1 TX100
TX120 TX125 TX225 TX300 TX804 TX904
TX957
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
TXD-COMPANY Numeric 4 AP125 AP126
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
AP30.2 AP30.4
AP32.2 AP520
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
AR82.1 BL122
CB10.1 CB180
CB191 CB20.1
CB30.1 CB500
DT180 DT181
EE135 EE35.1
EE35.2 EE520
MA530 MA540
PBIP.1 PO31.1
TX04.1 TX804
TX904 TX957
TXD-TAX-CODE Alpha 10 AP125 AP126
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
AP30.2 AP30.4
AP32.2 AP520
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
AR82.1 BL122
CB10.1 CB180
CB191 CB20.1
CB30.1 CB500
DT180 DT181
EE135 EE35.1
EE35.2 EE520
MA530 MA540
PBIP.1 PO31.1
TX04.1 TX804
TX904 TX957
TXD-TRANS-IDENT Numeric 10 AP125 AP126
Transaction ID A 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
AP30.2 AP30.4
AP32.2 AP520
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
AR82.1 BL122
CB10.1 CB180
CB191 CB20.1
CB30.1 CB500
DT180 DT181
EE135 EE35.1
EE35.2 EE520
MA530 MA540
PBIP.1 PO31.1
TX04.1 TX804
TX904 TX957
TXD-SYSTEM-CD Alpha 2 AP125 AP126
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 AP30.2 AP30.4
CB = Cash Ledger AP32.2 AP520
CR = Cash Receipts 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
AR82.1 BL122
CB10.1 CB180
CB191 CB20.1
CB30.1 CB500
DT180 DT181
EE135 EE35.1
EE35.2 EE520
MA530 MA540
PBIP.1 PO31.1
TX04.1 TX804
TX904 TX957
TXD-VEND-CUST Alpha 9 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
AP30.2 AP30.4
AP32.2 AP520
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
AR82.1 BL122
CB10.1 CB180
CB191 CB20.1
CB30.1 CB500
DT180 DT181
EE135 EE35.1
EE35.2 EE520
MA530 MA540
PBIP.1 PO31.1
TX04.1 TX804
TX904 TX957
TXD-TAX-ID-NBR Alpha 20 AP125 AP126
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
AP30.2 AP30.4
AP32.2 AP520
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
AR82.1 BL122
CB10.1 CB180
CB191 CB20.1
CB30.1 CB500
DT180 DT181
EE135 EE35.1
EE35.2 EE520
MA530 MA540
PBIP.1 PO31.1
TX04.1 TX804
TX904 TX957
TXD-PROD-TAX-CAT Alpha 15 AP125 AP126
Product Tax Category A 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. AP30.2 AP30.4
AP32.2 AP520
You define a product tax category in AR115 AR124
the Inventory Control system. 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
AR82.1 BL122
CB10.1 CB180
CB191 CB20.1
CB30.1 CB500
DT180 DT181
EE135 EE35.1
EE35.2 EE520
MA530 MA540
PBIP.1 PO31.1
TX04.1 TX804
TX904 TX957
TXD-INVOICE Alpha 22 AP125 AP126
Invoice Number The invoice number associated with the AP170 AP180
tax transaction. AP181 AP190
AP193 AP25.1
AP25.2 AP26.1
AP30.2 AP30.4
AP32.2 AP520
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
AR82.1 BL122
CB10.1 CB180
CB191 CB20.1
CB30.1 CB500
DT180 DT181
EE135 EE35.1
EE35.2 EE520
MA530 MA540
PBIP.1 PO31.1
TX04.1 TX804
TX904 TX957
TXD-SUFFIX Numeric 3 AP125 AP126
Invoice Suffix The 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
AP30.2 AP30.4
AP32.2 AP520
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
AR82.1 BL122
CB10.1 CB180
CB191 CB20.1
CB30.1 CB500
DT180 DT181
EE135 EE35.1
EE35.2 EE520
MA530 MA540
PBIP.1 PO31.1
TX04.1 TX804
TX904 TX957
TXD-CANCEL-SEQ Numeric 4 AP125 AP126
Cancel Sequence A 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
AP30.2 AP30.4
AP32.2 AP520
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
AR82.1 BL122
CB10.1 CB180
CB191 CB20.1
CB30.1 CB500
DT180 DT181
EE135 EE35.1
EE35.2 EE520
MA530 MA540
PBIP.1 PO31.1
TX04.1 TX804
TX904 TX957
TXD-DIST-COMPANY Numeric 4 AP125 AP126
Distribution 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
AP30.2 AP30.4
AP32.2 AP520
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
AR82.1 BL122
CB10.1 CB180
CB191 CB20.1
CB30.1 CB500
DT180 DT181
EE135 EE35.1
EE35.2 EE520
MA530 MA540
PBIP.1 PO31.1
TX04.1 TX804
TX904 TX957
TXD-TAX-ACCT-UNIT Alpha 15 AP125 AP126
Tax Accounting Unit The 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
AP30.2 AP30.4
AP32.2 AP520
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
AR82.1 BL122
CB10.1 CB180
CB191 CB20.1
CB30.1 CB500
DT180 DT181
EE135 EE35.1
EE35.2 EE520
MA530 MA540
PBIP.1 PO31.1
TX04.1 TX804
TX904 TX957
TXD-TAX-ACCOUNT Numeric 6 AP125 AP126
Tax 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
AP30.2 AP30.4
AP32.2 AP520
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
AR82.1 BL122
CB10.1 CB180
CB191 CB20.1
CB30.1 CB500
DT180 DT181
EE135 EE35.1
EE35.2 EE520
MA530 MA540
PBIP.1 PO31.1
TX04.1 TX804
TX904 TX957
TXD-TAX-SUB-ACCT Numeric 4 AP125 AP126
Tax 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
AP30.2 AP30.4
AP32.2 AP520
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
AR82.1 BL122
CB10.1 CB180
CB191 CB20.1
CB30.1 CB500
DT180 DT181
EE135 EE35.1
EE35.2 EE520
MA530 MA540
PBIP.1 PO31.1
TX04.1 TX804
TX904 TX957
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
AP30.2 AP30.4
AP32.2 AP520
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
AR82.1 BL122
CB10.1 CB180
CB191 CB20.1
CB30.1 CB500
DT180 DT181
EE135 EE35.1
EE35.2 EE520
MA530 MA540
PBIP.1 PO31.1
TX04.1 TX804
TX904 TX957
TXD-VOUCHER-NBR Alpha 10 AP125 AP126
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
AP30.2 AP30.4
AP32.2 AP520
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
AR82.1 BL122
CB10.1 CB180
CB191 CB20.1
CB30.1 CB500
DT180 DT181
EE135 EE35.1
EE35.2 EE520
MA530 MA540
PBIP.1 PO31.1
TX04.1 TX804
TX904 TX957
TXD-TAX-PNT-DATE Numeric 8 (yyyymmdd) AP125 AP126
Tax Point Date The date at which the system calculated AP170 AP180
sales tax. AP181 AP190
AP193 AP25.1
AP25.2 AP26.1
AP30.2 AP30.4
AP32.2 AP520
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
AR82.1 BL122
CB10.1 CB180
CB191 CB20.1
CB30.1 CB500
DT180 DT181
EE135 EE35.1
EE35.2 EE520
MA530 MA540
PBIP.1 PO31.1
TX04.1 TX804
TX904 TX957
TXD-INVOICE-DTE Numeric 8 (yyyymmdd) AP125 AP126
Invoice Date The transaction date associated with AP170 AP180
the tax transaction. AP181 AP190
AP193 AP25.1
AP25.2 AP26.1
AP30.2 AP30.4
AP32.2 AP520
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
AR82.1 BL122
CB10.1 CB180
CB191 CB20.1
CB30.1 CB500
DT180 DT181
EE135 EE35.1
EE35.2 EE520
MA530 MA540
PBIP.1 PO31.1
TX04.1 TX804
TX904 TX957
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
AP30.2 AP30.4
AP32.2 AP520
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
AR82.1 BL122
CB10.1 CB180
CB191 CB20.1
CB30.1 CB500
DT180 DT181
EE135 EE35.1
EE35.2 EE520
MA530 MA540
PBIP.1 PO31.1
TX04.1 TX804
TX904 TX957
TXD-TRAN-CURRENCY Alpha 5 AP125 AP126
Tax Transaction 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
AP30.2 AP30.4
AP32.2 AP520
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
AR82.1 BL122
CB10.1 CB180
CB191 CB20.1
CB30.1 CB500
DT180 DT181
EE135 EE35.1
EE35.2 EE520
MA530 MA540
PBIP.1 PO31.1
TX04.1 TX804
TX904 TX957
TXD-TRAN-INV-AMT Signed 15.2 AP125 AP126
Invoice Amount The amount of the transaction in the AP170 AP180
currency of the transaction. AP181 AP190
AP193 AP25.1
AP25.2 AP26.1
AP30.2 AP30.4
AP32.2 AP520
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
AR82.1 BL122
CB10.1 CB180
CB191 CB20.1
CB30.1 CB500
DT180 DT181
EE135 EE35.1
EE35.2 EE520
MA530 MA540
PBIP.1 PO31.1
TX04.1 TX804
TX904 TX957
TXD-TRAN-TAXABLE Signed 15.2 AP125 AP126
Taxable Amount The taxable amount of the transaction AP170 AP180
in the currency of the transaction. AP181 AP190
AP193 AP25.1
AP25.2 AP26.1
AP30.2 AP30.4
AP32.2 AP520
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
AR82.1 BL122
CB10.1 CB180
CB191 CB20.1
CB30.1 CB500
DT180 DT181
EE135 EE35.1
EE35.2 EE520
MA530 MA540
PBIP.1 PO31.1
TX04.1 TX804
TX904 TX957
TXD-TRAN-TAX-AMT Signed 15.2 AP125 AP126
Tax Amount The tax amount for the tax transaction AP170 AP180
in the currency of the transaction. AP181 AP190
AP193 AP25.1
AP25.2 AP26.1
AP30.2 AP30.4
AP32.2 AP520
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
AR82.1 BL122
CB10.1 CB180
CB191 CB20.1
CB30.1 CB500
DT180 DT181
EE135 EE35.1
EE35.2 EE520
MA530 MA540
PBIP.1 PO31.1
TX04.1 TX804
TX904 TX957
TXD-TRAN-ND Numeric 1 AP125 AP126
Transaction Number The number of decimal places defined AP170 AP180
of Decimals for the transaction currency associated AP181 AP190
with the tax transaction. AP193 AP25.1
AP25.2 AP26.1
AP30.2 AP30.4
AP32.2 AP520
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
AR82.1 BL122
CB10.1 CB180
CB191 CB20.1
CB30.1 CB500
DT180 DT181
EE135 EE35.1
EE35.2 EE520
MA530 MA540
PBIP.1 PO31.1
TX04.1 TX804
TX904 TX957
TXD-BASE-INV-AMT Signed 15.2 AP125 AP126
Base Invoice Amount The amount of the transaction in the AP170 AP180
company base currency. AP181 AP190
AP193 AP25.1
AP25.2 AP26.1
AP30.2 AP30.4
AP32.2 AP520
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
AR82.1 BL122
CB10.1 CB180
CB191 CB20.1
CB30.1 CB500
DT180 DT181
EE135 EE35.1
EE35.2 EE520
MA530 MA540
PBIP.1 PO31.1
TX04.1 TX804
TX904 TX957
TXD-BASE-TAXABLE Signed 15.2 AP125 AP126
Base Taxable Amount The taxable amount of the transaction AP170 AP180
in the company base currency. AP181 AP190
AP193 AP25.1
AP25.2 AP26.1
AP30.2 AP30.4
AP32.2 AP520
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
AR82.1 BL122
CB10.1 CB180
CB191 CB20.1
CB30.1 CB500
DT180 DT181
EE135 EE35.1
EE35.2 EE520
MA530 MA540
PBIP.1 PO31.1
TX04.1 TX804
TX904 TX957
TXD-BASE-TAX-AMT Signed 15.2 AP125 AP126
Total Tax Amount The tax amount of the tax transaction AP170 AP180
in the company base currency. AP181 AP190
AP193 AP25.1
AP25.2 AP26.1
AP30.2 AP30.4
AP32.2 AP520
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
AR82.1 BL122
CB10.1 CB180
CB191 CB20.1
CB30.1 CB500
DT180 DT181
EE135 EE35.1
EE35.2 EE520
MA530 MA540
PBIP.1 PO31.1
TX04.1 TX804
TX904 TX957
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
AP30.2 AP30.4
AP32.2 AP520
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
AR82.1 BL122
CB10.1 CB180
CB191 CB20.1
CB30.1 CB500
DT180 DT181
EE135 EE35.1
EE35.2 EE520
MA530 MA540
PBIP.1 PO31.1
TX04.1 TX804
TX904 TX957
TXD-TAX-RATE Percent 7.5 (Percent) AP125 AP126
Tax Rate The tax rate that the system used for AP170 AP180
the transaction. AP181 AP190
AP193 AP25.1
AP25.2 AP26.1
AP30.2 AP30.4
AP32.2 AP520
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
AR82.1 BL122
CB10.1 CB180
CB191 CB20.1
CB30.1 CB500
DT180 DT181
EE135 EE35.1
EE35.2 EE520
MA530 MA540
PBIP.1 PO31.1
TX04.1 TX804
TX904 TX957
TXD-ACCRUAL-FL Alpha 1 AP125 AP126
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 AP30.2 AP30.4
AP32.2 AP520
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
AR82.1 BL122
CB10.1 CB180
CB191 CB20.1
CB30.1 CB500
DT180 DT181
EE135 EE35.1
EE35.2 EE520
MA530 MA540
PBIP.1 PO31.1
TX04.1 TX804
TX904 TX957
TXD-PROC-LEVEL Alpha 5 AP125 AP126
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
AP30.2 AP30.4
AP32.2 AP520
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
AR82.1 BL122
CB10.1 CB180
CB191 CB20.1
CB30.1 CB500
DT180 DT181
EE135 EE35.1
EE35.2 EE520
MA530 MA540
PBIP.1 PO31.1
TX04.1 TX804
TX904 TX957
TXD-CURR-RATE Signed 13.6 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
AP30.2 AP30.4
AP32.2 AP520
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
AR82.1 BL122
CB10.1 CB180
CB191 CB20.1
CB30.1 CB500
DT180 DT181
EE135 EE35.1
EE35.2 EE520
MA530 MA540
PBIP.1 PO31.1
TX04.1 TX804
TX904 TX957
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 AP30.2 AP30.4
AP32.2 AP520
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
AR82.1 BL122
CB10.1 CB180
CB191 CB20.1
CB30.1 CB500
DT180 DT181
EE135 EE35.1
EE35.2 EE520
MA530 MA540
PBIP.1 PO31.1
TX04.1 TX100
TX225 TX804
TX904 TX957
TXD-MANUAL-FL Alpha 1 AP125 AP126
Manual Fl 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
AP30.2 AP30.4
AP32.2 AP520
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
AR82.1 BL122
CB10.1 CB180
CB191 CB20.1
CB30.1 CB500
DT180 DT181
EE135 EE35.1
EE35.2 EE520
MA530 MA540
PBIP.1 PO31.1
TX04.1 TX804
TX904 TX957
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 The name of the vendor or customer
corresponding to the vendor or customer
ID referenced in the VAT report.
TXD-VAT-REG-CTRY Alpha 2 AP125 AP126
VAT Registration This field along with the VAT-REG-NBR AP170 AP180
Country make up the VAT Registration Number for AP181 AP190
the company on the Tax Transaction. AP193 AP25.1
AP25.2 AP26.1
AP30.2 AP30.4
AP32.2 AP520
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
AR82.1 BL122
CB10.1 CB180
CB191 CB20.1
CB30.1 CB500
DT180 DT181
EE135 EE35.1
EE35.2 EE520
MA530 MA540
PBIP.1 PO31.1
TX04.1
TXD-VAT-REG-NBR Alpha 12 AP125 AP126
VAT Registration This field along with the VAT-REG-CTRY AP170 AP180
Number make up the VAT Registration Number. AP181 AP190
AP193 AP25.1
AP25.2 AP26.1
AP30.2 AP30.4
AP32.2 AP520
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
AR82.1 BL122
CB10.1 CB180
CB191 CB20.1
CB30.1 CB500
DT180 DT181
EE135 EE35.1
EE35.2 EE520
MA530 MA540
PBIP.1 PO31.1
TX04.1
TXD-TAX-USAGE-CD Alpha 10 AP125 AP126
Tax Usage Code The tax usage code assigned to a vendor AP170 AP180
to keep statistics on the invoice AP181 AP190
amounts of goods and services AP193 AP25.1
purchased for specific uses. Such AP25.2 AP26.1
statistics are required on some VAT AP30.2 AP30.4
returns. AP32.2 AP520
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
AR82.1 BL122
CB10.1 CB180
CB191 CB20.1
CB30.1 CB500
DT180 DT181
EE135 EE35.1
EE35.2 EE520
MA530 MA540
PBIP.1 PO31.1
TX04.1
TXD-INV-CRD-IND Alpha 1 AP125 AP126
Invoice/Credit Memo Specifies whether the tax transactions AP170 AP180
Indicator collected for a specific VAT report line AP181 AP190
(defined on TX06.1) consist of invoices, AP193 AP25.1
credit memos, or both. AP25.2 AP26.1
I - Invoice AP30.2 AP30.4
C - Credit memo AP32.2 AP520
B - Both 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
AR82.1 BL122
CB10.1 CB180
CB191 CB20.1
CB30.1 CB500
DT180 DT181
EE135 EE35.1
EE35.2 EE520
MA530 MA540
PBIP.1 PO31.1
TX04.1
TXD-TAX-YEAR Numeric 4 AP125 AP126
Tax Year The tax year for which the calendar was AP170 AP180
defined. AP181 AP190
AP193 AP25.1
AP25.2 AP26.1
AP30.2 AP30.4
AP32.2 AP520
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
AR82.1 BL122
CB10.1 CB180
CB191 CB20.1
CB30.1 CB500
DT180 DT181
EE135 EE35.1
EE35.2 EE520
MA530 MA540
PBIP.1 PO31.1
TX04.1 TX120
TXD-TAX-PERIOD Numeric 2 AP125 AP126
Tax Period A VAT reporting period defined for a AP170 AP180
company and tax year in a tax calendar AP181 AP190
using TX08.1 (Tax Calendar Maintenance) AP193 AP25.1
AP25.2 AP26.1
AP30.2 AP30.4
AP32.2 AP520
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
AR82.1 BL122
CB10.1 CB180
CB191 CB20.1
CB30.1 CB500
DT180 DT181
EE135 EE35.1
EE35.2 EE520
MA530 MA540
PBIP.1 PO31.1
TX04.1 TX120
TXD-SOURCE Alpha 1 AP125 AP126
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
AP30.2 AP30.4
AP32.2 AP520
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
AR82.1 BL122
CB10.1 CB180
CB191 CB20.1
CB30.1 CB500
DT180 DT181
EE135 EE35.1
EE35.2 EE520
MA530 MA540
PBIP.1 PO31.1
TX04.1 TX957
TXD-PURCH-SALE-RPT Alpha 1 TX125
Purchase and Sales Indicates whether a VAT Purchase and
report Sales report is required. This is a
Belgian requirement only.
TXD-CANCEL-FL Alpha 1
Cancel Flag Indicates whether this tax transaction
created for the unposted canceled AP
tax distributions in AP30. This field
is only used for TX125 Belgium
report.
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
AP30.2 AP30.4
AP32.2 AP520
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
...
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, Duplicates
TXDSET3 COMPANY This index is used to access tax
SYSTEM-CD transactions for a specific company,
VEND-CUST source, and vendor or customer..
INVOICE KeyChange, Duplicates
SUFFIX
CANCEL-SEQ
TAX-CODE
TRANS-IDENT
TXDSET4 COMPANY This index is used to access tax TX130
TAX-YEAR transaction for a specific company and
TAX-PERIOD tax period.
SYSTEM-CD KeyChange, Duplicates
TRANS-IDENT
TXDSET5 COMPANY This index is used to access tax
SYSTEM-CD transactions for a specific company and
TRANS-IDENT source.
KeyChange, Duplicates
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
Apcompany APCOMPANY Not Required
TXD-COMPANY -> CPY-COMPANY (CPYSET1)
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
|