Database Schema for

Data Dictionary -- Stock Planning

Srl. No.	Table Name	Comment
1	STKPLN_BATCH_DMND_PRCS_LOG	STKPLN_BATCH_DMND_PRCS_LOG
2	STKPLN_BATCH_PROCESS_LOG	STKPLN_BATCH_PROCESS_LOG
3	STKPLN_BATCH_RCPT_PRCS_LOG	STKPLN_BATCH_RCPT_PRCS_LOG
4	STKPLN_DMD_DEMANDDETAIL	Information about the Demands raised.
5	STKPLN_DSPOPDT_OPT_SETTING	Information about the Alert Count and Carry over count value for the Demand s and Receipts raised.
6	STKPLN_DSPOPMN_OPT_SETTING	Setting Options for 1.Online reservation of Demands and Receipts 2.Auto PR generation 3 Quantity Conversional Method Definition 4.Method for conversion of Fractional Quantity 5. Attempt Delink Relink Process for New Demands
7	STKPLN_DSPPRM_PARAM_DETAIL	Parameter Details Information
8	STKPLN_PG_PEGGINGDETAIL	Information about Demands Reserved against the Receipts
9	STKPLN_RPT_RECEIPTDETAIL	Information about the available free quantity and the quantity reserved for the Receipts and Physical Stock.


Table Name :	STKPLN_BATCH_DMND_PRCS_LOG
Comment :	STKPLN_BATCH_DMND_PRCS_LOG


Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
BATCH_DMND_WH_OU	_decimal_10_0	decimal(10)	Yes	Created OU Instance	No
BATCH_DMND_WH_CODE	_varchar_10	varchar(10)	Yes	Warehouse	No
BATCH_DMND_PART_OU	_decimal_10_0	decimal(10)	Yes	Part OU Instance	No
BATCH_DMND_PART_NO	_varchar_40	varchar(40)	Yes	Part number	No
BATCH_DMND_DOC_OU	_decimal_10_0	decimal(10)	Yes	Document OU Instance	No
BATCH_DMND_DOC_NO	_varchar_18	varchar(18)	Yes	Demand Document number	No
BATCH_DMND_DOC_TYPE	_varchar_25	Varchar(25)	Yes	Document Type	No
BATCH_DMND_LEVEL1NO	_decimal_10_0	decimal(10)	Yes	Level1 Number	No
BATCH_DMND_LEVEL2NO	_decimal_10_0	decimal(10)	Yes	Level2 Number	No
BATCH_DMND_LEVEL3NO	_decimal_10_0	decimal(10)	Yes	Level3 Number	No
BATCH_DMND_STATUS	_varchar_5	varchar(5)	Yes	Demand Status	No
BATCH_DMND_DATE	_datetime_8	datetime(8)	Yes	Demand Date	No
REPLICATION_KEY	_bigint_8	Bigint(8)	No	Replication Key	Yes


Table Name :	STKPLN_BATCH_PROCESS_LOG
Comment :	STKPLN_BATCH_PROCESS_LOG


Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
BATCH_RCPT_DOC_OU	_decimal_10_0	decimal(10)	No	Receipt Document OUInstance	No
BATCH_RCPT_DOC_TYPE	_varchar_25	Varchar(25)	No	Receipt Document Type	No
BATCH_RCPT_DOC_NO	_varchar_18	varchar(18)	No	Receipt Document Number	No
BATCH_RCPT_DATE	_datetime_8	datetime(8)	No	Receipt Date	No
BATCH_DMND_DOC_OU	_decimal_10_0	decimal(10)	No	Demand Document OU	No
BATCH_DMND_DOC_NO	_varchar_18	varchar(18)	No	Demand Document number	No
BATCH_DMND_DOC_TYPE	_varchar_25	Varchar(25)	No	Demand Doc Type	No
BATCH_DMND_DATE	_datetime_8	datetime(8)	No	Demand Date	No
REPLICATION_KEY	_bigint_8	Bigint(8)	No	Replication Key	Yes


