 |
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
AP125 AP126 AP170 AP180 AP181 AP190
AP193 AP20.1 AP20.2 AP20.3 AP20.4 AP20.5
AP20.7 AP23.1 AP25.1 AP25.2 AP26.1 AP27.1
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 MA41.2 MA43.2 MA61.1
MA70.1 MAI1.1 PBIP.1 TX04.1 TX100 TX120
TX125 TX300 TX804
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 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
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 MA41.2
MA43.2 MA61.1
...
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 AP20.1
Code Master). AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
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 MA41.2
MA43.2 MA61.1
...
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 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
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 MA41.2
MA43.2 MA61.1
...
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 AP20.1
AR = Accounts Receivable AP20.2 AP20.3
BL = Billing AP20.4 AP20.5
CB = Cash Ledger AP20.7 AP23.1
CR = Cash Receipts AP25.1 AP25.2
AP26.1 AP27.1
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 MA41.2
MA43.2 MA61.1
...
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 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
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 MA41.2
MA43.2 MA61.1
...
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 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
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 MA41.2
MA43.2 MA61.1
...
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 AP20.1
item grouping so that it is taxable in AP20.2 AP20.3
one state but not another. AP20.4 AP20.5
AP20.7 AP23.1
You define a product tax category in AP25.1 AP25.2
the Inventory Control system. AP26.1 AP27.1
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 MA41.2
MA43.2 MA61.1
...
TXD-INVOICE Alpha 22 AP125 AP126
Invoice Number The invoice number associated with the AP170 AP180
tax transaction. AP181 AP190
AP193 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
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 MA41.2
MA43.2 MA61.1
...
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 AP20.1
value of the transaction. AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
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 MA41.2
MA43.2 MA61.1
...
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 AP20.1
assigned is 9999. AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
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 MA41.2
MA43.2 MA61.1
...
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 AP20.1
Ledger system. AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
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 MA41.2
MA43.2 MA61.1
...
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 AP20.1
unit in the General Ledger system. AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
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 MA41.2
MA43.2 MA61.1
...
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 AP20.1
the General Ledger system. AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
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 MA41.2
MA43.2 MA61.1
...
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 AP20.1
in the General Ledger system. AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
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 MA41.2
MA43.2 MA61.1
...
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 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
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 MA41.2
MA43.2 MA61.1
...
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 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
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 MA41.2
MA43.2 MA61.1
...
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 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
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 MA41.2
MA43.2 MA61.1
...
TXD-INVOICE-DTE Numeric 8 (yyyymmdd) AP125 AP126
Invoice Date The transaction date associated with AP170 AP180
the tax transaction. AP181 AP190
AP193 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
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 MA41.2
MA43.2 MA61.1
...
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 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
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 MA41.2
MA43.2 MA61.1
...
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 AP20.1
system. AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
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 MA41.2
MA43.2 MA61.1
...
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 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
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 MA41.2
MA43.2 MA61.1
...
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 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
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 MA41.2
MA43.2 MA61.1
...
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 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
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 MA41.2
MA43.2 MA61.1
...
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 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
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 MA41.2
MA43.2 MA61.1
...
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 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
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 MA41.2
MA43.2 MA61.1
...
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 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
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 MA41.2
MA43.2 MA61.1
...
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 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
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 MA41.2
MA43.2 MA61.1
...
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 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
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 MA41.2
MA43.2 MA61.1
...
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 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
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 MA41.2
MA43.2 MA61.1
...
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 AP20.1
I = Invoiced AP20.2 AP20.3
A = Accrued AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
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 MA41.2
MA43.2 MA61.1
...
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 AP20.1
Accounts Payable, and Billing systems. AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
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 MA41.2
MA43.2 MA61.1
...
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 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
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 MA41.2
MA43.2 MA61.1
...
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 AP20.1
0 = Created AP20.2 AP20.3
1 = Reported AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
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 MA41.2
MA43.2 MA61.1
...
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 AP20.1
N = No AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
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 MA41.2
MA43.2 MA61.1
...
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 AP125 AP126
Vat Reg Ctry The country component of the VAT AP170 AP180
Registration Number. This field, AP181 AP190
together with the Registration Number AP193 AP20.1
for the company on the tax transaction. AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
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 MA41.2
MA43.2 MA61.1
...
TXD-VAT-REG-NBR Alpha 12 AP125 AP126
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 AP20.1
up the VAT Registration Number. AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
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 MA41.2
MA43.2 MA61.1
...
TXD-TAX-USAGE-CD Alpha 10 AP125 AP126
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 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
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 MA41.2
MA43.2 MA61.1
...
TXD-INV-CRD-IND Alpha 1 AP125 AP126
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 AP20.1
I = Invoice AP20.2 AP20.3
C = Credit Memo AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
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 MA41.2
MA43.2 MA61.1
...
TXD-TAX-YEAR Numeric 4 AP125 AP126
Tax Year The tax year for which the calendar was AP170 AP180
defined. AP181 AP190
AP193 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
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 MA41.2
MA43.2 MA61.1
...
TXD-TAX-PERIOD Numeric 2 AP125 AP126
Tax Period The tax period of the specified year. AP170 AP180
AP181 AP190
AP193 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
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 MA41.2
MA43.2 MA61.1
...
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 AP20.1
Accounts Receivable. AP20.2 AP20.3
I = Input = AP AP20.4 AP20.5
O = Output = AR AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
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 MA41.2
MA43.2 MA61.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 AP125 AP126
TAX-CODE transactions unique. AP170 AP180
TRANS-IDENT AP181 AP190
AP193 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP32.2 AP520
API1.1 API2.1
AR115 AR124
AR190 AR20.1
AR21.1 AR21.2
...
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
|