Skip to content
Developerhome
Product homepage
X3

Customer BPC Import/Export Template

  Less than to read

This template is provided with the SEED data folder for X3. It includes several record types to demonstrate the possibilities when importing or exporting customer data.

The data file is expected to have multiple records of data for a customer, with the records separated by CR + LF (carriage return and line feed). Fields within the record are delimited by a ; (semicolon). The data should be composed of ASCII characters.

When importing, keep in mind that the import follows the same pattern of entry as the user interface, so many field values are provided by the logic within the customer object. The import log will list values that are missing or invalid to help you correct your template.

Description Table Field Type Length Notes Required for Import
Primary record type   / string 1 Hard-coded as “B”  
Category BPCUSTOMER BCGCOD string 5 Must be an existing Category, Uses key format Required
Customer number BPCUSTOMER BPCNUM string 15 Uses key format Required
Company name BPARTNER BPRNAM string 35   Required
Short name BPARTNER BPRSHO string 10    
Acronym BPARTNER BPRLOG string 10    
Bill-to address BPCUSTOMER BPAINV string 5 Uses key format  
Pay-by address BPCUSTOMER BPAPYR string 5 Uses key format  
Default address BPCUSTOMER BPAADD string 5 Uses key format  
Ship-to customer address BPCUSTOMER BPDADD string 5 Uses key format  
Currency BPCUSTOMER CUR string 3 Must an existing Currency code, Uses key format  
Site tax ID no. BPARTNER CRN string 20 Format based on Country settings  
SIC code BPARTNER NAF string 10 Format based on Country settings  
EU VAT no. BPARTNER EECNUM string 20    
Bill-to customer BPCUSTOMER BPCINV string 15 Uses key format  
Tax rule BPCUSTOMER VACBPR string 5 Uses key format  
Payment term BPCUSTOMER PTE string 15 Uses key format  
Accounting code BPCUSTOMER ACCCOD string 10 Uses key format  
Statistical group BPCUSTOMER TSCCOD(0) string 5 Must be an existing Statistical group  
Statistical group BPCUSTOMER TSCCOD(1) string 5 Must be an existing Statistical group  
Authorized credit BPCUSTOMER OSTAUZ decimal 13.2    
Commission category BPCUSTOMER COMCAT integer 5    
Sales rep BPCUSTOMER REP(0) string 15 Uses key format  
Order header text BPCUSTOMER *71 string 100    
Order header text, cont. BPCUSTOMER *72 string 100 continuation of previous text field  
Invoice header text BPCUSTOMER *81 string 100    
Invoice header text, cont. BPCUSTOMER *82 string 100 continuation of previous text field  
Address record type   /     Hard-coded as “A”  
Address BPADDRESS BPAADD string 5 Uses key format Required
Description BPADDRESS BPADES string 30    
Address line BPADDRESS BPAADDLIG(0) string 50 Format based on Country settings  
Address line BPADDRESS BPAADDLIG(1) string 50 Format based on Country settings  
Address line BPADDRESS BPAADDLIG(2) string 50 Format based on Country settings  
Postal code BPADDRESS POSCOD string 10 Format based on Country settings Required
City BPADDRESS CTY string 40 Format based on Country settings Required
Country BPADDRESS CRY string 3 Must be an existing Country code Required
Telephone BPADDRESS TEL string 20 Format based on Country settings  
Fax BPADDRESS FAX string 20 Format based on Country settings  
Default address flag BPADDRESS BPAADDFLG integer 1 1 = No, 2 = Yes Required
Shipping address record type   /     Hard-coded as “D”  
Delivery address BPDLVCUST BPAADD string 5 Uses key format  
Company name BPDLVCUST BPDNAM(0) string 35    
Sales rep BPDLVCUST REP(0) string 15    
Delivery mode BPDLVCUST MDL string 5    
Carrier BPDLVCUST BPTNUM string 15 Uses key format  
Incoterm BPDLVCUST EECICT string 5 Uses key format  
Delivery LT in days BPDLVCUST DAYLTI integer 3    
Picking header text BPDLVCUST *71 string 100    
Picking header text, cont. BPDLVCUST *72 string 100 continuation of previous text field  
Delivery header text BPDLVCUST *81 string 100    
Delivery header text, cont. BPDLVCUST *82 string 100 continuation of previous text field  
Contact record type   /     Hard-coded as “C”  
Contact code CONTACT CCNCRM string 15 Uses key format  
Title CONTACTCRM CNTTTL integer 5    
First name CONTACTCRM CNTFNA string 20    
Last name CONTACTCRM CNTLNA string 35    
Telephone CONTACT TEL string 20 Format based on Country settings  
Function CONTACT CNTFNC integer 5    
Bank ID record type   /     Hard-coded as “R”  
Country BID CRY string 3 Must be an existing Country code  
Bank ID BID BIDNUM string 30 Format based on Country settings  
Paying bank BID PAB1 string 35 Format based on Country settings  

Notes

  • Uses Key format indicates that characters allowed for a value are restricted to uppercase letters, numbers, hyphen -, slash mark /, and underscore _.

  • Format based on Country settings means an user may define the format for this field using the function Common data > Common tables > Countries. This may restrict the length of a field to shorter than the length listed.

  • Every customer record must have a category associated with it. The category also provides several of the default values when creating a new customer, such as the country, language, and currency that the customer uses.

  • If you wish to modify this template, we recommend making a copy of it and using the copy, as upgrades to the application sometimes include updates to the demonstration data and will overwrite the BPC template.