Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ARDISTRIB


                             ARDISTRIB FILE

                            AR Distributions

The AR Distributions file contains distribution records for every transaction
that will be posted to the General Ledger system through the Lawson Accounts
Receivable system.

REFERENCED BY

AR287     AR293     AR295     AR296     AR95.1    AR99.6
AR220     AR242     AR286     TX101     AR199     GL235
AR129     AR130     AR131     AR135     AR39.1    AR39.2


UPDATED BY

AR115     AR124     AR137     AR190     AR195     AR196
AR197     AR20.1    AR21.1    AR21.2    AR21.3    AR24.1
AR28.1    AR29.2    AR29.3    AR30.1    AR300     AR32.1
AR33.5    AR34.1    AR42.1    AR42.2    AR42.6    AR42.7
AR43.1    AR44.3    AR48.3    AR502     AR507     AR560
AR570     AR575     AR580     AR82.1    ARLL.1    CB191
DT150     DT155     DT160     DT165     DT166     DT170
DT180     DT181     DT185     DT190     DT30.1    DT30.2
DT40.1    DT45.1    DT520     DT60.1    DT60.2    DT70.1
DT70.3    DT80.1    DT85.1    DT85.2    DT92.1    CB06.2


FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

AMD-GL-COMPANY         Numeric 4                                 AR115   AR124
General Ledger         The general ledger company associated     AR137   AR190
Company                with this distribution.                   AR196   AR20.1
                                                                 AR21.1  AR21.2
                                                                 AR21.3  AR24.1
                                                                 AR29.2  AR30.1
                                                                 AR32.1  AR33.5
                                                                 AR34.1  AR42.1
                                                                 AR42.2  AR42.6
                                                                 AR42.7  AR43.1
                                                                 AR44.3  AR48.3
                                                                 AR502   AR507
                                                                 AR560   AR570
                                                                 AR575   AR580
                                                                 AR82.1  ARLL.1
                                                                 CB191   DT150
                                                                 DT155   DT160
                                                                 DT165   DT166
                                                                 DT170   DT180
                                                                 DT181   DT185
                                                                 DT30.1  DT30.2
                                                                 DT40.1  DT45.1
                                                                 DT520   DT60.1
                                                                 DT60.2  DT70.1
                                                                 DT70.3  DT80.1
                                                                 DT85.1  DT85.2
                                                                 DT92.1

AMD-ACCT-UNIT          Alpha 15                                  AR115   AR124
Element: Accounting UniThe general ledger accounting unit to     AR137   AR190
                       which this distribution will be posted.   AR196   AR20.1
                                                                 AR21.1  AR21.2
                                                                 AR21.3  AR24.1
                                                                 AR29.2  AR30.1
                                                                 AR32.1  AR33.5
                                                                 AR34.1  AR42.1
                                                                 AR42.2  AR42.6
                                                                 AR42.7  AR43.1
                                                                 AR44.3  AR48.3
                                                                 AR502   AR507
                                                                 AR560   AR570
                                                                 AR575   AR580
                                                                 AR82.1  ARLL.1
                                                                 CB191   DT150
                                                                 DT155   DT160
                                                                 DT165   DT166
                                                                 DT170   DT180
                                                                 DT181   DT185
                                                                 DT30.1  DT30.2
                                                                 DT40.1  DT45.1
                                                                 DT520   DT60.1
                                                                 DT60.2  DT70.1
                                                                 DT70.3  DT80.1
                                                                 DT85.1  DT85.2
                                                                 DT92.1

AMD-ACCOUNT            Numeric 6                                 AR115   AR124
Element: Account       The general ledger account number to      AR137   AR190
                       which this distribution will be posted.   AR196   AR20.1
                                                                 AR21.1  AR21.2
                                                                 AR21.3  AR24.1
                                                                 AR29.2  AR30.1
                                                                 AR32.1  AR33.5
                                                                 AR34.1  AR42.1
                                                                 AR42.2  AR42.6
                                                                 AR42.7  AR43.1
                                                                 AR44.3  AR48.3
                                                                 AR502   AR507
                                                                 AR560   AR570
                                                                 AR575   AR580
                                                                 AR82.1  ARLL.1
                                                                 CB191   DT150
                                                                 DT155   DT160
                                                                 DT165   DT166
                                                                 DT170   DT180
                                                                 DT181   DT185
                                                                 DT30.1  DT30.2
                                                                 DT40.1  DT45.1
                                                                 DT520   DT60.1
                                                                 DT60.2  DT70.1
                                                                 DT70.3  DT80.1
                                                                 DT85.1  DT85.2
                                                                 DT92.1

AMD-SUB-ACCT           Numeric 4                                 AR115   AR124
Element: Subaccount    The general ledger subaccount number      AR137   AR190
                       used for posting the distribution.        AR196   AR20.1
                                                                 AR21.1  AR21.2
                                                                 AR21.3  AR24.1
                                                                 AR29.2  AR30.1
                                                                 AR32.1  AR33.5
                                                                 AR34.1  AR42.1
                                                                 AR42.2  AR42.6
                                                                 AR42.7  AR43.1
                                                                 AR44.3  AR48.3
                                                                 AR502   AR507
                                                                 AR560   AR570
                                                                 AR575   AR580
                                                                 AR82.1  ARLL.1
                                                                 CB191   DT150
                                                                 DT155   DT160
                                                                 DT165   DT166
                                                                 DT170   DT180
                                                                 DT181   DT185
                                                                 DT30.1  DT30.2
                                                                 DT40.1  DT45.1
                                                                 DT520   DT60.1
                                                                 DT60.2  DT70.1
                                                                 DT70.3  DT80.1
                                                                 DT85.1  DT85.2
                                                                 DT92.1

AMD-GL-DATE            Numeric 8  (yyyymmdd)                     AR115   AR124
Element: Posting Date  The date this distribution will be        AR137   AR190
                       posted to the general ledger.             AR196   AR20.1
                                                                 AR21.1  AR21.2
                                                                 AR21.3  AR24.1
                                                                 AR29.2  AR30.1
                                                                 AR32.1  AR33.5
                                                                 AR34.1  AR42.1
                                                                 AR42.2  AR42.6
                                                                 AR42.7  AR43.1
                                                                 AR44.3  AR48.3
                                                                 AR502   AR507
                                                                 AR560   AR570
                                                                 AR575   AR580
                                                                 AR82.1  ARLL.1
                                                                 CB191   DT150
                                                                 DT155   DT160
                                                                 DT165   DT166
                                                                 DT170   DT180
                                                                 DT181   DT185
                                                                 DT30.1  DT30.2
                                                                 DT40.1  DT45.1
                                                                 DT520   DT60.1
                                                                 DT60.2  DT70.1
                                                                 DT70.3  DT80.1
                                                                 DT85.1  DT85.2
                                                                 DT92.1

