Data Dictionary -- Logistics Common Master

Srl. No.	Table Name	Comment
1	CLM_CAINF_CARR_AGEN_INFO	This table holds the data of he Carrier Agency Information.
2	CLM_CATINF_CATEGORY_INFO	This table is to capture the category information of all purchase components
3	CLM_CLMPRM_PARAMETER_DETAILS	This table is to Store Parameter details of common logistics master component.
4	CLM_CTAINF_CERT_AUTH_INFO	This table is meant for defining the certifying authority codes
5	CLM_CTINF_CERTIFICATE_INFO	This is the table in which the certificate types are defined
6	CLM_DTC_Delivery_To_Code_Info	This table is to store Delivery code information
7	CLM_FINDEST_FINAL_DEST_INFO	This table is to store final destination code information
8	CLM_INTINF_INSUR_TERMS_INFO	This table is used to to store the Insurance Terms.
9	CLM_IOINF_INV_OPTIONS_INFO	This is the table in which inventory options are defined
10	CLM_IRINF_IR_OPT_INFO	This is the table in which issue route options are defined
11	CLM_ITINF_INCO_TERMS_INFO	This table used to Store the INCO Term Details
12	Clm_MRP_Priority_Code_Info	This table is used to store the manufacture priority code information
13	CLM_MSDINF_MNTSEPDOC_OPT_INFO	This table used to store the Maintenance Option in the various commercial documents such as "Purchase Request", "Purchase Order", "Blanket Purchase Order", "Release Slip", "Goods Receipt", "Repair Order", "Request for Quotation", "Quotation", "Loan Order"
14	CLM_PCINF_PKG_CODE_INFO	This is the table in which packaging codes are defined
15	CLM_POINF_PUR_OPTIONS_INFO	This is the table in which purchase options are defined
16	CLM_PO_SETOPT_DTL	This table is to store the purchase order details
17	CLM_PO_SETOPT_PARAM_VALUES	this table is to store the purchase order parameter values
18	CLM_PO_SETOPT_PERMIT_VALUES	this table is to store the purchase order permitted values
19	CLM_PTINF_PRT_TY_OPT_INFO	This is the table in which part type options are defined.
20	CLM_PYINF_PRTY_CODE_INFO	This is the table in which the priority codes are defined
21	CLM_RNINF_REASON_CODE_INFO	This is the table to capture user defined reason codes with the descriptions for the types "Quarantine" and "Rejection" mainly in GOODS RECEIPT & REPAIR RECEIPTS.
22	CLM_RPINF_REP_PROC_INFO	This is the table in which repair process codes are defined
23	CLM_SCINF_SC_OPT_INFO	Thisi s the table in which stock correction options are defined
24	CLM_SCINF_SHIP_COST_INFO	This is the table in which shipping cost codes are defined
25	CLM_SMINF_SHIP_MET_INFO	This is the table in which shipping method codes are created
26	CLM_UOINF_USR_OPT_INFO	This is the ouinstance in which user options are created
27	CLM_USINF_USER_STATUS_INFO	This is the table in which user status for puchase components are created.
28	LCM_EXRSN_INFO	This table stores the reason for exchange codes informations
29	LCM_LQCD_INFO	This table stores the quick code informations
30	LCM_PARAMETER_DETAILS	This table is used to store the parameter details of Logistics Common Master
31	LCM_set_option_dtl	This table stores the set options details
32	LCM_SET_OPTION_HDR	This table stores the set option header values
33	LCM_SET_OPTION_PARAM_VALUES	This table stores the set option parameter values
34	LCM_SET_OPTION_PERMIT_VALUES	This table stores the set option permitted values

Table Name :	CLM_CAINF_CARR_AGEN_INFO
Comment :	This table holds the data of he Carrier Agency Information.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
CAINF_CREATED_OUINSTANCE	_decimal_10_0	decimal(10)	No	stores the OUinstance	Yes
CAINF_CARR_AGEN_CODE	_varchar_20	varchar(20)	No	stores the carrier/agency code	Yes
CAINF_CARR_AGEN_DESC	_varchar_150	varchar(150)	Yes	stores the carrier/agency code description	No
CAINF_CARR_AGEN_STATUS	_varchar_5	varchar(5)	Yes	stores the status of the carrier/agency code A- Active I - Inactive	No
CAINF_CREATED_DATE	_datetime_8	datetime(8)	Yes	stores the record created date	No
CAINF_CREATED_BY	_varchar_30	varchar(30)	Yes	stores the user who created the record	No
CAINF_MODIFIED_DATE	_datetime_8	datetime(8)	Yes	stores the record modified date	No
CAINF_MODIFIED_BY	_varchar_30	varchar(30)	Yes	stores the user who modified the record	No
CAINF_TIMESTAMP	_decimal_38_0	decimal(38)	Yes	stores the timestamp	No
CAINF_REMARKS	_varchar_255	varchar(255)	Yes	This field holds the remarks of carrier agency	No

Table Name :	CLM_CATINF_CATEGORY_INFO
Comment :	This table is to capture the category information of all purchase components

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
CATINF_CREATED_OUINSTANCE	_decimal_10_0	decimal(10)	No	This is the OU instance in which category info is created	Yes
CATINF_CATEGORY_FOR	_varchar_5	varchar(5)	No	The category for contains the component names for which the category needs to be defined.Allowed values are "PO" - "Purchase Order", "GR" - "Goods Receipt", "GRS" - "Goods Return to Supplier", "PR" - "Purchase Request", "BPO" - "Blanket Purchase	Yes
CATINF_CATEGORY_CODE	_varchar_25	Varchar(25)	No	This field is to capture the category code for the components	Yes
CATINF_CATEGORY_DESC	_varchar_80	varchar(80)	No	This field is to capture the category description	No
CATINF_CREATEDDATE	_datetime_8	datetime(8)	Yes	This field holds the created date of the record	No
CATINF_CATEGORY_STATUS	_varchar_5	varchar(5)	No	This field holds the status of the record .Allowed values are "A"- "Active", "I"- "InActive", "B" - "Blank".	No
CATINF_CREATED_BY	_varchar_30	varchar(30)	No	This field holds the created user of the record	No
CATINF_MODIFIEDDATE	_datetime_8	datetime(8)	Yes	This field holds the modified date of the record	No
CATINF_MODIFIED_BY	_varchar_30	varchar(30)	Yes	This field holds the user who modified the record	No
CATINF_TIMESTAMP	_decimal_10_0	decimal(10)	No	This field holds the timestamp of the record	No

