POST jxc_api/VerticalBalances/Search

Request Information

URI Parameters

None.

Body Parameters

Name	Type	Additional information
StockDate	date	None.
WhIds	Collection of integer	None.
ShowDisableWh	boolean	None.
WhCatId	Collection of integer	None.
WhRange	Collection of integer	None.
ProdIds	Collection of integer	None.
CatId	Collection of integer	None.
Spec	string	None.
WithZero	boolean	None.
WithMinus	boolean	None.
ShowDisableProd	boolean	None.
UseAP	boolean	None.
Keyword	string	None.
LoadPrice	boolean	None.
WlSelects	Collection of WlSelect	None.
NoneDataAfterWhCatFilter	boolean	None.
FinalStockFlag	boolean	None.
PageIndex	integer	None.
PageSize	integer	None.
UsePager	boolean	None.
UseAsyncFileProcess	boolean	None.
AsyncFileType	AsyncFileType	None.
CustomSearchAndOrderCondition	CustomSearchAndOrderCondition	None.
ShowWarelocation	boolean	None.
ShowSubTotal	boolean	None.
StatsSummaryType	SummaryType	None.

Request Formats

application/json, text/json

Sample:

{
  "StockDate": "2025-05-12 14:12:13",
  "WhIds": [
    1,
    2
  ],
  "ShowDisableWh": true,
  "WhCatId": [
    1,
    2
  ],
  "WhRange": [
    1,
    2
  ],
  "ProdIds": [
    1,
    2
  ],
  "CatId": [
    1,
    2
  ],
  "Spec": "sample string 3",
  "WithZero": true,
  "WithMinus": true,
  "ShowDisableProd": true,
  "UseAP": true,
  "Keyword": "sample string 8",
  "LoadPrice": true,
  "WlSelects": [
    {
      "WhId": 1,
      "WlId": 2
    },
    {
      "WhId": 1,
      "WlId": 2
    }
  ],
  "NoneDataAfterWhCatFilter": true,
  "FinalStockFlag": true,
  "PageIndex": 12,
  "PageSize": 13,
  "UsePager": true,
  "UseAsyncFileProcess": true,
  "AsyncFileType": 10100110,
  "CustomSearchAndOrderCondition": {
    "OrderColumnName": "sample string 1",
    "OrderType": 0,
    "CustomSearchParams": [
      {
        "ColumnName": "sample string 1",
        "Params": [
          {},
          {}
        ]
      },
      {
        "ColumnName": "sample string 1",
        "Params": [
          {},
          {}
        ]
      }
    ]
  },
  "ShowWarelocation": true,
  "ShowSubTotal": true,
  "StatsSummaryType": 1
}

application/xml, text/xml

Sample:

<StockBalanceSearchCondition xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.datacontract.org/2004/07/LemonScm.Model.Stock">
  <_x003C_AsyncFileType_x003E_k__BackingField>PurchaseOrderListExport</_x003C_AsyncFileType_x003E_k__BackingField>
  <_x003C_CatId_x003E_k__BackingField xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:int>1</d2p1:int>
    <d2p1:int>2</d2p1:int>
  </_x003C_CatId_x003E_k__BackingField>
  <_x003C_CustomSearchAndOrderCondition_x003E_k__BackingField xmlns:d2p1="http://schemas.datacontract.org/2004/07/LemonScm.Model.Abstraction.NewApi.BaseData">
    <d2p1:CustomSearchParams>
      <d2p1:CustomSearchParam>
        <d2p1:ColumnName>sample string 1</d2p1:ColumnName>
        <d2p1:Params xmlns:d5p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
          <d5p1:anyType />
          <d5p1:anyType />
        </d2p1:Params>
      </d2p1:CustomSearchParam>
      <d2p1:CustomSearchParam>
        <d2p1:ColumnName>sample string 1</d2p1:ColumnName>
        <d2p1:Params xmlns:d5p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
          <d5p1:anyType />
          <d5p1:anyType />
        </d2p1:Params>
      </d2p1:CustomSearchParam>
    </d2p1:CustomSearchParams>
    <d2p1:OrderColumnName>sample string 1</d2p1:OrderColumnName>
    <d2p1:OrderType>None</d2p1:OrderType>
  </_x003C_CustomSearchAndOrderCondition_x003E_k__BackingField>
  <_x003C_FinalStockFlag_x003E_k__BackingField>true</_x003C_FinalStockFlag_x003E_k__BackingField>
  <_x003C_Keyword_x003E_k__BackingField>sample string 8</_x003C_Keyword_x003E_k__BackingField>
  <_x003C_LoadPrice_x003E_k__BackingField>true</_x003C_LoadPrice_x003E_k__BackingField>
  <_x003C_NoneDataAfterWhCatFilter_x003E_k__BackingField>true</_x003C_NoneDataAfterWhCatFilter_x003E_k__BackingField>
  <_x003C_PageIndex_x003E_k__BackingField>12</_x003C_PageIndex_x003E_k__BackingField>
  <_x003C_PageSize_x003E_k__BackingField>13</_x003C_PageSize_x003E_k__BackingField>
  <_x003C_ProdIds_x003E_k__BackingField xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:int>1</d2p1:int>
    <d2p1:int>2</d2p1:int>
  </_x003C_ProdIds_x003E_k__BackingField>
  <_x003C_ShowDisableProd_x003E_k__BackingField>true</_x003C_ShowDisableProd_x003E_k__BackingField>
  <_x003C_ShowDisableWh_x003E_k__BackingField>true</_x003C_ShowDisableWh_x003E_k__BackingField>
  <_x003C_ShowSubTotal_x003E_k__BackingField>true</_x003C_ShowSubTotal_x003E_k__BackingField>
  <_x003C_ShowWarelocation_x003E_k__BackingField>true</_x003C_ShowWarelocation_x003E_k__BackingField>
  <_x003C_Spec_x003E_k__BackingField>sample string 3</_x003C_Spec_x003E_k__BackingField>
  <_x003C_StatsSummaryType_x003E_k__BackingField>ProdAndWareHouse</_x003C_StatsSummaryType_x003E_k__BackingField>
  <_x003C_StockDate_x003E_k__BackingField>2025-05-12T14:12:13.5028239+08:00</_x003C_StockDate_x003E_k__BackingField>
  <_x003C_UseAP_x003E_k__BackingField>true</_x003C_UseAP_x003E_k__BackingField>
  <_x003C_UseAsyncFileProcess_x003E_k__BackingField>true</_x003C_UseAsyncFileProcess_x003E_k__BackingField>
  <_x003C_UsePager_x003E_k__BackingField>true</_x003C_UsePager_x003E_k__BackingField>
  <_x003C_WhCatId_x003E_k__BackingField xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:int>1</d2p1:int>
    <d2p1:int>2</d2p1:int>
  </_x003C_WhCatId_x003E_k__BackingField>
  <_x003C_WhIds_x003E_k__BackingField xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:int>1</d2p1:int>
    <d2p1:int>2</d2p1:int>
  </_x003C_WhIds_x003E_k__BackingField>
  <_x003C_WhRange_x003E_k__BackingField xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:int>1</d2p1:int>
    <d2p1:int>2</d2p1:int>
  </_x003C_WhRange_x003E_k__BackingField>
  <_x003C_WithMinus_x003E_k__BackingField>true</_x003C_WithMinus_x003E_k__BackingField>
  <_x003C_WithZero_x003E_k__BackingField>true</_x003C_WithZero_x003E_k__BackingField>
  <_x003C_WlSelects_x003E_k__BackingField xmlns:d2p1="http://schemas.datacontract.org/2004/07/LemonScm.Model.NewApi">
    <d2p1:WlSelect>
      <d2p1:WhId>1</d2p1:WhId>
      <d2p1:WlId>2</d2p1:WlId>
    </d2p1:WlSelect>
    <d2p1:WlSelect>
      <d2p1:WhId>1</d2p1:WhId>
      <d2p1:WlId>2</d2p1:WlId>
    </d2p1:WlSelect>
  </_x003C_WlSelects_x003E_k__BackingField>
</StockBalanceSearchCondition>

application/x-www-form-urlencoded

Sample:

Sample not available.

Response Information

Resource Description

ReportResultOfStockVerticalBalanceModel

Name	Type	Additional information
DataList	Collection of StockVerticalBalanceModel	None.
TotalRow	StockVerticalBalanceModel	None.
PageIndex	integer	None.
PageSize	integer	None.
Total	integer	None.
RDocumentStartDate	string	None.
RDocumentEndDate	string	None.
RDeliveryStartDate	string	None.
RDeliveryEndDate	string	None.

Response Formats

application/json, text/json

Sample:

{
  "DataList": [
    {
      "Id": 1,
      "Status": 2,
      "WhId": 3,
      "WhCatId": 4,
      "WhCatName": "sample string 5",
      "WlId": 6,
      "WhName": "sample string 7",
      "WhNo": "sample string 8",
      "WlName": "sample string 9",
      "WlNo": "sample string 10",
      "UnitQty": 11.0,
      "Cost": 12.0,
      "UnitCost": 13.0,
      "MunitQty": "sample string 14",
      "StockUnitQty": "sample string 15",
      "No": "sample string 16",
      "ProdName": "sample string 17",
      "CatName": "sample string 18",
      "Spec": "sample string 19",
      "Brand": "sample string 20",
      "ProdLocation": "sample string 21",
      "UnitName": "sample string 23",
      "MunitName": "sample string 24",
      "StockUnitName": "sample string 25",
      "ApId": 26,
      "AssistingProperty": true,
      "UseMultiUnits": true,
      "SerialEnabled": true,
      "BatchEnabled": true,
      "LifeTimeEnabled": true,
      "IsApRow": true,
      "IsCountRow": true,
      "ApName": "sample string 34",
      "LastOrder": 35,
      "Image": "sample string 36"
    },
    {
      "Id": 1,
      "Status": 2,
      "WhId": 3,
      "WhCatId": 4,
      "WhCatName": "sample string 5",
      "WlId": 6,
      "WhName": "sample string 7",
      "WhNo": "sample string 8",
      "WlName": "sample string 9",
      "WlNo": "sample string 10",
      "UnitQty": 11.0,
      "Cost": 12.0,
      "UnitCost": 13.0,
      "MunitQty": "sample string 14",
      "StockUnitQty": "sample string 15",
      "No": "sample string 16",
      "ProdName": "sample string 17",
      "CatName": "sample string 18",
      "Spec": "sample string 19",
      "Brand": "sample string 20",
      "ProdLocation": "sample string 21",
      "UnitName": "sample string 23",
      "MunitName": "sample string 24",
      "StockUnitName": "sample string 25",
      "ApId": 26,
      "AssistingProperty": true,
      "UseMultiUnits": true,
      "SerialEnabled": true,
      "BatchEnabled": true,
      "LifeTimeEnabled": true,
      "IsApRow": true,
      "IsCountRow": true,
      "ApName": "sample string 34",
      "LastOrder": 35,
      "Image": "sample string 36"
    }
  ],
  "TotalRow": {
    "Id": 1,
    "Status": 2,
    "WhId": 3,
    "WhCatId": 4,
    "WhCatName": "sample string 5",
    "WlId": 6,
    "WhName": "sample string 7",
    "WhNo": "sample string 8",
    "WlName": "sample string 9",
    "WlNo": "sample string 10",
    "UnitQty": 11.0,
    "Cost": 12.0,
    "UnitCost": 13.0,
    "MunitQty": "sample string 14",
    "StockUnitQty": "sample string 15",
    "No": "sample string 16",
    "ProdName": "sample string 17",
    "CatName": "sample string 18",
    "Spec": "sample string 19",
    "Brand": "sample string 20",
    "ProdLocation": "sample string 21",
    "UnitName": "sample string 23",
    "MunitName": "sample string 24",
    "StockUnitName": "sample string 25",
    "ApId": 26,
    "AssistingProperty": true,
    "UseMultiUnits": true,
    "SerialEnabled": true,
    "BatchEnabled": true,
    "LifeTimeEnabled": true,
    "IsApRow": true,
    "IsCountRow": true,
    "ApName": "sample string 34",
    "LastOrder": 35,
    "Image": "sample string 36"
  },
  "PageIndex": 1,
  "PageSize": 2,
  "Total": 3,
  "RDocumentStartDate": "sample string 4",
  "RDocumentEndDate": "sample string 5",
  "RDeliveryStartDate": "sample string 6",
  "RDeliveryEndDate": "sample string 7"
}

application/xml, text/xml

Sample:

<ReportResultOfStockVerticalBalanceModelXjY_Puht2 xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.datacontract.org/2004/07/LemonScm.Model.Abstraction.NewApi">
  <_x003C_RDeliveryEndDate_x003E_k__BackingField xmlns="http://schemas.datacontract.org/2004/07/LemonScm.Model.Abstraction.CommonData">sample string 7</_x003C_RDeliveryEndDate_x003E_k__BackingField>
  <_x003C_RDeliveryStartDate_x003E_k__BackingField xmlns="http://schemas.datacontract.org/2004/07/LemonScm.Model.Abstraction.CommonData">sample string 6</_x003C_RDeliveryStartDate_x003E_k__BackingField>
  <_x003C_RDocumentEndDate_x003E_k__BackingField xmlns="http://schemas.datacontract.org/2004/07/LemonScm.Model.Abstraction.CommonData">sample string 5</_x003C_RDocumentEndDate_x003E_k__BackingField>
  <_x003C_RDocumentStartDate_x003E_k__BackingField xmlns="http://schemas.datacontract.org/2004/07/LemonScm.Model.Abstraction.CommonData">sample string 4</_x003C_RDocumentStartDate_x003E_k__BackingField>
  <DataList xmlns:d2p1="http://schemas.datacontract.org/2004/07/LemonScm.WebApi.Areas.Storage.Models">
    <d2p1:StockVerticalBalanceModel>
      <d2p1:ApId>26</d2p1:ApId>
      <d2p1:ApName>sample string 34</d2p1:ApName>
      <d2p1:AssistingProperty>true</d2p1:AssistingProperty>
      <d2p1:BatchEnabled>true</d2p1:BatchEnabled>
      <d2p1:Brand>sample string 20</d2p1:Brand>
      <d2p1:CatName>sample string 18</d2p1:CatName>
      <d2p1:Cost>12</d2p1:Cost>
      <d2p1:Id>1</d2p1:Id>
      <d2p1:Image>sample string 36</d2p1:Image>
      <d2p1:IsApRow>true</d2p1:IsApRow>
      <d2p1:IsCountRow>true</d2p1:IsCountRow>
      <d2p1:LastOrder>35</d2p1:LastOrder>
      <d2p1:LifeTimeEnabled>true</d2p1:LifeTimeEnabled>
      <d2p1:MunitName>sample string 24</d2p1:MunitName>
      <d2p1:MunitQty>sample string 14</d2p1:MunitQty>
      <d2p1:No>sample string 16</d2p1:No>
      <d2p1:ProdLocation>sample string 21</d2p1:ProdLocation>
      <d2p1:ProdName>sample string 17</d2p1:ProdName>
      <d2p1:SerialEnabled>true</d2p1:SerialEnabled>
      <d2p1:Spec>sample string 19</d2p1:Spec>
      <d2p1:Status>2</d2p1:Status>
      <d2p1:StockUnitName>sample string 25</d2p1:StockUnitName>
      <d2p1:StockUnitQty>sample string 15</d2p1:StockUnitQty>
      <d2p1:UnitCost>13</d2p1:UnitCost>
      <d2p1:UnitId>22</d2p1:UnitId>
      <d2p1:UnitName>sample string 23</d2p1:UnitName>
      <d2p1:UnitQty>11</d2p1:UnitQty>
      <d2p1:UseMultiUnits>true</d2p1:UseMultiUnits>
      <d2p1:WhCatId>4</d2p1:WhCatId>
      <d2p1:WhCatName>sample string 5</d2p1:WhCatName>
      <d2p1:WhId>3</d2p1:WhId>
      <d2p1:WhName>sample string 7</d2p1:WhName>
      <d2p1:WhNo>sample string 8</d2p1:WhNo>
      <d2p1:WlId>6</d2p1:WlId>
      <d2p1:WlName>sample string 9</d2p1:WlName>
      <d2p1:WlNo>sample string 10</d2p1:WlNo>
    </d2p1:StockVerticalBalanceModel>
    <d2p1:StockVerticalBalanceModel>
      <d2p1:ApId>26</d2p1:ApId>
      <d2p1:ApName>sample string 34</d2p1:ApName>
      <d2p1:AssistingProperty>true</d2p1:AssistingProperty>
      <d2p1:BatchEnabled>true</d2p1:BatchEnabled>
      <d2p1:Brand>sample string 20</d2p1:Brand>
      <d2p1:CatName>sample string 18</d2p1:CatName>
      <d2p1:Cost>12</d2p1:Cost>
      <d2p1:Id>1</d2p1:Id>
      <d2p1:Image>sample string 36</d2p1:Image>
      <d2p1:IsApRow>true</d2p1:IsApRow>
      <d2p1:IsCountRow>true</d2p1:IsCountRow>
      <d2p1:LastOrder>35</d2p1:LastOrder>
      <d2p1:LifeTimeEnabled>true</d2p1:LifeTimeEnabled>
      <d2p1:MunitName>sample string 24</d2p1:MunitName>
      <d2p1:MunitQty>sample string 14</d2p1:MunitQty>
      <d2p1:No>sample string 16</d2p1:No>
      <d2p1:ProdLocation>sample string 21</d2p1:ProdLocation>
      <d2p1:ProdName>sample string 17</d2p1:ProdName>
      <d2p1:SerialEnabled>true</d2p1:SerialEnabled>
      <d2p1:Spec>sample string 19</d2p1:Spec>
      <d2p1:Status>2</d2p1:Status>
      <d2p1:StockUnitName>sample string 25</d2p1:StockUnitName>
      <d2p1:StockUnitQty>sample string 15</d2p1:StockUnitQty>
      <d2p1:UnitCost>13</d2p1:UnitCost>
      <d2p1:UnitId>22</d2p1:UnitId>
      <d2p1:UnitName>sample string 23</d2p1:UnitName>
      <d2p1:UnitQty>11</d2p1:UnitQty>
      <d2p1:UseMultiUnits>true</d2p1:UseMultiUnits>
      <d2p1:WhCatId>4</d2p1:WhCatId>
      <d2p1:WhCatName>sample string 5</d2p1:WhCatName>
      <d2p1:WhId>3</d2p1:WhId>
      <d2p1:WhName>sample string 7</d2p1:WhName>
      <d2p1:WhNo>sample string 8</d2p1:WhNo>
      <d2p1:WlId>6</d2p1:WlId>
      <d2p1:WlName>sample string 9</d2p1:WlName>
      <d2p1:WlNo>sample string 10</d2p1:WlNo>
    </d2p1:StockVerticalBalanceModel>
  </DataList>
  <PageIndex>1</PageIndex>
  <PageSize>2</PageSize>
  <Total>3</Total>
  <TotalRow xmlns:d2p1="http://schemas.datacontract.org/2004/07/LemonScm.WebApi.Areas.Storage.Models">
    <d2p1:ApId>26</d2p1:ApId>
    <d2p1:ApName>sample string 34</d2p1:ApName>
    <d2p1:AssistingProperty>true</d2p1:AssistingProperty>
    <d2p1:BatchEnabled>true</d2p1:BatchEnabled>
    <d2p1:Brand>sample string 20</d2p1:Brand>
    <d2p1:CatName>sample string 18</d2p1:CatName>
    <d2p1:Cost>12</d2p1:Cost>
    <d2p1:Id>1</d2p1:Id>
    <d2p1:Image>sample string 36</d2p1:Image>
    <d2p1:IsApRow>true</d2p1:IsApRow>
    <d2p1:IsCountRow>true</d2p1:IsCountRow>
    <d2p1:LastOrder>35</d2p1:LastOrder>
    <d2p1:LifeTimeEnabled>true</d2p1:LifeTimeEnabled>
    <d2p1:MunitName>sample string 24</d2p1:MunitName>
    <d2p1:MunitQty>sample string 14</d2p1:MunitQty>
    <d2p1:No>sample string 16</d2p1:No>
    <d2p1:ProdLocation>sample string 21</d2p1:ProdLocation>
    <d2p1:ProdName>sample string 17</d2p1:ProdName>
    <d2p1:SerialEnabled>true</d2p1:SerialEnabled>
    <d2p1:Spec>sample string 19</d2p1:Spec>
    <d2p1:Status>2</d2p1:Status>
    <d2p1:StockUnitName>sample string 25</d2p1:StockUnitName>
    <d2p1:StockUnitQty>sample string 15</d2p1:StockUnitQty>
    <d2p1:UnitCost>13</d2p1:UnitCost>
    <d2p1:UnitId>22</d2p1:UnitId>
    <d2p1:UnitName>sample string 23</d2p1:UnitName>
    <d2p1:UnitQty>11</d2p1:UnitQty>
    <d2p1:UseMultiUnits>true</d2p1:UseMultiUnits>
    <d2p1:WhCatId>4</d2p1:WhCatId>
    <d2p1:WhCatName>sample string 5</d2p1:WhCatName>
    <d2p1:WhId>3</d2p1:WhId>
    <d2p1:WhName>sample string 7</d2p1:WhName>
    <d2p1:WhNo>sample string 8</d2p1:WhNo>
    <d2p1:WlId>6</d2p1:WlId>
    <d2p1:WlName>sample string 9</d2p1:WlName>
    <d2p1:WlNo>sample string 10</d2p1:WlNo>
  </TotalRow>
</ReportResultOfStockVerticalBalanceModelXjY_Puht2>