API Sales Order

From InfiniteERP Wiki
Revision as of 10:40, 1 February 2022 by Wikiadmin (talk | contribs) (Sales Order Header)
Jump to: navigation, search

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