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