AR Bill of Exchange
The AR Bills of Exchange file contains all system-generated bills of exchange
and released customer-generated bills of exchange.
UPDATED BY
ARLL.1 |
FIELD NAME | DESCRIPTION/VALID VALUES | UPDATED BY | ||
---|---|---|---|---|
ARD-COMPANY Element: Company | Numeric 4 The company number represents an established company. Must be a valid record in the AR Company file. |
|
||
ARD-AR-DRAFT-NBR Element: Ar Draft Nbr | Alpha 22 |
|
||
ARD-SUFFIX Bill of Exchange Suffix | Numeric 3 The bill of exchange suffix number. Represents the occurrence value of the bill of exchange. Used if a bill of exchange is created for a single payment of a multiple payment invoice. |
|
||
ARD-CUSTOMER Element: Customer | Alpha 9 (Right Justified) The customer assigned to the bill of exchange. Represents the customer responsible for paying the bill of exchange obligation. Must be a valid record in the AR Company Customer file. |
|
||
ARD-CANCEL-SEQ Element: Seq Nbr | Numeric 4 An automatically assigned sequence number. |
|
||
ARD-DRAFT-SOURCE Bill of Exchange Source | Alpha 1 Indicates where the bill of exchange originated. Valid values are: R = Receivable. The bill of exchange was created by the vendor (accounts receivable). P = Payable. The bill of exchange was created by the customer (accounts payable). I = Interfaced. The bill of exchange was created by an interfacing system, such as an order entry system. |
|
||
ARD-APP-SEQ Element: Application Sequence | Numeric 7 The counter for the number of applications used in the Accounts Receivable Application file. |
|
||
ARD-PROCESS-LEVEL Element: Process Level | Alpha 5 The process level assigned to the bill of exchange. Must be a valid record in the AR Process Level file. |
|
||
ARD-BANK-INST-CODE Element: Payment Code | Alpha 3 A transaction code representing a type of cash payment (with atributes for either receiving AP payments, or creating EFT payments), bill of exchange payment, or bank service transaction. |
|
||
ARD-REMIT-COMPANY Element: Company | Numeric 4 This field contains the remittance company once the bill of exchange is included in a remittance. Must be a valid record in the AR Company file. |
|
||
ARD-REMIT-PROC-LEV Element: Process Level | Alpha 5 This field contains remittance process level once the bill of exchange is included in a remittance. Must be a valid record in the AR Process Level file. |
|
||
ARD-CASH-CODE Element: Cash Code | Alpha 4 The cash code (bank account) used for depositing the bill of exchange. Must be a valid record in the Cash Ledger Cash Code file. |
|
||
ARD-REMIT-TYPE Element: Remit Type | Alpha 1 Indicates the type of remittance associated with the bill of exchange. Valid values are: D = Discounted remittance E = Encashed remittance; full value upon due date Blank = Not included in a remittance |
|
||
ARD-REMIT-NBR Element: Remit Number | Numeric 7 The remittance number assigned to the bill of exchange when it is presented to the bank for cashing as part of a remittance. |
|
||
ARD-GROUP-RATE Element: Group Rate | Signed 14.7 The exchange rate used to convert a company base currency amount to the customer group currency. |
|
||
ARD-GROUP-MUDV Element: Group Mudv | Alpha 1 The multiplier or divisor indicator for the group rate. |
|
||
ARD-ORIG-CURRENCY Element: Transaction Currency | Alpha 5 The currency code assigned to the bill of exchange. Represents the currency that will be received upon cashing. |
|
||
ARD-CURR-MUDV Element: Curr Mudv | Alpha 1 The multiplier or divisor indicator used to convert the transaction currency amount to the company base currency. |
|
||
ARD-ORIG-ND Trans Currency Nbr of Decimals | Numeric 1 The number of decimals defined for the bill of exchange currency. |
|
||
ARD-ORIG-RATE Trans Currency Exchange Rate | Signed 14.7 The exchange rate used to convert the bill of exchange currency to the company base currency. |
|
||
ARD-CASH-RATE Cashing Exchange Rate | Signed 14.7 The currency exchange rate in effect when the bill of exchange was cashed. |
|
||
ARD-ORIG-AMT Bill of Exchange Amount | Signed 18.2 The amount of the bill of exchange in the currency of the bill of exchange. |
|
||
ARD-TRAN-ND Base Currency Nbr of Decimals | Numeric 1 The number of decimals defined for the company base currency. |
|
||
ARD-TRAN-AMT Base Currency BOE Amount | Signed 18.2 The amount of the bill of exchange in the company base currency. |
|
||
ARD-DRAFT-DATE Bill of Exchange Date | Numeric 8 (yyyymmdd) The date assigned to the bill of exchange. Represents the date the bill of exchange was created. |
|
||
ARD-MATURITY-DATE Element: Due Date | Numeric 8 (yyyymmdd) The bill of exchange due date. Indicates when the bill of exchange is due to be paid in full. |
|
||
ARD-ACCEPT-DATE Element: Acceptance Date | Numeric 8 (yyyymmdd) The acceptance date assigned to the bill of exchange. Used only for bills of exchange that require acceptance. |
|
||
ARD-ACCEPT-GL-DATE Acceptance General Ledger Date | Numeric 8 (yyyymmdd) The date used for posting the acceptance of a bill of exchange to the general ledger. Used only for bills of exchange that require acceptance. |
|
||
ARD-REMIT-DATE Element: Remit Date | Numeric 8 (yyyymmdd) The remittance creation date for the remittance associated with the bill of exchange. Bills of exchange are grouped into remittances to be presented to the bank for cashing. |
|
||
ARD-CASH-DATE Element: Date | Numeric 8 (yyyymmdd) The date the bill of exchange was cashed. |
|
||
ARD-DISHONOR-DATE Element: Dishonor Date | Numeric 8 (yyyymmdd) If the bill of exchange was dishonored, this field contains the dishonor date assigned to the bill of exchange. |
|
||
ARD-CANCEL-DATE Element: Cancel Date | Numeric 8 (yyyymmdd) If the bill of exchange was canceled, this field contains the cancel date assigned to the bill of exchange. |
|
||
ARD-RESOLVED-DATE Element: Resolved Date | Numeric 8 (yyyymmdd) If the bill of exchange was dishonored, this field contains the date the dishonored bill of exchange was resolved. |
|
||
ARD-STATUS Element: Status | Numeric 1 Indicates the status of the bill of exchange. Valid values are: 0 = Created 1 = Accepted 2 = Selected for Remittance 3 = Included in Remittance 4 = Presented 6 = Cashed 7 = Dishonored 8 = Canceled 9 = Historical 5 = Created/unrel |
|
||
ARD-PRINT-FLAG Element: Print Flag | Alpha 1 Indicates whether the bill of exchange has been created by DT155 (Bill of Exchange Print - Tape Create). Valid values are: N = No Y = Yes |
|
||
ARD-POSTAL-CODE Element: Postal Code | Alpha 10 (Lower Case) The postal code of the customer's payment bank. |
|
||
ARD-BANK-ENTITY Element: Bank | Alpha 15 The bank location the customer is paying the bill of exchange from. |
|
||
ARD-BANK-ACCT-NBR Element: Bank Acct Nbr | Alpha 35 The bank account within the bank location that the customer will be paying the bill of exchange from. |
|
||
ARD-ORIG-REV-AMT Element: Revenue Amount | Signed 18.2 The amount of additional revenue charged to a customer for processing the bill of exchange. This amount is in the company base currency. |
|
||
ARD-REVENUE-AMT Base Currency Revenue Amount | Signed 18.2 The amount of additional revenue charged to customer for processing the bill of exchange. This amount is in the currency of the bill of exchange. |
|
||
ARD-REV-ACCT-UNIT Revenue Accounting Unit | Alpha 15 The general ledger revenue accounting unit for the additional revenue charged. |
|
||
ARD-REV-ACCOUNT Revenue Account Number | Numeric 6 The general ledger revenue account number for the additional revenue charged. |
|
||
ARD-REV-SUB-ACCT Revenue Subaccount Number | Numeric 4 The general ledger revenue subaccount number for the additional revenue charged. |
|
||
ARD-ORIG-BNK-EXP Element: Bank Expense Amount | Signed 18.2 The expense incurred in the process of cashing the bill of exchange. This amount is in the currency of the bill of exchange. |
|
||
ARD-BNK-EXP-AMT Base Currency Bank Expense Amt | Signed 18.2 The expense incurred in the process of cashing the bill of exchange. This amount is in the company base currency. |
|
||
ARD-BEXP-ACCT-UNIT Element: Acct Unit | Alpha 15 The accounting unit used for posting the bank expenses. |
|
||
ARD-BEXP-ACCOUNT Bank Expense Account Number | Numeric 6 The account number used for posting the bank expenses. |
|
||
ARD-BEXP-SUB-ACCT Bank Expense Subaccount Number | Numeric 4 The subaccount number used for posting the bank expenses. |
|
||
ARD-ORIG-DIS-EXP Dishonor Expense Amount | Signed 18.2 The amount of expense incurred during the dishonoring of the bill of exchange. This amount is in the currency of the bill of exchange. |
|
||
ARD-DIS-EXP-AMT Base Curr Dishonor Expense Amt | Signed 18.2 The amount of the expense incurred during the dishonoring of the bill of exchange. This amount is in the company base currency. |
|
||
ARD-DEXP-ACCT-UNIT Dishonor Expense Accounting Un | Alpha 15 The accounting unit used for posting the dishonor expense. |
|
||
ARD-DEXP-ACCOUNT Dishonor Expense Account | Numeric 6 The account number used for posting the dishonor expense. |
|
||
ARD-DEXP-SUB-ACCT Dishonor Expense Subaccount | Numeric 4 The subaccount number used for posting the dishonor expense. |
|
||
ARD-DRAFT-CODE Bill of Exchange Code | Alpha 4 The bill of exchange receivable code used for posting the bill of exchange to the general ledger. This will be filled if the asset has been transferred from Accounts Receivable to Bill of Exchange Receivable. |
|
||
ARD-CASH-UPDATE-FL Element: Cashing Update Flag | Alpha 1 Indicates whether the bill of exchange has been processed through DT180 (Bank Presentation, Cashing Update). Valid values are: N = No Y = Yes |
|
||
ARD-AR-CODE Element: Ar Code | Alpha 4 The accounts receivable code assigned to the bill of exchange during creation. If the bill of exchange is for one invoice, the account receivable code assigned to the invoice is used. If the bill of exchange is for more than one invoice, the accounts receivable code assigned to the process level is used. |
|
||
ARD-DRAFT-REF Bill of Exchange Reference Nbr | Numeric 10 An optional reference number assigned to the bill of exchange. |
|
||
ARD-UNPAYMENT-CODE Element: Dishonored Code | Alpha 4 The general ledger code used in the dishonoring of a bill of exchange. |
|
||
ARD-RISK-FL Element: Risk Flag | Alpha 1 Indicates whether the bill of exchange is at risk with the bank (cashed at a discount before its due date and has not yet reached its due date). Valid values are: N = No Y = Yes |
|
||
ARD-DIS-UPDATE-FL Dishonored Update Flag | Alpha 1 Indicates whether a dishonored bill of exchange has been processed by DT180 (Bank Presentation, Cashing Update). Valid values are: Blank = Not dishonored P = Post presented BOE R = Post cash at risk BOE |
|
||
ARD-PRES-UPDATE-FL Presentation Update Flag | Alpha 1 Indicates whether the bill of exchange presentation has been processed by DT180 (Bank Presentation, Cashing Update). Valid values are: N = No Y = Yes |
|
||
ARD-RESOLUTION-FL Dishonored Resolution Flag | Alpha 1 If the bill of exchange has been dishonored, this field indicates how the dishonored bill of exchange was resolved. Valid values are: Blank = Not resolved 1 = Cashed 2 = Written Off 3 = Renegotiated |
|
||
ARD-COMMENT-CD Element: Comment Cd | Numeric 3 Indicates the number of comment lines that have been created for a bill of exchange. |
|
||
ARD-STATUS-DATE Element: Status Date | Derived 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 Element: Resolved Status | Derived This derived field indicates the type of resolution associated with a dishonored bill of exchange. |
|
||
ARD-JRNL-BOOK-NBR Element: Jrnl Book Nbr | Alpha 12 The journal book assigned to the bill of exchange. |
|
||
ARD-PAYER-REF Element: Payer's Reference | Alpha 10 Contains bank reference information for manually entered bills of exchange. |
|
||
ARD-PMT-BATCH-NBR Element: Pmt Batch Nbr | Numeric 6 The draft batch number which is also used as the batch number when creating payment records. |
|
||
ARD-ORIG-APP-AMT Element: Intl Amt | Signed 18.2 |
|
||
ARD-APPLD-AMT Element: Intl Amt | Signed 18.2 |
|
NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | |||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
ARDSET1 |
COMPANY AR-DRAFT-NBR SUFFIX CUSTOMER CANCEL-SEQ DRAFT-SOURCE |
|
| |||||||||||||||||||||||||||||||
ARDSET10 |
COMPANY AR-DRAFT-NBR SUFFIX CUSTOMER CANCEL-SEQ DRAFT-SOURCE BANK-INST-CODE |
|
| |||||||||||||||||||||||||||||||
ARDSET2 |
COMPANY CUSTOMER MATURITY-DATE AR-DRAFT-NBR SUFFIX |
|
| |||||||||||||||||||||||||||||||
ARDSET3 |
REMIT-COMPANY REMIT-PROC-LEV CASH-CODE REMIT-TYPE MATURITY-DATE CUSTOMER AR-DRAFT-NBR SUFFIX |
|
| |||||||||||||||||||||||||||||||
ARDSET4 |
REMIT-COMPANY REMIT-PROC-LEV CASH-CODE REMIT-TYPE AR-DRAFT-NBR SUFFIX CUSTOMER MATURITY-DATE |
|
| |||||||||||||||||||||||||||||||
ARDSET5 |
REMIT-COMPANY REMIT-PROC-LEV REMIT-NBR CUSTOMER AR-DRAFT-NBR SUFFIX COMPANY CANCEL-SEQ DRAFT-SOURCE |
|
| |||||||||||||||||||||||||||||||
ARDSET6 |
COMPANY CUSTOMER AR-DRAFT-NBR SUFFIX CANCEL-SEQ DRAFT-SOURCE |
|
||||||||||||||||||||||||||||||||
ARDSET7 |
COMPANY CUSTOMER AR-DRAFT-NBR SUFFIX |
|
||||||||||||||||||||||||||||||||
ARDSET8 |
COMPANY CUSTOMER AR-DRAFT-NBR SUFFIX MATURITY-DATE |
|
||||||||||||||||||||||||||||||||
ARDSET9 |
COMPANY CUSTOMER AR-DRAFT-NBR SUFFIX CANCEL-SEQ DRAFT-SOURCE |
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Arcomp | ARCOMP |
Required
| ||||||||||||||||||
Arcustgrp | ARCUSTGRP |
Required
| ||||||||||||||||||
Arcustomer | ARCUSTOMER |
Required
| ||||||||||||||||||
Cbbankinst | CBBANKINST |
Required
| ||||||||||||||||||
Cbcpycash | CBCPYCASH |
Required
| ||||||||||||||||||
Cust Bankent | CBBANKENT |
Required
| ||||||||||||||||||
Custdesc | CUSTDESC |
Required
| ||||||||||||||||||
Dtcustbank | DTCUSTBANK |
Required
| ||||||||||||||||||
Glsystem | GLSYSTEM |
Required
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | |||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Arapplied | ARAPPLIED |
Delete Restricted
|
All trademarks and registered trademarks are the property of their
respective owners.