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

UPDATED BY

AP125     AP126     AP170     AP180     AP181     AP190
AP193     AP20.1    AP20.2    AP20.3    AP20.4    AP20.5
AP20.7    AP23.1    AP25.1    AP25.2    AP26.1    AP27.1
AP30.2    AP30.4    AP32.2    AP520     API1.1    API2.1
AR115     AR124     AR190     AR20.1    AR21.1    AR21.2
AR21.3    AR24.1    AR29.2    AR30.1    AR30.2    AR30.4
AR42.1    AR42.2    AR42.7    AR43.1    AR560     AR570
AR575     AR580     BRIP.1    BRPI.1    CB10.1    CB180
CB191     CB20.1    CB30.1    CB500     DT180     DT181
EE135     EE35.1    EE35.2    EE520     MA41.2    MA41.7
MA43.2    MA61.1    MA70.1    MA75.1    MAI1.1    PBIP.1
TX04.1    TX100     TX120     TX125     TX300     TX804

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

TXD-COMPANY            Numeric 4                                 AP125   AP126
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  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP30.2  AP30.4
                                                                 AP32.2  AP520
                                                                 API1.1  API2.1
                                                                 AR115   AR124
                                                                 AR190   AR20.1
                                                                 AR21.1  AR21.2
                                                                 AR21.3  AR24.1
                                                                 AR29.2  AR30.1
                                                                 AR30.2  AR30.4
                                                                 AR42.1  AR42.2
                                                                 AR42.7  AR43.1
                                                                 AR560   AR570
                                                                 AR575   AR580
                                                                 BRIP.1  BRPI.1
                                                                 CB10.1  CB180
                                                                 CB191   CB20.1
                                                                 CB30.1  CB500
                                                                 DT180   DT181
                                                                 EE135   EE35.1
                                                                 EE35.2  EE520
                                                                 MA41.2  MA41.7
                                                                 ...

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  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP30.2  AP30.4
                                                                 AP32.2  AP520
                                                                 API1.1  API2.1
                                                                 AR115   AR124
                                                                 AR190   AR20.1
                                                                 AR21.1  AR21.2
                                                                 AR21.3  AR24.1
                                                                 AR29.2  AR30.1
                                                                 AR30.2  AR30.4
                                                                 AR42.1  AR42.2
                                                                 AR42.7  AR43.1
                                                                 AR560   AR570
                                                                 AR575   AR580
                                                                 BRIP.1  BRPI.1
                                                                 CB10.1  CB180
                                                                 CB191   CB20.1
                                                                 CB30.1  CB500
                                                                 DT180   DT181
                                                                 EE135   EE35.1
                                                                 EE35.2  EE520
                                                                 MA41.2  MA41.7
                                                                 ...

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  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP30.2  AP30.4
                                                                 AP32.2  AP520
                                                                 API1.1  API2.1
                                                                 AR115   AR124
                                                                 AR190   AR20.1
                                                                 AR21.1  AR21.2
                                                                 AR21.3  AR24.1
                                                                 AR29.2  AR30.1
                                                                 AR30.2  AR30.4
                                                                 AR42.1  AR42.2
                                                                 AR42.7  AR43.1
                                                                 AR560   AR570
                                                                 AR575   AR580
                                                                 BRIP.1  BRPI.1
                                                                 CB10.1  CB180
                                                                 CB191   CB20.1
                                                                 CB30.1  CB500
                                                                 DT180   DT181
                                                                 EE135   EE35.1
                                                                 EE35.2  EE520
                                                                 MA41.2  MA41.7
                                                                 ...

TXD-SYSTEM-CD          Alpha 2                                   AP125   AP126
Element: System Code   This field indicates on which system      AP170   AP180
                       the transaction originated.               AP181   AP190
                       AP = Accounts Payable                     AP193   AP20.1
                       AR = Accounts Receivable                  AP20.2  AP20.3
                       BL = Billing                              AP20.4  AP20.5
                       CB = Cash Ledger                          AP20.7  AP23.1
                       CR = Cash Receipts                        AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP30.2  AP30.4
                                                                 AP32.2  AP520
                                                                 API1.1  API2.1
                                                                 AR115   AR124
                                                                 AR190   AR20.1
                                                                 AR21.1  AR21.2
                                                                 AR21.3  AR24.1
                                                                 AR29.2  AR30.1
                                                                 AR30.2  AR30.4
                                                                 AR42.1  AR42.2
                                                                 AR42.7  AR43.1
                                                                 AR560   AR570
                                                                 AR575   AR580
                                                                 BRIP.1  BRPI.1
                                                                 CB10.1  CB180
                                                                 CB191   CB20.1
                                                                 CB30.1  CB500
                                                                 DT180   DT181
                                                                 EE135   EE35.1
                                                                 EE35.2  EE520
                                                                 MA41.2  MA41.7
                                                                 ...

TXD-VEND-CUST          Alpha 9  (Right Justified)                AP125   AP126
Vendor or Customer     The vendor or customer number the tax     AP170   AP180
ID                     transaction was created for.              AP181   AP190
                                                                 AP193   AP20.1
                                                                 AP20.2  AP20.3
                                                                 AP20.4  AP20.5
                                                                 AP20.7  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP30.2  AP30.4
                                                                 AP32.2  AP520
                                                                 API1.1  API2.1
                                                                 AR115   AR124
                                                                 AR190   AR20.1
                                                                 AR21.1  AR21.2
                                                                 AR21.3  AR24.1
                                                                 AR29.2  AR30.1
                                                                 AR30.2  AR30.4
                                                                 AR42.1  AR42.2
                                                                 AR42.7  AR43.1
                                                                 AR560   AR570
                                                                 AR575   AR580
                                                                 BRIP.1  BRPI.1
                                                                 CB10.1  CB180
                                                                 CB191   CB20.1
                                                                 CB30.1  CB500
                                                                 DT180   DT181
                                                                 EE135   EE35.1
                                                                 EE35.2  EE520
                                                                 MA41.2  MA41.7
                                                                 ...

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  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP30.2  AP30.4
                                                                 AP32.2  AP520
                                                                 API1.1  API2.1
                                                                 AR115   AR124
                                                                 AR190   AR20.1
                                                                 AR21.1  AR21.2
                                                                 AR21.3  AR24.1
                                                                 AR29.2  AR30.1
                                                                 AR30.2  AR30.4
                                                                 AR42.1  AR42.2
                                                                 AR42.7  AR43.1
                                                                 AR560   AR570
                                                                 AR575   AR580
                                                                 BRIP.1  BRPI.1
                                                                 CB10.1  CB180
                                                                 CB191   CB20.1
                                                                 CB30.1  CB500
                                                                 DT180   DT181
                                                                 EE135   EE35.1
                                                                 EE35.2  EE520
                                                                 MA41.2  MA41.7
                                                                 ...

