ARDRAFTS – AR Bill of Exchange
- System
- DT (DT)
- Prefix
ARD- Primary key
COMPANY,AR-DRAFT-NBR,SUFFIX,CUSTOMER,CANCEL-SEQ,DRAFT-SOURCE- Fields
- 70
- Updated by
- 1 program
- Referenced by
- 0 programs
ARDRAFTS is the AR Bill of Exchange table in Lawson DT (prefix ARD). It is indexed by COMPANY, AR-DRAFT-NBR, SUFFIX, CUSTOMER, CANCEL-SEQ, DRAFT-SOURCE (ARDSET1); alternate indexes: ARDSET10, ARDSET2, ARDSET3, ARDSET4, ARDSET5, ARDSET6, ARDSET7, ARDSET8 and 1 more. It is related 1:1 to ARCOMP, ARCUSTGRP, ARCUSTOMER, CBBANKINST, CBCPYCASH, CBBANKENT, CUSTDESC, DTCUSTBANK and 1 more and 1:M to ARAPPLIED. It is updated by ARLL.1. The table has 70 fields, 10 indexes and 10 documented relations.
About ARDRAFTS
No description in the Lawson data dictionary.
Fields (70)
Column = COBOL field name without the ARD- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
ARD-COMPANY PKCOMPANY | 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 PKAR_DRAFT_NBR | Alpha 22 | — | ARLL.1 |
ARD-SUFFIX PKSUFFIX | 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 PKCUSTOMER | 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 PKCANCEL_SEQ | Numeric 4 | An automatically assigned sequence number. | ARLL.1 |
ARD-DRAFT-SOURCE PKDRAFT_SOURCE | Alpha 1 | Indicates where the bill of exchange originated. Valid values are: was created by the vendor (accounts receivable). created by the customer (accounts payable). was created by an interfacing system, such as an order entry system.
| ARLL.1 |
ARD-APP-SEQAPP_SEQ | Numeric 7 | The counter for the number of applications used in the Accounts Receivable Application file. | ARLL.1 |
ARD-PROCESS-LEVELPROCESS_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-CODEBANK_INST_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-COMPANYREMIT_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-LEVREMIT_PROC_LEV | 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-CODECASH_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-TYPEREMIT_TYPE | Alpha 1 | Indicates the type of remittance associated with the bill of exchange. Valid values are: upon due date
| ARLL.1 |
ARD-REMIT-NBRREMIT_NBR | 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-RATEGROUP_RATE | Signed 14.7 | The exchange rate used to convert a company base currency amount to the customer group currency. | ARLL.1 |
ARD-GROUP-MUDVGROUP_MUDV | Alpha 1 | The multiplier or divisor indicator for the group rate. | ARLL.1 |
ARD-ORIG-CURRENCYORIG_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-MUDVCURR_MUDV | Alpha 1 | The multiplier or divisor indicator used to convert the transaction currency amount to the company base currency. | ARLL.1 |
ARD-ORIG-NDORIG_ND | Numeric 1 | The number of decimals defined for the bill of exchange currency. | ARLL.1 |
ARD-ORIG-RATEORIG_RATE | Signed 14.7 | The exchange rate used to convert the bill of exchange currency to the company base currency. | ARLL.1 |
ARD-CASH-RATECASH_RATE | Signed 14.7 | The currency exchange rate in effect when the bill of exchange was cashed. | ARLL.1 |
ARD-ORIG-AMTORIG_AMT | Signed 18.2 | The amount of the bill of exchange in the currency of the bill of exchange. | ARLL.1 |
ARD-TRAN-NDTRAN_ND | Numeric 1 | The number of decimals defined for the company base currency. | ARLL.1 |
ARD-TRAN-AMTTRAN_AMT | Signed 18.2 | The amount of the bill of exchange in the company base currency. | ARLL.1 |
ARD-DRAFT-DATEDRAFT_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-DATEMATURITY_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-DATEACCEPT_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-DATEACCEPT_GL_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-DATEREMIT_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-DATECASH_DATE | Numeric 8 (yyyymmdd) | The date the bill of exchange was cashed. | ARLL.1 |
ARD-DISHONOR-DATEDISHONOR_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-DATECANCEL_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-DATERESOLVED_DATE | Numeric 8 (yyyymmdd) | If the bill of exchange was dishonored, this field contains the date the dishonored bill of exchange was resolved. | — |
ARD-STATUSSTATUS | Numeric 1 | Indicates the status of the bill of exchange. Valid values are:
| ARLL.1 |
ARD-PRINT-FLAGPRINT_FLAG | Alpha 1 | Indicates whether the bill of exchange has been created by DT155 (Bill of Exchange Print - Tape Create). Valid values are:
| ARLL.1 |
ARD-POSTAL-CODEPOSTAL_CODE | Alpha 10 (Lower Case) | The postal code of the customer's payment bank. | ARLL.1 |
ARD-BANK-ENTITYBANK_ENTITY | Alpha 15 | The bank location the customer is paying the bill of exchange from. | ARLL.1 |
ARD-BANK-ACCT-NBRBANK_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-AMTORIG_REV_AMT | 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-AMTREVENUE_AMT | 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-UNITREV_ACCT_UNIT | Alpha 15 | The general ledger revenue accounting unit for the additional revenue charged. | ARLL.1 |
ARD-REV-ACCOUNTREV_ACCOUNT | Numeric 6 | The general ledger revenue account number for the additional revenue charged. | ARLL.1 |
ARD-REV-SUB-ACCTREV_SUB_ACCT | Numeric 4 | The general ledger revenue subaccount number for the additional revenue charged. | ARLL.1 |
ARD-ORIG-BNK-EXPORIG_BNK_EXP | 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-AMTBNK_EXP_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-UNITBEXP_ACCT_UNIT | Alpha 15 | The accounting unit used for posting the bank expenses. | ARLL.1 |
ARD-BEXP-ACCOUNTBEXP_ACCOUNT | Numeric 6 | The account number used for posting the bank expenses. | ARLL.1 |
ARD-BEXP-SUB-ACCTBEXP_SUB_ACCT | Numeric 4 | The subaccount number used for posting the bank expenses. | ARLL.1 |
ARD-ORIG-DIS-EXPORIG_DIS_EXP | 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-AMTDIS_EXP_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-UNITDEXP_ACCT_UNIT | Alpha 15 | The accounting unit used for posting the dishonor expense. | ARLL.1 |
ARD-DEXP-ACCOUNTDEXP_ACCOUNT | Numeric 6 | The account number used for posting the dishonor expense. | ARLL.1 |
ARD-DEXP-SUB-ACCTDEXP_SUB_ACCT | Numeric 4 | The subaccount number used for posting the dishonor expense. | ARLL.1 |
ARD-DRAFT-CODEDRAFT_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-FLCASH_UPDATE_FL | Alpha 1 | Indicates whether the bill of exchange has been processed through DT180 (Bank Presentation, Cashing Update). Valid values are:
| ARLL.1 |
ARD-AR-CODEAR_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-REFDRAFT_REF | Numeric 10 | An optional reference number assigned to the bill of exchange. | ARLL.1 |
ARD-UNPAYMENT-CODEUNPAYMENT_CODE | Alpha 4 | The general ledger code used in the dishonoring of a bill of exchange. | ARLL.1 |
ARD-RISK-FLRISK_FL | 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:
| ARLL.1 |
ARD-DIS-UPDATE-FLDIS_UPDATE_FL | Alpha 1 | Indicates whether a dishonored bill of exchange has been processed by DT180 (Bank Presentation, Cashing Update). Valid values are:
| ARLL.1 |
ARD-PRES-UPDATE-FLPRES_UPDATE_FL | Alpha 1 | Indicates whether the bill of exchange presentation has been processed by DT180 (Bank Presentation, Cashing Update). Valid values are:
| ARLL.1 |
ARD-RESOLUTION-FLRESOLUTION_FL | Alpha 1 | If the bill of exchange has been dishonored, this field indicates how the dishonored bill of exchange was resolved. Valid values are:
| ARLL.1 |
ARD-COMMENT-CDCOMMENT_CD | Numeric 3 | Indicates the number of comment lines that have been created for a bill of exchange. | ARLL.1 |
ARD-STATUS-DATESTATUS_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-STSRESOLVED_STS | Derived | This derived field indicates the type of resolution associated with a dishonored bill of exchange. | — |
ARD-JRNL-BOOK-NBRJRNL_BOOK_NBR | Alpha 12 | The journal book assigned to the bill of exchange. | ARLL.1 |
ARD-PAYER-REFPAYER_REF | Alpha 10 | Contains bank reference information for manually entered bills of exchange. | ARLL.1 |
ARD-PMT-BATCH-NBRPMT_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-AMTORIG_APP_AMT | Signed 18.2 | — | ARLL.1 |
ARD-APPLD-AMTAPPLD_AMT | Signed 18.2 | — | ARLL.1 |
Indexes (10)
Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
ARDSET1 | COMPANY, AR-DRAFT-NBR, SUFFIX, CUSTOMER, CANCEL-SEQ, DRAFT-SOURCE | Primary | ARLL.1 | |
ARDSET10 | COMPANY, AR-DRAFT-NBR, SUFFIX, CUSTOMER, CANCEL-SEQ, DRAFT-SOURCE, BANK-INST-CODE | Subset | Where BANK-INST-CODE != Spaces | ARLL.1 |
ARDSET2 | COMPANY, CUSTOMER, MATURITY-DATE, AR-DRAFT-NBR, SUFFIX | Subset | Where STATUS = Zeroes Or STATUS = 1 | ARLL.1 |
ARDSET3 | REMIT-COMPANY, REMIT-PROC-LEV, CASH-CODE, REMIT-TYPE, MATURITY-DATE, CUSTOMER, AR-DRAFT-NBR, SUFFIX | Subset | Where STATUS = 1 Or STATUS = 2 | ARLL.1 |
ARDSET4 | REMIT-COMPANY, REMIT-PROC-LEV, CASH-CODE, REMIT-TYPE, AR-DRAFT-NBR, SUFFIX, CUSTOMER, MATURITY-DATE | Subset | Where STATUS = 1 Or STATUS = 2 | ARLL.1 |
ARDSET5 | REMIT-COMPANY, REMIT-PROC-LEV, REMIT-NBR, CUSTOMER, AR-DRAFT-NBR, SUFFIX, COMPANY, CANCEL-SEQ, DRAFT-SOURCE | Subset | Where REMIT-NBR != Zeroes | ARLL.1 |
ARDSET6 | COMPANY, CUSTOMER, AR-DRAFT-NBR, SUFFIX, CANCEL-SEQ, DRAFT-SOURCE | Subset | Where STATUS < 7 Or (STATUS = 7 And RESOLUTION-FL = Spaces) | — |
ARDSET7 | COMPANY, CUSTOMER, AR-DRAFT-NBR, SUFFIX | KeyChange, Subset | Where STATUS < 7 Or STATUS = 6 And RISK-FL = "Y" | — |
ARDSET8 | COMPANY, CUSTOMER, AR-DRAFT-NBR, SUFFIX, MATURITY-DATE | Subset | Where STATUS = 7 And RESOLUTION-FL != "1" And RESOLUTION-FL != "2" And RESOLUTION-FL != "3" | — |
ARDSET9 | COMPANY, CUSTOMER, AR-DRAFT-NBR, SUFFIX, CANCEL-SEQ, DRAFT-SOURCE | — |
Relations
One to one (9) — lookups and parents
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| 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 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 | Required | ACO-CUST-GROUP → DTB-CUST-GROUP, ARD-COMPANY → DTB-COMPANY, ARD-CUSTOMER → DTB-CUSTOMER | |
| Glsystem | GLSYSTEM | Required | ARD-COMPANY → GLS-COMPANY |
One to many (1) — child tables
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| 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 |
Programs
Updated by (1)
- ARLL.1 AR Transaction Interface