View idempiere9.adempiere.c_invoice_header_v
Invoice Print View

 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
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
ad_language varchar 6  √  null Language for this entity
c_invoice_id numeric 10  √  null Invoice Identifier
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
c_doctype_id numeric 10  √  null Document type or rules
c_bpartner_id numeric 10  √  null Identifies a Business Partner
bpvalue varchar 40  √  null Business Partner Key Value
bptaxid varchar 20  √  null Tax ID of the Business Partner
naics varchar 6  √  null Standard Industry Code or its successor NAIC - http://www.osha.gov/oshstats/sicser.html
duns varchar 11  √  null Dun & Bradstreet Number
org_location_id numeric 10  √  null Organization Location/Address
taxid varchar 20  √  null Tax Identification
documenttype varchar 60  √  null Document Type
documenttypenote varchar 2000  √  null Optional note of a document type
c_order_id numeric 10  √  null Order
salesrep_id numeric 10  √  null Sales Representative or Company Agent
salesrep_name varchar 2147483647  √  null Sales Representative
dateinvoiced timestamp 29,6  √  null Date printed on Invoice
bpgreeting varchar 60  √  null Greeting for Business Partner
name varchar 120  √  null Alphanumeric identifier of the entity
name2 varchar 60  √  null Additional Name
bpcontactgreeting varchar 60  √  null Greeting for Business Partner Contact
title varchar 40  √  null Name this entity is referred to as
phone varchar 40  √  null Identifies a telephone number
contactname text 2147483647  √  null Business Partner Contact Name
c_location_id numeric 10  √  null Location or Address
referenceno varchar 40  √  null Your customer or vendor number at the Business Partner's site
postal text 2147483647  √  null Postal code
description varchar 255  √  null Optional short description of the record
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
paymentterm varchar 60  √  null Payment Term
paymenttermnote varchar 2000  √  null Note of a Payment Term
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
amtinwords numeric 0  √  null Amount in words
m_pricelist_id numeric 10  √  null Unique identifier of a Price List
istaxincluded bpchar 1  √  null Tax is included in the price
c_campaign_id numeric 10  √  null Marketing Campaign
c_project_id numeric 10  √  null Financial Project
c_activity_id numeric 10  √  null Business Activity
ispaid bpchar 1  √  null The document is paid
logo_id numeric 10  √  null Logo
c_invoice_ad_orgtrx_id numeric 10  √  null c_invoice_ad_orgtrx_id
ad_user_id numeric 10  √  null User within the system - Internal or Business Partner Contact
c_bpartner_location_id numeric 10  √  null Identifies the (ship to) address for this Business Partner
c_conversiontype_id numeric 10  √  null Currency Conversion Rate Type
c_doctypetarget_id numeric 10  √  null Target document type for conversing documents
c_dunninglevel_id numeric 10  √  null Dunning Level
c_payment_id numeric 10  √  null Payment identifier
dateacct timestamp 29,6  √  null Accounting Date
dateprinted timestamp 29,6  √  null Date the document was printed.
docaction bpchar 2  √  null The targeted status of the document
dunninggrace timestamp 29,6  √  null Dunning Grace Date
generateto bpchar 1  √  null Generate To
invoicecollectiontype bpchar 1  √  null Invoice Collection Status
isapproved bpchar 1  √  null Indicates if this document requires approval
isdiscountprinted bpchar 1  √  null Print Discount on Invoice and Order
isindispute bpchar 1  √  null Document is in dispute
ispayschedulevalid bpchar 1  √  null Is the Payment Schedule is valid
isprinted bpchar 1  √  null Indicates if this document / line is printed
c_invoice_isselfservice bpchar 1  √  null c_invoice_isselfservice
istransferred bpchar 1  √  null Transferred to General Ledger (i.e. accounted)
m_rma_id numeric 10  √  null Return Material Authorization
paymentrule bpchar 1  √  null How you pay the invoice
posted bpchar 1  √  null Posting status
processedon numeric 0  √  null The date+time (expressed in decimal format) when the document has been processed
processing bpchar 1  √  null Process Now
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_paymentterm_ad_org_id numeric 10  √  null C_PaymentTerm_AD_Org_ID
afterdelivery bpchar 1  √  null Due after delivery rather than after invoicing
c_paymentterm_id numeric 10  √  null The terms of Payment (timing, discount)
c_paymentterm_description varchar 255  √  null c_paymentterm_description
discount numeric 0  √  null Discount in percent
discount2 numeric 0  √  null Discount in percent
discountdays numeric 10  √  null Number of days from invoice date to be eligible for discount
discountdays2 numeric 10  √  null Number of days from invoice date to be eligible for discount
fixmonthcutoff numeric 10  √  null Last day to include for next due date
fixmonthday numeric 10  √  null Day of the month of the due date
fixmonthoffset numeric 10  √  null Number of months (0=same, 1=following)
gracedays numeric 10  √  null Days after due date to send first dunning letter
c_paymentterm_isactive bpchar 1  √  null c_paymentterm_isactive
isdefault bpchar 1  √  null Default value
isduefixed bpchar 1  √  null Payment is due on a fixed date
isnextbusinessday bpchar 1  √  null Payment due on the next business day
isvalid bpchar 1  √  null Element is valid
netday bpchar 1  √  null Day when payment is due net
netdays numeric 10  √  null Net Days in which payment is due
paymenttermusage bpchar 1  √  null Payment term usage indicates if this payment term is used for sales, purchases or both.
c_paymentterm_value varchar 40  √  null c_paymentterm_value
bp_acqusitioncost numeric 0  √  null bp_acqusitioncost
bp_actuallifetimevalue numeric 0  √  null bp_actuallifetimevalue
bp_ad_language varchar 6  √  null bp_ad_language
bp_ad_orgbp_id numeric 10  √  null bp_ad_orgbp_id
bp_ad_org_id numeric 10  √  null bp_ad_org_id
bp_bpartner_parent_id numeric 10  √  null bp_bpartner_parent_id
bp_c_bp_group_id numeric 10  √  null bp_c_bp_group_id
bp_c_dunning_id numeric 10  √  null bp_c_dunning_id
bp_c_greeting_id numeric 10  √  null bp_c_greeting_id
bp_c_invoiceschedule_id numeric 10  √  null C_BPartner_InvoiceSchedule_ID
bp_c_paymentterm_id numeric 10  √  null bp_c_paymentterm_id
bp_created timestamp 29,6  √  null bp_created
bp_createdby numeric 10  √  null bp_createdby
bp_c_taxgroup_id numeric 10  √  null bp_c_taxgroup_id
bp_deliveryrule bpchar 1  √  null bp_deliveryrule
bp_deliveryviarule bpchar 1  √  null bp_deliveryviarule
bp_description varchar 255  √  null bp_description
bp_dunninggrace timestamp 29,6  √  null bp_dunninggrace
bp_firstsale timestamp 29,6  √  null bp_firstsale
bp_flatdiscount numeric 0  √  null bp_flatdiscount
bp_freightcostrule bpchar 1  √  null bp_freightcostrule
bp_invoicerule bpchar 1  √  null bp_invoicerule
bp_isactive bpchar 1  √  null bp_isactive
bp_iscustomer bpchar 1  √  null bp_iscustomer
bp_isdiscountprinted bpchar 1  √  null bp_isdiscountprinted
bp_isemployee bpchar 1  √  null bp_isemployee
bp_ismanufacturer bpchar 1  √  null bp_ismanufacturer
bp_isonetime bpchar 1  √  null bp_isonetime
bp_ispotaxexempt bpchar 1  √  null bp_ispotaxexempt
bp_isprospect bpchar 1  √  null bp_isprospect
bp_issalesrep bpchar 1  √  null bp_issalesrep
bp_issummary bpchar 1  √  null bp_issummary
bp_istaxexempt bpchar 1  √  null bp_istaxexempt
bp_isvendor bpchar 1  √  null bp_isvendor
bp_logo_id numeric 10  √  null bp_logo_id
bp_m_discountschema_id numeric 10  √  null bp_m_discountschema_id
bp_m_pricelist_id numeric 10  √  null bp_m_pricelist_id
bp_naics varchar 6  √  null bp_naics
bp_numberemployees numeric 10  √  null bp_numberemployees
bp_paymentrule bpchar 1  √  null bp_paymentrule
bp_paymentrulepo bpchar 1  √  null bp_paymentrulepo
bp_po_discountschema_id numeric 10  √  null bp_po_discountschema_id
bp_po_paymentterm_id numeric 10  √  null bp_po_paymentterm_id
bp_po_pricelist_id numeric 10  √  null bp_po_pricelist_id
bp_poreference varchar 20  √  null bp_poreference
bp_potentiallifetimevalue numeric 0  √  null bp_potentiallifetimevalue
bp_rating bpchar 1  √  null bp_rating
bp_salesrep_id numeric 10  √  null bp_salesrep_id
bp_salesvolume numeric 10  √  null bp_salesvolume
bp_sendemail bpchar 1  √  null bp_sendemail
bp_shareofcustomer numeric 10  √  null bp_shareofcustomer
bp_shelflifeminpct numeric 10  √  null bp_shelflifeminpct
bp_so_creditlimit numeric 0  √  null bp_so_creditlimit
bp_socreditstatus bpchar 1  √  null bp_socreditstatus
bp_so_creditused numeric 0  √  null bp_so_creditused
bp_so_description varchar 255  √  null bp_so_description
bp_totalopenbalance numeric 0  √  null bp_totalopenbalance
bp_updated timestamp 29,6  √  null bp_updated
bp_updatedby numeric 10  √  null bp_updatedby
bp_url varchar 120  √  null bp_url
c_greeting_isactive bpchar 1  √  null c_greeting_isactive
isfirstnameonly bpchar 1  √  null Print only the first name in greetings
c_greeting_name varchar 60  √  null c_greeting_name
bp_location_ad_org_id numeric 10  √  null bp_location_ad_org_id
bp_location_c_bpartner_id numeric 10  √  null bp_location_c_bpartner_id
bp_location_created timestamp 29,6  √  null bp_location_created
bp_location_createdby numeric 10  √  null bp_location_createdby
c_salesregion_id numeric 10  √  null Sales coverage region
bp_location_fax varchar 40  √  null bp_location_fax
bp_location_isactive bpchar 1  √  null 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
bp_location_name varchar 60  √  null bp_location_name
bp_location_phone varchar 40  √  null bp_location_phone
bp_location_phone2 varchar 40  √  null bp_location_phone2
bp_location_updated timestamp 29,6  √  null bp_location_updated
bp_location_updatedby numeric 10  √  null 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_country_id numeric 10  √  null Country
city varchar 60  √  null Identifies a City
c_location_created timestamp 29,6  √  null c_location_created
c_location_createdby numeric 10  √  null c_location_createdby
c_region_id numeric 10  √  null Identifies a geographical Region
c_location_isactive bpchar 1  √  null c_location_isactive
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
ad_user_ad_org_id numeric 10  √  null AD_User_AD_Org_ID
ad_user_ad_ad_orgtrx_id numeric 10  √  null ad_user_ad_ad_orgtrx_id
ad_user_ad_birthday timestamp 29,6  √  null ad_user_ad_birthday
ad_user_c_bpartner_id numeric 10  √  null AD_User_C_BPartner_ID
ad_user_c_bpartner_location_id numeric 10  √  null AD_User_C_BPartner_Location_ID
ad_user_c_greeting_id numeric 10  √  null AD_User_C_Greeting_ID
ad_user_comments varchar 2000  √  null ad_user_comments
ad_user_created timestamp 29,6  √  null ad_user_created
ad_user_createdby numeric 10  √  null ad_user_createdby
ad_user_description varchar 255  √  null ad_user_description
ad_user_email varchar 60  √  null ad_user_email
ad_user_fax varchar 40  √  null ad_user_fax
ad_user_isactive bpchar 1  √  null ad_user_isactive
ad_user_lastcontact timestamp 29,6  √  null ad_user_lastcontact
ad_user_lastresult varchar 255  √  null ad_user_lastresult
ad_user_phone2 varchar 40  √  null ad_user_phone2
ad_user_supervisor_id numeric 10  √  null AD_User_Supervisor_ID
ad_user_updated timestamp 29,6  √  null ad_user_updated
ad_user_updatedby numeric 10  √  null ad_user_updatedby
ad_user_value varchar 40  √  null ad_user_value
user_greeting_isactive bpchar 1  √  null user_greeting_isactive
user_greeting_isfirstnameonly bpchar 1  √  null user_greeting_isfirstnameonly
user_greeting_name varchar 60  √  null user_greeting_name
ad_orginfo_ad_org_id numeric 10  √  null ad_orginfo_ad_org_id
ad_orgtype_id numeric 10  √  null Organization Type
c_calendar_id numeric 10  √  null Accounting Calendar Name
ad_orginfo_created timestamp 29,6  √  null ad_orginfo_created
ad_orginfo_createdby numeric 10  √  null ad_orginfo_createdby
dropship_warehouse_id numeric 10  √  null The (logical) warehouse to use for recording drop ship receipts and shipments.
ad_orginfo_duns varchar 11  √  null ad_orginfo_duns
ad_orginfo_email varchar 60  √  null ad_orginfo_email
ad_orginfo_fax varchar 40  √  null ad_orginfo_fax
ad_orginfo_isactive bpchar 1  √  null ad_orginfo_isactive
m_warehouse_id numeric 10  √  null Storage Warehouse and Service Point
parent_org_id numeric 10  √  null Parent (superior) Organization
ad_orginfo_phone varchar 40  √  null ad_orginfo_phone
ad_orginfo_phone2 varchar 40  √  null ad_orginfo_phone2
receiptfootermsg varchar 1023  √  null This message will be displayed at the bottom of a receipt when doing a sales or purchase
supervisor_id numeric 10  √  null Supervisor for this user/organization - used for escalation and approval
ad_orginfo_updated timestamp 29,6  √  null ad_orginfo_updated
ad_orginfo_updatedby numeric 10  √  null ad_orginfo_updatedby
salesrep_ad_org_id numeric 10  √  null SalesRep_AD_Org_ID
salesrep_ad_ad_orgtrx_id numeric 10  √  null salesrep_ad_ad_orgtrx_id
salesrep_ad_birthday timestamp 29,6  √  null salesrep_ad_birthday
salesrep_c_bpartner_id numeric 10  √  null salesrep_c_bpartner_id
salesrep_c_bp_location_id numeric 10  √  null Sales Representative Location
salesrep_c_greeting_id numeric 10  √  null salesrep_c_greeting_id
salesrep_comments varchar 2000  √  null salesrep_comments
salesrep_created timestamp 29,6  √  null salesrep_created
salesrep_createdby numeric 10  √  null salesrep_createdby
salesrep_description varchar 255  √  null salesrep_description
salesrep_email varchar 60  √  null salesrep_email
salesrep_fax varchar 40  √  null salesrep_fax
salesrep_isactive bpchar 1  √  null salesrep_isactive
salesrep_lastcontact timestamp 29,6  √  null salesrep_lastcontact
salesrep_lastresult varchar 255  √  null salesrep_lastresult
salesrep_phone varchar 40  √  null salesrep_phone
salesrep_phone2 varchar 40  √  null salesrep_phone2
salesrep_supervisor_id numeric 10  √  null salesrep_supervisor_id
salesrep_title varchar 40  √  null salesrep_title
salesrep_updated timestamp 29,6  √  null salesrep_updated
salesrep_updatedby numeric 10  √  null salesrep_updatedby
salesrep_value varchar 40  √  null salesrep_value
bpartner_acqusitioncost numeric 0  √  null bpartner_acqusitioncost
bpartner_actuallifetimevalue numeric 0  √  null bpartner_actuallifetimevalue
bpartner_ad_language varchar 6  √  null bpartner_ad_language
bpartner_ad_orgbp_id numeric 10  √  null bpartner_ad_orgbp_id
bpartner_ad_org_id numeric 10  √  null bpartner_ad_org_id
bpartner_bpartner_parent_id numeric 10  √  null bpartner_bpartner_parent_id
bpartner_c_bp_group_id numeric 10  √  null bpartner_c_bp_group_id
bpartner_c_dunning_id numeric 10  √  null bpartner_c_dunning_id
bpartner_c_greeting_id numeric 10  √  null bpartner_c_greeting_id
bpartner_c_invoiceschedule_id numeric 10  √  null bpartner_c_invoiceschedule_id
bpartner_c_paymentterm_id numeric 10  √  null bpartner_c_paymentterm_id
bpartner_created timestamp 29,6  √  null bpartner_created
bpartner_createdby numeric 10  √  null bpartner_createdby
bpartner_c_taxgroup_id numeric 10  √  null bpartner_c_taxgroup_id
bpartner_deliveryrule bpchar 1  √  null bpartner_deliveryrule
bpartner_deliveryviarule bpchar 1  √  null bpartner_deliveryviarule
bpartner_description varchar 255  √  null bpartner_description
bpartner_dunninggrace timestamp 29,6  √  null bpartner_dunninggrace
bpartner_duns varchar 11  √  null bpartner_duns
bpartner_firstsale timestamp 29,6  √  null bpartner_firstsale
bpartner_flatdiscount numeric 0  √  null bpartner_flatdiscount
bpartner_freightcostrule bpchar 1  √  null bpartner_freightcostrule
bpartner_invoicerule bpchar 1  √  null bpartner_invoicerule
bpartner_isactive bpchar 1  √  null bpartner_isactive
bpartner_iscustomer bpchar 1  √  null bpartner_iscustomer
bpartner_isdiscountprinted bpchar 1  √  null bpartner_isdiscountprinted
bpartner_isemployee bpchar 1  √  null bpartner_isemployee
bpartner_ismanufacturer bpchar 1  √  null bpartner_ismanufacturer
bpartner_isonetime bpchar 1  √  null bpartner_isonetime
bpartner_ispotaxexempt bpchar 1  √  null bpartner_ispotaxexempt
bpartner_isprospect bpchar 1  √  null bpartner_isprospect
bpartner_issalesrep bpchar 1  √  null bpartner_issalesrep
bpartner_issummary bpchar 1  √  null bpartner_issummary
bpartner_istaxexempt bpchar 1  √  null bpartner_istaxexempt
bpartner_isvendor bpchar 1  √  null bpartner_isvendor
bpartner_logo_id numeric 10  √  null bpartner_logo_id
bpartner_m_discountschema_id numeric 10  √  null bpartner_m_discountschema_id
bpartner_m_pricelist_id numeric 10  √  null bpartner_m_pricelist_id
bpartner_naics varchar 6  √  null bpartner_naics
bpartner_name2 varchar 60  √  null bpartner_name2
bpartner_numberemployees numeric 10  √  null bpartner_numberemployees
bpartner_paymentrule bpchar 1  √  null bpartner_paymentrule
bpartner_paymentrulepo bpchar 1  √  null bpartner_paymentrulepo
bpartner_po_discountschema_id numeric 10  √  null bpartner_po_discountschema_id
bpartner_po_paymentterm_id numeric 10  √  null bpartner_po_paymentterm_id
bpartner_po_pricelist_id numeric 10  √  null bpartner_po_pricelist_id
bpartner_poreference varchar 20  √  null bpartner_poreference
bpartner_potentiallifetimeval numeric 0  √  null bpartner_potentiallifetimevalue
bpartner_rating bpchar 1  √  null bpartner_rating
bpartner_referenceno varchar 40  √  null bpartner_referenceno
bpartner_salesrep_id numeric 10  √  null bpartner_salesrep_id
bpartner_salesvolume numeric 10  √  null bpartner_salesvolume
bpartner_sendemail bpchar 1  √  null bpartner_sendemail
bpartner_shareofcustomer numeric 10  √  null bpartner_shareofcustomer
bpartner_shelflifeminpct numeric 10  √  null bpartner_shelflifeminpct
bpartner_so_creditlimit numeric 0  √  null bpartner_so_creditlimit
bpartner_socreditstatus bpchar 1  √  null bpartner_socreditstatus
bpartner_so_creditused numeric 0  √  null bpartner_so_creditused
bpartner_so_description varchar 255  √  null bpartner_so_description
bpartner_taxid varchar 20  √  null bpartner_taxid
bpartner_totalopenbalance numeric 0  √  null bpartner_totalopenbalance
bpartner_updated timestamp 29,6  √  null bpartner_updated
bpartner_updatedby numeric 10  √  null bpartner_updatedby
bpartner_url varchar 120  √  null bpartner_url
bpartner_value varchar 40  √  null The Key of the Business Partner
cursymbol varchar 10  √  null Symbol of the currency (opt used for printing only)
cur_description varchar 255  √  null Currency Description

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