Logistics Common Master

Table Name CLM_CAINF_CARR_AGEN_INFO

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

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

CAINF_CREATED_OUINSTANCE

numeric(10)

NOT NULL

stores the OUinstance

Yes

No

CAINF_CARR_AGEN_CODE

varchar(20)

NOT NULL

stores the carrier/agency code

Yes

No

CAINF_CARR_AGEN_DESC

varchar(150)

NULL

stores the carrier/agency code description

No

No

CAINF_CARR_AGEN_STATUS

varchar(5)

NULL

stores the status of the carrier/agency code A- Active I - Inactive

No

No

CAINF_CREATED_DATE

datetime

NULL

stores the record created date

No

No

CAINF_CREATED_BY

varchar(30)

NULL

stores the user who created the record

No

No

CAINF_MODIFIED_DATE

datetime

NULL

stores the record modified date

No

No

CAINF_MODIFIED_BY

varchar(30)

NULL

stores the user who modified the record

No

No

CAINF_TIMESTAMP

decimal(38)

NULL

stores the timestamp

No

No

CAINF_REMARKS

varchar(255)

NULL

This field holds the remarks of carrier agency

No

No

Table Name Clm_CatInf_Category_Info

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

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

CatInf_Created_OUInstance

numeric(10)

NOT NULL

This is the OU instance in which category info is created

Yes

No

CatInf_Category_For

varchar(5)

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 Order", "RS"  -  "Release Slip", "RO" - "Repair Order" , "RFQ" - "Request for Quotation", "PT"  -  "Pay Term", "TCD" - "TCD", "LO" - "Loan Order", "RNT" - "Rental Order", "RLR" - "Rental / Loan Receipt", "SCO" - "Subcontract Order", "SCR" - "Subcontract Receipt".

CatInf_Category_Code

varchar(25)

This field is to capture the category code for the components

CatInf_Category_Desc

varchar(80)

This field is to capture the category description

No

CatInf_Category_Status

varchar(5)

This field holds the status of the record .Allowed values are "A"- "Active", "I"-  "InActive", "B" - "Blank".

CatInf_CreatedDate

datetime

NULL

This field holds the created date of the record

CatInf_Created_By

varchar(30)

NOT NULL

This field holds the created user of the record

CatInf_ModifiedDate

datetime

NULL

This field holds the modified date of the record

CatInf_Modified_By

varchar(30)

This field holds the user who modified the record

CatInf_Timestamp

numeric(10)

NOT NULL

This field holds the timestamp of the record

Table Name Clm_ClmPrm_parameter_details

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

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

ClmPrm_ComponentName

varchar(80)

NOT NULL

This field holds the Name of the component.

Yes

No

ClmPrm_ParamCategory

varchar(10)

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.

ClmPrm_ParamType

varchar(25)

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.

ClmPrm_ParamCode

varchar(5)

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.

ClmPrm_Langid

numeric(10)

NULL

Language id. This is the language id of the record.

No

ClmPrm_ParamDesc

varchar(80)

Param description is the values to be filled in the combo box or guidance text. This is actually the meta data of this component

ClmPrm_CreationDate

datetime

This field holds the record created date for auditing purpose.

ClmPrm_Sortby

numeric(10)

This field holds the default sort by code

Table Name Clm_CtAInf_Cert_Auth_Info

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

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

CtAInf_Created_OUInstance

numeric(10)

NOT NULL

This is the OU Instance in which the certifying authority codes are defined.

Yes

No

CtAInf_Cert_Auth_Code

varchar(25)

This field holds the certifying authority code

CtAInf_Cert_Auth_Desc

varchar(80)

NULL

This field holds the certifying authority description

No

CtAInf_Cert_Auth_Status

varchar(15)

This field holds the certifying authority status

CtAInf_CreatedDate

datetime

This field holds the created date of the record

CtAInf_Created_By

varchar(30)

This field holds the created user of the record

CtAInf_ModifiedDate

datetime

This field holds the modified date of the record

CtAInf_Modified_By

varchar(30)

This field holds the user who modified the record

CtAInf_Timestamp

numeric(10)

This field holds the timestamp of the record

Table Name Clm_CtInf_Certificate_Info

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

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

CtInf_Created_OUInstance

numeric(10)

NOT NULL

This is the OU instance in which certificate types are defined

Yes

No

