Navigation:  Purchasing > Technical References > ErrorIDs   Purchase Order transaction Import tables

Fields marked * may NOT be left blank. All other fields may be left blank.

 

Both import tables use the common PoImportID field to relate the master and detail portions of transactions. Each transaction being imported must have a unique PoImportID.

 

PoImport

Common information for a transaction. Each transaction has one record in this table.

 

PoImportID*

This field identifies the import transaction and relates a master record to its detail records.

 

PurchaseOrderTypeID*

1 means this is an ‘Order’.

2 means this is a ‘Quote’.

 

WarehouseID*

Specifies the Warehouse.

 

SupplierID*

Specifies the Supplier.

 

IsHold*

1 means this order is on Hold.
0 means this order is not on Hold.

 

OrderDate*

Specifies the date the we placed this order.

 

DeliveryDate*

Specifies the date this order should be received.

 

Terms

When blank the system uses the Terms specified for this Supplier.

 

ShipVia

When blank the system uses the Ship Via specified for this Supplier.

 

Reference

This field is available to specify an appropriate external reference.

 

VatCode

When blank the system uses the Vat Code specified for this Supplier.

 

VatLicense

When blank the system uses the Vat License specified for this Supplier.

 

Notes

This Memo field is used for any supplementary information about this Purchase Order.

 

OriginUserID

This field may be any UserID. When specified the Origin UserID of the imported Purchase Order will be the specified value. When blank the Origin UserID of the imported Purchase Order will be the UserID of the User running the Import task.

 

OriginTaskID

This field may be any TaskID value. When specified the Origin TaskID of the imported Purchase Order will be the specified value. When blank the Origin TaskID of the imported Purchase Order will be the TaskID of the Import task.

 

OriginTransID

This field may be any TransID value. When specified the Origin TransID of the imported Purchase Order will be the specified value. When blank the Origin TransID of the imported Purchase Order will be the PoImportID.

 

OriginBatchID

This field may be any BatchID value. When specified the Origin BatchID of the imported Purchase Order will be the specified value. When blank the Origin BatchID of the imported Purchase Order will also be blank.

 

ErrorID

This field is reserved for the Import task. Do not insert any value into this field. Any value in this field will be ignored and written over.

 

PoImportDetail

Transaction details. Each transaction has one or more records in this table.

 

PoImportID*

This field relates each detail record to the corresponding master record for that transaction.

 

ProductID*

Specifies the Product.

 

OnOrderQuantity*

Specifies the Order Quantity in the Unit Of Purchase for this Product.

 

Price

Specifies the price per unit in the Unit Of Purchase for this Product. Price is normally left blank so that the import task can use the applicable Price for this Supplier and Quantity.

 

DebitAccountID

When blank the system uses the applicable Asset or Expense AccountID as specified in Purchasing Setup. That AccountID is determined by the Product Group and Warehouse.

 

JobID

When Job Costing is installed this field is available to specify a JobID when applicable.

 

CostID

When Job Costing is installed this field is available to specify a CostID when applicable.

 

ErrorID

This field is reserved for the Import task. Do not insert any value into this field. Any value in this field will be ignored and written over.