AMD-CREATE-DATE        Numeric 8  (yyyymmdd)                     AR115   AR124
Element: Creation Date The system date indicating when this      AR137   AR190
                       distribution was created.                 AR196   AR20.1
                                                                 AR21.1  AR21.2
                                                                 AR21.3  AR24.1
                                                                 AR29.2  AR30.1
                                                                 AR32.1  AR33.5
                                                                 AR34.1  AR42.1
                                                                 AR42.2  AR42.6
                                                                 AR42.7  AR43.1
                                                                 AR44.3  AR48.3
                                                                 AR502   AR507
                                                                 AR560   AR570
                                                                 AR575   AR580
                                                                 AR82.1  ARLL.1
                                                                 CB191   DT150
                                                                 DT155   DT160
                                                                 DT165   DT166
                                                                 DT170   DT180
                                                                 DT181   DT185
                                                                 DT30.1  DT30.2
                                                                 DT40.1  DT45.1
                                                                 DT520   DT60.1
                                                                 DT60.2  DT70.1
                                                                 DT70.3  DT80.1
                                                                 DT85.1  DT85.2
                                                                 DT92.1

AMD-CREATE-TIME        Numeric 6  (hhmmss)                       AR115   AR124
Element: Creation Time The system time indicating when this      AR137   AR190
                       distribution was created.                 AR196   AR20.1
                                                                 AR21.1  AR21.2
                                                                 AR21.3  AR24.1
                                                                 AR29.2  AR30.1
                                                                 AR32.1  AR33.5
                                                                 AR34.1  AR42.1
                                                                 AR42.2  AR42.6
                                                                 AR42.7  AR43.1
                                                                 AR44.3  AR48.3
                                                                 AR502   AR507
                                                                 AR560   AR570
                                                                 AR575   AR580
                                                                 AR82.1  ARLL.1
                                                                 CB191   DT150
                                                                 DT155   DT160
                                                                 DT165   DT166
                                                                 DT170   DT180
                                                                 DT181   DT185
                                                                 DT30.1  DT30.2
                                                                 DT40.1  DT45.1
                                                                 DT520   DT60.1
                                                                 DT60.2  DT70.1
                                                                 DT70.3  DT80.1
                                                                 DT85.1  DT85.2
                                                                 DT92.1

AMD-PROG-SEQ-NBR       Numeric 7                                 AR115   AR124
Program Sequence       Program sequence number. If multiple      AR137   AR190
Number                 records with the same keys exist, this    AR196   AR20.1
                       sequence number is incremented to make    AR21.1  AR21.2
                       records unique.                           AR21.3  AR24.1
                                                                 AR29.2  AR30.1
                                                                 AR32.1  AR33.5
                                                                 AR34.1  AR42.1
                                                                 AR42.2  AR42.6
                                                                 AR42.7  AR43.1
                                                                 AR44.3  AR48.3
                                                                 AR502   AR507
                                                                 AR560   AR570
                                                                 AR575   AR580
                                                                 AR82.1  ARLL.1
                                                                 CB191   DT150
                                                                 DT155   DT160
                                                                 DT165   DT166
                                                                 DT170   DT180
                                                                 DT181   DT185
                                                                 DT30.1  DT30.2
                                                                 DT40.1  DT45.1
                                                                 DT520   DT60.1
                                                                 DT60.2  DT70.1
                                                                 DT70.3  DT80.1
                                                                 DT85.1  DT85.2
                                                                 DT92.1

AMD-COMPANY            Numeric 4                                 AR115   AR124
Element: Distribution CThe company assigned to the               AR137   AR190
                       distribution. This may be different from  AR196   AR20.1
                       the company assigned to the transaction   AR21.1  AR21.2
                       if an intercompany relationship is        AR21.3  AR24.1
                       defined in the Lawson General Ledger      AR29.2  AR30.1
                       system.                                   AR32.1  AR33.5
                                                                 AR34.1  AR42.1
                                                                 AR42.2  AR42.6
                                                                 AR42.7  AR43.1
                                                                 AR44.3  AR48.3
                                                                 AR502   AR507
                                                                 AR560   AR570
                                                                 AR575   AR580
                                                                 AR82.1  ARLL.1
                                                                 CB191   DT150
                                                                 DT155   DT160
                                                                 DT165   DT166
                                                                 DT170   DT180
                                                                 DT181   DT185
                                                                 DT30.1  DT30.2
                                                                 DT40.1  DT45.1
                                                                 DT520   DT60.1
                                                                 DT60.2  DT70.1
                                                                 DT70.3  DT80.1
                                                                 DT85.1  DT85.2
                                                                 DT92.1

AMD-BATCH-NBR          Numeric 6                                 AR115   AR124
Element: Batch Number  The batch number associated with the      AR137   AR190
                       transaction distribution.                 AR196   AR20.1
                                                                 AR21.1  AR21.2
                                                                 AR21.3  AR24.1
                                                                 AR29.2  AR30.1
                                                                 AR32.1  AR33.5
                                                                 AR34.1  AR42.1
                                                                 AR42.2  AR42.7
                                                                 AR43.1  AR44.3
                                                                 AR48.3  AR507
                                                                 AR560   AR570
                                                                 AR575   AR580
                                                                 AR82.1  ARLL.1
                                                                 CB191   DT150
                                                                 DT160   DT170
                                                                 DT180   DT181
                                                                 DT185   DT45.1
                                                                 DT60.1  DT60.2
                                                                 DT70.1  DT70.3
                                                                 DT80.1  DT92.1

AMD-CUSTOMER           Alpha 9  (Right Justified)                AR115   AR124
Element: Customer      The customer number associated with       AR137   AR190
                       this distribution. This field will have   AR196   AR20.1
                       a value depending on whether the          AR21.1  AR21.2
                       distributions are detail or summary and   AR21.3  AR24.1
                       the originating process.                  AR28.1  AR29.2
                                                                 AR29.3  AR30.1
                                                                 AR32.1  AR33.5
                                                                 AR34.1  AR42.1
                                                                 AR42.2  AR42.6
                                                                 AR42.7  AR43.1
                                                                 AR44.3  AR48.3
                                                                 AR502   AR507
                                                                 AR560   AR570
                                                                 AR575   AR580
                                                                 AR82.1  ARLL.1
                                                                 CB191   DT150
                                                                 DT155   DT160
                                                                 DT165   DT166
                                                                 DT170   DT180
                                                                 DT181   DT185
                                                                 DT30.1  DT30.2
                                                                 DT40.1  DT45.1
                                                                 DT520   DT60.1
                                                                 DT60.2  DT70.1
                                                                 DT70.3  DT80.1
                                                                 DT85.1  DT85.2
                                                                 DT92.1

