Table idempiere9.adempiere.c_invoice
Invoice Identifier

 Generated by
Quality Systems & Solutions
Legend:
Primary key columns
Columns with indexes
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
c_invoice_id numeric 10
c_bankstatementline
c_invoice
c_invoice
c_invoice
c_invoiceline
c_invoicetax
c_payment
i_bankstatement
i_invoice
i_payment
Invoice Identifier
ad_client_id numeric 10 Client/Tenant for this installation.
ad_org_id numeric 10
ad_org
Organizational entity within client
isactive bpchar 1 'Y'::bpchar The record is active in the system
created timestamp 29,6 now() Date this record was created
createdby numeric 10 User who created this records
updated timestamp 29,6 now() Date this record was updated
updatedby numeric 10 User who updated this records
issotrx bpchar 1 'Y'::bpchar This is a Sales Transaction
documentno varchar 30 Document sequence number of the document
docstatus bpchar 2 The current status of the document
docaction bpchar 2 The targeted status of the document
processing bpchar 1  √  null Process Now
processed bpchar 1 'N'::bpchar The document has been processed
posted bpchar 1 'N'::bpchar Posting status
c_doctype_id numeric 10
c_doctype
Document type or rules
c_doctypetarget_id numeric 10
c_doctype
Target document type for conversing documents
c_order_id numeric 10  √  null
c_order
Order
description varchar 255  √  null Optional short description of the record
isapproved bpchar 1 'Y'::bpchar Indicates if this document requires approval
istransferred bpchar 1 'N'::bpchar Transferred to General Ledger (i.e. accounted)
isprinted bpchar 1 'N'::bpchar Indicates if this document / line is printed
salesrep_id numeric 10  √  null
ad_user
Sales Representative or Company Agent
dateinvoiced timestamp 29,6 Date printed on Invoice
dateprinted timestamp 29,6  √  null Date the document was printed.
dateacct timestamp 29,6 Accounting Date
c_bpartner_id numeric 10
c_bpartner
Identifies a Business Partner
c_bpartner_location_id numeric 10
c_bpartner_location
Identifies the (ship to) address for this Business Partner
poreference varchar 20  √  null Transaction Reference Number (Sales Order, Purchase Order) of your Business Partner
isdiscountprinted bpchar 1 'Y'::bpchar Print Discount on Invoice and Order
dateordered timestamp 29,6  √  null Date of Order
c_currency_id numeric 10
c_currency
The Currency for this record
paymentrule bpchar 1 How you pay the invoice
c_paymentterm_id numeric 10
c_paymentterm
The terms of Payment (timing, discount)
c_charge_id numeric 10  √  null
c_charge
Additional document charges
chargeamt numeric 0  √  0 Charge Amount
totallines numeric 0 0 Total of all document lines
grandtotal numeric 0 0 Total amount of document
m_pricelist_id numeric 10
m_pricelist
Unique identifier of a Price List
istaxincluded bpchar 1 'N'::bpchar Tax is included in the price
c_campaign_id numeric 10  √  null
c_campaign
Marketing Campaign
c_project_id numeric 10  √  null
c_project
Financial Project
c_activity_id numeric 10  √  null
c_activity
Business Activity
ispaid bpchar 1 'N'::bpchar The document is paid
c_payment_id numeric 10  √  null
c_payment
Payment identifier
c_cashline_id numeric 10  √  null Cash Journal Line
createfrom bpchar 1  √  null Process which will generate a new document lines based on an existing document
generateto bpchar 1  √  null Generate To
sendemail bpchar 1 'N'::bpchar Enable sending Document EMail
ad_user_id numeric 10  √  null
ad_user
User within the system - Internal or Business Partner Contact
copyfrom bpchar 1  √  null Copy From Record
isselfservice bpchar 1 'N'::bpchar This is a Self-Service entry or this entry can be changed via Self-Service
ad_orgtrx_id numeric 10  √  null
ad_org
Performing or initiating organization
user1_id numeric 10  √  null
c_elementvalue
User defined list element #1
user2_id numeric 10  √  null
c_elementvalue
User defined list element #2
c_conversiontype_id numeric 10  √  null
c_conversiontype
Currency Conversion Rate Type
ispayschedulevalid bpchar 1 'N'::bpchar Is the Payment Schedule is valid
ref_invoice_id numeric 10  √  null
c_invoice
Referenced Invoice
isindispute bpchar 1 'N'::bpchar Document is in dispute
invoicecollectiontype bpchar 1  √  null Invoice Collection Status
m_rma_id numeric 10  √  null Return Material Authorization
dunninggrace timestamp 29,6  √  null Dunning Grace Date
c_dunninglevel_id numeric 10  √  null Dunning Level
reversal_id numeric 10  √  null
c_invoice
ID of document reversal
processedon numeric 0  √  null The date+time (expressed in decimal format) when the document has been processed
c_cashplanline_id numeric 10  √  NULL::numeric Cash Plan Line
c_invoice_uu varchar 36  √  NULL::character varying C_Invoice_UU
isfixedassetinvoice bpchar 1  √  null IsFixedAssetInvoice
relatedinvoice_id numeric 10  √  NULL::numeric
c_invoice
Related Invoice
isoverridecurrencyrate bpchar 1 'N'::bpchar Override Currency Conversion Rate
currencyrate numeric 0  √  null Currency Conversion Rate

Table contained 8 rows at 2021-12-25 14:48 +0100

Indexes:
Column(s) Type Sort
c_invoice_id Primary key Asc
documentno + c_doctype_id + c_bpartner_id Must be unique Asc/Asc/Asc
c_bpartner_id + documentno + c_doctypetarget_id Must be unique Asc/Asc/Asc
c_invoice_id Must be unique Asc
c_order_id Performance Asc
ispaid + ad_client_id Performance Asc/Asc
c_invoice_uu Must be unique Asc
posted + processed + processedon + ad_client_id Performance Asc/Asc/Asc/Asc

Close relationships  within of separation: