POST api/storageQuery/QueryTablecolumns

Request Information

URI Parameters

None.

Body Parameters

Name	Type	Additional information
CreateTimeBegin	date	None.
CreateTimeEnd	date	None.
sendDateBegin	date	None.
sendEndDate	date	None.
SelectQty	decimal number	None.
selectQtyString	string	None.
BusHeadId	integer	None.
defaultcol	Collection of columnsModel	None.
Id	integer	None.
OrderNo	string	None.
OrderLineNo	integer	None.
CustomerID	string	None.
SKU	string	None.
LineStatus	string	None.
LotNum	string	None.
LotAtt01	string	None.
LotAtt02	string	None.
LotAtt03	string	None.
LotAtt04	string	None.
LotAtt05	string	None.
LotAtt06	string	None.
LotAtt07	string	None.
LotAtt08	string	None.
LotAtt09	string	None.
LotAtt10	string	None.
LotAtt11	string	None.
LotAtt12	string	None.
LotAtt13	string	None.
LotAtt14	string	None.
LotAtt15	string	None.
LotAtt16	string	None.
LotAtt17	string	None.
LotAtt18	string	None.
Location	string	None.
QtyOrdered	decimal number	None.
QtyshippedEach	decimal number	None.
QtyOrigin	decimal number	None.
Usd1	string	None.
Usd2	string	None.
Usd3	string	None.
Usd4	string	None.
Usd5	string	None.
Notes	string	None.
GrossWeight	decimal number	None.
NetWeight	decimal number	None.
Cubic	decimal number	None.
Price	decimal number	None.
MoneyTrade	decimal number	None.
SaleNo	string	None.
ReferenceDocNumber	string	None.
CustomerMaterialNumber	string	None.
MovementType	string	None.
DnLineId	string	None.
DnNo	string	None.
HsCode	string	None.
GNo	decimal number	None.
GName	string	None.
InvoiceNo	string	None.
Unit	string	None.
DEdi09	decimal number	None.
DEdi10	decimal number	None.
KmsNo	string	None.
InvoiceLineNo	string	None.
Curr	string	None.
CustomerPo	string	None.
OrderType	string	None.
SendDate	string	None.
Cost	decimal number	None.
NetValue	decimal number	None.
SjCondition	string	None.
HgCondition	string	None.
WarehouseID	string	None.
FactoryID	string	None.
CreateDate	date	None.
CreateUser	string	None.
UpdateDate	date	None.
UpdateUser	string	None.
LeftQty	decimal number	None.
IsBom	string	None.
BomExgNo	string	None.
BomExgQty	decimal number	None.
BomExgMoney	decimal number	None.
AllocatDetailsCode	string	None.
GModel	string	None.
Unit1	string	None.
Unit2	string	None.
Qty1	string	None.
Qty2	string	None.
Country	string	None.
BillNo	string	None.
SasDclSeqno	integer	None.
DataFrom	integer	None.
DeclFlag	integer	None.
PageSize	integer	None.
PageIndex	integer	None.
TotalCount	integer	None.

Request Formats

application/json, text/json

Sample:

