Production Table List

By ukmodak | April 1st 2024 12:11:14 PM | viewed 174 times
Sl Table Name: Query example record
1-26 Setup Table(From Setup Module) ----
1-38 Sample Module Table(From Sample Module) ---- get table by schema or api
1-48 Order Module Table(From Order Module) ---- get table by schema or api
1 prod_opunit
create table prod_opunit(
id number(20) not null,
stn_hrm_company_id number(20) not null,
stn_item_group_id number(20) not null,
stn_item_unit_id number(20) not null, 
operating_unit_name varchar2(50) not null,
alias varchar2(50) not null,
code varchar2(50) not null,
description varchar2(150) not null,   
CONSTRAINT stn_hrm_company_fk FOREIGH KEY(stn_hrm_company_id) REFERENCES stn_hrm_company,
CONSTRAINT stn_item_group_fk FOREIGH KEY(stn_item_group_id) REFERENCES stn_item_group,
CONSTRAINT stn_item_unit_fk FOREIGH KEY(stn_item_unit_id) REFERENCES stn_item_unit_id,
CONSTRAINT prod_opunit_pk PRIMARY KEY(id)
)

2 prod_opunit_incharge
create table prod_opunit_incharge(
id number(20) not null,
prod_opunit_id number(20) not null,
auth_user_id number(20) not null,   
CONSTRAINT operating_unit_id_fk FOREIGH KEY(operating_unit_id) REFERENCES prod_opunit,
CONSTRAINT auth_user_id_fk FOREIGH KEY(auth_user_id) REFERENCES auth_user,
CONSTRAINT prod_opunit_incharge_pk PRIMARY KEY(id)
)

3 prod_tools
create table prod_tools(
id number(20) not null,
stn_hrm_company_id number(20) not null,
prod_opunit_id number(20) not null,
tools_type_lookup_dtl_id  number(20) not null, -- machine,computer,iron,manpower...
tools_name varchar2(50) not null, 
tools_no_code varchar2(50) not null, 
tools_specific varchar2(150) default null, 
prod_capacity_per_hr number(5) not null, 
stn_munit_id number(20) not null,  
 
CONSTRAINT stn_hrm_company_id_fk FOREIGH KEY(stn_hrm_company_id) REFERENCES stn_hrm_company,
CONSTRAINT prod_opunit_fk FOREIGH KEY(prod_opunit_id) REFERENCES prod_opunit,
CONSTRAINT stn_munit_id_fk FOREIGH KEY(stn_munit_id) REFERENCES stn_munit,
CONSTRAINT tools_type_lookup_dtl_fk FOREIGH KEY(tools_type_lookup_dtl_id) REFERENCES lookup_dtl,
CONSTRAINT prod_tools_pk PRIMARY KEY(id)
)

4 prod_tools_user
create table prod_tools_user(
id number(20) not null,
prod_tools_id number(20) not null,
auth_user_id number(20) not null,    
CONSTRAINT prod_tools_fk FOREIGH KEY(prod_tools_id) REFERENCES prod_tools,
CONSTRAINT auth_user_id_fk FOREIGH KEY(auth_user_id) REFERENCES auth_user,
CONSTRAINT prod_tools_user_pk PRIMARY KEY(id)
)

5 prod_item_rcp_setup_mst(rcp = recipe)
create table prod_item_rcp_setup_mst(
id number(20) not null,
recipe_name varchar2(70) not null,
detail_info varchar2(200) default null,
stn_hrm_company_id number(20) not null,
stn_item_group_id number(20) not null, 
smp_item_setup_id number(20) not null,  --[from sample table]


CONSTRAINT stn_hrm_company_fk1 FOREIGH KEY(stn_hrm_company_id) REFERENCES stn_hrm_company,
CONSTRAINT stn_item_group_fk1 FOREIGH KEY(stn_item_group_id) REFERENCES stn_item_group,
CONSTRAINT smp_item_setup_fk1 FOREIGH KEY(smp_item_setup_id) REFERENCES smp_item_setup,

CONSTRAINT prod_item_rcp_setup_mst_pk PRIMARY KEY(id)
)