TXD-PROD-TAX-CAT       Alpha 15                                  AP125   AP126
Element: Product Tax CaA product tax category lets you group     AP170   AP180
                       items to determine the tax rate by item   AP181   AP190
                       grouping.  For example, you can tax an    AP193   AP20.1
                       item grouping so that it is taxable in    AP20.2  AP20.3
                       one state but not another.                AP20.4  AP20.5
                                                                 AP20.7  AP23.1
                       You define a product tax category in      AP25.1  AP25.2
                       the Inventory Control system.             AP26.1  AP27.1
                                                                 AP30.2  AP30.4
                                                                 AP32.2  AP520
                                                                 API1.1  API2.1
                                                                 AR115   AR124
                                                                 AR190   AR20.1
                                                                 AR21.1  AR21.2
                                                                 AR21.3  AR24.1
                                                                 AR29.2  AR30.1
                                                                 AR30.2  AR30.4
                                                                 AR42.1  AR42.2
                                                                 AR42.7  AR43.1
                                                                 AR560   AR570
                                                                 AR575   AR580
                                                                 BRIP.1  BRPI.1
                                                                 CB10.1  CB180
                                                                 CB191   CB20.1
                                                                 CB30.1  CB500
                                                                 DT180   DT181
                                                                 EE135   EE35.1
                                                                 EE35.2  EE520
                                                                 MA41.2  MA41.7
                                                                 ...

TXD-INVOICE            Alpha 22                                  AP125   AP126
Element: Invoice NumberThe invoice number associated with the    AP170   AP180
                       tax transaction.                          AP181   AP190
                                                                 AP193   AP20.1
                                                                 AP20.2  AP20.3
                                                                 AP20.4  AP20.5
                                                                 AP20.7  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP30.2  AP30.4
                                                                 AP32.2  AP520
                                                                 API1.1  API2.1
                                                                 AR115   AR124
                                                                 AR190   AR20.1
                                                                 AR21.1  AR21.2
                                                                 AR21.3  AR24.1
                                                                 AR29.2  AR30.1
                                                                 AR30.2  AR30.4
                                                                 AR42.1  AR42.2
                                                                 AR42.7  AR43.1
                                                                 AR560   AR570
                                                                 AR575   AR580
                                                                 BRIP.1  BRPI.1
                                                                 CB10.1  CB180
                                                                 CB191   CB20.1
                                                                 CB30.1  CB500
                                                                 DT180   DT181
                                                                 EE135   EE35.1
                                                                 EE35.2  EE520
                                                                 MA41.2  MA41.7
                                                                 ...

TXD-SUFFIX             Numeric 3                                 AP125   AP126
Element: Invoice SuffixThe transaction suffix number             AP170   AP180
                       associated with the tax transaction.      AP181   AP190
                       This field represents the occurrence      AP193   AP20.1
                       value of the transaction.                 AP20.2  AP20.3
                                                                 AP20.4  AP20.5
                                                                 AP20.7  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP30.2  AP30.4
                                                                 AP32.2  AP520
                                                                 API1.1  API2.1
                                                                 AR115   AR124
                                                                 AR190   AR20.1
                                                                 AR21.1  AR21.2
                                                                 AR21.3  AR24.1
                                                                 AR29.2  AR30.1
                                                                 AR30.2  AR30.4
                                                                 AR42.1  AR42.2
                                                                 AR42.7  AR43.1
                                                                 AR560   AR570
                                                                 AR575   AR580
                                                                 BRIP.1  BRPI.1
                                                                 CB10.1  CB180
                                                                 CB191   CB20.1
                                                                 CB30.1  CB500
                                                                 DT180   DT181
                                                                 EE135   EE35.1
                                                                 EE35.2  EE520
                                                                 MA41.2  MA41.7
                                                                 ...

TXD-CANCEL-SEQ         Numeric 4                                 AP125   AP126
Element: Sequence NumbeA sequence number that is assigned when   AP170   AP180
                       an accounts payable distributed invoice   AP181   AP190
                       is canceled.  The first sequence          AP193   AP20.1
                       assigned is 9999.                         AP20.2  AP20.3
                                                                 AP20.4  AP20.5
                                                                 AP20.7  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP30.2  AP30.4
                                                                 AP32.2  AP520
                                                                 API1.1  API2.1
                                                                 AR115   AR124
                                                                 AR190   AR20.1
                                                                 AR21.1  AR21.2
                                                                 AR21.3  AR24.1
                                                                 AR29.2  AR30.1
                                                                 AR30.2  AR30.4
                                                                 AR42.1  AR42.2
                                                                 AR42.7  AR43.1
                                                                 AR560   AR570
                                                                 AR575   AR580
                                                                 BRIP.1  BRPI.1
                                                                 CB10.1  CB180
                                                                 CB191   CB20.1
                                                                 CB30.1  CB500
                                                                 DT180   DT181
                                                                 EE135   EE35.1
                                                                 EE35.2  EE520
                                                                 MA41.2  MA41.7
                                                                 ...

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  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP30.2  AP30.4
                                                                 AP32.2  AP520
                                                                 API1.1  API2.1
                                                                 AR115   AR124
                                                                 AR190   AR20.1
                                                                 AR21.1  AR21.2
                                                                 AR21.3  AR24.1
                                                                 AR29.2  AR30.1
                                                                 AR30.2  AR30.4
                                                                 AR42.1  AR42.2
                                                                 AR42.7  AR43.1
                                                                 AR560   AR570
                                                                 AR575   AR580
                                                                 BRIP.1  BRPI.1
                                                                 CB10.1  CB180
                                                                 CB191   CB20.1
                                                                 CB30.1  CB500
                                                                 DT180   DT181
                                                                 EE135   EE35.1
                                                                 EE35.2  EE520
                                                                 MA41.2  MA41.7
                                                                 ...