AMD-PROCESS-LEVEL      Alpha 5                                   AR115   AR124
Element: Process Level The process level associated with the     AR137   AR190
                       transaction distribution.                 AR196   AR20.1
                                                                 AR21.1  AR21.2
                                                                 AR21.3  AR24.1
                                                                 AR29.2  AR30.1
                                                                 AR32.1  AR33.5
                                                                 AR34.1  AR42.1
                                                                 AR42.2  AR42.6
                                                                 AR42.7  AR43.1
                                                                 AR44.3  AR48.3
                                                                 AR502   AR507
                                                                 AR560   AR570
                                                                 AR575   AR580
                                                                 ARLL.1  CB191
                                                                 DT150   DT155
                                                                 DT160   DT165
                                                                 DT166   DT170
                                                                 DT180   DT181
                                                                 DT185   DT30.1
                                                                 DT30.2  DT40.1
                                                                 DT45.1  DT520
                                                                 DT60.1  DT60.2
                                                                 DT70.1  DT70.3
                                                                 DT80.1  DT85.1
                                                                 DT85.2  DT92.1

AMD-TRANS-TYPE         Alpha 1                                   AR115   AR124
Element: Transaction TyThe type of transaction associated with   AR137   AR190
                       the distribution. Valid values are:       AR196   AR20.1
                                                                 AR21.1  AR21.2
                       C = Credit Memo                           AR21.3  AR24.1
                       D = Debit Memo                            AR29.2  AR30.1
                       I = Invoice                               AR32.1  AR33.5
                       N = Non-Accounts Receivable Payment       AR34.1  AR42.1
                       B = Bills of Exchange                     AR42.2  AR42.6
                       P = Payment (AR)                          AR42.7  AR43.1
                       R = Remittance                            AR44.3  AR48.3
                       M = Mixed                                 AR502   AR507
                                                                 AR560   AR570
                                                                 AR575   AR580
                                                                 AR82.1  ARLL.1
                                                                 CB191   DT150
                                                                 DT155   DT160
                                                                 DT165   DT166
                                                                 DT170   DT180
                                                                 DT181   DT185
                                                                 DT30.1  DT30.2
                                                                 DT40.1  DT45.1
                                                                 DT520   DT60.1
                                                                 DT60.2  DT70.1
                                                                 DT70.3  DT80.1
                                                                 DT85.1  DT85.2
                                                                 DT92.1

AMD-INVOICE            Alpha 22                                  AR115   AR124
Element: Invoice       Used to identify the invoice.             AR137   AR190
                                                                 AR196   AR20.1
                                                                 AR21.1  AR21.2
                                                                 AR21.3  AR24.1
                                                                 AR29.2  AR30.1
                                                                 AR32.1  AR33.5
                                                                 AR34.1  AR42.1
                                                                 AR42.2  AR42.6
                                                                 AR42.7  AR43.1
                                                                 AR44.3  AR48.3
                                                                 AR502   AR507
                                                                 AR560   AR570
                                                                 AR575   AR580
                                                                 AR82.1  ARLL.1
                                                                 CB191   DT150
                                                                 DT155   DT160
                                                                 DT165   DT166
                                                                 DT170   DT180
                                                                 DT181   DT185
                                                                 DT30.1  DT30.2
                                                                 DT40.1  DT45.1
                                                                 DT520   DT60.1
                                                                 DT60.2  DT70.1
                                                                 DT70.3  DT80.1
                                                                 DT85.1  DT85.2
                                                                 DT92.1

AMD-TRANS-DATE         Numeric 8  (yyyymmdd)                     AR115   AR124
Element: Transaction DaThe date of the transaction associated    AR137   AR190
                       with the distribution.                    AR196   AR20.1
                                                                 AR21.1  AR21.2
                                                                 AR21.3  AR24.1
                                                                 AR29.2  AR30.1
                                                                 AR32.1  AR33.5
                                                                 AR34.1  AR42.1
                                                                 AR42.2  AR42.6
                                                                 AR42.7  AR43.1
                                                                 AR44.3  AR48.3
                                                                 AR502   AR507
                                                                 AR560   AR570
                                                                 AR575   AR580
                                                                 AR82.1  ARLL.1
                                                                 CB191   DT150
                                                                 DT155   DT160
                                                                 DT165   DT166
                                                                 DT170   DT180
                                                                 DT181   DT185
                                                                 DT30.1  DT30.2
                                                                 DT40.1  DT45.1
                                                                 DT520   DT60.1
                                                                 DT60.2  DT70.1
                                                                 DT70.3  DT80.1
                                                                 DT85.1  DT85.2
                                                                 DT92.1

AMD-DIST-SEQ           Numeric 4                                 AR115   AR124
Distribution           Distribution sequence number. If          AR137   AR190
Sequence Number        multiple distributions are posted for a   AR196   AR20.1
                       transaction, this sequence number helps   AR21.1  AR21.2
                       identify and keep distributions unique.   AR21.3  AR24.1
                                                                 AR29.2  AR30.1
                                                                 AR32.1  AR33.5
                                                                 AR34.1  AR42.1
                                                                 AR42.2  AR42.6
                                                                 AR42.7  AR43.1
                                                                 AR44.3  AR48.3
                                                                 AR502   AR507
                                                                 AR560   AR570
                                                                 AR575   AR580
                                                                 AR82.1  ARLL.1
                                                                 CB191   DT150
                                                                 DT155   DT160
                                                                 DT165   DT166
                                                                 DT170   DT180
                                                                 DT181   DT185
                                                                 DT30.1  DT30.2
                                                                 DT40.1  DT45.1
                                                                 DT520   DT60.1
                                                                 DT60.2  DT70.1
                                                                 DT70.3  DT80.1
                                                                 DT85.1  DT85.2
                                                                 DT92.1

