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
Company Company number.
ASL-TRANS-TYPE Alpha 1 DT150
Transaction Type The type of transaction being stored.
ASL-INVOICE Alpha 22 DT150
Invoice Number Used to identify the invoice.
ASL-TRANS-NBR Alpha 10 (Right Justified)
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-AR-DRAFT-NBR Alpha 22
Ar Draft Nbr
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
Transaction Status The 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
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-INVOICE Alpha 22
Dr Invoice
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
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
|
