ERP/2.50/Developers Guide/Database Model/org.openbravo.model.dataimport/I Order

Contents 1 I_Order 1.1 Other Info 1.1.1 Check constraints 1.1.2 Indexes 1.1.2.1 Unique 1.2 Columns 1.2.1 Import Order 1.2.2 Client 1.2.3 Organization 1.2.4 Trx Organization 1.2.5 Active 1.2.6 Creation Date 1.2.7 Created By 1.2.8 Updated 1.2.9 Updated By 1.2.10 Import Process Complete 1.2.11 Import Error Message 1.2.12 Process Now 1.2.13 Processed 1.2.14 Sales Representative 1.2.15 Warehouse 1.2.16 Price List 1.2.17 Currency 1.2.18 Shipping Company 1.2.19 Sales Transaction 1.2.20 Business Partner 1.2.21 Business Partner Search Key 1.2.22 Name 1.2.23 Partner Address 1.2.24 Invoice Address 1.2.25 Location / Address 1.2.26 Address Line 1 1.2.27 Address Line 2 1.2.28 Postal Code 1.2.29 City Name 1.2.30 Region 1.2.31 Region Name 1.2.32 Country 1.2.33 ISO Country Code 1.2.34 User/Contact 1.2.35 Contact Name 1.2.36 Email 1.2.37 Phone 1.2.38 Project 1.2.39 Activity 1.2.40 Document Type 1.2.41 Document Type Name 1.2.42 Payment Terms 1.2.43 Payment Term Key 1.2.44 Sales Order 1.2.45 Document No. 1.2.46 Description 1.2.47 Product 1.2.48 Product Search Key 1.2.49 UPC/EAN 1.2.50 SKU 1.2.51 Tax 1.2.52 Tax Search Key 1.2.53 Tax Amount 1.2.54 Sales Order Line 1.2.55 Line Description 1.2.56 UOM 1.2.57 Ordered Quantity 1.2.58 Unit Price 1.2.59 Attribute Set Value 1.2.60 Sales Campaign 1.2.61 Bill to UPC 1.2.62 Business Partner UPC 1.2.63 UPC Address 1.2.64 Order Date 1.2.65 Scheduled Delivery Date 1.2.66 Order Reference No. 1.2.67 Paymentamount1 1.2.68 Paymentamount2 1.2.69 Paymentrule1 1.2.69.1 List values: All_Payment Rule 1.2.70 Paymentrule2 1.2.70.1 List values: All_Payment Rule 1.2.71 Perform_Post 1.2.72 Vendor UPC 1.2.73 Attributesetident

I_Order

You should supply the Document Type Name (or ID). The Document Type is on purpose not fully derived as it has too many consequences if it's wrong. The best way is to set the Document Type Name as a Constant in your Import File Format or as an imported fi

• Name:DataImportOrder
• Classname:Order

This table contains the following columns:

Name	Nullable	Data Type	Description
I_Order_ID	N	VARCHAR2(32)	Import Orders
AD_Client_ID	Y	VARCHAR2(32)	Client for this installation.
AD_Org_ID	Y	VARCHAR2(32)	Organizational entity within client
AD_OrgTrx_ID	Y	VARCHAR2(32)	The organization which performs or initiates the transaction.
IsActive	Y	CHAR(1)	A flag indicating whether this record is available for use or de-activated.
Created	Y	DATE	The date that this record is completed.
CreatedBy	Y	VARCHAR2(32)	User who created this records
Updated	Y	DATE	x not implemented
UpdatedBy	Y	VARCHAR2(32)	User who updated this records
I_IsImported	Y	CHAR(1)	A indication that the desired process has been completed successfully.
I_ErrorMsg	Y	NVARCHAR2(2000)	A message that appears when errors occur during the importing process.
Processing	Y	CHAR(1)	A request to process the respective document or task.
Processed	Y	CHAR(1)	A confirmation that the associated documents or requests are processed.
SalesRep_ID	Y	VARCHAR2(32)	The person in charge of a document.
M_Warehouse_ID	Y	VARCHAR2(32)	The location where products arrive to or are sent from.
M_PriceList_ID	Y	VARCHAR2(32)	A catalog of selected items with prices defined generally or for a specific partner.
C_Currency_ID	Y	VARCHAR2(32)	An accepted medium of monetary exchange that may vary across countries.
M_Shipper_ID	Y	VARCHAR2(32)	The name of the company making the shipment.
IsSOTrx	Y	CHAR(1)	An indication that a transfer of goods and money between business partners is occurring.
C_BPartner_ID	Y	VARCHAR2(32)	Anyone who takes part in daily business operations by acting as a customer, employee, etc.
BPartnerValue	Y	NVARCHAR2(40)	An abbreviated name (or a code) to help find a business partner.
Name	Y	NVARCHAR2(60)	A non-unique identifier for a record/document often used as a search tool.
C_BPartner_Location_ID	Y	VARCHAR2(32)	The location of the selected business partner.
BillTo_ID	Y	VARCHAR2(32)	The location where the invoice payment request will be sent.
C_Location_ID	Y	VARCHAR2(32)	A specific place or residence.
Address1	Y	NVARCHAR2(60)	A space to write the location of a business partner.
Address2	Y	NVARCHAR2(60)	A space to write the location of a business partner.
Postal	Y	VARCHAR2(10)	A identification code used to help get items to a specific location.
City	Y	NVARCHAR2(60)	A populated defined area located within a larger area such as a state, province, or country.
C_Region_ID	Y	VARCHAR2(32)	An area of a specific country.
RegionName	Y	NVARCHAR2(60)	The name of an area in a specific country.
C_Country_ID	Y	VARCHAR2(32)	A state or a nation.
CountryCode	Y	CHAR(2)	The geographic country code for a country based on the ISO standard.
AD_User_ID	Y	VARCHAR2(32)	An acquaintance to reach for information related to the business partner.
ContactName	Y	NVARCHAR2(60)	The name of the person to get in touch with.
Email	Y	NVARCHAR2(60)	An email address for a specified business partner.
Phone	Y	NVARCHAR2(40)	A telephone number for a specified business partner.
C_Project_ID	Y	VARCHAR2(32)	Identifier of a project defined within the Project & Service Management module.
C_Activity_ID	Y	VARCHAR2(32)	A distinct activity defined and used in activity based management.
C_DocType_ID	Y	VARCHAR2(32)	A value defining what sequence and process setup are used to handle this document.
DocTypeName	Y	NVARCHAR2(60)	A value defining what sequence and process setup are used to handle this document.
C_PaymentTerm_ID	Y	VARCHAR2(32)	The setup and timing defined to complete a specified payment.
PaymentTermValue	Y	NVARCHAR2(40)	Key of the Payment Term
C_Order_ID	Y	VARCHAR2(32)	A unique and often automatically generated identifier for a sales order.
DocumentNo	Y	NVARCHAR2(30)	An often automatically generated identifier for all documents.
Description	Y	NVARCHAR2(255)	A space to write additional related information.
M_Product_ID	Y	VARCHAR2(32)	An item produced by a process.
ProductValue	Y	NVARCHAR2(40)	A fast method for finding an item.
UPC	Y	NVARCHAR2(30)	A bar code with a number to identify a product.
SKU	Y	NVARCHAR2(30)	A "stock keeping unit" used to track items sold to business partners.
C_Tax_ID	Y	VARCHAR2(32)	The percentage of money requested by the government for this specified product or transaction.
TaxIndicator	Y	VARCHAR2(5)	A fast method for finding a specific tax.
TaxAmt	Y	NUMBER	The total sum of money requested by the government of the specified transaction.
C_OrderLine_ID	Y	VARCHAR2(32)	A unique and often automatically generated identifier for a sales order line.
LineDescription	Y	NVARCHAR2(255)	An additional detail regarding one item or charge.
C_UOM_ID	Y	VARCHAR2(32)	A non monetary unit of measure.
QtyOrdered	Y	NUMBER	The number of an item involved in a transaction, given in standard units. It is used to determine price per unit.
PriceActual	Y	NUMBER	The price that will be paid for a specified item.
M_AttributeSetInstance_ID	Y	VARCHAR2(32)	An attribute associated with a product as part of an attribute set.
C_Campaign_ID	Y	VARCHAR2(32)	An advertising effort aimed at increasing sales.
Billto_Upc	Y	NVARCHAR2(30)	null
Bpartnerupc	Y	NVARCHAR2(30)	null
C_Bpartner_Location_Upc	Y	NVARCHAR2(30)	null
DateOrdered	Y	DATE	The time listed on the order.
DatePromised	Y	DATE	The date that a task, process, or action is to be completed or delivered by.
Order_Referenceno	Y	NVARCHAR2(40)	null
Paymentamount1	Y	NUMBER	null
Paymentamount2	Y	NUMBER	null
Paymentrule1	Y	VARCHAR2(60)	null
Paymentrule2	Y	VARCHAR2(60)	null
Perform_Post	Y	CHAR(1)	null
Vendor_Upc	Y	NVARCHAR2(30)	null
Attributesetident	Y	NVARCHAR2(100)	The identifier for the attribute set. This identifier is the result of all the columns that are marked as isidentifier