TXD-TAX-ACCT-UNIT      Alpha 15                                  AP125   AP126
Element: Accounting UniThe general ledger accounting unit        AP170   AP180
                       associated with the tax transaction. You  AP181   AP190
                       must have already defined the accounting  AP193   AP20.1
                       unit in the General Ledger system.        AP20.2  AP20.3
                                                                 AP20.4  AP20.5
                                                                 AP20.7  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP30.2  AP30.4
                                                                 AP32.2  AP520
                                                                 API1.1  API2.1
                                                                 AR115   AR124
                                                                 AR190   AR20.1
                                                                 AR21.1  AR21.2
                                                                 AR21.3  AR24.1
                                                                 AR29.2  AR30.1
                                                                 AR30.2  AR30.4
                                                                 AR42.1  AR42.2
                                                                 AR42.7  AR43.1
                                                                 AR560   AR570
                                                                 AR575   AR580
                                                                 BRIP.1  BRPI.1
                                                                 CB10.1  CB180
                                                                 CB191   CB20.1
                                                                 CB30.1  CB500
                                                                 DT180   DT181
                                                                 EE135   EE35.1
                                                                 EE35.2  EE520
                                                                 MA41.2  MA41.7
                                                                 ...

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  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP30.2  AP30.4
                                                                 AP32.2  AP520
                                                                 API1.1  API2.1
                                                                 AR115   AR124
                                                                 AR190   AR20.1
                                                                 AR21.1  AR21.2
                                                                 AR21.3  AR24.1
                                                                 AR29.2  AR30.1
                                                                 AR30.2  AR30.4
                                                                 AR42.1  AR42.2
                                                                 AR42.7  AR43.1
                                                                 AR560   AR570
                                                                 AR575   AR580
                                                                 BRIP.1  BRPI.1
                                                                 CB10.1  CB180
                                                                 CB191   CB20.1
                                                                 CB30.1  CB500
                                                                 DT180   DT181
                                                                 EE135   EE35.1
                                                                 EE35.2  EE520
                                                                 MA41.2  MA41.7
                                                                 ...

TXD-TAX-SUB-ACCT       Numeric 4                                 AP125   AP126
Element: Subaccount    The general ledger subaccount number      AP170   AP180
                       associated with the tax transaction. You  AP181   AP190
                       must have already defined the subaccount  AP193   AP20.1
                       in the General Ledger system.             AP20.2  AP20.3
                                                                 AP20.4  AP20.5
                                                                 AP20.7  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP30.2  AP30.4
                                                                 AP32.2  AP520
                                                                 API1.1  API2.1
                                                                 AR115   AR124
                                                                 AR190   AR20.1
                                                                 AR21.1  AR21.2
                                                                 AR21.3  AR24.1
                                                                 AR29.2  AR30.1
                                                                 AR30.2  AR30.4
                                                                 AR42.1  AR42.2
                                                                 AR42.7  AR43.1
                                                                 AR560   AR570
                                                                 AR575   AR580
                                                                 BRIP.1  BRPI.1
                                                                 CB10.1  CB180
                                                                 CB191   CB20.1
                                                                 CB30.1  CB500
                                                                 DT180   DT181
                                                                 EE135   EE35.1
                                                                 EE35.2  EE520
                                                                 MA41.2  MA41.7
                                                                 ...

TXD-NAME               Alpha 30  (Lower Case)                    AP125   AP126
Vendor or Customer     The name of the vendor or customer the    AP170   AP180
Name                   tax transaction was created for.          AP181   AP190
                                                                 AP193   AP20.1
                                                                 AP20.2  AP20.3
                                                                 AP20.4  AP20.5
                                                                 AP20.7  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP30.2  AP30.4
                                                                 AP32.2  AP520
                                                                 API1.1  API2.1
                                                                 AR115   AR124
                                                                 AR190   AR20.1
                                                                 AR21.1  AR21.2
                                                                 AR21.3  AR24.1
                                                                 AR29.2  AR30.1
                                                                 AR30.2  AR30.4
                                                                 AR42.1  AR42.2
                                                                 AR42.7  AR43.1
                                                                 AR560   AR570
                                                                 AR575   AR580
                                                                 BRIP.1  BRPI.1
                                                                 CB10.1  CB180
                                                                 CB191   CB20.1
                                                                 CB30.1  CB500
                                                                 DT180   DT181
                                                                 EE135   EE35.1
                                                                 EE35.2  EE520
                                                                 MA41.2  MA41.7
                                                                 ...