Table Name :	CLM_CLMPRM_PARAMETER_DETAILS
Comment :	This table is to Store Parameter details of common logistics master component.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
CLMPRM_COMPONENTNAME	_varchar_80	varchar(80)	No	This field holds the Name of the component.	Yes
CLMPRM_PARAMCATEGORY	_varchar_10	varchar(10)	No	This field will capture the category of the static value. The static values could be to fill up combo, text field, guidance text, combo default etc.	Yes
CLMPRM_PARAMTYPE	_varchar_25	Varchar(25)	No	Normally param type is the name of the control. This will allow us to store all the possible values for a combo in multiple rows.	Yes
CLMPRM_PARAMCODE	_varchar_5	varchar(5)	No	This is the code that may be used for data storage. This is valid only incase of combo boxes. Here the short code that will be stored as data in the transaction could be maintained.	Yes
CLMPRM_LANGID	_decimal_10_0	decimal(10)	Yes	Language id. This is the language id of the record.	No
CLMPRM_PARAMDESC	_varchar_80	varchar(80)	No	Param description is the values to be filled in the combo box or guidance text. This is actually the meta data of this component	No
CLMPRM_CREATIONDATE	_datetime_8	datetime(8)	Yes	This field holds the record created date for auditing purpose.	No
CLMPRM_SORTBY	_decimal_10_0	decimal(10)	Yes	This field holds the default sort by code	No

Table Name :	CLM_CTAINF_CERT_AUTH_INFO
Comment :	This table is meant for defining the certifying authority codes

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
CTAINF_CREATED_OUINSTANCE	_decimal_10_0	decimal(10)	No	This is the OU Instance in which the certifying authority codes are defined.	Yes
CTAINF_CERT_AUTH_CODE	_varchar_25	Varchar(25)	No	This field holds the certifying authority code	Yes
CTAINF_CERT_AUTH_DESC	_varchar_80	varchar(80)	Yes	This field holds the certifying authority description	No
CTAINF_CERT_AUTH_STATUS	_varchar_15	varchar(15)	Yes	This field holds the certifying authority status	No
CTAINF_CREATEDDATE	_datetime_8	datetime(8)	Yes	This field holds the created date of the record	No
CTAINF_CREATED_BY	_varchar_30	varchar(30)	Yes	This field holds the created user of the record	No
CTAINF_MODIFIEDDATE	_datetime_8	datetime(8)	Yes	This field holds the modified date of the record	No
CTAINF_MODIFIED_BY	_varchar_30	varchar(30)	Yes	This field holds the user who modified the record	No
CTAINF_TIMESTAMP	_decimal_10_0	decimal(10)	Yes	This field holds the timestamp of the record	No

Table Name :	CLM_CTINF_CERTIFICATE_INFO
Comment :	This is the table in which the certificate types are defined

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
CTINF_CREATED_OUINSTANCE	_decimal_10_0	decimal(10)	No	This is the OU instance in which certificate types are defined	Yes
CTINF_CERTIFICATE_FOR	_varchar_5	varchar(5)	No	THe "certificate for" is used to define the certificate type for either part or supplier	Yes
CTINF_CERTIFICATE_TYPE	_varchar_25	Varchar(25)	No	THis field holds the certificate type created by the user.	Yes
CTINF_CERTIFICATE_DESC	_varchar_80	varchar(80)	No	This field holds the description for the certificate type.	No
CTINF_CERTIFICATE_STATUS	_varchar_5	varchar(5)	No	This field holds the status of the record. "A" - "Active", "I" - "Inactive".	No
CTINF_CREATEDDATE	_datetime_8	datetime(8)	No	This field holds the created date of the record	No
CTINF_CREATED_BY	_varchar_30	varchar(30)	No	This field holds the created user of the record	No
CTINF_MODIFIEDDATE	_datetime_8	datetime(8)	No	This field holds the modified date of the record	No
CTINF_MODIFIED_BY	_varchar_30	varchar(30)	No	This field holds the user who modified the record	No
CTINF_TIMESTAMP	_decimal_10_0	decimal(10)	No	This field holds the timestamp of the record	No

Table Name :	CLM_DTC_Delivery_To_Code_Info
Comment :	This table is to store Delivery code information

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
DTC_Ouinstance	udd_ctxt_ouinstance	int(4)	Yes	OU instance for delivery code	No
DTC_Unique_no	udd_count	int(4)	No	unique id for delivery code	Yes
DTC_DeliveryCode	udd_documentno	varchar(40)	Yes	DeliveryCode	No
DTC_Address1	udd_txt255	varchar(255)	Yes	Address1 for delivery code	No
DTC_Address2	udd_txt255	varchar(255)	Yes	Address2 for delivery code	No
DTC_Address3	udd_txt255	varchar(255)	Yes	Address3 for delivery code	No
DTC_City	udd_city	varchar(32)	Yes	City for delivery code	No
DTC_State	udd_state	varchar(32)	Yes	State for delivery code	No
DTC_Country	udd_country	varchar(40)	Yes	Country for delivery code	No
DTC_ZipCode	udd_zip	varchar(15)	Yes	ZipCode for delivery code	No
DTC_ContactPerson	udd_ctxt_user	varchar(30)	Yes	ContactPerson for delivery code	No
DTC_Faxno	udd_taskcode	varchar(30)	Yes	Faxno of the contact person for delivery code	No
DTC_Phoneno	udd_taskcode	varchar(30)	Yes	Phoneno of the contact person for delivery code	No
DTC_Email	udd_taskcode	varchar(30)	Yes	Email id of the contact person for delivery code	No
DTC_Status	udd_designparamcode	varchar(5)	Yes	status of delivery code A-Active,IA-inactive	No
DTC_Timestamp	udd_count	int(4)	Yes	Timestamp of delivery code	No
DTC_CreatedBy	udd_ctxt_user	varchar(30)	Yes	the person who craeted the delivery code	No
DTC_CreatedDate	udd_datetime1	datetime(8)	Yes	the date on which the delivery code is created	No
DTC_ModifiedBy	udd_ctxt_user	varchar(30)	Yes	the person who modified the delivery code	No
DTC_ModifiedDate	udd_datetime1	datetime(8)	Yes	the date on which the delivery code is modified	No

Table Name :	CLM_FINDEST_FINAL_DEST_INFO
Comment :	This table is to store final destination code information

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
FINDEST_FINAL_DEST_CODE	udd_flag	varchar(25)	No	unique code for final destination	Yes
FINDEST_FINAL_DEST_DESC	udd_txt150	varchar(150)	Yes	decsription of final destination code	No
FINDEST_FINAL_DEST_STATUS	udd_paramcode	varchar(30)	No	status of final destination code A- active IA-Inactive	No
FINDEST_CREATEDDATE	udd_datetime	varchar(30)	No	the date when final destination code created	No
FINDEST_CREATED_BY	udd_ctxt_user	varchar(30)	No	the person who created the final destination code	No
FINDEST_MODIFIEDDATE	udd_datetime	varchar(30)	Yes	the date when final destination code modified	No
FINDEST_MODIFIED_BY	udd_ctxt_user	varchar(30)	Yes	the person who modified the final destination code	No
FINDEST_TIMESTAMP	udd_timestamp	int(4)	No	the timwstamp for final destination code	No

