Data Dictionary -- Kit Management

Srl. No.	Table Name	Comment
1	KM_KICSL_CONS_INFO	KM_KICSL_CONS_INFO
2	KM_KISL_KIT_SRLLOT_INFO	KM_KISL_KIT_SRLLOT_INFO
3	KM_KTC_CONS_TRN_DTL	KM_KTC_CONS_TRN_DTL
4	KM_KTH_TRN_HDR	KM_KTH_TRN_HDR
5	KM_KTSL_SRLLOT_TRN_DTL	KM_KTSL_SRLLOT_TRN_DTL

Table Name :	KM_KICSL_CONS_INFO
Comment :	KM_KICSL_CONS_INFO

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
KICSL_KITSRLSMNREF	udd_seqno	int(4)	Yes	KITSRLSMNREF	No
KICSL_BOMLINENO	udd_lineno	int(4)	Yes	BOMLINENO	No
KICSL_CONSPARTCRTOU	udd_ctxt_ouinstance	int(4)	Yes	CONSPARTCRTOU	No
KICSL_CONSPARTNO	udd_partno	varchar(40)	Yes	CONSPARTNO	No
KICSL_CONSSRLNO	UDD_SERIALNO	varchar(40)	Yes	CONSSRLNO	No
KICSL_CONSLOTNO	udd_lotno	varchar(18)	Yes	CONSLOTNO	No
KICSL_QTY	udd_quantity	numeric(13)	Yes	QUANTITY	No
KICSL_CONSSTKSTATUS	udd_partstatus	varchar(40)	Yes	CONSSTOCKSTATUS	No
KICSL_CONSPARTCONDN	udd_designparamcode	varchar(5)	Yes	CONSPARTCONDITION	No
KICSL_OWNERSHIP	udd_designparamcode	varchar(5)	Yes	OWNERSHIP	No
KICSL_OWNINGAGENCYOU	udd_ctxt_ouinstance	int(4)	Yes	OWNINGAGENCYOU	No
KICSL_OWNINGAGENCY	udd_vendorcode	varchar(45)	Yes	OWNINGAGENCY	No
KICSL_EXPIRYDATE	udd_time	datetime(8)	Yes	EXPIRYDATE	No
KICSL_SRCDOCTYPE	udd_type	varchar(25)	Yes	SOURCE DOCUMENT TYPE	No
KICSL_SRCDOCNO	udd_documentno	varchar(40)	Yes	SOURCE DOCUMENT NO	No
KICSL_LSTUPDDOCTYPE	udd_type	varchar(25)	Yes	LAST UPDATE DOC TYPE	No
KICSL_LSTUPDDOCNO	udd_documentno	varchar(40)	Yes	LAST UPDATE DOCNO	No
KICSL_CREATEDBY	udd_ctxt_user	varchar(30)	Yes	CREATED BY	No
KICSL_CREATEDDATE	udd_time	datetime(8)	Yes	CREATED DATE	No
KICSL_MODIFIEDBY	udd_ctxt_user	varchar(30)	Yes	MODIFIED BY	No
KICSL_MODIFIEDDATE	udd_time	datetime(8)	Yes	MODIFIED DATE	No
KICSL_MFRSRLNO	udd_partserialnumber	varchar(40)	Yes	MFRSRLNO	No
KICSL_MFRLOTNO	udd_partserialnumber	varchar(40)	Yes	MFRLOTNO	No
REPLICATION_KEY	_bigint_8	Bigint(8)	No	REPLICATION KEY	Yes
KICSL_CONS_COST	udd_cost	numeric(13)	Yes	CONSCOST	No
KICSL_SeqNO	udd_seqno	int(4)	Yes	SEQUENCE NUMBER	No

Table Name :	KM_KISL_KIT_SRLLOT_INFO
Comment :	KM_KISL_KIT_SRLLOT_INFO

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
KISL_KITSRLSMNREF	udd_seqno	int(4)	No	KITSRLSMNREF	Yes
KISL_KITPARTCRTOU	udd_ctxt_ouinstance	int(4)	Yes	KITPARTCRTOU	No
KISL_KITPARTNO	udd_partno	varchar(40)	Yes	KITPARTNO	No
KISL_KITMFRSRLNO	UDD_SERIALNO	varchar(40)	Yes	KITMFRSRLNO	No
KISL_KITMFRLOTNO	udd_lotno	varchar(18)	Yes	KITMFRLOTNO	No
KISL_KITSRLNO	UDD_SERIALNO	varchar(40)	Yes	KITSRLNO	No
KISL_KITLOTNO	udd_lotno	varchar(18)	Yes	KITLOTNO	No
KISL_KITSRLCOMPLETED	udd_designparamcode	varchar(5)	Yes	KITSRLCOMPLETED	No
KISL_SRCDOCTYPE	udd_type	varchar(25)	Yes	SOURCE DOCTYPE	No
KISL_SRCDOCNO	udd_documentno	varchar(40)	Yes	SOURCE DOCNO	No
KISL_CREATEDBY	udd_ctxt_user	varchar(30)	Yes	CREATED BY	No
KISL_CREATEDDATE	udd_time	datetime(8)	Yes	CREATED DATE	No
KISL_MODIFIEDBY	udd_ctxt_user	varchar(30)	Yes	MODIFIED BY	No
KISL_MODIFIEDDATE	udd_time	datetime(8)	Yes	MODIFIED DATE	No
KISL_KITCOST	udd_cost	numeric(13)	Yes	Kit COST	No

