Stock Planning

Stkpln_Batch_Dmnd_Prcs_Log

Batch_dmnd_wh_ou

numeric(10)

NULL

No

No

Batch_dmnd_wh_code

varchar(10)

Batch_dmnd_part_ou

numeric(10)

Batch_dmnd_part_no

varchar(40)

Batch_dmnd_doc_ou

numeric(10)

Batch_dmnd_doc_no

varchar(18)

Batch_dmnd_doc_type

varchar(25)

Batch_dmnd_level1no

numeric(10)

Batch_dmnd_level2no

Batch_dmnd_level3no

Batch_dmnd_status

varchar(5)

Batch_dmnd_date

datetime

Stkpln_Batch_Process_Log

Batch_rcpt_doc_ou

numeric(10)

NOT NULL

Batch_rcpt_doc_type

varchar(25)

Batch_rcpt_doc_no

varchar(18)

Batch_rcpt_date

datetime

Batch_dmnd_doc_ou

numeric(10)

Batch_dmnd_doc_no

varchar(18)

Batch_dmnd_doc_type

varchar(25)

Batch_dmnd_date

datetime

Stkpln_Batch_Rcpt_Prcs_Log

Batch_rcpt_wh_ou

numeric(10)

NULL

Batch_rcpt_wh_code

varchar(10)

Batch_rcpt_part_ou

numeric(10)

Batch_rcpt_part_no

varchar(40)

Batch_rcpt_doc_ou

numeric(10)

Batch_rcpt_doc_no

varchar(18)

Batch_rcpt_doc_type

varchar(25)

Batch_rcpt_level1no

numeric(10)

Batch_rcpt_level2no

Batch_rcpt_level3no

Batch_rcpt_status

varchar(5)

Batch_rcpt_date

datetime

Stkpln_Dmd_Demanddetail

Information about the Demands raised.

Dmd_ouinstance

numeric(10)

NOT NULL

Yes

Dmd_warehouseou

Dmd_warehousecode

varchar(10)

Dmd_documentou

numeric(10)

Dmd_doctype

varchar(25)

Dmd_documentno

varchar(18)

Dmd_status

varchar(5)

’P’  for Plan Demand ’F’ for Firm Demand

Dmd_level1no

numeric(10)

Line Number.

Dmd_level2no

Subline Number

Dmd_level3no

Schedule Number

Dmd_itemcrtou

Part created Ouinstance

Dmd_itemcode

varchar(40)

Part Number

Dmd_demanddate

datetime

No

Dmd_partplnou

numeric(10)

NULL

Dmd_category

varchar(25)

’IA’  for Inactive Demands ’PD’ for Problem Demands ’UR’ Unrealized Demands

Dmd_qty

numeric(28,8)

NOT NULL

Dmd_problemqty

Demand Quantity unreserved

Stkpln_Dmdtmp_Dmddtl_Tmp

Dmdtmp_guid

varchar(40)

NULL

Dmdtmp_ouinstance

numeric(10)

Dmdtmp_warehouseou

Dmdtmp_warehousecode

varchar(10)

Dmdtmp_doctype

varchar(25)

Dmdtmp_documentno

varchar(18)

Dmdtmp_documentou

numeric(10)

Dmdtmp_level1no

Dmdtmp_level2no

Dmdtmp_level3no

Dmdtmp_itemcode

varchar(40)

Dmdtmp_itemcrtou

numeric(10)

Dmdtmp_partplnou

Dmdtmp_demanddate

datetime

Dmdtmp_status

varchar(5)

Dmdtmp_category

varchar(25)

Dmdtmp_qty

numeric(28,8)

Dmdtmp_Planqty

Dmdtmp_Firmqty

Dmdtmp_problemqty

Dmdtmp_flag

varchar(25)

Stkpln_Dspopdt_Opt_Setting

Information about the Alert Count and Carry over count value for the Demand s and Receipts raised.

DspOpMn_OuInstance

decimal(10)

NOT NULL

ouinstance

Yes

DspOpDt_Comp_Set

varchar(25)

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 Component Work Order 8.Receipt against Line Work Order 9.Receipt against Stock Transfer 10.Receipt against Stock Issue

Dspopdt_alert_cnt

numeric(10)

(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

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)

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

DspOpMn_OuInstance

decimal(10)

ouinstance

Yes

Dspopmn_receipt_res

varchar(5)

set the option for reserving a receipt ’ONLN’  -- For Online reservation ’OFLN’   -- For Offline reservation

No

Dspopmn_moddemand_res

set the option for reserving a demand ’ONLN’  -- For Online reservation ’OFLN’   -- For Offline reservation

