STATICCUST

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 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 IC140 IC66.1 IC83.1
MA180 MA41.1 MA41.2 MA41.4 MA41.7 MA42.2
MA43.2 MA43.7 MA44.1 MA44.2 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 PO100 PO101 PO122 PO131
PO136 PO150 PO190 PO20.1 PO20.6 PO20.9
PO21.1 PO21.2 PO21.3 PO21.4 PO21.5 PO22.1
PO22.3 PO22.4 PO23.1 PO24.1 PO25.1 PO25.5
PO25.6 PO25.7 PO27.2 PO28.2 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 RQ10.1 RQ10.2 RQ10.4
RQ12.1 RQ13.1 RQ13.2 RQ35.1 RQ500 RQIF.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 ZW130


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
API1.1 API2.1
AR301 BR00.1
BR00.2 BR02.3
BR10.1 BR10.9
BR11.1 BR120
BR121 BR122


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 11:09:15 2016

Home
Contact Us



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