erp

Order Table List

By ukmodak | April 1st 2024 12:11:14 PM | viewed 339 times





create table ord_po(
id number(20) not null,
code varchar2(50) not null,
stn_hrm_company_id number(20) not null,
pi_cat_lookup_dtl_id number(20) not null, -- import,export
po_no varchar2(50) default null,
invoice_no varchar2(20) not null,
po_date_issue_date date not null, 
delivery_date date not null,
due_date date not null,
po_file_name varchar2(20) default null,

is_lock number(1) not null,

create_date date default null,
update_date date default null,
create_by number(20) not null,
update_by number(20) not null,


CONSTRAINT stn_hrm_company_fk_81 FOREIGN KEY(stn_hrm_company_id) REFERENCES stn_hrm_company,
CONSTRAINT stn_lookup_dtl_fk_81 FOREIGN KEY(pi_cat_lookup_dtl_id) REFERENCES stn_lookup_dtl,
CONSTRAINT ord_po_pk PRIMARY KEY(id)
)
 


create table ord_po_buyer(
id number(20) not null,
ord_po_id number(20) not null, 
stn_party_id number(20) not null,

isu_stn_party_bank_dtl_id number(20) not null,

negotiating_lion_bank varchar2(50) default null,
negotiating_lion_bank_branch varchar2(50) default null,
stn_party_con_prsn_id number(20) not null,
buy_stn_party_customer_id number(20) not null,

create_date date default null,
update_date date default null,
create_by number(20) not null,
update_by number(20) not null,


CONSTRAINT ord_po_id_fk_82 FOREIGN KEY(ord_po_id) REFERENCES ord_po,
CONSTRAINT stn_party_fk_82 FOREIGN KEY(stn_party_id) REFERENCES stn_party,
CONSTRAINT stn_party_bank_dtl_fk_82 FOREIGN KEY(isu_stn_party_bank_dtl_id) REFERENCES stn_party_bank_dtl,
CONSTRAINT stn_party_con_prsn_fk_82 FOREIGN KEY(stn_party_con_prsn_id) REFERENCES stn_party_con_prsn,
CONSTRAINT stn_party_customer_id_fk_82 FOREIGN KEY(buy_stn_party_customer_id) REFERENCES stn_party_customer,
CONSTRAINT ord_po_buyer_pk PRIMARY KEY(id)
)
 


create table ord_po_seller(
id number(20) not null,
ord_po_id number(20) not null,

stn_party_id number(20) not null,
adv_stn_party_bank_dtl_id number(20) not null,

forwading_bank varchar2(50) default null,
orwading_bank_branch varchar2(50) default null,
noty_stn_party_customer_id number(20) not null,


create_date date default null,
update_date date default null,
create_by number(20) not null,
update_by number(20) not null,


CONSTRAINT ord_po_fk_83 FOREIGN KEY(ord_po_id) REFERENCES ord_po,
CONSTRAINT stn_party_fk_83 FOREIGN KEY(stn_party_id) REFERENCES stn_party,
CONSTRAINT stn_party_bank_dtl_fk_83 FOREIGN KEY(adv_stn_party_bank_dtl_id) REFERENCES stn_party_bank_dtl,
CONSTRAINT stn_party_customer_fk_83 FOREIGN KEY(noty_stn_party_customer_id) REFERENCES stn_party_customer,
CONSTRAINT ord_po_seller_pk PRIMARY KEY(id)
)
 


create table ord_po_shipment(
id number(20) not null,
ord_po_id number(20) not null,

partial_shipment int(1) not null, -- 0/1
transhipment int(1) not null, -- 0/1
ty_of_ship_stn_lookup_dtl_id number(20) not null,
del_term_stn_lookup_dtl_id number(20) not null,
 
port_of_loading varchar2(20) not null,
port_of_dischare varchar2(20) not null,

place_of_receipt varchar2(20) not null,
place_of_distination varchar2(20) not null,

ten_dl_term_stn_lookup_dtl_id number(20) not null,

CONSTRAINT ord_po_fk_85 FOREIGN KEY(ord_po_id) REFERENCES ord_po,
CONSTRAINT stn_lookup_dtl_id_fk_85 FOREIGN KEY(ty_of_ship_stn_lookup_dtl_id) REFERENCES stn_lookup_dtl,
CONSTRAINT stn_lookup_dtl_fk_85 FOREIGN KEY(del_term_stn_lookup_dtl_id) REFERENCES stn_lookup_dtl,
CONSTRAINT stn_lookup_dtl_id_id_fk_85 FOREIGN KEY(ten_dl_term_stn_lookup_dtl_id) REFERENCES stn_lookup_dtl,
CONSTRAINT ord_po_shipment_pk PRIMARY KEY(id)
)
 

create table ord_po_items(
id number(20) not null,
ord_po_id number(20) not null,
style_no_stn_lookup_dtl_id number(20) default null,
stn_color_id number(20) default null,
stn_size_id number(20) default null,
prod_desc varchar2(20) not null,
qty number(5) not null,
stn_munit_id number(5) not null,
stn_punit_id number(5) not null,
rate number(5,2) not null,
amount number(5,2) not null,
case_crtn_stn_package_id number(20) not null,
case_qty number(5,2) default null,
ration_crtn_stn_package_id number(20) not null,
ration_qty number(5,2) default null,

CONSTRAINT ord_po_fk_11 FOREIGN KEY(ord_po_id) REFERENCES ord_po,
CONSTRAINT stn_lookup_dtl_fk_11 FOREIGN KEY(style_no_stn_lookup_dtl_id) REFERENCES stn_lookup_dtl,
CONSTRAINT stn_color_fk_11 FOREIGN KEY(stn_color_id) REFERENCES stn_color,
CONSTRAINT stn_size_fk_11 FOREIGN KEY(stn_size_id) REFERENCES stn_size,
CONSTRAINT stn_munit_fk_11 FOREIGN KEY(stn_munit_id) REFERENCES stn_munit,
CONSTRAINT stn_punit_fk_11 FOREIGN KEY(stn_punit_id) REFERENCES stn_punit,
CONSTRAINT stn_package_fk_11 FOREIGN KEY(case_crtn_stn_package_id) REFERENCES stn_package,
CONSTRAINT stn_package_fk_11 FOREIGN KEY(ration_crtn_stn_package_id) REFERENCES stn_package,
CONSTRAINT ord_po_items_pk PRIMARY KEY(id)
)
 

create table ord_po_terms(
id number(20) not null,
ord_po_id number(20) not null,
sl number(2) not null,
code varchar2(20) not null,
term_and_cond varchar2(100) not null,

CONSTRAINT ord_po_fk_87 FOREIGN KEY(ord_po_id) REFERENCES ord_po,
CONSTRAINT ord_po_terms_pk PRIMARY KEY(id)
)
 


create table ord_po_amend_control(        -- done
id number(20) not null,
ord_po_id number(20) not null,
req_type_stn_lookup_dtl_id number(20) not null,     -- reqstn_type from lookup new,revised
reqstn_code varchar2(50) not null,
sl_no number(2) not null,                          -- 1,2,3,4

create_date date default null,
update_date date default null,
create_by number(20) not null,
update_by number(20) not null,

CONSTRAINT ord_po_fk_101 FOREIGN KEY(ord_po_id) REFERENCES ord_po,
CONSTRAINT stn_lookup_dtl_fk_101 FOREIGN KEY(req_type_stn_lookup_dtl_id) REFERENCES stn_lookup_dtl,
CONSTRAINT ord_po_amend_control_pk PRIMARY KEY(id)
)
 


create table ord_po_amend_record(
ord_po_amend_control_id number(20) not null,       -- VVI

id number(20) not null,
code varchar2(50) not null,
stn_hrm_company_id number(20) not null,
pi_cat_stn_lookup_dtl_id number(20) not null, -- import,export
po_no varchar2(50) default null,
invoice_no varchar2(20) not null,
po_date_issue_date date not null, 
delivery_date date not null,
due_date date not null,
po_file_name varchar2(20) default null,
is_lock number(1) not null,

create_date date default null,
update_date date default null,
create_by number(20) not null,
update_by number(20) not null,

CONSTRAINT ord_po_amend_control_fk_102 FOREIGN KEY(ord_po_amend_control_id) REFERENCES ord_po_amend_control,
CONSTRAINT stn_hrm_company_fk_102 FOREIGN KEY(stn_hrm_company_id) REFERENCES stn_hrm_company,
CONSTRAINT stn_lookup_dtl_fk_102 FOREIGN KEY(pi_cat_stn_lookup_dtl_id) REFERENCES stn_lookup_dtl,
CONSTRAINT ord_po_amend_record_pk PRIMARY KEY(id)
)
 


create table ord_po_buyer_amend_record(
ord_po_amend_control_id number(20) not null,       -- VVI


id number(20) not null,
ord_po_id number(20) not null, 
stn_party_id number(20) not null,

isu_stn_party_bank_dtl_id number(20) not null,

negotiating_lion_bank varchar2(50) default null,
negotiating_lion_bank_branch varchar2(50) default null,
stn_party_con_prsn_id number(20) not null,
buy_stn_party_customer_id number(20) not null,

create_date date default null,
update_date date default null,
create_by number(20) not null,
update_by number(20) not null,

CONSTRAINT ord_po_amend_control_fk_103 FOREIGN KEY(ord_po_amend_control_id) REFERENCES ord_po_amend_control,
CONSTRAINT ord_po_id_fk_103 FOREIGN KEY(ord_po_id) REFERENCES ord_po,
CONSTRAINT stn_party_fk_103 FOREIGN KEY(stn_party_id) REFERENCES stn_party,
CONSTRAINT stn_party_bank_dtl_fk_103 FOREIGN KEY(isu_stn_party_bank_dtl_id) REFERENCES stn_party_bank_dtl,
CONSTRAINT stn_party_con_prsn_fk_103 FOREIGN KEY(stn_party_con_prsn_id) REFERENCES stn_party_con_prsn,
CONSTRAINT stn_party_customer_id_fk_103 FOREIGN KEY(buy_stn_party_customer_id) REFERENCES stn_party_customer,
CONSTRAINT ord_po_buyer_amend_record_pk PRIMARY KEY(id)
)
 


create table ord_po_seller_amend_record(
ord_po_amend_control_id number(20) not null,       -- VVI

id number(20) not null,
ord_po_id number(20) not null,

stn_party_id number(20) not null,
adv_stn_party_bank_dtl_id number(20) not null,

forwading_bank varchar2(50) default null,
orwading_bank_branch varchar2(50) default null,
noty_stn_party_customer_id number(20) not null,


create_date date default null,
update_date date default null,
create_by number(20) not null,
update_by number(20) not null,

CONSTRAINT ord_po_amend_control_fk_88 FOREIGN KEY(ord_po_amend_control_id) REFERENCES ord_po_amend_control,
CONSTRAINT ord_po_fk_88 FOREIGN KEY(ord_po_id) REFERENCES ord_po,
CONSTRAINT stn_party_fk_88 FOREIGN KEY(stn_party_id) REFERENCES stn_party,
CONSTRAINT stn_party_bank_dtl_fk_88 FOREIGN KEY(adv_stn_party_bank_dtl_id) REFERENCES stn_party_bank_dtl,
CONSTRAINT stn_party_customer_fk_88 FOREIGN KEY(noty_stn_party_customer_id) REFERENCES stn_party_customer,
CONSTRAINT ord_po_seller_amend_record_pk PRIMARY KEY(id)
)
 


create table ord_po_shipment_amend_record(
ord_po_amend_control_id number(20) not null,       -- VVI

id number(20) not null,
ord_po_id number(20) not null,

partial_shipment number(1) not null, -- 0/1
transhipment number(1) not null, -- 0/1
ty_of_ship_stn_lookup_dtl_id number(20) not null,
del_term_stn_lookup_dtl_id number(20) not null,
 
port_of_loading varchar2(20) not null,
port_of_dischare varchar2(20) not null,

place_of_receipt varchar2(20) not null,
place_of_distination varchar2(20) not null,

ten_dl_term_stn_lookup_dtl_id number(20) not null,

CONSTRAINT ord_po_amend_con_fk_104 FOREIGN KEY(ord_po_amend_control_id) REFERENCES ord_po_amend_control,
CONSTRAINT ord_po_fk_104 FOREIGN KEY(ord_po_id) REFERENCES ord_po,
CONSTRAINT stn_lookup_dtl_fk_104 FOREIGN KEY(ty_of_ship_stn_lookup_dtl_id) REFERENCES stn_lookup_dtl,
CONSTRAINT stn_lookup_dtl_fk_114 FOREIGN KEY(del_term_stn_lookup_dtl_id) REFERENCES stn_lookup_dtl,
CONSTRAINT stn_lookup_dtl_fk_124 FOREIGN KEY(ten_dl_term_stn_lookup_dtl_id) REFERENCES stn_lookup_dtl,
CONSTRAINT ord_po_shipment_amend_rcd_pk PRIMARY KEY(id)
)
 

