Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ARDRAFTS


                             ARDRAFTS FILE

                          AR Bill of Exchange

The AR Bills of Exchange file contains all system-generated bills of exchange
and released customer-generated bills of exchange.

REFERENCED BY

AR258     AR37.6    AR37.8    AR80.2    DT17.1    DT190
DT220     DT270     DT280     AR72.1    AR271     AR275
AR150     AR161     AR194     AR250     AR251     AR252
AR253     AR255     AR256     AR286     AR287     AR294
AR50.1    AR505     AR53.1    AR90.1    DT95.1

UPDATED BY

AR129     AR130     AR131     AR135     AR30.1    AR33.1
AR33.6    AR39.1    AR39.2    AR42.1    AR42.2    AR42.6
AR42.7    AR43.1    AR44.3    AR48.3    AR502     AR560
ARLL.1    DT150     DT155     DT160     DT161     DT165
DT166     DT170     DT180     DT181     DT185     DT30.1
DT30.2    DT40.1    DT42.1    DT45.1    DT520     DT60.1
DT60.2    DT70.1    DT70.3    DT80.1    DT85.1    DT85.2
DT90.1    DT92.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

ARD-COMPANY            Numeric 4                                 AR42.1  AR42.2
Element: Company       The company number represents an          AR42.6  AR42.7
                       established company. Must be a valid      AR43.1  AR44.3
                       record in the AR Company file.            AR502   AR560
                                                                 ARLL.1  DT150
                                                                 DT155   DT160
                                                                 DT165   DT166
                                                                 DT180   DT30.1
                                                                 DT30.2  DT40.1
                                                                 DT42.1  DT45.1
                                                                 DT520   DT60.1
                                                                 DT60.2  DT70.1
                                                                 DT70.3  DT80.1
                                                                 DT85.1  DT85.2
                                                                 DT92.1

ARD-AR-DRAFT-NBR       Alpha 22                                  AR42.1  AR42.2
Element: Ar Draft Nbr                                            AR42.6  AR42.7
                                                                 AR43.1  AR44.3
                                                                 AR502   AR560
                                                                 ARLL.1  DT150
                                                                 DT155   DT160
                                                                 DT165   DT166
                                                                 DT180   DT30.1
                                                                 DT30.2  DT40.1
                                                                 DT42.1  DT45.1
                                                                 DT520   DT60.1
                                                                 DT60.2  DT70.1
                                                                 DT70.3  DT80.1
                                                                 DT85.1  DT85.2
                                                                 DT92.1

ARD-SUFFIX             Numeric 3                                 AR42.1  AR42.2
Bill of Exchange       The bill of exchange suffix number.       AR42.6  AR42.7
Suffix                 Represents the occurrence value of the    AR43.1  AR44.3
                       bill of exchange. Used if a bill of       AR502   AR560
                       exchange is created for a single payment  ARLL.1  DT150
                       of a multiple payment invoice.            DT155   DT160
                                                                 DT165   DT166
                                                                 DT180   DT30.1
                                                                 DT30.2  DT40.1
                                                                 DT42.1  DT45.1
                                                                 DT520   DT60.1
                                                                 DT60.2  DT70.1
                                                                 DT70.3  DT80.1
                                                                 DT85.1  DT85.2
                                                                 DT92.1

ARD-CUSTOMER           Alpha 9  (Right Justified)                AR42.1  AR42.2
Element: Customer      The customer assigned to the bill of      AR42.6  AR42.7
                       exchange. Represents the customer         AR43.1  AR44.3
                       responsible for paying the bill of        AR502   AR560
                       exchange obligation. Must be a valid      ARLL.1  DT150
                       record in the AR Company Customer file.   DT155   DT160
                                                                 DT165   DT166
                                                                 DT180   DT30.1
                                                                 DT30.2  DT40.1
                                                                 DT42.1  DT45.1
                                                                 DT520   DT60.1
                                                                 DT60.2  DT70.1
                                                                 DT70.3  DT80.1
                                                                 DT85.1  DT85.2
                                                                 DT92.1

ARD-CANCEL-SEQ         Numeric 4                                 AR42.1  AR42.2
Element: Seq Nbr       An automatically assigned sequence        AR42.6  AR42.7
                       number.                                   AR43.1  AR44.3
                                                                 AR502   AR560
                                                                 ARLL.1  DT150
                                                                 DT155   DT160
                                                                 DT165   DT166
                                                                 DT180   DT30.1
                                                                 DT30.2  DT40.1
                                                                 DT42.1  DT45.1
                                                                 DT520   DT60.1
                                                                 DT60.2  DT70.1
                                                                 DT70.3  DT80.1
                                                                 DT85.1  DT85.2
                                                                 DT92.1

ARD-DRAFT-SOURCE       Alpha 1                                   AR42.1  AR42.2
Bill of Exchange       Indicates where the bill of exchange      AR42.6  AR42.7
Source                 originated. Valid values are:             AR43.1  AR44.3
                                                                 AR502   AR560
                       R = Receivable. The bill of exchange      ARLL.1  DT150
                       was created by the vendor (accounts       DT155   DT160
                       receivable).                              DT165   DT166
                                                                 DT180   DT30.1
                       P = Payable. The bill of exchange was     DT30.2  DT40.1
                       created by the customer (accounts         DT42.1  DT45.1
                       payable).                                 DT520   DT60.1
                                                                 DT60.2  DT70.1
                       I = Interfaced. The bill of exchange      DT70.3  DT80.1
                       was created by an interfacing system,     DT85.1  DT85.2
                       such as an order entry system.            DT92.1

ARD-APP-SEQ            Numeric 7                                 AR129   AR130
Element: Application SeThe counter for the number of             AR131   AR135
                       applications used in the Accounts         AR30.1  AR33.1
                       Receivable Application file.              AR33.6  AR39.1
                                                                 AR39.2  AR42.1
                                                                 AR42.2  AR42.6
                                                                 AR42.7  AR43.1
                                                                 AR44.3  AR48.3
                                                                 AR502   AR560
                                                                 ARLL.1  DT150
                                                                 DT155   DT160
                                                                 DT165   DT166
                                                                 DT180   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