TXD-VOUCHER-NBR        Alpha 10                                  AP125   AP126
Element: Voucher       The voucher number associated with the    AP170   AP180
                       tax transaction.  Vouchers are used by    AP181   AP190
                       the Purchase Order system.                AP193   AP20.1
                                                                 AP20.2  AP20.3
                                                                 AP20.4  AP20.5
                                                                 AP20.7  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP30.2  AP30.4
                                                                 AP32.2  AP520
                                                                 API1.1  API2.1
                                                                 AR115   AR124
                                                                 AR190   AR20.1
                                                                 AR21.1  AR21.2
                                                                 AR21.3  AR24.1
                                                                 AR29.2  AR30.1
                                                                 AR30.2  AR30.4
                                                                 AR42.1  AR42.2
                                                                 AR42.7  AR43.1
                                                                 AR560   AR570
                                                                 AR575   AR580
                                                                 BRIP.1  BRPI.1
                                                                 CB10.1  CB180
                                                                 CB191   CB20.1
                                                                 CB30.1  CB500
                                                                 DT180   DT181
                                                                 EE135   EE35.1
                                                                 EE35.2  EE520
                                                                 MA41.2  MA41.7
                                                                 ...

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  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP30.2  AP30.4
                                                                 AP32.2  AP520
                                                                 API1.1  API2.1
                                                                 AR115   AR124
                                                                 AR190   AR20.1
                                                                 AR21.1  AR21.2
                                                                 AR21.3  AR24.1
                                                                 AR29.2  AR30.1
                                                                 AR30.2  AR30.4
                                                                 AR42.1  AR42.2
                                                                 AR42.7  AR43.1
                                                                 AR560   AR570
                                                                 AR575   AR580
                                                                 BRIP.1  BRPI.1
                                                                 CB10.1  CB180
                                                                 CB191   CB20.1
                                                                 CB30.1  CB500
                                                                 DT180   DT181
                                                                 EE135   EE35.1
                                                                 EE35.2  EE520
                                                                 MA41.2  MA41.7
                                                                 ...

TXD-INVOICE-DTE        Numeric 8  (yyyymmdd)                     AP125   AP126
Element: Date          The transaction date associated with      AP170   AP180
                       the tax transaction.                      AP181   AP190
                                                                 AP193   AP20.1
                                                                 AP20.2  AP20.3
                                                                 AP20.4  AP20.5
                                                                 AP20.7  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP30.2  AP30.4
                                                                 AP32.2  AP520
                                                                 API1.1  API2.1
                                                                 AR115   AR124
                                                                 AR190   AR20.1
                                                                 AR21.1  AR21.2
                                                                 AR21.3  AR24.1
                                                                 AR29.2  AR30.1
                                                                 AR30.2  AR30.4
                                                                 AR42.1  AR42.2
                                                                 AR42.7  AR43.1
                                                                 AR560   AR570
                                                                 AR575   AR580
                                                                 BRIP.1  BRPI.1
                                                                 CB10.1  CB180
                                                                 CB191   CB20.1
                                                                 CB30.1  CB500
                                                                 DT180   DT181
                                                                 EE135   EE35.1
                                                                 EE35.2  EE520
                                                                 MA41.2  MA41.7
                                                                 ...

TXD-POST-DATE          Numeric 8  (yyyymmdd)                     AP125   AP126
Element: Date          The general ledger posting date           AP170   AP180
                       associated with the tax transaction.      AP181   AP190
                                                                 AP193   AP20.1
                                                                 AP20.2  AP20.3
                                                                 AP20.4  AP20.5
                                                                 AP20.7  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP30.2  AP30.4
                                                                 AP32.2  AP520
                                                                 API1.1  API2.1
                                                                 AR115   AR124
                                                                 AR190   AR20.1
                                                                 AR21.1  AR21.2
                                                                 AR21.3  AR24.1
                                                                 AR29.2  AR30.1
                                                                 AR30.2  AR30.4
                                                                 AR42.1  AR42.2
                                                                 AR42.7  AR43.1
                                                                 AR560   AR570
                                                                 AR575   AR580
                                                                 BRIP.1  BRPI.1
                                                                 CB10.1  CB180
                                                                 CB191   CB20.1
                                                                 CB30.1  CB500
                                                                 DT180   DT181
                                                                 EE135   EE35.1
                                                                 EE35.2  EE520
                                                                 MA41.2  MA41.7
                                                                 ...

TXD-TRAN-CURRENCY      Alpha 5                                   AP125   AP126
To Company Base        The currency of the transaction           AP170   AP180
Currency               associated with the tax transaction. The  AP181   AP190
                       currency must be valid in the Currency    AP193   AP20.1
                       system.                                   AP20.2  AP20.3
                                                                 AP20.4  AP20.5
                                                                 AP20.7  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP30.2  AP30.4
                                                                 AP32.2  AP520
                                                                 API1.1  API2.1
                                                                 AR115   AR124
                                                                 AR190   AR20.1
                                                                 AR21.1  AR21.2
                                                                 AR21.3  AR24.1
                                                                 AR29.2  AR30.1
                                                                 AR30.2  AR30.4
                                                                 AR42.1  AR42.2
                                                                 AR42.7  AR43.1
                                                                 AR560   AR570
                                                                 AR575   AR580
                                                                 BRIP.1  BRPI.1
                                                                 CB10.1  CB180
                                                                 CB191   CB20.1
                                                                 CB30.1  CB500
                                                                 DT180   DT181
                                                                 EE135   EE35.1
                                                                 EE35.2  EE520
                                                                 MA41.2  MA41.7
                                                                 ...

TXD-TRAN-INV-AMT       Signed 15.2                               AP125   AP126
Element: Invoice AmountThe amount of the transaction in the      AP170   AP180
                       currency of the transaction.              AP181   AP190
                                                                 AP193   AP20.1
                                                                 AP20.2  AP20.3
                                                                 AP20.4  AP20.5
                                                                 AP20.7  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP30.2  AP30.4
                                                                 AP32.2  AP520
                                                                 API1.1  API2.1
                                                                 AR115   AR124
                                                                 AR190   AR20.1
                                                                 AR21.1  AR21.2
                                                                 AR21.3  AR24.1
                                                                 AR29.2  AR30.1
                                                                 AR30.2  AR30.4
                                                                 AR42.1  AR42.2
                                                                 AR42.7  AR43.1
                                                                 AR560   AR570
                                                                 AR575   AR580
                                                                 BRIP.1  BRPI.1
                                                                 CB10.1  CB180
                                                                 CB191   CB20.1
                                                                 CB30.1  CB500
                                                                 DT180   DT181
                                                                 EE135   EE35.1
                                                                 EE35.2  EE520
                                                                 MA41.2  MA41.7
                                                                 ...