AMD-DST-TYPE           Alpha 2                                   AR115   AR124
Element: Distribution TIdentifies where the transaction          AR137   AR190
                       originated in the Lawson Accounts         AR196   AR20.1
                       Receivable system. Valid values are:      AR21.1  AR21.2
                                                                 AR21.3  AR24.1
                       RI = Receivable Invoicing                 AR29.2  AR30.1
                       RL = Receivable Application               AR32.1  AR33.5
                       RM = Receivable Memo                      AR34.1  AR42.1
                       RN = Receivable Notice                    AR42.2  AR42.6
                       RP = Receivable Payment                   AR42.7  AR43.1
                       RV = Receivable Reversal                  AR44.3  AR48.3
                       RU = Unrealized Gain Loss                 AR502   AR507
                       BE = BOE Cashing Expense                  AR560   AR570
                       BG = BOE Bank Presentation Cashing        AR575   AR580
                       DA = BOE Accepted                         AR82.1  ARLL.1
                       DB = BOE Cancellation                     CB191   DT150
                       DC = BOE Cashing                          DT155   DT160
                       DH = BOE Dishonored                       DT165   DT166
                       DK = BOE Discounted Remittance            DT170   DT180
                       DR = BOE Cashing with Remittance          DT181   DT185
                       EC = BOE Gain Loss                        DT30.1  DT30.2
                       RY = Application Reversal                 DT40.1  DT45.1
                       RQ = Application Adjustment               DT520   DT60.1
                       RX = Adjustment Reversal                  DT60.2  DT70.1
                                                                 DT70.3  DT80.1
                                                                 DT85.1  DT85.2
                                                                 DT92.1

AMD-PAYMENT-SEQ        Numeric 6                                 AR190   AR196
Payment Sequence       A unique number assigned to each          AR48.3
Number                 transaction to be interfaced into the
                       Lawson system.

AMD-ACCUM-TYPE         Alpha 1                                   AR115   AR124
Distribution           Indicates whether the type of the         AR137   AR190
Summary/Detail         distribution is detail or summary. Valid  AR196   AR20.1
                       values are:                               AR21.1  AR21.2
                                                                 AR21.3  AR24.1
                       D = Detail                                AR29.2  AR30.1
                       S = Summary                               AR32.1  AR33.5
                                                                 AR34.1  AR42.1
                                                                 AR42.2  AR42.6
                                                                 AR42.7  AR43.1
                                                                 AR44.3  AR48.3
                                                                 AR502   AR507
                                                                 AR560   AR570
                                                                 AR575   AR580
                                                                 AR82.1  ARLL.1
                                                                 CB191   DT150
                                                                 DT155   DT160
                                                                 DT165   DT166
                                                                 DT170   DT180
                                                                 DT181   DT185
                                                                 DT30.1  DT30.2
                                                                 DT40.1  DT45.1
                                                                 DT520   DT60.1
                                                                 DT60.2  DT70.1
                                                                 DT70.3  DT80.1
                                                                 DT85.1  DT85.2
                                                                 DT92.1

AMD-TRAN-AMT           Signed 18.2                               AR115   AR124
Element: Base Amount   The amount of the distribution in the     AR137   AR190
                       company base currency.                    AR196   AR20.1
                                                                 AR21.1  AR21.2
                                                                 AR21.3  AR24.1
                                                                 AR29.2  AR30.1
                                                                 AR32.1  AR33.5
                                                                 AR34.1  AR42.1
                                                                 AR42.2  AR42.6
                                                                 AR42.7  AR43.1
                                                                 AR44.3  AR48.3
                                                                 AR502   AR507
                                                                 AR560   AR570
                                                                 AR575   AR580
                                                                 AR82.1  ARLL.1
                                                                 CB191   DT150
                                                                 DT155   DT160
                                                                 DT165   DT166
                                                                 DT170   DT180
                                                                 DT181   DT185
                                                                 DT30.1  DT30.2
                                                                 DT40.1  DT45.1
                                                                 DT520   DT60.1
                                                                 DT60.2  DT70.1
                                                                 DT70.3  DT80.1
                                                                 DT85.1  DT85.2
                                                                 DT92.1

AMD-TO-COMP-AMT        Signed 18.2                               AR115   AR124
Element: To Company AmoThe amount of the distribution that       AR137   AR190
                       will be posted to another company in a    AR20.1  AR21.1
                       intercompany transaction.                 AR21.2  AR21.3
                                                                 AR24.1  AR29.2
                                                                 AR30.1  AR32.1
                                                                 AR33.5  AR34.1
                                                                 AR42.2  AR44.3
                                                                 AR48.3  AR507
                                                                 AR560   AR570
                                                                 AR575   AR580
                                                                 AR82.1  ARLL.1
                                                                 CB191   DT150
                                                                 DT160   DT170
                                                                 DT180   DT181
                                                                 DT185   DT45.1
                                                                 DT60.1  DT60.2
                                                                 DT70.1  DT70.3
                                                                 DT80.1  DT92.1

AMD-UNITS              Signed 15.2                               AR190   AR21.3
Element: Units         The quantity of units for the             AR29.2  AR42.2
                       distribution if units are being used for  AR42.7  AR44.3
                       a transaction.                            AR48.3  AR507
                                                                 AR560   DT150
                                                                 DT160   DT170
                                                                 DT180   DT181
                                                                 DT185   DT45.1
                                                                 DT60.1  DT60.2
                                                                 DT70.1  DT70.3
                                                                 DT80.1  DT92.1

AMD-DESC               Alpha 30  (Lower Case)                    AR115   AR124
Element: Description   The description of the distribution.      AR137   AR190
                       The value in this field varies depending  AR196   AR20.1
                       on the type of transaction and the        AR21.1  AR21.2
                       program the distribution was created in.  AR21.3  AR24.1
                                                                 AR29.2  AR30.1
                                                                 AR32.1  AR33.5
                                                                 AR34.1  AR42.1
                                                                 AR42.2  AR42.6
                                                                 AR42.7  AR43.1
                                                                 AR44.3  AR48.3
                                                                 AR502   AR507
                                                                 AR560   AR570
                                                                 AR575   AR580
                                                                 AR82.1  ARLL.1
                                                                 CB191   DT150
                                                                 DT155   DT160
                                                                 DT165   DT166
                                                                 DT170   DT180
                                                                 DT181   DT185
                                                                 DT30.1  DT30.2
                                                                 DT40.1  DT45.1
                                                                 DT520   DT60.1
                                                                 DT60.2  DT70.1
                                                                 DT70.3  DT80.1
                                                                 DT85.1  DT85.2
                                                                 DT92.1

AMD-ACTIVITY           Alpha 15                                  AR190   AR21.3
Element: Activity      Activities are the processes or           AR29.2  AR42.2
                       procedures that produce work. Cost        AR42.7  AR44.3
                       objects (products, services, customers,   AR48.3  AR507
                       and so on) are the reasons for            AR560   DT150
                       performing the activity.                  DT160   DT170
                                                                 DT180   DT181
                                                                 DT185   DT45.1
                                                                 DT60.1  DT60.2
                                                                 DT70.1  DT70.3
                                                                 DT80.1  DT92.1