ARD-PROCESS-LEVEL      Alpha 5                                   AR42.1  AR42.2
Element: Process Level The process level assigned to the bill    AR42.6  AR42.7
                       of exchange. Must be a valid record in    AR43.1  AR44.3
                       the AR Process Level file.                AR502   AR560
                                                                 ARLL.1  DT150
                                                                 DT155   DT160
                                                                 DT165   DT166
                                                                 DT180   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

ARD-BANK-INST-CODE     Alpha 3                                   AR42.1  AR42.2
Element: Payment Code  A transaction code representing a type    AR42.6  AR42.7
                       of cash payment (with atributes for       AR43.1  AR44.3
                       either receiving AP payments, or          AR502   AR560
                       creating EFT payments), bill of exchange  ARLL.1  DT150
                       payment, or bank service transaction.     DT155   DT160
                                                                 DT161   DT165
                                                                 DT166   DT180
                                                                 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

ARD-REMIT-COMPANY      Numeric 4                                 AR42.1  AR42.2
Element: Company       This field contains the remittance        AR42.6  AR42.7
                       company once the bill of exchange is      AR43.1  AR44.3
                       included in a remittance. Must be a       AR502   AR560
                       valid record in the AR Company file.      ARLL.1  DT150
                                                                 DT155   DT160
                                                                 DT161   DT165
                                                                 DT166   DT180
                                                                 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

ARD-REMIT-PROC-LEV     Alpha 5                                   AR42.1  AR42.2
Element: Process Level This field contains remittance process    AR42.6  AR42.7
                       level once the bill of exchange is        AR43.1  AR44.3
                       included in a remittance. Must be a       AR502   AR560
                       valid record in the AR Process Level      ARLL.1  DT150
                       file.                                     DT155   DT160
                                                                 DT161   DT165
                                                                 DT166   DT180
                                                                 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

ARD-CASH-CODE          Alpha 4                                   AR42.1  AR42.2
Element: Cash Code     The cash code (bank account) used for     AR42.6  AR42.7
                       depositing the bill of exchange. Must be  AR43.1  AR44.3
                       a valid record in the Cash Ledger Cash    AR502   AR560
                       Code file.                                ARLL.1  DT150
                                                                 DT155   DT160
                                                                 DT161   DT165
                                                                 DT166   DT180
                                                                 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

ARD-REMIT-TYPE         Alpha 1                                   AR42.1  AR42.2
Element: Remit Type    Indicates the type of remittance          AR42.6  AR42.7
                       associated with the bill of exchange.     AR43.1  AR44.3
                       Valid values are:                         AR502   AR560
                                                                 ARLL.1  DT150
                       D = Discounted remittance                 DT155   DT160
                                                                 DT161   DT165
                       E = Encashed remittance; full value       DT166   DT180
                       upon due date                             DT30.1  DT30.2
                                                                 DT40.1  DT45.1
                       Blank =  Not included in a remittance     DT520   DT60.1
                                                                 DT60.2  DT70.1
                                                                 DT70.3  DT80.1
                                                                 DT85.1  DT85.2
                                                                 DT92.1

ARD-REMIT-NBR          Numeric 7                                 AR42.1  AR42.2
Element: Remit Number  The remittance number assigned to the     AR42.6  AR42.7
                       bill of exchange when it is presented to  AR43.1  AR44.3
                       the bank for cashing as part of a         AR502   AR560
                       remittance.                               ARLL.1  DT150
                                                                 DT155   DT160
                                                                 DT161   DT165
                                                                 DT166   DT180
                                                                 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

ARD-GROUP-RATE         Signed 14.7                               AR42.1  AR42.2
Element: Group Rate    The exchange rate used to convert a       AR42.6  AR42.7
                       company base currency amount to the       AR43.1  AR44.3
                       customer group currency.                  AR502   AR560
                                                                 ARLL.1  DT150
                                                                 DT155   DT160
                                                                 DT165   DT166
                                                                 DT180   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

ARD-GROUP-MUDV         Alpha 1                                   AR42.1  AR42.2
Element: Group Mudv    The multiplier or divisor indicator for   AR42.6  AR42.7
                       the group rate.                           AR43.1  AR44.3
                                                                 AR502   AR560
                                                                 ARLL.1  DT150
                                                                 DT155   DT160
                                                                 DT165   DT166
                                                                 DT180   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

ARD-ORIG-CURRENCY      Alpha 5                                   AR42.1  AR42.2
Element: Transaction CuThe currency code assigned to the bill    AR42.6  AR42.7
                       of exchange. Represents the currency      AR43.1  AR44.3
                       that will be received upon cashing.       AR502   AR560
                                                                 ARLL.1  DT150
                                                                 DT155   DT160
                                                                 DT165   DT166
                                                                 DT180   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

ARD-CURR-MUDV          Alpha 1                                   AR42.1  AR42.2
Element: Curr Mudv     The multiplier or divisor indicator       AR42.6  AR42.7
                       used to convert the transaction currency  AR43.1  AR44.3
                       amount to the company base currency.      AR502   AR560
                                                                 ARLL.1  DT150
                                                                 DT155   DT160
                                                                 DT165   DT166
                                                                 DT180   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

ARD-ORIG-ND            Numeric 1                                 AR42.1  AR42.2
Trans Currency Nbr     The number of decimals defined for the    AR42.6  AR42.7
of Decimals            bill of exchange currency.                AR43.1  AR44.3
                                                                 AR502   AR560
                                                                 ARLL.1  DT150
                                                                 DT155   DT160
                                                                 DT165   DT166
                                                                 DT180   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

ARD-ORIG-RATE          Signed 14.7                               AR42.1  AR42.2
Trans Currency         The exchange rate used to convert the     AR42.6  AR42.7
Exchange Rate          bill of exchange currency to the company  AR43.1  AR44.3
                       base currency.                            AR502   AR560
                                                                 ARLL.1  DT150
                                                                 DT155   DT160
                                                                 DT165   DT166
                                                                 DT180   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