Table Name :	CLM_INTINF_INSUR_TERMS_INFO
Comment :	This table is used to to store the Insurance Terms.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
INTINF_CREATED_OUINSTANCE	_decimal_10_0	decimal(10)	No	stores the OUinstance	Yes
INTINF_INSUR_TERM_CODE	_varchar_150	varchar(150)	No	stores the insurance term code	Yes
INTINF_INSUR_TERM_DESC	_varchar_150	varchar(150)	Yes	stores the insurance term description	No
INTINF_INSUR_TERM_STATUS	_varchar_5	varchar(5)	Yes	stores the insurance term code status	No
INTINF_CREATED_DATE	_datetime_8	datetime(8)	Yes	stores the record created date	No
INTINF_CREATED_BY	_varchar_30	varchar(30)	Yes	stores the user who created the record	No
INTINF_MODIFIED_DATE	_datetime_8	datetime(8)	Yes	stores the record modified date	No
INTINF_MODIFIED_BY	_varchar_30	varchar(30)	Yes	stores the user who modified the record	No
INTINF_TIMESTAMP	_decimal_38_0	decimal(38)	Yes	stores the timestamp	No

Table Name :	CLM_IOINF_INV_OPTIONS_INFO
Comment :	This is the table in which inventory options are defined

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
IOINF_CREATED_OUINSTANCE	_decimal_10_0	decimal(10)	No	This is the ouinstance in which inventory options are created.	Yes
IOINF_INV_OPT_ID	_decimal_10_0	decimal(10)	No	This is uniquely generated inventory option id.	Yes
IOINF_WH_CODE_UNIQUE	_varchar_5	varchar(5)	Yes	This field ensures the uniqueness of inventory documents across and within OUs.Allowed Values are "AOU" - "Across Stocking Locations", "WOU" - " Within Location".	No
IOINF_CREATEDDATE	_datetime_8	datetime(8)	Yes	This field holds the created date of the record	No
IOINF_CREATED_BY	_varchar_30	varchar(30)	Yes	This field holds the created user of the record	No
IOINF_MODIFIEDDATE	_datetime_8	datetime(8)	Yes	This field holds the modified date of the record	No
IOINF_MODIFIED_BY	_varchar_30	varchar(30)	Yes	This field holds the user who modified the record	No
IOINF_TIMESTAMP	_decimal_10_0	decimal(10)	Yes	This field holds the timestamp of the record	No
IOINF_STK_STATUS_CORE_RET	_varchar_25	Varchar(25)	Yes	This field holds the active values of status as defined in the interacting UDSS for the stock return component	No
IOINF_STATUS	_varchar_5	varchar(5)	Yes	This field holds the status of the records. A- Active I-Inactive	No
IOINF_STK_VAL_OPT	_varchar_5	varchar(5)	Yes	stores the options for valuation of stock. The valuation can be done either at warehouse level or location level WL - warehouse level LL - Location level	No
IOINF_AOG_MTL_REQ_AUTH	_varchar_5	varchar(5)	Yes	stores the option for material request authorization for A.O.G A - Automatic M - Manual	No
IOINF_MOD_ISSUED_STK_STATUS	udd_designparamcode	varchar(5)	Yes	stores the option for modification of the issue stock status during the maintenance return of Main Core parts. Allowed and Not Allowed.	No
IOINF_AIRREG_ENFORCE_OPT	udd_designparamcode	varchar(5)	Yes	the set option to enforce aircraft registartion	No
IOINF_OPEN_ISS_DOC_OTH	udd_designparamcode	varchar(5)	Yes	the flag holds the value for open issue document	No
IOINF_MMD_AOG_MR_PRINT	udd_designparamcode	varchar(5)	Yes	stores the option for unsatisfied material request with AOG priority, should be automatically printed or not	No

Table Name :	CLM_IRINF_IR_OPT_INFO
Comment :	This is the table in which issue route options are defined

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
IRINF_CREATED_OUINSTANCE	_decimal_10_0	decimal(10)	No	This is the OU Instance in which issue route options are defined	Yes
IRINF_IR_OPT_ID	_decimal_10_0	decimal(10)	No	This is uniquely generated id for issue route	Yes
IRINF_LWO_ISSUE_MR	_varchar_5	varchar(5)	Yes	This field is set when Line work order is issued through material request	No
IRINF_LWO_ISSUE_WO	_varchar_5	varchar(5)	Yes	This field is set when Line work order is issued through work order	No
IRINF_CWO_ISSUE_MR	_varchar_5	varchar(5)	Yes	This field is set when Component work order is issued through material request	No
IRINF_CWO_ISSUE_WO	_varchar_5	varchar(5)	Yes	This field is set when Component work order is issued through work order	No
IRINF_TECH_LOG_ISSUE_MR	_varchar_5	varchar(5)	Yes	The field is set when tech log document is issued through material request	No
IRINF_STATUS	_varchar_5	varchar(5)	Yes	This field holds the status of the records A- Active I -Inactive	No
IRINF_CREATED_DATE	_datetime_8	datetime(8)	Yes	This field holds the created date of the record	No
IRINF_CREATED_BY	_varchar_30	varchar(30)	Yes	This field holds the created user of the record	No
IRINF_MODIFIED_DATE	_datetime_8	datetime(8)	Yes	This field holds the modified date of the record	No
IRINF_MODIFIED_BY	_varchar_30	varchar(30)	Yes	This field holds the user who modified the record	No
IRINF_TIMESTAMP	_varchar_18	varchar(18)	Yes	This field holds the timestamp of the record	No

Table Name :	CLM_ITINF_INCO_TERMS_INFO
Comment :	This table used to Store the INCO Term Details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ITINF_CREATED_OUINSTANCE	_decimal_10_0	decimal(10)	No	stores the OUinstance	Yes
ITINF_INCO_TERM_CODE	_varchar_150	varchar(150)	No	stores the inco term code	Yes
ITINF_INCO_TERM_DESC	_varchar_150	varchar(150)	Yes	stores the inco term description	No
ITINF_INCO_TERM_STATUS	_varchar_5	varchar(5)	Yes	stores the inco term status A- Active I - Inactive	No
ITINF_CREATED_DATE	_datetime_8	datetime(8)	Yes	stores the record created date	No
ITINF_CREATED_BY	_varchar_30	varchar(30)	Yes	stores the user who created the record	No
ITINF_MODIFIED_DATE	_datetime_8	datetime(8)	Yes	stores the record modified date	No
ITINF_MODIFIED_BY	_varchar_30	varchar(30)	Yes	stores the user who modified the record	No
ITINF_TIMESTAMP	_decimal_38_0	decimal(38)	Yes	stores the timestamp	No