Dspopmn_pr_gen

indicate whether a purchase request must be automatically generated for a problem demand ’AUT’ --  PR generation is Automatic ’MAN’ -- PR generation is Manual

Dspopmn_fracqty_cnv_mthd

method of conversion of the fractional quantity ’RO’  --  Round Off ’RU’  --  Round Up ’RD’  --  Round Down

Dspopmn_onnewdmnd

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 Relink Process ’N’  --  Do not Attempt Delink Relink Process

Dspopmn_created_by

varchar(30)

The name of the user who created the option settings

Dspopmn_created_datetime

datetime

The date on which the option settings  was created

Dspopmn_modified_by

varchar(30)

The login ID of the user who last modified the option settings.

Dspopmn_modified_datetime

datetime

The date on which the option settings were last modified.

Dspopmn_timestamp

numeric(10)

timestamp

Stkpln_Dspprm_Param_Detail

Parameter Details Information

DspPrm_ComponentName

varchar(80)

Component Code

Yes

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

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

DspPrm_ParamCode

varchar(5)

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

DspPrm_Langid

decimal(10)

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

Dspprm_paramdesc

varchar(80)

Description of the Param Code

No

Dspprm_creationdate

datetime

Parameters created date

Dspprm_sort_by

numeric(10)

NULL

The order in which the values are populated.

Stkpln_Genval_Tmp

Stkpln_guid

varchar(40)

Stkpln_docou

numeric(10)

Stkpln_doctype

varchar(25)

Stkpln_docno

varchar(18)

Stkpln_lineno

numeric(28,8)

Stkpln_sublineno

Stkpln_scheduleno

Stkpln_trandate

datetime

Stkpln_tranqty

numeric(28,8)

Stkpln_tranuom

varchar(10)

Stkpln_partno

varchar(40)

Stkpln_transtatus

varchar(15)

Stkpln_whcode

varchar(10)

Stkpln_whou

numeric(10)

Stkpln_reshorizon

numeric

Stkpln_stdcost

Stkpln_stdvendor

varchar(45)

Stkpln_purordrlocn

numeric

Stkpln_shcdltype

varchar(25)

Stkpln_partou

numeric(28)

Stkpln_planou

Stkpln_procs_flg

varchar(5)

Stkpln_Pg_PeggingDetail

Information about Demands Reserved against the Receipts

Pg_ouinstance

numeric(10)

NOT NULL

Yes

Yes

Pg_warehouseou

Pg_warehousecode

varchar(10)

Pg_demanddocumentou

numeric(10)

No

Pg_itemcrtou

Yes

Pg_itemcode

varchar(40)

Pg_demanddoctype

varchar(25)

No

Pg_demanddocumentno

varchar(18)

Pg_demandstatus

varchar(5)

’P’ for Plan Demand ’F’ for Fime Demand

Pg_demandlevel1no

numeric(10)

Pg_demandlevel2no

Pg_demandlevel3no

Pg_reservationno

Pg_receiptdoctype

varchar(25)

No

Yes

Pg_receiptdocumentno

varchar(18)

Pg_receiptdocumentou

numeric(10)

Pg_receiptlevel1no

Pg_receiptlevel2no

Pg_receiptlevel3no

Pg_peggingqty

numeric(28,8)

Reserved Quantity

No

Stkpln_Pgtmp_Peginfo_Tmp

Pgtmp_guid

varchar(40)

NULL

Pgtmp_ouinstance

numeric(10)

Pgtmp_warehouseou

Pgtmp_warehousecode

varchar(10)

Pgtmp_demanddoctype

varchar(25)

Pgtmp_demanddocumentno

varchar(18)

Pgtmp_demanddocumentou

numeric(10)

Pgtmp_demandlevel1no

Pgtmp_demandlevel2no

Pgtmp_demandlevel3no

Pgtmp_demandstatus

varchar(5)

Pgtmp_reservationno

numeric(10)

Pgtmp_receiptdoctype

varchar(25)

Pgtmp_receiptdocumentno

varchar(18)

Pgtmp_receiptdocumentou

numeric(10)

Pgtmp_receiptlevel1no

Pgtmp_receiptlevel2no

Pgtmp_receiptlevel3no

Pgtmp_itemcode

varchar(40)

Pgtmp_peggingqty

numeric(28,8)

Pgtmp_itemcrtou

numeric(10)

Stkpln_Rctmp_Rcpt_Conv_Tmp

Rctmp_guid

varchar(40)

Rctmp_pln_doc_ou

numeric(10)

Rctmp_pln_doc_type

varchar(25)

Rctmp_pln_doc_no

varchar(18)

Rctmp_pln_line_no

