idempiere9.adempiere contains 356 columns - click on heading to sort:

Table	Column	Type	Size	Nulls	Auto	Default
a_asset	a_asset_action	varchar	2			'MD'::character varying	Asset Action
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	a_asset_group_id	numeric	10				Group of Assets
a_asset	a_asset_id	numeric	10				Asset used internally or by customers
a_asset_use	a_asset_id	numeric	10				Asset used internally or by customers
m_operationresource	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_status	varchar	2			'NW'::character varying	Asset Status
a_asset	a_asset_type_id	numeric	10	√		null	Asset Type
a_asset_use	a_asset_use_id	numeric	10				A_Asset_Use_ID
a_asset_use	a_asset_use_uu	varchar	36	√		NULL::character varying	A_Asset_Use_UU
a_asset	a_asset_uu	varchar	36	√		NULL::character varying	A_Asset_UU
a_asset	a_assettype	varchar	3			'MFX'::character varying	Asset Type
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
a_asset	ad_client_id	numeric	10				Client/Tenant for this installation.
a_asset_use	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_org	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_orginfo	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_user	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_user_substitute	ad_client_id	numeric	10				Client/Tenant for this installation.
c_job	ad_client_id	numeric	10				Client/Tenant for this installation.
c_jobassignment	ad_client_id	numeric	10				Client/Tenant for this installation.
c_jobremuneration	ad_client_id	numeric	10				Client/Tenant for this installation.
c_remuneration	ad_client_id	numeric	10				Client/Tenant for this installation.
c_userremuneration	ad_client_id	numeric	10				Client/Tenant for this installation.
m_bom	ad_client_id	numeric	10				Client/Tenant for this installation.
m_bomproduct	ad_client_id	numeric	10				Client/Tenant for this installation.
m_operationresource	ad_client_id	numeric	10				Client/Tenant for this installation.
m_productoperation	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_user	ad_image_id	numeric	10	√		NULL::numeric	Image or Icon
a_asset	ad_org_id	numeric	10				Organizational entity within client
a_asset_use	ad_org_id	numeric	10				Organizational entity within client
ad_org	ad_org_id	numeric	10				Organizational entity within client
ad_orginfo	ad_org_id	numeric	10				Organizational entity within client
ad_user	ad_org_id	numeric	10				Organizational entity within client
ad_user_substitute	ad_org_id	numeric	10				Organizational entity within client
c_job	ad_org_id	numeric	10				Organizational entity within client
c_jobassignment	ad_org_id	numeric	10				Organizational entity within client
c_jobremuneration	ad_org_id	numeric	10				Organizational entity within client
c_remuneration	ad_org_id	numeric	10				Organizational entity within client
c_userremuneration	ad_org_id	numeric	10				Organizational entity within client
m_bom	ad_org_id	numeric	10				Organizational entity within client
m_bomproduct	ad_org_id	numeric	10				Organizational entity within client
m_operationresource	ad_org_id	numeric	10				Organizational entity within client
m_productoperation	ad_org_id	numeric	10				Organizational entity within client
ad_org	ad_org_uu	varchar	36	√		NULL::character varying	AD_Org_UU
ad_orginfo	ad_orginfo_uu	varchar	36	√		NULL::character varying	AD_OrgInfo_UU
ad_user	ad_orgtrx_id	numeric	10	√		null	Performing or initiating organization
ad_orginfo	ad_orgtype_id	numeric	10	√		null	Organization Type
ad_org	ad_replicationstrategy_id	numeric	0	√		null	Data Replication Strategy
a_asset	ad_user_id	numeric	10	√		null	User within the system - Internal or Business Partner Contact
ad_user	ad_user_id	numeric	10				User within the system - Internal or Business Partner Contact
ad_user_substitute	ad_user_id	numeric	10				User within the system - Internal or Business Partner Contact
c_jobassignment	ad_user_id	numeric	10				User within the system - Internal or Business Partner Contact
c_userremuneration	ad_user_id	numeric	10				User within the system - Internal or Business Partner Contact
ad_user_substitute	ad_user_substitute_id	numeric	10				Substitute of the user
ad_user_substitute	ad_user_substitute_uu	varchar	36	√		NULL::character varying	AD_User_Substitute_UU
ad_user	ad_user_uu	varchar	36	√		NULL::character varying	AD_User_UU
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
ad_user	birthday	timestamp	29,6	√		null	Birthday or Anniversary day
m_bomproduct	bomproducttype	bpchar	1				BOM Product Type
m_bomproduct	bomqty	numeric	0			0	Bill of Materials Quantity
m_bom	bomtype	bpchar	1				Type of BOM
m_bom	bomuse	bpchar	1				The use of the Bill of Material
ad_user	bp_location_id	numeric	10	√		NULL::numeric	Address of the Business Partner
ad_user	bpname	varchar	60	√		NULL::character varying	BP Name
a_asset	c_activity_id	numeric	10	√		NULL::numeric	Business Activity
a_asset	c_bpartner_id	numeric	10	√		null	Identifies a Business Partner
ad_user	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
a_asset	c_bpartnersr_id	numeric	10	√		null	Business Partner (Agent or Sales Rep)
ad_orginfo	c_calendar_id	numeric	10	√		null	Accounting Calendar Name
ad_user	c_campaign_id	numeric	10	√		NULL::numeric	Marketing Campaign
ad_user	c_greeting_id	numeric	10	√		null	Greeting to print on correspondence
ad_user	c_job_id	numeric	10	√		null	Job Position
c_job	c_job_id	numeric	10				Job Position
c_jobassignment	c_job_id	numeric	10				Job Position
c_jobremuneration	c_job_id	numeric	10				Job Position
m_operationresource	c_job_id	numeric	10	√		null	Job Position
c_job	c_job_uu	varchar	36	√		NULL::character varying	C_Job_UU
c_jobassignment	c_jobassignment_id	numeric	10				Assignment of Employee (User) to Job Position
c_jobassignment	c_jobassignment_uu	varchar	36	√		NULL::character varying	C_JobAssignment_UU
c_job	c_jobcategory_id	numeric	10				Job Position Category
c_jobremuneration	c_jobremuneration_id	numeric	10				Remuneration for the Position
c_jobremuneration	c_jobremuneration_uu	varchar	36	√		NULL::character varying	C_JobRemuneration_UU
a_asset	c_location_id	numeric	10	√		null	Location or Address
ad_orginfo	c_location_id	numeric	10	√		null	Location or Address
ad_user	c_location_id	numeric	10	√		NULL::numeric	Location or Address
a_asset	c_project_id	numeric	10	√		null	Financial Project
c_jobremuneration	c_remuneration_id	numeric	10				Wage or Salary
c_remuneration	c_remuneration_id	numeric	10				Wage or Salary
c_userremuneration	c_remuneration_id	numeric	10				Wage or Salary
c_remuneration	c_remuneration_uu	varchar	36	√		NULL::character varying	C_Remuneration_UU
c_userremuneration	c_userremuneration_id	numeric	10				Employee Wage or Salary Overwrite
c_userremuneration	c_userremuneration_uu	varchar	36	√		NULL::character varying	C_UserRemuneration_UU
ad_user	comments	varchar	2000	√		null	Comments or additional information
ad_user	connectionprofile	bpchar	1	√		null	How a Java Client connects to the server(s)
a_asset	created	timestamp	29,6			now()	Date this record was created
a_asset_use	created	timestamp	29,6			statement_timestamp()	Date this record was created
ad_org	created	timestamp	29,6			now()	Date this record was created
ad_orginfo	created	timestamp	29,6			now()	Date this record was created
ad_user	created	timestamp	29,6			now()	Date this record was created
ad_user_substitute	created	timestamp	29,6			now()	Date this record was created
c_job	created	timestamp	29,6			now()	Date this record was created
c_jobassignment	created	timestamp	29,6			now()	Date this record was created
c_jobremuneration	created	timestamp	29,6			now()	Date this record was created
c_remuneration	created	timestamp	29,6			now()	Date this record was created
c_userremuneration	created	timestamp	29,6			now()	Date this record was created
m_bom	created	timestamp	29,6			now()	Date this record was created
m_bomproduct	created	timestamp	29,6			now()	Date this record was created
m_operationresource	created	timestamp	29,6			now()	Date this record was created
m_productoperation	created	timestamp	29,6			now()	Date this record was created
a_asset	createdby	numeric	10				User who created this records
a_asset_use	createdby	numeric	10				User who created this records
ad_org	createdby	numeric	10				User who created this records
ad_orginfo	createdby	numeric	10				User who created this records
ad_user	createdby	numeric	10				User who created this records
ad_user_substitute	createdby	numeric	10				User who created this records
c_job	createdby	numeric	10				User who created this records
c_jobassignment	createdby	numeric	10				User who created this records
c_jobremuneration	createdby	numeric	10				User who created this records
c_remuneration	createdby	numeric	10				User who created this records
c_userremuneration	createdby	numeric	10				User who created this records
m_bom	createdby	numeric	10				User who created this records
m_bomproduct	createdby	numeric	10				User who created this records
m_operationresource	createdby	numeric	10				User who created this records
m_productoperation	createdby	numeric	10				User who created this records
ad_user	dateaccountlocked	timestamp	29,6	√		null	Date Account Locked
ad_user	datelastlogin	timestamp	29,6	√		null	Date Last Login
ad_user	datepasswordchanged	timestamp	29,6	√		null	Date Password Changed
a_asset	description	varchar	255	√		null	Optional short description of the record
a_asset_use	description	varchar	255	√		null	Optional short description of the record
ad_org	description	varchar	255	√		null	Optional short description of the record
ad_user	description	varchar	255	√		null	Optional short description of the record
ad_user_substitute	description	varchar	255	√		null	Optional short description of the record
c_job	description	varchar	255	√		null	Optional short description of the record
c_jobassignment	description	varchar	255	√		null	Optional short description of the record
c_jobremuneration	description	varchar	255	√		null	Optional short description of the record
c_remuneration	description	varchar	255	√		null	Optional short description of the record
c_userremuneration	description	varchar	255	√		null	Optional short description of the record
m_bom	description	varchar	255	√		null	Optional short description of the record
m_bomproduct	description	varchar	255	√		null	Optional short description of the record
m_operationresource	description	varchar	255	√		null	Optional short description of the record
m_productoperation	description	varchar	255	√		null	Optional short description of the record
ad_orginfo	dropship_warehouse_id	numeric	10	√		null	The (logical) warehouse to use for recording drop ship receipts and shipments.
ad_orginfo	duns	varchar	11				Dun & Bradstreet Number
ad_orginfo	email	varchar	60	√		NULL::character varying	Electronic Mail Address
ad_user	email	varchar	60	√		null	Electronic Mail Address
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
ad_user	failedlogincount	numeric	10			(0)::numeric	Failed Login Count
ad_orginfo	fax	varchar	40	√		NULL::character varying	Facsimile number
ad_user	fax	varchar	40	√		null	Facsimile number
c_remuneration	grossramt	numeric	0			0	Gross Remuneration Amount
c_userremuneration	grossramt	numeric	0			0	Gross Remuneration Amount
c_remuneration	grossrcost	numeric	0			0	Gross Remuneration Costs
c_userremuneration	grossrcost	numeric	0			0	Gross Remuneration Costs
a_asset	guaranteedate	timestamp	29,6	√		null	Date when guarantee expires
a_asset	help	varchar	2000	√		null	Comment or Hint
c_job	help	varchar	2000	√		null	Comment or Hint
c_remuneration	help	varchar	2000	√		null	Comment or Hint
m_bom	help	varchar	2000	√		null	Comment or Hint
m_bomproduct	help	varchar	2000	√		null	Comment or Hint
m_operationresource	help	varchar	2000	√		null	Comment or Hint
m_productoperation	help	varchar	2000	√		null	Comment or Hint
a_asset	inventoryno	varchar	30	√		NULL::character varying	Inventory No
a_asset	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
a_asset_use	isactive	bpchar	1				The record is active in the system
ad_org	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_orginfo	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_user_substitute	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_job	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_jobassignment	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_jobremuneration	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_remuneration	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_userremuneration	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_bomproduct	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_productoperation	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
ad_user	isbillto	bpchar	1			'N'::bpchar	Business Partner Invoice/Bill Address
a_asset	isdepreciated	bpchar	1			'Y'::bpchar	The asset will be depreciated
a_asset	isdisposed	bpchar	1			'N'::bpchar	The asset is disposed
c_job	isemployee	bpchar	1			'N'::bpchar	Indicates if this Business Partner is an employee
ad_user	isexpired	bpchar	1			'N'::bpchar	Expired
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_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
ad_user	islocked	bpchar	1			'N'::bpchar	Locked
ad_user	ismenuautoexpand	bpchar	1	√		null	If ticked, the menu is automatically expanded
ad_user	isnoexpire	bpchar	1			'N'::bpchar	No Expire
ad_user	isnopasswordreset	bpchar	1			'N'::bpchar	No Password Reset
a_asset	isowned	bpchar	1			'Y'::bpchar	The asset is owned by the organization
m_bomproduct	isphantom	bpchar	1			'N'::bpchar	Phantom Component
ad_user	issaleslead	bpchar	1			'N'::bpchar	This contact is a sales lead
ad_user	isshipto	bpchar	1			'N'::bpchar	Business Partner Shipment Address
ad_org	issummary	bpchar	1			'N'::bpchar	This is a summary entity
ad_user	issupportuser	bpchar	1			'N'::bpchar	Support User
ad_user	isvendorlead	bpchar	1			'N'::bpchar	This contact is a vendor lead
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
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
m_bomproduct	leadtimeoffset	numeric	10			0	Optional Lead Time offset before starting production
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
m_bomproduct	line	numeric	10			0	Unique line for this document
a_asset	locationcomment	varchar	255	√		null	Additional comments or remarks concerning the location
ad_orginfo	logo_id	numeric	10	√		NULL::numeric	Logo
a_asset	lot	varchar	255	√		null	Lot number (alphanumeric)
a_asset	m_attributesetinstance_id	numeric	10	√		0	Product Attribute Set Instance
m_bomproduct	m_attributesetinstance_id	numeric	10	√		null	Product Attribute Set Instance
m_bom	m_bom_id	numeric	10				Bill of Material
m_bomproduct	m_bom_id	numeric	10				Bill of Material
m_bom	m_bom_uu	varchar	36	√		NULL::character varying	M_BOM_UU
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_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)
a_asset	m_inoutline_id	numeric	10	√		null	Line on Shipment or Receipt document
a_asset	m_locator_id	numeric	10	√		null	Warehouse Locator
m_operationresource	m_operationresource_id	numeric	10				Product Operation Resource
m_operationresource	m_operationresource_uu	varchar	36	√		NULL::character varying	M_OperationResource_UU
a_asset	m_product_id	numeric	10				Product, Service, Item
m_bom	m_product_id	numeric	10				Product, Service, Item
m_productoperation	m_product_id	numeric	10				Product, Service, Item
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_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
ad_orginfo	m_warehouse_id	numeric	10	√		null	Storage Warehouse and Service Point
a_asset	manufacturedyear	numeric	10	√		NULL::numeric	Manufactured Year
a_asset	manufacturer	varchar	30	√		NULL::character varying	Manufacturer of the Product
a_asset	name	varchar	60				Alphanumeric identifier of the entity
ad_org	name	varchar	60				Alphanumeric identifier of the entity
ad_user	name	varchar	60				Alphanumeric identifier of the entity
ad_user_substitute	name	varchar	60				Alphanumeric identifier of the entity
c_job	name	varchar	60				Alphanumeric identifier of the entity
c_remuneration	name	varchar	60				Alphanumeric identifier of the entity
m_bom	name	varchar	60				Alphanumeric identifier of the entity
m_operationresource	name	varchar	60				Alphanumeric identifier of the entity
m_productoperation	name	varchar	60				Alphanumeric identifier of the entity
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
ad_user	notificationtype	bpchar	1			'X'::bpchar	Type of Notifications
c_remuneration	overtimeamt	numeric	0			0	Hourly Overtime Rate
c_userremuneration	overtimeamt	numeric	0			0	Hourly Overtime Rate
c_remuneration	overtimecost	numeric	0			0	Hourly Overtime Cost
c_userremuneration	overtimecost	numeric	0			0	Hourly Overtime Cost
ad_orginfo	pa_goal_id	numeric	10	√		null
ad_orginfo	parent_org_id	numeric	10	√		null	Parent (superior) Organization
ad_user	password	varchar	1024	√		null	Password of any length (case sensitive)
ad_orginfo	phone	varchar	40	√		NULL::character varying	Identifies a telephone number
ad_user	phone	varchar	40	√		null	Identifies a telephone number
ad_orginfo	phone2	varchar	40	√		NULL::character varying	Identifies an alternate telephone number.
ad_user	phone2	varchar	40	√		null	Identifies an alternate telephone number.
a_asset	processed	bpchar	1			'N'::bpchar	The document has been processed
a_asset	processing	bpchar	1	√		'N'::bpchar	Process Now
ad_user	processing	bpchar	1	√		null	Process Now
m_bom	processing	bpchar	1	√		null	Process Now
a_asset	qty	numeric	0	√		null	Quantity
ad_user	r_defaultmailtext_id	numeric	10	√		NULL::numeric	Default mail template
ad_orginfo	receiptfootermsg	varchar	1023	√		null	This message will be displayed at the bottom of a receipt when doing a sales or purchase
c_remuneration	remunerationtype	bpchar	1				Type of Remuneration
ad_user	salesrep_id	numeric	10	√		NULL::numeric	Sales Representative or Company Agent
ad_user	salt	varchar	16	√		NULL::character varying	Random data added to improve password hash effectiveness
ad_user	securityquestion	varchar	1024	√		null	Security Question
m_bomproduct	seqno	numeric	10	√		0	Method of ordering records; lowest number comes first
a_asset	serno	varchar	255	√		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
c_remuneration	standardhours	numeric	10			0	Standard Work Hours based on Remuneration Type
ad_user_substitute	substitute_id	numeric	10				Entity which can be used in place of this entity
ad_orginfo	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
ad_orginfo	taxid	varchar	20				Tax Identification
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
ad_user	title	varchar	40	√		null	Name this entity is referred to as
ad_orginfo	transferbank_id	numeric	0	√		null	Bank account depending on currency will be used from this bank for doing transfers
ad_orginfo	transfercashbook_id	numeric	0	√		null	CashBook for transfers
m_operationresource	unitruntime	numeric	0			0	Time to produce one unit
m_productoperation	unitruntime	numeric	0	√		0	Time to produce one unit
a_asset	updated	timestamp	29,6			now()	Date this record was updated
a_asset_use	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
ad_org	updated	timestamp	29,6			now()	Date this record was updated
ad_orginfo	updated	timestamp	29,6			now()	Date this record was updated
ad_user	updated	timestamp	29,6			now()	Date this record was updated
ad_user_substitute	updated	timestamp	29,6			now()	Date this record was updated
c_job	updated	timestamp	29,6			now()	Date this record was updated
c_jobassignment	updated	timestamp	29,6			now()	Date this record was updated
c_jobremuneration	updated	timestamp	29,6			now()	Date this record was updated
c_remuneration	updated	timestamp	29,6			now()	Date this record was updated
c_userremuneration	updated	timestamp	29,6			now()	Date this record was updated
m_bom	updated	timestamp	29,6			now()	Date this record was updated
m_bomproduct	updated	timestamp	29,6			now()	Date this record was updated
m_operationresource	updated	timestamp	29,6			now()	Date this record was updated
m_productoperation	updated	timestamp	29,6			now()	Date this record was updated
a_asset	updatedby	numeric	10				User who updated this records
a_asset_use	updatedby	numeric	10				User who updated this records
ad_org	updatedby	numeric	10				User who updated this records
ad_orginfo	updatedby	numeric	10				User who updated this records
ad_user	updatedby	numeric	10				User who updated this records
ad_user_substitute	updatedby	numeric	10				User who updated this records
c_job	updatedby	numeric	10				User who updated this records
c_jobassignment	updatedby	numeric	10				User who updated this records
c_jobremuneration	updatedby	numeric	10				User who updated this records
c_remuneration	updatedby	numeric	10				User who updated this records
c_userremuneration	updatedby	numeric	10				User who updated this records
m_bom	updatedby	numeric	10				User who updated this records
m_bomproduct	updatedby	numeric	10				User who updated this records
m_operationresource	updatedby	numeric	10				User who updated this records
m_productoperation	updatedby	numeric	10				User who updated this records
a_asset_use	usedate	timestamp	29,6				UseDate
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
ad_user	userpin	varchar	20	√		null	User PIN
a_asset	useunits	numeric	0	√		null	Currently used units of the assets
a_asset_use	useunits	numeric	10				Currently used units of the assets
ad_user_substitute	validfrom	timestamp	29,6	√		null	Valid from including this date (first day)
c_jobassignment	validfrom	timestamp	29,6				Valid from including this date (first day)
c_jobremuneration	validfrom	timestamp	29,6				Valid from including this date (first day)
c_userremuneration	validfrom	timestamp	29,6				Valid from including this date (first day)
ad_user_substitute	validto	timestamp	29,6	√		null	Valid to including this date (last day)
c_jobassignment	validto	timestamp	29,6	√		null	Valid to including this date (last day)
c_jobremuneration	validto	timestamp	29,6	√		null	Valid to including this date (last day)
c_userremuneration	validto	timestamp	29,6	√		null	Valid to including this date (last day)
a_asset	value	varchar	40				Search key for the record in the format required - must be unique
ad_org	value	varchar	40				Search key for the record in the format required - must be unique
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