{
  "createTimeBegin": "2024-11-21 16:39:03",
  "createTimeEnd": "2024-11-21 16:39:03",
  "sendDateBegin": "2024-11-21 16:39:03",
  "sendEndDate": "2024-11-21 16:39:03",
  "selectQty": 1.0,
  "selectQtyString": "sample string 2",
  "busHeadId": 3,
  "defaultcol": [
    {
      "type": "sample string 1",
      "title": "sample string 2",
      "width": 3,
      "key": "sample string 4",
      "align": "sample string 5",
      "overHide": true,
      "statistics": true
    },
    {
      "type": "sample string 1",
      "title": "sample string 2",
      "width": 3,
      "key": "sample string 4",
      "align": "sample string 5",
      "overHide": true,
      "statistics": true
    }
  ],
  "id": 4,
  "orderNo": "sample string 5",
  "orderLineNo": 6,
  "customerID": "sample string 7",
  "sku": "sample string 8",
  "lineStatus": "sample string 9",
  "lotNum": "sample string 10",
  "lotAtt01": "sample string 11",
  "lotAtt02": "sample string 12",
  "lotAtt03": "sample string 13",
  "lotAtt04": "sample string 14",
  "lotAtt05": "sample string 15",
  "lotAtt06": "sample string 16",
  "lotAtt07": "sample string 17",
  "lotAtt08": "sample string 18",
  "lotAtt09": "sample string 19",
  "lotAtt10": "sample string 20",
  "lotAtt11": "sample string 21",
  "lotAtt12": "sample string 22",
  "lotAtt13": "sample string 23",
  "lotAtt14": "sample string 24",
  "lotAtt15": "sample string 25",
  "lotAtt16": "sample string 26",
  "lotAtt17": "sample string 27",
  "lotAtt18": "sample string 28",
  "location": "sample string 29",
  "qtyOrdered": 30.0,
  "qtyshippedEach": 31.0,
  "qtyOrigin": 32.0,
  "usd1": "sample string 33",
  "usd2": "sample string 34",
  "usd3": "sample string 35",
  "usd4": "sample string 36",
  "usd5": "sample string 37",
  "notes": "sample string 38",
  "grossWeight": 39.0,
  "netWeight": 40.0,
  "cubic": 41.0,
  "price": 42.0,
  "moneyTrade": 43.0,
  "saleNo": "sample string 44",
  "referenceDocNumber": "sample string 45",
  "customerMaterialNumber": "sample string 46",
  "movementType": "sample string 47",
  "dnLineId": "sample string 48",
  "dnNo": "sample string 49",
  "hsCode": "sample string 50",
  "gNo": 51.0,
  "gName": "sample string 52",
  "invoiceNo": "sample string 53",
  "unit": "sample string 54",
  "dEdi09": 55.0,
  "dEdi10": 56.0,
  "kmsNo": "sample string 57",
  "invoiceLineNo": "sample string 58",
  "curr": "sample string 59",
  "customerPo": "sample string 60",
  "orderType": "sample string 61",
  "sendDate": "sample string 62",
  "cost": 63.0,
  "netValue": 64.0,
  "sjCondition": "sample string 65",
  "hgCondition": "sample string 66",
  "warehouseID": "sample string 67",
  "factoryID": "sample string 68",
  "createDate": "2024-11-21 16:39:03",
  "createUser": "sample string 70",
  "updateDate": "2024-11-21 16:39:03",
  "updateUser": "sample string 72",
  "leftQty": 73.0,
  "isBom": "sample string 74",
  "bomExgNo": "sample string 75",
  "bomExgQty": 76.0,
  "bomExgMoney": 77.0,
  "allocatDetailsCode": "sample string 78",
  "gModel": "sample string 79",
  "unit1": "sample string 80",
  "unit2": "sample string 81",
  "qty1": "sample string 82",
  "qty2": "sample string 83",
  "country": "sample string 84",
  "billNo": "sample string 85",
  "sasDclSeqno": 86,
  "dataFrom": 87,
  "declFlag": 88,
  "pageSize": 89,
  "pageIndex": 90,
  "totalCount": 91
}

application/xml, text/xml

Sample:

<EntCusStockIn xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.datacontract.org/2004/07/Epass.Model">
  <PageIndex>90</PageIndex>
  <PageSize>89</PageSize>
  <TotalCount>91</TotalCount>
  <AllocatDetailsCode>sample string 78</AllocatDetailsCode>
  <BillNo>sample string 85</BillNo>
  <BomExgMoney>77</BomExgMoney>
  <BomExgNo>sample string 75</BomExgNo>
  <BomExgQty>76</BomExgQty>
  <BusHeadId>3</BusHeadId>
  <Cost>63</Cost>
  <Country>sample string 84</Country>
  <CreateDate>2024-11-21T16:39:03.7365801+08:00</CreateDate>
  <CreateTimeBegin>2024-11-21T16:39:03.7365801+08:00</CreateTimeBegin>
  <CreateTimeEnd>2024-11-21T16:39:03.7365801+08:00</CreateTimeEnd>
  <CreateUser>sample string 70</CreateUser>
  <Cubic>41</Cubic>
  <Curr>sample string 59</Curr>
  <CustomerID>sample string 7</CustomerID>
  <CustomerMaterialNumber>sample string 46</CustomerMaterialNumber>
  <CustomerPo>sample string 60</CustomerPo>
  <DEdi09>55</DEdi09>
  <DEdi10>56</DEdi10>
  <DataFrom>87</DataFrom>
  <DeclFlag>88</DeclFlag>
  <DnLineId>sample string 48</DnLineId>
  <DnNo>sample string 49</DnNo>
  <FactoryID>sample string 68</FactoryID>
  <GModel>sample string 79</GModel>
  <GName>sample string 52</GName>
  <GNo>51</GNo>
  <GrossWeight>39</GrossWeight>
  <HgCondition>sample string 66</HgCondition>
  <HsCode>sample string 50</HsCode>
  <Id>4</Id>
  <InvoiceLineNo>sample string 58</InvoiceLineNo>
  <InvoiceNo>sample string 53</InvoiceNo>
  <IsBom>sample string 74</IsBom>
  <KmsNo>sample string 57</KmsNo>
  <LeftQty>73</LeftQty>
  <LineStatus>sample string 9</LineStatus>
  <Location>sample string 29</Location>
  <LotAtt01>sample string 11</LotAtt01>
  <LotAtt02>sample string 12</LotAtt02>
  <LotAtt03>sample string 13</LotAtt03>
  <LotAtt04>sample string 14</LotAtt04>
  <LotAtt05>sample string 15</LotAtt05>
  <LotAtt06>sample string 16</LotAtt06>
  <LotAtt07>sample string 17</LotAtt07>
  <LotAtt08>sample string 18</LotAtt08>
  <LotAtt09>sample string 19</LotAtt09>
  <LotAtt10>sample string 20</LotAtt10>
  <LotAtt11>sample string 21</LotAtt11>
  <LotAtt12>sample string 22</LotAtt12>
  <LotAtt13>sample string 23</LotAtt13>
  <LotAtt14>sample string 24</LotAtt14>
  <LotAtt15>sample string 25</LotAtt15>
  <LotAtt16>sample string 26</LotAtt16>
  <LotAtt17>sample string 27</LotAtt17>
  <LotAtt18>sample string 28</LotAtt18>
  <LotNum>sample string 10</LotNum>
  <MoneyTrade>43</MoneyTrade>
  <MovementType>sample string 47</MovementType>
  <NetValue>64</NetValue>
  <NetWeight>40</NetWeight>
  <Notes>sample string 38</Notes>
  <OrderLineNo>6</OrderLineNo>
  <OrderNo>sample string 5</OrderNo>
  <OrderType>sample string 61</OrderType>
  <Price>42</Price>
  <Qty1>sample string 82</Qty1>
  <Qty2>sample string 83</Qty2>
  <QtyOrdered>30</QtyOrdered>
  <QtyOrigin>32</QtyOrigin>
  <QtyshippedEach>31</QtyshippedEach>
  <ReferenceDocNumber>sample string 45</ReferenceDocNumber>
  <SKU>sample string 8</SKU>
  <SaleNo>sample string 44</SaleNo>
  <SasDclSeqno>86</SasDclSeqno>
  <SelectQty>1</SelectQty>
  <SendDate>sample string 62</SendDate>
  <SjCondition>sample string 65</SjCondition>
  <Unit>sample string 54</Unit>
  <Unit1>sample string 80</Unit1>
  <Unit2>sample string 81</Unit2>
  <UpdateDate>2024-11-21T16:39:03.7365801+08:00</UpdateDate>
  <UpdateUser>sample string 72</UpdateUser>
  <Usd1>sample string 33</Usd1>
  <Usd2>sample string 34</Usd2>
  <Usd3>sample string 35</Usd3>
  <Usd4>sample string 36</Usd4>
  <Usd5>sample string 37</Usd5>
  <WarehouseID>sample string 67</WarehouseID>
  <defaultcol xmlns:d2p1="http://schemas.datacontract.org/2004/07/Epass.Model.Wms.RePortModel">
    <d2p1:columnsModel>
      <d2p1:align>sample string 5</d2p1:align>
      <d2p1:key>sample string 4</d2p1:key>
      <d2p1:overHide>true</d2p1:overHide>
      <d2p1:statistics>true</d2p1:statistics>
      <d2p1:title>sample string 2</d2p1:title>
      <d2p1:type>sample string 1</d2p1:type>
      <d2p1:width>3</d2p1:width>
    </d2p1:columnsModel>
    <d2p1:columnsModel>
      <d2p1:align>sample string 5</d2p1:align>
      <d2p1:key>sample string 4</d2p1:key>
      <d2p1:overHide>true</d2p1:overHide>
      <d2p1:statistics>true</d2p1:statistics>
      <d2p1:title>sample string 2</d2p1:title>
      <d2p1:type>sample string 1</d2p1:type>
      <d2p1:width>3</d2p1:width>
    </d2p1:columnsModel>
  </defaultcol>
  <selectQtyString>sample string 2</selectQtyString>
  <sendDateBegin>2024-11-21T16:39:03.7365801+08:00</sendDateBegin>
  <sendEndDate>2024-11-21T16:39:03.7365801+08:00</sendEndDate>
</EntCusStockIn>

application/x-www-form-urlencoded

Sample:

Sample not available.

Response Information

Resource Description

Collection of columnsModel

Name	Type	Additional information
type	string	None.
title	string	None.
width	integer	None.
key	string	None.
align	string	None.
overHide	boolean	None.
statistics	boolean	None.

Response Formats

application/json, text/json

Sample:

[
  {
    "type": "sample string 1",
    "title": "sample string 2",
    "width": 3,
    "key": "sample string 4",
    "align": "sample string 5",
    "overHide": true,
    "statistics": true
  },
  {
    "type": "sample string 1",
    "title": "sample string 2",
    "width": 3,
    "key": "sample string 4",
    "align": "sample string 5",
    "overHide": true,
    "statistics": true
  }
]

application/xml, text/xml

Sample:

<ArrayOfcolumnsModel xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.datacontract.org/2004/07/Epass.Model.Wms.RePortModel">
  <columnsModel>
    <align>sample string 5</align>
    <key>sample string 4</key>
    <overHide>true</overHide>
    <statistics>true</statistics>
    <title>sample string 2</title>
    <type>sample string 1</type>
    <width>3</width>
  </columnsModel>
  <columnsModel>
    <align>sample string 5</align>
    <key>sample string 4</key>
    <overHide>true</overHide>
    <statistics>true</statistics>
    <title>sample string 2</title>
    <type>sample string 1</type>
    <width>3</width>
  </columnsModel>
</ArrayOfcolumnsModel>