AMD-ACCT-CATEGORY      Alpha 5                                   AR190   AR21.3
Element: Category      Account categories are groupings of       AR29.2  AR42.2
                       costs, revenues, or a combination of      AR42.7  AR44.3
                       both used for reporting and inquiries     AR48.3  AR507
                       for activities in the Activity            AR560   DT150
                       Management system. All transactions are   DT160   DT170
                       posted to an account category within an   DT180   DT181
                       activity. You can assign a specific       DT185   DT45.1
                       General Ledger account or range of        DT60.1  DT60.2
                       accounts (company, accounting unit,       DT70.1  DT70.3
                       account, and subaccount) that make up     DT80.1  DT92.1
                       the transactions posted to an account
                       category using AC07.1 (Account
                       Assignment).

                       Period-to-date, year-to-date, and
                       life-to-date balances are maintained by
                       account category for activities. Account
                       categories must be assigned to
                       activities before you do any budgeting
                       or transaction processing.

                       Valid account category types are:
                       cost
                       revenue
                       accrual
                       pass thru

AMD-STATUS             Numeric 1                                 AR115   AR124
Element: Status        Status of the distribution record.        AR137   AR190
                       Valid values are:                         AR195   AR196
                                                                 AR20.1  AR21.1
                       0 = Unreleased                            AR21.2  AR21.3
                       2 = Released                              AR24.1  AR29.2
                       9 = Posted                                AR30.1  AR32.1
                                                                 AR33.5  AR34.1
                                                                 AR42.1  AR42.2
                                                                 AR42.6  AR42.7
                                                                 AR43.1  AR44.3
                                                                 AR48.3  AR502
                                                                 AR507   AR560
                                                                 AR570   AR575
                                                                 AR580   AR82.1
                                                                 ARLL.1  CB191
                                                                 DT150   DT155
                                                                 DT160   DT165
                                                                 DT166   DT170
                                                                 DT180   DT181
                                                                 DT185   DT190
                                                                 DT30.1  DT30.2
                                                                 DT40.1  DT45.1
                                                                 DT520   DT60.1
                                                                 DT60.2  DT70.1
                                                                 DT70.3  DT80.1
                                                                 DT85.1  DT85.2
                                                                 DT92.1

AMD-ORIG-CURRENCY      Alpha 5                                   AR115   AR124
Element: Transaction CuThe currency in which the transaction     AR137   AR190
                       was entered.                              AR196   AR20.1
                                                                 AR21.1  AR21.2
                                                                 AR21.3  AR24.1
                                                                 AR29.2  AR30.1
                                                                 AR32.1  AR33.5
                                                                 AR34.1  AR42.1
                                                                 AR42.2  AR42.6
                                                                 AR42.7  AR43.1
                                                                 AR44.3  AR48.3
                                                                 AR502   AR507
                                                                 AR560   AR570
                                                                 AR575   AR580
                                                                 AR82.1  ARLL.1
                                                                 CB191   DT150
                                                                 DT155   DT160
                                                                 DT165   DT166
                                                                 DT170   DT180
                                                                 DT181   DT185
                                                                 DT30.1  DT30.2
                                                                 DT40.1  DT45.1
                                                                 DT520   DT60.1
                                                                 DT60.2  DT70.1
                                                                 DT70.3  DT80.1
                                                                 DT85.1  DT85.2
                                                                 DT92.1

AMD-ORIG-RATE          Signed 14.7                               AR115   AR124
Element: Exchange Rate The currency exchange rate used to        AR137   AR190
                       convert a non-base currency transaction   AR196   AR20.1
                       amount to the company base currency. The  AR21.1  AR21.2
                       rate is maintained in the Currency        AR21.3  AR24.1
                       Relationship file and there is an option  AR29.2  AR30.1
                       at the company level to override the      AR32.1  AR33.5
                       rate at entry time.                       AR34.1  AR42.1
                                                                 AR42.2  AR42.6
                                                                 AR42.7  AR43.1
                                                                 AR44.3  AR48.3
                                                                 AR502   AR507
                                                                 AR560   AR570
                                                                 AR575   AR580
                                                                 AR82.1  ARLL.1
                                                                 CB191   DT150
                                                                 DT155   DT160
                                                                 DT165   DT166
                                                                 DT170   DT180
                                                                 DT181   DT185
                                                                 DT30.1  DT30.2
                                                                 DT40.1  DT45.1
                                                                 DT520   DT60.1
                                                                 DT60.2  DT70.1
                                                                 DT70.3  DT80.1
                                                                 DT85.1  DT85.2
                                                                 DT92.1

AMD-ORIG-AMT           Signed 18.2                               AR115   AR124
Element: Transaction AmThe amount of the distribution in         AR137   AR190
                       transaction currency.                     AR20.1  AR21.1
                                                                 AR21.2  AR21.3
                                                                 AR24.1  AR29.2
                                                                 AR30.1  AR32.1
                                                                 AR33.5  AR34.1
                                                                 AR42.1  AR42.2
                                                                 AR42.6  AR42.7
                                                                 AR43.1  AR44.3
                                                                 AR48.3  AR502
                                                                 AR507   AR560
                                                                 AR570   AR575
                                                                 AR580   AR82.1
                                                                 ARLL.1  CB191
                                                                 DT150   DT155
                                                                 DT160   DT165
                                                                 DT166   DT170
                                                                 DT180   DT181
                                                                 DT185   DT30.1
                                                                 DT30.2  DT40.1
                                                                 DT45.1  DT520
                                                                 DT60.1  DT60.2
                                                                 DT70.1  DT70.3
                                                                 DT80.1  DT85.1
                                                                 DT85.2  DT92.1

AMD-CAT-TYPE           Alpha 1                                   AR44.3  DT150
Element: Cat Type      Indicates the type of distribution        DT160   DT170
                       category. Valid values are:               DT180   DT181
                                                                 DT185   DT45.1
                       C = Category                              DT60.1  DT60.2
                       T = Tax                                   DT70.1  DT70.3
                                                                 DT80.1  DT92.1

AMD-AR-CATEGORY        Alpha 5                                   AR190   AR42.2
Element: AR Category   The category code assigned to the         AR42.7  AR44.3
                       distribution. Used to default             AR48.3  DT150
                       distribution information.                 DT160   DT170
                                                                 DT180   DT181
                                                                 DT185   DT45.1
                                                                 DT60.1  DT60.2
                                                                 DT70.1  DT70.3
                                                                 DT80.1  DT92.1

AMD-TAX-CODE           Alpha 10                                  AR190   AR21.3
Element: Tax Code      The tax code assigned to the              AR29.2  AR42.2
                       distribution. Identifies a tax            AR42.7  AR44.3
                       percentage to be assessed to the taxable  AR48.3  AR507
                       amount of a transaction. Must be defined  AR560   ARLL.1
                       in the Lawson Tax system.                 DT150   DT160
                                                                 DT170   DT180
                                                                 DT181   DT185
                                                                 DT45.1  DT60.1
                                                                 DT60.2  DT70.1
                                                                 DT70.3  DT80.1
                                                                 DT92.1

