Class Invoice

    • Field Detail

      • PROPERTY_ID

        public static final String PROPERTY_ID
        Property id stored in column C_Invoice_ID in table C_Invoice
        Help: The Invoice ID uniquely identifies an Invoice Document.
        See Also:
        Constant Field Values
      • PROPERTY_CREATIONDATE

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

        public static final String PROPERTY_SALESTRANSACTION
        Property salesTransaction stored in column IsSOTrx in table C_Invoice
        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_Invoice
        See Also:
        Constant Field Values
      • PROPERTY_DOCUMENTSTATUS

        public static final String PROPERTY_DOCUMENTSTATUS
        Property documentStatus stored in column DocStatus in table C_Invoice
        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_Invoice
        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_Invoice
        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_Invoice
        Help: The Processed checkbox indicates that a document has been processed.
        See Also:
        Constant Field Values
      • PROPERTY_POSTED

        public static final String PROPERTY_POSTED
        Property posted stored in column Posted in table C_Invoice
        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_DOCUMENTTYPE

        public static final String PROPERTY_DOCUMENTTYPE
        Property documentType stored in column C_DocType_ID in table C_Invoice
        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_Invoice
        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_SALESORDER

        public static final String PROPERTY_SALESORDER
        Property salesOrder stored in column C_Order_ID in table C_Invoice
        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_DESCRIPTION

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

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

        public static final String PROPERTY_SALESREPRESENTATIVE
        Property salesRepresentative stored in column SalesRep_ID in table C_Invoice
        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_INVOICEDATE

        public static final String PROPERTY_INVOICEDATE
        Property invoiceDate stored in column DateInvoiced in table C_Invoice
        See Also:
        Constant Field Values
      • PROPERTY_DATEPRINTED

        public static final String PROPERTY_DATEPRINTED
        Property datePrinted stored in column DatePrinted in table C_Invoice
        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_Invoice
        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_Invoice
        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_PARTNERADDRESS

        public static final String PROPERTY_PARTNERADDRESS
        Property partnerAddress stored in column C_BPartner_Location_ID in table C_Invoice
        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_Invoice
        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_Invoice
        Help: The Discount Printed Checkbox indicates if the discount will be printed on the document.
        See Also:
        Constant Field Values
      • PROPERTY_ORDERDATE

        public static final String PROPERTY_ORDERDATE
        Property orderDate stored in column DateOrdered in table C_Invoice
        Help: Indicates the Date an item was ordered.
        See Also:
        Constant Field Values
      • PROPERTY_CURRENCY

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

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

        public static final String PROPERTY_CHARGE
        Property charge stored in column C_Charge_ID in table C_Invoice
        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_Invoice
        Help: The Charge Amount indicates the amount for an additional charge.
        See Also:
        Constant Field Values
      • PROPERTY_SUMMEDLINEAMOUNT

        public static final String PROPERTY_SUMMEDLINEAMOUNT
        Property summedLineAmount stored in column TotalLines in table C_Invoice
        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_Invoice
        See Also:
        Constant Field Values
      • PROPERTY_PRICELIST

        public static final String PROPERTY_PRICELIST
        Property priceList stored in column M_PriceList_ID in table C_Invoice
        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_Invoice
        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_Invoice
        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_Invoice
        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_Invoice
        Help: Activities indicate tasks that are performed and used to utilize Activity based Costing
        See Also:
        Constant Field Values
      • PROPERTY_CREATELINESFROM

        public static final String PROPERTY_CREATELINESFROM
        Property createLinesFrom stored in column CreateFrom in table C_Invoice
        Help: A process that allows the user to copy lines (products) from an existing document different from the one being copied into. For example, in case of entering a new Goods Shipment, the user can copy lines (products) from an existing Sales Order or Sales Invoice.
        See Also:
        Constant Field Values
      • PROPERTY_GENERATETO

        public static final String PROPERTY_GENERATETO
        Property generateTo stored in column GenerateTo in table C_Invoice
        Help: A button that creates documents
        See Also:
        Constant Field Values
      • PROPERTY_USERCONTACT

        public static final String PROPERTY_USERCONTACT
        Property userContact stored in column AD_User_ID in table C_Invoice
        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_Invoice
        Help: Copy lines (products) from another document of the same type.
        See Also:
        Constant Field Values
      • PROPERTY_SELFSERVICE

        public static final String PROPERTY_SELFSERVICE
        Property selfService stored in column IsSelfService in table C_Invoice
        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_Invoice
        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_Invoice
        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_Invoice
        Help: The user defined element displays the optional elements that have been defined for this account combination.
        See Also:
        Constant Field Values
      • PROPERTY_WITHHOLDINGAMOUNT

        public static final String PROPERTY_WITHHOLDINGAMOUNT
        Property withholdingamount stored in column Withholdingamount in table C_Invoice
        See Also:
        Constant Field Values
      • PROPERTY_TAXDATE

        public static final String PROPERTY_TAXDATE
        Property taxDate stored in column Taxdate in table C_Invoice
        Help: Tax Date
        See Also:
        Constant Field Values
      • PROPERTY_WITHHOLDING

        public static final String PROPERTY_WITHHOLDING
        Property withholding stored in column C_Withholding_ID in table C_Invoice
        Help: The Withholding indicates the type of withholding to be calculated.
        See Also:
        Constant Field Values
      • PROPERTY_PAYMENTCOMPLETE

        public static final String PROPERTY_PAYMENTCOMPLETE
        Property paymentComplete stored in column Ispaid in table C_Invoice
        Help: The document is paid for.
        See Also:
        Constant Field Values
      • PROPERTY_TOTALPAID

        public static final String PROPERTY_TOTALPAID
        Property totalPaid stored in column Totalpaid in table C_Invoice
        Help: Total amount paid.
        See Also:
        Constant Field Values
      • PROPERTY_OUTSTANDINGAMOUNT

        public static final String PROPERTY_OUTSTANDINGAMOUNT
        Property outstandingAmount stored in column OutstandingAmt in table C_Invoice
        Help: Outstanding Amount. Amount pending to be paid
        See Also:
        Constant Field Values
      • PROPERTY_DAYSTILLDUE

        public static final String PROPERTY_DAYSTILLDUE
        Property daysTillDue stored in column DaysTillDue in table C_Invoice
        Help: Number of days left for the next due date
        See Also:
        Constant Field Values
      • PROPERTY_DUEAMOUNT

        public static final String PROPERTY_DUEAMOUNT
        Property dueAmount stored in column DueAmt in table C_Invoice
        Help: Total amount due
        See Also:
        Constant Field Values
      • PROPERTY_LASTCALCULATEDONDATE

        public static final String PROPERTY_LASTCALCULATEDONDATE
        Property lastCalculatedOnDate stored in column LastCalculatedOnDate in table C_Invoice
        Help: Last Calculated On Date for payment monitor
        See Also:
        Constant Field Values
      • PROPERTY_PAYMENTMETHOD

        public static final String PROPERTY_PAYMENTMETHOD
        Property paymentMethod stored in column FIN_Paymentmethod_ID in table C_Invoice
        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_Invoice
        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_FINALSETTLEMENTDATE

        public static final String PROPERTY_FINALSETTLEMENTDATE
        Property finalSettlementDate stored in column Finalsettlement in table C_Invoice
        See Also:
        Constant Field Values
      • PROPERTY_DAYSSALESOUTSTANDING

        public static final String PROPERTY_DAYSSALESOUTSTANDING
        Property daysSalesOutstanding stored in column Daysoutstanding in table C_Invoice
        See Also:
        Constant Field Values
      • PROPERTY_PERCENTAGEOVERDUE

        public static final String PROPERTY_PERCENTAGEOVERDUE
        Property percentageOverdue stored in column Percentageoverdue in table C_Invoice
        See Also:
        Constant Field Values
      • PROPERTY_COSTCENTER

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

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

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

        public static final String PROPERTY_APRMADDPAYMENT
        Property aPRMAddpayment stored in column EM_APRM_Addpayment in table C_Invoice
        Help: Launches a process to add a payment to the selected invoice.
        See Also:
        Constant Field Values
      • PROPERTY_CASHVAT

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

        public static final String PROPERTY_APRMPROCESSINVOICE
        Property aPRMProcessinvoice stored in column EM_APRM_Processinvoice in table C_Invoice
        See Also:
        Constant Field Values
      • PROPERTY_PREPAYMENTAMT

        public static final String PROPERTY_PREPAYMENTAMT
        Property prepaymentamt stored in column Prepaymentamt in table C_Invoice
        See Also:
        Constant Field Values
      • PROPERTY_CREATELINESFROMORDER

        public static final String PROPERTY_CREATELINESFROMORDER
        Property createLinesFromOrder stored in column Createfromorders in table C_Invoice
        Help: A process that allows the user to copy lines (products) from an existing document different from the one being copied into. For example,the user can copy lines (products) from an existing Sales Order or Purchase Order.
        See Also:
        Constant Field Values
      • PROPERTY_CREATELINESFROMSHIPMENT

        public static final String PROPERTY_CREATELINESFROMSHIPMENT
        Property createLinesFromShipment stored in column Createfrominouts in table C_Invoice
        Help: A process that allows the user to copy lines (products) from an existing document different from the one being copied into. For example,the user can copy lines (products) from an existing Goods Shipment/Receipt.
        See Also:
        Constant Field Values
      • PROPERTY_PAIDAMOUNTATINVOICING

        public static final String PROPERTY_PAIDAMOUNTATINVOICING
        Property paidAmountAtInvoicing stored in column Paidamtatinvoicing in table C_Invoice
        See Also:
        Constant Field Values
      • PROPERTY_EXTERNALBUSINESSPARTNERREFERENCE

        public static final String PROPERTY_EXTERNALBUSINESSPARTNERREFERENCE
        Property externalBusinessPartnerReference stored in column BPartner_ExtRef in table C_Invoice
        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_ALTERNATELOCATION

        public static final String PROPERTY_ALTERNATELOCATION
        Property alternateLocation stored in column C_Alternate_Location_ID in table C_Invoice
        Help: Different invoice location where the order will be invoiced
        See Also:
        Constant Field Values
      • PROPERTY_EINVOICESTATUS

        public static final String PROPERTY_EINVOICESTATUS
        Property einvoiceStatus stored in column Einvoice_Status in table C_Invoice
        Help: The status of the e-invoice generation
        See Also:
        Constant Field Values
      • PROPERTY_EINVOICEGENERATED

        public static final String PROPERTY_EINVOICEGENERATED
        Property einvoiceGenerated stored in column Einvoice_Generated in table C_Invoice
        Help: When the e-invoice document was generated
        See Also:
        Constant Field Values
      • PROPERTY_EINVOICEEXTERNALID

        public static final String PROPERTY_EINVOICEEXTERNALID
        Property einvoiceExternalID stored in column Einvoice_ExternalID in table C_Invoice
        Help: Reference to the e-invoice document in an external system
        See Also:
        Constant Field Values
      • PROPERTY_EINVOICESENDSTATUS

        public static final String PROPERTY_EINVOICESENDSTATUS
        Property einvoiceSendStatus stored in column Einvoice_Send_Status in table C_Invoice
        See Also:
        Constant Field Values
      • PROPERTY_EINVOICESENT

        public static final String PROPERTY_EINVOICESENT
        Property einvoiceSent stored in column Einvoice_Sent in table C_Invoice
        Help: Date when the e-invoice document was sent to an external system
        See Also:
        Constant Field Values
      • PROPERTY_INVOICETAXCASHVATVLIST

        public static final String PROPERTY_INVOICETAXCASHVATVLIST
        Property invoiceTaxCashVATVList stored in table C_Invoice
        See Also:
        Constant Field Values
      • PROPERTY_CURRENCYCONVERSIONRATEDOCLIST

        public static final String PROPERTY_CURRENCYCONVERSIONRATEDOCLIST
        Property currencyConversionRateDocList stored in table C_Invoice
        See Also:
        Constant Field Values
      • PROPERTY_FINPAYMENTSCHEDINVVLIST

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

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

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

        public static final String PROPERTY_FINANCIALMGMTDEBTPAYMENTLIST
        Property financialMgmtDebtPaymentList stored in table C_Invoice
        See Also:
        Constant Field Values
      • PROPERTY_INVOICEDISCOUNTLIST

        public static final String PROPERTY_INVOICEDISCOUNTLIST
        Property invoiceDiscountList stored in table C_Invoice
        See Also:
        Constant Field Values
      • PROPERTY_INVOICELINELIST

        public static final String PROPERTY_INVOICELINELIST
        Property invoiceLineList stored in table C_Invoice
        See Also:
        Constant Field Values
      • PROPERTY_INVOICELINETAXLIST

        public static final String PROPERTY_INVOICELINETAXLIST
        Property invoiceLineTaxList stored in table C_Invoice
        See Also:
        Constant Field Values
      • PROPERTY_INVOICETAXLIST

        public static final String PROPERTY_INVOICETAXLIST
        Property invoiceTaxList stored in table C_Invoice
        See Also:
        Constant Field Values
      • PROPERTY_MATERIALMGMTSHIPMENTINOUTLIST

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

        public static final String PROPERTY_PRICINGVOLUMEDISCOUNTINVOICELIST
        Property pricingVolumeDiscountInvoiceList stored in table C_Invoice
        See Also:
        Constant Field Values
      • PROPERTY_REVERSEDINVOICESLIST

        public static final String PROPERTY_REVERSEDINVOICESLIST
        Property reversedInvoicesList stored in table C_Invoice
        See Also:
        Constant Field Values
      • PROPERTY_REVERSEDINVOICESREVERSEDINVOICELIST

        public static final String PROPERTY_REVERSEDINVOICESREVERSEDINVOICELIST
        Property reversedInvoicesReversedInvoiceList stored in table C_Invoice
        See Also:
        Constant Field Values
    • Constructor Detail

      • Invoice

        public Invoice()