create table ord_po_items_amend_record(
ord_po_amend_control_id number(20) not null,       -- VVI

id number(20) not null,
ord_po_id number(20) not null,
style_no_stn_lookup_dtl_id number(20) default null,
stn_color_id number(20) default null,
stn_size_id number(20) default null,
prod_desc varchar2(20) not null,
qty number(5) not null,
stn_munit_id number(5) not null,
stn_punit_id number(5) not null,
rate number(5,2) not null,
amount number(5,2) not null,
case_crtn_stn_package_id number(20) not null,
case_qty number(5,2) default null,
ration_crtn_stn_package_id number(20) not null,
ration_qty number(5,2) default null,

CONSTRAINT ord_po_amend_control_fk_105 FOREIGN KEY(ord_po_amend_control_id) REFERENCES ord_po_amend_control,
CONSTRAINT ord_po_fk_105 FOREIGN KEY(ord_po_id) REFERENCES ord_po,
CONSTRAINT stn_lookup_dtl_fk_105 FOREIGN KEY(style_no_stn_lookup_dtl_id) REFERENCES stn_lookup_dtl,
CONSTRAINT stn_color_fk_105 FOREIGN KEY(stn_color_id) REFERENCES stn_color,
CONSTRAINT stn_size_fk_105 FOREIGN KEY(stn_size_id) REFERENCES stn_size,
CONSTRAINT stn_munit_fk_105 FOREIGN KEY(stn_munit_id) REFERENCES stn_munit,
CONSTRAINT stn_punit_fk_105 FOREIGN KEY(stn_punit_id) REFERENCES stn_punit,
CONSTRAINT stn_package_fk_105 FOREIGN KEY(case_crtn_stn_package_id) REFERENCES stn_package,
CONSTRAINT stn_package_fk_115 FOREIGN KEY(ration_crtn_stn_package_id) REFERENCES stn_package,
CONSTRAINT ord_po_items_amend_record_pk PRIMARY KEY(id)
)
 

create table ord_po_terms_amend_record(
ord_po_amend_control_id number(20) not null,       -- VVI

id number(20) not null,
ord_po_id number(20) not null,
sl number(2) not null,
code varchar2(20) not null,
term_and_cond varchar2(100) not null,

CONSTRAINT ord_po_amend_control_fk_106 FOREIGN KEY(ord_po_amend_control_id) REFERENCES ord_po_amend_control,
CONSTRAINT ord_po_fk_106 FOREIGN KEY(ord_po_id) REFERENCES ord_po,
CONSTRAINT ord_po_terms_amend_record_pk PRIMARY KEY(id)
)
 


create table ord_pi(
id number(20) not null,
ord_po_id number(20) not null,
code varchar2(50) not null,
stn_hrm_company_id number(20) not null,
pi_cat_stn_lookup_dtl_id number(20) not null, -- import,export
invoice_no varchar2(20) not null,
po_date_issue_date date not null, 
delivery_date date not null,
due_date date not null,

is_lock number(1) not null,

create_date date default null,
update_date date default null,
create_by number(20) not null,
update_by number(20) not null,

CONSTRAINT ord_po_fk_107 FOREIGN KEY(ord_po_id) REFERENCES ord_po,
CONSTRAINT stn_hrm_company_fk_107 FOREIGN KEY(stn_hrm_company_id) REFERENCES stn_hrm_company,
CONSTRAINT stn_lookup_dtl_fk_107 FOREIGN KEY(pi_cat_stn_lookup_dtl_id) REFERENCES stn_lookup_dtl,
CONSTRAINT ord_pi_pk PRIMARY KEY(id)
)
 


create table ord_pi_buyer(
id number(20) not null,
ord_pi_id number(20) not null, 
ord_po_buyer_id number(20) not null, 

create_date date default null,
update_date date default null,
create_by number(20) not null,
update_by number(20) not null,

CONSTRAINT ord_pi_fk_108 FOREIGN KEY(ord_pi_id) REFERENCES ord_pi,
CONSTRAINT ord_po_buyer_fk_108 FOREIGN KEY(ord_po_buyer_id) REFERENCES ord_po_buyer,
CONSTRAINT ord_pi_buyer_pk PRIMARY KEY(id)
)
 


create table ord_pi_seller(
id number(20) not null,
ord_pi_id number(20) not null,
ord_po_seller_id number(20) not null,

create_date date default null,
update_date date default null,
create_by number(20) not null,
update_by number(20) not null,


CONSTRAINT ord_pi_fk_109 FOREIGN KEY(ord_pi_id) REFERENCES ord_pi,
CONSTRAINT ord_po_seller_fk_109 FOREIGN KEY(ord_po_seller_id) REFERENCES ord_po_seller,
CONSTRAINT ord_pi_seller_pk PRIMARY KEY(id)
)
 


create table ord_pi_shipment(
id number(20) not null,
ord_pi_id number(20) not null,

partial_shipment number(1) not null, -- 0/1
transhipment number(1) not null, -- 0/1
ty_of_ship_stn_lookup_dtl_id number(20) not null,
del_term_stn_lookup_dtl_id number(20) not null,
 
port_of_loading varchar2(20) not null,
port_of_dischare varchar2(20) not null,

place_of_receipt varchar2(20) not null,
place_of_distination varchar2(20) not null,

ten_dl_term_stn_lookup_dtl_id number(20) not null,

CONSTRAINT ord_po_fk_100 FOREIGN KEY(ord_pi_id) REFERENCES ord_po,
CONSTRAINT stn_lookup_dtl_fk_110 FOREIGN KEY(ty_of_ship_stn_lookup_dtl_id) REFERENCES stn_lookup_dtl,
CONSTRAINT stn_lookup_dtl_fk_120 FOREIGN KEY(del_term_stn_lookup_dtl_id) REFERENCES stn_lookup_dtl,
CONSTRAINT stn_lookup_dtl_fk_130 FOREIGN KEY(ten_dl_term_stn_lookup_dtl_id) REFERENCES stn_lookup_dtl,
CONSTRAINT ord_pi_shipment_pk PRIMARY KEY(id)
)
 

create table ord_pi_items(
id number(20) not null,
ord_pi_id number(20) not null,
batch_lot_no number(2) default null,
style_no_stn_lookup_dtl_id number(20) default null,
stn_color_id number(20) default null,
stn_size_id number(20) default null,
prod_desc varchar2(20) not null,
qty number(5) not null,
stn_munit_id number(20) not null,
stn_punit_id number(20) not null,
rate number(5,2) not null,
amount number(5,2) not null,
case_crtn_stn_package_id number(20) not null,
case_qty number(5,2) default null,
ration_crtn_stn_package_id number(20) not null,
ration_qty number(5,2) default null,

CONSTRAINT ord_pi_fk_131 FOREIGN KEY(ord_pi_id) REFERENCES ord_po,
CONSTRAINT stn_lookup_dtl_fk_131 FOREIGN KEY(style_no_stn_lookup_dtl_id) REFERENCES stn_lookup_dtl,
CONSTRAINT stn_color_fk_131 FOREIGN KEY(stn_color_id) REFERENCES stn_color,
CONSTRAINT stn_size_fk_131 FOREIGN KEY(stn_size_id) REFERENCES stn_size,
CONSTRAINT stn_munit_fk_131 FOREIGN KEY(stn_munit_id) REFERENCES stn_munit,
CONSTRAINT stn_punit_fk_131 FOREIGN KEY(stn_punit_id) REFERENCES stn_punit,
CONSTRAINT stn_package_fk_131 FOREIGN KEY(case_crtn_stn_package_id) REFERENCES stn_package,
CONSTRAINT stn_package_fk_141 FOREIGN KEY(ration_crtn_stn_package_id) REFERENCES stn_package,
CONSTRAINT ord_pi_items_pk PRIMARY KEY(id)
)
 

create table ord_pi_terms(
id number(20) not null,
ord_pi_id number(20) not null,
sl number(2) not null,
code varchar2(20) not null,
term_and_cond varchar2(100) not null,

CONSTRAINT ord_pi_fk_91 FOREIGN KEY(ord_pi_id) REFERENCES ord_pi,
CONSTRAINT ord_pi_terms_pk PRIMARY KEY(id)
)
 


create table ord_pi_amend_control(        -- done
id number(20) not null,
ord_pi_id number(20) not null,
req_type_stn_lookup_dtl_id number(20) not null,     -- reqstn_type from lookup new,revised
reqstn_code varchar2(50) not null,
sl_no number(2) not null,                          -- 1,2,3,4

create_date date default null,
update_date date default null,
create_by number(20) not null,
update_by number(20) not null,

CONSTRAINT ord_pi_fk102 FOREIGN KEY(ord_pi_id) REFERENCES ord_pi,
CONSTRAINT stn_lookup_dtl_fk102 FOREIGN KEY(req_type_stn_lookup_dtl_id) REFERENCES stn_lookup_dtl,
CONSTRAINT ord_pi_amend_control_pk PRIMARY KEY(id)
)
 


create table ord_pi_amend_record(
ord_pi_amend_control_id number(20) not null,       -- VVI

id number(20) not null,
ord_po_id number(20) not null,
code varchar2(50) not null,
stn_hrm_company_id number(20) not null,
pi_cat_stn_lookup_dtl_id number(20) not null, -- import,export
invoice_no varchar2(20) not null,
po_date_issue_date date not null, 
delivery_date date not null,
due_date date not null,

is_lock number(1) not null,

create_date date default null,
update_date date default null,
create_by number(20) not null,
update_by number(20) not null,

CONSTRAINT ord_pi_amend_control_fk105 FOREIGN KEY(ord_pi_amend_control_id) REFERENCES ord_pi_amend_control,
CONSTRAINT stn_hrm_company_fk105 FOREIGN KEY(stn_hrm_company_id) REFERENCES stn_hrm_company,
CONSTRAINT stn_lookup_dtl_fk105 FOREIGN KEY(pi_cat_stn_lookup_dtl_id) REFERENCES stn_lookup_dtl,
CONSTRAINT ord_pi_amend_record_pk PRIMARY KEY(id)
)
 


create table ord_pi_buyer_amend_record(
ord_pi_amend_control_id number(20) not null,       -- VVI

id number(20) not null,
ord_pi_id number(20) not null, 
ord_po_buyer_id number(20) not null, 

create_date date default null,
update_date date default null,
create_by number(20) not null,
update_by number(20) not null,

CONSTRAINT ord_pi_amend_control_fk106 FOREIGN KEY(ord_pi_amend_control_id) REFERENCES ord_pi_amend_control,
CONSTRAINT ord_po_id_fk106 FOREIGN KEY(ord_pi_id) REFERENCES ord_po,
CONSTRAINT ord_po_buyer_fk106 FOREIGN KEY(ord_po_buyer_id) REFERENCES ord_po_buyer,
CONSTRAINT ord_pi_buyer_amend_record_pk PRIMARY KEY(id)
)
 


create table ord_pi_seller_amend_record(
ord_pi_amend_control_id number(20) not null,       -- VVI

id number(20) not null,
ord_pi_id number(20) not null,
ord_po_seller_id number(20) not null,

create_date date default null,
update_date date default null,
create_by number(20) not null,
update_by number(20) not null,


CONSTRAINT ord_pi_amend_control_fk107 FOREIGN KEY(ord_pi_amend_control_id) REFERENCES ord_pi_amend_control,
CONSTRAINT ord_po_fk107 FOREIGN KEY(ord_pi_id) REFERENCES ord_pi,
CONSTRAINT ord_po_seller_fk107 FOREIGN KEY(ord_po_seller_id) REFERENCES ord_po_seller,
CONSTRAINT ord_pi_seller_amend_record_pk PRIMARY KEY(id)
)
 