6 prod_item_rcp_setup_attr
create table prod_item_rcp_setup_attr(
id number(20) not null,
prod_item_rcp_setup_mst_id number(20) not null,
smp_sample_attribute_type_id number(20) not null,
smp_sample_attribute_val_id number(20) not null,

leign varchar2(50) not null,
color_id number(20) not null,
blank_thickness number(4,2) not null,
blank_thickness_stn_munit_id number(20) not null,
finish_thickness number(4,2) not null,
finish_thickness_stn_munit_id number(20) not null,
sheet_rod varchar2(50) not null,
req_qty number(4,2) not null,
stn_munit_id number(20) not null,
moq_qty number(4,2) not null,
total_rm number(4,2) not null,
total_rm_stn_munit_cnvt_dtl_id number(4,2) not null,
total_percent number(4,2) not null,


CONSTRAINT prod_item_rcp_setup_mst_fk1 FOREIGH KEY(prod_item_rcp_setup_mst_id) REFERENCES prod_item_rcp_setup_mst,
CONSTRAINT smp_sample_attribute_type_fk1 FOREIGH KEY(smp_sample_attribute_type_id) REFERENCES smp_sample_attribute_type,
CONSTRAINT smp_sample_attribute_val_fk1 FOREIGH KEY(smp_sample_attribute_val_id) REFERENCES smp_sample_attribute_val,

CONSTRAINT stn_color_fk1 FOREIGH KEY(stn_color_id) REFERENCES stn_color,
CONSTRAINT stn_munit_fk1 FOREIGH KEY(stn_munit_id) REFERENCES stn_munit,
CONSTRAINT blank_thickness_stn_munit_fk1 FOREIGH KEY(blank_thickness_stn_munit_id) REFERENCES stn_munit,
CONSTRAINT finish_thickness_stn_munit_fk1 FOREIGH KEY(finish_thickness_stn_munit_id) REFERENCES stn_munit,
CONSTRAINT total_rm_stn_munit_cnvtdtl_fk1 FOREIGH KEY(total_rm_stn_munit_cnvt_dtl_id) REFERENCES stn_munit_converter_dtl,

CONSTRAINT prod_item_rcp_setup_attr_pk PRIMARY KEY(id)
)

setup formula on this table(13,14) to generate BOM for rm collection
7 prod_item_rcp_setup_rm
create table prod_item_rcp_setup_rm(
id number(20) not null,
prod_item_rcp_setup_mst_id number(20) not null,
prod_item_rcp_setup_attr_id number(20) not null,
stn_item_group_id number(20) not null, 
smp_item_setup_id number(20) not null,   --[from sample module]

stn_munit_id number(20) not null,
percent number(4,2) not null,
qty number(4,2) not null,
stn_munit_cnvt_dtl_id number(4,2) not null,

CONSTRAINT prod_item_rcp_setup_mst_fk1 FOREIGH KEY(prod_item_rcp_setup_mst_id) REFERENCES prod_item_rcp_setup_mst,
CONSTRAINT prod_item_rcp_setup_attr_fk1 FOREIGH KEY(prod_item_rcp_setup_attr_id) REFERENCES prod_item_rcp_setup_attr,
CONSTRAINT stn_item_group_fk1 FOREIGH KEY(stn_item_group_id) REFERENCES stn_item_group,
CONSTRAINT smp_item_setup_fk1 FOREIGH KEY(smp_item_setup_id) REFERENCES smp_item_setup,
CONSTRAINT stn_munit_fk1 FOREIGH KEY(stn_munit_id) REFERENCES stn_munit,
CONSTRAINT stn_munit_cnvt_dtl_fk1 FOREIGH KEY(stn_munit_cnvt_dtl_id) REFERENCES stn_munit_cnvt_dtl,
CONSTRAINT prod_item_rcp_setup_rm_pk PRIMARY KEY(id)
)