Table Name :	Clm_MRP_Priority_Code_Info
Comment :	This table is used to store the manufacture priority code information

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
MRP_CREATED_OUINSTANCE	udd_ctxt_ouinstance	int(4)	Yes	This column is used to store the ouinstance	No
MRP_LINE_NO	udd_seqno	int(4)	Yes	This column is used to store the Line no	No
MRP_PRIORITY_CODE	udd_designparamcode	varchar(5)	Yes	This column is used to store the MR priority code	No
MRP_PRIORITY_DESC	udd_txt20	varchar(20)	Yes	This column is used to store MR priority code description	No
MRP_ORDER_OF_PREFERENCE	udd_order	int(4)	Yes	This column is used to store the order of preference of priority code	No
MRP_HISTORY_FLAG	udd_flag	varchar(25)	Yes	To maintain history flag. N will be stored for current records. Y will be stored for modified records.	No
MRP_CODE_STATUS	udd_status	varchar(25)	Yes	This column is used to store the status(Active or inactive) of priority code.	No
MRP_TIMESTAMP	udd_timestamp	int(4)	Yes	This column is used for concurrency check.	No
MRP_CREATED_BY	udd_ctxt_user	varchar(30)	Yes	This colum is used to store the user name who has created the priority code.	No
MRP_CREATED_DATE	udd_time	datetime(8)	Yes	This colum is used to store the created date of Priority	No
MRP_MODIFIED_BY	udd_ctxt_user	varchar(30)	Yes	This colum is used to store the user name who has modify the the priority code information.	No
MRP_MODIFIED_DATE	udd_time	datetime(8)	Yes	This colum is used to store the modified date of Priority	No
MRP_PREF_ERR_ROWNUM	udd_seqno	int(4)	Yes	This colum is used to store the rownumber	No
REPLICATION_KEY	_bigint_8	Bigint(8)	No	Unique Number	Yes

Table Name :	CLM_MSDINF_MNTSEPDOC_OPT_INFO
Comment :	This table used to store the Maintenance Option in the various commercial documents such as "Purchase Request", "Purchase Order", "Blanket Purchase Order", "Release Slip", "Goods Receipt", "Repair Order", "Request for Quotation", "Quotation", "Loan Order"

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
MSDINF_CREATED_OUINSTANCE	_decimal_10_0	decimal(10)	No	stores the OUinstance	Yes
MSDINF_OPT_ID	_decimal_10_0	decimal(10)	No	stores the option id which is a sequentially generated no	Yes
MSDINF_TRAN_TYPE	_varchar_5	varchar(5)	No	stores the transaction type MR - Material Request RS - Return Slip GL - General Material Request STR - Stock Transfer UPISU - Unplanned Issue UR - Unplanned Return SC - Stock Correction SCR - Standard Cost Revaluation	No
MSDINF_PRT_TY_COMP_FLAG	_varchar_5	varchar(5)	Yes	stores the flag to identify whether component type is allowed or not allowed for a given transaction type Y - Yes N - No	No
MSDINF_PRT_TY_CONS_FLAG	_varchar_5	varchar(5)	Yes	stores the flag to identify whether consumable type is allowed or not allowed for a given transaction type Y - Yes N - No	No
MSDINF_PRT_TY_KIT_FLAG	_varchar_5	varchar(5)	Yes	stores the flag to identify whether kit type is allowed or not allowed for a given transaction type Y - Yes N - No	No
MSDINF_PRT_TY_EXP_FLAG	_varchar_5	varchar(5)	Yes	stores the flag to identify whether expendable type is allowed or not allowed for a given transaction type Y - Yes N - No	No
MSDINF_PRT_TY_TOOL_FLAG	_varchar_5	varchar(5)	Yes	stores the flag to identify whether tool type is allowed or not allowed for a given transaction type Y - Yes N - No	No
MSDINF_PRT_TY_RMTL_FLAG	_varchar_5	varchar(5)	Yes	stores the flag to identify whether raw material type is allowed or not allowed for a given transaction type Y - Yes N - No	No
MSDINF_PRT_TY_MISC_FLAG	_varchar_5	varchar(5)	Yes	stores the flag to identify whether miscellaneous type is allowed or not allowed for a given transaction type Y - Yes N - No	No
MSDINF_STATUS	_varchar_5	varchar(5)	Yes	stores the status of a record for a given transaction type. Always the latest record will be in actibve status and all previous records will be inactivated	No
MSDINF_CREATED_DATE	_datetime_8	datetime(8)	Yes	stores the created date	No
MSDINF_CREATED_BY	_varchar_30	varchar(30)	Yes	stores the user who created the record	No
MSDINF_MODIFIED_DATE	_datetime_8	datetime(8)	Yes	stores the modified date	No
MSDINF_MODIFIED_BY	_varchar_30	varchar(30)	Yes	stores the user who modified the record	No
MSDINF_TIMESTAMP	_decimal_10_0	decimal(10)	Yes	stores the timestamp	No

Table Name :	CLM_PCINF_PKG_CODE_INFO
Comment :	This is the table in which packaging codes are defined

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
PCINF_CREATED_OUINSTANCE	_decimal_10_0	decimal(10)	No	This is the ouinstance in which packaging codes are defined.	Yes
PCINF_PKG_CODE	_varchar_25	Varchar(25)	No	This field is to capture the packaging code	Yes
PCINF_PKG_CODE_DESC	_varchar_150	varchar(150)	Yes	This field is to capture the description of the packaging code.	No
PCINF_PKG_CODE_STATUS	_varchar_5	varchar(5)	No	This field is to capture the status of the packaging code. Allowed values are A- Active I-Inactive	No
PCINF_CREATEDDATE	_datetime_8	datetime(8)	Yes	This field holds the created date of the record	No
PCINF_CREATED_BY	_varchar_30	varchar(30)	No	This field holds the created user of the record	No
PCINF_MODIFIEDDATE	_datetime_8	datetime(8)	Yes	This field holds the modified date of the record	No
PCINF_MODIFIED_BY	_varchar_30	varchar(30)	No	This field holds the user who modified the record	No
PCINF_TIMESTAMP	_decimal_10_0	decimal(10)	No	This field holds the timestamp of the record	No
PCInf_Length	udd_category	varchar(15)	No	This field is to capture the length of the packaging code.	No
PCInf_Breadth	udd_category	varchar(15)	No	This field is to capture the breadth of the packaging code.	No
PCInf_Height	udd_category	varchar(15)	No	This field is to capture the height of the packaging code.	No
PCInf_UOM	udd_uom	varchar(15)	No	This field is to capture the UOM of the packaging code.	No