TXD-TRAN-TAXABLE       Signed 15.2                               AP125   AP126
Element: Item Tax      The taxable amount of the transaction     AP170   AP180
                       in the currency of the transaction.       AP181   AP190
                                                                 AP193   AP20.1
                                                                 AP20.2  AP20.3
                                                                 AP20.4  AP20.5
                                                                 AP20.7  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP30.2  AP30.4
                                                                 AP32.2  AP520
                                                                 API1.1  API2.1
                                                                 AR115   AR124
                                                                 AR190   AR20.1
                                                                 AR21.1  AR21.2
                                                                 AR21.3  AR24.1
                                                                 AR29.2  AR30.1
                                                                 AR30.2  AR30.4
                                                                 AR42.1  AR42.2
                                                                 AR42.7  AR43.1
                                                                 AR560   AR570
                                                                 AR575   AR580
                                                                 BRIP.1  BRPI.1
                                                                 CB10.1  CB180
                                                                 CB191   CB20.1
                                                                 CB30.1  CB500
                                                                 DT180   DT181
                                                                 EE135   EE35.1
                                                                 EE35.2  EE520
                                                                 MA41.2  MA41.7
                                                                 ...

TXD-TRAN-TAX-AMT       Signed 15.2                               AP125   AP126
Element: Adj 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  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP30.2  AP30.4
                                                                 AP32.2  AP520
                                                                 API1.1  API2.1
                                                                 AR115   AR124
                                                                 AR190   AR20.1
                                                                 AR21.1  AR21.2
                                                                 AR21.3  AR24.1
                                                                 AR29.2  AR30.1
                                                                 AR30.2  AR30.4
                                                                 AR42.1  AR42.2
                                                                 AR42.7  AR43.1
                                                                 AR560   AR570
                                                                 AR575   AR580
                                                                 BRIP.1  BRPI.1
                                                                 CB10.1  CB180
                                                                 CB191   CB20.1
                                                                 CB30.1  CB500
                                                                 DT180   DT181
                                                                 EE135   EE35.1
                                                                 EE35.2  EE520
                                                                 MA41.2  MA41.7
                                                                 ...

TXD-TRAN-ND            Numeric 1                                 AP125   AP126
Account Currency       The number of decimal places defined      AP170   AP180
Code                   for the transaction currency associated   AP181   AP190
                       with the tax transaction.                 AP193   AP20.1
                                                                 AP20.2  AP20.3
                                                                 AP20.4  AP20.5
                                                                 AP20.7  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP30.2  AP30.4
                                                                 AP32.2  AP520
                                                                 API1.1  API2.1
                                                                 AR115   AR124
                                                                 AR190   AR20.1
                                                                 AR21.1  AR21.2
                                                                 AR21.3  AR24.1
                                                                 AR29.2  AR30.1
                                                                 AR30.2  AR30.4
                                                                 AR42.1  AR42.2
                                                                 AR42.7  AR43.1
                                                                 AR560   AR570
                                                                 AR575   AR580
                                                                 BRIP.1  BRPI.1
                                                                 CB10.1  CB180
                                                                 CB191   CB20.1
                                                                 CB30.1  CB500
                                                                 DT180   DT181
                                                                 EE135   EE35.1
                                                                 EE35.2  EE520
                                                                 MA41.2  MA41.7
                                                                 ...

TXD-BASE-INV-AMT       Signed 15.2                               AP125   AP126
Element: Adj 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  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP30.2  AP30.4
                                                                 AP32.2  AP520
                                                                 API1.1  API2.1
                                                                 AR115   AR124
                                                                 AR190   AR20.1
                                                                 AR21.1  AR21.2
                                                                 AR21.3  AR24.1
                                                                 AR29.2  AR30.1
                                                                 AR30.2  AR30.4
                                                                 AR42.1  AR42.2
                                                                 AR42.7  AR43.1
                                                                 AR560   AR570
                                                                 AR575   AR580
                                                                 BRIP.1  BRPI.1
                                                                 CB10.1  CB180
                                                                 CB191   CB20.1
                                                                 CB30.1  CB500
                                                                 DT180   DT181
                                                                 EE135   EE35.1
                                                                 EE35.2  EE520
                                                                 MA41.2  MA41.7
                                                                 ...

TXD-BASE-TAXABLE       Signed 15.2                               AP125   AP126
Element: Item Tax      The taxable amount of the transaction     AP170   AP180
                       in the company base currency.             AP181   AP190
                                                                 AP193   AP20.1
                                                                 AP20.2  AP20.3
                                                                 AP20.4  AP20.5
                                                                 AP20.7  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP30.2  AP30.4
                                                                 AP32.2  AP520
                                                                 API1.1  API2.1
                                                                 AR115   AR124
                                                                 AR190   AR20.1
                                                                 AR21.1  AR21.2
                                                                 AR21.3  AR24.1
                                                                 AR29.2  AR30.1
                                                                 AR30.2  AR30.4
                                                                 AR42.1  AR42.2
                                                                 AR42.7  AR43.1
                                                                 AR560   AR570
                                                                 AR575   AR580
                                                                 BRIP.1  BRPI.1
                                                                 CB10.1  CB180
                                                                 CB191   CB20.1
                                                                 CB30.1  CB500
                                                                 DT180   DT181
                                                                 EE135   EE35.1
                                                                 EE35.2  EE520
                                                                 MA41.2  MA41.7
                                                                 ...

TXD-BASE-TAX-AMT       Signed 15.2                               AP125   AP126
Element: Adj 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  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP30.2  AP30.4
                                                                 AP32.2  AP520
                                                                 API1.1  API2.1
                                                                 AR115   AR124
                                                                 AR190   AR20.1
                                                                 AR21.1  AR21.2
                                                                 AR21.3  AR24.1
                                                                 AR29.2  AR30.1
                                                                 AR30.2  AR30.4
                                                                 AR42.1  AR42.2
                                                                 AR42.7  AR43.1
                                                                 AR560   AR570
                                                                 AR575   AR580
                                                                 BRIP.1  BRPI.1
                                                                 CB10.1  CB180
                                                                 CB191   CB20.1
                                                                 CB30.1  CB500
                                                                 DT180   DT181
                                                                 EE135   EE35.1
                                                                 EE35.2  EE520
                                                                 MA41.2  MA41.7
                                                                 ...

