Difference between revisions of "API Sales Order"

From InfiniteERP Wiki
Jump to: navigation, search
(Complete Sales Order)
(Sales Order Header)
Line 92: Line 92:
 
<p>
 
<p>
 
==== Sales Order Header ====
 
==== Sales Order Header ====
[[file:yasmeera-westore-header1.png|600px]]
+
[[file:yasmeera-westore-header1.png|900px]]
 
</p>
 
</p>
  
 
<p>
 
<p>
 +
 
==== Complete Sales Order ====
 
==== Complete Sales Order ====
 
[[file:yasmeera-westore-order1.png|900px]]
 
[[file:yasmeera-westore-order1.png|900px]]

Revision as of 11:38, 2 February 2022

Introduction

Panduan menggunakan API Sales Order.

Mandatory Field

Sales Order Header

Get Sales Order Header API:

https://HOST/infinite/org.openbravo.service.json.jsonrest/Order?_where=documentNo='TEST-WEBSTORE-001'

Contoh response data dari Query di atas klik di sini

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 Date sample "2022-02-02"
scheduledDeliveryDate Yes Date sample "2022-02-02"
accountingDate Yes Date sample "2022-02-02"
currency Yes varchar(32) Defaulted to "303" for IDR, mata uang hanya IDR Rupiah
creationDate Yes DateTime sample "2022-02-02T07:38:24+07:00"
createdBy Yes varchar(32) Defaulted to "92A2C4122CA0439984A4749910105FDE"
updated Yes DateTime sample "2022-02-02T07:38:24+07:00"
updatedBy Yes varchar(32) Defaulted to "92A2C4122CA0439984A4749910105FDE"
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 "5645CA0F00874F1D92502738D06B3BA7"
shippingCompany Yes varchar(32) di isi dengan ID Ekspedisi, contoh untuk JNE "984C01BD749B4C09B618021EB6A5A618", refer to this list Daftar ID Ekspedisi
deliveryNotes Yes varchar(255) Alamat kirim tujuan bisa disimpan di sini
description Yes varchar(255) Informasi Pembeli dari Webstore bisa disimpan di sini

Screen Reference

Sales Order Header

Yasmeera-westore-header1.png

Complete Sales Order

Yasmeera-westore-order1.png

Sales Order Line

Get Sales Order LINE by salesOrder ID.
Notes: Please always specify pagination filter with _startRow=0&_endRow=50& parameter

https://HOST/infinite/org.openbravo.service.json.jsonrest/OrderLine?_startRow=0&_endRow=50&_where=salesOrder='0E8FEF9276C04CDDA88053EF8C9432A5'

Contoh response data dari Query di atas klik di sini

Daftar field mandatory:

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 dan dapat di akses dengan API berikut:

https://HOST/infinite/org.openbravo.service.json.jsonrest/ShippingShippingCompany?_where=client='0866093A2EEE4EE88399C8CE4E664858'
Name ID
BARAKA E162D7C547DF45ADABB9F1C9E6313DFD
JNE 984C01BD749B4C09B618021EB6A5A618
SICEPAT EFDAC9B812BF4C399A18DAAB24351037
SAJIRA B5F1003E587E4A9FAF01539D877EC6AC
LION PARCEL 7E2EBE2037AA4552B85D6340163000F8

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