Inventory > Technical References > Transaction Import tables

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

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

IcImport table

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

IcImportID*

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

IcTypeID*

1 means this is a ‘Receipt’.
2 means this is an ‘Issue’.

WarehouseID*

Specifies the Warehouse.

ToWarehouseID

This field must be a valid Warehouse. It may be left blank.

If this field contains a WarehouseID and the IcType is an Issue than this transaction will be treated as a transfer. This means that the Warehouse in the WarehouseID field becomes the FromWarehouseID and the inventory items will be transferred from this Warehouse to the ToWarehouseID.

IcTransDate*

Transaction date.

Reference

This field may be any value.

Notes

This field may be any value.

OriginUserID

This field may be any UserID value. When specified the Origin UserID of the posted transaction will be the specified value. When blank the Origin UserID of the posted transaction 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 posted transaction will be the specified value. When blank the Origin TaskID of the posted transaction will be the TaskID of the Import task.

OriginTransID

This field may be any TransID value. When specified the Origin TransID of the posted transaction will be the specified value. When blank the Origin TransID of the posted transaction will be the IcImportID.

OriginBatchID

This field may be any BatchID value. When specified the Origin BatchID of the posted transaction will be the specified value. When blank the Origin BatchID of the posted transaction 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.

IcImportDetail table

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

IcImportID*

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

ProductID*

Specifies the Product.

Quantity*

Specifies the Quantity in the Unit Of Stock for this Product.

It is always specified as a positive value.

The system knows whether this is a Receipt or Issue based on the IcTypeID value in the corresponding IcImport record.

Amount*

Specifies the dollar value.

It is always specified as a positive value.

The system knows whether this is a Receipt or Issue based on the IcTypeID value in the corresponding IcImport record.

PostedQuantity

This field is used internally by the system and applies to Issues only.

In the standard setup where negative OnHand Available Quantity is not allowed, if your import transaction is an Issue transaction where the Quantity for a Product exceeds its current OnHand Available Quantity the system will accept just the Quantity equal to the OnHand Available Quantity. That accepted Quantity will then be shown in the PostedQuantity field for that item, the original Quantity and Amount will be adjusted and the transaction will not be deleted. This means that once a sufficient Receipt for that Product has been posted then you can simply run the Import task again.

Do not insert any value into this field.

If Inventory setup allows Negative OnHand Available Quantity then this field is not 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.