The system object Account tables include:
•WH_ACCOUNT
•WH_ACCOUNT_CATEGORIES
•WH_ACCOUNT_TRANSACTIONS
•WH_ACCOUNT_GROUP_ACCESS*
•WH_ACCOUNT_USER_ACCESS*
•WH_ACCOUNT_SECURITY
•WH_ACCOUNT_WORKFLOW
•WH_ACCOUNT_WORKFLOW_HISTORY
•WH_ACCOUNT_WORKFLOW_RECIPIENT
•WH_ACCOUNT_WORKFLOW_REVIEW
* These tables support the user access and security feature and should not be queried directly.
WH_ACCOUNT
Column Name |
Oracle Data Type |
MSSQL Data Type |
ACCOUNT_ALLOCATION_LIMIT |
NUMBER |
DECIMAL(28, 12) |
ACCOUNT_ALLOW_POSTING |
VARCHAR2(20) |
VARCHAR(20) |
ACCOUNT_BALANCE |
NUMBER |
DECIMAL(28, 12) |
ACCOUNT_DEFAULT_CATEGORY |
VARCHAR2(50) |
VARCHAR(50) |
ACCOUNT_DEFAULT_CATEGORY_TREE |
VARCHAR2(250) |
VARCHAR(250) |
ACCOUNT_NAME |
VARCHAR2(250) |
VARCHAR(250) |
ACCOUNT_NONUS_TAX |
NUMBER |
DECIMAL(28, 12) |
ACCOUNT_NONUS_TAX_TYPE |
VARCHAR2(50) |
VARCHAR(50) |
ACCOUNT_NONUS_TAX_PCT |
NUMBER |
DECIMAL(28, 12) |
ACCOUNT_OVERDRAFT_TYPE |
VARCHAR2(40) |
VARCHAR(40) |
ACCOUNT_PERIOD_END_ON_DATE |
DATE |
DATETIME |
ACCOUNT_PERIOD_START_ON_DATE |
DATE |
DATETIME |
ACCOUNT_PRIMARY_KEY |
NUMBER |
INT |
ACCOUNT_STATUS |
VARCHAR2(20) |
VARCHAR(20) |
ACCOUNT_TOTAL_ACCRUAL |
NUMBER |
DECIMAL(28, 12) |
ACCOUNT_TOTAL_ALLOCATED |
NUMBER |
DECIMAL(28, 12) |
ACCOUNT_TOTAL_USED |
NUMBER |
DECIMAL(28, 12) |
ACCOUNT_TREE_KEY |
VARCHAR2(700) |
VARCHAR(700) |
ACCOUNT_TYPE |
VARCHAR2(20) |
VARCHAR(20) |
CREATED_BY_CONTACT_FIRST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
CREATED_BY_CONTACT_MIDDLE_NAME |
VARCHAR2(50) |
VARCHAR(50) |
CREATED_BY_CONTACT_NAME |
VARCHAR2(250) |
VARCHAR(250) |
CREATED_BY_CONTACT_PK |
NUMBER |
INT |
CREATED_BY_CONTACT_TYPE |
VARCHAR2(10) |
VARCHAR(10) |
CREATED_ON |
DATE |
DATETIME |
DOCUMENT_FOLDER_PRIMARY_KEY |
NUMBER |
INT |
MODIFIED_BY_CONTACT_FIRST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
MODIFIED_BY_CONTACT_MID_NAME |
VARCHAR2(50) |
VARCHAR(50) |
MODIFIED_BY_CONTACT_NAME |
VARCHAR2(250) |
VARCHAR(250) |
MODIFIED_BY_CONTACT_PK |
NUMBER |
INT |
MODIFIED_BY_CONTACT_TYPE |
VARCHAR2(10) |
VARCHAR(10) |
BEHALF_OF_CONTACT_PRIMARY_KEY |
NUMBER |
INT |
MODIFIED_ON |
DATE |
DATETIME |
PARENT_ACCOUNT_NAME |
VARCHAR2(250) |
VARCHAR(250) |
PARENT_ACCOUNT_PRIMARY_KEY |
NUMBER |
INT |
POST_ACCOUNT_TO_INVOLVED |
VARCHAR2(20) |
VARCHAR(20) |
POST_ACCOUNT_TO_VENDOR |
VARCHAR2(20) |
VARCHAR(20) |
POST_EXPENSES_OF_CATEGORY |
VARCHAR2(50) |
VARCHAR(50) |
POST_EXPENSES_TO_THIS_ACCOUNT |
VARCHAR2(20) |
VARCHAR(20) |
POST_INVOICE_EXPENSE_OF_TYPE |
VARCHAR2(50) |
VARCHAR(50) |
POST_INVOICE_EXPENSES_TO_THIS |
VARCHAR2(20) |
VARCHAR(20) |
POST_INVOICE_TASK_OF_TYPE |
VARCHAR2(50) |
VARCHAR(50) |
POST_INVOICE_TASKS_TO_THIS |
VARCHAR2(20) |
VARCHAR(20) |
POST_PROJECT_TO_THIS_ACCOUNT |
VARCHAR2(20) |
VARCHAR(20) |
POST_TASKS_OF_TYPE |
VARCHAR2(50) |
VARCHAR(50) |
POST_TASKS_TO_THIS_ACCOUNT |
VARCHAR2(20) |
VARCHAR(20) |
POSTED_EXPENSE_PERCENT |
NUMBER |
DECIMAL(28, 12) |
POSTED_TASK_PERCENT |
NUMBER |
DECIMAL(28, 12) |
POSTING_INVC_ACCRUAL |
VARCHAR2(10) |
VARCHAR(10) |
POSTING_INVC_CREDIT_NOTE |
VARCHAR2(10) |
VARCHAR(10) |
POSTING_INVC_STANDARD |
VARCHAR2(10) |
VARCHAR(10) |
POSTING_INVOICE_EXPENSE_PERCNT |
NUMBER |
DECIMAL(28, 12) |
POSTING_INVOICE_TASK_PERCENT |
NUMBER |
DECIMAL(28, 12) |
POSTING_INVOLVED_CONTACT_FIRST |
VARCHAR2(50) |
VARCHAR(50) |
POSTING_INVOLVED_CONTACT_MIDDL |
VARCHAR2(50) |
VARCHAR(50) |
POSTING_INVOLVED_CONTACT_NAME |
VARCHAR2(250) |
VARCHAR(250) |
POSTING_INVOLVED_CONTACT_PK |
NUMBER |
INT |
POSTING_INVOLVED_CONTACT_TYPE |
VARCHAR2(10) |
VARCHAR(10) |
POSTING_PROJECT_CATEGORY_NAME |
VARCHAR2(50) |
VARCHAR(50) |
POSTING_PROJECT_CATEGORY_TREE |
VARCHAR2(250) |
VARCHAR(250) |
POSTING_PROJECT_NAME |
VARCHAR2(250) |
VARCHAR(250) |
POSTING_PROJECT_NUMBER |
VARCHAR2(50) |
VARCHAR(50) |
POSTING_PROJECT_OBJECT_TITLE |
VARCHAR2(250) |
VARCHAR(250) |
POSTING_PROJECT_PRIMARY_KEY |
NUMBER |
INT |
POSTING_PROJECT_UNIQUE_CODE |
VARCHAR2(4) |
VARCHAR(4) |
POSTING_VENDOR_CONTACT_FIRST |
VARCHAR2(50) |
VARCHAR(50) |
POSTING_VENDOR_CONTACT_MIDDLE |
VARCHAR2(50) |
VARCHAR(50) |
POSTING_VENDOR_CONTACT_NAME |
VARCHAR2(250) |
VARCHAR(250) |
POSTING_VENDOR_CONTACT_PK |
NUMBER |
INT |
POSTING_VENDOR_CONTACT_TYPE |
VARCHAR2(10) |
VARCHAR(10) |
SECURITY |
VARCHAR2(10) |
VARCHAR(10) |
WORKFLOW_CURRENT_STATUS |
VARCHAR2(15) |
VARCHAR(15) |
WORKFLOW_CURRENT_ACTION |
VARCHAR2(50) |
VARCHAR(50) |
NOTES |
CLOB |
NTEXT |
CURRENT_APPROVER_CONTACT_PK |
NUMBER |
INT |
CURRENT_APPROVER_NAME |
VARCHAR2(250) |
VARCHAR(250) |
CURRENT_APPROVER_FIRST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
CURRENT_APPROVER_MIDDLE_NAME |
VARCHAR2(50) |
VARCHAR(50) |
CURRENT_APPROVER_TYPE |
VARCHAR2(7) |
VARCHAR(7) |
LAST_PERFRMR_CONTACT_PK |
NUMBER |
INT |
LAST_PERFRMR_NAME |
VARCHAR2(250) |
VARCHAR(250) |
LAST_PERFRMR_FIRST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
LAST_PERFRMR_MIDDLE_NAME |
VARCHAR2(50) |
VARCHAR(50) |
LAST_PERFRMR_TYPE |
VARCHAR2(7) |
VARCHAR(7) |
MULTIPLE_APPROVERS |
VARCHAR2(3) |
VARCHAR(3) |
ACCOUNT_PERIOD_START_ON_DT_KEY |
DATE |
DATETIME |
ACCOUNT_PERIOD_END_ON_DATE_KEY |
DATE |
DATETIME |
CREATED_ON_DATE_KEY |
DATE |
DATETIME |
MODIFIED_ON_DATE_KEY |
DATE |
DATETIME |
ACCOUNT_TOTAL_MATTER_FEE_TAX |
NVARCHAR2(3) |
NVARCHAR(3) |
ACCOUNT_TOTAL_MATTER_EXP_TAX |
NVARCHAR2(3) |
NVARCHAR(3) |
WH_ACCOUNT_CATEGORIES
Column Name |
Oracle Data Type |
MSSQL Data Type |
ACCOUNT_PRIMARY_KEY |
NUMBER |
INT |
ACCOUNT_NAME |
VARCHAR2(250) |
VARCHAR(250) |
ACCOUNT_TYPE |
VARCHAR2(20) |
VARCHAR(20) |
ACCOUNT_OVERDRAFT_TYPE |
VARCHAR2(40) |
VARCHAR(40) |
ACCOUNT_PERIOD_START_ON_DATE |
DATE |
DATETIME |
ACCOUNT_PERIOD_END_ON_DATE |
DATE |
DATETIME |
ACCOUNT_STATUS |
VARCHAR2(20) |
VARCHAR(20) |
ACCOUNT_ALLOW_POSTING |
VARCHAR2(20) |
VARCHAR(20) |
ACCOUNT_ALLOCATION_LIMIT |
NUMBER |
DECIMAL(28,12) |
ACCOUNT_TOTAL_ALLOCATED |
NUMBER |
DECIMAL(28,12) |
ACCOUNT_TOTAL_USED |
NUMBER |
DECIMAL(28,12) |
ACCOUNT_BALANCE |
NUMBER |
DECIMAL(28,12) |
PARENT_ACCOUNT_PRIMARY_KEY |
NUMBER |
INT |
PARENT_ACCOUNT_NAME |
VARCHAR2(250) |
VARCHAR(250) |
CATEGORY_NAME |
VARCHAR2(50) |
VARCHAR(50) |
CATEGORY_TREE_POSITION |
VARCHAR2(250) |
VARCHAR(250) |
IS_CATEGORY_MANUALLY_ADDED |
VARCHAR2(1) |
VARCHAR(1) |
IS_DEFAULT_CATEGORY |
VARCHAR2(5) |
VARCHAR(5) |
SECURITY |
VARCHAR2(10) |
VARCHAR(10) |
WH_ACCOUNT_TRANSACTIONS
Column Name |
Oracle Data Type |
MSSQL Data Type |
ACCOUNT_PRIMARY_KEY |
NUMBER |
INT |
ACCOUNT_NAME |
VARCHAR2(250) |
VARCHAR(250) |
ACCOUNT_TYPE |
VARCHAR2(20) |
VARCHAR(20) |
ACCOUNT_OVERDRAFT_TYPE |
VARCHAR2(40) |
VARCHAR(40) |
ACCOUNT_PERIOD_START_ON_DATE |
DATE |
DATETIME |
ACCOUNT_PERIOD_END_ON_DATE |
DATE |
DATETIME |
ACCOUNT_STATUS |
VARCHAR2(20) |
VARCHAR(20) |
ACCOUNT_ALLOW_POSTING |
VARCHAR2(20) |
VARCHAR(20) |
ACCOUNT_ALLOCATION_LIMIT |
NUMBER |
DECIMAL(28,12) |
ACCOUNT_TOTAL_ALLOCATED |
NUMBER |
DECIMAL(28,12) |
ACCOUNT_TOTAL_USED |
NUMBER |
DECIMAL(28,12) |
ACCOUNT_BALANCE |
NUMBER |
DECIMAL(28,12) |
ACCOUNT_DEFAULT_CATEGORY |
VARCHAR2(50) |
VARCHAR(50) |
ACCOUNT_DEFAULT_CATEGORY_TREE |
VARCHAR2(250) |
VARCHAR(250) |
TRANSACTION_PRIMARY_KEY |
NUMBER |
INT |
TRANSACTION_DATE |
DATE |
DATETIME |
TRANSACTION_DESCRIPTION |
VARCHAR2(250) |
VARCHAR(250) |
TRANSACTION_TOTAL_AMOUNT |
NUMBER |
DECIMAL(28,12) |
DETAIL_PRIMARY_KEY |
NUMBER |
INT |
DETAIL_TOTAL_AMOUNT |
NUMBER |
DECIMAL(28,12) |
DETAIL_DESCRIPTION |
VARCHAR2(250) |
VARCHAR(250) |
DETAIL_STATUS |
VARCHAR2(20) |
VARCHAR(20) |
TRANSACTION_CREATED_ON |
DATE |
DATETIME |
TRANSACTION_MODIFIED_ON |
DATE |
DATETIME |
CREATED_BY_CONTACT_PK |
NUMBER |
INT |
CREATED_BY_CONTACT_TYPE |
VARCHAR2(10) |
VARCHAR(10) |
CREATED_BY_CONTACT_NAME |
VARCHAR2(250) |
VARCHAR(250) |
CREATED_BY_CONTACT_MIDDLE_NAME |
VARCHAR2(50) |
VARCHAR(50) |
CREATED_BY_CONTACT_FIRST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
MODIFIED_BY_CONTACT_PK |
NUMBER |
INT |
MODIFIED_BY_CONTACT_TYPE |
VARCHAR2(10) |
VARCHAR(10) |
MODIFIED_BY_CONTACT_NAME |
VARCHAR2(250) |
VARCHAR(250) |
MODIFIED_BY_CONTACT_MID_NAME |
VARCHAR2(50) |
VARCHAR(50) |
MODIFIED_BY_CONTACT_FIRST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
EXPENSE_PRIMARY_KEY |
NUMBER |
INT |
EXPENSE_DESCRIPTION |
VARCHAR2(250) |
VARCHAR(250) |
EXPENSE_DATE |
DATE |
DATETIME |
TASK_PRIMARY_KEY |
NUMBER |
INT |
TASK_SUBJECT |
VARCHAR2(250) |
VARCHAR(250) |
TASK_COMPLETED_ON |
DATE |
DATETIME |
INVOICE_PRIMARY_KEY |
NUMBER |
INT |
INVOICE_NUMBER |
VARCHAR2(50) |
VARCHAR(50) |
INVOICE_DATE |
DATE |
DATETIME |
TRANSFERED_ACCOUNT_PRIMARY_KEY |
NUMBER |
INT |
TRANSFERRED_ACCOUNT_NAME |
VARCHAR2(250) |
VARCHAR(250) |
TRANSFERRED_ACCOUNT_TYPE |
VARCHAR2(20) |
VARCHAR(20) |
WITHDRAWAL |
VARCHAR2(1) |
VARCHAR(1) |
SECURITY |
VARCHAR2(10) |
VARCHAR(10) |
WH_ACCOUNT_GROUP_ACCESS
Column Name |
Oracle Data Type |
MSSQL Data Type |
ACCOUNT_PRIMARY_KEY |
NUMBER |
INT |
GROUP_PRIMARY_KEY |
NUMBER |
INT |
ALLOW_DENY_IID |
CHAR(1) |
CHAR(1) |
OPERATION_IID |
NUMBER |
INT |
IS_MANUAL |
NUMBER |
INT |
VERSION |
NUMBER |
INT |
WH_ACCOUNT_USER_ACCESS
Column Name |
Oracle Data Type |
MSSQL Data Type |
ACCOUNT_PRIMARY_KEY |
NUMBER |
INT |
USER_PRIMARY_KEY |
NUMBER |
INT |
ALLOW_DENY_IID |
CHAR(1) |
CHAR(1) |
OPERATION_IID |
NUMBER |
INT |
IS_MANUAL |
NUMBER |
INT |
VERSION |
NUMBER |
INT |
WH_ACCOUNT_SECURITY
Column Name |
Oracle Data Type |
MSSQL Data Type |
ACCOUNT_PRIMARY_KEY |
NUMBER |
INT |
CREATED_BY_CONTACT_PK |
NUMBER |
INT |
SECURITY |
NVARCHAR2(10) |
NVARCHAR(10) |
WH_ACCOUNT_WORKFLOW
Column Name |
Oracle Data Type |
MSSQL Data Type |
ACCOUNT_PRIMARY_KEY |
NUMBER |
INT |
ACCOUNT_NAME |
VARCHAR2(250) |
VARCHAR(250) |
ACCOUNT_TYPE |
VARCHAR2(7) |
VARCHAR(7) |
ACCOUNT_OVERDRAFT_TYPE |
VARCHAR2(30) |
VARCHAR(30) |
ACCOUNT_PERIOD_START_ON_DATE |
DATE |
DATETIME |
ACCOUNT_PERIOD_END_ON_DATE |
DATE |
DATETIME |
ACCOUNT_STATUS |
VARCHAR2(8) |
VARCHAR(8) |
ACCOUNT_ALLOW_POSTING |
VARCHAR2(1) |
VARCHAR(1) |
ACCOUNT_ALLOCATION_LIMIT |
NUMBER |
DECIMAL(28,12) |
ACCOUNT_TOTAL_ALLOCATED |
NUMBER |
DECIMAL(28,12) |
ACCOUNT_TOTAL_USED |
NUMBER |
DECIMAL(28,12) |
ACCOUNT_BALANCE |
NUMBER |
DECIMAL(28,12) |
PARENT_ACCOUNT_PRIMARY_KEY |
NUMBER |
INT |
PARENT_ACCOUNT_NAME |
VARCHAR2(250) |
VARCHAR(250) |
WORKFLOW_PRIMARY_KEY |
NUMBER |
INT |
REQUEST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
REQUESTED_BY_CONTACT_PK |
NUMBER |
INT |
REQUESTED_BY_CONTACT_TYPE |
VARCHAR2(7) |
VARCHAR(7) |
REQUESTED_BY_FIRST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
REQUESTED_BY_MIDDLE_NAME |
VARCHAR2(50) |
VARCHAR(50) |
REQUESTED_BY_NAME |
VARCHAR2(250) |
VARCHAR(250) |
REQUESTED_ON |
DATE |
DATETIME |
COMPLETED_ON |
DATE |
DATETIME |
WORKFLOW_STATUS |
VARCHAR2(30) |
VARCHAR(30) |
COMMENT_TO_REQUESTOR |
VARCHAR2(2000) |
VARCHAR(2000) |
EXPIRES_ON |
DATE |
DATETIME |
EXPIRE_ACTION |
VARCHAR2(30) |
VARCHAR(30) |
TRANSACTION_STATUS |
VARCHAR2(250) |
VARCHAR(250) |
CURRENT_STOP_NO |
NUMBER |
INT |
REJECT_ACTION |
VARCHAR2(30) |
VARCHAR(30) |
REJECT_REASON |
VARCHAR2(50) |
VARCHAR(50) |
UPDATE_WHILE_PENDING |
VARCHAR(105) |
VARCHAR(105) |
PROCESS_MANAGER_CONTACT_PK |
NUMBER |
INT |
PROCESS_MANAGER_CONTACT_TYPE |
VARCHAR2(7) |
VARCHAR(7) |
PROCESS_MANAGER_FIRST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
PROCESS_MANAGER_MIDDLE_NAME |
VARCHAR2(50) |
VARCHAR(50) |
PROCESS_MANAGER_NAME |
VARCHAR2(250) |
VARCHAR(250) |
STOP_MEMBER_PRIMARY_KEY |
NUMBER |
INT |
STOP_PRIMARY_KEY |
NUMBER |
INT |
STOP |
NUMBER |
INT |
PERFORMER_CONTACT_PK |
NUMBER |
INT |
PERFORMER_CONTACT_TYPE |
VARCHAR2(7) |
VARCHAR(7) |
PERFORMER_FIRST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
PERFORMER_MIDDLE_NAME |
VARCHAR2(50) |
VARCHAR(50) |
PERFORMER_NAME |
VARCHAR2(250) |
VARCHAR(250) |
STOP_STATUS |
VARCHAR2(40) |
VARCHAR(40) |
ACTION_DATE |
DATE |
DATETIME |
STOP_EXPIRATION_DATE |
DATE |
DATETIME |
INTERNAL_COMMENT |
VARCHAR2(2000) |
VARCHAR(2000) |
EMAIL_SENT |
VARCHAR2(3) |
VARCHAR(3) |
CREATED_BY_CONTACT_PK |
NUMBER |
INT |
CREATED_BY_CONTACT_TYPE |
VARCHAR2(7) |
VARCHAR(7) |
CREATED_BY_CONTACT_NAME |
VARCHAR2(250) |
VARCHAR(250) |
CREATED_BY_CONTACT_MIDDLE_NAME |
VARCHAR2(50) |
VARCHAR(50) |
CREATED_BY_CONTACT_FIRST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
CREATED_ON |
DATE |
DATETIME |
MODIFIED_BY_CONTACT_PK |
NUMBER |
INT |
MODIFIED_BY_CONTACT_NAME |
VARCHAR2(250) |
VARCHAR(250) |
MODIFIED_BY_CONTACT_MID_NAME |
VARCHAR2(50) |
VARCHAR(50) |
MODIFIED_BY_CONTACT_FIRST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
MODIFIED_BY_CONTACT_TYPE |
VARCHAR2(7) |
VARCHAR(7) |
MODIFIED_ON |
DATE |
DATETIME |
WH_ACCOUNT_WORKFLOW_HISTORY
Column Name |
Oracle Data Type |
MSSQL Data Type |
ACCOUNT_PRIMARY_KEY |
NUMBER |
INT |
ACCOUNT_NAME |
VARCHAR2(250) |
VARCHAR(250) |
ACCOUNT_TYPE |
VARCHAR2(7) |
VARCHAR(7) |
ACCOUNT_OVERDRAFT_TYPE |
VARCHAR2(30) |
VARCHAR(30) |
ACCOUNT_PERIOD_START_ON_DATE |
DATE |
DATETIME |
ACCOUNT_PERIOD_END_ON_DATE |
DATE |
DATETIME |
ACCOUNT_STATUS |
VARCHAR2(8) |
VARCHAR(8) |
ACCOUNT_ALLOW_POSTING |
VARCHAR2(1) |
VARCHAR(1) |
ACCOUNT_ALLOCATION_LIMIT |
NUMBER |
DECIMAL(28,12) |
ACCOUNT_TOTAL_ALLOCATED |
NUMBER |
DECIMAL(28,12) |
ACCOUNT_TOTAL_USED |
NUMBER |
DECIMAL(28,12) |
ACCOUNT_BALANCE |
NUMBER |
DECIMAL(28,12) |
PARENT_ACCOUNT_PRIMARY_KEY |
NUMBER |
INT |
PARENT_ACCOUNT_NAME |
VARCHAR2(250) |
VARCHAR(250) |
WORKFLOW_PRIMARY_KEY |
NUMBER |
INT |
REQUEST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
REQUESTED_BY_CONTACT_PK |
NUMBER |
INT |
REQUESTED_BY_CONTACT_TYPE |
VARCHAR2(7) |
VARCHAR(7) |
REQUESTED_BY_FIRST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
REQUESTED_BY_MIDDLE_NAME |
VARCHAR2(50) |
VARCHAR(50) |
REQUESTED_BY_NAME |
VARCHAR2(250) |
VARCHAR(250) |
REQUESTED_ON |
DATE |
DATETIME |
COMPLETED_ON |
DATE |
DATETIME |
WORKFLOW_STATUS |
VARCHAR2(30) |
VARCHAR(30) |
COMMENT_TO_REQUESTOR |
VARCHAR2(2000) |
VARCHAR(2000) |
EXPIRES_ON |
DATE |
DATETIME |
EXPIRE_ACTION |
VARCHAR2(30) |
VARCHAR(30) |
TRANSACTION_STATUS |
VARCHAR2(250) |
VARCHAR(250) |
CURRENT_STOP_NO |
NUMBER |
INT |
REJECT_ACTION |
VARCHAR2(30) |
VARCHAR(30) |
REJECT_REASON |
VARCHAR2(50) |
VARCHAR(50) |
UPDATE_WHILE_PENDING |
VARCHAR2(105) |
VARCHAR(105) |
PROCESS_MANAGER_CONTACT_PK |
NUMBER |
INT |
PROCESS_MANAGER_CONTACT_TYPE |
VARCHAR2(7) |
VARCHAR(7) |
PROCESS_MANAGER_FIRST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
PROCESS_MANAGER_MIDDLE_NAME |
VARCHAR2(50) |
VARCHAR(50) |
PROCESS_MANAGER_NAME |
VARCHAR2(250) |
VARCHAR(250) |
STOP |
NUMBER |
INT |
PERFORMER_CONTACT_PK |
NUMBER |
INT |
PERFORMER_CONTACT_TYPE |
VARCHAR2(7) |
VARCHAR(7) |
PERFORMER_FIRST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
PERFORMER_MIDDLE_NAME |
VARCHAR2(50) |
VARCHAR(50) |
PERFORMER_NAME |
VARCHAR2(250) |
VARCHAR(250) |
ACTIVITY |
VARCHAR2(250) |
VARCHAR(250) |
ACTION_DATE |
DATE |
DATETIME |
INTERNAL_COMMENT |
VARCHAR2(2000) |
VARCHAR(2000) |
CREATED_BY_CONTACT_PK |
NUMBER |
INT |
CREATED_BY_CONTACT_TYPE |
VARCHAR2(7) |
VARCHAR(7) |
CREATED_BY_CONTACT_NAME |
VARCHAR2(250) |
VARCHAR(250) |
CREATED_BY_CONTACT_MIDDLE_NAME |
VARCHAR2(50) |
VARCHAR(50) |
CREATED_BY_CONTACT_FIRST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
CREATED_ON |
DATE |
DATETIME |
MODIFIED_BY_CONTACT_PK |
NUMBER |
INT |
MODIFIED_BY_CONTACT_NAME |
VARCHAR2(250) |
VARCHAR(250) |
MODIFIED_BY_CONTACT_MID_NAME |
VARCHAR2(50) |
VARCHAR(50) |
MODIFIED_BY_CONTACT_FIRST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
MODIFIED_BY_CONTACT_TYPE |
VARCHAR2(7) |
VARCHAR(7) |
MODIFIED_ON |
DATE |
DATETIME |
WH_ACCOUNT_WORKFLOW_RECIPIENT
Column Name |
Oracle Data Type |
MSSQL Data Type |
ACCOUNT_PRIMARY_KEY |
NUMBER |
INT |
ACCOUNT_NAME |
VARCHAR2(250) |
VARCHAR2(250) |
ACCOUNT_TYPE |
VARCHAR2(7) |
VARCHAR2(7) |
CCOUNT_OVERDRAFT_TYPE |
VARCHAR2(30) |
VARCHAR2(30) |
ACCOUNT_PERIOD_START_ON_DATE |
DATE |
DATETIME |
ACCOUNT_PERIOD_END_ON_DATE |
DATE |
DATETIME |
ACCOUNT_STATUS |
VARCHAR2(8) |
VARCHAR2(8) |
ACCOUNT_ALLOW_POSTING |
VARCHAR2(1) |
VARCHAR2(1) |
ACCOUNT_ALLOCATION_LIMIT |
NUMBER |
DECIMAL(28,12) |
ACCOUNT_TOTAL_ALLOCATED |
NUMBER |
DECIMAL(28,12) |
ACCOUNT_TOTAL_USED |
NUMBER |
DECIMAL(28,12) |
ACCOUNT_BALANCE |
NUMBER |
DECIMAL(28,12) |
PARENT_ACCOUNT_PRIMARY_KEY |
NUMBER |
INT |
PARENT_ACCOUNT_NAME |
VARCHAR2(250) |
VARCHAR2(250) |
WORKFLOW_PRIMARY_KEY |
NUMBER |
INT |
REQUEST_NAME |
VARCHAR2(50) |
VARCHAR2(50) |
REQUESTED_BY_CONTACT_PK |
NUMBER |
INT |
REQUESTED_BY_CONTACT_TYPE |
VARCHAR2(7) |
VARCHAR2(7) |
REQUESTED_BY_FIRST_NAME |
VARCHAR2(50) |
VARCHAR2(50) |
REQUESTED_BY_MIDDLE_NAME |
VARCHAR2(50) |
VARCHAR2(50) |
REQUESTED_BY_NAME |
VARCHAR2(250) |
VARCHAR2(250) |
REQUESTED_ON |
DATE |
DATETIME |
COMPLETED_ON |
DATE |
DATETIME |
WORKFLOW_STATUS |
VARCHAR2(30) |
VARCHAR2(30) |
EXPIRES_ON |
DATE |
DATETIME |
CURRENT_STOP_NO |
NUMBER |
INT |
PROCESS_MANAGER_CONTACT_PK |
NUMBER |
INT |
PROCESS_MANAGER_CONTACT_TYPE |
VARCHAR2(7) |
VARCHAR2(7) |
PROCESS_MANAGER_FIRST_NAME |
VARCHAR2(50) |
VARCHAR2(50) |
PROCESS_MANAGER_MIDDLE_NAME |
VARCHAR2(50) |
VARCHAR2(50) |
PROCESS_MANAGER_NAME |
VARCHAR2(250) |
VARCHAR2(250) |
EVENT |
VARCHAR2(250) |
VARCHAR2(250) |
RECIPIENT_CONTACT_PK |
NUMBER |
INT |
RECIPIENT_CONTACT_TYPE |
VARCHAR2(7) |
VARCHAR2(7) |
RECIPIENT_FIRST_NAME |
VARCHAR2(50) |
VARCHAR2(50) |
RECIPIENT_MIDDLE_NAME |
VARCHAR2(50) |
VARCHAR2(50) |
RECIPIENT_NAME |
VARCHAR2(250) |
VARCHAR2(250) |
VERSION |
NUMBER |
INT |
CREATED_ON |
DATE |
DATETIME |
CREATED_BY_CONTACT_PK |
NUMBER |
INT |
CREATED_BY_CONTACT_TYPE |
VARCHAR2(7) |
VARCHAR2(7) |
CREATED_BY_CONTACT_NAME |
VARCHAR2(250) |
VARCHAR2(250) |
CREATED_BY_CONTACT_MIDDLE_NAME |
VARCHAR2(50) |
VARCHAR2(50) |
CREATED_BY_CONTACT_FIRST_NAME |
VARCHAR2(50) |
VARCHAR2(50) |
MODIFIED_ON |
DATE |
DATETIME |
MODIFIED_BY_CONTACT_PK |
NUMBER |
INT |
MODIFIED_BY_CONTACT_TYPE |
VARCHAR2(7) |
VARCHAR2(7) |
MODIFIED_BY_CONTACT_NAME |
VARCHAR2(250) |
VARCHAR2(250) |
MODIFIED_BY_CONTACT_MID_NAME |
VARCHAR2(50) |
VARCHAR2(50) |
WH_ACCOUNT_WORKFLOW_REVIEW
Column Name |
Oracle Data Type |
MSSQL Data Type |
ACCOUNT_PRIMARY_KEY |
NUMBER |
INT |
ACCOUNT_NAME |
VARCHAR2(250) |
VARCHAR2(250) |
ACCOUNT_TYPE |
VARCHAR2(7) |
VARCHAR2(7) |
ACCOUNT_OVERDRAFT_TYPE |
VARCHAR2(30) |
VARCHAR2(30) |
ACCOUNT_PERIOD_START_ON_DATE |
DATE |
DATETIME |
ACCOUNT_PERIOD_END_ON_DATE |
DATE |
DATETIME |
ACCOUNT_STATUS |
VARCHAR2(8) |
VARCHAR2(8) |
ACCOUNT_ALLOW_POSTING |
VARCHAR2(1) |
VARCHAR2(1) |
ACCOUNT_ALLOCATION_LIMIT |
NUMBER |
DECIMAL(28,12) |
ACCOUNT_TOTAL_ALLOCATED |
NUMBER |
DECIMAL(28,12) |
ACCOUNT_TOTAL_USED |
NUMBER |
DECIMAL(28,12) |
ACCOUNT_BALANCE |
NUMBER |
DECIMAL(28,12) |
PARENT_ACCOUNT_PRIMARY_KEY |
NUMBER |
INT |
PARENT_ACCOUNT_NAME |
VARCHAR2(250) |
VARCHAR2(250) |
WORKFLOW_PRIMARY_KEY |
NUMBER |
INT |
REQUEST_NAME |
VARCHAR2(50) |
VARCHAR2(50) |
REQUESTED_BY_CONTACT_PK |
NUMBER |
INT |
REQUESTED_BY_CONTACT_TYPE |
VARCHAR2(7) |
VARCHAR2(7) |
REQUESTED_BY_FIRST_NAME |
VARCHAR2(50) |
VARCHAR2(50) |
REQUESTED_BY_MIDDLE_NAME |
VARCHAR2(50) |
VARCHAR2(50) |
REQUESTED_BY_NAME |
VARCHAR2(250) |
VARCHAR2(250) |
REQUESTED_ON |
DATE |
DATETIME |
COMPLETED_ON |
DATE |
DATETIME |
WORKFLOW_STATUS |
VARCHAR2(30) |
VARCHAR2(30) |
EXPIRES_ON |
DATE |
DATETIME |
CURRENT_STOP_NO |
NUMBER |
INT |
PROCESS_MANAGER_CONTACT_PK |
NUMBER |
INT |
PROCESS_MANAGER_CONTACT_TYPE |
VARCHAR2(7) |
VARCHAR2(7) |
PROCESS_MANAGER_FIRST_NAME |
VARCHAR2(50) |
VARCHAR2(50) |
PROCESS_MANAGER_MIDDLE_NAME |
VARCHAR2(50) |
VARCHAR2(50) |
PROCESS_MANAGER_NAME |
VARCHAR2(250) |
VARCHAR2(250) |
STOP_PRIMARY_KEY |
NUMBER |
INT |
STOP |
NUMBER |
INT |
STOP_MEMBER_PRIMARY_KEY |
NUMBER |
INT |
STOP_STATUS |
VARCHAR2(40) |
VARCHAR2(40) |
EMAIL_SENT |
VARCHAR2(3) |
VARCHAR2(3) |
REVIEW_PRIMARY_KEY |
NUMBER |
INT |
REVIEW_PERFORMER_CONTACT_PK |
NUMBER |
INT |
REVIEW_PERFORMER_CONTACT_TYPE |
VARCHAR2(7) |
VARCHAR2(7) |
REVIEW_PERFORMER_FIRST_NAME |
VARCHAR2(50) |
VARCHAR2(50) |
REVIEW_PERFORMER_MIDDLE_NAME |
VARCHAR2(50) |
VARCHAR2(50) |
REVIEW_PERFORMER_NAME |
VARCHAR2(250) |
VARCHAR2(250) |
REVIEW_STATUS |
VARCHAR2(20) |
VARCHAR2(20) |
REVIEW_ACTION_DATE |
DATE |
DATETIME |
REVIEW_APPROVAL_COMMENT |
VARCHAR2(250) |
VARCHAR2(250) |
REVIEW_REQUEST_COMMENT |
VARCHAR2(250) |
VARCHAR2(250) |
CREATED_ON |
DATE |
DATETIME |
CREATED_BY_CONTACT_PK |
NUMBER |
INT |
CREATED_BY_CONTACT_TYPE |
VARCHAR2(7) |
VARCHAR2(7) |
CREATED_BY_CONTACT_NAME |
VARCHAR2(250) |
VARCHAR2(250) |
CREATED_BY_CONTACT_MIDDLE_NAME |
VARCHAR2(50) |
VARCHAR2(50) |
CREATED_BY_CONTACT_FIRST_NAME |
VARCHAR2(50) |
VARCHAR2(50) |
MODIFIED_ON |
DATE |
DATETIME |
MODIFIED_BY_CONTACT_PK |
NUMBER |
INT |
MODIFIED_BY_CONTACT_TYPE |
VARCHAR2(7) |
VARCHAR2(7) |
MODIFIED_BY_CONTACT_NAME |
VARCHAR2(250) |
VARCHAR2(250) |
MODIFIED_BY_CONTACT_MID_NAME |
VARCHAR2(50) |
VARCHAR2(50) |
