ARIEFT – No description in the Lawson data dictionary
- System
- Accounts Receivable (AR)
- Prefix
AIF- Primary key
COMPANY,CUSTOMER- Fields
- 21
- Updated by
- 2 programs
- Referenced by
- 0 programs
ARIEFT is a Lawson Accounts Receivable table (prefix AIF); no description in the lawson data dictionary. It is indexed by COMPANY, CUSTOMER (AIFSET1). It is updated by AR501 and AR98.1. The table has 21 fields, 1 index and 0 documented relations.
About ARIEFT
No description in the Lawson data dictionary.
Fields (21)
Column = COBOL field name without the AIF- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
#AIF-COMPANY PKCOMPANY | Numeric 4 | The number representing an AR company. | AR98.1 |
#AIF-CUSTOMER PKCUSTOMER | Alpha 9 (Right Justified) | This field contains the number that represents a customer. | AR98.1 |
#AIF-BANK-ENTITYBANK_ENTITY | Alpha 15 | Represents a bank institution location. | AR98.1 |
#AIF-BANK-ACCT-NBRBANK_ACCT_NBR | Alpha 35 | The bank-assigned account number identification. | AR98.1 |
#AIF-START-DATESTART_DATE | Numeric 8 (yyyymmdd) | The start date for EFT selection for the associated bank account. | AR98.1 |
#AIF-END-DATEEND_DATE | Numeric 8 (yyyymmdd) | The end date for EFT selection for the associated bank account. | AR98.1 |
#AIF-PRENOTEPRENOTE | Numeric 8 (yyyymmdd) | This is the date the prenotification was sent to the customer for EFT processing. | AR98.1 |
#AIF-FT-TYPEFT_TYPE | Alpha 1 | The type of bank account. Valid values are:
| AR98.1 |
#AIF-PRE-NOTEPRE_NOTE | Alpha 1 | Indicates if sending a prenote for this bank account is required. | AR98.1 |
#AIF-PRENOTE-STATUSPRENOTE_STATUS | Numeric 1 | Status of the prenote for this bank account. Valid values are:
| AR98.1 |
#AIF-CUST-ACCT-TYPECUST_ACCT_TYPE | Alpha 1 | The type of account the customer has:
| AR98.1 |
#AIF-RIBKEYRIBKEY | Numeric 2 | The bank account RIBKEY value. | AR98.1 |
#AIF-CUST-PRE-NOTECUST_PRE_NOTE | Alpha 1 | Indicates if customers are prenotified of EFT transactions. Valid values are:
| AR98.1 |
#AIF-CUST-NOTE-METHCUST_NOTE_METH | Alpha 1 | Indicates the method used to deliver pre or final EFT notification to a customer. Valid values are:
| AR98.1 |
#AIF-ADJ-NOTE-METHADJ_NOTE_METH | Alpha 1 | The method used to deliver the EFT adjustment notification to the customer. Valid values are:
| AR98.1 |
#AIF-USER1-FIELDUSER1_FIELD | Alpha 5 | User1 defined field. | AR98.1 |
#AIF-USER2-FIELDUSER2_FIELD | Alpha 10 | User2 defined field. | AR98.1 |
#AIF-PAYMENT-FORMATPAYMENT_FORMAT | Alpha 1 | Determines the payment format of the file output for EFT transactions. Valid values are:
| AR98.1 |
#AIF-VBANK-IDENTVBANK_IDENT | Alpha 1 | — | AR98.1 |
#AIF-BANK-TRAN-CDBANK_TRAN_CD | Alpha 2 | The value used for bank accunt edit verification. | AR98.1 |
#AIF-BIC-IDBIC_ID | Alpha 12 | — | — |
Indexes (1)
Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
AIFSET1 |
| Primary | AR501, AR98.1 |