ARDRAFTS

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.
ARLL.1
ARD-AR-DRAFT-NBR
Element: Ar Draft Nbr
Alpha 22
ARLL.1
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.
ARLL.1
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.
ARLL.1
ARD-CANCEL-SEQ
Element: Seq Nbr
Numeric 4
An automatically assigned sequence number.
ARLL.1
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.
ARLL.1
ARD-APP-SEQ
Element: Application Sequence
Numeric 7
The counter for the number of applications used in the Accounts Receivable Application file.
ARLL.1
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.
ARLL.1
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.
ARLL.1
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.
ARLL.1
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.
ARLL.1
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.
ARLL.1
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
ARLL.1
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.
ARLL.1
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.
ARLL.1
ARD-GROUP-MUDV
Element: Group Mudv
Alpha 1
The multiplier or divisor indicator for the group rate.
ARLL.1
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.
ARLL.1
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.
ARLL.1
ARD-ORIG-ND
Trans Currency Nbr
of Decimals
Numeric 1
The number of decimals defined for the bill of exchange currency.
ARLL.1
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.
ARLL.1
ARD-CASH-RATE
Cashing Exchange
Rate
Signed 14.7
The currency exchange rate in effect when the bill of exchange was cashed.
ARLL.1
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.
ARLL.1
ARD-TRAN-ND
Base Currency Nbr
of Decimals
Numeric 1
The number of decimals defined for the company base currency.
ARLL.1
ARD-TRAN-AMT
Base Currency BOE
Amount
Signed 18.2
The amount of the bill of exchange in the company base currency.
ARLL.1
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.
ARLL.1
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.
ARLL.1
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.
ARLL.1
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.
ARLL.1
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.
ARLL.1
ARD-CASH-DATE
Element: Date
Numeric 8 (yyyymmdd)
The date the bill of exchange was cashed.
ARLL.1
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.
ARLL.1
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.
ARLL.1
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
ARLL.1
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
ARLL.1
ARD-POSTAL-CODE
Element: Postal Code
Alpha 10 (Lower Case)
The postal code of the customer's payment bank.
ARLL.1
ARD-BANK-ENTITY
Element: Bank
Alpha 15
The bank location the customer is paying the bill of exchange from.
ARLL.1
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.
ARLL.1
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.
ARLL.1
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.
ARLL.1
ARD-REV-ACCT-UNIT
Revenue Accounting
Unit
Alpha 15
The general ledger revenue accounting unit for the additional revenue charged.
ARLL.1
ARD-REV-ACCOUNT
Revenue Account
Number
Numeric 6
The general ledger revenue account number for the additional revenue charged.
ARLL.1
ARD-REV-SUB-ACCT
Revenue Subaccount
Number
Numeric 4
The general ledger revenue subaccount number for the additional revenue charged.
ARLL.1
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.
ARLL.1
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.
ARLL.1
ARD-BEXP-ACCT-UNIT
Element: Acct Unit
Alpha 15
The accounting unit used for posting the bank expenses.
ARLL.1
ARD-BEXP-ACCOUNT
Bank Expense
Account Number
Numeric 6
The account number used for posting the bank expenses.
ARLL.1
ARD-BEXP-SUB-ACCT
Bank Expense
Subaccount Number
Numeric 4
The subaccount number used for posting the bank expenses.
ARLL.1
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.
ARLL.1
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.
ARLL.1
ARD-DEXP-ACCT-UNIT
Dishonor Expense
Accounting Un
Alpha 15
The accounting unit used for posting the dishonor expense.
ARLL.1
ARD-DEXP-ACCOUNT
Dishonor Expense
Account
Numeric 6
The account number used for posting the dishonor expense.
ARLL.1
ARD-DEXP-SUB-ACCT
Dishonor Expense
Subaccount
Numeric 4
The subaccount number used for posting the dishonor expense.
ARLL.1
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.
ARLL.1
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
ARLL.1
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.
ARLL.1
ARD-DRAFT-REF
Bill of Exchange
Reference Nbr
Numeric 10
An optional reference number assigned to the bill of exchange.
ARLL.1
ARD-UNPAYMENT-CODE
Element: Dishonored Code
Alpha 4
The general ledger code used in the dishonoring of a bill of exchange.
ARLL.1
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
ARLL.1
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
ARLL.1
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
ARLL.1
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
ARLL.1
ARD-COMMENT-CD
Element: Comment Cd
Numeric 3
Indicates the number of comment lines that have been created for a bill of exchange.
ARLL.1
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.
ARLL.1
ARD-PAYER-REF
Element: Payer's Reference
Alpha 10
Contains bank reference information for manually entered bills of exchange.
ARLL.1
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.
ARLL.1
ARD-ORIG-APP-AMT
Element: Intl Amt
Signed 18.2
ARLL.1
ARD-APPLD-AMT
Element: Intl Amt
Signed 18.2
ARLL.1


