|
|
MINCUSTCL FILE
AR Minor Customer Class
The AR Minor Customer Class file holds all customer minor classes. Every
minor class must belong to one customer major class (major classes are kept in
the AR Major Customer file). Many minor classes can have the same major class.
Every customer must belong to one major and minor class. These classes are
used for reporting selection criteria.
REFERENCED BY
AR150 AR170 AR205 AR210 AR234 AR250
AR251 AR253 AR260 AR271 AR292 DT150
UPDATED BY
AR05.1 AR08.1 AR09.1 AR10.1 AR301 AR501
AR550 BL02.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
MNC-MAJOR-CLASS Alpha 4 AR05.1
Element: Major Class This is the major customer class.
MNC-MINOR-CLASS Alpha 4 AR05.1
Element: Minor Class This is the minor customer class.
MNC-DESC Alpha 30 (Lower Case) AR05.1
Element: Description This is the minor customer class
description.
MNC-USED-FL Alpha 1 AR08.1 AR09.1
Element: Used This is the minor customer class used AR10.1 AR301
flag. If this minor class has been used, AR501 AR550
it may not be deleted. Valid values are: BL02.1
N = No; Class not used
Y = Yes; Class has been used
MINCUSTCL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
MNCSET1 MAJOR-CLASS This is the primary path used to access AR05.1 AR08.1
MINOR-CLASS records. AR09.1 AR10.1
AR150 AR170
AR205 AR210
AR234 AR250
AR251 AR253
AR260 AR271
AR292 AR301
AR501 AR550
BL02.1 DT150
MINCUSTCL FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Majcustclass MAJCUSTCL Required
MNC-MAJOR-CLASS -> MJC-MAJOR-CLASS
|
