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 AR73.1 AR80.2 DT17.1 DT190 DT220 DT270 DT280 DT95.1 AR271 AR275 AR72.1 AR150 AR161 AR194 AR250 AR251 AR252 AR253 AR255 AR256 AR286 AR287 AR294 AR50.1 AR505 AR53.1 AR90.1 UPDATED BY AR130 AR131 AR135 AR30.3 AR31.6 AR42.1 AR42.2 AR42.6 AR42.7 AR43.1 AR44.3 AR502 AR560 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 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 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-NBR Alpha 10 (Right Justified) AR42.1 AR42.2 Bill of Exchange The number assigned to the bill of AR42.6 AR42.7 Number exchange. AR43.1 AR44.3 AR502 AR560 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 DT150 DT155 of a multiple payment invoice. 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 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 DT150 DT155 record in the AR Company Customer file. 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 Cancel Sequence The sequence number assigned upon a AR42.6 AR42.7 cancellation of a distributed invoice. AR43.1 AR44.3 The first sequence assigned is 9999. AR502 AR560 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 DT150 DT155 was created by the vendor (accounts DT160 DT165 receivable). DT166 DT180 DT30.1 DT30.2 P = Payable. The bill of exchange was DT40.1 DT42.1 created by the customer (accounts DT45.1 DT520 payable). DT60.1 DT60.2 DT70.1 DT70.3 I = Interfaced. The bill of exchange DT80.1 DT85.1 was created by an interfacing system, DT85.2 DT92.1 such as an order entry system. ARD-APP-SEQ Numeric 5 AR130 AR131 Application Sequence The counter for the number of AR135 AR30.3 applications used in the Accounts AR31.6 AR42.1 Receivable Application file. AR42.2 AR42.6 AR42.7 AR43.1 AR44.3 AR502 AR560 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 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 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 Payment Code The bill of exchange payment AR42.6 AR42.7 transaction code assigned to the bill of AR43.1 AR44.3 exchange. Represents the type of bill of AR502 AR560 exchange payment. Must be a valid record DT150 DT155 in the Cash Ledger Bank Transaction Code DT160 DT161 file. 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 Remittance 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. 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 Remittance Process This field contains remittance process AR42.6 AR42.7 Level 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 DT150 DT155 file. 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 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. 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 Remittance 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 DT150 DT155 D = Discounted remittance DT160 DT161 DT165 DT166 E = Encashed remittance; full value DT180 DT30.1 upon due date DT30.2 DT40.1 DT45.1 DT520 Blank = Not included in a remittance 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 Remittance 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. 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 12.6 AR42.1 AR42.2 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 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 Group The multiplier or divisor indicator for AR42.6 AR42.7 Multiply/Divide the group rate. AR43.1 AR44.3 AR502 AR560 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 Transaction Currency The 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 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 Currency The multiplier or divisor indicator AR42.6 AR42.7 Multiply/Divide used to convert the transaction currency AR43.1 AR44.3 amount to the company base currency. AR502 AR560 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 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 12.6 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 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 12.6 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 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 15.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 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 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 15.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 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 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 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 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 Acceptance Date The 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 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. 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 Remittance 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 DT150 DT155 bank for cashing. 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 Cash Date The date the bill of exchange was AR42.6 AR42.7 cashed. AR43.1 AR44.3 AR502 AR560 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 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 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 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 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 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 Status Indicates the status of the bill of AR42.6 AR42.7 exchange. Valid values are: AR43.1 AR44.3 AR502 AR560 0 = Created DT150 DT155 1 = Accepted DT160 DT161 2 = Selected for Remittance DT165 DT166 3 = Included in Remittance DT170 DT180 4 = Presented DT181 DT30.1 6 = Cashed DT30.2 DT40.1 7 = Dishonored DT42.1 DT45.1 8 = Canceled DT520 DT60.1 9 = Historical DT60.2 DT70.1 5 = Created/unrel DT70.3 DT80.1 DT85.1 DT85.2 DT90.1 DT92.1 ARD-PRINT-FLAG Alpha 1 AR42.1 AR42.2 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: DT150 DT155 DT160 DT165 N = No DT166 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-POSTAL-CODE Alpha 10 (Lower Case) AR42.1 AR42.2 Postal Code The postal code of the customer's AR42.6 AR42.7 payment bank. AR43.1 AR44.3 AR502 AR560 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 Bank The bank location the customer is AR42.6 AR42.7 paying the bill of exchange from. AR43.1 AR44.3 AR502 AR560 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 17 AR42.1 AR42.2 Bank Account Number 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 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 15.2 AR42.1 AR42.2 Revenue Amount The 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. 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 15.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. 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 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 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 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 15.2 AR42.1 AR42.2 Bank Expense Amount The 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. 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 15.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 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 Bank Expense The accounting unit used for posting AR42.6 AR42.7 Accounting Unit the bank expenses. AR43.1 AR44.3 AR502 AR560 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 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 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 15.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. 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 15.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. 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 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 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 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 DT150 DT155 Accounts Receivable to Bill of Exchange DT160 DT165 Receivable. 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 Cashing Update Flag Indicates 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: DT150 DT155 DT160 DT165 N = No DT166 DT180 Y = Yes 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 Accounts Receivable The accounts receivable code assigned AR42.6 AR42.7 Code 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 DT150 DT155 assigned to the invoice is used. If the DT160 DT165 bill of exchange is for more than one DT166 DT180 invoice, the accounts receivable code DT30.1 DT30.2 assigned to the process level is used. 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 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 Dishonored Code The general ledger code used in the AR42.6 AR42.7 dishonoring of a bill of exchange. AR43.1 AR44.3 AR502 AR560 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 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 DT150 DT155 are: DT160 DT165 DT166 DT170 N = No DT180 DT30.1 Y = Yes 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: DT150 DT155 DT160 DT165 Blank = Not dishonored DT166 DT180 P = Post presented BOE DT185 DT30.1 R = Post cash at risk BOE 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: DT150 DT155 DT160 DT165 N = No DT166 DT180 Y = Yes 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: DT150 DT155 DT160 DT165 Blank = Not resolved DT166 DT180 1 = Cashed DT30.1 DT30.2 2 = Written Off DT40.1 DT45.1 3 = Renegotiated 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 Comment Code 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 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 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 Resolved Status This derived field indicates the type of resolution associated with a dishonored bill of exchange. ARD-PAYER-REF Alpha 10 AR42.1 AR42.2 Payer's Reference Contains bank reference information for AR42.6 AR42.7 manually entered bills of exchange. AR43.1 AR44.3 AR502 AR560 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-JRNL-BOOK-NBR Alpha 12 AR42.1 AR42.2 Journal Book The journal book assigned to the bill AR42.6 AR42.7 of exchange. AR43.1 AR44.3 AR502 AR560 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 15.2 AR130 AR131 Applied Amount The applied amount. AR135 AR30.3 AR31.6 AR42.1 AR42.2 AR42.6 AR42.7 AR43.1 AR44.3 AR502 AR560 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 15.2 AR130 AR131 Original Payment Original applied amount. AR135 AR30.3 Amount AR31.6 AR42.1 AR42.2 AR42.6 AR42.7 AR43.1 AR44.3 AR502 AR560 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-PMT-BATCH-NBR Numeric 6 AR42.1 AR42.2 Payment Batch Number Payment batch number. AR42.6 AR42.7 AR43.1 AR44.3 AR502 AR560 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-TYPE-V Derived Remittance Type The remittance type of encashed (E), discounted (D), or spaces. ARD-DRAFT-STAT Derived Draft Stat The draft statement number assigned by the remittance control process to a set of bills of exchange with the same maturity date. ARDRAFTS FILE INDEX NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN ARDSET1 COMPANY This is the primary path for accessing AR258 AR37.6 DRAFT-NBR records. AR37.8 AR42.1 SUFFIX AR42.2 AR42.6 CUSTOMER AR42.7 AR43.1 CANCEL-SEQ AR44.3 AR502 DRAFT-SOURCE AR560 AR73.1 AR80.2 DT150 DT155 DT160 DT161 DT165 DT166 DT17.1 DT170 DT180 DT185 DT190 DT220 DT270 DT280 DT30.1 DT30.2 DT40.1 ... ARDSET10 COMPANY Used in the Bills of Exchange AR42.1 AR42.2 DRAFT-NBR maintenance and update common object. AR42.6 AR42.7 SUFFIX Subset AR43.1 AR44.3 CUSTOMER Where BANK-INST-CODE != Spaces AR502 AR560 CANCEL-SEQ DT150 DT155 DRAFT-SOURCE DT160 DT165 BANK-INST-CODE 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 This path is used in the acceptance AR42.1 AR42.2 CUSTOMER process. AR42.6 AR42.7 MATURITY-DATE Subset AR43.1 AR44.3 DRAFT-NBR Where STATUS = Zeroes AR502 AR560 SUFFIX Or STATUS = 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 This path is used in the remittance AR42.1 AR42.2 REMIT-PROC-LEVselection process. This path spans AR42.6 AR42.7 CASH-CODE records that are ready for selection (in AR43.1 AR44.3 REMIT-TYPE accepted status) and those already AR502 AR560 MATURITY-DATE selected. DT150 DT155 CUSTOMER Subset DT160 DT161 DRAFT-NBR Where STATUS = 1 DT165 DT166 SUFFIX Or STATUS = 2 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 This path is used in the remittance AR42.1 AR42.2 REMIT-PROC-LEVselection process. This path spans AR42.6 AR42.7 CASH-CODE records that are ready for selection (in AR43.1 AR44.3 REMIT-TYPE accepted status) and those already AR502 AR560 DRAFT-NBR selected. DT150 DT155 SUFFIX Subset DT160 DT165 CUSTOMER Where STATUS = 1 DT166 DT180 MATURITY-DATE Or STATUS = 2 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 This path is used in the presentation AR42.1 AR42.2 REMIT-PROC-LEVprocess of all remittances and the AR42.6 AR42.7 REMIT-NBR cashing process of discounted AR43.1 AR44.3 CUSTOMER remittances. AR502 AR560 DRAFT-NBR Duplicates, Subset DT150 DT155 SUFFIX Where REMIT-NBR != Zeroes 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 ARDSET6 COMPANY This path is used in the automatic AR271 AR275 CUSTOMER cashing process. AR72.1 AR73.1 DRAFT-NBR Subset DT180 SUFFIX Where STATUS < 7 CANCEL-SEQ Or (STATUS = 7 DRAFT-SOURCE And RESOLUTION-FL = Spaces ) ARDSET7 COMPANY This path is used to validate a bill of DT40.1 CUSTOMER exchange in the re-creation process. DRAFT-NBR KeyChange, Subset SUFFIX Where STATUS < 7 Or STATUS = 6 And RISK-FL = "Y" ARDSET8 COMPANY This path is used in the dishonor DT92.1 CUSTOMER resolution process. This path spans DRAFT-NBR records that are dishonored and can be SUFFIX resolved. MATURITY-DATE Subset Where STATUS = 7 And RESOLUTION-FL != "1" And RESOLUTION-FL != "2" And RESOLUTION-FL != "3" ARDSET9 COMPANY This is an alternate path used to span AR130 AR131 CUSTOMER records in customer order. AR135 AR150 DRAFT-NBR AR161 AR194 SUFFIX AR250 AR251 CANCEL-SEQ AR252 AR253 DRAFT-SOURCE AR255 AR256 AR286 AR287 AR294 AR30.3 AR31.6 AR50.1 AR505 AR53.1 AR90.1 DT280 DT40.1 DT520 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 Not Required ACO-CUST-GROUP -> DTB-CUST-GROUP ARD-CUSTOMER -> DTB-CUSTOMER Dtremit DTREMIT Required When ARD-REMIT-NBR != Zeroes ARD-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-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-DRAFT-NBR -> DMT-DRAFT-NBR ARD-SUFFIX -> DMT-SUFFIX ARD-DRAFT-SOURCE -> DMT-DRAFT-SOURCE DMT-SEQ-NBR Dtcredit DTCREDIT ARD-COMPANY -> DTX-COMPANY ARD-DRAFT-NBR -> DTX-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 |