View source | Discuss this page | Page history | Printable version   
Toolbox
Main Page
Upload file
What links here
Recent changes
Help

PDF Books
Show collection (0 pages)
Collections help

Search

ERP 2.50:Developers Guide/Database Model/org.openbravo.model.common.order/C Order Header V

ERP 2.50:Developers Guide/Database Model/org.openbravo.model.common.order

Index

Contents

C_Order_Header_V

This table contains the following columns:

Name Nullable Data Type Description
AD_Client_ID NVARCHAR2(32)Client for this installation.
AD_Org_ID NVARCHAR2(32)Organizational entity within client
IsActive NCHAR(1)A flag indicating whether this record is available for use or de-activated.
Created NDATEThe date that this record is completed.
CreatedBy NVARCHAR2(32)User who created this records
Updated NDATEx not implemented
UpdatedBy NVARCHAR2(32)User who updated this records
AD_Language YCHAR(5)A method of communication being used.
C_Order_ID NVARCHAR2(32)A unique and often automatically generated identifier for a sales order.
IsSOTrx NCHAR(1)An indication that a transfer of goods and money between business partners is occurring.
DocumentNo NNVARCHAR2(30)An often automatically generated identifier for all documents.
DocStatus NVARCHAR2(60)The Document Status indicates the status of a document at this time.
C_DocType_ID NVARCHAR2(32)A value defining what sequence and process setup are used to handle this document.
C_BPartner_ID NVARCHAR2(32)Anyone who takes part in daily business operations by acting as a customer, employee, etc.
BPValue NNVARCHAR2(40)Business Partner Key Value
Org_Location_ID YVARCHAR2(32)Organization Location/Address
TaxID NVARCHAR2(20)The government defined unique number for assigning and paying taxes.
DocumentType NNVARCHAR2(60)Document Type
DocumentTypeNote YNVARCHAR2(2000)Optional note of a document type
SalesRep_ID YVARCHAR2(32)The person in charge of a document.
SalesRep_Name YNVARCHAR2(60)null
DateOrdered NDATEThe time listed on the order.
DatePromised YDATEThe date that a task, process, or action is to be completed or delivered by.
BPGreeting YNVARCHAR2(60)Greeting for Business Partner
Name NNVARCHAR2(60)A non-unique identifier for a record/document often used as a search tool.
Name2 YNVARCHAR2(60)Additional space to write the name of a business partner.
BPContactGreeting YNVARCHAR2(60)Greeting for Business Partner Contact
Title YNVARCHAR2(40)A defined job, title, or ranking within a company.
ContactName YNVARCHAR2(60)The name of the person to get in touch with.
C_Location_ID YVARCHAR2(32)A specific place or residence.
ReferenceNo YNVARCHAR2(40)The number for a specific reference.
Description YNVARCHAR2(255)A space to write additional related information.
POReference YNVARCHAR2(20)A reference or document order number as listed in business partner application.
C_Currency_ID NVARCHAR2(32)An accepted medium of monetary exchange that may vary across countries.
PaymentTerm NNVARCHAR2(60)Payment Term
PaymentTermNote YNVARCHAR2(2000)Note of a Payment Term
C_Charge_ID YVARCHAR2(32)A cost or expense incurred during business activity.
ChargeAmt YNUMBERThe amount of a cost or expense incurred during business activity.
TotalLines NNUMBERThe final sum of all line totals made to a specified document or transaction (not including taxes).
GrandTotal NNUMBERThe final monetary amount (including taxes) charge listed in a document.
M_PriceList_ID NVARCHAR2(32)A catalog of selected items with prices defined generally or for a specific partner.
IsTaxIncluded YCHAR(1)Tax is included in the price
C_Campaign_ID YVARCHAR2(32)An advertising effort aimed at increasing sales.
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.
M_Shipper_ID YVARCHAR2(32)The name of the company making the shipment.
DeliveryRule NVARCHAR2(60)A definition stating when a specific delivery will occur.
DeliveryViaRule NVARCHAR2(60)The desired means of getting requested goods to a business partner.
PriorityRule NVARCHAR2(60)A defined level of importance or precedence.
InvoiceRule NVARCHAR2(60)Frequency and method of invoicing

Columns

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

Language

The Language identifies the language to use for display

top

Sales Order

Unique identifier and a reference to a Sales Order originating from the document sequence defined for this document type.

top

Sales Transaction

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

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

Document Status

The Document Status indicates the status of a document at this time. To change the status of a document, use one of the buttons usually located at the bottom of the document window.

List values: All_Document Status

The allowed values for this list are:

top

Document Type

The Document Type determines document sequence and processing rules

top

Business Partner

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

top

BP Search Key

Search Key of Business Partner

top

Org Location

Foreign key column to Org_Location table, (column: null)

top

Tax ID

The Tax ID field identifies the legal Identification number of this Entity.

top

Document Type Name

Document Type

top

Document Type Note

Optional note of a document type

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 Representative Name

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

BP Greeting

Greeting for Business Partner

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

Name 2

Additional Name

top

BP Contact Greeting

Greeting for Business Partner Contact

top

Position

The Title indicates the name that an entity is referred to as.

top

Contact Name

Business Partner Contact Name

top

Location / Address

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

top

Reference No.

The reference number can be printed on orders and invoices to allow your business partner to faster identify your records.

top

Description

A description is limited to 255 characters.

top

Order Reference

This can be used to input a reference for this specific transaction. For example, a Purchase Order number can be input on a Sales Order for easier reference.

top

Currency

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

top

Payment Term

Payment Term

top

Payment Term Note

Note of a Payment Term

top

Charge

Foreign key column to C_Charge table, (column: C_Charge_ID)

top

Charge Amount

The Charge Amount indicates the amount for an additional charge.

top

Summed Line Amount

The Total amount displays the total of all lines in document currency

top

Grand Total Amount

The Grand Total displays the total amount including Tax and Freight in document currency

top

Price List

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

top

Price includes Tax

The Tax Included checkbox indicates if the prices include tax. This is also known as the gross price.

top

Sales Campaign

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

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

Shipping Company

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

top

Delivery Terms

The Delivery Rule indicates when an order should be delivered. For example should the order be delivered when the entire order is complete, when a line is complete or as the products become available.

List values: C_Order DeliveryRule

The allowed values for this list are:

top

Delivery Method

The Delivery Via indicates how the products should be delivered. For example, will the order be picked up or shipped.

List values: C_Order DeliveryViaRule

The allowed values for this list are:

top

Priority

The Priority indicates the importance (high, medium, low) of this document

List values: All_PriorityRule

The allowed values for this list are:

top

Invoice Terms

The Invoice Rule defines how a Business Partner is invoiced and the frequency of invoicing.

List values: C_Order InvoiceRule

The allowed values for this list are:

top

Retrieved from "http://wiki.openbravo.com/wiki/ERP_2.50:Developers_Guide/Database_Model/org.openbravo.model.common.order/C_Order_Header_V"

This page has been accessed 3,955 times. This page was last modified on 14 June 2011, at 11:04. Content is available under Creative Commons Attribution-ShareAlike 2.5 Spain License.