Table idempiere9.adempiere.i_invoice
Import Invoice

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
i_invoice_id numeric 10 Import Invoice
ad_client_id numeric 10  √  null Client/Tenant for this installation.
ad_org_id numeric 10  √  null
ad_org.ad_org_id adorg_iinvoice N
Organizational entity within client
ad_orgtrx_id numeric 10  √  null
ad_org.ad_org_id adorgtrx_iinvoice N
Performing or initiating organization
isactive bpchar 1  √  'Y'::bpchar The record is active in the system
created timestamp 29,6 statement_timestamp() Date this record was created
createdby numeric 10  √  null User who created this records
updated timestamp 29,6 statement_timestamp() Date this record was updated
updatedby numeric 10  √  null User who updated this records
i_isimported bpchar 1 'N'::bpchar Has this import been processed
i_errormsg varchar 2000  √  null Messages generated from import process
processing bpchar 1  √  null Process Now
processed bpchar 1  √  'N'::bpchar The document has been processed
m_pricelist_id numeric 10  √  null
m_pricelist.m_pricelist_id mpricelist_iinvoice N
Unique identifier of a Price List
c_currency_id numeric 10  √  null
c_currency.c_currency_id ccurrency_iinvoice N
The Currency for this record
salesrep_id numeric 10  √  null
ad_user.ad_user_id adusersalesrep_iinvoice N
Sales Representative or Company Agent
issotrx bpchar 1  √  'Y'::bpchar This is a Sales Transaction
c_bpartner_id numeric 10  √  null
c_bpartner.c_bpartner_id cbpartner_iinvoice N
Identifies a Business Partner
c_bpartner_location_id numeric 10  √  null
c_bpartner_location.c_bpartner_location_id cbplocation_iinvoice N
Identifies the (ship to) address for this Business Partner
bpartnervalue varchar 40  √  null Key of the Business Partner
name varchar 60  √  null Alphanumeric identifier of the entity
c_location_id numeric 10  √  null
c_location.c_location_id clocation_iinvoice N
Location or Address
address1 varchar 60  √  null Address line 1 for this location
address2 varchar 60  √  null Address line 2 for this location
postal varchar 10  √  null Postal code
city varchar 60  √  null Identifies a City
c_region_id numeric 10  √  null
c_region.c_region_id cregion_iinvoice N
Identifies a geographical Region
regionname varchar 60  √  null Name of the Region
ad_user_id numeric 10  √  null
ad_user.ad_user_id aduser_iinvoice N
User within the system - Internal or Business Partner Contact
email varchar 60  √  null Electronic Mail Address
contactname varchar 60  √  null Business Partner Contact Name
phone varchar 40  √  null Identifies a telephone number
c_country_id numeric 10  √  null
c_country.c_country_id ccountry_iinvoice N
Country
countrycode bpchar 2  √  null Upper-case two-letter alphanumeric ISO Country code according to ISO 3166-1 - http://www.chemie.fu-berlin.de/diverse/doc/ISO_3166.html
c_doctype_id numeric 10  √  null
c_doctype.c_doctype_id cdoctype_iinvoice N
Document type or rules
doctypename varchar 60  √  null Name of the Document Type
c_paymentterm_id numeric 10  √  null
c_paymentterm.c_paymentterm_id cpaymentterm_iinvoice N
The terms of Payment (timing, discount)
paymenttermvalue varchar 40  √  null Key of the Payment Term
c_project_id numeric 10  √  null
c_project.c_project_id cproject_iinvoice N
Financial Project
c_campaign_id numeric 10  √  null
c_campaign.c_campaign_id ccampaign_iinvoice N
Marketing Campaign
c_activity_id numeric 10  √  null
c_activity.c_activity_id cactivity_iinvoice N
Business Activity
c_invoice_id numeric 10  √  null
c_invoice.c_invoice_id cinvoice_iinvoice N
Invoice Identifier
documentno varchar 30  √  null Document sequence number of the document
dateinvoiced timestamp 29,6  √  null Date printed on Invoice
dateacct timestamp 29,6  √  null Accounting Date
description varchar 255  √  null Optional short description of the record
m_product_id numeric 10  √  null
m_product.m_product_id nproduct_iinvoice N
Product, Service, Item
productvalue varchar 40  √  null Key of the Product
upc varchar 30  √  null Bar Code (Universal Product Code or its superset European Article Number)
sku varchar 30  √  null Stock Keeping Unit
c_tax_id numeric 10  √  null
c_tax.c_tax_id ctax_iinvoice N
Tax identifier
taxindicator varchar 10  √  null Short form for Tax to be printed on documents
taxamt numeric 0  √  0 Tax Amount for a document
c_invoiceline_id numeric 10  √  null
c_invoiceline.c_invoiceline_id cinvliceline_iinvoice N
Invoice Detail Line
linedescription varchar 255  √  null Description of the Line
qtyordered numeric 0  √  0 Ordered Quantity
priceactual numeric 0  √  0 Actual Price
projectvalue varchar 40  √  null Key of the Project
activityvalue varchar 40  √  null Text key for Activity
chargename varchar 60  √  null Name of the Charge
c_charge_id numeric 10  √  null
c_charge.c_charge_id ccharge_iinvoice R
Additional document charges
i_invoice_uu varchar 36  √  NULL::character varying I_Invoice_UU
c_1099box_id numeric 10  √  NULL::numeric
c_1099box.c_1099box_id c1099box_iinvoice R
1099 Box
c_1099box_value varchar 40  √  NULL::character varying 1099 Box Value

Table contained 0 rows at 2021-12-25 14:43 +0100

Indexes:
Column(s) Type Sort Constraint Name
i_invoice_id Primary key Asc i_invoice_pkey
i_invoice_uu Must be unique Asc i_invoice_uu_idx


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.