Order Table List

By ukmodak | April 1st 2024 12:11:14 PM | viewed 290 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 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
bONEandALL
Visitor

Total : 20167

Today :14

Today Visit Country :

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