| Element | Parent | Required | Data Type | Description | Valid Values |
|---|---|---|---|---|---|
| TransactionHeader | Yes | ||||
| TransactionType | TransactionHeader | Yes | VARCHAR(20) | This is the type of transaction that is being integrated. | ProdMisc |
| TransactionID | TransactionHeader | No | VARCHAR(15) | This is the transaction number. If the transaction does not exist we will create it. If this is empty we will use the next number. | |
| TransactionStatusName | TransactionHeader | No | VARCHAR(25) | This is the status that the transaction should be integrated as. If no status is passed, "New" will be used. | New, In Process, Staging, Loading, Shipped |
| SiteID | TransactionHeader | Yes | VARCHAR(10) | This is the site ID where the production event is happening. | |
| TransactionDate | TransactionHeader | Yes | DATETIME | This is the date the transaction affects inventory. | |
| UserID | TransactionHeader | No | VARCHAR(150) | This is the user who is completing the transaction. Does not have to be a valid NS user. | |
| CompanyID | TransactionHeader | Yes | VARCHAR(10) | This is the ID of the company that you are sending data for. The value must match an entry in ERPx_MFDataEntityCompany for the Company ID column. | |
| TransactionDetail | TransactionHeader | Yes | |||
| ItemSort | TransactionDetail | No | INTEGER | This is the sequence of the items on the transaction. If not passed we will sequence them and it is suggested to let NorthScope sequence the lines. | |
| ItemID | TransactionDetail | Yes | VARCHAR(50) | This is the item ID for the inventory item being used in the production transaction. | |
| TransactionUnits | TransactionDetail | No | NUMERIC(18,5) | This is the number of units for this line on the transaction. If an item is managed by units only or units and weight this value must be passed. Item issues should be sent as positive quantities. Negative quantities can be used to "un-do" a production event. | |
| UnitsUOMID | TransactionDetail | No | VARCHAR(10) | This is the unit of measure for the units on the transaction. It is required if TransactionUnits is being used. | |
| TransactionWeight | TransactionDetail | No | NUMERIC(18,5) | This is the weight value for this line on the transaction. If an item is managed by weight only or units and weight this value must be passed. Item issues should be sent as positive quantities. Negative quantities can be used to "un-do" a production event. | |
| WeightUOMID | TransactionDetail | No | VARCHAR(10) | This is the unit of measure for the weight on the transaction. It is required if TransactionWeight is being used. | |
| Lot | TransactionDetail | No | VARCHAR(50) | This is the production batch (or "lot") number that is being allocated if an item is lot tracked. |
Example:
<TransactionHeader>
<TransactionType>ProdMisc</TransactionType>
<TransactionID>1234567</TransactionID>
<TransactionStatusName>In Process</TransactionStatusName>
<SiteID>ABC</SiteID>
<TransactionDate>2018-01-16</TransactionDate>
<UserID>UserA</UserID>
<CompanyID>XYZ</CompanyID>
<TransactionDetail>
<ItemSort />
<ItemID>12345</ItemID>
<TransactionUnits>1.000000</TransactionUnits>
<UnitsUOMID>CASE</UnitsUOMID>
<TransactionWeight>10.55000</TransactionWeight>
<WeightUOMID>LB</WeightUOMID>
<Lot>18000</Lot>
</TransactionDetail>
</TransactionHeader>