ARD-CASH-RATE          Signed 14.7                               AR42.1  AR42.2
Cashing Exchange       The currency exchange rate in effect      AR42.6  AR42.7
Rate                   when the bill of exchange was cashed.     AR43.1  AR44.3
                                                                 AR502   AR560
                                                                 ARLL.1  DT150
                                                                 DT155   DT160
                                                                 DT165   DT166
                                                                 DT180   DT181
                                                                 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

ARD-ORIG-AMT           Signed 18.2                               AR42.1  AR42.2
Bill of Exchange       The amount of the bill of exchange in     AR42.6  AR42.7
Amount                 the currency of the bill of exchange.     AR43.1  AR44.3
                                                                 AR502   AR560
                                                                 AR90.1  ARLL.1
                                                                 DT150   DT155
                                                                 DT160   DT165
                                                                 DT166   DT180
                                                                 DT30.1  DT30.2
                                                                 DT40.1  DT45.1
                                                                 DT520   DT60.1
                                                                 DT60.2  DT70.1
                                                                 DT70.3  DT80.1
                                                                 DT85.1  DT85.2
                                                                 DT90.1  DT92.1

ARD-TRAN-ND            Numeric 1                                 AR42.1  AR42.2
Base Currency Nbr      The number of decimals defined for the    AR42.6  AR42.7
of Decimals            company base currency.                    AR43.1  AR44.3
                                                                 AR502   AR560
                                                                 ARLL.1  DT150
                                                                 DT155   DT160
                                                                 DT165   DT166
                                                                 DT180   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

ARD-TRAN-AMT           Signed 18.2                               AR42.1  AR42.2
Base Currency BOE      The amount of the bill of exchange in     AR42.6  AR42.7
Amount                 the company base currency.                AR43.1  AR44.3
                                                                 AR502   AR560
                                                                 AR90.1  ARLL.1
                                                                 DT150   DT155
                                                                 DT160   DT165
                                                                 DT166   DT180
                                                                 DT30.1  DT30.2
                                                                 DT40.1  DT45.1
                                                                 DT520   DT60.1
                                                                 DT60.2  DT70.1
                                                                 DT70.3  DT80.1
                                                                 DT85.1  DT85.2
                                                                 DT90.1  DT92.1

ARD-DRAFT-DATE         Numeric 8  (yyyymmdd)                     AR42.1  AR42.2
Bill of Exchange       The date assigned to the bill of          AR42.6  AR42.7
Date                   exchange. Represents the date the bill    AR43.1  AR44.3
                       of exchange was created.                  AR502   AR560
                                                                 ARLL.1  DT150
                                                                 DT155   DT160
                                                                 DT165   DT166
                                                                 DT180   DT30.1
                                                                 DT30.2  DT40.1
                                                                 DT42.1  DT45.1
                                                                 DT520   DT60.1
                                                                 DT60.2  DT70.1
                                                                 DT70.3  DT80.1
                                                                 DT85.1  DT85.2
                                                                 DT92.1

ARD-MATURITY-DATE      Numeric 8  (yyyymmdd)                     AR42.1  AR42.2
Element: Due Date      The bill of exchange due date.            AR42.6  AR42.7
                       Indicates when the bill of exchange is    AR43.1  AR44.3
                       due to be paid in full.                   AR502   AR560
                                                                 ARLL.1  DT150
                                                                 DT155   DT160
                                                                 DT165   DT166
                                                                 DT180   DT30.1
                                                                 DT30.2  DT40.1
                                                                 DT42.1  DT45.1
                                                                 DT520   DT60.1
                                                                 DT60.2  DT70.1
                                                                 DT70.3  DT80.1
                                                                 DT85.1  DT85.2
                                                                 DT92.1

ARD-ACCEPT-DATE        Numeric 8  (yyyymmdd)                     AR42.1  AR42.2
Element: Acceptance DatThe acceptance date assigned to the       AR42.6  AR42.7
                       bill of exchange. Used only for bills of  AR43.1  AR44.3
                       exchange that require acceptance.         AR502   AR560
                                                                 ARLL.1  DT150
                                                                 DT155   DT160
                                                                 DT165   DT166
                                                                 DT180   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

ARD-ACCEPT-GL-DATE     Numeric 8  (yyyymmdd)                     AR42.1  AR42.2
Acceptance General     The date used for posting the             AR42.6  AR42.7
Ledger Date            acceptance of a bill of exchange to the   AR43.1  AR44.3
                       general ledger. Used only for bills of    AR502   AR560
                       exchange that require acceptance.         ARLL.1  DT150
                                                                 DT155   DT160
                                                                 DT165   DT166
                                                                 DT180   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

ARD-REMIT-DATE         Numeric 8  (yyyymmdd)                     AR42.1  AR42.2
Element: Remit Date    The remittance creation date for the      AR42.6  AR42.7
                       remittance associated with the bill of    AR43.1  AR44.3
                       exchange. Bills of exchange are grouped   AR502   AR560
                       into remittances to be presented to the   ARLL.1  DT150
                       bank for cashing.                         DT155   DT160
                                                                 DT165   DT166
                                                                 DT180   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

ARD-CASH-DATE          Numeric 8  (yyyymmdd)                     AR42.1  AR42.2
Element: Date          The date the bill of exchange was         AR42.6  AR42.7
                       cashed.                                   AR43.1  AR44.3
                                                                 AR502   AR560
                                                                 ARLL.1  DT150
                                                                 DT155   DT160
                                                                 DT165   DT166
                                                                 DT180   DT181
                                                                 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

ARD-DISHONOR-DATE      Numeric 8  (yyyymmdd)                     AR42.1  AR42.2
Element: Dishonor Date If the bill of exchange was dishonored,   AR42.6  AR42.7
                       this field contains the dishonor date     AR43.1  AR44.3
                       assigned to the bill of exchange.         AR502   AR560
                                                                 ARLL.1  DT150
                                                                 DT155   DT160
                                                                 DT165   DT166
                                                                 DT180   DT30.1
                                                                 DT30.2  DT40.1
                                                                 DT45.1  DT520
                                                                 DT60.1  DT60.2
                                                                 DT70.1  DT70.3
                                                                 DT80.1  DT85.1
                                                                 DT85.2  DT90.1
                                                                 DT92.1

