Update Data Documentation Business Partner

Update Business Partner Data

Using CURL in the terminal console to update the Business Partner data. (* If there is no data in the data column, user may direct remove the column from the update data array.)

curl --header "Content-Type: application/x-www-form-urlencoded" \
--request POST \
--data '
{
	"action": "updateBpartner",
	"module":"bpartner",
	"token":"simit_5d6c867398a91-75539",
	"uid":"admin",
	"org":"SIMIT",
	"branch":"HQ",
	"data": {
        "header": {
            "bpartner_id": "1-1-165",
            "bpartner_no": "abc",
            "bpartner_name": "abc",
            "bpartner_url": "www.abc.com",
            "group_id": "",
            "group_code": "",
            "industry_id": "",
            "industry_code": "",
            "bankname": "ABC BANK",
            "bankaccountno": "123123123123",
            "bankaccountname": "",
            "alalternatenameter": "",
            "companyno": "",
            "shortremarks": "",
            "description": "",
            "tooltips": "",
            "gstno": "",
            "registered_date": "0000-00-00",
            "docdate": "2019-07-18",
            "uname": "abc",
            "pass": "abc123",
            "inchargeperson": "ABCDEF",
            "seqno": "0",
            "isactive": "1",
            "bp_logo": "",
            "bpartner_ic": "",
            "membergroup_id": "",
            "membergroup_code": "",
            "bp_girobankname": "HONGLEONG",
            "bp_girobankaccountno": "123123123123"
        },
        "line": {
            "currency_code": "SGD",
            "deliveryterm_id": "",
            "deliveryterm_code": "",
            "tax_id": "",
            "tax_code": "",
            "salesterms_id": "1-1-1",
            "salesterms_code": "",
            "purchaseterms_id": "",
            "purchaseterms_code": "",
            "salespricetag_id": "",
            "salespricetag_code": "",
            "purchasepricetag_id": "",
            "purchasepricetag_code": "",
            "isdebtor": "0",
            "iscreditor": "1",
            "debtoraccounts_id": "",
            "debtoraccounts_code": "",
            "creditoraccounts_id": "1-1-18",
            "creditoraccounts_code": "",
            "salesagent_id": "",
            "salesagent_code": "",
            "istransporter": "",
            "isprospect": "",
            "isdealer": "",
            "termcontrol": "",
            "linkorganization_id": "",
            "linkorganization_code": "",
            "linkbranch_id": "",
            "linkbranch_code": "",
            "sell_pricelist": "",
            "sell_pricelist_no": "",
            "purchase_pricelist": "",
            "purchase_pricelist_no": "",
            "purchaselimit": "",
            "saleslimit": "",
            "iscontrolsaleslimit": "",
            "iscontrolsalesterm": "",
            "iscontrolpurchaselimit": "",
            "iscontrolpurchaseterm": ""
        }
    }
}
' \
https://simbiz_system_url/simbiz/api.php