CtInf_Certificate_For

varchar(5)

THe "certificate for" is used to define the certificate type for either part or supplier

CtInf_Certificate_Type

varchar(25)

THis field holds the certificate type created by the user.

CtInf_Certificate_Desc

varchar(80)

This field holds the description for the certificate type.

No

CtInf_Certificate_Status

varchar(5)

This field holds the status of the record. "A" - "Active", "I"  -  "Inactive".

CtInf_CreatedDate

datetime

This field holds the created date of the record

CtInf_Created_By

varchar(30)

This field holds the created user of the record

CtInf_ModifiedDate

datetime

This field holds the modified date of the record

CtInf_Modified_By

varchar(30)

This field holds the user who modified the record

CtInf_Timestamp

numeric(10)

This field holds the timestamp of the record

Table Name CLM_INTINF_INSUR_TERMS_INFO

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

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

INTINF_INSUR_TERM_CODE

varchar(150)

NOT NULL

stores the insurance term code

Yes

No

INTINF_CREATED_OUINSTANCE

numeric(10)

stores the OUinstance

INTINF_INSUR_TERM_DESC

varchar(150)

NULL

stores the insurance term description

No

INTINF_INSUR_TERM_STATUS

varchar(5)

stores the insurance term code status

INTINF_CREATED_DATE

datetime

stores the record created date

INTINF_CREATED_BY

varchar(30)

stores the user who created the record

INTINF_MODIFIED_DATE

datetime

stores the record modified date

INTINF_MODIFIED_BY

varchar(30)

stores the user who modified the record

INTINF_TIMESTAMP

decimal(38)

stores the timestamp

Table Name Clm_IOInf_Inv_Options_Info

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

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

IOInf_Created_OUInstance

numeric(10)

NOT NULL

This is the ouinstance in which inventory options are created.

Yes

No

IOInf_Inv_Opt_Id

This is uniquely generated inventory option id.

IOInf_Wh_Code_Unique

varchar(5)

NULL

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

This field holds the created date of the record

IOInf_Created_By

varchar(30)

This field holds the created user of the record

IOInf_ModifiedDate

datetime

This field holds the modified date of the record

IOInf_Modified_By

varchar(30)

This field holds the user who modified the record

IOInf_Timestamp

numeric(10)

This field holds the timestamp of the record

IOInf_Stk_Status_Core_Ret

varchar(25)

This field holds the active values of status as defined in the interacting UDSS for the stock return component

IOInf_Status

varchar(5)

This field holds the status of the records. A- Active I-Inactive

IOINF_STK_VAL_OPT

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

IOINF_AOG_MTL_REQ_AUTH

stores the option for material request authorization for A.O.G A - Automatic M - Manual

Table Name Clm_IRInf_IR_Opt_Info

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

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

IRInf_Created_OUInstance

numeric(10)

NOT NULL

This is the OU Instance in which issue route options are defined

Yes

No

IRInf_IR_Opt_Id

This is uniquely generated id for issue route

IRInf_LWO_Issue_MR

varchar(5)

NULL

This field is set when Line work order is issued through material request

No

IRInf_LWO_Issue_WO

This field is set when Line work order is issued through work order

IRInf_CWO_Issue_MR

This field is set when Component work order is issued through material request

IRInf_CWO_Issue_WO

This field is set when Component work order is issued through work order

IRInf_Tech_Log_Issue_MR

The field is set when tech log document is issued through material request

IRInf_Status

This field holds the status of the records A- Active I -Inactive

IRInf_Created_Date

datetime

This field holds the created date of the record

IRInf_Created_By

varchar(30)

This field holds the created user of the record

IRInf_Modified_Date

datetime

This field holds the modified date of the record

IRInf_Modified_By

varchar(30)

This field holds the user who modified the record

IRInf_Timestamp

varchar(18)

This field holds the timestamp of the record

Table Name CLM_ITINF_INCO_TERMS_INFO

Table Comment This table used to Store the INCO Term Details

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

ITINF_INCO_TERM_CODE

varchar(150)

NOT NULL

stores the inco term code

Yes

No

ITINF_CREATED_OUINSTANCE

numeric(10)

stores the OUinstance

ITINF_INCO_TERM_DESC

varchar(150)

NULL

stores the inco term description

No

ITINF_INCO_TERM_STATUS

varchar(5)

