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
BR10.1 BR11.1 BR120 BR121 BR210 BR211
BR220 BR420 BR450 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 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 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 AC551 AR10.1
CUSTOMER unique. AR10.2 AR219
PROCESS-LEVEL AR301 AR42.1
AR42.2 AR42.6
AR42.7 AR43.1
AR44.3 AR48.1
AR48.3 AR502
AR560 BR10.1
BR11.1 BR120
BR121 BR210
BR211 BR220
BR420 BR450
BRIP.1 CB06.2
DT150 DT155
DT160 DT165
...
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
|
