ERP/3.0/Developers Guide/Reference/Entity Model/C OrderLine PE HQL
This article is protected against manual editing because it is automatically generated from Openbravo meta-data. Learn more about writing and translating such documents.
C_OrderLine_PE_HQL
To the database table (C_OrderLine_PE_HQL) of this entity.
Properties
Note:
- Properties marked with a * are part of the Id of the Entity.
- Properties marked with a # are part of the Identifier of the Entity.
Property | Column | Constraints | Type | Description |
createdBy | createdBy | Max Length: 60 | java.lang.String | The Created By field indicates the user who created this record. |
creationDate | created | java.util.Date | The Created field indicates the date that this record was created. | |
goodsShipmentLine | shipmentInOutLine | Max Length: 60 | java.lang.String | The Goods Shipment Line indicates a unique line in a Shipment document |
lineNo | lineNo | java.lang.Long | Indicates the unique line for a document. It will also control the display order of the lines within a document. | |
operativeQuantity | operativeQuantity | java.math.BigDecimal | The number of a certain item involved in the transaction, according to the defined Operative UOM. | |
operativeUOM | operativeUOM | Max Length: 30 | java.lang.String | The Alternative UOM defines a unique non monetary unit of measure |
orderDate | orderDate | java.util.Date | Indicates the Date an item was ordered. | |
orderQuantity | orderQuantity | java.math.BigDecimal |
Product quantity in the order uom. | |
orderedQuantity | orderedQuantity | java.math.BigDecimal | The Quantity indicates the number of a specific product or item for this document. | |
product | product | Max Length: 60 | java.lang.String | Identifies an item which is either purchased or sold in this organization. |
id*# | id | java.lang.String | A unique identifier and a reference to a sales order line (product). | |
scheduledDeliveryDate | scheduledDeliveryDate | java.util.Date | Scheduled Delivery Date indicates the date, if any, that an order was promised by. | |
uOM | uOM | Max Length: 30 | java.lang.String | The UOM defines a unique non monetary unit of measure |
updated | updated | java.util.Date | The Updated field indicates the date that this record was updated. | |
updatedBy | updatedBy | Max Length: 60 | java.lang.String | The Updated By field indicates the user who updated this record. |
warehouse | warehouse | Max Length: 20 | java.lang.String | |
documentNo | documentNo | java.lang.String | 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). | |
grandTotalAmount | grandTotalAmount | java.math.BigDecimal | The Grand Total displays the total amount including Tax and Freight in document currency
|