stores the inco term status A- Active I - Inactive

ITINF_CREATED_DATE

datetime

stores the record created date

ITINF_CREATED_BY

varchar(30)

stores the user who created the record

ITINF_MODIFIED_DATE

datetime

stores the record modified date

ITINF_MODIFIED_BY

varchar(30)

stores the user who modified the record

ITINF_TIMESTAMP

decimal(38)

stores the timestamp

Table Name Clm_MRP_Priority_Code_Info

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

MRP_CREATED_OUINSTANCE

int

NULL

This column is used to store the ouinstance

No

No

MRP_LINE_NO

This column is used to store the Line no

MRP_PRIORITY_CODE

sql_variant

This column is used to store the MR priority code

MRP_PRIORITY_DESC

This column is used to store MR priority code description

MRP_ORDER_OF_PREFERENCE

int

This column is used to store the order of preference of priority code

MRP_HISTORY_FLAG

sql_variant

To maintain history flag.’N’ will be stored for current records. ’Y’ will be stored for modified records.

MRP_CODE_STATUS

This column is used to store the status(Active or inactive) of priority code.

MRP_TIMESTAMP

int

This column is used for concurrency check.

MRP_CREATED_BY

sql_variant

This column is used to store the user name who has created the priority code.

MRP_CREATED_DATE

datetime

This column is used to store the created date of Priority

MRP_MODIFIED_BY

sql_variant

This column is used to store the user name who has modify the the priority code information.

MRP_MODIFIED_DATE

datetime

This column is used to store the modified date of Priority

MRP_PREF_ERR_ROWNUM

int

This column is used to store the row number

Table Name CLM_MSDINF_MNTSEPDOC_OPT_INFO

Table 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", "Rental Order", "Loan / Rental Receipt" and "Subcontract Order".

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

MSDINF_CREATED_OUINSTANCE

numeric(10)

NOT NULL

stores the OU instance

Yes

No

MSDINF_OPT_ID

stores the option id which is a sequentially generated no

MSDINF_TRAN_TYPE

varchar(5)

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

NULL

stores the flag to identify whether component type is allowed or not allowed for a given transaction type Y - Yes N - No

MSDINF_PRT_TY_CONS_FLAG

stores the flag to identify whether consumable type is allowed or not allowed for a given transaction type Y - Yes N - No

MSDINF_PRT_TY_KIT_FLAG

stores the flag to identify whether kit type is allowed or not allowed for a given transaction type Y - Yes N - No

MSDINF_PRT_TY_EXP_FLAG

stores the flag to identify whether expendable type is allowed or not allowed for a given transaction type Y - Yes N - No

MSDINF_PRT_TY_TOOL_FLAG

stores the flag to identify whether tool type is allowed or not allowed for a given transaction type Y - Yes N - No

MSDINF_PRT_TY_RMTL_FLAG

stores the flag to identify whether raw material type is allowed or not allowed for a given transaction type Y - Yes N - No

MSDINF_PRT_TY_MISC_FLAG

stores the flag to identify whether miscellaneous type is allowed or not allowed for a given transaction type Y - Yes N - No

MSDINF_STATUS

stores the status of a record for a given transaction type. Always the latest record will be in active status and all previous records will be inactivated

MSDINF_CREATED_DATE

datetime

stores the created date

MSDINF_CREATED_BY

varchar(30)

stores the user who created the record

MSDINF_MODIFIED_DATE

datetime

stores the modified date

MSDINF_MODIFIED_BY

varchar(30)

stores the user who modified the record

MSDINF_TIMESTAMP

numeric(10)

stores the timestamp

Table Name Clm_PCInf_Pkg_code_Info

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

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

PCInf_Created_OUInstance

numeric(10)

NOT NULL

This is the ouinstance in which packaging codes are defined.

Yes

No

PCInf_Pkg_code

varchar(25)

This field is to capture the packaging code

PCInf_Pkg_code_Desc

varchar(150)

NULL

This field is to capture the description of the packaging code.

No

PCInf_Pkg_code_Status

varchar(5)

This field is to capture the status of the packaging code. Allowed values are A- Active I-Inactive

PCInf_CreatedDate

datetime

This field holds the created date of the record

PCInf_Created_By

varchar(30)

This field holds the created user of the record

PCInf_ModifiedDate

datetime

This field holds the modified date of the record

