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 AP125 AP126 AP131 AP20.1 AP20.2
AP20.3 AP20.4 AP20.5 AP20.7 AP23.1 AP25.1
AP25.2 AP26.1 AP27.1 AP30.4 API1.1 AR219
AR48.1 AR48.3 AR72.1 BR10.1 BR11.1 BR120
BR121 BR122 BR123 BR15.1 BR151 BR152
BR155 BR156 BR16.1 BR16.2 BR210 BR211
BR215 BR220 BR251 BR252 BR253 BR420
BR450 BR51.1 BR51.2 BR52.1 BR52.2 BR521
BR53.1 BR55.2 BR91.1 BRIP.1 BRPI.1 CB06.2
IC02.1 IC28.1 IC531 MA180 MA41.2 MA41.7
MA43.1 MA43.2 MA43.3 MA43.9 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
PBIP.1 PO100 PO101 PO122 PO131 PO20.1
PO21.1 PO21.2 PO21.3 PO21.4 PO21.5 PO22.1
PO23.1 PO25.1 PO25.5 PO25.6 PO25.7 PO27.2
PO29.1 PO30.1 PO30.2 PO30.3 PO300 PO31.1
PO31.2 PO32.2 PO33.1 PO34.1 PO35.1 PO36.1
PO36.2 PO38.1 PO39.1 PO39.2 PO44.1 PO50.1
PO52.1 PO520 PO536 POI3.1 POII.1 POIJ.1
PR197 RQ10.1 RQ10.2 RQ10.3 RQIE.1 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 15.2 AR194
Element: Static CurrentThis will contain the static amounts
that are current (and future) for
customer.
STA-AGING Signed 15.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 AC551 AP125
CUSTOMER records. AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 AR194
AR219 AR301
AR48.1 AR48.3
AR72.1 BR10.1
BR11.1 BR120
BR121 BR122
BR123 BR15.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
|
