Lawson Insight Technical Documentation


ERDs Tables Elements Libraries App Forms

                             ARDFTSEL FILE

                      AR Obligations Selected-BOEs

AR Obligations Selected-BOEs

UPDATED BY

DT150     DT40.1    DT520

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

ASL-COMPANY          Numeric 4                                   DT150
Company              Company number.

ASL-TRANS-TYPE       Alpha 1                                     DT150
Transaction Type     The type of transaction being stored.

ASL-TRANS-NBR        Alpha 10  (Right Justified)                 DT150
Transaction Number   Represents a unique user-defined value
                     identifying the transaction.

ASL-TRANS-SUFFIX     Numeric 3                                   DT150
Transaction Suffix   The sequence number of each obligation
                     selected.

ASL-CUSTOMER         Alpha 9  (Right Justified)                  DT150
Customer             This field contains the number that
                     represents a customer.

ASL-SELECTION-SEQ    Numeric 7                                   DT150
Selection Sequence   The sequence number of the record
                     within the selection group.

ASL-SELECTION-GRP    Numeric 10                                  DT150
Selection Group      Used to group selections together based
                     on the criteria used to build the
                     selection file.

ASL-DRAFT-NBR        Alpha 10  (Right Justified)
Bill of Exchange     The bill of exchange number for the
Number               select record.

ASL-SUFFIX           Numeric 3
Invoice Suffix       The occurrence value.

ASL-DRAFT-COMPANY    Numeric 4                                   DT150
Bill of Exchange     The company which owns the bill of
Company              exchange.

ASL-DRAFT-CUSTOMER   Alpha 9  (Right Justified)                  DT150
Bill of Exchange     The customer which owns the bill of
Customer             exchange.

ASL-PROCESS-LEVEL    Alpha 5                                     DT150
Process Level        The process level, which is the
                     reporting hierarchy below company.

ASL-BANK-INST-CODE   Alpha 3                                     DT150
Payment Code         A user-defined value representing a
                     specific banking transaction. There are
                     three categories of bank transactions:
                     cash payments, bill of exchange
                     payments, and miscellaneous non-payment
                     bank transactions.

ASL-DUE-DATE         Numeric 8  (yyyymmdd)                       DT150
Due Date             The due date of the selected
                     obligation.

ASL-ORIG-CURRENCY    Alpha 5                                     DT150
Transaction Currency The transaction currency of the
                     selected obligation.

ASL-STATUS           Numeric 1                                   DT150   DT40.1
Transaction Status   The status of the transaction. Valid        DT520
                     values are:

                     0 = Created
                     1 = In dispute
                     2 = Transaction date
                     3 = Due date
                     4 = GL date
                     5 = Bill of exchange not created
                     6 = Selected for other BOE
                     7 = Customer generated BOE

ASL-NAT-FLAG         Alpha 1                                     DT150
National Account     The national account flag of the
Flag                 transaction customer.

ASL-GROUPING         Alpha 1                                     DT150
Grouping             Indicates if the selections are being
                     grouped by due date or national account.


ASL-DR-COMPANY       Numeric 4
Debit Company        The debit company.

ASL-DR-CUSTOMER      Alpha 9  (Right Justified)
Debit Customer       The debit customer.

ASL-DR-TRANS-TYPE    Alpha 1
Debit Transaction    The debit transaction type.
Type

ASL-DR-TRANS-NBR     Alpha 10
Debit Transaction    The debit transaction number.
Number

ASL-PAYMENT-SEQ      Numeric 6
Payment Sequence     Payment Sequence. The generated
                     sequence number to separate individual
                     invoice payment requirements.

ASL-APPLD-AMT        Signed 15.2
Applied Amount       The amount to be applied to the debit
                     transaction.

                         ARDFTSEL FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

ASLSET1   COMPANY       The path is used to keep records unique  DT150
          TRANS-TYPE    and to read previously selected bill of
          TRANS-NBR     exchange records.
          TRANS-SUFFIX
          CUSTOMER
          SELECTION-SEQ

ASLSET2   DRAFT-COMPANY The path is used to read selected group  DT150
          DRAFT-CUSTOMERrecords.
          BANK-INST-CODE
          ORIG-CURRENCY
          TRANS-TYPE
          TRANS-NBR
          TRANS-SUFFIX
          SELECTION-SEQ

ASLSET3   DRAFT-COMPANY The path is used to read due date        DT150
          DRAFT-CUSTOMERselected records.
          DUE-DATE
          BANK-INST-CODE
          ORIG-CURRENCY
          TRANS-TYPE
          TRANS-NBR
          TRANS-SUFFIX
          SELECTION-SEQ

ASLSET4   SELECTION-GRP The path is used to read multi selected  DT150   DT40.1
          DRAFT-COMPANY created bills of exchange.               DT520
          DRAFT-CUSTOMERKeyChange, Subset
          TRANS-TYPE    Where SELECTION-GRP != Zeroes
          TRANS-NBR
          TRANS-SUFFIX
          SELECTION-SEQ

ASLSET5   DRAFT-COMPANY The path is used to read selected group  DT150   DT40.1
          DRAFT-CUSTOMERrecords.                                 DT520
          ORIG-CURRENCY Subset
          TRANS-TYPE    Where TRANS-TYPE = "C"
          TRANS-NBR
          SELECTION-SEQ

ASLSET6   DRAFT-COMPANY The path is used to read single bill of
          DRAFT-CUSTOMERexchange created records.
          DRAFT-NBR
          SUFFIX
          TRANS-TYPE
          TRANS-NBR
          TRANS-SUFFIX
          SELECTION-SEQ