|
|
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 AR10.1 AR501 AR550
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 AR10.1
Element: Used This is the minor customer class used AR501 AR550
flag. If this minor class has been used,
it may not be deleted. Valid values are:
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. AR10.1 AR150
AR170 AR205
AR210 AR234
AR250 AR251
AR253 AR260
AR271 AR292
AR501 AR550
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
|
