POST jxc_api/CashBank/Search

Request Information

URI Parameters

None.

Body Parameters

Name	Type	Additional information
StartDate	date	None.
EndDate	date	None.
CustIds	Collection of integer	None.
VendIds	Collection of integer	None.
AcIds	Collection of integer	None.
EmpIds	Collection of integer	None.
AcId	integer	None.
Keywords	string	None.
PageIndex	integer	None.
PageSize	integer	None.
UsePager	boolean	None.
CustomSearchAndOrderCondition	CustomSearchAndOrderCondition	None.
CurrUserSn	integer	None.
CanViewAllBill	boolean	None.
CanOpeAllWh	boolean	None.
OpeWhList	Collection of integer	None.
DocumentDateType	integer	None.
DocumentDateArr	Collection of date	None.
DeliveryDateType	integer	None.
DeliveryDateArr	Collection of date	None.
OffDateType	integer	None.
OffDateArr	Collection of date	None.
InventoryDateType	integer	None.
InventoryDateArr	Collection of date	None.
BillOrigins	Collection of integer	None.

Request Formats

application/json, text/json

Sample:

{
  "StartDate": "2025-04-04 20:52:23",
  "EndDate": "2025-04-04 20:52:23",
  "CustIds": [
    1,
    2
  ],
  "VendIds": [
    1,
    2
  ],
  "AcIds": [
    1,
    2
  ],
  "EmpIds": [
    1,
    2
  ],
  "AcId": 1,
  "Keywords": "sample string 2",
  "PageIndex": 3,
  "PageSize": 4,
  "UsePager": true,
  "CustomSearchAndOrderCondition": {
    "OrderColumnName": "sample string 1",
    "OrderType": 0,
    "CustomSearchParams": [
      {
        "ColumnName": "sample string 1",
        "Params": [
          {},
          {}
        ]
      },
      {
        "ColumnName": "sample string 1",
        "Params": [
          {},
          {}
        ]
      }
    ]
  },
  "CurrUserSn": 6,
  "CanViewAllBill": true,
  "CanOpeAllWh": true,
  "OpeWhList": [
    1,
    2
  ],
  "DocumentDateType": 9,
  "DocumentDateArr": [
    "2025-04-04 20:52:23",
    "2025-04-04 20:52:23"
  ],
  "DeliveryDateType": 10,
  "DeliveryDateArr": [
    "2025-04-04 20:52:23",
    "2025-04-04 20:52:23"
  ],
  "OffDateType": 11,
  "OffDateArr": [
    "2025-04-04 20:52:23",
    "2025-04-04 20:52:23"
  ],
  "InventoryDateType": 12,
  "InventoryDateArr": [
    "2025-04-04 20:52:23",
    "2025-04-04 20:52:23"
  ],
  "BillOrigins": [
    1,
    2
  ]
}

application/xml, text/xml

Sample:

