STATICCUST FILE
AR Override Static Cust Agings
AR Override Static Cust Agings
REFERENCED BY
AC115 AC15.2 AC450 AR72.1 AR73.1 BL02.1
BL02.2 BL04.1 BL120 BL121 BL122 BL123
BL130 BL20.1 BL20.3 BL202 BL204 BL21.2
BL21.5 BL220 BL231 BL246 BL29.1 BL29.2
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 BL520 BL80.1 BL80.3 BL802
BL81.1 BL820 BL85.1 BL85.2 BL90.1 BL902
BL92.1 BL940 OE10.1 OE10.2 OE10.3 OE10.4
OE10.5 OE10.6 OE10.7 OE10.8 OE11.1 OE11.4
OE11.8 OE11.9 OE110 OE112 OE113 OE114
OE129 OE130 OE14.3 OE14.4 OE15.1 OE15.2
OE15.3 OE15.4 OE15.5 OE15.7 OE230 OE254
OE260 OE270 OE271 OE272 OE284 OE285
OE286 OE290 OE291 OE292 OE293 OE294
OE30.1 OE30.2 OE30.3 OE30.4 OE30.5 OE30.6
OE30.7 OE30.9 OE330 OE510 OE53.1 OE54.1
OE60.1 OE80.1 OE80.2 OE81.1 OE81.2 OE810
OE830 OE85.1 OE90.1 OE90.2 OE920 OE950
PBIP.1 SA03.1 SA100 SA252 SA254 SA256
SA261 SA271 SA281 SA291 SA300 SA80.2
SA90.2 TX140 TX40.1 WH110 WH120 WH130
WH132 WH190 WH20.2 WH20.7 WH21.2 WH30.1
WH30.2 WH30.3 WH31.1 WH31.2 WH31.3 WH32.1
WH32.2 WH32.3 WH33.5 WH34.1 WH34.2 WH34.3
WH34.4 WH40.1 WH40.2 WH520 WH830
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 AC115 AC15.2
CUSTOMER records. AC450 AR194
AR301 AR72.1
AR73.1 BL02.1
BL02.2 BL04.1
BL120 BL121
BL122 BL123
BL130 BL20.1
BL20.3 BL202
BL204 BL21.2
BL21.5 BL220
BL231 BL246
BL29.1 BL29.2
BL290 BL291
BL31.1 BL31.2
...
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
|