ARFINRATE – Finance Charge Rates
- System
- Accounts Receivable (AR)
- Prefix
AFI- Primary key
FIN-CHRG-CD,EFF-DATE- Fields
- 3
- Updated by
- 1 program
- Referenced by
- 1 program
ARFINRATE is the Finance Charge Rates table in Lawson Accounts Receivable (prefix AFI). It is indexed by FIN-CHRG-CD, EFF-DATE (AFISET1); alternate indexes: AFISET2. It is updated by AR07.2 and referenced by AR207. The table has 3 fields, 2 indexes and 0 documented relations.
About ARFINRATE
This file contains one or more finance charge rates, expressed as a monthly rate, for a finance charge code.
Fields (3)
Column = COBOL field name without the AFI- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
AFI-FIN-CHRG-CD PKFIN_CHRG_CD | Alpha 2 | Finance charge code. At least one effective rate and charge rate must be attached to a finance charge code. Multiple effective dates and rates can be attached. | AR07.2 |
AFI-EFF-DATE PKEFF_DATE | Numeric 8 (yyyymmdd) | Effective date for the charge rate. | AR07.2 |
AFI-CHRG-RATECHRG_RATE | Percent 7.5 (Percent) | Finance charge rate per month. A charge rate is specified for each effective date. | AR07.2 |
Indexes (2)
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 |
|---|---|---|---|---|
AFISET1 | FIN-CHRG-CD, EFF-DATE | Primary | AR07.1, AR07.2 | |
AFISET2 | FIN-CHRG-CD, EFF-DATE* | AR207 |
Programs
Updated by (1)
- AR07.2 Finance Charge Rates
Referenced by (1)
- AR207 Finance Charge Listing