SchemaSpy Analysis of idempiere11.adempiere - ColumnsUtility Generated by
Quality Systems & Solutions
Generated on 2024-01-03 13:56 +0100
Legend:
Primary key columns
Columns with indexes
 

idempiere11.adempiere contains 977 columns - click on heading to sort:
Table Column Type Size Nulls Auto Default
ad_ctxhelpsuggestion acceptsuggestion bpchar 1  √  NULL::bpchar Accept suggested changes
ad_fieldsuggestion acceptsuggestion bpchar 1  √  NULL::bpchar Accept suggested changes
ad_form accesslevel bpchar 1 Access Level required
ad_process accesslevel bpchar 1 Access Level required
ad_table accesslevel bpchar 1 Access Level required
ad_task accesslevel bpchar 1 Access Level required
ad_workflow accesslevel bpchar 1 Access Level required
ad_menu action bpchar 1  √  null Indicates the Action to be performed
ad_userpreference autocommit bpchar 1  √  'Y'::bpchar Automatic Commit
ad_userpreference autonew bpchar 1  √  'Y'::bpchar Automatic New Record
ad_color colortype bpchar 1 Color presentation for this color
ad_ctxhelpsuggestion comparesuggestion bpchar 1  √  NULL::bpchar Compare suggested text with original text
ad_fieldsuggestion comparesuggestion bpchar 1  √  NULL::bpchar Compare suggested text with original text
ad_table copycomponentsfromview bpchar 1  √  NULL::bpchar Copy Components From View
ad_process copyfromprocess bpchar 1  √  NULL::bpchar Copy settings from one report and process to another.
ad_table createpartition bpchar 1  √  NULL::bpchar Process which create or update table partitions based on the table and column records
ad_table createwindowfromtable bpchar 1  √  NULL::bpchar Create Window From Table
ad_table databaseviewdrop bpchar 1  √  NULL::bpchar Drop view
ad_impformat_row datatype bpchar 1 Type of data
ad_process_para daterangeoption bpchar 1 'D'::bpchar Options, how the date editor will be displayed.
ad_impformat_row decimalpoint bpchar 1 Decimal Point in the data file - if any
c_bpartner deliveryrule bpchar 1  √  null Defines the timing of Delivery
c_bpartner deliveryviarule bpchar 1  √  null How the order will be delivered
ad_impformat_row divideby100 bpchar 1 'N'::bpchar Divide number by 100 to get correct amount
ad_workflow durationunit bpchar 1  √  null Unit of Duration
ad_process executiontype bpchar 1  √  NULL::bpchar Execution Type defines whether the report/process will always run in background or foreground.
ad_fieldsuggestion fieldsuggestiontarget bpchar 1 'E'::bpchar Apply Suggestion To
ad_impformat formattype bpchar 1 Format of the data
c_bpartner freightcostrule bpchar 1  √  null Method for charging Freight
c_doctype hascharges bpchar 1 'N'::bpchar Charges can be added to the document
c_doctype hasproforma bpchar 1  √  'N'::bpchar Indicates if Pro Forma Invoices can be generated from this document
ad_table importtable bpchar 1  √  null Import Table Columns from Database
c_bpartner invoicerule bpchar 1  √  null Frequency and method of invoicing
c_bpartner is1099vendor bpchar 1 'N'::bpchar 1099 Vendor
ad_archive isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_attachment isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_color isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_ctxhelpsuggestion isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_fieldsuggestion isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_form isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_image isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_impformat isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_impformat_row isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_issue isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_menu isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_message isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_message_trl isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_migrationscript isactive bpchar 1 The record is active in the system
ad_note isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_pinstance isactive bpchar 1  √  'Y'::bpchar The record is active in the system
ad_pinstance_para isactive bpchar 1  √  'Y'::bpchar The record is active in the system
ad_printform isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_process isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_process_para isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_recentitem isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_sequence isactive bpchar 1  √  'Y'::bpchar The record is active in the system
ad_sequence_audit isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_sequence_no isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_storageprovider isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_table isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_task isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_taskinstance isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_userpreference isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_val_rule isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_wf_process isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_window isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_wlistbox_customization isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_workflow isactive bpchar 1 'Y'::bpchar The record is active in the system
c_bpartner isactive bpchar 1 'Y'::bpchar The record is active in the system
c_doctype isactive bpchar 1 'Y'::bpchar The record is active in the system
c_uom isactive bpchar 1 'Y'::bpchar The record is active in the system
c_uom_conversion isactive bpchar 1 'Y'::bpchar The record is active in the system
test isactive bpchar 1 'Y'::bpchar The record is active in the system
testuu isactive bpchar 1 'Y'::bpchar The record is active in the system
testuu_trl isactive bpchar 1 'Y'::bpchar The record is active in the system
testuudet isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_migrationscript isapply bpchar 1 Apply Script
ad_ctxhelpsuggestion isapproved bpchar 1 'N'::bpchar Indicates if this document requires approval
ad_fieldsuggestion isapproved bpchar 1 'N'::bpchar Indicates if this document requires approval
ad_sequence isaudited bpchar 1  √  'N'::bpchar Activate Audit Trail of what numbers are generated
ad_process_para isautocomplete bpchar 1 'N'::bpchar Automatic completion for text fields
ad_sequence isautosequence bpchar 1 'Y'::bpchar Automatically assign the next number
ad_form isbetafunctionality bpchar 1 'N'::bpchar This functionality is considered Beta
ad_process isbetafunctionality bpchar 1 'N'::bpchar This functionality is considered Beta
ad_window isbetafunctionality bpchar 1 'N'::bpchar This functionality is considered Beta
ad_workflow isbetafunctionality bpchar 1 'N'::bpchar This functionality is considered Beta
ad_menu iscentrallymaintained bpchar 1  √  'Y'::bpchar Information maintained in System Element table
ad_process_para iscentrallymaintained bpchar 1 'Y'::bpchar Information maintained in System Element table
ad_table iscentrallymaintained bpchar 1  √  'Y'::bpchar Information maintained in System Element table
ad_table ischangelog bpchar 1 'N'::bpchar Maintain a log of changes
c_doctype ischargeorproductmandatory bpchar 1  √  'N'::bpchar Mandatory Charge or Product
c_doctype iscreatecounter bpchar 1 'Y'::bpchar Create Counter Document
c_bpartner iscustomer bpchar 1 'Y'::bpchar Indicates if this Business Partner is a Customer
ad_color isdefault bpchar 1 'N'::bpchar Default value
ad_storageprovider isdefault bpchar 1 'N'::bpchar Default value
ad_window isdefault bpchar 1 'N'::bpchar Default value
ad_workflow isdefault bpchar 1 'N'::bpchar Default value
c_doctype isdefault bpchar 1 'N'::bpchar Default value
c_uom isdefault bpchar 1 'N'::bpchar Default value
c_doctype isdefaultcounterdoc bpchar 1 'N'::bpchar The document type is the default counter document type
ad_table isdeleteable bpchar 1 'Y'::bpchar Indicates if records can be deleted from the database
ad_userpreference isdetailedzoomacross bpchar 1  √  'N'::bpchar Detailed Zoom Across
ad_process isdirectprint bpchar 1  √  'N'::bpchar Print without dialog
c_bpartner isdiscountprinted bpchar 1  √  'Y'::bpchar Print Discount on Invoice and Order
c_doctype isdocnocontrolled bpchar 1 'N'::bpchar The document has a document sequence
c_bpartner isemployee bpchar 1 'N'::bpchar Indicates if this Business Partner is an employee
ad_process_para isencrypted bpchar 1 'N'::bpchar Display or Storage is encrypted
ad_table ishighvolume bpchar 1 'N'::bpchar Use Search instead of Pick list
c_doctype isindexed bpchar 1 'Y'::bpchar Index the document for the internal search engine
c_doctype isintransit bpchar 1 'N'::bpchar Movement is in transit
ad_process_para ismandatory bpchar 1 'N'::bpchar Data entry is required in this column
c_bpartner ismanufacturer bpchar 1  √  'N'::bpchar Indicate role of this Business partner as Manufacturer
c_doctype isnopricelistcheck bpchar 1  √  'N'::bpchar Allow Product Without Price List
ad_pinstance_para isnotclause bpchar 1 'N'::bpchar Indicates if a chosen multiple component value must be negate
c_bpartner isonetime bpchar 1 'N'::bpchar One time transaction
ad_sequence isorglevelsequence bpchar 1 'N'::bpchar This sequence can be defined for each organization
c_doctype isoverwritedateoncomplete bpchar 1  √  'N'::bpchar Overwrite Date on Complete
c_doctype isoverwriteseqoncomplete bpchar 1  √  'N'::bpchar Overwrite Sequence on Complete
ad_table ispartition bpchar 1 'N'::bpchar This is a partitioned table
c_doctype ispickqaconfirm bpchar 1 'N'::bpchar Require Pick or QA Confirmation before processing
c_bpartner ispotaxexempt bpchar 1 'N'::bpchar Business partner is exempt from tax on purchases
c_doctype ispreparesplitdocument bpchar 1 'Y'::bpchar Prepare generated split shipment/receipt document
ad_pinstance isprocessing bpchar 1 'N'::bpchar Processing
c_bpartner isprospect bpchar 1 'N'::bpchar Indicates this is a Prospect
ad_process_para isrange bpchar 1 'N'::bpchar The parameter is a range of values
ad_menu isreadonly bpchar 1 'N'::bpchar Field is read only
ad_archive isreport bpchar 1 'Y'::bpchar Indicates a Report record
ad_process isreport bpchar 1 'Y'::bpchar Indicates a Report record
ad_issue isreproducible bpchar 1  √  'N'::bpchar Problem can re reproduced in Gardenworld
ad_pinstance isrunasjob bpchar 1  √  'N'::bpchar Run as Job
c_bpartner issalesrep bpchar 1 'N'::bpchar Indicates if the business partner is a sales representative or company agent
ad_ctxhelpsuggestion issaveastenantcustomization bpchar 1 'N'::bpchar Apply changes as tenant customization
ad_table issecurityenabled bpchar 1 'N'::bpchar If security is enabled, user access to data can be restricted via Roles
ad_process isserverprocess bpchar 1  √  null Run this Process on Server only
ad_task isserverprocess bpchar 1  √  'N'::bpchar Run this Process on Server only
c_doctype isshipconfirm bpchar 1 'N'::bpchar Require Ship or Receipt Confirmation before processing
ad_table isshowindrilloptions bpchar 1  √  'Y'::bpchar This parameter enables the table to be displayed in Drill Assistant - Table tab
ad_process_para isshownegatebutton bpchar 1 'N'::bpchar Show Negate Button for Chosen Multiple editors
ad_menu issotrx bpchar 1 'Y'::bpchar This is a Sales Transaction
ad_window issotrx bpchar 1 'Y'::bpchar This is a Sales Transaction
c_doctype issotrx bpchar 1 'Y'::bpchar This is a Sales Transaction
c_doctype issplitwhendifference bpchar 1 'N'::bpchar Split document when there is a difference
ad_issue issuesource bpchar 1  √  null Issue Source
ad_menu issummary bpchar 1 'N'::bpchar This is a summary entity
ad_pinstance issummary bpchar 1  √  NULL::bpchar This is a summary entity
c_bpartner issummary bpchar 1 'N'::bpchar This is a summary entity
ad_sequence istableid bpchar 1  √  'N'::bpchar The document number will be used as the record key
c_bpartner istaxexempt bpchar 1  √  'N'::bpchar Business partner is exempt from tax on sales
ad_message_trl istranslated bpchar 1 'N'::bpchar This column is translated
testuu_trl istranslated bpchar 1 'N'::bpchar This column is translated
ad_fieldsuggestion isupdatebaselanguage bpchar 1 'Y'::bpchar Update Base Language
ad_userpreference isusesimilarto bpchar 1  √  'N'::bpchar Use Similar To
ad_workflow isvalid bpchar 1 'N'::bpchar Element is valid
ad_issue isvanillasystem bpchar 1  √  'N'::bpchar The system was NOT compiled from Source - i.e. standard distribution
c_bpartner isvendor bpchar 1 'N'::bpchar Indicates if this Business Partner is a Vendor
ad_table isview bpchar 1 'N'::bpchar This is a view
ad_message msgtype bpchar 1 Type of message (Informational, Menu or Error)
c_bpartner paymentrule bpchar 1  √  null How you pay the invoice
c_bpartner paymentrulepo bpchar 1  √  null Purchase payment option
ad_ctxhelpsuggestion processed bpchar 1 'N'::bpchar The document has been processed
ad_fieldsuggestion processed bpchar 1 'N'::bpchar The document has been processed
ad_issue processed bpchar 1 'N'::bpchar The document has been processed
ad_note processed bpchar 1  √  'N'::bpchar The document has been processed
ad_wf_process processed bpchar 1 'N'::bpchar The document has been processed
test processed bpchar 1  √  'N'::bpchar The document has been processed
ad_impformat processing bpchar 1 Process Now
ad_issue processing bpchar 1  √  null Process Now
ad_note processing bpchar 1  √  null Process Now
ad_table processing bpchar 1  √  NULL::bpchar Process Now
ad_wf_process processing bpchar 1  √  null Process Now
ad_window processing bpchar 1  √  null Process Now
test processing bpchar 1  √  null Process Now
ad_workflow publishstatus bpchar 1 Status of Publication
c_bpartner rating bpchar 1  √  null Classification or Importance
ad_ctxhelpsuggestion rejectsuggestion bpchar 1  √  NULL::bpchar Reject suggested changes
ad_fieldsuggestion rejectsuggestion bpchar 1  √  NULL::bpchar Reject suggested changes
ad_table replicationtype bpchar 1 'L'::bpchar Type of Data Replication
ad_migrationscript scriptroll bpchar 1  √  null Roll the Script
c_bpartner sendemail bpchar 1 'N'::bpchar Enable sending Document EMail
ad_process showhelp bpchar 1  √  'Y'::bpchar Show Help
c_bpartner socreditstatus bpchar 1  √  'O'::bpchar Business Partner Credit Status
ad_sequence startnewmonth bpchar 1 'N'::bpchar Restart sequence every month
ad_sequence startnewyear bpchar 1  √  'N'::bpchar Restart the sequence with Start on every 1/1
ad_issue systemstatus bpchar 1 Status of the system - Support priority depends on system status
ad_userpreference toggleondoubleclick bpchar 1  √  'N'::bpchar Defines if double click in a field on grid mode switch to form view
ad_val_rule type bpchar 1  √  null Type of Validation (SQL, Java Script, Java Language)
ad_workflow validateworkflow bpchar 1  √  null Validate Workflow
ad_userpreference viewfindresult bpchar 1 '0'::bpchar Does the system must switch to grid mode after the Find panel closes
ad_window windowtype bpchar 1  √  null Type or classification of a Window
ad_workflow workflowtype bpchar 1 'G'::bpchar Type of Workflow
c_doctype docsubtypeso bpchar 2  √  null Sales Order Sub Type
ad_workflow processtype bpchar 2  √  null Process Type
ad_migrationscript status bpchar 2 Status of the currently running check
ad_wf_process wfstate bpchar 2 State of the execution of the workflow
c_doctype docbasetype bpchar 3 Logical type of document
ad_archive binarydata bytea 2147483647  √  null Binary Data
ad_attachment binarydata bytea 2147483647  √  null Binary Data
ad_image binarydata bytea 2147483647  √  null Binary Data
test binarydata bytea 2147483647  √  null Binary Data
ad_migrationscript script bytea 2147483647  √  null Dynamic Java Language Script to calculate result
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
ad_workflow cost numeric 0 Cost information
c_uom_conversion dividerate numeric 0 0 To convert Source number to Target number, the Source is divided
c_bpartner flatdiscount numeric 0  √  null Flat discount percentage
ad_color imagealpha numeric 0 Image Texture Composite Alpha
c_uom_conversion multiplyrate numeric 0 0 Rate to multiple the source by to calculate the target.
ad_workflow overlapunits numeric 0  √  null Overlap Units are number of units that must be completed before they are moved the next activity
ad_pinstance_log p_number numeric 0  √  null Process Parameter
ad_pinstance_para p_number numeric 0  √  null Process Parameter
ad_pinstance_para p_number_to numeric 0  √  null Process Parameter
c_bpartner potentiallifetimevalue numeric 0  √  0 Total Revenue expected
ad_workflow qtybatchsize numeric 0  √  (1)::numeric Qty Batch Size
c_bpartner so_creditlimit numeric 0  √  0 Total outstanding invoice amounts allowed
c_bpartner so_creditused numeric 0  √  0 Current open balance
ad_process statistic_seconds numeric 0  √  null Internal statistics how many seconds a process took
test t_amount numeric 0  √  0 Amount
test t_number numeric 0  √  0 Number
test t_qty numeric 0  √  0 Qty
c_bpartner totalopenbalance numeric 0  √  null Total Open Balance Amount in primary Accounting Currency
ad_workflow unitscycles numeric 0  √  null The Units by Cycles are defined for process type Flow Repetitive Dedicated and indicated the product to be manufactured on a production line for duration unit.
ad_issue a_asset_id numeric 10  √  null Asset used internally or by customers
test account_acct numeric 10  √  null Account_Acct
ad_archive ad_archive_id numeric 10 Document and Report Archive
ad_attachment ad_attachment_id numeric 10 Attachment for the document
ad_note ad_broadcastmessage_id numeric 10  √  NULL::numeric Broadcast Message
ad_archive ad_client_id numeric 10 Tenant for this installation.
ad_attachment ad_client_id numeric 10 Tenant for this installation.
ad_color ad_client_id numeric 10 Tenant for this installation.
ad_ctxhelpsuggestion ad_client_id numeric 10 Tenant for this installation.
ad_fieldsuggestion ad_client_id numeric 10 Tenant for this installation.
ad_form ad_client_id numeric 10 Tenant for this installation.
ad_image ad_client_id numeric 10 Tenant for this installation.
ad_impformat ad_client_id numeric 10 Tenant for this installation.
ad_impformat_row ad_client_id numeric 10 Tenant for this installation.
ad_issue ad_client_id numeric 10 Tenant for this installation.
ad_menu ad_client_id numeric 10 Tenant for this installation.
ad_message ad_client_id numeric 10 Tenant for this installation.
ad_message_trl ad_client_id numeric 10 Tenant for this installation.
ad_migrationscript ad_client_id numeric 10 Tenant for this installation.
ad_note ad_client_id numeric 10 Tenant for this installation.
ad_pinstance ad_client_id numeric 10  √  null Tenant for this installation.
ad_pinstance_para ad_client_id numeric 10  √  null Tenant for this installation.
ad_printform ad_client_id numeric 10  √  null Tenant for this installation.
ad_process ad_client_id numeric 10 Tenant for this installation.
ad_process_para ad_client_id numeric 10 Tenant for this installation.
ad_recentitem ad_client_id numeric 10 Tenant for this installation.
ad_sequence ad_client_id numeric 10 Tenant for this installation.
ad_sequence_audit ad_client_id numeric 10 Tenant for this installation.
ad_sequence_no ad_client_id numeric 10 Tenant for this installation.
ad_storageprovider ad_client_id numeric 10 NULL::numeric Tenant for this installation.
ad_table ad_client_id numeric 10 Tenant for this installation.
ad_task ad_client_id numeric 10 Tenant for this installation.
ad_taskinstance ad_client_id numeric 10 Tenant for this installation.
ad_userpreference ad_client_id numeric 10 Tenant for this installation.
ad_val_rule ad_client_id numeric 10 Tenant for this installation.
ad_wf_process ad_client_id numeric 10 Tenant for this installation.
ad_window ad_client_id numeric 10 Tenant for this installation.
ad_wlistbox_customization ad_client_id numeric 10 Tenant for this installation.
ad_workflow ad_client_id numeric 10 Tenant for this installation.
c_bpartner ad_client_id numeric 10 Tenant for this installation.
c_doctype ad_client_id numeric 10 Tenant for this installation.
c_uom ad_client_id numeric 10 Tenant for this installation.
c_uom_conversion ad_client_id numeric 10 Tenant for this installation.
test ad_client_id numeric 10 Tenant for this installation.
testuu ad_client_id numeric 10 Tenant for this installation.
testuu_trl ad_client_id numeric 10 Tenant for this installation.
testuudet ad_client_id numeric 10 Tenant for this installation.
ad_color ad_color_id numeric 10 Color for backgrounds or indicators
ad_window ad_color_id numeric 10  √  null Color for backgrounds or indicators
ad_impformat_row ad_column_id numeric 10 Column in the table
ad_ctxhelpsuggestion ad_ctxhelp_id numeric 10 Context Help
ad_form ad_ctxhelp_id numeric 10  √  NULL::numeric Context Help
ad_process ad_ctxhelp_id numeric 10  √  NULL::numeric Context Help
ad_task ad_ctxhelp_id numeric 10  √  NULL::numeric Context Help
ad_workflow ad_ctxhelp_id numeric 10  √  NULL::numeric Context Help
ad_ctxhelpsuggestion ad_ctxhelpmsg_id numeric 10 Context Help Message
ad_ctxhelpsuggestion ad_ctxhelpsuggestion_id numeric 10 Context Help Suggestion
ad_process_para ad_element_id numeric 10  √  null System Element enables the central maintenance of column description and help.
ad_fieldsuggestion ad_field_id numeric 10 Field on a database table
ad_process_para ad_fieldgroup_id numeric 10  √  NULL::numeric Logical grouping of fields
ad_fieldsuggestion ad_fieldsuggestion_id numeric 10 Field Suggestions
ad_form ad_form_id numeric 10 Special Form
ad_issue ad_form_id numeric 10  √  null Special Form
ad_menu ad_form_id numeric 10  √  null Special Form
ad_process ad_form_id numeric 10  √  null Special Form
ad_color ad_image_id numeric 10  √  null Image or Icon
ad_image ad_image_id numeric 10 Image or Icon
ad_window ad_image_id numeric 10  √  null Image or Icon
ad_impformat ad_impformat_id numeric 10 Import Format
ad_impformat_row ad_impformat_id numeric 10 Import Format
ad_impformat_row ad_impformat_row_id numeric 10 Format Field
ad_menu ad_infowindow_id numeric 10  √  NULL::numeric Info and search/select Window
ad_issue ad_issue_id numeric 10 Automatically created or manually entered System Issue
ad_pinstance ad_language_id numeric 10  √  NULL::numeric Language ID
ad_menu ad_menu_id numeric 10 Identifies a Menu
ad_message ad_message_id numeric 10 System Message
ad_message_trl ad_message_id numeric 10 System Message
ad_note ad_message_id numeric 10 System Message
ad_wf_process ad_message_id numeric 10  √  null System Message
ad_migrationscript ad_migrationscript_id numeric 10 Table to check whether the migration script has been applied
ad_note ad_note_id numeric 10 System Notice
ad_archive ad_org_id numeric 10 Organizational entity within tenant
ad_attachment ad_org_id numeric 10 Organizational entity within tenant
ad_color ad_org_id numeric 10 Organizational entity within tenant
ad_ctxhelpsuggestion ad_org_id numeric 10 Organizational entity within tenant
ad_fieldsuggestion ad_org_id numeric 10 Organizational entity within tenant
ad_form ad_org_id numeric 10 Organizational entity within tenant
ad_image ad_org_id numeric 10 Organizational entity within tenant
ad_impformat ad_org_id numeric 10 Organizational entity within tenant
ad_impformat_row ad_org_id numeric 10 Organizational entity within tenant
ad_issue ad_org_id numeric 10 Organizational entity within tenant
ad_menu ad_org_id numeric 10 Organizational entity within tenant
ad_message ad_org_id numeric 10 Organizational entity within tenant
ad_message_trl ad_org_id numeric 10 Organizational entity within tenant
ad_migrationscript ad_org_id numeric 10 Organizational entity within tenant
ad_note ad_org_id numeric 10 Organizational entity within tenant
ad_pinstance ad_org_id numeric 10  √  null Organizational entity within tenant
ad_pinstance_para ad_org_id numeric 10  √  null Organizational entity within tenant
ad_printform ad_org_id numeric 10 Organizational entity within tenant
ad_process ad_org_id numeric 10 Organizational entity within tenant
ad_process_para ad_org_id numeric 10 Organizational entity within tenant
ad_recentitem ad_org_id numeric 10 Organizational entity within tenant
ad_sequence ad_org_id numeric 10 Organizational entity within tenant
ad_sequence_audit ad_org_id numeric 10 Organizational entity within tenant
ad_sequence_no ad_org_id numeric 10 Organizational entity within tenant
ad_storageprovider ad_org_id numeric 10 NULL::numeric Organizational entity within tenant
ad_table ad_org_id numeric 10 Organizational entity within tenant
ad_task ad_org_id numeric 10 Organizational entity within tenant
ad_taskinstance ad_org_id numeric 10 Organizational entity within tenant
ad_userpreference ad_org_id numeric 10 Organizational entity within tenant
ad_val_rule ad_org_id numeric 10 Organizational entity within tenant
ad_wf_process ad_org_id numeric 10 Organizational entity within tenant
ad_window ad_org_id numeric 10 Organizational entity within tenant
ad_wlistbox_customization ad_org_id numeric 10 Organizational entity within tenant
ad_workflow ad_org_id numeric 10 Organizational entity within tenant
c_bpartner ad_org_id numeric 10 Organizational entity within tenant
c_doctype ad_org_id numeric 10 Organizational entity within tenant
c_uom ad_org_id numeric 10 Organizational entity within tenant
c_uom_conversion ad_org_id numeric 10 Organizational entity within tenant
test ad_org_id numeric 10 Organizational entity within tenant
testuu ad_org_id numeric 10 Organizational entity within tenant
testuu_trl ad_org_id numeric 10 Organizational entity within tenant
testuudet 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
ad_pinstance ad_pinstance_id numeric 10 Instance of the process
ad_pinstance_log ad_pinstance_id numeric 10 Instance of the process
ad_pinstance_para ad_pinstance_id numeric 10 Instance of the process
ad_printform ad_printform_id numeric 10 Form
ad_pinstance ad_printformat_id numeric 10  √  NULL::numeric Data Print Format
ad_process ad_printformat_id numeric 10  √  null Data Print Format
c_doctype ad_printformat_id numeric 10  √  null Data Print Format
ad_archive ad_process_id numeric 10  √  null Process or Report
ad_issue ad_process_id numeric 10  √  null Process or Report
ad_menu ad_process_id numeric 10  √  null Process or Report
ad_pinstance ad_process_id numeric 10 Process or Report
ad_process ad_process_id numeric 10 Process or Report
ad_process_para ad_process_id numeric 10 Process or Report
ad_process_para ad_process_para_id numeric 10 Process Parameter
ad_recentitem ad_recentitem_id numeric 10 Recent Item
ad_process_para ad_reference_id numeric 10 System Reference and Validation
ad_process_para ad_reference_value_id numeric 10  √  null Required to specify, if data type is Table or List
ad_process ad_reportview_id numeric 10  √  null View used to generate this report
ad_recentitem ad_role_id numeric 10 Responsibility Role
ad_sequence ad_sequence_id numeric 10 Document Sequence
ad_sequence_audit ad_sequence_id numeric 10 Document Sequence
ad_sequence_no ad_sequence_id numeric 10 Document Sequence
ad_pinstance ad_session_id numeric 10  √  NULL::numeric User Session Online or Web
ad_archive ad_storageprovider_id numeric 10  √  NULL::numeric Storage Provider
ad_attachment ad_storageprovider_id numeric 10  √  NULL::numeric Storage Provider
ad_image ad_storageprovider_id numeric 10  √  NULL::numeric Storage Provider
ad_storageprovider ad_storageprovider_id numeric 10 Storage Provider
ad_recentitem ad_tab_id numeric 10  √  null Tab within a Window
ad_archive ad_table_id numeric 10  √  null Database Table information
ad_attachment ad_table_id numeric 10 Database Table information
ad_impformat ad_table_id numeric 10 Database Table information
ad_note ad_table_id numeric 10  √  null Database Table information
ad_pinstance ad_table_id numeric 10  √  NULL::numeric Database Table information
ad_pinstance_log ad_table_id numeric 10  √  NULL::numeric Database Table information
ad_recentitem ad_table_id numeric 10 Database Table information
ad_sequence_audit ad_table_id numeric 10 Database Table information
ad_table ad_table_id numeric 10 Database Table information
ad_wf_process ad_table_id numeric 10 Database Table information
ad_workflow ad_table_id numeric 10  √  null Database Table information
test ad_table_id numeric 10  √  NULL::numeric Database Table information
ad_menu ad_task_id numeric 10  √  null Operation System Task
ad_task ad_task_id numeric 10 Operation System Task
ad_taskinstance ad_task_id numeric 10 Operation System Task
ad_taskinstance ad_taskinstance_id numeric 10 Task Instance
ad_ctxhelpsuggestion ad_user_id numeric 10 User within the system - Internal or Business Partner Contact
ad_fieldsuggestion ad_user_id numeric 10 User within the system - Internal or Business Partner Contact
ad_note ad_user_id numeric 10  √  null User within the system - Internal or Business Partner Contact
ad_pinstance ad_user_id numeric 10  √  null User within the system - Internal or Business Partner Contact
ad_recentitem ad_user_id numeric 10  √  null User within the system - Internal or Business Partner Contact
ad_userpreference ad_user_id numeric 10 User within the system - Internal or Business Partner Contact
ad_wf_process ad_user_id numeric 10  √  null User within the system - Internal or Business Partner Contact
ad_wlistbox_customization ad_user_id numeric 10 User within the system - Internal or Business Partner Contact
ad_ctxhelpsuggestion ad_userclient_id numeric 10 Tenant of User
ad_fieldsuggestion ad_userclient_id numeric 10 Tenant of User
ad_userpreference ad_userpreference_id numeric 10 AD_UserPreference_ID
ad_process_para ad_val_rule_id numeric 10  √  null Dynamic Validation Rule
ad_table ad_val_rule_id numeric 10  √  null Dynamic Validation Rule
ad_val_rule ad_val_rule_id numeric 10 Dynamic Validation Rule
ad_note ad_wf_activity_id numeric 10  √  null Workflow Activity
ad_workflow ad_wf_node_id numeric 10  √  null Workflow Node (activity), step or process
ad_wf_process ad_wf_process_id numeric 10 Actual Workflow Process Instance
ad_wf_process ad_wf_responsible_id numeric 10 Responsible for Workflow Execution
ad_workflow ad_wf_responsible_id numeric 10  √  null Responsible for Workflow Execution
ad_issue ad_window_id numeric 10  √  null Data entry or display window
ad_menu ad_window_id numeric 10  √  null Data entry or display window
ad_recentitem ad_window_id numeric 10  √  null Data entry or display window
ad_table ad_window_id numeric 10  √  null Data entry or display window
ad_window ad_window_id numeric 10 Data entry or display window
ad_wlistbox_customization ad_wlistbox_customization_id numeric 10 Customization of the Wlistbox
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_process ad_workflow_id numeric 10  √  null Workflow or combination of tasks
ad_wf_process ad_workflow_id numeric 10 Workflow or combination of tasks
ad_workflow ad_workflow_id numeric 10 Workflow or combination of tasks
ad_workflow ad_workflowprocessor_id numeric 10  √  null Workflow Processor Server
ad_color alpha numeric 10 Color Alpha value 0-255
ad_color alpha_1 numeric 10  √  null Alpha value for second color
ad_userpreference automaticdecimalplacesforamoun numeric 10  √  (0)::numeric Automatically insert a decimal point
ad_color blue numeric 10 Color RGB blue value
ad_color blue_1 numeric 10  √  null RGB value for second color
c_bpartner bpartner_parent_id numeric 10  √  null Business Partner Parent
c_bpartner c_bp_group_id numeric 10 Business Partner Group
ad_archive c_bpartner_id numeric 10  √  null Identifies a Business Partner
c_bpartner c_bpartner_id numeric 10 Identifies a Business Partner
test c_bpartner_id numeric 10  √  null Identifies a Business Partner
test c_currency_id numeric 10  √  null The Currency for this record
c_doctype c_doctype_id numeric 10 Document type or rules
c_doctype c_doctypedifference_id numeric 10  √  null Document type for generating in dispute Shipments
c_doctype c_doctypeinvoice_id numeric 10  √  null Document type used for invoices generated from this sales document
c_doctype c_doctypeproforma_id numeric 10  √  null Document type used for pro forma invoices generated from this sales document
c_doctype c_doctypeshipment_id numeric 10  √  null Document type used for shipments generated from this sales document
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
test c_location_id numeric 10  √  null Location or Address
test c_payment_id numeric 10  √  null Payment identifier
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_uom_conversion c_uom_conversion_id numeric 10 Unit of Measure Conversion
c_uom c_uom_id numeric 10 Unit of Measure
c_uom_conversion c_uom_id numeric 10 Unit of Measure
test c_uom_id numeric 10  √  null Unit of Measure
c_uom_conversion c_uom_to_id numeric 10 Target or destination Unit of Measure
c_uom costingprecision numeric 10 Rounding used costing calculations
ad_archive createdby numeric 10 User who created this records
ad_attachment createdby numeric 10 User who created this records
ad_color createdby numeric 10 User who created this records
ad_ctxhelpsuggestion createdby numeric 10 User who created this records
ad_fieldsuggestion createdby numeric 10 User who created this records
ad_form createdby numeric 10 User who created this records
ad_image createdby numeric 10 User who created this records
ad_impformat createdby numeric 10 User who created this records
ad_impformat_row createdby numeric 10 User who created this records
ad_issue createdby numeric 10 User who created this records
ad_menu createdby numeric 10 User who created this records
ad_message createdby numeric 10 User who created this records
ad_message_trl createdby numeric 10 User who created this records
ad_migrationscript createdby numeric 10 User who created this records
ad_note createdby numeric 10 User who created this records
ad_pinstance createdby numeric 10  √  null User who created this records
ad_pinstance_para createdby numeric 10  √  null User who created this records
ad_printform createdby numeric 10 User who created this records
ad_process createdby numeric 10 User who created this records
ad_process_para createdby numeric 10 User who created this records
ad_recentitem createdby numeric 10 User who created this records
ad_sequence createdby numeric 10 User who created this records
ad_sequence_audit createdby numeric 10 User who created this records
ad_sequence_no createdby numeric 10 User who created this records
ad_storageprovider createdby numeric 10 NULL::numeric User who created this records
ad_table createdby numeric 10 User who created this records
ad_task createdby numeric 10 User who created this records
ad_taskinstance createdby numeric 10  √  null User who created this records
ad_userpreference createdby numeric 10 User who created this records
ad_val_rule createdby numeric 10 User who created this records
ad_wf_process createdby numeric 10 User who created this records
ad_window createdby numeric 10 User who created this records
ad_wlistbox_customization createdby numeric 10 User who created this records
ad_workflow createdby numeric 10 User who created this records
c_bpartner createdby numeric 10 User who created this records
c_doctype createdby numeric 10 User who created this records
c_uom createdby numeric 10 User who created this records
c_uom_conversion createdby numeric 10 User who created this records
test createdby numeric 10 User who created this records
testuu createdby numeric 10 User who created this records
testuu_trl createdby numeric 10 User who created this records
testuudet createdby numeric 10 User who created this records
ad_sequence currentnext numeric 10 The next number to be used
ad_sequence_no currentnext numeric 10 The next number to be used
ad_sequence currentnextsys numeric 10 Next sequence for system use
c_bpartner default1099box_id numeric 10  √  NULL::numeric Default 1099 Box
c_doctype definitesequence_id numeric 10  √  null Definite Sequence
ad_printform distrib_order_mailtext_id numeric 10  √  null Email text used for sending Distribution Order
ad_printform distrib_order_printformat_id numeric 10  √  null Print Format for printing Distribution Order
c_doctype docnosequence_id numeric 10  √  null Document sequence determines the numbering of documents
c_bpartner documentcopies numeric 10  √  null Number of copies to be printed
c_doctype documentcopies numeric 10 Number of copies to be printed
ad_workflow duration numeric 10 0 Normal Duration in Duration Unit
ad_impformat_row endno numeric 10  √  null End No
ad_process_para fieldlength numeric 10 Length of the column in the database
c_doctype gl_category_id numeric 10 General Ledger Category
ad_color green numeric 10 RGB value
ad_color green_1 numeric 10  √  null RGB value for second color
ad_userpreference gridafterfindthreshold numeric 10  √  NULL::numeric Force grid view when Find panel closes if number of records exceed threshold
ad_sequence incrementno numeric 10 The number to increment the last document number by
ad_printform invoice_mailtext_id numeric 10  √  null Email text used for sending invoices
ad_printform invoice_printformat_id numeric 10  √  null Print Format for printing Invoices
c_bpartner invoice_printformat_id numeric 10  √  null Print Format for printing Invoices
ad_workflow limit numeric 10  √  null Maximum Duration in Duration Unit
ad_color linedistance numeric 10  √  null Distance between lines
ad_issue lineno numeric 10  √  0 Line No
ad_color linewidth numeric 10  √  null Width of the lines
ad_table loadseq numeric 10  √  null Sequence
ad_pinstance_log log_id numeric 10 Log
c_bpartner logo_id numeric 10  √  NULL::numeric Logo
c_bpartner m_discountschema_id numeric 10  √  null Schema to calculate the trade discount percentage
test m_locator_id numeric 10  √  null Warehouse Locator
c_bpartner m_pricelist_id numeric 10  √  null Unique identifier of a Price List
c_uom_conversion m_product_id numeric 10  √  null Product, Service, Item
test m_product_id numeric 10  √  null Product, Service, Item
ad_printform manuf_order_mailtext_id numeric 10  √  null Email text used for sending Manufacturing Order
ad_printform manuf_order_printformat_id numeric 10  √  null Print Format for printing Manufacturing Order
ad_workflow movingtime numeric 10  √  null Moving Time
c_bpartner numberemployees numeric 10  √  null Number of employees
ad_printform order_mailtext_id numeric 10  √  null Email text used for sending order acknowledgements or quotations
ad_printform order_printformat_id numeric 10  √  null Print Format for Orders, Quotes, Offers
ad_pinstance_log p_id numeric 10  √  null Process ID
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
ad_table po_window_id numeric 10  √  null Purchase Order Window
ad_wf_process priority numeric 10  √  null Indicates if this request is of a high, medium or low priority.
ad_workflow priority numeric 10  √  null Indicates if this request is of a high, medium or low priority.
ad_printform project_mailtext_id numeric 10  √  null Standard text for Project EMails
ad_printform project_printformat_id numeric 10  √  null Standard Project Print Format
ad_workflow queuingtime numeric 10  √  null Queue time is the time a job waits at a work center before begin handled.
ad_issue r_issueknown_id numeric 10  √  null Known Issue
ad_issue r_issueproject_id numeric 10  √  null Implementation Projects
ad_issue r_issuesystem_id numeric 10  √  null System creating the issue
ad_issue r_issueuser_id numeric 10  √  null User who reported issues
ad_issue r_request_id numeric 10  √  null Request from a Business Partner or Prospect
ad_archive record_id numeric 10  √  null Direct internal record ID
ad_attachment record_id numeric 10  √  null Direct internal record ID
ad_issue record_id numeric 10  √  null Direct internal record ID
ad_note record_id numeric 10  √  null Direct internal record ID
ad_pinstance record_id numeric 10 Direct internal record ID
ad_pinstance_log record_id numeric 10  √  NULL::numeric Direct internal record ID
ad_recentitem record_id numeric 10  √  null Direct internal record ID
ad_sequence_audit record_id numeric 10 Direct internal record ID
ad_wf_process record_id numeric 10 Direct internal record ID
test record_id numeric 10  √  NULL::numeric Direct internal record ID
ad_color red numeric 10 RGB value
ad_color red_1 numeric 10  √  null RGB value for second color
ad_printform remittance_mailtext_id numeric 10  √  null Email text used for sending payment remittances
ad_printform remittance_printformat_id numeric 10  √  null Print Format for separate Remittances
ad_color repeatdistance numeric 10  √  null Distance in points to repeat gradient color - or zero
ad_pinstance result numeric 10  √  null Result of the action taken
ad_workflow s_resource_id numeric 10  √  null Resource
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
ad_impformat_row seqno numeric 10 Method of ordering records; lowest number comes first
ad_pinstance_para seqno numeric 10 Method of ordering records; lowest number comes first
ad_process_para seqno numeric 10 Method of ordering records; lowest number comes first
ad_workflow setuptime numeric 10  √  null Setup time before starting Production
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
ad_printform shipment_mailtext_id numeric 10  √  null Email text used for sending delivery notes
ad_printform shipment_printformat_id numeric 10  √  null Print Format for Shipments, Receipts, Pick Lists
ad_impformat_row startno numeric 10  √  null Starting number/position
ad_sequence startno numeric 10 Starting number/position
ad_color startpoint numeric 10  √  null Start point of the gradient colors
ad_process statistic_count numeric 10  √  null Internal statistics how often the entity was used
c_uom stdprecision numeric 10 Rule for rounding calculated amounts
test t_integer numeric 10  √  null Integer
test test_id numeric 10 Test ID
ad_archive updatedby numeric 10 User who updated this records
ad_attachment updatedby numeric 10 User who updated this records
ad_color updatedby numeric 10 User who updated this records
ad_ctxhelpsuggestion updatedby numeric 10 User who updated this records
ad_fieldsuggestion updatedby numeric 10 User who updated this records
ad_form updatedby numeric 10 User who updated this records
ad_image updatedby numeric 10 User who updated this records
ad_impformat updatedby numeric 10 User who updated this records
ad_impformat_row updatedby numeric 10 User who updated this records
ad_issue updatedby numeric 10 User who updated this records
ad_menu updatedby numeric 10 User who updated this records
ad_message updatedby numeric 10 User who updated this records
ad_message_trl updatedby numeric 10 User who updated this records
ad_migrationscript updatedby numeric 10 User who updated this records
ad_note updatedby numeric 10 User who updated this records
ad_pinstance updatedby numeric 10 User who updated this records
ad_pinstance_para updatedby numeric 10  √  null User who updated this records
ad_printform updatedby numeric 10 User who updated this records
ad_process updatedby numeric 10 User who updated this records
ad_process_para updatedby numeric 10 User who updated this records
ad_recentitem updatedby numeric 10 User who updated this records
ad_sequence updatedby numeric 10 User who updated this records
ad_sequence_audit updatedby numeric 10 User who updated this records
ad_sequence_no updatedby numeric 10 User who updated this records
ad_storageprovider updatedby numeric 10 NULL::numeric User who updated this records
ad_table updatedby numeric 10 User who updated this records
ad_task updatedby numeric 10 User who updated this records
ad_taskinstance updatedby numeric 10  √  null User who updated this records
ad_userpreference updatedby numeric 10 User who updated this records
ad_val_rule updatedby numeric 10 User who updated this records
ad_wf_process updatedby numeric 10 User who updated this records
ad_window updatedby numeric 10 User who updated this records
ad_wlistbox_customization updatedby numeric 10 User who updated this records
ad_workflow updatedby numeric 10 User who updated this records
c_bpartner updatedby numeric 10 User who updated this records
c_doctype updatedby numeric 10 User who updated this records
c_uom updatedby numeric 10 User who updated this records
c_uom_conversion updatedby numeric 10 User who updated this records
test updatedby numeric 10 User who updated this records
testuu updatedby numeric 10 User who updated this records
testuu_trl updatedby numeric 10 User who updated this records
testuudet updatedby numeric 10 User who updated this records
ad_workflow version numeric 10 0 Version of the table definition
ad_workflow waitingtime numeric 10 0 Workflow Simulation Waiting time
ad_window winheight numeric 10  √  null Window Height
ad_window winwidth numeric 10  √  null Window Width
ad_workflow workingtime numeric 10 0 Workflow Simulation Execution Time
ad_workflow yield numeric 10  √  (100)::numeric The Yield is the percentage of a lot that is expected to be of acceptable wuality may fall below 100 percent
test characterdata text 2147483647  √  null Long Character Field
ad_workflow help text 2147483647  √  null Comment or Hint
ad_archive created timestamp 29,6 now() Date this record was created
ad_attachment created timestamp 29,6 now() Date this record was created
ad_color created timestamp 29,6 now() Date this record was created
ad_ctxhelpsuggestion created timestamp 29,6 statement_timestamp() Date this record was created
ad_fieldsuggestion created timestamp 29,6 statement_timestamp() Date this record was created
ad_form created timestamp 29,6 now() Date this record was created
ad_image created timestamp 29,6 now() Date this record was created
ad_impformat created timestamp 29,6 now() Date this record was created
ad_impformat_row created timestamp 29,6 now() Date this record was created
ad_issue created timestamp 29,6 now() Date this record was created
ad_menu created timestamp 29,6 now() Date this record was created
ad_message created timestamp 29,6 now() Date this record was created
ad_message_trl created timestamp 29,6 now() Date this record was created
ad_migrationscript created timestamp 29,6 statement_timestamp() Date this record was created
ad_note created timestamp 29,6 now() Date this record was created
ad_pinstance created timestamp 29,6 now() Date this record was created
ad_pinstance_para created timestamp 29,6 statement_timestamp() Date this record was created
ad_printform created timestamp 29,6 now() Date this record was created
ad_process created timestamp 29,6 now() Date this record was created
ad_process_para created timestamp 29,6 now() Date this record was created
ad_recentitem created timestamp 29,6 statement_timestamp() Date this record was created
ad_sequence created timestamp 29,6 now() Date this record was created
ad_sequence_audit created timestamp 29,6 now() Date this record was created
ad_sequence_no created timestamp 29,6 now() Date this record was created
ad_storageprovider created timestamp 29,6 statement_timestamp() Date this record was created
ad_table created timestamp 29,6 now() Date this record was created
ad_task created timestamp 29,6 now() Date this record was created
ad_taskinstance created timestamp 29,6 now() Date this record was created
ad_userpreference created timestamp 29,6 statement_timestamp() Date this record was created
ad_val_rule created timestamp 29,6 now() Date this record was created
ad_wf_process created timestamp 29,6 now() Date this record was created
ad_window created timestamp 29,6 now() Date this record was created
ad_wlistbox_customization created timestamp 29,6 statement_timestamp() Date this record was created
ad_workflow created timestamp 29,6 now() Date this record was created
c_bpartner created timestamp 29,6 now() Date this record was created
c_doctype created timestamp 29,6 now() Date this record was created
c_uom created timestamp 29,6 now() Date this record was created
c_uom_conversion created timestamp 29,6 now() Date this record was created
test created timestamp 29,6 now() Date this record was created
testuu created timestamp 29,6 Date this record was created
testuu_trl created timestamp 29,6 Date this record was created
testuudet created timestamp 29,6 Date this record was created
c_bpartner dunninggrace timestamp 29,6  √  null Dunning Grace Date
c_bpartner firstsale timestamp 29,6  √  null Date of First Sale
ad_pinstance_log p_date timestamp 29,6  √  now() Process Parameter
ad_pinstance_para p_date timestamp 29,6  √  null Process Parameter
ad_pinstance_para p_date_to timestamp 29,6  √  null Process Parameter
test t_date timestamp 29,6  √  null Date
test t_datetime timestamp 29,6  √  null DateTime
ad_archive updated timestamp 29,6 now() Date this record was updated
ad_attachment updated timestamp 29,6 now() Date this record was updated
ad_color updated timestamp 29,6 now() Date this record was updated
ad_ctxhelpsuggestion updated timestamp 29,6 statement_timestamp() Date this record was updated
ad_fieldsuggestion updated timestamp 29,6 statement_timestamp() Date this record was updated
ad_form updated timestamp 29,6 now() Date this record was updated
ad_image updated timestamp 29,6 now() Date this record was updated
ad_impformat updated timestamp 29,6 now() Date this record was updated
ad_impformat_row updated timestamp 29,6 now() Date this record was updated
ad_issue updated timestamp 29,6 now() Date this record was updated
ad_menu updated timestamp 29,6 now() Date this record was updated
ad_message updated timestamp 29,6 now() Date this record was updated
ad_message_trl updated timestamp 29,6 now() Date this record was updated
ad_migrationscript updated timestamp 29,6 statement_timestamp() Date this record was updated
ad_note updated timestamp 29,6 now() Date this record was updated
ad_pinstance updated timestamp 29,6 statement_timestamp() Date this record was updated
ad_pinstance_para updated timestamp 29,6 statement_timestamp() Date this record was updated
ad_printform updated timestamp 29,6 now() Date this record was updated
ad_process updated timestamp 29,6 now() Date this record was updated
ad_process_para updated timestamp 29,6 now() Date this record was updated
ad_recentitem updated timestamp 29,6 statement_timestamp() Date this record was updated
ad_sequence updated timestamp 29,6 now() Date this record was updated
ad_sequence_audit updated timestamp 29,6 now() Date this record was updated
ad_sequence_no updated timestamp 29,6 now() Date this record was updated
ad_storageprovider updated timestamp 29,6 statement_timestamp() Date this record was updated
ad_table updated timestamp 29,6 now() Date this record was updated
ad_task updated timestamp 29,6 now() Date this record was updated
ad_taskinstance updated timestamp 29,6 now() Date this record was updated
ad_userpreference updated timestamp 29,6 statement_timestamp() Date this record was updated
ad_val_rule updated timestamp 29,6 now() Date this record was updated
ad_wf_process updated timestamp 29,6 now() Date this record was updated
ad_window updated timestamp 29,6 now() Date this record was updated
ad_wlistbox_customization updated timestamp 29,6 statement_timestamp() Date this record was updated
ad_workflow updated timestamp 29,6 now() Date this record was updated
c_bpartner updated timestamp 29,6 now() Date this record was updated
c_doctype updated timestamp 29,6 now() Date this record was updated
c_uom updated timestamp 29,6 now() Date this record was updated
c_uom_conversion updated timestamp 29,6 now() Date this record was updated
test updated timestamp 29,6 now() Date this record was updated
testuu updated timestamp 29,6 Date this record was updated
testuu_trl updated timestamp 29,6 Date this record was updated
testuudet updated timestamp 29,6 Date this record was updated
ad_workflow validfrom timestamp 29,6  √  null Valid from including this date (first day)
ad_workflow validto timestamp 29,6  √  null Valid to including this date (last day)
test t_timestamp timestamptz 35,6  √  null Timestamp with time zone
ad_table copycolumnsfromtable varchar 1  √  null Copy Columns From Table
ad_impformat separatorchar varchar 1  √  NULL::character varying Separator Character
ad_process allowmultipleexecution varchar 2 'P'::character varying Allow or disallow executing a process/report multiple times concurrently
c_doctype docsubtypeinv varchar 2  √  NULL::character varying Inventory Sub Type
ad_pinstance notificationtype varchar 2  √  NULL::character varying Type of Notifications
c_uom uomtype varchar 2  √  NULL::character varying UOM Type
ad_pinstance_log pinstancelogtype varchar 3  √  'R'::character varying Process Audit Log Type
c_uom x12de355 varchar 4 UOM EDI X12 Code
ad_pinstance reporttype varchar 5  √  NULL::character varying Report Type
ad_ctxhelpsuggestion ad_language varchar 6 Language for this entity
ad_fieldsuggestion ad_language varchar 6 Language for this entity
ad_message_trl ad_language varchar 6 Language for this entity
c_bpartner ad_language varchar 6  √  null Language for this entity
testuu_trl ad_language varchar 6 Language for this entity
ad_sequence_no calendaryearmonth varchar 6 '0000'::character varying YYYYMM
c_bpartner naics varchar 6  √  null Standard Industry Code or its successor NAIC - http://www.osha.gov/oshstats/sicser.html
test color varchar 7  √  NULL::character varying Color
ad_issue releaseno varchar 10 '.'::character varying Internal Release Number
ad_migrationscript releaseno varchar 10 Internal Release Number
c_uom uomsymbol varchar 10  √  null Symbol for a Unit of Measure
c_bpartner duns varchar 11  √  null Dun & Bradstreet Number
ad_workflow author varchar 20 'ComPiere'::character varying Author/Creator of the Entity
ad_impformat_row dataformat varchar 20  √  null Format String in Java Notation, e.g. ddMMyy
ad_impformat_row importprefix varchar 20  √  NULL::character varying This prefix will be added in front of import string if they are not empty
c_bpartner poreference varchar 20  √  null Transaction Reference Number (Sales Order, Purchase Order) of your Business Partner
c_bpartner taxid varchar 20  √  null Tax Identification
ad_process_para valuemax varchar 20  √  null Maximum Value for a field
ad_process_para valuemin varchar 20  √  null Minimum Value for a field
ad_process_para columnname varchar 30 Name of the column in the database
ad_sequence_audit documentno varchar 30 Document sequence number of the document
ad_workflow documentno varchar 30  √  null Document sequence number of the document
ad_issue requestdocumentno varchar 30  √  null iDempiere Request Document No
ad_archive ad_archive_uu varchar 36  √  NULL::character varying AD_Archive_UU
ad_attachment ad_attachment_uu varchar 36  √  NULL::character varying AD_Attachment_UU
ad_color ad_color_uu varchar 36  √  NULL::character varying AD_Color_UU
ad_ctxhelpsuggestion ad_ctxhelpsuggestion_uu varchar 36 Context Help Suggestion UUID
ad_fieldsuggestion ad_fieldsuggestion_uu varchar 36 Field Suggestions UUID
ad_form ad_form_uu varchar 36  √  NULL::character varying AD_Form_UU
ad_image ad_image_uu varchar 36  √  NULL::character varying AD_Image_UU
ad_impformat_row ad_impformat_row_uu varchar 36  √  NULL::character varying AD_ImpFormat_Row_UU
ad_impformat ad_impformat_uu varchar 36  √  NULL::character varying AD_ImpFormat_UU
ad_issue ad_issue_uu varchar 36  √  NULL::character varying AD_Issue_UU
ad_menu ad_menu_uu varchar 36  √  NULL::character varying AD_Menu_UU
ad_message_trl ad_message_trl_uu varchar 36  √  NULL::character varying AD_Message_Trl_UU
ad_message ad_message_uu varchar 36  √  NULL::character varying AD_Message_UU
ad_migrationscript ad_migrationscript_uu varchar 36  √  NULL::character varying AD_MigrationScript_UU
ad_note ad_note_uu varchar 36  √  NULL::character varying AD_Note_UU
ad_pinstance_log ad_pinstance_log_uu varchar 36  √  null AD_PInstance_Log_UU
ad_pinstance_para ad_pinstance_para_uu varchar 36  √  NULL::character varying AD_PInstance_Para_UU
ad_pinstance ad_pinstance_uu varchar 36  √  NULL::character varying AD_PInstance_UU
ad_printform ad_printform_uu varchar 36  √  NULL::character varying AD_PrintForm_UU
ad_process_para ad_process_para_uu varchar 36  √  NULL::character varying AD_Process_Para_UU
ad_process ad_process_uu varchar 36  √  NULL::character varying AD_Process_UU
ad_recentitem ad_recentitem_uu varchar 36  √  NULL::character varying AD_RecentItem_UU
ad_sequence_audit ad_sequence_audit_uu varchar 36  √  NULL::character varying AD_Sequence_Audit_UU
ad_sequence_no ad_sequence_no_uu varchar 36  √  NULL::character varying AD_Sequence_No_UU
ad_sequence ad_sequence_uu varchar 36  √  NULL::character varying AD_Sequence_UU
ad_storageprovider ad_storageprovider_uu varchar 36  √  NULL::character varying AD_StorageProvider_UU
ad_table ad_table_uu varchar 36  √  NULL::character varying AD_Table_UU
ad_task ad_task_uu varchar 36  √  NULL::character varying AD_Task_UU
ad_taskinstance ad_taskinstance_uu varchar 36  √  NULL::character varying AD_TaskInstance_UU
ad_userpreference ad_userpreference_uu varchar 36  √  NULL::character varying AD_UserPreference_UU
ad_val_rule ad_val_rule_uu varchar 36  √  NULL::character varying AD_Val_Rule_UU
ad_wf_process ad_wf_process_uu varchar 36  √  NULL::character varying AD_WF_Process_UU
ad_window ad_window_uu varchar 36  √  NULL::character varying AD_Window_UU
ad_wlistbox_customization ad_wlistbox_customization_uu varchar 36  √  NULL::character varying AD_Wlistbox_Customization_UU
ad_workflow ad_workflow_uu varchar 36  √  NULL::character varying AD_Workflow_UU
testuudet alttestuu_uu varchar 36  √  null Alternate Test UU
c_bpartner c_bpartner_uu varchar 36  √  NULL::character varying C_BPartner_UU
c_doctype c_doctype_uu varchar 36  √  NULL::character varying C_DocType_UU
c_uom_conversion c_uom_conversion_uu varchar 36  √  NULL::character varying C_UOM_Conversion_UU
c_uom c_uom_uu varchar 36  √  NULL::character varying C_UOM_UU
ad_archive record_uu varchar 36  √  NULL::character varying Record UUID
ad_attachment record_uu varchar 36  √  NULL::character varying Record UUID
ad_pinstance record_uu varchar 36  √  NULL::character varying Record UUID
ad_recentitem record_uu varchar 36  √  NULL::character varying Record UUID
test record_uu varchar 36  √  NULL::character varying Record UUID
test test_uu varchar 36  √  NULL::character varying Test_UU
testuu_trl testuu_trl_uu varchar 36  √  NULL::character varying TestUU_Trl_UU
testuu testuu_uu varchar 36 NULL::character varying Test UU
testuu_trl testuu_uu varchar 36 Test UU
testuudet testuu_uu varchar 36 Test UU
testuudet testuudet_uu varchar 36 NULL::character varying TestUUDet_UU
ad_sequence decimalpattern varchar 40  √  null Java Decimal Pattern
ad_form entitytype varchar 40 'D'::character varying Dictionary Entity Type; Determines ownership and synchronization
ad_image entitytype varchar 40 'U'::character varying Dictionary Entity Type; Determines ownership and synchronization
ad_menu entitytype varchar 40 'D'::character varying Dictionary Entity Type; Determines ownership and synchronization
ad_message entitytype varchar 40 'D'::character varying Dictionary Entity Type; Determines ownership and synchronization
ad_process entitytype varchar 40 'D'::character varying Dictionary Entity Type; Determines ownership and synchronization
ad_process_para entitytype varchar 40 'D'::character varying Dictionary Entity Type; Determines ownership and synchronization
ad_table entitytype varchar 40 'D'::character varying Dictionary Entity Type; Determines ownership and synchronization
ad_task entitytype varchar 40 'D'::character varying Dictionary Entity Type; Determines ownership and synchronization
ad_val_rule entitytype varchar 40 'D'::character varying Dictionary Entity Type; Determines ownership and synchronization
ad_window entitytype varchar 40 'D'::character varying Dictionary Entity Type; Determines ownership and synchronization
ad_workflow entitytype varchar 40 'D'::character varying Dictionary Entity Type; Determines ownership and synchronization
c_bpartner referenceno varchar 40  √  null Your customer or vendor number at the Business Partner's site
ad_table tablename varchar 40 Name of the table in the database
ad_process value varchar 40 Search key for the record in the format required - must be unique
ad_workflow value varchar 40 Search key for the record in the format required - must be unique
c_bpartner value varchar 40 Search key for the record in the format required - must be unique
testuu value varchar 40  √  NULL::character varying Search key for the record in the format required - must be unique
ad_issue version varchar 40 Version of the table definition
ad_sequence vformat varchar 40  √  null Format of the value; Can contain fixed format elements, Variables: "_lLoOaAcCa09"
ad_process workflowvalue varchar 40  √  null Key of the Workflow to start
ad_form classname varchar 60  √  null Java Classname
ad_impformat_row constantvalue varchar 60  √  null Constant value
c_bpartner customerprofileid varchar 60  √  NULL::character varying Customer Profile ID
ad_sequence datecolumn varchar 60  √  null Fully qualified date column
ad_migrationscript developername varchar 60  √  null Developer Name
ad_storageprovider method varchar 60  √  NULL::character varying Method
ad_archive name varchar 60 Alphanumeric identifier of the entity
ad_color name varchar 60 Alphanumeric identifier of the entity
ad_fieldsuggestion name varchar 60  √  NULL::character varying Alphanumeric identifier of the entity
ad_form name varchar 60 Alphanumeric identifier of the entity
ad_image name varchar 60 Alphanumeric identifier of the entity
ad_impformat name varchar 60 Alphanumeric identifier of the entity
ad_impformat_row name varchar 60 Alphanumeric identifier of the entity
ad_issue name varchar 60 Alphanumeric identifier of the entity
ad_menu name varchar 60 Alphanumeric identifier of the entity
ad_migrationscript name varchar 60 Alphanumeric identifier of the entity
ad_pinstance name varchar 60  √  NULL::character varying Alphanumeric identifier of the entity
ad_printform name varchar 60 Alphanumeric identifier of the entity
ad_process name varchar 60 Alphanumeric identifier of the entity
ad_process_para name varchar 60 Alphanumeric identifier of the entity
ad_sequence name varchar 60 Alphanumeric identifier of the entity
ad_storageprovider name varchar 60 NULL::character varying Alphanumeric identifier of the entity
ad_table name varchar 60 Alphanumeric identifier of the entity
ad_task name varchar 60 Alphanumeric identifier of the entity
ad_val_rule name varchar 60 Alphanumeric identifier of the entity
ad_window name varchar 60 Alphanumeric identifier of the entity
ad_workflow name varchar 60 Alphanumeric identifier of the entity
c_doctype name varchar 60 Alphanumeric identifier of the entity
c_uom name varchar 60 Alphanumeric identifier of the entity
test name varchar 60 Alphanumeric identifier of the entity
testuu name varchar 60 Alphanumeric identifier of the entity
testuu_trl name varchar 60 Alphanumeric identifier of the entity
testuudet name varchar 60 Alphanumeric identifier of the entity
c_bpartner name2 varchar 60  √  null Additional Name
ad_sequence orgcolumn varchar 60  √  NULL::character varying Fully qualified Organization column (AD_Org_ID)
ad_pinstance_para parametername varchar 60  √  null Parameter Name
c_doctype printname varchar 60 The label text to be printed on a document or correspondence.
ad_process procedurename varchar 60  √  null Name of the Database Procedure
ad_migrationscript projectname varchar 60 Name of the Project
ad_issue releasetag varchar 60  √  null Release Tag
ad_issue remote_addr varchar 60  √  null Remote Address
ad_issue sourcemethodname varchar 60  √  null Source Method Name
ad_issue supportemail varchar 60  √  null EMail address to send support information and updates to
ad_attachment title varchar 60 Name this entity is referred to as
ad_issue username varchar 60 User Name
ad_storageprovider username varchar 60  √  NULL::character varying User Name
ad_wlistbox_customization wlistboxname varchar 80 WlistboxName
ad_form imageurl varchar 120  √  NULL::character varying URL of image
ad_image imageurl varchar 120  √  null URL of image
ad_form jspurl varchar 120  √  null Web URL of the jsp function
ad_issue local_host varchar 120  √  null Local Host Info
c_bpartner name varchar 120 Alphanumeric identifier of the entity
ad_issue remote_host varchar 120  √  null Remote host Info
c_bpartner url varchar 120  √  null Full URL address - e.g. http://www.idempiere.org
ad_storageprovider url varchar 225  √  NULL::character varying Full URL address - e.g. http://www.idempiere.org
ad_process classname varchar 255  √  null Java Classname
ad_issue databaseinfo varchar 255  √  null Database Information
ad_issue dbaddress varchar 255  √  null JDBC URL of the database server
ad_archive description varchar 255  √  null Optional short description of the record
ad_fieldsuggestion description varchar 255  √  NULL::character varying Optional short description of the record
ad_form description varchar 255  √  null Optional short description of the record
ad_image description varchar 255  √  null Optional short description of the record
ad_impformat description varchar 255  √  null Optional short description of the record
ad_menu description varchar 255  √  null Optional short description of the record
ad_note description varchar 255  √  null Optional short description of the record
ad_printform description varchar 255  √  null Optional short description of the record
ad_process description varchar 255  √  null Optional short description of the record
ad_process_para description varchar 255  √  null Optional short description of the record
ad_sequence description varchar 255  √  null Optional short description of the record
ad_table description varchar 255  √  null Optional short description of the record
ad_task description varchar 255  √  null Optional short description of the record
ad_val_rule description varchar 255  √  null Optional short description of the record
ad_window description varchar 255  √  null Optional short description of the record
ad_workflow description varchar 255  √  null Optional short description of the record
c_bpartner description varchar 255  √  null Optional short description of the record
c_doctype description varchar 255  √  null Optional short description of the record
c_uom description varchar 255  √  null Optional short description of the record
test description varchar 255  √  null Optional short description of the record
testuu description varchar 255  √  NULL::character varying Optional short description of the record
testuu_trl description varchar 255  √  NULL::character varying Optional short description of the record
ad_process filenamepattern varchar 255  √  NULL::character varying File Name Pattern
ad_storageprovider folder varchar 255  √  NULL::character varying A folder on a local or remote system to store data into
ad_process jasperreport varchar 255  √  null Jasper Report
ad_issue javainfo varchar 255  √  null Java Version Info
ad_issue loggername varchar 255  √  null Logger Name
ad_userpreference migrationscriptcomment varchar 255  √  NULL::character varying Migration Script Comment
ad_issue operatingsysteminfo varchar 255  √  null Operating System Info
ad_storageprovider password varchar 255  √  NULL::character varying Password of any length (case sensitive)
ad_process_para placeholder varchar 255  √  NULL::character varying Placeholder
ad_process_para placeholder2 varchar 255  √  NULL::character varying Placeholder2
ad_sequence prefix varchar 255  √  null Prefix before the sequence number
ad_note reference varchar 255  √  null Reference for this record
c_bpartner so_description varchar 255  √  null Description to be used on orders
ad_issue sourceclassname varchar 255  √  null Source Class Name
ad_issue statisticsinfo varchar 255  √  null Information to help profiling the system for solving support issues
ad_sequence suffix varchar 255  √  null Suffix after the number
ad_window titlelogic varchar 255  √  NULL::character varying The result determines the title to be displayed for this window
ad_message value varchar 255 Search key for the record in the format required - must be unique
ad_process_para vformat varchar 255  √  null Format of the value; Can contain fixed format elements, Variables: "_lLoOaAcCa09"
ad_migrationscript filename varchar 500 Name of the local file or URL
ad_issue comments varchar 2000  √  null Comments or additional information
ad_process_para defaultvalue varchar 2000  √  null Default value hierarchy, separated by ;
ad_process_para defaultvalue2 varchar 2000  √  null Default value hierarchy, separated by ;
ad_migrationscript description varchar 2000  √  null Optional short description of the record
ad_process_para displaylogic varchar 2000  √  null If the Field is displayed, the result determines if the field is actually displayed
c_doctype documentnote varchar 2000  √  null Additional information for a Document
ad_workflow docvaluelogic varchar 2000  √  null Logic to determine Workflow Start - If true, a workflow process is started for the document
ad_pinstance errormsg varchar 2000  √  null Error Msg
ad_issue errortrace varchar 2000  √  null System Error Trace
ad_archive help varchar 2000  √  null Comment or Hint
ad_fieldsuggestion help varchar 2000  √  NULL::character varying Comment or Hint
ad_form help varchar 2000  √  null Comment or Hint
ad_process help varchar 2000  √  null Comment or Hint
ad_process_para help varchar 2000  √  null Comment or Hint
ad_table help varchar 2000  √  null Comment or Hint
ad_task help varchar 2000  √  null Comment or Hint
ad_window help varchar 2000  √  null Comment or Hint
test help varchar 2000  √  null Comment or Hint
testuu help varchar 2000  √  NULL::character varying Comment or Hint
testuu_trl help varchar 2000  √  NULL::character varying Comment or Hint
ad_issue issuesummary varchar 2000 Issue Summary
ad_process_para mandatorylogic varchar 2000  √  NULL::character varying Mandatory Logic
ad_ctxhelpsuggestion msgtext varchar 2000 Textual Informational, Menu or Error Message
ad_message msgtext varchar 2000 Textual Informational, Menu or Error Message
ad_message_trl msgtext varchar 2000 Textual Informational, Menu or Error Message
ad_message msgtip varchar 2000  √  null Additional tip or help for this message
ad_message_trl msgtip varchar 2000  √  null Additional tip or help for this message
ad_task os_command varchar 2000 Operating System Command
ad_process_para query varchar 2000  √  NULL::character varying SQL
ad_process_para readonlylogic varchar 2000  √  null Logic to determine if field is read only (applies only when field is read-write)
ad_migrationscript reference varchar 2000  √  null Reference for this record
ad_issue responsetext varchar 2000  √  null Request Response Text
ad_impformat_row script varchar 2000  √  null Dynamic Java Language Script to calculate result
ad_issue stacktrace varchar 2000  √  null System Log Trace
testuudet testuu_uus varchar 2000  √  NULL::character varying Multi Test UU
ad_attachment textmsg varchar 2000  √  null Text Message
ad_note textmsg varchar 2000  √  null Text Message
ad_wf_process textmsg varchar 2000  √  null Text Message
ad_migrationscript url varchar 2000  √  null Full URL address - e.g. http://www.idempiere.org
ad_impformat_row callout varchar 4000  √  null Fully qualified class names and method - separated by semicolons
ad_val_rule code varchar 4000  √  null Validation Code
ad_wlistbox_customization custom varchar 4000 Custom
ad_pinstance_para info varchar 4000  √  null Information
ad_pinstance_para info_to varchar 4000  √  null Info To
ad_pinstance_log p_msg varchar 4000  √  null Process Message
ad_pinstance_para p_string varchar 4000  √  null Process Parameter
ad_pinstance_para p_string_to varchar 4000  √  null Process Parameter
ad_menu predefinedcontextvariables varchar 4000  √  NULL::character varying Predefined context variables to inject when opening a menu entry or a window
ad_window predefinedcontextvariables varchar 4000  √  NULL::character varying Predefined context variables to inject when opening a menu entry or a window
ad_issue profileinfo varchar 4000  √  null Information to help profiling the system for solving support issues