Table Name :	CLM_POINF_PUR_OPTIONS_INFO
Comment :	This is the table in which purchase options are defined

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
POINF_CREATED_OUINSTANCE	_decimal_10_0	decimal(10)	No	This is the ouinstance in which purchase options are created	Yes
POINF_PRT_SUPP_MAP	_varchar_5	varchar(5)	Yes	If express PO is created,supplier to part mapping is done when this column value is set to "APS" - "Allow Express PO and map part to supplier" If express PO is created,supplier to part mapping is not done when this column value is set to "DPS"	No
POINF_PUR_OPT_ID	_decimal_10_0	decimal(10)	No	This is uniquely generated purchase option id.	Yes
POINF_CREATEDDATE	_datetime_8	datetime(8)	Yes	This field holds the created date of the record	No
POINF_SUP_MANU_ALLOW	_varchar_5	varchar(5)	Yes	This column holds the values "Yes" and "No" if there is no interaction between this component OU and Utilities module. If there is an interaction between this component and Utilities module, then populate the combo with the value No only.	No
POINF_CREATED_BY	_varchar_30	varchar(30)	Yes	This field holds the created user of the record	No
POINF_MOVE_TO_DIFF_WH	_varchar_18	varchar(18)	Yes	stores option whether movement to different warehouse is allowed or not A - Allowed NA - Not Allowed	No
POINF_APP_DTCD_LINEITM_ON	_varchar_18	varchar(18)	Yes	stores the options for the value to apportion the doc TCDs to line items BV - Basic Value TV - Total Value	No
POINF_STATUS	_varchar_5	varchar(5)	Yes	This field holds the status of the record A-Active I-Inactive	No
POINF_PRT_BUY_CTRL	_varchar_5	varchar(5)	Yes	It holds the following values "Needed" and "Not Needed"	No
POINF_MODIFIEDDATE	_datetime_8	datetime(8)	Yes	This field holds the modified date of the record	No
POINF_MODIFIED_BY	_varchar_30	varchar(30)	Yes	This field holds the user who modified the record	No
POINF_MOVEMENT_TO_CC	_varchar_5	varchar(5)	Yes	Stores the option whether the part can be directly moved to comsumption centre or not A - Allowed NA - Not Allowed	No
POINF_TIMESTAMP	_decimal_10_0	decimal(10)	Yes	This field holds the timestamp of the record	No
POINF_COMP_ID	_varchar_90	varchar(90)	Yes	To store the Default Component Id Value.	No
POINF_CMP_CHK	_varchar_5	varchar(5)	Yes	This field used to hold Mandatory or Non Mandatory If maintenance program check is mandatory for the component. When this check is mandatory, the system ensures the following for parts moved through the Goods Receipt transaction:	No
POInf_Matypol	_varchar_20	varchar(20)	Yes	the matching type indicating the matching of the quantity ordered, the quantity received or the quantity accepted with the quantity invoiced	No
poinf_mandate_WrkCntr	_varchar_5	varchar(5)	Yes	To store mandate workcenter set option values	No
POINF_ExpDate_Status	udd_designparamcode	varchar(5)	Yes	to specify whether the shelf life expiry date must be automatically calculated or not. Manual,Automatic	No
POINF_PUR_TRANSIT_TIME	_int_0	int(0)	Yes	the transit time for purchase order	No
POINF_SUPPCLS_REPAGNCY	udd_designparamcode	varchar(5)	Yes	To enable supplier class-repair agency mapping	No

Table Name :	CLM_PO_SETOPT_DTL
Comment :	This table is to store the purchase order details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
SETOPTDTL_OUINSTANCE	udd_ctxt_ouinstance	int(4)	No	This column is used to store the ouinstance	No
SETOPTDTL_OPTKEYCODE	udd_documentno	varchar(40)	No	to store the parameter code	No
SETOPTDTL_STATUS	udd_paramcode	varchar(30)	Yes	used to store the satus to check data entered or not.	No
SETOPTDTL_VALUE	udd_groupno	int(4)	Yes	store the option value	No
SETOPTDTL_HISTORY	udd_flag	varchar(25)	Yes	used to store the history flag to maintain history	No
SETOPTDTL_MODIFIEDBY	udd_ctxt_user	varchar(30)	Yes	used to store the user name who modified the data.	No
SETOPTDTL_MODIFIEDDATE	udd_time	datetime(8)	Yes	used to store the modified date	No
REPLICATION_KEY	_bigint_8	Bigint(8)	No	Unique Number	Yes

Table Name :	CLM_PO_SETOPT_PARAM_VALUES
Comment :	this table is to store the purchase order parameter values

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
SETOPT_LANGID	udd_ctxt_language	int(4)	Yes	It is used to store the language ID	No
SETOPT_OPTKEYCODE	udd_designparamcode	varchar(5)	No	the unique set option code for parameter	Yes
SETOPT_METADATA_TYPE	udd_paramcode	varchar(30)	Yes	used to store the parameter catogry.	No
SETOPT_PARAMCODE	udd_paramcode	varchar(30)	Yes	It is used to store the parameter code.	No
SETOPT_PARAMDESC	udd_txt150	varchar(150)	Yes	It is used to store the description of parameter code.	No
SETOPT_MANDATORY_CHECK	udd_flag1	varchar(25)	Yes	used to store , parameter is mandatory or not	No
SETOPT_SOTRBY	udd_seqno	int(4)	Yes	used to sort the parameters	No
SETOPT_CREATEDDATE	udd_time	datetime(8)	Yes	store the parameter created date	No

Table Name :	CLM_PO_SETOPT_PERMIT_VALUES
Comment :	this table is to store the purchase order permitted values

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
SetOpt_OptLanguage	udd_ctxt_language	int(4)	Yes	It is used to store the language ID	No
SetOpt_OptKeyCode	udd_documentno	varchar(40)	Yes	unique option key code Value	No
SetOpt_permittedvalue	udd_count	int(4)	Yes	It is used to store the permitted values(0,1,...)	No
SetOpt_permittedvalue_desc	udd_txt150	varchar(150)	Yes	It is used to store the permitted value description	No
REPLICATION_KEY	_bigint_8	Bigint(8)	No	Unique Number	Yes

Table Name :	CLM_PTINF_PRT_TY_OPT_INFO
Comment :	This is the table in which part type options are defined.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
PTINF_CREATED_OUINSTANCE	_decimal_10_0	decimal(10)	No	This is the OU instance in which part type options are defined.	Yes
PTINF_OPT_ID	_decimal_10_0	decimal(10)	No	This is uniquely generated option id	Yes
PTINF_TRAN_TYPE	_varchar_5	varchar(5)	No	This field holds the transaction types for which part type options are defined. Allowed values are "General Material Request", "Stock Transfer", "Unplanned Issue", "Unplanned Return", "Stock Correction" and "Standard Cost Revaluation"	Yes
PTINF_PRT_TY_ALL_FLAG	_varchar_5	varchar(5)	Yes	This flag is set when part types allowed are set for ALL	No
PTINF_PRT_TY_COMP_FLAG	_varchar_5	varchar(5)	Yes	This flag is set when part types allowed are set asr components	No
PTINF_PRT_TY_CONS_FLAG	_varchar_5	varchar(5)	Yes	This flag is set when part types allowed are set as consumables	No
PTINF_PRT_TY_KIT_FLAG	_varchar_5	varchar(5)	Yes	This flag is set when part types allowed are set as kits	No
PTINF_PRT_TY_SPRE_FLAG	_varchar_5	varchar(5)	Yes	This flag is set when part types allowed are set as spares	No
PTINF_PRT_TY_TOOL_FLAG	_varchar_5	varchar(5)	Yes	This flag is set when part types allowed are set as tools	No
PTINF_PRT_TY_RMTL_FLAG	_varchar_5	varchar(5)	Yes	This flag is set when part types allowed are set as raw material	No
PTINF_STATUS	_varchar_5	varchar(5)	Yes	This field stores the status of the record I- Inactive A- Active	No
PTINF_CREATED_DATE	_datetime_8	datetime(8)	Yes	This field holds the created date of the record	No
PTINF_CREATED_BY	_varchar_30	varchar(30)	Yes	This field holds the created user of the record	No
PTINF_MODIFIED_DATE	_datetime_8	datetime(8)	Yes	This field holds the modified date of the record	No
PTINF_MODIFIED_BY	_varchar_30	varchar(30)	Yes	This field holds the user who modified the record	No
PTINF_TIMESTAMP	_decimal_10_0	decimal(10)	Yes	This field holds the timestamp of the record	No
PTINF_PRT_TY_MISC_FLAG	_varchar_5	varchar(5)	Yes	This flag is set when part types allowed are set as miscellaneous	No

