JiwaAPI

IN_WarehouseSOHQuery

The following routes are available for this service:
GET	/Queries/IN_WarehouseSOH	Retrieves a list of inventory stock levels per warehouse.

**IN_WarehouseSOHQuery** Parameters:
Name	Parameter	Data Type	Required
IN_WarehouseSOHID	query	string	No
IN_WarehouseSOHIDStartsWith	query	string	No
IN_WarehouseSOHIDEndsWith	query	string	No
IN_WarehouseSOHIDContains	query	string	No
IN_WarehouseSOHIDLike	query	string	No
IN_WarehouseSOHIDBetween	query	string[]	No
IN_WarehouseSOHIDIn	query	string[]	No
InventoryID	query	string	No
InventoryIDStartsWith	query	string	No
InventoryIDEndsWith	query	string	No
InventoryIDContains	query	string	No
InventoryIDLike	query	string	No
InventoryIDBetween	query	string[]	No
InventoryIDIn	query	string[]	No
IN_LogicalID	query	string	No
IN_LogicalIDStartsWith	query	string	No
IN_LogicalIDEndsWith	query	string	No
IN_LogicalIDContains	query	string	No
IN_LogicalIDLike	query	string	No
IN_LogicalIDBetween	query	string[]	No
IN_LogicalIDIn	query	string[]	No
QuantityLeft	query	decimal?	No
QuantityLeftGreaterThanOrEqualTo	query	decimal?	No
QuantityLeftGreaterThan	query	decimal?	No
QuantityLeftLessThan	query	decimal?	No
QuantityLeftLessThanOrEqualTo	query	decimal?	No
QuantityLeftNotEqualTo	query	decimal?	No
QuantityLeftBetween	query	Nullable<Decimal>[]	No
QuantityLeftIn	query	Nullable<Decimal>[]	No
QuantityAllocated	query	decimal?	No
QuantityAllocatedGreaterThanOrEqualTo	query	decimal?	No
QuantityAllocatedGreaterThan	query	decimal?	No
QuantityAllocatedLessThan	query	decimal?	No
QuantityAllocatedLessThanOrEqualTo	query	decimal?	No
QuantityAllocatedNotEqualTo	query	decimal?	No
QuantityAllocatedBetween	query	Nullable<Decimal>[]	No
QuantityAllocatedIn	query	Nullable<Decimal>[]	No
PickAllocated	query	decimal?	No
PickAllocatedGreaterThanOrEqualTo	query	decimal?	No
PickAllocatedGreaterThan	query	decimal?	No
PickAllocatedLessThan	query	decimal?	No
PickAllocatedLessThanOrEqualTo	query	decimal?	No
PickAllocatedNotEqualTo	query	decimal?	No
PickAllocatedBetween	query	Nullable<Decimal>[]	No
PickAllocatedIn	query	Nullable<Decimal>[]	No
ShipAllocated	query	decimal?	No
ShipAllocatedGreaterThanOrEqualTo	query	decimal?	No
ShipAllocatedGreaterThan	query	decimal?	No
ShipAllocatedLessThan	query	decimal?	No
ShipAllocatedLessThanOrEqualTo	query	decimal?	No
ShipAllocatedNotEqualTo	query	decimal?	No
ShipAllocatedBetween	query	Nullable<Decimal>[]	No
ShipAllocatedIn	query	Nullable<Decimal>[]	No
ForwardRequirements	query	decimal?	No
ForwardRequirementsGreaterThanOrEqualTo	query	decimal?	No
ForwardRequirementsGreaterThan	query	decimal?	No
ForwardRequirementsLessThan	query	decimal?	No
ForwardRequirementsLessThanOrEqualTo	query	decimal?	No
ForwardRequirementsNotEqualTo	query	decimal?	No
ForwardRequirementsBetween	query	Nullable<Decimal>[]	No
ForwardRequirementsIn	query	Nullable<Decimal>[]	No
TransferAllocated	query	decimal?	No
TransferAllocatedGreaterThanOrEqualTo	query	decimal?	No
TransferAllocatedGreaterThan	query	decimal?	No
TransferAllocatedLessThan	query	decimal?	No
TransferAllocatedLessThanOrEqualTo	query	decimal?	No
TransferAllocatedNotEqualTo	query	decimal?	No
TransferAllocatedBetween	query	Nullable<Decimal>[]	No
TransferAllocatedIn	query	Nullable<Decimal>[]	No
BOMAllocated	query	decimal?	No
BOMAllocatedGreaterThanOrEqualTo	query	decimal?	No
BOMAllocatedGreaterThan	query	decimal?	No
BOMAllocatedLessThan	query	decimal?	No
BOMAllocatedLessThanOrEqualTo	query	decimal?	No
BOMAllocatedNotEqualTo	query	decimal?	No
BOMAllocatedBetween	query	Nullable<Decimal>[]	No
BOMAllocatedIn	query	Nullable<Decimal>[]	No