Table Name :	STKPLN_BATCH_RCPT_PRCS_LOG
Comment :	STKPLN_BATCH_RCPT_PRCS_LOG


Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
BATCH_RCPT_WH_OU	_decimal_10_0	decimal(10)	Yes	Receipt Warehouse OU	No
BATCH_RCPT_WH_CODE	_varchar_10	varchar(10)	Yes	Receipt Warehouse Code	No
BATCH_RCPT_PART_OU	_decimal_10_0	decimal(10)	Yes	Receipt Part OU Instance	No
BATCH_RCPT_PART_NO	_varchar_40	varchar(40)	Yes	Receipt Part Number	No
BATCH_RCPT_DOC_OU	_decimal_10_0	decimal(10)	Yes	Receipt Document OUInstance	No
BATCH_RCPT_DOC_NO	_varchar_18	varchar(18)	Yes	Receipt Document Number	No
BATCH_RCPT_DOC_TYPE	_varchar_25	Varchar(25)	Yes	Recept Document type	No
BATCH_RCPT_LEVEL1NO	_decimal_10_0	decimal(10)	Yes	Level1 Number	No
BATCH_RCPT_LEVEL2NO	_decimal_10_0	decimal(10)	Yes	Level2 Number	No
BATCH_RCPT_LEVEL3NO	_decimal_10_0	decimal(10)	Yes	Level3 Number	No
BATCH_RCPT_STATUS	_varchar_5	varchar(5)	Yes	Batch Receipt Status	No
BATCH_RCPT_DATE	_datetime_8	datetime(8)	Yes	Receipt Date	No
REPLICATION_KEY	_bigint_8	Bigint(8)	No	Replication Key	Yes


Table Name :	STKPLN_DMD_DEMANDDETAIL
Comment :	Information about the Demands raised.


Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
DMD_OUINSTANCE	_decimal_10_0	decimal(10)	No	Demand OU Instance	Yes
DMD_WAREHOUSEOU	_decimal_10_0	decimal(10)	No	Warehouse OU Instance	Yes
DMD_WAREHOUSECODE	_varchar_10	varchar(10)	No	Warehouse ID	Yes
DMD_DOCUMENTOU	_decimal_10_0	decimal(10)	No	Document OU Instance	Yes
DMD_DOCTYPE	_varchar_25	Varchar(25)	No	Document Type	Yes
DMD_DOCUMENTNO	_varchar_18	varchar(18)	No	Document Number	Yes
DMD_LEVEL1NO	_decimal_10_0	decimal(10)	No	Line Number.	Yes
DMD_LEVEL2NO	_decimal_10_0	decimal(10)	No	Subline Number	Yes
DMD_LEVEL3NO	_decimal_10_0	decimal(10)	No	Schedule Number	Yes
DMD_ITEMCRTOU	_decimal_10_0	decimal(10)	No	Part created Ouinstance	Yes
DMD_ITEMCODE	_varchar_40	varchar(40)	No	Part Number	Yes
DMD_STATUS	_varchar_5	varchar(5)	No	P for Plan Demand F for Firm Demand	Yes
DMD_DEMANDDATE	_datetime_8	datetime(8)	No	DEMANDDATE	No
DMD_PARTPLNOU	_decimal_10_0	decimal(10)	Yes	Part Plan OU instance	No
DMD_CATEGORY	_varchar_25	Varchar(25)	Yes	IA for Inactive Demands PD for Problem Demands UR Unrealized Demands	No
DMD_QTY	_decimal_28_8	decimal(28)	No	Demand Quantity	No
DMD_PROBLEMQTY	_decimal_28_8	decimal(28)	No	Demand Quantity unreserved	No


Table Name :	STKPLN_DSPOPDT_OPT_SETTING
Comment :	Information about the Alert Count and Carry over count value for the Demand s and Receipts raised.


Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
DSPOPMN_OUINSTANCE	_decimal_10_0	decimal(10)	No	ouinstance	Yes
DSPOPDT_COMP_SET	_varchar_25	Varchar(25)	No	Carry Over Count Details 1.Issue against Material Request 2.Reservation by Visit Package 3.Receipt against Purchase Order 4.Receipt against Purchase Request 5.Receipt against Release Slip 6.Receipt against Hangar Work Order 7.Receipt against Compon	Yes
DSPOPDT_ALERT_CNT	_decimal_10_0	decimal(10)	No	(The number of days by which the demand posted by a material request, reservation by visit package or a receipt against a purchase order can be carried over) Alert count defined in days	No
DSPOPDT_CARRYOVER_CNT	_decimal_10_0	decimal(10)	No	The number of days set for reminder, for which the demand posted by a material request, reservation by visit package or a receipt against a purchase order can be carried over (Carry over count defined in days)	No


Table Name :	STKPLN_DSPOPMN_OPT_SETTING
Comment :	Setting Options for 1.Online reservation of Demands and Receipts 2.Auto PR generation 3 Quantity Conversional Method Definition 4.Method for conversion of Fractional Quantity 5. Attempt Delink Relink Process for New Demands


Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
DSPOPMN_OUINSTANCE	_decimal_10_0	decimal(10)	No	ouinstance	Yes
DSPOPMN_RECEIPT_RES	_varchar_5	varchar(5)	No	set the option for reserving a receipt ONLN -- For Online reservation OFLN -- For Offline reservation	No
DSPOPMN_MODDEMAND_RES	_varchar_5	varchar(5)	No	set the option for reserving a demand ONLN -- For Online reservation OFLN -- For Offline reservation	No
DSPOPMN_PR_GEN	_varchar_5	varchar(5)	No	indicate whether a purchase request must be automatically generated for a problem demand AUT -- PR generation is Automatic MAN -- PR generation is Manual	No
DSPOPMN_FRACQTY_CNV_MTHD	_varchar_5	varchar(5)	No	method of conversion of the fractional quantity RO -- Round Off RU -- Round Up RD -- Round Down	No
DSPOPMN_ONNEWDMND	_varchar_5	varchar(5)	No	indicate whether the "Delink Relink" process must be attempted or not, when new demands come into the system. The "Delink Relink" process takes up all valid demands and receipts, and carries out the process of reservation. Y -- Attempt Delink Re	No
DSPOPMN_CREATED_BY	_varchar_30	varchar(30)	No	The name of the user who created the option settings	No
DSPOPMN_CREATED_DATETIME	_datetime_8	datetime(8)	No	The date on which the option settings was created	No
DSPOPMN_MODIFIED_BY	_varchar_30	varchar(30)	No	The login ID of the user who last modified the option settings.	No
DSPOPMN_MODIFIED_DATETIME	_datetime_8	datetime(8)	No	The date on which the option settings were last modified.	No
DSPOPMN_TIMESTAMP	_decimal_10_0	decimal(10)	No	timestamp	No


Table Name :	STKPLN_DSPPRM_PARAM_DETAIL
Comment :	Parameter Details Information


Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
DSPPRM_COMPONENTNAME	_varchar_80	varchar(80)	No	Component Code	Yes
DSPPRM_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
DSPPRM_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
DSPPRM_PARAMCODE	_varchar_5	varchar(5)	No	Param code is the values to be filled in the combo box or guidance text. This is actually the meta data of this component	Yes
DSPPRM_LANGID	_decimal_10_0	decimal(10)	No	Language id. This is the language id of the record.	Yes
DSPPRM_PARAMDESC	_varchar_80	varchar(80)	No	Description of the Param Code	No
DSPPRM_CREATIONDATE	_datetime_8	datetime(8)	No	Parameters created date	No
DSPPRM_SORT_BY	_decimal_10_0	decimal(10)	Yes	The order in which the values are populated.	No