TXD-BASE-ND            Numeric 1                                 AP125   AP126
Account Currency       The number of decimal places defined      AP170   AP180
Code                   for the company base currency.            AP181   AP190
                                                                 AP193   AP20.1
                                                                 AP20.2  AP20.3
                                                                 AP20.4  AP20.5
                                                                 AP20.7  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP30.2  AP30.4
                                                                 AP32.2  AP520
                                                                 API1.1  API2.1
                                                                 AR115   AR124
                                                                 AR190   AR20.1
                                                                 AR21.1  AR21.2
                                                                 AR21.3  AR24.1
                                                                 AR29.2  AR30.1
                                                                 AR30.2  AR30.4
                                                                 AR42.1  AR42.2
                                                                 AR42.7  AR43.1
                                                                 AR560   AR570
                                                                 AR575   AR580
                                                                 BRIP.1  BRPI.1
                                                                 CB10.1  CB180
                                                                 CB191   CB20.1
                                                                 CB30.1  CB500
                                                                 DT180   DT181
                                                                 EE135   EE35.1
                                                                 EE35.2  EE520
                                                                 MA41.2  MA41.7
                                                                 ...

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  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP30.2  AP30.4
                                                                 AP32.2  AP520
                                                                 API1.1  API2.1
                                                                 AR115   AR124
                                                                 AR190   AR20.1
                                                                 AR21.1  AR21.2
                                                                 AR21.3  AR24.1
                                                                 AR29.2  AR30.1
                                                                 AR30.2  AR30.4
                                                                 AR42.1  AR42.2
                                                                 AR42.7  AR43.1
                                                                 AR560   AR570
                                                                 AR575   AR580
                                                                 BRIP.1  BRPI.1
                                                                 CB10.1  CB180
                                                                 CB191   CB20.1
                                                                 CB30.1  CB500
                                                                 DT180   DT181
                                                                 EE135   EE35.1
                                                                 EE35.2  EE520
                                                                 MA41.2  MA41.7
                                                                 ...

TXD-ACCRUAL-FL         Alpha 1                                   AP125   AP126
Element: Accrual Flag  Accrual flags determined how tax was      AP170   AP180
                       applied to invoices, whether as invoiced  AP181   AP190
                       or accrued (noninvoiced).                 AP193   AP20.1
                       I = Invoiced                              AP20.2  AP20.3
                       A = Accrued                               AP20.4  AP20.5
                                                                 AP20.7  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP30.2  AP30.4
                                                                 AP32.2  AP520
                                                                 API1.1  API2.1
                                                                 AR115   AR124
                                                                 AR190   AR20.1
                                                                 AR21.1  AR21.2
                                                                 AR21.3  AR24.1
                                                                 AR29.2  AR30.1
                                                                 AR30.2  AR30.4
                                                                 AR42.1  AR42.2
                                                                 AR42.7  AR43.1
                                                                 AR560   AR570
                                                                 AR575   AR580
                                                                 BRIP.1  BRPI.1
                                                                 CB10.1  CB180
                                                                 CB191   CB20.1
                                                                 CB30.1  CB500
                                                                 DT180   DT181
                                                                 EE135   EE35.1
                                                                 EE35.2  EE520
                                                                 MA41.2  MA41.7
                                                                 ...

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  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP30.2  AP30.4
                                                                 AP32.2  AP520
                                                                 API1.1  API2.1
                                                                 AR115   AR124
                                                                 AR190   AR20.1
                                                                 AR21.1  AR21.2
                                                                 AR21.3  AR24.1
                                                                 AR29.2  AR30.1
                                                                 AR30.2  AR30.4
                                                                 AR42.1  AR42.2
                                                                 AR42.7  AR43.1
                                                                 AR560   AR570
                                                                 AR575   AR580
                                                                 BRIP.1  BRPI.1
                                                                 CB10.1  CB180
                                                                 CB191   CB20.1
                                                                 CB30.1  CB500
                                                                 DT180   DT181
                                                                 EE135   EE35.1
                                                                 EE35.2  EE520
                                                                 MA41.2  MA41.7
                                                                 ...

TXD-CURR-RATE          Signed 13.6                               AP125   AP126
Currency Exchange      The currency exchange rate used to        AP170   AP180
Rate                   convert a nonbase currency transaction    AP181   AP190
                       amount to the company base currency.      AP193   AP20.1
                                                                 AP20.2  AP20.3
                                                                 AP20.4  AP20.5
                                                                 AP20.7  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP30.2  AP30.4
                                                                 AP32.2  AP520
                                                                 API1.1  API2.1
                                                                 AR115   AR124
                                                                 AR190   AR20.1
                                                                 AR21.1  AR21.2
                                                                 AR21.3  AR24.1
                                                                 AR29.2  AR30.1
                                                                 AR30.2  AR30.4
                                                                 AR42.1  AR42.2
                                                                 AR42.7  AR43.1
                                                                 AR560   AR570
                                                                 AR575   AR580
                                                                 BRIP.1  BRPI.1
                                                                 CB10.1  CB180
                                                                 CB191   CB20.1
                                                                 CB30.1  CB500
                                                                 DT180   DT181
                                                                 EE135   EE35.1
                                                                 EE35.2  EE520
                                                                 MA41.2  MA41.7
                                                                 ...