ARD-CANCEL-DATE        Numeric 8  (yyyymmdd)                     AR42.1  AR42.2
Element: Cancel Date   If the bill of exchange was canceled,     AR42.6  AR42.7
                       this field contains the cancel date       AR43.1  AR44.3
                       assigned to the bill of exchange.         AR502   AR560
                                                                 ARLL.1  DT150
                                                                 DT155   DT160
                                                                 DT165   DT166
                                                                 DT180   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

ARD-RESOLVED-DATE      Numeric 8  (yyyymmdd)                     DT40.1  DT92.1
Element: Resolved Date If the bill of exchange was dishonored,
                       this field contains the date the
                       dishonored bill of exchange was
                       resolved.

ARD-STATUS             Numeric 1                                 AR42.1  AR42.2
Element: Status        Indicates the status of the bill of       AR42.6  AR42.7
                       exchange. Valid values are:               AR43.1  AR44.3
                                                                 AR502   AR560
                       0 = Created                               ARLL.1  DT150
                       1 = Accepted                              DT155   DT160
                       2 = Selected for Remittance               DT161   DT165
                       3 = Included in Remittance                DT166   DT170
                       4 = Presented                             DT180   DT181
                       6 = Cashed                                DT30.1  DT30.2
                       7 = Dishonored                            DT40.1  DT42.1
                       8 = Canceled                              DT45.1  DT520
                       9 = Historical                            DT60.1  DT60.2
                       5 = Created/unrel                         DT70.1  DT70.3
                                                                 DT80.1  DT85.1
                                                                 DT85.2  DT90.1
                                                                 DT92.1

ARD-PRINT-FLAG         Alpha 1                                   AR42.1  AR42.2
Element: Print Flag    Indicates whether the bill of exchange    AR42.6  AR42.7
                       has been created by DT155 (Bill of        AR43.1  AR44.3
                       Exchange Print - Tape Create). Valid      AR502   AR560
                       values are:                               ARLL.1  DT150
                                                                 DT155   DT160
                       N = No                                    DT165   DT166
                       Y = Yes                                   DT180   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

ARD-POSTAL-CODE        Alpha 10  (Lower Case)                    AR42.1  AR42.2
Element: Postal Code   The postal code of the customer's         AR42.6  AR42.7
                       payment bank.                             AR43.1  AR44.3
                                                                 AR502   AR560
                                                                 ARLL.1  DT150
                                                                 DT155   DT160
                                                                 DT165   DT166
                                                                 DT180   DT30.1
                                                                 DT30.2  DT40.1
                                                                 DT42.1  DT45.1
                                                                 DT520   DT60.1
                                                                 DT60.2  DT70.1
                                                                 DT70.3  DT80.1
                                                                 DT85.1  DT85.2
                                                                 DT92.1

ARD-BANK-ENTITY        Alpha 15                                  AR42.1  AR42.2
Element: Bank          The bank location the customer is         AR42.6  AR42.7
                       paying the bill of exchange from.         AR43.1  AR44.3
                                                                 AR502   AR560
                                                                 ARLL.1  DT150
                                                                 DT155   DT160
                                                                 DT165   DT166
                                                                 DT180   DT30.1
                                                                 DT30.2  DT40.1
                                                                 DT42.1  DT45.1
                                                                 DT520   DT60.1
                                                                 DT60.2  DT70.1
                                                                 DT70.3  DT80.1
                                                                 DT85.1  DT85.2
                                                                 DT92.1

ARD-BANK-ACCT-NBR      Alpha 35                                  AR42.1  AR42.2
Element: Bank Acct Nbr The bank account within the bank          AR42.6  AR42.7
                       location that the customer will be        AR43.1  AR44.3
                       paying the bill of exchange from.         AR502   AR560
                                                                 ARLL.1  DT150
                                                                 DT155   DT160
                                                                 DT165   DT166
                                                                 DT180   DT30.1
                                                                 DT30.2  DT40.1
                                                                 DT42.1  DT45.1
                                                                 DT520   DT60.1
                                                                 DT60.2  DT70.1
                                                                 DT70.3  DT80.1
                                                                 DT85.1  DT85.2
                                                                 DT92.1

ARD-ORIG-REV-AMT       Signed 18.2                               AR42.1  AR42.2
Element: Revenue AmountThe amount of additional revenue          AR42.6  AR42.7
                       charged to a customer for processing the  AR43.1  AR44.3
                       bill of exchange. This amount is in the   AR502   AR560
                       company base currency.                    ARLL.1  DT150
                                                                 DT155   DT160
                                                                 DT165   DT166
                                                                 DT180   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

ARD-REVENUE-AMT        Signed 18.2                               AR42.1  AR42.2
Base Currency          The amount of additional revenue          AR42.6  AR42.7
Revenue Amount         charged to customer for processing the    AR43.1  AR44.3
                       bill of exchange. This amount is in the   AR502   AR560
                       currency of the bill of exchange.         ARLL.1  DT150
                                                                 DT155   DT160
                                                                 DT165   DT166
                                                                 DT180   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

ARD-REV-ACCT-UNIT      Alpha 15                                  AR42.1  AR42.2
Revenue Accounting     The general ledger revenue accounting     AR42.6  AR42.7
Unit                   unit for the additional revenue charged.  AR43.1  AR44.3
                                                                 AR502   AR560
                                                                 ARLL.1  DT150
                                                                 DT155   DT160
                                                                 DT165   DT166
                                                                 DT180   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

ARD-REV-ACCOUNT        Numeric 6                                 AR42.1  AR42.2
Revenue Account        The general ledger revenue account        AR42.6  AR42.7
Number                 number for the additional revenue         AR43.1  AR44.3
                       charged.                                  AR502   AR560
                                                                 ARLL.1  DT150
                                                                 DT155   DT160
                                                                 DT165   DT166
                                                                 DT180   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