Table Name :	CLM_PYINF_PRTY_CODE_INFO
Comment :	This is the table in which the priority codes are defined

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
PYINF_CREATED_OUINSTANCE	_decimal_10_0	decimal(10)	No	This is the column in which the priority codes are defined	Yes
PYINF_PRTY_CODE	_varchar_20	varchar(20)	No	This field is to capture the priority codes	Yes
PYINF_PRTY_CODE_DESC	_varchar_150	varchar(150)	Yes	This field is to capture the description of the priority code	No
PYINF_PRTY_CODE_STATUS	_varchar_5	varchar(5)	No	This field is to capture the status of the priority code.Allowed values are A- Active I- Inactive	No
PYINF_CREATEDDATE	_datetime_8	datetime(8)	Yes	This field holds the created date of the record	No
PYINF_CREATED_BY	_varchar_30	varchar(30)	No	This field holds the created user of the record	No
PYINF_MODIFIEDDATE	_datetime_8	datetime(8)	Yes	This field holds the modified date of the record	No
PYINF_MODIFIED_BY	_varchar_30	varchar(30)	No	This field holds the user who modified the record	No
PYINF_TIMESTAMP	_decimal_10_0	decimal(10)	No	This field holds the timestamp of the record	No

Table Name :	CLM_RNINF_REASON_CODE_INFO
Comment :	This is the table to capture user defined reason codes with the descriptions for the types "Quarantine" and "Rejection" mainly in GOODS RECEIPT & REPAIR RECEIPTS.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
RNINF_CREATED_OUINSTANCE	_decimal_10_0	decimal(10)	No	This is the OUInstance in which reason code is created	Yes
RNINF_REASON_CODE_TYPE	_varchar_5	varchar(5)	No	This field is to hold the type of the reason code. Allowed Values are "Q" - "Quarantine", "R" - "Rejection".	Yes
RNINF_REASON_CODE	_varchar_25	Varchar(25)	No	This field is to capture user defined reason codes for the types "QUARANTINE" and "REJECTION"	Yes
RNINF_REASON_DESC	_varchar_255	varchar(255)	No	This field is to capture the reason description.	No
RNINF_REASON_STATUS	_varchar_15	varchar(15)	No	This field is to store the status of the record.Allowed values are "A"- "Active", "I"- "InActive", "B" - "Blank".	No
RNINF_CREATEDDATE	_datetime_8	datetime(8)	Yes	This field holds the created date of the record	No
RNINF_CREATED_BY	_varchar_30	varchar(30)	Yes	This field holds the created user of the record	No
RNINF_MODIFIEDDATE	_datetime_8	datetime(8)	Yes	This field holds the modified date of the record	No
RNINF_MODIFIED_BY	_varchar_30	varchar(30)	Yes	This field holds the user who modified the record	No
RNINF_TIMESTAMP	_decimal_10_0	decimal(10)	No	This field holds the timestamp of the record	No

Table Name :	CLM_RPINF_REP_PROC_INFO
Comment :	This is the table in which repair process codes are defined

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
RPINF_CREATED_OUINSTANCE	_decimal_10_0	decimal(10)	No	This is the ouinstance in which repair process codes are defined	Yes
RPINF_REP_PROC_CODE	_varchar_25	Varchar(25)	No	THe repair process descriptions are codified in this field	Yes
RPINF_REP_PROC_DESC	_varchar_150	varchar(150)	Yes	This field is to capture the repair process description	No
RPINF_REP_PROC_STATUS	_varchar_5	varchar(5)	No	This is field which captures the status of repair process code	No
RPINF_CREATEDDATE	_datetime_8	datetime(8)	Yes	This field holds the created date of the record	No
RPINF_CREATED_BY	_varchar_30	varchar(30)	No	This field holds the created user of the record	No
RPINF_MODIFIEDDATE	_datetime_8	datetime(8)	Yes	This field holds the modified date of the record	No
RPINF_MODIFIED_BY	_varchar_30	varchar(30)	No	This field holds the user who modified the record	No
RPINF_TIMESTAMP	_decimal_10_0	decimal(10)	No	This field holds the timestamp of the record	No
RPINF_MAINTYPE	udd_designparamcode	varchar(5)	Yes	the field holds the type of the repair process code	No

Table Name :	CLM_SCINF_SC_OPT_INFO
Comment :	Thisi s the table in which stock correction options are defined

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
SCINF_CREATED_OUINSTANCE	_decimal_10_0	decimal(10)	No	This is the OUInstance in which stock correction options are created	Yes
SCINF_SC_OPT_ID	_decimal_10_0	decimal(10)	No	This is uniquely generated stock correction option id	Yes
SCINF_PHY_INV_QTY	_varchar_5	varchar(5)	Yes	Thsi field is set when physical inventory has quanity as stock correction measure.	No
SCINF_PHY_INV_QTY_VALUE	_varchar_5	varchar(5)	Yes	Thsi field is set when physical inventory has quantity & value as stock correction measure.	No
SCINF_CYC_CNT_QTY	_varchar_5	varchar(5)	Yes	This field is set when cycle count has quantity as stock correction measure	No
SCINF_CYC_CNT_QTY_VALUE	_varchar_5	varchar(5)	Yes	This field is set when cycle count has both quantity and value as stock correction options.	No
SCINF_GEN_QTY	_varchar_5	varchar(5)	Yes	This field is set when general stock correction option is of quantity type	No
SCINF_GEN_VALUE	_varchar_5	varchar(5)	Yes	This field is set when general stock correction option is of value type	No
SCINF_GEN_QTY_VALUE	_varchar_5	varchar(5)	Yes	This field is set when general stock correction options are of both types: 1.quantity 2.value	No
SCINF_STATUS	_varchar_5	varchar(5)	Yes	This field captures the status of the record. Allowed values are A- Active I- Inactive	No
SCINF_CREATED_DATE	_datetime_8	datetime(8)	Yes	This field holds the created date of the record	No
SCINF_CREATED_BY	_varchar_30	varchar(30)	Yes	This field holds the created user of the record	No
SCINF_MODIFIED_DATE	_datetime_8	datetime(8)	Yes	This field holds the modified date of the record	No
SCINF_MODIFIED_BY	_varchar_30	varchar(30)	Yes	This field holds the user who modified the record	No
SCINF_TIMESTAMP	_decimal_10_0	decimal(10)	Yes	This field holds the timestamp of the record	No