Table Name :	KM_KTC_CONS_TRN_DTL
Comment :	KM_KTC_CONS_TRN_DTL

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
KTC_TRNOU	udd_ctxt_ouinstance	int(4)	No	TRANSACTION OUINSTANCE	Yes
KTC_TRNNO	udd_documentno	varchar(40)	No	TRANSACTION NO	Yes
KTC_BOMLINENO	udd_lineno	int(4)	Yes	BOMLINENO	No
KTC_KITSRLLINENO	udd_lineno	int(4)	Yes	KITSRLLINENO	No
KTC_KITMFRSRLNO	UDD_SERIALNO	varchar(40)	Yes	KITMFRSRLNO	No
KTC_CONSSEQNO	udd_seqno	int(4)	No	CONSSEQNO	Yes
KTC_CONSPARTCRTOU	udd_ctxt_ouinstance	int(4)	Yes	CONSPARTCRTOU	No
KTC_CONSPARTNO	udd_partno	varchar(40)	Yes	CONSPARTNO	No
KTC_CONSMFRPARTNO	udd_partno	varchar(40)	Yes	CONSMFRPARTNO	No
KTC_CONSMFRNO	udd_vendorcode	varchar(45)	Yes	CONSMFRNO	No
KTC_QTY	udd_quantity	numeric(13)	Yes	QUANTITY	No
KTC_CONSSTKSTATUS	udd_partstatus	varchar(40)	Yes	CONSSTKSTATUS	No
KTC_CONSPARTCOND	udd_designparamcode	varchar(5)	Yes	CONSPARTCOND	No
KTC_CONSSRLNO	UDD_SERIALNO	varchar(40)	Yes	CONSSRLNO	No
KTC_CONSMFRSRLNO	UDD_SERIALNO	varchar(40)	Yes	CONSMFRSRLNO	No
KTC_CONSLOTNO	udd_lotno	varchar(18)	Yes	CONSLOTNO	No
KTC_CONSMFRLOTNO	udd_lotno	varchar(18)	Yes	CONSMFRLOTNO	No
KTC_ZONE	udd_zone	varchar(10)	Yes	ZONE	No
KTC_BIN	udd_bin	varchar(10)	Yes	BIN	No
KTC_REMARKS	udd_txt255	varchar(255)	Yes	REMARKS	No
KTC_EXPDATE	udd_time	datetime(8)	Yes	EXPDATE	No
KTC_REQTYPE	udd_designparamcode	varchar(5)	Yes	REQTYPE	No
KTC_BREAKQTY	udd_quantity	numeric(13)	Yes	BREAKQTY	No
KTC_REPLENISHMENTMR	udd_flag	varchar(25)	Yes	REPLENISHMENTMR	No
KTC_SeqNO	udd_seqno	int(4)	Yes	SEQUENCE NUMBER	No

