Sheet:
Context
Entities: (30)
1. bom_detail
bom_seq_no int NOT NULL
bom_ser_no int NOT NULL
child_code char(10) NOT NULL
child_item_no int NOT NULL
child_qty double NOT NULL
child_uom char(5) NOT NULL
group_no int NOT NULL
labour_required int NOT NULL
parent_code char(10) NOT NULL
parent_item_no int NOT NULL
parent_qty double NOT NULL
parent_uom char(5) NOT NULL
part_type char(1) NOT NULL
subgroup_no int NOT NULL
Primary key: Bom detail primaryISAM UNIQUE
bom_seq_no
bom_ser_no
Location: Disk1Space
Description:
It is detail table of the bill of material of its master one.
Related Objects:2. bom_master
Entity: bom_master
Relationship: BOM_MASTER+BOM_DETAIL
Cardinality: OneToMany
Entity: issue_detail
Relationship: BOM_DETAIL+ISSUE_DETAIL
Cardinality: OneToMany
bom_date date NOT NULL
bom_ser_no int NOT NULL
wpo_ser_no int NOT NULL
wpo_seq_no int NOT NULL
item_ser_no int NOT NULL
item_code char(10) NOT NULL
Primary key: Bom master primaryISAM
bom_ser_no
Description:
It is master table of the bill of material contains work order number and date for which this bill of material is created.
Related Objects:3. customers
Entity: bom_detail
Relationship: BOM_MASTER+BOM_DETAIL
Cardinality: OneToMany
address char(40) NOT NULL
city char(30) NOT NULL
country char(30) NOT NULL
cust_ser_no int NOT NULL
last_name char(30)
first_name char(30) NOT NULL
phone_no char(20)
pincode char(10)
state char(30) NOT NULL
middle_name char(30)
customer_code char(10) NOT NULL
remarks char(30)
Primary key: Customers primaryISAM
cust_ser_no
Description:
Table for the information of the customer.
Related Objects:4. dc_detail
Entity: dc_master
Relationship: CUSTOMERS+DC_MASTER
Cardinality: OneToMany
Entity: invoice_master
Relationship: CUSTOMERS+INV_MASTER
Cardinality: OneToMany
Entity: wpo_master
Relationship: CUSTOMERS+WPO_MASTER
Cardinality: OneToMany
item_ser_no int NOT NULL
dc_qty double NOT NULL
dc_seq_no int NOT NULL
uom char(5) NOT NULL
dc_ser_no int NOT NULL
item_code char(10) NOT NULL
wpo_seq_no int NOT NULL
Primary key: Dc detail primaryISAM
dc_ser_no
dc_seq_no
Description:
DC_DETAIL contains the details of the master table DC_MASTER.
Related Objects:5. dc_master
Entity: dc_master
Relationship: DC_MASTER+DC_DETAIL
Cardinality: OneToMany
Entity: wpo_detail
Relationship: WPO_DETAIL+DC_DETAIL
Cardinality: OneToMany
dc_ser_no int NOT NULL
dc_date date NOT NULL
cust_ser_no int NOT NULL
desc char(30) NOT NULL
customer_code char(10) NOT NULL
wpo_ser_no int NOT NULL
address char(40) NOT NULL
pincode char(10)
first_name char(30) NOT NULL
last_name char(30)
city char(30) NOT NULL
country char(30) NOT NULL
Primary key: Dc master primaryISAM
dc_ser_no
Description:
DC_MASTER is the master table for the delivery of material to the customer against the work order.
Related Objects:6. gia_detail
Entity: dc_detail
Relationship: DC_MASTER+DC_DETAIL
Cardinality: OneToMany
Entity: wpo_master
Relationship: WPO_MASTER+DC_MASTER
Cardinality: OneToMany
Entity: customers
Relationship: CUSTOMERS+DC_MASTER
Cardinality: OneToMany
gia_seq_no int NOT NULL
gia_ser_no int NOT NULL
item_ser_no int NOT NULL
gia_rate double NOT NULL
gia_value double NOT NULL
gia_qty double NOT NULL
uom char(5) NOT NULL
item_code char(10) NOT NULL
delay int
mo_ser_no int NOT NULL
mo_seq_no int NOT NULL
Primary key: Gia detail primaryISAM
gia_ser_no
gia_seq_no
Description:
GIA_DETAIL contains the details of the manufactured items which are received corresponding to its GIA_MASTER.
Related Objects:7. gia_master
Entity: gia_master
Relationship: GIA_MASTER+GIA_DETAIL
Cardinality: OneToMany
Entity: item_mon_totals
Relationship: GIA+ITEM_MON
Cardinality: OneToMany
Entity: mo_detail
Relationship: MO_DETAIL+GIA_DETAIL
Cardinality: OneToMany
gia_ser_no int NOT NULL
gia_date date NOT NULL
total_value double NOT NULL
desc char(30) NOT NULL
Primary key: Gia master primaryISAM
gia_ser_no
Description:
Master table of the GIA_DEATIL contains the main data about the items received after manufacturing of items.
Related Objects:8. invoice_detail
Entity: gia_detail
Relationship: GIA_MASTER+GIA_DETAIL
Cardinality: OneToMany
inv_ser_no int NOT NULL
inv_seq_no int NOT NULL
item_ser_no int NOT NULL
item_code char(10) NOT NULL
inv_qty double NOT NULL
inv_value double NOT NULL
excise_duty double NOT NULL
tax double NOT NULL
total_value double NOT NULL
wpo_seq_no int NOT NULL
inv_rate double NOT NULL
uom char(5) NOT NULL
Primary key: Inv detail primaryISAM
inv_seq_no
inv_ser_no
Related Objects:9. invoice_master
Entity: invoice_master
Relationship: INV_MASTER+INV_DETAIL
Cardinality: OneToMany
Entity: wpo_detail
Relationship: WPO_DETAIL+INV_DETAIL
Cardinality: OneToMany
inv_ser_no int NOT NULL
inv_date date NOT NULL
customer_code char(10) NOT NULL
cust_ser_no int NOT NULL
first_name char(30) NOT NULL
last_name char(30)
address char(40) NOT NULL
city char(30) NOT NULL
country char(30) NOT NULL
pincode char(10)
desc char(30) NOT NULL
wpo_ser_no int NOT NULL
total_amt double NOT NULL
trans_cost double NOT NULL
Primary key: Inv master primaryISAM
inv_ser_no
Related Objects:10. issue_detail
Entity: invoice_detail
Relationship: INV_MASTER+INV_DETAIL
Cardinality: OneToMany
Entity: customers
Relationship: CUSTOMERS+INV_MASTER
Cardinality: OneToMany
Entity: wpo_master
Relationship: WPO_MASTER+INV_MASTER
Cardinality: OneToMany
issue_qty double NOT NULL
item_ser_no int NOT NULL
iss_seq_no int NOT NULL
iss_rate double NOT NULL
iss_value double NOT NULL
iss_ser_no int NOT NULL
uom char(5) NOT NULL
item_code char(10) NOT NULL
wpo_seq_no int NOT NULL
issue_type char(2) NOT NULL
Primary key: Issue detail primaryISAM
iss_seq_no
iss_ser_no
Description:
ISSUE_DETAIL contains the detail of ISSUE_MASTER ,i.e, details of issue of items for manufacturing.
Related Objects:11. issue_master
Entity: issue_master
Relationship: ISSUE_MASTER+ISSUE_DETAIL
Cardinality: OneToMany
Entity: item_mon_totals
Relationship: ISSUE+ITEM_MON
Cardinality: OneToManyZero
Entity: issue_sa_detail
Relationship: ISSUE_DETAIL+ISSUE_SA
Cardinality: OneToMany
desc char(30) NOT NULL
iss_ser_no int NOT NULL
issue_date date NOT NULL
total_value double NOT NULL
wpo_ser_no int NOT NULL
Primary key: Issue master primaryISAM
iss_ser_no
Related Objects:12. issue_sa_detail
Entity: issue_detail
Relationship: ISSUE_MASTER+ISSUE_DETAIL
Cardinality: OneToMany
item_ser_no int NOT NULL
qty double NOT NULL
uom char(5) NOT NULL
for_item_no int NOT NULL
Primary key: Issue SA primaryISAM
for_item_no
item_ser_no
Related Objects:13. item_mon_totals
Entity: issue_detail
Relationship: ISSUE_DETAIL+ISSUE_SA
Cardinality: OneToMany
Entity: super_alt_detail
Relationship: SA_DETAIL+ISSUE_SA
Cardinality: OneToMany
opening_balance_qty double NOT NULL
opening_balance_value double NOT NULL
item_ser_no int NOT NULL
current_year int
uom char(5) NOT NULL
month_idx char(25) NOT NULL
Primary key: Item mon totals primaryISAM
current_year
month_idx
item_ser_no
Description:
This table contains the present inventory level with all transcations,i.e, opening balance of Qty and value.
Related Objects:14. items_detail
Entity: issue_detail
Relationship: ISSUE+ITEM_MON
Cardinality: OneToManyZero
Entity: items_master
Relationship: ITEMS_MASTER+ITEM_MON
Cardinality: OneToMany
item_ser_no int NOT NULL
item_code char(10) NOT NULL
item_qty double NOT NULL
labour_required int NOT NULL
child_uom char(5) NOT NULL
child_item_no int NOT NULL
child_code char(10) NOT NULL
child_qty double NOT NULL
part_type char(1) NOT NULL
uom char(5) NOT NULL
Primary key: Items detail primaryISAM
child_item_no
item_ser_no
Description:
Details of item_master gives information about further explosion of all the manufacturing items in terms of items required and Qty. required to produce an item.
Related Objects:15. items_master
Entity: items_master
Relationship: ITEMS_MAS+ITEMS_DET
Cardinality: OneToMany
Entity: items_master
Relationship: ITEMS+CHILD
Cardinality: OneToMany
item_ser_no int NOT NULL
item_desc char(50) NOT NULL
uom char(5) NOT NULL
lead_time int NOT NULL
ord_level double NOT NULL
min_level double NOT NULL
max_level double NOT NULL
part_type char(1) NOT NULL
item_code char(10) NOT NULL
unit_cost double NOT NULL
unit_price double NOT NULL
latest_exp date
exp_qty double
Primary key: Items master primaryISAM
item_ser_no
Description:
This table contains all information about Items.It is master table of the Items_detail table.
Related Objects:16. mo_detail
Entity: items_detail
Relationship: ITEMS_MAS+ITEMS_DET
Cardinality: OneToMany
Entity: items_detail
Relationship: ITEMS+CHILD
Cardinality: OneToMany
Entity: uom
Relationship: UOM+ITEMS_MASTER
Cardinality: OneToManyZero
Entity: super_alt_detail
Relationship: ITEMS_MASTER+SUPER_ALT_DETAIL
Cardinality: OneToMany
Entity: super_alt_master
Relationship: ITEMS_MASTER+SUPER_ALT_MASTER
Cardinality: OneToMany
Entity: item_mon_totals
Relationship: ITEMS_MASTER+ITEM_MON
Cardinality: OneToMany
mo_ser_no int NOT NULL
item_ser_no int NOT NULL
mo_qty double NOT NULL
mo_seq_no int NOT NULL
uom char(5) NOT NULL
item_code char(10) NOT NULL
wpo_seq_no int NOT NULL
received_qty double NOT NULL
received_value double NOT NULL
Primary key: Mo detail primaryISAM
mo_seq_no
mo_ser_no
Description:
MO_DETAIL contains the details of manufacturing order corresponding to its MO_MASTER.
Related Objects:17. mo_master
Entity: mo_master
Relationship: MO_MASTER+MO_DETAIL
Cardinality: OneToMany
mo_date date NOT NULL
mo_status char(1) NOT NULL
mo_ser_no int NOT NULL
desc char(30) NOT NULL
expected_manu_date date
wpo_ser_no int NOT NULL
Primary key: Mo master primaryISAM
mo_ser_no
Description:
Master table for manufacturing order of items.
Related Objects:18. mrn_detail
Entity: mo_detail
Relationship: MO_MASTER+MO_DETAIL
Cardinality: OneToMany
Entity: wpo_totals
Relationship: MO+WPO_TOTALS
Cardinality: OneToMany
mrn_ser_no int NOT NULL
mrn_qty double NOT NULL
item_ser_no int NOT NULL
mrn_seq_no int NOT NULL
mrn_value double NOT NULL
uom char(5) NOT NULL
item_code char(10) NOT NULL
mrn_rate double NOT NULL
from_wpo_seq int NOT NULL
Primary key: Mrn detail primaryISAM
mrn_seq_no
mrn_ser_no
Description:
MRN_DETAIL contains the details of the material return corresponding to its MRN_MASTER.
Related Objects:19. mrn_master
Entity: mrn_master
Relationship: MRN_MASTER+MRN_DETAIL
Cardinality: OneToMany
Entity: item_mon_totals
Relationship: MRN+ITEM_MON
Cardinality: OneToMany
Entity: issue_detail
Relationship: ISSUE_DETAIL+MRN_DETAIL
Cardinality: OneToMany
Entity: wpo_detail
Relationship: WPO_DETAIL+MRN_DETAIL
Cardinality: OneToMany
mrn_ser_no int NOT NULL
total_value double NOT NULL
mrn_date date NOT NULL
desc char(30) NOT NULL
from_wpo_ser int NOT NULL
Primary key: Mrn master primaryISAM
mrn_ser_no
Description:
Master table for return of material which was issued to a work order.
Related Objects:20. po_detail
Entity: mrn_detail
Relationship: MRN_MASTER+MRN_DETAIL
Cardinality: OneToMany
Entity: wpo_totals
Relationship: MRN+WPO_TOTALS
Cardinality: OneToMany
item_ser_no int NOT NULL
po_rate double NOT NULL
po_ser_no int NOT NULL
po_qty double NOT NULL
uom char(5) NOT NULL
po_seq_no int NOT NULL
item_code char(10) NOT NULL
po_item_status char(1) NOT NULL
po_value double
expected_rec_date date NOT NULL
wpo_seq_no int NOT NULL
received_qty double NOT NULL
received_value double NOT NULL
Primary key: Po detail primaryISAM
po_seq_no
po_ser_no
Description:
PO_DETAIL contains the details of purchase order corresponding to its PO_MASTER.
Related Objects:21. po_master
Entity: po_master
Relationship: PO_MASTER+PO_DETAIL
Cardinality: OneToMany
Entity: pr_detail
Relationship: PO_DETAIL+PR_DETAIL
Cardinality: OneToMany
Entity: bom_detail
Relationship: BOM_DETAIL+PO_DETAIL
Cardinality: OneToMany
po_ser_no int NOT NULL
po_status char(1) NOT NULL
vend_ser_no int NOT NULL
po_date date NOT NULL
desc char(30) NOT NULL
payment_mode char(20) NOT NULL
vendor_code char(10) NOT NULL
total_value double NOT NULL
wpo_ser_no int NOT NULL
Primary key: Po master primaryISAM
po_ser_no
Description:
PO_MASTER is the master table of PO_DETAIL contains main information regarding purchase order.
Related Objects:22. pr_detail
Entity: po_detail
Relationship: PO_MASTER+PO_DETAIL
Cardinality: OneToMany
Entity: wpo_totals
Relationship: PO+WPO_TOTALS
Cardinality: OneToMany
Entity: pr_master
Relationship: PO_MASTER+PR_MASTER
Cardinality: OneToMany
Entity: vendors
Relationship: VENDORS+PO_MASTER
Cardinality: OneToMany
item_ser_no int NOT NULL
pr_rate double NOT NULL
pr_value double
pr_ser_no int NOT NULL
pr_seq_no int NOT NULL
pr_qty double NOT NULL
uom char(5) NOT NULL
item_code char(10) NOT NULL
delay int
expiry_date date
po_ser_no int NOT NULL
po_seq_no int NOT NULL
Primary key: Pr detail primaryISAM
po_seq_no
po_ser_no
Description:
PR_DETAIL contains the details of received items corresponding to its PR_MASTER table.
Related Objects:23. pr_master
Entity: pr_master
Relationship: PR_MASTER+PR_DETAIL
Cardinality: OneToMany
Entity: po_detail
Relationship: PO_DETAIL+PR_DETAIL
Cardinality: OneToMany
Entity: item_mon_totals
Relationship: PR+ITEM_MON
Cardinality: OneToMany
total_value double NOT NULL
pr_date date NOT NULL
pr_ser_no int NOT NULL
desc char(30) NOT NULL
vend_ser_no int NOT NULL
vendor_code char(10) NOT NULL
Primary key: Pr master primaryISAM
pr_ser_no
Description:
This is master table of the purchase receipts which contains the information of received items against purchase order.
Related Objects:24. super_alt_detail
Entity: pr_detail
Relationship: PR_MASTER+PR_DETAIL
Cardinality: OneToMany
Entity: po_master
Relationship: PO_MASTER+PR_MASTER
Cardinality: OneToMany
super_alt_seq_no int NOT NULL
super_alt_ser_no int NOT NULL
uom char(5) NOT NULL
qty double NOT NULL
item_ser_no int NOT NULL
Primary key: SA detail primaryISAM
super_alt_seq_no
super_alt_ser_no
Related Objects:25. super_alt_master
Entity: super_alt_master
Relationship: SA_MASTER+SA_DETAIL
Cardinality: OneToMany
Entity: issue_sa_detail
Relationship: SA_DETAIL+ISSUE_SA
Cardinality: OneToMany
Entity: items_master
Relationship: ITEMS_MASTER+SUPER_ALT_DETAIL
Cardinality: OneToMany
item_ser_no int NOT NULL
replace_status char(1) NOT NULL
replace_tag char(1) NOT NULL
super_alt_ser_no int NOT NULL
uom char(5) NOT NULL
qty double NOT NULL
Primary key: SA master primaryISAM
super_alt_ser_no
Related Objects:26. uom
Entity: super_alt_detail
Relationship: SA_MASTER+SA_DETAIL
Cardinality: OneToMany
Entity: issue_detail
Relationship: ISSUE_DETAIL+SUPER_ALT_MASTER
Cardinality: OneToMany
Entity: items_master
Relationship: ITEMS_MASTER+SUPER_ALT_MASTER
Cardinality: OneToMany
uom char(5) NOT NULL
desc char(30) NOT NULL
Primary key: Uom primaryISAM
uom
Description:
Table contains unit of measurement used for the items.
Related Objects:27. vendors
Entity: items_master
Relationship: UOM+ITEMS_MASTER
Cardinality: OneToManyZero
vend_ser_no int NOT NULL
state char(30) NOT NULL
pincode char(10)
phone_no char(20)
last_name char(30)
first_name char(30) NOT NULL
country char(30) NOT NULL
city char(30) NOT NULL
address char(40) NOT NULL
middle_name char(30)
vendor_code char(10) NOT NULL
remarks char(30)
Primary key: Vendors primaryISAM
vend_ser_no
Description:
Table contains information about vendors.
Related Objects:28. wpo_detail
Entity: po_master
Relationship: VENDORS+PO_MASTER
Cardinality: OneToMany
wpo_ser_no int NOT NULL
wpo_seq_no int NOT NULL
wpo_qty double NOT NULL
item_ser_no int NOT NULL
item_code char(10) NOT NULL
unit_price double NOT NULL
wpo_uom char(5) NOT NULL
wpo_price double NOT NULL
expect_del_date date NOT NULL
wpo_part_type char(1) NOT NULL
wpo_item_status char(1) NOT NULL
balance_qty double NOT NULL
Primary key: Wpo detail primaryISAM
wpo_ser_no
wpo_seq_no
Description:
WPO_DETAIL is the detail table of its master WPO_MASTER. Gives details regarding children items, Qty & UOM of the work order Item.
Related Objects:29. wpo_master
Entity: issue_detail
Relationship: WPO_DETAIL+ISSUE_DETAIL
Cardinality: OneToMany
Entity: mo_detail
Relationship: WPO_DETAIL+MO_DETAIL
Cardinality: OneToMany
Entity: po_detail
Relationship: WPO_DETAIL+PO_DETAIL
Cardinality: OneToMany
Entity: bom_master
Relationship: WPO_DETAIL+BOM_MASTER
Cardinality: OneToMany
Entity: items_master
Relationship: WPO_DETAIL+ITEMS_MASTER
Cardinality: OneToMany
cust_ser_no int NOT NULL
customer_code char(10) NOT NULL
desc char(30) NOT NULL
payment_cond char(30) NOT NULL
payment_mode char(20) NOT NULL
total_price double NOT NULL
wpo_code char(10) NOT NULL
wpo_date date NOT NULL
wpo_ser_no int NOT NULL
wpo_status char(1) NOT NULL
Primary key: Wpo master primaryISAM
wpo_ser_no
Location: Disk1Space
Trigger: Trigger1 on wpo_master
Description:
Master table for WPO_DETAIL, which contains the broad view of the work order.
Related Objects:30. wpo_totals
Entity: dc_master
Relationship: WPO_MASTER+DC_MASTER
Cardinality: OneToMany
Entity: mo_master
Relationship: WPO_MASTER+MO_MASTER
Cardinality: OneToMany
Entity: issue_master
Relationship: WPO_MASTER+ISSUE_MASTER
Cardinality: OneToMany
Entity: mrn_master
Relationship: WPO_MASTER+MRN_MASTER
Cardinality: OneToMany
Entity: wpo_totals
Relationship: WPO_MASTER+WPO_TOTALS
Cardinality: OneToMany
Entity: invoice_master
Relationship: WPO_MASTER+INV_MASTER
Cardinality: OneToMany
Entity: customers
Relationship: CUSTOMERS+WPO_MASTER
Cardinality: OneToMany
Entity: po_master
Relationship: WPO_MASTER+PO_MASTER
Cardinality: OneToMany
Entity: wpo_detail
Relationship: WPO_MASTER+WPO_DETAIL
Cardinality: OneToMany
wpo_ser_no int NOT NULL
total_amt double NOT NULL
doc_type char(20) NOT NULL
Primary key: Wpo totals primaryISAM
wpo_ser_no
doc_type
Related Objects:
Entity: issue_master
Relationship: ISSUE+WPO_TOTALS
Cardinality: OneToMany
Entity: mrn_master
Relationship: MRN+WPO_TOTALS
Cardinality: OneToMany
From: bom_detail2. BOM_DETAIL+PO_DETAIL
To: issue_detail
bom_detail.item_code
issue_detail.child_code
bom_detail.item_ser_no
issue_detail.child_item_no
bom_detail.child_uom
issue_detail.uom
From: bom_detail3. BOM_MASTER+BOM_DETAIL
To: po_detail
bom_detail.item_ser_no
po_detail.child_item_no
bom_detail.item_code
po_detail.child_code
bom_detail.uom
po_detail.child_uom
From: bom_master4. CUSTOMERS+DC_MASTER
To: bom_detail
bom_master.bom_ser_no
bom_detail.bom_ser_no
From: customers5. CUSTOMERS+INV_MASTER
To: dc_master
customers.address
dc_master.address
customers.first_name
dc_master.first_name
customers.last_name
dc_master.last_name
customers.pincode
dc_master.pincode
customers.cust_ser_no
dc_master.cust_ser_no
customers.city
dc_master.city
customers.country
dc_master.country
From: customers6. CUSTOMERS+WPO_MASTER
To: invoice_master
customers.cust_ser_no
invoice_master.cust_ser_no
customers.first_name
invoice_master.first_name
customers.last_name
invoice_master.last_name
customers.pincode
invoice_master.pincode
customers.address
invoice_master.address
customers.city
invoice_master.city
customers.country
invoice_master.country
From: customers7. DC_MASTER+DC_DETAIL
To: wpo_master
customers.cust_ser_no
wpo_master.cust_ser_no
customers.customer_code
wpo_master.customer_code
From: dc_master8. GIA_MASTER+GIA_DETAIL
To: dc_detail
dc_master.dc_ser_no
dc_detail.dc_ser_no
From: gia_master9. GIA+ITEM_MON
To: gia_detail
gia_master.gia_ser_no
gia_detail.gia_ser_no
From: gia_detail10. INV_MASTER+INV_DETAIL
To: item_mon_totals
gia_detail.item_ser_no
item_mon_totals.item_ser_no
gia_detail.uom
item_mon_totals.uom
From: invoice_master11. ISSUE_DETAIL+ISSUE_SA
To: invoice_detail
invoice_master.inv_ser_no
invoice_detail.inv_ser_no
From: issue_detail12. ISSUE_DETAIL+MRN_DETAIL
To: issue_sa_detail
issue_detail.item_ser_no
issue_sa_detail.for_item_no
From: issue_detail13. ISSUE_DETAIL+SUPER_ALT_MASTER
To: mrn_detail
issue_detail.item_ser_no
mrn_detail.item_ser_no
issue_detail.item_code
mrn_detail.item_code
issue_detail.uom
mrn_detail.uom
From: issue_detail14. ISSUE_MASTER+ISSUE_DETAIL
To: super_alt_master
issue_detail.item_ser_no
super_alt_master.item_ser_no
issue_detail.uom
super_alt_master.uom
From: issue_master15. ISSUE+ITEM_MON
To: issue_detail
issue_master.iss_ser_no
issue_detail.iss_ser_no
From: issue_detail16. ISSUE+WPO_TOTALS
To: item_mon_totals
issue_detail.item_ser_no
item_mon_totals.item_ser_no
issue_detail.uom
item_mon_totals.uom
From: wpo_totals17. ITEMS_MAS+ITEMS_DET
To: issue_master
wpo_totals.wpo_ser_no
issue_master.wpo_ser_no
From: items_master18. ITEMS_MASTER+ITEM_MON
To: items_detail
items_master.item_code
items_detail.item_code
items_master.item_ser_no
items_detail.item_ser_no
items_master.uom
items_detail.uom
From: items_master19. ITEMS_MASTER+SUPER_ALT_DETAIL
To: item_mon_totals
items_master.item_ser_no
item_mon_totals.item_ser_no
items_master.uom
item_mon_totals.uom
From: items_master20. ITEMS_MASTER+SUPER_ALT_MASTER
To: super_alt_detail
items_master.item_ser_no
super_alt_detail.item_ser_no
items_master.uom
super_alt_detail.uom
From: items_master21. ITEMS+CHILD
To: super_alt_master
items_master.item_ser_no
super_alt_master.item_ser_no
items_master.uom
super_alt_master.uom
From: items_master22. MO_DETAIL+GIA_DETAIL
To: items_detail
items_master.item_ser_no
items_detail.child_item_no
items_master.item_code
items_detail.child_code
items_master.uom
items_detail.child_uom
From: mo_detail23. MO_MASTER+MO_DETAIL
To: gia_detail
mo_detail.mo_ser_no
gia_detail.mo_ser_no
mo_detail.mo_seq_no
gia_detail.mo_seq_no
mo_detail.item_ser_no
gia_detail.item_ser_no
mo_detail.uom
gia_detail.uom
mo_detail.item_code
gia_detail.item_code
mo_detail.received_qty
gia_detail.gia_qty
mo_detail.received_value
gia_detail.gia_value
From: mo_master24. MO+WPO_TOTALS
To: mo_detail
mo_master.mo_ser_no
mo_detail.mo_ser_no
From: mo_master25. MRN_MASTER+MRN_DETAIL
To: wpo_totals
mo_master.wpo_ser_no
wpo_totals.wpo_ser_no
From: mrn_master26. MRN+ITEM_MON
To: mrn_detail
mrn_master.mrn_ser_no
mrn_detail.mrn_ser_no
From: mrn_detail27. MRN+WPO_TOTALS
To: item_mon_totals
mrn_detail.item_ser_no
item_mon_totals.item_ser_no
mrn_detail.uom
item_mon_totals.uom
From: mrn_master28. PO_DETAIL+PR_DETAIL
To: wpo_totals
mrn_master.from_wpo_ser
wpo_totals.wpo_ser_no
From: po_detail29. PO_MASTER+PO_DETAIL
To: pr_detail
po_detail.po_seq_no
pr_detail.po_seq_no
po_detail.po_ser_no
pr_detail.po_ser_no
po_detail.item_ser_no
pr_detail.item_ser_no
po_detail.item_code
pr_detail.item_code
po_detail.uom
pr_detail.uom
po_detail.received_qty
pr_detail.pr_qty
po_detail.received_value
pr_detail.pr_value
From: po_master30. PO_MASTER+PR_MASTER
To: po_detail
po_master.po_ser_no
po_detail.po_ser_no
From: po_master31. PO+WPO_TOTALS
To: pr_master
po_master.vend_ser_no
pr_master.vend_ser_no
po_master.vendor_code
pr_master.vendor_code
From: po_master32. PR_MASTER+PR_DETAIL
To: wpo_totals
po_master.wpo_ser_no
wpo_totals.wpo_ser_no
From: pr_master33. PR+ITEM_MON
To: pr_detail
pr_master.pr_ser_no
pr_detail.pr_ser_no
From: pr_detail34. SA_DETAIL+ISSUE_SA
To: item_mon_totals
pr_detail.item_ser_no
item_mon_totals.item_ser_no
pr_detail.uom
item_mon_totals.uom
From: super_alt_detail35. SA_MASTER+SA_DETAIL
To: issue_sa_detail
super_alt_detail.item_ser_no
issue_sa_detail.item_ser_no
super_alt_detail.uom
issue_sa_detail.uom
From: super_alt_master36. UOM+ITEMS_MASTER
To: super_alt_detail
super_alt_master.super_alt_ser_no
super_alt_detail.super_alt_ser_no
From: uom37. VENDORS+PO_MASTER
To: items_master
uom.uom
items_master.uom
From: vendors38. WPO_DETAIL+BOM_MASTER
To: po_master
vendors.vend_ser_no
po_master.vend_ser_no
vendors.vendor_code
po_master.vendor_code
From: wpo_detail39. WPO_DETAIL+DC_DETAIL
To: bom_master
wpo_detail.wpo_seq_no
bom_master.wpo_seq_no
wpo_detail.wpo_ser_no
bom_master.wpo_ser_no
From: wpo_detail40. WPO_DETAIL+INV_DETAIL
To: dc_detail
wpo_detail.wpo_seq_no
dc_detail.wpo_seq_no
wpo_detail.item_ser_no
dc_detail.item_ser_no
wpo_detail.item_code
dc_detail.item_code
wpo_detail.wpo_uom
dc_detail.uom
From: wpo_detail41. WPO_DETAIL+ISSUE_DETAIL
To: invoice_detail
wpo_detail.wpo_seq_no
invoice_detail.wpo_seq_no
wpo_detail.item_ser_no
invoice_detail.item_ser_no
wpo_detail.item_code
invoice_detail.item_code
wpo_detail.wpo_uom
invoice_detail.uom
From: wpo_detail42. WPO_DETAIL+ITEMS_MASTER
To: issue_detail
wpo_detail.item_ser_no
issue_detail.item_ser_no
wpo_detail.item_code
issue_detail.item_code
wpo_detail.wpo_uom
issue_detail.uom
wpo_detail.wpo_seq_no
issue_detail.wpo_seq_no
From: wpo_detail43. WPO_DETAIL+MO_DETAIL
To: items_master
From: wpo_detail44. WPO_DETAIL+MRN_DETAIL
To: mo_detail
wpo_detail.wpo_seq_no
mo_detail.wpo_seq_no
wpo_detail.item_ser_no
mo_detail.item_ser_no
wpo_detail.item_code
mo_detail.item_code
wpo_detail.wpo_uom
mo_detail.uom
From: wpo_detail45. WPO_DETAIL+PO_DETAIL
To: mrn_detail
wpo_detail.wpo_seq_no
mrn_detail.from_wpo_seq
From: wpo_detail46. WPO_MASTER+DC_MASTER
To: po_detail
wpo_detail.wpo_seq_no
po_detail.wpo_seq_no
wpo_detail.item_ser_no
po_detail.item_ser_no
wpo_detail.item_code
po_detail.item_code
wpo_detail.wpo_uom
po_detail.uom
From: wpo_master47. WPO_MASTER+INV_MASTER
To: dc_master
wpo_master.wpo_ser_no
dc_master.wpo_ser_no
wpo_master.customer_code
dc_master.customer_code
wpo_master.cust_ser_no
dc_master.cust_ser_no
From: wpo_master48. WPO_MASTER+ISSUE_MASTER
To: invoice_master
wpo_master.cust_ser_no
invoice_master.cust_ser_no
wpo_master.customer_code
invoice_master.customer_code
wpo_master.wpo_ser_no
invoice_master.wpo_ser_no
From: wpo_master49. WPO_MASTER+MO_MASTER
To: issue_master
wpo_master.wpo_ser_no
issue_master.wpo_ser_no
From: wpo_master50. WPO_MASTER+MRN_MASTER
To: mo_master
wpo_master.wpo_ser_no
mo_master.wpo_ser_no
From: wpo_master51. WPO_MASTER+PO_MASTER
To: mrn_master
wpo_master.wpo_ser_no
mrn_master.from_wpo_ser
From: wpo_master52. WPO_MASTER+WPO_DETAIL
To: po_master
wpo_master.wpo_ser_no
po_master.wpo_ser_no
From: wpo_master53. WPO_MASTER+WPO_TOTALS
To: wpo_detail
wpo_master.wpo_ser_no
wpo_detail.wpo_ser_no
From: wpo_master
To: wpo_totals
wpo_master.wpo_ser_no
wpo_totals.wpo_ser_no
customersfirst_nameissue_detail
cust_ser_no
middle_name
item_code
Replace If Exists
Check Option
Force Constraints:Laxman Gehlot
Where Clause:
Put Where Clause here
Description:
View is created for demonstration only
Source:
Procedure for execution
Description:
Procedure is created for demonstration only
Source:
Ascending Minimum: 1 Increment: 111 Maximum: 11111111 Intial: 11111 Cycle Values: Yes Order Values: Yes Cache: Default
Description:
Sequence is created for demonstration only
Source:
Create a Package For the said statement
Description:
Package is created for demonstration only
Source:
Function Definition
Description:
Function is created for demonstration only
On: wpo_master
Description:
Trigger Description
Description:
Disk1Space Description
Datafile:DatafileDisk1
Description:
DatafileDisk1 Description