**QueryBase** Parameters:
Name	Parameter	Data Type	Required
Skip	form	int?	No
Take	form	int?	No
OrderBy	form	string	No
OrderByDesc	form	string	No
Include	form	string	No
Fields	form	string	No
Meta	form	Dictionary<string, string>	No

**IN_WarehouseSOH** Parameters:
Name	Parameter	Data Type	Required
IN_WarehouseSOHID	form	string	No
InventoryID	form	string	No
IN_LogicalID	form	string	No
QuantityLeft	form	decimal?	No
QuantityAllocated	form	decimal?	No
PickAllocated	form	decimal?	No
ShipAllocated	form	decimal?	No
ForwardRequirements	form	decimal?	No
TransferAllocated	form	decimal?	No
BOMAllocated	form	decimal?	No

**QueryResponse<T>** Parameters:
Name	Parameter	Data Type	Required
Offset	form	int	No
Total	form	int	No
Results	form	List<T>	No
Meta	form	Dictionary<string, string>	No
ResponseStatus	form	ResponseStatus	No

To override the Content-type in your clients, use the HTTP Accept Header, append the .xml suffix or ?format=xml

HTTP + XML

The following are sample HTTP requests and responses. The placeholders shown need to be replaced with actual values.

GET /Queries/IN_WarehouseSOH HTTP/1.1 
Host: api.jiwa.com.au 
Accept: application/xml

HTTP/1.1 200 OK
Content-Type: application/xml
Content-Length: length

<QueryResponseOfIN_WarehouseSOH7kRqkrSv xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.servicestack.net/types">
  <Offset>0</Offset>
  <Total>0</Total>
  <Results xmlns:d2p1="http://schemas.datacontract.org/2004/07/JiwaFinancials.Jiwa.JiwaServiceModel.Tables">
    <d2p1:IN_WarehouseSOH>
      <d2p1:_x003C_BOMAllocated_x003E_k__BackingField>0</d2p1:_x003C_BOMAllocated_x003E_k__BackingField>
      <d2p1:_x003C_ForwardRequirements_x003E_k__BackingField>0</d2p1:_x003C_ForwardRequirements_x003E_k__BackingField>
      <d2p1:_x003C_IN_LogicalID_x003E_k__BackingField>String</d2p1:_x003C_IN_LogicalID_x003E_k__BackingField>
      <d2p1:_x003C_IN_WarehouseSOHID_x003E_k__BackingField>String</d2p1:_x003C_IN_WarehouseSOHID_x003E_k__BackingField>
      <d2p1:_x003C_InventoryID_x003E_k__BackingField>String</d2p1:_x003C_InventoryID_x003E_k__BackingField>
      <d2p1:_x003C_PickAllocated_x003E_k__BackingField>0</d2p1:_x003C_PickAllocated_x003E_k__BackingField>
      <d2p1:_x003C_QuantityAllocated_x003E_k__BackingField>0</d2p1:_x003C_QuantityAllocated_x003E_k__BackingField>
      <d2p1:_x003C_QuantityLeft_x003E_k__BackingField>0</d2p1:_x003C_QuantityLeft_x003E_k__BackingField>
      <d2p1:_x003C_ShipAllocated_x003E_k__BackingField>0</d2p1:_x003C_ShipAllocated_x003E_k__BackingField>
      <d2p1:_x003C_TransferAllocated_x003E_k__BackingField>0</d2p1:_x003C_TransferAllocated_x003E_k__BackingField>
    </d2p1:IN_WarehouseSOH>
  </Results>
  <Meta xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:KeyValueOfstringstring>
      <d2p1:Key>String</d2p1:Key>
      <d2p1:Value>String</d2p1:Value>
    </d2p1:KeyValueOfstringstring>
  </Meta>
  <ResponseStatus>
    <ErrorCode>String</ErrorCode>
    <Message>String</Message>
    <StackTrace>String</StackTrace>
    <Errors>
      <ResponseError>
        <ErrorCode>String</ErrorCode>
        <FieldName>String</FieldName>
        <Message>String</Message>
        <Meta xmlns:d5p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
          <d5p1:KeyValueOfstringstring>
            <d5p1:Key>String</d5p1:Key>
            <d5p1:Value>String</d5p1:Value>
          </d5p1:KeyValueOfstringstring>
        </Meta>
      </ResponseError>
    </Errors>
    <Meta xmlns:d3p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
      <d3p1:KeyValueOfstringstring>
        <d3p1:Key>String</d3p1:Key>
        <d3p1:Value>String</d3p1:Value>
      </d3p1:KeyValueOfstringstring>
    </Meta>
  </ResponseStatus>
</QueryResponseOfIN_WarehouseSOH7kRqkrSv>