FRBALANCE FILE
FR Statement Balances
This file keeps a rolling ten period statement balance for use in receivable
reporting.
UPDATED BY
AR150
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
FRB-COMPANY Numeric 4 AR150
Company This field contains the company number
defined in the General Ledger, Accounts
Receivable, and Billing systems.
FRB-CUSTOMER Alpha 9 (Right Justified) AR150
Customer Number This field contains the customer number,
which is defined in the Accounts
Receivable system.
FRB-LAST-STA-DATE Numeric 8 (yyyymmdd) Occurs 11 Times AR150
Last Statement Date This field contains the date of the last
statement created by FR150 (Statement
Report) for the customer.
FRB-LAST-STA-BAL Signed 15.2 Occurs 11 Times AR150
Last Statement This field contains the balance of the
Balance last statement created by FR150
(Statement Report) for the customer.
FRBALANCE FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
FRBSET1 COMPANY AR150
CUSTOMER
FRBALANCE FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Arcomp ARCOMP Required
FRB-COMPANY -> ACO-COMPANY
Arcustomer ARCUSTOMER Required
FRB-COMPANY -> ACM-COMPANY
FRB-CUSTOMER -> ACM-CUSTOMER
Custdesc CUSTDESC Required
ACO-CUST-GROUP -> CUD-CUST-GROUP
FRB-CUSTOMER -> CUD-CUSTOMER
Salesrep SALESREP Required
FRB-COMPANY -> SAW-COMPANY
ACM-SALESMAN -> SAW-SALESMAN
|
