ARIBILLTO – No description in the Lawson data dictionary
- System
- Accounts Receivable (AR)
- Prefix
AIB- Primary key
CUST-GROUP,CUSTOMER,BILL-TO- Fields
- 16
- Updated by
- 1 program
- Referenced by
- 0 programs
ARIBILLTO is a Lawson Accounts Receivable table (prefix AIB); no description in the lawson data dictionary. It is indexed by CUST-GROUP, CUSTOMER, BILL-TO (AIBSET1). It is updated by AR501. The table has 16 fields, 1 index and 0 documented relations.
About ARIBILLTO
No description in the Lawson data dictionary.
Fields (16)
Column = COBOL field name without the AIB- 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 |
|---|---|---|---|
#AIB-CUST-GROUP PKCUST_GROUP | Alpha 5 | Customer group. Used to identify a group of customer associated with one or more companies. | — |
#AIB-CUSTOMER PKCUSTOMER | Alpha 9 (Right Justified) | This field contains the number that represents a customer. | — |
#AIB-BILL-TO PKBILL_TO | Numeric 4 | This field contains the Bill To identifier relating to an address. | — |
#AIB-NAMENAME | Alpha 30 (Lower Case) | Displays the company description. | — |
#AIB-ADDR1ADDR1 | Alpha 30 (Lower Case) | This field contains the first line of address information. | — |
#AIB-ADDR2ADDR2 | Alpha 30 (Lower Case) | This field contains the first line of address information. | — |
#AIB-ADDR3ADDR3 | Alpha 30 (Lower Case) | This field contains the first line of address information. | — |
#AIB-ADDR4ADDR4 | Alpha 30 (Lower Case) | This field contains the first line of address information. | — |
#AIB-CITYCITY | Alpha 18 (Lower Case) | This field contains the city of the address. | — |
#AIB-STATESTATE | Alpha 2 | This field contains the two-character state code of the address. | — |
#AIB-ZIPZIP | Alpha 10 | This field contains the postal code of the address. | — |
#AIB-COUNTYCOUNTY | Alpha 25 (Lower Case) | This field contains the county of the address. | — |
#AIB-DEFAULT-BILLDEFAULT_BILL | Alpha 1 | Indicates if this Bill To is the default Bill To. Valid values are Y and N. | — |
#AIB-COUNTRY-CODECOUNTRY_CODE | Alpha 2 | The country code. Required for VAT and intrastat reporting. Must be defined in IN01.1 (Country Maintenance). | — |
#AIB-REGIONREGION | Alpha 2 | The region code, if applicable for the country. Used by Intrastat processing. Must be defined in IN02.1 (Region Maintenance) | — |
#AIB-E-MAIL-ADDRESSE_MAIL_ADDRESS | Alpha 60 (Lower Case) | e-mail address. | — |
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 |
|---|---|---|---|---|
AIBSET1 |
| Primary | AR501 |
Programs
Updated by (1)
- AR501 Customer Conversion