Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

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