SchemaSpy Analysis of idempiere9.adempiere - ColumnsRfQ Generated by
Quality Systems & Solutions
Generated on 2021-12-25 14:55 +0100
Legend:
Primary key columns
Columns with indexes
 

idempiere9.adempiere contains 675 columns - click on heading to sort:
Table Column Type Size Nulls Auto Default
c_rfqresponse checkcomplete bpchar 1  √  null Check Complete
ad_user connectionprofile bpchar 1  √  null How a Java Client connects to the server(s)
c_order copyfrom bpchar 1  √  null Copy From Record
m_product copyfrom bpchar 1  √  NULL::bpchar Copy From Record
c_rfq copylines bpchar 1  √  null Copy Lines
ad_printformat createcopy bpchar 1  √  null Create Copy
c_rfq createpo bpchar 1  √  null Create Purchase Order
c_rfq createso bpchar 1  √  null Create SO
c_bpartner deliveryrule bpchar 1  √  null Defines the timing of Delivery
c_order deliveryrule bpchar 1 Defines the timing of Delivery
c_bpartner deliveryviarule bpchar 1  √  null How the order will be delivered
c_order deliveryviarule bpchar 1 How the order will be delivered
m_product discontinued bpchar 1  √  'N'::bpchar This product is no longer available
m_pricelist enforcepricelimit bpchar 1 'N'::bpchar Do not allow prices below the limit price
c_bpartner freightcostrule bpchar 1  √  null Method for charging Freight
c_order freightcostrule bpchar 1 Method for charging Freight
c_bpartner invoicerule bpchar 1  √  null Frequency and method of invoicing
c_order invoicerule bpchar 1 Frequency and method of invoicing
c_bpartner is1099vendor bpchar 1 'N'::bpchar 1099 Vendor
ad_printformat isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_user isactive bpchar 1 'Y'::bpchar The record is active in the system
c_bpartner isactive bpchar 1 'Y'::bpchar The record is active in the system
c_bpartner_location isactive bpchar 1 'Y'::bpchar The record is active in the system
c_bpartner_product isactive bpchar 1 'Y'::bpchar The record is active in the system
c_currency isactive bpchar 1 'Y'::bpchar The record is active in the system
c_order isactive bpchar 1 'Y'::bpchar The record is active in the system
c_rfq isactive bpchar 1 'Y'::bpchar The record is active in the system
c_rfq_topic isactive bpchar 1 'Y'::bpchar The record is active in the system
c_rfq_topicsubscriber isactive bpchar 1 'Y'::bpchar The record is active in the system
c_rfq_topicsubscriberonly isactive bpchar 1 'Y'::bpchar The record is active in the system
c_rfqline isactive bpchar 1 'Y'::bpchar The record is active in the system
c_rfqlineqty isactive bpchar 1 'Y'::bpchar The record is active in the system
c_rfqresponse isactive bpchar 1 'Y'::bpchar The record is active in the system
c_rfqresponseline isactive bpchar 1 'Y'::bpchar The record is active in the system
c_rfqresponselineqty isactive bpchar 1 'Y'::bpchar The record is active in the system
c_uom isactive bpchar 1 'Y'::bpchar The record is active in the system
m_attributesetinstance isactive bpchar 1 'Y'::bpchar The record is active in the system
m_pricelist isactive bpchar 1 'Y'::bpchar The record is active in the system
m_pricelist_version isactive bpchar 1 'Y'::bpchar The record is active in the system
m_product isactive bpchar 1 'Y'::bpchar The record is active in the system
m_product_category isactive bpchar 1 'Y'::bpchar The record is active in the system
r_contactinterest isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_user isaddmailtextautomatically bpchar 1 'N'::bpchar The selected mail template will be automatically inserted when creating an email
c_order isapproved bpchar 1 'Y'::bpchar Indicates if this document requires approval
m_product isautoproduce bpchar 1 'N'::bpchar Auto create production to fulfill shipment
ad_user isbillto bpchar 1 'N'::bpchar Business Partner Invoice/Bill Address
c_bpartner_location isbillto bpchar 1 'Y'::bpchar Business Partner Invoice/Bill Address
m_product isbom bpchar 1 'N'::bpchar Bill of Materials
ad_printformat isbreakpageperrecord bpchar 1 'Y'::bpchar Page Break after each record
c_rfqresponse iscomplete bpchar 1 'N'::bpchar It is complete
c_order iscreditapproved bpchar 1 'N'::bpchar Credit has been approved
c_bpartner iscustomer bpchar 1 'Y'::bpchar Indicates if this Business Partner is a Customer
ad_printformat isdefault bpchar 1 'N'::bpchar Default value
c_uom isdefault bpchar 1 'N'::bpchar Default value
m_pricelist isdefault bpchar 1 'N'::bpchar Default value
m_product_category isdefault bpchar 1 'N'::bpchar Default value
c_order isdelivered bpchar 1 'N'::bpchar Delivered
c_bpartner isdiscountprinted bpchar 1  √  'Y'::bpchar Print Discount on Invoice and Order
c_order isdiscountprinted bpchar 1 'Y'::bpchar Print Discount on Invoice and Order
c_order isdropship bpchar 1 'N'::bpchar Drop Shipments are sent directly to the Drop Shipment Location
m_product isdropship bpchar 1 'N'::bpchar Drop Shipments are sent directly to the Drop Shipment Location
c_bpartner isemployee bpchar 1 'N'::bpchar Indicates if this Business Partner is an employee
c_currency isemumember bpchar 1 'N'::bpchar This currency is member if the European Monetary Union
c_currency iseuro bpchar 1 'N'::bpchar This currency is the Euro
m_product isexcludeautodelivery bpchar 1 'N'::bpchar Exclude from automatic Delivery
ad_user isexpired bpchar 1 'N'::bpchar Expired
ad_printformat isform bpchar 1 'N'::bpchar If Selected, a Form is printed, if not selected a columnar List report
ad_user isfullbpaccess bpchar 1 'Y'::bpchar The user/contact has full access to Business Partner information and resources
ad_user isinpayroll bpchar 1 'N'::bpchar Defined if any User Contact will be used for Calculate Payroll
c_rfq isinvitedvendorsonly bpchar 1 'N'::bpchar Only invited vendors can respond to an RfQ
c_order isinvoiced bpchar 1 'N'::bpchar Is this invoiced?
m_product isinvoiceprintdetails bpchar 1 'N'::bpchar Print detail BOM elements on the invoice
m_product iskanban bpchar 1 'N'::bpchar This part is Kanban controlled
ad_user islocked bpchar 1 'N'::bpchar Locked
m_pricelist ismandatory bpchar 1  √  'N'::bpchar Data entry is required in this column
m_product ismanufactured bpchar 1 'N'::bpchar This product is manufactured
c_bpartner ismanufacturer bpchar 1  √  'N'::bpchar Indicate role of this Business partner as Manufacturer
c_bpartner_product ismanufacturer bpchar 1 'N'::bpchar Indicate role of this Business partner as Manufacturer
ad_user ismenuautoexpand bpchar 1  √  null If ticked, the menu is automatically expanded
ad_user isnoexpire bpchar 1 'N'::bpchar No Expire
ad_user isnopasswordreset bpchar 1 'N'::bpchar No Password Reset
c_rfqlineqty isofferqty bpchar 1 'N'::bpchar This quantity is used in the Offer to the Customer
c_bpartner isonetime bpchar 1 'N'::bpchar One time transaction
m_product isownbox bpchar 1 'N'::bpchar Own Box
c_bpartner_location ispayfrom bpchar 1 'Y'::bpchar Business Partner pays from that address and we'll send dunning letters there
c_order ispayschedulevalid bpchar 1 'N'::bpchar Is the Payment Schedule is valid
m_product isphantom bpchar 1  √  'N'::bpchar Phantom Component
m_product ispicklistprintdetails bpchar 1 'N'::bpchar Print detail BOM elements on the pick list
c_bpartner ispotaxexempt bpchar 1 'N'::bpchar Business partner is exempt from tax on purchases
m_pricelist ispresentforproduct bpchar 1  √  'N'::bpchar isPresentForProduct
c_bpartner_location ispreservecustomname bpchar 1 'N'::bpchar Preserve custom name
c_order isprinted bpchar 1 'N'::bpchar Indicates if this document / line is printed
c_order ispriviledgedrate bpchar 1 'N'::bpchar Priviledged Rate
c_bpartner isprospect bpchar 1 'N'::bpchar Indicates this is a Prospect
m_product ispurchased bpchar 1 'Y'::bpchar Organization purchases this product
c_rfqlineqty ispurchaseqty bpchar 1 'N'::bpchar This quantity is used in the Purchase Order to the Supplier
c_rfq isquoteallqty bpchar 1 'Y'::bpchar Suppliers are requested to provide responses for all quantities
c_rfq isquotetotalamt bpchar 1 'N'::bpchar The response can have just the total amount for the RfQ
c_bpartner_location isremitto bpchar 1 'Y'::bpchar Business Partner payment address
c_rfqlineqty isrfqqty bpchar 1 'Y'::bpchar The quantity is used when generating RfQ Responses
c_rfq isrfqresponseaccepted bpchar 1 'Y'::bpchar Are Responses to the Request for Quotation accepted
ad_user issaleslead bpchar 1 'N'::bpchar This contact is a sales lead
c_bpartner issalesrep bpchar 1 'N'::bpchar Indicates if the business partner is a sales representative or company agent
c_order isselected bpchar 1 'N'::bpchar Selected
c_rfqresponse isselectedwinner bpchar 1 'N'::bpchar The response is the selected winner
c_rfqresponseline isselectedwinner bpchar 1 'N'::bpchar The response is the selected winner
c_order isselfservice bpchar 1 'N'::bpchar This is a Self-Service entry or this entry can be changed via Self-Service
c_rfq isselfservice bpchar 1 'N'::bpchar This is a Self-Service entry or this entry can be changed via Self-Service
c_rfq_topic isselfservice bpchar 1 'N'::bpchar This is a Self-Service entry or this entry can be changed via Self-Service
c_rfqresponse isselfservice bpchar 1 'N'::bpchar This is a Self-Service entry or this entry can be changed via Self-Service
c_rfqresponseline isselfservice bpchar 1 'N'::bpchar This is a Self-Service entry or this entry can be changed via Self-Service
m_product isselfservice bpchar 1 'Y'::bpchar This is a Self-Service entry or this entry can be changed via Self-Service
m_product_category isselfservice bpchar 1 'Y'::bpchar This is a Self-Service entry or this entry can be changed via Self-Service
ad_user isshipto bpchar 1 'N'::bpchar Business Partner Shipment Address
c_bpartner_location isshipto bpchar 1 'Y'::bpchar Business Partner Shipment Address
m_product issold bpchar 1 'Y'::bpchar Organization sells this product
m_pricelist issopricelist bpchar 1 'Y'::bpchar This is a Sales Price List
c_order issotrx bpchar 1 'Y'::bpchar This is a Sales Transaction
ad_printformat isstandardheaderfooter bpchar 1 'Y'::bpchar The standard Header and Footer is used
m_product isstocked bpchar 1 'Y'::bpchar Organization stocks this product
c_bpartner issummary bpchar 1 'N'::bpchar This is a summary entity
m_product issummary bpchar 1 'N'::bpchar This is a summary entity
ad_user issupportuser bpchar 1 'N'::bpchar Support User
ad_printformat istablebased bpchar 1 'Y'::bpchar Table based List Reporting
c_bpartner istaxexempt bpchar 1  √  'N'::bpchar Business partner is exempt from tax on sales
c_order istaxincluded bpchar 1 'N'::bpchar Tax is included in the price
m_pricelist istaxincluded bpchar 1 'N'::bpchar Tax is included in the price
m_product istoformule bpchar 1  √  null
c_order istransferred bpchar 1 'N'::bpchar Transferred to General Ledger (i.e. accounted)
c_bpartner isvendor bpchar 1 'N'::bpchar Indicates if this Business Partner is a Vendor
ad_user isvendorlead bpchar 1 'N'::bpchar This contact is a vendor lead
m_product isverified bpchar 1 'N'::bpchar The BOM configuration has been verified
m_product iswebstorefeatured bpchar 1 'N'::bpchar If selected, the product is displayed in the initial or any empty search
m_product_category mmpolicy bpchar 1 'F'::bpchar Material Movement Policy
ad_user notificationtype bpchar 1 'X'::bpchar Type of Notifications
c_bpartner paymentrule bpchar 1  √  null How you pay the invoice
c_order paymentrule bpchar 1 How you pay the invoice
c_bpartner paymentrulepo bpchar 1  √  null Purchase payment option
c_order posted bpchar 1 'N'::bpchar Posting status
c_order priorityrule bpchar 1 Priority of a document
m_pricelist_version proccreate bpchar 1  √  null Create
c_order processed bpchar 1 'N'::bpchar The document has been processed
c_rfq processed bpchar 1 'N'::bpchar The document has been processed
c_rfqresponse processed bpchar 1 'N'::bpchar The document has been processed
ad_user processing bpchar 1  √  null Process Now
c_order processing bpchar 1  √  null Process Now
c_rfq processing bpchar 1  √  null Process Now
c_rfqresponse processing bpchar 1  √  null Process Now
m_product processing bpchar 1  √  null Process Now
m_product producttype bpchar 1 'I'::bpchar Type of product
c_rfq publishrfq bpchar 1  √  null Publish RfQ
c_rfq quotetype bpchar 1 Request for Quotation Type
c_rfq rankrfq bpchar 1  √  null Rank RfQ
c_bpartner rating bpchar 1  √  null Classification or Importance
c_bpartner sendemail bpchar 1 'N'::bpchar Enable sending Document EMail
c_order sendemail bpchar 1 'N'::bpchar Enable sending Document EMail
c_order shippingrateinquiry bpchar 1  √  NULL::bpchar Rate Inquiry
c_bpartner socreditstatus bpchar 1  √  'O'::bpchar Business Partner Credit Status
c_order docaction bpchar 2 The targeted status of the document
c_order docstatus bpchar 2 The current status of the document
c_currency iso_code bpchar 3 Three letter ISO 4217 Code of the Currency
c_bpartner acqusitioncost numeric 0  √  0 The cost of gaining the prospect as a customer
c_bpartner actuallifetimevalue numeric 0  √  0 Actual Life Time Revenue
c_rfqlineqty benchmarkprice numeric 0 0 Price to compare responses to
c_rfqlineqty bestresponseamt numeric 0  √  0 Best Response Amount
c_order chargeamt numeric 0  √  0 Charge Amount
c_rfqresponselineqty discount numeric 0  √  null Discount in percent
c_currency emurate numeric 0  √  0 Official rate to the Euro
c_bpartner flatdiscount numeric 0  √  null Flat discount percentage
c_order freightamt numeric 0  √  0 Freight Amount
c_order grandtotal numeric 0 0 Total amount of document
c_rfq margin numeric 0  √  null Margin for a product as a percentage
c_rfqlineqty margin numeric 0  √  null Margin for a product as a percentage
c_rfqlineqty offeramt numeric 0  √  0 Amount of the Offer
m_product_category plannedmargin numeric 0 Project's planned margin as a percentage
c_bpartner potentiallifetimevalue numeric 0  √  0 Total Revenue expected
c_rfqresponse price numeric 0 0 Price
c_rfqresponselineqty price numeric 0 0 Price
c_order processedon numeric 0  √  null The date+time (expressed in decimal format) when the document has been processed
c_rfqlineqty qty numeric 0 0 Quantity
c_bpartner_product qualityrating numeric 0  √  null Method for rating vendors
c_currency roundofffactor numeric 0  √  null Used to Round Off Payment Amount
m_product shelfheight numeric 0  √  null Shelf height required
c_bpartner so_creditlimit numeric 0  √  0 Total outstanding invoice amounts allowed
c_bpartner so_creditused numeric 0  √  0 Current open balance
c_order totallines numeric 0 0 Total of all document lines
c_bpartner totalopenbalance numeric 0  √  null Total Open Balance Amount in primary Accounting Currency
m_product unitsperpallet numeric 0  √  null Units Per Pallet
c_order volume numeric 0  √  null Volume of a product
m_product volume numeric 0  √  0 Volume of a product
c_order weight numeric 0  √  null Weight of a product
m_product weight numeric 0  √  0 Weight of a product
m_product_category a_asset_group_id numeric 10  √  null Group of Assets
ad_printformat ad_client_id numeric 10 Client/Tenant for this installation.
ad_user ad_client_id numeric 10 Client/Tenant for this installation.
c_bpartner ad_client_id numeric 10 Client/Tenant for this installation.
c_bpartner_location ad_client_id numeric 10 Client/Tenant for this installation.
c_bpartner_product ad_client_id numeric 10 Client/Tenant for this installation.
c_currency ad_client_id numeric 10 Client/Tenant for this installation.
c_order ad_client_id numeric 10 Client/Tenant for this installation.
c_rfq ad_client_id numeric 10 Client/Tenant for this installation.
c_rfq_topic ad_client_id numeric 10 Client/Tenant for this installation.
c_rfq_topicsubscriber ad_client_id numeric 10 Client/Tenant for this installation.
c_rfq_topicsubscriberonly ad_client_id numeric 10 Client/Tenant for this installation.
c_rfqline ad_client_id numeric 10 Client/Tenant for this installation.
c_rfqlineqty ad_client_id numeric 10 Client/Tenant for this installation.
c_rfqresponse ad_client_id numeric 10 Client/Tenant for this installation.
c_rfqresponseline ad_client_id numeric 10 Client/Tenant for this installation.
c_rfqresponselineqty ad_client_id numeric 10 Client/Tenant for this installation.
c_uom ad_client_id numeric 10 Client/Tenant for this installation.
m_attributesetinstance ad_client_id numeric 10 Client/Tenant for this installation.
m_pricelist ad_client_id numeric 10 Client/Tenant for this installation.
m_pricelist_version ad_client_id numeric 10 Client/Tenant for this installation.
m_product ad_client_id numeric 10 Client/Tenant for this installation.
m_product_category ad_client_id numeric 10 Client/Tenant for this installation.
r_contactinterest ad_client_id numeric 10 Client/Tenant for this installation.
ad_user ad_image_id numeric 10  √  NULL::numeric Image or Icon
ad_printformat ad_org_id numeric 10 Organizational entity within client
ad_user ad_org_id numeric 10 Organizational entity within client
c_bpartner ad_org_id numeric 10 Organizational entity within client
c_bpartner_location ad_org_id numeric 10 Organizational entity within client
c_bpartner_product ad_org_id numeric 10 Organizational entity within client
c_currency ad_org_id numeric 10 Organizational entity within client
c_order ad_org_id numeric 10 Organizational entity within client
c_rfq ad_org_id numeric 10 Organizational entity within client
c_rfq_topic ad_org_id numeric 10 Organizational entity within client
c_rfq_topicsubscriber ad_org_id numeric 10 Organizational entity within client
c_rfq_topicsubscriberonly ad_org_id numeric 10 Organizational entity within client
c_rfqline ad_org_id numeric 10 Organizational entity within client
c_rfqlineqty ad_org_id numeric 10 Organizational entity within client
c_rfqresponse ad_org_id numeric 10 Organizational entity within client
c_rfqresponseline ad_org_id numeric 10 Organizational entity within client
c_rfqresponselineqty ad_org_id numeric 10 Organizational entity within client
c_uom ad_org_id numeric 10 Organizational entity within client
m_attributesetinstance ad_org_id numeric 10 Organizational entity within client
m_pricelist ad_org_id numeric 10 Organizational entity within client
m_pricelist_version ad_org_id numeric 10 Organizational entity within client
m_product ad_org_id numeric 10 Organizational entity within client
m_product_category ad_org_id numeric 10 Organizational entity within client
r_contactinterest ad_org_id numeric 10 Organizational entity within client
c_bpartner ad_orgbp_id numeric 10  √  null The Business Partner is another Organization for explicit Inter-Org transactions
ad_user ad_orgtrx_id numeric 10  √  null Performing or initiating organization
c_order ad_orgtrx_id numeric 10  √  null Performing or initiating organization
ad_printformat ad_printcolor_id numeric 10 Color used for printing and display
m_product_category ad_printcolor_id numeric 10  √  null Color used for printing and display
ad_printformat ad_printfont_id numeric 10 Maintain Print Font
ad_printformat ad_printformat_id numeric 10 Data Print Format
c_rfq_topic ad_printformat_id numeric 10  √  null Data Print Format
ad_printformat ad_printheaderfooter_id numeric 10  √  NULL::numeric Print Header/Footer
ad_printformat ad_printpaper_id numeric 10 Printer paper definition
ad_printformat ad_printtableformat_id numeric 10  √  null Table Format in Reports
ad_printformat ad_reportview_id numeric 10  √  null View used to generate this report
ad_printformat ad_table_id numeric 10 Database Table information
ad_user ad_user_id numeric 10 User within the system - Internal or Business Partner Contact
c_order ad_user_id numeric 10  √  null User within the system - Internal or Business Partner Contact
c_rfq ad_user_id numeric 10  √  null User within the system - Internal or Business Partner Contact
c_rfq_topicsubscriber ad_user_id numeric 10  √  null User within the system - Internal or Business Partner Contact
c_rfqresponse ad_user_id numeric 10  √  null User within the system - Internal or Business Partner Contact
r_contactinterest ad_user_id numeric 10 User within the system - Internal or Business Partner Contact
ad_printformat ad_window_id numeric 10  √  NULL::numeric Data entry or display window
m_pricelist basepricelist_id numeric 10  √  null Pricelist to be used, if product not found on this pricelist
c_order bill_bpartner_id numeric 10  √  null Business Partner to be invoiced
c_order bill_location_id numeric 10  √  null Business Partner Location for invoicing
c_order bill_user_id numeric 10  √  null Business Partner Contact for invoicing
ad_user bp_location_id numeric 10  √  NULL::numeric Address of the Business Partner
c_bpartner bpartner_parent_id numeric 10  √  null Business Partner Parent
c_order c_activity_id numeric 10  √  null Business Activity
c_bpartner c_bp_group_id numeric 10 Business Partner Group
ad_user c_bpartner_id numeric 10  √  null Identifies a Business Partner
c_bpartner c_bpartner_id numeric 10 Identifies a Business Partner
c_bpartner_location c_bpartner_id numeric 10 Identifies a Business Partner
c_bpartner_product c_bpartner_id numeric 10 Identifies a Business Partner
c_order c_bpartner_id numeric 10 Identifies a Business Partner
c_rfq c_bpartner_id numeric 10  √  null Identifies a Business Partner
c_rfq_topicsubscriber c_bpartner_id numeric 10 Identifies a Business Partner
c_rfqresponse c_bpartner_id numeric 10 Identifies a Business Partner
ad_user c_bpartner_location_id numeric 10  √  null Identifies the (ship to) address for this Business Partner
c_bpartner_location c_bpartner_location_id numeric 10 Identifies the (ship to) address for this Business Partner
c_order c_bpartner_location_id numeric 10 Identifies the (ship to) address for this Business Partner
c_rfq c_bpartner_location_id numeric 10  √  null Identifies the (ship to) address for this Business Partner
c_rfq_topicsubscriber c_bpartner_location_id numeric 10 Identifies the (ship to) address for this Business Partner
c_rfqresponse c_bpartner_location_id numeric 10 Identifies the (ship to) address for this Business Partner
ad_user c_campaign_id numeric 10  √  NULL::numeric Marketing Campaign
c_order c_campaign_id numeric 10  √  null Marketing Campaign
c_order c_cashline_id numeric 10  √  null Cash Journal Line
c_order c_cashplanline_id numeric 10  √  NULL::numeric Cash Plan Line
c_order c_charge_id numeric 10  √  null Additional document charges
c_order c_conversiontype_id numeric 10  √  null Currency Conversion Rate Type
c_currency c_currency_id numeric 10 The Currency for this record
c_order c_currency_id numeric 10 The Currency for this record
c_rfq c_currency_id numeric 10 The Currency for this record
c_rfqresponse c_currency_id numeric 10 The Currency for this record
m_pricelist c_currency_id numeric 10 The Currency for this record
c_order c_doctype_id numeric 10 Document type or rules
c_order c_doctypetarget_id numeric 10 Target document type for conversing documents
c_bpartner c_dunning_id numeric 10  √  null Dunning Rules for overdue invoices
ad_user c_greeting_id numeric 10  √  null Greeting to print on correspondence
c_bpartner c_greeting_id numeric 10  √  null Greeting to print on correspondence
c_bpartner c_invoiceschedule_id numeric 10  √  null Schedule for generating Invoices
ad_user c_job_id numeric 10  √  null Job Position
ad_user c_location_id numeric 10  √  NULL::numeric Location or Address
c_bpartner_location c_location_id numeric 10  √  null Location or Address
c_order c_opportunity_id numeric 10  √  NULL::numeric Sales Opportunity
c_order c_order_id numeric 10 Order
c_rfq c_order_id numeric 10  √  null Order
c_rfqresponse c_order_id numeric 10  √  null Order
c_order c_ordersource_id numeric 10  √  null Order Source
c_order c_payment_id numeric 10  √  null Payment identifier
c_bpartner c_paymentterm_id numeric 10  √  null The terms of Payment (timing, discount)
c_order c_paymentterm_id numeric 10 The terms of Payment (timing, discount)
c_order c_pos_id numeric 10  √  null Point of Sales Terminal
c_order c_project_id numeric 10  √  null Financial Project
m_product c_revenuerecognition_id numeric 10  √  null Method for recording revenue
c_rfq c_rfq_id numeric 10 Request for Quotation
c_rfqline c_rfq_id numeric 10 Request for Quotation
c_rfqresponse c_rfq_id numeric 10 Request for Quotation
c_rfq c_rfq_topic_id numeric 10 Topic for Request for Quotations
c_rfq_topic c_rfq_topic_id numeric 10 Topic for Request for Quotations
c_rfq_topicsubscriber c_rfq_topic_id numeric 10 Topic for Request for Quotations
c_rfq_topicsubscriber c_rfq_topicsubscriber_id numeric 10 Request for Quotation Topic Subscriber
c_rfq_topicsubscriberonly c_rfq_topicsubscriber_id numeric 10 Request for Quotation Topic Subscriber
c_rfq_topicsubscriberonly c_rfq_topicsubscriberonly_id numeric 10 Include Subscriber only for certain products or product categories
c_rfqline c_rfqline_id numeric 10 Request for Quotation Line
c_rfqlineqty c_rfqline_id numeric 10 Request for Quotation Line
c_rfqresponseline c_rfqline_id numeric 10 Request for Quotation Line
c_rfqlineqty c_rfqlineqty_id numeric 10 Request for Quotation Line Quantity
c_rfqresponselineqty c_rfqlineqty_id numeric 10 Request for Quotation Line Quantity
c_rfqresponse c_rfqresponse_id numeric 10 Request for Quotation Response from a potential Vendor
c_rfqresponseline c_rfqresponse_id numeric 10 Request for Quotation Response from a potential Vendor
c_rfqresponseline c_rfqresponseline_id numeric 10 Request for Quotation Response Line
c_rfqresponselineqty c_rfqresponseline_id numeric 10 Request for Quotation Response Line
c_rfqresponselineqty c_rfqresponselineqty_id numeric 10 Request for Quotation Response Line Quantity
c_bpartner_location c_salesregion_id numeric 10  √  null Sales coverage region
m_product c_subscriptiontype_id numeric 10  √  null Type of subscription
m_product c_taxcategory_id numeric 10 Tax Category
c_bpartner c_taxgroup_id numeric 10  √  null Tax Group
c_rfqlineqty c_uom_id numeric 10 Unit of Measure
c_uom c_uom_id numeric 10 Unit of Measure
m_product c_uom_id numeric 10 Unit of Measure
c_currency costingprecision numeric 10 Rounding used costing calculations
c_uom costingprecision numeric 10 Rounding used costing calculations
ad_printformat createdby numeric 10 User who created this records
ad_user createdby numeric 10 User who created this records
c_bpartner createdby numeric 10 User who created this records
c_bpartner_location createdby numeric 10 User who created this records
c_bpartner_product createdby numeric 10 User who created this records
c_currency createdby numeric 10 User who created this records
c_order createdby numeric 10 User who created this records
c_rfq createdby numeric 10 User who created this records
c_rfq_topic createdby numeric 10 User who created this records
c_rfq_topicsubscriber createdby numeric 10 User who created this records
c_rfq_topicsubscriberonly createdby numeric 10 User who created this records
c_rfqline createdby numeric 10 User who created this records
c_rfqlineqty createdby numeric 10 User who created this records
c_rfqresponse createdby numeric 10 User who created this records
c_rfqresponseline createdby numeric 10 User who created this records
c_rfqresponselineqty createdby numeric 10 User who created this records
c_uom createdby numeric 10 User who created this records
m_attributesetinstance createdby numeric 10 User who created this records
m_pricelist createdby numeric 10 User who created this records
m_pricelist_version createdby numeric 10 User who created this records
m_product createdby numeric 10 User who created this records
m_product_category createdby numeric 10 User who created this records
r_contactinterest createdby numeric 10 User who created this records
c_bpartner default1099box_id numeric 10  √  NULL::numeric Default 1099 Box
c_rfq deliverydays numeric 10  √  0 Number of Days (planned) until Delivery
c_rfqline deliverydays numeric 10  √  0 Number of Days (planned) until Delivery
c_rfqresponse deliverydays numeric 10  √  0 Number of Days (planned) until Delivery
c_rfqresponseline deliverydays numeric 10  √  0 Number of Days (planned) until Delivery
c_bpartner documentcopies numeric 10  √  null Number of copies to be printed
c_order dropship_bpartner_id numeric 10  √  null Business Partner to ship to
c_order dropship_location_id numeric 10  √  null Business Partner Location for shipping to
c_order dropship_user_id numeric 10  √  null Business Partner Contact for drop shipment
ad_user failedlogincount numeric 10 (0)::numeric Failed Login Count
ad_printformat footermargin numeric 10 Margin of the Footer in 1/72 of an inch
m_product guaranteedays numeric 10  √  null Number of days the product is guaranteed or available
m_product guaranteedaysmin numeric 10  √  null Minimum number of guarantee days
ad_printformat headermargin numeric 10 Margin of the Header in 1/72 of an inch
c_bpartner invoice_printformat_id numeric 10  √  null Print Format for printing Invoices
ad_printformat jasperprocess_id numeric 10  √  null The Jasper Process used by the printengine if any process defined
c_rfqline line numeric 10 0 Unique line for this document
c_order link_order_id numeric 10  √  null This field links a sales order to the purchase order that is generated from it.
c_bpartner logo_id numeric 10  √  NULL::numeric Logo
m_product lowlevel numeric 10 (0)::numeric The Low Level is used to calculate the material plan and determines if a net requirement should be exploited
m_attributesetinstance m_attributeset_id numeric 10  √  null Product Attribute Set
m_product m_attributeset_id numeric 10  √  null Product Attribute Set
c_rfqline m_attributesetinstance_id numeric 10  √  0 Product Attribute Set Instance
m_attributesetinstance m_attributesetinstance_id numeric 10 Product Attribute Set Instance
m_product m_attributesetinstance_id numeric 10  √  0 Product Attribute Set Instance
c_bpartner m_discountschema_id numeric 10  √  null Schema to calculate the trade discount percentage
m_pricelist_version m_discountschema_id numeric 10 Schema to calculate the trade discount percentage
c_order m_freightcategory_id numeric 10  √  NULL::numeric Category of the Freight
m_product m_freightcategory_id numeric 10  √  null Category of the Freight
m_product m_locator_id numeric 10  √  null Warehouse Locator
m_attributesetinstance m_lot_id numeric 10  √  null Product Lot Definition
m_product m_parttype_id numeric 10  √  NULL::numeric Part Type
c_bpartner m_pricelist_id numeric 10  √  null Unique identifier of a Price List
c_order m_pricelist_id numeric 10 Unique identifier of a Price List
m_pricelist m_pricelist_id numeric 10 Unique identifier of a Price List
m_pricelist_version m_pricelist_id numeric 10 Unique identifier of a Price List
m_pricelist_version m_pricelist_version_base_id numeric 10  √  null Source for Price list calculations
m_pricelist_version m_pricelist_version_id numeric 10 Identifies a unique instance of a Price List
c_rfq_topicsubscriberonly m_product_category_id numeric 10  √  null Category of a Product
m_product m_product_category_id numeric 10 Category of a Product
m_product_category m_product_category_id numeric 10 Category of a Product
m_product_category m_product_category_parent_id numeric 10  √  null Parent Product Category
c_bpartner_product m_product_id numeric 10 Product, Service, Item
c_rfq_topicsubscriberonly m_product_id numeric 10  √  null Product, Service, Item
c_rfqline m_product_id numeric 10  √  null Product, Service, Item
m_product m_product_id numeric 10 Product, Service, Item
c_order m_shipper_id numeric 10  √  null Method or manner of product delivery
c_order m_warehouse_id numeric 10 Storage Warehouse and Service Point
c_bpartner numberemployees numeric 10  √  null Number of employees
c_order pay_bpartner_id numeric 10  √  null Business Partner responsible for the payment
c_order pay_location_id numeric 10  √  null Location of the Business Partner responsible for the payment
c_bpartner po_discountschema_id numeric 10  √  null Schema to calculate the purchase trade discount percentage
c_bpartner po_paymentterm_id numeric 10  √  null Payment rules for a purchase order
c_bpartner po_pricelist_id numeric 10  √  null Price List used by this Business Partner
m_pricelist priceprecision numeric 10 2 Precision (number of decimals) for the Price
c_order quotationorder_id numeric 10  √  NULL::numeric Quotation used for generating this order
ad_user r_defaultmailtext_id numeric 10  √  NULL::numeric Default mail template
r_contactinterest r_interestarea_id numeric 10 Interest Area or Topic
m_product r_mailtext_id numeric 10  √  null Text templates for mailings
c_rfqresponse ranking numeric 10  √  0 Relative Rank Number
c_rfqresponselineqty ranking numeric 10  √  0 Relative Rank Number
c_order ref_order_id numeric 10  √  null Reference to corresponding Sales/Purchase Order
m_product s_expensetype_id numeric 10  √  null Expense report type
m_product s_resource_id numeric 10  √  null Resource
ad_user salesrep_id numeric 10  √  NULL::numeric Sales Representative or Company Agent
c_bpartner salesrep_id numeric 10  √  null Sales Representative or Company Agent
c_order salesrep_id numeric 10  √  null Sales Representative or Company Agent
c_rfq salesrep_id numeric 10 Sales Representative or Company Agent
m_product salesrep_id numeric 10  √  null Sales Representative or Company Agent
c_bpartner salesvolume numeric 10  √  null Total Volume of Sales in Thousands of Currency
c_bpartner shareofcustomer numeric 10  √  null Share of Customer's business as a percentage
m_product shelfdepth numeric 10  √  null Shelf depth required
c_bpartner_product shelflifemindays numeric 10 Minimum Shelf Life in days based on Product Instance Guarantee Date
c_bpartner shelflifeminpct numeric 10  √  null Minimum Shelf Life in percent based on Product Instance Guarantee Date
c_bpartner_product shelflifeminpct numeric 10 Minimum Shelf Life in percent based on Product Instance Guarantee Date
m_product shelfwidth numeric 10  √  null Shelf width required
c_currency stdprecision numeric 10 Rule for rounding calculated amounts
c_uom stdprecision numeric 10 Rule for rounding calculated amounts
ad_user supervisor_id numeric 10  √  null Supervisor for this user/organization - used for escalation and approval
m_product unitsperpack numeric 10 1 The Units Per Pack indicates the no of units of a product packed together.
ad_printformat updatedby numeric 10 User who updated this records
ad_user updatedby numeric 10 User who updated this records
c_bpartner updatedby numeric 10 User who updated this records
c_bpartner_location updatedby numeric 10 User who updated this records
c_bpartner_product updatedby numeric 10 User who updated this records
c_currency updatedby numeric 10 User who updated this records
c_order updatedby numeric 10 User who updated this records
c_rfq updatedby numeric 10 User who updated this records
c_rfq_topic updatedby numeric 10 User who updated this records
c_rfq_topicsubscriber updatedby numeric 10 User who updated this records
c_rfq_topicsubscriberonly updatedby numeric 10 User who updated this records
c_rfqline updatedby numeric 10 User who updated this records
c_rfqlineqty updatedby numeric 10 User who updated this records
c_rfqresponse updatedby numeric 10 User who updated this records
c_rfqresponseline updatedby numeric 10 User who updated this records
c_rfqresponselineqty updatedby numeric 10 User who updated this records
c_uom updatedby numeric 10 User who updated this records
m_attributesetinstance updatedby numeric 10 User who updated this records
m_pricelist updatedby numeric 10 User who updated this records
m_pricelist_version updatedby numeric 10 User who updated this records
m_product updatedby numeric 10 User who updated this records
m_product_category updatedby numeric 10 User who updated this records
r_contactinterest updatedby numeric 10 User who updated this records
c_order user1_id numeric 10  √  null User defined list element #1
c_order user2_id numeric 10  √  null User defined list element #2
c_order amountrefunded numeric 22,2  √  null AmountRefunded
c_order amounttendered numeric 22,2  √  null AmountTendered
ad_user birthday timestamp 29,6  √  null Birthday or Anniversary day
ad_printformat created timestamp 29,6 now() Date this record was created
ad_user created timestamp 29,6 now() Date this record was created
c_bpartner created timestamp 29,6 now() Date this record was created
c_bpartner_location created timestamp 29,6 now() Date this record was created
c_bpartner_product created timestamp 29,6 now() Date this record was created
c_currency created timestamp 29,6 now() Date this record was created
c_order created timestamp 29,6 now() Date this record was created
c_rfq created timestamp 29,6 now() Date this record was created
c_rfq_topic created timestamp 29,6 now() Date this record was created
c_rfq_topicsubscriber created timestamp 29,6 now() Date this record was created
c_rfq_topicsubscriberonly created timestamp 29,6 now() Date this record was created
c_rfqline created timestamp 29,6 now() Date this record was created
c_rfqlineqty created timestamp 29,6 now() Date this record was created
c_rfqresponse created timestamp 29,6 now() Date this record was created
c_rfqresponseline created timestamp 29,6 now() Date this record was created
c_rfqresponselineqty created timestamp 29,6 now() Date this record was created
c_uom created timestamp 29,6 now() Date this record was created
m_attributesetinstance created timestamp 29,6 now() Date this record was created
m_pricelist created timestamp 29,6 now() Date this record was created
m_pricelist_version created timestamp 29,6 now() Date this record was created
m_product created timestamp 29,6 now() Date this record was created
m_product_category created timestamp 29,6 now() Date this record was created
r_contactinterest created timestamp 29,6 now() Date this record was created
ad_user dateaccountlocked timestamp 29,6  √  null Date Account Locked
c_order dateacct timestamp 29,6 Accounting Date
c_rfqresponse dateinvited timestamp 29,6  √  null Date when (last) invitation was sent
ad_user datelastlogin timestamp 29,6  √  null Date Last Login
c_order dateordered timestamp 29,6 Date of Order
ad_user datepasswordchanged timestamp 29,6  √  null Date Password Changed
c_order dateprinted timestamp 29,6  √  null Date the document was printed.
c_order datepromised timestamp 29,6  √  null Date Order was promised
c_rfq dateresponse timestamp 29,6 Date of the Response
c_rfqresponse dateresponse timestamp 29,6  √  null Date of the Response
c_rfq dateworkcomplete timestamp 29,6  √  null Date when work is (planned to be) complete
c_rfqline dateworkcomplete timestamp 29,6  √  null Date when work is (planned to be) complete
c_rfqresponse dateworkcomplete timestamp 29,6  √  null Date when work is (planned to be) complete
c_rfqresponseline dateworkcomplete timestamp 29,6  √  null Date when work is (planned to be) complete
c_rfq dateworkstart timestamp 29,6  √  null Date when work is (planned to be) started
c_rfqline dateworkstart timestamp 29,6  √  null Date when work is (planned to be) started
c_rfqresponse dateworkstart timestamp 29,6  √  null Date when work is (planned to be) started
c_rfqresponseline dateworkstart timestamp 29,6  √  null Date when work is (planned to be) started
m_product discontinuedat timestamp 29,6  √  null Discontinued At indicates Date when product was discontinued
m_product discontinuedby timestamp 29,6  √  null
c_bpartner dunninggrace timestamp 29,6  √  null Dunning Grace Date
ad_user emailverifydate timestamp 29,6  √  null Date Email was verified
c_currency emuentrydate timestamp 29,6  √  null Date when the currency joined / will join the EMU
c_bpartner firstsale timestamp 29,6  √  null Date of First Sale
m_attributesetinstance guaranteedate timestamp 29,6  √  null Date when guarantee expires
ad_user lastcontact timestamp 29,6  √  null Date this individual was last contacted
c_rfq_topicsubscriber optoutdate timestamp 29,6  √  null Date the contact opted out
r_contactinterest optoutdate timestamp 29,6  √  null Date the contact opted out
c_rfq_topicsubscriber subscribedate timestamp 29,6  √  null Date the contact actively subscribed
r_contactinterest subscribedate timestamp 29,6  √  null Date the contact actively subscribed
ad_printformat updated timestamp 29,6 now() Date this record was updated
ad_user updated timestamp 29,6 now() Date this record was updated
c_bpartner updated timestamp 29,6 now() Date this record was updated
c_bpartner_location updated timestamp 29,6 now() Date this record was updated
c_bpartner_product updated timestamp 29,6 now() Date this record was updated
c_currency updated timestamp 29,6 now() Date this record was updated
c_order updated timestamp 29,6 now() Date this record was updated
c_rfq updated timestamp 29,6 now() Date this record was updated
c_rfq_topic updated timestamp 29,6 now() Date this record was updated
c_rfq_topicsubscriber updated timestamp 29,6 now() Date this record was updated
c_rfq_topicsubscriberonly updated timestamp 29,6 now() Date this record was updated
c_rfqline updated timestamp 29,6 now() Date this record was updated
c_rfqlineqty updated timestamp 29,6 now() Date this record was updated
c_rfqresponse updated timestamp 29,6 now() Date this record was updated
c_rfqresponseline updated timestamp 29,6 now() Date this record was updated
c_rfqresponselineqty updated timestamp 29,6 now() Date this record was updated
c_uom updated timestamp 29,6 now() Date this record was updated
m_attributesetinstance updated timestamp 29,6 now() Date this record was updated
m_pricelist updated timestamp 29,6 now() Date this record was updated
m_pricelist_version updated timestamp 29,6 now() Date this record was updated
m_product updated timestamp 29,6 now() Date this record was updated
m_product_category updated timestamp 29,6 now() Date this record was updated
r_contactinterest updated timestamp 29,6 now() Date this record was updated
m_pricelist_version validfrom timestamp 29,6 Valid from including this date (first day)
c_uom uomtype varchar 2  √  NULL::character varying UOM Type
c_uom x12de355 varchar 4 UOM EDI X12 Code
c_bpartner ad_language varchar 6  √  null Language for this entity
c_bpartner naics varchar 6  √  null Standard Industry Code or its successor NAIC - http://www.osha.gov/oshstats/sicser.html
c_currency cursymbol varchar 10  √  null Symbol of the currency (opt used for printing only)
ad_user leadsource varchar 10  √  NULL::character varying The source of this lead/opportunity
ad_user leadstatus varchar 10  √  NULL::character varying The status of this lead/opportunity in the sales cycle
c_uom uomsymbol varchar 10  √  null Symbol for a Unit of Measure
c_bpartner duns varchar 11  √  null Dun & Bradstreet Number
m_product classification varchar 12  √  null Classification for grouping
ad_user salt varchar 16  √  NULL::character varying Random data added to improve password hash effectiveness
m_product customstariffnumber varchar 20  √  null Customs Tariff Number, usually the HS-Code
c_bpartner poreference varchar 20  √  null Transaction Reference Number (Sales Order, Purchase Order) of your Business Partner
c_order poreference varchar 20  √  null Transaction Reference Number (Sales Order, Purchase Order) of your Business Partner
c_bpartner taxid varchar 20  √  null Tax Identification
ad_user userpin varchar 20  √  null User PIN
m_product versionno varchar 20  √  null Version Number
c_order documentno varchar 30 Document sequence number of the document
c_rfq documentno varchar 30 '.'::character varying Document sequence number of the document
c_bpartner_product manufacturer varchar 30  √  null Manufacturer of the Product
c_order promotioncode varchar 30  √  null User entered promotion code at sales time
m_product sku varchar 30  √  null Stock Keeping Unit
m_product upc varchar 30  √  null Bar Code (Universal Product Code or its superset European Article Number)
c_bpartner_product vendorcategory varchar 30  √  null Product Category of the Business Partner
c_bpartner_product vendorproductno varchar 30  √  null Product Key of the Business Partner
ad_printformat ad_printformat_uu varchar 36  √  NULL::character varying AD_PrintFormat_UU
ad_user ad_user_uu varchar 36  √  NULL::character varying AD_User_UU
c_bpartner_location c_bpartner_location_uu varchar 36  √  NULL::character varying C_BPartner_Location_UU
c_bpartner_product c_bpartner_product_uu varchar 36  √  NULL::character varying C_BPartner_Product_UU
c_bpartner c_bpartner_uu varchar 36  √  NULL::character varying C_BPartner_UU
c_currency c_currency_uu varchar 36  √  NULL::character varying C_Currency_UU
c_order c_order_uu varchar 36  √  NULL::character varying C_Order_UU
c_rfq_topic c_rfq_topic_uu varchar 36  √  NULL::character varying C_RfQ_Topic_UU
c_rfq_topicsubscriber c_rfq_topicsubscriber_uu varchar 36  √  NULL::character varying C_RfQ_TopicSubscriber_UU
c_rfq_topicsubscriberonly c_rfq_topicsubscriberonly_uu varchar 36  √  NULL::character varying C_RfQ_TopicSubscriberOnly_UU
c_rfq c_rfq_uu varchar 36  √  NULL::character varying C_RfQ_UU
c_rfqline c_rfqline_uu varchar 36  √  NULL::character varying C_RfQLine_UU
c_rfqlineqty c_rfqlineqty_uu varchar 36  √  NULL::character varying C_RfQLineQty_UU
c_rfqresponse c_rfqresponse_uu varchar 36  √  NULL::character varying C_RfQResponse_UU
c_rfqresponseline c_rfqresponseline_uu varchar 36  √  NULL::character varying C_RfQResponseLine_UU
c_rfqresponselineqty c_rfqresponselineqty_uu varchar 36  √  NULL::character varying C_RfQResponseLineQty_UU
c_uom c_uom_uu varchar 36  √  NULL::character varying C_UOM_UU
m_attributesetinstance m_attributesetinstance_uu varchar 36  √  NULL::character varying M_AttributeSetInstance_UU
m_pricelist m_pricelist_uu varchar 36  √  NULL::character varying M_PriceList_UU
m_pricelist_version m_pricelist_version_uu varchar 36  √  NULL::character varying M_PriceList_Version_UU
m_product_category m_product_category_uu varchar 36  √  NULL::character varying M_Product_Category_UU
m_product m_product_uu varchar 36  √  NULL::character varying M_Product_UU
r_contactinterest r_contactinterest_uu varchar 36  √  NULL::character varying R_ContactInterest_UU
ad_user emailverify varchar 40  √  null Verification information of EMail Address
ad_user fax varchar 40  √  null Facsimile number
c_bpartner_location fax varchar 40  √  null Facsimile number
c_bpartner_location isdn varchar 40  √  null ISDN or modem line
m_attributesetinstance lot varchar 40  √  null Lot number (alphanumeric)
ad_user phone varchar 40  √  null Identifies a telephone number
c_bpartner_location phone varchar 40  √  null Identifies a telephone number
ad_user phone2 varchar 40  √  null Identifies an alternate telephone number.
c_bpartner_location phone2 varchar 40  √  null Identifies an alternate telephone number.
ad_printformat printername varchar 40  √  null Name of the Printer
c_bpartner referenceno varchar 40  √  null Your customer or vendor number at the Business Partner's site
m_attributesetinstance serno varchar 40  √  null Product Serial Number
ad_user title varchar 40  √  null Name this entity is referred to as
ad_user value varchar 40  √  null Search key for the record in the format required - must be unique
c_bpartner value varchar 40 Search key for the record in the format required - must be unique
m_product value varchar 40 Search key for the record in the format required - must be unique
m_product_category value varchar 40 Search key for the record in the format required - must be unique
ad_user bpname varchar 60  √  NULL::character varying BP Name
c_bpartner_location customeraddressid varchar 60  √  NULL::character varying Customer Address ID
c_bpartner customerprofileid varchar 60  √  NULL::character varying Customer Profile ID
ad_user email varchar 60  √  null Electronic Mail Address
ad_user emailuser varchar 60  √  null User Name (ID) in the Mail System
ad_user ldapuser varchar 60  √  null User Name used for authorization via LDAP (directory) services
ad_printformat name varchar 60 Alphanumeric identifier of the entity
ad_user name varchar 60 Alphanumeric identifier of the entity
c_bpartner_location name varchar 60 Alphanumeric identifier of the entity
c_rfq name varchar 60 Alphanumeric identifier of the entity
c_rfq_topic name varchar 60 Alphanumeric identifier of the entity
c_rfqresponse name varchar 60 Alphanumeric identifier of the entity
c_uom name varchar 60 Alphanumeric identifier of the entity
m_pricelist name varchar 60 Alphanumeric identifier of the entity
m_pricelist_version name varchar 60 Alphanumeric identifier of the entity
m_product_category name varchar 60 Alphanumeric identifier of the entity
c_bpartner name2 varchar 60  √  null Additional Name
m_product descriptionurl varchar 120  √  null URL for the description
m_product downloadurl varchar 120  √  null
m_product imageurl varchar 120  √  null URL of image
c_bpartner name varchar 120 Alphanumeric identifier of the entity
c_bpartner url varchar 120  √  null Full URL address - e.g. http://www.idempiere.org
ad_printformat classname varchar 240  √  null Java Classname
ad_printformat description varchar 255  √  null Optional short description of the record
ad_user description varchar 255  √  null Optional short description of the record
c_bpartner description varchar 255  √  null Optional short description of the record
c_bpartner_product description varchar 255  √  null Optional short description of the record
c_currency description varchar 255 Optional short description of the record
c_order description varchar 255  √  null Optional short description of the record
c_rfq description varchar 255  √  null Optional short description of the record
c_rfq_topic description varchar 255  √  null Optional short description of the record
c_rfq_topicsubscriberonly description varchar 255  √  null Optional short description of the record
c_rfqline description varchar 255  √  null Optional short description of the record
c_rfqresponse description varchar 255  √  null Optional short description of the record
c_rfqresponseline description varchar 255  √  null Optional short description of the record
c_uom description varchar 255  √  null Optional short description of the record
m_attributesetinstance description varchar 255  √  null Optional short description of the record
m_pricelist description varchar 255  √  null Optional short description of the record
m_pricelist_version description varchar 255  √  null Optional short description of the record
m_product description varchar 255  √  null Optional short description of the record
m_product_category description varchar 255  √  null Optional short description of the record
ad_user emailuserpw varchar 255  √  null Password of your email user id
m_product group1 varchar 255  √  null Group1
m_product group2 varchar 255  √  null Group2
ad_user lastresult varchar 255  √  null Result of last contact
ad_user leadsourcedescription varchar 255  √  NULL::character varying Additional information on the source of this lead/opportunity
ad_user leadstatusdescription varchar 255  √  NULL::character varying Additional information on the status of this lead/opportunity
m_product name varchar 255 Alphanumeric identifier of the entity
c_bpartner so_description varchar 255  √  null Description to be used on orders
ad_printformat args varchar 510  √  null Args
c_order ordertype varchar 510  √  null Type of Order: MRP records grouped by source (Sales Order, Purchase Order, Distribution Order, Requisition)
ad_user answer varchar 1024  √  NULL::character varying Answer
ad_user password varchar 1024  √  null Password of any length (case sensitive)
ad_user securityquestion varchar 1024  √  null Security Question
ad_user comments varchar 2000  √  null Comments or additional information
m_product documentnote varchar 2000  √  null Additional information for a Document
c_rfq help varchar 2000  √  null Comment or Hint
c_rfqline help varchar 2000  √  null Comment or Hint
c_rfqresponse help varchar 2000  √  null Comment or Hint
c_rfqresponseline help varchar 2000  √  null Comment or Hint
m_product help varchar 2000  √  null Comment or Hint