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 primary

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

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 primary

ISAM
cust_ser_no

Description:
Table for the information of the customer.

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 primary

ISAM
dc_ser_no
dc_seq_no

Description:
DC_DETAIL contains the details of the master table DC_MASTER.

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 primary

ISAM
dc_ser_no

Description:
DC_MASTER is the master table for the delivery of material to the customer against the work order.

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 primary

ISAM
gia_ser_no
gia_seq_no

Description:
GIA_DETAIL contains the details of the manufactured items which are received corresponding to its GIA_MASTER.

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 primary

ISAM
gia_ser_no

Description:
Master table of the GIA_DEATIL contains the main data about the items received after manufacturing of items.

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 primary

ISAM
inv_seq_no
inv_ser_no

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 primary

ISAM
inv_ser_no

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 primary

ISAM
iss_seq_no
iss_ser_no

Description:
ISSUE_DETAIL contains the detail of ISSUE_MASTER ,i.e, details of issue of items for manufacturing.

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 primary

ISAM
iss_ser_no

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 primary

ISAM
for_item_no
item_ser_no

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 primary

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

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 primary

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

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 primary

ISAM
item_ser_no

Description:
This table contains all information about Items.It is master table of the Items_detail table.

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 primary

ISAM
mo_seq_no
mo_ser_no

Description:
MO_DETAIL contains the details of manufacturing order corresponding to its MO_MASTER.

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 primary

ISAM
mo_ser_no

Description:
Master table for manufacturing order of items.

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 primary

ISAM
mrn_seq_no
mrn_ser_no

Description:
MRN_DETAIL contains the details of the material return corresponding to its MRN_MASTER.

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 primary

ISAM
mrn_ser_no

Description:
Master table for return of material which was issued to a work order.

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 primary

ISAM
po_seq_no
po_ser_no

Description:
PO_DETAIL contains the details of purchase order corresponding to its PO_MASTER.

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 primary

ISAM
po_ser_no

Description:
PO_MASTER is the master table of PO_DETAIL contains main information regarding purchase order.

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 primary

ISAM
po_seq_no
po_ser_no

Description:
PR_DETAIL contains the details of received items corresponding to its PR_MASTER table.

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 primary

ISAM
pr_ser_no

Description:
This is master table of the purchase receipts which contains the information of received items against purchase order.

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 primary

ISAM
super_alt_seq_no
super_alt_ser_no

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 primary

ISAM
super_alt_ser_no

uom char(5) NOT NULL
desc char(30) NOT NULL

Primary key: Uom primary

ISAM
uom

Description:
Table contains unit of measurement used for the items.

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 primary

ISAM
vend_ser_no

Description:
Table contains information about vendors.

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 primary

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

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 primary

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

wpo_ser_no int NOT NULL
total_amt double NOT NULL
doc_type char(20) NOT NULL

Primary key: Wpo totals primary

ISAM
wpo_ser_no
doc_type

From: bom_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_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_master
To: bom_detail
bom_master.bom_ser_no
bom_detail.bom_ser_no

From: customers
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: customers
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: customers
To: wpo_master
customers.cust_ser_no
wpo_master.cust_ser_no
customers.customer_code
wpo_master.customer_code

From: dc_master
To: dc_detail
dc_master.dc_ser_no
dc_detail.dc_ser_no

From: gia_master
To: gia_detail
gia_master.gia_ser_no
gia_detail.gia_ser_no

From: gia_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_master
To: invoice_detail
invoice_master.inv_ser_no
invoice_detail.inv_ser_no

From: issue_detail
To: issue_sa_detail
issue_detail.item_ser_no
issue_sa_detail.for_item_no

From: issue_detail
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_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_master
To: issue_detail
issue_master.iss_ser_no
issue_detail.iss_ser_no

From: issue_detail
To: item_mon_totals
issue_detail.item_ser_no
item_mon_totals.item_ser_no
issue_detail.uom
item_mon_totals.uom

From: wpo_totals
To: issue_master
wpo_totals.wpo_ser_no
issue_master.wpo_ser_no

From: items_master
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_master
To: item_mon_totals
items_master.item_ser_no
item_mon_totals.item_ser_no
items_master.uom
item_mon_totals.uom

From: items_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_master
To: super_alt_master
items_master.item_ser_no
super_alt_master.item_ser_no
items_master.uom
super_alt_master.uom

From: items_master
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_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_master
To: mo_detail
mo_master.mo_ser_no
mo_detail.mo_ser_no

From: mo_master
To: wpo_totals
mo_master.wpo_ser_no
wpo_totals.wpo_ser_no

From: mrn_master
To: mrn_detail
mrn_master.mrn_ser_no
mrn_detail.mrn_ser_no

From: mrn_detail
To: item_mon_totals
mrn_detail.item_ser_no
item_mon_totals.item_ser_no
mrn_detail.uom
item_mon_totals.uom

From: mrn_master
To: wpo_totals
mrn_master.from_wpo_ser
wpo_totals.wpo_ser_no

From: 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_master
To: po_detail
po_master.po_ser_no
po_detail.po_ser_no

From: po_master
To: pr_master
po_master.vend_ser_no
pr_master.vend_ser_no
po_master.vendor_code
pr_master.vendor_code

From: po_master
To: wpo_totals
po_master.wpo_ser_no
wpo_totals.wpo_ser_no

From: pr_master
To: pr_detail
pr_master.pr_ser_no
pr_detail.pr_ser_no

From: pr_detail
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_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_master
To: super_alt_detail
super_alt_master.super_alt_ser_no
super_alt_detail.super_alt_ser_no

From: uom
To: items_master
uom.uom
items_master.uom

From: vendors
To: po_master
vendors.vend_ser_no
po_master.vend_ser_no
vendors.vendor_code
po_master.vendor_code

From: wpo_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_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_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_detail
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_detail
To: items_master

From: wpo_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_detail
To: mrn_detail
wpo_detail.wpo_seq_no
mrn_detail.from_wpo_seq

From: wpo_detail
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_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_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_master
To: issue_master
wpo_master.wpo_ser_no
issue_master.wpo_ser_no

From: wpo_master
To: mo_master
wpo_master.wpo_ser_no
mo_master.wpo_ser_no

From: wpo_master
To: mrn_master
wpo_master.wpo_ser_no
mrn_master.from_wpo_ser

From: wpo_master
To: po_master
wpo_master.wpo_ser_no
po_master.wpo_ser_no

From: wpo_master
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

customers

first_name
cust_ser_no
middle_name

issue_detail

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