|
|
ARDFTSEL FILE
AR Obligations Selected-BOEs
The Bills of Exchange Select file is used in DT150 (Selection, Generation of
Bill Exchange) 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 The number representing an AR company.
ASL-TRANS-TYPE Alpha 1 DT150
Element: Transaction TyThe type of transaction being stored.
ASL-INVOICE Alpha 22 DT150
Element: Invoice Used 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 The user-entered draft number used for
record selection.
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 transaction code representing a type
of cash payment (with atributes for
either receiving AP payments, or
creating EFT payments), bill of
exchange bank service transaction.
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 The user-entered draft number used for
record selection.
ASL-PAYMENT-SEQ Numeric 6
Element: Payment SequenPayment Sequence. The generated
sequence number to separate individual
invoice payment requirements.
ASL-APPLD-AMT Signed 18.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 DT150
TRANS-TYPE
INVOICE
TRANS-SUFFIX
CUSTOMER
SELECTION-SEQ
ASLSET2 DRAFT-COMPANY DT150
DRAFT-CUSTOMER
BANK-INST-CODE
ORIG-CURRENCY
TRANS-TYPE
INVOICE
TRANS-SUFFIX
SELECTION-SEQ
ASLSET3 DRAFT-COMPANY DT150
DRAFT-CUSTOMER
DUE-DATE
BANK-INST-CODE
ORIG-CURRENCY
TRANS-TYPE
INVOICE
TRANS-SUFFIX
SELECTION-SEQ
ASLSET4 SELECTION-GRP KeyChange, Subset DT150
DRAFT-COMPANY Where SELECTION-GRP != Zeroes
DRAFT-CUSTOMER
TRANS-TYPE
INVOICE
TRANS-SUFFIX
SELECTION-SEQ
ASLSET5 DRAFT-COMPANY Subset DT150
DRAFT-CUSTOMERWhere TRANS-TYPE = "C"
ORIG-CURRENCY
TRANS-TYPE
INVOICE
SELECTION-SEQ
|