ARD-REV-SUB-ACCT       Numeric 4                                 AR42.1  AR42.2
Revenue Subaccount     The general ledger revenue subaccount     AR42.6  AR42.7
Number                 number for the additional revenue         AR43.1  AR44.3
                       charged.                                  AR502   AR560
                                                                 ARLL.1  DT150
                                                                 DT155   DT160
                                                                 DT165   DT166
                                                                 DT180   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

ARD-ORIG-BNK-EXP       Signed 18.2                               AR42.1  AR42.2
Element: Bank Expense AThe expense incurred in the process of    AR42.6  AR42.7
                       cashing the bill of exchange. This        AR43.1  AR44.3
                       amount is in the currency of the bill of  AR502   AR560
                       exchange.                                 ARLL.1  DT150
                                                                 DT155   DT160
                                                                 DT165   DT166
                                                                 DT180   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

ARD-BNK-EXP-AMT        Signed 18.2                               AR42.1  AR42.2
Base Currency Bank     The expense incurred in the process of    AR42.6  AR42.7
Expense Amt            cashing the bill of exchange. This        AR43.1  AR44.3
                       amount is in the company base currency.   AR502   AR560
                                                                 ARLL.1  DT150
                                                                 DT155   DT160
                                                                 DT165   DT166
                                                                 DT180   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

ARD-BEXP-ACCT-UNIT     Alpha 15                                  AR42.1  AR42.2
Element: Acct Unit     The accounting unit used for posting      AR42.6  AR42.7
                       the bank expenses.                        AR43.1  AR44.3
                                                                 AR502   AR560
                                                                 ARLL.1  DT150
                                                                 DT155   DT160
                                                                 DT165   DT166
                                                                 DT180   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

ARD-BEXP-ACCOUNT       Numeric 6                                 AR42.1  AR42.2
Bank Expense           The account number used for posting the   AR42.6  AR42.7
Account Number         bank expenses.                            AR43.1  AR44.3
                                                                 AR502   AR560
                                                                 ARLL.1  DT150
                                                                 DT155   DT160
                                                                 DT165   DT166
                                                                 DT180   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

ARD-BEXP-SUB-ACCT      Numeric 4                                 AR42.1  AR42.2
Bank Expense           The subaccount number used for posting    AR42.6  AR42.7
Subaccount Number      the bank expenses.                        AR43.1  AR44.3
                                                                 AR502   AR560
                                                                 ARLL.1  DT150
                                                                 DT155   DT160
                                                                 DT165   DT166
                                                                 DT180   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

ARD-ORIG-DIS-EXP       Signed 18.2                               AR42.1  AR42.2
Dishonor Expense       The amount of expense incurred during     AR42.6  AR42.7
Amount                 the dishonoring of the bill of exchange.  AR43.1  AR44.3
                       This amount is in the currency of the     AR502   AR560
                       bill of exchange.                         ARLL.1  DT150
                                                                 DT155   DT160
                                                                 DT165   DT166
                                                                 DT180   DT30.1
                                                                 DT30.2  DT40.1
                                                                 DT45.1  DT520
                                                                 DT60.1  DT60.2
                                                                 DT70.1  DT70.3
                                                                 DT80.1  DT85.1
                                                                 DT85.2  DT90.1
                                                                 DT92.1

ARD-DIS-EXP-AMT        Signed 18.2                               AR42.1  AR42.2
Base Curr Dishonor     The amount of the expense incurred        AR42.6  AR42.7
Expense Amt            during the dishonoring of the bill of     AR43.1  AR44.3
                       exchange. This amount is in the company   AR502   AR560
                       base currency.                            ARLL.1  DT150
                                                                 DT155   DT160
                                                                 DT165   DT166
                                                                 DT180   DT30.1
                                                                 DT30.2  DT40.1
                                                                 DT45.1  DT520
                                                                 DT60.1  DT60.2
                                                                 DT70.1  DT70.3
                                                                 DT80.1  DT85.1
                                                                 DT85.2  DT90.1
                                                                 DT92.1

ARD-DEXP-ACCT-UNIT     Alpha 15                                  AR42.1  AR42.2
Dishonor Expense       The accounting unit used for posting      AR42.6  AR42.7
Accounting Un          the dishonor expense.                     AR43.1  AR44.3
                                                                 AR502   AR560
                                                                 ARLL.1  DT150
                                                                 DT155   DT160
                                                                 DT165   DT166
                                                                 DT180   DT30.1
                                                                 DT30.2  DT40.1
                                                                 DT45.1  DT520
                                                                 DT60.1  DT60.2
                                                                 DT70.1  DT70.3
                                                                 DT80.1  DT85.1
                                                                 DT85.2  DT90.1
                                                                 DT92.1

ARD-DEXP-ACCOUNT       Numeric 6                                 AR42.1  AR42.2
Dishonor Expense       The account number used for posting the   AR42.6  AR42.7
Account                dishonor expense.                         AR43.1  AR44.3
                                                                 AR502   AR560
                                                                 ARLL.1  DT150
                                                                 DT155   DT160
                                                                 DT165   DT166
                                                                 DT180   DT30.1
                                                                 DT30.2  DT40.1
                                                                 DT45.1  DT520
                                                                 DT60.1  DT60.2
                                                                 DT70.1  DT70.3
                                                                 DT80.1  DT85.1
                                                                 DT85.2  DT90.1
                                                                 DT92.1

ARD-DEXP-SUB-ACCT      Numeric 4                                 AR42.1  AR42.2
Dishonor Expense       The subaccount number used for posting    AR42.6  AR42.7
Subaccount             the dishonor expense.                     AR43.1  AR44.3
                                                                 AR502   AR560
                                                                 ARLL.1  DT150
                                                                 DT155   DT160
                                                                 DT165   DT166
                                                                 DT180   DT30.1
                                                                 DT30.2  DT40.1
                                                                 DT45.1  DT520
                                                                 DT60.1  DT60.2
                                                                 DT70.1  DT70.3
                                                                 DT80.1  DT85.1
                                                                 DT85.2  DT90.1
                                                                 DT92.1

