Contents
Description
ip1CustomerOrderList.get retrieves customer orders based on the customer number, order selection and by some portion of customer reference or some portion of item description or item code.
Restrictions
Access to any of the operations in ip1CustomerOrderList.get is dependent on user access.
Input/Output parameters
View JSON parameters| Input | Type | Description |
| customerNumber | 10A | Customer number(Mandatory input) |
| orderSel | 1A | Ord sel:’ ‘=All,’O’=O/S only, ‘C’=Completed |
| customerReference | 30A | Customer reference(Partial value allowed) |
| itemDesc | 60A | Item desc.(Multiple partial value allowed) |
| itemCode | 20A | Item code(Optional) |
| noOfRecords | 5N0 | No of records to return |
| sortFields |
Array of 6 max. 8A |
Sort fields(If not given, sort by ODT,PN) DB field name: ODT, PN, DT, DOCN, DOCD, TSTS, CREF |
| sortOrder | 1A | Sort order:A=Ascending, D=Descending |
| keyFrom | 100a | Key-from returned |
| keyTo | 100a | Key-to returned |
| direction | 1A | P=Previous,N=Next,F=First,L=Last |
| Output | Type | Description |
| lists | List of orders | |
| osDocType | 1A | O/S doc type |
| processNumber | 8A | Process number |
| documentType | 1A | Document type |
| documentNumber | 8A | Document number |
| documentDate | 10A | Document date |
| transactionStatus | 1A | Order status |
| transStsDesc | 30a |
Order Status description Order Status description if ODT=’ ‘ O/S doc type description if ODT<>’ ‘ |
| customerReference | 30A |
Customer reference |
| totalAmount | 13N2 |
Total amount |
| currencyISO | 3A |
Currency ISO |
| exchangeCode | 1A | Currency exchange code |
| currencyISO | 3A | Currency ISO |
| customerStatus | 1A | Customer status |
| noOfRecordsReturned | 5N0 | No of records returned |
| keyFrom | 100a | Key-from returned |
| keyTo | 100a | Key-to returned |
| pageInfo | 1A | A=All,T=Top,B=Bottom,M=More |
JSON example
View JSON request & response expampleSample request:
{
“IptorAPI”: “1.0”,
“method”: “ip1CustomerOrderList.get”,
“params”: {
“customerNumber”: “25”,
“orderSel”: “O”,
“customerReference”: “MOT”,
“noOfRecords”: 3,
“sortBy”: [
{
“field”: “DOCD”,
“order”: “D”
},
{
“field”: “TSTS”,
“order”: “A”
}
]
},
“id”: “1234567890”
}
Sample response:
{
“IptorAPI”: “1.0”,
“data”: {
“lists”: [
{
“osDocType”: “”,
“processNumber”: “40004426”,
“documentType”: “A”,
“documentNumber”: “”,
“documentDate”: “2019-11-08”,
“transactionStatus”: “L”,
“transStsDesc”: “IN MAINTENANCE”,
“customerReference”: “MOT1”,
“totalAmount”: 12.32
},
{
“osDocType”: “B”,
“processNumber”: “01919577”,
“documentType”: “A”,
“documentNumber”: “”,
“documentDate”: “2016-03-09”,
“transactionStatus”: “”,
“transStsDesc”: “BACK ORDER”,
“customerReference”: “MOT6”,
“totalAmount”: 19
},
{
“osDocType”: “B”,
“processNumber”: “01919579”,
“documentType”: “A”,
“documentNumber”: “”,
“documentDate”: “2016-03-09”,
“transactionStatus”: “”,
“transStsDesc”: “BACK ORDER”,
“customerReference”: “MOT7”,
“totalAmount”: 19
}
],
“noOfRecordsReturned”: 3,
“keyFrom”: “#2019-11-08L 40004426”,
“keyTo”: “#2016-03-09B01919579”,
“pageInfo”: “T”
},
“control”: {
“more”: true
},
“id”: “1234567890”
}
Response format
For standard response format for IP1 API methods, see Response format.
Related topics