PCInf_Modified_By

varchar(30)

This field holds the user who modified the record

PCInf_Timestamp

numeric(10)

This field holds the timestamp of the record

Table Name CLM_PO_SETOPT_DTL

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

SETOPTDTL_OUINSTANCE

int

NOT NULL

This column is used to store the ouinstance

Yes

No

SETOPTDTL_OPTKEYCODE

sql_variant

to store the parameter code

SETOPTDTL_STATUS

NULL

used to store the status to check data entered or not.

No

SETOPTDTL_VALUE

int

store the option value

SETOPTDTL_HISTORY

sql_variant

used to store the history flag to maintain history

SETOPTDTL_MODIFIEDBY

used to store the user name who modified the data.

SETOPTDTL_MODIFIEDDATE

datetime

used to store the modified date

Table Name CLM_PO_SETOPT_PARAM_VALUES

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

SETOPT_OPTKEYCODE

sql_variant

NOT NULL

used to store the permitted value key code.

Yes

No

SETOPT_LANGID

int

NULL

It is used to store the language ID

No

SETOPT_METADATA_TYPE

sql_variant

used to store the parameter category.

SETOPT_PARAMCODE

It is used to store the parameter code.

SETOPT_PARAMDESC

It is used to store the description of parameter code.

SETOPT_MANDATORY_CHECK

used to store , parameter is mandatory or not

SETOPT_SOTRBY

int

used to sort the parameters

SETOPT_CREATEDDATE

datetime

store the parameter created date

Table Name CLM_PO_SETOPT_PERMIT_VALUES

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

SetOpt_OptLanguage

int

NULL

It is used to store the language ID

No

No

SetOpt_OptKeyCode

sql_variant

It is used to store the permitted value code

SetOpt_permittedvalue

int

It is used to store the permitted values(0,1,...)

SetOpt_permittedvalue_desc

sql_variant

It is used to store the permitted value description

Table Name Clm_POInf_Pur_Options_Info

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

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

POInf_Created_OUInstance

numeric(10)

NOT NULL

This is the ou instance in which purchase options are created

Yes

No

POInf_Pur_Opt_Id

This is uniquely generated purchase option id.

POInf_Prt_Supp_Map

varchar(5)

NULL

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"  - "Allow Express PO and dont map part to supplier" "B" - "Blank".

No

POInf_CreatedDate

datetime

This field holds the created date of the record

POInf_Sup_Manu_Allow

varchar(5)

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.

POInf_Created_By

varchar(30)

This field holds the created user of the record

POINF_MOVE_TO_DIFF_WH

varchar(18)

stores option whether movement to different warehouse is allowed or not A - Allowed NA - Not Allowed

POINF_APP_DTCD_LINEITM_ON

stores the options for the value to apportion the doc TCDs to line items BV - Basic Value TV - Total Value

POInf_Status

varchar(5)

This field holds the status of the record A-Active I-Inactive

POInf_Prt_Buy_Ctrl

It holds the following values "Needed" and "Not Needed"

POInf_ModifiedDate

datetime

This field holds the modified date of the record

POInf_Modified_By

varchar(30)

This field holds the user who modified the record

POInf_Movement_To_CC

varchar(5)

Stores the option whether the part can be directly moved to consumption centre or not A - Allowed NA - Not Allowed

POInf_Timestamp

numeric(10)

This field holds the timestamp of the record

POInf_Comp_Id

varchar(90)

To store the Default Component Id Value.

POINF_CMP_CHK

varchar(5)

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:

POInf_Matypol

varchar(20)

poinf_mandate_WrkCntr

varchar(5)

To store mandate work center set option values

POINF_SUPPCLS_REPAGNCY

To enable supplier class-repair agency mapping

Table Name Clm_PTInf_Prt_Ty_Opt_Info

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

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

PTInf_Created_OUInstance

numeric(10)

NOT NULL

This is the OU instance in which part type options are defined.

Yes

No

PTInf_Opt_Id

This is uniquely generated option id

PTInf_Tran_Type

varchar(5)

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"

PTInf_Prt_Ty_All_Flag

NULL

This flag is set when part types allowed are set for ALL

No

PTInf_Prt_Ty_Comp_Flag

This flag is set when part types allowed are set as components

PTInf_Prt_Ty_Cons_Flag

This flag is set when part types allowed are set as consumables

