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

idempiere9.adempiere contains 974 columns - click on heading to sort:
Table Column Type Size Nulls Auto Default
a_asset a_asset_class_id numeric 10  √  NULL::numeric Asset class
a_asset a_asset_createdate timestamp 29,6  √  null Create Date
a_asset_delivery a_asset_delivery_uu varchar 36  √  NULL::character varying A_Asset_Delivery_UU
r_request a_asset_id numeric 10  √  null Asset used internally or by customers
r_requestaction a_asset_id numeric 10  √  null Asset used internally or by customers
a_asset a_asset_revaldate timestamp 29,6  √  null Revaluation Date
a_asset a_asset_type_id numeric 10  √  null Asset Type
a_asset a_asset_uu varchar 36  √  NULL::character varying A_Asset_UU
a_asset a_parent_asset_id numeric 10  √  null Parent Asset
a_asset a_qty_current numeric 0  √  null Current Qty
a_asset a_qty_original numeric 0  √  null A_QTY_Original
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
ad_user ad_image_id numeric 10  √  NULL::numeric Image or Icon
c_bpartner ad_language varchar 6  √  null Language for this entity
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
m_inout ad_orgtrx_id numeric 10  √  null Performing or initiating organization
c_bp_group ad_printcolor_id numeric 10  √  null Color used for printing and display
r_request ad_role_id numeric 10  √  null Responsibility Role
r_requestaction ad_role_id numeric 10  √  null Responsibility Role
ad_role ad_role_uu varchar 36  √  NULL::character varying AD_Role_UU
ad_smtp ad_smtp_uu varchar 36  √  NULL::character varying AD_SMTP_UU
r_request ad_table_id numeric 10  √  null Database Table information
ad_table ad_table_uu varchar 36  √  NULL::character varying AD_Table_UU
ad_role ad_tree_menu_id numeric 10  √  null Tree of the menu
ad_role ad_tree_org_id numeric 10  √  null Trees are used for (financial) reporting and security access (via role)
a_asset ad_user_id numeric 10  √  null User within the system - Internal or Business Partner Contact
a_asset_delivery ad_user_id numeric 10  √  null User within the system - Internal or Business Partner Contact
m_inout ad_user_id numeric 10  √  null User within the system - Internal or Business Partner Contact
r_request ad_user_id numeric 10  √  null User within the system - Internal or Business Partner Contact
r_requestaction ad_user_id numeric 10  √  null User within the system - Internal or Business Partner Contact
ad_user ad_user_uu varchar 36  √  NULL::character varying AD_User_UU
ad_usermail ad_usermail_uu varchar 36  √  NULL::character varying AD_UserMail_UU
ad_table ad_val_rule_id numeric 10  √  null Dynamic Validation Rule
ad_table ad_window_id numeric 10  √  null Data entry or display window
m_rma amt numeric 0  √  null Amount
ad_role amtapproval numeric 0  √  0 The approval amount limit for this role
ad_role amtapprovalaccum numeric 0  √  null The approval amount limit for this role accumulated on a period
ad_user answer varchar 1024  √  NULL::character varying Answer
a_asset assetactivationdate timestamp 29,6  √  null Activation Date
a_asset assetdepreciationdate timestamp 29,6  √  null Date of last depreciation
a_asset assetdisposaldate timestamp 29,6  √  null Date when the asset is/was disposed
a_asset assetservicedate timestamp 29,6  √  null Date when Asset was put into service
r_requesttype autoduedatedays numeric 10  √  null Automatic Due Date Days
ad_user birthday timestamp 29,6  √  null Birthday or Anniversary day
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
ad_user bpname varchar 60  √  NULL::character varying BP Name
a_asset c_activity_id numeric 10  √  NULL::numeric Business Activity
m_inout c_activity_id numeric 10  √  null Business Activity
r_request c_activity_id numeric 10  √  null Business Activity
r_requestaction c_activity_id numeric 10  √  null Business Activity
c_activity c_activity_uu varchar 36  √  NULL::character varying C_Activity_UU
c_bp_group c_bp_group_uu varchar 36  √  NULL::character varying C_BP_Group_UU
a_asset c_bpartner_id numeric 10  √  null Identifies a Business Partner
ad_user c_bpartner_id numeric 10  √  null Identifies a Business Partner
m_rma c_bpartner_id numeric 10  √  null Identifies a Business Partner
r_request c_bpartner_id numeric 10  √  null Identifies a Business Partner
r_requestaction c_bpartner_id numeric 10  √  null Identifies a Business Partner
a_asset c_bpartner_location_id numeric 10  √  null Identifies the (ship to) address for this Business Partner
ad_user c_bpartner_location_id numeric 10  √  null Identifies the (ship to) address for this Business Partner
c_bpartner c_bpartner_uu varchar 36  √  NULL::character varying C_BPartner_UU
a_asset c_bpartnersr_id numeric 10  √  null Business Partner (Agent or Sales Rep)
ad_user c_campaign_id numeric 10  √  NULL::numeric Marketing Campaign
m_inout c_campaign_id numeric 10  √  null Marketing Campaign
r_request c_campaign_id numeric 10  √  null Marketing Campaign
m_inout c_charge_id numeric 10  √  null Additional document charges
ad_role c_currency_id numeric 10  √  null The Currency for this record
m_rma c_currency_id numeric 10  √  null The Currency for this record
c_bp_group c_dunning_id numeric 10  √  null Dunning Rules for overdue invoices
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
m_inout c_invoice_id numeric 10  √  null Invoice Identifier
r_request c_invoice_id numeric 10  √  null Invoice Identifier
r_requestaction c_invoice_id numeric 10  √  null Invoice Identifier
r_request c_invoicerequest_id numeric 10  √  null The generated invoice for this request
c_bpartner c_invoiceschedule_id numeric 10  √  null Schedule for generating Invoices
ad_user c_job_id numeric 10  √  null Job Position
a_asset c_location_id numeric 10  √  null Location or Address
ad_user c_location_id numeric 10  √  NULL::numeric Location or Address
m_inout c_order_id numeric 10  √  null Order
m_rma c_order_id numeric 10  √  null Order
r_request c_order_id numeric 10  √  null Order
r_requestaction c_order_id numeric 10  √  null Order
r_request c_payment_id numeric 10  √  null Payment identifier
r_requestaction c_payment_id numeric 10  √  null Payment identifier
c_bpartner c_paymentterm_id numeric 10  √  null The terms of Payment (timing, discount)
a_asset c_project_id numeric 10  √  null Financial Project
m_inout c_project_id numeric 10  √  null Financial Project
r_request c_project_id numeric 10  √  null Financial Project
r_requestaction c_project_id numeric 10  √  null Financial Project
m_product c_revenuerecognition_id numeric 10  √  null Method for recording revenue
m_product c_subscriptiontype_id numeric 10  √  null Type of subscription
c_bpartner c_taxgroup_id numeric 10  √  null Tax Group
m_inout chargeamt numeric 0  √  0 Charge Amount
m_product classification varchar 12  √  null Classification for grouping
r_request closedate timestamp 29,6  √  null Close Date
ad_user comments varchar 2000  √  null Comments or additional information
r_requestaction confidentialtype bpchar 1  √  null Type of Confidentiality
ad_role connectionprofile bpchar 1  √  null How a Java Client connects to the server(s)
ad_user connectionprofile bpchar 1  √  null How a Java Client connects to the server(s)
r_requesttype contentcolor varchar 7  √  NULL::character varying Content color of calendar dashlet
ad_table copycolumnsfromtable varchar 1  √  null Copy Columns From Table
ad_table copycomponentsfromview bpchar 1  √  NULL::bpchar Copy Components From View
m_product copyfrom bpchar 1  √  NULL::bpchar Copy From Record
m_inout createconfirm bpchar 1  √  null Create Confirm
m_inout createfrom bpchar 1  √  null Process which will generate a new document lines based on an existing document
m_rma createfrom bpchar 1  √  NULL::bpchar Process which will generate a new document lines based on an existing document
m_inout createpackage bpchar 1  √  null Create Package
ad_table createwindowfromtable bpchar 1  √  NULL::bpchar Create Window From Table
c_bp_group creditwatchpercent numeric 0  √  null Credit Watch - Percent of Credit Limit when OK switches to Watch
c_bpartner customerprofileid varchar 60  √  NULL::character varying Customer Profile ID
m_product customstariffnumber varchar 20  √  null Customs Tariff Number, usually the HS-Code
ad_table databaseviewdrop bpchar 1  √  NULL::bpchar Drop view
ad_user dateaccountlocked timestamp 29,6  √  null Date Account Locked
r_request datecompleteplan timestamp 29,6  √  null Planned Completion Date
r_requestaction datecompleteplan timestamp 29,6  √  null Planned Completion Date
r_request datelastaction timestamp 29,6  √  null Date this request was last acted on
r_request datelastalert timestamp 29,6  √  null Date when last alert were sent
ad_user datelastlogin timestamp 29,6  √  null Date Last Login
r_requestprocessor datelastrun timestamp 29,6  √  null Date the process was last run.
r_request datenextaction timestamp 29,6  √  null Date that this request should be acted on
r_requestaction datenextaction timestamp 29,6  √  null Date that this request should be acted on
r_requestprocessor datenextrun timestamp 29,6  √  null Date the process will run next
m_inout dateordered timestamp 29,6  √  null Date of Order
ad_user datepasswordchanged timestamp 29,6  √  null Date Password Changed
m_inout dateprinted timestamp 29,6  √  null Date the document was printed.
m_inout datereceived timestamp 29,6  √  null Date a product was received
r_request datestartplan timestamp 29,6  √  null Planned Start Date
r_requestaction datestartplan timestamp 29,6  √  null Planned Start Date
ad_role daysapprovalaccum numeric 10  √  null The days approval indicates the days to take into account to verify the accumulated approval amount.
c_bpartner default1099box_id numeric 10  √  NULL::numeric Default 1099 Box
a_asset_delivery deliveryconfirmation varchar 120  √  null EMail Delivery confirmation
ad_usermail deliveryconfirmation varchar 120  √  null EMail Delivery confirmation
c_bpartner deliveryrule bpchar 1  √  null Defines the timing of Delivery
c_bpartner deliveryviarule bpchar 1  √  null How the order will be delivered
a_asset description varchar 255  √  null Optional short description of the record
a_asset_delivery description varchar 255  √  null Optional short description of the record
ad_role description varchar 255  √  null Optional short description of the record
ad_table description varchar 255  √  null Optional short description of the record
ad_user description varchar 255  √  null Optional short description of the record
c_activity description varchar 255  √  null Optional short description of the record
c_bp_group description varchar 255  √  null Optional short description of the record
c_bpartner description varchar 255  √  null Optional short description of the record
m_changenotice description varchar 255  √  null Optional short description of the record
m_changerequest description varchar 255  √  null Optional short description of the record
m_inout description varchar 255  √  null Optional short description of the record
m_product description varchar 255  √  null Optional short description of the record
m_rma description varchar 255  √  null Optional short description of the record
r_category description varchar 255  √  null Optional short description of the record
r_group description varchar 255  √  null Optional short description of the record
r_interestarea description varchar 255  √  null Optional short description of the record
r_requestprocessor description varchar 255  √  null Optional short description of the record
r_requesttype description varchar 255  √  null Optional short description of the record
r_resolution description varchar 255  √  null Optional short description of the record
r_status description varchar 255  √  null Optional short description of the record
r_statuscategory description varchar 255  √  null Optional short description of the record
m_product descriptionurl varchar 120  √  null URL for the description
m_changenotice detailinfo text 2147483647  √  null Additional Detail Information
m_changerequest detailinfo text 2147483647  √  null Additional Detail Information
m_product discontinued bpchar 1  √  'N'::bpchar This product is no longer available
m_product discontinuedat timestamp 29,6  √  null Discontinued At indicates Date when product was discontinued
m_product discontinuedby timestamp 29,6  √  null
c_bpartner documentcopies numeric 10  √  null Number of copies to be printed
m_product documentnote varchar 2000  √  null Additional information for a Document
m_product downloadurl varchar 120  √  null
m_inout dropship_bpartner_id numeric 10  √  null Business Partner to ship to
m_inout dropship_location_id numeric 10  √  null Business Partner Location for shipping to
m_inout dropship_user_id numeric 10  √  null Business Partner Contact for drop shipment
c_bpartner dunninggrace timestamp 29,6  √  null Dunning Grace Date
c_bpartner duns varchar 11  √  null Dun & Bradstreet Number
a_asset_delivery email varchar 60  √  null Electronic Mail Address
ad_user email varchar 60  √  null Electronic Mail Address
ad_usermail emailfrom varchar 255  √  NULL::character varying EMail sent from
ad_smtp emailtest bpchar 1  √  NULL::bpchar Test EMail
ad_user emailuser varchar 60  √  null User Name (ID) in the Mail System
ad_user emailuserpw varchar 255  √  null Password of your email user id
ad_user emailverify varchar 40  √  null Verification information of EMail Address
ad_user emailverifydate timestamp 29,6  √  null Date Email was verified
r_requestaction enddate timestamp 29,6  √  null Last effective date (inclusive)
r_request endtime timestamp 29,6  √  null End of the time span
r_requestupdate endtime timestamp 29,6  √  null End of the time span
ad_user fax varchar 40  √  null Facsimile number
c_bpartner firstsale timestamp 29,6  √  null Date of First Sale
c_bpartner flatdiscount numeric 0  √  null Flat discount percentage
m_inout fob varchar 10  √  NULL::character varying Freight Terms
m_inout freightamt numeric 0  √  0 Freight Amount
m_inout freightcharges varchar 10  √  NULL::character varying Freight Charges
c_bpartner freightcostrule bpchar 1  √  null Method for charging Freight
r_requestprocessor frequency numeric 10  √  (1)::numeric Frequency of events
r_requestprocessor frequencytype bpchar 1  √  null Frequency of event
m_inout generateto bpchar 1  √  null Generate To
m_rma generateto bpchar 1  √  null Generate To
m_product group1 varchar 255  √  null Group1
m_product group2 varchar 255  √  null Group2
a_asset guaranteedate timestamp 29,6  √  null Date when guarantee expires
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
r_requesttype headercolor varchar 7  √  NULL::character varying Header color of calendar dashlet
a_asset help varchar 2000  √  null Comment or Hint
ad_table help varchar 2000  √  null Comment or Hint
c_activity help varchar 2000  √  null Comment or Hint
m_changenotice help varchar 2000  √  null Comment or Hint
m_changerequest help varchar 2000  √  null Comment or Hint
m_product help varchar 2000  √  null Comment or Hint
m_rma help varchar 2000  √  null Comment or Hint
r_category help varchar 2000  √  null Comment or Hint
r_group help varchar 2000  √  null Comment or Hint
r_resolution help varchar 2000  √  null Comment or Hint
r_status help varchar 2000  √  null Comment or Hint
r_statuscategory help varchar 2000  √  null Comment or Hint
m_product imageurl varchar 120  √  null URL of image
ad_table importtable bpchar 1  √  null Import Table Columns from Database
m_inout insurance bpchar 1  √  NULL::bpchar Insurance
a_asset inventoryno varchar 30  √  NULL::character varying Inventory No
c_bpartner invoice_printformat_id numeric 10  √  null Print Format for printing Invoices
c_bpartner invoicerule bpchar 1  √  null Frequency and method of invoicing
ad_role isaccessadvanced bpchar 1  √  'N'::bpchar Access Advanced
ad_table iscentrallymaintained bpchar 1  √  'Y'::bpchar Information maintained in System Element table
ad_usermail isdelivered bpchar 1  √  null Delivered
c_bpartner isdiscountprinted bpchar 1  √  'Y'::bpchar Print Discount on Invoice and Order
m_inout isdropship bpchar 1  √  'N'::bpchar Drop Shipments are sent directly to the Drop Shipment Location
r_requestaction isescalated bpchar 1  √  null This request has been escalated
r_requestaction isinvoiced bpchar 1  √  null Is this invoiced?
r_requesttype isinvoiced bpchar 1  √  null Is this invoiced?
c_bpartner 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
m_product isphantom bpchar 1  √  'N'::bpchar Phantom Component
r_requestaction isselfservice bpchar 1  √  null This is a Self-Service entry or this entry can be changed via Self-Service
c_bpartner istaxexempt bpchar 1  √  'N'::bpchar Business partner is exempt from tax on sales
m_product istoformule bpchar 1  √  null
r_requestprocessor_route keyword varchar 60  √  null Case insensitive keyword
ad_user lastcontact timestamp 29,6  √  null Date this individual was last contacted
a_asset lastmaintenancedate timestamp 29,6  √  null Last Maintenance Date
a_asset lastmaintenancenote varchar 60  √  null Last Maintenance Note
a_asset lastmaintenanceunit numeric 10  √  null Last Maintenance Unit
a_asset lastmaintenanceuseunit numeric 10  √  null
a_asset lastmaintenencedate timestamp 29,6  √  null
ad_user lastresult varchar 255  √  null Result of last contact
r_request lastresult varchar 2000  √  null Result of last contact
ad_user ldapuser varchar 60  √  null User Name used for authorization via LDAP (directory) services
ad_user leadsource varchar 10  √  NULL::character varying The source of this lead/opportunity
ad_user leadsourcedescription varchar 255  √  NULL::character varying Additional information on the source of this lead/opportunity
ad_user leadstatus varchar 10  √  NULL::character varying The status of this lead/opportunity in the sales cycle
ad_user leadstatusdescription varchar 255  √  NULL::character varying Additional information on the status of this lead/opportunity
a_asset lease_bpartner_id numeric 10  √  null The Business Partner who rents or leases
a_asset leaseterminationdate timestamp 29,6  √  null Lease Termination Date
a_asset lifeuseunits numeric 0  √  null Units of use until the asset is not usable anymore
ad_table loadseq numeric 10  √  null Sequence
a_asset locationcomment varchar 255  √  null Additional comments or remarks concerning the location
c_bpartner logo_id numeric 10  √  NULL::numeric Logo
a_asset lot varchar 255  √  null Lot number (alphanumeric)
a_asset_delivery lot varchar 40  √  null Lot number (alphanumeric)
m_product m_attributeset_id numeric 10  √  null Product Attribute Set
a_asset m_attributesetinstance_id numeric 10  √  0 Product Attribute Set Instance
m_product m_attributesetinstance_id numeric 10  √  0 Product Attribute Set Instance
r_group m_bom_id numeric 10  √  null
m_changerequest m_changenotice_id numeric 10  √  null Bill of Materials (Engineering) Change Notice (Version)
r_group m_changenotice_id numeric 10  √  null Bill of Materials (Engineering) Change Notice (Version)
m_changenotice m_changenotice_uu varchar 36  √  NULL::character varying M_ChangeNotice_UU
r_request m_changerequest_id numeric 10  √  null BOM (Engineering) Change Request
m_changerequest m_changerequest_uu varchar 36  √  NULL::character varying M_ChangeRequest_UU
c_bp_group m_discountschema_id numeric 10  √  null Schema to calculate the trade discount percentage
c_bpartner m_discountschema_id numeric 10  √  null Schema to calculate the trade discount percentage
m_changerequest m_fixchangenotice_id numeric 10  √  null Fixed in Change Notice
r_request m_fixchangenotice_id numeric 10  √  null Fixed in Change Notice
m_product m_freightcategory_id numeric 10  √  null Category of the Freight
r_request m_inout_id numeric 10  √  null Material Shipment Document
r_requestaction m_inout_id numeric 10  √  null Material Shipment Document
m_inout m_inout_uu varchar 36  √  NULL::character varying M_InOut_UU
a_asset m_inoutline_id numeric 10  √  null Line on Shipment or Receipt document
a_asset_delivery m_inoutline_id numeric 10  √  null Line on Shipment or Receipt document
a_asset m_locator_id numeric 10  √  null Warehouse Locator
m_product m_locator_id numeric 10  √  null Warehouse Locator
m_product m_parttype_id numeric 10  √  NULL::numeric Part Type
c_bp_group m_pricelist_id numeric 10  √  null Unique identifier of a Price List
c_bpartner m_pricelist_id numeric 10  √  null Unique identifier of a Price List
r_category m_product_id numeric 10  √  null Product, Service, Item
r_request m_product_id numeric 10  √  null Product, Service, Item
r_requestaction m_product_id numeric 10  √  null Product, Service, Item
m_product m_product_uu varchar 36  √  NULL::character varying M_Product_UU
a_asset_delivery m_productdownload_id numeric 10  √  null Product downloads
r_request m_productspent_id numeric 10  √  null Product/Resource/Service used in Request
r_requestaction m_productspent_id numeric 10  √  null Product/Resource/Service used in Request
r_requestupdate m_productspent_id numeric 10  √  null Product/Resource/Service used in Request
m_inout m_rma_id numeric 10  √  null Return Material Authorization
r_request m_rma_id numeric 10  √  null Return Material Authorization
r_requestaction m_rma_id numeric 10  √  null Return Material Authorization
m_rma m_rma_uu varchar 36  √  NULL::character varying M_RMA_UU
m_rma m_rmatype_id numeric 10  √  null Return Material Authorization Type
m_inout m_shipper_id numeric 10  √  null Method or manner of product delivery
r_mailtext mailheader varchar 2000  √  null Mail Header (Subject)
ad_usermail mailtext varchar 2000  √  null Text used for Mail message
r_mailtext mailtext2 varchar 2000  √  null Optional second text part used for Mail message
r_mailtext mailtext3 varchar 2000  √  null Optional third text part used for Mail message
a_asset manufacturedyear numeric 10  √  NULL::numeric Manufactured Year
a_asset manufacturer varchar 30  √  NULL::character varying Manufacturer of the Product
a_asset_delivery messageid varchar 120  √  null EMail Message ID
ad_usermail messageid varchar 120  √  null EMail Message ID
c_bpartner naics varchar 6  √  null Standard Industry Code or its successor NAIC - http://www.osha.gov/oshstats/sicser.html
c_bpartner name2 varchar 60  √  null Additional Name
r_status next_status_id numeric 10  √  null Move to next status automatically after timeout
r_request nextaction bpchar 1  √  null Next Action to be taken
a_asset nextmaintenanceuseunit numeric 10  √  null
a_asset nextmaintenencedate timestamp 29,6  √  null Next Maintenence Date
a_asset nextmaintenenceunit numeric 10  √  null Next Maintenence Unit
m_inout nopackages numeric 10  √  (1)::numeric Number of packages shipped
r_requestaction nullcolumns varchar 255  √  null Columns with NULL value
c_bpartner numberemployees numeric 10  √  null Number of employees
r_contactinterest optoutdate timestamp 29,6  √  null Date the contact opted out
ad_user password varchar 1024  √  null Password of any length (case sensitive)
c_bpartner paymentrule bpchar 1  √  null How you pay the invoice
c_bpartner paymentrulepo bpchar 1  √  null Purchase payment option
ad_user phone varchar 40  √  null Identifies a telephone number
ad_user phone2 varchar 40  √  null Identifies an alternate telephone number.
m_inout pickdate timestamp 29,6  √  null Date/Time when picked for Shipment
c_bp_group po_discountschema_id numeric 10  √  null Schema to calculate the purchase trade discount percentage
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_bp_group po_pricelist_id numeric 10  √  null Price List used by this Business Partner
c_bpartner po_pricelist_id numeric 10  √  null Price List used by this Business Partner
ad_table po_window_id numeric 10  √  null Purchase Order Window
c_bpartner poreference varchar 20  √  null Transaction Reference Number (Sales Order, Purchase Order) of your Business Partner
m_inout poreference varchar 20  √  null Transaction Reference Number (Sales Order, Purchase Order) of your Business Partner
c_bpartner potentiallifetimevalue numeric 0  √  0 Total Revenue expected
m_changerequest pp_product_bom_id numeric 10  √  null BOM & Formula
r_group pp_product_bom_id numeric 10  √  null BOM & Formula
c_bp_group pricematchtolerance numeric 0  √  null PO-Invoice Match Price Tolerance in percent of the purchase price
r_requestaction priority bpchar 1  √  null Indicates if this request is of a high, medium or low priority.
c_bp_group prioritybase bpchar 1  √  null Base of Priority
r_request priorityuser bpchar 1  √  null Priority of the issue for the User
r_requestaction priorityuser bpchar 1  √  null Priority of the issue for the User
m_inout processedon numeric 0  √  null The date+time (expressed in decimal format) when the document has been processed
a_asset processing bpchar 1  √  'N'::bpchar Process Now
ad_table processing bpchar 1  √  NULL::bpchar Process Now
ad_user processing bpchar 1  √  null Process Now
m_changenotice processing bpchar 1  √  null Process Now
m_inout processing bpchar 1  √  null Process Now
m_product processing bpchar 1  √  null Process Now
m_rma processing bpchar 1  √  null Process Now
r_requestprocessor processing bpchar 1  √  null Process Now
a_asset qty numeric 0  √  null Quantity
r_request qtyinvoiced numeric 0  √  0 Invoiced Quantity
r_requestaction qtyinvoiced numeric 0  √  null Invoiced Quantity
r_requestupdate qtyinvoiced numeric 0  √  0 Invoiced Quantity
r_request qtyplan numeric 0  √  null Planned Quantity
r_requestaction qtyplan numeric 0  √  null Planned Quantity
r_request qtyspent numeric 0  √  0 Quantity used for this event
r_requestaction qtyspent numeric 0  √  null Quantity used for this event
r_requestupdate qtyspent numeric 0  √  0 Quantity used for this event
r_request r_category_id numeric 10  √  null Request Category
r_requestaction r_category_id numeric 10  √  null Request Category
r_category r_category_uu varchar 36  √  NULL::character varying R_Category_UU
r_categoryupdates r_categoryupdates_uu varchar 36  √  NULL::character varying R_CategoryUpdates_UU
r_contactinterest r_contactinterest_uu varchar 36  √  NULL::character varying R_ContactInterest_UU
ad_user r_defaultmailtext_id numeric 10  √  NULL::numeric Default mail template
r_request r_group_id numeric 10  √  null Request Group
r_requestaction r_group_id numeric 10  √  null Request Group
r_group r_group_uu varchar 36  √  NULL::character varying R_Group_UU
r_groupupdates r_groupupdates_uu varchar 36  √  NULL::character varying R_GroupUpdates_UU
r_interestarea r_interestarea_uu varchar 36  √  NULL::character varying R_InterestArea_UU
ad_usermail r_mailtext_id numeric 10  √  null Text templates for mailings
m_product r_mailtext_id numeric 10  √  null Text templates for mailings
r_request r_mailtext_id numeric 10  √  null Text templates for mailings
r_mailtext r_mailtext_uu varchar 36  √  NULL::character varying R_MailText_UU
r_request r_request_uu varchar 36  √  NULL::character varying R_Request_UU
r_requestaction r_requestaction_uu varchar 36  √  NULL::character varying R_RequestAction_UU
r_requestprocessor_route r_requestprocessor_route_uu varchar 36  √  NULL::character varying R_RequestProcessor_Route_UU
r_requestprocessor r_requestprocessor_uu varchar 36  √  NULL::character varying R_RequestProcessor_UU
r_request r_requestrelated_id numeric 10  √  null Related Request (Master Issue, ..)
r_requestaction r_requesttype_id numeric 10  √  null Type of request (e.g. Inquiry, Complaint, ..)
r_requestprocessor r_requesttype_id numeric 10  √  null Type of request (e.g. Inquiry, Complaint, ..)
r_requestprocessor_route r_requesttype_id numeric 10  √  null Type of request (e.g. Inquiry, Complaint, ..)
r_requesttype r_requesttype_uu varchar 36  √  NULL::character varying R_RequestType_UU
r_requesttypeupdates r_requesttypeupdates_uu varchar 36  √  NULL::character varying R_RequestTypeUpdates_UU
r_requestupdate r_requestupdate_uu varchar 36  √  NULL::character varying R_RequestUpdate_UU
r_requestupdates r_requestupdates_uu varchar 36  √  NULL::character varying R_RequestUpdates_UU
r_request r_resolution_id numeric 10  √  null Request Resolution
r_requestaction r_resolution_id numeric 10  √  null Request Resolution
r_resolution r_resolution_uu varchar 36  √  NULL::character varying R_Resolution_UU
r_request r_standardresponse_id numeric 10  √  null Request Standard Response
r_standardresponse r_standardresponse_uu varchar 36  √  NULL::character varying R_StandardResponse_UU
r_request r_status_id numeric 10  √  null Request Status
r_requestaction r_status_id numeric 10  √  null Request Status
r_status r_status_uu varchar 36  √  NULL::character varying R_Status_UU
r_statuscategory r_statuscategory_uu varchar 36  √  NULL::character varying R_StatusCategory_UU
c_bpartner rating bpchar 1  √  null Classification or Importance
ad_usermail recipientbcc varchar 2000  √  null Bcc
ad_usermail recipientcc varchar 2000  √  null Cc
ad_usermail recipientto varchar 2000  √  NULL::character varying To
r_request record_id numeric 10  √  null Direct internal record ID
m_inout ref_inout_id numeric 10  √  null Referenced Shipment
m_rma ref_rma_id numeric 10  √  NULL::numeric Referenced RMA
c_bpartner referenceno varchar 40  √  null Your customer or vendor number at the Business Partner's site
a_asset_delivery referrer varchar 255  √  null Referring web address
a_asset_delivery remote_addr varchar 60  √  null Remote Address
a_asset_delivery remote_host varchar 60  √  null Remote host Info
ad_smtp requestuser varchar 60  √  NULL::character varying User Name (ID) of the email owner
ad_smtp requestuserpw varchar 255  √  NULL::character varying Password of the user name (ID) for mail processing
r_request result varchar 2000  √  null Result of the action taken
r_requestupdate result varchar 2000  √  null Result of the action taken
m_inout returnbpartner_id numeric 10  √  NULL::numeric Return Partner
m_inout returnlocation_id numeric 10  √  NULL::numeric Return Location
m_inout returnuser_id numeric 10  √  NULL::numeric Return User/Contact
m_inout reversal_id numeric 10  √  null ID of document reversal
ad_role roletype varchar 2  √  NULL::character varying Role Type
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
m_inout salesrep_id numeric 10  √  null Sales Representative or Company Agent
m_product salesrep_id numeric 10  √  null Sales Representative or Company Agent
r_requestaction salesrep_id numeric 10  √  null Sales Representative or Company Agent
c_bpartner salesvolume numeric 10  √  null Total Volume of Sales in Thousands of Currency
ad_user salt varchar 16  √  NULL::character varying Random data added to improve password hash effectiveness
ad_user securityquestion varchar 1024  √  null Security Question
a_asset serno varchar 255  √  null Product Serial Number
a_asset_delivery serno varchar 40  √  null Product Serial Number
c_bpartner shareofcustomer numeric 10  √  null Share of Customer's business as a percentage
m_product shelfdepth numeric 10  √  null Shelf depth required
m_product shelfheight numeric 0  √  null Shelf height required
c_bpartner shelflifeminpct numeric 10  √  null Minimum Shelf Life in percent based on Product Instance Guarantee Date
m_product shelfwidth numeric 10  √  null Shelf width required
m_inout shipdate timestamp 29,6  √  null Shipment Date/Time
m_inout shipperaccount varchar 40  √  NULL::character varying Shipper Account Number
m_product sku varchar 30  √  null Stock Keeping Unit
ad_smtp smtphost varchar 60  √  NULL::character varying Hostname of Mail Server for SMTP and IMAP
ad_smtp smtpport numeric 10  √  NULL::numeric SMTP Port Number
c_bpartner so_creditlimit numeric 0  √  0 Total outstanding invoice amounts allowed
c_bpartner so_creditused numeric 0  √  0 Current open balance
c_bpartner so_description varchar 255  √  null Description to be used on orders
c_bpartner socreditstatus bpchar 1  √  'O'::bpchar Business Partner Credit Status
r_request startdate timestamp 29,6  √  null First effective day (inclusive)
r_requestaction startdate timestamp 29,6  √  null First effective day (inclusive)
r_request starttime timestamp 29,6  √  null Time started
r_requestupdate starttime timestamp 29,6  √  null Time started
ad_usermail subject varchar 255  √  null Email Message Subject
r_contactinterest subscribedate timestamp 29,6  √  null Date the contact actively subscribed
r_requestaction summary varchar 2000  √  null Textual summary of this request
ad_role supervisor_id numeric 10  √  null Supervisor for this user/organization - used for escalation and approval
ad_user supervisor_id numeric 10  √  null Supervisor for this user/organization - used for escalation and approval
r_request taskstatus bpchar 1  √  null Status of the Task
r_requestaction taskstatus bpchar 1  √  null Status of the Task
c_bpartner taxid varchar 20  √  null Tax Identification
r_status timeoutdays numeric 10  √  null Timeout in Days to change Status automatically
ad_user title varchar 40  √  null Name this entity is referred to as
c_bpartner totalopenbalance numeric 0  √  null Total Open Balance Amount in primary Accounting Currency
m_inout trackingno varchar 60  √  null Number to track the shipment
m_product unitsperpallet numeric 0  √  null Units Per Pallet
m_product upc varchar 30  √  null Bar Code (Universal Product Code or its superset European Article Number)
r_status update_status_id numeric 10  √  null Automatically change the status after entry from web
a_asset_delivery url varchar 120  √  null Full URL address - e.g. http://www.idempiere.org
c_bpartner url varchar 120  √  null Full URL address - e.g. http://www.idempiere.org
ad_smtp usedbyemailordomain varchar 255  √  NULL::character varying Used by email or domain
a_asset uselifemonths numeric 10  √  null Months of the usable life of the asset
a_asset uselifeyears numeric 10  √  null Years of the usable life of the asset
m_inout user1_id numeric 10  √  null User defined list element #1
m_inout user2_id numeric 10  √  null User defined list element #2
ad_role userdiscount numeric 22,2  √  null UserDiscount
ad_user userpin varchar 20  √  null User PIN
a_asset useunits numeric 0  √  null Currently used units of the assets
ad_user value varchar 40  √  null Search key for the record in the format required - must be unique
a_asset versionno varchar 20  √  null Version Number
a_asset_delivery versionno varchar 20  √  null Version Number
m_product versionno varchar 20  √  null Version Number
m_inout volume numeric 0  √  null Volume of a product
m_product volume numeric 0  √  0 Volume of a product
ad_usermail w_mailmsg_id numeric 10  √  null Web Store Mail Message Template
m_inout weight numeric 0  √  null Weight of a product
m_product weight numeric 0  √  0 Weight of a product
a_asset a_asset_action varchar 2 'MD'::character varying Asset Action
a_asset_delivery a_asset_delivery_id numeric 10 Delivery of Asset
a_asset a_asset_group_id numeric 10 Group of Assets
a_asset a_asset_id numeric 10 Asset used internally or by customers
a_asset_delivery a_asset_id numeric 10 Asset used internally or by customers
a_asset a_asset_status varchar 2 'NW'::character varying Asset Status
a_asset a_assettype varchar 3 'MFX'::character varying Asset Type
ad_table accesslevel bpchar 1 Access Level required
a_asset ad_client_id numeric 10 Client/Tenant for this installation.
a_asset_delivery ad_client_id numeric 10 Client/Tenant for this installation.
ad_role ad_client_id numeric 10 Client/Tenant for this installation.
ad_smtp ad_client_id numeric 10 Client/Tenant for this installation.
ad_table ad_client_id numeric 10 Client/Tenant for this installation.
ad_user ad_client_id numeric 10 Client/Tenant for this installation.
ad_usermail ad_client_id numeric 10 Client/Tenant for this installation.
c_activity ad_client_id numeric 10 Client/Tenant for this installation.
c_bp_group ad_client_id numeric 10 Client/Tenant for this installation.
c_bpartner ad_client_id numeric 10 Client/Tenant for this installation.
m_changenotice ad_client_id numeric 10 Client/Tenant for this installation.
m_changerequest ad_client_id numeric 10 Client/Tenant for this installation.
m_inout ad_client_id numeric 10 Client/Tenant for this installation.
m_product ad_client_id numeric 10 Client/Tenant for this installation.
m_rma ad_client_id numeric 10 Client/Tenant for this installation.
r_category ad_client_id numeric 10 Client/Tenant for this installation.
r_categoryupdates ad_client_id numeric 10 Client/Tenant for this installation.
r_contactinterest ad_client_id numeric 10 Client/Tenant for this installation.
r_group ad_client_id numeric 10 Client/Tenant for this installation.
r_groupupdates ad_client_id numeric 10 Client/Tenant for this installation.
r_interestarea ad_client_id numeric 10 Client/Tenant for this installation.
r_mailtext ad_client_id numeric 10 Client/Tenant for this installation.
r_request ad_client_id numeric 10 Client/Tenant for this installation.
r_requestaction ad_client_id numeric 10 Client/Tenant for this installation.
r_requestprocessor ad_client_id numeric 10 Client/Tenant for this installation.
r_requestprocessor_route ad_client_id numeric 10 Client/Tenant for this installation.
r_requesttype ad_client_id numeric 10 Client/Tenant for this installation.
r_requesttypeupdates ad_client_id numeric 10 Client/Tenant for this installation.
r_requestupdate ad_client_id numeric 10 Client/Tenant for this installation.
r_requestupdates ad_client_id numeric 10 Client/Tenant for this installation.
r_resolution ad_client_id numeric 10 Client/Tenant for this installation.
r_standardresponse ad_client_id numeric 10 Client/Tenant for this installation.
r_status ad_client_id numeric 10 Client/Tenant for this installation.
r_statuscategory ad_client_id numeric 10 Client/Tenant for this installation.
a_asset ad_org_id numeric 10 Organizational entity within client
a_asset_delivery ad_org_id numeric 10 Organizational entity within client
ad_role ad_org_id numeric 10 Organizational entity within client
ad_smtp ad_org_id numeric 10 0 Organizational entity within client
ad_table ad_org_id numeric 10 Organizational entity within client
ad_user ad_org_id numeric 10 Organizational entity within client
ad_usermail ad_org_id numeric 10 Organizational entity within client
c_activity ad_org_id numeric 10 Organizational entity within client
c_bp_group ad_org_id numeric 10 Organizational entity within client
c_bpartner ad_org_id numeric 10 Organizational entity within client
m_changenotice ad_org_id numeric 10 Organizational entity within client
m_changerequest ad_org_id numeric 10 Organizational entity within client
m_inout ad_org_id numeric 10 Organizational entity within client
m_product ad_org_id numeric 10 Organizational entity within client
m_rma ad_org_id numeric 10 Organizational entity within client
r_category ad_org_id numeric 10 Organizational entity within client
r_categoryupdates ad_org_id numeric 10 Organizational entity within client
r_contactinterest ad_org_id numeric 10 Organizational entity within client
r_group ad_org_id numeric 10 Organizational entity within client
r_groupupdates ad_org_id numeric 10 Organizational entity within client
r_interestarea ad_org_id numeric 10 Organizational entity within client
r_mailtext ad_org_id numeric 10 Organizational entity within client
r_request ad_org_id numeric 10 Organizational entity within client
r_requestaction ad_org_id numeric 10 Organizational entity within client
r_requestprocessor ad_org_id numeric 10 Organizational entity within client
r_requestprocessor_route ad_org_id numeric 10 Organizational entity within client
r_requesttype ad_org_id numeric 10 Organizational entity within client
r_requesttypeupdates ad_org_id numeric 10 Organizational entity within client
r_requestupdate ad_org_id numeric 10 Organizational entity within client
r_requestupdates ad_org_id numeric 10 Organizational entity within client
r_resolution ad_org_id numeric 10 Organizational entity within client
r_standardresponse ad_org_id numeric 10 Organizational entity within client
r_status ad_org_id numeric 10 Organizational entity within client
r_statuscategory ad_org_id numeric 10 Organizational entity within client
ad_role ad_role_id numeric 10 Responsibility Role
r_requestprocessor ad_schedule_id numeric 10 NULL::numeric Schedule
ad_smtp ad_smtp_id numeric 10 SMTP Server
ad_table ad_table_id numeric 10 Database Table information
ad_user ad_user_id numeric 10 User within the system - Internal or Business Partner Contact
ad_usermail ad_user_id numeric 10 User within the system - Internal or Business Partner Contact
r_categoryupdates ad_user_id numeric 10 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
r_groupupdates ad_user_id numeric 10 User within the system - Internal or Business Partner Contact
r_requestprocessor_route ad_user_id numeric 10 User within the system - Internal or Business Partner Contact
r_requesttypeupdates ad_user_id numeric 10 User within the system - Internal or Business Partner Contact
r_requestupdates ad_user_id numeric 10 User within the system - Internal or Business Partner Contact
ad_usermail ad_usermail_id numeric 10 Mail sent to the user
ad_role allow_info_account bpchar 1 'Y'::bpchar Allow Info Account
ad_role allow_info_asset bpchar 1 'Y'::bpchar Allow Info Asset
ad_role allow_info_bpartner bpchar 1 'Y'::bpchar Allow Info BPartner
ad_role allow_info_cashjournal bpchar 1 'N'::bpchar Allow Info CashJournal
ad_role allow_info_crp bpchar 1 'N'::bpchar Allow Info CRP
ad_role allow_info_inout bpchar 1 'Y'::bpchar Allow Info InOut
ad_role allow_info_invoice bpchar 1 'Y'::bpchar Allow Info Invoice
ad_role allow_info_mrp bpchar 1 'N'::bpchar Allow Info MRP
ad_role allow_info_order bpchar 1 'Y'::bpchar Allow Info Order
ad_role allow_info_payment bpchar 1 'Y'::bpchar Allow Info Payment
ad_role allow_info_product bpchar 1 'Y'::bpchar Allow Info Product
ad_role allow_info_resource bpchar 1 'Y'::bpchar Allow Info Resource
ad_role allow_info_schedule bpchar 1 'Y'::bpchar Allow Info Schedule
c_activity c_activity_id numeric 10 Business Activity
c_bp_group c_bp_group_id numeric 10 Business Partner Group
c_bpartner c_bp_group_id numeric 10 Business Partner Group
c_bpartner c_bpartner_id numeric 10 Identifies a Business Partner
m_inout c_bpartner_id numeric 10 Identifies a Business Partner
m_inout c_bpartner_location_id numeric 10 Identifies the (ship to) address for this Business Partner
m_inout c_doctype_id numeric 10 Document type or rules
m_rma c_doctype_id numeric 10 Document type or rules
m_product c_taxcategory_id numeric 10 Tax Category
m_product c_uom_id numeric 10 Unit of Measure
r_request confidentialtype bpchar 1 'C'::bpchar Type of Confidentiality
r_requesttype confidentialtype bpchar 1 'C'::bpchar Type of Confidentiality
r_request confidentialtypeentry bpchar 1 Confidentiality of the individual entry
r_requestupdate confidentialtypeentry bpchar 1 Confidentiality of the individual entry
ad_role confirmqueryrecords numeric 10 0 Require Confirmation if more records will be returned by the query (If not defined 500)
a_asset created timestamp 29,6 now() Date this record was created
a_asset_delivery created timestamp 29,6 now() Date this record was created
ad_role created timestamp 29,6 now() Date this record was created
ad_smtp created timestamp 29,6 statement_timestamp() Date this record was created
ad_table created timestamp 29,6 now() Date this record was created
ad_user created timestamp 29,6 now() Date this record was created
ad_usermail created timestamp 29,6 now() Date this record was created
c_activity created timestamp 29,6 now() Date this record was created
c_bp_group created timestamp 29,6 now() Date this record was created
c_bpartner created timestamp 29,6 now() Date this record was created
m_changenotice created timestamp 29,6 now() Date this record was created
m_changerequest created timestamp 29,6 now() Date this record was created
m_inout created timestamp 29,6 now() Date this record was created
m_product created timestamp 29,6 now() Date this record was created
m_rma created timestamp 29,6 now() Date this record was created
r_category created timestamp 29,6 now() Date this record was created
r_categoryupdates created timestamp 29,6 now() Date this record was created
r_contactinterest created timestamp 29,6 now() Date this record was created
r_group created timestamp 29,6 now() Date this record was created
r_groupupdates created timestamp 29,6 now() Date this record was created
r_interestarea created timestamp 29,6 now() Date this record was created
r_mailtext created timestamp 29,6 now() Date this record was created
r_request created timestamp 29,6 now() Date this record was created
r_requestaction created timestamp 29,6 now() Date this record was created
r_requestprocessor created timestamp 29,6 now() Date this record was created
r_requestprocessor_route created timestamp 29,6 now() Date this record was created
r_requesttype created timestamp 29,6 now() Date this record was created
r_requesttypeupdates created timestamp 29,6 now() Date this record was created
r_requestupdate created timestamp 29,6 now() Date this record was created
r_requestupdates created timestamp 29,6 now() Date this record was created
r_resolution created timestamp 29,6 now() Date this record was created
r_standardresponse created timestamp 29,6 now() Date this record was created
r_status created timestamp 29,6 now() Date this record was created
r_statuscategory created timestamp 29,6 now() Date this record was created
a_asset createdby numeric 10 User who created this records
a_asset_delivery createdby numeric 10 User who created this records
ad_role createdby numeric 10 User who created this records
ad_smtp createdby numeric 10 User who created this records
ad_table createdby numeric 10 User who created this records
ad_user createdby numeric 10 User who created this records
ad_usermail createdby numeric 10 User who created this records
c_activity createdby numeric 10 User who created this records
c_bp_group createdby numeric 10 User who created this records
c_bpartner createdby numeric 10 User who created this records
m_changenotice createdby numeric 10 User who created this records
m_changerequest createdby numeric 10 User who created this records
m_inout createdby numeric 10 User who created this records
m_product createdby numeric 10 User who created this records
m_rma createdby numeric 10 User who created this records
r_category createdby numeric 10 User who created this records
r_categoryupdates createdby numeric 10 User who created this records
r_contactinterest createdby numeric 10 User who created this records
r_group createdby numeric 10 User who created this records
r_groupupdates createdby numeric 10 User who created this records
r_interestarea createdby numeric 10 User who created this records
r_mailtext createdby numeric 10 User who created this records
r_request createdby numeric 10 User who created this records
r_requestaction createdby numeric 10 User who created this records
r_requestprocessor createdby numeric 10 User who created this records
r_requestprocessor_route createdby numeric 10 User who created this records
r_requesttype createdby numeric 10 User who created this records
r_requesttypeupdates createdby numeric 10 User who created this records
r_requestupdate createdby numeric 10 User who created this records
r_requestupdates createdby numeric 10 User who created this records
r_resolution createdby numeric 10 User who created this records
r_standardresponse createdby numeric 10 User who created this records
r_status createdby numeric 10 User who created this records
r_statuscategory createdby numeric 10 User who created this records
m_inout dateacct timestamp 29,6 Accounting Date
m_inout deliveryrule bpchar 1 Defines the timing of Delivery
m_inout deliveryviarule bpchar 1 How the order will be delivered
m_inout docaction bpchar 2 The targeted status of the document
m_rma docaction bpchar 2 The targeted status of the document
m_inout docstatus bpchar 2 The current status of the document
m_rma docstatus bpchar 2 The current status of the document
m_changerequest documentno varchar 30 Document sequence number of the document
m_inout documentno varchar 30 Document sequence number of the document
m_rma documentno varchar 30 Document sequence number of the document
r_request documentno varchar 30 Document sequence number of the document
r_requesttype duedatetolerance numeric 10 7 Tolerance in days between the Date Next Action and the date the request is regarded as overdue
r_request duetype bpchar 1 Status of the next action for this Request
ad_table entitytype varchar 40 'D'::character varying Dictionary Entity Type; Determines ownership and synchronization
ad_user failedlogincount numeric 10 (0)::numeric Failed Login Count
m_inout freightcostrule bpchar 1 Method for charging Freight
r_requestprocessor inactivityalertdays numeric 10 0 Send Alert when there is no activity after days (0= no alert)
m_rma inout_id numeric 10 MaterialShipment Document
c_bpartner is1099vendor bpchar 1 'N'::bpchar 1099 Vendor
ad_role isaccessallorgs bpchar 1 'N'::bpchar Access all Organizations (no org access control) of the client
a_asset isactive bpchar 1 'Y'::bpchar The record is active in the system
a_asset_delivery isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_role isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_smtp isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_table 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
ad_usermail isactive bpchar 1 'Y'::bpchar The record is active in the system
c_activity isactive bpchar 1 'Y'::bpchar The record is active in the system
c_bp_group 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
m_changenotice isactive bpchar 1 'Y'::bpchar The record is active in the system
m_changerequest isactive bpchar 1 'Y'::bpchar The record is active in the system
m_inout 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_rma isactive bpchar 1 'Y'::bpchar The record is active in the system
r_category isactive bpchar 1 'Y'::bpchar The record is active in the system
r_categoryupdates 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
r_group isactive bpchar 1 'Y'::bpchar The record is active in the system
r_groupupdates isactive bpchar 1 'Y'::bpchar The record is active in the system
r_interestarea isactive bpchar 1 'Y'::bpchar The record is active in the system
r_mailtext isactive bpchar 1 'Y'::bpchar The record is active in the system
r_request isactive bpchar 1 'Y'::bpchar The record is active in the system
r_requestaction isactive bpchar 1 'Y'::bpchar The record is active in the system
r_requestprocessor isactive bpchar 1 'Y'::bpchar The record is active in the system
r_requestprocessor_route isactive bpchar 1 'Y'::bpchar The record is active in the system
r_requesttype isactive bpchar 1 'Y'::bpchar The record is active in the system
r_requesttypeupdates isactive bpchar 1 'Y'::bpchar The record is active in the system
r_requestupdate isactive bpchar 1 'Y'::bpchar The record is active in the system
r_requestupdates isactive bpchar 1 'Y'::bpchar The record is active in the system
r_resolution isactive bpchar 1 'Y'::bpchar The record is active in the system
r_standardresponse isactive bpchar 1 'Y'::bpchar The record is active in the system
r_status isactive bpchar 1 'Y'::bpchar The record is active in the system
r_statuscategory 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
m_inout isalternatereturnaddress bpchar 1 'N'::bpchar Alternate Return Address
m_changenotice isapproved bpchar 1 'N'::bpchar Indicates if this document requires approval
m_changerequest isapproved bpchar 1 'N'::bpchar Indicates if this document requires approval
m_inout isapproved bpchar 1 'N'::bpchar Indicates if this document requires approval
m_rma isapproved bpchar 1 'N'::bpchar Indicates if this document requires approval
r_requesttype isautochangerequest bpchar 1 'N'::bpchar Automatically create BOM (Engineering) Change Request
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
m_product isbom bpchar 1 'N'::bpchar Bill of Materials
ad_role iscanapproveowndoc bpchar 1 'Y'::bpchar Users with this role can approve their own documents
ad_role iscanexport bpchar 1 'Y'::bpchar Users with this role can export data
ad_role iscanreport bpchar 1 'Y'::bpchar Users with this role can create reports
ad_role ischangelog bpchar 1 'N'::bpchar Maintain a log of changes
ad_table ischangelog bpchar 1 'N'::bpchar Maintain a log of changes
r_status isclosed bpchar 1 'N'::bpchar The status is closed
c_bp_group isconfidentialinfo bpchar 1 'N'::bpchar Can enter confidential information
r_requesttype isconfidentialinfo bpchar 1 'N'::bpchar Can enter confidential information
c_bpartner iscustomer bpchar 1 'Y'::bpchar Indicates if this Business Partner is a Customer
c_bp_group isdefault bpchar 1 'N'::bpchar Default value
r_requesttype isdefault bpchar 1 'N'::bpchar Default value
r_status isdefault bpchar 1 'N'::bpchar Default value
r_statuscategory isdefault bpchar 1 'N'::bpchar Default value
ad_table isdeleteable bpchar 1 'Y'::bpchar Indicates if records can be deleted from the database
a_asset isdepreciated bpchar 1 'Y'::bpchar The asset will be depreciated
ad_role isdiscountallowedontotal bpchar 1 'N'::bpchar IsDiscountAllowedOnTotal
ad_role isdiscountuptolimitprice bpchar 1 'N'::bpchar IsDiscountUptoLimitPrice
a_asset isdisposed bpchar 1 'N'::bpchar The asset is disposed
m_product isdropship bpchar 1 'N'::bpchar Drop Shipments are sent directly to the Drop Shipment Location
r_requesttype isemailwhendue bpchar 1 'N'::bpchar Send EMail when Request becomes due
r_requesttype isemailwhenoverdue bpchar 1 'N'::bpchar Send EMail when Request becomes overdue
c_bpartner isemployee bpchar 1 'N'::bpchar Indicates if this Business Partner is an employee
r_request isescalated bpchar 1 'N'::bpchar This request has been escalated
m_product isexcludeautodelivery bpchar 1 'N'::bpchar Exclude from automatic Delivery
ad_user isexpired bpchar 1 'N'::bpchar Expired
r_status isfinalclose bpchar 1 'N'::bpchar Entries with Final Close cannot be re-opened
ad_user isfullbpaccess bpchar 1 'Y'::bpchar The user/contact has full access to Business Partner information and resources
a_asset isfullydepreciated bpchar 1 'N'::bpchar The asset is fully depreciated
ad_table ishighvolume bpchar 1 'N'::bpchar Use Search instead of Pick list
r_mailtext ishtml bpchar 1 'N'::bpchar Text has HTML tags
r_requesttype isindexed bpchar 1 'Y'::bpchar Index the document for the internal search engine
m_inout isindispute bpchar 1 'N'::bpchar Document is in dispute
ad_user isinpayroll bpchar 1 'N'::bpchar Defined if any User Contact will be used for Calculate Payroll
a_asset isinposession bpchar 1 'Y'::bpchar The asset is in the possession of the organization
m_inout isintransit bpchar 1 'N'::bpchar Movement is in transit
r_request 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
ad_role ismanual bpchar 1 'Y'::bpchar This is a manual process
m_product ismanufactured bpchar 1 'N'::bpchar This product is manufactured
ad_role ismasterrole bpchar 1 'N'::bpchar A master role cannot be assigned to users, it is intended to define access to menu option and documents and inherit to other roles
ad_role ismenuautoexpand bpchar 1 'N'::bpchar 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_bpartner isonetime bpchar 1 'N'::bpchar One time transaction
r_status isopen bpchar 1 'N'::bpchar The status is closed
m_product isownbox bpchar 1 'N'::bpchar Own Box
a_asset isowned bpchar 1 'Y'::bpchar The asset is owned by the organization
ad_role ispersonalaccess bpchar 1 'N'::bpchar Allow access to all personal records
ad_role ispersonallock bpchar 1 'N'::bpchar Allow users with role to lock access to personal records
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_inout isprinted bpchar 1 'N'::bpchar Indicates if this document / line is printed
c_bpartner isprospect bpchar 1 'N'::bpchar Indicates this is a Prospect
m_product ispurchased bpchar 1 'Y'::bpchar Organization purchases this product
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
ad_smtp issecuresmtp bpchar 1 'N'::bpchar Use SSL/TLS for SMTP
ad_table issecurityenabled bpchar 1 'N'::bpchar If security is enabled, user access to data can be restricted via Roles
m_product isselfservice bpchar 1 'Y'::bpchar This is a Self-Service entry or this entry can be changed via Self-Service
r_categoryupdates isselfservice bpchar 1 'N'::bpchar This is a Self-Service entry or this entry can be changed via Self-Service
r_groupupdates isselfservice bpchar 1 'N'::bpchar This is a Self-Service entry or this entry can be changed via Self-Service
r_interestarea isselfservice bpchar 1 'N'::bpchar This is a Self-Service entry or this entry can be changed via Self-Service
r_request isselfservice bpchar 1 'N'::bpchar This is a Self-Service entry or this entry can be changed via Self-Service
r_requesttype isselfservice bpchar 1 'Y'::bpchar This is a Self-Service entry or this entry can be changed via Self-Service
r_requesttypeupdates isselfservice bpchar 1 'N'::bpchar This is a Self-Service entry or this entry can be changed via Self-Service
r_requestupdates isselfservice bpchar 1 'N'::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
ad_role isshowacct bpchar 1 'Y'::bpchar Users with this role can see accounting information
ad_smtp issmtpauthorization bpchar 1 'N'::bpchar Your mail server requires Authentication
m_product issold bpchar 1 'Y'::bpchar Organization sells this product
m_inout issotrx bpchar 1 'Y'::bpchar This is a Sales Transaction
m_rma issotrx bpchar 1 'Y'::bpchar This is a Sales Transaction
m_product isstocked bpchar 1 'Y'::bpchar Organization stocks this product
c_activity issummary bpchar 1 'N'::bpchar This is a summary entity
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_role isuseuserorgaccess bpchar 1 'N'::bpchar Use Org Access defined by user instead of Role Org Access
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
ad_table isview bpchar 1 'N'::bpchar This is a view
r_status iswebcanupdate bpchar 1 'Y'::bpchar Entry can be updated from the Web
m_product iswebstorefeatured bpchar 1 'N'::bpchar If selected, the product is displayed in the initial or any empty search
r_requestprocessor keeplogdays numeric 10 Number of days to keep the log entries
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_changenotice m_changenotice_id numeric 10 Bill of Materials (Engineering) Change Notice (Version)
m_changerequest m_changerequest_id numeric 10 BOM (Engineering) Change Request
m_inout m_inout_id numeric 10 Material Shipment Document
m_product m_product_category_id numeric 10 Category of a Product
a_asset m_product_id numeric 10 Product, Service, Item
m_product m_product_id numeric 10 Product, Service, Item
m_rma m_rma_id numeric 10 Return Material Authorization
m_inout m_warehouse_id numeric 10 Storage Warehouse and Service Point
r_mailtext mailtext text 2147483647 Text used for Mail message
ad_role maxqueryrecords numeric 10 0 If defined, you cannot query more records as defined - the query criteria needs to be changed to query less records
a_asset_delivery movementdate timestamp 29,6 Date a product was moved in or out of inventory
m_inout movementdate timestamp 29,6 Date a product was moved in or out of inventory
m_inout movementtype bpchar 2 Method of moving the inventory
a_asset name varchar 60 Alphanumeric identifier of the entity
ad_role name varchar 60 Alphanumeric identifier of the entity
ad_smtp name varchar 60 Alphanumeric identifier of the entity
ad_table name varchar 60 Alphanumeric identifier of the entity
ad_user name varchar 60 Alphanumeric identifier of the entity
c_activity name varchar 60 Alphanumeric identifier of the entity
c_bp_group name varchar 60 Alphanumeric identifier of the entity
c_bpartner name varchar 120 Alphanumeric identifier of the entity
m_changenotice name varchar 60 Alphanumeric identifier of the entity
m_changerequest name varchar 60 Alphanumeric identifier of the entity
m_product name varchar 255 Alphanumeric identifier of the entity
m_rma name varchar 60 Alphanumeric identifier of the entity
r_category name varchar 60 Alphanumeric identifier of the entity
r_group name varchar 60 Alphanumeric identifier of the entity
r_interestarea name varchar 60 Alphanumeric identifier of the entity
r_mailtext name varchar 60 Alphanumeric identifier of the entity
r_requestprocessor name varchar 60 Alphanumeric identifier of the entity
r_requesttype name varchar 60 Alphanumeric identifier of the entity
r_resolution name varchar 60 Alphanumeric identifier of the entity
r_standardresponse name varchar 60 Alphanumeric identifier of the entity
r_status name varchar 60 Alphanumeric identifier of the entity
r_statuscategory name varchar 60 Alphanumeric identifier of the entity
ad_user notificationtype bpchar 1 'X'::bpchar Type of Notifications
r_requestprocessor overduealertdays numeric 10 Send email alert after number of days due (0=no alerts)
r_requestprocessor overdueassigndays numeric 10 Escalation to superior after number of due days (0 = no)
ad_role overwritepricelimit bpchar 1 'N'::bpchar Overwrite Price Limit if the Price List enforces the Price Limit
m_inout posted bpchar 1 'N'::bpchar Posting status
ad_role preferencetype bpchar 1 'C'::bpchar Determines what preferences the user can set
r_request priority bpchar 1 Indicates if this request is of a high, medium or low priority.
m_inout priorityrule bpchar 1 Priority of a document
a_asset processed bpchar 1 'N'::bpchar The document has been processed
m_changenotice processed bpchar 1 'N'::bpchar The document has been processed
m_changerequest processed bpchar 1 'N'::bpchar The document has been processed
m_inout processed bpchar 1 'N'::bpchar The document has been processed
m_rma processed bpchar 1 'N'::bpchar The document has been processed
r_request processed bpchar 1 'N'::bpchar The document has been processed
m_product producttype bpchar 1 'I'::bpchar Type of product
r_category r_category_id numeric 10 Request Category
r_categoryupdates r_category_id numeric 10 Request Category
r_group r_group_id numeric 10 Request Group
r_groupupdates r_group_id numeric 10 Request Group
r_contactinterest r_interestarea_id numeric 10 Interest Area or Topic
r_interestarea r_interestarea_id numeric 10 Interest Area or Topic
r_mailtext r_mailtext_id numeric 10 Text templates for mailings
r_request r_request_id numeric 10 Request from a Business Partner or Prospect
r_requestaction r_request_id numeric 10 Request from a Business Partner or Prospect
r_requestupdate r_request_id numeric 10 Request from a Business Partner or Prospect
r_requestupdates r_request_id numeric 10 Request from a Business Partner or Prospect
r_requestaction r_requestaction_id numeric 10 Request has been changed
r_requestprocessor r_requestprocessor_id numeric 10 Processor for Requests
r_requestprocessor_route r_requestprocessor_id numeric 10 Processor for Requests
r_requestprocessor_route r_requestprocessor_route_id numeric 10 Automatic routing of requests
r_request r_requesttype_id numeric 10 Type of request (e.g. Inquiry, Complaint, ..)
r_requesttype r_requesttype_id numeric 10 Type of request (e.g. Inquiry, Complaint, ..)
r_requesttypeupdates r_requesttype_id numeric 10 Type of request (e.g. Inquiry, Complaint, ..)
r_requestupdate r_requestupdate_id numeric 10 Request Updates
r_resolution r_resolution_id numeric 10 Request Resolution
r_standardresponse r_standardresponse_id numeric 10 Request Standard Response
r_status r_status_id numeric 10 Request Status
r_requesttype r_statuscategory_id numeric 10 Request Status Category
r_status r_statuscategory_id numeric 10 Request Status Category
r_statuscategory r_statuscategory_id numeric 10 Request Status Category
r_requestprocessor reminddays numeric 10 7 Days between sending Reminder Emails for a due or inactive Document
ad_table replicationtype bpchar 1 'L'::bpchar Type of Data Replication
r_request requestamt numeric 0 0 Amount associated with this request
r_standardresponse responsetext varchar 2000 Request Response Text
m_rma salesrep_id numeric 10 Sales Representative or Company Agent
r_request salesrep_id numeric 10 Sales Representative or Company Agent
c_bpartner sendemail bpchar 1 'N'::bpchar Enable sending Document EMail
m_inout sendemail bpchar 1 'N'::bpchar Enable sending Document EMail
r_requestprocessor_route seqno numeric 10 Method of ordering records; lowest number comes first
r_status seqno numeric 10 0 Method of ordering records; lowest number comes first
r_request summary varchar 2000 Textual summary of this request
r_requestprocessor supervisor_id numeric 10 Supervisor for this user/organization - used for escalation and approval
ad_table tablename varchar 40 Name of the table in the database
m_product unitsperpack numeric 10 1 The Units Per Pack indicates the no of units of a product packed together.
a_asset updated timestamp 29,6 now() Date this record was updated
a_asset_delivery updated timestamp 29,6 now() Date this record was updated
ad_role updated timestamp 29,6 now() Date this record was updated
ad_smtp updated timestamp 29,6 statement_timestamp() Date this record was updated
ad_table updated timestamp 29,6 now() Date this record was updated
ad_user updated timestamp 29,6 now() Date this record was updated
ad_usermail updated timestamp 29,6 now() Date this record was updated
c_activity updated timestamp 29,6 now() Date this record was updated
c_bp_group updated timestamp 29,6 now() Date this record was updated
c_bpartner updated timestamp 29,6 now() Date this record was updated
m_changenotice updated timestamp 29,6 now() Date this record was updated
m_changerequest updated timestamp 29,6 now() Date this record was updated
m_inout updated timestamp 29,6 now() Date this record was updated
m_product updated timestamp 29,6 now() Date this record was updated
m_rma updated timestamp 29,6 now() Date this record was updated
r_category updated timestamp 29,6 now() Date this record was updated
r_categoryupdates updated timestamp 29,6 now() Date this record was updated
r_contactinterest updated timestamp 29,6 now() Date this record was updated
r_group updated timestamp 29,6 now() Date this record was updated
r_groupupdates updated timestamp 29,6 now() Date this record was updated
r_interestarea updated timestamp 29,6 now() Date this record was updated
r_mailtext updated timestamp 29,6 now() Date this record was updated
r_request updated timestamp 29,6 now() Date this record was updated
r_requestaction updated timestamp 29,6 now() Date this record was updated
r_requestprocessor updated timestamp 29,6 now() Date this record was updated
r_requestprocessor_route updated timestamp 29,6 now() Date this record was updated
r_requesttype updated timestamp 29,6 now() Date this record was updated
r_requesttypeupdates updated timestamp 29,6 now() Date this record was updated
r_requestupdate updated timestamp 29,6 now() Date this record was updated
r_requestupdates updated timestamp 29,6 now() Date this record was updated
r_resolution updated timestamp 29,6 now() Date this record was updated
r_standardresponse updated timestamp 29,6 now() Date this record was updated
r_status updated timestamp 29,6 now() Date this record was updated
r_statuscategory updated timestamp 29,6 now() Date this record was updated
a_asset updatedby numeric 10 User who updated this records
a_asset_delivery updatedby numeric 10 User who updated this records
ad_role updatedby numeric 10 User who updated this records
ad_smtp updatedby numeric 10 User who updated this records
ad_table updatedby numeric 10 User who updated this records
ad_user updatedby numeric 10 User who updated this records
ad_usermail updatedby numeric 10 User who updated this records
c_activity updatedby numeric 10 User who updated this records
c_bp_group updatedby numeric 10 User who updated this records
c_bpartner updatedby numeric 10 User who updated this records
m_changenotice updatedby numeric 10 User who updated this records
m_changerequest updatedby numeric 10 User who updated this records
m_inout updatedby numeric 10 User who updated this records
m_product updatedby numeric 10 User who updated this records
m_rma updatedby numeric 10 User who updated this records
r_category updatedby numeric 10 User who updated this records
r_categoryupdates updatedby numeric 10 User who updated this records
r_contactinterest updatedby numeric 10 User who updated this records
r_group updatedby numeric 10 User who updated this records
r_groupupdates updatedby numeric 10 User who updated this records
r_interestarea updatedby numeric 10 User who updated this records
r_mailtext updatedby numeric 10 User who updated this records
r_request updatedby numeric 10 User who updated this records
r_requestaction updatedby numeric 10 User who updated this records
r_requestprocessor updatedby numeric 10 User who updated this records
r_requestprocessor_route updatedby numeric 10 User who updated this records
r_requesttype updatedby numeric 10 User who updated this records
r_requesttypeupdates updatedby numeric 10 User who updated this records
r_requestupdate updatedby numeric 10 User who updated this records
r_requestupdates updatedby numeric 10 User who updated this records
r_resolution updatedby numeric 10 User who updated this records
r_standardresponse updatedby numeric 10 User who updated this records
r_status updatedby numeric 10 User who updated this records
r_statuscategory updatedby numeric 10 User who updated this records
ad_role userlevel bpchar 3 ' O'::bpchar System Client Organization
a_asset value varchar 40 Search key for the record in the format required - must be unique
c_activity value varchar 40 Search key for the record in the format required - must be unique
c_bp_group value varchar 40 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
r_interestarea value varchar 40 Search key for the record in the format required - must be unique
r_status value varchar 40 Search key for the record in the format required - must be unique