Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

TXCOMPANY


                             TXCOMPANY FILE

                              Tax Company

The Tax Company file contains company information, as well as which tax
system the company uses.  If general ledger accounts are defined at the
company level, those accounts are included on this file.

REFERENCED BY

AP272     AP700     BL12.1    BL209     PO150     PO190
PO229     PO53.4    PO53.5    PO53.8    IN120     IN20.1
TX06.1    TX07.1    TX08.1    TX125     TX130     TX200
TX202     TX220     TX221     TX226     TX301

UPDATED BY

AM115     AM117     AM15.1    AM15.2    AM15.3    AM15.4
AM20.1    AM20.3    AM21.1    AM21.3    AM500     AM51.1
AM551     AM97.1    AP00.3    AP10.1    AP10.2    AP10.5
AP10.6    AP110     AP125     AP126     AP131     AP170
AP180     AP181     AP190     AP193     AP220     AP25.1
AP25.2    AP26.1    AP27.1    AP30.2    AP30.4    AP510
AP520     AP95.1    API1.1    API2.1    API3.1    API4.1
API5.1    AR02.1    AR08.1    AR10.1    AR115     AR124
AR15.4    AR190     AR20.1    AR21.1    AR21.2    AR21.3
AR24.1    AR29.2    AR30.1    AR34.1    AR42.1    AR42.2
AR42.7    AR43.1    AR501     AR550     AR560     AR570
AR575     AR580     ARLL.1    BL00.1    BL01.1    BL02.1
BL09.1    BL120     BL121     BL122     BL123     BL130
BL20.1    BL20.3    BL20.5    BL20.6    BL21.2    BL21.5
BL29.1    BL29.2    BL290     BL520     BL80.1    BL802
BL820     BL92.1    BR00.1    BR00.2    BR02.3    BR11.1
BR120     BR121     BR122     BR140     BR16.1    BR20.1
BR20.2    BR20.3    BR20.4    BR20.5    BR20.6    BR420
BR46.1    BR46.2    BR46.4    BR521     BRIP.1    CB03.2
CB10.1    CB10.3    CB180     CB191     CB20.1    CB30.1
CB500     CXCP.1    DT180     DT181     EE05.1    EE135
EE20.3    EE35.1    EE35.2    EE520     DR100     IC02.1
IC10.1    IC10.2    IC11.1    IC12.1    IC141     IC142
IC28.1    IC330     IC811     IC812     IC83.1    IC840
MA08.1    MA180     MA208     MA530     MA531     MA540
MA60.2    MA60.3    MA60.5    MA61.1    MA65.1    MA66.2
MA66.3    MA67.1    MA67.2    MA70.1    MA75.1    MA80.1
MAI1.1    OE10.1    OE10.2    OE10.3    OE10.4    OE10.5
OE10.6    OE10.7    OE10.8    OE11.1    OE11.4    OE11.8
OE11.9    OE110     OE111     OE112     OE113     OE114
OE116     OE129     OE13.2    OE13.3    OE13.5    OE13.6
OE14.1    OE14.2    OE14.4    OE229     OE30.1    OE30.2
OE30.3    OE30.4    OE30.5    OE30.6    OE30.7    OE30.9
OE510     OE530     OE80.1    OE80.2    OE80.3    OE80.4
OE80.5    OE81.1    OE810     OE830     OE90.1    OE90.2
PBIP.1    PO100     PO101     PO120     PO122     PO131
PO132     PO20.1    PO21.2    PO21.3    PO21.4    PO21.5
PO22.1    PO220     PO23.1    PO25.1    PO25.5    PO25.6
PO25.7    PO27.1    PO27.2    PO29.1    PO30.1    PO30.2
PO30.3    PO300     PO31.1    PO31.2    PO32.1    PO32.2
PO32.3    PO33.1    PO34.1    PO35.1    PO36.1    PO36.2
PO38.1    PO39.1    PO39.2    PO44.1    PO50.1    PO52.1
PO520     PO536     POED.1    POI3.1    POI7.1    POIE.1
POIF.1    POIG.1    POII.1    POIJ.1    POIM.1    POIT.1
PR05.1    PR05.3    PR197     PR226     PR247     PR26.1
PR47.1    UK47.1    RQ10.1    RQ10.2    RQ10.3    RQ11.1
RQ13.2    RQ35.1    RQ500     RQIB.1    RQIC.1    RQID.1
RQIF.1    RQIG.1    RQIJ.1    TX00.1    TX02.1    TX04.1
TX100     TX101     TX120     TX140     TX204     TX300
TX40.1    TX40.2    TX804     WH130     WH132     WH190
WH20.2    WH20.7    WH222     WH30.1    WH30.2    WH30.3
WH30.4    WH31.1    WH31.2    WH31.3    WH31.4    WH32.1
WH32.2    WH32.3    WH32.4    WH33.1    WH33.2    WH33.3
WH33.4    WH33.5    WH33.6    WH33.8    WH33.9    WH34.1
WH34.2    WH34.3    WH34.4    WH40.1    WH40.2    WH520
WH830     WO132     WO140

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

TXC-COMPANY            Numeric 4                                 AM115   AM117
Element: Company       This field contains the company number.   AM15.1  AM15.2
                                                                 AM15.3  AM15.4
                                                                 AM20.1  AM20.3
                                                                 AM21.1  AM21.3
                                                                 AM500   AM51.1
                                                                 AM551   AM97.1
                                                                 AP00.3  AP10.1
                                                                 AP10.2  AP10.5
                                                                 AP10.6  AP110
                                                                 AP125   AP126
                                                                 AP131   AP170
                                                                 AP180   AP181
                                                                 AP190   AP193
                                                                 AP220   AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP30.2
                                                                 AP30.4  AP510
                                                                 AP520   AP95.1
                                                                 API1.1  API2.1
                                                                 API3.1  API4.1
                                                                 API5.1  AR02.1
                                                                 AR08.1  AR10.1
                                                                 AR115   AR124
                                                                 AR15.4  AR190
                                                                 AR20.1  AR21.1
                                                                 AR21.2  AR21.3
                                                                 AR24.1  AR29.2
                                                                 AR30.1  AR34.1
                                                                 AR42.1  AR42.2
                                                                 ...

