-
Notifications
You must be signed in to change notification settings - Fork 2
Create Debtor Debit Note
seansimit edited this page Mar 30, 2022
·
3 revisions
Using CURL in terminal console to insert the Debtor Debit Note data.(* If there is no data in the data column, user may direct remove the column from the insert data array.)
curl --header "Content-Type: application/x-www-form-urlencoded" \
--request POST \
--data '
{
"action": "createDebtorDebitNote",
"module": "sales",
"token": "simit_5d6ce44404688-30487",
"uid": "admin",
"org": "SIMIT",
"branch": "HQ",
"data": {
"headerarr": {
"document_no": "API-ARDN-00001",
"document_refno": "API_DOC_TEST",
"document_date": "2019-09-02",
"document_status": "D",
"document_prepareby": "admin",
"document_desc": "DOCUMENT CREATED FROM API",
"document_note": "ADDITIONAL NOTE",
"document_reason": "",
"document_glmemo": "ADDITIONAL GLMEMO",
"bpartner_no": "S0001",
"bpartner_name": "",
"billcontacts_name": "",
"billcontacts_hp": "",
"billaddress_street1": "",
"billaddress_street2": "",
"billaddress_street3": "",
"billaddress_street4": "",
"billaddress_postcode": "",
"billaddress_city": "",
"billaddress_area": "",
"billaddress_country": "",
"shipaddress_street1": "",
"shipaddress_street2": "",
"shipaddress_street3": "",
"shipaddress_street4": "",
"shipaddress_postcode": "",
"shipaddress_city": "",
"shipaddress_area": "",
"shipaddress_country": "",
"shippinginfo": "",
"shipcontacts_name": "",
"shipcontacts_hp": "",
"totalamt": "200",
"totalamt_local": "200",
"totaltaxamt": "",
"totaltaxamt_local": "",
"totalnetamt": "200",
"totalnetamt_local": "200",
"salesagent_name": "",
"terms_name": "",
"terms_day": "",
"currency_code": "MYR",
"currency_rate": "1",
"document_trackdate": "0000-00-00",
"document_tracktype": "",
"document_trackremark": "",
"document_trackupdated": "0000-00-00 00:00:00",
"document_trackupdatedby": "",
"track1_code": "",
"track2_code": "",
"track3_code": "",
"track4_code": "",
"track5_code": "",
"isprinted": "0",
"isop": "0",
"isimport": "0",
"filling_date": "2019-08-06",
"filingdatelastchangebyuser": "admin",
"created": "2019-08-06 12:04:36",
"createdby": "admin",
"updated": "2019-08-06 12:04:36",
"updatedby": "admin",
"organization_code": "SIMIT",
"branch_code": "HQ",
"rounding_amount": "0.00"
},
"linearr": [
{
"documentline_seq": "10",
"documentline_desc": "",
"documentline_promisedate": "0000-00-00",
"item_code": "",
"item_name": "TEST ITEM 1",
"quantity": "1",
"basequantity": "1",
"uom_code": "",
"baseuom_code": "",
"unitprice": "100",
"unitprice_local": "100",
"discount": "",
"discount_amt": "",
"amount_sub": "100",
"amount_sub_local": "100",
"amount_tax": "",
"amount_tax_local": "",
"amount_netttotal": "100",
"amount_netttotal_local": "100",
"accounts_code": "11-1000",
"isinclusive": "0",
"tax_name": "",
"tax_rate": "",
"taxaccounts_id": "",
"msic_code": "",
"serialno": "",
"batchno": "",
"lotno": "",
"track1_code": "",
"track2_code": "",
"track3_code": "",
"track4_code": "",
"track5_code": "",
"customfield1": "",
"customfield2": "",
"customfield3": "",
"created": "2019-08-06 12:04:36",
"createdby": "admin",
"updated": "2019-08-06 12:04:36",
"updatedby": "admin",
"isprint": "0",
"isremark": "0",
"linedocument_no": "",
"inventorydebitacc_id": "",
"inventorycreditacc_id": "",
"syscalgstamt": "",
"taxupdatedby": "",
"inventorycost": "",
"othercost": "",
"hscode_code": ""
},
{
"documentline_seq": "10",
"documentline_desc": "",
"documentline_promisedate": "0000-00-00",
"item_code": "",
"item_name": "TEST ITEM 2",
"quantity": "1",
"basequantity": "1",
"uom_code": "",
"baseuom_code": "",
"unitprice": "100",
"unitprice_local": "100",
"discount": "",
"discount_amt": "",
"amount_sub": "100",
"amount_sub_local": "100",
"amount_tax": "",
"amount_tax_local": "",
"amount_netttotal": "100",
"amount_netttotal_local": "100",
"accounts_code": "11-1000",
"isinclusive": "0",
"tax_name": "",
"tax_rate": "",
"taxaccounts_id": "",
"msic_code": "",
"serialno": "",
"batchno": "",
"lotno": "",
"track1_code": "",
"track2_code": "",
"track3_code": "",
"track4_code": "",
"track5_code": "",
"customfield1": "",
"customfield2": "",
"customfield3": "",
"created": "2019-08-06 12:04:36",
"createdby": "admin",
"updated": "2019-08-06 12:04:36",
"updatedby": "admin",
"isprint": "0",
"isremark": "0",
"linedocument_no": "",
"inventorydebitacc_id": "",
"inventorycreditacc_id": "",
"syscalgstamt": "",
"taxupdatedby": "",
"inventorycost": "",
"othercost": "",
"hscode_code": ""
}
]
}
}
' \
https://simbiz_system_url/simbiz/api.php
The available field for insert Debtor Debit Note Data
Debtor Debit Note Header Data
| No | Field Name | Data Type (Size) | Required | Description |
|---|---|---|---|---|
| 1 | document_no | varchar(255) | Y | Debtor Debit Note document number |
| 2 | document_refno | varchar(255) | Debtor Debit Note reference number | |
| 3 | document_date | date | Debtor Debit Note document date | |
| 4 | document_status | varchar(30) | Debtor Debit Note document status | |
| 5 | document_prepareby | varchar(50) | Preparer of the document | |
| 6 | document_desc | text | Debtor Debit Note description | |
| 7 | document_note | text | Debtor Debit Note document note | |
| 8 | document_reason | varchar(255) | Debtor Debit Note Void reason | |
| 9 | document_glmemo | varchar(255) | Debtor Debit Note document GL memo | |
| 10 | bpartner_no | varchar(50) | Debtor Debit Note business partner number | |
| 11 | bpartner_name | varchar(255) | Debtor Debit Note business partner name | |
| 12 | billcontacts_name | varchar(255) | Debtor Debit Note Bill Contact Name | |
| 13 | billcontacts_hp | varchar(255) | Debtor Debit Note bill contact handphone number | |
| 14 | billaddress_street1 | varchar(255) | Debtor Debit Note bill address street 1 | |
| 15 | billaddress_street2 | varchar(255) | Debtor Debit Note bill address street 2 | |
| 16 | billaddress_street3 | varchar(255) | Debtor Debit Note bill address street 3 | |
| 17 | billaddress_street4 | varchar(255) | Debtor Debit Note bill address street 4 | |
| 18 | billaddress_postcode | varchar(50) | Debtor Debit Note bill address postcode | |
| 19 | billaddress_city | varchar(50) | Debtor Debit Note bill address city | |
| 20 | billaddress_area | varchar(50) | Debtor Debit Note bill address area | |
| 21 | billaddress_country | varchar(50) | Debtor Debit Note bill address country | |
| 22 | shipaddress_street1 | varchar(255) | Debtor Debit Note ship address street 1 | |
| 23 | shipaddress_street2 | varchar(255) | Debtor Debit Note ship address street 2 | |
| 24 | shipaddress_street3 | varchar(255) | Debtor Debit Note ship address street 3 | |
| 25 | shipaddress_street4 | varchar(255) | Debtor Debit Note ship address street 4 | |
| 26 | shipaddress_postcode | varchar(50) | Debtor Debit Note ship address postcode | |
| 27 | shipaddress_city | varchar(50) | Debtor Debit Note ship address city | |
| 28 | shipaddress_area | varchar(50) | Debtor Debit Note ship address area | |
| 29 | shipaddress_country | varchar(50) | Debtor Debit Note ship address country | |
| 30 | shippinginfo | varchar(255) | Debtor Debit Note shipping info | |
| 31 | shipcontacts_name | varchar(255) | Debtor Debit Note shipping contact name | |
| 32 | shipcontacts_hp | varchar(50) | Debtor Debit Note shipping contact handphone | |
| 33 | totalamt | decimal(22,2) | Debtor Debit Note total amount | |
| 34 | totalamt_local | decimal(22,2) | Debtor Debit Note total amount in local currency | |
| 35 | totaltaxamt | decimal(22,2) | Debtor Debit Note total tax amount | |
| 36 | totaltaxamt_local | decimal(22,2) | Debtor Debit Note total tax amount in local currency | |
| 37 | totalnetamt | decimal(22,2) | Debtor Debit Note total net amount (amt + tax) | |
| 38 | totalnetamt_local | decimal(22,2) | Debtor Debit Note total net amount in local currency | |
| 39 | salesagent_name | varchar(255) | Debtor Debit Note sales agent | |
| 40 | terms_name | varchar(255) | Debtor Debit Note term name | |
| 41 | terms_day | int(11) | Debtor Debit Note term day | |
| 42 | currency_code | varchar(255) | Debtor Debit Note currency code | |
| 43 | currency_rate | decimal(14,8) NULL | Debtor Debit Note currency rate | |
| 44 | document_trackdate | date [1970-01-01] | Debtor Debit Note track date | |
| 45 | document_tracktype | varchar(100) | Debtor Debit Note track type | |
| 46 | document_trackremark | text | Debtor Debit Note track remark | |
| 47 | document_trackupdated | datetime | Debtor Debit Note track last update date time | |
| 48 | document_trackupdatedby | varchar(50) | Debtor Debit Note track last update by | |
| 49 | track1_code | varchar(255) | Debtor Debit Note track 1 code | |
| 50 | track2_code | varchar(255) | Debtor Debit Note track 2 code | |
| 51 | track3_code | varchar(255) | Debtor Debit Note track 3 code | |
| 52 | track4_code | varchar(255) | Debtor Debit Note track 4 code | |
| 53 | track5_code | varchar(255) | Debtor Debit Note track 5 code | |
| 54 | isprinted | smallint(1) | Debtor Debit Note is allow print out in the print format | |
| 55 | isop | smallint(1) [0] | ||
| 56 | isimport | smallint(1) | ||
| 57 | filling_date | date | Debtor Debit Note filling Date | |
| 58 | filingdatelastchangebyuser | varchar(50) | Debtor Debit Note filling Date last updated user | |
| 59 | created | datetime | Debtor Debit Note created date in the system | |
| 60 | createdby | varchar(50) | Debtor Debit Note creator | |
| 61 | updated | datetime | Debtor Debit Note last updated date | |
| 62 | updatedby | varchar(50) | Debtor Debit Note last updated user | |
| 63 | organization_code | varchar(10) | Debtor Debit Note was created under which organization | |
| 64 | branch_code | varchar(40) | Debtor Debit Note was created under which branch |
Debtor Debit Note Line Data
| No | Field Name | Data Type (Size) | Required | Description |
|---|---|---|---|---|
| 1 | documentline_seq | smallint(6) | Debtor Debit Note's document line Sequence No | |
| 2 | documentline_desc | text | Debtor Debit Note's Line description | |
| 3 | documentline_promisedate | date | Debtor Debit Note's line promise date | |
| 4 | item_code | varchar(255) | Debtor Debit Note's line item code | |
| 5 | item_name | varchar(255) | Debtor Debit Note's line item name | |
| 6 | quantity | decimal(28,8) | Debtor Debit Note's line item quantity | |
| 7 | basequantity | decimal(28,8) | Debtor Debit Note's line item base quantity | |
| 8 | uom_code | varchar(255) | Debtor Debit Note's line item UOM | |
| 9 | baseuom_code | varchar(255) | Debtor Debit Note's line item base UOM | |
| 10 | accounts_code | varchar(50) | Y | Debtor Debit Note's line item account code |
| 11 | unitprice | decimal(24,4) | Debtor Debit Note's line item unit price | |
| 12 | unitprice_local | decimal(24,4) | Debtor Debit Note's line item unit price in local currency | |
| 13 | discount | varchar(255) | Debtor Debit Note's line item discount percentage | |
| 14 | discount_amt | decimal(24,2) | Debtor Debit Note's line item discount amount | |
| 15 | amount_sub | decimal(22,2) | Debtor Debit Note's line sub amount (unitprice * quantity) | |
| 16 | amount_sub_local | decimal(22,2) | Debtor Debit Note's line sub amount in local currency | |
| 17 | amount_tax | decimal(22,2) | Debtor Debit Note's line tax amount | |
| 18 | amount_tax_local | decimal(22,2) | Debtor Debit Note's line tax amount in local currency | |
| 19 | amount_netttotal | decimal(22,2) | Debtor Debit Note's line net total (sub amount + tax amount) | |
| 20 | amount_netttotal_local | decimal(22,2) | Debtor Debit Note's line net total in local currency | |
| 21 | isinclusive | smallint(11) | Is Inclusive tax? (Yes[1]/No[0]) | |
| 22 | tax_name | varchar(255) | Debtor Debit Note's line tax name | |
| 23 | tax_rate | decimal(10,4) | Debtor Debit Note's line tax rate | |
| 24 | taxaccounts_id | varchar(50) | Debtor Debit Note's line tax account | |
| 25 | msic_code | varchar(30) | Debtor Debit Note's line MSIC code | |
| 26 | serialno | text NULL | Debtor Debit Note's line item's serial number | |
| 27 | batchno | varchar(255) | Debtor Debit Note's line item's batch number | |
| 28 | lotno | varchar(255) | Debtor Debit Note's line item's lot number | |
| 29 | track1_code | varchar(255) | Debtor Debit Note's line track 1 code | |
| 30 | track2_code | varchar(255) | Debtor Debit Note's line track 2 code | |
| 31 | track3_code | varchar(255) | Debtor Debit Note's line track 3 code | |
| 32 | track4_code | varchar(255) | Debtor Debit Note's line track 4 code | |
| 33 | track5_code | varchar(255) | Debtor Debit Note's line track 5 code | |
| 34 | customfield1 | varchar(255) | Debtor Debit Note's line custom field 1 | |
| 35 | customfield2 | varchar(255) | Debtor Debit Note's line custom field 2 | |
| 36 | customfield3 | varchar(255) | Debtor Debit Note's line custom field 3 | |
| 37 | created | datetime | Debtor Debit Note's line created date in the system | |
| 38 | createdby | varchar(50) | Debtor Debit Note's line creator | |
| 39 | updated | datetime | Debtor Debit Note's line last updated date | |
| 40 | updatedby | varchar(50) | Debtor Debit Note's line last updated user | |
| 41 | isprint | smallint(1) [1] | Debtor Debit Note's line is allow print out in the print format? (Yes[1]/No[0]) | |
| 42 | isremark | int(11) | Is remark? (Yes[1]/No[0]) | |
| 43 | linedocument_no | varchar(255) | ||
| 44 | inventorydebitacc_id | varchar(50) | ||
| 45 | inventorycreditacc_id | varchar(50) | ||
| 46 | syscalgstamt | decimal(14,2) | ||
| 47 | taxupdatedby | varchar(50) | ||
| 48 | inventorycost | decimal(22,2) NULL | Debtor Debit Note's line item's inventory cost | |
| 49 | othercost | decimal(22,2) NULL | Debtor Debit Note's line item's landing cost | |
| 50 | hscode_code | varchar(50) | Debtor Debit Note's line item's HS code |