Introduction
ToolWatch Vista integration support allows you to sync Purchase Orders (POs) and receipts in order to create the inventory and to have the purchase history available as a data point that can be used to view historical costs.
Purchase Order Header
A ToolWatch Purchase Order header will be created for every Purchase Order Header in Vista. The purchase order headers fields of the Vista table bPOHD are used and the following fields will be mapped:
Vista POHeader | ToolWatch POHeader | Notes |
POCo | POCo |
|
PO | PO |
|
Vendor | Vendor |
|
VendorGroup | VendorGroup |
|
Status | Status |
|
Purge | Purge |
|
AutoCloseYN | AutoCloseYN |
|
DocType | DocType |
|
Description | Description |
|
OrderDate | OrderDate |
|
OrderBy | OrderBy |
|
ExpDate | ExpDate |
|
Notes | Notes |
|
JCCo | JCCo |
|
Job | Job |
|
ShipLoc | ShipLoc |
|
Address | Address |
|
City | City |
|
State | State |
|
Zip | Zip |
|
ShipIns | ShipIns |
|
| PurchaseOrderId |
|
| VendorId |
|
Purchase Order Items
Purchase order Items refers to purchase order lines. A purchase order can have <one/many> purchase order Item. The purchase order item are found in Vista bPOIT table and the following fields are mapped into ToolWatch.
Vista POItem | ToolWatch POItem | Notes |
| LineId |
|
| LineNumber |
|
| PurchaseOrderId |
|
| organizationId |
|
| MasterId |
|
| ItemNumber |
|
| Description |
|
| SKU |
|
| QuantityOrdered |
|
| QuantityReceived |
|
| QuantityCancelled |
|
| costCenterId |
|
| costCodeId |
|
| Bill |
|
| uomDescription |
|
| cost |
|
| itemType |
|
| createdById |
|
| createdBy |
|
| createdOn |
|
| modifiedById |
|
| modifiedBy |
|
| modifiedOn |
|