ARD-DRAFT-CODE         Alpha 4                                   AR42.1  AR42.2
Bill of Exchange       The bill of exchange receivable code      AR42.6  AR42.7
Code                   used for posting the bill of exchange to  AR43.1  AR44.3
                       the general ledger. This will be filled   AR502   AR560
                       if the asset has been transferred from    ARLL.1  DT150
                       Accounts Receivable to Bill of Exchange   DT155   DT160
                       Receivable.                               DT165   DT166
                                                                 DT180   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

ARD-CASH-UPDATE-FL     Alpha 1                                   AR42.1  AR42.2
Element: Cashing UpdateIndicates whether the bill of exchange    AR42.6  AR42.7
                       has been processed through DT180 (Bank    AR43.1  AR44.3
                       Presentation, Cashing Update). Valid      AR502   AR560
                       values are:                               ARLL.1  DT150
                                                                 DT155   DT160
                       N = No                                    DT165   DT166
                       Y = Yes                                   DT180   DT181
                                                                 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

ARD-AR-CODE            Alpha 4                                   AR42.1  AR42.2
Element: Ar Code       The accounts receivable code assigned     AR42.6  AR42.7
                       to the bill of exchange during creation.  AR43.1  AR44.3
                       If the bill of exchange is for one        AR502   AR560
                       invoice, the account receivable code      ARLL.1  DT150
                       assigned to the invoice is used. If the   DT155   DT160
                       bill of exchange is for more than one     DT165   DT166
                       invoice, the accounts receivable code     DT180   DT30.1
                       assigned to the process level is used.    DT30.2  DT40.1
                                                                 DT45.1  DT520
                                                                 DT60.1  DT60.2
                                                                 DT70.1  DT70.3
                                                                 DT80.1  DT85.1
                                                                 DT85.2  DT92.1

ARD-DRAFT-REF          Numeric 10                                AR42.1  AR42.2
Bill of Exchange       An optional reference number assigned     AR42.6  AR42.7
Reference Nbr          to the bill of exchange.                  AR43.1  AR44.3
                                                                 AR502   AR560
                                                                 ARLL.1  DT150
                                                                 DT155   DT160
                                                                 DT165   DT166
                                                                 DT180   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

ARD-UNPAYMENT-CODE     Alpha 4                                   AR42.1  AR42.2
Element: Dishonored CodThe general ledger code used in the       AR42.6  AR42.7
                       dishonoring of a bill of exchange.        AR43.1  AR44.3
                                                                 AR502   AR560
                                                                 ARLL.1  DT150
                                                                 DT155   DT160
                                                                 DT165   DT166
                                                                 DT180   DT30.1
                                                                 DT30.2  DT40.1
                                                                 DT45.1  DT520
                                                                 DT60.1  DT60.2
                                                                 DT70.1  DT70.3
                                                                 DT80.1  DT85.1
                                                                 DT85.2  DT90.1
                                                                 DT92.1

ARD-RISK-FL            Alpha 1                                   AR42.1  AR42.2
Element: Risk Flag     Indicates whether the bill of exchange    AR42.6  AR42.7
                       is at risk with the bank (cashed at a     AR43.1  AR44.3
                       discount before its due date and has not  AR502   AR560
                       yet reached its due date). Valid values   ARLL.1  DT150
                       are:                                      DT155   DT160
                                                                 DT165   DT166
                       N = No                                    DT170   DT180
                       Y = Yes                                   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

ARD-DIS-UPDATE-FL      Alpha 1                                   AR42.1  AR42.2
Dishonored Update      Indicates whether a dishonored bill of    AR42.6  AR42.7
Flag                   exchange has been processed by DT180      AR43.1  AR44.3
                       (Bank Presentation, Cashing Update).      AR502   AR560
                       Valid values are:                         ARLL.1  DT150
                                                                 DT155   DT160
                       Blank = Not dishonored                    DT165   DT166
                       P = Post presented BOE                    DT180   DT185
                       R = Post cash at risk BOE                 DT30.1  DT30.2
                                                                 DT40.1  DT45.1
                                                                 DT520   DT60.1
                                                                 DT60.2  DT70.1
                                                                 DT70.3  DT80.1
                                                                 DT85.1  DT85.2
                                                                 DT90.1  DT92.1

ARD-PRES-UPDATE-FL     Alpha 1                                   AR42.1  AR42.2
Presentation Update    Indicates whether the bill of exchange    AR42.6  AR42.7
Flag                   presentation has been processed by DT180  AR43.1  AR44.3
                       (Bank Presentation, Cashing Update).      AR502   AR560
                       Valid values  are:                        ARLL.1  DT150
                                                                 DT155   DT160
                       N = No                                    DT165   DT166
                       Y = Yes                                   DT180   DT181
                                                                 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

ARD-RESOLUTION-FL      Alpha 1                                   AR42.1  AR42.2
Dishonored             If the bill of exchange has been          AR42.6  AR42.7
Resolution Flag        dishonored, this field indicates how the  AR43.1  AR44.3
                       dishonored bill of exchange was           AR502   AR560
                       resolved. Valid values are:               ARLL.1  DT150
                                                                 DT155   DT160
                       Blank = Not resolved                      DT165   DT166
                       1 = Cashed                                DT180   DT30.1
                       2 = Written Off                           DT30.2  DT40.1
                       3 = Renegotiated                          DT45.1  DT520
                                                                 DT60.1  DT60.2
                                                                 DT70.1  DT70.3
                                                                 DT80.1  DT85.1
                                                                 DT85.2  DT92.1