<CashBankSearchConditions xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.datacontract.org/2004/07/LemonScm.Model.ReportModels">
  <_billOrigins xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays" xmlns="http://schemas.datacontract.org/2004/07/LemonScm.Model.Abstraction.Setting">
    <d2p1:int>1</d2p1:int>
    <d2p1:int>2</d2p1:int>
  </_billOrigins>
  <_x003C_DeliveryDateArr_x003E_k__BackingField xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays" xmlns="http://schemas.datacontract.org/2004/07/LemonScm.Model.Abstraction.Setting">
    <d2p1:dateTime>2025-04-04T20:52:23.1570031+08:00</d2p1:dateTime>
    <d2p1:dateTime>2025-04-04T20:52:23.1570031+08:00</d2p1:dateTime>
  </_x003C_DeliveryDateArr_x003E_k__BackingField>
  <_x003C_DeliveryDateType_x003E_k__BackingField xmlns="http://schemas.datacontract.org/2004/07/LemonScm.Model.Abstraction.Setting">10</_x003C_DeliveryDateType_x003E_k__BackingField>
  <_x003C_DocumentDateArr_x003E_k__BackingField xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays" xmlns="http://schemas.datacontract.org/2004/07/LemonScm.Model.Abstraction.Setting">
    <d2p1:dateTime>2025-04-04T20:52:23.1570031+08:00</d2p1:dateTime>
    <d2p1:dateTime>2025-04-04T20:52:23.1570031+08:00</d2p1:dateTime>
  </_x003C_DocumentDateArr_x003E_k__BackingField>
  <_x003C_DocumentDateType_x003E_k__BackingField xmlns="http://schemas.datacontract.org/2004/07/LemonScm.Model.Abstraction.Setting">9</_x003C_DocumentDateType_x003E_k__BackingField>
  <_x003C_InventoryDateArr_x003E_k__BackingField xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays" xmlns="http://schemas.datacontract.org/2004/07/LemonScm.Model.Abstraction.Setting">
    <d2p1:dateTime>2025-04-04T20:52:23.1570031+08:00</d2p1:dateTime>
    <d2p1:dateTime>2025-04-04T20:52:23.1570031+08:00</d2p1:dateTime>
  </_x003C_InventoryDateArr_x003E_k__BackingField>
  <_x003C_InventoryDateType_x003E_k__BackingField xmlns="http://schemas.datacontract.org/2004/07/LemonScm.Model.Abstraction.Setting">12</_x003C_InventoryDateType_x003E_k__BackingField>
  <_x003C_OffDateArr_x003E_k__BackingField xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays" xmlns="http://schemas.datacontract.org/2004/07/LemonScm.Model.Abstraction.Setting">
    <d2p1:dateTime>2025-04-04T20:52:23.1570031+08:00</d2p1:dateTime>
    <d2p1:dateTime>2025-04-04T20:52:23.1570031+08:00</d2p1:dateTime>
  </_x003C_OffDateArr_x003E_k__BackingField>
  <_x003C_OffDateType_x003E_k__BackingField xmlns="http://schemas.datacontract.org/2004/07/LemonScm.Model.Abstraction.Setting">11</_x003C_OffDateType_x003E_k__BackingField>
  <_x003C_CanOpeAllWh_x003E_k__BackingField xmlns="http://schemas.datacontract.org/2004/07/LemonScm.Model.Setting">true</_x003C_CanOpeAllWh_x003E_k__BackingField>
  <_x003C_CanViewAllBill_x003E_k__BackingField xmlns="http://schemas.datacontract.org/2004/07/LemonScm.Model.Setting">true</_x003C_CanViewAllBill_x003E_k__BackingField>
  <_x003C_CurrUserSn_x003E_k__BackingField xmlns="http://schemas.datacontract.org/2004/07/LemonScm.Model.Setting">6</_x003C_CurrUserSn_x003E_k__BackingField>
  <_x003C_OpeWhList_x003E_k__BackingField xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays" xmlns="http://schemas.datacontract.org/2004/07/LemonScm.Model.Setting">
    <d2p1:int>1</d2p1:int>
    <d2p1:int>2</d2p1:int>
  </_x003C_OpeWhList_x003E_k__BackingField>
  <_x003C_AcId_x003E_k__BackingField>1</_x003C_AcId_x003E_k__BackingField>
  <_x003C_AcIds_x003E_k__BackingField xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:int>1</d2p1:int>
    <d2p1:int>2</d2p1:int>
  </_x003C_AcIds_x003E_k__BackingField>
  <_x003C_CustIds_x003E_k__BackingField xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:int>1</d2p1:int>
    <d2p1:int>2</d2p1:int>
  </_x003C_CustIds_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_EmpIds_x003E_k__BackingField xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:int>1</d2p1:int>
    <d2p1:int>2</d2p1:int>
  </_x003C_EmpIds_x003E_k__BackingField>
  <_x003C_EndDate_x003E_k__BackingField>2025-04-04T20:52:23.1570031+08:00</_x003C_EndDate_x003E_k__BackingField>
  <_x003C_Keywords_x003E_k__BackingField>sample string 2</_x003C_Keywords_x003E_k__BackingField>
  <_x003C_PageIndex_x003E_k__BackingField>3</_x003C_PageIndex_x003E_k__BackingField>
  <_x003C_PageSize_x003E_k__BackingField>4</_x003C_PageSize_x003E_k__BackingField>
  <_x003C_StartDate_x003E_k__BackingField>2025-04-04T20:52:23.1570031+08:00</_x003C_StartDate_x003E_k__BackingField>
  <_x003C_UsePager_x003E_k__BackingField>true</_x003C_UsePager_x003E_k__BackingField>
  <_x003C_VendIds_x003E_k__BackingField xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:int>1</d2p1:int>
    <d2p1:int>2</d2p1:int>
  </_x003C_VendIds_x003E_k__BackingField>
