GET breeze/ProdInvoices/GetAllWhere?SqlWhereClause={SqlWhereClause}
No documentation available.
Request Information
Parameters
| Name | Description | Additional information |
|---|---|---|
| SqlWhereClause | No documentation available. |
Define this parameter in the request URI. |
Response Information
Response body formats
application/json, text/json
Sample:
[
{
"CONO": 1,
"INVOICENO": "sample string 2",
"INVOICESEQ": 3,
"UNQINVOICE": "sample string 4",
"INVOICEDT": "2025-06-06T21:41:23.5150712+00:00",
"SYSID": "sample string 6",
"ORDERTYPE": "sample string 7",
"CUSTORDNO": "sample string 8",
"CUSTPONO": "sample string 9",
"BILLCUSTNO": 1,
"BILLNAME": "sample string 10",
"BILLADDR1": "sample string 11",
"BILLADDR2": "sample string 12",
"BILLADDR3": "sample string 13",
"BILLADDR4": "sample string 14",
"BILLADDR5": "sample string 15",
"BILLCITY": "sample string 16",
"BILLSTATE": "sample string 17",
"BILLZIP": "sample string 18",
"BILLCNTRY": "sample string 19",
"SOLDCUSTNO": 1,
"SOLDNAME": "sample string 20",
"SOLDADDR1": "sample string 21",
"SOLDADDR2": "sample string 22",
"SOLDADDR3": "sample string 23",
"SOLDADDR4": "sample string 24",
"SOLDADDR5": "sample string 25",
"SOLDCITY": "sample string 26",
"SOLDSTATE": "sample string 27",
"SOLDZIP": "sample string 28",
"SOLDCNTRY": "sample string 29",
"SHIPCUSTNO": "sample string 30",
"SHIPNAME": "sample string 31",
"SHIPADDR1": "sample string 32",
"SHIPADDR2": "sample string 33",
"SHIPADDR3": "sample string 34",
"SHIPADDR4": "sample string 35",
"SHIPADDR5": "sample string 36",
"SHIPCITY": "sample string 37",
"SHIPSTATE": "sample string 38",
"SHIPZIP": "sample string 39",
"SHIPCNTRY": "sample string 40",
"TERMCODE": "sample string 41",
"TERMPECT": 1.1,
"TERMDESC": "sample string 42",
"SALESMANNO": 1,
"TTLSPCH1": 1.1,
"TTLSPCH2": 1.1,
"TTLSPCH3": 1.1,
"TTLSRCHAMT": 1.1,
"TTLTAXAMT": 1.1,
"TTLSPCHGTX": 1.1,
"TTLSRCHTAX": 1.1,
"TTLSPCHGDC": 1.1,
"TTLSRCHDSC": 1.1,
"TTLITMCST": 1.1,
"TTLSRCHCST": 1.1,
"TTLSPCCHG3": 1.1,
"TTLTRDDSC": 1.1,
"TTLTERMDSC": 1.1,
"TTLITMAMT": 1.1,
"SHIPINS": "sample string 43",
"WAREHOUSE": "sample string 44",
"PICKLIST": 1,
"COMPANY": 1,
"INVXREF": 1,
"INVXREFSQ": 1,
"USERID": "sample string 45",
"SHIPMENTID": "sample string 46",
"SHIPMENTNO": 1,
"CARRIER": "sample string 47",
"PROBILLNO": "sample string 48",
"SHIPHDR": "sample string 49",
"PRODUCTID": "sample string 50",
"ITEMDSC": "sample string 51",
"SERIALNO": "sample string 52",
"INVCODE": "sample string 53",
"ORDERSEQ": 1,
"SHIPRELSEQ": 1,
"SHIPQTY": 1.1,
"MFGDATE": "2025-06-06T21:41:23.5150712+00:00",
"SHPDATE": "2025-06-06T21:41:23.5150712+00:00",
"SKUNO": "sample string 54",
"SELLPRICE": 1.1,
"SELLAMT": 1.1,
"COST": 1.1,
"UOM": "sample string 55",
"CURRENCYCD": "sample string 56",
"ORGSHIPTO": "sample string 57",
"DbFileName": "sample string 58",
"DbForeignKeys": [
"sample string 1",
"sample string 2",
"sample string 3"
]
},
{
"CONO": 1,
"INVOICENO": "sample string 2",
"INVOICESEQ": 3,
"UNQINVOICE": "sample string 4",
"INVOICEDT": "2025-06-06T21:41:23.5150712+00:00",
"SYSID": "sample string 6",
"ORDERTYPE": "sample string 7",
"CUSTORDNO": "sample string 8",
"CUSTPONO": "sample string 9",
"BILLCUSTNO": 1,
"BILLNAME": "sample string 10",
"BILLADDR1": "sample string 11",
"BILLADDR2": "sample string 12",
"BILLADDR3": "sample string 13",
"BILLADDR4": "sample string 14",
"BILLADDR5": "sample string 15",
"BILLCITY": "sample string 16",
"BILLSTATE": "sample string 17",
"BILLZIP": "sample string 18",
"BILLCNTRY": "sample string 19",
"SOLDCUSTNO": 1,
"SOLDNAME": "sample string 20",
"SOLDADDR1": "sample string 21",
"SOLDADDR2": "sample string 22",
"SOLDADDR3": "sample string 23",
"SOLDADDR4": "sample string 24",
"SOLDADDR5": "sample string 25",
"SOLDCITY": "sample string 26",
"SOLDSTATE": "sample string 27",
"SOLDZIP": "sample string 28",
"SOLDCNTRY": "sample string 29",
"SHIPCUSTNO": "sample string 30",
"SHIPNAME": "sample string 31",
"SHIPADDR1": "sample string 32",
"SHIPADDR2": "sample string 33",
"SHIPADDR3": "sample string 34",
"SHIPADDR4": "sample string 35",
"SHIPADDR5": "sample string 36",
"SHIPCITY": "sample string 37",
"SHIPSTATE": "sample string 38",
"SHIPZIP": "sample string 39",
"SHIPCNTRY": "sample string 40",
"TERMCODE": "sample string 41",
"TERMPECT": 1.1,
"TERMDESC": "sample string 42",
"SALESMANNO": 1,
"TTLSPCH1": 1.1,
"TTLSPCH2": 1.1,
"TTLSPCH3": 1.1,
"TTLSRCHAMT": 1.1,
"TTLTAXAMT": 1.1,
"TTLSPCHGTX": 1.1,
"TTLSRCHTAX": 1.1,
"TTLSPCHGDC": 1.1,
"TTLSRCHDSC": 1.1,
"TTLITMCST": 1.1,
"TTLSRCHCST": 1.1,
"TTLSPCCHG3": 1.1,
"TTLTRDDSC": 1.1,
"TTLTERMDSC": 1.1,
"TTLITMAMT": 1.1,
"SHIPINS": "sample string 43",
"WAREHOUSE": "sample string 44",
"PICKLIST": 1,
"COMPANY": 1,
"INVXREF": 1,
"INVXREFSQ": 1,
"USERID": "sample string 45",
"SHIPMENTID": "sample string 46",
"SHIPMENTNO": 1,
"CARRIER": "sample string 47",
"PROBILLNO": "sample string 48",
"SHIPHDR": "sample string 49",
"PRODUCTID": "sample string 50",
"ITEMDSC": "sample string 51",
"SERIALNO": "sample string 52",
"INVCODE": "sample string 53",
"ORDERSEQ": 1,
"SHIPRELSEQ": 1,
"SHIPQTY": 1.1,
"MFGDATE": "2025-06-06T21:41:23.5150712+00:00",
"SHPDATE": "2025-06-06T21:41:23.5150712+00:00",
"SKUNO": "sample string 54",
"SELLPRICE": 1.1,
"SELLAMT": 1.1,
"COST": 1.1,
"UOM": "sample string 55",
"CURRENCYCD": "sample string 56",
"ORGSHIPTO": "sample string 57",
"DbFileName": "sample string 58",
"DbForeignKeys": [
"sample string 1",
"sample string 2",
"sample string 3"
]
},
{
"CONO": 1,
"INVOICENO": "sample string 2",
"INVOICESEQ": 3,
"UNQINVOICE": "sample string 4",
"INVOICEDT": "2025-06-06T21:41:23.5150712+00:00",
"SYSID": "sample string 6",
"ORDERTYPE": "sample string 7",
"CUSTORDNO": "sample string 8",
"CUSTPONO": "sample string 9",
"BILLCUSTNO": 1,
"BILLNAME": "sample string 10",
"BILLADDR1": "sample string 11",
"BILLADDR2": "sample string 12",
"BILLADDR3": "sample string 13",
"BILLADDR4": "sample string 14",
"BILLADDR5": "sample string 15",
"BILLCITY": "sample string 16",
"BILLSTATE": "sample string 17",
"BILLZIP": "sample string 18",
"BILLCNTRY": "sample string 19",
"SOLDCUSTNO": 1,
"SOLDNAME": "sample string 20",
"SOLDADDR1": "sample string 21",
"SOLDADDR2": "sample string 22",
"SOLDADDR3": "sample string 23",
"SOLDADDR4": "sample string 24",
"SOLDADDR5": "sample string 25",
"SOLDCITY": "sample string 26",
"SOLDSTATE": "sample string 27",
"SOLDZIP": "sample string 28",
"SOLDCNTRY": "sample string 29",
"SHIPCUSTNO": "sample string 30",
"SHIPNAME": "sample string 31",
"SHIPADDR1": "sample string 32",
"SHIPADDR2": "sample string 33",
"SHIPADDR3": "sample string 34",
"SHIPADDR4": "sample string 35",
"SHIPADDR5": "sample string 36",
"SHIPCITY": "sample string 37",
"SHIPSTATE": "sample string 38",
"SHIPZIP": "sample string 39",
"SHIPCNTRY": "sample string 40",
"TERMCODE": "sample string 41",
"TERMPECT": 1.1,
"TERMDESC": "sample string 42",
"SALESMANNO": 1,
"TTLSPCH1": 1.1,
"TTLSPCH2": 1.1,
"TTLSPCH3": 1.1,
"TTLSRCHAMT": 1.1,
"TTLTAXAMT": 1.1,
"TTLSPCHGTX": 1.1,
"TTLSRCHTAX": 1.1,
"TTLSPCHGDC": 1.1,
"TTLSRCHDSC": 1.1,
"TTLITMCST": 1.1,
"TTLSRCHCST": 1.1,
"TTLSPCCHG3": 1.1,
"TTLTRDDSC": 1.1,
"TTLTERMDSC": 1.1,
"TTLITMAMT": 1.1,
"SHIPINS": "sample string 43",
"WAREHOUSE": "sample string 44",
"PICKLIST": 1,
"COMPANY": 1,
"INVXREF": 1,
"INVXREFSQ": 1,
"USERID": "sample string 45",
"SHIPMENTID": "sample string 46",
"SHIPMENTNO": 1,
"CARRIER": "sample string 47",
"PROBILLNO": "sample string 48",
"SHIPHDR": "sample string 49",
"PRODUCTID": "sample string 50",
"ITEMDSC": "sample string 51",
"SERIALNO": "sample string 52",
"INVCODE": "sample string 53",
"ORDERSEQ": 1,
"SHIPRELSEQ": 1,
"SHIPQTY": 1.1,
"MFGDATE": "2025-06-06T21:41:23.5150712+00:00",
"SHPDATE": "2025-06-06T21:41:23.5150712+00:00",
"SKUNO": "sample string 54",
"SELLPRICE": 1.1,
"SELLAMT": 1.1,
"COST": 1.1,
"UOM": "sample string 55",
"CURRENCYCD": "sample string 56",
"ORGSHIPTO": "sample string 57",
"DbFileName": "sample string 58",
"DbForeignKeys": [
"sample string 1",
"sample string 2",
"sample string 3"
]
}
]
application/xml
Sample:
Sample not available.
text/xml
Sample:
Sample not available.