PTInf_Prt_Ty_Kit_Flag

This flag is set when part types allowed are set as kits

PTInf_Prt_Ty_Spre_Flag

This flag is set when part types allowed are set as spares

PTInf_Prt_Ty_Tool_Flag

This flag is set when part types allowed are set as tools

PTInf_Prt_Ty_RMtl_Flag

This flag is set when part types allowed are set as raw material

PTINF_STATUS

This field stores the status of the record I- Inactive A- Active

PTInf_Created_Date

datetime

This field holds the created date of the record

PTInf_Created_By

varchar(30)

This field holds the created user of the record

PTInf_Modified_Date

datetime

This field holds the modified date of the record

PTInf_Modified_By

varchar(30)

This field holds the user who modified the record

PTInf_Timestamp

numeric(10)

This field holds the timestamp of the record

PTINF_PRT_TY_MISC_FLAG

varchar(5)

This flag is set when part types allowed are set as miscellaneous

Table Name Clm_PyInf_Prty_Code_Info

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

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

PyInf_Created_OUInstance

numeric(10)

NOT NULL

This is the column in which the priority codes are defined

Yes

No

PyInf_Prty_Code

varchar(20)

This field is to capture the priority codes

PyInf_Prty_Code_Desc

varchar(150)

NULL

This field is to capture the description of the priority code

No

PyInf_Prty_Code_Status

varchar(5)

This field is to capture the status of the priority code. Allowed values are A- Active I- Inactive

PyInf_CreatedDate

datetime

This field holds the created date of the record

PyInf_Created_By

varchar(30)

This field holds the created user of the record

PyInf_ModifiedDate

datetime

This field holds the modified date of the record

PyInf_Modified_By

varchar(30)

This field holds the user who modified the record

PyInf_Timestamp

numeric(10)

This field holds the timestamp of the record

Table Name Clm_RnInf_Reason_Code_Info

Table 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.

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

RnInf_Created_OUInstance

numeric(10)

NOT NULL

This is the OUInstance in which reason code is created

Yes

No

RnInf_Reason_Code

varchar(25)

This field is to capture user defined reason codes for the types "QUARANTINE" and "REJECTION"

RnInf_Reason_Code_Type

varchar(5)

This field is to hold the type of the reason code. Allowed Values are "Q" - "Quarantine", "R" - "Rejection".

RnInf_Reason_Desc

varchar(255)

This field is to capture the reason description.

No

RnInf_Reason_Status

varchar(15)

This field is to store the status of the record. Allowed values are "A"- "Active", "I"-  "InActive", "B" - "Blank".

RnInf_CreatedDate

datetime

NULL

This field holds the created date of the record

RnInf_Created_By

varchar(30)

This field holds the created user of the record

RnInf_ModifiedDate

datetime

This field holds the modified date of the record

RnInf_Modified_By

varchar(30)

This field holds the user who modified the record

RnInf_Timestamp

numeric(10)

NOT NULL

This field holds the timestamp of the record

Table Name Clm_RPInf_Rep_Proc_Info

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

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

RPInf_Created_OUInstance

numeric(10)

NOT NULL

This is the ou instance in which repair process codes are defined

Yes

No

RPInf_Rep_Proc_Code

varchar(25)

THe repair process descriptions are codified in this field

RPInf_Rep_Proc_Desc

varchar(150)

NULL

This field is to capture the repair process description

No

RPInf_Rep_Proc_Status

varchar(5)

This is field which captures the status of repair process code

RPInf_CreatedDate

datetime

This field holds the created date of the record

RPInf_Created_By

varchar(30)

This field holds the created user of the record

RPInf_ModifiedDate

datetime

This field holds the modified date of the record

RPInf_Modified_By

varchar(30)

This field holds the user who modified the record

RPInf_Timestamp

numeric(10)

This field holds the timestamp of the record

Table Name Clm_SCInf_SC_Opt_Info

Table Comment This is the table in which stock correction options are defined

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

SCInf_Created_OUInstance

numeric(10)

NOT NULL

This is the OUInstance in which stock correction options are created

Yes

No

SCInf_SC_Opt_Id

This is uniquely generated stock correction option id

SCInf_Phy_Inv_Qty

varchar(5)

NULL

This field is set when physical inventory has quantity as stock correction measure.

No

SCInf_Phy_Inv_Qty_Value

