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 BR122 BR123
BR15.1 BR151 BR152 BR155 BR156 BR16.1
BR16.2 BR210 BR211 BR215 BR220 BR251
BR252 BR253 BR420 BR450 BR51.1 BR51.2
BR52.1 BR52.2 BR521 BR53.1 BR55.2 BR91.1
BRIP.1 BRPI.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
PBIP.1 PR197 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 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 BR122
BR123 BR15.1
BR151 BR152
BR155 BR156
BR16.1 BR16.2
BR210 BR211
...
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
|