Table Name :	STKPLN_PG_PEGGINGDETAIL
Comment :	Information about Demands Reserved against the Receipts


Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
PG_OUINSTANCE	_decimal_10_0	decimal(10)	No	ouinstance	Yes
PG_WAREHOUSEOU	_decimal_10_0	decimal(10)	No	Warehouse OU Instance	Yes
PG_WAREHOUSECODE	_varchar_10	varchar(10)	No	warehouse code	Yes
PG_DEMANDDOCTYPE	_varchar_25	Varchar(25)	No	Demand Doc Type	Yes
PG_DEMANDDOCUMENTNO	_varchar_18	varchar(18)	No	Demand Document number	Yes
PG_DEMANDDOCUMENTOU	_decimal_10_0	decimal(10)	No	Demand Document OU	Yes
PG_DEMANDLEVEL1NO	_decimal_10_0	decimal(10)	No	Demand Level 1	Yes
PG_DEMANDLEVEL2NO	_decimal_10_0	decimal(10)	No	Demand Level 2	Yes
PG_DEMANDLEVEL3NO	_decimal_10_0	decimal(10)	No	Demand Level 3	Yes
PG_DEMANDSTATUS	_varchar_5	varchar(5)	No	P for Plan Demand F for Fime Demand	Yes
PG_RESERVATIONNO	_decimal_10_0	decimal(10)	No	Reservation number	Yes
PG_RECEIPTDOCTYPE	_varchar_25	Varchar(25)	No	Receipt Document Type	No
PG_RECEIPTDOCUMENTNO	_varchar_18	varchar(18)	No	Receipt Document Number	No
PG_RECEIPTDOCUMENTOU	_decimal_10_0	decimal(10)	No	Receipt Document OUInstance	No
PG_RECEIPTLEVEL1NO	_decimal_10_0	decimal(10)	No	Receipt Level 1 no	No
PG_RECEIPTLEVEL2NO	_decimal_10_0	decimal(10)	No	Receipt Level 2 no	No
PG_RECEIPTLEVEL3NO	_decimal_10_0	decimal(10)	No	Receipt Level 3 no	No
PG_ITEMCODE	_varchar_40	varchar(40)	No	Item code	Yes
PG_PEGGINGQTY	_decimal_28_8	decimal(28)	No	Reserved Quantity	No
PG_ITEMCRTOU	_decimal_10_0	decimal(10)	No	item created OU	Yes


Table Name :	STKPLN_RPT_RECEIPTDETAIL
Comment :	Information about the available free quantity and the quantity reserved for the Receipts and Physical Stock.


Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
RPT_OUINSTANCE	_decimal_10_0	decimal(10)	No	ouinstance	Yes
RPT_WAREHOUSEOU	_decimal_10_0	decimal(10)	No	Warehouse OU Instance	Yes
RPT_WAREHOUSECODE	_varchar_10	varchar(10)	No	Warehouse code	Yes
RPT_DOCTYPE	_varchar_25	Varchar(25)	No	Document type	Yes
RPT_DOCUMENTNO	_varchar_18	varchar(18)	No	Document Number	Yes
RPT_DOCUMENTOU	_decimal_10_0	decimal(10)	No	Document OU Instance	Yes
RPT_LEVEL1NO	_decimal_10_0	decimal(10)	No	Line Number	Yes
RPT_LEVEL2NO	_decimal_10_0	decimal(10)	No	Sub Line Number	Yes
RPT_LEVEL3NO	_decimal_10_0	decimal(10)	No	Shcedule Number	Yes
RPT_PARTPLNOU	_decimal_10_0	decimal(10)	No	Part Plan OU instance	No
RPT_ITEMCODE	_varchar_40	varchar(40)	No	Part Number	Yes
RPT_ITEMCRTOU	_decimal_10_0	decimal(10)	No	Part Created OUinstance	Yes
RPT_RECEIPTDATE	_datetime_8	datetime(8)	No	receipt date	No
RPT_STATUS	_varchar_5	varchar(5)	No	P for Plan Receipt F for Firm Receipt	No
RPT_CATEGORY	_varchar_25	Varchar(25)	Yes	UR for Unrealized Receipts	No
RPT_QTY	_decimal_28_8	decimal(28)	No	quantity	No
RPT_FIRMFREEQTY	_decimal_28_8	decimal(28)	No	Firm receipt free quantity. i.e Firm Receipt available for reservation	No
RPT_PLANFREEQTY	_decimal_28_8	decimal(28)	No	Plan receipt free quantity. i.e Plan Receipt available for reservation	No
RPT_PLANRESFIRMRCPT	_decimal_28_8	decimal(28)	No	Firm Receipts reserved for Plan Demands	No
RPT_FIRMRESPLANRCPT	_decimal_28_8	decimal(28)	No	Plan Receipts reserved for Firm Demand	No