Skip to main content
Mitratech Success Center

Account

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)

  • Was this article helpful?