Process:
Context
Local Data Flows: (4)
1. MANAGEMENT I/P(Composite)
From: MANAGEMENT [b]
To: INVENTORY SYSTEM [1]
ITEMS INFO
WORK ORDERS
No definition in Dict.
CUSTOMERS INFO
VENDORS INFO
UOM
SUPER_ALT_PARTS INFO
No definition in Dict.
PURCHASE ORDER
MO INFORMATION
ISSUE ITEMS
GIA INFO
MRN INFO
PR INFO
DELIVERY CHALLAN
INVOICE INFO
Description: Input information given by Management to Inventory System.
2. MANAGEMENT O/P(Composite)
From: INVENTORY SYSTEM [1]
To: MANAGEMENT [b]
COMPONENT STORE REPORT
PURCHASE ORDER REPORT
UNDER STOCK REPORT
CONSUMPTION REPORT
MO REPORT
UNMOVED ITEMS REPORT
OVER STOCK REPORT
BELOW ORDER REPORT
TESTING STORE REPORT
WORK ORDER ALLOCATION
STOCK LEDGER REPORT
Description: Output of Inventory System received by the Management as Reports.
3. USER I/P(Composite)
From: INVENTORY1 USER [a]
To: INVENTORY SYSTEM [1]
PURCHASE ORDER
PR INFO
UOM
SUPER_ALT_PARTS INFO
MO INFORMATION
WORK ORDERS
DELIVERY CHALLAN
MRN INFO
GIA INFO
No definition in Dict.
ISSUE ITEMS
CUSTOMERS INFO
VENDORS INFO
ITEMS INFO
No definition in Dict.
INVOICE INFO
Description: User Input Parameters
4. USER O/P(Composite)
From: INVENTORY SYSTEM [1]
To: INVENTORY1 USER [a]
WORK ORDER ALLOCATION
COMPONENT STORE REPORT
PURCHASE ORDER REPORT
UNDER STOCK REPORT
CONSUMPTION REPORT
MO REPORT
UNMOVED ITEMS REPORT
OVER STOCK REPORT
BELOW ORDER REPORT
TESTING STORE REPORT
STOCK LEDGER REPORT
Description: Output received by the User.
Exploded Processes (1)
1. INVENTORY SYSTEM [1]
Lowest Level Processes (0)
Undefined Processes (0)
External Entities (2)
1. INVENTORY1 USER [a]
Description: User of Inventory System.
2. MANAGEMENT [b]
Description: Management of organization.
Imported Entities: (0)
Data Store: (0)
Process:
INVENTORY SYSTEM [1]
Inventory system.
Imported Data Flows: (3)
1. MANAGEMENT O/P(Composite)
From: REPORTS [1.3]
To: MANAGEMENT [a]
2. USER I/P(Composite)
From: INVENTORY1 USER [1]
To: DATA ENTRY [1.1]
3. USER O/P(Composite)
From: DATA ENTRY [1.1]
To: INVENTORY1 USER [1]
Local Data Flows: (3)
1. INTERPROCESSINFO
From: PROCESSING [1.2]
To: REPORTS [1.3]
2. INTERPROCESSINFO
From: PROCESSING [1.2]
To: interprocessinfo [1/D1]
3. INVOICE INFO(Composite)
From: interprocessinfo [1/D1]
To: DATA ENTRY [1.1]
Exploded Processes (3)
1. Data Entry [1.1]
2. Processing [1.2]
3. Reports [1.3]
Lowest Level Processes (0)
Undefined Processes (0)
External Entities (2)
1. INVENTORY1 USER [1]
2. MANAGEMENT [a]
Imported Entities: (0)
Data Store: (1)
1. interprocessinfo [1/D1]
Process:
Data Entry [1.1]
Data entry of inventory.
Imported Data Flows: (14)
1. CUSTOMERS INFO
From: INVENTORY1 USER [1]
To: CUSTOMERS DATA ENTRY [1.1.2]
2. DELIVERY CHALLAN(Composite)
From & To: INVENTORY1 USER [1.1/a]
To & From: DELIVERY CHALLAN DATA ENTRY [1.1.13]
3. GIA INFO(Composite)
From & To: INVENTORY1 USER [1]
To & From: GOODS INWARD ADVICE DATA ENTRY [1.1.11]
4. INVOICE INFO(Composite)
From & To: INVENTORY1 USER [1]
To & From: INVOICE DATA ENTRY [1.1.14]
5. ISSUE ITEMS(Composite)
From & To: INVENTORY1 USER [1]
To & From: ISSUE ITEMS DATA ENTRY [1.1.9]
6. ITEMS INFO(Composite)
From & To: INVENTORY1 USER [1]
To & From: ITEMS DATA ENTRY [1.1.5]
7. MO INFORMATION(Composite)
From & To: INVENTORY1 USER [1]
To & From: MANUFACTURING ORDER DATA ENTRY [1.1.8]
8. MRN INFO(Composite)
From: INVENTORY1 USER [1]
To: MATERIAL RETURN NOTE [1.1.10]
9. PR INFO(Composite)
From & To: INVENTORY1 USER [1]
To & From: PURCHASE RECEIPTS DATA ENTRY [1.1.6]
10. PURCHASE ORDER(Composite)
From & To: INVENTORY1 USER [1]
To & From: PURCHASE ORDER DATA ENTRY [1.1.3]
11. SUPER_ALT_PARTS INFO
From & To: INVENTORY1 USER [1]
To & From: SUPERSEDING AND ALTERNATE PARTS DATA ENTRY [1.1.12]
12. UOM
From & To: INVENTORY1 USER [1]
To & From: UOM [1.1.4]
13. VENDORS INFO
From & To: INVENTORY1 USER [1]
To & From: VENDORS DATA ENTRY [1.1.7]
14. WORK ORDERS(Composite)
From & To: INVENTORY1 USER [1]
To & From: WORK/PURCHASE ORDER DATA ENTRY [1.1.1]
Local Data Flows: (68)
1. CUSTOMERS INFO
From & To: CUSTOMERS DATA ENTRY [1.1.2]
To & From: customers [1.1/D6]
Description: Information about customers.
2. CUSTOMERS INFO
From: customers [1.1/D6]
To: WORK/PURCHASE ORDER DATA ENTRY [1.1.1]
Description: Information about customers.
3. CUSTOMERS INFO
From: customers [1.1/D52]
To: DELIVERY CHALLAN DATA ENTRY [1.1.13]
Description: Information about customers.
4. CUSTOMERS INFO
From: customers [1.1/D53]
To: INVOICE DATA ENTRY [1.1.14]
Description: Information about customers.
5. DC DETAIL
From & To: DELIVERY CHALLAN DATA ENTRY [1.1.13]
To & From: dc_detail [1.1/D47]
Description: Details of transfering the stock to the customer for which work order was placed. It includes items Qty, rate etc.
6. DC MASTER
From & To: dc_master [1.1/D46]
To & From: DELIVERY CHALLAN DATA ENTRY [1.1.13]
Description: Master information of transfering the stock to the customer for which work order was placed.
7. GIA DETAIL
From & To: GOODS INWARD ADVICE DATA ENTRY [1.1.11]
To & From: gia_detail [1.1/D37]
Description: Deatils of the ready items which came as work order items are received after manufacturing from the production plant..
8. GIA MASTER
From & To: GOODS INWARD ADVICE DATA ENTRY [1.1.11]
To & From: gia_master [1.1/D36]
Description: It contains the master data of ready work order items. Work order items are received after manufacturing and other procedures as a ready product.
9. INVOICE MASTER
From & To: invoice_master [1.1/D54]
To & From: INVOICE DATA ENTRY [1.1.14]
10. INVOICE_DETAIL
From & To: invoice_detail [1.1/D55]
To & From: INVOICE DATA ENTRY [1.1.14]
11. ISSUE ALT DETAIL
From & To: ISSUE ITEMS DATA ENTRY [1.1.9]
To & From: issue_sa_detail [1.1/D62]
12. ISSUE DETAIL
From & To: ISSUE ITEMS DATA ENTRY [1.1.9]
To & From: issue_detail [1.1/D32]
Description: Details of issue items from the inventory to the production for manufacturing of items.
13. ISSUE MASTER
From & To: ISSUE ITEMS DATA ENTRY [1.1.9]
To & From: issue_master [1.1/D31]
Description: Master information pertaining to the items issued from the inventory to the production department for manufacturing of items.
14. ITEM MONTHLY TOTALS
From: PURCHASE RECEIPTS DATA ENTRY [1.1.6]
To: item_mon_totals [1.1/D20]
Description: Contains the present inventory level with all transcations.
15. ITEM MONTHLY TOTALS
From: GOODS INWARD ADVICE DATA ENTRY [1.1.11]
To: item_mon_totals [1.1/D39]
Description: Contains the present inventory level with all transcations.
16. ITEM MONTHLY TOTALS
From: ISSUE ITEMS DATA ENTRY [1.1.9]
To: item_mon_totals [1.1/D33]
Description: Contains the present inventory level with all transcations.
17. ITEMS DETAIL
From & To: ITEMS DATA ENTRY [1.1.5]
To & From: items_detail [1.1/D9]
18. ITEMS MASTER
From: items_master [1.1/D30]
To: ISSUE ITEMS DATA ENTRY [1.1.9]
Description: Master Information about all items.Its master of the items detail.
19. ITEMS MASTER
From: items_master [1.1/D25]
To: MANUFACTURING ORDER DATA ENTRY [1.1.8]
Description: Master Information about all items.Its master of the items detail.
20. ITEMS MASTER
From: items_master [1.1/D35]
To: GOODS INWARD ADVICE DATA ENTRY [1.1.11]
Description: Master Information about all items.Its master of the items detail.
21. ITEMS MASTER
From & To: ITEMS DATA ENTRY [1.1.5]
To & From: items_master [1.1/D8]
Description: Master Information about all items.Its master of the items detail.
22. ITEMS MASTER
From: items_master [1.1/D1]
To: WORK/PURCHASE ORDER DATA ENTRY [1.1.1]
Description: Master Information about all items.Its master of the items detail.
23. ITEMS MASTER
From: items_master [1.1/D45]
To: MATERIAL RETURN NOTE [1.1.10]
Description: Master Information about all items.Its master of the items detail.
24. ITEMS_MASTER
From: items_master [1.1/D50]
To: SUPERSEDING AND ALTERNATE PARTS DATA ENTRY [1.1.12]
25. MO DETAIL
From: mo_detail [1.1/D41]
To: GOODS INWARD ADVICE DATA ENTRY [1.1.11]
Description: It contains the details of manufacturing order for work order item.
26. MO DETAIL
From & To: mo_detail [1.1/D27]
To & From: MANUFACTURING ORDER DATA ENTRY [1.1.8]
Description: It contains the details of manufacturing order for work order item.
27. MO MASTER
From: mo_master [1.1/D40]
To: GOODS INWARD ADVICE DATA ENTRY [1.1.11]
Description: Contains master data of manufacturing order for work order item.
28. MO MASTER
From & To: mo_master [1.1/D26]
To & From: MANUFACTURING ORDER DATA ENTRY [1.1.8]
Description: Contains master data of manufacturing order for work order item.
29. MRN DETAIL
From & To: MATERIAL RETURN NOTE [1.1.10]
To & From: mrn_detail [1.1/D43]
Description: Details of the material return by the customer.
30. MRN DETAIL
From: mrn_detail [1.1/D5]
To: WORK/PURCHASE ORDER DATA ENTRY [1.1.1]
Description: Details of the material return by the customer.
31. MRN MASTER
From & To: MATERIAL RETURN NOTE [1.1.10]
To & From: mrn_master [1.1/D42]
Description: Main information about the material return from a work order.
32. PR DETAIL
From & To: PURCHASE RECEIPTS DATA ENTRY [1.1.6]
To & From: pr_detail [1.1/D22]
Description: Contains details of received items (as purchase receipts detail ) against purchase order.
33. PR MASTER
From & To: PURCHASE RECEIPTS DATA ENTRY [1.1.6]
To & From: pr_master [1.1/D21]
Description: This flow has master data of received items as purchase receipts against purchase orders.
34. PURCHASE ORDER DETAIL
From & To: PURCHASE ORDER DATA ENTRY [1.1.3]
To & From: po_detail [1.1/D16]
Description: This flow contains details of Purchase order.
35. PURCHASE ORDER DETAIL
From: po_detail [1.1/D24]
To: PURCHASE RECEIPTS DATA ENTRY [1.1.6]
Description: This flow contains details of Purchase order.
36. PURCHASE ORDER MASTER
From: po_master [1.1/D23]
To: PURCHASE RECEIPTS DATA ENTRY [1.1.6]
Description: It contains the master information about purchase order through PO_MASTER..
37. PURCHASE ORDER MASTER
From: po_master [1.1/D15]
To: PURCHASE ORDER DATA ENTRY [1.1.3]
Description: It contains the master information about purchase order through PO_MASTER..
38. SER_NO_INFO
From & To: ser_no_info [1.1/D17]
To & From: PURCHASE ORDER DATA ENTRY [1.1.3]
Description: SER_NO_INFO contains all the system generated keys.
39. SER_NO_INFO
From & To: VENDORS DATA ENTRY [1.1.7]
To & From: ser_no_info [1.1/D12]
Description: SER_NO_INFO contains all the system generated keys.
40. SER_NO_INFO
From & To: MATERIAL RETURN NOTE [1.1.10]
To & From: ser_no_info [1.1/D44]
Description: SER_NO_INFO contains all the system generated keys.
41. SER_NO_INFO
From & To: WORK/PURCHASE ORDER DATA ENTRY [1.1.1]
To & From: ser_no_info [1.1/D4]
Description: SER_NO_INFO contains all the system generated keys.
42. SER_NO_INFO
From & To: ITEMS DATA ENTRY [1.1.5]
To & From: ser_no_info [1.1/D10]
Description: SER_NO_INFO contains all the system generated keys.
43. SER_NO_INFO
From & To: SUPERSEDING AND ALTERNATE PARTS DATA ENTRY [1.1.12]
To & From: ser_no_info [1.1/D51]
Description: SER_NO_INFO contains all the system generated keys.
44. SER_NO_INFO
From & To: GOODS INWARD ADVICE DATA ENTRY [1.1.11]
To & From: ser_no_info [1.1/D38]
Description: SER_NO_INFO contains all the system generated keys.
45. SER_NO_INFO
From & To: CUSTOMERS DATA ENTRY [1.1.2]
To & From: ser_no_info [1.1/D13]
Description: SER_NO_INFO contains all the system generated keys.
46. SER_NO_INFO
From & To: ser_no_info [1.1/D56]
To & From: INVOICE DATA ENTRY [1.1.14]
Description: SER_NO_INFO contains all the system generated keys.
47. SER_NO_INFO
From & To: ser_no_info [1.1/D10]
To & From: PURCHASE RECEIPTS DATA ENTRY [1.1.6]
Description: SER_NO_INFO contains all the system generated keys.
48. SER_NO_INFO
From & To: ser_no_info [1.1/D28]
To & From: MANUFACTURING ORDER DATA ENTRY [1.1.8]
Description: SER_NO_INFO contains all the system generated keys.
49. SER_NO_INFO
From & To: ser_no_info [1.1/D28]
To & From: ISSUE ITEMS DATA ENTRY [1.1.9]
Description: SER_NO_INFO contains all the system generated keys.
50. SER_NO_INFO
From: ser_no_info [1.1/D51]
To: DELIVERY CHALLAN DATA ENTRY [1.1.13]
Description: SER_NO_INFO contains all the system generated keys.
51. SUPER ALT DETAIL
From & To: SUPERSEDING AND ALTERNATE PARTS DATA ENTRY [1.1.12]
To & From: super_alt_detail [1.1/D61]
52. SUPER ALT MASTER
From & To: SUPERSEDING AND ALTERNATE PARTS DATA ENTRY [1.1.12]
To & From: super_alt_master [1.1/D60]
53. UOM
From: uom [1.1/D18]
To: PURCHASE ORDER DATA ENTRY [1.1.3]
Description: Details of unit of measurement of items.
54. UOM
From: uom [1.1/D7]
To: ITEMS DATA ENTRY [1.1.5]
Description: Details of unit of measurement of items.
55. UOM
From & To: UOM [1.1.4]
To & From: uom [1.1/D7]
Description: Details of unit of measurement of items.
56. VENDORS INFO
From & To: VENDORS DATA ENTRY [1.1.7]
To & From: vendors [1.1/D11]
Description: Information pertaining to vendors.
57. VENDORS INFO
From: vendors [1.1/D11]
To: PURCHASE RECEIPTS DATA ENTRY [1.1.6]
Description: Information pertaining to vendors.
58. VENDORS INFO
From: vendors [1.1/D14]
To: PURCHASE ORDER DATA ENTRY [1.1.3]
Description: Information pertaining to vendors.
59. WORK ORDER DETAIL
From & To: WORK/PURCHASE ORDER DATA ENTRY [1.1.1]
To & From: wpo_detail [1.1/D3]
Description: This flow contains the detail information of work order such as items required, items qty etc. through
explosion of work order item.
60. WORK ORDER DETAIL
From: wpo_detail [1.1/D19]
To: PURCHASE ORDER DATA ENTRY [1.1.3]
Description: This flow contains the detail information of work order such as items required, items qty etc. through
explosion of work order item.
61. WORK ORDER DETAIL
From: wpo_detail [1.1/D34]
To: ISSUE ITEMS DATA ENTRY [1.1.9]
Description: This flow contains the detail information of work order such as items required, items qty etc. through
explosion of work order item.
62. WORK ORDER DETAIL
From: wpo_detail [1.1/D48]
To: DELIVERY CHALLAN DATA ENTRY [1.1.13]
Description: This flow contains the detail information of work order such as items required, items qty etc. through
explosion of work order item.
63. WORK ORDER DETAIL
From: wpo_detail [1.1/D58]
To: INVOICE DATA ENTRY [1.1.14]
Description: This flow contains the detail information of work order such as items required, items qty etc. through
explosion of work order item.
64. WORK ORDER DETAIL
From & To: wpo_detail [1.1/D29]
To & From: MANUFACTURING ORDER DATA ENTRY [1.1.8]
Description: This flow contains the detail information of work order such as items required, items qty etc. through
explosion of work order item.
65. WORK ORDER MASTER
From & To: WORK/PURCHASE ORDER DATA ENTRY [1.1.1]
To & From: wpo_master [1.1/D2]
Description: It contains the flow of master table of WPO_MASTER, such as, work order item,customers information etc.
66. WORK ORDER MASTER
From: wpo_master [1.1/D49]
To: DELIVERY CHALLAN DATA ENTRY [1.1.13]
Description: It contains the flow of master table of WPO_MASTER, such as, work order item,customers information etc.
67. WORK ORDER MASTER
From: wpo_master [1.1/D57]
To: INVOICE DATA ENTRY [1.1.14]
Description: It contains the flow of master table of WPO_MASTER, such as, work order item,customers information etc.
68. WPO DETAIL
From: wpo_detail [1.1/D59]
To: MATERIAL RETURN NOTE [1.1.10]
Exploded Processes (0)
Lowest Level Processes (14)
1. CUSTOMERS DATA ENTRY [1.1.2]
2. DELIVERY CHALLAN DATA ENTRY [1.1.13]
3. GOODS INWARD ADVICE DATA ENTRY [1.1.11]
4. INVOICE DATA ENTRY [1.1.14]
5. ISSUE ITEMS DATA ENTRY [1.1.9]
6. ITEMS DATA ENTRY [1.1.5]
7. MANUFACTURING ORDER DATA ENTRY [1.1.8]
8. MATERIAL RETURN NOTE [1.1.10]
9. PURCHASE ORDER DATA ENTRY [1.1.3]
10. PURCHASE RECEIPTS DATA ENTRY [1.1.6]
11. SUPERSEDING AND ALTERNATE PARTS DATA ENTRY [1.1.12]
12. UOM [1.1.4]
13. VENDORS DATA ENTRY [1.1.7]
14. WORK/PURCHASE ORDER DATA ENTRY [1.1.1]
Undefined Processes (0)
External Entities (2)
1. INVENTORY1 USER [1.1/a]
Description: User of Inventory System.
2. INVENTORY1 USER [1]
Imported Entities: (0)
Data Store: (28)
1. customers [1.1/D6]
Description: Table for the information of the customer.
2. dc_detail [1.1/D47]
Description: DC_DETAIL contains the details of the master table DC_MASTER.
3. dc_master [1.1/D46]
Description: DC_MASTER is the master table for the delivery of material to the customer against the work order.
4. gia_detail [1.1/D37]
Description: GIA_DETAIL contains the details of the manufactured items which are received corresponding to its GIA_MASTER.
5. gia_master [1.1/D36]
Description: Master table of the GIA_DEATIL contains the main data about the items received after manufacturing of items.
6. invoice_detail [1.1/D55]
7. invoice_master [1.1/D54]
8. issue_detail [1.1/D32]
Description: ISSUE_DETAIL contains the detail of ISSUE_MASTER ,i.e, details of issue of items for manufacturing.
9. issue_master [1.1/D31]
10. issue_sa_detail [1.1/D62]
11. item_mon_totals [1.1/D20]
Description: This table contains the present inventory level with all transcations,i.e, opening balance of Qty and value.
12. items_detail [1.1/D9]
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.
13. items_master [1.1/D1]
Description: This table contains all information about Items.It is master table of the Items_detail table.
14. mo_detail [1.1/D27]
Description: MO_DETAIL contains the details of manufacturing order corresponding to its MO_MASTER.
15. mo_master [1.1/D26]
Description: Master table for manufacturing order of items.
16. mrn_detail [1.1/D5]
Description: MRN_DETAIL contains the details of the material return corresponding to its MRN_MASTER.
17. mrn_master [1.1/D42]
Description: Master table for return of material which was issued to a work order.
18. po_detail [1.1/D16]
Description: PO_DETAIL contains the details of purchase order corresponding to its PO_MASTER.
19. po_master [1.1/D15]
Description: PO_MASTER is the master table of PO_DETAIL contains main information regarding purchase order.
20. pr_detail [1.1/D22]
Description: PR_DETAIL contains the details of received items corresponding to its PR_MASTER table.
21. pr_master [1.1/D21]
Description: This is master table of the purchase receipts which contains the information of received items against purchase order.
22. ser_no_info [1.1/D4]
Description: System generated serial No. infomation stored in this table. Automaticaly incrementd by database engine to generate the serial No. for various documents.
23. super_alt_detail [1.1/D61]
24. super_alt_master [1.1/D60]
25. uom [1.1/D7]
Description: Table contains unit of measurement used for the items.
26. vendors [1.1/D11]
Description: Table contains information about vendors.
27. wpo_detail [1.1/D3]
Description: WPO_DETAIL is the detail table of its master WPO_MASTER. Gives details regarding children items, Qty & UOM of the work order Item.
28. wpo_master [1.1/D2]
Description: Master table for WPO_DETAIL, which contains the broad view of the work order.
Process:
Processing [1.2]
Batch processing for inventory module.
Imported Data Flows: (2)
1. CUSTOMERS INFO
From: INVENTORY1 USER [1]
To: ITEMS MONTHLY PROCESSING [1.2.2]
2. INTERPROCESSINFO
From: interprocessinfo [1.2/D28]
To: BILL OF MATERIAL [1.2.1]
Local Data Flows: (26)
1. BOM DETAIL
From: BILL OF MATERIAL [1.2.1]
To: bom_detail [1.2/D4]
Description: It is detail table of the bill of material of its master one.
2. BOM MASTER
From: BILL OF MATERIAL [1.2.1]
To: bom_master [1.2/D3]
Description: It is master table of the bill of material contains work order number and date for which this bill of material is created.
3. GIA DETAIL
From: gia_detail [1.2/D8]
To: ITEMS MONTHLY PROCESSING [1.2.2]
Description: Deatils of the ready items which came as work order items are received after manufacturing from the production plant..
4. GIA DETAIL
From: gia_master [1.2/D9]
To: ITEMS MONTHLY PROCESSING [1.2.2]
Description: Deatils of the ready items which came as work order items are received after manufacturing from the production plant..
5. GIA DETAIL
From: gia_detail [1.2/D23]
To: WORK ORDER TOTALS [1.2.3]
Description: Deatils of the ready items which came as work order items are received after manufacturing from the production plant..
6. GIA MASTER
From: gia_master [1.2/D22]
To: WORK ORDER TOTALS [1.2.3]
Description: It contains the master data of ready work order items. Work order items are received after manufacturing and other procedures as a ready product.
7. ISSUE DETAIL
From: issue_detail [1.2/D11]
To: ITEMS MONTHLY PROCESSING [1.2.2]
Description: Details of issue items from the inventory to the production for manufacturing of items.
8. ISSUE DETAIL
From: issue_detail [1.2/D21]
To: WORK ORDER TOTALS [1.2.3]
Description: Details of issue items from the inventory to the production for manufacturing of items.
9. ISSUE MASTER
From: issue_master [1.2/D10]
To: ITEMS MONTHLY PROCESSING [1.2.2]
Description: Master information pertaining to the items issued from the inventory to the production department for manufacturing of items.
10. ISSUE MASTER
From: issue_master [1.2/D20]
To: WORK ORDER TOTALS [1.2.3]
Description: Master information pertaining to the items issued from the inventory to the production department for manufacturing of items.
11. ITEM MONTHLY TOTALS
From & To: ITEMS MONTHLY PROCESSING [1.2.2]
To & From: item_mon_totals [1.2/D13]
Description: Contains the present inventory level with all transcations.
12. ITEMS DETAIL
From: items_detail [1.2/D1]
To: BILL OF MATERIAL [1.2.1]
13. ITEMS MASTER
From: items_master [1.2/D5]
To: BILL OF MATERIAL [1.2.1]
Description: Master Information about all items.Its master of the items detail.
14. ITEMS MASTER
From: items_master [1.2/D12]
To: ITEMS MONTHLY PROCESSING [1.2.2]
Description: Master Information about all items.Its master of the items detail.
15. MRN DETAIL
From: mrn_detail [1.2/D15]
To: ITEMS MONTHLY PROCESSING [1.2.2]
Description: Details of the material return by the customer.
16. MRN DETAIL
From: mrn_detail [1.2/D25]
To: WORK ORDER TOTALS [1.2.3]
Description: Details of the material return by the customer.
17. MRN MASTER
From: mrn_master [1.2/D14]
To: ITEMS MONTHLY PROCESSING [1.2.2]
Description: Main information about the material return from a work order.
18. MRN MASTER
From: mrn_master [1.2/D24]
To: WORK ORDER TOTALS [1.2.3]
Description: Main information about the material return from a work order.
19. PR DETAIL
From: pr_detail [1.2/D6]
To: ITEMS MONTHLY PROCESSING [1.2.2]
Description: Contains details of received items (as purchase receipts detail ) against purchase order.
20. PR DETAIL
From: pr_detail [1.2/D19]
To: WORK ORDER TOTALS [1.2.3]
Description: Contains details of received items (as purchase receipts detail ) against purchase order.
21. PR MASTER
From: pr_master [1.2/D7]
To: ITEMS MONTHLY PROCESSING [1.2.2]
Description: This flow has master data of received items as purchase receipts against purchase orders.
22. PR MASTER
From: pr_master [1.2/D18]
To: WORK ORDER TOTALS [1.2.3]
Description: This flow has master data of received items as purchase receipts against purchase orders.
23. WORK ORDER DETAIL
From: wpo_detail [1.2/D2]
To: BILL OF MATERIAL [1.2.1]
Description: This flow contains the detail information of work order such as items required, items qty etc. through
explosion of work order item.
24. WORK ORDER DETAIL
From: wpo_detail [1.2/D16]
To: WORK ORDER TOTALS [1.2.3]
Description: This flow contains the detail information of work order such as items required, items qty etc. through
explosion of work order item.
25. WORK ORDER MASTER
From: wpo_master [1.2/D17]
To: WORK ORDER TOTALS [1.2.3]
Description: It contains the flow of master table of WPO_MASTER, such as, work order item,customers information etc.
26. WPO TOTALS
From: WORK ORDER TOTALS [1.2.3]
To: wpo_totals [1.2/D26]
Exploded Processes (0)
Lowest Level Processes (3)
1. BILL OF MATERIAL [1.2.1]
2. ITEMS MONTHLY PROCESSING [1.2.2]
3. WORK ORDER TOTALS [1.2.3]
Undefined Processes (1)
1. Reports [1.2.4]
External Entities (1)
1. INVENTORY1 USER [1]
Imported Entities: (0)
Data Store: (17)
1. bom_detail [1.2/D4]
Description: It is detail table of the bill of material of its master one.
2. bom_master [1.2/D3]
Description: It is master table of the bill of material contains work order number and date for which this bill of material is created.
3. gia_detail [1.2/D8]
Description: GIA_DETAIL contains the details of the manufactured items which are received corresponding to its GIA_MASTER.
4. gia_master [1.2/D9]
Description: Master table of the GIA_DEATIL contains the main data about the items received after manufacturing of items.
5. interprocessinfo [1.2/D28]
6. issue_detail [1.2/D11]
Description: ISSUE_DETAIL contains the detail of ISSUE_MASTER ,i.e, details of issue of items for manufacturing.
7. issue_master [1.2/D10]
8. item_mon_totals [1.2/D13]
Description: This table contains the present inventory level with all transcations,i.e, opening balance of Qty and value.
9. items_detail [1.2/D1]
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.
10. items_master [1.2/D5]
Description: This table contains all information about Items.It is master table of the Items_detail table.
11. mrn_detail [1.2/D15]
Description: MRN_DETAIL contains the details of the material return corresponding to its MRN_MASTER.
12. mrn_master [1.2/D14]
Description: Master table for return of material which was issued to a work order.
13. pr_detail [1.2/D6]
Description: PR_DETAIL contains the details of received items corresponding to its PR_MASTER table.
14. pr_master [1.2/D7]
Description: This is master table of the purchase receipts which contains the information of received items against purchase order.
15. wpo_detail [1.2/D2]
Description: WPO_DETAIL is the detail table of its master WPO_MASTER. Gives details regarding children items, Qty & UOM of the work order Item.
16. wpo_master [1.2/D17]
Description: Master table for WPO_DETAIL, which contains the broad view of the work order.
17. wpo_totals [1.2/D26]
Process:
Reports [1.3]
Preparation of various reports which are essential to the inventory user or management.
Imported Data Flows: (10)
1. BELOW ORDER REPORT
From: MANAGEMENT [a]
To: MANAGEMENT [a]
2. COMPONENT STORE REPORT
From: COMPONENT STORE LEDGER REPORT [1.3.11]
To: INVENTORY1 USER [1]
3. CONSUMPTION REPORT
From: CONSUMPTION STATEMENT REPORT [1.3.5]
To: MANAGEMENT [a]
4. MO REPORT
From: MANUFACTURING ORDER REPORT [1.3.6]
To: INVENTORY1 USER [1]
5. OVER STOCK REPORT
From: OVER STOCK REPORT [1.3.7]
To: MANAGEMENT [a]
6. PURCHASE ORDER REPORT
From: PURCHASE ORDER REPORT [1.3.2]
To: MANAGEMENT [a]
7. STOCK LEDGER REPORT
From: STOCK LEDGER REPORT [1.3.1]
To: INVENTORY1 USER [1]
8. TESTING STORE REPORT
From: TESTING STORE LEDGER REPORT [1.3.10]
To: MANAGEMENT [a]
9. UNDER STOCK REPORT
From: UNDER STOCK REPORT [1.3.3]
To: INVENTORY1 USER [1]
10. UNMOVED ITEMS REPORT
From: UNMOVED ITEMS REPORT [1.3.4]
To: MANAGEMENT [a]
Local Data Flows: (81)
1. GIA DETAIL
From: gia_detail [1.3/D65]
To: WORK ORDER SUMMARY REPORT [1.3.9]
Description: Deatils of the ready items which came as work order items are received after manufacturing from the production plant..
2. GIA DETAIL
From: gia_detail [1.3/D7]
To: STOCK LEDGER REPORT [1.3.1]
Description: Deatils of the ready items which came as work order items are received after manufacturing from the production plant..
3. GIA DETAIL
From: gia_detail [1.3/D71]
To: TESTING STORE LEDGER REPORT [1.3.10]
Description: Deatils of the ready items which came as work order items are received after manufacturing from the production plant..
4. GIA DETAIL
From: gia_detail [1.3/D93]
To: UNMOVED ITEMS REPORT [1.3.4]
Description: Deatils of the ready items which came as work order items are received after manufacturing from the production plant..
5. GIA DETAIL
From: gia_detail [1.3/D43]
To: MANUFACTURING ORDER REPORT [1.3.6]
Description: Deatils of the ready items which came as work order items are received after manufacturing from the production plant..
6. GIA MASTER
From: gia_master [1.3/D64]
To: WORK ORDER SUMMARY REPORT [1.3.9]
Description: It contains the master data of ready work order items. Work order items are received after manufacturing and other procedures as a ready product.
7. GIA MASTER
From: gia_master [1.3/D6]
To: STOCK LEDGER REPORT [1.3.1]
Description: It contains the master data of ready work order items. Work order items are received after manufacturing and other procedures as a ready product.
8. GIA MASTER
From: gia_master [1.3/D70]
To: TESTING STORE LEDGER REPORT [1.3.10]
Description: It contains the master data of ready work order items. Work order items are received after manufacturing and other procedures as a ready product.
9. GIA MASTER
From: gia_master [1.3/D92]
To: UNMOVED ITEMS REPORT [1.3.4]
Description: It contains the master data of ready work order items. Work order items are received after manufacturing and other procedures as a ready product.
10. GIA MASTER
From: gia_master [1.3/D42]
To: MANUFACTURING ORDER REPORT [1.3.6]
Description: It contains the master data of ready work order items. Work order items are received after manufacturing and other procedures as a ready product.
11. ISSUE DETAIL
From: issue_detail [1.3/D26]
To: CONSUMPTION STATEMENT REPORT [1.3.5]
Description: Details of issue items from the inventory to the production for manufacturing of items.
12. ISSUE DETAIL
From: issue_detail [1.3/D34]
To: UNMOVED ITEMS REPORT [1.3.4]
Description: Details of issue items from the inventory to the production for manufacturing of items.
13. ISSUE DETAIL
From: issue_detail [1.3/D4]
To: STOCK LEDGER REPORT [1.3.1]
Description: Details of issue items from the inventory to the production for manufacturing of items.
14. ISSUE DETAIL
From: issue_detail [1.3/D79]
To: COMPONENT STORE LEDGER REPORT [1.3.11]
Description: Details of issue items from the inventory to the production for manufacturing of items.
15. ISSUE DETAIL
From: issue_detail [1.3/D95]
To: WORK ORDER SUMMARY REPORT [1.3.9]
Description: Details of issue items from the inventory to the production for manufacturing of items.
16. ISSUE MASTER
From: issue_master [1.3/D35]
To: UNMOVED ITEMS REPORT [1.3.4]
Description: Master information pertaining to the items issued from the inventory to the production department for manufacturing of items.
17. ISSUE MASTER
From: issue_master [1.3/D5]
To: STOCK LEDGER REPORT [1.3.1]
Description: Master information pertaining to the items issued from the inventory to the production department for manufacturing of items.
18. ISSUE MASTER
From: issue_master [1.3/D78]
To: COMPONENT STORE LEDGER REPORT [1.3.11]
Description: Master information pertaining to the items issued from the inventory to the production department for manufacturing of items.
19. ISSUE MASTER
From: issue_master [1.3/D25]
To: CONSUMPTION STATEMENT REPORT [1.3.5]
Description: Master information pertaining to the items issued from the inventory to the production department for manufacturing of items.
20. ISSUE MASTER
From: issue_master [1.3/D94]
To: WORK ORDER SUMMARY REPORT [1.3.9]
Description: Master information pertaining to the items issued from the inventory to the production department for manufacturing of items.
21. ITEM MONTHLY TOTALS
From: item_mon_totals [1.3/D36]
To: UNMOVED ITEMS REPORT [1.3.4]
Description: Contains the present inventory level with all transcations.
22. ITEM MONTHLY TOTALS
From & To: item_mon_totals [1.3/D12]
To & From: STOCK LEDGER REPORT [1.3.1]
Description: Contains the present inventory level with all transcations.
23. ITEM MONTHLY TOTALS
From: item_mon_totals [1.3/D19]
To: UNDER STOCK REPORT [1.3.3]
Description: Contains the present inventory level with all transcations.
24. ITEM MONTHLY TOTALS
From: item_mon_totals [1.3/D45]
To: OVER STOCK REPORT [1.3.7]
Description: Contains the present inventory level with all transcations.
25. ITEM MONTHLY TOTALS
From: item_mon_totals [1.3/D51]
To: item_mon_totals [1.3/D51]
Description: Contains the present inventory level with all transcations.
26. ITEM MONTHLY TOTALS
From: item_mon_totals [1.3/D75]
To: TESTING STORE LEDGER REPORT [1.3.10]
Description: Contains the present inventory level with all transcations.
27. ITEM MONTHLY TOTALS
From: item_mon_totals [1.3/D83]
To: COMPONENT STORE LEDGER REPORT [1.3.11]
Description: Contains the present inventory level with all transcations.
28. ITEMS MASTER
From: items_master [1.3/D44]
To: OVER STOCK REPORT [1.3.7]
Description: Master Information about all items.Its master of the items detail.
29. ITEMS MASTER
From: items_master [1.3/D1]
To: STOCK LEDGER REPORT [1.3.1]
Description: Master Information about all items.Its master of the items detail.
30. ITEMS MASTER
From: items_master [1.3/D17]
To: PURCHASE ORDER REPORT [1.3.2]
Description: Master Information about all items.Its master of the items detail.
31. ITEMS MASTER
From: items_master [1.3/D24]
To: CONSUMPTION STATEMENT REPORT [1.3.5]
Description: Master Information about all items.Its master of the items detail.
32. ITEMS MASTER
From: items_master [1.3/D39]
To: MANUFACTURING ORDER REPORT [1.3.6]
Description: Master Information about all items.Its master of the items detail.
33. ITEMS MASTER
From: items_master [1.3/D50]
To: items_master [1.3/D50]
Description: Master Information about all items.Its master of the items detail.
34. ITEMS MASTER
From: items_master [1.3/D58]
To: WORK ORDER SUMMARY REPORT [1.3.9]
Description: Master Information about all items.Its master of the items detail.
35. ITEMS MASTER
From: items_master [1.3/D82]
To: COMPONENT STORE LEDGER REPORT [1.3.11]
Description: Master Information about all items.Its master of the items detail.
36. ITEMS MASTER
From: items_master [1.3/D68]
To: TESTING STORE LEDGER REPORT [1.3.10]
Description: Master Information about all items.Its master of the items detail.
37. ITEMS MASTER
From: items_master [1.3/D18]
To: UNDER STOCK REPORT [1.3.3]
Description: Master Information about all items.Its master of the items detail.
38. ITEMS MASTER
From: items_master [1.3/D31]
To: UNMOVED ITEMS REPORT [1.3.4]
Description: Master Information about all items.Its master of the items detail.
39. MO DETAIL
From: mo_detail [1.3/D96]
To: UNDER STOCK REPORT [1.3.3]
Description: It contains the details of manufacturing order for work order item.
40. MO DETAIL
From: mo_detail [1.3/D97]
To: UNMOVED ITEMS REPORT [1.3.4]
Description: It contains the details of manufacturing order for work order item.
41. MO DETAIL
From: mo_detail [1.3/D98]
To: MANUFACTURING ORDER REPORT [1.3.6]
Description: It contains the details of manufacturing order for work order item.
42. MO DETAIL
From: mo_detail [1.3/D99]
To: OVER STOCK REPORT [1.3.7]
Description: It contains the details of manufacturing order for work order item.
43. MO DETAIL
From: mo_detail [1.3/D100]
To: mo_detail [1.3/D100]
Description: It contains the details of manufacturing order for work order item.
44. MO MASTER
From: mo_master [1.3/D37]
To: UNMOVED ITEMS REPORT [1.3.4]
Description: Contains master data of manufacturing order for work order item.
45. MO MASTER
From: mo_master [1.3/D48]
To: OVER STOCK REPORT [1.3.7]
Description: Contains master data of manufacturing order for work order item.
46. MO MASTER
From: mo_master [1.3/D54]
To: mo_master [1.3/D54]
Description: Contains master data of manufacturing order for work order item.
47. MO MASTER
From: mo_master [1.3/D62]
To: WORK ORDER SUMMARY REPORT [1.3.9]
Description: Contains master data of manufacturing order for work order item.
48. MO MASTER
From: mo_master [1.3/D40]
To: MANUFACTURING ORDER REPORT [1.3.6]
Description: Contains master data of manufacturing order for work order item.
49. MRN DETAIL
From: mrn_detail [1.3/D84]
To: TESTING STORE LEDGER REPORT [1.3.10]
Description: Details of the material return by the customer.
50. MRN DETAIL
From: mrn_detail [1.3/D86]
To: STOCK LEDGER REPORT [1.3.1]
Description: Details of the material return by the customer.
51. MRN MASTER
From: mrn_master [1.3/D89]
To: TESTING STORE LEDGER REPORT [1.3.10]
Description: Main information about the material return from a work order.
52. MRN MASTER
From: mrn_master [1.3/D85]
To: STOCK LEDGER REPORT [1.3.1]
Description: Main information about the material return from a work order.
53. MTA DETAIL
From: MTA_DETAIL [1.3/D67]
To: WORK ORDER SUMMARY REPORT [1.3.9]
54. MTA DETAIL
From: MTA_DETAIL [1.3/D88]
To: COMPONENT STORE LEDGER REPORT [1.3.11]
55. MTA MASTER
From: MTA_MASTER [1.3/D66]
To: WORK ORDER SUMMARY REPORT [1.3.9]
56. MTA MASTER
From: MTA_MASTER [1.3/D87]
To: COMPONENT STORE LEDGER REPORT [1.3.11]
57. PO MASTER
From: po_master [1.3/D20]
To: UNDER STOCK REPORT [1.3.3]
58. PR DETAIL
From: pr_detail [1.3/D16]
To: PURCHASE ORDER REPORT [1.3.2]
Description: Contains details of received items (as purchase receipts detail ) against purchase order.
59. PR DETAIL
From: pr_detail [1.3/D61]
To: WORK ORDER SUMMARY REPORT [1.3.9]
Description: Contains details of received items (as purchase receipts detail ) against purchase order.
60. PR DETAIL
From: pr_detail [1.3/D2]
To: STOCK LEDGER REPORT [1.3.1]
Description: Contains details of received items (as purchase receipts detail ) against purchase order.
61. PR DETAIL
From: pr_detail [1.3/D81]
To: COMPONENT STORE LEDGER REPORT [1.3.11]
Description: Contains details of received items (as purchase receipts detail ) against purchase order.
62. PR DETAIL
From: pr_detail [1.3/D91]
To: UNMOVED ITEMS REPORT [1.3.4]
Description: Contains details of received items (as purchase receipts detail ) against purchase order.
63. PR MASTER
From: pr_master [1.3/D15]
To: PURCHASE ORDER REPORT [1.3.2]
Description: This flow has master data of received items as purchase receipts against purchase orders.
64. PR MASTER
From: pr_master [1.3/D3]
To: STOCK LEDGER REPORT [1.3.1]
Description: This flow has master data of received items as purchase receipts against purchase orders.
65. PR MASTER
From: pr_master [1.3/D60]
To: WORK ORDER SUMMARY REPORT [1.3.9]
Description: This flow has master data of received items as purchase receipts against purchase orders.
66. PR MASTER
From: pr_master [1.3/D80]
To: COMPONENT STORE LEDGER REPORT [1.3.11]
Description: This flow has master data of received items as purchase receipts against purchase orders.
67. PR MASTER
From: pr_master [1.3/D90]
To: UNMOVED ITEMS REPORT [1.3.4]
Description: This flow has master data of received items as purchase receipts against purchase orders.
68. PURCHASE ORDER DETAIL
From: po_detail [1.3/D14]
To: PURCHASE ORDER REPORT [1.3.2]
Description: This flow contains details of Purchase order.
69. PURCHASE ORDER DETAIL
From: po_detail [1.3/D33]
To: UNMOVED ITEMS REPORT [1.3.4]
Description: This flow contains details of Purchase order.
70. PURCHASE ORDER DETAIL
From: po_detail [1.3/D21]
To: UNDER STOCK REPORT [1.3.3]
Description: This flow contains details of Purchase order.
71. PURCHASE ORDER DETAIL
From: po_detail [1.3/D47]
To: OVER STOCK REPORT [1.3.7]
Description: This flow contains details of Purchase order.
72. PURCHASE ORDER DETAIL
From: po_detail [1.3/D53]
To: po_detail [1.3/D53]
Description: This flow contains details of Purchase order.
73. PURCHASE ORDER DETAIL
From: po_detail [1.3/D57]
To: WORK ORDER SUMMARY REPORT [1.3.9]
Description: This flow contains details of Purchase order.
74. PURCHASE ORDER MASTER
From: po_master [1.3/D13]
To: PURCHASE ORDER REPORT [1.3.2]
Description: It contains the master information about purchase order through PO_MASTER..
75. PURCHASE ORDER MASTER
From: po_master [1.3/D32]
To: UNMOVED ITEMS REPORT [1.3.4]
Description: It contains the master information about purchase order through PO_MASTER..
76. PURCHASE ORDER MASTER
From: po_master [1.3/D46]
To: OVER STOCK REPORT [1.3.7]
Description: It contains the master information about purchase order through PO_MASTER..
77. PURCHASE ORDER MASTER
From: po_master [1.3/D52]
To: po_master [1.3/D52]
Description: It contains the master information about purchase order through PO_MASTER..
78. PURCHASE ORDER MASTER
From: po_master [1.3/D56]
To: WORK ORDER SUMMARY REPORT [1.3.9]
Description: It contains the master information about purchase order through PO_MASTER..
79. STN DETAIL
From: STN_DETAIL [1.3/D77]
To: COMPONENT STORE LEDGER REPORT [1.3.11]
80. STN MASTER
From: STN_MASTER [1.3/D76]
To: COMPONENT STORE LEDGER REPORT [1.3.11]
81. WORK ORDER MASTER
From: wpo_master [1.3/D59]
To: WORK ORDER SUMMARY REPORT [1.3.9]
Description: It contains the flow of master table of WPO_MASTER, such as, work order item,customers information etc.
Exploded Processes (0)
Lowest Level Processes (11)
1. BELOW ORDER LEVEL REPORT [1.3.8]
2. COMPONENT STORE LEDGER REPORT [1.3.11]
3. CONSUMPTION STATEMENT REPORT [1.3.5]
4. MANUFACTURING ORDER REPORT [1.3.6]
5. OVER STOCK REPORT [1.3.7]
6. PURCHASE ORDER REPORT [1.3.2]
7. STOCK LEDGER REPORT [1.3.1]
8. TESTING STORE LEDGER REPORT [1.3.10]
9. UNDER STOCK REPORT [1.3.3]
10. UNMOVED ITEMS REPORT [1.3.4]
11. WORK ORDER SUMMARY REPORT [1.3.9]
Undefined Processes (0)
External Entities (2)
1. INVENTORY1 USER [1]
2. MANAGEMENT [a]
Imported Entities: (0)
Data Store: (19)
1. gia_detail [1.3/D7]
Description: GIA_DETAIL contains the details of the manufactured items which are received corresponding to its GIA_MASTER.
2. gia_master [1.3/D6]
Description: Master table of the GIA_DEATIL contains the main data about the items received after manufacturing of items.
3. issue_detail [1.3/D4]
Description: ISSUE_DETAIL contains the detail of ISSUE_MASTER ,i.e, details of issue of items for manufacturing.
4. issue_master [1.3/D5]
5. item_mon_totals [1.3/D12]
Description: This table contains the present inventory level with all transcations,i.e, opening balance of Qty and value.
6. items_master [1.3/D1]
Description: This table contains all information about Items.It is master table of the Items_detail table.
7. mo_detail [1.3/D96]
Description: MO_DETAIL contains the details of manufacturing order corresponding to its MO_MASTER.
8. mo_master [1.3/D37]
Description: Master table for manufacturing order of items.
9. mrn_detail [1.3/D84]
Description: MRN_DETAIL contains the details of the material return corresponding to its MRN_MASTER.
10. mrn_master [1.3/D85]
Description: Master table for return of material which was issued to a work order.
11. MTA_DETAIL [1.3/D67]
12. MTA_MASTER [1.3/D66]
13. po_detail [1.3/D14]
Description: PO_DETAIL contains the details of purchase order corresponding to its PO_MASTER.
14. po_master [1.3/D13]
Description: PO_MASTER is the master table of PO_DETAIL contains main information regarding purchase order.
15. pr_detail [1.3/D2]
Description: PR_DETAIL contains the details of received items corresponding to its PR_MASTER table.
16. pr_master [1.3/D3]
Description: This is master table of the purchase receipts which contains the information of received items against purchase order.
17. STN_DETAIL [1.3/D77]
18. STN_MASTER [1.3/D76]
19. wpo_master [1.3/D59]
Description: Master table for WPO_DETAIL, which contains the broad view of the work order.
Datastorage:
(31)
1. customers
address
city
country
cust_ser_no
last_name
first_name
phone_no
pincode
state
middle_name
customer_code
remarks
2. dc_detail
item_ser_no
dc_qty
dc_seq_no
uom
dc_ser_no
item_code
wpo_seq_no
3. dc_master
dc_ser_no
dc_date
cust_ser_no
desc
customer_code
wpo_ser_no
address
pincode
first_name
last_name
city
country
4. gia_detail
gia_seq_no
gia_ser_no
item_ser_no
gia_rate
gia_value
gia_qty
uom
item_code
delay
mo_ser_no
mo_seq_no
5. gia_master
gia_ser_no
gia_date
total_value
desc
6. invoice_detail
inv_ser_no
inv_seq_no
item_ser_no
item_code
inv_qty
inv_value
excise_duty
tax
total_value
wpo_seq_no
inv_rate
uom
7. invoice_master
inv_ser_no
inv_date
customer_code
cust_ser_no
first_name
last_name
address
city
country
pincode
desc
wpo_ser_no
total_amt
trans_cost
8. issue_detail
issue_qty
item_ser_no
iss_seq_no
iss_rate
iss_value
iss_ser_no
uom
item_code
wpo_seq_no
issue_type
9. issue_master
desc
iss_ser_no
issue_date
total_value
wpo_ser_no
10. issue_sa_detail
item_ser_no
qty
uom
for_item_no
11. item_mon_totals
opening_balance_qty
opening_balance_value
item_ser_no
current_year
uom
month_idx
12. items_detail
item_ser_no
item_code
item_qty
labour_required
child_uom
child_item_no
child_code
child_qty
part_type
uom
13. items_master
item_ser_no
item_desc
uom
lead_time
ord_level
min_level
max_level
part_type
item_code
unit_cost
unit_price
latest_exp
exp_qty
14. mo_detail
mo_ser_no
item_ser_no
mo_qty
mo_seq_no
uom
item_code
wpo_seq_no
received_qty
received_value
15. mo_master
mo_date
mo_status
mo_ser_no
desc
expected_manu_date
wpo_ser_no
16. mrn_detail
mrn_ser_no
mrn_qty
item_ser_no
mrn_seq_no
mrn_value
uom
item_code
mrn_rate
from_wpo_seq
17. mrn_master
mrn_ser_no
total_value
mrn_date
desc
from_wpo_ser
18. po_detail
item_ser_no
po_rate
po_ser_no
po_qty
uom
po_seq_no
item_code
po_item_status
po_value
expected_rec_date
wpo_seq_no
received_qty
received_value
19. po_master
po_ser_no
po_status
vend_ser_no
po_date
desc
payment_mode
vendor_code
total_value
wpo_ser_no
20. pr_detail
item_ser_no
pr_rate
pr_value
pr_ser_no
pr_seq_no
pr_qty
uom
item_code
delay
expiry_date
po_seq_no
po_ser_no
21. pr_master
total_value
pr_date
pr_ser_no
desc
vend_ser_no
vendor_code
22. ser_no_info
po_ser_no
item_ser_no
vend_ser_no
wpo_ser_no
mrn_ser_no
iss_ser_no
pr_ser_no
super_alt_ser_no
gia_ser_no
mta_ser_no
cust_ser_no
dc_ser_no
doc_ser_no
mo_ser_no
No definition in Dict.
bom_ser_no
23. super_alt_detail
super_alt_seq_no
super_alt_ser_no
uom
qty
item_ser_no
24. super_alt_master
item_ser_no
replace_status
replace_tag
super_alt_ser_no
uom
qty
25. uom
uom
desc
26. vendors
vend_ser_no
state
pincode
phone_no
last_name
first_name
country
city
address
middle_name
vendor_code
remarks
27. wpo_detail
wpo_ser_no
wpo_seq_no
wpo_qty
item_ser_no
item_code
unit_price
wpo_uom
wpo_price
expect_del_date
wpo_part_type
wpo_item_status
balance_qty
28. wpo_master
wpo_ser_no
wpo_date
cust_ser_no
desc
wpo_code
payment_cond
customer_code
payment_mode
total_price
wpo_status
29. bom_detail
bom_ser_no
child_qty
child_item_no
child_uom
child_code
labour_required
parent_item_no
parent_code
parent_qty
subgroup_no
group_no
part_type
parent_uom
bom_seq_no
30. bom_master
bom_date
bom_ser_no
wpo_ser_no
wpo_seq_no
item_ser_no
item_code
31. wpo_totals
wpo_ser_no
total_amt
doc_type
Dataflow:
(31)
1. CUSTOMERS INFO
address
city
country
cust_ser_no
first_name
last_name
phone_no
pincode
state
customer_code
middle_name
remarks
2. DC DETAIL
dc_qty
dc_seq_no
dc_ser_no
item_ser_no
uom
item_code
wpo_seq_no
3. DC MASTER
dc_ser_no
dc_date
cust_ser_no
customer_code
desc
wpo_ser_no
address
first_name
last_name
pincode
city
country
4. GIA DETAIL
gia_rate
gia_qty
gia_ser_no
gia_seq_no
gia_value
item_ser_no
uom
item_code
delay
mo_ser_no
mo_seq_no
5. GIA MASTER
gia_ser_no
gia_date
total_value
desc
6. INVOICE MASTER
address
cust_ser_no
customer_code
desc
first_name
inv_date
inv_ser_no
last_name
pincode
trans_cost
total_amt
wpo_ser_no
city
country
7. INVOICE_DETAIL
excise_duty
inv_ser_no
inv_seq_no
item_ser_no
item_code
inv_qty
inv_value
tax
total_value
wpo_seq_no
inv_rate
uom
8. ISSUE ALT DETAIL
for_item_no
item_ser_no
uom
qty
9. ISSUE DETAIL
iss_seq_no
item_ser_no
issue_qty
iss_rate
iss_value
iss_ser_no
uom
item_code
wpo_seq_no
issue_type
10. ISSUE MASTER
wpo_ser_no
total_value
issue_date
iss_ser_no
desc
item_code
item_ser_no
11. ITEM MONTHLY TOTALS
item_ser_no
opening_balance_qty
opening_balance_value
uom
current_year
month_idx
12. ITEMS DETAIL
child_item_no
child_code
child_qty
child_uom
item_code
item_ser_no
item_qty
labour_required
part_type
uom
13. ITEMS MASTER
exp_qty
item_code
item_desc
item_ser_no
latest_exp
max_level
min_level
part_type
ord_level
unit_price
unit_cost
lead_time
uom
14. MO DETAIL
mo_ser_no
mo_seq_no
mo_qty
item_ser_no
uom
item_code
wpo_seq_no
received_qty
received_value
15. MO MASTER
expected_manu_date
mo_ser_no
mo_status
mo_date
desc
wpo_ser_no
16. MRN DETAIL
item_ser_no
mrn_seq_no
mrn_ser_no
mrn_value
uom
mrn_qty
item_code
mrn_rate
from_wpo_seq
17. MRN MASTER
mrn_ser_no
mrn_date
total_value
desc
from_wpo_ser
18. PR DETAIL
item_ser_no
pr_ser_no
pr_seq_no
pr_qty
pr_rate
pr_value
uom
item_code
delay
expiry_date
po_seq_no
po_ser_no
19. PR MASTER
total_value
vend_ser_no
pr_ser_no
pr_date
desc
vendor_code
20. PURCHASE ORDER DETAIL
item_ser_no
po_qty
po_seq_no
po_ser_no
po_rate
uom
expect_del_date
item_code
po_item_status
po_value
wpo_seq_no
received_qty
received_value
21. PURCHASE ORDER MASTER
po_ser_no
po_status
total_value
vend_ser_no
po_date
desc
payment_mode
vendor_code
wpo_ser_no
22. SER_NO_INFO
item_ser_no
iss_ser_no
mo_ser_no
po_ser_no
pr_ser_no
vend_ser_no
wpo_ser_no
gia_ser_no
mta_ser_no
cust_ser_no
doc_ser_no
mrn_ser_no
dc_ser_no
super_alt_ser_no
No definition in Dict.
bom_ser_no
23. SUPER ALT DETAIL
super_alt_seq_no
super_alt_ser_no
item_ser_no
qty
uom
24. SUPER ALT MASTER
item_ser_no
replace_tag
replace_status
super_alt_ser_no
uom
qty
25. UOM
uom
desc
26. VENDORS INFO
address
city
country
last_name
first_name
phone_no
pincode
state
vend_ser_no
middle_name
remarks
vendor_code
27. WORK ORDER DETAIL
wpo_ser_no
wpo_seq_no
wpo_qty
item_code
item_ser_no
unit_price
wpo_uom
wpo_price
expect_del_date
wpo_part_type
wpo_item_status
balance_qty
28. WORK ORDER MASTER
wpo_ser_no
wpo_date
wpo_code
payment_cond
desc
customer_code
cust_ser_no
payment_mode
total_price
wpo_status
29. BOM DETAIL
bom_ser_no
parent_item_no
parent_code
parent_qty
parent_uom
part_type
labour_required
child_code
child_item_no
child_qty
child_uom
group_no
subgroup_no
bom_seq_no
30. BOM MASTER
bom_ser_no
bom_date
wpo_ser_no
wpo_seq_no
item_ser_no
item_code
31. WPO TOTALS
wpo_ser_no
wpo_seq_no
total_qty
total_amt