create table ord_pi_shipment_amend_record(
ord_pi_amend_control_id number(20) not null,       -- VVI
id number(20) not null,
ord_pi_id number(20) not null,

partial_shipment number(1) not null, -- 0/1
transhipment number(1) not null, -- 0/1
ty_of_ship_stn_lookup_dtl_id number(20) not null,
del_term_stn_lookup_dtl_id number(20) not null,
 
port_of_loading varchar2(20) not null,
port_of_dischare varchar2(20) not null,

place_of_receipt varchar2(20) not null,
place_of_distination varchar2(20) not null,

ten_dl_term_stn_lookup_dtl_id number(20) not null,


CONSTRAINT ord_pi_amend_control_fk108 FOREIGN KEY(ord_pi_amend_control_id) REFERENCES ord_pi_amend_control,
CONSTRAINT ord_pi_fk108 FOREIGN KEY(ord_pi_id) REFERENCES ord_pi,
CONSTRAINT stn_lookup_dtl_fk108 FOREIGN KEY(ty_of_ship_stn_lookup_dtl_id) REFERENCES stn_lookup_dtl,
CONSTRAINT stn_lookup_dtl_fk148 FOREIGN KEY(del_term_stn_lookup_dtl_id) REFERENCES stn_lookup_dtl,
CONSTRAINT stn_lookup_dtl_fk158 FOREIGN KEY(ten_dl_term_stn_lookup_dtl_id) REFERENCES stn_lookup_dtl,
CONSTRAINT ord_pi_shipment_amend_rcd_pk PRIMARY KEY(id)
)
 

create table ord_pi_items_amend_record(
ord_pi_amend_control_id number(20) not null,       -- VVI
id number(20) not null,
ord_pi_id number(20) not null,
batch_lot_no number(2) default null,
style_no_stn_lookup_dtl_id number(20) default null,
stn_color_id number(20) default null,
stn_size_id number(20) default null,
prod_desc varchar2(20) not null,
qty number(5) not null,
stn_munit_id number(5) not null,
stn_punit_id number(5) not null,
rate number(5,2) not null,
amount number(5,2) not null,
case_crtn_stn_package_id number(20) not null,
case_qty number(5,2) default null,
ration_crtn_stn_package_id number(20) not null,
ration_qty number(5,2) default null,

CONSTRAINT ord_pi_amend_control_fk109 FOREIGN KEY(ord_pi_amend_control_id) REFERENCES ord_pi_amend_control,
CONSTRAINT ord_pi_fk109 FOREIGN KEY(ord_pi_id) REFERENCES ord_pi,
CONSTRAINT stn_lookup_dtl_fk109 FOREIGN KEY(style_no_stn_lookup_dtl_id) REFERENCES stn_lookup_dtl,
CONSTRAINT stn_color_fk109 FOREIGN KEY(stn_color_id) REFERENCES stn_color,
CONSTRAINT stn_size_fk109 FOREIGN KEY(stn_size_id) REFERENCES stn_size,
CONSTRAINT stn_munit_fk109 FOREIGN KEY(stn_munit_id) REFERENCES stn_munit,
CONSTRAINT stn_punit_fk109 FOREIGN KEY(stn_punit_id) REFERENCES stn_punit,
CONSTRAINT stn_package_fk169 FOREIGN KEY(case_crtn_stn_package_id) REFERENCES stn_package,
CONSTRAINT stn_package_fk109 FOREIGN KEY(ration_crtn_stn_package_id) REFERENCES stn_package,
CONSTRAINT ord_pi_items_amend_record_pk PRIMARY KEY(id)
)
 

create table ord_pi_terms_amend_record(
ord_pi_amend_control_id number(20) not null,       -- VVI

id number(20) not null,
ord_pi_id number(20) not null,
sl number(2) not null,
code varchar2(20) not null,
term_and_cond varchar2(100) not null,

CONSTRAINT ord_pi_amend_control_fk110 FOREIGN KEY(ord_pi_amend_control_id) REFERENCES ord_pi_amend_control,
CONSTRAINT ord_pi_fk110 FOREIGN KEY(ord_pi_id) REFERENCES ord_pi,
CONSTRAINT ord_pi_terms_amend_record_pk PRIMARY KEY(id)
)
 
create table ord_our_mkt_mrc_team(              -- done
id number(20) not null,         
smp_item_setup_id number(20) not null,  -- from sample table 
marketing_type varchar2(50) not null, -- marketing,merchandiser
team_name varchar2(50) not null,  -- A,B,AA,BB
mkt_stn_hrm_employee_id number(20) not null,
create_date date default null,
update_date date default null,
create_by number(20) not null,
update_by number(20) not null,
CONSTRAINT smp_item_setup_fk111 FOREIGN KEY(smp_item_setup_id) REFERENCES smp_item_setup,
CONSTRAINT stn_hrm_employee_fk111 FOREIGN KEY(mkt_stn_hrm_employee_id) REFERENCES stn_hrm_employee,
CONSTRAINT ord_our_mkt_mrc_team_pk PRIMARY KEY(id)
)
create table ord_our_mkt_mrc_tm_mb(          -- done
id number(20) not null,         
smp_item_setup_id number(20) not null,
ord_our_mkt_mrc_team_id number(20) not null,   --[from setup mkt_mrchen_team_member table]
mkt_stn_hrm_employee_id number(20) not null,
ac_head_no varchar2(50) default null,     -- come from accounting 

create_date date default null,
update_date date default null,
create_by number(20) not null,
update_by number(20) not null,


CONSTRAINT smp_item_setup_fk112 FOREIGN KEY(smp_item_setup_id) REFERENCES smp_item_setup,
CONSTRAINT ord_our_mkt_mrc_team_fk112 FOREIGN KEY(ord_our_mkt_mrc_team_id) REFERENCES ord_our_mkt_mrc_team,
CONSTRAINT mkt_hrm_employee_fk112 FOREIGN KEY(mkt_stn_hrm_employee_id) REFERENCES stn_hrm_employee,
CONSTRAINT ord_our_mkt_mrc_tm_mb_pk PRIMARY KEY(id)
)
create table ord_our_mkt_mrc_comsn_stn(                  -- done
id number(20) not null, 
type varchar2(20) not null,
stn_hrm_company_id number(20) default null,
smp_item_our_mkt_mrc_usr_id number(20) default null,
exchange_rate_bdt number(5,2) default null, 

is_active number(1) not null,     -- 0/1
create_date date default null,
update_date date default null,
create_by number(20) not null,
update_by number(20) not null,
      
CONSTRAINT smp_item_our_mkt_mrc_usr_fk113 FOREIGN KEY(smp_item_our_mkt_mrc_usr_id) REFERENCES smp_item_our_mkt_mrc_usr,
CONSTRAINT stn_hrm_company_fk113 FOREIGN KEY(stn_hrm_company_id) REFERENCES stn_hrm_company,
CONSTRAINT ord_our_mkt_mrc_comsn_stn_pk PRIMARY KEY(id)
)

create table ord_our_mkt_mrc_com_setdtl(              -- done
id number(20) not null,
ord_our_mkt_mrc_comsn_stn_id number(20) not null,
commission varchar2(50) not null,
minimum_amount number(2,2) default null,
from_date date default null,
to_date date default null,
CONSTRAINT ord_our_mkt_mrc_comsn_fk114 FOREIGN KEY(ord_our_mkt_mrc_comsn_stn_id) REFERENCES ord_our_mkt_mrc_comsn_stn,
CONSTRAINT ord_our_mkt_mrc_com_setdtl_pk PRIMARY KEY(id)
)
create table ord_byr_mkt_mrc_comsn_stn(                  -- done
id number(20) not null, 
stn_party_id number(20) default null,
exchange_rate_bdt number(5,2) default null,
 
create_date date default null,
update_date date default null,
create_by number(20) not null,
update_by number(20) not null,
      
CONSTRAINT stn_party_fk118 FOREIGN KEY(stn_party_id) REFERENCES stn_party,
CONSTRAINT ord_byr_mkt_mrc_comsn_stn_pk PRIMARY KEY(id)
)

create table ord_byr_mkt_mrc_comsetdtl(              -- done
id number(20) not null,
ord_byr_mkt_mrc_comsn_stn_id number(20) not null,

buyer_comm number(2,2) not null,
mrc_comm number(2,2) not null,
mkt_comm number(2,2) not null,
from_date date not null,
to_date date not null,
CONSTRAINT ord_byr_mkt_mrc_comsnfk116 FOREIGN KEY(ord_byr_mkt_mrc_comsn_stn_id) REFERENCES ord_byr_mkt_mrc_comsn_stn,
CONSTRAINT ord_byr_mkt_mrc_comsetdtlpk PRIMARY KEY(id)
)

create table ord_order(             -- done
id number(20) not null, 
smp_sample_id number(20) not null, 
stn_hrm_company_id number(20) not null,                -- sbu
stn_apv_form_step_id number(20) not null,            -- [DRAFT,WIP,APPROVED from setting]
reqstg_stn_lookup_dtl_id number(20) not null,        -- reqstn_stage type lookup dtl    
reqslt_stn_lookup_dtl_id number(20) not null,        -- reqstn_slot type lookup dtl    
po_no varchar2(50) default null,
po_tp_stn_lookup_dtl_id number(20) default null,      -- po_type type lookup dtl 
pro_ty_stn_lookup_dtl_id number(20) default null,    -- product_type type lookup dtl 
sample_no_product_ref varchar2(50) not null,

create_date date default null,
update_date date default null,
create_by number(20) not null,
update_by number(20) not null,

CONSTRAINT smp_sample_fk119 FOREIGN KEY(smp_sample_id) REFERENCES smp_sample,
CONSTRAINT stn_hrm_company_fk119 FOREIGN KEY(stn_hrm_company_id) REFERENCES stn_hrm_company,
CONSTRAINT stn_apv_form_step_fk119 FOREIGN KEY(stn_apv_form_step_id) REFERENCES stn_apv_form_step,
CONSTRAINT reqstg_stn_lookup_dtl_fk119 FOREIGN KEY(reqstg_stn_lookup_dtl_id) REFERENCES stn_lookup_dtl,
CONSTRAINT reqslt_lookup_dtl_fk119 FOREIGN KEY(reqslt_stn_lookup_dtl_id) REFERENCES stn_lookup_dtl,
CONSTRAINT po_tp_stn_lookup_dtl_fk119 FOREIGN KEY(po_tp_stn_lookup_dtl_id) REFERENCES stn_lookup_dtl,
CONSTRAINT pro_ty_stn_lookup_dtl_fk119 FOREIGN KEY(pro_ty_stn_lookup_dtl_id) REFERENCES stn_lookup_dtl,
CONSTRAINT ord_order_pk PRIMARY KEY(id)
)
 
	
create table ord_order_party(  
id number(20) not null,
ord_order_id number(20) not null, 
stn_party_id number(20) not null,
stn_party_customer_id number(20) not null,
stn_party_contact_mkt_id number(20) not null,
stn_party_contact_mrc_id number(20) not null,
stn_party_delivery_port_id number(20) not null,
party_note varchar2(100) default null,
is_nomination varchar2(10) default null,

CONSTRAINT ord_order_fk120 FOREIGN KEY(ord_order_id) REFERENCES ord_order,
CONSTRAINT stn_party_fk120 FOREIGN KEY(stn_party_id) REFERENCES stn_party,
CONSTRAINT stn_party_customer_fk120 FOREIGN KEY(stn_party_customer_id) REFERENCES stn_party_customer,
CONSTRAINT stn_party_contact_mkt_fk120 FOREIGN KEY(stn_party_contact_mkt_id) REFERENCES stn_party_con_prsn,
CONSTRAINT stn_party_contact_mrc_fk120 FOREIGN KEY(stn_party_contact_mrc_id) REFERENCES stn_party_con_prsn,
CONSTRAINT stn_party_delivery_port_fk120 FOREIGN KEY(stn_party_delivery_port_id) REFERENCES stn_party_del_port,

CONSTRAINT ord_order_party_pk PRIMARY KEY(id)
)
 
create table ord_order_3rd_pty_test(    -- done
id number(20) not null,  
ord_order_id number(20) not null,    

third_part_test_name number(1) not null,
test_type varchar2(50) default null,
stn_party_id number(20) default null,
req_cert_stn_lookup_dtl_id number(20) default null,  -- req_certificate from lookup 
cert_std_stn_lookup_dtl_id number(20) default null,  -- certificate_std from lookup 
test_requirement varchar2(50) default null,
test_by varchar2(50) default null,
approx_test_price varchar2(50) default null,

CONSTRAINT ord_order_fk121 FOREIGN KEY(ord_order_id) REFERENCES ord_order,
CONSTRAINT stn_party_fk121 FOREIGN KEY(stn_party_id) REFERENCES stn_party,
CONSTRAINT req_cert_stn_lookup_dtl_fk121 FOREIGN KEY(req_cert_stn_lookup_dtl_id) REFERENCES stn_lookup_dtl,
CONSTRAINT cert_std_stn_lookup_dtl_fk121 FOREIGN KEY(cert_std_stn_lookup_dtl_id) REFERENCES stn_lookup_dtl,
CONSTRAINT ord_order_3rd_pty_test_pk PRIMARY KEY(id)
)
create table ord_order_mail_attch(     -- done
id number(20) not null,  
ord_order_id number(20) not null,
party_name varchar2(50) not null,     
mail_attach_link varchar2(100) default null,

CONSTRAINT ord_order_fk_74 FOREIGN KEY(ord_order_id) REFERENCES ord_order,
CONSTRAINT ord_order_mail_attch_pk PRIMARY KEY(id)
)
create table ord_order_breakdown(            -- done
id number(20) not null,
smp_item_setup_id number(20) not null, 
foreign_table varchar2(30) not null,     -- [color,size,munit,package.... tables from ord_item_breakdown_setn]
foreign_table_id varchar2(30) not null,  -- [color,size,munit,package.... tables from ord_item_breakdown_setn]

field_name varchar2(30) not null,
field_type varchar2(30) not null,         -- [static from ord_item_breakdown_setn]
field_value varchar2(30) not null,        -- [static from ord_item_breakdown_setn]
sl_no number(2) not null,
CONSTRAINT ord_item_setup_fk_76 FOREIGN KEY(smp_item_setup_id) REFERENCES smp_item_setup,
CONSTRAINT ord_order_breakdown_pk PRIMARY KEY(id)

)


