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
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
CB06.2 MA41.1 MA41.2 MA41.4 MA41.7 MA43.1
MA43.2 MA43.3 MA43.4 MA43.6 MA43.7 MAI1.1
PO136 PO190 PO300 PO520 POCP.1 POI3.1
POII.1 POIJ.1 TX140 TX40.1


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
...
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 CB06.2
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7


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: Wed Jun 08 20:47:57 2016

Home
Contact Us



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