Difference between revisions of "CGS Constants list"
(→Diagrams constants) |
|||
| (22 intermediate revisions by 4 users not shown) | |||
| Line 1: | Line 1: | ||
| − | === Search type constants === | + | = CGScript Constants List = |
| + | |||
| + | === Search type constants === | ||
| + | |||
<source lang="sql"> | <source lang="sql"> | ||
NAME_SEARCH_TYPE_ANYWHERE | NAME_SEARCH_TYPE_ANYWHERE | ||
| Line 7: | Line 10: | ||
</source> | </source> | ||
| + | === Resource access constant === | ||
| + | |||
| + | <source lang="sql"> | ||
| + | RESOURCE_ACCESS_OBSERVER | ||
| + | RESOURCE_ACCESS_MANAGER | ||
| + | RESOURCE_ACCESS_ADMINISTRATOR | ||
| + | </source> | ||
| + | |||
| + | === Resource type constant === | ||
| − | |||
<source lang="sql"> | <source lang="sql"> | ||
Resource_Type_ResourceTemplate | Resource_Type_ResourceTemplate | ||
| Line 46: | Line 57: | ||
</source> | </source> | ||
| − | === Resource access constant === | + | === Resource access constant === |
| + | |||
<source lang="sql"> | <source lang="sql"> | ||
RESOURCE_ACCESS_OBSERVER | RESOURCE_ACCESS_OBSERVER | ||
| Line 53: | Line 65: | ||
</source> | </source> | ||
| − | === Ledger entry constant === | + | === Task constant === |
| + | |||
| + | <source lang="sql"> | ||
| + | TASK_RESOURCE_ID | ||
| + | TASK_CASE_NUMBER | ||
| + | TASK_NAME | ||
| + | TASK_PARENT_RESOURCE_ID | ||
| + | TASK_TEMPLATE_RESOURCE_ID | ||
| + | TASK_TIME_REGISTRATION | ||
| + | TASK_COMPLETED | ||
| + | TASK_TESTCASE | ||
| + | TASK_RESPONSIBLE_RESOURCE_ID | ||
| + | TASK_SUPERVISOR_RESOURCE_ID | ||
| + | TASK_OBSERVER | ||
| + | TASK_OBSERVER_INHERIT_ACCESS | ||
| + | TASK_STATUS | ||
| + | TASK_ACCEPTANCE_DEADLINE | ||
| + | TASK_COMPLETION_DEADLINE | ||
| + | TASK_APPROVAL_DEADLINE | ||
| + | TASK_ACTUAL_START_DATE | ||
| + | TASK_ACTUAL_END_DATE | ||
| + | TASK_APPROVED_DATE | ||
| + | TASK_MAN_HOURS | ||
| + | TASK_DESCRIPTION | ||
| + | </source> | ||
| + | |||
| + | === Task status constant === | ||
| + | |||
| + | <source lang="sql"> | ||
| + | TASK_STATUS_NEEDACCEPTANCE | ||
| + | TASK_STATUS_INPROGRESS | ||
| + | TASK_STATUS_APPROVED | ||
| + | TASK_STATUS_AWAITINGAPPROVAL | ||
| + | </source> | ||
| + | |||
| + | === User constant === | ||
| + | |||
| + | <source lang="sql"> | ||
| + | USER_RESOURCE_ID | ||
| + | USER_NAME | ||
| + | USER_TEMPLATE_RESOURCE_ID | ||
| + | USER_PASSWORD | ||
| + | USER_TIME_REGISTRATION | ||
| + | USER_MAN_HOURS | ||
| + | USER_CALCULATED_MAN_HOURS | ||
| + | USER_PHONE_NUMBER | ||
| + | USER_ACCESS_EXPIRATION | ||
| + | USER_PROTECTED_UNTIL | ||
| + | USER_LANGUAGE | ||
| + | USER_CULTURE | ||
| + | USER_EMAIL | ||
| + | USER_FIRST_NAME | ||
| + | USER_MIDDLE_NAME | ||
| + | USER_LAST_NAME | ||
| + | USER_CURRENCY | ||
| + | USER_DISCOUNT | ||
| + | USER_POINT_BALANCE | ||
| + | USER_TIMEZONE | ||
| + | USER_ADDRESS | ||
| + | USER_CITY | ||
| + | USER_ZIPCODE | ||
| + | USER_REGION | ||
| + | USER_COUNTRY | ||
| + | USER_POSTBOX | ||
| + | USER_WEBSITE | ||
| + | USER_DELETED | ||
| + | USER_DISABLED | ||
| + | USER_MASK | ||
| + | </source> | ||
| + | |||
| + | === Questionnaire constant === | ||
| + | |||
| + | <source lang="sql"> | ||
| + | QUESTIONNAIRE_OBJECT_TYPE | ||
| + | QUESTIONNAIRE_RESOURCE_ID | ||
| + | QUESTIONNAIRE_NAME | ||
| + | QUESTIONNAIRE_RESOURCE_TEMPLATE_RESOURCE_ID | ||
| + | QUESTIONNAIRE_PARENT_RESOURCE_ID | ||
| + | QUESTIONNAIRE_TEMPLATE_RESOURCE_ID | ||
| + | QUESTIONNAIRE_TIME_REGISTRATION | ||
| + | QUESTIONNAIRE_COMPLETED | ||
| + | QUESTIONNAIRE_DISPLAY_IN_MY_QUESTIONNAIRE | ||
| + | QUESTIONNAIRE_USE_OLD_VIEWER | ||
| + | QUESTIONNAIRE_ALIAS | ||
| + | QUESTIONNAIRE_LAYOUT_RESOURCE_ID | ||
| + | QUESTIONNAIRE_TIME_ESTIMATE | ||
| + | QUESTIONNAIRE_STATUS | ||
| + | QUESTIONNAIRE_TARGET | ||
| + | QUESTIONNAIRE_CATI_OUTCOME_SET | ||
| + | QUESTIONNAIRE_AUTOMATIC_RELEASE_DATE | ||
| + | QUESTIONNAIRE_DEVELOPMENT_START_DATE | ||
| + | QUESTIONNAIRE_AUTOMATIC_CLOSE_DATE | ||
| + | QUESTIONNAIRE_DEVELOPMENT_END_DATE | ||
| + | QUESTIONNAIRE_MAN_HOURS | ||
| + | QUESTIONNAIRE_DESCRIPTION | ||
| + | </source> | ||
| + | |||
| + | === QuestionnaireStatus constant === | ||
| + | <source lang="sql"> | ||
| + | QUESTIONNAIRE_STATUS_CLOSED: 1 | ||
| + | QUESTIONNAIRE_STATUS_PAUSED: 2 | ||
| + | QUESTIONNAIRE_STATUS_ACTIVE: 3 | ||
| + | QUESTIONNAIRE_STATUS_OPEN_FOR_TEST: 4 | ||
| + | </source> | ||
| + | === CATI CGS constant === | ||
| + | |||
| + | <source lang="sql"> | ||
| + | CATI_OBJECT_TYPE | ||
| + | CATI_CONTACT_ID | ||
| + | CATI_CONTACT_INTERVIEWER_USER_RESOURCE_ID | ||
| + | CATI_CONTACT_START_DATE | ||
| + | CATI_CONTACT_END_DATE | ||
| + | CATI_CONTACT_OUTCOME_STATUS_ID | ||
| + | CATI_CONTACT_OUTCOME_STATUS_AS_TEXT | ||
| + | CATI_CONTACT_DESCRIPTION | ||
| + | </source> | ||
| + | |||
| + | === CATI list type constant === | ||
| + | |||
| + | <source lang="sql"> | ||
| + | CATI_MAIN | ||
| + | CATI_ONGOING | ||
| + | CATI_APPOINTMENT | ||
| + | CATI_FINISHED | ||
| + | CATI_RETRY | ||
| + | </source> | ||
| + | |||
| + | === QAS constant === | ||
| + | |||
| + | <source lang="sql"> | ||
| + | QAS_OBJECT_TYPE | ||
| + | QAS_ID | ||
| + | QAS_QUESTIONNAIRE_RESOURCE_ID | ||
| + | QAS_USER_RESOURCE_ID | ||
| + | QAS_TEST | ||
| + | QAS_STATUS | ||
| + | QAS_COMPLETED | ||
| + | QAS_STARTDATE | ||
| + | QAS_ENDDATE | ||
| + | QAS_GUID | ||
| + | QAS_CATI_APPOINTMENT | ||
| + | QAS_CATI_LIST_TYPE | ||
| + | QAS_CATI_TIMES_CALLED | ||
| + | </source> | ||
| + | |||
| + | === Project constant === | ||
| + | |||
| + | <source lang="sql"> | ||
| + | PROJECT_RESOURCE_ID | ||
| + | PROJECT_NAME | ||
| + | PROJECT_TEMPLATE_RESOURCE_ID | ||
| + | PROJECT_TIME_REGISTRATION | ||
| + | PROJECT_COMPLETED | ||
| + | PROJECT_PARENT_RESOURCE_ID | ||
| + | PROJECT_CODE | ||
| + | PROJECT_PROPOSE_CODE | ||
| + | PROJECT_CLIENT_REF_NO | ||
| + | PROJECT_TIME_BUDGET | ||
| + | PROJECT_CALCULATED_MAN_HOURS | ||
| + | PROJECT_PLANNED_START_DATE | ||
| + | PROJECT_ACTUAL_START_DATE | ||
| + | PROJECT_PLANNED_END_DATE | ||
| + | PROJECT_ACTUAL_END_DATE | ||
| + | </source> | ||
| + | |||
| + | === Bulk mail constant === | ||
| + | |||
| + | <source lang="sql"> | ||
| + | BULKMAIL_OBJECT | ||
| + | BULKMAIL_NAME | ||
| + | BULKMAIL_PARENT_RESOURCE_ID | ||
| + | BULKMAIL_MAIL_TEMPLTE_ID | ||
| + | BULKMAIL_TEMPLATE_RESOURCE_ID | ||
| + | </source> | ||
| + | |||
| + | === Group constant === | ||
| + | |||
| + | <source lang="sql"> | ||
| + | GROUP_RESOURCE_ID | ||
| + | GROUP_NAME | ||
| + | GROUP_TEMPLATE_RESOURCE_ID | ||
| + | GROUP_PARENT_RESOURCE_ID | ||
| + | GROUP_TIME_REGISTRATION | ||
| + | GROUP_MAN_HOURS | ||
| + | GROUP_CALCULATED_MAN_HOURS | ||
| + | </source> | ||
| + | |||
| + | === Folder constant === | ||
| + | |||
| + | <source lang="sql"> | ||
| + | FOLDER_RESOURCE_ID | ||
| + | FOLDER_NAME | ||
| + | FOLDER_PARENT_RESOURCE_ID | ||
| + | FOLDER_TEMPLATE_RESOURCE_ID | ||
| + | FOLDER_TIME_REGISTRATION | ||
| + | FOLDER_TIME_BUDGET | ||
| + | FOLDER_MAN_HOURS | ||
| + | FOLDER_DESCRIPTION | ||
| + | </source> | ||
| + | |||
| + | === Data cache - custom column constant === | ||
| + | |||
| + | <source lang="sql"> | ||
| + | CUSTOM_COLUMN_TYPE_NUMBER | ||
| + | CUSTOM_COLUMN_TYPE_BOOLEAN | ||
| + | CUSTOM_COLUMN_TYPE_STRING | ||
| + | CUSTOM_COLUMN_DATA_TYPE | ||
| + | CUSTOM_COLUMN_TEXT | ||
| + | CUSTOM_COLUMN_NAME | ||
| + | CUSTOM_COLUMN_OPTIONS | ||
| + | CUSTOM_COLUMN_OPTION_EXPRESSION | ||
| + | CUSTOM_COLUMN_OPTION_VALUE | ||
| + | CUSTOM_COLUMN_OPTION_TEXT | ||
| + | </source> | ||
| + | |||
| + | === Ledger entry constant === | ||
| + | |||
<source lang="sql"> | <source lang="sql"> | ||
LEDGER_ENTRY_ID | LEDGER_ENTRY_ID | ||
| Line 67: | Line 295: | ||
</source> | </source> | ||
| − | === Invoice constant === | + | === Invoice constant === |
| + | |||
<source lang="sql"> | <source lang="sql"> | ||
INVOICE_RESOURCE_ID | INVOICE_RESOURCE_ID | ||
| Line 86: | Line 315: | ||
INVOICE_LEDGER | INVOICE_LEDGER | ||
INVOICE_TOTAL | INVOICE_TOTAL | ||
| + | // Address to constant | ||
| + | INVOICE_CUSTOMER | ||
| + | INVOICE_REPRESENTATIVE | ||
</source> | </source> | ||
| − | === Diagrams constants === | + | === Diagrams constants === |
| + | |||
<source lang="sql"> | <source lang="sql"> | ||
Diagram_ShowModeType_Percentage | Diagram_ShowModeType_Percentage | ||
| Line 141: | Line 374: | ||
</source> | </source> | ||
| − | === Diagrams Known Color constants === | + | === Diagrams Known Color constants === |
| + | |||
<source lang="sql"> | <source lang="sql"> | ||
Diagram_KnownColor_ActiveBorder | Diagram_KnownColor_ActiveBorder | ||
| Line 317: | Line 551: | ||
Diagram_KnownColor_MenuBar | Diagram_KnownColor_MenuBar | ||
Diagram_KnownColor_MenuHighlight | Diagram_KnownColor_MenuHighlight | ||
| + | </source> | ||
| + | === Table Diagram constants === | ||
| + | <source lang="sql"> | ||
| + | TableDiagram_AllTable | ||
| + | TableDiagram_ColumnHeader | ||
| + | TableDiagram_ColumnHeaderLevel1 | ||
| + | TableDiagram_ColumnHeaderLevel2 | ||
| + | TableDiagram_ColumnHeaderLevel3 | ||
| + | TableDiagram_RowHeader | ||
| + | TableDiagram_RowHeaderLevel1 | ||
| + | TableDiagram_RowHeaderLevel2 | ||
| + | TableDiagram_RowHeaderLevel3 | ||
| + | TableDiagram_AbsoluteColumn | ||
| + | TableDiagram_AbsoluteColumnHeader | ||
| + | TableDiagram_AbsoluteColumnValue | ||
| + | TableDiagram_PercentageColumn | ||
| + | TableDiagram_PercentageColumnHeader | ||
| + | TableDiagram_PercentageColumnValue | ||
| + | TableDiagram_TotalColumn | ||
| + | TableDiagram_TotalColumnHeader | ||
| + | TableDiagram_TotalColumnValue | ||
| + | TableDiagram_TotalRow | ||
| + | TableDiagram_TotalRowHeader | ||
| + | TableDiagram_TotalRowValue | ||
| + | TableDiagram_AnswerRow | ||
| + | TableDiagram_AnswerRowAlternate | ||
| + | TableDiagram_VarianceRow | ||
| + | TableDiagram_VarianceRowHeader | ||
| + | TableDiagram_VarianceRowValue | ||
| + | TableDiagram_AverageRow | ||
| + | TableDiagram_AverageRowHeader | ||
| + | TableDiagram_AverageRowValue | ||
| + | TableDiagram_StdDevRow | ||
| + | TableDiagram_StdDevRowHeader | ||
| + | TableDiagram_StdDevRowValue | ||
| + | TableDiagram_StdErrorRow | ||
| + | TableDiagram_StdErrorRowHeader | ||
| + | TableDiagram_StdErrorRowValue | ||
| + | TableDiagram_MedianRow | ||
| + | TableDiagram_MedianRowHeader | ||
| + | TableDiagram_MedianRowValue | ||
| + | TableDiagram_QuantilesRow | ||
| + | TableDiagram_QuantilesRowHeader | ||
| + | TableDiagram_QuantilesRowValue | ||
| + | TableDiagram_PercentileRow | ||
| + | TableDiagram_PercentileRowHeader | ||
| + | TableDiagram_PercentileRowValue | ||
| + | TableDiagram_SignificanceRow | ||
| + | TableDiagram_SignificanceRowHeader | ||
| + | TableDiagram_SignificanceRowValue | ||
| + | TableDiagram_CountAnswerRow | ||
| + | TableDiagram_CountAnswerRowHeader | ||
| + | TableDiagram_CountAnswerRowValue | ||
| + | TableDiagram_TotalRespondentRow | ||
| + | TableDiagram_TotalRespondentRowHeader | ||
| + | TableDiagram_TotalRespondentRowValue | ||
| + | TableDiagram_WeightRow | ||
| + | TableDiagram_WeightRowHeader | ||
| + | TableDiagram_WeightRowValue | ||
| + | TableDiagram_QuestionHeader | ||
| + | </source> | ||
| − | + | === Table Diagram style constants === | |
| + | <source lang="sql"> | ||
| + | TABLE_DIAGRAM_STYLE_FILL, | ||
| + | TABLE_DIAGRAM_STYLE_DECIMAL | ||
| + | TABLE_DIAGRAM_STYLE_FONT | ||
| + | TABLE_DIAGRAM_STYLE_VALIGN | ||
| + | TABLE_DIAGRAM_STYLE_HALIGN | ||
| + | TABLE_DIAGRAM_STYLE_NUMBER_FORMATTER | ||
| + | TABLE_DIAGRAM_STYLE_PERCENT_FORMATTER | ||
| + | TABLE_DIAGRAM_STYLE_SIGNIFICANCE_FORMATTER | ||
| + | TABLE_DIAGRAM_STYLE_BORDER_STYLE | ||
| + | </source><br/>Back to [[DATA]] page | ||
| − | + | [[Category:Functions]] | |
Latest revision as of 05:23, 18 March 2022
Contents
- 1 CGScript Constants List
- 1.1 Search type constants
- 1.2 Resource access constant
- 1.3 Resource type constant
- 1.4 Resource access constant
- 1.5 Task constant
- 1.6 Task status constant
- 1.7 User constant
- 1.8 Questionnaire constant
- 1.9 QuestionnaireStatus constant
- 1.10 CATI CGS constant
- 1.11 CATI list type constant
- 1.12 QAS constant
- 1.13 Project constant
- 1.14 Bulk mail constant
- 1.15 Group constant
- 1.16 Folder constant
- 1.17 Data cache - custom column constant
- 1.18 Ledger entry constant
- 1.19 Invoice constant
- 1.20 Diagrams constants
- 1.21 Diagrams Known Color constants
- 1.22 Table Diagram constants
- 1.23 Table Diagram style constants
CGScript Constants List
Search type constants
NAME_SEARCH_TYPE_ANYWHERE
NAME_SEARCH_TYPE_END
NAME_SEARCH_TYPE_IDENTICAL
NAME_SEARCH_TYPE_START
Resource access constant
RESOURCE_ACCESS_OBSERVER
RESOURCE_ACCESS_MANAGER
RESOURCE_ACCESS_ADMINISTRATOR
Resource type constant
Resource_Type_ResourceTemplate
Resource_Type_User
Resource_Type_Group
Resource_Type_ReportTemplate
Resource_Type_Project
Resource_Type_Folder
Resource_Type_QuestionnaireTemplate
Resource_Type_Attachment
Resource_Type_Questionnaire
Resource_Type_Report
Resource_Type_MessageTemplate
Resource_Type_Image
Resource_Type_Layout
Resource_Type_Product
Resource_Type_MessageFolder
Resource_Type_EmailAccount
Resource_Type_Diagram
Resource_Type_Asset
Resource_Type_WorkFlow
Resource_Type_QuestionnaireScript
Resource_Type_TabulationScript
Resource_Type_LayoutTemplate
Resource_Type_Coding
Resource_Type_Task
Resource_Type_System
Resource_Type_DataCacheSpecification
Resource_Type_TaskSet
Resource_Type_PaperQuestionnaire
Resource_Type_SampleRequest
Resource_Type_BulkMail
Resource_Type_Function
Resource_Type_DCSExport
Resource_Type_TestCase
Resource_Type_BulkSms
Resource access constant
RESOURCE_ACCESS_OBSERVER
RESOURCE_ACCESS_MANAGER
RESOURCE_ACCESS_ADMINISTRATOR
Task constant
TASK_RESOURCE_ID
TASK_CASE_NUMBER
TASK_NAME
TASK_PARENT_RESOURCE_ID
TASK_TEMPLATE_RESOURCE_ID
TASK_TIME_REGISTRATION
TASK_COMPLETED
TASK_TESTCASE
TASK_RESPONSIBLE_RESOURCE_ID
TASK_SUPERVISOR_RESOURCE_ID
TASK_OBSERVER
TASK_OBSERVER_INHERIT_ACCESS
TASK_STATUS
TASK_ACCEPTANCE_DEADLINE
TASK_COMPLETION_DEADLINE
TASK_APPROVAL_DEADLINE
TASK_ACTUAL_START_DATE
TASK_ACTUAL_END_DATE
TASK_APPROVED_DATE
TASK_MAN_HOURS
TASK_DESCRIPTION
Task status constant
TASK_STATUS_NEEDACCEPTANCE
TASK_STATUS_INPROGRESS
TASK_STATUS_APPROVED
TASK_STATUS_AWAITINGAPPROVAL
User constant
USER_RESOURCE_ID
USER_NAME
USER_TEMPLATE_RESOURCE_ID
USER_PASSWORD
USER_TIME_REGISTRATION
USER_MAN_HOURS
USER_CALCULATED_MAN_HOURS
USER_PHONE_NUMBER
USER_ACCESS_EXPIRATION
USER_PROTECTED_UNTIL
USER_LANGUAGE
USER_CULTURE
USER_EMAIL
USER_FIRST_NAME
USER_MIDDLE_NAME
USER_LAST_NAME
USER_CURRENCY
USER_DISCOUNT
USER_POINT_BALANCE
USER_TIMEZONE
USER_ADDRESS
USER_CITY
USER_ZIPCODE
USER_REGION
USER_COUNTRY
USER_POSTBOX
USER_WEBSITE
USER_DELETED
USER_DISABLED
USER_MASK
Questionnaire constant
QUESTIONNAIRE_OBJECT_TYPE
QUESTIONNAIRE_RESOURCE_ID
QUESTIONNAIRE_NAME
QUESTIONNAIRE_RESOURCE_TEMPLATE_RESOURCE_ID
QUESTIONNAIRE_PARENT_RESOURCE_ID
QUESTIONNAIRE_TEMPLATE_RESOURCE_ID
QUESTIONNAIRE_TIME_REGISTRATION
QUESTIONNAIRE_COMPLETED
QUESTIONNAIRE_DISPLAY_IN_MY_QUESTIONNAIRE
QUESTIONNAIRE_USE_OLD_VIEWER
QUESTIONNAIRE_ALIAS
QUESTIONNAIRE_LAYOUT_RESOURCE_ID
QUESTIONNAIRE_TIME_ESTIMATE
QUESTIONNAIRE_STATUS
QUESTIONNAIRE_TARGET
QUESTIONNAIRE_CATI_OUTCOME_SET
QUESTIONNAIRE_AUTOMATIC_RELEASE_DATE
QUESTIONNAIRE_DEVELOPMENT_START_DATE
QUESTIONNAIRE_AUTOMATIC_CLOSE_DATE
QUESTIONNAIRE_DEVELOPMENT_END_DATE
QUESTIONNAIRE_MAN_HOURS
QUESTIONNAIRE_DESCRIPTION
QuestionnaireStatus constant
QUESTIONNAIRE_STATUS_CLOSED: 1
QUESTIONNAIRE_STATUS_PAUSED: 2
QUESTIONNAIRE_STATUS_ACTIVE: 3
QUESTIONNAIRE_STATUS_OPEN_FOR_TEST: 4
CATI CGS constant
CATI_OBJECT_TYPE
CATI_CONTACT_ID
CATI_CONTACT_INTERVIEWER_USER_RESOURCE_ID
CATI_CONTACT_START_DATE
CATI_CONTACT_END_DATE
CATI_CONTACT_OUTCOME_STATUS_ID
CATI_CONTACT_OUTCOME_STATUS_AS_TEXT
CATI_CONTACT_DESCRIPTION
CATI list type constant
CATI_MAIN
CATI_ONGOING
CATI_APPOINTMENT
CATI_FINISHED
CATI_RETRY
QAS constant
QAS_OBJECT_TYPE
QAS_ID
QAS_QUESTIONNAIRE_RESOURCE_ID
QAS_USER_RESOURCE_ID
QAS_TEST
QAS_STATUS
QAS_COMPLETED
QAS_STARTDATE
QAS_ENDDATE
QAS_GUID
QAS_CATI_APPOINTMENT
QAS_CATI_LIST_TYPE
QAS_CATI_TIMES_CALLED
Project constant
PROJECT_RESOURCE_ID
PROJECT_NAME
PROJECT_TEMPLATE_RESOURCE_ID
PROJECT_TIME_REGISTRATION
PROJECT_COMPLETED
PROJECT_PARENT_RESOURCE_ID
PROJECT_CODE
PROJECT_PROPOSE_CODE
PROJECT_CLIENT_REF_NO
PROJECT_TIME_BUDGET
PROJECT_CALCULATED_MAN_HOURS
PROJECT_PLANNED_START_DATE
PROJECT_ACTUAL_START_DATE
PROJECT_PLANNED_END_DATE
PROJECT_ACTUAL_END_DATE
Bulk mail constant
BULKMAIL_OBJECT
BULKMAIL_NAME
BULKMAIL_PARENT_RESOURCE_ID
BULKMAIL_MAIL_TEMPLTE_ID
BULKMAIL_TEMPLATE_RESOURCE_ID
Group constant
GROUP_RESOURCE_ID
GROUP_NAME
GROUP_TEMPLATE_RESOURCE_ID
GROUP_PARENT_RESOURCE_ID
GROUP_TIME_REGISTRATION
GROUP_MAN_HOURS
GROUP_CALCULATED_MAN_HOURS
Folder constant
FOLDER_RESOURCE_ID
FOLDER_NAME
FOLDER_PARENT_RESOURCE_ID
FOLDER_TEMPLATE_RESOURCE_ID
FOLDER_TIME_REGISTRATION
FOLDER_TIME_BUDGET
FOLDER_MAN_HOURS
FOLDER_DESCRIPTION
Data cache - custom column constant
CUSTOM_COLUMN_TYPE_NUMBER
CUSTOM_COLUMN_TYPE_BOOLEAN
CUSTOM_COLUMN_TYPE_STRING
CUSTOM_COLUMN_DATA_TYPE
CUSTOM_COLUMN_TEXT
CUSTOM_COLUMN_NAME
CUSTOM_COLUMN_OPTIONS
CUSTOM_COLUMN_OPTION_EXPRESSION
CUSTOM_COLUMN_OPTION_VALUE
CUSTOM_COLUMN_OPTION_TEXT
Ledger entry constant
LEDGER_ENTRY_ID
LEDGER_RESOURCE_ID
LEDGER_ENTRY_NAME
LEDGER_ENTRY_DESCRIPTION
LEDGER_ENTRY_UNIT
LEDGER_ENTRY_COST
LEDGER_ENTRY_CURRENCY_ID
LEDGER_ENTRY_EXCHANGE_RATE
LEDGER_ENTRY_AMOUNT_SELECTED_CURRENCY
LEDGER_ENTRY_AMOUNT_DEFAULT_CURRENCY
Invoice constant
INVOICE_RESOURCE_ID
INVOICE_PART
INVOICE_PARENT_RESOURCE_ID
INVOICE_TEMPLATE_RESOURCE_ID
INVOICE_SUBMITTED
INVOICE_REVENUE_TYPE
INVOICE_CUSTOMER
INVOICE_REPRESENTATIVE
INVOICE_ADDRESS_TO
INVOICE_EARNER
INVOICE_REFERENCE
INVOICE_INVOICE_DATE
INVOICE_DUE_DATE
INVOICE_PAID_DATE
INVOICE_SUBMITTED_DATE
INVOICE_LEDGER
INVOICE_TOTAL
// Address to constant
INVOICE_CUSTOMER
INVOICE_REPRESENTATIVE
Diagrams constants
Diagram_ShowModeType_Percentage
Diagram_ShowModeType_Absolute
Diagram_ShowModeType_Both
Diagram_ChartType_Table
Diagram_ChartType_Line
Diagram_ChartType_Bar
Diagram_ChartType_Pie
Diagram_ChartType_Radar
// Direction Type
Diagram_DirectionType_Vertical
Diagram_DirectionType_Horizontal
// Back Plane Style
Diagram_BackPlaneStyle_Rectangle
Diagram_BackPlaneStyle_Ellipse
Diagram_BackPlaneStyle_Circle
Diagram_BackPlaneStyle_CutEdgeRectangle
Diagram_BackPlaneStyle_SmoothEdgeRectangle
Diagram_BackPlaneStyle_NotSet
// Fill Type
Diagram_FillType_NoFill
Diagram_FillType_SolidFill
// HAlignment
Diagram_HAlignment_Center
Diagram_HAlignment_Left
Diagram_HAlignment_Right
Diagram_HAlignment_NotSet
// VAlignment
Diagram_VAlignment_Center
Diagram_VAlignment_Top
Diagram_VAlignment_Bottom
Diagram_VAlignment_NotSet
// Visibility
Diagram_Visibility_True
Diagram_Visibility_Visible
Diagram_Visibility_NotVisible
Diagram_Visibility_False
Diagram_Visibility_NotSet
// Fill constant
DIAGRAM_FILL_STYLE_COLOR
DIAGRAM_FILL_STYLE_TYPE
DIAGRAM_FILL_STYLE_INHERIT
// Font constant
DIAGRAM_FONT_STYLE_FACE
DIAGRAM_FONT_STYLE_SIZE
DIAGRAM_FONT_STYLE_COLOR
DIAGRAM_FONT_STYLE_BOLD
DIAGRAM_FONT_STYLE_ITALIC
DIAGRAM_FONT_STYLE_UNDERLINE
DIAGRAM_FONT_STYLE_INHERIT
Diagrams Known Color constants
Diagram_KnownColor_ActiveBorder
Diagram_KnownColor_ActiveCaption
Diagram_KnownColor_ActiveCaptionText
Diagram_KnownColor_AppWorkspace
Diagram_KnownColor_Control
Diagram_KnownColor_ControlDark
Diagram_KnownColor_ControlDarkDark
Diagram_KnownColor_ControlLight
Diagram_KnownColor_ControlLightLight
Diagram_KnownColor_ControlText
Diagram_KnownColor_Desktop
Diagram_KnownColor_GrayText
Diagram_KnownColor_Highlight
Diagram_KnownColor_HighlightText
Diagram_KnownColor_HotTrack
Diagram_KnownColor_InactiveBorder
Diagram_KnownColor_InactiveCaption
Diagram_KnownColor_InactiveCaptionText
Diagram_KnownColor_Info
Diagram_KnownColor_InfoText
Diagram_KnownColor_Menu
Diagram_KnownColor_MenuText
Diagram_KnownColor_ScrollBar
Diagram_KnownColor_Window
Diagram_KnownColor_WindowFrame
Diagram_KnownColor_WindowText
Diagram_KnownColor_Transparent
Diagram_KnownColor_AliceBlue
Diagram_KnownColor_AntiqueWhite
Diagram_KnownColor_Aqua
Diagram_KnownColor_Aquamarine
Diagram_KnownColor_Azure
Diagram_KnownColor_Beige
Diagram_KnownColor_Bisque
Diagram_KnownColor_Black
Diagram_KnownColor_BlanchedAlmond
Diagram_KnownColor_Blue
Diagram_KnownColor_BlueViolet
Diagram_KnownColor_Brown
Diagram_KnownColor_BurlyWood
Diagram_KnownColor_CadetBlue
Diagram_KnownColor_Chartreuse
Diagram_KnownColor_Chocolate
Diagram_KnownColor_Coral
Diagram_KnownColor_CornflowerBlue
Diagram_KnownColor_Cornsilk
Diagram_KnownColor_Crimson
Diagram_KnownColor_Cyan
Diagram_KnownColor_DarkBlue
Diagram_KnownColor_DarkCyan
Diagram_KnownColor_DarkGoldenrod
Diagram_KnownColor_DarkGray
Diagram_KnownColor_DarkGreen
Diagram_KnownColor_DarkKhaki
Diagram_KnownColor_DarkMagenta
Diagram_KnownColor_DarkOliveGreen
Diagram_KnownColor_DarkOrange
Diagram_KnownColor_DarkOrchid
Diagram_KnownColor_DarkRed
Diagram_KnownColor_DarkSalmon
Diagram_KnownColor_DarkSeaGreen
Diagram_KnownColor_DarkSlateBlue
Diagram_KnownColor_DarkSlateGray
Diagram_KnownColor_DarkTurquoise
Diagram_KnownColor_DarkViolet
Diagram_KnownColor_DeepPink
Diagram_KnownColor_DeepSkyBlue
Diagram_KnownColor_DimGray
Diagram_KnownColor_DodgerBlue
Diagram_KnownColor_Firebrick
Diagram_KnownColor_FloralWhite
Diagram_KnownColor_ForestGreen
Diagram_KnownColor_Fuchsia
Diagram_KnownColor_Gainsboro
Diagram_KnownColor_GhostWhite
Diagram_KnownColor_Gold
Diagram_KnownColor_Goldenrod
Diagram_KnownColor_Gray
Diagram_KnownColor_Green
Diagram_KnownColor_GreenYellow
Diagram_KnownColor_Honeydew
Diagram_KnownColor_HotPink
Diagram_KnownColor_IndianRed
Diagram_KnownColor_Indigo
Diagram_KnownColor_Ivory
Diagram_KnownColor_Khaki
Diagram_KnownColor_Lavender
Diagram_KnownColor_LavenderBlush
Diagram_KnownColor_LawnGreen
Diagram_KnownColor_LemonChiffon
Diagram_KnownColor_LightBlue
Diagram_KnownColor_LightCoral
Diagram_KnownColor_LightCyan
Diagram_KnownColor_LightGoldenrodYellow
Diagram_KnownColor_LightGray
Diagram_KnownColor_LightGreen
Diagram_KnownColor_LightPink
Diagram_KnownColor_LightSalmon
Diagram_KnownColor_LightSeaGreen
Diagram_KnownColor_LightSkyBlue
Diagram_KnownColor_LightSlateGray
Diagram_KnownColor_LightSteelBlue
Diagram_KnownColor_LightYellow
Diagram_KnownColor_Lime
Diagram_KnownColor_LimeGreen
Diagram_KnownColor_Linen
Diagram_KnownColor_Magenta
Diagram_KnownColor_Maroon
Diagram_KnownColor_MediumAquamarine
Diagram_KnownColor_MediumBlue
Diagram_KnownColor_MediumOrchid
Diagram_KnownColor_MediumPurple
Diagram_KnownColor_MediumSeaGreen
Diagram_KnownColor_MediumSlateBlue
Diagram_KnownColor_MediumSpringGreen
Diagram_KnownColor_MediumTurquoise
Diagram_KnownColor_MediumVioletRed
Diagram_KnownColor_MidnightBlue
Diagram_KnownColor_MintCream
Diagram_KnownColor_MistyRose
Diagram_KnownColor_Moccasin
Diagram_KnownColor_NavajoWhite
Diagram_KnownColor_Navy
Diagram_KnownColor_OldLace
Diagram_KnownColor_Olive
Diagram_KnownColor_OliveDrab
Diagram_KnownColor_Orange
Diagram_KnownColor_OrangeRed
Diagram_KnownColor_Orchid
Diagram_KnownColor_PaleGoldenrod
Diagram_KnownColor_PaleGreen
Diagram_KnownColor_PaleTurquoise
Diagram_KnownColor_PaleVioletRed
Diagram_KnownColor_PapayaWhip
Diagram_KnownColor_PeachPuff
Diagram_KnownColor_Peru
Diagram_KnownColor_Pink
Diagram_KnownColor_Plum
Diagram_KnownColor_PowderBlue
Diagram_KnownColor_Purple
Diagram_KnownColor_Red
Diagram_KnownColor_RosyBrown
Diagram_KnownColor_RoyalBlue
Diagram_KnownColor_SaddleBrown
Diagram_KnownColor_Salmon
Diagram_KnownColor_SandyBrown
Diagram_KnownColor_SeaGreen
Diagram_KnownColor_SeaShell
Diagram_KnownColor_Sienna
Diagram_KnownColor_Silver
Diagram_KnownColor_SkyBlue
Diagram_KnownColor_SlateBlue
Diagram_KnownColor_SlateGray
Diagram_KnownColor_Snow
Diagram_KnownColor_SpringGreen
Diagram_KnownColor_SteelBlue
Diagram_KnownColor_Tan
Diagram_KnownColor_Teal
Diagram_KnownColor_Thistle
Diagram_KnownColor_Tomato
Diagram_KnownColor_Turquoise
Diagram_KnownColor_Violet
Diagram_KnownColor_Wheat
Diagram_KnownColor_White
Diagram_KnownColor_WhiteSmoke
Diagram_KnownColor_Yellow
Diagram_KnownColor_YellowGreen
Diagram_KnownColor_ButtonFace
Diagram_KnownColor_ButtonHighlight
Diagram_KnownColor_ButtonShadow
Diagram_KnownColor_GradientActiveCaption
Diagram_KnownColor_GradientInactiveCaption
Diagram_KnownColor_MenuBar
Diagram_KnownColor_MenuHighlight
Table Diagram constants
TableDiagram_AllTable
TableDiagram_ColumnHeader
TableDiagram_ColumnHeaderLevel1
TableDiagram_ColumnHeaderLevel2
TableDiagram_ColumnHeaderLevel3
TableDiagram_RowHeader
TableDiagram_RowHeaderLevel1
TableDiagram_RowHeaderLevel2
TableDiagram_RowHeaderLevel3
TableDiagram_AbsoluteColumn
TableDiagram_AbsoluteColumnHeader
TableDiagram_AbsoluteColumnValue
TableDiagram_PercentageColumn
TableDiagram_PercentageColumnHeader
TableDiagram_PercentageColumnValue
TableDiagram_TotalColumn
TableDiagram_TotalColumnHeader
TableDiagram_TotalColumnValue
TableDiagram_TotalRow
TableDiagram_TotalRowHeader
TableDiagram_TotalRowValue
TableDiagram_AnswerRow
TableDiagram_AnswerRowAlternate
TableDiagram_VarianceRow
TableDiagram_VarianceRowHeader
TableDiagram_VarianceRowValue
TableDiagram_AverageRow
TableDiagram_AverageRowHeader
TableDiagram_AverageRowValue
TableDiagram_StdDevRow
TableDiagram_StdDevRowHeader
TableDiagram_StdDevRowValue
TableDiagram_StdErrorRow
TableDiagram_StdErrorRowHeader
TableDiagram_StdErrorRowValue
TableDiagram_MedianRow
TableDiagram_MedianRowHeader
TableDiagram_MedianRowValue
TableDiagram_QuantilesRow
TableDiagram_QuantilesRowHeader
TableDiagram_QuantilesRowValue
TableDiagram_PercentileRow
TableDiagram_PercentileRowHeader
TableDiagram_PercentileRowValue
TableDiagram_SignificanceRow
TableDiagram_SignificanceRowHeader
TableDiagram_SignificanceRowValue
TableDiagram_CountAnswerRow
TableDiagram_CountAnswerRowHeader
TableDiagram_CountAnswerRowValue
TableDiagram_TotalRespondentRow
TableDiagram_TotalRespondentRowHeader
TableDiagram_TotalRespondentRowValue
TableDiagram_WeightRow
TableDiagram_WeightRowHeader
TableDiagram_WeightRowValue
TableDiagram_QuestionHeader
Table Diagram style constants
TABLE_DIAGRAM_STYLE_FILL,
TABLE_DIAGRAM_STYLE_DECIMAL
TABLE_DIAGRAM_STYLE_FONT
TABLE_DIAGRAM_STYLE_VALIGN
TABLE_DIAGRAM_STYLE_HALIGN
TABLE_DIAGRAM_STYLE_NUMBER_FORMATTER
TABLE_DIAGRAM_STYLE_PERCENT_FORMATTER
TABLE_DIAGRAM_STYLE_SIGNIFICANCE_FORMATTER
TABLE_DIAGRAM_STYLE_BORDER_STYLE
Back to DATA page