Table Name :	CLM_SCINF_SHIP_COST_INFO
Comment :	This is the table in which shipping cost codes are defined

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
SCINF_CREATED_OUINSTANCE	_decimal_10_0	decimal(10)	No	This is the OUInstance in which stock correction options are created	Yes
SCINF_SHIP_COST_CODE	_varchar_25	Varchar(25)	No	This field is to capture the shipping cost code	Yes
SCINF_SHIP_COST_DESC	_varchar_150	varchar(150)	Yes	This field is to capture the description of the shipping cost code	No
SCINF_SHIP_COST_STATUS	_varchar_5	varchar(5)	No	This field is to capture the status of shipping cost codes. Allowed values are A- Active I- Inactive	No
SCINF_CREATEDDATE	_datetime_8	datetime(8)	Yes	This field holds the created date of the record	No
SCINF_CREATED_BY	_varchar_30	varchar(30)	No	This field holds the created user of the record	No
SCINF_MODIFIEDDATE	_datetime_8	datetime(8)	Yes	This field holds the modified date of the record	No
SCINF_MODIFIED_BY	_varchar_30	varchar(30)	No	This field holds the user who modified the record	No
SCINF_TIMESTAMP	_decimal_10_0	decimal(10)	No	This field holds the timestamp of the record	No

Table Name :	CLM_SMINF_SHIP_MET_INFO
Comment :	This is the table in which shipping method codes are created

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
SMINF_CREATED_OUINSTANCE	_decimal_10_0	decimal(10)	No	This is the OUInstance in which shipping method codes are created	Yes
SMINF_SHIP_METHOD_CODE	_varchar_25	Varchar(25)	No	Shipping methods of Parts are codified in this field	Yes
SMINF_SHIP_METHOD_DESC	_varchar_150	varchar(150)	Yes	This field contains the exact description of the shipping method	No
SMINF_SHIP_METHOD_STATUS	_varchar_5	varchar(5)	Yes	This is the status of the shipping method.Allowed values are A- Active I-Inactive	No
SMINF_CREATEDDATE	_datetime_8	datetime(8)	Yes	This field holds the created date of the record	No
SMINF_CREATED_BY	_varchar_30	varchar(30)	Yes	This field holds the created user of the record	No
SMINF_MODIFIEDDATE	_datetime_8	datetime(8)	Yes	This field holds the modified date of the record	No
SMINF_MODIFIED_BY	_varchar_30	varchar(30)	Yes	This field holds the user who modified the record	No
SMINF_TIMESTAMP	_decimal_10_0	decimal(10)	Yes	This field holds the timestamp of the record	No

Table Name :	CLM_UOINF_USR_OPT_INFO
Comment :	This is the ouinstance in which user options are created

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
UOINF_CREATED_OUINSTANCE	_decimal_10_0	decimal(10)	No	This is the ouinstance in which the user options are created	Yes
UOINF_USR_OPT_FOR	_varchar_5	varchar(5)	No	This field is to capture the document codes for which user option is created.Allowed values are PR, PO, BPO, RS, GR, RO, RFQ, Quotation	Yes
UOINF_USR_OPT_VALUE_FOR	_varchar_5	varchar(5)	No	There are four types of user options currently available in the system.Allowed values are User Option 1, User Option 2, User Option 3, User Option 4	Yes
UOINF_USR_OPT_VALUE	udd_userdefined	varchar(30)	No	The exact character value of the user options is stored .	Yes
UOINF_USR_OPT_DESC	_varchar_150	varchar(150)	Yes	This field is to capture the description of user options	No
UOINF_USR_OPT_STATUS	_varchar_5	varchar(5)	Yes	This is the status in which user option is created.Allowed values are A- Active I- Inactive	No
UOINF_CREATEDDATE	_datetime_8	datetime(8)	Yes	This field holds the created date of the record	No
UOINF_CREATED_BY	_varchar_30	varchar(30)	Yes	This field holds the created user of the record	No
UOINF_MODIFIEDDATE	_datetime_8	datetime(8)	Yes	This field holds the modified date of the record	No
UOINF_MODIFIED_BY	_varchar_30	varchar(30)	Yes	This field holds the user who modified the record	No
UOINF_TIMESTAMP	_decimal_10_0	decimal(10)	Yes	This field holds the timestamp of the record	No

Table Name :	CLM_USINF_USER_STATUS_INFO
Comment :	This is the table in which user status for puchase components are created.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
USINF_CREATED_OUINSTANCE	_decimal_10_0	decimal(10)	No	This is the OUinstance in which user status is created.	Yes
USINF_DOCUMENT_CODE	_varchar_5	varchar(5)	No	This field holds the document codes for which user status are created. "PO", "GR", "GRS", "PR", "BPO", "RS", "RO", "RFQ" "SCO" "LO" "RTO"	Yes
USINF_USER_STATUS	_varchar_25	Varchar(25)	No	This field holds the user status of the document	Yes
USINF_USER_STATUS_DESC	_varchar_80	varchar(80)	Yes	This field hold s the description of the user status	No
USINF_STATUS	_varchar_15	varchar(15)	Yes	This field holds the status of the record. A-Active I-Inactive	No
USINF_CREATEDDATE	_datetime_8	datetime(8)	Yes	This field holds the created date of the record	No
USINF_CREATED_BY	_varchar_30	varchar(30)	Yes	This field holds the created user of the record	No
USINF_MODIFIEDDATE	_datetime_8	datetime(8)	Yes	This field holds the modified date of the record	No
USINF_MODIFIED_BY	_varchar_30	varchar(30)	Yes	This field holds the user who modified the record	No
USINF_TIMESTAMP	_decimal_10_0	decimal(10)	Yes	This field holds the timestamp of the record	No

Table Name :	LCM_EXRSN_INFO
Comment :	This table stores the reason for exchange codes informations

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
EXRSN_OuInstance	udd_ctxt_ouinstance	int(4)	No	Ou instanec	Yes
EXRSN_ReasonCode	udd_quickcodes	varchar(25)	No	unique code for reason for exchange	Yes
EXRSN_ReasonDesc	udd_txt150	varchar(150)	Yes	description of reason for exchange code	No
EXRSN_ReasonType	udd_type	varchar(25)	Yes	type of the reason for exchange code	No
EXRSN_Created_By	udd_ctxt_user	varchar(30)	Yes	the person who created the reason for exchange code	No
EXRSN_Created_Date	udd_datetime1	datetime(8)	Yes	the date on which reason for exchange code created	No
EXRSN_Modified_By	udd_ctxt_user	varchar(30)	Yes	the person who modified the reason for exchange code	No
EXRSN_Modified_Date	udd_datetime1	datetime(8)	Yes	the date on which reason for exchange code modified	No
EXRSN_TimeStamp	udd_seqno	int(4)	Yes	TimeStamp for reason for exchange code	No
EXRSN_Status	udd_designparamcode	varchar(5)	Yes	status of reason for exchange code	No

