ARCUSTPER – AR Customer Period Totals
- System
- Accounts Receivable (AR)
- Prefix
ARP- Primary key
COMPANY,CUSTOMER,YEAR- Fields
- 10
- Updated by
- 8 programs
- Referenced by
- 0 programs
ARCUSTPER is the AR Customer Period Totals table in Lawson Accounts Receivable (prefix ARP). It is indexed by COMPANY, CUSTOMER, YEAR (ARPSET1). It is updated by AR10.1, AR13.1, AR13.2, AR301, AR501, ARLL.1, CB06.2 and CB191. The table has 10 fields, 1 index and 0 documented relations.
About ARCUSTPER
No description in the Lawson data dictionary.
Fields (10)
Column = COBOL field name without the ARP- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
ARP-COMPANY PKCOMPANY | Numeric 4 | The number representing an AR company. | AR13.1, AR13.2, AR501, ARLL.1, CB06.2, CB191 |
ARP-CUSTOMER PKCUSTOMER | Alpha 9 (Right Justified) | Customer number. | AR13.1, AR13.2, AR501, ARLL.1, CB06.2, CB191 |
ARP-YEAR PKYEAR | Numeric 4 | The fiscal year (as defined by the General Ledger system) for the data stored on this record. | AR13.1, AR13.2, AR501, ARLL.1, CB06.2, CB191 |
ARP-PERIOD-BILLPERIOD_BILL | Signed 18.2 Occurs 13 Times ×13 | The period (as defined by the General Ledger) billed amount for invoices entered for this period. | AR13.1, AR13.2, AR501, ARLL.1, CB06.2 |
ARP-PERIOD-CRDTSPERIOD_CRDTS | Signed 18.2 Occurs 13 Times ×13 | The period (as defined by the General Ledger) credit amount for credit memos entered for this period. | AR501, ARLL.1 |
ARP-PERIOD-WROFFSPERIOD_WROFFS | Signed 18.2 Occurs 13 Times ×13 | The period (as defined by the General Ledger) write-off amount for write-offs entered for this period. | AR501 |
ARP-PERIOD-PAIDPERIOD_PAID | Signed 18.2 Occurs 13 Times ×13 | The period (as defined by the General Ledger) paid amount for payments entered for this period. | AR13.1, AR13.2, AR501, ARLL.1, CB06.2, CB191 |
ARP-PERIOD-CHGBKSPERIOD_CHGBKS | Signed 18.2 Occurs 13 Times ×13 | The period (as defined by the General Ledger) chargeback amount for chargebacks entered for this period. | AR13.1, AR13.2, AR501, ARLL.1, CB06.2 |
ARP-PERIOD-EA-DISCPERIOD_EA_DISC | Signed 18.2 Occurs 13 Times ×13 | — | AR13.1, AR13.2, AR501, ARLL.1, CB06.2 |
ARP-PERIOD-UE-DISCPERIOD_UE_DISC | Signed 18.2 Occurs 13 Times ×13 | — | AR13.1, AR13.2, AR501, ARLL.1, CB06.2 |
Indexes (1)
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 |
|---|---|---|---|---|
ARPSET1 | COMPANY, CUSTOMER, YEAR | Primary | AR10.1, AR13.1, AR13.2, AR301, AR501, ARLL.1, CB06.2, CB191 |