create table ord_order_amd_cntrl(        -- done
id number(20) not null,
ord_order_id number(20) not null,
req_type_stn_lookup_dtl_id number(20) not null,     -- reqstn_type from lookup new,addition,deduction,deletion
reqstn_code varchar2(50) not null,
sl_no number(2) not null,                          -- 1,2,3,4

create_date date default null,
update_date date default null,
create_by number(20) not null,
update_by number(20) not null,

CONSTRAINT ord_order_fk_77 FOREIGN KEY(ord_order_id) REFERENCES ord_order,
CONSTRAINT stn_lookup_dtl_fk_77 FOREIGN KEY(req_type_stn_lookup_dtl_id) REFERENCES stn_lookup_dtl,
CONSTRAINT ord_order_amd_cntrl_pk PRIMARY KEY(id)
)
 


create table ord_order_amd_record(                         -- done
ord_order_amd_cntrl_id number(20) not null,       -- VVI

id number(20) not null, 
smp_sample_id number(20) not null,
stn_hrm_company_id number(20) not null,                -- sbu
stn_apv_form_step_id number(20) not null,            -- [DRAFT,WIP,APPROVED from setting]
reqstg_stn_lookup_dtl_id number(20) not null,        -- reqstn_stage type lookup dtl    
reqslt_stn_lookup_dtl_id number(20) not null,        -- reqstn_slot type lookup dtl    
po_no varchar2(50) default null,
po_tp_stn_lookup_dtl_id number(20) default null,      -- po_type type lookup dtl 
pro_ty_stn_lookup_dtl_id number(20) default null,    -- product_type type lookup dtl 
sample_no_product_ref varchar2(50) not null,

create_date date default null,
update_date date default null,
create_by number(20) not null,
update_by number(20) not null,

CONSTRAINT smp_sample_fk_78 FOREIGN KEY(smp_sample_id) REFERENCES smp_sample,
CONSTRAINT stn_hrm_company_fk_78 FOREIGN KEY(stn_hrm_company_id) REFERENCES stn_hrm_company,
CONSTRAINT stn_apv_form_step_fk_78 FOREIGN KEY(stn_apv_form_step_id) REFERENCES stn_apv_form_step,
CONSTRAINT reqstg_stn_lookup_dtl_fk_78 FOREIGN KEY(reqstg_stn_lookup_dtl_id) REFERENCES stn_lookup_dtl,
CONSTRAINT reqslt_lookup_dtl_fk_78 FOREIGN KEY(reqslt_stn_lookup_dtl_id) REFERENCES stn_lookup_dtl,
CONSTRAINT po_tp_stn_lookup_dtl_fk_78 FOREIGN KEY(po_tp_stn_lookup_dtl_id) REFERENCES stn_lookup_dtl,
CONSTRAINT pro_ty_stn_lookup_dtl_fk_78 FOREIGN KEY(pro_ty_stn_lookup_dtl_id) REFERENCES stn_lookup_dtl,
CONSTRAINT ord_order_amd_record_pk PRIMARY KEY(id)
)
 
	
create table ord_order_party_amd_record( 
ord_order_amd_cntrl_id number(20) not null,       -- VVI 
id number(20) not null, 
stn_party_id number(20) not null,
stn_party_customer_id number(20) not null,
stn_party_contact_mkt_id number(20) not null,
stn_party_contact_mrc_id number(20) not null,
stn_party_delivery_port_id number(20) not null,
party_note varchar2(100) default null,
is_nomination varchar2(10) default null,

CONSTRAINT ord_order_amd_cntrl_fk122 FOREIGN KEY(ord_order_amd_cntrl_id) REFERENCES ord_order_amd_cntrl,
CONSTRAINT stn_party_fk122 FOREIGN KEY(stn_party_id) REFERENCES stn_party,
CONSTRAINT stn_party_customer_fk122 FOREIGN KEY(stn_party_customer_id) REFERENCES stn_party_customer,
CONSTRAINT stn_party_contact_mkt_fk122 FOREIGN KEY(stn_party_contact_mkt_id) REFERENCES stn_party_con_prsn,
CONSTRAINT stn_party_contact_mrc_fk122 FOREIGN KEY(stn_party_contact_mrc_id) REFERENCES stn_party_con_prsn,
CONSTRAINT stn_party_delivery_port_fk122 FOREIGN KEY(stn_party_delivery_port_id) REFERENCES stn_party_del_port,

CONSTRAINT ord_order_party_amd_record_pk PRIMARY KEY(id)
)
create table ord_order_3rdpty_amd_rcd(  -- done
ord_order_amd_cntrl_id number(20) not null,       -- VVI

id number(20) not null,  
ord_order_id number(20) not null,    

third_part_test_name number(1) not null,
test_type varchar2(50) default null,
stn_party_id number(20) default null,
req_cert_stn_lookup_dtl_id number(20) default null,  -- req_certificate from lookup 
cert_std_stn_lookup_dtl_id number(20) default null,  -- certificate_std from lookup 
test_requirement varchar2(50) default null,
test_by varchar2(50) default null,
approx_test_price varchar2(50) default null,

CONSTRAINT ord_order_amd_cntrl_fk_79 FOREIGN KEY(ord_order_amd_cntrl_id) REFERENCES ord_order_amd_cntrl,
CONSTRAINT ord_order_fk_79 FOREIGN KEY(ord_order_id) REFERENCES ord_order,
CONSTRAINT stn_party_fk_79 FOREIGN KEY(stn_party_id) REFERENCES stn_party,
CONSTRAINT req_cert_stn_lookup_dtl_fk_79 FOREIGN KEY(req_cert_stn_lookup_dtl_id) REFERENCES stn_lookup_dtl,
CONSTRAINT cert_std_stn_lookup_dtl_fk_79 FOREIGN KEY(cert_std_stn_lookup_dtl_id) REFERENCES stn_lookup_dtl,
CONSTRAINT ord_order_3rdpty_amd_rcd_pk PRIMARY KEY(id)
)
create table ord_order_mailatchamdrcd(             -- done
ord_order_amd_cntrl_id number(20) not null, -- VVI
id number(20) not null,  
ord_order_id number(20) not null,
party_name varchar2(50) not null,    
mail_attach_link varchar2(100) default null,

CONSTRAINT ord_order_amd_cntrl_fk_80 FOREIGN KEY(ord_order_amd_cntrl_id) REFERENCES ord_order_amd_cntrl,
CONSTRAINT ord_order_fk_80 FOREIGN KEY(ord_order_id) REFERENCES ord_order,
CONSTRAINT ord_order_mailatchamdrcd_pk PRIMARY KEY(id)
)
create table ord_order_bkdown_amdrcd(                       -- done
ord_order_amd_cntrl_id number(20) not null,       -- VVI
id number(20) not null,
smp_item_setup_id number(20) not null, 
foreign_table varchar2(30) not null,     -- [color,size,munit,package.... tables from ord_item_breakdown_setn]
foreign_table_id varchar2(30) not null,  -- [color,size,munit,package.... tables from ord_item_breakdown_setn]

field_name varchar2(30) not null,
field_type varchar2(30) not null,         -- [static from ord_item_breakdown_setn]
field_value varchar2(30) not null,        -- [static from ord_item_breakdown_setn]
sl_no number(2) not null,

CONSTRAINT ord_order_amd_cntrl_fk124 FOREIGN KEY(ord_order_amd_cntrl_id) REFERENCES ord_order_amd_cntrl,
CONSTRAINT ord_item_setup_fk124 FOREIGN KEY(smp_item_setup_id) REFERENCES smp_item_setup,
CONSTRAINT ord_order_bkdown_amdrcd_pk PRIMARY KEY(id)
)

create table ord_export_lc_crd(
id number(20) not null,
lc_for varchar2(50) not null, -- import,export
stn_hrm_company_id number(20) not null,
cmc_letter_of_credit_id number(20) not null,
remarks varchar2(150) not null,

--CONSTRAINT cmc_letter_of_credit_id_fk FOREIGN KEY(letter_of_credit_id) REFERENCES cmc_letter_of_credit,
CONSTRAINT stn_hrm_company_id_fk FOREIGN KEY(stn_hrm_company_id) REFERENCES stn_hrm_company,
CONSTRAINT ord_export_lc_crd_pk PRIMARY KEY(id)
)
 

create table ord_export_lc_crd_dtl(
id number(20) not null,
ord_export_lc_crd_id number(20) not null,

sl number(2) not null,
doc_name_stn_lookup_dtl_id number(20) not null,
ref_no varchar2(20) not null,
amount number(5,2) not null,
stn_punit_id number(5) not null,
convert_rate number(5,2) default null,
convert_punit_id number(5) not null,
dated date not null,
app_sts_stn_lookup_dtl_id number(20) not null,

CONSTRAINT ord_export_lc_crd_fk125 FOREIGN KEY(ord_export_lc_crd_id) REFERENCES ord_export_lc_crd,
CONSTRAINT stn_lookup_dtl_fk125 FOREIGN KEY(doc_name_stn_lookup_dtl_id) REFERENCES stn_lookup_dtl,
CONSTRAINT stn_lookup_dtl_fk155 FOREIGN KEY(app_sts_stn_lookup_dtl_id) REFERENCES stn_lookup_dtl,
CONSTRAINT stn_punit_fk135 FOREIGN KEY(stn_punit_id) REFERENCES stn_punit,
CONSTRAINT stn_punit_fk125 FOREIGN KEY(convert_punit_id) REFERENCES stn_punit,
CONSTRAINT ord_export_lc_crd_dtl_pk PRIMARY KEY(id)
)
 
