Modules:IDL Business Partners
Contents |
Introduction
Business Partner is a generic term used for several object types like customer, vendor, employee, etc. All these object types have several properties in common, such as a name, address and contact.
Input file definition
Field name | Type | Nullable | Description | Accepted values | Comment |
---|---|---|---|---|---|
Organization | String(40) | No | Indicates the organization to be used when processing documents. | [Organization search key] | |
SearchKey | String(40) | No | Allows for a fast method of finding a particular business partner. | Duplicates in this field will create a new Location, Contact or Bank Account (for the referenced Business Partner) if the fields affecting this child entities have changes. | |
Name | String(60) | No | Business Partner name. | ||
Fiscal Name | String(60) | Yes | Business Partner fiscal name. | ||
Description | String(255) | Yes | More information about the Business Partner. | ||
TaxID | String(20) | Yes | Identifies the legal Identification number of this Entity. | ||
Tax Exempt | Boolean | No | If a business partner is exempt from tax, the exempt tax rate is used. For this, you need to set up a tax rate with a 0% rate and indicate that this is your tax exempt rate. This is required for tax reporting, so that you can track tax exempt transactions. | {TRUE, FALSE} | |
ReferenceNo | String(40) | Yes | The reference number can be printed on orders and invoices to allow your business partner to faster identify your records. | ||
Category | String(60) | No | A way of grouping business partners together for classification and reporting purposes. Provides a method of defining certain defaults to be used when opening new business partners. | [Business Partner category name] | If it does not exists any category with this name, a new Business Partner Category will be created with this name. |
Language | String(6) | Yes | Identifies the language to use for display. | [ISO code] | |
Location1stLine | String(60) | Yes | Identifies the address for a location. | ||
Location2ndLine | String(60) | Yes | Provides additional address information for an entity. It can be used for building location, apartment number or similar information. | ||
LocationPostalCode | String(10) | Yes | Identifies the postal code for this Business Partner address. | ||
LocationCity | String(60) | Yes | Identifies a unique City for this Country or Region. | ||
LocationRegion | String(60) | Yes | Identifies a unique Region for this Country. | [Region name] | At least Region and Country fields must be filled to create a Business Partner Location. In other case, the location will not be created. |
LocationCountry | String(60) | Yes | Defines a Country. Each Country must be defined before it can be used in any document. | [Country name] | At least Country field must be filled to create a Business Partner Location. In other case, the location will not be created. |
LocationPhone | String(40) | Yes | Identifies a telephone number | ||
LocationAlternativePhone | String(40) | Yes | Identifies an alternate telephone number. | ||
LocationFax | String(40) | Yes | Identifies a facsimile number for this Business Partner or Location. | ||
LocationShipToAddress | Boolean | Yes | Indicates if this location is the address to use when shipping orders to this Business Partner. | ||
LocationPayFroAddress | Boolean | Yes | Identifies if this location is the address the Business Partner pays from. | ||
LocationInvoiceToAddress | Boolean | Yes | Indicates if this location is the Invoice to Address for this Business Partner | ||
LocationRemitToAddress | Boolean | Yes | Indicates if this location is the address to which we should send payments to this Business Partner. | ||
ConsumptionDays | Integer | Yes | This field is used Copy Lines From in Order tab to specify the consumptions made in the last n days. | ||
Bank AccountShowGeneric | Boolean | Yes | Generic bank account. | {TRUE, FALSE} | If true the 'Bank Account - Number' must be filled. |
BankAccountShowIBAN | Boolean | Yes | IBAN bank account. | {TRUE, FALSE} | If true the 'Bank Account - IBAN' must be filled. |
BankAccountNumber | String(20) | Yes | Bank account generic number. | ||
BankAccountIBAN | String(34) | Yes | Bank Account IBAN. | ||
ContactUser | String(60) | Yes | Contact name | This field must be not null to enter contact data. | |
ContactFirstName | String(60) | Yes | First Name of the contact. | ||
ContactLastName | String(60) | Yes | Last name of the contact. | ||
ContactDescription | String(255) | Yes | More information about the contact. | ||
ContactEmail | String(40) | Yes | The Email Address is the Electronic Mail ID for this User and should be fully qualified (e.g. joe.smith@company.com). | ||
ContactPosition | String(40) | Yes | The Title indicates the name that an entity is referred to as. | ||
ContactPhone | String(40) | Yes | Identifies a telephone number. | ||
ContactAlternativePhone | String(40) | Yes | Identifies an alternate telephone number. | ||
ContactFax | String(40) | Yes | Identifies a facsimile number for this Business Partner or Location. | ||
Vendor | Boolean | No | Indicates if this Business Partner is a Vendor. If it is selected, additional fields will display which further identify this vendor. | {'TRUE', 'FALSE'} | |
VendorPaymentMethod | String(60) | Yes | Indicates the method of purchase payment. | NAME column from the FIN_PAYMENT_METHOD table. | If it does not exists any payment method with this name, a new payment method will be created with this name. Note: the payment method must be associated (before or after import process) to any financial account. |
VendorPaymentTerms | String(40) | Yes | Indicates the payment term that will be used when this purchase order becomes an invoice. | [Payment term search key] | |
VendorPurchasePriceList | String(40) | Yes | Default purchase price list for vendor. | ||
VendorTaxCategory | String(40) | Yes | Defined for apply default taxes for procurement transactions. | [Tax Category name] | |
VendorFinancialAccount | String(60) | Yes | Vendor default financial account. | NAME column from the FIN_FINANCIAL_ACCOUNT table. | |
Customer | Boolean | No | Indicates a business partner that is your customer, ie. that will be making purchases from you. If selected, additional fields will display further details that need to be entered for a customer. | {'TRUE', 'FALSE'} | |
CustomerPaymentMethod | String(60) | Yes | Indicates the method of payment used for this transaction (eg. cash, wire transfer, etc.). | NAME column from the FIN_PAYMENT_METHOD table. | If it does not exists any payment method with this name, a new payment method will be created with this name. Note: the payment method must be associated (before or after import process) to any financial account. |
CustomerPaymentTerms | String(32) | Yes | Identifies the method and timing of payment for this transaction. | [Payment term search key] | |
CustomerPriceList | String(32) | Yes | Customer price list. | [Price List name] | |
CustomerTaxCategory | String(32) | Yes | Defined for apply default taxes for procurement transactions. | [Tax Category name] | |
CustomerFinancialAccount | String(60) | Yes | Customer default financial account. | NAME column from the FIN_FINANCIAL_ACCOUNT table. | |
CustomerInvoiceSchedule | String(60) | Yes | Identifies the frequency used when generating invoices. | [Invoice Schedule name] | |
CustomerInvoiceTerms | String(60) | Yes | Defines how a Business Partner is invoiced and the frequency of invoicing. | [C_Order InvoiceRule reference list] | English: {After Delivery, Immediate, Do not invoice, After Order delivered, Customer Schedule after Delivery} |
Employee | Boolean | No | Indicates if this Business Partner is an Employee. If it is selected, additional fields will display which further identify this employee. | {'TRUE', 'FALSE'} | |
EmployeeSalesRepresentative | Boolean | Yes | Indicates if this employee is also a sales representative. | {'TRUE', 'FALSE'} |
Default Value definition
Field name | Type | Accepted values | Examples |
---|---|---|---|
Organization | String(40) | [search_key] column from [AD_Org] table. | |
Language | String(6) | [ad_language] column from [ad_language] table. | es_ES, eu_ES, en_GB, ... |
TaxID | String(20) | 1111, 54321, 789789, ... | |
Category | String(60) | [name] column from [c_bpartner] table. | Standard Category, VIP, ... |
PaymentTerm | String(60) | [name] column from [c_paymentterm] table. | Immediate, One month, Fifteen days ... |
SalePriceList | String(60) | [name] column from [m_pricelist] table. | General Sales, Mafalda Sales, Standard Sales... |
Country | String(60) | [name] column from [c_country] table. | Spain, United States, United Kingdom, France, ... |
POPaymentTerm | String(40) | [po_payment_term] column from [c_bpartner] table. | Fifteen Days, Immidiate, One Month, ... |
PurchasePriceList | String(40) | [purchase_pricelist] column from [c_bpartner] table. | Purchase |
IsSalesRepresentative | Boolean | TRUE / True / true / FALSE / False / false | |
Vendor | Boolean | TRUE / True / true / FALSE / False / false | |
Customer | Boolean | TRUE / True / true / FALSE / False / false | |
Employee | Boolean | TRUE / True / true / FALSE / False / false | |
POFinancialAccount | String | NAME column from FIN_FINANCIAL_ACCOUNT table. |
|
SOFinancialAccount | String | NAME column from FIN_FINANCIAL_ACCOUNT table. |
|
InvoiceSchedule | String | [name] column from [c_invoiceschedule] table. |
|
InvoiceTerm | String | {After Delivery, Immediate, Do not invoice, After Order delivered, Customer Schedule after Delivery}. |
Input file definition (Version 1.X.X)
Field name | Type | Nullable | Description | Accepted values | Comment |
---|---|---|---|---|---|
Organization | String(40) | No | Indicates the organization to be used when processing documents. | [Organization search key] | |
SearchKey | String(40) | No | Allows for a fast method of finding a particular business partner. | Duplicates in this field will create a new Location, Contact or Bank Account (for the referenced Business Partner) if the fields affecting this child entities have changes. | |
Name | String(60) | No | Business Partner name. | ||
Description | String(255) | Yes | More information about the Business Partner. | ||
TaxID | String(20) | Yes | Identifies the legal Identification number of this Entity. | ||
Tax Exempt | Boolean | No | If a business partner is exempt from tax, the exempt tax rate is used. For this, you need to set up a tax rate with a 0% rate and indicate that this is your tax exempt rate. This is required for tax reporting, so that you can track tax exempt transactions. | {TRUE, FALSE} | |
ReferenceNo | String(40) | Yes | The reference number can be printed on orders and invoices to allow your business partner to faster identify your records. | ||
Category | String(60) | No | A way of grouping business partners together for classification and reporting purposes. Provides a method of defining certain defaults to be used when opening new business partners. | [Business Partner category name] | If it does not exists any category with this name, a new Business Partner Category will be created with this name. |
Language | String(6) | Yes | Identifies the language to use for display. | [ISO code] | |
Location1stLine | String(60) | Yes | Identifies the address for a location. | ||
Location2ndLine | String(60) | Yes | Provides additional address information for an entity. It can be used for building location, apartment number or similar information. | ||
LocationPostalCode | String(10) | Yes | Identifies the postal code for this Business Partner address. | ||
LocationCity | String(60) | Yes | Identifies a unique City for this Country or Region. | ||
LocationRegion | String(60) | Yes | Identifies a unique Region for this Country. | [Region name] | At least Region and Country fields must be filled to create a Business Partner Location. In other case, the location will not be created. |
LocationCountry | String(60) | Yes | Defines a Country. Each Country must be defined before it can be used in any document. | [Country name] | At least Country field must be filled to create a Business Partner Location. In other case, the location will not be created. |
LocationPhone | String(40) | Yes | Identifies a telephone number | ||
LocationAlternativePhone | String(40) | Yes | Identifies an alternate telephone number. | ||
LocationFax | String(40) | Yes | Identifies a facsimile number for this Business Partner or Location. | ||
LocationShipToAddress | Boolean | Yes | Indicates if this location is the address to use when shipping orders to this Business Partner. | ||
LocationPayFroAddress | Boolean | Yes | Identifies if this location is the address the Business Partner pays from. | ||
LocationInvoiceToAddress | Boolean | Yes | Indicates if this location is the Invoice to Address for this Business Partner | ||
LocationRemitToAddress | Boolean | Yes | Indicates if this location is the address to which we should send payments to this Business Partner. | ||
ConsumptionDays | Integer | Yes | This field is used Copy Lines From in Order tab to specify the consumptions made in the last n days. | ||
Bank AccountShowGeneric | Boolean | Yes | Generic bank account. | {TRUE, FALSE} | If true the 'Bank Account - Number' must be filled. |
BankAccountShowIBAN | Boolean | Yes | IBAN bank account. | {TRUE, FALSE} | If true the 'Bank Account - IBAN' must be filled. |
BankAccountNumber | String(20) | Yes | Bank account generic number. | ||
BankAccountIBAN | String(34) | Yes | Bank Account IBAN. | ||
ContactName | String(60) | Yes | Contact name | This field must be not null to enter contact data. | |
ContactFirstName | String(60) | Yes | First Name of the contact. | ||
ContactLastName | String(60) | Yes | Last name of the contact. | ||
ContactDescription | String(255) | Yes | More information about the contact. | ||
ContactEmail | String(40) | Yes | The Email Address is the Electronic Mail ID for this User and should be fully qualified (e.g. joe.smith@company.com). | ||
ContactPosition | String(40) | Yes | The Title indicates the name that an entity is referred to as. | ||
ContactPhone | String(40) | Yes | Identifies a telephone number. | ||
ContactAlternativePhone | String(40) | Yes | Identifies an alternate telephone number. | ||
ContactFax | String(40) | Yes | Identifies a facsimile number for this Business Partner or Location. | ||
Vendor | Boolean | No | Indicates if this Business Partner is a Vendor. If it is selected, additional fields will display which further identify this vendor. | {'TRUE', 'FALSE'} | |
VendorFormOfPayment | String(32) | Yes | Indicates the method of purchase payment. | [All_Payment Rule reference list] | English: {Wire Transfer, Check, Promissory Note, Money Order, Bank Deposit, Cash, Cash on Delivery, Credit Card, On Credit, Bank Remittance, Withholding} |
VendorPaymentTerms | String(40) | Yes | Indicates the payment term that will be used when this purchase order becomes an invoice. | [Payment term search key] | |
VendorPurchasePriceList | String(40) | Yes | Default purchase price list for vendor. | ||
VendorTaxCategory | String(40) | Yes | Defined for apply default taxes for procurement transactions. | [Tax Category name] | |
VendorBankAccount | String(50) | Yes | Vendor default bank account. | [Displayed account] | |
Customer | Boolean | No | Indicates a business partner that is your customer, ie. that will be making purchases from you. If selected, additional fields will display further details that need to be entered for a customer. | {'TRUE', 'FALSE'} | |
CustomerFormOfPayment | String(60) | Yes | Indicates the method of payment used for this transaction (eg. cash, wire transfer, etc.) | [All_Payment Rule reference list] | English: {Wire Transfer, Check, Promissory Note, Money Order, Bank Deposit, Cash, Cash on Delivery, Credit Card, On Credit, Bank Remittance, Withholding} |
CustomerPaymentTerms | String(32) | Yes | Identifies the method and timing of payment for this transaction. | [Payment term search key] | |
CustomerPriceList | String(32) | Yes | Customer price list. | [Price List name] | |
CustomerTaxCategory | String(32) | Yes | Defined for apply default taxes for procurement transactions. | [Tax Category name] | |
CustomerBankAccount | String(50) | Yes | Customer default bank account. | [Displayed account] | |
CustomerInvoiceSchedule | String(60) | Yes | Identifies the frequency used when generating invoices. | [Invoice Schedule name] | |
CustomerInvoiceTerms | String(60) | Yes | Defines how a Business Partner is invoiced and the frequency of invoicing. | [C_Order InvoiceRule reference list] | English: {After Delivery, Immediate, Do not invoice, After Order delivered, Customer Schedule after Delivery} |
Employee | Boolean | No | Indicates if this Business Partner is an Employee. If it is selected, additional fields will display which further identify this employee. | {'TRUE', 'FALSE'} | |
EmployeeSalesRepresentative | Boolean | Yes | Indicates if this employee is also a sales representative. | {'TRUE', 'FALSE'} |
Default Value definition (Version 1.X.X)
Field name | Type | Accepted values | Examples |
---|---|---|---|
Organization | String(40) | [search_key] column from [AD_Org] table | |
Language | String(6) | [ad_language] column from [ad_language] table | es_ES, eu_ES, en_GB, ... |
TaxID | String(20) | 1111, 54321, 789789, ... | |
Category | String(60) | [name] column from [c_bpartner] table | Standard Category, VIP, ... |
PaymentTerm | String(60) | [name] column from [c_paymentterm] table | Immediate, One month, Fifteen days ... |
SalePriceList | String(60) | [name] column from [m_pricelist] table | General Sales, Mafalda Sales, Standard Sales... |
Country | String(60) | [name] column from [c_country] table | Spain, United States, United Kingdom, France, ... |
POPaymentTerm | String(40) | [po_payment_term] column from [c_bpartner] table | Fifteen Days, Immidiate, One Month, ... |
PurchasePriceList | String(40) | [purchase_pricelist] column from [c_bpartner] table | Purchase |
IsSalesRepresentative | Boolean | TRUE / True / true / FALSE / False / false | |
Vendor | Boolean | TRUE / True / true / FALSE / False / false | |
Customer | Boolean | TRUE / True / true / FALSE / False / false | |
Employee | Boolean | TRUE / True / true / FALSE / False / false | |
POBankAccount | String | [displayed_Account] column from [c_bankaccount] table |
|
SOBankAccount | String | [displayed_Account] column from [c_bankaccount] table |
|
InvoiceSchedule | String | [name] column from [c_invoiceschedule] table |
|
InvoiceTerm | String | {After Delivery, Immediate, Do not invoice, After Order delivered, Customer Schedule after Delivery} |