Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ARDFTSEL


                             ARDFTSEL FILE

                      AR Obligations Selected-BOEs

The AR Obligations Selected - BOEs file is used in DT150 (Selection,
Generation of Bill Exchange) of to store data for invoices, debit memos, and
credit memos which will be grouped together into a bill of exchange upon
generation. After the bill of exchange has been generated, the bill of
exchange select file record will be deleted.

UPDATED BY

DT150

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

ASL-COMPANY            Numeric 4                                 DT150
Element: Company       Company number.

ASL-TRANS-TYPE         Alpha 1                                   DT150
Element: Transaction TyThe type of transaction being stored.

ASL-INVOICE            Alpha 22                                  DT150
Element: Invoice NumberUsed to identify the invoice.

ASL-TRANS-NBR          Alpha 10  (Right Justified)
Element: Transaction NuRepresents a unique user-defined value
                       identifying the transaction.

ASL-TRANS-SUFFIX       Numeric 3                                 DT150
Element: Transaction SuThe sequence number of each obligation
                       selected.

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

ASL-SELECTION-SEQ      Numeric 7                                 DT150
Element: Selection SequThe sequence number of the record
                       within the selection group.

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

ASL-AR-DRAFT-NBR       Alpha 22
Element: Ar Draft Nbr

ASL-SUFFIX             Numeric 3
Element: Invoice SuffixThe 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
Element: Process Level The process level, which is the
                       reporting hierarchy below company.

ASL-BANK-INST-CODE     Alpha 3                                   DT150
Element: 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
Element: Due Date      The due date of the selected
                       obligation.

ASL-ORIG-CURRENCY      Alpha 5                                   DT150
Element: Transaction CuThe transaction currency of the
                       selected obligation.

ASL-STATUS             Numeric 1                                 DT150
Element: Transaction StThe status of the transaction. Valid
                       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
Element: Grouping      Indicates if the selections are being
                       grouped by due date or national account.


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

ASL-DR-CUSTOMER        Alpha 9  (Right Justified)
Element: Debit CustomerThe debit customer.

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

ASL-DR-INVOICE         Alpha 22
Element: Invoice Number

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

ASL-APPLD-AMT          Signed 15.2
Element: Applied AmountThe 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
          INVOICE       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
          INVOICE
          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
          INVOICE
          TRANS-SUFFIX
          SELECTION-SEQ

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

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

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

ASLSET7   SELECTION-GRP This index was created as a solution to
          DRAFT-COMPANY the Find Next/Prev Flag error. It is
          DRAFT-CUSTOMERonly used where a modify must be done
          TRANS-TYPE    within a 850-FIND-NLT or 850-Find-BEGRNG
          INVOICE       loop.
          SELECTION-SEQ Subset
          TRANS-SUFFIX  Where SELECTION-GRP != Zeroes