ARD-COMMENT-CD         Numeric 3                                 AR42.1  AR42.2
Element: Comment Cd    Indicates the number of comment lines     AR42.6  AR42.7
                       that have been created for a bill of      AR43.1  AR44.3
                       exchange.                                 AR502   AR560
                                                                 ARLL.1  DT150
                                                                 DT155   DT160
                                                                 DT165   DT166
                                                                 DT180   DT30.1
                                                                 DT30.2  DT40.1
                                                                 DT42.1  DT45.1
                                                                 DT520   DT60.1
                                                                 DT60.2  DT70.1
                                                                 DT70.3  DT80.1
                                                                 DT85.1  DT85.2
                                                                 DT92.1

ARD-STATUS-DATE        Derived
Element: Status Date   This derived field indicates the date
                       the system assigned the bill of exchange
                       its current status. This field changes
                       each time the bill of exchange status
                       changes as it proceeds along its cycle.

ARD-RESOLVED-STS       Derived
Element: Resolved StatuThis derived field indicates the type
                       of resolution associated with a
                       dishonored bill of exchange.

ARD-JRNL-BOOK-NBR      Alpha 12                                  AR42.1  AR42.2
Element: Jrnl Book Nbr The journal book assigned to the bill     AR42.6  AR42.7
                       of exchange.                              AR43.1  AR44.3
                                                                 AR502   AR560
                                                                 ARLL.1  DT150
                                                                 DT155   DT160
                                                                 DT165   DT166
                                                                 DT180   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

ARD-PAYER-REF          Alpha 10                                  AR42.1  AR42.2
Element: Payer's RefereContains bank reference information for   AR42.6  AR42.7
                       manually entered bills of exchange.       AR43.1  AR44.3
                                                                 AR502   AR560
                                                                 ARLL.1  DT150
                                                                 DT155   DT160
                                                                 DT165   DT166
                                                                 DT180   DT30.1
                                                                 DT30.2  DT40.1
                                                                 DT42.1  DT45.1
                                                                 DT520   DT60.1
                                                                 DT60.2  DT70.1
                                                                 DT70.3  DT80.1
                                                                 DT85.1  DT85.2
                                                                 DT92.1

ARD-PMT-BATCH-NBR      Numeric 6                                 AR42.1  AR42.2
Element: Pmt Batch Nbr The draft batch number which is also      AR42.6  AR42.7
                       used as the batch number when creating    AR43.1  AR44.3
                       payment records.                          AR502   AR560
                                                                 ARLL.1  DT150
                                                                 DT155   DT160
                                                                 DT165   DT166
                                                                 DT180   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

ARD-ORIG-APP-AMT       Signed 18.2                               AR129   AR130
Element: Intl Amt                                                AR131   AR135
                                                                 AR30.1  AR33.1
                                                                 AR33.6  AR39.1
                                                                 AR39.2  AR42.1
                                                                 AR42.2  AR42.6
                                                                 AR42.7  AR43.1
                                                                 AR44.3  AR48.3
                                                                 AR502   AR560
                                                                 ARLL.1  DT150
                                                                 DT155   DT160
                                                                 DT165   DT166
                                                                 DT180   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

ARD-APPLD-AMT          Signed 18.2                               AR129   AR130
Element: Intl Amt                                                AR131   AR135
                                                                 AR30.1  AR33.1
                                                                 AR33.6  AR39.1
                                                                 AR39.2  AR42.1
                                                                 AR42.2  AR42.6
                                                                 AR42.7  AR43.1
                                                                 AR44.3  AR48.3
                                                                 AR502   AR560
                                                                 ARLL.1  DT150
                                                                 DT155   DT160
                                                                 DT165   DT166
                                                                 DT180   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

                         ARDRAFTS FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

ARDSET1   COMPANY                                                AR258   AR37.6
          AR-DRAFT-NBR                                           AR37.8  AR42.1
          SUFFIX                                                 AR42.2  AR42.6
          CUSTOMER                                               AR42.7  AR43.1
          CANCEL-SEQ                                             AR44.3  AR502
          DRAFT-SOURCE                                           AR560   AR80.2
                                                                 ARLL.1  DT150
                                                                 DT155   DT160
                                                                 DT161   DT165
                                                                 DT166   DT17.1
                                                                 DT170   DT180
                                                                 DT185   DT190
                                                                 DT220   DT270
                                                                 DT280   DT30.1
                                                                 DT30.2  DT40.1
                                                                 ...

ARDSET10  COMPANY       Subset                                   AR42.1  AR42.2
          AR-DRAFT-NBR  Where BANK-INST-CODE != Spaces           AR42.6  AR42.7
          SUFFIX                                                 AR43.1  AR44.3
          CUSTOMER                                               AR502   AR560
          CANCEL-SEQ                                             ARLL.1  DT150
          DRAFT-SOURCE                                           DT155   DT160
          BANK-INST-CODE                                         DT165   DT166
                                                                 DT180   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

ARDSET2   COMPANY       Subset                                   AR42.1  AR42.2
          CUSTOMER      Where STATUS = Zeroes                    AR42.6  AR42.7
          MATURITY-DATE Or    STATUS = 1                         AR43.1  AR44.3
          AR-DRAFT-NBR                                           AR502   AR560
          SUFFIX                                                 AR72.1  ARLL.1
                                                                 DT150   DT155
                                                                 DT160   DT165
                                                                 DT166   DT180
                                                                 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

ARDSET3   REMIT-COMPANY Subset                                   AR42.1  AR42.2
          REMIT-PROC-LEVWhere STATUS = 1                         AR42.6  AR42.7
          CASH-CODE     Or    STATUS = 2                         AR43.1  AR44.3
          REMIT-TYPE                                             AR502   AR560
          MATURITY-DATE                                          ARLL.1  DT150
          CUSTOMER                                               DT155   DT160
          AR-DRAFT-NBR                                           DT161   DT165
          SUFFIX                                                 DT166   DT180
                                                                 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

ARDSET4   REMIT-COMPANY Subset                                   AR42.1  AR42.2
          REMIT-PROC-LEVWhere STATUS = 1                         AR42.6  AR42.7
          CASH-CODE     Or    STATUS = 2                         AR43.1  AR44.3
          REMIT-TYPE                                             AR502   AR560
          AR-DRAFT-NBR                                           ARLL.1  DT150
          SUFFIX                                                 DT155   DT160
          CUSTOMER                                               DT165   DT166
          MATURITY-DATE                                          DT180   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

