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

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

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

Index

Contents

C_Order_Open

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
C_Order_ID NVARCHAR2(32)A unique and often automatically generated identifier for a sales order.
DocStatus NVARCHAR2(60)The Document Status indicates the status of a document at this time.
DocAction NVARCHAR2(60)A means of changing the transaction status of the document.
C_DocType_ID NVARCHAR2(32)A value defining what sequence and process setup are used to handle this document.
SalesRep_ID YVARCHAR2(32)The person in charge of a document.
C_BPartner_ID NVARCHAR2(32)Anyone who takes part in daily business operations by acting as a customer, employee, etc.
C_BPartner_Location_ID NVARCHAR2(32)The location of the selected business partner.
AD_User_ID YVARCHAR2(32)An acquaintance to reach for information related to the business partner.
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.
IsSOTrx NCHAR(1)An indication that a transfer of goods and money between business partners is occurring.
C_OrderLine_ID NVARCHAR2(32)A unique and often automatically generated identifier for a sales order line.
DateOrdered NDATEThe time listed on the order.
DatePromised YDATEThe date that a task, process, or action is to be completed or delivered by.
M_Product_ID YVARCHAR2(32)An item produced by a process.
M_Warehouse_ID NVARCHAR2(32)The location where products arrive to or are sent from.
DirectShip NCHAR(1)Ship direct from Vendor to Customer
C_UOM_ID NVARCHAR2(32)A non monetary unit of measure.
QtyOrdered NNUMBERThe number of an item involved in a transaction, given in standard units. It is used to determine price per unit.
QtyReserved NNUMBERReserved Quantity
QtyDelivered NNUMBERDelivered Quantity
QtyInvoiced NNUMBERThe total number of a product included in an invoice to a business partner.
PriceActual NNUMBERThe price that will be paid for a specified item.
QtyToDeliver YNUMBERnull
QtyToInvoice YNUMBERnull
NetAmtToInvoice YNUMBERNet amount of this Invoice

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

Sales Order

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

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 Action


You find the current status in the Document Status field. The options are listed in a popup

List values: All_Document Action

The allowed values for this list are:

top

Document Type

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

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)

top

User/Contact

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

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

Sales Transaction

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

top

Sales Order Line

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

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

Product

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

top

Warehouse

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

top

Direct shipment

Direct Shipment indicates if this line will ship directly from the vendor to the customer

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

Reserved Quantity

The Reserved Quantity indicates the quantity of a product that is currently reserved for this order.

top

Delivered Quantity

The Delivered Quantity indicates the quantity of a product that has already been delivered.

top

Invoiced Quantity

The Invoiced Quantity indicates the quantity of a product that have been invoiced.

top

Unit Price

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

top

Qty to deliver

top

Qty to invoice

top

Invoice net Amount

Indicates the net amount for this invoice. It does not include shipping or any additional charges.

top

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

This page has been accessed 3,074 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.