AMD-TRAN-TAXABLE       Signed 18.2                               AR190   AR21.3
Element: Base Taxable AThe taxable amount of the distribution.   AR29.2  AR42.2
                                                                 AR42.7  AR44.3
                                                                 AR48.3  AR560
                                                                 ARLL.1  DT150
                                                                 DT160   DT170
                                                                 DT180   DT181
                                                                 DT185   DT45.1
                                                                 DT60.1  DT60.2
                                                                 DT70.1  DT70.3
                                                                 DT80.1  DT92.1

AMD-UPDATE-SUM         Alpha 2                                   AR115   AR137
Element: Update SummaryIndicates what summary amount should be   AR190   AR196
                       updated when AR194 (Audit Summary) is     AR33.5  AR42.1
                       run. Valid values are:                    AR42.2  AR42.6
                                                                 AR42.7  AR43.1
                       01 = Invoice                              AR44.3  AR48.3
                       02 = Memos                                AR502   AR560
                       03 = Cash                                 AR82.1  ARLL.1
                       04 = Credits Applied                      DT150   DT155
                       06 = Chargebacks                          DT160   DT165
                       07 = Discounts                            DT166   DT170
                       08 = Write-Offs                           DT180   DT181
                       09 = Gain/Loss on currency exchange       DT185   DT30.1
                       10 = Cashed Bill of Exchange              DT30.2  DT40.1
                                                                 DT45.1  DT520
                                                                 DT60.1  DT60.2
                                                                 DT70.1  DT70.3
                                                                 DT80.1  DT85.1
                                                                 DT85.2  DT92.1

AMD-ORIG-ND            Numeric 1                                 AR115   AR124
Element: Number of DeciIndicates the number of decimals          AR190   AR196
                       defined for the transaction currency.     AR20.1  AR21.1
                                                                 AR21.2  AR21.3
                                                                 AR24.1  AR29.2
                                                                 AR30.1  AR32.1
                                                                 AR33.5  AR34.1
                                                                 AR42.1  AR42.2
                                                                 AR42.6  AR42.7
                                                                 AR43.1  AR44.3
                                                                 AR48.3  AR502
                                                                 AR507   AR560
                                                                 AR570   AR575
                                                                 AR580   AR82.1
                                                                 ARLL.1  CB191
                                                                 DT150   DT155
                                                                 DT160   DT165
                                                                 DT166   DT170
                                                                 DT180   DT181
                                                                 DT185   DT30.1
                                                                 DT30.2  DT40.1
                                                                 DT45.1  DT520
                                                                 DT60.1  DT60.2
                                                                 DT70.1  DT70.3
                                                                 DT80.1  DT85.1
                                                                 DT85.2  DT92.1

AMD-AUTO-REV           Alpha 1                                   AR190   AR195
Element: Auto Reversal When the Auto Reversal field is set to    AR196   AR44.3
                       "Y", program AR196 (Unrealized Gain Loss  AR48.3  DT150
                       Report) creates an opposite entry for     DT160   DT170
                       this transaction. Valid values are:       DT180   DT181
                                                                 DT185   DT45.1
                       N = No reversing records needed           DT60.1  DT60.2
                       Y = Reversing records needed              DT70.1  DT70.3
                                                                 DT80.1  DT92.1

AMD-ORIG-COMPANY       Numeric 4                                 AR190   AR42.1
Element: Originating CoThis is the company the distribution      AR42.2  AR42.6
                       record originated from.                   AR42.7  AR43.1
                                                                 AR44.3  AR48.3
                                                                 AR502   AR560
                                                                 ARLL.1  DT150
                                                                 DT155   DT160
                                                                 DT165   DT166
                                                                 DT170   DT180
                                                                 DT181   DT185
                                                                 DT30.1  DT30.2
                                                                 DT40.1  DT45.1
                                                                 DT520   DT60.1
                                                                 DT60.2  DT70.1
                                                                 DT70.3  DT80.1
                                                                 DT85.1  DT85.2
                                                                 DT92.1

AMD-ORIG-TAXABLE       Signed 18.2                               AR190   AR21.3
Element: Intl Amt      The taxable amount of the original        AR29.2  AR42.2
                       distribution transaction.                 AR42.7  AR44.3
                                                                 AR48.3  AR560
                                                                 ARLL.1  DT150
                                                                 DT160   DT170
                                                                 DT180   DT181
                                                                 DT185   DT45.1
                                                                 DT60.1  DT60.2
                                                                 DT70.1  DT70.3
                                                                 DT80.1  DT92.1

AMD-DOCUMENT-NBR       Alpha 27                                  AR115   AR124
Element: Document NumbeThis field is used for document           AR190   AR196
                       journalizing in the Lawson General        AR20.1  AR21.1
                       Ledger system. Document numbers are       AR21.2  AR21.3
                       assessed during record creation and       AR24.1  AR29.2
                       represent a source document or a summary  AR30.1  AR32.1
                       value for many documents with an          AR33.5  AR34.1
                       identifying source prefix. Valid values   AR42.1  AR42.2
                       are:                                      AR42.6  AR42.7
                                                                 AR43.1  AR44.3
                       1 = Invoicing detail                      AR48.3  AR502
                       2 = Debit Memo detail                     AR560   AR570
                       3 = Credit Memo detail                    AR575   AR580
                       5 = Payment Batch summary                 AR82.1  ARLL.1
                       6 = Payment detail                        CB191   DT150
                       7 = Application detail/summary            DT155   DT160
                       8 = RTM detail                            DT165   DT166
                       9 = Finance Charge summary                DT170   DT180
                       10 = Finance Charge detail                DT181   DT185
                       11 = Invoice Unreal Gain Loss detail      DT30.1  DT30.2
                       12 = Db Memo Unreal Gain Loss detail      DT40.1  DT45.1
                       13 = Cr Memo Unreal Gain Loss detail      DT520   DT60.1
                       14 = Transfer to Non-AR detail            DT60.2  DT70.1
                       15 = Debit Memo Grouping                  DT70.3  DT80.1
                                                                 DT85.1  DT85.2
                                                                 DT92.1

