SchemaSpy Analysis of idempiere11.adempiere - ColumnsTrees | Generated by Quality Systems & Solutions |
Generated on 2024-01-03 13:56 +0100 |
| |||||
|
idempiere11.adempiere contains 534 columns - click on heading to sort:
Table | Column | Type | Size | Nulls | Auto | Default | |
---|---|---|---|---|---|---|---|
ad_clientinfo | ad_client_id | numeric | 10 | Tenant for this installation. | |||
ad_clientinfo | ad_clientinfo_uu | varchar | 36 | √ | NULL::character varying | AD_ClientInfo_UU | |
ad_clientinfo | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
ad_clientinfo | ad_storageprovider_id | numeric | 10 | √ | NULL::numeric | Storage Provider | |
ad_clientinfo | ad_tree_activity_id | numeric | 10 | √ | null | Trees are used for (financial) reporting | |
ad_clientinfo | ad_tree_bpartner_id | numeric | 10 | √ | null | Trees are used for (financial) reporting | |
ad_clientinfo | ad_tree_campaign_id | numeric | 10 | √ | null | Trees are used for (financial) reporting | |
ad_clientinfo | ad_tree_menu_id | numeric | 10 | √ | null | Tree of the menu | |
ad_clientinfo | ad_tree_org_id | numeric | 10 | √ | null | Trees are used for (financial) reporting and security access (via role) | |
ad_clientinfo | ad_tree_product_id | numeric | 10 | √ | null | Trees are used for (financial) reporting | |
ad_clientinfo | ad_tree_project_id | numeric | 10 | √ | null | Trees are used for (financial) reporting | |
ad_clientinfo | ad_tree_salesregion_id | numeric | 10 | √ | null | Trees are used for (financial) reporting | |
ad_clientinfo | c_acctschema1_id | numeric | 10 | √ | null | Primary rules for accounting | |
ad_clientinfo | c_bpartnercashtrx_id | numeric | 10 | √ | null | Business Partner used for creating new Business Partners on the fly | |
ad_clientinfo | c_calendar_id | numeric | 10 | √ | null | Accounting Calendar Name | |
ad_clientinfo | c_chargefreight_id | numeric | 10 | √ | NULL::numeric | Charge for Freight | |
ad_clientinfo | c_uom_length_id | numeric | 10 | √ | null | Standard Unit of Measure for Length | |
ad_clientinfo | c_uom_time_id | numeric | 10 | √ | null | Standard Unit of Measure for Time | |
ad_clientinfo | c_uom_volume_id | numeric | 10 | √ | null | Standard Unit of Measure for Volume | |
ad_clientinfo | c_uom_weight_id | numeric | 10 | √ | null | Standard Unit of Measure for Weight | |
ad_clientinfo | created | timestamp | 29,6 | now() | Date this record was created | ||
ad_clientinfo | createdby | numeric | 10 | User who created this records | |||
ad_clientinfo | fy_startdate | timestamp | 29,6 | √ | null | Financial Year Start Date | |
ad_clientinfo | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
ad_clientinfo | isconfirmondocclose | bpchar | 1 | 'N'::bpchar | Show Confirmation On Document Action Close | ||
ad_clientinfo | isconfirmondocvoid | bpchar | 1 | 'N'::bpchar | Show Confirmation On Document Action Void | ||
ad_clientinfo | isdiscountlineamt | bpchar | 1 | 'Y'::bpchar | Payment Discount calculation does not include Taxes and Charges | ||
ad_clientinfo | keeplogdays | numeric | 10 | √ | null | Number of days to keep the log entries | |
ad_clientinfo | logo_id | numeric | 10 | √ | NULL::numeric | Logo | |
ad_clientinfo | logoreport_id | numeric | 10 | √ | NULL::numeric | Logo Report | |
ad_clientinfo | logoweb_id | numeric | 10 | √ | NULL::numeric | Logo Web | |
ad_clientinfo | m_productfreight_id | numeric | 10 | √ | null | Product for Freight | |
ad_clientinfo | storagearchive_id | numeric | 10 | √ | NULL::numeric | Archive Store | |
ad_clientinfo | storageimage_id | numeric | 10 | √ | NULL::numeric | Storage provider for Image | |
ad_clientinfo | timezone | varchar | 60 | √ | NULL::character varying | Time zone name | |
ad_clientinfo | updated | timestamp | 29,6 | now() | Date this record was updated | ||
ad_clientinfo | updatedby | numeric | 10 | User who updated this records | |||
ad_menu | action | bpchar | 1 | √ | null | Indicates the Action to be performed | |
ad_menu | ad_client_id | numeric | 10 | Tenant for this installation. | |||
ad_menu | ad_form_id | numeric | 10 | √ | null | Special Form | |
ad_menu | ad_infowindow_id | numeric | 10 | √ | NULL::numeric | Info and search/select Window | |
ad_menu | ad_menu_id | numeric | 10 | Identifies a Menu | |||
ad_menu | ad_menu_uu | varchar | 36 | √ | NULL::character varying | AD_Menu_UU | |
ad_menu | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
ad_menu | ad_process_id | numeric | 10 | √ | null | Process or Report | |
ad_menu | ad_task_id | numeric | 10 | √ | null | Operation System Task | |
ad_menu | ad_window_id | numeric | 10 | √ | null | Data entry or display window | |
ad_menu | ad_workbench_id | numeric | 10 | √ | null | Collection of windows, reports | |
ad_menu | ad_workflow_id | numeric | 10 | √ | null | Workflow or combination of tasks | |
ad_menu | created | timestamp | 29,6 | now() | Date this record was created | ||
ad_menu | createdby | numeric | 10 | User who created this records | |||
ad_menu | description | varchar | 255 | √ | null | Optional short description of the record | |
ad_menu | entitytype | varchar | 40 | 'D'::character varying | Dictionary Entity Type; Determines ownership and synchronization | ||
ad_menu | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
ad_menu | iscentrallymaintained | bpchar | 1 | √ | 'Y'::bpchar | Information maintained in System Element table | |
ad_menu | isreadonly | bpchar | 1 | 'N'::bpchar | Field is read only | ||
ad_menu | issotrx | bpchar | 1 | 'Y'::bpchar | This is a Sales Transaction | ||
ad_menu | issummary | bpchar | 1 | 'N'::bpchar | This is a summary entity | ||
ad_menu | name | varchar | 60 | Alphanumeric identifier of the entity | |||
ad_menu | predefinedcontextvariables | varchar | 4000 | √ | NULL::character varying | Predefined context variables to inject when opening a menu entry or a window | |
ad_menu | updated | timestamp | 29,6 | now() | Date this record was updated | ||
ad_menu | updatedby | numeric | 10 | User who updated this records | |||
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_tree | ad_client_id | numeric | 10 | Tenant for this installation. | |||
ad_tree | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
ad_tree | ad_table_id | numeric | 10 | √ | NULL::numeric | Database Table information | |
ad_tree | ad_tree_id | numeric | 10 | Identifies a Tree | |||
ad_tree | ad_tree_uu | varchar | 36 | √ | NULL::character varying | AD_Tree_UU | |
ad_tree | created | timestamp | 29,6 | now() | Date this record was created | ||
ad_tree | createdby | numeric | 10 | User who created this records | |||
ad_tree | description | varchar | 255 | √ | null | Optional short description of the record | |
ad_tree | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
ad_tree | isallnodes | bpchar | 1 | 'Y'::bpchar | All Nodes are included (Complete Tree) | ||
ad_tree | isdefault | bpchar | 1 | 'N'::bpchar | Default value | ||
ad_tree | isloadallnodesimmediately | bpchar | 1 | 'Y'::bpchar | If checked, all nodes are loaded before tree is displayed | ||
ad_tree | istreedrivenbyvalue | bpchar | 1 | 'N'::bpchar | Driven by Search Key | ||
ad_tree | isvaluedisplayed | bpchar | 1 | 'N'::bpchar | Displays Value column with the Display column | ||
ad_tree | name | varchar | 60 | Alphanumeric identifier of the entity | |||
ad_tree | parent_column_id | numeric | 10 | √ | NULL::numeric | The link column on the parent tab. | |
ad_tree | processing | bpchar | 1 | √ | null | Process Now | |
ad_tree | treetype | bpchar | 2 | Element this tree is built on (i.e Product, Business Partner) | |||
ad_tree | updated | timestamp | 29,6 | now() | Date this record was updated | ||
ad_tree | updatedby | numeric | 10 | User who updated this records | |||
ad_tree_favorite | ad_client_id | numeric | 10 | Tenant for this installation. | |||
ad_tree_favorite | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
ad_tree_favorite | ad_tree_favorite_id | numeric | 10 | Favorite Tree | |||
ad_tree_favorite | ad_tree_favorite_uu | varchar | 36 | √ | NULL::character varying | Favorite Tree | |
ad_tree_favorite | ad_user_id | numeric | 10 | User within the system - Internal or Business Partner Contact | |||
ad_tree_favorite | created | timestamp | 29,6 | √ | statement_timestamp() | Date this record was created | |
ad_tree_favorite | createdby | numeric | 10 | √ | NULL::numeric | User who created this records | |
ad_tree_favorite | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
ad_tree_favorite | updated | timestamp | 29,6 | √ | statement_timestamp() | Date this record was updated | |
ad_tree_favorite | updatedby | numeric | 10 | User who updated this records | |||
ad_tree_favorite_node | ad_client_id | numeric | 10 | Tenant for this installation. | |||
ad_tree_favorite_node | ad_menu_id | numeric | 10 | √ | NULL::numeric | Identifies a Menu | |
ad_tree_favorite_node | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
ad_tree_favorite_node | ad_tree_favorite_id | numeric | 10 | Favorite Tree | |||
ad_tree_favorite_node | ad_tree_favorite_node_id | numeric | 10 | Favorite Node Tree | |||
ad_tree_favorite_node | ad_tree_favorite_node_uu | varchar | 36 | √ | NULL::character varying | Favorite Node Tree | |
ad_tree_favorite_node | created | timestamp | 29,6 | statement_timestamp() | Date this record was created | ||
ad_tree_favorite_node | createdby | numeric | 10 | User who created this records | |||
ad_tree_favorite_node | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
ad_tree_favorite_node | iscollapsible | bpchar | 1 | 'Y'::bpchar | Flag to indicate the state of the dashboard panel | ||
ad_tree_favorite_node | isfavourite | bpchar | 1 | 'N'::bpchar | This record is a favourite | ||
ad_tree_favorite_node | issummary | bpchar | 1 | 'N'::bpchar | This is a summary entity | ||
ad_tree_favorite_node | loginopenseqno | numeric | 10 | √ | NULL::numeric | Determine the order items will be automatically opened when user logs in | |
ad_tree_favorite_node | name | varchar | 120 | √ | NULL::character varying | Alphanumeric identifier of the entity | |
ad_tree_favorite_node | parent_id | numeric | 10 | √ | NULL::numeric | Parent of Entity | |
ad_tree_favorite_node | seqno | numeric | 10 | Method of ordering records; lowest number comes first | |||
ad_tree_favorite_node | updated | timestamp | 29,6 | statement_timestamp() | Date this record was updated | ||
ad_tree_favorite_node | updatedby | numeric | 10 | User who updated this records | |||
ad_treebar | ad_client_id | numeric | 10 | Tenant for this installation. | |||
ad_treebar | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
ad_treebar | ad_tree_id | numeric | 10 | Identifies a Tree | |||
ad_treebar | ad_treebar_uu | varchar | 36 | √ | NULL::character varying | AD_TreeBar_UU | |
ad_treebar | ad_user_id | numeric | 10 | User within the system - Internal or Business Partner Contact | |||
ad_treebar | created | timestamp | 29,6 | now() | Date this record was created | ||
ad_treebar | createdby | numeric | 10 | User who created this records | |||
ad_treebar | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
ad_treebar | isfavourite | bpchar | 1 | 'Y'::bpchar | This record is a favourite | ||
ad_treebar | loginopenseqno | numeric | 10 | √ | NULL::numeric | Determine the order items will be automatically opened when user logs in | |
ad_treebar | node_id | numeric | 10 | Node | |||
ad_treebar | updated | timestamp | 29,6 | now() | Date this record was updated | ||
ad_treebar | updatedby | numeric | 10 | User who updated this records | |||
ad_treenode | ad_client_id | numeric | 10 | Tenant for this installation. | |||
ad_treenode | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
ad_treenode | ad_tree_id | numeric | 10 | Identifies a Tree | |||
ad_treenode | ad_treenode_uu | varchar | 36 | √ | NULL::character varying | AD_TreeNode_UU | |
ad_treenode | created | timestamp | 29,6 | now() | Date this record was created | ||
ad_treenode | createdby | numeric | 10 | User who created this records | |||
ad_treenode | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
ad_treenode | node_id | numeric | 10 | Node | |||
ad_treenode | parent_id | numeric | 10 | √ | null | Parent of Entity | |
ad_treenode | seqno | numeric | 10 | √ | null | Method of ordering records; lowest number comes first | |
ad_treenode | updated | timestamp | 29,6 | now() | Date this record was updated | ||
ad_treenode | updatedby | numeric | 10 | User who updated this records | |||
ad_treenodebp | ad_client_id | numeric | 10 | Tenant for this installation. | |||
ad_treenodebp | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
ad_treenodebp | ad_tree_id | numeric | 10 | Identifies a Tree | |||
ad_treenodebp | ad_treenodebp_uu | varchar | 36 | √ | NULL::character varying | AD_TreeNodeBP_UU | |
ad_treenodebp | created | timestamp | 29,6 | now() | Date this record was created | ||
ad_treenodebp | createdby | numeric | 10 | User who created this records | |||
ad_treenodebp | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
ad_treenodebp | node_id | numeric | 10 | Node | |||
ad_treenodebp | parent_id | numeric | 10 | √ | null | Parent of Entity | |
ad_treenodebp | seqno | numeric | 10 | √ | null | Method of ordering records; lowest number comes first | |
ad_treenodebp | updated | timestamp | 29,6 | now() | Date this record was updated | ||
ad_treenodebp | updatedby | numeric | 10 | User who updated this records | |||
ad_treenodemm | ad_client_id | numeric | 10 | Tenant for this installation. | |||
ad_treenodemm | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
ad_treenodemm | ad_tree_id | numeric | 10 | Identifies a Tree | |||
ad_treenodemm | ad_treenodemm_uu | varchar | 36 | √ | NULL::character varying | AD_TreeNodeMM_UU | |
ad_treenodemm | created | timestamp | 29,6 | now() | Date this record was created | ||
ad_treenodemm | createdby | numeric | 10 | User who created this records | |||
ad_treenodemm | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
ad_treenodemm | node_id | numeric | 10 | Node | |||
ad_treenodemm | parent_id | numeric | 10 | √ | null | Parent of Entity | |
ad_treenodemm | seqno | numeric | 10 | √ | null | Method of ordering records; lowest number comes first | |
ad_treenodemm | updated | timestamp | 29,6 | now() | Date this record was updated | ||
ad_treenodemm | updatedby | numeric | 10 | User who updated this records | |||
ad_treenodepr | ad_client_id | numeric | 10 | Tenant for this installation. | |||
ad_treenodepr | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
ad_treenodepr | ad_tree_id | numeric | 10 | Identifies a Tree | |||
ad_treenodepr | ad_treenodepr_uu | varchar | 36 | √ | NULL::character varying | AD_TreeNodePR_UU | |
ad_treenodepr | created | timestamp | 29,6 | now() | Date this record was created | ||
ad_treenodepr | createdby | numeric | 10 | User who created this records | |||
ad_treenodepr | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
ad_treenodepr | node_id | numeric | 10 | Node | |||
ad_treenodepr | parent_id | numeric | 10 | √ | null | Parent of Entity | |
ad_treenodepr | seqno | numeric | 10 | √ | null | Method of ordering records; lowest number comes first | |
ad_treenodepr | updated | timestamp | 29,6 | now() | Date this record was updated | ||
ad_treenodepr | updatedby | numeric | 10 | User who updated this records | |||
ad_treenodeu1 | ad_client_id | numeric | 10 | Tenant for this installation. | |||
ad_treenodeu1 | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
ad_treenodeu1 | ad_tree_id | numeric | 10 | Identifies a Tree | |||
ad_treenodeu1 | ad_treenodeu1_uu | varchar | 36 | √ | NULL::character varying | AD_TreeNodeU1_UU | |
ad_treenodeu1 | created | timestamp | 29,6 | now() | Date this record was created | ||
ad_treenodeu1 | createdby | numeric | 10 | User who created this records | |||
ad_treenodeu1 | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
ad_treenodeu1 | node_id | numeric | 10 | Node | |||
ad_treenodeu1 | parent_id | numeric | 10 | Parent of Entity | |||
ad_treenodeu1 | seqno | numeric | 10 | 0 | Method of ordering records; lowest number comes first | ||
ad_treenodeu1 | updated | timestamp | 29,6 | now() | Date this record was updated | ||
ad_treenodeu1 | updatedby | numeric | 10 | User who updated this records | |||
ad_treenodeu2 | ad_client_id | numeric | 10 | Tenant for this installation. | |||
ad_treenodeu2 | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
ad_treenodeu2 | ad_tree_id | numeric | 10 | Identifies a Tree | |||
ad_treenodeu2 | ad_treenodeu2_uu | varchar | 36 | √ | NULL::character varying | AD_TreeNodeU2_UU | |
ad_treenodeu2 | created | timestamp | 29,6 | now() | Date this record was created | ||
ad_treenodeu2 | createdby | numeric | 10 | User who created this records | |||
ad_treenodeu2 | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
ad_treenodeu2 | node_id | numeric | 10 | Node | |||
ad_treenodeu2 | parent_id | numeric | 10 | Parent of Entity | |||
ad_treenodeu2 | seqno | numeric | 10 | 0 | Method of ordering records; lowest number comes first | ||
ad_treenodeu2 | updated | timestamp | 29,6 | now() | Date this record was updated | ||
ad_treenodeu2 | updatedby | numeric | 10 | User who updated this records | |||
ad_treenodeu3 | ad_client_id | numeric | 10 | Tenant for this installation. | |||
ad_treenodeu3 | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
ad_treenodeu3 | ad_tree_id | numeric | 10 | Identifies a Tree | |||
ad_treenodeu3 | ad_treenodeu3_uu | varchar | 36 | √ | NULL::character varying | AD_TreeNodeU3_UU | |
ad_treenodeu3 | created | timestamp | 29,6 | now() | Date this record was created | ||
ad_treenodeu3 | createdby | numeric | 10 | User who created this records | |||
ad_treenodeu3 | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
ad_treenodeu3 | node_id | numeric | 10 | Node | |||
ad_treenodeu3 | parent_id | numeric | 10 | Parent of Entity | |||
ad_treenodeu3 | seqno | numeric | 10 | 0 | Method of ordering records; lowest number comes first | ||
ad_treenodeu3 | updated | timestamp | 29,6 | now() | Date this record was updated | ||
ad_treenodeu3 | updatedby | numeric | 10 | User who updated this records | |||
ad_treenodeu4 | ad_client_id | numeric | 10 | Tenant for this installation. | |||
ad_treenodeu4 | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
ad_treenodeu4 | ad_tree_id | numeric | 10 | Identifies a Tree | |||
ad_treenodeu4 | ad_treenodeu4_uu | varchar | 36 | √ | NULL::character varying | AD_TreeNodeU4_UU | |
ad_treenodeu4 | created | timestamp | 29,6 | now() | Date this record was created | ||
ad_treenodeu4 | createdby | numeric | 10 | User who created this records | |||
ad_treenodeu4 | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
ad_treenodeu4 | node_id | numeric | 10 | Node | |||
ad_treenodeu4 | parent_id | numeric | 10 | Parent of Entity | |||
ad_treenodeu4 | seqno | numeric | 10 | 0 | Method of ordering records; lowest number comes first | ||
ad_treenodeu4 | updated | timestamp | 29,6 | now() | Date this record was updated | ||
ad_treenodeu4 | updatedby | numeric | 10 | User who updated this records | |||
c_activity | ad_client_id | numeric | 10 | Tenant for this installation. | |||
c_activity | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
c_activity | c_activity_id | numeric | 10 | Business Activity | |||
c_activity | c_activity_uu | varchar | 36 | √ | NULL::character varying | C_Activity_UU | |
c_activity | created | timestamp | 29,6 | now() | Date this record was created | ||
c_activity | createdby | numeric | 10 | User who created this records | |||
c_activity | description | varchar | 255 | √ | null | Optional short description of the record | |
c_activity | help | varchar | 2000 | √ | null | Comment or Hint | |
c_activity | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
c_activity | issummary | bpchar | 1 | 'N'::bpchar | This is a summary entity | ||
c_activity | name | varchar | 60 | Alphanumeric identifier of the entity | |||
c_activity | updated | timestamp | 29,6 | now() | Date this record was updated | ||
c_activity | updatedby | numeric | 10 | User who updated this records | |||
c_activity | value | varchar | 40 | Search key for the record in the format required - must be unique | |||
c_bpartner | acqusitioncost | numeric | 0 | √ | 0 | The cost of gaining the prospect as a customer | |
c_bpartner | actuallifetimevalue | numeric | 0 | √ | 0 | Actual Life Time Revenue | |
c_bpartner | ad_client_id | numeric | 10 | Tenant for this installation. | |||
c_bpartner | ad_language | varchar | 6 | √ | null | Language for this entity | |
c_bpartner | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
c_bpartner | ad_orgbp_id | numeric | 10 | √ | null | The Business Partner is another Organization for explicit Inter-Org transactions | |
c_bpartner | bpartner_parent_id | numeric | 10 | √ | null | Business Partner Parent | |
c_bpartner | c_bp_group_id | numeric | 10 | Business Partner Group | |||
c_bpartner | c_bpartner_id | numeric | 10 | Identifies a Business Partner | |||
c_bpartner | c_bpartner_uu | varchar | 36 | √ | NULL::character varying | C_BPartner_UU | |
c_bpartner | c_dunning_id | numeric | 10 | √ | null | Dunning Rules for overdue invoices | |
c_bpartner | c_greeting_id | numeric | 10 | √ | null | Greeting to print on correspondence | |
c_bpartner | c_invoiceschedule_id | numeric | 10 | √ | null | Schedule for generating Invoices | |
c_bpartner | c_paymentterm_id | numeric | 10 | √ | null | The terms of Payment (timing, discount) | |
c_bpartner | c_taxgroup_id | numeric | 10 | √ | null | Tax Group | |
c_bpartner | created | timestamp | 29,6 | now() | Date this record was created | ||
c_bpartner | createdby | numeric | 10 | User who created this records | |||
c_bpartner | customerprofileid | varchar | 60 | √ | NULL::character varying | Customer Profile ID | |
c_bpartner | default1099box_id | numeric | 10 | √ | NULL::numeric | Default 1099 Box | |
c_bpartner | deliveryrule | bpchar | 1 | √ | null | Defines the timing of Delivery | |
c_bpartner | deliveryviarule | bpchar | 1 | √ | null | How the order will be delivered | |
c_bpartner | description | varchar | 255 | √ | null | Optional short description of the record | |
c_bpartner | documentcopies | numeric | 10 | √ | null | Number of copies to be printed | |
c_bpartner | dunninggrace | timestamp | 29,6 | √ | null | Dunning Grace Date | |
c_bpartner | duns | varchar | 11 | √ | null | Dun & Bradstreet Number | |
c_bpartner | firstsale | timestamp | 29,6 | √ | null | Date of First Sale | |
c_bpartner | flatdiscount | numeric | 0 | √ | null | Flat discount percentage | |
c_bpartner | freightcostrule | bpchar | 1 | √ | null | Method for charging Freight | |
c_bpartner | invoice_printformat_id | numeric | 10 | √ | null | Print Format for printing Invoices | |
c_bpartner | invoicerule | bpchar | 1 | √ | null | Frequency and method of invoicing | |
c_bpartner | is1099vendor | bpchar | 1 | 'N'::bpchar | 1099 Vendor | ||
c_bpartner | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
c_bpartner | iscustomer | bpchar | 1 | 'Y'::bpchar | Indicates if this Business Partner is a Customer | ||
c_bpartner | isdiscountprinted | bpchar | 1 | √ | 'Y'::bpchar | Print Discount on Invoice and Order | |
c_bpartner | isemployee | bpchar | 1 | 'N'::bpchar | Indicates if this Business Partner is an employee | ||
c_bpartner | ismanufacturer | bpchar | 1 | √ | 'N'::bpchar | Indicate role of this Business partner as Manufacturer | |
c_bpartner | isonetime | bpchar | 1 | 'N'::bpchar | One time transaction | ||
c_bpartner | ispotaxexempt | bpchar | 1 | 'N'::bpchar | Business partner is exempt from tax on purchases | ||
c_bpartner | isprospect | bpchar | 1 | 'N'::bpchar | Indicates this is a Prospect | ||
c_bpartner | issalesrep | bpchar | 1 | 'N'::bpchar | Indicates if the business partner is a sales representative or company agent | ||
c_bpartner | issummary | bpchar | 1 | 'N'::bpchar | This is a summary entity | ||
c_bpartner | istaxexempt | bpchar | 1 | √ | 'N'::bpchar | Business partner is exempt from tax on sales | |
c_bpartner | isvendor | bpchar | 1 | 'N'::bpchar | Indicates if this Business Partner is a Vendor | ||
c_bpartner | logo_id | numeric | 10 | √ | NULL::numeric | Logo | |
c_bpartner | m_discountschema_id | numeric | 10 | √ | null | Schema to calculate the trade discount percentage | |
c_bpartner | m_pricelist_id | numeric | 10 | √ | null | Unique identifier of a Price List | |
c_bpartner | naics | varchar | 6 | √ | null | Standard Industry Code or its successor NAIC - http://www.osha.gov/oshstats/sicser.html | |
c_bpartner | name | varchar | 120 | Alphanumeric identifier of the entity | |||
c_bpartner | name2 | varchar | 60 | √ | null | Additional Name | |
c_bpartner | numberemployees | numeric | 10 | √ | null | Number of employees | |
c_bpartner | paymentrule | bpchar | 1 | √ | null | How you pay the invoice | |
c_bpartner | paymentrulepo | bpchar | 1 | √ | null | Purchase payment option | |
c_bpartner | po_discountschema_id | numeric | 10 | √ | null | Schema to calculate the purchase trade discount percentage | |
c_bpartner | po_paymentterm_id | numeric | 10 | √ | null | Payment rules for a purchase order | |
c_bpartner | po_pricelist_id | numeric | 10 | √ | null | Price List used by this Business Partner | |
c_bpartner | poreference | varchar | 20 | √ | null | Transaction Reference Number (Sales Order, Purchase Order) of your Business Partner | |
c_bpartner | potentiallifetimevalue | numeric | 0 | √ | 0 | Total Revenue expected | |
c_bpartner | rating | bpchar | 1 | √ | null | Classification or Importance | |
c_bpartner | referenceno | varchar | 40 | √ | null | Your customer or vendor number at the Business Partner's site | |
c_bpartner | salesrep_id | numeric | 10 | √ | null | Sales Representative or Company Agent | |
c_bpartner | salesvolume | numeric | 10 | √ | null | Total Volume of Sales in Thousands of Currency | |
c_bpartner | sendemail | bpchar | 1 | 'N'::bpchar | Enable sending Document EMail | ||
c_bpartner | shareofcustomer | numeric | 10 | √ | null | Share of Customer's business as a percentage | |
c_bpartner | shelflifeminpct | numeric | 10 | √ | null | Minimum Shelf Life in percent based on Product Instance Guarantee Date | |
c_bpartner | so_creditlimit | numeric | 0 | √ | 0 | Total outstanding invoice amounts allowed | |
c_bpartner | so_creditused | numeric | 0 | √ | 0 | Current open balance | |
c_bpartner | so_description | varchar | 255 | √ | null | Description to be used on orders | |
c_bpartner | socreditstatus | bpchar | 1 | √ | 'O'::bpchar | Business Partner Credit Status | |
c_bpartner | taxid | varchar | 20 | √ | null | Tax Identification | |
c_bpartner | totalopenbalance | numeric | 0 | √ | null | Total Open Balance Amount in primary Accounting Currency | |
c_bpartner | updated | timestamp | 29,6 | now() | Date this record was updated | ||
c_bpartner | updatedby | numeric | 10 | User who updated this records | |||
c_bpartner | url | varchar | 120 | √ | null | Full URL address - e.g. http://www.idempiere.org | |
c_bpartner | value | varchar | 40 | Search key for the record in the format required - must be unique | |||
c_element | ad_client_id | numeric | 10 | Tenant for this installation. | |||
c_element | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
c_element | ad_tree_id | numeric | 10 | √ | null | Identifies a Tree | |
c_element | c_element_id | numeric | 10 | Accounting Element | |||
c_element | c_element_uu | varchar | 36 | √ | NULL::character varying | C_Element_UU | |
c_element | created | timestamp | 29,6 | now() | Date this record was created | ||
c_element | createdby | numeric | 10 | User who created this records | |||
c_element | description | varchar | 255 | √ | null | Optional short description of the record | |
c_element | elementtype | bpchar | 1 | Element Type (account or user defined) | |||
c_element | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
c_element | isbalancing | bpchar | 1 | 'N'::bpchar | All transactions within an element value must balance (e.g. cost centers) | ||
c_element | isnaturalaccount | bpchar | 1 | 'Y'::bpchar | The primary natural account | ||
c_element | name | varchar | 60 | Alphanumeric identifier of the entity | |||
c_element | updated | timestamp | 29,6 | now() | Date this record was updated | ||
c_element | updatedby | numeric | 10 | User who updated this records | |||
c_element | vformat | varchar | 40 | √ | null | Format of the value; Can contain fixed format elements, Variables: "_lLoOaAcCa09" | |
c_elementvalue | accountsign | bpchar | 1 | Indicates the Natural Sign of the Account as a Debit or Credit | |||
c_elementvalue | accounttype | bpchar | 1 | Indicates the type of account | |||
c_elementvalue | ad_client_id | numeric | 10 | Tenant for this installation. | |||
c_elementvalue | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
c_elementvalue | bpartnertype | bpchar | 1 | √ | NULL::bpchar | Business Partner Type | |
c_elementvalue | c_bankaccount_id | numeric | 10 | √ | null | Account at the Bank | |
c_elementvalue | c_currency_id | numeric | 10 | √ | null | The Currency for this record | |
c_elementvalue | c_element_id | numeric | 10 | Accounting Element | |||
c_elementvalue | c_elementvalue_id | numeric | 10 | Account Element | |||
c_elementvalue | c_elementvalue_uu | varchar | 36 | √ | NULL::character varying | C_ElementValue_UU | |
c_elementvalue | created | timestamp | 29,6 | now() | Date this record was created | ||
c_elementvalue | createdby | numeric | 10 | User who created this records | |||
c_elementvalue | description | varchar | 255 | √ | null | Optional short description of the record | |
c_elementvalue | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
c_elementvalue | isbankaccount | bpchar | 1 | √ | 'N'::bpchar | Indicates if this is the Bank Account | |
c_elementvalue | isdetailbpartner | bpchar | 1 | 'N'::bpchar | Manage Business Partners | ||
c_elementvalue | isdetailproduct | bpchar | 1 | 'N'::bpchar | Manage Products | ||
c_elementvalue | isdoccontrolled | bpchar | 1 | √ | 'N'::bpchar | Control account - If an account is controlled by a document, you cannot post manually to it | |
c_elementvalue | isforeigncurrency | bpchar | 1 | √ | 'N'::bpchar | Balances in foreign currency accounts are held in the nominated currency | |
c_elementvalue | issummary | bpchar | 1 | 'N'::bpchar | This is a summary entity | ||
c_elementvalue | name | varchar | 120 | Alphanumeric identifier of the entity | |||
c_elementvalue | postactual | bpchar | 1 | 'Y'::bpchar | Actual Values can be posted | ||
c_elementvalue | postbudget | bpchar | 1 | 'Y'::bpchar | Budget values can be posted | ||
c_elementvalue | postencumbrance | bpchar | 1 | 'Y'::bpchar | Post commitments to this account | ||
c_elementvalue | poststatistical | bpchar | 1 | 'Y'::bpchar | Post statistical quantities to this account? | ||
c_elementvalue | updated | timestamp | 29,6 | now() | Date this record was updated | ||
c_elementvalue | updatedby | numeric | 10 | User who updated this records | |||
c_elementvalue | validfrom | timestamp | 29,6 | √ | null | Valid from including this date (first day) | |
c_elementvalue | validto | timestamp | 29,6 | √ | null | Valid to including this date (last day) | |
c_elementvalue | value | varchar | 40 | Search key for the record in the format required - must be unique | |||
c_project | ad_client_id | numeric | 10 | Tenant for this installation. | |||
c_project | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
c_project | ad_orgtrx_id | numeric | 10 | √ | NULL::numeric | Performing or initiating organization | |
c_project | ad_user_id | numeric | 10 | √ | null | User within the system - Internal or Business Partner Contact | |
c_project | c_activity_id | numeric | 10 | √ | NULL::numeric | Business Activity | |
c_project | c_bpartner_id | numeric | 10 | √ | null | Identifies a Business Partner | |
c_project | c_bpartner_location_id | numeric | 10 | √ | null | Identifies the (ship to) address for this Business Partner | |
c_project | c_bpartnersr_id | numeric | 10 | √ | null | Business Partner (Agent or Sales Rep) | |
c_project | c_campaign_id | numeric | 10 | √ | null | Marketing Campaign | |
c_project | c_currency_id | numeric | 10 | The Currency for this record | |||
c_project | c_paymentterm_id | numeric | 10 | √ | null | The terms of Payment (timing, discount) | |
c_project | c_phase_id | numeric | 10 | √ | null | Standard Phase of the Project Type | |
c_project | c_project_id | numeric | 10 | Financial Project | |||
c_project | c_project_uu | varchar | 36 | √ | NULL::character varying | C_Project_UU | |
c_project | c_projecttype_id | numeric | 10 | √ | null | Type of the project | |
c_project | committedamt | numeric | 0 | 0 | The (legal) commitment amount | ||
c_project | committedqty | numeric | 0 | 0 | The (legal) commitment Quantity | ||
c_project | copyfrom | bpchar | 1 | √ | null | Copy From Record | |
c_project | created | timestamp | 29,6 | now() | Date this record was created | ||
c_project | createdby | numeric | 10 | User who created this records | |||
c_project | datecontract | timestamp | 29,6 | √ | null | The (planned) effective date of this document. | |
c_project | datefinish | timestamp | 29,6 | √ | null | Finish or (planned) completion date | |
c_project | description | varchar | 255 | √ | null | Optional short description of the record | |
c_project | generateto | bpchar | 1 | √ | null | Generate To | |
c_project | invoicedamt | numeric | 0 | 0 | The amount invoiced | ||
c_project | invoicedqty | numeric | 0 | 0 | The quantity invoiced | ||
c_project | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
c_project | iscommitceiling | bpchar | 1 | 'N'::bpchar | The commitment amount/quantity is the chargeable ceiling | ||
c_project | iscommitment | bpchar | 1 | 'Y'::bpchar | Is this document a (legal) commitment? | ||
c_project | issummary | bpchar | 1 | 'N'::bpchar | This is a summary entity | ||
c_project | m_pricelist_version_id | numeric | 10 | √ | null | Identifies a unique instance of a Price List | |
c_project | m_warehouse_id | numeric | 10 | √ | null | Storage Warehouse and Service Point | |
c_project | name | varchar | 60 | Alphanumeric identifier of the entity | |||
c_project | note | varchar | 2000 | √ | null | Optional additional user defined information | |
c_project | plannedamt | numeric | 0 | 0 | Planned amount for this project | ||
c_project | plannedmarginamt | numeric | 0 | 0 | Project's planned margin amount | ||
c_project | plannedqty | numeric | 0 | 0 | Planned quantity for this project | ||
c_project | poreference | varchar | 20 | √ | null | Transaction Reference Number (Sales Order, Purchase Order) of your Business Partner | |
c_project | processed | bpchar | 1 | 'N'::bpchar | The document has been processed | ||
c_project | processing | bpchar | 1 | √ | null | Process Now | |
c_project | projectbalanceamt | numeric | 0 | 0 | Total Project Balance | ||
c_project | projectcategory | bpchar | 1 | √ | 'N'::bpchar | Project Category | |
c_project | projectlinelevel | bpchar | 1 | 'P'::bpchar | Project Line Level | ||
c_project | projinvoicerule | bpchar | 1 | '-'::bpchar | Invoice Rule for the project | ||
c_project | salesrep_id | numeric | 10 | √ | null | Sales Representative or Company Agent | |
c_project | updated | timestamp | 29,6 | now() | Date this record was updated | ||
c_project | updatedby | numeric | 10 | User who updated this records | |||
c_project | value | varchar | 40 | Search key for the record in the format required - must be unique | |||
c_salesregion | ad_client_id | numeric | 10 | Tenant for this installation. | |||
c_salesregion | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
c_salesregion | c_salesregion_id | numeric | 10 | Sales coverage region | |||
c_salesregion | c_salesregion_uu | varchar | 36 | √ | NULL::character varying | C_SalesRegion_UU | |
c_salesregion | created | timestamp | 29,6 | now() | Date this record was created | ||
c_salesregion | createdby | numeric | 10 | User who created this records | |||
c_salesregion | description | varchar | 255 | √ | null | Optional short description of the record | |
c_salesregion | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
c_salesregion | isdefault | bpchar | 1 | 'N'::bpchar | Default value | ||
c_salesregion | issummary | bpchar | 1 | 'N'::bpchar | This is a summary entity | ||
c_salesregion | name | varchar | 60 | Alphanumeric identifier of the entity | |||
c_salesregion | salesrep_id | numeric | 10 | √ | null | Sales Representative or Company Agent | |
c_salesregion | updated | timestamp | 29,6 | now() | Date this record was updated | ||
c_salesregion | updatedby | numeric | 10 | User who updated this records | |||
c_salesregion | value | varchar | 40 | Search key for the record in the format required - must be unique | |||
m_product | ad_client_id | numeric | 10 | Tenant for this installation. | |||
m_product | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
m_product | c_revenuerecognition_id | numeric | 10 | √ | null | Method for recording revenue | |
m_product | c_subscriptiontype_id | numeric | 10 | √ | null | Type of subscription | |
m_product | c_taxcategory_id | numeric | 10 | Tax Category | |||
m_product | c_uom_id | numeric | 10 | Unit of Measure | |||
m_product | classification | varchar | 12 | √ | null | Classification for grouping | |
m_product | copyfrom | bpchar | 1 | √ | NULL::bpchar | Copy From Record | |
m_product | created | timestamp | 29,6 | now() | Date this record was created | ||
m_product | createdby | numeric | 10 | User who created this records | |||
m_product | customstariffnumber | varchar | 20 | √ | null | Customs Tariff Number, usually the HS-Code | |
m_product | description | varchar | 255 | √ | null | Optional short description of the record | |
m_product | descriptionurl | varchar | 120 | √ | null | URL for the description | |
m_product | discontinued | bpchar | 1 | √ | 'N'::bpchar | This product is no longer available | |
m_product | discontinuedat | timestamp | 29,6 | √ | null | Discontinued At indicates Date when product was discontinued | |
m_product | discontinuedby | timestamp | 29,6 | √ | null | ||
m_product | documentnote | varchar | 2000 | √ | null | Additional information for a Document | |
m_product | downloadurl | varchar | 120 | √ | null | ||
m_product | group1 | varchar | 255 | √ | null | Group1 | |
m_product | group2 | varchar | 255 | √ | null | Group2 | |
m_product | guaranteedays | numeric | 10 | √ | null | Number of days the product is guaranteed or available | |
m_product | guaranteedaysmin | numeric | 10 | √ | null | Minimum number of guarantee days | |
m_product | help | varchar | 2000 | √ | null | Comment or Hint | |
m_product | imageurl | varchar | 120 | √ | null | URL of image | |
m_product | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
m_product | isautoproduce | bpchar | 1 | 'N'::bpchar | Auto create production to fulfill shipment | ||
m_product | isbom | bpchar | 1 | 'N'::bpchar | Bill of Materials | ||
m_product | isdropship | bpchar | 1 | 'N'::bpchar | Drop Shipments are sent directly to the Drop Shipment Location | ||
m_product | isexcludeautodelivery | bpchar | 1 | 'N'::bpchar | Exclude from automatic Delivery | ||
m_product | isinvoiceprintdetails | bpchar | 1 | 'N'::bpchar | Print detail BOM elements on the invoice | ||
m_product | iskanban | bpchar | 1 | 'N'::bpchar | This part is Kanban controlled | ||
m_product | ismanufactured | bpchar | 1 | 'N'::bpchar | This product is manufactured | ||
m_product | isownbox | bpchar | 1 | 'N'::bpchar | Own Box | ||
m_product | isphantom | bpchar | 1 | √ | 'N'::bpchar | Phantom Component | |
m_product | ispicklistprintdetails | bpchar | 1 | 'N'::bpchar | Print detail BOM elements on the pick list | ||
m_product | ispurchased | bpchar | 1 | 'Y'::bpchar | Organization purchases this product | ||
m_product | isselfservice | bpchar | 1 | 'Y'::bpchar | This is a Self-Service entry or this entry can be changed via Self-Service | ||
m_product | issold | bpchar | 1 | 'Y'::bpchar | Organization sells this product | ||
m_product | isstocked | bpchar | 1 | 'Y'::bpchar | Organization stocks this product | ||
m_product | issummary | bpchar | 1 | 'N'::bpchar | This is a summary entity | ||
m_product | istoformule | bpchar | 1 | √ | null | ||
m_product | isverified | bpchar | 1 | 'N'::bpchar | The BOM configuration has been verified | ||
m_product | iswebstorefeatured | bpchar | 1 | 'N'::bpchar | If selected, the product is displayed in the initial or any empty search | ||
m_product | lowlevel | numeric | 10 | (0)::numeric | The Low Level is used to calculate the material plan and determines if a net requirement should be exploited | ||
m_product | m_attributeset_id | numeric | 10 | √ | null | Product Attribute Set | |
m_product | m_attributesetinstance_id | numeric | 10 | √ | 0 | Product Attribute Set Instance | |
m_product | m_freightcategory_id | numeric | 10 | √ | null | Category of the Freight | |
m_product | m_locator_id | numeric | 10 | √ | null | Warehouse Locator | |
m_product | m_parttype_id | numeric | 10 | √ | NULL::numeric | Part Type | |
m_product | m_product_category_id | numeric | 10 | Category of a Product | |||
m_product | m_product_id | numeric | 10 | Product, Service, Item | |||
m_product | m_product_uu | varchar | 36 | √ | NULL::character varying | M_Product_UU | |
m_product | name | varchar | 255 | Alphanumeric identifier of the entity | |||
m_product | processing | bpchar | 1 | √ | null | Process Now | |
m_product | producttype | bpchar | 1 | 'I'::bpchar | Type of product | ||
m_product | r_mailtext_id | numeric | 10 | √ | null | Text templates for mailings | |
m_product | s_expensetype_id | numeric | 10 | √ | null | Expense report type | |
m_product | s_resource_id | numeric | 10 | √ | null | Resource | |
m_product | salesrep_id | numeric | 10 | √ | null | Sales Representative or Company Agent | |
m_product | shelfdepth | numeric | 10 | √ | null | Shelf depth required | |
m_product | shelfheight | numeric | 0 | √ | null | Shelf height required | |
m_product | shelfwidth | numeric | 10 | √ | null | Shelf width required | |
m_product | sku | varchar | 30 | √ | null | Stock Keeping Unit | |
m_product | unitsperpack | numeric | 10 | 1 | The Units Per Pack indicates the no of units of a product packed together. | ||
m_product | unitsperpallet | numeric | 0 | √ | null | Units Per Pallet | |
m_product | upc | varchar | 30 | √ | null | Bar Code (Universal Product Code or its superset European Article Number) | |
m_product | updated | timestamp | 29,6 | now() | Date this record was updated | ||
m_product | updatedby | numeric | 10 | User who updated this records | |||
m_product | value | varchar | 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 | |
m_product_category | a_asset_group_id | numeric | 10 | √ | null | Group of Assets | |
m_product_category | ad_client_id | numeric | 10 | Tenant for this installation. | |||
m_product_category | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
m_product_category | ad_printcolor_id | numeric | 10 | √ | null | Color used for printing and display | |
m_product_category | created | timestamp | 29,6 | now() | Date this record was created | ||
m_product_category | createdby | numeric | 10 | User who created this records | |||
m_product_category | description | varchar | 255 | √ | null | Optional short description of the record | |
m_product_category | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
m_product_category | isdefault | bpchar | 1 | 'N'::bpchar | Default value | ||
m_product_category | isselfservice | bpchar | 1 | 'Y'::bpchar | This is a Self-Service entry or this entry can be changed via Self-Service | ||
m_product_category | m_product_category_id | numeric | 10 | Category of a Product | |||
m_product_category | m_product_category_parent_id | numeric | 10 | √ | null | Parent Product Category | |
m_product_category | m_product_category_uu | varchar | 36 | √ | NULL::character varying | M_Product_Category_UU | |
m_product_category | mmpolicy | bpchar | 1 | 'F'::bpchar | Material Movement Policy | ||
m_product_category | name | varchar | 60 | Alphanumeric identifier of the entity | |||
m_product_category | plannedmargin | numeric | 0 | Project's planned margin as a percentage | |||
m_product_category | updated | timestamp | 29,6 | now() | Date this record was updated | ||
m_product_category | updatedby | numeric | 10 | User who updated this records | |||
m_product_category | value | varchar | 40 | Search key for the record in the format required - must be unique |