Difference between revisions of "API Sales Order"
(→Sales Order Header) |
|||
| Line 17: | Line 17: | ||
| organization || Yes || varchar(32) || set default to 7F844AE4060B41CDB7E943F75B76F4B2 || | | organization || Yes || varchar(32) || set default to 7F844AE4060B41CDB7E943F75B76F4B2 || | ||
|- | |- | ||
| − | | businessPartner || Yes || varchar(32) || set default to Webstore ID || | + | | businessPartner || Yes || varchar(32) || set default to Webstore ID "1DF416E52D30419CBAF6C13C8DD27B95" || |
|- | |- | ||
| − | | salesTransaction || Yes || char(2) || defaulted to | + | | salesTransaction || Yes || char(2) || defaulted to "true" || |
|- | |- | ||
| − | | documentNo || Yes || varchar(32) || nomor sales order || | + | | documentNo || Yes || varchar(32) || nomor sales order || |
|- | |- | ||
| − | | documentType || Yes || varchar(32) || Tipe | + | | documentType || Yes || varchar(32) || Tipe POS Order; Defaulted to "0" || |
|- | |- | ||
| − | | 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 || varchar(32) || Defaulted to | + | | partnerAddress || Yes || varchar(32) || Defaulted to "80537B71C48742219669AF2EEA18DEE7" || |
|- | |- | ||
| − | | orderReference|| Optional || varchar(32) || | + | | orderReference|| Optional || varchar(32) || bebas di isi sebagai referensi || |
|- | |- | ||
| − | | paymentTerms || Yes || varchar(32) || Defaulted | + | | paymentTerms || Yes || varchar(32) || Defaulted to "27BD0BB9FBBA4E5E86F978933FD7F6DC" (Cash Before Delivery) || |
|- | |- | ||
| − | | priceList || Yes || varchar(32) || Defaulted to | + | | priceList || Yes || varchar(32) || Defaulted to "C8E96B73984E402285D8B0CFF856420C"|| |
|- | |- | ||
| − | | paymentMethod || Yes || varchar(32) || Defaulted to | + | | paymentMethod || Yes || varchar(32) || Defaulted to "DACDC69551CF403D9ADBD00F63F8219F"|| |
|- | |- | ||
| orderDate || Yes || varchar(32) || Defaulted to xxx || | | orderDate || Yes || varchar(32) || Defaulted to xxx || | ||
Revision as of 08:20, 2 February 2022
Contents
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 "1DF416E52D30419CBAF6C13C8DD27B95" | |
| salesTransaction | Yes | char(2) | defaulted to "true" | |
| documentNo | Yes | varchar(32) | nomor sales order | |
| documentType | Yes | varchar(32) | Tipe POS Order; Defaulted to "0" | |
| documentStatus | Yes | char(2) | set default to "DR" for testing only, for PRD will be informed later | |
| partnerAddress | Yes | varchar(32) | Defaulted to "80537B71C48742219669AF2EEA18DEE7" | |
| orderReference | Optional | varchar(32) | bebas di isi sebagai referensi | |
| paymentTerms | Yes | varchar(32) | Defaulted to "27BD0BB9FBBA4E5E86F978933FD7F6DC" (Cash Before Delivery) | |
| priceList | Yes | varchar(32) | Defaulted to "C8E96B73984E402285D8B0CFF856420C" | |
| paymentMethod | Yes | varchar(32) | Defaulted to "DACDC69551CF403D9ADBD00F63F8219F" | |
| 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 | |
| processed | Yes | char(1) | defaulted to FALSE | |
| invoiceAddress | Yes | varchar(32) | defaulted to xxx | |
| active | Yes | char(1) | defaulted to TRUE | |
| warehouse | Yes | varchar(32) | defaulted to warehouse id xxx | |
| transactionDocument | Yes | varchar(32) | defaulted to documentType ID |
Screen Reference
Sales Order Header
Complete Sales Order
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 |
Screen Reference
Sales Order Lines Details