AMD-DST-SOURCE         Alpha 1                                   AR115   AR124
Element: Distribution SThe source of the distribution. Valid     AR137   AR190
                       values are:                               AR20.1  AR21.1
                                                                 AR21.2  AR21.3
                       A = Accounts Receivable                   AR24.1  AR29.2
                       B = Bill of Exchange                      AR30.1  AR32.1
                                                                 AR33.5  AR34.1
                                                                 AR42.1  AR42.2
                                                                 AR42.6  AR42.7
                                                                 AR43.1  AR44.3
                                                                 AR48.3  AR502
                                                                 AR560   AR570
                                                                 AR575   AR580
                                                                 AR82.1  ARLL.1
                                                                 CB191   DT150
                                                                 DT155   DT160
                                                                 DT165   DT166
                                                                 DT170   DT180
                                                                 DT181   DT185
                                                                 DT30.1  DT30.2
                                                                 DT40.1  DT45.1
                                                                 DT520   DT60.1
                                                                 DT60.2  DT70.1
                                                                 DT70.3  DT80.1
                                                                 DT85.1  DT85.2
                                                                 DT92.1

AMD-BASE-ACCTUNIT      Alpha 15                                  AR115   AR124
Element: Base Account UUsed for inter-zone balancing in the      AR137   AR190
                       Lawson General Ledger system.             AR196   AR20.1
                                                                 AR21.1  AR21.2
                                                                 AR21.3  AR24.1
                                                                 AR29.2  AR30.1
                                                                 AR32.1  AR33.5
                                                                 AR34.1  AR42.1
                                                                 AR42.2  AR42.6
                                                                 AR42.7  AR43.1
                                                                 AR44.3  AR48.3
                                                                 AR502   AR507
                                                                 AR560   AR570
                                                                 AR575   AR580
                                                                 AR82.1  ARLL.1
                                                                 CB191   DT150
                                                                 DT155   DT160
                                                                 DT165   DT166
                                                                 DT170   DT180
                                                                 DT181   DT185
                                                                 DT30.1  DT30.2
                                                                 DT40.1  DT45.1
                                                                 DT520   DT60.1
                                                                 DT60.2  DT70.1
                                                                 DT70.3  DT80.1
                                                                 DT85.1  DT85.2
                                                                 DT92.1

AMD-JRNL-BOOK-NBR      Alpha 12                                  AR115   AR124
Element: Journal Book NThis field will contain the journal       AR137   AR190
                       book number for the distribution record.  AR20.1  AR21.1
                                                                 AR21.2  AR21.3
                                                                 AR24.1  AR29.2
                                                                 AR30.1  AR32.1
                                                                 AR34.1  AR42.1
                                                                 AR42.2  AR42.6
                                                                 AR42.7  AR43.1
                                                                 AR44.3  AR48.3
                                                                 AR502   AR507
                                                                 AR560   AR570
                                                                 AR575   AR580
                                                                 AR82.1  ARLL.1
                                                                 CB191   DT150
                                                                 DT155   DT160
                                                                 DT165   DT166
                                                                 DT170   DT180
                                                                 DT181   DT185
                                                                 DT30.1  DT30.2
                                                                 DT40.1  DT45.1
                                                                 DT520   DT60.1
                                                                 DT60.2  DT70.1
                                                                 DT70.3  DT80.1
                                                                 DT85.1  DT85.2
                                                                 DT92.1

AMD-MX-VALUE           Alpha 32 Occurs 3 Times                   AR115   AR124
Element: Matrix Value  An optional transaction attribute value   AR137   AR190
                       as defined in the Lawson General Ledger   AR196   AR20.1
                       system's Source Code program.             AR21.1  AR21.2
                                                                 AR21.3  AR24.1
                                                                 AR29.2  AR30.1
                                                                 AR32.1  AR34.1
                                                                 AR42.1  AR42.2
                                                                 AR42.7  AR43.1
                                                                 AR44.3  AR48.3
                                                                 AR560   AR570
                                                                 AR575   AR580
                                                                 AR82.1  ARLL.1
                                                                 CB191   DT150
                                                                 DT160   DT170
                                                                 DT180   DT181
                                                                 DT185   DT45.1
                                                                 DT60.1  DT60.2
                                                                 DT70.1  DT70.3
                                                                 DT80.1  DT92.1

AMD-GLT-OBJ-ID         Numeric 12                                AR115   AR124
General Ledger         A subsystem interface identification      AR190   AR195
Object ID              number. Used for Drill Around purposes.   AR20.1  AR21.1
                                                                 AR21.2  AR21.3
                                                                 AR24.1  AR29.2
                                                                 AR30.1  AR32.1
                                                                 AR34.1  AR42.1
                                                                 AR42.2  AR42.7
                                                                 AR43.1  AR44.3
                                                                 AR48.3  AR560
                                                                 AR570   AR575
                                                                 AR580   ARLL.1
                                                                 CB191   DT150
                                                                 DT160   DT170
                                                                 DT180   DT181
                                                                 DT185   DT190
                                                                 DT45.1  DT60.1
                                                                 DT60.2  DT70.1
                                                                 DT70.3  DT80.1
                                                                 DT92.1

AMD-DRAFT-SOURCE       Alpha 1                                   AR190   AR48.3
Bill of Exchange       This defines origination of the bill of   DT180   DT181
Source                 exchange.

AMD-ATN-OBJ-ID         Numeric 12                                AR115   AR124
Element: Activity ObjecA subsystem interface identification      AR190   AR195
                       number. Used for Drill Around purposes.   AR20.1  AR21.1
                                                                 AR21.2  AR21.3
                                                                 AR24.1  AR29.2
                                                                 AR30.1  AR32.1
                                                                 AR34.1  AR42.1
                                                                 AR42.2  AR42.7
                                                                 AR43.1  AR48.3
                                                                 AR560   AR570
                                                                 AR575   AR580
                                                                 ARLL.1  CB191
                                                                 DT180   DT181
                                                                 DT190

AMD-TAX-POINT          Alpha 1                                   AR21.3  AR29.2
Element: Tax Point     Indicates the tax point origin, used      AR42.2  AR42.7
                       for tax calculation. Valid values are:    AR48.3  AR560
                                                                 ARLL.1  DT180
                       I = Invoice origin                        DT181
                       P = Payment origin
                       Blank = No tax point origin
                       S = Shipping Date
                       G = GL Date

AMD-JBK-SEQ-NBR        Numeric 10                                AR115   AR124
Element: Jbk Seq Nbr   The journal book sequence number          AR190   AR20.1
                       assigned to a journal book transaction    AR21.1  AR21.2
                       when it is added or interfaced to the     AR21.3  AR24.1
                       Lawson system. Used only when  Auto       AR30.1  AR32.1
                       Journal Book Seq Nbr is set to Yes in     AR34.1  AR570
                       GL10.1 (Company).                         AR575   AR580
                                                                 CB191

AMD-LINE-TYPE          Alpha 1                                   AR42.2  AR560
Element: Line Type     This field contains the line type used
                       for intrastat purpose.  Valid values
                       are:

                       Blank
                       G = Goods
                       S = Services

