View idempiere9.adempiere.rv_c_invoice
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
c_invoice_id numeric 10  √  null Invoice Identifier
ad_client_id numeric 10  √  null Client/Tenant for this installation.
ad_org_id numeric 10  √  null Organizational entity within client
isactive bpchar 1  √  null The record is active in the system
created timestamp 29,6  √  null Date this record was created
createdby numeric 10  √  null User who created this records
updated timestamp 29,6  √  null Date this record was updated
updatedby numeric 10  √  null User who updated this records
issotrx bpchar 1  √  null This is a Sales Transaction
documentno varchar 30  √  null Document sequence number of the document
docstatus bpchar 2  √  null The current status of the document
docaction bpchar 2  √  null The targeted status of the document
isprinted bpchar 1  √  null Indicates if this document / line is printed
isdiscountprinted bpchar 1  √  null Print Discount on Invoice and Order
processing bpchar 1  √  null Process Now
processed bpchar 1  √  null The document has been processed
istransferred bpchar 1  √  null Transferred to General Ledger (i.e. accounted)
ispaid bpchar 1  √  null The document is paid
c_doctype_id numeric 10  √  null Document type or rules
c_doctypetarget_id numeric 10  √  null Target document type for conversing documents
c_order_id numeric 10  √  null Order
description varchar 255  √  null Optional short description of the record
isapproved bpchar 1  √  null Indicates if this document requires approval
salesrep_id numeric 10  √  null Sales Representative or Company Agent
dateinvoiced timestamp 29,6  √  null Date printed on Invoice
dateprinted timestamp 29,6  √  null Date the document was printed.
dateacct timestamp 29,6  √  null Accounting Date
c_bpartner_id numeric 10  √  null Identifies a Business Partner
c_bpartner_location_id numeric 10  √  null Identifies the (ship to) address for this Business Partner
ad_user_id numeric 10  √  null User within the system - Internal or Business Partner Contact
c_bp_group_id numeric 10  √  null Business Partner Group
poreference varchar 20  √  null Transaction Reference Number (Sales Order, Purchase Order) of your Business Partner
dateordered timestamp 29,6  √  null Date of Order
c_currency_id numeric 10  √  null The Currency for this record
c_conversiontype_id numeric 10  √  null Currency Conversion Rate Type
paymentrule bpchar 1  √  null How you pay the invoice
c_paymentterm_id numeric 10  √  null The terms of Payment (timing, discount)
m_pricelist_id numeric 10  √  null Unique identifier of a Price List
c_campaign_id numeric 10  √  null Marketing Campaign
c_project_id numeric 10  √  null Financial Project
c_activity_id numeric 10  √  null Business Activity
ispayschedulevalid bpchar 1  √  null Is the Payment Schedule is valid
invoicecollectiontype bpchar 1  √  null Invoice Collection Status
c_country_id numeric 10  √  null Country
c_region_id numeric 10  √  null Identifies a geographical Region
postal varchar 10  √  null Postal code
city varchar 60  √  null Identifies a City
c_charge_id numeric 10  √  null Additional document charges
chargeamt numeric 0  √  null Charge Amount
totallines numeric 0  √  null Total of all document lines
grandtotal numeric 0  √  null Total amount of document
multiplier int4 10  √  null Type Multiplier (Credit = -1)
c_invoice_ad_orgtrx_id numeric 10  √  null c_invoice_ad_orgtrx_id
c_invoice_c_conversiontype_id numeric 10  √  null c_invoice_c_conversiontype_id
c_dunninglevel_id numeric 10  √  null Dunning Level
c_payment_id numeric 10  √  null Payment identifier
c_invoice_dateordered timestamp 29,6  √  null c_invoice_dateordered
dunninggrace timestamp 29,6  √  null Dunning Grace Date
generateto bpchar 1  √  null Generate To
isindispute bpchar 1  √  null Document is in dispute
c_invoice_ispayschedulevalid bpchar 1  √  null c_invoice_ispayschedulevalid
c_invoice_isselfservice bpchar 1  √  null c_invoice_isselfservice
istaxincluded bpchar 1  √  null Tax is included in the price
m_rma_id numeric 10  √  null Return Material Authorization
posted bpchar 1  √  null Posting status
processedon numeric 0  √  null The date+time (expressed in decimal format) when the document has been processed
ref_invoice_id numeric 10  √  null Referenced Invoice
reversal_id numeric 10  √  null ID of document reversal
sendemail bpchar 1  √  null Enable sending Document EMail
user1_id numeric 10  √  null User defined list element #1
user2_id numeric 10  √  null User defined list element #2
c_bp_acqusitioncost numeric 0  √  null c_bp_acqusitioncost
c_bp_actuallifetimevalue numeric 0  √  null c_bp_actuallifetimevalue
c_bp_ad_language varchar 6  √  null c_bp_ad_language
c_bp_ad_orgbp_id numeric 10  √  null c_bp_ad_orgbp_id
c_bp_ad_org_id numeric 10  √  null c_bp_ad_org_id
c_bp_bpartner_parent_id numeric 10  √  null c_bp_bpartner_parent_id
c_bp_c_dunning_id numeric 10  √  null c_bp_c_dunning_id
c_bp_c_greeting_id numeric 10  √  null c_bp_c_greeting_id
c_bp_c_invoiceschedule_id numeric 10  √  null c_bp_c_invoiceschedule_id
c_bp_c_paymentterm_id numeric 10  √  null c_bp_c_paymentterm_id
c_bp_created timestamp 29,6  √  null c_bp_created
c_bp_createdby numeric 10  √  null c_bp_createdby
c_bp_c_taxgroup_id numeric 10  √  null c_bp_c_taxgroup_id
c_bp_deliveryrule bpchar 1  √  null c_bp_deliveryrule
c_bp_deliveryviarule bpchar 1  √  null c_bp_deliveryviarule
c_bp_description varchar 255  √  null c_bp_description
c_bp_dunninggrace timestamp 29,6  √  null c_bp_dunninggrace
c_bp_duns varchar 11  √  null c_bp_duns
c_bp_firstsale timestamp 29,6  √  null c_bp_firstsale
c_bp_flatdiscount numeric 0  √  null c_bp_flatdiscount
c_bp_freightcostrule bpchar 1  √  null c_bp_freightcostrule
c_bp_invoicerule bpchar 1  √  null c_bp_invoicerule
c_bp_isactive bpchar 1  √  null c_bp_isactive
c_bp_iscustomer bpchar 1  √  null c_bp_iscustomer
c_bp_isdiscountprinted bpchar 1  √  null c_bp_isdiscountprinted
c_bp_isemployee bpchar 1  √  null c_bp_isemployee
c_bp_ismanufacturer bpchar 1  √  null c_bp_ismanufacturer
c_bp_isonetime bpchar 1  √  null c_bp_isonetime
c_bp_ispotaxexempt bpchar 1  √  null c_bp_ispotaxexempt
c_bp_isprospect bpchar 1  √  null c_bp_isprospect
c_bp_issalesrep bpchar 1  √  null c_bp_issalesrep
c_bp_issummary bpchar 1  √  null c_bp_issummary
c_bp_istaxexempt bpchar 1  √  null c_bp_istaxexempt
c_bp_isvendor bpchar 1  √  null c_bp_isvendor
c_bp_logo_id numeric 10  √  null c_bp_logo_id
c_bp_m_discountschema_id numeric 10  √  null c_bp_m_discountschema_id
c_bp_m_pricelist_id numeric 10  √  null c_bp_m_pricelist_id
c_bp_naics varchar 6  √  null c_bp_naics
c_bp_name varchar 120  √  null c_bp_name
c_bp_name2 varchar 60  √  null c_bp_name2
c_bp_numberemployees numeric 10  √  null c_bp_numberemployees
c_bp_paymentrule bpchar 1  √  null c_bp_paymentrule
c_bp_paymentrulepo bpchar 1  √  null c_bp_paymentrulepo
c_bp_po_discountschema_id numeric 10  √  null c_bp_po_discountschema_id
c_bp_po_paymentterm_id numeric 10  √  null c_bp_po_paymentterm_id
c_bp_po_pricelist_id numeric 10  √  null c_bp_po_pricelist_id
c_bp_poreference varchar 20  √  null c_bp_poreference
c_bp_potentiallifetimevalue numeric 0  √  null c_bp_potentiallifetimevalue
c_bp_rating bpchar 1  √  null c_bp_rating
c_bp_referenceno varchar 40  √  null c_bp_referenceno
c_bp_salesrep_id numeric 10  √  null c_bp_salesrep_id
c_bp_salesvolume numeric 10  √  null c_bp_salesvolume
c_bp_sendemail bpchar 1  √  null c_bp_sendemail
c_bp_shareofcustomer numeric 10  √  null c_bp_shareofcustomer
c_bp_shelflifeminpct numeric 10  √  null c_bp_shelflifeminpct
c_bp_so_creditlimit numeric 0  √  null c_bp_so_creditlimit
c_bp_socreditstatus bpchar 1  √  null c_bp_socreditstatus
c_bp_so_creditused numeric 0  √  null c_bp_so_creditused
c_bp_so_description varchar 255  √  null c_bp_so_description
taxid varchar 20  √  null Tax Identification
c_bp_totalopenbalance numeric 0  √  null c_bp_totalopenbalance
c_bp_updated timestamp 29,6  √  null c_bp_updated
c_bp_updatedby numeric 10  √  null c_bp_updatedby
c_bp_url varchar 120  √  null c_bp_url
c_bp_value varchar 40  √  null c_bp_value
c_bp_location_ad_org_id numeric 10  √  null c_bp_location_ad_org_id
c_bp_location_c_bpartner_id numeric 10  √  null c_bpartner_location_c_bpartner_id
c_bp_location_c_location_id numeric 10  √  null c_bp_location_c_location_id
c_bp_location_created timestamp 29,6  √  null c_bp_location_created
c_bp_location_createdby numeric 10  √  null c_bp_location_createdby
c_salesregion_id numeric 10  √  null Sales coverage region
c_bp_location_fax varchar 40  √  null c_bp_location_fax
c_bp_location_isactive bpchar 1  √  null c_bp_location_isactive
isbillto bpchar 1  √  null Business Partner Invoice/Bill Address
isdn varchar 40  √  null ISDN or modem line
ispayfrom bpchar 1  √  null Business Partner pays from that address and we'll send dunning letters there
isremitto bpchar 1  √  null Business Partner payment address
isshipto bpchar 1  √  null Business Partner Shipment Address
c_bp_location_name varchar 60  √  null c_bp_location_name
c_bp_location_phone varchar 40  √  null c_bp_location_phone
c_bp_location_phone2 varchar 40  √  null c_bp_location_phone2
c_bp_location_updated timestamp 29,6  √  null c_bp_location_updated
c_bp_location_updatedby numeric 10  √  null c_bp_location_updatedby
address1 varchar 60  √  null Address line 1 for this location
address2 varchar 60  √  null Address line 2 for this location
address3 varchar 60  √  null Address Line 3 for the location
address4 varchar 60  √  null Address Line 4 for the location
c_location_ad_org_id numeric 10  √  null c_location_ad_org_id
c_city_id numeric 10  √  null City
c_location_created timestamp 29,6  √  null c_location_created
c_location_createdby numeric 10  √  null c_location_createdby
c_location_isactive bpchar 1  √  null c_location_isactive
postal_add varchar 10  √  null Additional ZIP or Postal code
regionname varchar 40  √  null Name of the Region
c_location_updated timestamp 29,6  √  null c_location_updated
c_location_updatedby numeric 10  √  null c_location_updatedby

Analyzed at 2021-12-25 14:43 +0100