Class Order

    • Field Detail

      • PROPERTY_ID

        public static final String PROPERTY_ID
        Property id stored in column C_Order_ID in table C_Order
        Help: Unique identifier and a reference to a Sales Order originating from the document sequence defined for this document type.
        See Also:
        Constant Field Values
      • PROPERTY_CREATIONDATE

        public static final String PROPERTY_CREATIONDATE
        Property creationDate stored in column Created in table C_Order
        See Also:
        Traceable, Constant Field Values
      • PROPERTY_SALESTRANSACTION

        public static final String PROPERTY_SALESTRANSACTION
        Property salesTransaction stored in column IsSOTrx in table C_Order
        Help: The Sales Transaction checkbox indicates if this item is a Sales Transaction.
        See Also:
        Constant Field Values
      • PROPERTY_DOCUMENTNO

        public static final String PROPERTY_DOCUMENTNO
        Property documentNo stored in column DocumentNo in table C_Order
        See Also:
        Constant Field Values
      • PROPERTY_DOCUMENTSTATUS

        public static final String PROPERTY_DOCUMENTSTATUS
        Property documentStatus stored in column DocStatus in table C_Order
        Help: 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.
        See Also:
        Constant Field Values
      • PROPERTY_DOCUMENTACTION

        public static final String PROPERTY_DOCUMENTACTION
        Property documentAction stored in column DocAction in table C_Order
        Help: You find the current status in the Document Status field. The options are listed in a popup
        See Also:
        Constant Field Values
      • PROPERTY_PROCESSNOW

        public static final String PROPERTY_PROCESSNOW
        Property processNow stored in column Processing in table C_Order
        Help: When this field is set as 'Y' a process is being performed on this record.
        See Also:
        Constant Field Values
      • PROPERTY_PROCESSED

        public static final String PROPERTY_PROCESSED
        Property processed stored in column Processed in table C_Order
        Help: The Processed checkbox indicates that a document has been processed.
        See Also:
        Constant Field Values
      • PROPERTY_DOCUMENTTYPE

        public static final String PROPERTY_DOCUMENTTYPE
        Property documentType stored in column C_DocType_ID in table C_Order
        Help: The Document Type determines document sequence and processing rules
        See Also:
        Constant Field Values
      • PROPERTY_TRANSACTIONDOCUMENT

        public static final String PROPERTY_TRANSACTIONDOCUMENT
        Property transactionDocument stored in column C_DocTypeTarget_ID in table C_Order
        Help: Specifies document subtype (eg. POS Order, Return Material, etc.) that each document (such as Sales Invoice, Purchase Order, etc.). Various document subtypes usually differ on the consequences they have. You can convert document types (e.g. from Offer to Order). The conversion is then reflected in the current type.
        See Also:
        Constant Field Values
      • PROPERTY_DESCRIPTION

        public static final String PROPERTY_DESCRIPTION
        Property description stored in column Description in table C_Order
        Help: A description is limited to 255 characters.
        See Also:
        Constant Field Values
      • PROPERTY_DELIVERED

        public static final String PROPERTY_DELIVERED
        Property delivered stored in column IsDelivered in table C_Order
        See Also:
        Constant Field Values
      • PROPERTY_REINVOICE

        public static final String PROPERTY_REINVOICE
        Property reinvoice stored in column IsInvoiced in table C_Order
        Help: Indicator if invoiced
        See Also:
        Constant Field Values
      • PROPERTY_PRINT

        public static final String PROPERTY_PRINT
        Property print stored in column IsPrinted in table C_Order
        Help: The Printed checkbox indicates if this document or line will included when printing.
        See Also:
        Constant Field Values
      • PROPERTY_SELECTED

        public static final String PROPERTY_SELECTED
        Property selected stored in column IsSelected in table C_Order
        See Also:
        Constant Field Values
      • PROPERTY_SALESREPRESENTATIVE

        public static final String PROPERTY_SALESREPRESENTATIVE
        Property salesRepresentative stored in column SalesRep_ID in table C_Order
        Help: Indicates the sales representative responsible for the transaction that the document specifies . A valid sales representative is a business partner marked as an employee and a sales representative.
        See Also:
        Constant Field Values
      • PROPERTY_ORDERDATE

        public static final String PROPERTY_ORDERDATE
        Property orderDate stored in column DateOrdered in table C_Order
        See Also:
        Constant Field Values
      • PROPERTY_SCHEDULEDDELIVERYDATE

        public static final String PROPERTY_SCHEDULEDDELIVERYDATE
        Property scheduledDeliveryDate stored in column DatePromised in table C_Order
        Help: Scheduled Delivery Date indicates the date, if any, that an order was promised by.
        See Also:
        Constant Field Values
      • PROPERTY_DATEPRINTED

        public static final String PROPERTY_DATEPRINTED
        Property datePrinted stored in column DatePrinted in table C_Order
        Help: Indicates the Date that a document was printed.
        See Also:
        Constant Field Values
      • PROPERTY_ACCOUNTINGDATE

        public static final String PROPERTY_ACCOUNTINGDATE
        Property accountingDate stored in column DateAcct in table C_Order
        Help: The date this transaction is recorded on in the general ledger. This date also indicates which accounting period within the fiscal year this transaction will be part of.
        See Also:
        Constant Field Values
      • PROPERTY_BUSINESSPARTNER

        public static final String PROPERTY_BUSINESSPARTNER
        Property businessPartner stored in column C_BPartner_ID in table C_Order
        Help: A Business Partner is anyone with whom you transact. This can include a customer, vendor, employee or any combination of these.
        See Also:
        Constant Field Values
      • PROPERTY_INVOICEADDRESS

        public static final String PROPERTY_INVOICEADDRESS
        Property invoiceAddress stored in column BillTo_ID in table C_Order
        Help: An indication of the address to use in the invoice.<br />
        See Also:
        Constant Field Values
      • PROPERTY_PARTNERADDRESS

        public static final String PROPERTY_PARTNERADDRESS
        Property partnerAddress stored in column C_BPartner_Location_ID in table C_Order
        Help: The Partner address indicates the location of a Business Partner
        See Also:
        Constant Field Values
      • PROPERTY_ORDERREFERENCE

        public static final String PROPERTY_ORDERREFERENCE
        Property orderReference stored in column POReference in table C_Order
        Help: 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.
        See Also:
        Constant Field Values
      • PROPERTY_PRINTDISCOUNT

        public static final String PROPERTY_PRINTDISCOUNT
        Property printDiscount stored in column IsDiscountPrinted in table C_Order
        Help: The Discount Printed Checkbox indicates if the discount will be printed on the document.
        See Also:
        Constant Field Values
      • PROPERTY_CURRENCY

        public static final String PROPERTY_CURRENCY
        Property currency stored in column C_Currency_ID in table C_Order
        Help: Indicates the currency to be used when processing this document.
        See Also:
        Constant Field Values
      • PROPERTY_FORMOFPAYMENT

        public static final String PROPERTY_FORMOFPAYMENT
        Property formOfPayment stored in column PaymentRule in table C_Order
        Help: Form of Payment indicates the method of payment used for this transaction (eg. cash, wire transfer, etc.)
        See Also:
        Constant Field Values
      • PROPERTY_PAYMENTTERMS

        public static final String PROPERTY_PAYMENTTERMS
        Property paymentTerms stored in column C_PaymentTerm_ID in table C_Order
        Help: Payment Terms identify the method and timing of payment for this transaction.
        See Also:
        Constant Field Values
      • PROPERTY_INVOICETERMS

        public static final String PROPERTY_INVOICETERMS
        Property invoiceTerms stored in column InvoiceRule in table C_Order
        Help: The Invoice Rule defines how a Business Partner is invoiced and the frequency of invoicing.
        See Also:
        Constant Field Values
      • PROPERTY_DELIVERYTERMS

        public static final String PROPERTY_DELIVERYTERMS
        Property deliveryTerms stored in column DeliveryRule in table C_Order
        Help: 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.
        See Also:
        Constant Field Values
      • PROPERTY_FREIGHTCOSTRULE

        public static final String PROPERTY_FREIGHTCOSTRULE
        Property freightCostRule stored in column FreightCostRule in table C_Order
        Help: The Freight Cost Rule indicates the method used when charging for freight.
        See Also:
        Constant Field Values
      • PROPERTY_FREIGHTAMOUNT

        public static final String PROPERTY_FREIGHTAMOUNT
        Property freightAmount stored in column FreightAmt in table C_Order
        Help: The Freight Amount indicates the amount charged for Freight in the document currency.
        See Also:
        Constant Field Values
      • PROPERTY_DELIVERYMETHOD

        public static final String PROPERTY_DELIVERYMETHOD
        Property deliveryMethod stored in column DeliveryViaRule in table C_Order
        Help: The Delivery Via indicates how the products should be delivered. For example, will the order be picked up or shipped.
        See Also:
        Constant Field Values
      • PROPERTY_SHIPPINGCOMPANY

        public static final String PROPERTY_SHIPPINGCOMPANY
        Property shippingCompany stored in column M_Shipper_ID in table C_Order
        Help: The Shipper is any entity which will provide shipping to or shipping from an Organization.
        See Also:
        Constant Field Values
      • PROPERTY_CHARGE

        public static final String PROPERTY_CHARGE
        Property charge stored in column C_Charge_ID in table C_Order
        Help: The Charge indicates a type of Charge (Handling, Shipping, Restocking)
        See Also:
        Constant Field Values
      • PROPERTY_CHARGEAMOUNT

        public static final String PROPERTY_CHARGEAMOUNT
        Property chargeAmount stored in column ChargeAmt in table C_Order
        Help: The Charge Amount indicates the amount for an additional charge.
        See Also:
        Constant Field Values
      • PROPERTY_PRIORITY

        public static final String PROPERTY_PRIORITY
        Property priority stored in column PriorityRule in table C_Order
        Help: The Priority indicates the importance (high, medium, low) of this document
        See Also:
        Constant Field Values
      • PROPERTY_SUMMEDLINEAMOUNT

        public static final String PROPERTY_SUMMEDLINEAMOUNT
        Property summedLineAmount stored in column TotalLines in table C_Order
        Help: The Total amount displays the total of all lines in document currency
        See Also:
        Constant Field Values
      • PROPERTY_GRANDTOTALAMOUNT

        public static final String PROPERTY_GRANDTOTALAMOUNT
        Property grandTotalAmount stored in column GrandTotal in table C_Order
        See Also:
        Constant Field Values
      • PROPERTY_WAREHOUSE

        public static final String PROPERTY_WAREHOUSE
        Property warehouse stored in column M_Warehouse_ID in table C_Order
        Help: The Warehouse identifies a unique Warehouse where products are stored or Services are provided.
        See Also:
        Constant Field Values
      • PROPERTY_PRICELIST

        public static final String PROPERTY_PRICELIST
        Property priceList stored in column M_PriceList_ID in table C_Order
        Help: Price Lists are used to determine the pricing, margin and cost of items purchased or sold.
        See Also:
        Constant Field Values
      • PROPERTY_PRICEINCLUDESTAX

        public static final String PROPERTY_PRICEINCLUDESTAX
        Property priceIncludesTax stored in column IsTaxIncluded in table C_Order
        Help: The Tax Included checkbox indicates if the prices include tax. This is also known as the gross price.
        See Also:
        Constant Field Values
      • PROPERTY_SALESCAMPAIGN

        public static final String PROPERTY_SALESCAMPAIGN
        Property salesCampaign stored in column C_Campaign_ID in table C_Order
        Help: The Campaign defines a unique marketing program. Projects can be associated with a pre defined Marketing Campaign. You can then report based on a specific Campaign.
        See Also:
        Constant Field Values
      • PROPERTY_PROJECT

        public static final String PROPERTY_PROJECT
        Property project stored in column C_Project_ID in table C_Order
        Help: Identifier of a project defined within the Project & Service Management module.
        See Also:
        Constant Field Values
      • PROPERTY_ACTIVITY

        public static final String PROPERTY_ACTIVITY
        Property activity stored in column C_Activity_ID in table C_Order
        Help: Activities indicate tasks that are performed and used to utilize Activity based Costing
        See Also:
        Constant Field Values
      • PROPERTY_POSTED

        public static final String PROPERTY_POSTED
        Property posted stored in column Posted in table C_Order
        Help: An accounting status button that indicates if the transaction has already been posted to the general ledger or not. When doing the accounting manually this button can be used to post or unpost the transaction from the general ledger by hand.
        See Also:
        Constant Field Values
      • PROPERTY_USERCONTACT

        public static final String PROPERTY_USERCONTACT
        Property userContact stored in column AD_User_ID in table C_Order
        Help: The User identifies a unique user in the system. This could be an internal user or a business partner contact
        See Also:
        Constant Field Values
      • PROPERTY_COPYFROM

        public static final String PROPERTY_COPYFROM
        Property copyFrom stored in column CopyFrom in table C_Order
        Help: Copy lines (products) from another document of the same type.
        See Also:
        Constant Field Values
      • PROPERTY_DROPSHIPPARTNER

        public static final String PROPERTY_DROPSHIPPARTNER
        Property dropShipPartner stored in column DropShip_BPartner_ID in table C_Order
        Help: Business Partner for Drop Shipment
        See Also:
        Constant Field Values
      • PROPERTY_DROPSHIPLOCATION

        public static final String PROPERTY_DROPSHIPLOCATION
        Property dropShipLocation stored in column DropShip_Location_ID in table C_Order
        Help: Business Partner Shipment Location for Drop Shipment
        See Also:
        Constant Field Values
      • PROPERTY_DROPSHIPCONTACT

        public static final String PROPERTY_DROPSHIPCONTACT
        Property dropShipContact stored in column DropShip_User_ID in table C_Order
        Help: Business Partner Contact for Drop Shipment
        See Also:
        Constant Field Values
      • PROPERTY_SELFSERVICE

        public static final String PROPERTY_SELFSERVICE
        Property selfService stored in column IsSelfService in table C_Order
        Help: Self-Service allows users to enter data or update their data. The flag indicates, that this record was entered or created via Self-Service or that the user can change it via the Self-Service functionality.
        See Also:
        Constant Field Values
      • PROPERTY_TRXORGANIZATION

        public static final String PROPERTY_TRXORGANIZATION
        Property trxOrganization stored in column AD_OrgTrx_ID in table C_Order
        Help: The organization which performs or initiates this transaction (for another organization). The owning Organization may not be the transaction organization in a service bureau environment, with centralized services, and inter-organization transactions.
        See Also:
        Constant Field Values
      • PROPERTY_STDIMENSION

        public static final String PROPERTY_STDIMENSION
        Property stDimension stored in column User1_ID in table C_Order
        Help: The user defined element displays the optional elements that have been defined for this account combination.
        See Also:
        Constant Field Values
      • PROPERTY_NDDIMENSION

        public static final String PROPERTY_NDDIMENSION
        Property ndDimension stored in column User2_ID in table C_Order
        Help: The user defined element displays the optional elements that have been defined for this account combination.
        See Also:
        Constant Field Values
      • PROPERTY_DELIVERYNOTES

        public static final String PROPERTY_DELIVERYNOTES
        Property deliveryNotes stored in column Deliverynotes in table C_Order
        Help: Notes for the delivery
        See Also:
        Constant Field Values
      • PROPERTY_INCOTERMS

        public static final String PROPERTY_INCOTERMS
        Property incoterms stored in column C_Incoterms_ID in table C_Order
        Help: The ID identifies a unique Incoterm
        See Also:
        Constant Field Values
      • PROPERTY_INCOTERMSDESCRIPTION

        public static final String PROPERTY_INCOTERMSDESCRIPTION
        Property iNCOTERMSDescription stored in column Incotermsdescription in table C_Order
        Help: Description of the incoterm
        See Also:
        Constant Field Values
      • PROPERTY_GENERATETEMPLATE

        public static final String PROPERTY_GENERATETEMPLATE
        Property generateTemplate stored in column Generatetemplate in table C_Order
        Help: A button that copies the products that are defined as template in the business partner window
        See Also:
        Constant Field Values
      • PROPERTY_DELIVERYLOCATION

        public static final String PROPERTY_DELIVERYLOCATION
        Property deliveryLocation stored in column Delivery_Location_ID in table C_Order
        Help: Location where the product will be delivered to
        See Also:
        Constant Field Values
      • PROPERTY_COPYFROMPO

        public static final String PROPERTY_COPYFROMPO
        Property copyFromPO stored in column CopyFromPO in table C_Order
        Help: Copy lines from orders
        See Also:
        Constant Field Values
      • PROPERTY_PAYMENTMETHOD

        public static final String PROPERTY_PAYMENTMETHOD
        Property paymentMethod stored in column FIN_Paymentmethod_ID in table C_Order
        See Also:
        Constant Field Values
      • PROPERTY_FINPAYMENTPRIORITY

        public static final String PROPERTY_FINPAYMENTPRIORITY
        Property fINPaymentPriority stored in column FIN_Payment_Priority_ID in table C_Order
        Help: Sets the priority of the payment plans generated when processing the invoice or order. The distribution algorithm will be driven by this priority. The pending payments for order or payments will be displayed ordered by the payment priority first and then by the due date.
        See Also:
        Constant Field Values
      • PROPERTY_PICKFROMSHIPMENT

        public static final String PROPERTY_PICKFROMSHIPMENT
        Property pickFromShipment stored in column RM_PickFromShipment in table C_Order
        See Also:
        Constant Field Values
      • PROPERTY_RECEIVEMATERIALS

        public static final String PROPERTY_RECEIVEMATERIALS
        Property receiveMaterials stored in column RM_ReceiveMaterials in table C_Order
        See Also:
        Constant Field Values
      • PROPERTY_CREATEINVOICE

        public static final String PROPERTY_CREATEINVOICE
        Property createInvoice stored in column RM_CreateInvoice in table C_Order
        See Also:
        Constant Field Values
      • PROPERTY_RETURNREASON

        public static final String PROPERTY_RETURNREASON
        Property returnReason stored in column C_Return_Reason_ID in table C_Order
        See Also:
        Constant Field Values
      • PROPERTY_ADDORPHANLINE

        public static final String PROPERTY_ADDORPHANLINE
        Property addOrphanLine stored in column RM_AddOrphanLine in table C_Order
        See Also:
        Constant Field Values
      • PROPERTY_ASSET

        public static final String PROPERTY_ASSET
        Property asset stored in column A_Asset_ID in table C_Order
        Help: Any item of economic value owned by the corporation, especially that which could be converted to cash.
        See Also:
        Constant Field Values
      • PROPERTY_CALCULATEPROMOTIONS

        public static final String PROPERTY_CALCULATEPROMOTIONS
        Property calculatePromotions stored in column Calculate_Promotions in table C_Order
        See Also:
        Constant Field Values
      • PROPERTY_COSTCENTER

        public static final String PROPERTY_COSTCENTER
        Property costcenter stored in column C_Costcenter_ID in table C_Order
        Help: Division that adds to the cost of an organization. Internal structure for cost allocation.
        See Also:
        Constant Field Values
      • PROPERTY_CREATEORDER

        public static final String PROPERTY_CREATEORDER
        Property createOrder stored in column Convertquotation in table C_Order
        See Also:
        Constant Field Values
      • PROPERTY_REJECTREASON

        public static final String PROPERTY_REJECTREASON
        Property rejectReason stored in column C_Reject_Reason_ID in table C_Order
        See Also:
        Constant Field Values
      • PROPERTY_VALIDUNTIL

        public static final String PROPERTY_VALIDUNTIL
        Property validUntil stored in column validuntil in table C_Order
        See Also:
        Constant Field Values
      • PROPERTY_QUOTATION

        public static final String PROPERTY_QUOTATION
        Property quotation stored in column Quotation_ID in table C_Order
        See Also:
        Constant Field Values
      • PROPERTY_RESERVATIONSTATUS

        public static final String PROPERTY_RESERVATIONSTATUS
        Property reservationStatus stored in column SO_Res_Status in table C_Order
        Help: Identifies if the Sales Order is completely or partially reserved
        See Also:
        Constant Field Values
      • PROPERTY_CREATEPOLINES

        public static final String PROPERTY_CREATEPOLINES
        Property createPOLines stored in column Create_POLines in table C_Order
        See Also:
        Constant Field Values
      • PROPERTY_CASHVAT

        public static final String PROPERTY_CASHVAT
        Property cashVAT stored in column Iscashvat in table C_Order
        Help: Cash VAT tax rate
        See Also:
        Constant Field Values
      • PROPERTY_PICKFROMRECEIPT

        public static final String PROPERTY_PICKFROMRECEIPT
        Property pickfromreceipt stored in column RM_Pickfromreceipt in table C_Order
        See Also:
        Constant Field Values
      • PROPERTY_CANCELANDREPLACE

        public static final String PROPERTY_CANCELANDREPLACE
        Property cancelandreplace stored in column Cancelandreplace in table C_Order
        Help: Button that creates a temporal duplicated order
        See Also:
        Constant Field Values
      • PROPERTY_APRMADDPAYMENT

        public static final String PROPERTY_APRMADDPAYMENT
        Property aPRMAddPayment stored in column EM_APRM_AddPayment in table C_Order
        Help: Launches a process to add a payment to the selected invoice.
        See Also:
        Constant Field Values
      • PROPERTY_CONFIRMCANCELANDREPLACE

        public static final String PROPERTY_CONFIRMCANCELANDREPLACE
        Property confirmcancelandreplace stored in column Confirmcancelandreplace in table C_Order
        Help: Button that confirms the temporal Order by closing it and creates a canceled order
        See Also:
        Constant Field Values
      • PROPERTY_CANCELLEDORDER

        public static final String PROPERTY_CANCELLEDORDER
        Property cancelledorder stored in column Cancelledorder_id in table C_Order
        Help: Link to the order that has been canceled
        See Also:
        Constant Field Values
      • PROPERTY_REPLACEDORDER

        public static final String PROPERTY_REPLACEDORDER
        Property replacedorder stored in column Replacedorder_id in table C_Order
        Help: Link to the order that has been replaced
        See Also:
        Constant Field Values
      • PROPERTY_ISCANCELLED

        public static final String PROPERTY_ISCANCELLED
        Property iscancelled stored in column Iscancelled in table C_Order
        Help: The Sales Order has been canceled and canceled and replaced. A new Cancellation Sales Order has been created in Closed Status and if it is replaced also a new Sales Order in Book Status has been created replacing the original one.
        See Also:
        Constant Field Values
      • PROPERTY_REPLACEMENTORDER

        public static final String PROPERTY_REPLACEMENTORDER
        Property replacementorder stored in column Replacementorder_ID in table C_Order
        Help: Link to the replacement order. This order is the order that has replaced the current Cancelled order.
        See Also:
        Constant Field Values
      • PROPERTY_EXTERNALBUSINESSPARTNERREFERENCE

        public static final String PROPERTY_EXTERNALBUSINESSPARTNERREFERENCE
        Property externalBusinessPartnerReference stored in column BPartner_ExtRef in table C_Order
        Help: This field stores the business partner reference to an external CRM system. This is useful only when the business partner management is done outside Openbravo. In this case Openbravo will internally use the anonymous customer but it will track the real customer in the external system through this field.
        See Also:
        Constant Field Values
      • PROPERTY__COMPUTEDCOLUMNS

        public static final String PROPERTY__COMPUTEDCOLUMNS
        Property _computedColumns stored in column _computedColumns in table C_Order
        See Also:
        Constant Field Values
      • PROPERTY_FINPAYMENTSCHEDINVVLIST

        public static final String PROPERTY_FINPAYMENTSCHEDINVVLIST
        Property fINPaymentSchedInvVList stored in table C_Order
        See Also:
        Constant Field Values
      • PROPERTY_FINPAYMENTSCHEDORDVLIST

        public static final String PROPERTY_FINPAYMENTSCHEDORDVLIST
        Property fINPaymentSchedOrdVList stored in table C_Order
        See Also:
        Constant Field Values
      • PROPERTY_FINPAYMENTSCHEDULELIST

        public static final String PROPERTY_FINPAYMENTSCHEDULELIST
        Property fINPaymentScheduleList stored in table C_Order
        See Also:
        Constant Field Values
      • PROPERTY_INVOICELIST

        public static final String PROPERTY_INVOICELIST
        Property invoiceList stored in table C_Order
        See Also:
        Constant Field Values
      • PROPERTY_MATERIALMGMTSHIPMENTINOUTLIST

        public static final String PROPERTY_MATERIALMGMTSHIPMENTINOUTLIST
        Property materialMgmtShipmentInOutList stored in table C_Order
        See Also:
        Constant Field Values
      • PROPERTY_ORDERQUOTATIONLIST

        public static final String PROPERTY_ORDERQUOTATIONLIST
        Property orderQuotationList stored in table C_Order
        See Also:
        Constant Field Values
      • PROPERTY_ORDERCANCELLEDORDERLIST

        public static final String PROPERTY_ORDERCANCELLEDORDERLIST
        Property orderCancelledorderList stored in table C_Order
        See Also:
        Constant Field Values
      • PROPERTY_ORDERDISCOUNTLIST

        public static final String PROPERTY_ORDERDISCOUNTLIST
        Property orderDiscountList stored in table C_Order
        See Also:
        Constant Field Values
      • PROPERTY_ORDERLINELIST

        public static final String PROPERTY_ORDERLINELIST
        Property orderLineList stored in table C_Order
        See Also:
        Constant Field Values
      • PROPERTY_ORDERLINETAXLIST

        public static final String PROPERTY_ORDERLINETAXLIST
        Property orderLineTaxList stored in table C_Order
        See Also:
        Constant Field Values
      • PROPERTY_ORDERTAXLIST

        public static final String PROPERTY_ORDERTAXLIST
        Property orderTaxList stored in table C_Order
        See Also:
        Constant Field Values
      • PROPERTY_PROJECTLINELIST

        public static final String PROPERTY_PROJECTLINELIST
        Property projectLineList stored in table C_Order
        See Also:
        Constant Field Values
      • PROPERTY_PROJECTLINEPURCHASEORDERLIST

        public static final String PROPERTY_PROJECTLINEPURCHASEORDERLIST
        Property projectLinePurchaseOrderList stored in table C_Order
        See Also:
        Constant Field Values
      • PROPERTY_PROJECTPHASELIST

        public static final String PROPERTY_PROJECTPHASELIST
        Property projectPhaseList stored in table C_Order
        See Also:
        Constant Field Values
      • COMPUTED_COLUMN_DELIVERYSTATUS

        public static final String COMPUTED_COLUMN_DELIVERYSTATUS
        Computed column for property deliveryStatus

        Computed from:
        (coalesce((select case when sum(abs(ol.qtyordered)) = 0 or iscancelled = 'Y' or cancelledorder_id is not null then 0 else round(coalesce(sum(abs(ol.qtydelivered)), 0)/sum(abs(ol.qtyordered)) * 100, 0) end from c_orderline ol where ol.c_order_id=c_order_id and ol.c_order_discount_id is null),0))
        See Also:
        Constant Field Values
      • COMPUTED_COLUMN_INVOICESTATUS

        public static final String COMPUTED_COLUMN_INVOICESTATUS
        Computed column for property invoiceStatus

        Computed from:
        (coalesce((select case when sum(abs(ol.qtyordered)) = 0 or iscancelled = 'Y' or cancelledorder_id is not null then 0 else round(coalesce(sum(abs(ol.qtyinvoiced)), 0)/sum(abs(ol.qtyordered)) * 100, 0) end from c_orderline ol where ol.c_order_id=c_order_id and ol.c_order_discount_id is null), 0))
        See Also:
        Constant Field Values
      • COMPUTED_COLUMN_PAYMENTSTATUS

        public static final String COMPUTED_COLUMN_PAYMENTSTATUS
        Computed column for property paymentStatus
        Help: Percent paid of the order
        Computed from:
        (coalesce((select case when sum(fps.amount) = 0 then 0 else round(sum(fps.paidamt)/sum(fps.amount) 100, 0) end from FIN_Payment_Schedule fps where fps.c_order_id=c_order_id),0))
        See Also:
        Constant Field Values
    • Constructor Detail

      • Order

        public Order()