View source | Discuss this page | Page history | Printable version   

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

ERP/3.0/Developers Guide/Database Model/org.openbravo.model.dataimport

Index

Contents

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

This table contains the following columns:

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

top

Indexes

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

Unique

top

Columns

Import Order

Import Orders

top

Client

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

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

top

Trx Organization

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.

top

Creation Date

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

top

Created By

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

top

Updated

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

top

Updated By

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.

top

Import Error Message

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

top

Process Now

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

top

Processed

The Processed checkbox indicates that a document has been processed.

top

Sales Representative

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

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

top

Price List

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

top

Currency

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

top

Shipping Company

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.

top

Business Partner

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.

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.

top

Partner Address

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

top

Invoice Address

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


Reference Table C_BPartner Location

top

Location / Address

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

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.

top

Postal Code

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

top

City Name

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

top

Region

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.

top

Country

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

top

User/Contact

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

top

Email

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

top

Phone

The Phone field identifies a telephone number

top

Project

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

top

Activity

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

top

Document Type

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.

top

Payment Terms

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

top

Payment Term Key

Key of the Payment Term

top

Sales Order

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).

top

Description

A description is limited to 255 characters.

top

Product

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

top

Product Search Key

A fast method for finding an item.

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)

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.

top

Tax

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.

top

Tax Amount

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

top

Sales Order Line

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

top

Line Description

An additional detail regarding one item or charge.

top

UOM

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.

top

Attribute Set Value

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

top

Unit Price

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

top

Sales Campaign

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

top

Bill to UPC

top

Business Partner UPC

top

UPC Address

top

Order Date

Indicates the Date an item was ordered.

top

Scheduled Delivery Date

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

top

Order Reference No.

top

Paymentamount1

top

Paymentamount2

top

Paymentrule1

List values: All_Payment Rule

The allowed values for this list are:

top

Paymentrule2

List values: All_Payment Rule

The allowed values for this list are:

top

Perform_Post

top

Vendor UPC

top

Attributesetident

top

Retrieved from "http://wiki.openbravo.com/wiki/ERP/3.0/Developers_Guide/Database_Model/org.openbravo.model.dataimport/I_Order"

This page has been accessed 4,246 times. This page was last modified on 27 April 2011, at 16:21. Content is available under Creative Commons Attribution-ShareAlike 2.5 Spain License.