View idempiere9.adempiere.c_project_header_v
Project 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_project_id numeric 10  √  null Financial Project
value varchar 40  √  null Search key for the record in the format required - must be unique
projectname varchar 60  √  null Name of the Project
description varchar 255  √  null Optional short description of the record
note varchar 2000  √  null Optional additional user defined information
issummary bpchar 1  √  null This is a summary entity
projectcategory bpchar 1  √  null Project Category
org_location_id numeric 10  √  null Organization Location/Address
taxid varchar 20  √  null Tax Identification
c_projecttype_id numeric 10  √  null Type of the project
projecttypename varchar 60  √  null Name of the Project Type
c_phase_id numeric 10  √  null Standard Phase of the Project Type
projectphasename varchar 60  √  null Name of the Project Phase
salesrep_id numeric 10  √  null Sales Representative or Company Agent
salesrep_name varchar 2147483647  √  null Sales Representative
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
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
paymentterm varchar 60  √  null Payment Term
paymenttermnote varchar 2000  √  null Note of a Payment Term
poreference varchar 20  √  null Transaction Reference Number (Sales Order, Purchase Order) of your Business Partner
c_currency_id numeric 10  √  null The Currency for this record
m_pricelist_version_id numeric 10  √  null Identifies a unique instance of a Price List
c_campaign_id numeric 10  √  null Marketing Campaign
plannedamt numeric 0  √  null Planned amount for this project
plannedqty numeric 0  √  null Planned quantity for this project
plannedmarginamt numeric 0  √  null Project's planned margin amount
invoicedamt numeric 0  √  null The amount invoiced
invoicedqty numeric 0  √  null The quantity invoiced
projectbalanceamt numeric 0  √  null Total Project Balance
iscommitment bpchar 1  √  null Is this document a (legal) commitment?
committedamt numeric 0  √  null The (legal) commitment amount
committedqty numeric 0  √  null The (legal) commitment Quantity
datecontract timestamp 29,6  √  null The (planned) effective date of this document.
datefinish timestamp 29,6  √  null Finish or (planned) completion date
iscommitceiling bpchar 1  √  null The commitment amount/quantity is the chargeable ceiling
m_warehouse_id numeric 10  √  null Storage Warehouse and Service Point
logo_id numeric 10  √  null Logo
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
copyfrom bpchar 1  √  null Copy From Record
c_project_c_paymentterm_id numeric 10  √  null c_project_c_paymentterm_id
generateto bpchar 1  √  null Generate To
c_project_processed bpchar 1  √  null c_project_processed
c_project_processing bpchar 1  √  null c_project_processing
projectlinelevel bpchar 1  √  null Project Line Level
projinvoicerule bpchar 1  √  null Invoice Rule for the project
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_bp_group_id numeric 10  √  null c_bp_c_bp_group_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_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_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_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
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
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
ad_orginfo_m_warehouse_id numeric 10  √  null ad_orginfo_m_warehouse_id
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
c_projecttype_ad_org_id numeric 10  √  null c_projecttype_ad_org_id
c_projecttype_description varchar 255  √  null c_projecttype_description
c_projecttype_help varchar 2000  √  null c_projecttype_help
c_projecttype_isactive bpchar 1  √  null c_projecttype_isactive
c_projecttype_projectcategory bpchar 1  √  null c_projecttype_projectcategory
c_phase_ad_org_id numeric 10  √  null c_phase_ad_org_id
c_phase_c_phase_id numeric 10  √  null c_phase_c_phase_id
c_phase_c_projecttype_id numeric 10  √  null c_phase_c_projecttype_id
c_phase_description varchar 255  √  null c_phase_description
c_phase_help varchar 2000  √  null c_phase_help
c_phase_isactive bpchar 1  √  null c_phase_isactive
c_phase_m_product_id numeric 10  √  null c_phase_m_product_id
c_phase_seqno numeric 10  √  null c_phase_seqno
standardqty numeric 0  √  null Standard Quantity
salesrep_ad_org_id numeric 10  √  null SalesRep_AD_Org_ID
salesrep_ad_orgtrx_id numeric 10  √  null salesrep_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
salesrep_bp_acqusitioncost numeric 0  √  null salesrep_bp_acqusitioncost
salesrep_bp_actuallifevalue numeric 0  √  null salesrep_bp_actuallifevalue
salesrep_bp_ad_language varchar 6  √  null salesrep_bp_ad_language
salesrep_bp_ad_orgbp_id numeric 10  √  null salesrep_bp_ad_orgbp_id
salesrep_bp_ad_org_id numeric 10  √  null salesrep_bp_ad_org_id
salesrep_bp_bpartner_parent_id numeric 10  √  null salesrep_bp_bpartner_parent_id
salesrep_bp_c_bp_group_id numeric 10  √  null SalesRep_BP_C_BP_Group_ID
salesrep_bp_c_dunning_id numeric 10  √  null salesrep_bp_c_dunning_id
salesrep_bp_c_greeting_id numeric 10  √  null SalesRep_BP_C_Greeting_ID
salesrep_bp_c_invoicesched_id numeric 10  √  null salesrep_bp_c_invoiceschedule_id
salesrep_bp_c_paymentterm_id numeric 10  √  null SalesRep_BP_C_PaymentTerm_ID
salesrep_bp_created timestamp 29,6  √  null salesrep_bp_created
salesrep_bp_createdby numeric 10  √  null salesrep_bp_createdby
salesrep_bp_c_taxgroup_id numeric 10  √  null SalesRep_BP_C_TaxGroup_ID
salesrep_bp_deliveryrule bpchar 1  √  null salesrep_bp_deliveryrule
salesrep_bp_deliveryviarule bpchar 1  √  null salesrep_bp_deliveryviarule
salesrep_bp_description varchar 255  √  null salesrep_bp_description
salesrep_bp_dunninggrace timestamp 29,6  √  null salesrep_bp_dunninggrace
salesrep_bp_duns varchar 11  √  null salesrep_bp_duns
salesrep_bp_firstsale timestamp 29,6  √  null salesrep_bp_firstsale
salesrep_bp_flatdiscount numeric 0  √  null salesrep_bp_flatdiscount
salesrep_bp_freightcostrule bpchar 1  √  null salesrep_bp_freightcostrule
salesrep_bp_invoicerule bpchar 1  √  null salesrep_bp_invoicerule
salesrep_bp_isactive bpchar 1  √  null salesrep_bp_isactive
salesrep_bp_iscustomer bpchar 1  √  null salesrep_bp_iscustomer
salesrep_bp_isdiscountprinted bpchar 1  √  null salesrep_bp_isdiscountprinted
salesrep_bp_isemployee bpchar 1  √  null salesrep_bp_isemployee
salesrep_bp_ismanufacturer bpchar 1  √  null salesrep_bp_ismanufacturer
salesrep_bp_isonetime bpchar 1  √  null salesrep_bp_isonetime
salesrep_bp_ispotaxexempt bpchar 1  √  null salesrep_bp_ispotaxexempt
salesrep_bp_isprospect bpchar 1  √  null salesrep_bp_isprospect
salesrep_bp_issalesrep bpchar 1  √  null salesrep_bp_issalesrep
salesrep_bp_issummary bpchar 1  √  null salesrep_bp_issummary
salesrep_bp_istaxexempt bpchar 1  √  null salesrep_bp_istaxexempt
salesrep_bp_isvendor bpchar 1  √  null salesrep_bp_isvendor
salesrep_bp_logo_id numeric 10  √  null salesrep_bp_logo_id
salesrep_bp_m_discountschm_id numeric 10  √  null SalesRep_BP_M_DiscountSchm_ID
salesrep_bp_m_pricelist_id numeric 10  √  null SalesRep_BP_M_PriceList_ID
salesrep_bp_naics varchar 6  √  null salesrep_bp_naics
salesrep_bp_name2 varchar 60  √  null salesrep_bp_name2
salesrep_bp_numberemployees numeric 10  √  null salesrep_bp_numberemployees
salesrep_bp_paymentrule bpchar 1  √  null salesrep_bp_paymentrule
salesrep_bp_paymentrulepo bpchar 1  √  null salesrep_bp_paymentrulepo
salesrep_bp_po_discountschm_id numeric 10  √  null SalesRep_BP_PO_DiscountSchm_ID
salesrep_bp_po_paymentterm_id numeric 10  √  null SalesRep_BP_PO_PaymentTerm_ID
salesrep_bp_po_pricelist_id numeric 10  √  null SalesRep_BP_PO_PriceList_ID
salesrep_bp_poreference varchar 20  √  null salesrep_bp_poreference
salesrep_bp_potentiallifevalue numeric 0  √  null salesrep_bp_potentiallifevalue
salesrep_bp_rating bpchar 1  √  null salesrep_bp_rating
salesrep_bp_referenceno varchar 40  √  null salesrep_bp_referenceno
salesrep_bp_salesrep_id numeric 10  √  null salesrep_bp_salesrep_id
salesrep_bp_salesvolume numeric 10  √  null salesrep_bp_salesvolume
salesrep_bp_sendemail bpchar 1  √  null salesrep_bp_sendemail
salesrep_bp_shareofcustomer numeric 10  √  null salesrep_bp_shareofcustomer
salesrep_bp_shelflifeminpct numeric 10  √  null salesrep_bp_shelflifeminpct
salesrep_bp_so_creditlimit numeric 0  √  null salesrep_bp_so_creditlimit
salesrep_bp_socreditstatus bpchar 1  √  null salesrep_bp_socreditstatus
salesrep_bp_so_creditused numeric 0  √  null salesrep_bp_so_creditused
salesrep_bp_so_description varchar 255  √  null salesrep_bp_so_description
salesrep_bp_taxid varchar 20  √  null salesrep_bp_taxid
salesrep_bp_totalopenbalance numeric 0  √  null salesrep_bp_totalopenbalance
salesrep_bp_updated timestamp 29,6  √  null salesrep_bp_updated
salesrep_bp_updatedby numeric 10  √  null salesrep_bp_updatedby
salesrep_bp_url varchar 120  √  null salesrep_bp_url
salesrep_bp_value varchar 40  √  null salesrep_bp_value
c_greeting_ad_org_id numeric 10  √  null c_greeting_ad_org_id
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
ad_user_ad_org_id numeric 10  √  null AD_User_AD_Org_ID
ad_user_ad_orgtrx_id numeric 10  √  null AD_User_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
c_user_greeting_ad_org_id numeric 10  √  null c_user_greeting_ad_org_id
c_user_greeting_c_greeting_id numeric 10  √  null c_user_greeting_c_greeting_id
c_user_greeting_isactive bpchar 1  √  null c_user_greeting_isactive
c_user_greeting_isfnameonly bpchar 1  √  null c_user_greeting_isfnameonly
c_user_greeting_name varchar 60  √  null c_user_greeting_name
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_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
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_c_paymentterm_id numeric 10  √  null c_paymentterm_c_paymentterm_id
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

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