| Column | Mandatory to has value | DataType/Length | Description |
| BPCode | Yes | 20 | Code of Business Partner. Must be unique. If Code exist, line will be rejected |
| BPName | Yes | 200 | Name of Business Partner |
| BPUEN | No | 20 | UEN of Business Partner |
| CountryCode | No | 2 | Country Code. Code must be in Country |
| AddressCode | Yes if u want to add address detail | 10 | Address Code, Must be unique for the same Customer |
| AddressName | No | 200 | Address Name. Will be excluded in no address code |
| AddressLine1 | No | 200 | Address Line 1. Will be excluded in no address code |
| AddressLine2 | No | 200 | Address Line 2. Will be excluded in no address code |
| AddressLine3 | No | 200 | Address Line 3. Will be excluded in no address code |
| Attn | No | 100 | Attn Person. Will be excluded in no address code |
| Contact | No | 100 | Contact no.. Will be excluded in no address code |
| Fax | No | 100 | Fax No.. Will be excluded in no address code |
| Email | No | 100 | Email Address. Will be excluded in no address code |
| Website | No | 100 | Website URL. Will be excluded in no address code |
| CustomerGroup | Yes if u want to add record as customer | 30 | Customer Group. Code must be in Customer Accounting Group |
| CustomerTerm | No | 20 | Customer Term. Code must be in Payment Terms. Will be excluded if no Customer Group |
| CustomerCurrency | No | 3 | Customer Currency. Code must be in Currency. Will be excluded if no Customer Group |
| CustomerRemark | No | 4000 | Customer Remark Will be excluded if no Customer Group |
| CustomerTax | No | 8 | Customer Tax. Code must be in Tax. Will be excluded if no Customer Group |
| CustomerRef | No | 20 | Customer Reference. Will be excluded if no Customer Group |
| CustomerAddress | No | 10 | Customer Default Address. Code must be in Address Code. Will be excluded if no Customer Group |
| CustomerPIC | No | 20 | Customer Persion in charge. Code must be in Employee. Will be excluded if no Customer Group |
| CustomerCredit | No | Number (16,2) | Customer Credit Limit. Will be excluded if no Customer Group |
| VendorGroup | Yes if u want to add record as vendor | 30 | Vendor Group. Code must be in Vendor Accounting Group |
| VendorTerm | No | 20 | Vendor Term. Code must be in Payment Terms. Will be excluded if no Vendor Group |
| VendorCurrency | No | 3 | Vendor Currency. Code must be in Currency. Will be excluded if no Vendor Group |
| VendorRemark | No | 4000 | Vendor Remark Will be excluded if no Vendor Group |
| VendorTax | No | 8 | Vendor Tax. Code must be in Tax. Will be excluded if no Vendor Group |
| VendorRef | No | 20 | Vendor Reference. Will be excluded if no Vendor Group |
| VendorAddress | No | 10 | Vendor Default Address. Code must be in Address Code. Will be excluded if no Vendor Group |
| VendorGSTNum | No | 20 | Vendor GST No.. Code must be in Employee. Will be excluded if no Vendor Group
|