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

Projects:IDLContracts

Contents

Input file definition

Contract Header

Field name Type Nullable Description Accepted values Comment
Organization String(40) No Indicates the organization to be used when processing documents. [Organization search key]
Search Key String(40) No Allows for a fast method of finding a particular contract.
Name String(60) No
Business Partner String(40) No BusinessPartner searchKery
Business partner location String(60) Yes BusinessPartnerLocation Name
Agreement Date Date(yyyy-MM-dd) Yes It is the date in which the agreement was signed
Invoice Start Date Date(yyyy-MM-dd) No A parameter stating when a specified request will begin.
Invoice End Date Date(yyyy-MM-dd) Yes The real end date is used to indicate when the project is expected to be completed or has been completed.
Description String(255) Yes
SalesRep String (40) Yes Indicates the sales representative responsible for the transaction that the document specifies
User String (40) Yes Invoices created from this contract will be linked to this contact
Price List String(60) No PriceList Name
Payment Terms String(40) No PaymentTerms SearchKey
InvoicingDate Date(yyyy-MM-dd) No
Payment Method String(60) No PaymentMethod Name
Invoice Schedule String(60) No
Duration Integer Yes
Duration Unit String(60) Yes {'Day','Week','Month','Year'}
Automatic Renewal Boolean Yes {'TRUE', 'FALSE'}
Notice Period Integer Yes
Notice Period Unit String(60) Yes {'Day','Week','Month','Year'}
Contract Type String(60) No
Notice Received On Date(yyyy-MM-dd) Yes

Invoice Plan

Field name Type Nullable Description Accepted values Comment
Project String(40) No Desc. [Project search key]
Description String(255) Yes
Starting date Date(yyyy-MM-dd) No A parameter stating when a specified request will begin.
Endind date Date(yyyy-MM-dd) No The End Date indicates the last date in this range.
Invoice date Date(yyyy-MM-dd) No The End Date indicates the last date in this range.
NetUnitPrice Number No
Quantity Number No Indicates the quantity of product needed to process one time the sequence.
LineNetAmt Number No
Responsible String(40) Yes BusinessPartner searchKey
Block invoice Boolean Yes {TRUE, FALSE}
Product String(60) No Identifies an item which is either purchased or sold in this organization. Product Name
Billing group String(60) Yes [BillingGroup Name]
Business Partner String(40) Yes BusinessPartner searchKey IF it is null it is inherited from 'business partner' field of its parent.
Invoicing date Date(yyyy-MM-dd) No
Billed location String(60) Yes BusinessPartnerLocation Name If it is null it is inherited from 'Bill to address' field of its parent.

Invoice Plan Template

Field name Type Nullable Description Accepted values Comment
Project String(40) No Desc. [Project search key]
Starting date Date(yyyy-MM-dd) No A parameter stating when a specified request will begin.
Endind date Date(yyyy-MM-dd) Yes The End Date indicates the last date in this range.
NetUnitPrice Number No
Quantity Number No Indicates the quantity of product needed to process one time the sequence.
LineNetAmt Number No
Product String(60) No Identifies an item which is either purchased or sold in this organization. Product Name
Billing group String(60) Yes [BillingGroup Name]
Business Partner String(40) No BusinessPartner searchKery
Billed location String(60) No BusinessPartnerLocation Name

Notes

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

This page has been accessed 693 times. This page was last modified on 16 April 2014, at 08:50. Content is available under Creative Commons Attribution-ShareAlike 2.5 Spain License.