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
AP125 AP126 AP131 AP25.1 AP25.2 AP26.1
AP27.1 AP30.4 AR219 AR48.1 AR48.3 AR72.1
BL02.1 BL04.1 BL120 BL121 BL122 BL123
BL125 BL130 BL20.1 BL20.3 BL20.6 BL202
BL204 BL21.2 BL21.5 BL217 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
BL530 BL546 BL80.1 BL80.3 BL802 BL81.1
BL82.1 BL820 BL85.1 BL85.2 BL90.1 BL92.1
BR00.1 BR00.2 BR02.3 BR10.1 BR11.1 BR120
BR121 BR122 BR140 BR16.1 BR17.1 BR19.1
BR20.1 BR20.2 BR20.3 BR20.4 BR20.5 BR20.7
BR21.2 BR210 BR211 BR216 BR217 BR220
BR400 BR420 BR45.1 BR450 BR46.1 BR46.2
BR46.4 BR521 BRIP.1 CB06.2 IC02.1 IC28.1
IC531 MA180 MA530 MA531 MA60.2 MA60.3
MA60.5 MA61.1 MA66.2 MA66.3 MA67.1 MA67.2
MA70.1 MA75.1 MA80.1 MAI1.1 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 OE111
OE112 OE113 OE114 OE116 OE129 OE13.2
OE13.3 OE13.5 OE13.6 OE130 OE14.3 OE14.4
OE16.1 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 OE530 OE54.1 OE60.1 OE80.1
OE80.2 OE81.1 OE81.2 OE810 OE830 OE85.1
OE85.3 OE86.1 OE90.1 OE90.2 PBIP.1 PO100
PO101 PO122 PO131 PO20.1 PO21.2 PO21.3
PO21.4 PO21.5 PO22.1 PO23.1 PO29.1 PO30.1
PO30.2 PO30.3 PO300 PO31.1 PO31.2 PO32.2
PO33.1 PO34.1 PO35.1 PO38.1 PO39.1 PO39.2
PO44.1 PO50.1 PO52.1 PO520 POI3.1 POIE.1
POII.1 POIJ.1 PR197 RQ10.1 RQ10.2 SA03.1
SA100 SA252 SA254 SA256 SA261 SA271
SA281 SA291 SA300 SA80.2 SA90.2 TX140
TX40.1 WH110 WH120 WH130 WH132 WH190
WH20.1 WH20.2 WH20.7 WH21.2 WH224 WH30.1
WH30.2 WH30.3 WH30.4 WH31.1 WH31.2 WH31.3
WH31.4 WH32.1 WH32.2 WH32.3 WH32.4 WH33.5
WH34.1 WH34.2 WH34.3 WH34.4 WH40.1 WH40.2
WH520 WH830 WO30.1
UPDATED BY
AR194 AR301
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
STA-COMPANY Numeric 4 AR194
Element: Company Company number.
STA-CUSTOMER Alpha 9 (Right Justified) AR194
Element: Customer NumbeThis contains the customer number for
this aging record.
STA-AGING-CODE Numeric 2 AR194
Element: 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 18.2 AR194
Element: Static CurrentThis will contain the static amounts
that are current (and future) for
customer.
STA-AGING Signed 18.2 Occurs 5 Times AR194
Element: 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 AP125 AP126
CUSTOMER records. AP131 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
AR194 AR219
AR301 AR48.1
AR48.3 AR72.1
BL02.1 BL04.1
BL120 BL121
BL122 BL123
BL125 BL130
BL20.1 BL20.3
BL20.6 BL202
BL204 BL21.2
BL21.5 BL217
...
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
|