TXD-STATUS             Numeric 1                                 AP125   AP126
Tax Transaction        This field indicates whether the tax      AP170   AP180
Update Status          transaction has been updated by running   AP181   AP190
                       TX100 (Tax Analysis Report).              AP193   AP20.1
                       0 = Created                               AP20.2  AP20.3
                       1 = Reported                              AP20.4  AP20.5
                                                                 AP20.7  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP30.2  AP30.4
                                                                 AP32.2  AP520
                                                                 API1.1  API2.1
                                                                 AR115   AR124
                                                                 AR190   AR20.1
                                                                 AR21.1  AR21.2
                                                                 AR21.3  AR24.1
                                                                 AR29.2  AR30.1
                                                                 AR30.2  AR30.4
                                                                 AR42.1  AR42.2
                                                                 AR42.7  AR43.1
                                                                 AR560   AR570
                                                                 AR575   AR580
                                                                 BRIP.1  BRPI.1
                                                                 CB10.1  CB180
                                                                 CB191   CB20.1
                                                                 CB30.1  CB500
                                                                 DT180   DT181
                                                                 EE135   EE35.1
                                                                 EE35.2  EE520
                                                                 MA41.2  MA41.7
                                                                 ...

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  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP30.2  AP30.4
                                                                 AP32.2  AP520
                                                                 API1.1  API2.1
                                                                 AR115   AR124
                                                                 AR190   AR20.1
                                                                 AR21.1  AR21.2
                                                                 AR21.3  AR24.1
                                                                 AR29.2  AR30.1
                                                                 AR30.2  AR30.4
                                                                 AR42.1  AR42.2
                                                                 AR42.7  AR43.1
                                                                 AR560   AR570
                                                                 AR575   AR580
                                                                 BRIP.1  BRPI.1
                                                                 CB10.1  CB180
                                                                 CB191   CB20.1
                                                                 CB30.1  CB500
                                                                 DT180   DT181
                                                                 EE135   EE35.1
                                                                 EE35.2  EE520
                                                                 MA41.2  MA41.7
                                                                 ...

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  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP30.2  AP30.4
                                                                 AP32.2  AP520
                                                                 API1.1  API2.1
                                                                 AR115   AR124
                                                                 AR190   AR20.1
                                                                 AR21.1  AR21.2
                                                                 AR21.3  AR24.1
                                                                 AR29.2  AR30.1
                                                                 AR30.2  AR30.4
                                                                 AR42.1  AR42.2
                                                                 AR42.7  AR43.1
                                                                 AR560   AR570
                                                                 AR575   AR580
                                                                 BRIP.1  BRPI.1
                                                                 CB10.1  CB180
                                                                 CB191   CB20.1
                                                                 CB30.1  CB500
                                                                 DT180   DT181
                                                                 EE135   EE35.1
                                                                 EE35.2  EE520
                                                                 MA41.2  MA41.7
                                                                 ...

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  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP30.2  AP30.4
                                                                 AP32.2  AP520
                                                                 API1.1  API2.1
                                                                 AR115   AR124
                                                                 AR190   AR20.1
                                                                 AR21.1  AR21.2
                                                                 AR21.3  AR24.1
                                                                 AR29.2  AR30.1
                                                                 AR30.2  AR30.4
                                                                 AR42.1  AR42.2
                                                                 AR42.7  AR43.1
                                                                 AR560   AR570
                                                                 AR575   AR580
                                                                 BRIP.1  BRPI.1
                                                                 CB10.1  CB180
                                                                 CB191   CB20.1
                                                                 CB30.1  CB500
                                                                 DT180   DT181
                                                                 EE135   EE35.1
                                                                 EE35.2  EE520
                                                                 MA41.2  MA41.7
                                                                 ...

TXD-TAX-USAGE-CD       Alpha 10                                  AP125   AP126
Element: Tax Usage Cd  The tax usage coe for the vendor.  This   AP170   AP180
                       filed is required if the AP Company       AP181   AP190
                       inidcates that VAT reporting required.    AP193   AP20.1
                                                                 AP20.2  AP20.3
                                                                 AP20.4  AP20.5
                                                                 AP20.7  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP30.2  AP30.4
                                                                 AP32.2  AP520
                                                                 API1.1  API2.1
                                                                 AR115   AR124
                                                                 AR190   AR20.1
                                                                 AR21.1  AR21.2
                                                                 AR21.3  AR24.1
                                                                 AR29.2  AR30.1
                                                                 AR30.2  AR30.4
                                                                 AR42.1  AR42.2
                                                                 AR42.7  AR43.1
                                                                 AR560   AR570
                                                                 AR575   AR580
                                                                 BRIP.1  BRPI.1
                                                                 CB10.1  CB180
                                                                 CB191   CB20.1
                                                                 CB30.1  CB500
                                                                 DT180   DT181
                                                                 EE135   EE35.1
                                                                 EE35.2  EE520
                                                                 MA41.2  MA41.7
                                                                 ...

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  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP30.2  AP30.4
                                                                 AP32.2  AP520
                                                                 API1.1  API2.1
                                                                 AR115   AR124
                                                                 AR190   AR20.1
                                                                 AR21.1  AR21.2
                                                                 AR21.3  AR24.1
                                                                 AR29.2  AR30.1
                                                                 AR30.2  AR30.4
                                                                 AR42.1  AR42.2
                                                                 AR42.7  AR43.1
                                                                 AR560   AR570
                                                                 AR575   AR580
                                                                 BRIP.1  BRPI.1
                                                                 CB10.1  CB180
                                                                 CB191   CB20.1
                                                                 CB30.1  CB500
                                                                 DT180   DT181
                                                                 EE135   EE35.1
                                                                 EE35.2  EE520
                                                                 MA41.2  MA41.7
                                                                 ...

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  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP30.2  AP30.4
                                                                 AP32.2  AP520
                                                                 API1.1  API2.1
                                                                 AR115   AR124
                                                                 AR190   AR20.1
                                                                 AR21.1  AR21.2
                                                                 AR21.3  AR24.1
                                                                 AR29.2  AR30.1
                                                                 AR30.2  AR30.4
                                                                 AR42.1  AR42.2
                                                                 AR42.7  AR43.1
                                                                 AR560   AR570
                                                                 AR575   AR580
                                                                 BRIP.1  BRPI.1
                                                                 CB10.1  CB180
                                                                 CB191   CB20.1
                                                                 CB30.1  CB500
                                                                 DT180   DT181
                                                                 EE135   EE35.1
                                                                 EE35.2  EE520
                                                                 MA41.2  MA41.7
                                                                 ...

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  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP30.2  AP30.4
                                                                 AP32.2  AP520
                                                                 API1.1  API2.1
                                                                 AR115   AR124
                                                                 AR190   AR20.1
                                                                 AR21.1  AR21.2
                                                                 AR21.3  AR24.1
                                                                 AR29.2  AR30.1
                                                                 AR30.2  AR30.4
                                                                 AR42.1  AR42.2
                                                                 AR42.7  AR43.1
                                                                 AR560   AR570
                                                                 AR575   AR580
                                                                 BRIP.1  BRPI.1
                                                                 CB10.1  CB180
                                                                 CB191   CB20.1
                                                                 CB30.1  CB500
                                                                 DT180   DT181
                                                                 EE135   EE35.1
                                                                 EE35.2  EE520
                                                                 MA41.2  MA41.7
                                                                 ...

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  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP30.2  AP30.4
                                                                 AP32.2  AP520
                                                                 API1.1  API2.1
                                                                 AR115   AR124
                                                                 AR190   AR20.1
                                                                 AR21.1  AR21.2
                                                                 AR21.3  AR24.1
                                                                 AR29.2  AR30.1
                                                                 AR30.2  AR30.4
                                                                 AR42.1  AR42.2
                                                                 AR42.7  AR43.1
                                                                 AR560   AR570
                                                                 AR575   AR580
                                                                 BRIP.1  BRPI.1
                                                                 CB10.1  CB180
                                                                 CB191   CB20.1
                                                                 CB30.1  CB500
                                                                 DT180   DT181
                                                                 EE135   EE35.1
                                                                 EE35.2  EE520
                                                                 MA41.2  MA41.7
                                                                 ...