TXC-NAME               Alpha 30  (Lower Case)                    AM115   AM117
Element: Name          This field contains the company name or   AM15.1  AM15.2
                       description.                              AM15.3  AM15.4
                                                                 AM20.1  AM20.3
                                                                 AM21.1  AM21.3
                                                                 AM500   AM51.1
                                                                 AM551   AM97.1
                                                                 AP00.3  AP10.1
                                                                 AP10.2  AP10.5
                                                                 AP10.6  AP110
                                                                 AP125   AP126
                                                                 AP131   AP170
                                                                 AP180   AP181
                                                                 AP190   AP193
                                                                 AP220   AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP30.2
                                                                 AP30.4  AP510
                                                                 AP520   AP95.1
                                                                 API1.1  API2.1
                                                                 API3.1  API4.1
                                                                 API5.1  AR02.1
                                                                 AR08.1  AR10.1
                                                                 AR115   AR124
                                                                 AR15.4  AR190
                                                                 AR20.1  AR21.1
                                                                 AR21.2  AR21.3
                                                                 AR24.1  AR29.2
                                                                 AR30.1  AR34.1
                                                                 AR42.1  AR42.2
                                                                 ...

TXC-TAX-ID             Alpha 20                                  AM115   AM117
Element: Tax ID        This field contains the tax ID or         AM15.1  AM15.2
                       registration number.                      AM15.3  AM15.4
                                                                 AM20.1  AM20.3
                                                                 AM21.1  AM21.3
                                                                 AM500   AM51.1
                                                                 AM551   AM97.1
                                                                 AP00.3  AP10.1
                                                                 AP10.2  AP10.5
                                                                 AP10.6  AP110
                                                                 AP125   AP126
                                                                 AP131   AP170
                                                                 AP180   AP181
                                                                 AP190   AP193
                                                                 AP220   AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP30.2
                                                                 AP30.4  AP510
                                                                 AP520   AP95.1
                                                                 API1.1  API2.1
                                                                 API3.1  API4.1
                                                                 API5.1  AR02.1
                                                                 AR08.1  AR10.1
                                                                 AR115   AR124
                                                                 AR15.4  AR190
                                                                 AR20.1  AR21.1
                                                                 AR21.2  AR21.3
                                                                 AR24.1  AR29.2
                                                                 AR30.1  AR34.1
                                                                 AR42.1  AR42.2
                                                                 ...

TXC-THIRD-PARTY        Alpha 1                                   AM115   AM117
Element: Third Party   This field indicates which tax system     AM15.1  AM15.2
                       you are using, whether you use the Tax    AM15.3  AM15.4
                       system or a third-party tax system.       AM20.1  AM20.3
                       A = Using AVP Sales/Use Tax System        AM21.1  AM21.3
                       C = Using Vertex - City/Zip Access        AM500   AM51.1
                       G = Using Vertex - Geocode Access         AM551   AM97.1
                       S = Using Vertex - State Zip              AP00.3  AP10.1
                       Z = Using Vertex - Zip Code Access        AP10.2  AP10.5
                       Q = Using V/Quantum Geocode               AP10.6  AP110
                       R = Using V/Quantm CtyStZp or StZp        AP125   AP126
                       " " = Using Lawson Tax System             AP131   AP170
                                                                 AP180   AP181
                                                                 AP190   AP193
                                                                 AP220   AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP30.2
                                                                 AP30.4  AP510
                                                                 AP520   AP95.1
                                                                 API1.1  API2.1
                                                                 API3.1  API4.1
                                                                 API5.1  AR02.1
                                                                 AR08.1  AR10.1
                                                                 AR115   AR124
                                                                 AR15.4  AR190
                                                                 AR20.1  AR21.1
                                                                 AR21.2  AR21.3
                                                                 AR24.1  AR29.2
                                                                 AR30.1  AR34.1
                                                                 AR42.1  AR42.2
                                                                 ...

TXC-TOLERANCE-LMT      Signed 18.2                               AM115   AM117
Element: Intl Amt      This field indicates the minimum          AM15.1  AM15.2
                       taxable amount for the acceptable tax     AM15.3  AM15.4
                       rate range. The tolerance limit is valid  AM20.1  AM20.3
                       for taxable amounts greater than or       AM21.1  AM21.3
                       equal to the amount you entered.          AM500   AM51.1
                                                                 AM551   AM97.1
                                                                 AP00.3  AP10.1
                                                                 AP10.2  AP10.5
                                                                 AP10.6  AP110
                                                                 AP125   AP126
                                                                 AP131   AP170
                                                                 AP180   AP181
                                                                 AP190   AP193
                                                                 AP220   AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP30.2
                                                                 AP30.4  AP510
                                                                 AP520   AP95.1
                                                                 API1.1  API2.1
                                                                 API3.1  API4.1
                                                                 API5.1  AR02.1
                                                                 AR08.1  AR10.1
                                                                 AR115   AR124
                                                                 AR15.4  AR190
                                                                 AR20.1  AR21.1
                                                                 AR21.2  AR21.3
                                                                 AR24.1  AR29.2
                                                                 AR30.1  AR34.1
                                                                 AR42.1  AR42.2
                                                                 ...

