Difference between revisions of "API Sales Order"
(→Sales Order Header) |
(→Sales Order Header) |
||
| Line 44: | Line 44: | ||
|- | |- | ||
| currency || Yes || varchar(32) || Defaulted to 303 || | | currency || Yes || varchar(32) || Defaulted to 303 || | ||
| + | |- | ||
| + | | creationDate || Yes || DateTime || || | ||
| + | |- | ||
| + | | createdBy || Yes || varchar(32) || user id || | ||
| + | |- | ||
| + | | updated || Yes || DateTime || || | ||
| + | |- | ||
| + | | updatedBy || Yes || varchar(32) || user id || | ||
| + | |- | ||
| + | | documentAction || Yes || varchar(2) || defaulted to CO || | ||
|} | |} | ||
Revision as of 10:40, 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 | |
| creationDate | Yes | DateTime | ||
| createdBy | Yes | varchar(32) | user id | |
| updated | Yes | DateTime | ||
| updatedBy | Yes | varchar(32) | user id | |
| documentAction | Yes | varchar(2) | defaulted to CO |
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 |
