BALFWDTOT – AR Balance Forward Cust Totals
- System
- Accounts Receivable (AR)
- Prefix
BFT- Primary key
COMPANY,CUSTOMER,CURRENCY-CD- Fields
- 6
- Updated by
- 1 program
- Referenced by
- 0 programs
BALFWDTOT is the AR Balance Forward Cust Totals table in Lawson Accounts Receivable (prefix BFT). It is indexed by COMPANY, CUSTOMER, CURRENCY-CD (BFTSET1). It is updated by AR301. The table has 6 fields, 1 index and 0 documented relations.
About BALFWDTOT
No description in the Lawson data dictionary.
Fields (6)
Column = COBOL field name without the BFT- 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 |
|---|---|---|---|
#BFT-COMPANY PKCOMPANY | Numeric 4 | The number representing an AR company. | — |
#BFT-CUSTOMER PKCUSTOMER | Alpha 9 (Right Justified) | Customer number. | — |
#BFT-CURRENCY-CD PKCURRENCY_CD | Alpha 5 | Currency code identifying the balance amount. | — |
#BFT-BALANCEFBALANCEF | Signed 18.2 | Balance amount as of the last statement run. | — |
#BFT-DATEDATE | Numeric 8 (yyyymmdd) | "As of" date of the last statement run for this customer. | — |
#BFT-NAT-ACCT-FLNAT_ACCT_FL | Alpha 1 | —
| — |
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 |
|---|---|---|---|---|
BFTSET1 |
| Primary | AR301 |
Programs
Updated by (1)
- AR301 Customer Purge