TXC-TOLERANCE-AMT      Signed 18.2                               AM115   AM117
Element: Intl Amt      Enter a tax tolerance amount for          AM15.1  AM15.2
                       tolerance checking. Tolerance checking    AM15.3  AM15.4
                       applies to verifying a tax amount (for    AM20.1  AM20.3
                       example, the Accounts Payable system      AM21.1  AM21.3
                       would verify a sales tax amount on an     AM500   AM51.1
                       invoice that they're about to pay). If    AM551   AM97.1
                       the difference between the passed tax     AP00.3  AP10.1
                       amount exceeds the tax tolerance amount,  AP10.2  AP10.5
                       then it will result in an error.          AP10.6  AP110
                                                                 AP125   AP126
                                                                 AP131   AP170
                                                                 AP180   AP181
                                                                 AP190   AP193
                                                                 AP220   AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP30.2
                                                                 AP30.4  AP510
                                                                 AP520   AP95.1
                                                                 API1.1  API2.1
                                                                 API3.1  API4.1
                                                                 API5.1  AR02.1
                                                                 AR08.1  AR10.1
                                                                 AR115   AR124
                                                                 AR15.4  AR190
                                                                 AR20.1  AR21.1
                                                                 AR21.2  AR21.3
                                                                 AR24.1  AR29.2
                                                                 AR30.1  AR34.1
                                                                 AR42.1  AR42.2
                                                                 ...

TXC-LAST-TRANS-ID      Numeric 10                                AP125   AP126
Element: Seq Trns Nbr  This field indicates the last             AP170   AP180
                       transaction identifier that the system    AP181   AP190
                       generated.                                AP193   AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP30.2
                                                                 AP30.4  AP520
                                                                 API1.1  API2.1
                                                                 AR115   AR124
                                                                 AR190   AR20.1
                                                                 AR21.1  AR21.2
                                                                 AR21.3  AR24.1
                                                                 AR29.2  AR30.1
                                                                 AR34.1  AR42.1
                                                                 AR42.2  AR42.7
                                                                 AR43.1  AR560
                                                                 AR570   AR575
                                                                 AR580   ARLL.1
                                                                 BL120   BL122
                                                                 BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 BRIP.1  CB10.1
                                                                 CB180   CB191
                                                                 CB20.1  CB30.1
                                                                 CB500   DT180
                                                                 DT181   EE135
                                                                 EE35.1  EE35.2
                                                                 ...

TXC-FROM-RATE          Percent 7.4  (Percent)                    AM115   AM117
Element: From Rate     This field shows the lowest acceptable    AM15.1  AM15.2
                       tax rate, if you entered a tolerance      AM15.3  AM15.4
                       limit.                                    AM20.1  AM20.3
                                                                 AM21.1  AM21.3
                                                                 AM500   AM51.1
                                                                 AM551   AM97.1
                                                                 AP00.3  AP10.1
                                                                 AP10.2  AP10.5
                                                                 AP10.6  AP110
                                                                 AP125   AP126
                                                                 AP131   AP170
                                                                 AP180   AP181
                                                                 AP190   AP193
                                                                 AP220   AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP30.2
                                                                 AP30.4  AP510
                                                                 AP520   AP95.1
                                                                 API1.1  API2.1
                                                                 API3.1  API4.1
                                                                 API5.1  AR02.1
                                                                 AR08.1  AR10.1
                                                                 AR115   AR124
                                                                 AR15.4  AR190
                                                                 AR20.1  AR21.1
                                                                 AR21.2  AR21.3
                                                                 AR24.1  AR29.2
                                                                 AR30.1  AR34.1
                                                                 AR42.1  AR42.2
                                                                 ...

TXC-THRU-RATE          Percent 7.4  (Percent)                    AM115   AM117
Element: From Rate     This field shows the highest acceptable   AM15.1  AM15.2
                       tax rate if you entered a tolerance       AM15.3  AM15.4
                       limit.                                    AM20.1  AM20.3
                                                                 AM21.1  AM21.3
                                                                 AM500   AM51.1
                                                                 AM551   AM97.1
                                                                 AP00.3  AP10.1
                                                                 AP10.2  AP10.5
                                                                 AP10.6  AP110
                                                                 AP125   AP126
                                                                 AP131   AP170
                                                                 AP180   AP181
                                                                 AP190   AP193
                                                                 AP220   AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP30.2
                                                                 AP30.4  AP510
                                                                 AP520   AP95.1
                                                                 API1.1  API2.1
                                                                 API3.1  API4.1
                                                                 API5.1  AR02.1
                                                                 AR08.1  AR10.1
                                                                 AR115   AR124
                                                                 AR15.4  AR190
                                                                 AR20.1  AR21.1
                                                                 AR21.2  AR21.3
                                                                 AR24.1  AR29.2
                                                                 AR30.1  AR34.1
                                                                 AR42.1  AR42.2
                                                                 ...

TXC-ACCT-BY-CODE       Alpha 1                                   AM115   AM117
Element: All Flag      This field indicates whether general      AM15.1  AM15.2
                       ledger accounts are defined at the        AM15.3  AM15.4
                       company level or at the tax code level.   AM20.1  AM20.3
                       Select Yes to indicate that general       AM21.1  AM21.3
                       ledger accounts are defined at the tax    AM500   AM51.1
                       code level.  Select No to indicate that   AM551   AM97.1
                       general ledger accounts are defined at    AP00.3  AP10.1
                       the company level.                        AP10.2  AP10.5
                       Y = Yes                                   AP10.6  AP110
                       N = No                                    AP125   AP126
                                                                 AP131   AP170
                                                                 AP180   AP181
                                                                 AP190   AP193
                                                                 AP220   AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP30.2
                                                                 AP30.4  AP510
                                                                 AP520   AP95.1
                                                                 API1.1  API2.1
                                                                 API3.1  API4.1
                                                                 API5.1  AR02.1
                                                                 AR08.1  AR10.1
                                                                 AR115   AR124
                                                                 AR15.4  AR190
                                                                 AR20.1  AR21.1
                                                                 AR21.2  AR21.3
                                                                 AR24.1  AR29.2
                                                                 AR30.1  AR34.1
                                                                 AR42.1  AR42.2
                                                                 ...

TXC-TAX-POINT          Alpha 1                                   AM115   AM117
Element: Tax Point     This field indicates the date at which    AM15.1  AM15.2
                       you want the system to calculate sales    AM15.3  AM15.4
                       tax.  If you select Invoice Date, tax is  AM20.1  AM20.3
                       calculated when you release an invoice    AM21.1  AM21.3
                       in the Billing system.                    AM500   AM51.1
                                                                 AM551   AM97.1
                       If you select Shipping Date, it is        AP00.3  AP10.1
                       calculated when you perform shipping      AP10.2  AP10.5
                       feedback in the Warehouse system.         AP10.6  AP110
                                                                 AP125   AP126
                       If you select Payment Date, tax is        AP131   AP170
                       calculated at the date of payment.        AP180   AP181
                       I = Invoice Date                          AP190   AP193
                       S = Shipping Date                         AP220   AP25.1
                       P = Payment Date                          AP25.2  AP26.1
                       G = GL Date                               AP27.1  AP30.2
                                                                 AP30.4  AP510
                                                                 AP520   AP95.1
                                                                 API1.1  API2.1
                                                                 API3.1  API4.1
                                                                 API5.1  AR02.1
                                                                 AR08.1  AR10.1
                                                                 AR115   AR124
                                                                 AR15.4  AR190
                                                                 AR20.1  AR21.1
                                                                 AR21.2  AR21.3
                                                                 AR24.1  AR29.2
                                                                 AR30.1  AR34.1
                                                                 AR42.1  AR42.2
                                                                 ...

TXC-ACCR-CODE          Alpha 4                                   AM115   AM117
Accounts Receivable    A user-defined code representing an       AM15.1  AM15.2
Code                   accounts payable accrual account.         AM15.3  AM15.4
                                                                 AM20.1  AM20.3
                                                                 AM21.1  AM21.3
                                                                 AM500   AM51.1
                                                                 AM551   AM97.1
                                                                 AP00.3  AP10.1
                                                                 AP10.2  AP10.5
                                                                 AP10.6  AP110
                                                                 AP125   AP126
                                                                 AP131   AP170
                                                                 AP180   AP181
                                                                 AP190   AP193
                                                                 AP220   AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP30.2
                                                                 AP30.4  AP510
                                                                 AP520   AP95.1
                                                                 API1.1  API2.1
                                                                 API3.1  API4.1
                                                                 API5.1  AR02.1
                                                                 AR08.1  AR10.1
                                                                 AR115   AR124
                                                                 AR15.4  AR190
                                                                 AR20.1  AR21.1
                                                                 AR21.2  AR21.3
                                                                 AR24.1  AR29.2
                                                                 AR30.1  AR34.1
                                                                 AR42.1  AR42.2
                                                                 ...

TXC-ACCRUAL-FL         Alpha 1                                   AM115   AM117
Element: Accrual Flag  This field indicates how the tax code     AM15.1  AM15.2
                       will affect a taxable transaction.        AM15.3  AM15.4
                       Invoiced taxes increase the transaction   AM20.1  AM20.3
                       amount and accrued (noninvoiced) taxes    AM21.1  AM21.3
                       do not affect the transaction amount.     AM500   AM51.1
                       I = Invoiced                              AM551   AM97.1
                       A = Accrued                               AP00.3  AP10.1
                                                                 AP10.2  AP10.5
                                                                 AP10.6  AP110
                                                                 AP125   AP126
                                                                 AP131   AP170
                                                                 AP180   AP181
                                                                 AP190   AP193
                                                                 AP220   AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP30.2
                                                                 AP30.4  AP510
                                                                 AP520   AP95.1
                                                                 API1.1  API2.1
                                                                 API3.1  API4.1
                                                                 API5.1  AR02.1
                                                                 AR08.1  AR10.1
                                                                 AR115   AR124
                                                                 AR15.4  AR190
                                                                 AR20.1  AR21.1
                                                                 AR21.2  AR21.3
                                                                 AR24.1  AR29.2
                                                                 AR30.1  AR34.1
                                                                 AR42.1  AR42.2
                                                                 ...

TXC-ALLOW-CHANGE       Alpha 1                                   AM115   AM117
Element: All Flag      This field indicates whether or not you   AM15.1  AM15.2
                       can override the default general ledger   AM15.3  AM15.4
                       accounts at tax calculation time.         AM20.1  AM20.3
                       Y = Yes                                   AM21.1  AM21.3
                       N = No                                    AM500   AM51.1
                                                                 AM551   AM97.1
                                                                 AP00.3  AP10.1
                                                                 AP10.2  AP10.5
                                                                 AP10.6  AP110
                                                                 AP125   AP126
                                                                 AP131   AP170
                                                                 AP180   AP181
                                                                 AP190   AP193
                                                                 AP220   AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP30.2
                                                                 AP30.4  AP510
                                                                 AP520   AP95.1
                                                                 API1.1  API2.1
                                                                 API3.1  API4.1
                                                                 API5.1  AR02.1
                                                                 AR08.1  AR10.1
                                                                 AR115   AR124
                                                                 AR15.4  AR190
                                                                 AR20.1  AR21.1
                                                                 AR21.2  AR21.3
                                                                 AR24.1  AR29.2
                                                                 AR30.1  AR34.1
                                                                 AR42.1  AR42.2
                                                                 ...

TXC-LAND-COST-FLG      Alpha 1                                   AM115   AM117
Element: All Flag      This field is used with the Purchase      AM15.1  AM15.2
                       Order and Inventory Control systems.      AM15.3  AM15.4
                       Select Yes to indicate that the tax on    AM20.1  AM20.3
                       an item is included in the item's cost    AM21.1  AM21.3
                       (landed).                                 AM500   AM51.1
                       Y = Yes                                   AM551   AM97.1
                       N = No                                    AP00.3  AP10.1
                                                                 AP10.2  AP10.5
                                                                 AP10.6  AP110
                                                                 AP125   AP126
                                                                 AP131   AP170
                                                                 AP180   AP181
                                                                 AP190   AP193
                                                                 AP220   AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP30.2
                                                                 AP30.4  AP510
                                                                 AP520   AP95.1
                                                                 API1.1  API2.1
                                                                 API3.1  API4.1
                                                                 API5.1  AR02.1
                                                                 AR08.1  AR10.1
                                                                 AR115   AR124
                                                                 AR15.4  AR190
                                                                 AR20.1  AR21.1
                                                                 AR21.2  AR21.3
                                                                 AR24.1  AR29.2
                                                                 AR30.1  AR34.1
                                                                 AR42.1  AR42.2
                                                                 ...

TXC-TAX-TERMS          Alpha 1                                   AM115   AM117
Element: Tax Terms     This field indicates whether tax is       AM15.1  AM15.2
                       calculated before or after payment terms  AM15.3  AM15.4
                       are applied.  You define terms in the     AM20.1  AM20.3
                       Terms system.                             AM21.1  AM21.3
                       B = Tax Before Terms                      AM500   AM51.1
                       A = Tax After Terms                       AM551   AM97.1
                                                                 AP00.3  AP10.1
                                                                 AP10.2  AP10.5
                                                                 AP10.6  AP110
                                                                 AP125   AP126
                                                                 AP131   AP170
                                                                 AP180   AP181
                                                                 AP190   AP193
                                                                 AP220   AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP30.2
                                                                 AP30.4  AP510
                                                                 AP520   AP95.1
                                                                 API1.1  API2.1
                                                                 API3.1  API4.1
                                                                 API5.1  AR02.1
                                                                 AR08.1  AR10.1
                                                                 AR115   AR124
                                                                 AR15.4  AR190
                                                                 AR20.1  AR21.1
                                                                 AR21.2  AR21.3
                                                                 AR24.1  AR29.2
                                                                 AR30.1  AR34.1
                                                                 AR42.1  AR42.2
                                                                 ...

TXC-INP-ACCT-UNIT      Alpha 15                                  AM115   AM117
Element: Accounting UniThe general ledger accounting unit used   AM15.1  AM15.2
                       for input taxes.  Input taxes are paid    AM15.3  AM15.4
                       by the company through the Accounts       AM20.1  AM20.3
                       Payable system.                           AM21.1  AM21.3
                                                                 AM500   AM51.1
                                                                 AM551   AM97.1
                                                                 AP00.3  AP10.1
                                                                 AP10.2  AP10.5
                                                                 AP10.6  AP110
                                                                 AP125   AP126
                                                                 AP131   AP170
                                                                 AP180   AP181
                                                                 AP190   AP193
                                                                 AP220   AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP30.2
                                                                 AP30.4  AP510
                                                                 AP520   AP95.1
                                                                 API1.1  API2.1
                                                                 API3.1  API4.1
                                                                 API5.1  AR02.1
                                                                 AR08.1  AR10.1
                                                                 AR115   AR124
                                                                 AR15.4  AR190
                                                                 AR20.1  AR21.1
                                                                 AR21.2  AR21.3
                                                                 AR24.1  AR29.2
                                                                 AR30.1  AR34.1
                                                                 AR42.1  AR42.2
                                                                 ...

TXC-INP-ACCOUNT        Numeric 6                                 AM115   AM117
Element: Account       The general ledger account used for       AM15.1  AM15.2
                       input taxes.  Input taxes are paid by     AM15.3  AM15.4
                       the company through the Accounts Payable  AM20.1  AM20.3
                       system.                                   AM21.1  AM21.3
                                                                 AM500   AM51.1
                                                                 AM551   AM97.1
                                                                 AP00.3  AP10.1
                                                                 AP10.2  AP10.5
                                                                 AP10.6  AP110
                                                                 AP125   AP126
                                                                 AP131   AP170
                                                                 AP180   AP181
                                                                 AP190   AP193
                                                                 AP220   AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP30.2
                                                                 AP30.4  AP510
                                                                 AP520   AP95.1
                                                                 API1.1  API2.1
                                                                 API3.1  API4.1
                                                                 API5.1  AR02.1
                                                                 AR08.1  AR10.1
                                                                 AR115   AR124
                                                                 AR15.4  AR190
                                                                 AR20.1  AR21.1
                                                                 AR21.2  AR21.3
                                                                 AR24.1  AR29.2
                                                                 AR30.1  AR34.1
                                                                 AR42.1  AR42.2
                                                                 ...

TXC-INP-SUB-ACCT       Numeric 4                                 AM115   AM117
Element: Subaccount    The general ledger subaccount used for    AM15.1  AM15.2
                       input taxes.  Input taxes are paid for    AM15.3  AM15.4
                       by the company through the Accounts       AM20.1  AM20.3
                       Payable system.                           AM21.1  AM21.3
                                                                 AM500   AM51.1
                                                                 AM551   AM97.1
                                                                 AP00.3  AP10.1
                                                                 AP10.2  AP10.5
                                                                 AP10.6  AP110
                                                                 AP125   AP126
                                                                 AP131   AP170
                                                                 AP180   AP181
                                                                 AP190   AP193
                                                                 AP220   AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP30.2
                                                                 AP30.4  AP510
                                                                 AP520   AP95.1
                                                                 API1.1  API2.1
                                                                 API3.1  API4.1
                                                                 API5.1  AR02.1
                                                                 AR08.1  AR10.1
                                                                 AR115   AR124
                                                                 AR15.4  AR190
                                                                 AR20.1  AR21.1
                                                                 AR21.2  AR21.3
                                                                 AR24.1  AR29.2
                                                                 AR30.1  AR34.1
                                                                 AR42.1  AR42.2
                                                                 ...

TXC-INPDU-ACT-UNIT     Alpha 15                                  AM115   AM117
Element: Accounting UniThe general ledger accounting unit for    AM15.1  AM15.2
                       the input due account.  This account is   AM15.3  AM15.4
                       a temporary account to post the tax       AM20.1  AM20.3
                       amount to when invoicing and the tax      AM21.1  AM21.3
                       point date is set to payment date. When   AM500   AM51.1
                       the company actually pays the vendor,     AM551   AM97.1
                       the tax posting is moved from this        AP00.3  AP10.1
                       account to the input accounting unit.     AP10.2  AP10.5
                                                                 AP10.6  AP110
                                                                 AP125   AP126
                                                                 AP131   AP170
                                                                 AP180   AP181
                                                                 AP190   AP193
                                                                 AP220   AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP30.2
                                                                 AP30.4  AP510
                                                                 AP520   AP95.1
                                                                 API1.1  API2.1
                                                                 API3.1  API4.1
                                                                 API5.1  AR02.1
                                                                 AR08.1  AR10.1
                                                                 AR115   AR124
                                                                 AR15.4  AR190
                                                                 AR20.1  AR21.1
                                                                 AR21.2  AR21.3
                                                                 AR24.1  AR29.2
                                                                 AR30.1  AR34.1
                                                                 AR42.1  AR42.2
                                                                 ...

TXC-INPDU-ACCOUNT      Numeric 6                                 AM115   AM117
Element: Account       The general ledger account for the        AM15.1  AM15.2
                       input due account.  This account is a     AM15.3  AM15.4
                       temporary account to post the tax amount  AM20.1  AM20.3
                       to when invoicing and the tax point date  AM21.1  AM21.3
                       is set to payment date. When the company  AM500   AM51.1
                       actually pays the vendor, the tax         AM551   AM97.1
                       posting is moved from this account to     AP00.3  AP10.1
                       the input account.                        AP10.2  AP10.5
                                                                 AP10.6  AP110
                                                                 AP125   AP126
                                                                 AP131   AP170
                                                                 AP180   AP181
                                                                 AP190   AP193
                                                                 AP220   AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP30.2
                                                                 AP30.4  AP510
                                                                 AP520   AP95.1
                                                                 API1.1  API2.1
                                                                 API3.1  API4.1
                                                                 API5.1  AR02.1
                                                                 AR08.1  AR10.1
                                                                 AR115   AR124
                                                                 AR15.4  AR190
                                                                 AR20.1  AR21.1
                                                                 AR21.2  AR21.3
                                                                 AR24.1  AR29.2
                                                                 AR30.1  AR34.1
                                                                 AR42.1  AR42.2
                                                                 ...

TXC-INPDU-SUB-ACCT     Numeric 4                                 AM115   AM117
Element: Subaccount    The general ledger subaccount for the     AM15.1  AM15.2
                       input due account.  This account is a     AM15.3  AM15.4
                       temporary account to post the tax amount  AM20.1  AM20.3
                       to when invoicing and the tax point date  AM21.1  AM21.3
                       is set to payment date. When the company  AM500   AM51.1
                       actually pays the vendor, the tax         AM551   AM97.1
                       posting is moved from this account to     AP00.3  AP10.1
                       the input subaccount.                     AP10.2  AP10.5
                                                                 AP10.6  AP110
                                                                 AP125   AP126
                                                                 AP131   AP170
                                                                 AP180   AP181
                                                                 AP190   AP193
                                                                 AP220   AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP30.2
                                                                 AP30.4  AP510
                                                                 AP520   AP95.1
                                                                 API1.1  API2.1
                                                                 API3.1  API4.1
                                                                 API5.1  AR02.1
                                                                 AR08.1  AR10.1
                                                                 AR115   AR124
                                                                 AR15.4  AR190
                                                                 AR20.1  AR21.1
                                                                 AR21.2  AR21.3
                                                                 AR24.1  AR29.2
                                                                 AR30.1  AR34.1
                                                                 AR42.1  AR42.2
                                                                 ...

TXC-OUT-ACCT-UNIT      Alpha 15                                  AM115   AM117
Element: Accounting UniThe general ledger accounting unit used   AM15.1  AM15.2
                       for output taxes.  Output taxes are       AM15.3  AM15.4
                       collected by the company through the      AM20.1  AM20.3
                       Accounts Receivable system.               AM21.1  AM21.3
                                                                 AM500   AM51.1
                                                                 AM551   AM97.1
                                                                 AP00.3  AP10.1
                                                                 AP10.2  AP10.5
                                                                 AP10.6  AP110
                                                                 AP125   AP126
                                                                 AP131   AP170
                                                                 AP180   AP181
                                                                 AP190   AP193
                                                                 AP220   AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP30.2
                                                                 AP30.4  AP510
                                                                 AP520   AP95.1
                                                                 API1.1  API2.1
                                                                 API3.1  API4.1
                                                                 API5.1  AR02.1
                                                                 AR08.1  AR10.1
                                                                 AR115   AR124
                                                                 AR15.4  AR190
                                                                 AR20.1  AR21.1
                                                                 AR21.2  AR21.3
                                                                 AR24.1  AR29.2
                                                                 AR30.1  AR34.1
                                                                 AR42.1  AR42.2
                                                                 ...

TXC-OUT-ACCOUNT        Numeric 6                                 AM115   AM117
Element: Account       The general ledger account used for       AM15.1  AM15.2
                       output taxes.  Output taxes are           AM15.3  AM15.4
                       collected by the company through the      AM20.1  AM20.3
                       Accounts Receivable system.               AM21.1  AM21.3
                                                                 AM500   AM51.1
                                                                 AM551   AM97.1
                                                                 AP00.3  AP10.1
                                                                 AP10.2  AP10.5
                                                                 AP10.6  AP110
                                                                 AP125   AP126
                                                                 AP131   AP170
                                                                 AP180   AP181
                                                                 AP190   AP193
                                                                 AP220   AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP30.2
                                                                 AP30.4  AP510
                                                                 AP520   AP95.1
                                                                 API1.1  API2.1
                                                                 API3.1  API4.1
                                                                 API5.1  AR02.1
                                                                 AR08.1  AR10.1
                                                                 AR115   AR124
                                                                 AR15.4  AR190
                                                                 AR20.1  AR21.1
                                                                 AR21.2  AR21.3
                                                                 AR24.1  AR29.2
                                                                 AR30.1  AR34.1
                                                                 AR42.1  AR42.2
                                                                 ...

TXC-OUT-SUB-ACCT       Numeric 4                                 AM115   AM117
Element: Subaccount    The general ledger subaccount used for    AM15.1  AM15.2
                       output taxes.  Output taxes are           AM15.3  AM15.4
                       collected by the company through the      AM20.1  AM20.3
                       Accounts Receivable system.               AM21.1  AM21.3
                                                                 AM500   AM51.1
                                                                 AM551   AM97.1
                                                                 AP00.3  AP10.1
                                                                 AP10.2  AP10.5
                                                                 AP10.6  AP110
                                                                 AP125   AP126
                                                                 AP131   AP170
                                                                 AP180   AP181
                                                                 AP190   AP193
                                                                 AP220   AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP30.2
                                                                 AP30.4  AP510
                                                                 AP520   AP95.1
                                                                 API1.1  API2.1
                                                                 API3.1  API4.1
                                                                 API5.1  AR02.1
                                                                 AR08.1  AR10.1
                                                                 AR115   AR124
                                                                 AR15.4  AR190
                                                                 AR20.1  AR21.1
                                                                 AR21.2  AR21.3
                                                                 AR24.1  AR29.2
                                                                 AR30.1  AR34.1
                                                                 AR42.1  AR42.2
                                                                 ...

TXC-OUTDU-ACT-UNIT     Alpha 15                                  AM115   AM117
Element: Accounting UniThe general ledger accounting unit for    AM15.1  AM15.2
                       output due taxes.  This account is a      AM15.3  AM15.4
                       temporary account to post the tax amount  AM20.1  AM20.3
                       to when invoicing and the tax point date  AM21.1  AM21.3
                       is set to payment date. When the          AM500   AM51.1
                       customer actually pays the invoice, the   AM551   AM97.1
                       tax posting is moved from this account    AP00.3  AP10.1
                       to the output accounting unit.            AP10.2  AP10.5
                                                                 AP10.6  AP110
                                                                 AP125   AP126
                                                                 AP131   AP170
                                                                 AP180   AP181
                                                                 AP190   AP193
                                                                 AP220   AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP30.2
                                                                 AP30.4  AP510
                                                                 AP520   AP95.1
                                                                 API1.1  API2.1
                                                                 API3.1  API4.1
                                                                 API5.1  AR02.1
                                                                 AR08.1  AR10.1
                                                                 AR115   AR124
                                                                 AR15.4  AR190
                                                                 AR20.1  AR21.1
                                                                 AR21.2  AR21.3
                                                                 AR24.1  AR29.2
                                                                 AR30.1  AR34.1
                                                                 AR42.1  AR42.2
                                                                 ...

TXC-OUTDU-ACCOUNT      Numeric 6                                 AM115   AM117
Element: Account       The general ledger account for the        AM15.1  AM15.2
                       output due account.  This account is a    AM15.3  AM15.4
                       temporary account to post the tax amount  AM20.1  AM20.3
                       to when invoicing and the tax point date  AM21.1  AM21.3
                       is set to payment date. When the          AM500   AM51.1
                       customer actually pays the invoice, the   AM551   AM97.1
                       tax posting is moved from this account    AP00.3  AP10.1
                       to the output account.                    AP10.2  AP10.5
                                                                 AP10.6  AP110
                                                                 AP125   AP126
                                                                 AP131   AP170
                                                                 AP180   AP181
                                                                 AP190   AP193
                                                                 AP220   AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP30.2
                                                                 AP30.4  AP510
                                                                 AP520   AP95.1
                                                                 API1.1  API2.1
                                                                 API3.1  API4.1
                                                                 API5.1  AR02.1
                                                                 AR08.1  AR10.1
                                                                 AR115   AR124
                                                                 AR15.4  AR190
                                                                 AR20.1  AR21.1
                                                                 AR21.2  AR21.3
                                                                 AR24.1  AR29.2
                                                                 AR30.1  AR34.1
                                                                 AR42.1  AR42.2
                                                                 ...

TXC-OUTDU-SUB-ACCT     Numeric 4                                 AM115   AM117
Element: Subaccount    The general ledger subaccount for the     AM15.1  AM15.2
                       output due account.  This account is a    AM15.3  AM15.4
                       temporary account to post the tax amount  AM20.1  AM20.3
                       to when invoicing and the tax point date  AM21.1  AM21.3
                       is set to payment date. When the          AM500   AM51.1
                       customer actually pays the invoice, the   AM551   AM97.1
                       tax posting is moved from this account    AP00.3  AP10.1
                       to the output subaccount.                 AP10.2  AP10.5
                                                                 AP10.6  AP110
                                                                 AP125   AP126
                                                                 AP131   AP170
                                                                 AP180   AP181
                                                                 AP190   AP193
                                                                 AP220   AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP30.2
                                                                 AP30.4  AP510
                                                                 AP520   AP95.1
                                                                 API1.1  API2.1
                                                                 API3.1  API4.1
                                                                 API5.1  AR02.1
                                                                 AR08.1  AR10.1
                                                                 AR115   AR124
                                                                 AR15.4  AR190
                                                                 AR20.1  AR21.1
                                                                 AR21.2  AR21.3
                                                                 AR24.1  AR29.2
                                                                 AR30.1  AR34.1
                                                                 AR42.1  AR42.2
                                                                 ...

TXC-NBR-PERIODS        Numeric 2
Element: Number of PeriThe Number of Periods field contains
                       the number of periods that are included
                       when the outline is built. This field
                       can contain up to two numeric values.


TXC-INTRASTAT-IND      Alpha 1                                   AM115   AM117
Element: Intrastat Ind Determines whether the company is         AM15.1  AM15.2
                       subject to Intrastat reporting.           AM15.3  AM15.4
                                                                 AM20.1  AM20.3
                                                                 AM21.1  AM21.3
                                                                 AM500   AM51.1
                                                                 AM551   AM97.1
                                                                 AP00.3  AP10.1
                                                                 AP10.2  AP10.5
                                                                 AP10.6  AP110
                                                                 AP125   AP126
                                                                 AP131   AP170
                                                                 AP180   AP181
                                                                 AP190   AP193
                                                                 AP220   AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP30.2
                                                                 AP30.4  AP510
                                                                 AP520   AP95.1
                                                                 API1.1  API2.1
                                                                 API3.1  API4.1
                                                                 API5.1  AR02.1
                                                                 AR08.1  AR10.1
                                                                 AR115   AR124
                                                                 AR15.4  AR190
                                                                 AR20.1  AR21.1
                                                                 AR21.2  AR21.3
                                                                 AR24.1  AR29.2
                                                                 AR30.1  AR34.1
                                                                 AR42.1  AR42.2
                                                                 ...

TXC-VAT-REG-CTRY       Alpha 2                                   AM115   AM117
Element: Vat Reg Ctry  The country component of the VAT          AM15.1  AM15.2
                       Registration Number. This field,          AM15.3  AM15.4
                       together with the Registration Number     AM20.1  AM20.3
                       for the company on the tax transaction.   AM21.1  AM21.3
                                                                 AM500   AM51.1
                                                                 AM551   AM97.1
                                                                 AP00.3  AP10.1
                                                                 AP10.2  AP10.5
                                                                 AP10.6  AP110
                                                                 AP125   AP126
                                                                 AP131   AP170
                                                                 AP180   AP181
                                                                 AP190   AP193
                                                                 AP220   AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP30.2
                                                                 AP30.4  AP510
                                                                 AP520   AP95.1
                                                                 API1.1  API2.1
                                                                 API3.1  API4.1
                                                                 API5.1  AR02.1
                                                                 AR08.1  AR10.1
                                                                 AR115   AR124
                                                                 AR15.4  AR190
                                                                 AR20.1  AR21.1
                                                                 AR21.2  AR21.3
                                                                 AR24.1  AR29.2
                                                                 AR30.1  AR34.1
                                                                 AR42.1  AR42.2
                                                                 ...

TXC-VAT-REG-NBR        Alpha 12                                  AM115   AM117
Element: Vat Reg Nbr   The number component of the VAT           AM15.1  AM15.2
                       Registration Number. This field together  AM15.3  AM15.4
                       with the Registration Country field make  AM20.1  AM20.3
                       up the VAT Registration Number.           AM21.1  AM21.3
                                                                 AM500   AM51.1
                                                                 AM551   AM97.1
                                                                 AP00.3  AP10.1
                                                                 AP10.2  AP10.5
                                                                 AP10.6  AP110
                                                                 AP125   AP126
                                                                 AP131   AP170
                                                                 AP180   AP181
                                                                 AP190   AP193
                                                                 AP220   AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP30.2
                                                                 AP30.4  AP510
                                                                 AP520   AP95.1
                                                                 API1.1  API2.1
                                                                 API3.1  API4.1
                                                                 API5.1  AR02.1
                                                                 AR08.1  AR10.1
                                                                 AR115   AR124
                                                                 AR15.4  AR190
                                                                 AR20.1  AR21.1
                                                                 AR21.2  AR21.3
                                                                 AR24.1  AR29.2
                                                                 AR30.1  AR34.1
                                                                 AR42.1  AR42.2
                                                                 ...

TXC-VAT-NBR            Derived
Element: Vat Nbr       The concatenation of the VAT-REG-CTRY
                       and VAT-REG-NBR fields, used as VAT
                       reporting ID.


TXC-BRANCH-ID          Alpha 3                                   AM115   AM117
Element: Branch Id     The company's branch ID, if required      AM15.1  AM15.2
                       for Intrastate reporting.                 AM15.3  AM15.4
                                                                 AM20.1  AM20.3
                                                                 AM21.1  AM21.3
                                                                 AM500   AM51.1
                                                                 AM551   AM97.1
                                                                 AP00.3  AP10.1
                                                                 AP10.2  AP10.5
                                                                 AP10.6  AP110
                                                                 AP125   AP126
                                                                 AP131   AP170
                                                                 AP180   AP181
                                                                 AP190   AP193
                                                                 AP220   AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP30.2
                                                                 AP30.4  AP510
                                                                 AP520   AP95.1
                                                                 API1.1  API2.1
                                                                 API3.1  API4.1
                                                                 API5.1  AR02.1
                                                                 AR08.1  AR10.1
                                                                 AR115   AR124
                                                                 AR15.4  AR190
                                                                 AR20.1  AR21.1
                                                                 AR21.2  AR21.3
                                                                 AR24.1  AR29.2
                                                                 AR30.1  AR34.1
                                                                 AR42.1  AR42.2
                                                                 ...

TXC-TAXABLE-CNTR       Alpha 1                                   AM115   AM117
Element: Taxable Cntr  This field indicates whether the taxable  AM15.1  AM15.2
                       amount edit is turned on or off.  If      AM15.3  AM15.4
                       turned on, the taxable amount sum of the  AM20.1  AM20.3
                       invoice lines must equal the total        AM21.1  AM21.3
                       taxable amount on the AP invoice.         AM500   AM51.1
                       N = No (Default)                          AM551   AM97.1
                       Y = Yes                                   AP00.3  AP10.1
                                                                 AP10.2  AP10.5
                                                                 AP10.6  AP110
                                                                 AP125   AP126
                                                                 AP131   AP170
                                                                 AP180   AP181
                                                                 AP190   AP193
                                                                 AP220   AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP30.2
                                                                 AP30.4  AP510
                                                                 AP520   AP95.1
                                                                 API1.1  API2.1
                                                                 API3.1  API4.1
                                                                 API5.1  AR02.1
                                                                 AR08.1  AR10.1
                                                                 AR115   AR124
                                                                 AR15.4  AR190
                                                                 AR20.1  AR21.1
                                                                 AR21.2  AR21.3
                                                                 AR24.1  AR29.2
                                                                 AR30.1  AR34.1
                                                                 AR42.1  AR42.2
                                                                 ...

                         TXCOMPANY FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

TXCSET1   COMPANY       This index is used to access and update  AM115   AM117
                        tax company records.                     AM15.1  AM15.2
                                                                 AM15.3  AM15.4
                                                                 AM20.1  AM20.3
                                                                 AM21.1  AM21.3
                                                                 AM500   AM51.1
                                                                 AM551   AM97.1
                                                                 AP00.3  AP10.1
                                                                 AP10.2  AP10.5
                                                                 AP10.6  AP110
                                                                 AP125   AP126
                                                                 AP131   AP170
                                                                 AP180   AP181
                                                                 AP190   AP193
                                                                 AP220   AP25.1
                                                                 ...

                         TXCOMPANY FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Inp Due Acct   GLMASTER     Required
                            When (TXC-INPDU-ACT-UNIT != Spaces )
                            Or   (TXC-INPDU-ACCOUNT  != Zeroes )
                            Or   (TXC-INPDU-SUB-ACCT != Zeroes )

                            TXC-COMPANY           -> GLM-COMPANY
                            TXC-INPDU-ACT-UNIT    -> GLM-ACCT-UNIT
                            TXC-INPDU-ACCOUNT     -> GLM-ACCOUNT
                            TXC-INPDU-SUB-ACCT    -> GLM-SUB-ACCOUNT

Input Account  GLMASTER     Required
                            When TXC-INP-ACCT-UNIT != Spaces
                            Or   TXC-INP-ACCOUNT   != Zeroes
                            Or   TXC-INP-SUB-ACCT  != Zeroes

                            TXC-COMPANY           -> GLM-COMPANY
                            TXC-INP-ACCT-UNIT     -> GLM-ACCT-UNIT
                            TXC-INP-ACCOUNT       -> GLM-ACCOUNT
                            TXC-INP-SUB-ACCT      -> GLM-SUB-ACCOUNT

Outpt Due Acct GLMASTER     Required
                            When (TXC-OUTDU-ACT-UNIT != Spaces )
                            Or   (TXC-OUTDU-ACCOUNT  != Zeroes )
                            Or   (TXC-OUTDU-SUB-ACCT != Zeroes )

                            TXC-COMPANY           -> GLM-COMPANY
                            TXC-OUTDU-ACT-UNIT    -> GLM-ACCT-UNIT
                            TXC-OUTDU-ACCOUNT     -> GLM-ACCOUNT
                            TXC-OUTDU-SUB-ACCT    -> GLM-SUB-ACCOUNT

Output Account GLMASTER     Required
                            When TXC-OUT-ACCT-UNIT != Spaces
                            Or   TXC-OUT-ACCOUNT   != Zeroes
                            Or   TXC-OUT-SUB-ACCT  != Zeroes

                            TXC-COMPANY           -> GLM-COMPANY
                            TXC-OUT-ACCT-UNIT     -> GLM-ACCT-UNIT
                            TXC-OUT-ACCOUNT       -> GLM-ACCOUNT
                            TXC-OUT-SUB-ACCT      -> GLM-SUB-ACCOUNT

                         TXCOMPANY FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Txtaxcode      TXTAXCODE

                            TXC-COMPANY           -> TAC-COMPANY
                                                     TAC-TAX-CODE