ProjectDBRawmaterialTransactions

This macro is part of the DirectSQL integration and imports RawmaterialTransactions according to the settings for DirectSQL in combination with the parameters selected below.

Example parameter configuration

Parameter descriptions

(* = configuration required)

deleteNonImportedTransaction
If = true transactions that are not imported will be deleted

forewardFromToday
If = true only transactions forward from today will be included

inventoryQuery
a custom SQL query for the inventory may be included here

lastChanged
Internal use only. Don’t change.

lastUpdated
Internal use only. Don’t change.

materialType
Defines the type of materials to import.
Default -1 = all types.

0 = rawmaterial
1 = resource/tool
2 = semifinished product
3 = finished product
4 = recipe

purchaseQuery
a custom SQL query for the purchases may be included here

readInventories
If = true inventories will be included

readPurchases
If = true purchases will be included

readShipments
If = true shipments will be included

shipmentQuery
a custom SQL query for the shipments may be included here