Create Data Documentation Business Partner

Create Business Partner Data

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	email	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]