STATICCUST FILE
AR Override Static Cust Agings
The AR Override Static Cust Agings file contains customer static aging
amounts where the period definition comes from the customer's aging code
record. This record is created by AR194 (Audit Summary).
REFERENCED BY
AC551 AR219 AR48.1 AR48.3 AR72.1 BL02.1
BL04.1 BL121 BL123 BL125 BL202 BL204
BL217 BL220 BL231 BL246 BL290 BL291
BL31.1 BL31.2 BL31.3 BL31.5 BL31.7 BL32.3
BL32.4 BL33.1 BL331 BL34.1 BL46.1 BL46.2
BL80.1 BL80.3 BL802 BL81.1 BL82.1 BL85.1
BL85.2 BL90.1 BR10.1 BR11.1 BR120 BR121
BR210 BR211 BR220 BR420 BR450 BRIP.1
IC02.1 PR197 TX140 TX40.1 WH110 WH120
WH130 WH21.2 WH33.1 WH33.2 WH33.3 WH33.4
WH33.5 WH33.6 WH33.8 WH33.9 WH34.1 WH34.2
WH34.3 WH34.4
UPDATED BY
AR194 AR301
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
STA-COMPANY Numeric 4 AR194
Company Company number.
STA-CUSTOMER Alpha 9 (Right Justified) AR194
Customer Number This contains the customer number for
this aging record.
STA-AGING-CODE Numeric 2 AR194
Aging Code This is the aging code that was
assigned to the customer at the time
AR194 (Audit Summary) created the static
aging record.
STA-STATIC-CUR Signed 15.2 AR194
Static Current This will contain the static amounts
that are current (and future) for
customer.
STA-AGING Signed 15.2 Occurs 5 Times AR194
Aging This contains the aging values as
defined in the respective aging code
file.
STATICCUST FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
STASET1 COMPANY This is the primary path used to access AC551 AR194
CUSTOMER records. AR219 AR301
AR48.1 AR48.3
AR72.1 BL02.1
BL04.1 BL121
BL123 BL125
BL202 BL204
BL217 BL220
BL231 BL246
BL290 BL291
BL31.1 BL31.2
BL31.3 BL31.5
BL31.7 BL32.3
BL32.4 BL33.1
BL331 BL34.1
...
STATICCUST FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Agingcode AGINGCODE Required
STA-COMPANY -> AGE-COMPANY
STA-AGING-CODE -> AGE-AGING-CODE
Arcomp ARCOMP Required
STA-COMPANY -> ACO-COMPANY
Arcustomer ARCUSTOMER Required
STA-COMPANY -> ACM-COMPANY
STA-CUSTOMER -> ACM-CUSTOMER
|
