|
|
STATICCUST FILE
AR Override Static Cust Agings
This 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), and is used in credit management for instant aging display.
REFERENCED BY
AC56.1 AC560 AP125 AP126 AP131 AP20.1
AP20.2 AP20.3 AP20.4 AP20.5 AP20.7 AP21.1
AP23.1 AP25.1 AP25.2 AP26.1 AP27.1 AP30.4
API1.1 AR219 AR48.1 AR48.3 AR72.1 BL02.1
BL04.1 BL10.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 BR10.9 BR11.1
BR120 BR121 BR122 BR123 BR140 BR151
BR152 BR155 BR156 BR16.1 BR16.2 BR17.1
BR180 BR19.1 BR20.1 BR20.2 BR20.3 BR20.4
BR20.5 BR20.7 BR21.2 BR210 BR211 BR216
BR217 BR220 BR251 BR252 BR253 BR400
BR420 BR45.1 BR450 BR46.1 BR46.2 BR46.4
BR51.1 BR51.2 BR52.1 BR52.2 BR521 BR53.1
BR55.2 BR70.1 BR70.2 BR91.1 BRIP.1 CB06.2
IC02.1 MA180 MA41.1 MA41.2 MA41.4 MA41.7
MA43.1 MA43.2 MA43.3 MA43.7 MA530 MA531
MA60.2 MA60.3 MA60.5 MA61.1 MA66.2 MA66.3
MA67.2 MA67.3 MA68.2 MA68.3 MA68.5 MA70.1
MA75.1 MA80.1 MAI1.1 PD10.1 PD10.2 PD130
PD20.1 PD20.2 PD20.3 PO100 PO101 PO122
PO131 PO20.1 PO21.1 PO21.2 PO21.3 PO21.4
PO21.5 PO22.1 PO23.1 PO24.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 PO32.4
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 POID.1 POII.1 POIJ.1 PW110
RQ10.1 RQ10.2 TX140 TX40.1 WH110 WH120
WH130 WH132 WH190 WH20.1 WH20.2 WH20.7
WH21.2 WH224 WH226 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
Element: Company The number representing an AR company.
STA-CUSTOMER Alpha 9 (Right Justified) AR194
Element: Customer This contains the customer number for
this aging record.
STA-AGING-CODE Numeric 2 AR194
Element: Aging Code This is the customer aging code that
defines the static aging amounts.
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 AC56.1 AC560
CUSTOMER AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 AR194
AR219 AR301
AR48.1 AR48.3
AR72.1 BL02.1
BL04.1 BL10.1
BL120 BL121
...
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
|