8 prod_prdtn_process_mst
create table prod_prdtn_process_mst(
id number(20) not null,
production_name varchar2(50) not null,
stn_item_group_id number(20) not null, 
smp_item_setup_id number(20) not null,
stn_hrm_company_id number(20) not null,
smp_sample_id number(20) default null,
ord_order_id number(20) default null,
 
CONSTRAINT stn_item_group_fk FOREIGH KEY(stn_item_group_id) REFERENCES stn_item_group,
CONSTRAINT smp_item_setup_fk FOREIGH KEY(smp_item_setup_id) REFERENCES smp_item_setup,
CONSTRAINT stn_hrm_company_fk FOREIGH KEY(stn_hrm_company_id) REFERENCES stn_hrm_company,
CONSTRAINT smp_sample_fk FOREIGH KEY(smp_sample_id) REFERENCES smp_sample,
CONSTRAINT ord_order_fk FOREIGH KEY(ord_order_id) REFERENCES ord_order,

CONSTRAINT prod_prdtn_process_mst_pk PRIMARY KEY(id)
)

9 prod_prdtn_process_dtl
create table prod_prdtn_process_dtl(
id number(20) not null,
prod_prdtn_process_mst_id number(20) not null,
unit_sts_lookup_dtl_id number(20) not null,
current_prod_opunit_id number(20) not null, 
next_prod_opunit_id number(20) not null,
step_no number(4) not null,
is_active number(1) not null,
work_sts_lookup_dtl_id number(20) not null,  -- work in progress,done
inspect_sts_lookup_dtl_id  number(20) default null,  -- inspected,reinspect,rejected
  
CONSTRAINT prod_prdtn_process_mst_fk FOREIGH KEY(prod_prdtn_process_mst_id) REFERENCES prod_prdtn_process_mst,
CONSTRAINT unit_sts_lookup_dtl_fk FOREIGH KEY(unit_sts_lookup_dtl_id) REFERENCES unit_sts_lookup_dtl,
CONSTRAINT current_prod_opunit_fk FOREIGH KEY(current_prod_opunit_id) REFERENCES current_prod_opunit,
CONSTRAINT next_prod_opunit_fk FOREIGH KEY(next_prod_opunit_id) REFERENCES next_prod_opunit,
CONSTRAINT prod_prdtn_process_dtl_pk PRIMARY KEY(id)
)

