Overview
To import purchase order into the database.
Mandatory fields:
Item IDid: The item ID of all the items thats in the purchase order is entered.
Quantity: The quantity of the items in the purchase order is entered here.
Vendor IDid: The vendor to whom the purchase order is sent is entered here.Each purchase order should have the vendor, Venue and level and level ID same since the each vendor corresponds to one particular PO.
Venue IDid: The venue of the PO thats to be delivered is entered.
Level: If the items are going to store, S is entered.If its warehouse W is entered.
Level IDid: The ID of the warehouse or store in is entered.
Not Mandatory fields:
Unit Cost: The unit cost of the item is entered, if blank it takes the unit cost in the database.
Retail Price: The retail price of the item is entered, if blank it takes the retail price from the database.
Discount: Discount ID thats to be processed on the items is entered here.
Tax: Tax ID thats to be processed on the items is entered here.
Unit of measureOf Measure: The conversion units are entered here.
...