MAJCUSTCL

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 AR205 AR210


UPDATED BY
AR05.1 AR09.1 AR10.1 AR301 AR501 AR550
TX140

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
MJC-MAJOR-CLASS
Element: Major Class
Alpha 4
This is the user-defined major customer class.
AR05.1
MJC-DESC
Element: Description
Alpha 30 (Lower Case)
This is the major customer class description.
AR05.1
MJC-ACTIVE-STATUS
Element: Active Status
Alpha 1
Active Status flag indicates whether or not a particular customer major class is active. Valid values are: A = Active I = Inactive
AR05.1
MJC-USED-FL
Element: Used Fl
Alpha 1
This is the used flag for the major customer class. If this class has been used, the class may not be deleted. Valid values are: N = No; Class has not been used Y = Yes; Class has been used
AR05.1 AR09.1
AR10.1 AR301
AR501 AR550
TX140


MAJCUSTCL FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
MJCSET1 MAJOR-CLASS
AR05.1 AR08.1
AR09.1 AR10.1
AR205 AR210
AR301 AR501
AR550 TX140


MAJCUSTCL FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Mincustclass MINCUSTCL Delete Cascades
MJC-MAJOR-CLASS->MNC-MAJOR-CLASS
  MNC-MINOR-CLASS


File created: Thu Jun 09 02:09:12 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.