-
Notifications
You must be signed in to change notification settings - Fork 2
Create Data Documentation Business Partner
seansimit edited this page Mar 30, 2022
·
12 revisions
Using CURL in terminal console to retrieve the Invoice 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": "createBpartner",
"module":"bpartner",
"token":"simit_5d6c867398a91-75539",
"uid":"admin",
"org":"SIMIT",
"branch":"HQ",
"data": {
"header": {
"bpartner_no": "S0001",
"bpartner_name": "Sim IT Sdn Bhd",
"bpartner_url": "http://www.simitgroup.com/",
"group_id": "",
"group_code": "",
"industry_id": "",
"industry_code": "",
"bankname": "",
"bankaccountno": "",
"bankaccountname": "",
"alternatename": "SIMIT GROUP",
"companyno": "",
"shortremarks": "",
"description": "",
"tooltips": "",
"gstno": "",
"registered_date": "2000-01-01",
"document_date": "2019-07-18",
"uname": "",
"pass": "",
"inchargeperson": "SIMIT",
"seqno": "1",
"isactive": "1",
"bp_logo": "",
"bpartner_ic": "",
"membergroup_id": "",
"membergroup_code": "",
"bp_girobankname": "",
"bp_girobankaccountno": ""
},
"line": {
"currency_code": "MYR",
"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": "1",
"iscreditor": "0",
"debtoraccounts_id": "1-1-3",
"debtoraccounts_code": "",
"creditoraccounts_id": "",
"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": "0.00",
"saleslimit": "0.00",
"iscontrolsaleslimit": "0",
"iscontrolsalesterm": "0",
"iscontrolpurchaselimit": "0",
"iscontrolpurchaseterm": "0"
},
"address": [
{
"addname": "HQ",
"addseq": "1",
"addstreet1": "20, Jalan Ekoperniagaan 2/5",
"addstreet2": "Taman Ekoperniagaan",
"addstreet3": "",
"addstreet4": "",
"addpostcode": "81100",
"addcity": "Johor",
"addarea": "Johor Bahru",
"addcountry": "Malaysia",
"addtel1": "+6(07) 859 0776",
"addtel2": "",
"addfax": "+6(07) 859 0776",
"adddesc": "",
"addagent": "",
"addshipment": "",
"addinv": "",
"addactive": "1",
"adddeliveryterm": ""
}
],
"contact": [
{
"contacts_code": "SIMIT",
"contacts_name": "SIMIT INCHARGE",
"alternatename": "INCHARGE",
"description": "",
"greeting": "Mr",
"email": "[email protected]",
"hpno": "+6(07) 859 0776",
"hpno2": "",
"tel_1": "",
"tel_2": "",
"fax": "",
"department": "Admin",
"uid": "",
"ic_no": "",
"races_id": "",
"races_code": "",
"gender": "m",
"language": "eng",
"dateofbirth": "0000-00-00",
"seqno": "1",
"isactive": "1"
}
]
}
}
' \
https://simbiz_system_url/simbiz/api.php
| Business Partner Header Data | ||||
|---|---|---|---|---|
| No | Field Name | Data Type (Size) | Required | Description |
| 1 | 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) |
| 2 | bpartner_name | varchar(255) | Business Partner's name (Personal/Company) | |
| 3 | bpartner_url | varchar(255) | Business Partner's personal/company website's link | |
| 4 | group_id | varchar(50) | Business Partner's Group | |
| 5 | group_code | varchar(255) | Business Partner's Group Code | |
| 6 | industry_id | varchar(50) | Business Partner's business industry | |
| 7 | industry_code | varchar(255) | Business Partner's business industry code | |
| 8 | bankname | varchar(30) | Business Partner's bank account name | |
| 9 | bankaccountno | varchar(30) | Business Partner's bank account number | |
| 10 | bankaccountname | varchar(50) | Business Partner's bank account name | |
| 11 | alternatename | varchar(40) | Business Partner's alternate name | |
| 12 | companyno | varchar(20) | Business Partner's register number | |
| 13 | shortremarks | varchar(40) | Business Partner's remark | |
| 14 | description | text | Business Partner's description | |
| 15 | tooltips | varchar(255) | ||
| 16 | gstno | varchar(50) | Business Partner's GST number | |
| 17 | registered_date | date | The date of register in the system | |
| 18 | document_date | date | ||
| 19 | inchargeperson | varchar(50) | Business Partner's In charge person | |
| 20 | seqno | int(11) | Sequence Number | |
| 21 | isactive | smallint(1) | Active [1]/ Not Active [0] | |
| 22 | bp_logo | text | Business Partner's logo | |
| 23 | bpartner_ic | varchar(50) | Business Partner's IC number | |
| 24 | membergroup_id | varchar(50) | Business Partner's membership group (for membership function) | |
| 25 | membergroup_code | varchar(255) | Business Partner's membership group code (for membership function) | |
| 26 | bp_girobankname | varchar(100) | Business Partner's GIRO bank's name | |
| 27 | 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 | |
| 3 | deliveryterm_code | varchar(255) | Business Partner's preferred delivery term's code | |
| 4 | tax_id | varchar(255) | ||
| 5 | tax_code | varchar(100) | ||
| 6 | salesterms_id | varchar(255) | Business Partner's preferred sales term | |
| 7 | salesterms_code | varchar(20) | Business Partner's preferred sales term's code | |
| 8 | purchaseterms_id | varchar(255) | Business Partner's preferred purchase term | |
| 9 | purchaseterms_code | varchar(20) | Business Partner's preferred purchase term's code | |
| 10 | salespricetag_id | varchar(255) | Business Partner's preferred sales price tag | |
| 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 | |
| 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 | debtoraccounts_code | varchar(50) | Business Partner's Debtor account code | |
| 18 | creditoraccounts_id | varchar(255) | Business Partner's Creditor account | |
| 19 | creditoraccounts_code | varchar(50) | Business Partner's Creditor account code | |
| 20 | salesagent_id | varchar(255) | Business Partner's sales agent ID | |
| 21 | salesagent_code | varchar(50) | Sales person's code | |
| 22 | istransporter | varchar(255) | ||
| 23 | isprospect | varchar(255) | ||
| 24 | isdealer | varchar(255) | ||
| 25 | termcontrol | varchar(255) | Business Partner's term control | |
| 26 | linkorganization_id | varchar(255) | Link business partner to another organization (generate opposite function) | |
| 27 | linkorganization_code | varchar(10) | ||
| 28 | linkbranch_id | varchar(255) | Link business partner to another organization's branch (generate opposite function) | |
| 29 | linebranch_code | varchar(40) | Link business partner to another organization's branch code(generate opposite function) | |
| 30 | sell_pricelist | varchar(255) | Sell price list that assign to the business partner | |
| 31 | sell_pricelist_no | varchar(255) | Sell price list number that assign to the business partner | |
| 32 | purchase_pricelist | varchar(255) | Purchase price list that assign to the business partner | |
| 33 | purchase_pricelist_no | varchar(255) | Purchase price list number that assign to the business partner | |
| 34 | purchaselimit | decimal(12,2) NULL | Purchase limit set on the business partner | |
| 35 | saleslimit | decimal(12,2) NULL | Sales limit set on the business partner | |
| 36 | iscontrolsaleslimit | smallint(1) NULL | Yes [1] / No [0] | |
| 37 | iscontrolsalesterm | smallint(1) NULL | Yes [1] / No [0] | |
| 38 | iscontrolpurchaselimit | smallint(1) NULL | Yes [1] / No [0] | |
| 39 | iscontrolpurchaseterm | smallint(1) NULL | Yes [1] / No [0] | |
| Business Partner Address data | ||||
| No | Field Name | Data Type (Size) | Required | Description |
| 1 | address_name | varchar(255) | Y | Business partner's address name |
| 2 | address_seq | varchar(255) | Sequence number | |
| 3 | address_street1 | varchar(255) | Business partner's address 1 | |
| 4 | address_street2 | varchar(255) | Business partner's address 2 | |
| 5 | address_street3 | varchar(255) | Business partner's address 3 | |
| 6 | address_street4 | varchar(255) | Business partner's address 4 | |
| 7 | address_postcode | varchar(255) | Business partner's address postcode | |
| 8 | address_city | varchar(255) | Business partner's address city | |
| 9 | address_area | varchar(50) | Business partner's address area | |
| 10 | address_country | varchar(50) | Business partner's address country | |
| 11 | address_tel1 | varchar(255) | Business partner's telephone number 1 | |
| 12 | address_tel2 | varchar(255) | Business partner's telephone number 2 | |
| 13 | address_fax | varchar(255) | Business partner's fax number | |
| 14 | address_desc | text | Business partner's address's description | |
| 15 | salesagent_id | varchar(50) | Sales person who bring in the business partner | |
| 16 | isshipment | smallint(1) | Business partner's address for shipment purpose? (yes[1]/no[0]) | |
| 17 | isinvoice | smallint(1) | Business partner's address is for invoice purpose? (yes[1]/no[0]) | |
| 18 | isactive | smallint(1) | Active [1]/ Not Active [0] | |
| 19 | deliveryterm_id | varchar(50) | Business Partner's preferred delivery term | |
| Business Partner Contacts data | ||||
| No | Field Name | Data Type (Size) | Required | Description |
| 1 | contacts_code | varchar(20) NULL | Y | Business Partner's contact person's code |
| 2 | contacts_name | varchar(60) | Y | Business Partner's contact person's name |
| 3 | alternatename | varchar(60) | Contact person's alternate name | |
| 4 | description | varchar(255) | Business Partner's contact person description | |
| 5 | greeting | varchar(40) | Business Partner's greeting (Mr/Mrs) | |
| 6 | varchar(60) | Contact person's email address | ||
| 7 | hpno | varchar(20) | Contact person's handphone number 1 | |
| 8 | hpno2 | varchar(50) | Contact person's handphone number 2 | |
| 9 | tel_1 | varchar(50) | Contact person's office number 1 | |
| 10 | tel_2 | varchar(50) | Contact person's office number 2 | |
| 11 | fax | varchar(20) | Contact person's fax number | |
| 12 | department | varchar(30) | Contact person's department in the company | |
| 13 | uid | varchar(50) | ||
| 14 | ic_no | varchar(50) | ||
| 15 | races_id | varchar(50) | Contact person's race | |
| 16 | races_no | varchar(20) | Contact person's race name | |
| 17 | gender | varchar(20) | Contact person's gender | |
| 18 | language | varchar(20) | Contact person's preferred language | |
| 19 | dateofbirth | date | Contact person's date of birth | |
| 20 | seqno | smallint(6) [10] | Sequence Number | |
| 21 | isactive | smallint(6) | Active [1]/ Not Active [0] |