</CashBankSearchConditions>

application/x-www-form-urlencoded

Sample:

Sample not available.

Response Information

Resource Description

Collection of CashBankInfo

Name	Type	Additional information
RowType	integer	None.
AcId	integer	None.
AcNo	string	None.
AcName	string	None.
Id	integer	None.
No	string	None.
Date	date	None.
FmtDate	string	None.
BType	BillType	None.
BillName	string	None.
InAmount	decimal number	None.
OutAmount	decimal number	None.
RestAmount	decimal number	None.
CustId	integer	None.
VendId	integer	None.
PayeeType	ContactType	None.
PayeeId	integer	None.
VCName	string	None.
EmpId	integer	None.
RPName	string	None.
CheckedDate	date	None.
Note	string	None.

Response Formats

application/json, text/json

Sample:

[
  {
    "RowType": 1,
    "AcId": 3,
    "AcNo": "sample string 4",
    "AcName": "sample string 5",
    "Id": 6,
    "No": "sample string 7",
    "Date": "2025-04-04 20:52:23",
    "FmtDate": "2025-04-04",
    "BType": 1010,
    "BillName": "sample string 9",
    "InAmount": 10.0,
    "OutAmount": 11.0,
    "RestAmount": 12.0,
    "CustId": 13,
    "VendId": 14,
    "PayeeType": 1010,
    "PayeeId": 15,
    "VCName": "sample string 16",
    "EmpId": 17,
    "RPName": "sample string 18",
    "CheckedDate": "2025-04-04 20:52:23",
    "Note": "sample string 20"
  },
  {
    "RowType": 1,
    "AcId": 3,
    "AcNo": "sample string 4",
    "AcName": "sample string 5",
    "Id": 6,
    "No": "sample string 7",
    "Date": "2025-04-04 20:52:23",
    "FmtDate": "2025-04-04",
    "BType": 1010,
    "BillName": "sample string 9",
    "InAmount": 10.0,
    "OutAmount": 11.0,
    "RestAmount": 12.0,
    "CustId": 13,
    "VendId": 14,
    "PayeeType": 1010,
    "PayeeId": 15,
    "VCName": "sample string 16",
    "EmpId": 17,
    "RPName": "sample string 18",
    "CheckedDate": "2025-04-04 20:52:23",
    "Note": "sample string 20"
  }
]

application/xml, text/xml

Sample:

<ArrayOfCashBankInfo xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.datacontract.org/2004/07/LemonScm.Model.ReportModels">
  <CashBankInfo>
    <_x003C_AcId_x003E_k__BackingField>3</_x003C_AcId_x003E_k__BackingField>
    <_x003C_AcName_x003E_k__BackingField>sample string 5</_x003C_AcName_x003E_k__BackingField>
    <_x003C_AcNo_x003E_k__BackingField>sample string 4</_x003C_AcNo_x003E_k__BackingField>
    <_x003C_BType_x003E_k__BackingField>Purchase</_x003C_BType_x003E_k__BackingField>
    <_x003C_BillName_x003E_k__BackingField>sample string 9</_x003C_BillName_x003E_k__BackingField>
    <_x003C_CheckedDate_x003E_k__BackingField>2025-04-04T20:52:23.1570031+08:00</_x003C_CheckedDate_x003E_k__BackingField>
    <_x003C_CustId_x003E_k__BackingField>13</_x003C_CustId_x003E_k__BackingField>
    <_x003C_Date_x003E_k__BackingField>2025-04-04T20:52:23.1570031+08:00</_x003C_Date_x003E_k__BackingField>
    <_x003C_EmpId_x003E_k__BackingField>17</_x003C_EmpId_x003E_k__BackingField>
    <_x003C_Id_x003E_k__BackingField>6</_x003C_Id_x003E_k__BackingField>
    <_x003C_InAmount_x003E_k__BackingField>10</_x003C_InAmount_x003E_k__BackingField>
    <_x003C_IsInit_x003E_k__BackingField>2</_x003C_IsInit_x003E_k__BackingField>
    <_x003C_No_x003E_k__BackingField>sample string 7</_x003C_No_x003E_k__BackingField>
    <_x003C_Note_x003E_k__BackingField>sample string 20</_x003C_Note_x003E_k__BackingField>
    <_x003C_OutAmount_x003E_k__BackingField>11</_x003C_OutAmount_x003E_k__BackingField>
    <_x003C_PayeeId_x003E_k__BackingField>15</_x003C_PayeeId_x003E_k__BackingField>
    <_x003C_PayeeType_x003E_k__BackingField>Customer</_x003C_PayeeType_x003E_k__BackingField>
    <_x003C_RPName_x003E_k__BackingField>sample string 18</_x003C_RPName_x003E_k__BackingField>
    <_x003C_RestAmount_x003E_k__BackingField>12</_x003C_RestAmount_x003E_k__BackingField>
    <_x003C_RowType_x003E_k__BackingField>1</_x003C_RowType_x003E_k__BackingField>
    <_x003C_VCName_x003E_k__BackingField>sample string 16</_x003C_VCName_x003E_k__BackingField>
    <_x003C_VendId_x003E_k__BackingField>14</_x003C_VendId_x003E_k__BackingField>
  </CashBankInfo>
  <CashBankInfo>
    <_x003C_AcId_x003E_k__BackingField>3</_x003C_AcId_x003E_k__BackingField>
    <_x003C_AcName_x003E_k__BackingField>sample string 5</_x003C_AcName_x003E_k__BackingField>
    <_x003C_AcNo_x003E_k__BackingField>sample string 4</_x003C_AcNo_x003E_k__BackingField>
    <_x003C_BType_x003E_k__BackingField>Purchase</_x003C_BType_x003E_k__BackingField>
    <_x003C_BillName_x003E_k__BackingField>sample string 9</_x003C_BillName_x003E_k__BackingField>
    <_x003C_CheckedDate_x003E_k__BackingField>2025-04-04T20:52:23.1570031+08:00</_x003C_CheckedDate_x003E_k__BackingField>
    <_x003C_CustId_x003E_k__BackingField>13</_x003C_CustId_x003E_k__BackingField>
    <_x003C_Date_x003E_k__BackingField>2025-04-04T20:52:23.1570031+08:00</_x003C_Date_x003E_k__BackingField>
    <_x003C_EmpId_x003E_k__BackingField>17</_x003C_EmpId_x003E_k__BackingField>
    <_x003C_Id_x003E_k__BackingField>6</_x003C_Id_x003E_k__BackingField>
    <_x003C_InAmount_x003E_k__BackingField>10</_x003C_InAmount_x003E_k__BackingField>
    <_x003C_IsInit_x003E_k__BackingField>2</_x003C_IsInit_x003E_k__BackingField>
    <_x003C_No_x003E_k__BackingField>sample string 7</_x003C_No_x003E_k__BackingField>
    <_x003C_Note_x003E_k__BackingField>sample string 20</_x003C_Note_x003E_k__BackingField>
    <_x003C_OutAmount_x003E_k__BackingField>11</_x003C_OutAmount_x003E_k__BackingField>
    <_x003C_PayeeId_x003E_k__BackingField>15</_x003C_PayeeId_x003E_k__BackingField>
    <_x003C_PayeeType_x003E_k__BackingField>Customer</_x003C_PayeeType_x003E_k__BackingField>
    <_x003C_RPName_x003E_k__BackingField>sample string 18</_x003C_RPName_x003E_k__BackingField>
    <_x003C_RestAmount_x003E_k__BackingField>12</_x003C_RestAmount_x003E_k__BackingField>
    <_x003C_RowType_x003E_k__BackingField>1</_x003C_RowType_x003E_k__BackingField>
    <_x003C_VCName_x003E_k__BackingField>sample string 16</_x003C_VCName_x003E_k__BackingField>
    <_x003C_VendId_x003E_k__BackingField>14</_x003C_VendId_x003E_k__BackingField>
  </CashBankInfo>
</ArrayOfCashBankInfo>