ARCUSTTOTS FILE
AR Customer PL Inclusions
AR Customer PL Inclusions
REFERENCED BY
AC115 AC15.2 AC450 AR42.1 AR42.2 AR42.6
AR42.7 AR43.1 AR44.3 AR502 AR560 BL02.1
BL02.2 BL04.1 BL120 BL121 BL122 BL123
BL130 BL20.1 BL20.3 BL202 BL204 BL21.2
BL21.5 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 BL80.1 BL80.3 BL802
BL81.1 BL820 BL85.1 BL85.2 BL90.1 BL902
BL92.1 BL940 DT150 DT155 DT160 DT165
DT166 DT180 DT30.1 DT30.2 DT40.1 DT45.1
DT520 DT60.1 DT60.2 DT70.1 DT70.3 DT80.1
DT85.1 DT85.2 DT92.1 OE10.1 OE10.2 OE10.3
OE10.4 OE10.5 OE10.6 OE10.7 OE10.8 OE11.1
OE11.4 OE11.8 OE11.9 OE110 OE112 OE113
OE114 OE129 OE130 OE14.3 OE14.4 OE15.1
OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE230
OE254 OE260 OE270 OE271 OE272 OE284
OE285 OE286 OE290 OE291 OE292 OE293
OE294 OE30.1 OE30.2 OE30.3 OE30.4 OE30.5
OE30.6 OE30.7 OE30.9 OE330 OE510 OE53.1
OE54.1 OE60.1 OE80.1 OE80.2 OE81.1 OE81.2
OE810 OE830 OE85.1 OE90.1 OE90.2 OE920
OE950 PBIP.1 SA03.1 SA100 SA252 SA254
SA256 SA261 SA271 SA281 SA291 SA300
SA80.2 SA90.2 TX140 TX40.1 WH110 WH120
WH130 WH132 WH190 WH20.2 WH20.7 WH21.2
WH30.1 WH30.2 WH30.3 WH31.1 WH31.2 WH31.3
WH32.1 WH32.2 WH32.3 WH33.5 WH34.1 WH34.2
WH34.3 WH34.4 WH40.1 WH40.2 WH520 WH830
UPDATED BY
AR10.1 AR10.2 AR301
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CUT-COMPANY Numeric 4 AR10.2
Company Company number. Must be a valid company
in the AR Company file.
CUT-CUSTOMER Alpha 9 (Right Justified) AR10.2
Customer Customer number.
CUT-PROCESS-LEVEL Alpha 5 AR10.2
Process Level Process Level that is included
(invoicing restricted to) for invoicing.
CUT-PL-EXCL-FL Alpha 1 AR10.2
Process Level Process level exclusion flag. Used in
Exclusion conjunction with the process level
inclusion flag in the customer file.
Valid values are:
I = Process level invoice allowed
Blank = Process level invoice not
allowed
ARCUSTTOTS FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CUTSET1 COMPANY The path is used to keep the records AC115 AC15.2
CUSTOMER unique. AC450 AR10.1
PROCESS-LEVEL AR10.2 AR301
AR42.1 AR42.2
AR42.6 AR42.7
AR43.1 AR44.3
AR502 AR560
BL02.1 BL02.2
BL04.1 BL120
BL121 BL122
BL123 BL130
BL20.1 BL20.3
BL202 BL204
BL21.2 BL21.5
BL220 BL231
...
ARCUSTTOTS FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Arcomp ARCOMP Required
CUT-COMPANY -> ACO-COMPANY
Arcustomer ARCUSTOMER Required
CUT-COMPANY -> ACM-COMPANY
CUT-CUSTOMER -> ACM-CUSTOMER
Arproclevl ARPROCLEVL Required
CUT-COMPANY -> APV-COMPANY
CUT-PROCESS-LEVEL -> APV-PROCESS-LEVEL
Customername CUSTDESC Required
ACO-CUST-GROUP -> CUD-CUST-GROUP
ACM-CUSTOMER -> CUD-CUSTOMER
|