ARCUSTFLDS FILE
AR Customer User Fields
The AR Customer User Fields file carries the user-defined field information
for each customer. User-defined field information consists of ten fields at
the company customer level. These fields serve as reference fields only.
REFERENCED BY
AC551 AR211 AR219 AR48.1 AR48.3 BR10.1
BR11.1 BR120 BR121 BR210 BR211 BR220
BR420 BR450 BRIP.1 CB06.2 IC02.1 IC531
MX223 PBIP.1 PR197 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
AR10.1 AR301 AR501 AR550
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ACF-COMPANY Numeric 4 AR10.1 AR501
Company Company number. AR550
ACF-CUSTOMER Alpha 9 (Right Justified) AR10.1 AR501
Customer Customer number. AR550
ACF-CUST-USER1 Alpha 10 AR10.1 AR501
Customer User 1 Customer user-defined field 1. The data AR550
is optionally maintained in AR10.1
(Customer).
ACF-CUST-USER2 Alpha 18 AR10.1 AR501
Customer User 2 Customer user-defined field 2. This AR550
data is optionally maintained in AR10.1
(Customer).
ACF-CUST-USER3 Signed 15.2 AR10.1 AR501
Customer User 3 Customer user-defined field 3. This AR550
data is optionally maintained in AR10.1
(Customer).
ACF-CUST-USER4 Signed 15.2 AR10.1 AR501
Customer User 4 Customer user-defined field 4. This AR550
data is optionally maintained in AR10.1
(Customer).
ACF-CUST-USER5 Numeric 9 AR10.1 AR501
Customer User 5 Customer user-defined field 5. This AR550
data is optionally maintained in AR10.1
(Customer).
ACF-CUST-USER6 Alpha 30 AR10.1 AR501
Customer User 6 Customer user-defined field 6. This AR550
data is optionally maintained in AR10.1
(Customer).
ACF-CUST-USER7 Alpha 30 AR10.1 AR501
Customer User 7 Customer user-defined field 7. This AR550
data is optionally maintained in AR10.1
(Customer).
ACF-CUST-USER8 Numeric 8 (yyyymmdd) AR10.1 AR501
Customer User 8 Customer user-defined field 8. This AR550
data is optionally maintained in AR10.1
(Customer).
ACF-CUST-USER9 Numeric 3 AR10.1 AR501
Customer User 9 Customer user-defined field 9. This AR550
data is optionally maintained in AR10.1
(Customer).
ACF-CUST-USER10 Alpha 3 AR10.1 AR501
Customer User 10 Customer user-defined field 10. This AR550
data is optionally maintained in AR10.1
(Customer).
ARCUSTFLDS FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ACFSET1 COMPANY This is the primary path used to access AC551 AR10.1
CUSTOMER customer fields records. AR211 AR219
AR301 AR48.1
AR48.3 AR550
BR10.1 BR11.1
BR120 BR121
BR210 BR211
BR220 BR420
BR450 BRIP.1
CB06.2 IC02.1
IC531 MX223
PBIP.1 PR197
TX140 TX40.1
WH110 WH120
WH130 WH132
...
ARCUSTFLDS FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Arcustomer ARCUSTOMER Required
ACF-COMPANY -> ACM-COMPANY
ACF-CUSTOMER -> ACM-CUSTOMER
|
