STATICCUST

AR Ovrd Credit Trans Review

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
AP510 API1.1 API2.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 BR49.1 BR51.1 BR51.2
BR52.1 BR52.2 BR521 BR53.1 BR55.2 BR70.1
BR70.2 BR91.1 BRIP.1 CB06.2 CX100 CX20.1
CX20.2 CX20.4 CX20.5 CX220 CX30.1 CX300
CX506 CXCP.1 DR100 IC02.1 IC12.1 IC140
IC141 IC142 IC145 IC243 IC330 IC64.1
IC64.2 IC64.3 IC64.4 IC64.5 IC64.6 IC64.7
IC64.8 IC64.9 IC66.1 IC83.1 MA180 MA278
MA41.1 MA41.2 MA41.4 MA41.7 MA42.2 MA43.2
MA43.7 MA44.1 MA44.2 MA53.1 MA530 MA531
MA60.2 MA60.3 MA60.5 MA61.1 MA66.2 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 PD570 PO04.1 PO04.2 PO10.1
PO10.2 PO100 PO101 PO115 PO120 PO122
PO131 PO132 PO136 PO15.1 PO15.2 PO15.4
PO150 PO17.1 PO190 PO20.1 PO20.6 PO20.9
PO204 PO21.1 PO21.2 PO21.3 PO21.4 PO21.5
PO22.1 PO22.3 PO22.4 PO220 PO222 PO224
PO225 PO229 PO23.1 PO230 PO234 PO24.1
PO25.1 PO25.5 PO25.6 PO25.7 PO251 PO26.3
PO26.7 PO26.9 PO27.2 PO27.3 PO27.4 PO275
PO276 PO277 PO28.2 PO280 PO29.1 PO30.1
PO30.2 PO30.3 PO30.4 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 PO54.5 POCP.1 POI3.1
POID.1 POII.1 POIJ.1 RQ01.1 RQ10.1 RQ10.2
RQ10.3 RQ10.4 RQ10.5 RQ11.1 RQ12.1 RQ13.1
RQ13.2 RQ35.1 RQ44.1 RQ500 RQ810 RQIB.1
RQIF.1 RQII.1 RQIJ.1 TX140 TX40.1 WH110
WH120 WH130 WH132 WH190 WH20.1 WH20.2
WH20.7 WH21.2 WH222 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 WH32.5
WH33.1 WH33.2 WH33.3 WH33.4 WH33.5 WH33.6
WH33.8 WH33.9 WH34.1 WH34.2 WH34.3 WH34.4
WH40.1 WH40.2 WH520 WH830


UPDATED BY
AR301

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
STA-COMPANY
Element: Company
Numeric 4
The number representing an AR company.
STA-CUSTOMER
Element: Customer
Alpha 9 (Right Justified)
This contains the customer number for this aging record.
STA-AGING-CODE
Element: Aging Code
Numeric 2
This is the customer aging code that defines the static aging amounts.
STA-STATIC-CUR
Element: Static Current
Signed 18.2
This will contain the static amounts that are current (and future) for customer.
STA-AGING
Element: Aging
Signed 18.2 Occurs 5 Times
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
CUSTOMER
...
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
AP510 API1.1
API2.1 AR301
BR00.1 BR00.2
BR02.3 BR10.1
BR10.9 BR11.1
BR120 BR121


STATICCUST FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED 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


File created: Thu Jun 09 02:09:15 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.