Business Partner Header Data
No	Field Name	Data Type (Size)	Required	Description
1	bpartner_id	varchar(50)	Y	Business Partner ID (* will pick either one between bpartner_id and bpartner_no, bpartner_id will be the first priority)
2	bpartner_no	varchar(50)	Y	Business Partner No (* will pick either one between bpartner_id and bpartner_no, bpartner_id will be the first priority)
3	bpartner_name	varchar(255)		Business Partner's name (Personal/Company)
4	bpartner_url	varchar(255)		Business Partner's personal/company website's link
5	docformat_id	varchar(50)		Business Partner's number format ID
6	group_id	varchar(50)		Business Partner's Group
7	industry_id	varchar(50)		Business Partner's business industry
8	industry_code	varchar(255)		Business Partner's business industry code
9	bankname	varchar(30)		Business Partner's bank account name
10	bankaccountno	varchar(30)		Business Partner's bank account number
11	bankaccountname	varchar(50)		Business Partner's bank account name
12	alternatename	varchar(40)		Business Partner's alternate name
13	companyno	varchar(20)		Business Partner's register number
14	shortremarks	varchar(40)		Business Partner's remark
15	description	text		Business Partner's description
16	tooltips	varchar(255)
17	gstno	varchar(50)		Business Partner's GST number
18	registered_date	date		The date of register in the system
19	document_date	date
20	uname	varchar(255)
21	pass	varchar(255)
22	inchargeperson	varchar(50)		Business Partner's In charge person
23	seqno	int(11)		Sequence Number
24	isactive	smallint(1)		Active [1]/ Not Active [0]
25	bp_logo	text		Business Partner's logo
26	bpartner_ic	varchar(50)		Business Partner's IC number
27	membergroup_id	varchar(50)		Business Partner's membership group (for membership function)
28	membergroup_code			Business Partner's membership group code (for membership function)
29	bp_girobankname	varchar(100)		Business Partner's GIRO bank's name
30	bp_girobankaccountno	varchar(30)		Business Partner's GIRO bank's account number
Business Partner Line Data
No	Field Name	Data Type (Size)	Required	Description
1	currency_code	varchar(50)		Business Partner's preferred transaction currency
2	deliveryterm_id	varchar(255)		Business Partner's preferred delivery term ID
3	deliveryterm_code	varchar(255)		Business Partner's preferred delivery term code
4	tax_id	varchar(255)
5	tax_code	varchar(100)
6	salesterms_id	varchar(255)		Business Partner's preferred sales term ID
7	salesterms_code	varchar(20)		Business Partner's preferred sales term code
8	purchaseterms_id	varchar(255)		Business Partner's preferred purchase term ID
9	purchaseterms_code	varchar(20)		Business Partner's preferred purchase term code
10	salespricetag_id	varchar(255)		Business Partner's preferred sales price tag ID
11	salespricetag_code	varchar(255)		Business Partner's preferred sales price tag code
12	purchasepricetag_id	varchar(255)		Business Partner's preferred purchase price tag ID
13	purchasepricetag_code	varchar(255)		Business Partner's preferred purchase price tag code
14	isdebtor	varchar(255)		is debtor? (yes[1]/no[0])
15	iscreditor	varchar(255)		is creditor? (yes[1]/no[0])
16	debtoraccounts_id	varchar(255)		Business Partner's Debtor account
17	creditoraccounts_id	varchar(255)		Business Partner's Creditor account
18	salesagent_id	varchar(255)		Sales person
19	salesagent_code	varchar(50)		Sales person code
20	istransporter	varchar(255)
21	isprospect	varchar(255)
22	isdealer	varchar(255)
23	termcontrol	varchar(255)		Business Partner's term control
24	linkorganization_id	varchar(255)		Link business partner to another organization (generate opposite function)
25	linkbranch_id	varchar(255)		Link business partner to another organization's branch (generate opposite function)
26	updated	varchar(255)		Business Partner's details last updated date
27	updatedby	datetime		Business Partner's details last updated user
28	organization_id	int(11)		Business Partner details was created under which organization
29	branch_id	int(11)		Business Partner details was created under which branch
30	sell_pricelist	varchar(255)		Sell price list that assign to the business partner
31	purchase_pricelist	varchar(255)		Purchase price list that assign to the business partner
32	purchaselimit	decimal(12,2) NULL		Purchase limit set on the business partner
33	saleslimit	decimal(12,2) NULL		Sales limit set on the business partner
34	iscontrolsaleslimit	smallint(1) NULL		Yes [1] / No [0]
35	iscontrolsalesterm	smallint(1) NULL		Yes [1] / No [0]
36	iscontrolpurchaselimit	smallint(1) NULL		Yes [1] / No [0]
37	iscontrolpurchaseterm	smallint(1) NULL		Yes [1] / No [0]
38	currentsalesamt	decimal(12,2) NULL		Business Partner's current sales amount
39	currentpurchaseamt	decimal(12,2) NULL		Business Partner's current purchase amount