create table ord_export_lc_realize(
id number(20) not null,
cmc_letter_of_credit_id number(20) not null,
stn_hrm_company_id number(20) not null,
realize_date date not null,

--CONSTRAINT cmc_letter_of_credit_fk FOREIGN KEY(cmc_letter_of_credit_id) REFERENCES cmc_letter_of_credit,
CONSTRAINT stn_hrm_company_fk FOREIGN KEY(stn_hrm_company_id) REFERENCES stn_lookup_dtl,
CONSTRAINT ord_export_lc_realize_pk PRIMARY KEY(id)
)
create table ord_prod_challan(
id number(20) not null,
stn_hrm_company_id number(20) not null,
ord_order_id number(20) not null,
CONSTRAINT stn_hrm_company_fk_83 FOREIGN KEY(stn_hrm_company_id) REFERENCES stn_hrm_company,
CONSTRAINT ord_order_fk_83 FOREIGN KEY(ord_order_id) REFERENCES ord_order,
CONSTRAINT ord_prod_challan_pk PRIMARY KEY(id)
)
create table ord_acc_payment_vc(
id number(20) not null,
stn_hrm_company_id number(20) not null,
acc_payment_vc_id number(20) not null,
CONSTRAINT stn_hrm_company_fk126 FOREIGN KEY(stn_hrm_company_id) REFERENCES stn_hrm_company,
--CONSTRAINT acc_payment_vc_fk126 FOREIGN KEY(acc_payment_vc_id) REFERENCES acc_payment_vc,
CONSTRAINT ord_acc_payment_vc_pk PRIMARY KEY(id)
)
create table ord_acc_receive_vc(
id number(20) not null,
stn_hrm_company_id number(20) not null,
acc_receive_vc_id number(20) not null,

CONSTRAINT stn_hrm_company_fk333 FOREIGN KEY(stn_hrm_company_id) REFERENCES stn_hrm_company,
--CONSTRAINT acc_receive_vc_fk333 FOREIGN KEY(acc_receive_vc_id) REFERENCES acc_receive_vc,
CONSTRAINT ord_acc_receive_vc_pk PRIMARY KEY(id)
)


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	ord_po	create table ord_po( id number(20) not null, code varchar2(50) not null, stn_hrm_company_id number(20) not null, pi_cat_lookup_dtl_id number(20) not null, -- import,export po_no varchar2(50) default null, invoice_no varchar2(20) not null, po_date_issue_date date not null, delivery_date date not null, due_date date not null, po_file_name varchar2(20) default null, is_lock number(1) not null, create_date date default null, update_date date default null, create_by number(20) not null, update_by number(20) not null, CONSTRAINT stn_hrm_company_fk_81 FOREIGN KEY(stn_hrm_company_id) REFERENCES stn_hrm_company, CONSTRAINT stn_lookup_dtl_fk_81 FOREIGN KEY(pi_cat_lookup_dtl_id) REFERENCES stn_lookup_dtl, CONSTRAINT ord_po_pk PRIMARY KEY(id) )
2	ord_po_buyer	create table ord_po_buyer( id number(20) not null, ord_po_id number(20) not null, stn_party_id number(20) not null, isu_stn_party_bank_dtl_id number(20) not null, negotiating_lion_bank varchar2(50) default null, negotiating_lion_bank_branch varchar2(50) default null, stn_party_con_prsn_id number(20) not null, buy_stn_party_customer_id number(20) not null, create_date date default null, update_date date default null, create_by number(20) not null, update_by number(20) not null, CONSTRAINT ord_po_id_fk_82 FOREIGN KEY(ord_po_id) REFERENCES ord_po, CONSTRAINT stn_party_fk_82 FOREIGN KEY(stn_party_id) REFERENCES stn_party, CONSTRAINT stn_party_bank_dtl_fk_82 FOREIGN KEY(isu_stn_party_bank_dtl_id) REFERENCES stn_party_bank_dtl, CONSTRAINT stn_party_con_prsn_fk_82 FOREIGN KEY(stn_party_con_prsn_id) REFERENCES stn_party_con_prsn, CONSTRAINT stn_party_customer_id_fk_82 FOREIGN KEY(buy_stn_party_customer_id) REFERENCES stn_party_customer, CONSTRAINT ord_po_buyer_pk PRIMARY KEY(id) )
3	ord_po_seller	create table ord_po_seller( id number(20) not null, ord_po_id number(20) not null, stn_party_id number(20) not null, adv_stn_party_bank_dtl_id number(20) not null, forwading_bank varchar2(50) default null, orwading_bank_branch varchar2(50) default null, noty_stn_party_customer_id number(20) not null, create_date date default null, update_date date default null, create_by number(20) not null, update_by number(20) not null, CONSTRAINT ord_po_fk_83 FOREIGN KEY(ord_po_id) REFERENCES ord_po, CONSTRAINT stn_party_fk_83 FOREIGN KEY(stn_party_id) REFERENCES stn_party, CONSTRAINT stn_party_bank_dtl_fk_83 FOREIGN KEY(adv_stn_party_bank_dtl_id) REFERENCES stn_party_bank_dtl, CONSTRAINT stn_party_customer_fk_83 FOREIGN KEY(noty_stn_party_customer_id) REFERENCES stn_party_customer, CONSTRAINT ord_po_seller_pk PRIMARY KEY(id) )
4	ord_po_shipment	create table ord_po_shipment( id number(20) not null, ord_po_id number(20) not null, partial_shipment int(1) not null, -- 0/1 transhipment int(1) not null, -- 0/1 ty_of_ship_stn_lookup_dtl_id number(20) not null, del_term_stn_lookup_dtl_id number(20) not null, port_of_loading varchar2(20) not null, port_of_dischare varchar2(20) not null, place_of_receipt varchar2(20) not null, place_of_distination varchar2(20) not null, ten_dl_term_stn_lookup_dtl_id number(20) not null, CONSTRAINT ord_po_fk_85 FOREIGN KEY(ord_po_id) REFERENCES ord_po, CONSTRAINT stn_lookup_dtl_id_fk_85 FOREIGN KEY(ty_of_ship_stn_lookup_dtl_id) REFERENCES stn_lookup_dtl, CONSTRAINT stn_lookup_dtl_fk_85 FOREIGN KEY(del_term_stn_lookup_dtl_id) REFERENCES stn_lookup_dtl, CONSTRAINT stn_lookup_dtl_id_id_fk_85 FOREIGN KEY(ten_dl_term_stn_lookup_dtl_id) REFERENCES stn_lookup_dtl, CONSTRAINT ord_po_shipment_pk PRIMARY KEY(id) )
5	ord_po_items	create table ord_po_items( id number(20) not null, ord_po_id number(20) not null, style_no_stn_lookup_dtl_id number(20) default null, stn_color_id number(20) default null, stn_size_id number(20) default null, prod_desc varchar2(20) not null, qty number(5) not null, stn_munit_id number(5) not null, stn_punit_id number(5) not null, rate number(5,2) not null, amount number(5,2) not null, case_crtn_stn_package_id number(20) not null, case_qty number(5,2) default null, ration_crtn_stn_package_id number(20) not null, ration_qty number(5,2) default null, CONSTRAINT ord_po_fk_11 FOREIGN KEY(ord_po_id) REFERENCES ord_po, CONSTRAINT stn_lookup_dtl_fk_11 FOREIGN KEY(style_no_stn_lookup_dtl_id) REFERENCES stn_lookup_dtl, CONSTRAINT stn_color_fk_11 FOREIGN KEY(stn_color_id) REFERENCES stn_color, CONSTRAINT stn_size_fk_11 FOREIGN KEY(stn_size_id) REFERENCES stn_size, CONSTRAINT stn_munit_fk_11 FOREIGN KEY(stn_munit_id) REFERENCES stn_munit, CONSTRAINT stn_punit_fk_11 FOREIGN KEY(stn_punit_id) REFERENCES stn_punit, CONSTRAINT stn_package_fk_11 FOREIGN KEY(case_crtn_stn_package_id) REFERENCES stn_package, CONSTRAINT stn_package_fk_11 FOREIGN KEY(ration_crtn_stn_package_id) REFERENCES stn_package, CONSTRAINT ord_po_items_pk PRIMARY KEY(id) )
6	ord_po_terms	create table ord_po_terms( id number(20) not null, ord_po_id number(20) not null, sl number(2) not null, code varchar2(20) not null, term_and_cond varchar2(100) not null, CONSTRAINT ord_po_fk_87 FOREIGN KEY(ord_po_id) REFERENCES ord_po, CONSTRAINT ord_po_terms_pk PRIMARY KEY(id) )
7	ord_po_amend_control(all insert,ammend info recorred here)	create table ord_po_amend_control( -- done id number(20) not null, ord_po_id number(20) not null, req_type_stn_lookup_dtl_id number(20) not null, -- reqstn_type from lookup new,revised reqstn_code varchar2(50) not null, sl_no number(2) not null, -- 1,2,3,4 create_date date default null, update_date date default null, create_by number(20) not null, update_by number(20) not null, CONSTRAINT ord_po_fk_101 FOREIGN KEY(ord_po_id) REFERENCES ord_po, CONSTRAINT stn_lookup_dtl_fk_101 FOREIGN KEY(req_type_stn_lookup_dtl_id) REFERENCES stn_lookup_dtl, CONSTRAINT ord_po_amend_control_pk PRIMARY KEY(id) )
8	ord_po_amend_record	create table ord_po_amend_record( ord_po_amend_control_id number(20) not null, -- VVI id number(20) not null, code varchar2(50) not null, stn_hrm_company_id number(20) not null, pi_cat_stn_lookup_dtl_id number(20) not null, -- import,export po_no varchar2(50) default null, invoice_no varchar2(20) not null, po_date_issue_date date not null, delivery_date date not null, due_date date not null, po_file_name varchar2(20) default null, is_lock number(1) not null, create_date date default null, update_date date default null, create_by number(20) not null, update_by number(20) not null, CONSTRAINT ord_po_amend_control_fk_102 FOREIGN KEY(ord_po_amend_control_id) REFERENCES ord_po_amend_control, CONSTRAINT stn_hrm_company_fk_102 FOREIGN KEY(stn_hrm_company_id) REFERENCES stn_hrm_company, CONSTRAINT stn_lookup_dtl_fk_102 FOREIGN KEY(pi_cat_stn_lookup_dtl_id) REFERENCES stn_lookup_dtl, CONSTRAINT ord_po_amend_record_pk PRIMARY KEY(id) )
9	ord_po_buyer_amend_record	create table ord_po_buyer_amend_record( ord_po_amend_control_id number(20) not null, -- VVI id number(20) not null, ord_po_id number(20) not null, stn_party_id number(20) not null, isu_stn_party_bank_dtl_id number(20) not null, negotiating_lion_bank varchar2(50) default null, negotiating_lion_bank_branch varchar2(50) default null, stn_party_con_prsn_id number(20) not null, buy_stn_party_customer_id number(20) not null, create_date date default null, update_date date default null, create_by number(20) not null, update_by number(20) not null, CONSTRAINT ord_po_amend_control_fk_103 FOREIGN KEY(ord_po_amend_control_id) REFERENCES ord_po_amend_control, CONSTRAINT ord_po_id_fk_103 FOREIGN KEY(ord_po_id) REFERENCES ord_po, CONSTRAINT stn_party_fk_103 FOREIGN KEY(stn_party_id) REFERENCES stn_party, CONSTRAINT stn_party_bank_dtl_fk_103 FOREIGN KEY(isu_stn_party_bank_dtl_id) REFERENCES stn_party_bank_dtl, CONSTRAINT stn_party_con_prsn_fk_103 FOREIGN KEY(stn_party_con_prsn_id) REFERENCES stn_party_con_prsn, CONSTRAINT stn_party_customer_id_fk_103 FOREIGN KEY(buy_stn_party_customer_id) REFERENCES stn_party_customer, CONSTRAINT ord_po_buyer_amend_record_pk PRIMARY KEY(id) )
10	ord_po_seller_amend_record	create table ord_po_seller_amend_record( ord_po_amend_control_id number(20) not null, -- VVI id number(20) not null, ord_po_id number(20) not null, stn_party_id number(20) not null, adv_stn_party_bank_dtl_id number(20) not null, forwading_bank varchar2(50) default null, orwading_bank_branch varchar2(50) default null, noty_stn_party_customer_id number(20) not null, create_date date default null, update_date date default null, create_by number(20) not null, update_by number(20) not null, CONSTRAINT ord_po_amend_control_fk_88 FOREIGN KEY(ord_po_amend_control_id) REFERENCES ord_po_amend_control, CONSTRAINT ord_po_fk_88 FOREIGN KEY(ord_po_id) REFERENCES ord_po, CONSTRAINT stn_party_fk_88 FOREIGN KEY(stn_party_id) REFERENCES stn_party, CONSTRAINT stn_party_bank_dtl_fk_88 FOREIGN KEY(adv_stn_party_bank_dtl_id) REFERENCES stn_party_bank_dtl, CONSTRAINT stn_party_customer_fk_88 FOREIGN KEY(noty_stn_party_customer_id) REFERENCES stn_party_customer, CONSTRAINT ord_po_seller_amend_record_pk PRIMARY KEY(id) )
11	ord_po_shipment_amend_record	create table ord_po_shipment_amend_record( ord_po_amend_control_id number(20) not null, -- VVI id number(20) not null, ord_po_id number(20) not null, partial_shipment number(1) not null, -- 0/1 transhipment number(1) not null, -- 0/1 ty_of_ship_stn_lookup_dtl_id number(20) not null, del_term_stn_lookup_dtl_id number(20) not null, port_of_loading varchar2(20) not null, port_of_dischare varchar2(20) not null, place_of_receipt varchar2(20) not null, place_of_distination varchar2(20) not null, ten_dl_term_stn_lookup_dtl_id number(20) not null, CONSTRAINT ord_po_amend_con_fk_104 FOREIGN KEY(ord_po_amend_control_id) REFERENCES ord_po_amend_control, CONSTRAINT ord_po_fk_104 FOREIGN KEY(ord_po_id) REFERENCES ord_po, CONSTRAINT stn_lookup_dtl_fk_104 FOREIGN KEY(ty_of_ship_stn_lookup_dtl_id) REFERENCES stn_lookup_dtl, CONSTRAINT stn_lookup_dtl_fk_114 FOREIGN KEY(del_term_stn_lookup_dtl_id) REFERENCES stn_lookup_dtl, CONSTRAINT stn_lookup_dtl_fk_124 FOREIGN KEY(ten_dl_term_stn_lookup_dtl_id) REFERENCES stn_lookup_dtl, CONSTRAINT ord_po_shipment_amend_rcd_pk PRIMARY KEY(id) )
12	ord_po_items_amend_record	create table ord_po_items_amend_record( ord_po_amend_control_id number(20) not null, -- VVI id number(20) not null, ord_po_id number(20) not null, style_no_stn_lookup_dtl_id number(20) default null, stn_color_id number(20) default null, stn_size_id number(20) default null, prod_desc varchar2(20) not null, qty number(5) not null, stn_munit_id number(5) not null, stn_punit_id number(5) not null, rate number(5,2) not null, amount number(5,2) not null, case_crtn_stn_package_id number(20) not null, case_qty number(5,2) default null, ration_crtn_stn_package_id number(20) not null, ration_qty number(5,2) default null, CONSTRAINT ord_po_amend_control_fk_105 FOREIGN KEY(ord_po_amend_control_id) REFERENCES ord_po_amend_control, CONSTRAINT ord_po_fk_105 FOREIGN KEY(ord_po_id) REFERENCES ord_po, CONSTRAINT stn_lookup_dtl_fk_105 FOREIGN KEY(style_no_stn_lookup_dtl_id) REFERENCES stn_lookup_dtl, CONSTRAINT stn_color_fk_105 FOREIGN KEY(stn_color_id) REFERENCES stn_color, CONSTRAINT stn_size_fk_105 FOREIGN KEY(stn_size_id) REFERENCES stn_size, CONSTRAINT stn_munit_fk_105 FOREIGN KEY(stn_munit_id) REFERENCES stn_munit, CONSTRAINT stn_punit_fk_105 FOREIGN KEY(stn_punit_id) REFERENCES stn_punit, CONSTRAINT stn_package_fk_105 FOREIGN KEY(case_crtn_stn_package_id) REFERENCES stn_package, CONSTRAINT stn_package_fk_115 FOREIGN KEY(ration_crtn_stn_package_id) REFERENCES stn_package, CONSTRAINT ord_po_items_amend_record_pk PRIMARY KEY(id) )
13	ord_po_terms_amend_record	create table ord_po_terms_amend_record( ord_po_amend_control_id number(20) not null, -- VVI id number(20) not null, ord_po_id number(20) not null, sl number(2) not null, code varchar2(20) not null, term_and_cond varchar2(100) not null, CONSTRAINT ord_po_amend_control_fk_106 FOREIGN KEY(ord_po_amend_control_id) REFERENCES ord_po_amend_control, CONSTRAINT ord_po_fk_106 FOREIGN KEY(ord_po_id) REFERENCES ord_po, CONSTRAINT ord_po_terms_amend_record_pk PRIMARY KEY(id) )
14	ord_pi	create table ord_pi( id number(20) not null, ord_po_id number(20) not null, code varchar2(50) not null, stn_hrm_company_id number(20) not null, pi_cat_stn_lookup_dtl_id number(20) not null, -- import,export invoice_no varchar2(20) not null, po_date_issue_date date not null, delivery_date date not null, due_date date not null, is_lock number(1) not null, create_date date default null, update_date date default null, create_by number(20) not null, update_by number(20) not null, CONSTRAINT ord_po_fk_107 FOREIGN KEY(ord_po_id) REFERENCES ord_po, CONSTRAINT stn_hrm_company_fk_107 FOREIGN KEY(stn_hrm_company_id) REFERENCES stn_hrm_company, CONSTRAINT stn_lookup_dtl_fk_107 FOREIGN KEY(pi_cat_stn_lookup_dtl_id) REFERENCES stn_lookup_dtl, CONSTRAINT ord_pi_pk PRIMARY KEY(id) )
15	ord_pi_buyer	create table ord_pi_buyer( id number(20) not null, ord_pi_id number(20) not null, ord_po_buyer_id number(20) not null, create_date date default null, update_date date default null, create_by number(20) not null, update_by number(20) not null, CONSTRAINT ord_pi_fk_108 FOREIGN KEY(ord_pi_id) REFERENCES ord_pi, CONSTRAINT ord_po_buyer_fk_108 FOREIGN KEY(ord_po_buyer_id) REFERENCES ord_po_buyer, CONSTRAINT ord_pi_buyer_pk PRIMARY KEY(id) )
16	ord_pi_seller	create table ord_pi_seller( id number(20) not null, ord_pi_id number(20) not null, ord_po_seller_id number(20) not null, create_date date default null, update_date date default null, create_by number(20) not null, update_by number(20) not null, CONSTRAINT ord_pi_fk_109 FOREIGN KEY(ord_pi_id) REFERENCES ord_pi, CONSTRAINT ord_po_seller_fk_109 FOREIGN KEY(ord_po_seller_id) REFERENCES ord_po_seller, CONSTRAINT ord_pi_seller_pk PRIMARY KEY(id) )
17	ord_pi_shipment	create table ord_pi_shipment( id number(20) not null, ord_pi_id number(20) not null, partial_shipment number(1) not null, -- 0/1 transhipment number(1) not null, -- 0/1 ty_of_ship_stn_lookup_dtl_id number(20) not null, del_term_stn_lookup_dtl_id number(20) not null, port_of_loading varchar2(20) not null, port_of_dischare varchar2(20) not null, place_of_receipt varchar2(20) not null, place_of_distination varchar2(20) not null, ten_dl_term_stn_lookup_dtl_id number(20) not null, CONSTRAINT ord_po_fk_100 FOREIGN KEY(ord_pi_id) REFERENCES ord_po, CONSTRAINT stn_lookup_dtl_fk_110 FOREIGN KEY(ty_of_ship_stn_lookup_dtl_id) REFERENCES stn_lookup_dtl, CONSTRAINT stn_lookup_dtl_fk_120 FOREIGN KEY(del_term_stn_lookup_dtl_id) REFERENCES stn_lookup_dtl, CONSTRAINT stn_lookup_dtl_fk_130 FOREIGN KEY(ten_dl_term_stn_lookup_dtl_id) REFERENCES stn_lookup_dtl, CONSTRAINT ord_pi_shipment_pk PRIMARY KEY(id) )
18	ord_pi_items	create table ord_pi_items( id number(20) not null, ord_pi_id number(20) not null, batch_lot_no number(2) default null, style_no_stn_lookup_dtl_id number(20) default null, stn_color_id number(20) default null, stn_size_id number(20) default null, prod_desc varchar2(20) not null, qty number(5) not null, stn_munit_id number(20) not null, stn_punit_id number(20) not null, rate number(5,2) not null, amount number(5,2) not null, case_crtn_stn_package_id number(20) not null, case_qty number(5,2) default null, ration_crtn_stn_package_id number(20) not null, ration_qty number(5,2) default null, CONSTRAINT ord_pi_fk_131 FOREIGN KEY(ord_pi_id) REFERENCES ord_po, CONSTRAINT stn_lookup_dtl_fk_131 FOREIGN KEY(style_no_stn_lookup_dtl_id) REFERENCES stn_lookup_dtl, CONSTRAINT stn_color_fk_131 FOREIGN KEY(stn_color_id) REFERENCES stn_color, CONSTRAINT stn_size_fk_131 FOREIGN KEY(stn_size_id) REFERENCES stn_size, CONSTRAINT stn_munit_fk_131 FOREIGN KEY(stn_munit_id) REFERENCES stn_munit, CONSTRAINT stn_punit_fk_131 FOREIGN KEY(stn_punit_id) REFERENCES stn_punit, CONSTRAINT stn_package_fk_131 FOREIGN KEY(case_crtn_stn_package_id) REFERENCES stn_package, CONSTRAINT stn_package_fk_141 FOREIGN KEY(ration_crtn_stn_package_id) REFERENCES stn_package, CONSTRAINT ord_pi_items_pk PRIMARY KEY(id) )
19	ord_pi_terms	create table ord_pi_terms( id number(20) not null, ord_pi_id number(20) not null, sl number(2) not null, code varchar2(20) not null, term_and_cond varchar2(100) not null, CONSTRAINT ord_pi_fk_91 FOREIGN KEY(ord_pi_id) REFERENCES ord_pi, CONSTRAINT ord_pi_terms_pk PRIMARY KEY(id) )
20	ord_pi_amend_control(all insert,ammend info recorred here)	create table ord_pi_amend_control( -- done id number(20) not null, ord_pi_id number(20) not null, req_type_stn_lookup_dtl_id number(20) not null, -- reqstn_type from lookup new,revised reqstn_code varchar2(50) not null, sl_no number(2) not null, -- 1,2,3,4 create_date date default null, update_date date default null, create_by number(20) not null, update_by number(20) not null, CONSTRAINT ord_pi_fk102 FOREIGN KEY(ord_pi_id) REFERENCES ord_pi, CONSTRAINT stn_lookup_dtl_fk102 FOREIGN KEY(req_type_stn_lookup_dtl_id) REFERENCES stn_lookup_dtl, CONSTRAINT ord_pi_amend_control_pk PRIMARY KEY(id) )
21	ord_pi_amend_record	create table ord_pi_amend_record( ord_pi_amend_control_id number(20) not null, -- VVI id number(20) not null, ord_po_id number(20) not null, code varchar2(50) not null, stn_hrm_company_id number(20) not null, pi_cat_stn_lookup_dtl_id number(20) not null, -- import,export invoice_no varchar2(20) not null, po_date_issue_date date not null, delivery_date date not null, due_date date not null, is_lock number(1) not null, create_date date default null, update_date date default null, create_by number(20) not null, update_by number(20) not null, CONSTRAINT ord_pi_amend_control_fk105 FOREIGN KEY(ord_pi_amend_control_id) REFERENCES ord_pi_amend_control, CONSTRAINT stn_hrm_company_fk105 FOREIGN KEY(stn_hrm_company_id) REFERENCES stn_hrm_company, CONSTRAINT stn_lookup_dtl_fk105 FOREIGN KEY(pi_cat_stn_lookup_dtl_id) REFERENCES stn_lookup_dtl, CONSTRAINT ord_pi_amend_record_pk PRIMARY KEY(id) )
22	ord_pi_buyer_amend_record	create table ord_pi_buyer_amend_record( ord_pi_amend_control_id number(20) not null, -- VVI id number(20) not null, ord_pi_id number(20) not null, ord_po_buyer_id number(20) not null, create_date date default null, update_date date default null, create_by number(20) not null, update_by number(20) not null, CONSTRAINT ord_pi_amend_control_fk106 FOREIGN KEY(ord_pi_amend_control_id) REFERENCES ord_pi_amend_control, CONSTRAINT ord_po_id_fk106 FOREIGN KEY(ord_pi_id) REFERENCES ord_po, CONSTRAINT ord_po_buyer_fk106 FOREIGN KEY(ord_po_buyer_id) REFERENCES ord_po_buyer, CONSTRAINT ord_pi_buyer_amend_record_pk PRIMARY KEY(id) )
23	ord_pi_seller_amend_record	create table ord_pi_seller_amend_record( ord_pi_amend_control_id number(20) not null, -- VVI id number(20) not null, ord_pi_id number(20) not null, ord_po_seller_id number(20) not null, create_date date default null, update_date date default null, create_by number(20) not null, update_by number(20) not null, CONSTRAINT ord_pi_amend_control_fk107 FOREIGN KEY(ord_pi_amend_control_id) REFERENCES ord_pi_amend_control, CONSTRAINT ord_po_fk107 FOREIGN KEY(ord_pi_id) REFERENCES ord_pi, CONSTRAINT ord_po_seller_fk107 FOREIGN KEY(ord_po_seller_id) REFERENCES ord_po_seller, CONSTRAINT ord_pi_seller_amend_record_pk PRIMARY KEY(id) )
24	ord_pi_shipment_amend_record	create table ord_pi_shipment_amend_record( ord_pi_amend_control_id number(20) not null, -- VVI id number(20) not null, ord_pi_id number(20) not null, partial_shipment number(1) not null, -- 0/1 transhipment number(1) not null, -- 0/1 ty_of_ship_stn_lookup_dtl_id number(20) not null, del_term_stn_lookup_dtl_id number(20) not null, port_of_loading varchar2(20) not null, port_of_dischare varchar2(20) not null, place_of_receipt varchar2(20) not null, place_of_distination varchar2(20) not null, ten_dl_term_stn_lookup_dtl_id number(20) not null, CONSTRAINT ord_pi_amend_control_fk108 FOREIGN KEY(ord_pi_amend_control_id) REFERENCES ord_pi_amend_control, CONSTRAINT ord_pi_fk108 FOREIGN KEY(ord_pi_id) REFERENCES ord_pi, CONSTRAINT stn_lookup_dtl_fk108 FOREIGN KEY(ty_of_ship_stn_lookup_dtl_id) REFERENCES stn_lookup_dtl, CONSTRAINT stn_lookup_dtl_fk148 FOREIGN KEY(del_term_stn_lookup_dtl_id) REFERENCES stn_lookup_dtl, CONSTRAINT stn_lookup_dtl_fk158 FOREIGN KEY(ten_dl_term_stn_lookup_dtl_id) REFERENCES stn_lookup_dtl, CONSTRAINT ord_pi_shipment_amend_rcd_pk PRIMARY KEY(id) )
25	ord_pi_items_amend_record	create table ord_pi_items_amend_record( ord_pi_amend_control_id number(20) not null, -- VVI id number(20) not null, ord_pi_id number(20) not null, batch_lot_no number(2) default null, style_no_stn_lookup_dtl_id number(20) default null, stn_color_id number(20) default null, stn_size_id number(20) default null, prod_desc varchar2(20) not null, qty number(5) not null, stn_munit_id number(5) not null, stn_punit_id number(5) not null, rate number(5,2) not null, amount number(5,2) not null, case_crtn_stn_package_id number(20) not null, case_qty number(5,2) default null, ration_crtn_stn_package_id number(20) not null, ration_qty number(5,2) default null, CONSTRAINT ord_pi_amend_control_fk109 FOREIGN KEY(ord_pi_amend_control_id) REFERENCES ord_pi_amend_control, CONSTRAINT ord_pi_fk109 FOREIGN KEY(ord_pi_id) REFERENCES ord_pi, CONSTRAINT stn_lookup_dtl_fk109 FOREIGN KEY(style_no_stn_lookup_dtl_id) REFERENCES stn_lookup_dtl, CONSTRAINT stn_color_fk109 FOREIGN KEY(stn_color_id) REFERENCES stn_color, CONSTRAINT stn_size_fk109 FOREIGN KEY(stn_size_id) REFERENCES stn_size, CONSTRAINT stn_munit_fk109 FOREIGN KEY(stn_munit_id) REFERENCES stn_munit, CONSTRAINT stn_punit_fk109 FOREIGN KEY(stn_punit_id) REFERENCES stn_punit, CONSTRAINT stn_package_fk169 FOREIGN KEY(case_crtn_stn_package_id) REFERENCES stn_package, CONSTRAINT stn_package_fk109 FOREIGN KEY(ration_crtn_stn_package_id) REFERENCES stn_package, CONSTRAINT ord_pi_items_amend_record_pk PRIMARY KEY(id) )
26	ord_pi_terms_amend_record	create table ord_pi_terms_amend_record( ord_pi_amend_control_id number(20) not null, -- VVI id number(20) not null, ord_pi_id number(20) not null, sl number(2) not null, code varchar2(20) not null, term_and_cond varchar2(100) not null, CONSTRAINT ord_pi_amend_control_fk110 FOREIGN KEY(ord_pi_amend_control_id) REFERENCES ord_pi_amend_control, CONSTRAINT ord_pi_fk110 FOREIGN KEY(ord_pi_id) REFERENCES ord_pi, CONSTRAINT ord_pi_terms_amend_record_pk PRIMARY KEY(id) )
27	ord_our_marketing_marchendiser_team	create table ord_our_mkt_mrc_team( -- done id number(20) not null, smp_item_setup_id number(20) not null, -- from sample table marketing_type varchar2(50) not null, -- marketing,merchandiser team_name varchar2(50) not null, -- A,B,AA,BB mkt_stn_hrm_employee_id number(20) not null, create_date date default null, update_date date default null, create_by number(20) not null, update_by number(20) not null, CONSTRAINT smp_item_setup_fk111 FOREIGN KEY(smp_item_setup_id) REFERENCES smp_item_setup, CONSTRAINT stn_hrm_employee_fk111 FOREIGN KEY(mkt_stn_hrm_employee_id) REFERENCES stn_hrm_employee, CONSTRAINT ord_our_mkt_mrc_team_pk PRIMARY KEY(id) )
28	ord_our_marketing_marchendiser_team_member	create table ord_our_mkt_mrc_tm_mb( -- done id number(20) not null, smp_item_setup_id number(20) not null, ord_our_mkt_mrc_team_id number(20) not null, --[from setup mkt_mrchen_team_member table] mkt_stn_hrm_employee_id number(20) not null, ac_head_no varchar2(50) default null, -- come from accounting create_date date default null, update_date date default null, create_by number(20) not null, update_by number(20) not null, CONSTRAINT smp_item_setup_fk112 FOREIGN KEY(smp_item_setup_id) REFERENCES smp_item_setup, CONSTRAINT ord_our_mkt_mrc_team_fk112 FOREIGN KEY(ord_our_mkt_mrc_team_id) REFERENCES ord_our_mkt_mrc_team, CONSTRAINT mkt_hrm_employee_fk112 FOREIGN KEY(mkt_stn_hrm_employee_id) REFERENCES stn_hrm_employee, CONSTRAINT ord_our_mkt_mrc_tm_mb_pk PRIMARY KEY(id) )
29	ord_our_marketing_marchandiser_commsn_setn	create table ord_our_mkt_mrc_comsn_stn( -- done id number(20) not null, type varchar2(20) not null, stn_hrm_company_id number(20) default null, smp_item_our_mkt_mrc_usr_id number(20) default null, exchange_rate_bdt number(5,2) default null, is_active number(1) not null, -- 0/1 create_date date default null, update_date date default null, create_by number(20) not null, update_by number(20) not null, CONSTRAINT smp_item_our_mkt_mrc_usr_fk113 FOREIGN KEY(smp_item_our_mkt_mrc_usr_id) REFERENCES smp_item_our_mkt_mrc_usr, CONSTRAINT stn_hrm_company_fk113 FOREIGN KEY(stn_hrm_company_id) REFERENCES stn_hrm_company, CONSTRAINT ord_our_mkt_mrc_comsn_stn_pk PRIMARY KEY(id) )
30	ord_our_marketing_marchandiser_commsn_details	create table ord_our_mkt_mrc_com_setdtl( -- done id number(20) not null, ord_our_mkt_mrc_comsn_stn_id number(20) not null, commission varchar2(50) not null, minimum_amount number(2,2) default null, from_date date default null, to_date date default null, CONSTRAINT ord_our_mkt_mrc_comsn_fk114 FOREIGN KEY(ord_our_mkt_mrc_comsn_stn_id) REFERENCES ord_our_mkt_mrc_comsn_stn, CONSTRAINT ord_our_mkt_mrc_com_setdtl_pk PRIMARY KEY(id) )
31	ord_buyer_marketing_marchandiser_commsn_setn	create table ord_byr_mkt_mrc_comsn_stn( -- done id number(20) not null, stn_party_id number(20) default null, exchange_rate_bdt number(5,2) default null, create_date date default null, update_date date default null, create_by number(20) not null, update_by number(20) not null, CONSTRAINT stn_party_fk118 FOREIGN KEY(stn_party_id) REFERENCES stn_party, CONSTRAINT ord_byr_mkt_mrc_comsn_stn_pk PRIMARY KEY(id) )
32	ord_buyer_marketing_marchandiser_commsn_details	create table ord_byr_mkt_mrc_comsetdtl( -- done id number(20) not null, ord_byr_mkt_mrc_comsn_stn_id number(20) not null, buyer_comm number(2,2) not null, mrc_comm number(2,2) not null, mkt_comm number(2,2) not null, from_date date not null, to_date date not null, CONSTRAINT ord_byr_mkt_mrc_comsnfk116 FOREIGN KEY(ord_byr_mkt_mrc_comsn_stn_id) REFERENCES ord_byr_mkt_mrc_comsn_stn, CONSTRAINT ord_byr_mkt_mrc_comsetdtlpk PRIMARY KEY(id) )
33	ord_order (is the main table after collecting or comparing with setup table)	create table ord_order( -- done id number(20) not null, smp_sample_id number(20) not null, stn_hrm_company_id number(20) not null, -- sbu stn_apv_form_step_id number(20) not null, -- [DRAFT,WIP,APPROVED from setting] reqstg_stn_lookup_dtl_id number(20) not null, -- reqstn_stage type lookup dtl reqslt_stn_lookup_dtl_id number(20) not null, -- reqstn_slot type lookup dtl po_no varchar2(50) default null, po_tp_stn_lookup_dtl_id number(20) default null, -- po_type type lookup dtl pro_ty_stn_lookup_dtl_id number(20) default null, -- product_type type lookup dtl sample_no_product_ref varchar2(50) not null, create_date date default null, update_date date default null, create_by number(20) not null, update_by number(20) not null, CONSTRAINT smp_sample_fk119 FOREIGN KEY(smp_sample_id) REFERENCES smp_sample, CONSTRAINT stn_hrm_company_fk119 FOREIGN KEY(stn_hrm_company_id) REFERENCES stn_hrm_company, CONSTRAINT stn_apv_form_step_fk119 FOREIGN KEY(stn_apv_form_step_id) REFERENCES stn_apv_form_step, CONSTRAINT reqstg_stn_lookup_dtl_fk119 FOREIGN KEY(reqstg_stn_lookup_dtl_id) REFERENCES stn_lookup_dtl, CONSTRAINT reqslt_lookup_dtl_fk119 FOREIGN KEY(reqslt_stn_lookup_dtl_id) REFERENCES stn_lookup_dtl, CONSTRAINT po_tp_stn_lookup_dtl_fk119 FOREIGN KEY(po_tp_stn_lookup_dtl_id) REFERENCES stn_lookup_dtl, CONSTRAINT pro_ty_stn_lookup_dtl_fk119 FOREIGN KEY(pro_ty_stn_lookup_dtl_id) REFERENCES stn_lookup_dtl, CONSTRAINT ord_order_pk PRIMARY KEY(id) )
34	ord_order_party	create table ord_order_party( id number(20) not null, ord_order_id number(20) not null, stn_party_id number(20) not null, stn_party_customer_id number(20) not null, stn_party_contact_mkt_id number(20) not null, stn_party_contact_mrc_id number(20) not null, stn_party_delivery_port_id number(20) not null, party_note varchar2(100) default null, is_nomination varchar2(10) default null, CONSTRAINT ord_order_fk120 FOREIGN KEY(ord_order_id) REFERENCES ord_order, CONSTRAINT stn_party_fk120 FOREIGN KEY(stn_party_id) REFERENCES stn_party, CONSTRAINT stn_party_customer_fk120 FOREIGN KEY(stn_party_customer_id) REFERENCES stn_party_customer, CONSTRAINT stn_party_contact_mkt_fk120 FOREIGN KEY(stn_party_contact_mkt_id) REFERENCES stn_party_con_prsn, CONSTRAINT stn_party_contact_mrc_fk120 FOREIGN KEY(stn_party_contact_mrc_id) REFERENCES stn_party_con_prsn, CONSTRAINT stn_party_delivery_port_fk120 FOREIGN KEY(stn_party_delivery_port_id) REFERENCES stn_party_del_port, CONSTRAINT ord_order_party_pk PRIMARY KEY(id) )
35	ord_order_3rd_pty_test	create table ord_order_3rd_pty_test( -- done id number(20) not null, ord_order_id number(20) not null, third_part_test_name number(1) not null, test_type varchar2(50) default null, stn_party_id number(20) default null, req_cert_stn_lookup_dtl_id number(20) default null, -- req_certificate from lookup cert_std_stn_lookup_dtl_id number(20) default null, -- certificate_std from lookup test_requirement varchar2(50) default null, test_by varchar2(50) default null, approx_test_price varchar2(50) default null, CONSTRAINT ord_order_fk121 FOREIGN KEY(ord_order_id) REFERENCES ord_order, CONSTRAINT stn_party_fk121 FOREIGN KEY(stn_party_id) REFERENCES stn_party, CONSTRAINT req_cert_stn_lookup_dtl_fk121 FOREIGN KEY(req_cert_stn_lookup_dtl_id) REFERENCES stn_lookup_dtl, CONSTRAINT cert_std_stn_lookup_dtl_fk121 FOREIGN KEY(cert_std_stn_lookup_dtl_id) REFERENCES stn_lookup_dtl, CONSTRAINT ord_order_3rd_pty_test_pk PRIMARY KEY(id) )
36	ord_order_mail_attch	create table ord_order_mail_attch( -- done id number(20) not null, ord_order_id number(20) not null, party_name varchar2(50) not null, mail_attach_link varchar2(100) default null, CONSTRAINT ord_order_fk_74 FOREIGN KEY(ord_order_id) REFERENCES ord_order, CONSTRAINT ord_order_mail_attch_pk PRIMARY KEY(id) )
37	ord_order_breakdown	create table ord_order_breakdown( -- done id number(20) not null, smp_item_setup_id number(20) not null, foreign_table varchar2(30) not null, -- [color,size,munit,package.... tables from ord_item_breakdown_setn] foreign_table_id varchar2(30) not null, -- [color,size,munit,package.... tables from ord_item_breakdown_setn] field_name varchar2(30) not null, field_type varchar2(30) not null, -- [static from ord_item_breakdown_setn] field_value varchar2(30) not null, -- [static from ord_item_breakdown_setn] sl_no number(2) not null, CONSTRAINT ord_item_setup_fk_76 FOREIGN KEY(smp_item_setup_id) REFERENCES smp_item_setup, CONSTRAINT ord_order_breakdown_pk PRIMARY KEY(id) )
38	ord_order_amendment_control(all insert,ammend info recorred here)	create table ord_order_amd_cntrl( -- done id number(20) not null, ord_order_id number(20) not null, req_type_stn_lookup_dtl_id number(20) not null, -- reqstn_type from lookup new,addition,deduction,deletion reqstn_code varchar2(50) not null, sl_no number(2) not null, -- 1,2,3,4 create_date date default null, update_date date default null, create_by number(20) not null, update_by number(20) not null, CONSTRAINT ord_order_fk_77 FOREIGN KEY(ord_order_id) REFERENCES ord_order, CONSTRAINT stn_lookup_dtl_fk_77 FOREIGN KEY(req_type_stn_lookup_dtl_id) REFERENCES stn_lookup_dtl, CONSTRAINT ord_order_amd_cntrl_pk PRIMARY KEY(id) )
39	ord_order_ammendment_record (recoded all sample record)	create table ord_order_amd_record( -- done ord_order_amd_cntrl_id number(20) not null, -- VVI id number(20) not null, smp_sample_id number(20) not null, stn_hrm_company_id number(20) not null, -- sbu stn_apv_form_step_id number(20) not null, -- [DRAFT,WIP,APPROVED from setting] reqstg_stn_lookup_dtl_id number(20) not null, -- reqstn_stage type lookup dtl reqslt_stn_lookup_dtl_id number(20) not null, -- reqstn_slot type lookup dtl po_no varchar2(50) default null, po_tp_stn_lookup_dtl_id number(20) default null, -- po_type type lookup dtl pro_ty_stn_lookup_dtl_id number(20) default null, -- product_type type lookup dtl sample_no_product_ref varchar2(50) not null, create_date date default null, update_date date default null, create_by number(20) not null, update_by number(20) not null, CONSTRAINT smp_sample_fk_78 FOREIGN KEY(smp_sample_id) REFERENCES smp_sample, CONSTRAINT stn_hrm_company_fk_78 FOREIGN KEY(stn_hrm_company_id) REFERENCES stn_hrm_company, CONSTRAINT stn_apv_form_step_fk_78 FOREIGN KEY(stn_apv_form_step_id) REFERENCES stn_apv_form_step, CONSTRAINT reqstg_stn_lookup_dtl_fk_78 FOREIGN KEY(reqstg_stn_lookup_dtl_id) REFERENCES stn_lookup_dtl, CONSTRAINT reqslt_lookup_dtl_fk_78 FOREIGN KEY(reqslt_stn_lookup_dtl_id) REFERENCES stn_lookup_dtl, CONSTRAINT po_tp_stn_lookup_dtl_fk_78 FOREIGN KEY(po_tp_stn_lookup_dtl_id) REFERENCES stn_lookup_dtl, CONSTRAINT pro_ty_stn_lookup_dtl_fk_78 FOREIGN KEY(pro_ty_stn_lookup_dtl_id) REFERENCES stn_lookup_dtl, CONSTRAINT ord_order_amd_record_pk PRIMARY KEY(id) )
39	ord_order_party_ammendment_record	create table ord_order_party_amd_record( ord_order_amd_cntrl_id number(20) not null, -- VVI id number(20) not null, stn_party_id number(20) not null, stn_party_customer_id number(20) not null, stn_party_contact_mkt_id number(20) not null, stn_party_contact_mrc_id number(20) not null, stn_party_delivery_port_id number(20) not null, party_note varchar2(100) default null, is_nomination varchar2(10) default null, CONSTRAINT ord_order_amd_cntrl_fk122 FOREIGN KEY(ord_order_amd_cntrl_id) REFERENCES ord_order_amd_cntrl, CONSTRAINT stn_party_fk122 FOREIGN KEY(stn_party_id) REFERENCES stn_party, CONSTRAINT stn_party_customer_fk122 FOREIGN KEY(stn_party_customer_id) REFERENCES stn_party_customer, CONSTRAINT stn_party_contact_mkt_fk122 FOREIGN KEY(stn_party_contact_mkt_id) REFERENCES stn_party_con_prsn, CONSTRAINT stn_party_contact_mrc_fk122 FOREIGN KEY(stn_party_contact_mrc_id) REFERENCES stn_party_con_prsn, CONSTRAINT stn_party_delivery_port_fk122 FOREIGN KEY(stn_party_delivery_port_id) REFERENCES stn_party_del_port, CONSTRAINT ord_order_party_amd_record_pk PRIMARY KEY(id) )
40	ord_order_third_pty_test_amd_record	create table ord_order_3rdpty_amd_rcd( -- done ord_order_amd_cntrl_id number(20) not null, -- VVI id number(20) not null, ord_order_id number(20) not null, third_part_test_name number(1) not null, test_type varchar2(50) default null, stn_party_id number(20) default null, req_cert_stn_lookup_dtl_id number(20) default null, -- req_certificate from lookup cert_std_stn_lookup_dtl_id number(20) default null, -- certificate_std from lookup test_requirement varchar2(50) default null, test_by varchar2(50) default null, approx_test_price varchar2(50) default null, CONSTRAINT ord_order_amd_cntrl_fk_79 FOREIGN KEY(ord_order_amd_cntrl_id) REFERENCES ord_order_amd_cntrl, CONSTRAINT ord_order_fk_79 FOREIGN KEY(ord_order_id) REFERENCES ord_order, CONSTRAINT stn_party_fk_79 FOREIGN KEY(stn_party_id) REFERENCES stn_party, CONSTRAINT req_cert_stn_lookup_dtl_fk_79 FOREIGN KEY(req_cert_stn_lookup_dtl_id) REFERENCES stn_lookup_dtl, CONSTRAINT cert_std_stn_lookup_dtl_fk_79 FOREIGN KEY(cert_std_stn_lookup_dtl_id) REFERENCES stn_lookup_dtl, CONSTRAINT ord_order_3rdpty_amd_rcd_pk PRIMARY KEY(id) )
41	ord_order_mail_attch_amd_record	create table ord_order_mailatchamdrcd( -- done ord_order_amd_cntrl_id number(20) not null, -- VVI id number(20) not null, ord_order_id number(20) not null, party_name varchar2(50) not null, mail_attach_link varchar2(100) default null, CONSTRAINT ord_order_amd_cntrl_fk_80 FOREIGN KEY(ord_order_amd_cntrl_id) REFERENCES ord_order_amd_cntrl, CONSTRAINT ord_order_fk_80 FOREIGN KEY(ord_order_id) REFERENCES ord_order, CONSTRAINT ord_order_mailatchamdrcd_pk PRIMARY KEY(id) )
42	ord_order_breakdown_amd_record	create table ord_order_bkdown_amdrcd( -- done ord_order_amd_cntrl_id number(20) not null, -- VVI id number(20) not null, smp_item_setup_id number(20) not null, foreign_table varchar2(30) not null, -- [color,size,munit,package.... tables from ord_item_breakdown_setn] foreign_table_id varchar2(30) not null, -- [color,size,munit,package.... tables from ord_item_breakdown_setn] field_name varchar2(30) not null, field_type varchar2(30) not null, -- [static from ord_item_breakdown_setn] field_value varchar2(30) not null, -- [static from ord_item_breakdown_setn] sl_no number(2) not null, CONSTRAINT ord_order_amd_cntrl_fk124 FOREIGN KEY(ord_order_amd_cntrl_id) REFERENCES ord_order_amd_cntrl, CONSTRAINT ord_item_setup_fk124 FOREIGN KEY(smp_item_setup_id) REFERENCES smp_item_setup, CONSTRAINT ord_order_bkdown_amdrcd_pk PRIMARY KEY(id) )
43	ord_export_lc_crd from Commercial Module	create table ord_export_lc_crd( id number(20) not null, lc_for varchar2(50) not null, -- import,export stn_hrm_company_id number(20) not null, cmc_letter_of_credit_id number(20) not null, remarks varchar2(150) not null, --CONSTRAINT cmc_letter_of_credit_id_fk FOREIGN KEY(letter_of_credit_id) REFERENCES cmc_letter_of_credit, CONSTRAINT stn_hrm_company_id_fk FOREIGN KEY(stn_hrm_company_id) REFERENCES stn_hrm_company, CONSTRAINT ord_export_lc_crd_pk PRIMARY KEY(id) )	all dependency table come from commercial
44	ord_export_lc_crd_dtl from Commercial Module	create table ord_export_lc_crd_dtl( id number(20) not null, ord_export_lc_crd_id number(20) not null, sl number(2) not null, doc_name_stn_lookup_dtl_id number(20) not null, ref_no varchar2(20) not null, amount number(5,2) not null, stn_punit_id number(5) not null, convert_rate number(5,2) default null, convert_punit_id number(5) not null, dated date not null, app_sts_stn_lookup_dtl_id number(20) not null, CONSTRAINT ord_export_lc_crd_fk125 FOREIGN KEY(ord_export_lc_crd_id) REFERENCES ord_export_lc_crd, CONSTRAINT stn_lookup_dtl_fk125 FOREIGN KEY(doc_name_stn_lookup_dtl_id) REFERENCES stn_lookup_dtl, CONSTRAINT stn_lookup_dtl_fk155 FOREIGN KEY(app_sts_stn_lookup_dtl_id) REFERENCES stn_lookup_dtl, CONSTRAINT stn_punit_fk135 FOREIGN KEY(stn_punit_id) REFERENCES stn_punit, CONSTRAINT stn_punit_fk125 FOREIGN KEY(convert_punit_id) REFERENCES stn_punit, CONSTRAINT ord_export_lc_crd_dtl_pk PRIMARY KEY(id) )	all dependency table come from commercial
45	ord_export_lc_realize from Commercial Module	create table ord_export_lc_realize( id number(20) not null, cmc_letter_of_credit_id number(20) not null, stn_hrm_company_id number(20) not null, realize_date date not null, --CONSTRAINT cmc_letter_of_credit_fk FOREIGN KEY(cmc_letter_of_credit_id) REFERENCES cmc_letter_of_credit, CONSTRAINT stn_hrm_company_fk FOREIGN KEY(stn_hrm_company_id) REFERENCES stn_lookup_dtl, CONSTRAINT ord_export_lc_realize_pk PRIMARY KEY(id) )
46	ord_prod_challan from Production Module	create table ord_prod_challan( id number(20) not null, stn_hrm_company_id number(20) not null, ord_order_id number(20) not null, CONSTRAINT stn_hrm_company_fk_83 FOREIGN KEY(stn_hrm_company_id) REFERENCES stn_hrm_company, CONSTRAINT ord_order_fk_83 FOREIGN KEY(ord_order_id) REFERENCES ord_order, CONSTRAINT ord_prod_challan_pk PRIMARY KEY(id) )
47	ord_acc_payment_vc from Account Module	create table ord_acc_payment_vc( id number(20) not null, stn_hrm_company_id number(20) not null, acc_payment_vc_id number(20) not null, CONSTRAINT stn_hrm_company_fk126 FOREIGN KEY(stn_hrm_company_id) REFERENCES stn_hrm_company, --CONSTRAINT acc_payment_vc_fk126 FOREIGN KEY(acc_payment_vc_id) REFERENCES acc_payment_vc, CONSTRAINT ord_acc_payment_vc_pk PRIMARY KEY(id) )
48	ord_acc_receive_vc from Account Module	create table ord_acc_receive_vc( id number(20) not null, stn_hrm_company_id number(20) not null, acc_receive_vc_id number(20) not null, CONSTRAINT stn_hrm_company_fk333 FOREIGN KEY(stn_hrm_company_id) REFERENCES stn_hrm_company, --CONSTRAINT acc_receive_vc_fk333 FOREIGN KEY(acc_receive_vc_id) REFERENCES acc_receive_vc, CONSTRAINT ord_acc_receive_vc_pk PRIMARY KEY(id) )
Batch info come from production module

Latest Tutorial