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 TX222
UPDATED BY
AP125 AP126 AP170 AP180 AP181 AP190
AP193 AP195 AP20.1 AP20.2 AP20.3 AP20.4
AP20.5 AP20.7 AP21.1 AP23.1 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 AR32.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
CB150 CB180 CB191 CB20.1 CB30.1 CB45.1
CB46.1 CB500 CB543 CB544 DT180 DT181
EE135 EE35.1 EE35.2 EE520 MA41.1 MA41.2
MA41.4 MA41.7 MA43.2 MA61.1 MA70.1 MA75.1
MAI1.1 TX04.1 TX100 TX101 TX120 TX125
TX300 TX804 WH20.7
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 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 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
AR32.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 CB150
...
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 AP20.1
Code Master). AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 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
AR32.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 CB150
...
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 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 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
AR32.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 CB150
...
TXD-SYSTEM-CD Alpha 2 AP125 AP126
Element: System Cd 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 AP21.1
CR = Cash Receipts AP23.1 AP25.1
BR = Billing and Revenue 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
AR32.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 CB150
...
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 AP21.1
AP23.1 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
AR32.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 CB150
...
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 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 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
AR32.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 CB150
...
TXD-PROD-TAX-CAT Alpha 15 AP125 AP126
Element: Prod Tax Cat 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 AP21.1
You define a product tax category in AP23.1 AP25.1
the Inventory Control 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
AR32.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 CB150
...
TXD-INVOICE Alpha 22 AP125 AP126
Element: Invoice 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 AP21.1
AP23.1 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
AR32.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 CB150
...
TXD-SUFFIX Numeric 3 AP125 AP126
Element: 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 AP21.1
AP23.1 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
AR32.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 CB150
...
TXD-CANCEL-SEQ Numeric 4 AP125 AP126
Element: Seq Nbr 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 AP21.1
AP23.1 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
AR32.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 CB150
...
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 AP20.1
Ledger system. AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 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
AR32.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 CB150
...
TXD-TAX-ACCT-UNIT Alpha 15 AP125 AP126
Element: Acct 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 AP21.1
AP23.1 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
AR32.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 CB150
...
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 AP20.1
the General Ledger system. AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 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
AR32.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 CB150
...
TXD-TAX-SUB-ACCT Numeric 4 AP125 AP126
Element: Sub Acct 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 AP21.1
AP23.1 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
AR32.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 CB150
...
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 AP21.1
AP23.1 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
AR32.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 CB150
...
TXD-VOUCHER-NBR Alpha 10 AP125 AP126
Element: Voucher Nbr 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 AP21.1
AP23.1 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
AR32.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 CB150
...
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 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 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
AR32.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 CB150
...
TXD-INVOICE-DTE Numeric 8 (yyyymmdd) AP125 AP126
Element: Invoice Dte 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 AP21.1
AP23.1 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
AR32.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 CB150
...
TXD-POST-DATE Numeric 8 (yyyymmdd) AP125 AP126
Element: Post Date The general ledger posting date AP170 AP180
associated with the tax transaction. AP181 AP190
AP193 AP195
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP23.1
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 AR32.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
...
TXD-TRAN-CURRENCY Alpha 5 AP125 AP126
Element: To Base Curr The currency of the transaction AP170 AP180
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 AP21.1
AP23.1 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
AR32.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 CB150
...
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 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 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
AR32.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 CB150
...
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 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 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
AR32.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 CB150
...
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 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 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
AR32.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 CB150
...
TXD-TRAN-ND Numeric 1 AP125 AP126
Element: Acct Nd The number of decimal places defined AP170 AP180
for the transaction currency associated AP181 AP190
with the tax transaction. AP193 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 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
AR32.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 CB150
...
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 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 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
AR32.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 CB150
...
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 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 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
AR32.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 CB150
...
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 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 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
AR32.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 CB150
...
TXD-BASE-ND Numeric 1 AP125 AP126
Element: Base Nd The number of decimal places defined AP170 AP180
for the company base currency. AP181 AP190
AP193 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 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
AR32.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 CB150
...
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 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 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
AR32.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 CB150
...
TXD-ACCRUAL-FL Alpha 1 AP125 AP126
Element: Accrual Fl 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 AP21.1
AP23.1 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
AR32.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 CB150
...
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 AP20.1
Accounts Payable, and Billing systems. AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 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
AR32.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 CB150
...
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 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 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
AR32.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 CB150
...
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 AP21.1
AP23.1 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
AR32.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 CB150
...
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 AP20.1
N = No AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 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
AR32.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 CB150
...
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 AP20.1
for the company on the tax transaction. AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 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
AR32.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 CB150
...
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 AP20.1
up the VAT Registration Number. AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 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
AR32.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 CB150
...
TXD-TAX-USAGE-CD Alpha 10 AP125 AP126
Element: Tax Usage Cd The tax usage code for the vendor. This AP170 AP180
field is required if the AP Company AP181 AP190
indicates that VAT reporting is AP193 AP20.1
required. AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 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
AR32.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 CB150
...
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 AP20.1
I = Invoice AP20.2 AP20.3
C = Credit Memo AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 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
AR32.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 CB150
...
TXD-TAX-YEAR Numeric 4 AP125 AP126
Element: 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 AP21.1
AP23.1 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
AR32.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 CB150
...
TXD-TAX-PERIOD Numeric 2 AP125 AP126
Element: 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 AP21.1
AP23.1 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
AR32.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 CB150
...
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 AP20.1
Accounts Receivable. AP20.2 AP20.3
I = Input = AP AP20.4 AP20.5
O = Output = AR AP20.7 AP21.1
AP23.1 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
AR32.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 CB150
...
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
TXTAXTRAN FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
TXDSET1 COMPANY AP125 AP126
TAX-CODE AP170 AP180
TRANS-IDENT AP181 AP190
AP193 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 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
...
TXDSET2 COMPANY KeyChange TX120 TX125
TAX-CODE
SYSTEM-CD
TAX-PNT-DATE*
VOUCHER-NBR
TRANS-IDENT
TXDSET4 COMPANY KeyChange TX130 TX222
TAX-YEAR
TAX-PERIOD
SYSTEM-CD
TRANS-IDENT
TAX-CODE
TXDSET6 COMPANY AP195 TX222
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
|