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

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

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

Index

Contents

I_Budgetline

Is an interim table which is used when external data into the system

This table contains the following columns:

Name Nullable Data Type Description
I_Budgetline_ID NVARCHAR2(32)null
AD_Client_ID YVARCHAR2(32)Client for this installation.
AD_Org_ID YVARCHAR2(32)Organizational entity within client
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
C_Budgetline_ID YVARCHAR2(32)null
C_Elementvalue_ID YVARCHAR2(32)A identification code for an account type.
Elementvalueident YNVARCHAR2(100)null
C_Period_ID YVARCHAR2(32)A specified time period.
Periodident YNVARCHAR2(100)null
C_Currency_ID YVARCHAR2(32)An accepted medium of monetary exchange that may vary across countries.
C_UOM_ID YVARCHAR2(32)A non monetary unit of measure.
M_Product_ID YVARCHAR2(32)An item produced by a process.
Productident YNVARCHAR2(100)null
C_BPartner_ID YVARCHAR2(32)Anyone who takes part in daily business operations by acting as a customer, employee, etc.
Partnerident YNVARCHAR2(100)null
AD_OrgTrx_ID YVARCHAR2(32)The organization which performs or initiates the transaction.
Orgtrxident YNVARCHAR2(100)null
C_SalesRegion_ID YVARCHAR2(32)A defined section of the world where sales efforts will be focused.
Salesregionident YNVARCHAR2(100)null
C_Project_ID YVARCHAR2(32)Identifier of a project defined within the Project & Service Management module.
Projectident YNVARCHAR2(100)null
C_Campaign_ID YVARCHAR2(32)An advertising effort aimed at increasing sales.
Campaignident YNVARCHAR2(100)null
C_Activity_ID YVARCHAR2(32)A distinct activity defined and used in activity based management.
Activityident YNVARCHAR2(100)null
Description YNVARCHAR2(255)A space to write additional related information.
SeqNo YNUMBER(10, 0)The order of records in a specified document.
C_BP_Group_ID YVARCHAR2(32)A classification of business partners based on defined similarities.
Bpgroupident YNVARCHAR2(100)null
M_Product_Category_ID YVARCHAR2(32)A classification of items based on similar characteristics or attributes.
Prodcategoryident YNVARCHAR2(100)null
C_Budget_ID YVARCHAR2(32)A group of planned expenses for a task.
Qty YNUMBERThe number of a certain item.
Price YNUMBERThe cost or value of a good or service.
Amount YNUMBERA monetary total.
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.
I_ErrorMsg YNVARCHAR2(2000)A message that appears when errors occur during the importing process.
I_IsImported YCHAR(1)A indication that the desired process has been completed successfully.
Currencyident YNVARCHAR2(10)null
C_Acctschema_ID YVARCHAR2(32)The structure used in accounting including costing methods, currencies, and the calendar.
Acctschemaident YNVARCHAR2(100)null

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

I_Budgetline_ID

The ID identifies a unique record

top

Client

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

top

Organization

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

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

Budget Line

Foreign key column to C_Budgetline table, (column: C_Budgetline_ID)

top

Account Element

Foreign key column to C_Elementvalue table, (column: C_ElementValue_ID)

top

Elementvalueident

top

Period

Foreign key column to C_Period table, (column: C_Period_ID)

top

Period Identification

The identifier for the Period. This identifier is the result of all the columns that are marked as isidentifier

top

Currency

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

top

UOM

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

top

Product

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

top

Product Identification

The identifier for the Product. This identifier is the result of all the columns that are marked as isidentifier

top

Business Partner

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

top

Partner Identification

The identifier for the Partner. This identifier is the result of all the columns that are marked as isidentifier

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

Organization Trx Identification

The identifier for the Organization. This identifier is the result of all the columns that are marked as isidentifier

top

Sales Region

Foreign key column to C_SalesRegion table, (column: C_SalesRegion_ID)

top

Sales Region Identification

The identifier for the Sales region. This identifier is the result of all the columns that are marked as isidentifier

top

Project

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

top

Project Identification

The identifier for the Project. This identifier is the result of all the columns that are marked as isidentifier

top

Sales Campaign

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

top

Campaign Identification

The identifier for the Campaign. This identifier is the result of all the columns that are marked as isidentifier

top

Activity

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

top

Activity Identification

top

Description

A description is limited to 255 characters.

top

Sequence Number

The Sequence indicates the order of records

top

Business Partner Category

Foreign key column to C_BP_Group table, (column: C_BP_Group_ID)

top

BP Group Identitification

The identifier for the business partner group. This identifier is the result of all the columns that are marked as isidentifier

top

Product Category

Foreign key column to M_Product_Category table, (column: M_Product_Category_ID)

top

Product Category ID

The identifier for the product category. This identifier is the result of all the columns that are marked as isidentifier

top

Budget

Foreign key column to C_Budget table, (column: C_Budget_ID)

top

Quantity

The Quantity indicates the number of a specific product or item for this document.

top

Price

The Price indicates the Price for a product or service.

top

Amount

The Amount indicates the amount for this document line.

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

Import Error Message

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

top

Import Process Complete

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

top

Currency Identification

The identifier for the Currency. This identifier is the result of all the columns that are marked as isidentifier

top

Accounting Schema

Foreign key column to C_Acctschema table, (column: C_AcctSchema_ID)

top

Acctschemaident

top

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

This page has been accessed 2,463 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.