Page Comparison

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
TransactionClassID	TransactionHeader	No	VARCHAR(50)	This is the ID of the inventory transaction class the transaction belongs to. The default transaction class is used, if the value is not provided.
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, Released, In Process, Staging, Loading, Shipped, Approved, Ready To Post
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.
ProductionOrder	TransactionHeader	No	VARCHAR(50)	This is the Default Work Order for all the line items, unless specified differently in the Transaction Detail for an item.
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-doundo" 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 this value must be passed. If an item is managed by units and weight this value must be passed. , and no weight value is provided it will be calculated based on the item's unit of measure schedule and conversions per the number of units provided for the line on the transaction. Item issues should be sent as positive quantities. Negative quantities can be used to " un-do undo" a production event. Note: For uniform weight items, if the user does not pass the correct weight value per the item's unit of measure schedule, we will automatically fix it to avoid any integration errors.
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.
ProductionOrder	TransactionDetail	No	VARCHAR(100)	This is the Work Order ID value for the item on the transaction.
Owner	TransactionDetail	No	VARCHAR(25)	This is the name of the owner assigned to the lot and must be a valid owner name configured in the system. This value will default to the value assigned to the "Default Owner" preference if not provided in the XML.
Attributes	TransactionDetail	No
TransactionAttributeList	Attributes	No		Child element of Attributes.
TransactionAttribute	TransactionAttributeList	No		Child element of TransactionAttributeList.
Name	TransactionAttribute	No	VARCHAR(25)	This is the attribute name associated with the Production Misc transaction.
Value	TransactionAttribute	No	VARCHAR(200)	This is the attribute value for the associated transaction attribute.
LotAttributeList	Attributes	No		Child element of Attributes.
LotAttribute	LotAttributeList	No		Child element of LotAttributeList.
ItemID	LotAttribute	No	VARCHAR(50)	This is the Item ID of the item for the associated production batch (lot) that the attributes are to be assigned to. This must be a valid item that is setup in the inventory items master file and should match the ItemID entered in the TransactionDetail.
Lot	LotAttribute	No	VARCHAR(50)	This is the production batch (or "lot") number associated with the item that the attributes are to be assigned to. This can either be a new or existing lot, but should match the Lot entered in the TransactionDetail.
SiteID	LotAttribute	No	VARCHAR(20)	This is the Site ID associated with the item and lot that the attributes are to be assigned to. This value should match the SiteID entered in the TransactionHeader.
Owner	LotAttribute	No	VARCHAR(25)	This is the name of the owner assigned to the lot. This must be a valid owner name configured in the system and should match the Owner entered in the TransactionDetail.
AttributesList	LotAttribute	No		Child element of LotAttribute.
Attribute	AttributesList	No		Child element of AttributesList.
AttributeName	Attribute	No	VARCHAR(25)	This is the attribute name associated with the production batch (Lot) configured in the Attributes master file for production batches.
AttributeValue	Attribute	No	VARCHAR(200)	This is the attribute value for the associated production batch (lot) attribute. Valid values are dependent upon what type of attribute the value is associated to. For List type attributes the value entered must exist as an option in the list, for Date type attributes the value entered must be a valid date and format.

Example:

...


Pallets	TransactionDetail	No
ItemPallet	Pallets	No		Child element of Pallets.
ItemID	ItemPallet	No	VARCHAR(50)	This is the Item ID of the item that is associated to the Pallet. This must be a valid item that is setup in the inventory items master file and should match the ItemID entered in the TransactionDetail.
Lot	ItemPallet	No	VARCHAR(50)	This is the production batch (or "lot") number associated with the item on the Pallet. This can either be a new or existing lot, but should match the Lot entered in the TransactionDetail.
SiteID	ItemPallet	No	VARCHAR(20)	This is the Site ID associated with the item and lot on the Pallet. This value should match the SiteID entered in the TransactionHeader.
Owner	ItemPallet	No	VARCHAR(25)	This is the name of the owner assigned to the lot on the Pallet. This must be a valid owner name configured in the system and should match the Owner entered in the TransactionDetail.
PalletList	ItemPallet	No		Child element of ItemPallet.
Pallet	PalletList	No		Child element of PalletList.
Number	Pallet	No	VARCHAR(50)	This is the Pallet Number assigned to the pallet.
Units	Pallet	No	NUMERIC(18,5)	This is the quantity of Units for the item on the pallet. If an item is managed by units only or units and weight this value must be passed.
UnitsUOMID	Pallet	No	VARCHAR(10)	This is the unit of measure for the item's units on the pallet.
Weight	Pallet	No	NUMERIC(18,5)	This is the weight value for the item on the pallet. If an item is managed by weight only or units and weight this value must be passed.
WeightUOMID	Pallet	No	VARCHAR(10)	This is the unit of measure for the item's weight on the pallet.
Certifications	TransactionDetail	No
LotCertificationsList	Certifications	No		Child element of Certifications.
LotCertification	LotCertificationsList	No		Child element of LotCertificationsList.
ItemID	LotCertification	No	VARCHAR(50)	This is the Item ID of the item that the certifications are to be assigned to. This must be a valid item that is setup in the inventory items master file and should match the ItemID entered in the TransactionDetail.
Lot	LotCertification	No	VARCHAR(50)	This is the production batch (or "lot") number associated with the item that the certifications are to be assigned to. This can either be a new or existing lot, but should match the Lot entered in the TransactionDetail.
SiteID	LotCertification	No	VARCHAR(20)	This is the Site ID associated with the item and lot that the certifications are to be assigned to. This value should match the SiteID entered in the TransactionHeader.
Owner	LotCertification	No	VARCHAR(25)	This is the name of the owner assigned to the lot. This must be a valid owner name configured in the system and should match the Owner entered in the TransactionDetail.
CertificationsList	Certifications	No		Child element of Certifications.
Certification	CertificationsList	No		Child element of CertificationsList.
CertificationName	Certification	No	VARCHAR(25)	This is the certification name associated with the production batch (Lot) configured in the Lot Certifications master file. If no certification is provided "No" is implied.
CertificationValue	Certification	No	VARCHAR(3)	This is the certification value for the associated production batch (lot) certificate. Valid values are "Yes" or "No". If no value is provided "No" is implied.	Yes or No (not case sensitive)