AMD-WEIGHT             Signed 9.3                                AR42.2  AR560
Element: Weight        This field contains a weight
                       measurement used in the intrastat
                       process.

AMD-ICN-CODE           Alpha 8                                   AR42.2  AR560
Element: Icn Code      The ICN code used in the intrastat
                       process.

AMD-SUPLMNTARY-QTY     Signed 13.4                               AR42.2  AR560
Element: Quantity      The supplementary quantity used in the
                       intrastat process.

AMD-BAL-DATE           Numeric 8  (yyyymmdd)                     AR197
Element: Date          This field displays the system date
                       when this was created.

                         ARDISTRIB FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

AMDSET1   GL-COMPANY                                             AR115   AR124
          ACCT-UNIT                                              AR195   AR197
          ACCOUNT                                                AR20.1  AR21.1
          SUB-ACCT                                               AR21.2  AR21.3
          GL-DATE                                                AR24.1  AR287
          CREATE-DATE                                            AR29.2  AR293
          CREATE-TIME                                            AR295   AR296
          PROG-SEQ-NBR                                           AR30.1  AR300
                                                                 AR32.1  AR33.5
                                                                 AR34.1  AR42.1
                                                                 AR42.2  AR42.6
                                                                 AR42.7  AR43.1
                                                                 AR44.3  AR502
                                                                 AR560   AR570
                                                                 AR575   AR580
                                                                 ...

AMDSET2   COMPANY       Subset                                   AR115   AR124
          BATCH-NBR     Where DST-TYPE = "RI"                    AR190   AR195
          TRANS-TYPE    Or    DST-TYPE = "RP"                    AR20.1  AR21.1
          INVOICE       Or    DST-TYPE = "RM"                    AR21.2  AR21.3
          CUSTOMER                                               AR220   AR24.1
          DIST-SEQ                                               AR242   AR28.1
                                                                 AR28.6  AR286
                                                                 AR29.2  AR29.3
                                                                 AR295   AR30.1
                                                                 AR300   AR32.1
                                                                 AR34.1  AR42.1
                                                                 AR42.2  AR42.6
                                                                 AR42.7  AR43.1
                                                                 AR44.3  AR48.3
                                                                 AR560   AR570
                                                                 ...

AMDSET3   COMPANY       Subset                                   AR195   AR199
          ACCT-UNIT     Where STATUS = 2                         DT190
          ACCOUNT
          SUB-ACCT
          GL-COMPANY
          GL-DATE
          CREATE-DATE
          CREATE-TIME
          PROG-SEQ-NBR

AMDSET4   COMPANY       Subset                                   AR196   AR29.3
          CUSTOMER      Where DST-TYPE = "RU"
          TRANS-TYPE
          INVOICE
          PAYMENT-SEQ
          DIST-SEQ

AMDSET5   GL-COMPANY    KeyChange                                GL235
          ACCT-UNIT
          ACCOUNT
          SUB-ACCT
          GL-DATE
          GLT-OBJ-ID
          CREATE-DATE
          CREATE-TIME
          PROG-SEQ-NBR

AMDSET6   COMPANY       Subset                                   AR129   AR130
          CUSTOMER      Where TAX-POINT = "P"                    AR131   AR135
          TRANS-TYPE                                             AR190   AR30.1
          INVOICE                                                AR30.8  AR32.1
          DIST-SEQ                                               AR33.1  AR33.3
                                                                 AR33.6  AR34.1
                                                                 AR39.1  AR39.2
                                                                 AR48.3  DT180
                                                                 DT181

AMDSET7   ATN-OBJ-ID    Subset
          GL-COMPANY    Where ATN-OBJ-ID != Zeroes
          ACCT-UNIT
          ACCOUNT
          SUB-ACCT
          GL-DATE
          CREATE-DATE
          CREATE-TIME
          PROG-SEQ-NBR

AMDSET8   GL-COMPANY    Subset                                   AR197
          ACCT-UNIT     Where BAL-DATE = Zeroes
          ACCOUNT       And   STATUS   = 9
          SUB-ACCT
          DST-TYPE
          GL-DATE
          CREATE-DATE
          CREATE-TIME
          PROG-SEQ-NBR

                         ARDISTRIB FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Arcategory     ARCATEGORY   Required

                            AMD-COMPANY        -> ACA-COMPANY
                            AMD-AR-CATEGORY    -> ACA-AR-CATEGORY

Aroihdr        AROIHDR      Required

                            AMD-COMPANY        -> ARH-COMPANY
                            AMD-BATCH-NBR      -> ARH-BATCH-NBR
                            AMD-CUSTOMER       -> ARH-CUSTOMER
                            AMD-TRANS-TYPE     -> ARH-TRANS-TYPE
                            AMD-INVOICE        -> ARH-INVOICE

Arpayment      ARPAYMENT    Required
                            When AMD-TRANS-TYPE = "N"

                            AMD-COMPANY        -> APM-COMPANY
                            AMD-BATCH-NBR      -> APM-BATCH-NBR
                            AMD-TRANS-TYPE     -> APM-TRANS-TYPE
                            AMD-INVOICE        -> APM-TRANS-NBR
                            AMD-CUSTOMER       -> APM-CUSTOMER

Arudistrib     ARUDISTRIB   Not Required

                            AMD-COMPANY        -> DGM-COMPANY
                            AMD-BATCH-NBR      -> DGM-BATCH-NBR
                            AMD-TRANS-TYPE     -> DGM-TRANS-TYPE
                            AMD-INVOICE        -> DGM-INVOICE
                            AMD-CUSTOMER       -> DGM-CUSTOMER
                            AMD-DIST-SEQ       -> DGM-DIST-SEQ

Company        ARCOMP       Required

                            AMD-COMPANY        -> ACO-COMPANY

Custdesc       CUSTDESC     Required
                            When AMD-CUSTOMER != Spaces
                            Or   AMD-CUSTOMER != "000000000"

                            ACO-CUST-GROUP     -> CUD-CUST-GROUP
                            AMD-CUSTOMER       -> CUD-CUSTOMER

Customer       ARCUSTOMER   Required

                            AMD-COMPANY        -> ACM-COMPANY
                            AMD-CUSTOMER       -> ACM-CUSTOMER

Gl Comp        ARCOMP       Required

                            AMD-GL-COMPANY     -> ACO-COMPANY

Txtaxcode      TXTAXCODE    Required

                            AMD-COMPANY        -> TAC-COMPANY
                            AMD-TAX-CODE       -> TAC-TAX-CODE

                         ARDISTRIB FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Sltrans        SLTRANS

                            AMD-GLT-OBJ-ID     -> SLT-GLT-OBJ-ID
                                                  SLT-OBJ-ID