TXD-PURCH-SALE-RPT     Alpha 1                                   TX125
Element: Purch Sale RptIndicates whether a VAT Purchase and
                       Sales report is required.

TXD-CANCEL-FL          Alpha 1
Element: All Flag

                         TXTAXTRAN FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

TXDSET1   COMPANY       This index is used to keep tax           AP125   AP126
          TAX-CODE      transactions unique.                     AP170   AP180
          TRANS-IDENT                                            AP181   AP190
                                                                 AP193   AP20.1
                                                                 AP20.2  AP20.3
                                                                 AP20.4  AP20.5
                                                                 AP20.7  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP30.2  AP30.4
                                                                 AP32.2  AP520
                                                                 API1.1  API2.1
                                                                 AR115   AR124
                                                                 AR190   AR20.1
                                                                 AR21.1  AR21.2
                                                                 ...

TXDSET2   COMPANY       This index is used to access tax         TX120   TX125
          TAX-CODE      transactions for a specific company and
          SYSTEM-CD     tax code.
          TAX-PNT-DATE*
          VOUCHER-NBR   KeyChange
          TRANS-IDENT

TXDSET4   COMPANY       KeyChangeDuplicates                      TX130
          TAX-YEAR
          TAX-PERIOD
          SYSTEM-CD
          TRANS-IDENT

TXDSET6   COMPANY
          INVOICE
          TAX-CODE
          PROD-TAX-CAT
          TRANS-IDENT

                         TXTAXTRAN FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Apapihist      APAPIHIST    Not Required
                            Valid When TXD-SYSTEM-CD = "AP"

                            TXD-COMPANY          -> AH1-COMPANY
                            TXD-VEND-CUST        -> AH1-VENDOR
                            TXD-INVOICE          -> AH1-INVOICE
                            TXD-SUFFIX           -> AH1-SUFFIX
                            TXD-CANCEL-SEQ       -> AH1-CANCEL-SEQ

Apcompany      APCOMPANY    Not Required

                            TXD-COMPANY          -> CPY-COMPANY

Apinvoice      APINVOICE    Not Required
                            Valid When TXD-SYSTEM-CD = "AP"

                            TXD-COMPANY          -> API-COMPANY
                            TXD-VEND-CUST        -> API-VENDOR
                            TXD-INVOICE          -> API-INVOICE
                            TXD-SUFFIX           -> API-SUFFIX
                            TXD-CANCEL-SEQ       -> API-CANCEL-SEQ

Apvendmast     APVENMAST    Required
                            When TXD-SYSTEM-CD = "AP"

                            CPY-VENDOR-GROUP     -> VEN-VENDOR-GROUP
                            TXD-VEND-CUST        -> VEN-VENDOR

Arcomp         ARCOMP       Not Required

                            TXD-COMPANY          -> ACO-COMPANY

Cucode         CUCODES      Required

                            TXD-TRAN-CURRENCY    -> CUC-CURRENCY-CODE

Custdesc       CUSTDESC     Not Required
                            Valid When TXD-INPUT-OUTPUT = I

                            ACO-CUST-GROUP       -> CUD-CUST-GROUP
                            TXD-VEND-CUST        -> CUD-CUSTOMER

Glmaster       GLMASTER     Not Required

                            TXD-COMPANY          -> GLM-COMPANY
                            TXD-TAX-ACCT-UNIT    -> GLM-ACCT-UNIT
                            TXD-TAX-ACCOUNT      -> GLM-ACCOUNT
                            TXD-TAX-SUB-ACCT     -> GLM-SUB-ACCOUNT

Glsystem       GLSYSTEM     Required

                            TXD-COMPANY          -> GLS-COMPANY

Txcodemast     TXCODEMAST   Required

                            TXD-TAX-CODE         -> TCM-TAX-CODE

Txcompany      TXCOMPANY    Required

                            TXD-COMPANY          -> TXC-COMPANY

Txtaxcode      TXTAXCODE    Required
                            When TXC-ACCT-BY-CODE = "Y"

                            TXD-COMPANY          -> TAC-COMPANY
                            TXD-TAX-CODE         -> TAC-TAX-CODE