Difference between revisions of "API Sales Order"
(→Sales Order Header) |
(→Sales Order Header) |
||
| Line 11: | Line 11: | ||
{| class="wikitable" | {| class="wikitable" | ||
|- | |- | ||
| − | ! Field Name !! Mandatory !! Type !! | + | ! Field Name !! Mandatory !! Type !! Value !! WEBSTORE Field Name |
|- | |- | ||
| client || Yes || varchar(32) || set default value to 0866093A2EEE4EE88399C8CE4E664858 || | | client || Yes || varchar(32) || set default value to 0866093A2EEE4EE88399C8CE4E664858 || | ||
| Line 36: | Line 36: | ||
|- | |- | ||
| paymentMethod || Yes || varchar(32) || Defaulted to xxx || | | paymentMethod || Yes || varchar(32) || Defaulted to xxx || | ||
| + | |- | ||
| + | | orderDate || Yes || varchar(32) || Defaulted to xxx || | ||
| + | |- | ||
| + | | scheduledDeliveryDate || Yes || varchar(32) || Defaulted to xxx || | ||
| + | |- | ||
| + | | accountingDate || Yes || varchar(32) || Defaulted to xxx || | ||
| + | |- | ||
| + | | currency || Yes || varchar(32) || Defaulted to 303 || | ||
|} | |} | ||
Revision as of 10:36, 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 | Value | 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 | varchar(32) | Defaulted to xxx | |
| orderReference | Optional | varchar(32) | ||
| paymentTerms | Yes | varchar(32) | Defaulted | |
| priceList | Yes | varchar(32) | Defaulted to xxx | |
| paymentMethod | Yes | varchar(32) | Defaulted to xxx | |
| orderDate | Yes | varchar(32) | Defaulted to xxx | |
| scheduledDeliveryDate | Yes | varchar(32) | Defaulted to xxx | |
| accountingDate | Yes | varchar(32) | Defaulted to xxx | |
| currency | Yes | varchar(32) | Defaulted to 303 |
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 |
