idempiere11.adempiere contains 376 columns - click on heading to sort:

Table	Column	Type	Size	Nulls	Auto	Default
m_operationresource	a_asset_id	numeric	10	√		null	Asset used internally or by customers
r_request	a_asset_id	numeric	10	√		null	Asset used internally or by customers
m_attributesetinstance	ad_client_id	numeric	10				Tenant for this installation.
m_bom	ad_client_id	numeric	10				Tenant for this installation.
m_bomalternative	ad_client_id	numeric	10				Tenant for this installation.
m_bomproduct	ad_client_id	numeric	10				Tenant for this installation.
m_changenotice	ad_client_id	numeric	10				Tenant for this installation.
m_changerequest	ad_client_id	numeric	10				Tenant for this installation.
m_operationresource	ad_client_id	numeric	10				Tenant for this installation.
m_product	ad_client_id	numeric	10				Tenant for this installation.
m_product_acct	ad_client_id	numeric	10				Tenant for this installation.
m_product_bom	ad_client_id	numeric	10	√		null	Tenant for this installation.
m_productoperation	ad_client_id	numeric	10				Tenant for this installation.
r_category	ad_client_id	numeric	10				Tenant for this installation.
r_group	ad_client_id	numeric	10				Tenant for this installation.
r_request	ad_client_id	numeric	10				Tenant for this installation.
r_requesttype	ad_client_id	numeric	10				Tenant for this installation.
m_attributesetinstance	ad_org_id	numeric	10				Organizational entity within tenant
m_bom	ad_org_id	numeric	10				Organizational entity within tenant
m_bomalternative	ad_org_id	numeric	10				Organizational entity within tenant
m_bomproduct	ad_org_id	numeric	10				Organizational entity within tenant
m_changenotice	ad_org_id	numeric	10				Organizational entity within tenant
m_changerequest	ad_org_id	numeric	10				Organizational entity within tenant
m_operationresource	ad_org_id	numeric	10				Organizational entity within tenant
m_product	ad_org_id	numeric	10				Organizational entity within tenant
m_product_acct	ad_org_id	numeric	10				Organizational entity within tenant
m_product_bom	ad_org_id	numeric	10	√		null	Organizational entity within tenant
m_productoperation	ad_org_id	numeric	10				Organizational entity within tenant
r_category	ad_org_id	numeric	10				Organizational entity within tenant
r_group	ad_org_id	numeric	10				Organizational entity within tenant
r_request	ad_org_id	numeric	10				Organizational entity within tenant
r_requesttype	ad_org_id	numeric	10				Organizational entity within tenant
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_requesttype	autoduedatedays	numeric	10	√		null	Automatic Due Date Days
m_bomproduct	bomproducttype	bpchar	1				BOM Product Type
m_bomproduct	bomqty	numeric	0			0	Bill of Materials Quantity
m_product_bom	bomqty	numeric	0	√		null	Bill of Materials Quantity
m_bom	bomtype	bpchar	1				Type of BOM
m_product_bom	bomtype	varchar	2147483647	√		null	Type of BOM
m_bom	bomuse	bpchar	1				The use of the Bill of Material
m_product_acct	c_acctschema_id	numeric	10				Rules for accounting
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
m_operationresource	c_job_id	numeric	10	√		null	Job Position
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
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
r_request	closedate	timestamp	29,6	√		null	Close Date
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_requesttype	contentcolor	varchar	7	√		NULL::character varying	Content color of calendar dashlet
m_product	copyfrom	bpchar	1	√		NULL::bpchar	Copy From Record
m_attributesetinstance	created	timestamp	29,6			now()	Date this record was created
m_bom	created	timestamp	29,6			now()	Date this record was created
m_bomalternative	created	timestamp	29,6			now()	Date this record was created
m_bomproduct	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_operationresource	created	timestamp	29,6			now()	Date this record was created
m_product	created	timestamp	29,6			now()	Date this record was created
m_product_acct	created	timestamp	29,6			now()	Date this record was created
m_product_bom	created	timestamp	29,6	√		null	Date this record was created
m_productoperation	created	timestamp	29,6			now()	Date this record was created
r_category	created	timestamp	29,6			now()	Date this record was created
r_group	created	timestamp	29,6			now()	Date this record was created
r_request	created	timestamp	29,6			now()	Date this record was created
r_requesttype	created	timestamp	29,6			now()	Date this record was created
m_attributesetinstance	createdby	numeric	10				User who created this records
m_bom	createdby	numeric	10				User who created this records
m_bomalternative	createdby	numeric	10				User who created this records
m_bomproduct	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_operationresource	createdby	numeric	10				User who created this records
m_product	createdby	numeric	10				User who created this records
m_product_acct	createdby	numeric	10				User who created this records
m_product_bom	createdby	numeric	10	√		null	User who created this records
m_productoperation	createdby	numeric	10				User who created this records
r_category	createdby	numeric	10				User who created this records
r_group	createdby	numeric	10				User who created this records
r_request	createdby	numeric	10				User who created this records
r_requesttype	createdby	numeric	10				User who created this records
m_product	customstariffnumber	varchar	20	√		null	Customs Tariff Number, usually the HS-Code
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
m_attributesetinstance	description	varchar	255	√		null	Optional short description of the record
m_bom	description	varchar	255	√		null	Optional short description of the record
m_bomalternative	description	varchar	255	√		null	Optional short description of the record
m_bomproduct	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_operationresource	description	varchar	255	√		null	Optional short description of the record
m_product	description	varchar	255	√		null	Optional short description of the record
m_product_bom	description	varchar	255	√		null	Optional short description of the record
m_productoperation	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_requesttype	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
m_changerequest	documentno	varchar	30				Document sequence number of the document
r_request	documentno	varchar	30				Document sequence number of the document
m_product	documentnote	varchar	2000	√		null	Additional information for a Document
m_product	downloadurl	varchar	120	√		null
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
r_request	endtime	timestamp	29,6	√		null	End of the time span
m_product	group1	varchar	255	√		null	Group1
m_product	group2	varchar	255	√		null	Group2
m_attributesetinstance	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
m_bom	help	varchar	2000	√		null	Comment or Hint
m_bomproduct	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_operationresource	help	varchar	2000	√		null	Comment or Hint
m_product	help	varchar	2000	√		null	Comment or Hint
m_productoperation	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
m_product	imageurl	varchar	120	√		null	URL of image
m_attributesetinstance	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
m_bom	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
m_bomalternative	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
m_bomproduct	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_operationresource	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
m_product	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
m_product_acct	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
m_product_bom	isactive	bpchar	1	√		null	The record is active in the system
m_productoperation	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_group	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_requesttype	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_changerequest	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
m_product	isbom	bpchar	1			'N'::bpchar	Bill of Materials
r_requesttype	isconfidentialinfo	bpchar	1			'N'::bpchar	Can enter confidential information
r_requesttype	isdefault	bpchar	1			'N'::bpchar	Default value
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
r_request	isescalated	bpchar	1			'N'::bpchar	This request has been escalated
m_product	isexcludeautodelivery	bpchar	1			'N'::bpchar	Exclude from automatic Delivery
r_requesttype	isindexed	bpchar	1			'Y'::bpchar	Index the document for the internal search engine
r_request	isinvoiced	bpchar	1			'N'::bpchar	Is this invoiced?
r_requesttype	isinvoiced	bpchar	1	√		null	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
m_product	ismanufactured	bpchar	1			'N'::bpchar	This product is manufactured
m_product	isownbox	bpchar	1			'N'::bpchar	Own Box
m_bomproduct	isphantom	bpchar	1			'N'::bpchar	Phantom Component
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
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
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
r_request	lastresult	varchar	2000	√		null	Result of last contact
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_product_bom	line	numeric	10	√		null	Unique line for this document
m_attributesetinstance	lot	varchar	40	√		null	Lot number (alphanumeric)
m_product	lowlevel	numeric	10			(0)::numeric	The Low Level is used to calculate the material plan and determines if a net requirement should be exploited
m_attributesetinstance	m_attributeset_id	numeric	10	√		null	Product Attribute Set
m_product	m_attributeset_id	numeric	10	√		null	Product Attribute Set
m_attributesetinstance	m_attributesetinstance_id	numeric	10				Product Attribute Set Instance
m_bomproduct	m_attributesetinstance_id	numeric	10	√		null	Product Attribute Set Instance
m_product	m_attributesetinstance_id	numeric	10	√		0	Product Attribute Set Instance
m_attributesetinstance	m_attributesetinstance_uu	varchar	36	√		NULL::character varying	M_AttributeSetInstance_UU
m_bom	m_bom_id	numeric	10				Bill of Material
m_bomproduct	m_bom_id	numeric	10				Bill of Material
r_group	m_bom_id	numeric	10	√		null
m_bom	m_bom_uu	varchar	36	√		NULL::character varying	M_BOM_UU
m_bomalternative	m_bomalternative_id	numeric	10				Product BOM Alternative Group
m_bomproduct	m_bomalternative_id	numeric	10	√		null	Product BOM Alternative Group
m_bomalternative	m_bomalternative_uu	varchar	36	√		NULL::character varying	M_BOMAlternative_UU
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_bom	m_changenotice_id	numeric	10	√		null	Bill of Materials (Engineering) Change Notice (Version)
m_bomproduct	m_changenotice_id	numeric	10	√		null	Bill of Materials (Engineering) Change Notice (Version)
m_changenotice	m_changenotice_id	numeric	10				Bill of Materials (Engineering) Change Notice (Version)
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
m_changerequest	m_changerequest_id	numeric	10				BOM (Engineering) Change Request
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
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
m_product	m_locator_id	numeric	10	√		null	Warehouse Locator
m_attributesetinstance	m_lot_id	numeric	10	√		null	Product Lot Definition
m_operationresource	m_operationresource_id	numeric	10				Product Operation Resource
m_operationresource	m_operationresource_uu	varchar	36	√		NULL::character varying	M_OperationResource_UU
m_product	m_parttype_id	numeric	10	√		NULL::numeric	Part Type
m_product_acct	m_product_acct_uu	varchar	36	√		NULL::character varying	M_Product_Acct_UU
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	m_product_category_id	numeric	10				Category of a Product
m_bom	m_product_id	numeric	10				Product, Service, Item
m_bomalternative	m_product_id	numeric	10				Product, Service, Item
m_product	m_product_id	numeric	10				Product, Service, Item
m_product_acct	m_product_id	numeric	10				Product, Service, Item
m_product_bom	m_product_id	numeric	10	√		null	Product, Service, Item
m_productoperation	m_product_id	numeric	10				Product, Service, Item
r_category	m_product_id	numeric	10	√		null	Product, Service, Item
r_request	m_product_id	numeric	10	√		null	Product, Service, Item
m_product	m_product_uu	varchar	36	√		NULL::character varying	M_Product_UU
m_bomproduct	m_productbom_id	numeric	10	√		null	Bill of Material Component Product
m_product_bom	m_productbom_id	numeric	10	√		null	Bill of Material Component Product
m_bomproduct	m_productoperation_id	numeric	10	√		null	Product Manufacturing Operation
m_operationresource	m_productoperation_id	numeric	10				Product Manufacturing Operation
m_productoperation	m_productoperation_id	numeric	10				Product Manufacturing Operation
m_productoperation	m_productoperation_uu	varchar	36	√		NULL::character varying	M_ProductOperation_UU
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
m_bom	name	varchar	60				Alphanumeric identifier of the entity
m_bomalternative	name	varchar	60				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_operationresource	name	varchar	60				Alphanumeric identifier of the entity
m_product	name	varchar	255				Alphanumeric identifier of the entity
m_productoperation	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_requesttype	name	varchar	60				Alphanumeric identifier of the entity
r_request	nextaction	bpchar	1	√		null	Next Action to be taken
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_changerequest	pp_product_bom_id	numeric	10	√		null	BOM & Formula
r_group	pp_product_bom_id	numeric	10	√		null	BOM & Formula
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
m_changenotice	processed	bpchar	1			'N'::bpchar	The document has been processed
m_changerequest	processed	bpchar	1			'N'::bpchar	The document has been processed
r_request	processed	bpchar	1			'N'::bpchar	The document has been processed
m_bom	processing	bpchar	1	√		null	Process Now
m_changenotice	processing	bpchar	1	√		null	Process Now
m_product	processing	bpchar	1	√		null	Process Now
m_product	producttype	bpchar	1			'I'::bpchar	Type of product
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_category	r_category_id	numeric	10				Request Category
r_request	r_category_id	numeric	10	√		null	Request Category
r_category	r_category_uu	varchar	36	√		NULL::character varying	R_Category_UU
r_group	r_group_id	numeric	10				Request Group
r_request	r_group_id	numeric	10	√		null	Request Group
r_group	r_group_uu	varchar	36	√		NULL::character varying	R_Group_UU
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_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_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_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_requesttype	r_statuscategory_id	numeric	10				Request Status Category
r_request	record_id	numeric	10	√		null	Direct internal record ID
r_request	record_uu	varchar	36	√		NULL::character varying	Record UUID
r_request	requestamt	numeric	0			0	Amount associated with this request
r_request	result	varchar	2000	√		null	Result of the action taken
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
r_request	salesrep_id	numeric	10				Sales Representative or Company Agent
m_bomproduct	seqno	numeric	10	√		0	Method of ordering records; lowest number comes first
m_attributesetinstance	serno	varchar	40	√		null	Product Serial Number
m_operationresource	setuptime	numeric	0			0	Setup time before starting Production
m_productoperation	setuptime	numeric	0	√		0	Setup time before starting Production
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
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
m_operationresource	teardowntime	numeric	0			0	Time at the end of the operation
m_productoperation	teardowntime	numeric	0	√		0	Time at the end of the operation
m_operationresource	unitruntime	numeric	0			0	Time to produce one unit
m_productoperation	unitruntime	numeric	0	√		0	Time to produce one 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_attributesetinstance	updated	timestamp	29,6			now()	Date this record was updated
m_bom	updated	timestamp	29,6			now()	Date this record was updated
m_bomalternative	updated	timestamp	29,6			now()	Date this record was updated
m_bomproduct	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_operationresource	updated	timestamp	29,6			now()	Date this record was updated
m_product	updated	timestamp	29,6			now()	Date this record was updated
m_product_acct	updated	timestamp	29,6			now()	Date this record was updated
m_product_bom	updated	timestamp	29,6	√		null	Date this record was updated
m_productoperation	updated	timestamp	29,6			now()	Date this record was updated
r_category	updated	timestamp	29,6			now()	Date this record was updated
r_group	updated	timestamp	29,6			now()	Date this record was updated
r_request	updated	timestamp	29,6			now()	Date this record was updated
r_requesttype	updated	timestamp	29,6			now()	Date this record was updated
m_attributesetinstance	updatedby	numeric	10				User who updated this records
m_bom	updatedby	numeric	10				User who updated this records
m_bomalternative	updatedby	numeric	10				User who updated this records
m_bomproduct	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_operationresource	updatedby	numeric	10				User who updated this records
m_product	updatedby	numeric	10				User who updated this records
m_product_acct	updatedby	numeric	10				User who updated this records
m_product_bom	updatedby	numeric	10	√		null	User who updated this records
m_productoperation	updatedby	numeric	10				User who updated this records
r_category	updatedby	numeric	10				User who updated this records
r_group	updatedby	numeric	10				User who updated this records
r_request	updatedby	numeric	10				User who updated this records
r_requesttype	updatedby	numeric	10				User who updated this records
m_product	value	varchar	510				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