10 prod_rcp_brkdown_batch(rcp=recipe)
create table prod_rcp_brkdown_batch(
id number(20) not null,
prod_prdtn_process_dtl_id
smp_sample_breakdown_id default null,
ord_order_breakdown_id default null,

CONSTRAINT prod_prdtn_process_dtl_fk FOREIGH KEY(prod_prdtn_process_dtl_id) REFERENCES prod_prdtn_process_dtl,
CONSTRAINT smp_sample_breakdown_fk FOREIGH KEY(smp_sample_breakdown_id) REFERENCES smp_sample_breakdown,
CONSTRAINT ord_order_breakdown_fk FOREIGH KEY(ord_order_breakdown_id) REFERENCES ord_order_breakdown,
CONSTRAINT prod_rcp_brkdown_batch_pk PRIMARY KEY(id)
)
11 prod_rcp_brkdown_batch_attr
create table prod_item_rcp_setup_attr(
id number(20) not null,
prod_item_rcp_setup_mst_id number(20) not null,
smp_sample_attribute_type_id number(20) not null,
smp_sample_attribute_val_id number(20) not null,

leign varchar2(50) not null,
color_id number(20) not null,
blank_thickness number(4,2) not null,
blank_thickness_stn_munit_id number(20) not null,
finish_thickness number(4,2) not null,
finish_thickness_stn_munit_id number(20) not null,
sheet_rod varchar2(50) not null,
req_qty number(4,2) not null,
stn_munit_id number(20) not null,
moq_qty number(4,2) not null,
total_rm number(4,2) not null,
total_rm_stn_munit_cnvt_dtl_id number(4,2) not null,
total_percent number(4,2) not null,


CONSTRAINT prod_item_rcp_setup_mst_fk1 FOREIGH KEY(prod_item_rcp_setup_mst_id) REFERENCES prod_item_rcp_setup_mst,
CONSTRAINT smp_sample_attribute_type_fk1 FOREIGH KEY(smp_sample_attribute_type_id) REFERENCES smp_sample_attribute_type,
CONSTRAINT smp_sample_attribute_val_fk1 FOREIGH KEY(smp_sample_attribute_val_id) REFERENCES smp_sample_attribute_val,

CONSTRAINT stn_color_fk1 FOREIGH KEY(stn_color_id) REFERENCES stn_color,
CONSTRAINT stn_munit_fk1 FOREIGH KEY(stn_munit_id) REFERENCES stn_munit,
CONSTRAINT blank_thickness_stn_munit_fk1 FOREIGH KEY(blank_thickness_stn_munit_id) REFERENCES stn_munit,
CONSTRAINT finish_thickness_stn_munit_fk1 FOREIGH KEY(finish_thickness_stn_munit_id) REFERENCES stn_munit,
CONSTRAINT total_rm_stn_munit_cnvtdtl_fk1 FOREIGH KEY(total_rm_stn_munit_cnvt_dtl_id) REFERENCES stn_munit_converter_dtl,

CONSTRAINT prod_rcp_brkdown_batch_attr_pk PRIMARY KEY(id)
)

