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

idempiere9.adempiere contains 356 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
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_type_id numeric 10  √  null Asset Type
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_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
ad_user ad_image_id numeric 10  √  NULL::numeric Image or Icon
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_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
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
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_uu varchar 36  √  NULL::character varying C_JobAssignment_UU
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_remuneration c_remuneration_uu varchar 36  √  NULL::character varying C_Remuneration_UU
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)
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 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_orginfo fax varchar 40  √  NULL::character varying Facsimile number
ad_user fax varchar 40  √  null Facsimile number
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
ad_user ismenuautoexpand bpchar 1  √  null If ticked, the menu is automatically expanded
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
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
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_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_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_uu varchar 36  √  NULL::character varying M_OperationResource_UU
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_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 nextmaintenanceuseunit numeric 10  √  null
a_asset nextmaintenencedate timestamp 29,6  √  null Next Maintenence Date
a_asset nextmaintenenceunit numeric 10  √  null Next Maintenence Unit
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 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
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_productoperation setuptime numeric 0  √  0 Setup time before starting Production
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
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_productoperation unitruntime numeric 0  √  0 Time to produce one unit
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
ad_user_substitute validfrom timestamp 29,6  √  null 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)
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 a_asset_action varchar 2 'MD'::character varying Asset Action
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
a_asset a_asset_status varchar 2 'NW'::character varying Asset Status
a_asset_use a_asset_use_id numeric 10 A_Asset_Use_ID
a_asset a_assettype varchar 3 'MFX'::character varying Asset Type
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.
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_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
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
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
c_jobassignment c_jobassignment_id numeric 10 Assignment of Employee (User) to Job Position
c_job c_jobcategory_id numeric 10 Job Position Category
c_jobremuneration c_jobremuneration_id numeric 10 Remuneration for the Position
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_userremuneration c_userremuneration_id numeric 10 Employee Wage or Salary Overwrite
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_orginfo duns varchar 11 Dun & Bradstreet Number
ad_user failedlogincount numeric 10 (0)::numeric Failed Login Count
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 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 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
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_bom m_bom_id numeric 10 Bill of Material
m_bomproduct m_bom_id numeric 10 Bill of Material
m_bomproduct m_bomproduct_id numeric 10 Bill of Material Component (Product)
m_operationresource m_operationresource_id numeric 10 Product Operation Resource
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_operationresource m_productoperation_id numeric 10 Product Manufacturing Operation
m_productoperation m_productoperation_id numeric 10 Product Manufacturing Operation
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
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
a_asset processed bpchar 1 'N'::bpchar The document has been processed
c_remuneration remunerationtype bpchar 1 Type of Remuneration
m_operationresource 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 taxid varchar 20 Tax Identification
m_operationresource teardowntime numeric 0 0 Time at the end of the operation
m_operationresource 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_use useunits numeric 10 Currently used units of the assets
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)
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