This field is set when physical inventory has quantity & value as stock correction measure.

SCInf_Cyc_Cnt_Qty

This field is set when cycle count has quantity as stock correction measure

SCInf_Cyc_Cnt_Qty_Value

This field is set when cycle count has both quantity and value as stock correction options.

SCInf_Gen_Qty

This field is set when general stock correction option is of quantity type

SCInf_Gen_Value

This field is set when general stock correction option is of value type

SCInf_Gen_Qty_Value

This field is set when general stock correction options are of both types: 1.quantity 2.value

SCInf_Status

This field captures the status of the record. Allowed values are A- Active I- Inactive

SCInf_Created_Date

datetime

This field holds the created date of the record

SCInf_Created_By

varchar(30)

This field holds the created user of the record

SCInf_Modified_Date

datetime

This field holds the modified date of the record

SCInf_Modified_By

varchar(30)

This field holds the user who modified the record

SCInf_Timestamp

numeric(10)

This field holds the timestamp of the record

Table Name Clm_SCInf_Ship_Cost_Info

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

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

SCInf_Created_OUInstance

numeric(10)

NOT NULL

This is the ouinstance in which shipping cost codes are defined

Yes

No

SCInf_Ship_Cost_Code

varchar(25)

This field is to capture the shipping cost code

SCInf_Ship_Cost_Desc

varchar(150)

NULL

This field is to capture the description of the shipping cost code

No

SCInf_Ship_Cost_Status

varchar(5)

This field is to capture the status of shipping cost codes. Allowed values are A- Active I- Inactive

SCInf_CreatedDate

datetime

This field holds the created date of the record

SCInf_Created_By

varchar(30)

This field holds the created user of the record

SCInf_ModifiedDate

datetime

This field holds the modified date of the record

SCInf_Modified_By

varchar(30)

This field holds the user who modified the record

SCInf_Timestamp

numeric(10)

This field holds the timestamp of the record

Table Name Clm_SMInf_Ship_Met_Info

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

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

SMInf_Created_OUInstance

numeric(10)

NOT NULL

This is the OUInstance in which shipping method codes are created

Yes

No

SMInf_Ship_Method_Code

varchar(25)

Shipping methods of Parts are codified in this field

SMInf_Ship_Method_Desc

varchar(150)

NULL

This field contains the exact description of the shipping method

No

SMInf_Ship_Method_Status

varchar(5)

This is the status of the shipping method. Allowed values are A- Active I-Inactive

SMInf_CreatedDate

datetime

This field holds the created date of the record

SMInf_Created_By

varchar(30)

This field holds the created user of the record

SMInf_ModifiedDate

datetime

This field holds the modified date of the record

SMInf_Modified_By

varchar(30)

This field holds the user who modified the record

SMInf_Timestamp

numeric(10)

This field holds the timestamp of the record

Table Name Clm_UOInf_Usr_Opt_Info

Table Comment This is the ou instance in which user options are created

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

UOInf_Created_OUInstance

numeric(10)

NOT NULL

This is the ou instance in which the user options are created

Yes

No

UOInf_Usr_Opt_For

varchar(5)

NOT NULL

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

No

UOInf_Usr_Opt_Value_For

varchar(5)

NOT NULL

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

No

UOInf_Usr_Opt_Value

varchar(18)

NOT NULL

The exact character value of the user options is stored .

Yes

No

UOInf_Usr_Opt_Desc

varchar(150)

NULL

This field is to capture the description of user options

No

No

UOInf_Usr_Opt_Status

varchar(5)

NULL

This is the status in which user option is created. Allowed values are A- Active I- Inactive

No

No

UOInf_CreatedDate

datetime

NULL

This field holds the created date of the record

No

No

UOInf_Created_By

varchar(30)

NULL

This field holds the created user of the record

No

No

UOInf_ModifiedDate

datetime

NULL

This field holds the modified date of the record

No

No

UOInf_Modified_By

varchar(30)

NULL

This field holds the user who modified the record

No

No

UOInf_Timestamp

numeric(10)

NULL

This field holds the timestamp of the record

No

No

Table Name Clm_USInf_User_Status_Info

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

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

USInf_Created_OUInstance

numeric(10)

NOT NULL

This is the OUinstance in which user status is created.

Yes

No

USInf_Document_Code

varchar(5)

