Table idempiere9.adempiere.c_invoice
Invoice Identifier

 Generated by
Quality Systems & Solutions
Legend:
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
c_invoice_id numeric 10
a_asset_addition.c_invoice_id cinvoice_aassetaddition R
a_asset_disposed.c_invoice_id cinvoice_aassetdisposed R
c_allocationline.c_invoice_id cinvoice_callocationline R
c_bankstatementline.c_invoice_id cinvoice_cbankstatementline R
c_cashline.c_invoice_id cinvoice_ccashline R
c_dunningrunline.c_invoice_id cinvoice_cdunningrunline N
c_invoice.ref_invoice_id cinvoice_ref R
c_invoice.relatedinvoice_id relatedinvoice_cinvoice R
c_invoice.reversal_id reversal_cinvoice R
c_invoicebatchline.c_invoice_id cinvoice_cinvoicebatchline R
c_invoiceline.c_invoice_id cinvoice_cinvoiceline C
c_invoicepayschedule.c_invoice_id cinvoice_cinvoicepaysched C
c_invoicetax.c_invoice_id cinvoice_cinvoicetax C
c_payment.c_invoice_id cinvoice_cpayment R
c_paymentallocate.c_invoice_id cinvoice_cpaymentallocate R
c_paymenttransaction.c_invoice_id cinvoice_cpaymenttransaction R
c_payselectionline.c_invoice_id cinvoice_cpayselectline R
c_recurring.c_invoice_id cinvoice_crecurring R
c_recurring_run.c_invoice_id cinvoice_crecurringrun R
c_taxdeclarationline.c_invoice_id cinvoice_ctaxdeclline R
dd_order.c_invoice_id cinvoice_ddorder R
i_bankstatement.c_invoice_id cinvoice_ibankstatement N
i_invoice.c_invoice_id cinvoice_iinvoice N
i_payment.c_invoice_id cinvoice_ipayment N
m_inout.c_invoice_id cinvoice_minout R
m_inoutconfirm.c_invoice_id cinvoice_minoutconfirm R
m_shippingtransaction.c_invoice_id cinvoice_mshippingtransaction R
r_request.c_invoice_id rinvoice_rrequest R
r_request.c_invoicerequest_id cinvoicerequest_rrequest R
r_requestaction.c_invoice_id cinvoice_rrequestaction R
t_invoicegl.c_invoice_id cinvoice_tinvoicegl C
Invoice Identifier
ad_client_id numeric 10 Client/Tenant for this installation.
ad_org_id numeric 10
ad_org.ad_org_id adorg_cinvoice R
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.c_doctype_id cdoctype_cinvoice R
Document type or rules
c_doctypetarget_id numeric 10
c_doctype.c_doctype_id cdoctypetarget_cinvoice R
Target document type for conversing documents
c_order_id numeric 10  √  null
c_order.c_order_id corder_cinvoice R
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.ad_user_id aduser_sr_cinvoice R
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.c_bpartner_id cbpartner_cinvoice R
Identifies a Business Partner
c_bpartner_location_id numeric 10
c_bpartner_location.c_bpartner_location_id c_bplocation_cinvoice R
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.c_currency_id ccurrency_cinvoice R
The Currency for this record
paymentrule bpchar 1 How you pay the invoice
c_paymentterm_id numeric 10
c_paymentterm.c_paymentterm_id cpaymentterm_cinvoice R
The terms of Payment (timing, discount)
c_charge_id numeric 10  √  null
c_charge.c_charge_id ccharge_cinvoice R
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.m_pricelist_id mpricelist_cinvoice R
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.c_campaign_id ccampaign_cinvoice R
Marketing Campaign
c_project_id numeric 10  √  null
c_project.c_project_id cproject_cinvoice R
Financial Project
c_activity_id numeric 10  √  null
c_activity.c_activity_id cactivity_cinvoice R
Business Activity
ispaid bpchar 1 'N'::bpchar The document is paid
c_payment_id numeric 10  √  null
c_payment.c_payment_id cpayment_cinvoice R
Payment identifier
c_cashline_id numeric 10  √  null
c_cashline.c_cashline_id ccashline_cinvoice R
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.ad_user_id aduser_cinvoice R
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.ad_org_id adorgtrx_cinvoice R
Performing or initiating organization
user1_id numeric 10  √  null
c_elementvalue.c_elementvalue_id celementvalueuser1_cinvoice R
User defined list element #1
user2_id numeric 10  √  null
c_elementvalue.c_elementvalue_id celementvalueuser2_cinvoice R
User defined list element #2
c_conversiontype_id numeric 10  √  null
c_conversiontype.c_conversiontype_id cconversiontype_cinvoice R
Currency Conversion Rate Type
ispayschedulevalid bpchar 1 'N'::bpchar Is the Payment Schedule is valid
ref_invoice_id numeric 10  √  null
c_invoice.c_invoice_id cinvoice_ref R
Referenced Invoice
isindispute bpchar 1 'N'::bpchar Document is in dispute
invoicecollectiontype bpchar 1  √  null Invoice Collection Status
m_rma_id numeric 10  √  null
m_rma.m_rma_id mrma_cinvoice R
Return Material Authorization
dunninggrace timestamp 29,6  √  null Dunning Grace Date
c_dunninglevel_id numeric 10  √  null
c_dunninglevel.c_dunninglevel_id cdunninglevel_cinvoice R
Dunning Level
reversal_id numeric 10  √  null
c_invoice.c_invoice_id reversal_cinvoice R
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
c_cashplanline.c_cashplanline_id ccashplanline_cinvoice R
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.c_invoice_id relatedinvoice_cinvoice R
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:43 +0100

Indexes:
Column(s) Type Sort Constraint Name
c_invoice_id Primary key Asc c_invoice_pkey
documentno + c_doctype_id + c_bpartner_id Must be unique Asc/Asc/Asc c_invoice_documentno
c_bpartner_id + documentno + c_doctypetarget_id Must be unique Asc/Asc/Asc c_invoice_documentno_target
c_invoice_id Must be unique Asc c_invoice_key
c_order_id Performance Asc c_invoice_order
ispaid + ad_client_id Performance Asc/Asc c_invoice_paid
c_invoice_uu Must be unique Asc c_invoice_uu_idx
posted + processed + processedon + ad_client_id Performance Asc/Asc/Asc/Asc idxc_invoice_proc_on


SchemaSpy was unable to generate a diagram of table relationships.
SchemaSpy requires Graphviz version 2.2.1 or versions greater than 2.4 from www.graphviz.org.