Code Block

language	xml
title	Example Production Misc XML

<TransactionHeader>
    <TransactionType>ProdMisc</TransactionType>

...


    <TransactionClassID>Default</TransactionClassID>
    <TransactionID>1234567</TransactionID>

...


    <TransactionStatusName>Ready

...

To

...

Post</TransactionStatusName>

...


    <SiteID>ABC</SiteID>

...

<TransactionDate>2020-01-

...

20</TransactionDate>
    <ProductionOrder>123</ProductionOrder> <!-- Default Work Order -->
    <UserID>UserA</UserID>

...


    <CompanyID>XYZ</CompanyID>

...


    <TransactionDetail>

...


        <ItemSort />

...

<ItemID>1234321</ItemID>

...


        <TransactionUnits>1.000000</TransactionUnits>

...


        <UnitsUOMID>CASE</UnitsUOMID>

...


        <TransactionWeight>10.55000</TransactionWeight>

...


        <WeightUOMID>LB</WeightUOMID>

...

<Lot>18001</Lot>
        <ProductionOrder>456</ProductionOrder> <!-- Work Order -->
        <Owner>NLP</Owner>
    </TransactionDetail>
	<Attributes>
        <TransactionAttributeList>
            <TransactionAttribute>
                <Name>My Lookup Attribute</Name>
                <Value>Red</Value>
            </TransactionAttribute>
            <TransactionAttribute>
                <Name>My Text Attribute</Name>
                <Value>425-949-3313</Value>
            </TransactionAttribute>
            <TransactionAttribute>
                <Name>My Date Attribute</Name>
                <Value>2020-01-20</Value>
            </TransactionAttribute>
        </TransactionAttributeList>
        <LotAttributeList>
            <LotAttribute>
                <ItemID>1234321</ItemID>
                <Lot>18001</Lot>
                <SiteID>ABC</SiteID>
                <Owner>NLP</Owner>
                <AttributesList>
                    <Attribute>
                        <AttributeName>My Lot Lookup Attribute</AttributeName>
                        <AttributeValue>Red</AttributeValue>
                    </Attribute>
                    <Attribute>
                        <AttributeName>My Lot Text Attribute</AttributeName>
                        <AttributeValue>425-949-3313</AttributeValue>
                    </Attribute>
                    <Attribute>
                        <AttributeName>My Lot Date Attribute</AttributeName>
                        <AttributeValue>2020-01-20</AttributeValue>
                    </Attribute>
                </AttributesList>
            </LotAttribute>
        </LotAttributeList>
    </Attributes>
    <Pallets>
      <ItemPallet>
         <ItemID>1234321</ItemID>
         <Lot>18001</Lot>
         <SiteID>ABC</SiteID>
         <Owner>NLP</Owner>
         <PalletList>
            <Pallet>
               <Number>12345</Number>
               <Units>2</Units>
               <UnitsUOMID>CASE</UnitsUOMID>
               <Weight>60</Weight>
               <WeightUOMID>LB</WeightUOMID>
            </Pallet>
            <Pallet>
               <Number>23456</Number>
               <Units>2</Units>
               <UnitsUOMID>CASE</UnitsUOMID>
               <Weight>60</Weight>
               <WeightUOMID>LB</WeightUOMID>
            </Pallet>
            <Pallet>
               <Number>34567</Number>
               <Units>1</Units>
               <UnitsUOMID>CASE</UnitsUOMID>
               <Weight>30.55</Weight>
               <WeightUOMID>LB</WeightUOMID>
            </Pallet>
         </PalletList>
      </ItemPallet>
   </Pallets>
 <Certifications>
      <LotCertificationsList>
         <LotCertification>
            <ItemID>1234321</ItemID>
            <Lot>18001</Lot>
            <SiteID>ABC</SiteID>
            <Owner>NLP</Owner>
            <CertificationsList>
               <Certification>
                  <CertificationName>MSC</CertificationName>
                  <CertificationValue>Yes</CertificationValue>
               </Certification>
               <Certification>
                  <CertificationName>Kosher</CertificationName>
                  <CertificationValue>No</CertificationValue>
               </Certification>
               <Certification>
                  <CertificationName>Vegan</CertificationName>
                  <CertificationValue><!--The absence of a value implies No --></CertificationValue>
               </Certification>
               <!--   The absence of a whole certification implies No           
               <Certification>
                  <CertificationName>Peanut</CertificationName>
                  <CertificationValue>No</CertificationValue>
               </Certification>
               -->
            </CertificationsList>
         </LotCertification>
      </LotCertificationsList>
   </Certifications>
</TransactionHeader>

Versions Compared

Old Version 5

New Version Current

Key