Category

 

Table Name CLS_CATEGORY_MASTER

 

 

Table Comment This table contains Category details Category component enables user to classify various masters and transactions into different groups for better control. Assumptions: · The Category component would be deployed at the LO level. · Inter OU interaction of &nbspCategory would take place.

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

 Table Column Is PK Table Column Is FK

CAT_CATEGORY

varchar(255)

NOT NULL

Category The various Category defined for a OU Eg : Transport Mode

 Yes No

CAT_CATEGORY_TYPE

varchar(5)

NOT NULL

Unique Category type which is defined under the category Eg : For Transport Type Category, different category could be 1) AIR 2) RAIL 3) SHIP 4) ROAD

 Yes No

CAT_OU

INT

NOT NULL

Organisations Unit, where the Category details is defined.

 Yes No

CAT_LO

varchar(20)

NOT NULL

LO Information where the category created Logistics Level Retrieved from EMOD based on OU and stored here Category information maintained at LO level

 No No

CAT_TYPE_DESC

varchar(255)

NOT NULL

Description of the Category Type

 No No

CAT_TYPE_DESC_SHD

varchar(255)

NULL

Shadow column for the category desc

 No No

CAT_STATUS

varchar(8)

NULL

It holds current status of the category type The Category Type Status can be any one of the following, 1. Active 2. Inactive 3. Cancelled ---------------------------------- Meta Data Values ---------------------------------- Active              &nbspAC Inactive           &nbspIA Cancelled        &nbspCA ----------------------------------

 No No

CAT_PREV_STATUS

varchar(8)

NULL

The previous status value will be stored in this column.

 No No

CAT_DFLT_FLAG

varchar(8)

NOT NULL

The default value , possible values may be yes or no.

 No No

CAT_CREATED_BY

varchar(30)

NULL

Login User , one who created the Record

 No No

CAT_CREATED_DATE

datetime

NOT NULL

The Date when the record had been created

 No No

CAT_MODIFIED_BY

varchar(30)

NULL

Login User , who recently made the transaction on the record

 No No

CAT_MODIFIED_DATE

datetime

NULL

The Last Date of Modification of the record

 No No

CAT_TIMESTAMP_VALUE

INT

NOT NULL

Timestamp value Will be updated by each transaction

 No No

CAT_ADDL1

INT

NULL

The additional column may be used for future reference with integer datatype.

 No No

CAT_ADDL2

varchar(255)

NULL

The additional column may be used for future reference with char datatype.

 No No

CAT_ADDL3

varchar(255)

NULL

The additional column may be used for future reference with char datatype.

 No No