Table Name :	KM_KTH_TRN_HDR
Comment :	KM_KTH_TRN_HDR

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
KTH_TRNOU	udd_ctxt_ouinstance	int(4)	No	TRANSACTION OUINSTANCE	Yes
KTH_TRNNO	udd_documentno	varchar(40)	No	TRANSACTION NO	Yes
KTH_KITUNIQUEID	udd_seqno	int(4)	Yes	KITUNIQUEID	No
KTH_KITPARTCRTOU	udd_ctxt_ouinstance	int(4)	Yes	KITPARTCRTOU	No
KTH_KITPARTNO	udd_partno	varchar(40)	Yes	KIT PART NO	No
KTH_KITMFRPARTNO	udd_partno	varchar(40)	Yes	KITMFRPARTNO	No
KTH_KITMFRNO	udd_vendorcode	varchar(45)	Yes	KIT MFRNO	No
KTH_KITOPERATION	udd_txt20	varchar(20)	Yes	KIT OPERATION	No
KTH_REFDET	udd_flag	varchar(25)	Yes	REFDET	No
KTH_STATUS	udd_designparamcode	varchar(5)	Yes	STATUS	No
KTH_KITCATEG	udd_flag	varchar(25)	Yes	KITCATEG	No
KTH_USERSTAT	udd_flag	varchar(25)	Yes	USERSTAT	No
KTH_REQUESTEDBY	udd_ctxt_user	varchar(30)	Yes	REQUESTED BY	No
KTH_KITOPERATIONBY	udd_ctxt_user	varchar(30)	Yes	KITOPERATION BY	No
KTH_WHOU	udd_ctxt_ouinstance	int(4)	Yes	WAREHOUSE OUINSTANCE	No
KTH_WHID	udd_warehouse	varchar(10)	Yes	WAREHOUSE ID	No
KTH_QTY	udd_quantity	numeric(13)	Yes	QUANTITY	No
KTH_ALWINCMPLKIT	udd_designparamcode	varchar(5)	Yes	ALWINCMPLKIT	No
KTH_REMARKS	udd_txt2000	varchar(2000)	Yes	REMARKS	No
KTH_COMMENTS	udd_txt2000	varchar(2000)	Yes	COMMENTS	No
KTH_CREATEDBY	udd_ctxt_user	varchar(30)	Yes	CREATED BY	No
KTH_CREATEDDATE	udd_time	datetime(8)	Yes	CREATED DATE	No
KTH_MODIFIEDBY	udd_ctxt_user	varchar(30)	Yes	MODIFIED BY	No
KTH_MODIFEDDATE	udd_time	datetime(8)	Yes	MODIFED DATE	No
KTH_TIMESTAMP	udd_timestamp	int(4)	Yes	TIMESTAMP	No
KTH_BLDOWNERSHIP	udd_designparamcode	varchar(5)	Yes	BLDOWNERSHIP	No
KTH_BLDOWNINGAGENCY	udd_vendorcode	varchar(45)	Yes	BLDOWNINGAGENCY	No
KTH_BLDOWNINGAGENCYOU	udd_ctxt_ouinstance	int(4)	Yes	BLDOWNINGAGENCYOU	No
KTH_BLDSTKSTATUS	udd_partstatus	varchar(40)	Yes	BLDSTOCK STATUS	No
KTH_BLDPARTCOND	udd_designparamcode	varchar(5)	Yes	BLD PART CONDITION	No
KTH_BREAKALLPARTS	udd_designparamcode	varchar(5)	Yes	BREAK ALL PARTS	No

Table Name :	KM_KTSL_SRLLOT_TRN_DTL
Comment :	KM_KTSL_SRLLOT_TRN_DTL

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
KTSL_TRNOU	udd_ctxt_ouinstance	int(4)	No	TRANSACTION OUINSTANCE	Yes
KTSL_TRNNO	udd_documentno	varchar(40)	No	TRANSACTION NO	Yes
KTSL_KITSRLLINENO	udd_lineno	int(4)	No	KITSRLLINENO	Yes
KTSL_KITMFRSRLNO	UDD_SERIALNO	varchar(40)	Yes	KITMFRSRLNO	No
KTSL_KITMFRLOTNO	udd_lotno	varchar(18)	Yes	KITMFRLOTNO	No
KTSL_KITSRLNO	UDD_SERIALNO	varchar(40)	Yes	KITSRLNO	No
KTSL_KITLOTNO	udd_lotno	varchar(18)	Yes	KITLOTNO	No
KTSL_ZONE	udd_zone	varchar(10)	Yes	ZONE	No
KTSL_BIN	udd_bin	varchar(10)	Yes	BIN	No
KTSL_REMARKS	udd_txt255	varchar(255)	Yes	REMARKS	No
KTSL_LINESTATUS	udd_designparamcode	varchar(5)	Yes	LINE STATUS	No
KTSL_OWNERSHIP	udd_designparamcode	varchar(5)	Yes	OWNERSHIP	No
KTSL_OWNINGAGENCY	udd_vendorcode	varchar(45)	Yes	OWNINGAGENCY	No
KTSL_OWNINGAGENCYOU	udd_ctxt_ouinstance	int(4)	Yes	OWNINGAGENCYOU	No
KTSL_STKSTATUS	udd_partstatus	varchar(40)	Yes	STKSTATUS	No
KTSL_PARTCOND	udd_designparamcode	varchar(5)	Yes	PARTCOND	No
KTSL_ISUOU	udd_ctxt_ouinstance	int(4)	Yes	ISSUE OUINSTANCE	No
KTSL_ISUNO	udd_documentno	varchar(40)	Yes	ISSUE NO	No
KTSL_RTNOU	udd_ctxt_ouinstance	int(4)	Yes	RTNOU	No
KTSL_RTNNO	udd_documentno	varchar(40)	Yes	RTNNO	No
KTSL_CONSAVL	udd_designparamcode	varchar(5)	Yes	CONSAVL	No
KTSL_INSPSTATUS	udd_status	varchar(25)	Yes	INSPSTATUS	No
KTSL_CERTIFICATENO	udd_documentno	varchar(40)	Yes	CERTIFICATENO	No
KTSL_CERTIFICATETYPE	udd_documenttype	varchar(40)	Yes	CERTIFICATE TYPE	No
KTSL_CERTIFICATEDATE	udd_time	datetime(8)	Yes	CERTIFICATE DATE	No
KTSL_CANCELATIONCOMMENTS	udd_txt2000	varchar(2000)	Yes	CANCELATION COMMENTS	No