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

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

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

Index

Contents

I_Invoice

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_Invoice_ID NVARCHAR2(32)Import Invoice
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.
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.
SalesRep_ID YVARCHAR2(32)The person in charge of a document.
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.
C_BPartner_Location_ID YVARCHAR2(32)The location of the selected business partner.
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_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.
AD_User_ID YVARCHAR2(32)An acquaintance to reach for information related to the business partner.
Email YNVARCHAR2(60)An email address for a specified business partner.
ContactName YNVARCHAR2(60)The name of the person to get in touch with.
Phone YNVARCHAR2(40)A telephone number for a specified business partner.
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.
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_Project_ID YVARCHAR2(32)Identifier of a project defined within the Project & Service Management module.
C_Campaign_ID YVARCHAR2(32)An advertising effort aimed at increasing sales.
C_Activity_ID YVARCHAR2(32)A distinct activity defined and used in activity based management.
C_Invoice_ID YVARCHAR2(32)A document listing products, quantities and prices, payment terms, etc.
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_InvoiceLine_ID YVARCHAR2(32)A statement displaying one item or charge in an invoice.
LineDescription YNVARCHAR2(255)An additional detail regarding one item or charge.
QtyOrdered YNUMBERThe number of an item involved in a transaction, given in standard units. It is used to determine price per unit.
PriceActual YNUMBERThe price that will be paid for a specified item.

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 Invoice

Import Invoice

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

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

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

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

Partner Address

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


Validation Rule C_BPartner Location: null. With the following code:

 
C_BPartner_Location.C_BPartner_ID=@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

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

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

Email

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

top

Contact Name

Business Partner Contact Name

top

Phone

The Phone field identifies a telephone number

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

Document Type

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


Validation Rule C_DocType Invoices and Credit Memos: Document Type AR/AP Invoice and Credit Memos. With the following code:

 
C_DocType.DocBaseType IN ('ARI', 'API','ARC','APC') 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

Project

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

top

Sales Campaign

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

top

Activity

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

top

Invoice

Foreign key column to C_Invoice table, (column: C_Invoice_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

Invoice Line

Foreign key column to C_InvoiceLine table, (column: C_InvoiceLine_ID)

top

Line Description

An additional detail regarding one item or charge.

top

Ordered Quantity

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

top

Unit Price

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

top

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

This page has been accessed 3,506 times. This page was last modified on 15 April 2011, at 21:39. Content is available under Creative Commons Attribution-ShareAlike 2.5 Spain License.