setup formula on this table(13,14) to generate BOM for rm collection
12 prod_rcp_brkdown_batch_rm
create table prod_rcp_brkdown_batch_rm(
id number(20) not null,
prod_rcp_brkdown_batch_id number(20) not null,


prod_item_rcp_setup_mst_id number(20) not null,       --[ from prod_item_rcp_setup_mst]
prod_rcp_brkdown_batch_attr_id number(20) not null,   --[ update tale of prod_item_rcp_setup_attr]
stn_item_group_id number(20) not null, 
smp_item_setup_id number(20) not null,                --[from sample module]

stn_munit_id number(20) not null,
percent number(4,2) not null,
qty number(4,2) not null,
stn_munit_cnvt_dtl_id number(4,2) not null,

cur_prod_opunit_id number(20) not null,
next_prod_opunit_id number(20) default null,
sumit_date datetime default null,
is_lock numer(2) not null,


CONSTRAINT ord_order_breakdown_fk FOREIGH KEY(ord_order_breakdown_id) REFERENCES ord_order_breakdown,
CONSTRAINT prod_item_rcp_setup_mst_fk1 FOREIGH KEY(prod_item_rcp_setup_mst_id) REFERENCES prod_item_rcp_setup_mst,
CONSTRAINT prod_item_rcp_setup_attr_fk1 FOREIGH KEY(prod_item_rcp_setup_attr_id) REFERENCES prod_item_rcp_setup_attr,
CONSTRAINT stn_item_group_fk1 FOREIGH KEY(stn_item_group_id) REFERENCES stn_item_group,
CONSTRAINT smp_item_setup_fk1 FOREIGH KEY(smp_item_setup_id) REFERENCES smp_item_setup,
CONSTRAINT stn_munit_fk1 FOREIGH KEY(stn_munit_id) REFERENCES stn_munit,
CONSTRAINT stn_munit_cnvt_dtl_fk1 FOREIGH KEY(stn_munit_cnvt_dtl_id) REFERENCES stn_munit_cnvt_dtl,

CONSTRAINT cur_prod_opunit_fk1 FOREIGH KEY(cur_prod_opunit_id) REFERENCES prod_opunit,
CONSTRAINT next_prod_opunit_fk1 FOREIGH KEY(next_prod_opunit_id) REFERENCES prod_opunit,

CONSTRAINT prod_rcp_brkdown_batch_rm_pk PRIMARY KEY(id)
)
13 prod_rqsn_brkdown_batch_rm(rqsn = requisition)
create table prod_rqsn_brkdown_batch_rm(
id number(20) not null,
prod_rcp_brkdown_batch_id number(20) not null,


prod_item_rcp_setup_mst_id number(20) not null,       --[ from prod_item_rcp_setup_mst]
prod_rcp_brkdown_batch_attr_id number(20) not null,   --[ update tale of prod_item_rcp_setup_attr]
stn_item_group_id number(20) not null, 
smp_item_setup_id number(20) not null,                --[from sample module]

stn_munit_id number(20) not null,
percent number(4,2) not null,
qty number(4,2) not null,
stn_munit_cnvt_dtl_id number(4,2) not null,
inv_warehouse_id number(20) default null,
inv_store_id number(20) default null,

cur_prod_opunit_id number(20) not null,
next_prod_opunit_id number(20) default null,
sumit_date datetime default null,
is_lock numer(2) not null,


CONSTRAINT ord_order_breakdown_fk FOREIGH KEY(ord_order_breakdown_id) REFERENCES ord_order_breakdown,
CONSTRAINT prod_item_rcp_setup_mst_fk1 FOREIGH KEY(prod_item_rcp_setup_mst_id) REFERENCES prod_item_rcp_setup_mst,
CONSTRAINT prod_item_rcp_setup_attr_fk1 FOREIGH KEY(prod_item_rcp_setup_attr_id) REFERENCES prod_item_rcp_setup_attr,
CONSTRAINT stn_item_group_fk1 FOREIGH KEY(stn_item_group_id) REFERENCES stn_item_group,
CONSTRAINT smp_item_setup_fk1 FOREIGH KEY(smp_item_setup_id) REFERENCES smp_item_setup,
CONSTRAINT stn_munit_fk1 FOREIGH KEY(stn_munit_id) REFERENCES stn_munit,
CONSTRAINT stn_munit_cnvt_dtl_fk1 FOREIGH KEY(stn_munit_cnvt_dtl_id) REFERENCES stn_munit_cnvt_dtl,

CONSTRAINT inv_warehouse_fk1 FOREIGH KEY(inv_warehouse_id) REFERENCES inv_warehouse,
CONSTRAINT inv_store_fk1 FOREIGH KEY(inv_store_id) REFERENCES inv_store,

CONSTRAINT cur_prod_opunit_fk1 FOREIGH KEY(cur_prod_opunit_id) REFERENCES prod_opunit,
CONSTRAINT next_prod_opunit_fk1 FOREIGH KEY(next_prod_opunit_id) REFERENCES prod_opunit,

CONSTRAINT prod_rqsn_brkdown_batch_rm_pk PRIMARY KEY(id)
)
14 prod_recv_brkdown_batch_rm(recv = receive)
create table prod_recv_brkdown_batch_rm(
id number(20) not null,
prod_rcp_brkdown_batch_id number(20) not null,


prod_item_rcp_setup_mst_id number(20) not null,       --[ from prod_item_rcp_setup_mst]
prod_rcp_brkdown_batch_attr_id number(20) not null,   --[ update tale of prod_item_rcp_setup_attr]
stn_item_group_id number(20) not null, 
smp_item_setup_id number(20) not null,                --[from sample module]

stn_munit_id number(20) not null,
percent number(4,2) not null,
qty number(4,2) not null,
stn_munit_cnvt_dtl_id number(4,2) not null,
inv_warehouse_id number(20) default null,
inv_store_id number(20) default null,


cur_prod_opunit_id number(20) not null,
next_prod_opunit_id number(20) default null,
sumit_date datetime default null,
is_lock numer(2) not null,


CONSTRAINT ord_order_breakdown_fk FOREIGH KEY(ord_order_breakdown_id) REFERENCES ord_order_breakdown,
CONSTRAINT prod_item_rcp_setup_mst_fk1 FOREIGH KEY(prod_item_rcp_setup_mst_id) REFERENCES prod_item_rcp_setup_mst,
CONSTRAINT prod_item_rcp_setup_attr_fk1 FOREIGH KEY(prod_item_rcp_setup_attr_id) REFERENCES prod_item_rcp_setup_attr,
CONSTRAINT stn_item_group_fk1 FOREIGH KEY(stn_item_group_id) REFERENCES stn_item_group,
CONSTRAINT smp_item_setup_fk1 FOREIGH KEY(smp_item_setup_id) REFERENCES smp_item_setup,
CONSTRAINT stn_munit_fk1 FOREIGH KEY(stn_munit_id) REFERENCES stn_munit,
CONSTRAINT stn_munit_cnvt_dtl_fk1 FOREIGH KEY(stn_munit_cnvt_dtl_id) REFERENCES stn_munit_cnvt_dtl,

CONSTRAINT inv_warehouse_fk1 FOREIGH KEY(inv_warehouse_id) REFERENCES inv_warehouse,
CONSTRAINT inv_store_fk1 FOREIGH KEY(inv_store_id) REFERENCES inv_store,

CONSTRAINT cur_prod_opunit_fk1 FOREIGH KEY(cur_prod_opunit_id) REFERENCES prod_opunit,
CONSTRAINT next_prod_opunit_fk1 FOREIGH KEY(next_prod_opunit_id) REFERENCES prod_opunit,

CONSTRAINT prod_recv_brkdown_batch_rm_pk PRIMARY KEY(id)
)
15 prod_process_tools
create table prod_process_tools(
id number(20) not null,
prod_prdtn_process_dtl_id
prod_unit_id number(20) not null,
prod_tools_id number(20) not null,

cur_prod_opunit_id number(20) not null,
 
CONSTRAINT prod_prdtn_process_dtl_fk FOREIGH KEY(prod_prdtn_process_dtl_id) REFERENCES prod_prdtn_process_dtl,
CONSTRAINT prod_unit_fk FOREIGH KEY(prod_unit_id) REFERENCES prod_unit,
CONSTRAINT prod_tools_fk FOREIGH KEY(prod_tools_id) REFERENCES prod_tools,
CONSTRAINT cur_prod_opunit_fk1 FOREIGH KEY(cur_prod_opunit_id) REFERENCES prod_opunit,
CONSTRAINT prod_process_tools_pk PRIMARY KEY(id)
)

