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 |