SchemaSpy Analysis of idempiere11.adempiere - ColumnsProduct Operation | Generated by Quality Systems & Solutions |
Generated on 2024-01-03 13:54 +0100 |
| |||||
|
idempiere11.adempiere contains 358 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 | 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 | 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 | Tenant for this installation. | |||
a_asset | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
a_asset | ad_user_id | numeric | 10 | √ | null | User within the system - Internal or Business Partner Contact | |
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 | |
a_asset | c_activity_id | numeric | 10 | √ | NULL::numeric | Business Activity | |
a_asset | 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 | |
a_asset | c_bpartnersr_id | numeric | 10 | √ | null | Business Partner (Agent or Sales Rep) | |
a_asset | c_location_id | numeric | 10 | √ | null | Location or Address | |
a_asset | c_project_id | numeric | 10 | √ | null | Financial Project | |
a_asset | created | timestamp | 29,6 | now() | Date this record was created | ||
a_asset | createdby | numeric | 10 | User who created this records | |||
a_asset | description | varchar | 255 | √ | null | Optional short description of the record | |
a_asset | guaranteedate | timestamp | 29,6 | √ | null | Date when guarantee expires | |
a_asset | 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 | isdepreciated | bpchar | 1 | 'Y'::bpchar | The asset will be depreciated | ||
a_asset | isdisposed | bpchar | 1 | 'N'::bpchar | The asset is disposed | ||
a_asset | isfullydepreciated | bpchar | 1 | 'N'::bpchar | The asset is fully depreciated | ||
a_asset | isinposession | bpchar | 1 | 'Y'::bpchar | The asset is in the possession of the organization | ||
a_asset | isowned | bpchar | 1 | 'Y'::bpchar | The asset is owned by the organization | ||
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 | ||
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 | |
a_asset | lot | varchar | 255 | √ | null | Lot number (alphanumeric) | |
a_asset | m_attributesetinstance_id | numeric | 10 | √ | 0 | Product Attribute Set Instance | |
a_asset | m_inoutline_id | numeric | 10 | √ | null | Line on Shipment or Receipt document | |
a_asset | m_locator_id | numeric | 10 | √ | null | Warehouse Locator | |
a_asset | m_product_id | numeric | 10 | Product, Service, Item | |||
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 | |||
a_asset | nextmaintenanceuseunit | numeric | 10 | √ | null | ||
a_asset | nextmaintenencedate | timestamp | 29,6 | √ | null | Next Maintenance Date | |
a_asset | nextmaintenenceunit | numeric | 10 | √ | null | Next Maintenence Unit | |
a_asset | processed | bpchar | 1 | 'N'::bpchar | The document has been processed | ||
a_asset | processing | bpchar | 1 | √ | 'N'::bpchar | Process Now | |
a_asset | qty | numeric | 0 | √ | null | Quantity | |
a_asset | serno | varchar | 255 | √ | null | Product Serial Number | |
a_asset | updated | timestamp | 29,6 | now() | Date this record was updated | ||
a_asset | updatedby | numeric | 10 | User who updated this records | |||
a_asset | uselifemonths | numeric | 10 | √ | null | Months of the usable life of the asset | |
a_asset | uselifeyears | numeric | 0 | √ | null | Years of the usable life of the asset | |
a_asset | useunits | numeric | 0 | √ | null | Currently used units of the assets | |
a_asset | value | varchar | 40 | Search key for the record in the format required - must be unique | |||
a_asset | versionno | varchar | 20 | √ | null | Version Number | |
a_asset_use | a_asset_id | numeric | 10 | Asset used internally or by customers | |||
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_use | ad_client_id | numeric | 10 | Tenant for this installation. | |||
a_asset_use | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
a_asset_use | created | timestamp | 29,6 | statement_timestamp() | Date this record was created | ||
a_asset_use | createdby | numeric | 10 | User who created this records | |||
a_asset_use | description | varchar | 255 | √ | null | Optional short description of the record | |
a_asset_use | isactive | bpchar | 1 | The record is active in the system | |||
a_asset_use | updated | timestamp | 29,6 | statement_timestamp() | Date this record was updated | ||
a_asset_use | updatedby | numeric | 10 | User who updated this records | |||
a_asset_use | usedate | timestamp | 29,6 | Use Date | |||
a_asset_use | useunits | numeric | 10 | Currently used units of the assets | |||
ad_org | ad_client_id | numeric | 10 | Tenant for this installation. | |||
ad_org | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
ad_org | ad_org_uu | varchar | 36 | √ | NULL::character varying | AD_Org_UU | |
ad_org | ad_replicationstrategy_id | numeric | 0 | √ | null | Data Replication Strategy | |
ad_org | created | timestamp | 29,6 | now() | Date this record was created | ||
ad_org | createdby | numeric | 10 | User who created this records | |||
ad_org | description | varchar | 255 | √ | null | Optional short description of the record | |
ad_org | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
ad_org | issummary | bpchar | 1 | 'N'::bpchar | This is a summary entity | ||
ad_org | name | varchar | 60 | Alphanumeric identifier of the entity | |||
ad_org | updated | timestamp | 29,6 | now() | Date this record was updated | ||
ad_org | updatedby | numeric | 10 | User who updated this records | |||
ad_org | value | varchar | 40 | Search key for the record in the format required - must be unique | |||
ad_orginfo | ad_client_id | numeric | 10 | Tenant for this installation. | |||
ad_orginfo | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
ad_orginfo | ad_orginfo_uu | varchar | 36 | √ | NULL::character varying | AD_OrgInfo_UU | |
ad_orginfo | ad_orgtype_id | numeric | 10 | √ | null | Organization Type | |
ad_orginfo | c_calendar_id | numeric | 10 | √ | null | Accounting Calendar Name | |
ad_orginfo | c_location_id | numeric | 10 | √ | null | Location or Address | |
ad_orginfo | created | timestamp | 29,6 | now() | Date this record was created | ||
ad_orginfo | createdby | numeric | 10 | User who created this records | |||
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 | varchar | 60 | √ | NULL::character varying | Electronic Mail Address | ||
ad_orginfo | fax | varchar | 40 | √ | NULL::character varying | Facsimile number | |
ad_orginfo | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
ad_orginfo | logo_id | numeric | 10 | √ | NULL::numeric | Logo | |
ad_orginfo | m_warehouse_id | numeric | 10 | √ | null | Storage Warehouse and Service Point | |
ad_orginfo | pa_goal_id | numeric | 10 | √ | null | ||
ad_orginfo | parent_org_id | numeric | 10 | √ | null | Parent (superior) Organization | |
ad_orginfo | phone | varchar | 40 | √ | NULL::character varying | Identifies a telephone number | |
ad_orginfo | phone2 | varchar | 40 | √ | NULL::character varying | Identifies an alternate telephone number. | |
ad_orginfo | receiptfootermsg | varchar | 1023 | √ | null | This message will be displayed at the bottom of a receipt when doing a sales or purchase | |
ad_orginfo | supervisor_id | numeric | 10 | √ | null | Supervisor for this user/organization - used for escalation and approval | |
ad_orginfo | taxid | varchar | 20 | Tax Identification | |||
ad_orginfo | timezone | varchar | 60 | √ | NULL::character varying | Time zone name | |
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 | |
ad_orginfo | updated | timestamp | 29,6 | now() | Date this record was updated | ||
ad_orginfo | updatedby | numeric | 10 | User who updated this records | |||
ad_user | ad_client_id | numeric | 10 | Tenant for this installation. | |||
ad_user | ad_image_id | numeric | 10 | √ | NULL::numeric | Image or Icon | |
ad_user | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
ad_user | ad_orgtrx_id | numeric | 10 | √ | null | Performing or initiating organization | |
ad_user | ad_user_id | numeric | 10 | User within the system - Internal or Business Partner Contact | |||
ad_user | ad_user_uu | varchar | 36 | √ | NULL::character varying | AD_User_UU | |
ad_user | answer | varchar | 1024 | √ | NULL::character varying | Answer | |
ad_user | authenticationtype | varchar | 10 | √ | NULL::character varying | Authentication Type | |
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 | |
ad_user | c_bpartner_id | numeric | 10 | √ | null | Identifies a Business Partner | |
ad_user | c_bpartner_location_id | numeric | 10 | √ | null | Identifies the (ship to) address for this Business Partner | |
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 | |
ad_user | c_location_id | numeric | 10 | √ | NULL::numeric | Location or Address | |
ad_user | comments | varchar | 2000 | √ | null | Comments or additional information | |
ad_user | connectionprofile | bpchar | 1 | √ | null | How a Java Tenant connects to the server(s) | |
ad_user | created | timestamp | 29,6 | now() | Date this record was created | ||
ad_user | 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 | |
ad_user | description | varchar | 255 | √ | null | Optional short description of the record | |
ad_user | 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_user | fax | varchar | 40 | √ | null | Facsimile number | |
ad_user | 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 | ||
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 | ||
ad_user | isinpayroll | bpchar | 1 | 'N'::bpchar | Defined if any User Contact will be used for Calculate Payroll | ||
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 | ||
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_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 | |
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 | |
ad_user | name | varchar | 60 | Alphanumeric identifier of the entity | |||
ad_user | notificationtype | bpchar | 1 | 'X'::bpchar | Type of Notifications | ||
ad_user | password | varchar | 1024 | √ | null | Password of any length (case sensitive) | |
ad_user | phone | varchar | 40 | √ | null | Identifies a telephone number | |
ad_user | phone2 | varchar | 40 | √ | null | Identifies an alternate telephone number. | |
ad_user | processing | bpchar | 1 | √ | null | Process Now | |
ad_user | r_defaultmailtext_id | numeric | 10 | √ | NULL::numeric | Default mail template | |
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 | |
ad_user | supervisor_id | numeric | 10 | √ | null | Supervisor for this user/organization - used for escalation and approval | |
ad_user | title | varchar | 40 | √ | null | Name this entity is referred to as | |
ad_user | updated | timestamp | 29,6 | now() | Date this record was updated | ||
ad_user | updatedby | numeric | 10 | User who updated this records | |||
ad_user | userpin | varchar | 20 | √ | null | User PIN | |
ad_user | value | varchar | 40 | √ | null | Search key for the record in the format required - must be unique | |
ad_user_substitute | ad_client_id | numeric | 10 | Tenant for this installation. | |||
ad_user_substitute | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
ad_user_substitute | 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_substitute | created | timestamp | 29,6 | now() | Date this record was created | ||
ad_user_substitute | createdby | numeric | 10 | User who created this records | |||
ad_user_substitute | description | varchar | 255 | √ | null | Optional short description of the record | |
ad_user_substitute | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
ad_user_substitute | name | varchar | 60 | Alphanumeric identifier of the entity | |||
ad_user_substitute | substitute_id | numeric | 10 | Entity which can be used in place of this entity | |||
ad_user_substitute | updated | timestamp | 29,6 | now() | Date this record was updated | ||
ad_user_substitute | updatedby | numeric | 10 | User who updated this records | |||
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_job | ad_client_id | numeric | 10 | Tenant for this installation. | |||
c_job | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
c_job | c_job_id | numeric | 10 | Job Position | |||
c_job | c_job_uu | varchar | 36 | √ | NULL::character varying | C_Job_UU | |
c_job | c_jobcategory_id | numeric | 10 | Job Position Category | |||
c_job | created | timestamp | 29,6 | now() | Date this record was created | ||
c_job | createdby | numeric | 10 | User who created this records | |||
c_job | description | varchar | 255 | √ | null | Optional short description of the record | |
c_job | help | varchar | 2000 | √ | null | Comment or Hint | |
c_job | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
c_job | isemployee | bpchar | 1 | 'N'::bpchar | Indicates if this Business Partner is an employee | ||
c_job | name | varchar | 60 | Alphanumeric identifier of the entity | |||
c_job | updated | timestamp | 29,6 | now() | Date this record was updated | ||
c_job | updatedby | numeric | 10 | User who updated this records | |||
c_jobassignment | ad_client_id | numeric | 10 | Tenant for this installation. | |||
c_jobassignment | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
c_jobassignment | ad_user_id | numeric | 10 | User within the system - Internal or Business Partner Contact | |||
c_jobassignment | c_job_id | numeric | 10 | Job Position | |||
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_jobassignment | created | timestamp | 29,6 | now() | Date this record was created | ||
c_jobassignment | createdby | numeric | 10 | User who created this records | |||
c_jobassignment | description | varchar | 255 | √ | null | Optional short description of the record | |
c_jobassignment | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
c_jobassignment | updated | timestamp | 29,6 | now() | Date this record was updated | ||
c_jobassignment | updatedby | numeric | 10 | User who updated this records | |||
c_jobassignment | validfrom | timestamp | 29,6 | Valid from including this date (first day) | |||
c_jobassignment | validto | timestamp | 29,6 | √ | null | Valid to including this date (last day) | |
c_jobremuneration | ad_client_id | numeric | 10 | Tenant for this installation. | |||
c_jobremuneration | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
c_jobremuneration | c_job_id | numeric | 10 | Job Position | |||
c_jobremuneration | c_jobremuneration_id | numeric | 10 | Remuneration for the Position | |||
c_jobremuneration | c_jobremuneration_uu | varchar | 36 | √ | NULL::character varying | C_JobRemuneration_UU | |
c_jobremuneration | c_remuneration_id | numeric | 10 | Wage or Salary | |||
c_jobremuneration | created | timestamp | 29,6 | now() | Date this record was created | ||
c_jobremuneration | createdby | numeric | 10 | User who created this records | |||
c_jobremuneration | description | varchar | 255 | √ | null | Optional short description of the record | |
c_jobremuneration | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
c_jobremuneration | updated | timestamp | 29,6 | now() | Date this record was updated | ||
c_jobremuneration | updatedby | numeric | 10 | User who updated this records | |||
c_jobremuneration | validfrom | timestamp | 29,6 | Valid from including this date (first day) | |||
c_jobremuneration | validto | timestamp | 29,6 | √ | null | Valid to including this date (last day) | |
c_remuneration | ad_client_id | numeric | 10 | Tenant for this installation. | |||
c_remuneration | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
c_remuneration | c_remuneration_id | numeric | 10 | Wage or Salary | |||
c_remuneration | c_remuneration_uu | varchar | 36 | √ | NULL::character varying | C_Remuneration_UU | |
c_remuneration | created | timestamp | 29,6 | now() | Date this record was created | ||
c_remuneration | createdby | numeric | 10 | User who created this records | |||
c_remuneration | description | varchar | 255 | √ | null | Optional short description of the record | |
c_remuneration | grossramt | numeric | 0 | 0 | Gross Remuneration Amount | ||
c_remuneration | grossrcost | numeric | 0 | 0 | Gross Remuneration Costs | ||
c_remuneration | help | varchar | 2000 | √ | null | Comment or Hint | |
c_remuneration | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
c_remuneration | name | varchar | 60 | Alphanumeric identifier of the entity | |||
c_remuneration | overtimeamt | numeric | 0 | 0 | Hourly Overtime Rate | ||
c_remuneration | overtimecost | numeric | 0 | 0 | Hourly Overtime Cost | ||
c_remuneration | remunerationtype | bpchar | 1 | Type of Remuneration | |||
c_remuneration | standardhours | numeric | 10 | 0 | Standard Work Hours based on Remuneration Type | ||
c_remuneration | updated | timestamp | 29,6 | now() | Date this record was updated | ||
c_remuneration | updatedby | numeric | 10 | User who updated this records | |||
c_userremuneration | ad_client_id | numeric | 10 | Tenant for this installation. | |||
c_userremuneration | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
c_userremuneration | ad_user_id | numeric | 10 | User within the system - Internal or Business Partner Contact | |||
c_userremuneration | c_remuneration_id | numeric | 10 | Wage or Salary | |||
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 | |
c_userremuneration | created | timestamp | 29,6 | now() | Date this record was created | ||
c_userremuneration | createdby | numeric | 10 | User who created this records | |||
c_userremuneration | description | varchar | 255 | √ | null | Optional short description of the record | |
c_userremuneration | grossramt | numeric | 0 | 0 | Gross Remuneration Amount | ||
c_userremuneration | grossrcost | numeric | 0 | 0 | Gross Remuneration Costs | ||
c_userremuneration | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
c_userremuneration | overtimeamt | numeric | 0 | 0 | Hourly Overtime Rate | ||
c_userremuneration | overtimecost | numeric | 0 | 0 | Hourly Overtime Cost | ||
c_userremuneration | updated | timestamp | 29,6 | now() | Date this record was updated | ||
c_userremuneration | updatedby | numeric | 10 | User who updated this records | |||
c_userremuneration | validfrom | timestamp | 29,6 | Valid from including this date (first day) | |||
c_userremuneration | validto | timestamp | 29,6 | √ | null | Valid to including this date (last day) | |
m_bom | ad_client_id | numeric | 10 | Tenant for this installation. | |||
m_bom | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
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_bomproduct | ad_client_id | numeric | 10 | Tenant for this installation. | |||
m_bomproduct | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
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_operationresource | a_asset_id | numeric | 10 | √ | null | Asset used internally or by customers | |
m_operationresource | ad_client_id | numeric | 10 | Tenant for this installation. | |||
m_operationresource | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
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_productoperation | ad_client_id | numeric | 10 | Tenant for this installation. | |||
m_productoperation | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
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 |