NOT NULL

This field holds the document codes for which user status are created. "PO", "GR", "GRS",   "PR", "BPO", "RS", "RO", "RFQ" "SCO" "LO" "RTO"

Yes

No

USInf_User_Status

varchar(25)

NOT NULL

This field holds the user status of the document

Yes

No

USInf_User_Status_Desc

varchar(80)

NULL

This field hold s the description of the user status

No

No

USInf_Status

varchar(15)

NULL

This field holds the status of the record. A-Active I-Inactive

No

No

USInf_CreatedDate

datetime

NULL

This field holds the created date of the record

No

No

USInf_Created_By

varchar(30)

NULL

This field holds the created user of the record

No

No

USInf_ModifiedDate

datetime

NULL

This field holds the modified date of the record

No

No

USInf_Modified_By

varchar(30)

NULL

This field holds the user who modified the record

No

No

USInf_Timestamp

numeric(10)

NULL

This field holds the timestamp of the record

No

No

Table Name LCM_PARAMETER_DETAILS

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

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

LCM_COMPONENTNAME

sql_variant

NOT NULL

This field holds the Name of the component.

No

No

LCM_PARAMCATEGORY

sql_variant

NOT NULL

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

No

LCM_PARAMTYPE

sql_variant

NOT NULL

This will allow us to store all the possible values for a combo in multiple rows.

No

No

LCM_PARAMCODE

sql_variant

NOT NULL

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

No

LCM_LANGID

bigint

NOT NULL

Language id. This is the language id of the record.

No

No

LCM_PARAMDESC

sql_variant

NULL

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

No

LCM_SORT_BY

bigint

This field holds the default sort by code

No

No

Table Name LCM_set_option_dtl

Table Comment LCM_set_option_dtl

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

SETOPTDTL_OUINSTANCE

int

NOT NULL

Yes

No

SETOPTDTL_OPTKEYCODE

sql_variant

NOT NULL

to store the parameter code

Yes

No

SETOPTDTL_STATUS

sql_variant

NULL

used to store the status to check data entered or not.

No

No

SETOPTDTL_VALUE

int

NULL

store the option value

No

No

SETOPTDTL_MODIFIEDBY

sql_variant

NULL

used to store the user name who modified the data.

No

No

SETOPTDTL_MODIFIEDDATE

datetime

NULL

used to store the modified date

No

No

Table Name LCM_SET_OPTION_HDR

Table Comment LCM_SET_OPTION_HDR

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

setopthdr_ouinstance

int

NULL

No

No

setopthdr_timestamp

int

NULL

To Store the timestamp.

No

No

setopthdr_createdby

sql_variant

NULL

stores the user who created the record

No

No

setopthdr_createddate

datetime

NULL

stores the record created date

No

No

setopthdr_modifiedby

sql_variant

NULL

stores the user who modified the record

No

No

setopthdr_modifieddate

datetime

NULL

stores the record modified date

No

No

Table Name LCM_SET_OPTION_PARAM_VALUES

Table Comment LCM_SET_OPTION_PARAM_VALUES

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

SETOPT_OPTKEYCODE

sql_variant

NOT NULL

Yes

No

SETOPT_LANGID

int

NULL

It is used to store the language ID

No

No

SETOPT_METADATA_TYPE

sql_variant

NULL

used to store the parameter category.

No

No

SETOPT_PARAMCODE

sql_variant

NULL

It is used to store the parameter code.

No

No

SETOPT_PARAMDESC

sql_variant

NULL

It is used to store the description of parameter code.

No

No

SETOPT_MANDATORY_CHECK

sql_variant

NULL

used to store , parameter is mandatory or not

No

No

SETOPT_SOTRBY

int

NULL

used to sort the parameters

No

No

SETOPT_CREATEDDATE

datetime

NULL

store the parameter created date

No

No

Table Name LCM_SET_OPTION_PERMIT_VALUES

Table Comment LCM_SET_OPTION_PERMIT_VALUES

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

SetOpt_OptLanguage

int

NULL

Language code

No

No

SetOpt_OptKeyCode

sql_variant

NULL

It is used to store the permitted value code

No

No

SetOpt_permittedvalue

int

NULL

It is used to store the permitted values(0,1,...)

No

No

SetOpt_permittedvalue_desc

sql_variant

NULL

It is used to store the permitted value description

No

No