Difference between revisions of "API Sales Order"
(→Sales Order Header) |
(→Sales Order Header) |
||
| Line 19: | Line 19: | ||
| businessPartner || Yes || varchar(32) || set default to Webstore ID || mitra_id | | businessPartner || Yes || varchar(32) || set default to Webstore ID || mitra_id | ||
|- | |- | ||
| − | | documentNo || Yes || varchar( | + | | salesTransaction || Yes || char(2) || defaulted to True || |
| + | |- | ||
| + | | documentNo || Yes || varchar(32) || nomor sales order || doc_id | ||
| + | |- | ||
| + | | documentType || Yes || varchar(32) || Tipe Sales Order; Defaulted to xxx || | ||
|- | |- | ||
| documentStatus || Yes || char(2) || set default to DR for testing only, for PRD will be informed later || | | documentStatus || Yes || char(2) || set default to DR for testing only, for PRD will be informed later || | ||
| + | |- | ||
| + | | partnerAddress || Yes || char(2) || || | ||
| + | |- | ||
| + | | orderReference|| Yes || char(2) || || | ||
| + | |- | ||
| + | | paymentTerms || Yes || char(2) || || | ||
| + | |- | ||
| + | | priceList || Yes || char(2) || || | ||
| + | |- | ||
| + | | paymentMethod || Yes || char(2) || || | ||
|} | |} | ||
Revision as of 10:29, 1 February 2022
Introduction
Panduan menggunakan API Sales Order.
Mandatory Field
Sales Order Header
Daftar field wajid yang tidak boleh kosong ketika INSERT data:
| Field Name | Mandatory | Type | Remark | WEBSTORE Field Name |
|---|---|---|---|---|
| client | Yes | varchar(32) | set default value to 0866093A2EEE4EE88399C8CE4E664858 | |
| organization | Yes | varchar(32) | set default to 7F844AE4060B41CDB7E943F75B76F4B2 | |
| businessPartner | Yes | varchar(32) | set default to Webstore ID | mitra_id |
| salesTransaction | Yes | char(2) | defaulted to True | |
| documentNo | Yes | varchar(32) | nomor sales order | doc_id |
| documentType | Yes | varchar(32) | Tipe Sales Order; Defaulted to xxx | |
| documentStatus | Yes | char(2) | set default to DR for testing only, for PRD will be informed later | |
| partnerAddress | Yes | char(2) | ||
| orderReference | Yes | char(2) | ||
| paymentTerms | Yes | char(2) | ||
| priceList | Yes | char(2) | ||
| paymentMethod | Yes | char(2) |
Sales Order Line
| Field Name | Mandatory | Type | Remark |
|---|---|---|---|
| client | Yes | varchar(32) | set default value to 0866093A2EEE4EE88399C8CE4E664858 |
| organization | Yes | varchar(32) | set default to 7F844AE4060B41CDB7E943F75B76F4B2 |
| id | Yes | varchar(32) | ID sales order header |
| lineNo | Yes | numeric | nomor urut line pada sales order |