ARDRAFTS FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ARDSET1 COMPANY
AR-DRAFT-NBR
SUFFIX
CUSTOMER
CANCEL-SEQ
DRAFT-SOURCE
ARLL.1
ARDSET10 COMPANY
AR-DRAFT-NBR
SUFFIX
CUSTOMER
CANCEL-SEQ
DRAFT-SOURCE
BANK-INST-CODE
Subset
WhereBANK-INST-CODE !=Spaces
ARLL.1
ARDSET2 COMPANY
CUSTOMER
MATURITY-DATE
AR-DRAFT-NBR
SUFFIX
Subset
WhereSTATUS =Zeroes
OrSTATUS =1
ARLL.1
ARDSET3 REMIT-COMPANY
REMIT-PROC-LEV
CASH-CODE
REMIT-TYPE
MATURITY-DATE
CUSTOMER
AR-DRAFT-NBR
SUFFIX
Subset
WhereSTATUS =1
OrSTATUS =2
ARLL.1
ARDSET4 REMIT-COMPANY
REMIT-PROC-LEV
CASH-CODE
REMIT-TYPE
AR-DRAFT-NBR
SUFFIX
CUSTOMER
MATURITY-DATE
Subset
WhereSTATUS =1
OrSTATUS =2
ARLL.1
ARDSET5 REMIT-COMPANY
REMIT-PROC-LEV
REMIT-NBR
CUSTOMER
AR-DRAFT-NBR
SUFFIX
COMPANY
CANCEL-SEQ
DRAFT-SOURCE
Subset
WhereREMIT-NBR !=Zeroes
ARLL.1
ARDSET6 COMPANY
CUSTOMER
AR-DRAFT-NBR
SUFFIX
CANCEL-SEQ
DRAFT-SOURCE
Subset
WhereSTATUS <7
Or(STATUS =7
AndRESOLUTION-FL =Spaces)
ARDSET7 COMPANY
CUSTOMER
AR-DRAFT-NBR
SUFFIX
KeyChange, Subset
WhereSTATUS <7
OrSTATUS =6
AndRISK-FL ="Y"
ARDSET8 COMPANY
CUSTOMER
AR-DRAFT-NBR
SUFFIX
MATURITY-DATE
Subset
WhereSTATUS =7
AndRESOLUTION-FL !="1"
AndRESOLUTION-FL !="2"
AndRESOLUTION-FL !="3"
ARDSET9 COMPANY
CUSTOMER
AR-DRAFT-NBR
SUFFIX
CANCEL-SEQ
DRAFT-SOURCE


ARDRAFTS FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Arcomp ARCOMP Required
ARD-COMPANY->ACO-COMPANY (ACOSET1)
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
AndARD-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 Required
ACO-CUST-GROUP->DTB-CUST-GROUP
ARD-COMPANY->DTB-COMPANY
ARD-CUSTOMER->DTB-CUSTOMER
Glsystem GLSYSTEM Required
ARD-COMPANY->GLS-COMPANY


ARDRAFTS FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Arapplied ARAPPLIED Delete Restricted
ARD-COMPANY->ARA-CR-COMPANY
ARD-CUSTOMER->ARA-CR-CUSTOMER
"B"->ARA-CR-TYPE
ARD-AR-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


File created: Thu Jun 09 11:12:41 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.