Table Name :	LCM_LQCD_INFO
Comment :	This table stores the quick code informations

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
LQCD_OUINSTANCE	udd_ctxt_ouinstance	int(4)	Yes	OU instance for quick code	No
LQCD_QUICKCODE	udd_desc40	varchar(40)	Yes	unique id for quick code	No
LQCD_DESCRIPTION	udd_notes	varchar(2000)	Yes	quick code description	No
LQCD_DEFAULT_FLAG	udd_designparamcode	varchar(5)	Yes	stores the flag value whethere the quick code is default or not	No
LQCD_MAND_FLAG	udd_seqno	int(4)	Yes	the mandatory flag for quick code	No
LQCD_APPLICABLE_ON	udd_designparamcode	varchar(5)	Yes	the field holds the value whether the quick code is applicable for part or document level	No
LQCD_STATUS	udd_status	varchar(25)	Yes	the status os quick code A-Active, IA- InActive	No
LQCD_QCODE_TYPE	udd_desc40	varchar(40)	Yes	the type of the quick code	No
LQCD_REFDOC_TYPE	udd_desc40	varchar(40)	Yes	the reference document type of the quick code	No
LQCD_REFDOC_SUBTYPE	udd_desc40	varchar(40)	Yes	the reference document sub type of the quick code	No
LQCD_QCODE_TYPE_MAND	udd_flag	varchar(25)	Yes	the mandatory flag for quick code type	No
LQCD_QCODE_TYPE_APPL	udd_flag	varchar(25)	Yes	stores the value to which the quick code is applicable	No
LQCD_CREATEDBY	udd_ctxt_user	varchar(30)	Yes	the person who created the quick code	No
LQCD_CREATEDBYDATE	udd_datetime	varchar(30)	Yes	the date on which the quick code is created	No
LQCD_MODIFIEDBY	udd_ctxt_user	varchar(30)	Yes	the person who modified the quick code	No
LQCD_MODIFIEDDATE	udd_datetime	varchar(30)	Yes	the date on which the quick code is modified	No
LQCD_SEQNO	udd_seqno	int(4)	No	the sequnce no of quick code	No
LQCD_PART_ASSOCIATED	udd_desc20	varchar(20)	Yes	Part associated with the quick code	No
LQCD_RECORD_SRLOT	udd_designparamcode	varchar(5)	Yes	It stores the record serial LOT	No

Table Name :	LCM_PARAMETER_DETAILS
Comment :	This table is used to store the parameter details of Logistics Common Master

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
LCM_COMPONENTNAME	udd_txt80	varchar(80)	No	This field holds the Name of the component.	No
LCM_PARAMCATEGORY	udd_paramcategory	varchar(10)	No	This field will capture the category of the static value. The static values could be to fill up combo, text field, guidance text, combo default etc.	No
LCM_PARAMTYPE	udd_paramtype	varchar(25)	No	This will allow us to store all the possible values for a combo in multiple rows.	No
LCM_PARAMCODE	udd_designparamcode	varchar(5)	No	This is the code that may be used for data storage.This is valid only incase of combo boxes. Here the short code that will be stored as data in the transaction could be maintained.	No
LCM_LANGID	udd_hrouid	numeric(9)	No	Language id. This is the language id of the record.	No
LCM_PARAMDESC	udd_desc255	varchar(255)	Yes	Param description is the values to be filled in the combo box or guidance text. This is actually the meta data of this component	No
LCM_SORT_BY	udd_hrouid	numeric(9)	Yes	This field holds the default sort by code	No
REPLICATION_KEY	_bigint_8	Bigint(8)	No	Unique Number	Yes

Table Name :	LCM_set_option_dtl
Comment :	This table stores the set options details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
setoptdtl_ouinstance	udd_ctxt_ouinstance	int(4)	No	This column is used to store the ouinstance	Yes
SetOptdtl_OptKeyCode	udd_documentno	varchar(40)	No	to store the parameter code	Yes
setoptdtl_status	udd_paramcode	varchar(30)	Yes	used to store the satus to check data entered or not.	No
setoptdtl_value	udd_groupno	int(4)	Yes	store the option value	No
setoptdtl_modifiedby	udd_ctxt_user	varchar(30)	Yes	used to store the user name who modified the data.	No
setoptdtl_modifieddate	udd_time	datetime(8)	Yes	used to store the modified date	No

Table Name :	LCM_SET_OPTION_HDR
Comment :	This table stores the set option header values

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
setopthdr_ouinstance	udd_ctxt_ouinstance	int(4)	Yes	OU instance for set option	No
setopthdr_timestamp	udd_timestamp	int(4)	Yes	To Store the timestamp.	No
setopthdr_createdby	udd_ctxt_user	varchar(30)	Yes	stores the user who created the record	No
setopthdr_createddate	udd_time	datetime(8)	Yes	stores the record created date	No
setopthdr_modifiedby	udd_ctxt_user	varchar(30)	Yes	stores the user who modified the record	No
setopthdr_modifieddate	udd_time	datetime(8)	Yes	stores the record modified date	No
REPLICATION_KEY	_bigint_8	Bigint(8)	No	Unique Number	Yes

Table Name :	LCM_SET_OPTION_PARAM_VALUES
Comment :	This table stores the set option parameter values

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
SetOpt_Langid	udd_ctxt_language	int(4)	Yes	It is used to store the language ID	No
SetOpt_OptKeyCode	udd_designparamcode	varchar(5)	No	stores the unique set option ket code	Yes
SetOpt_Metadata_type	udd_paramcode	varchar(30)	Yes	used to store the parameter catogry.	No
SetOpt_paramcode	udd_paramcode	varchar(30)	Yes	It is used to store the parameter code.	No
SetOpt_paramDesc	udd_txt150	varchar(150)	Yes	It is used to store the description of parameter code.	No
SetOpt_Mandatory_Check	udd_flag1	varchar(25)	Yes	used to store , parameter is mandatory or not	No
SetOpt_Sotrby	udd_seqno	int(4)	Yes	used to sort the parameters	No
Setopt_createdDate	udd_time	datetime(8)	Yes	store the parameter created date	No

Table Name :	LCM_SET_OPTION_PERMIT_VALUES
Comment :	This table stores the set option permitted values

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
SetOpt_OptLanguage	udd_ctxt_language	int(4)	Yes	It is used to store the language ID	No
SetOpt_OptKeyCode	udd_documentno	varchar(40)	Yes	unique option key code Value for set option	No
SetOpt_permittedvalue	udd_count	int(4)	Yes	It is used to store the permitted values(0,1,...)	No
SetOpt_permittedvalue_desc	udd_txt150	varchar(150)	Yes	It is used to store the permitted value description	No
REPLICATION_KEY	_bigint_8	Bigint(8)	No	Unique Number	Yes