View source | View content page | Page history | Printable version   

Projects:EulenIDL

Input file definition

The file format should be utf-8 in order to be able to import all the characters.

Contracts

Field name Type Nullable Description Accepted values Comment
Organization String(40) No Organization search key
Generated automatically Boolean No Defines if invoice plans are generated automatically or not
Project category String(15) No Defines if it is a header or line OBCNTR_CONTRACT - OBHCNTR_CHILD
Parent String(40) Yes Defines the header of that contract line Contract searchkey It is mandatory if it is contract line.
Search key String(40) No A search key allows for a fast method of finding a particular record. [Project search key]
Name String(60) No A more descriptive identifier Project Name
Document no String(30) Yes It is mandatory if it is a contract header.
Business Partner String(40) Yes BusinessPartner SearchKey It is madatory if it is a contract header. It is line and null, the value is inherited from its parent.
Business Partner Location String(60) Yes businessPartnerLocation search key It is mandatory if it is a contract header. If it is line and value is null, the value is inherited from its parent.
Billed Location String(60) Yes businessPartnerLocation search key It is mandatory if it is a contract line. If it is contract header, the value is business partner location.
Starting date Date (yyyy-MM-dd) No
Ending date Date(yyyy-MM-dd) No
Product String(40) Yes Product search key
Currency String(3) Yes Currency isocode If it is contract header and in the csv the value is null it tries to get from the default value. If it does not exist it fails. If it is lines contract and the value is null, the value is inherited from its parent.
Description String(255) Yes
Sales representative String(60) Yes User Name
Responsible String(40) Yes BusinessPartner SearchKey
User String(60) Yes User Name
Pricelist String(60) Yes Pricelist name If it child and value is null, the value is inherited from its parent. if it is parent it is mandatory.
Payment Terms String(60) Yes PaymentTerm Name If it is child and value is null, the value is inherited from its parent. if it is parent and value is null, the value is taken from business partner.
Payment Method String(60) Yes PaymentMethod Name If it is child and value is null, the value is inherited from its parent. if it is parent and value is null, the value is taken from business partner.
Invoicing type String(15) Yes Fix - Variable (case sensitive) Mandatory if it is line contract.
Invoice schedule String(60) Yes Contract Invoice Schedule Name Mandatory if it is line contract and invocing type is fix
Period day Number Yes Mandatory if it is line contract and invocing type is fix
Amount per period BigDecimal Yes Mandatory if it is line contract and invocing type is fix
Billing group String(40) Yes BillingGroup name Only for line contract and it can be null.
User1 String(40) Yes Mandatory if it is line contract

Retrieved from "http://wiki.openbravo.com/wiki/Projects:EulenIDL"

This page has been accessed 471 times. This page was last modified on 28 January 2013, at 16:09. Content is available under Creative Commons Attribution-ShareAlike 2.5 Spain License.