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

idempiere9.adempiere contains 375 columns - click on heading to sort:
Table Column Type Size Nulls Auto Default
m_attributesetinstance ad_client_id numeric 10 Client/Tenant for this installation.
m_attributesetinstance ad_org_id numeric 10 Organizational entity within client
m_attributesetinstance created timestamp 29,6 now() Date this record was created
m_attributesetinstance createdby numeric 10 User who created this records
m_attributesetinstance description varchar 255  √  null Optional short description of the record
m_attributesetinstance guaranteedate timestamp 29,6  √  null Date when guarantee expires
m_attributesetinstance isactive bpchar 1 'Y'::bpchar The record is active in the system
m_attributesetinstance lot varchar 40  √  null Lot number (alphanumeric)
m_attributesetinstance m_attributeset_id numeric 10  √  null Product Attribute Set
m_attributesetinstance m_attributesetinstance_id numeric 10 Product Attribute Set Instance
m_attributesetinstance m_attributesetinstance_uu varchar 36  √  NULL::character varying M_AttributeSetInstance_UU
m_attributesetinstance m_lot_id numeric 10  √  null Product Lot Definition
m_attributesetinstance serno varchar 40  √  null Product Serial Number
m_attributesetinstance updated timestamp 29,6 now() Date this record was updated
m_attributesetinstance updatedby numeric 10 User who updated this records
m_bom ad_client_id numeric 10 Client/Tenant for this installation.
m_bom ad_org_id numeric 10 Organizational entity within client
m_bom bomtype bpchar 1 Type of BOM
m_bom bomuse bpchar 1 The use of the Bill of Material
m_bom created timestamp 29,6 now() Date this record was created
m_bom createdby numeric 10 User who created this records
m_bom description varchar 255  √  null Optional short description of the record
m_bom help varchar 2000  √  null Comment or Hint
m_bom isactive bpchar 1 'Y'::bpchar The record is active in the system
m_bom m_bom_id numeric 10 Bill of Material
m_bom m_bom_uu varchar 36  √  NULL::character varying M_BOM_UU
m_bom m_changenotice_id numeric 10  √  null Bill of Materials (Engineering) Change Notice (Version)
m_bom m_product_id numeric 10 Product, Service, Item
m_bom name varchar 60 Alphanumeric identifier of the entity
m_bom processing bpchar 1  √  null Process Now
m_bom updated timestamp 29,6 now() Date this record was updated
m_bom updatedby numeric 10 User who updated this records
m_bomalternative ad_client_id numeric 10 Client/Tenant for this installation.
m_bomalternative ad_org_id numeric 10 Organizational entity within client
m_bomalternative created timestamp 29,6 now() Date this record was created
m_bomalternative createdby numeric 10 User who created this records
m_bomalternative description varchar 255  √  null Optional short description of the record
m_bomalternative isactive bpchar 1 'Y'::bpchar The record is active in the system
m_bomalternative m_bomalternative_id numeric 10 Product BOM Alternative Group
m_bomalternative m_bomalternative_uu varchar 36  √  NULL::character varying M_BOMAlternative_UU
m_bomalternative m_product_id numeric 10 Product, Service, Item
m_bomalternative name varchar 60 Alphanumeric identifier of the entity
m_bomalternative updated timestamp 29,6 now() Date this record was updated
m_bomalternative updatedby numeric 10 User who updated this records
m_bomproduct ad_client_id numeric 10 Client/Tenant for this installation.
m_bomproduct ad_org_id numeric 10 Organizational entity within client
m_bomproduct bomproducttype bpchar 1 BOM Product Type
m_bomproduct bomqty numeric 0 0 Bill of Materials Quantity
m_bomproduct created timestamp 29,6 now() Date this record was created
m_bomproduct createdby numeric 10 User who created this records
m_bomproduct description varchar 255  √  null Optional short description of the record
m_bomproduct help varchar 2000  √  null Comment or Hint
m_bomproduct isactive bpchar 1 'Y'::bpchar The record is active in the system
m_bomproduct isphantom bpchar 1 'N'::bpchar Phantom Component
m_bomproduct leadtimeoffset numeric 10 0 Optional Lead Time offset before starting production
m_bomproduct line numeric 10 0 Unique line for this document
m_bomproduct m_attributesetinstance_id numeric 10  √  null Product Attribute Set Instance
m_bomproduct m_bom_id numeric 10 Bill of Material
m_bomproduct m_bomalternative_id numeric 10  √  null Product BOM Alternative Group
m_bomproduct m_bomproduct_id numeric 10 Bill of Material Component (Product)
m_bomproduct m_bomproduct_uu varchar 36  √  NULL::character varying M_BOMProduct_UU
m_bomproduct m_changenotice_id numeric 10  √  null Bill of Materials (Engineering) Change Notice (Version)
m_bomproduct m_productbom_id numeric 10  √  null Bill of Material Component Product
m_bomproduct m_productoperation_id numeric 10  √  null Product Manufacturing Operation
m_bomproduct seqno numeric 10  √  0 Method of ordering records; lowest number comes first
m_bomproduct updated timestamp 29,6 now() Date this record was updated
m_bomproduct updatedby numeric 10 User who updated this records
m_changenotice ad_client_id numeric 10 Client/Tenant for this installation.
m_changenotice ad_org_id numeric 10 Organizational entity within client
m_changenotice created timestamp 29,6 now() Date this record was created
m_changenotice createdby numeric 10 User who created this records
m_changenotice description varchar 255  √  null Optional short description of the record
m_changenotice detailinfo text 2147483647  √  null Additional Detail Information
m_changenotice help varchar 2000  √  null Comment or Hint
m_changenotice isactive bpchar 1 'Y'::bpchar The record is active in the system
m_changenotice isapproved bpchar 1 'N'::bpchar Indicates if this document requires approval
m_changenotice m_changenotice_id numeric 10 Bill of Materials (Engineering) Change Notice (Version)
m_changenotice m_changenotice_uu varchar 36  √  NULL::character varying M_ChangeNotice_UU
m_changenotice name varchar 60 Alphanumeric identifier of the entity
m_changenotice processed bpchar 1 'N'::bpchar The document has been processed
m_changenotice processing bpchar 1  √  null Process Now
m_changenotice updated timestamp 29,6 now() Date this record was updated
m_changenotice updatedby numeric 10 User who updated this records
m_changerequest ad_client_id numeric 10 Client/Tenant for this installation.
m_changerequest ad_org_id numeric 10 Organizational entity within client
m_changerequest created timestamp 29,6 now() Date this record was created
m_changerequest createdby numeric 10 User who created this records
m_changerequest description varchar 255  √  null Optional short description of the record
m_changerequest detailinfo text 2147483647  √  null Additional Detail Information
m_changerequest documentno varchar 30 Document sequence number of the document
m_changerequest help varchar 2000  √  null Comment or Hint
m_changerequest isactive bpchar 1 'Y'::bpchar The record is active in the system
m_changerequest isapproved bpchar 1 'N'::bpchar Indicates if this document requires approval
m_changerequest m_changenotice_id numeric 10  √  null Bill of Materials (Engineering) Change Notice (Version)
m_changerequest m_changerequest_id numeric 10 BOM (Engineering) Change Request
m_changerequest m_changerequest_uu varchar 36  √  NULL::character varying M_ChangeRequest_UU
m_changerequest m_fixchangenotice_id numeric 10  √  null Fixed in Change Notice
m_changerequest name varchar 60 Alphanumeric identifier of the entity
m_changerequest pp_product_bom_id numeric 10  √  null BOM & Formula
m_changerequest processed bpchar 1 'N'::bpchar The document has been processed
m_changerequest updated timestamp 29,6 now() Date this record was updated
m_changerequest updatedby numeric 10 User who updated this records
m_operationresource a_asset_id numeric 10  √  null Asset used internally or by customers
m_operationresource ad_client_id numeric 10 Client/Tenant for this installation.
m_operationresource ad_org_id numeric 10 Organizational entity within client
m_operationresource c_job_id numeric 10  √  null Job Position
m_operationresource created timestamp 29,6 now() Date this record was created
m_operationresource createdby numeric 10 User who created this records
m_operationresource description varchar 255  √  null Optional short description of the record
m_operationresource help varchar 2000  √  null Comment or Hint
m_operationresource isactive bpchar 1 'Y'::bpchar The record is active in the system
m_operationresource m_operationresource_id numeric 10 Product Operation Resource
m_operationresource m_operationresource_uu varchar 36  √  NULL::character varying M_OperationResource_UU
m_operationresource m_productoperation_id numeric 10 Product Manufacturing Operation
m_operationresource name varchar 60 Alphanumeric identifier of the entity
m_operationresource setuptime numeric 0 0 Setup time before starting Production
m_operationresource teardowntime numeric 0 0 Time at the end of the operation
m_operationresource unitruntime numeric 0 0 Time to produce one unit
m_operationresource updated timestamp 29,6 now() Date this record was updated
m_operationresource updatedby numeric 10 User who updated this records
m_product ad_client_id numeric 10 Client/Tenant for this installation.
m_product ad_org_id numeric 10 Organizational entity within client
m_product c_revenuerecognition_id numeric 10  √  null Method for recording revenue
m_product c_subscriptiontype_id numeric 10  √  null Type of subscription
m_product c_taxcategory_id numeric 10 Tax Category
m_product c_uom_id numeric 10 Unit of Measure
m_product classification varchar 12  √  null Classification for grouping
m_product copyfrom bpchar 1  √  NULL::bpchar Copy From Record
m_product created timestamp 29,6 now() Date this record was created
m_product createdby numeric 10 User who created this records
m_product customstariffnumber varchar 20  √  null Customs Tariff Number, usually the HS-Code
m_product description varchar 255  √  null Optional short description of the record
m_product descriptionurl varchar 120  √  null URL for the description
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
m_product documentnote varchar 2000  √  null Additional information for a Document
m_product downloadurl varchar 120  √  null
m_product group1 varchar 255  √  null Group1
m_product group2 varchar 255  √  null Group2
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
m_product help varchar 2000  √  null Comment or Hint
m_product imageurl varchar 120  √  null URL of image
m_product isactive bpchar 1 'Y'::bpchar The record is active in the system
m_product isautoproduce bpchar 1 'N'::bpchar Auto create production to fulfill shipment
m_product isbom bpchar 1 'N'::bpchar Bill of Materials
m_product isdropship bpchar 1 'N'::bpchar Drop Shipments are sent directly to the Drop Shipment Location
m_product isexcludeautodelivery bpchar 1 'N'::bpchar Exclude from automatic Delivery
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
m_product ismanufactured bpchar 1 'N'::bpchar This product is manufactured
m_product isownbox bpchar 1 'N'::bpchar Own Box
m_product isphantom bpchar 1  √  'N'::bpchar Phantom Component
m_product ispicklistprintdetails bpchar 1 'N'::bpchar Print detail BOM elements on the pick list
m_product ispurchased bpchar 1 'Y'::bpchar Organization purchases this product
m_product isselfservice bpchar 1 'Y'::bpchar This is a Self-Service entry or this entry can be changed via Self-Service
m_product issold bpchar 1 'Y'::bpchar Organization sells this product
m_product isstocked bpchar 1 'Y'::bpchar Organization stocks this product
m_product issummary bpchar 1 'N'::bpchar This is a summary entity
m_product istoformule bpchar 1  √  null
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 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_product m_attributeset_id numeric 10  √  null Product Attribute Set
m_product m_attributesetinstance_id numeric 10  √  0 Product Attribute Set Instance
m_product m_freightcategory_id numeric 10  √  null Category of the Freight
m_product m_locator_id numeric 10  √  null Warehouse Locator
m_product m_parttype_id numeric 10  √  NULL::numeric Part Type
m_product m_product_category_id numeric 10 Category of a Product
m_product m_product_id numeric 10 Product, Service, Item
m_product m_product_uu varchar 36  √  NULL::character varying M_Product_UU
m_product name varchar 255 Alphanumeric identifier of the entity
m_product processing bpchar 1  √  null Process Now
m_product producttype bpchar 1 'I'::bpchar Type of product
m_product r_mailtext_id numeric 10  √  null Text templates for mailings
m_product s_expensetype_id numeric 10  √  null Expense report type
m_product s_resource_id numeric 10  √  null Resource
m_product salesrep_id numeric 10  √  null Sales Representative or Company Agent
m_product shelfdepth numeric 10  √  null Shelf depth required
m_product shelfheight numeric 0  √  null Shelf height required
m_product shelfwidth numeric 10  √  null Shelf width required
m_product sku varchar 30  √  null Stock Keeping Unit
m_product unitsperpack numeric 10 1 The Units Per Pack indicates the no of units of a product packed together.
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)
m_product updated timestamp 29,6 now() Date this record was updated
m_product updatedby numeric 10 User who updated this records
m_product value varchar 40 Search key for the record in the format required - must be unique
m_product versionno varchar 20  √  null Version Number
m_product volume numeric 0  √  0 Volume of a product
m_product weight numeric 0  √  0 Weight of a product
m_product_acct ad_client_id numeric 10 Client/Tenant for this installation.
m_product_acct ad_org_id numeric 10 Organizational entity within client
m_product_acct c_acctschema_id numeric 10 Rules for accounting
m_product_acct created timestamp 29,6 now() Date this record was created
m_product_acct createdby numeric 10 User who created this records
m_product_acct isactive bpchar 1 'Y'::bpchar The record is active in the system
m_product_acct m_product_acct_uu varchar 36  √  NULL::character varying M_Product_Acct_UU
m_product_acct m_product_id numeric 10 Product, Service, Item
m_product_acct p_asset_acct numeric 10 Account for Product Asset (Inventory)
m_product_acct p_averagecostvariance_acct numeric 10  √  NULL::numeric Average Cost Variance
m_product_acct p_burden_acct numeric 10  √  null The Burden account is the account used Manufacturing Order
m_product_acct p_cogs_acct numeric 10 Account for Cost of Goods Sold
m_product_acct p_costadjustment_acct numeric 10  √  null Product Cost Adjustment Account
m_product_acct p_costofproduction_acct numeric 10  √  null The Cost Of Production account is the account used Manufacturing Order
m_product_acct p_expense_acct numeric 10 Account for Product Expense
m_product_acct p_floorstock_acct numeric 10  √  null The Floor Stock account is the account used Manufacturing Order
m_product_acct p_inventoryclearing_acct numeric 10  √  null Product Inventory Clearing Account
m_product_acct p_invoicepricevariance_acct numeric 10 Difference between Costs and Invoice Price (IPV)
m_product_acct p_labor_acct numeric 10  √  null The Labor account is the account used Manufacturing Order
m_product_acct p_landedcostclearing_acct numeric 10  √  NULL::numeric Product Landed Cost Clearing Account
m_product_acct p_methodchangevariance_acct numeric 10  √  null The Method Change Variance account is the account used Manufacturing Order
m_product_acct p_mixvariance_acct numeric 10  √  null The Mix Variance account is the account used Manufacturing Order
m_product_acct p_outsideprocessing_acct numeric 10  √  null The Outside Processing Account is the account used in Manufacturing Order
m_product_acct p_overhead_acct numeric 10  √  null The Overhead account is the account used in Manufacturing Order
m_product_acct p_purchasepricevariance_acct numeric 10 Difference between Standard Cost and Purchase Price (PPV)
m_product_acct p_ratevariance_acct numeric 10  √  null The Rate Variance account is the account used Manufacturing Order
m_product_acct p_revenue_acct numeric 10 Account for Product Revenue (Sales Account)
m_product_acct p_scrap_acct numeric 10  √  null The Scrap account is the account used in Manufacturing Order
m_product_acct p_tradediscountgrant_acct numeric 10 Trade Discount Granted Account
m_product_acct p_tradediscountrec_acct numeric 10 Trade Discount Receivable Account
m_product_acct p_usagevariance_acct numeric 10  √  null The Usage Variance account is the account used Manufacturing Order
m_product_acct p_wip_acct numeric 10  √  null The Work in Process account is the account used Manufacturing Order
m_product_acct updated timestamp 29,6 now() Date this record was updated
m_product_acct updatedby numeric 10 User who updated this records
m_product_bom ad_client_id numeric 10  √  null Client/Tenant for this installation.
m_product_bom ad_org_id numeric 10  √  null Organizational entity within client
m_product_bom bomqty numeric 0  √  null Bill of Materials Quantity
m_product_bom bomtype varchar 2147483647  √  null Type of BOM
m_product_bom created timestamp 29,6  √  null Date this record was created
m_product_bom createdby numeric 10  √  null User who created this records
m_product_bom description varchar 255  √  null Optional short description of the record
m_product_bom isactive bpchar 1  √  null The record is active in the system
m_product_bom line numeric 10  √  null Unique line for this document
m_product_bom m_product_bom_id numeric 10  √  null BOM Line
m_product_bom m_product_bom_uu varchar 36  √  null M_Product_BOM_UU
m_product_bom m_product_id numeric 10  √  null Product, Service, Item
m_product_bom m_productbom_id numeric 10  √  null Bill of Material Component Product
m_product_bom updated timestamp 29,6  √  null Date this record was updated
m_product_bom updatedby numeric 10  √  null User who updated this records
m_productoperation ad_client_id numeric 10 Client/Tenant for this installation.
m_productoperation ad_org_id numeric 10 Organizational entity within client
m_productoperation created timestamp 29,6 now() Date this record was created
m_productoperation createdby numeric 10 User who created this records
m_productoperation description varchar 255  √  null Optional short description of the record
m_productoperation help varchar 2000  √  null Comment or Hint
m_productoperation isactive bpchar 1 'Y'::bpchar The record is active in the system
m_productoperation m_product_id numeric 10 Product, Service, Item
m_productoperation m_productoperation_id numeric 10 Product Manufacturing Operation
m_productoperation m_productoperation_uu varchar 36  √  NULL::character varying M_ProductOperation_UU
m_productoperation name varchar 60 Alphanumeric identifier of the entity
m_productoperation setuptime numeric 0  √  0 Setup time before starting Production
m_productoperation teardowntime numeric 0  √  0 Time at the end of the operation
m_productoperation unitruntime numeric 0  √  0 Time to produce one unit
m_productoperation updated timestamp 29,6 now() Date this record was updated
m_productoperation updatedby numeric 10 User who updated this records
r_category ad_client_id numeric 10 Client/Tenant for this installation.
r_category ad_org_id numeric 10 Organizational entity within client
r_category created timestamp 29,6 now() Date this record was created
r_category createdby numeric 10 User who created this records
r_category description varchar 255  √  null Optional short description of the record
r_category help varchar 2000  √  null Comment or Hint
r_category isactive bpchar 1 'Y'::bpchar The record is active in the system
r_category m_product_id numeric 10  √  null Product, Service, Item
r_category name varchar 60 Alphanumeric identifier of the entity
r_category r_category_id numeric 10 Request Category
r_category r_category_uu varchar 36  √  NULL::character varying R_Category_UU
r_category updated timestamp 29,6 now() Date this record was updated
r_category updatedby numeric 10 User who updated this records
r_group ad_client_id numeric 10 Client/Tenant for this installation.
r_group ad_org_id numeric 10 Organizational entity within client
r_group created timestamp 29,6 now() Date this record was created
r_group createdby numeric 10 User who created this records
r_group description varchar 255  √  null Optional short description of the record
r_group help varchar 2000  √  null Comment or Hint
r_group isactive bpchar 1 'Y'::bpchar The record is active in the system
r_group m_bom_id numeric 10  √  null
r_group m_changenotice_id numeric 10  √  null Bill of Materials (Engineering) Change Notice (Version)
r_group name varchar 60 Alphanumeric identifier of the entity
r_group pp_product_bom_id numeric 10  √  null BOM & Formula
r_group r_group_id numeric 10 Request Group
r_group r_group_uu varchar 36  √  NULL::character varying R_Group_UU
r_group updated timestamp 29,6 now() Date this record was updated
r_group updatedby numeric 10 User who updated this records
r_request a_asset_id numeric 10  √  null Asset used internally or by customers
r_request ad_client_id numeric 10 Client/Tenant for this installation.
r_request ad_org_id numeric 10 Organizational entity within client
r_request ad_role_id numeric 10  √  null Responsibility Role
r_request ad_table_id numeric 10  √  null Database Table information
r_request ad_user_id numeric 10  √  null User within the system - Internal or Business Partner Contact
r_request c_activity_id numeric 10  √  null Business Activity
r_request c_bpartner_id numeric 10  √  null Identifies a Business Partner
r_request c_campaign_id numeric 10  √  null Marketing Campaign
r_request c_invoice_id numeric 10  √  null Invoice Identifier
r_request c_invoicerequest_id numeric 10  √  null The generated invoice for this request
r_request c_order_id numeric 10  √  null Order
r_request c_payment_id numeric 10  √  null Payment identifier
r_request c_project_id numeric 10  √  null Financial Project
r_request closedate timestamp 29,6  √  null Close Date
r_request confidentialtype bpchar 1 'C'::bpchar Type of Confidentiality
r_request confidentialtypeentry bpchar 1 Confidentiality of the individual entry
r_request created timestamp 29,6 now() Date this record was created
r_request createdby numeric 10 User who created this records
r_request 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
r_request datenextaction timestamp 29,6  √  null Date that this request should be acted on
r_request datestartplan timestamp 29,6  √  null Planned Start Date
r_request documentno varchar 30 Document sequence number of the document
r_request duetype bpchar 1 Status of the next action for this Request
r_request endtime timestamp 29,6  √  null End of the time span
r_request isactive bpchar 1 'Y'::bpchar The record is active in the system
r_request isescalated bpchar 1 'N'::bpchar This request has been escalated
r_request isinvoiced bpchar 1 'N'::bpchar Is this invoiced?
r_request isselfservice bpchar 1 'N'::bpchar This is a Self-Service entry or this entry can be changed via Self-Service
r_request lastresult varchar 2000  √  null Result of last contact
r_request m_changerequest_id numeric 10  √  null BOM (Engineering) Change Request
r_request m_fixchangenotice_id numeric 10  √  null Fixed in Change Notice
r_request m_inout_id numeric 10  √  null Material Shipment Document
r_request m_product_id numeric 10  √  null Product, Service, Item
r_request m_productspent_id numeric 10  √  null Product/Resource/Service used in Request
r_request m_rma_id numeric 10  √  null Return Material Authorization
r_request nextaction bpchar 1  √  null Next Action to be taken
r_request priority bpchar 1 Indicates if this request is of a high, medium or low priority.
r_request priorityuser bpchar 1  √  null Priority of the issue for the User
r_request processed bpchar 1 'N'::bpchar The document has been processed
r_request qtyinvoiced numeric 0  √  0 Invoiced Quantity
r_request qtyplan numeric 0  √  null Planned Quantity
r_request qtyspent numeric 0  √  0 Quantity used for this event
r_request r_category_id numeric 10  √  null Request Category
r_request r_group_id numeric 10  √  null Request Group
r_request r_mailtext_id numeric 10  √  null Text templates for mailings
r_request r_request_id numeric 10 Request from a Business Partner or Prospect
r_request r_request_uu varchar 36  √  NULL::character varying R_Request_UU
r_request r_requestrelated_id numeric 10  √  null Related Request (Master Issue, ..)
r_request r_requesttype_id numeric 10 Type of request (e.g. Inquiry, Complaint, ..)
r_request r_resolution_id numeric 10  √  null Request Resolution
r_request r_standardresponse_id numeric 10  √  null Request Standard Response
r_request r_status_id numeric 10  √  null Request Status
r_request record_id numeric 10  √  null Direct internal record ID
r_request requestamt numeric 0 0 Amount associated with this request
r_request result varchar 2000  √  null Result of the action taken
r_request salesrep_id numeric 10 Sales Representative or Company Agent
r_request startdate timestamp 29,6  √  null First effective day (inclusive)
r_request starttime timestamp 29,6  √  null Time started
r_request summary varchar 2000 Textual summary of this request
r_request taskstatus bpchar 1  √  null Status of the Task
r_request updated timestamp 29,6 now() Date this record was updated
r_request updatedby numeric 10 User who updated this records
r_requesttype ad_client_id numeric 10 Client/Tenant for this installation.
r_requesttype ad_org_id numeric 10 Organizational entity within client
r_requesttype autoduedatedays numeric 10  √  null Automatic Due Date Days
r_requesttype confidentialtype bpchar 1 'C'::bpchar Type of Confidentiality
r_requesttype contentcolor varchar 7  √  NULL::character varying Content color of calendar dashlet
r_requesttype created timestamp 29,6 now() Date this record was created
r_requesttype createdby numeric 10 User who created this records
r_requesttype description varchar 255  √  null Optional short description of the record
r_requesttype duedatetolerance numeric 10 7 Tolerance in days between the Date Next Action and the date the request is regarded as overdue
r_requesttype headercolor varchar 7  √  NULL::character varying Header color of calendar dashlet
r_requesttype isactive bpchar 1 'Y'::bpchar The record is active in the system
r_requesttype isautochangerequest bpchar 1 'N'::bpchar Automatically create BOM (Engineering) Change Request
r_requesttype isconfidentialinfo bpchar 1 'N'::bpchar Can enter confidential information
r_requesttype isdefault bpchar 1 'N'::bpchar Default value
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
r_requesttype isindexed bpchar 1 'Y'::bpchar Index the document for the internal search engine
r_requesttype isinvoiced bpchar 1  √  null Is this invoiced?
r_requesttype isselfservice bpchar 1 'Y'::bpchar This is a Self-Service entry or this entry can be changed via Self-Service
r_requesttype name varchar 60 Alphanumeric identifier of the entity
r_requesttype r_requesttype_id numeric 10 Type of request (e.g. Inquiry, Complaint, ..)
r_requesttype r_requesttype_uu varchar 36  √  NULL::character varying R_RequestType_UU
r_requesttype r_statuscategory_id numeric 10 Request Status Category
r_requesttype updated timestamp 29,6 now() Date this record was updated
r_requesttype updatedby numeric 10 User who updated this records