|
|
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
AR120 AR150 AR170 AR205 AR210 AR234
AR250 AR251 AR253 AR260 AR271 AR292
AR300 DT150
UPDATED BY
AR05.1 AR08.1 AR09.1 AR10.1 AR301 AR501
AR550 BL02.1 BL802 PW550 TX140
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 Fl 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 BL802
PW550 TX140
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 AR05.1 AR08.1
MINOR-CLASS AR09.1 AR10.1
AR120 AR150
AR170 AR205
AR210 AR234
AR250 AR251
AR253 AR260
AR271 AR292
AR300 AR301
AR501 AR550
BL02.1 BL802
DT150 PW550
TX140
MINCUSTCL FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Majcustclass MAJCUSTCL Required
MNC-MAJOR-CLASS -> MJC-MAJOR-CLASS
|
