ARCUSTTOTS FILE
AR Customer PL Inclusions
The AR Customer PL Inclusions file will hold the information regarding a
customer's inclusion process levels for invoicing (maintained and created in
AR10.2 (Customer Process Level Inclusions). This record will also be created
by AR560 (Transaction Interface).
REFERENCED BY
AR219 AR42.1 AR42.2 AR42.6 AR42.7 AR43.1
AR44.3 AR48.1 AR48.3 AR502 AR560 ARLL.1
BL02.1 BL04.1 BL120 BL121 BL122 BL123
BL125 BL130 BL20.1 BL20.3 BL20.6 BL202
BL204 BL21.2 BL21.5 BL217 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
BL530 BL546 BL80.1 BL80.3 BL802 BL81.1
BL82.1 BL820 BL85.1 BL85.2 BL90.1 BL92.1
BR00.1 BR00.2 BR02.3 BR10.1 BR11.1 BR120
BR121 BR122 BR140 BR16.1 BR17.1 BR19.1
BR20.1 BR20.2 BR20.3 BR20.4 BR20.5 BR20.7
BR21.2 BR210 BR211 BR216 BR217 BR220
BR400 BR420 BR45.1 BR450 BR46.1 BR46.2
BR46.4 BR521 BRIP.1 CB06.2 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 IC02.1
IC531 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 OE111 OE112 OE113 OE114
OE116 OE129 OE13.2 OE13.3 OE13.5 OE13.6
OE130 OE14.3 OE14.4 OE16.1 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 OE530
OE54.1 OE60.1 OE80.1 OE80.2 OE81.1 OE81.2
OE810 OE830 OE85.1 OE85.3 OE86.1 OE90.1
OE90.2 PBIP.1 PR197 SA03.1 SA100 SA252
SA254 SA256 SA261 SA271 SA281 SA291
SA300 SA80.2 SA90.2 TX140 TX40.1 WH110
WH120 WH130 WH132 WH190 WH20.1 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
WO30.1
UPDATED BY
AR10.1 AR10.2 AR301
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CUT-COMPANY Numeric 4 AR10.2
Element: Company Company number. Must be a valid company
in the AR Company file.
CUT-CUSTOMER Alpha 9 (Right Justified) AR10.2
Element: Customer Customer number.
CUT-PROCESS-LEVEL Alpha 5 AR10.2
Element: 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 AR10.1 AR10.2
CUSTOMER unique. AR219 AR301
PROCESS-LEVEL AR42.1 AR42.2
AR42.6 AR42.7
AR43.1 AR44.3
AR48.1 AR48.3
AR502 AR560
ARLL.1 BL02.1
BL04.1 BL120
BL121 BL122
BL123 BL125
BL130 BL20.1
BL20.3 BL20.6
BL202 BL204
BL21.2 BL21.5
...
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
|
