Account

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)