Difference between revisions of "API Sales Order"

From InfiniteERP Wiki
Jump to: navigation, search
(Sales Order Header)
(Sales Order Header)
Line 73: Line 73:
 
| transactionDocument || Yes || varchar(32)  || defaulted to documentType ID ||  
 
| transactionDocument || Yes || varchar(32)  || defaulted to documentType ID ||  
 
|-
 
|-
| shippingCompany || Yes || varchar(32)  || di isi dengan ID Ekspedisi, contoh untuk JNE  "984C01BD749B4C09B618021EB6A5A618" || refer to this list [[https://wiki.infinite-erp.co.id/index.php/API_Sales_Order#Daftar_Ekspedisi | Daftar ID Ekspedisi ]]
+
| shippingCompany || Yes || varchar(32)  || di isi dengan ID Ekspedisi, contoh untuk JNE  "984C01BD749B4C09B618021EB6A5A618" || refer to this list [[https://wiki.infinite-erp.co.id/index.php/API_Sales_Order#Daftar_Ekspedisi|Daftar ID Ekspedisi]]
 
|}
 
|}
  

Revision as of 09:14, 2 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
active Yes char(1) defaulted to TRUE
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) sample "2022-02-02"
scheduledDeliveryDate Yes varchar(32) sample "2022-02-02"
accountingDate Yes varchar(32) sample "2022-02-02"
currency Yes varchar(32) Defaulted to 303
creationDate Yes DateTime, sample "2022-02-02T07:38:24+07:00"
createdBy Yes varchar(32) user id
updated Yes DateTime, sample "2022-02-02T07:38:24+07:00"
updatedBy Yes varchar(32) user id
documentAction Yes varchar(2) defaulted to CO
processed Yes char(1) defaulted to FALSE
invoiceTerms Yes varchar(32) defaulted to "I"
invoiceAddress Yes varchar(32) defaulted to "80537B71C48742219669AF2EEA18DEE7"
deliveryTerms Yes varchar(32) defaulted to "A"
freightCostRule Yes varchar(32) defaulted to "I"
deliveryMethod Yes varchar(32) defaulted to "S"
warehouse Yes varchar(32) defaulted to warehouse id "69B6CC4F386A4BEC93906C53C16C16E5" for S1-SRENGSENG
transactionDocument Yes varchar(32) defaulted to documentType ID
shippingCompany Yes varchar(32) di isi dengan ID Ekspedisi, contoh untuk JNE "984C01BD749B4C09B618021EB6A5A618" refer to this list [ID Ekspedisi]

Screen Reference

Sales Order Header

Yasmeera-westore-header1.png

Complete Sales Order

Yasmeera-westore-order1.png

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

Yasmeera-westore-line-detail-1.png

Shipping Company (Ekspedisi)

Get the list of Shipping Company:

https://HOST/infinite/org.openbravo.service.json.jsonrest/ShippingShippingCompany?_where=client='0866093A2EEE4EE88399C8CE4E664858'

Daftar Ekspedisi

Daftar ini mungkin akan berubah sesuai kebutuhan:

Name ID
BARAKA E162D7C547DF45ADABB9F1C9E6313DFD
JNE 984C01BD749B4C09B618021EB6A5A618
SICEPAT EFDAC9B812BF4C399A18DAAB24351037
SAJIRA B5F1003E587E4A9FAF01539D877EC6AC
LION PARCEL 7E2EBE2037AA4552B85D6340163000F8

Daftar Ekspedisi ( Shipping Company )
Yasmeera-shipping-company.png