16 prod_process_tools_time
create table prod_process_tools_output(
id number(20) not null,
prod_process_tools_id number(20) not null,
start_time datetime default null,
end_time datetime default null,

cur_prod_opunit_id number(20) not null,

CONSTRAINT prod_process_tools_fk FOREIGH KEY(prod_process_tools_id) REFERENCES prod_process_tools,
CONSTRAINT cur_prod_opunit_fk1 FOREIGH KEY(cur_prod_opunit_id) REFERENCES prod_opunit,
CONSTRAINT prod_process_tools_output_pk PRIMARY KEY(id)
)

17 prod_process_tools_output
create table prod_process_tools_output(
id number(20) not null,
prod_process_tools_id number(20) not null,
date_time datetime not null,
output_name varchar2(50) not null,
output_qty number(4,2) not null,
wast_qty number(4,2) not null,

cur_prod_opunit_id number(20) not null,
next_prod_opunit_id number(20) default null,
sumit_date datetime default null,
is_lock numer(2) not null,
 
CONSTRAINT prod_process_tools_fk FOREIGH KEY(prod_process_tools_id) REFERENCES prod_process_tools,
CONSTRAINT cur_prod_opunit_fk1 FOREIGH KEY(cur_prod_opunit_id) REFERENCES prod_opunit,
CONSTRAINT next_prod_opunit_fk1 FOREIGH KEY(next_prod_opunit_id) REFERENCES prod_opunit,
CONSTRAINT prod_process_tools_output_pk PRIMARY KEY(id)
)

