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
AC551 AR219 AR42.1 AR42.2 AR42.6 AR42.7
AR43.1 AR44.3 AR48.1 AR48.3 AR502 AR560
BL02.1 BL04.1 BL121 BL123 BL125 BL202
BL204 BL217 BL220 BL231 BL246 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 BL80.1 BL80.3 BL802 BL81.1 BL82.1
BL85.1 BL85.2 BL90.1 BR10.1 BR11.1 BR120
BR121 BR210 BR211 BR220 BR420 BR450
BRIP.1 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 PR197 TX140 TX40.1
WH110 WH120 WH130 WH21.2 WH33.1 WH33.2
WH33.3 WH33.4 WH33.5 WH33.6 WH33.8 WH33.9
WH34.1 WH34.2 WH34.3 WH34.4
UPDATED BY
AR301
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CUT-COMPANY Numeric 4
Company Company number. Must be a valid company
in the AR Company file.
CUT-CUSTOMER Alpha 9 (Right Justified)
Customer Customer number.
CUT-PROCESS-LEVEL Alpha 5
Process Level Process Level that is included
(invoicing restricted to) for invoicing.
CUT-PL-EXCL-FL Alpha 1
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 AC551 AR219
CUSTOMER unique. AR301 AR42.1
PROCESS-LEVEL AR42.2 AR42.6
AR42.7 AR43.1
AR44.3 AR48.1
AR48.3 AR502
AR560 BL02.1
BL04.1 BL121
BL123 BL125
BL202 BL204
BL217 BL220
BL231 BL246
BL290 BL291
BL31.1 BL31.2
BL31.3 BL31.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
|
