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 AP25.1 AP25.2
AP26.1 AP27.1 AR219 AR48.1 AR48.3 AR72.1
BR10.1 BR11.1 BR120 BR121 BR210 BR211
BR220 BR420 BR450 BRIP.1 CB06.2 IC02.1
IC28.1 IC531 MX223 MA180 MA43.9 MA530
MA531 MA60.2 MA60.3 MA60.5 MA61.1 MA66.3
MA67.1 MA67.2 MA70.1 MAI1.1 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 TX140
TX40.1 WH110 WH120 WH130 WH132 WH190
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
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 AP125
CUSTOMER records. AP126 AP131
AP25.1 AP25.2
AP26.1 AP27.1
AR194 AR219
AR301 AR48.1
AR48.3 AR72.1
BR10.1 BR11.1
BR120 BR121
BR210 BR211
BR220 BR420
BR450 BRIP.1
CB06.2 IC02.1
IC28.1 IC531
MX223 MA180
...
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
|