Other Info

Check constraints

These are the check constraints for this table:

• I_ORDER_ISACTIVE_CHECK: ISACTIVE IN ('Y', 'N')
• I_ORDER_ISSOTRX_CHECK: ISSOTRX IN ('Y', 'N')
• I_ORDER_I_ISIMPORTED_CHECK: I_ISIMPORTED IN ('Y', 'N', 'E')
• I_ORDER_PROCESSED_CHECK: PROCESSED IN ('Y', 'N')

top

Indexes

These are the indexes for this table (for each index there is a list of all the columns included within it):

Unique

• I_ORDER_KEY
  • I_Order_ID

top

Columns

Import Order

Import Orders

• Physical column name: I_Order_ID
• Property Name: id
• Reference: ID

top

Client

• Physical column name: AD_Client_ID
• Property Name: client
• Reference: TableDir
• Default value: @AD_CLIENT_ID@
• This column is part of the table's identifier

Foreign key column to AD_Client table, (column: AD_Client_ID)

Validation Rule AD_Client Security validation: Clients with user access rights. With the following code:

 
AD_Client.AD_Client_ID IN (@#User_Client@)

top

Organization

• Physical column name: AD_Org_ID
• Property Name: organization
• Reference: TableDir
• Default value: @AD_Org_ID@

Foreign key column to AD_Org table, (column: AD_Org_ID)

top

Trx Organization

• Physical column name: AD_OrgTrx_ID
• Property Name: trxOrganization
• Reference: Table

Foreign key column to AD_Org table, (column: AD_Org_ID)

Reference Table AD_Org (Trx) With the following where clause:

 
AD_Org.IsSummary='N' AND AD_Org_ID <> '0'

top

Active

There are two methods of making records unavailable in the system: One is to delete the record, the other is to de-activate the record. A de-activated record is not available for selection, but available for reporting. There are two reasons for de-activating and not deleting records:
(1) The system requires the record for auditing purposes.
(2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are existing invoices for it. By de-activating the Business Partner you prevent it from being used in future transactions.

• Physical column name: IsActive
• Property Name: active
• Reference: YesNo

top

Creation Date

The Created field indicates the date that this record was created.

• Physical column name: Created
• Property Name: creationDate
• Reference: DateTime

top

Created By

• Physical column name: CreatedBy
• Property Name: createdBy
• Reference: Search

Foreign key column to AD_User table, (column: AD_User_ID)

top

Updated

The Updated field indicates the date that this record was updated.

• Physical column name: Updated
• Property Name: updated
• Reference: DateTime

top

Updated By

• Physical column name: UpdatedBy
• Property Name: updatedBy
• Reference: Search

Foreign key column to AD_User table, (column: AD_User_ID)

top

Import Process Complete

The Imported check box indicates if this import has been processed.

• Physical column name: I_IsImported
• Property Name: importProcessComplete
• Reference: YesNo

top

Import Error Message

The Import Error Message displays any error messages generated during the import process.

• Physical column name: I_ErrorMsg
• Property Name: importErrorMessage
• Reference: String

top

Process Now

When this field is set as 'Y' a process is being performed on this record.

• Physical column name: Processing
• Property Name: processNow
• Reference: Button

top

Processed

The Processed checkbox indicates that a document has been processed.

• Physical column name: Processed
• Property Name: processed
• Reference: YesNo

top

Sales Representative

• Physical column name: SalesRep_ID
• Property Name: salesRepresentative
• Reference: Table

Foreign key column to AD_User table, (column: AD_User_ID)

Reference Table AD_User SalesRep With the following where clause:

 
EXISTS (SELECT * FROM C_BPartner bp WHERE AD_User.C_BPartner_ID=bp.C_BPartner_ID AND bp.IsSalesRep='Y')

top

Warehouse

• Physical column name: M_Warehouse_ID
• Property Name: warehouse
• Reference: TableDir

Foreign key column to M_Warehouse table, (column: M_Warehouse_ID)

top

Price List

• Physical column name: M_PriceList_ID
• Property Name: priceList
• Reference: TableDir

Foreign key column to M_PriceList table, (column: M_PriceList_ID)

top

Currency

• Physical column name: C_Currency_ID
• Property Name: currency
• Reference: TableDir

Foreign key column to C_Currency table, (column: C_Currency_ID)

top

Shipping Company

• Physical column name: M_Shipper_ID
• Property Name: shippingCompany
• Reference: TableDir

Foreign key column to M_Shipper table, (column: M_Shipper_ID)

top

Sales Transaction

The Sales Transaction checkbox indicates if this item is a Sales Transaction.

• Physical column name: IsSOTrx
• Property Name: salesTransaction
• Reference: YesNo

top

Business Partner

• Physical column name: C_BPartner_ID
• Property Name: businessPartner
• Reference: Search

Foreign key column to C_BPartner table, (column: C_BPartner_ID)

top

Business Partner Search Key

An abbreviated name (or a code) to help find a business partner. Usually, a company's internal identifier is entered here.

• Physical column name: BPartnerValue
• Property Name: businessPartnerSearchKey
• Reference: String

top

Name

A more descriptive identifier (that does need to be unique) of a record/document that is used as a default search option along with the search key (that is unique and mostly shorter). It is up to 60 characters in length.

• Physical column name: Name
• Property Name: name
• Reference: String

top

Partner Address

• Physical column name: C_BPartner_Location_ID
• Property Name: partnerAddress
• Reference: TableDir

Foreign key column to C_BPartner_Location table, (column: C_BPartner_Location_ID)

top

Invoice Address

• Physical column name: BillTo_ID
• Property Name: invoiceAddress
• Reference: Table

Foreign key column to C_BPartner_Location table, (column: C_BPartner_Location_ID)

Reference Table C_BPartner Location

top

Location / Address

• Physical column name: C_Location_ID
• Property Name: locationAddress
• Reference: Search

Foreign key column to C_Location table, (column: C_Location_ID)

top

Address Line 1

The Address 1 identifies the address for an entity's location

• Physical column name: Address1
• Property Name: addressLine1
• Reference: String

top

Address Line 2

The Address 2 provides additional address information for an entity. It can be used for building location, apartment number or similar information.

• Physical column name: Address2
• Property Name: addressLine2
• Reference: String

top

Postal Code

The Postal Code field identifies the postal code for this entity's address.

• Physical column name: Postal
• Property Name: postalCode
• Reference: String

top

City Name

The City identifies a unique City for this Country or Region.

• Physical column name: City
• Property Name: cityName
• Reference: String

top

Region

• Physical column name: C_Region_ID
• Property Name: region
• Reference: TableDir

Foreign key column to C_Region table, (column: C_Region_ID)

top

Region Name

The Region Name defines the name that will print when this region is used in a document.

• Physical column name: RegionName
• Property Name: regionName
• Reference: String

top

Country

• Physical column name: C_Country_ID
• Property Name: country
• Reference: TableDir

Foreign key column to C_Country table, (column: C_Country_ID)

top

ISO Country Code

For details - http://www.din.de/gremien/nas/nabd/iso3166ma/codlstp1.html or - http://www.unece.org/trade/rec/rec03en.htm

• Physical column name: CountryCode
• Property Name: iSOCountryCode
• Reference: String

top

User/Contact

• Physical column name: AD_User_ID
• Property Name: userContact
• Reference: TableDir
• Default value: -1

Foreign key column to AD_User table, (column: AD_User_ID)

Validation Rule AD_User C_BPartner User/Contacts: null. With the following code:

 
AD_User.C_BPartner_ID=@C_BPartner_ID@

top

Contact Name

Business Partner Contact Name

• Physical column name: ContactName
• Property Name: contactName
• Reference: String

top

Email

The Email Address is the Electronic Mail ID for this User and should be fully qualified (e.g. joe.smith@company.com).

• Physical column name: Email
• Property Name: email
• Reference: String

top

Phone

The Phone field identifies a telephone number

• Physical column name: Phone
• Property Name: phone
• Reference: String

top

Project

• Physical column name: C_Project_ID
• Property Name: project
• Reference: Search

Foreign key column to C_Project table, (column: C_Project_ID)

top

Activity

• Physical column name: C_Activity_ID
• Property Name: activity
• Reference: TableDir

Foreign key column to C_Activity table, (column: C_Activity_ID)

top

Document Type

• Physical column name: C_DocType_ID
• Property Name: documentType
• Reference: TableDir

Foreign key column to C_DocType table, (column: C_DocType_ID)

Validation Rule C_DocType Orders: Document Tpe for SO/PO. With the following code:

 
C_DocType.DocBaseType IN ('SOO', 'POO') AND AD_ISORGINCLUDED(@AD_Org_ID@,C_DocType.AD_Org_ID, @#AD_Client_ID@) <> '-1'

top

Document Type Name

A value defining what sequence and process setup are used to handle this document.

• Physical column name: DocTypeName
• Property Name: documentTypeName
• Reference: String

top

Payment Terms

• Physical column name: C_PaymentTerm_ID
• Property Name: paymentTerms
• Reference: TableDir

Foreign key column to C_PaymentTerm table, (column: C_PaymentTerm_ID)

top

Payment Term Key

Key of the Payment Term

• Physical column name: PaymentTermValue
• Property Name: paymentTermKey
• Reference: String

top

Sales Order

• Physical column name: C_Order_ID
• Property Name: salesOrder
• Reference: Search

Foreign key column to C_Order table, (column: C_Order_ID)

top

Document No.

The document number is usually automatically generated by the system and determined by the document type of the document. If the document is not saved, the preliminary number is displayed in "<>". If the document type of your document has no automatic document sequence defined, the field will be empty when creating a new document. This is for documents which usually have an external number (like vendor invoice). If you leave the field empty, the system will generate a document number for you. The document sequence used for this fallback number is defined in the "Document Sequence" window with the name "DocumentNo_<TableName>", where TableName is the actual name of the table inside the database (e.g. C_Order).

• Physical column name: DocumentNo
• Property Name: documentNo
• Reference: String

top

Description

A description is limited to 255 characters.

• Physical column name: Description
• Property Name: description
• Reference: String

top

Product

• Physical column name: M_Product_ID
• Property Name: product
• Reference: Search

Foreign key column to M_Product table, (column: M_Product_ID)

top

Product Search Key

A fast method for finding an item.

• Physical column name: ProductValue
• Property Name: productSearchKey
• Reference: String

top

UPC/EAN

Use this field to enter the bar code for the product in any of the bar code symbologies (Codabar, Code 25, Code 39, Code 93, Code 128, UPC (A), UPC (E), EAN-13, EAN-8, ITF, ITF-14, ISBN, ISSN, JAN-13, JAN-8, POSTNET and FIM, MSI/Plessey, and Pharmacode)

• Physical column name: UPC
• Property Name: uPCEAN
• Reference: String

top

SKU

The SKU indicates a user defined stock keeping unit. It may be used for an additional bar code symbols or your own schema.

• Physical column name: SKU
• Property Name: sKU
• Reference: String

top

Tax

• Physical column name: C_Tax_ID
• Property Name: tax
• Reference: TableDir

Foreign key column to C_Tax table, (column: C_Tax_ID)

top

Tax Search Key

The Tax Indicator identifies the short name that will print on documents referencing this tax.

• Physical column name: TaxIndicator
• Property Name: taxSearchKey
• Reference: String

top

Tax Amount

The Tax Amount displays the total tax amount for a document.

• Physical column name: TaxAmt
• Property Name: taxAmount
• Reference: Amount

top

Sales Order Line

• Physical column name: C_OrderLine_ID
• Property Name: salesOrderLine
• Reference: Search

Foreign key column to C_OrderLine table, (column: C_OrderLine_ID)

top

Line Description

An additional detail regarding one item or charge.

• Physical column name: LineDescription
• Property Name: lineDescription
• Reference: String

top

UOM

• Physical column name: C_UOM_ID
• Property Name: uOM
• Reference: TableDir

Foreign key column to C_UOM table, (column: C_UOM_ID)

top

Ordered Quantity

The Ordered Quantity indicates the quantity of a product that was ordered.

• Physical column name: QtyOrdered
• Property Name: orderedQuantity
• Reference: Quantity

top

Unit Price

The actual price indicates the price for a product in source currency.

• Physical column name: PriceActual
• Property Name: unitPrice
• Reference: Price

top

Attribute Set Value

• Physical column name: M_AttributeSetInstance_ID
• Property Name: attributeSetValue
• Reference: PAttribute

Foreign key column to M_AttributeSetInstance table, (column: M_AttributeSetInstance_ID)

top

Sales Campaign

• Physical column name: C_Campaign_ID
• Property Name: salesCampaign
• Reference: TableDir

Foreign key column to C_Campaign table, (column: C_Campaign_ID)

top

Bill to UPC

• Physical column name: Billto_Upc
• Property Name: billToUPC
• Reference: String

top

Business Partner UPC

• Physical column name: Bpartnerupc
• Property Name: businessPartnerUPC
• Reference: String

top

UPC Address

• Physical column name: C_Bpartner_Location_Upc
• Property Name: uPCAddress
• Reference: String

top

Order Date

Indicates the Date an item was ordered.

• Physical column name: DateOrdered
• Property Name: orderDate
• Reference: Date

top

Scheduled Delivery Date

Scheduled Delivery Date indicates the date, if any, that an order was promised by.

• Physical column name: DatePromised
• Property Name: scheduledDeliveryDate
• Reference: Date

top

Order Reference No.

• Physical column name: Order_Referenceno
• Property Name: orderReferenceNo
• Reference: String

top

Paymentamount1

• Physical column name: Paymentamount1
• Property Name: paymentamount1
• Reference: Number
• Default value: 0

top

Paymentamount2

• Physical column name: Paymentamount2
• Property Name: paymentamount2
• Reference: Number
• Default value: 0

top

Paymentrule1

• Physical column name: Paymentrule1
• Property Name: paymentrule1
• Reference: List

List values: All_Payment Rule

The allowed values for this list are:

• 1 (Wire Transfer): Wire Transfer
• 2 (Check): Check
• 3 (Promissory Note): Promissory Note
• 4 (Money Order)
• 5 (Bank Deposit)
• B (Cash): Cash payments that generate an automatic accounting line.
• C (Cash on Delivery): Cash on Delivery
• K (Credit Card)
• P (On Credit): Cash payments that do not generate an automatic accounting line. Its is not an automatic cash entry.
• R (Bank Remittance)
• T (Transfer (ACH))
• W (Withholding)

top

Paymentrule2

• Physical column name: Paymentrule2
• Property Name: paymentrule2
• Reference: List

List values: All_Payment Rule

The allowed values for this list are:

• 1 (Wire Transfer): Wire Transfer
• 2 (Check): Check
• 3 (Promissory Note): Promissory Note
• 4 (Money Order)
• 5 (Bank Deposit)
• B (Cash): Cash payments that generate an automatic accounting line.
• C (Cash on Delivery): Cash on Delivery
• K (Credit Card)
• P (On Credit): Cash payments that do not generate an automatic accounting line. Its is not an automatic cash entry.
• R (Bank Remittance)
• T (Transfer (ACH))
• W (Withholding)

top

Perform_Post

• Physical column name: Perform_Post
• Property Name: performPost
• Reference: YesNo

top

Vendor UPC

• Physical column name: Vendor_Upc
• Property Name: vendorUPC
• Reference: String

top

Attributesetident

• Physical column name: Attributesetident
• Property Name: attributesetident
• Reference: String

top