numeric(10)

Rctmp_pln_subline_no

Rctmp_pln_schedule_no

Rctmp_pln_warehouse_ou

Rctmp_pln_warehouse_id

varchar(10)

Rctmp_pln_receipt_date

datetime

Rctmp_pln_rcpt_status

varchar(5)

Rctmp_pln_tran_uom

varchar(10)

Rctmp_pln_tran_qty

numeric(28,8)

Rctmp_firm_doc_ou

numeric(10)

Rctmp_firm_doc_type

varchar(25)

Rctmp_firm_doc_no

varchar(18)

Rctmp_firm_line_no

numeric(10)

Rctmp_firm_subline_no

Rctmp_firm_schedule_no

Rctmp_firm_warehouse_ou

Rctmp_firm_warehouse_id

varchar(10)

Rctmp_firm_receipt_date

datetime

Rctmp_firm_rcpt_status

varchar(5)

Rctmp_firm_tran_uom

varchar(10)

Rctmp_firm_tran_qty

numeric(28,8)

Rctmp_part_crt_ou

numeric(10)

Rctmp_part_pln_ou

Rctmp_part_no

varchar(40)

Rctmp_process_flag

varchar(5)

Stkpln_Rpt_ReceiptDetail

Information about the available free quantity and the quantity reserved for the Receipts and Physical Stock.

Rpt_ouinstance

numeric(10)

NOT NULL

Yes

Rpt_warehouseou

Rpt_warehousecode

varchar(10)

Rpt_documentou

numeric(10)

Rpt_doctype

varchar(25)

Rpt_documentno

varchar(18)

Rpt_level1no

numeric(10)

Line Number

Rpt_level2no

Sub Line Number

Rpt_level3no

Schedule Number

Rpt_itemcrtou

Part Created OUinstance

Rpt_itemcode

varchar(40)

Part Number

Rpt_partplnou

numeric(10)

No

Rpt_receiptdate

datetime

Rpt_status

varchar(5)

’P’ for Plan Receipt ’F’ for Firm Receipt

Rpt_category

varchar(25)

NULL

’UR’  for Unrealized Receipts

Rpt_qty

numeric(28,8)

NOT NULL

Rpt_firmfreeqty

Firm receipt free quantity. i.e Firm Receipt available for reservation

Rpt_planfreeqty

Plan receipt free quantity. i.e Plan Receipt available for reservation

Rpt_planresfirmrcpt

Firm Receipts reserved for Plan Demands

Rpt_firmresplanrcpt

Plan Receipts reserved for Firm Demand

Stkpln_Rpttmp_Rcptdtl_Tmp

Rpttmp_guid

varchar(40)

NULL

Rpttmp_ouinstance

numeric(10)

Rpttmp_warehouseou

Rpttmp_warehousecode

varchar(10)

Rpttmp_doctype

varchar(25)

Rpttmp_documentno

varchar(18)

Rpttmp_documentou

numeric(10)

Rpttmp_level1no

Rpttmp_level2no

Rpttmp_level3no

Rpttmp_itemcode

varchar(40)

Rpttmp_itemcrtou

numeric(10)

Rpttmp_partplnou

Rpttmp_receiptdate

datetime

Rpttmp_status

varchar(5)

Rpttmp_category

varchar(25)

Rpttmp_qty

numeric(28,8)

Rpttmp_Planqty

Rpttmp_Firmqty

Rpttmp_firmfreeqty

Rpttmp_planfreeqty

Rpttmp_planresfirmrcpt

Rpttmp_firmresplanrcpt

Stkpln_Stkpr_Autogen_Tmp

Stkpr_guid

varchar(40)

STKPR_PR_OU

decimal(10)

Stkpr_docou

numeric(10)

Stkpr_doctype

varchar(25)

Stkpr_docno

varchar(40)

Stkpr_need_date

datetime

Stkpr_warehouse

varchar(40)

Stkpr_warehouse_ou

numeric(10)

Stkpr_partcrt_ou

Stkpr_partpln_ou

Stkpr_part_no

varchar(40)

Stkpr_line_no

numeric(10)

Stkpr_subline_no

Stkpr_schedule_no

Stkpr_reqd_qty

numeric(28,8)

Stkpr_part_std_cost

Stkpr_reqd_uom

varchar(10)

Stkpr_pur_ordering_ou

numeric(10)

Stkpr_supplier_ou

Stkpr_supplier_code

varchar(45)

Stkpr_pur_price

numeric(28,8)

Stkpr_goodsrcpt_ou

numeric(10)

Stkpr_schedule_type

varchar(25)

Stkpr_prtype

varchar(5)