multiple record insert allowed
18 prod_process_asn_timeline
create table prod_process_asn_timeline(
id number(20) not null,
prod_prdtn_process_dtl_id number(20) not null,
prod_unit_id number(20) not null,

start_time datetime default null,
end_time datetime default null,
extend_time datetime default null,
actual_finish_time datetime default null,

cur_prod_opunit_id number(20) not null,

CONSTRAINT prod_prdtn_process_dtl_fk FOREIGH KEY(prod_prdtn_process_dtl_id) REFERENCES prod_prdtn_process_dtl,
CONSTRAINT prod_unit_fk FOREIGH KEY(prod_unit_id) REFERENCES prod_unit,
CONSTRAINT cur_prod_opunit_fk1 FOREIGH KEY(cur_prod_opunit_id) REFERENCES prod_opunit,
CONSTRAINT prod_process_asn_timeline_pk PRIMARY KEY(id)
)

19 prod_process_asn_comment
create table prod_process_asn_timeline(
id number(20) not null,
prod_prdtn_process_dtl_id number(20) not null,
prod_unit_id number(20) not null,
comment varchar2(50) default null,
cur_prod_opunit_id number(20) not null,

CONSTRAINT prod_prdtn_process_dtl_fk FOREIGH KEY(prod_prdtn_process_dtl_id) REFERENCES prod_prdtn_process_dtl,
CONSTRAINT prod_unit_fk FOREIGH KEY(prod_unit_id) REFERENCES prod_unit,
CONSTRAINT cur_prod_opunit_fk1 FOREIGH KEY(cur_prod_opunit_id) REFERENCES prod_opunit,
CONSTRAINT prod_process_asn_comment_pk PRIMARY KEY(id)
)

20 prod_delivery_challan
create table prod_delivery_challan(
id number(20) not null,
prod_prdtn_process_mst_id number(20) not null,

delivery_man varchar2(50) default null,
driver varchar2(50) default null,
vehicle_no varchar2(50) default null,
delivery_note_date date default null,
delivery_note_type varchar2(50) default null,
delivery_note_received varchar2(50) default null,
bill_challan_no varchar2(50) default null,
bill_challan_date date default null,
is_bill_prepared number(2) not null,
remarks varchar2(100) default null,

inv_warehouse_id number(20) default null,
inv_store_id number(20) default null,

is_received number(2) default null,
received_date date default null,
received_by varchar2(50) default null,

CONSTRAINT prod_prdtn_process_mst_fk1 FOREIGH KEY(prod_prdtn_process_mst_id) REFERENCES prod_prdtn_process_mst,
CONSTRAINT prod_delivery_challan_pk PRIMARY KEY(id)
)

21 prod_challan_batch
create table prod_challan_batch(
id number(20) not null,
prod_delivery_challan_id number(20) not null,
smp_sample_breakdown_id default null,
ord_order_breakdown_id default null,

CONSTRAINT prod_delivery_challan_fk1 FOREIGH KEY(prod_delivery_challan_id) REFERENCES prod_delivery_challan,
CONSTRAINT smp_sample_breakdown_fk1 FOREIGH KEY(smp_sample_breakdown_id) REFERENCES smp_sample_breakdown,
CONSTRAINT ord_order_breakdown_fk1 FOREIGH KEY(ord_order_breakdown_id) REFERENCES ord_order_breakdown,
CONSTRAINT prod_challan_batch_pk PRIMARY KEY(id)
)

bONEandALL
Visitor

Total : 20166

Today :13

Today Visit Country :

  • China
  • United States
  • United Kingdom
  • Portugal
  • Canada