Contents
Description
ip1basicCustomerOrderDetails.get retrieves sales order details for the outstanding document type and process number.
Restrictions
Access to any of the operations in ip1basicCustomerOrderDetails.get is dependent on user access.
Input/Output parameters
View JSON parameters| Input | Type | Description |
| ODT | 1A | O/S doc type (‘ ‘=Normal order) (mandatory) |
| PN | 8A | Process number (mandatory) |
| Output | Type | Description |
| CN | 10A | Customer number |
| PCNM | 60A | Postal customer name |
| DT | 1A | Document type |
| DOCN | 8A | Document number |
| DOCD | 10A | Document date |
| TSTS | 1A | Order status |
| TSTSD | 30A | Order status description |
| CREF | 30A | Customer reference |
| TOTA | 13N2 | Order Total amount |
| BCNM | 60A | Billing name |
| BAD0 | 60A | Billing address 0 |
| BAD1 | 60A | Billing address 1 |
| BAD2 | 60A | Billing address 2 |
| BAD3 | 60A | Billing address 3 |
| BAD4 | 20A | Billing address 4 |
| BAD5 | 20A | Billing address 5 |
| BAD6 | 60A | Billing address 6 |
| BPHN | 20A | Billing phone |
| BFAX | 20A | Billing fax |
| DCNM | 60A | Delivery name |
| DAD0 | 60A | Delivery address 0 |
| DAD1 | 60A | Delivery address 1 |
| DAD2 | 60A | Delivery address 2 |
| DAD3 | 60A | Delivery address 3 |
| DAD4 | 20A | Delivery address 4 |
| DAD5 | 20A | Delivery address 5 |
| DAD6 | 60A | Delivery address 6 |
| DPHN | 20A | Delivery phone |
| DFAX | 20A | Delivery fax |
| EMLA | 120A | Email address |
| ORDERLINES | ||
| LNO | 5N | Line no. |
| SLNO | 3N | Sub-line no. |
| I | 20A | Item |
| IDSC | 60A | Item description |
| ORDQ | 9N | Order quantity |
| DLVQ | 9N | Delivery quantity |
| BOQ | 9N | Backorder quantity |
| UPRA | 9N2 | Unit price |
| DCRA | 5N2 | Discount rate |
| TXRA | 5N2 | Tax rate |
| TTTB | 13N2 | Taxable amount |
| TTTX | 13N2 | Tax amount |
| TTTT | 13N2 | Line total amount |
| TOS | 2A | Type of sales |
| FSTF | 1A | Firm sale transaction flag |
JSON example
View JSON request & response exampleRequest:
{
“IptorAPI”: “1.0”,
“method”: “ip1basicCustomerOrderDetails.get”,
“params”: {
“ODT”: “”,
“PN”: “40002423”
},
“id”: “281212”
}
Response:
{
“IptorAPI”: “1.0”,
“data”: {
“CN”: “0000000025”,
“PCNM”: “año así día”,
“ODT”: “”,
“PN”: “40002423”,
“DT”: “A”,
“DOCN”: “”,
“DOCD”: “2017-06-19”,
“TSTS”: “D”,
“TSTSD”: “IN WAREHOUSE”,
“CREF”: “NOB2”,
“TOTA”: 3.53,
“EMLA”: “”,
“BCNM”: “año así día”,
“BAD0”: “2 Spring Street”,
“BAD1”: “”,
“BAD2”: “”,
“BAD3”: “Chatswood west”,
“BAD4”: “NSW”,
“BAD5”: “2067”,
“BAD6”: “Australia”,
“BPHN”: “123”,
“BFAX”: “K”,
“DCNM”: “Mira test dlv adr”,
“DAD0”: “1 Good St”,
“DAD1”: “”,
“DAD2”: “”,
“DAD3”: “Chatswood west”,
“DAD4”: “NSW”,
“DAD5”: “2067”,
“DAD6”: “Australia”,
“DPHN”: “111 1111”,
“DFAX”: “”,
“ORDLINES”: [
{
“LNO”: 10,
“SLNO”: 0,
“I”: “MOI1”,
“IDSC”: “mIRA\\S ITEM ?”,
“ORDQ”: 1,
“DLVQ”: 1,
“BOQ”: 0,
“UPRA”: 10,
“DCRA”: 5,
“TXRA”: 12.2,
“TTTB”: 9.5,
“TTTX”: 1.16,
“TTTT”: 10.66,
“TOS”: “FS”,
“FSTF”: “N”
},
{
“LNO”: 20,
“SLNO”: 0,
“I”: “ADJUST1”,
“IDSC”: “adjustmen testing”,
“ORDQ”: 1,
“DLVQ”: 1,
“BOQ”: 0,
“UPRA”: -15.32,
“DCRA”: 0,
“TXRA”: 10.69,
“TTTB”: -13.84,
“TTTX”: -1.48,
“TTTT”: -15.32,
“TOS”: “FS”,
“FSTF”: “N”
},
{
“LNO”: 30,
“SLNO”: 0,
“I”: “MOI1”,
“IDSC”: “mIRA\\S ITEM ?”,
“ORDQ”: 0,
“DLVQ”: 0,
“BOQ”: 0,
“UPRA”: -10.66,
“DCRA”: 0,
“TXRA”: 12.2,
“TTTB”: -9.5,
“TTTX”: -1.16,
“TTTT”: -10.66,
“TOS”: “FS”,
“FSTF”: “N”
},
{
“LNO”: 40,
“SLNO”: 0,
“I”: “BONUS2”,
“IDSC”: “bonus item”,
“ORDQ”: 1,
“DLVQ”: 0,
“BOQ”: 1,
“UPRA”: 0,
“DCRA”: 0,
“TXRA”: 21,
“TTTB”: 0,
“TTTX”: 0,
“TTTT”: 0,
“TOS”: “SM”,
“FSTF”: “N”
}
]
},
“id”: “281212”
}
Response format
For standard response format for IP1 API methods, see Response format.
Related topics
ip1basicItemWarehouseStock.get
