ERP/2.50/Developers Guide/Database Model/org.openbravo.model.common.invoice/C Invoice V2
C_Invoice_V2
- Name:InvoiceV2
- Classname:InvoiceV2
This table contains the following columns:
| Name | Nullable | Data Type | Description |
| C_Invoice_ID | N | VARCHAR2(32) | A document listing products, quantities and prices, payment terms, etc. |
| AD_Client_ID | N | VARCHAR2(32) | Client for this installation. |
| AD_Org_ID | N | VARCHAR2(32) | Organizational entity within client |
| IsActive | N | CHAR(1) | A flag indicating whether this record is available for use or de-activated. |
| Created | N | DATE | The date that this record is completed. |
| CreatedBy | N | VARCHAR2(32) | User who created this records |
| Updated | N | DATE | x not implemented |
| UpdatedBy | N | VARCHAR2(32) | User who updated this records |
| IsSOTrx | N | CHAR(1) | An indication that a transfer of goods and money between business partners is occurring. |
| DocumentNo | N | NVARCHAR2(30) | An often automatically generated identifier for all documents. |
| DocStatus | N | VARCHAR2(60) | The Document Status indicates the status of a document at this time. |
| DocAction | N | VARCHAR2(60) | A means of changing the transaction status of the document. |
| IsPrinted | N | CHAR(1) | A reference stating whether or not the document has been printed at any time in the past. |
| IsDiscountPrinted | N | CHAR(1) | An option to have any discount printed on the invoice. |
| Processing | Y | CHAR(1) | A request to process the respective document or task. |
| Processed | N | CHAR(1) | A confirmation that the associated documents or requests are processed. |
| C_DocType_ID | N | VARCHAR2(32) | A value defining what sequence and process setup are used to handle this document. |
| C_DocTypeTarget_ID | N | VARCHAR2(32) | The specific document type which should be used for the document. |
| C_Order_ID | Y | VARCHAR2(32) | A unique and often automatically generated identifier for a sales order. |
| Description | Y | NVARCHAR2(255) | A space to write additional related information. |
| SalesRep_ID | Y | VARCHAR2(32) | The person in charge of a document. |
| DateInvoiced | N | DATE | The time listed on the invoice. |
| DatePrinted | Y | DATE | Date the document was printed. |
| DateAcct | N | DATE | The date this transaction is recorded for in the general ledger. |
| C_BPartner_ID | N | VARCHAR2(32) | Anyone who takes part in daily business operations by acting as a customer, employee, etc. |
| C_BPartner_Location_ID | N | VARCHAR2(32) | The location of the selected business partner. |
| AD_User_ID | Y | VARCHAR2(32) | An acquaintance to reach for information related to the business partner. |
| C_BP_Group_ID | N | VARCHAR2(32) | A classification of business partners based on defined similarities. |
| POReference | Y | NVARCHAR2(20) | A reference or document order number as listed in business partner application. |
| DateOrdered | Y | DATE | The time listed on the order. |
| C_Currency_ID | N | VARCHAR2(32) | An accepted medium of monetary exchange that may vary across countries. |
| PaymentRule | N | VARCHAR2(60) | The method used for payment of this transaction. |
| C_PaymentTerm_ID | N | VARCHAR2(32) | The setup and timing defined to complete a specified payment. |
| M_PriceList_ID | N | VARCHAR2(32) | A catalog of selected items with prices defined generally or for a specific partner. |
| C_Campaign_ID | Y | VARCHAR2(32) | An advertising effort aimed at increasing sales. |
| C_Project_ID | Y | VARCHAR2(32) | Identifier of a project defined within the Project & Service Management module. |
| C_Activity_ID | Y | VARCHAR2(32) | A distinct activity defined and used in activity based management. |
| C_Charge_ID | Y | VARCHAR2(32) | A cost or expense incurred during business activity. |
| ChargeAmt | Y | NUMBER | The amount of a cost or expense incurred during business activity. |
| TotalLines | Y | NUMBER | The final sum of all line totals made to a specified document or transaction (not including taxes). |
| GrandTotal | Y | NUMBER | The final monetary amount (including taxes) charge listed in a document. |
| Multiplier | Y | NUMBER | null |
Columns
Invoice
- Physical column name: C_Invoice_ID
- Reference: Search
Foreign key column to C_Invoice table, (column: C_Invoice_ID)
Client
- Physical column name: AD_Client_ID
- Reference: TableDir
- Default value: @AD_CLIENT_ID@
Foreign key column to AD_Client table, (column: AD_Client_ID)
Organization
- Physical column name: AD_Org_ID
- Reference: TableDir
- Default value: @AD_Org_ID@
Foreign key column to AD_Org table, (column: AD_Org_ID)
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.
- Physical column name: IsActive
- Reference: YesNo
Creation Date
The Created field indicates the date that this record was created.
- Physical column name: Created
- Reference: DateTime
Created By
- Physical column name: CreatedBy
- Reference: Search
Foreign key column to AD_User table, (column: AD_User_ID)
Updated
The Updated field indicates the date that this record was updated.
- Physical column name: Updated
- Reference: DateTime
Updated By
- Physical column name: UpdatedBy
- Reference: Search
Foreign key column to AD_User table, (column: AD_User_ID)
Sales Transaction
The Sales Transaction checkbox indicates if this item is a Sales Transaction.
- Physical column name: IsSOTrx
- Reference: YesNo
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).
- Physical column name: DocumentNo
- Reference: String
- This column is part of the table's identifier
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.
- Physical column name: DocStatus
- Reference: List
List values: All_Document Status
The allowed values for this list are:
- ?? (Unknown)
- AP (Accepted)
- CH (Modified)
- CL (Closed)
- CO (Completed)
- DR (Draft)
- IN (Inactive)
- IP (Under Way)
- NA (Not Accepted)
- PE (Accounting Error)
- PO (Posted)
- PR (Printed)
- RE (Re-Opened)
- TE (Transfer Error)
- TR (Transferred)
- VO (Voided)
- WP (Not Paid)
- XX (Procesando)
Document Action
You find the current status in the Document Status field. The options are listed in a popup
- Physical column name: DocAction
- Reference: List
List values: All_Document Action
The allowed values for this list are:
- -- (<None>): No action
- AP (Approve): Approve this transaction
- CL (Close): Finally close this transaction. It cannot be re-activated.
- CO (Complete): Generate documents and complete transaction
- PO (Post): Post transaction
- PR (Process): Reserve Inventory
- RA (Reverse - Accrual): Reverse by switching Dr/Cr with current date
- RC (Void): Reverse Transaction (correction) by reversing sign with same date
- RE (Reactivate): Reverse documents/inventory and allow changes; You need to Complete the transaction after the change.
- RJ (Reject): Reject the approval of the document.
- TR (Transfer)
- VO (Void): Set all quantities to zero and complete transaction
- XL (Unlock): Unlock transaction (process error)
The Printed checkbox indicates if this document or line will included when printing.
- Physical column name: IsPrinted
- Reference: YesNo
Print Discount
The Discount Printed Checkbox indicates if the discount will be printed on the document.
- Physical column name: IsDiscountPrinted
- Reference: YesNo
Process Now
When this field is set as 'Y' a process is being performed on this record.
- Physical column name: Processing
- Reference: YesNo
Processed
The Processed checkbox indicates that a document has been processed.
- Physical column name: Processed
- Reference: YesNo
Document Type
- Physical column name: C_DocType_ID
- Reference: TableDir
Foreign key column to C_DocType table, (column: C_DocType_ID)
Transaction Document
- Physical column name: C_DocTypeTarget_ID
- Reference: Table
Foreign key column to C_DocType table, (column: C_DocType_ID)
Reference Table C_DocType With the following where clause:
C_DocType.AD_Client_ID=@#AD_Client_ID@
Sales Order
- Physical column name: C_Order_ID
- Reference: Search
Foreign key column to C_Order table, (column: C_Order_ID)
Description
A description is limited to 255 characters.
- Physical column name: Description
- Reference: String
Sales Representative
- Physical column name: SalesRep_ID
- Reference: Table
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')
Invoice Date
The Date Invoice indicates the date printed on the invoice.
- Physical column name: DateInvoiced
- Reference: Date
Date printed
Indicates the Date that a document was printed.
- Physical column name: DatePrinted
- Reference: Date
Accounting Date
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.
- Physical column name: DateAcct
- Reference: Date
Business Partner
- Physical column name: C_BPartner_ID
- Reference: Search
Foreign key column to C_BPartner table, (column: C_BPartner_ID)
Partner Address
- Physical column name: C_BPartner_Location_ID
- Reference: TableDir
Foreign key column to C_BPartner_Location table, (column: C_BPartner_Location_ID)
User/Contact
- Physical column name: AD_User_ID
- Reference: TableDir
Foreign key column to AD_User table, (column: AD_User_ID)
Business Partner Category
- Physical column name: C_BP_Group_ID
- Reference: TableDir
Foreign key column to C_BP_Group table, (column: C_BP_Group_ID)
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.
- Physical column name: POReference
- Reference: String
Order Date
Indicates the Date an item was ordered.
- Physical column name: DateOrdered
- Reference: Date
Currency
- Physical column name: C_Currency_ID
- Reference: TableDir
Foreign key column to C_Currency table, (column: C_Currency_ID)
Form of Payment
Form of Payment indicates the method of payment used for this transaction (eg. cash, wire transfer, etc.)
- Physical column name: PaymentRule
- Reference: List
List values: All_Payment Rule
The allowed values for this list are:
- 1 (Wire Transfer): Wire Transfer
- 2 (Check): Check
- 3 (Promissory Note): Promissory Note
- 4 (Money Order)
- 5 (Bank Deposit)
- B (Cash): Cash payments that generate an automatic accounting line.
- C (Cash on Delivery): Cash on Delivery
- K (Credit Card)
- P (On Credit): Cash payments that do not generate an automatic accounting line. Its is not an automatic cash entry.
- R (Bank Remittance)
- T (Transfer (ACH))
- W (Withholding)
Payment Terms
- Physical column name: C_PaymentTerm_ID
- Reference: TableDir
Foreign key column to C_PaymentTerm table, (column: C_PaymentTerm_ID)
Price List
- Physical column name: M_PriceList_ID
- Reference: TableDir
Foreign key column to M_PriceList table, (column: M_PriceList_ID)
Sales Campaign
- Physical column name: C_Campaign_ID
- Reference: TableDir
Foreign key column to C_Campaign table, (column: C_Campaign_ID)
Project
- Physical column name: C_Project_ID
- Reference: TableDir
Foreign key column to C_Project table, (column: C_Project_ID)
Activity
- Physical column name: C_Activity_ID
- Reference: TableDir
Foreign key column to C_Activity table, (column: C_Activity_ID)
Charge
- Physical column name: C_Charge_ID
- Reference: TableDir
Foreign key column to C_Charge table, (column: C_Charge_ID)
Charge Amount
The Charge Amount indicates the amount for an additional charge.
- Physical column name: ChargeAmt
- Reference: Amount
Summed Line Amount
The Total amount displays the total of all lines in document currency
- Physical column name: TotalLines
- Reference: Amount
Grand Total Amount
The Grand Total displays the total amount including Tax and Freight in document currency
- Physical column name: GrandTotal
- Reference: Amount
Multiplier
Number of times needed to run this sequence in order to satisfy the complete process plan.
- Physical column name: Multiplier
- Reference: Number