ARDSET5   REMIT-COMPANY Subset                                   AR42.1  AR42.2
          REMIT-PROC-LEVWhere REMIT-NBR != Zeroes                AR42.6  AR42.7
          REMIT-NBR                                              AR43.1  AR44.3
          CUSTOMER                                               AR502   AR560
          AR-DRAFT-NBR                                           ARLL.1  DT150
          SUFFIX                                                 DT155   DT160
          COMPANY                                                DT165   DT166
          CANCEL-SEQ                                             DT180   DT181
          DRAFT-SOURCE                                           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

ARDSET6   COMPANY       Subset                                   AR271   AR275
          CUSTOMER      Where  STATUS        < 7                 DT180
          AR-DRAFT-NBR  Or    (STATUS        = 7
          SUFFIX        And    RESOLUTION-FL = Spaces )
          CANCEL-SEQ
          DRAFT-SOURCE

ARDSET7   COMPANY       KeyChange, Subset                        DT40.1
          CUSTOMER      Where STATUS  < 7
          AR-DRAFT-NBR  Or    STATUS  = 6
          SUFFIX        And   RISK-FL = "Y"

ARDSET8   COMPANY       Subset                                   DT92.1
          CUSTOMER      Where STATUS        =  7
          AR-DRAFT-NBR  And   RESOLUTION-FL != "1"
          SUFFIX        And   RESOLUTION-FL != "2"
          MATURITY-DATE And   RESOLUTION-FL != "3"

ARDSET9   COMPANY                                                AR129   AR130
          CUSTOMER                                               AR131   AR135
          AR-DRAFT-NBR                                           AR150   AR161
          SUFFIX                                                 AR194   AR250
          CANCEL-SEQ                                             AR251   AR252
          DRAFT-SOURCE                                           AR253   AR255
                                                                 AR256   AR286
                                                                 AR287   AR294
                                                                 AR30.1  AR33.1
                                                                 AR33.6  AR39.1
                                                                 AR39.2  AR48.3
                                                                 AR50.1  AR505
                                                                 AR53.1  AR90.1
                                                                 DT180   DT185
                                                                 DT270   DT280
                                                                 ...

                         ARDRAFTS FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Arcomp         ARCOMP       Required

                            ARD-COMPANY           -> ACO-COMPANY

Arcustgrp      ARCUSTGRP    Required

                            ACO-CUST-GROUP        -> ACG-CUST-GROUP

Arcustomer     ARCUSTOMER   Required

                            ARD-COMPANY           -> ACM-COMPANY
                            ARD-CUSTOMER          -> ACM-CUSTOMER

Cbbankinst     CBBANKINST   Required

                            ARD-BANK-INST-CODE    -> CBI-BANK-INST-CODE

Cbcpycash      CBCPYCASH    Required
                            When ARD-STATUS >  2
                            And  ARD-STATUS != 8

                            ARD-COMPANY           -> CBY-COMPANY
                            ARD-CASH-CODE         -> CBY-CASH-CODE

Cust Bankent   CBBANKENT    Required

                            DTB-BANK-ENTITY       -> CBE-BANK-ENTITY

Custdesc       CUSTDESC     Required

                            ACO-CUST-GROUP        -> CUD-CUST-GROUP
                            ARD-CUSTOMER          -> CUD-CUSTOMER

Dtcustbank     DTCUSTBANK   Required

                            ACO-CUST-GROUP        -> DTB-CUST-GROUP
                            ARD-COMPANY           -> DTB-COMPANY
                            ARD-CUSTOMER          -> DTB-CUSTOMER

Dtremit        DTREMIT      Required
                            When ARD-REMIT-NBR != Zeroes

                            ARD-REMIT-COMPANY     -> DRM-COMPANY
                            ARD-REMIT-PROC-LEV    -> DRM-PROCESS-LEVEL
                            ARD-CASH-CODE         -> DRM-CASH-CODE
                            ARD-REMIT-TYPE        -> DRM-REMIT-TYPE
                            ARD-REMIT-NBR         -> DRM-REMIT-NBR
                            ARD-MATURITY-DATE     -> DRM-MATURITY-DATE

Glsystem       GLSYSTEM     Required

                            ARD-COMPANY           -> GLS-COMPANY

                         ARDRAFTS FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Arapplied      ARAPPLIED    Delete Restricted

                            ARD-COMPANY           -> ARA-CR-COMPANY
                            ARD-CUSTOMER          -> ARA-CR-CUSTOMER
                            "B"                   -> ARA-CR-TYPE
                            ARD-AR-DRAFT-NBR      -> ARA-CR-NBR
                            Zeroes                -> ARA-CR-PYMNT-SEQ
                            Zeroes                -> ARA-CR-BATCH
                            ARD-SUFFIX            -> ARA-CR-SUFFIX
                            ARD-CANCEL-SEQ        -> ARA-CR-CANCEL-SEQ
                                                     ARA-CR-APP-SEQ

Dtcomment      DTCOMMENT    Delete Cascades

                            ARD-COMPANY           -> DMT-COMPANY
                            ARD-CUSTOMER          -> DMT-CUSTOMER
                            ARD-AR-DRAFT-NBR      -> DMT-AR-DRAFT-NBR
                            ARD-SUFFIX            -> DMT-SUFFIX
                            ARD-DRAFT-SOURCE      -> DMT-DRAFT-SOURCE
                                                     DMT-SEQ-NBR

Dtcredit       DTCREDIT

                            ARD-COMPANY           -> DTX-COMPANY
                            ARD-AR-DRAFT-NBR      -> DTX-AR-DRAFT-NBR
                            ARD-SUFFIX            -> DTX-SUFFIX
                            ARD-CUSTOMER          -> DTX-CUSTOMER
                            ARD-CANCEL-SEQ        -> DTX-CANCEL-SEQ
                            ARD-DRAFT-SOURCE      -> DTX-DRAFT-SOURCE
                                                     DTX-APP-SEQ