Account

WH_ACCOUNT

Column Name	Oracle Data Type	MSSQL Data Type	Friendly Column Name
ACCOUNT_ALLOCATION_LIMIT	NUMBER	DECIMAL(28, 12)	Account Allocation Limit
ACCOUNT_ALLOW_POSTING	VARCHAR2(20)	VARCHAR(20)	Account Allow Posting
ACCOUNT_BALANCE	NUMBER	DECIMAL(28, 12)	Account Balance
ACCOUNT_DEFAULT_CATEGORY	VARCHAR2(50)	VARCHAR(50)	Account Default Category
ACCOUNT_DEFAULT_CATEGORY_TREE	VARCHAR2(250)	VARCHAR(250)	Account Default Catergory Tree
ACCOUNT_NAME	VARCHAR2(250)	VARCHAR(250)	Account Name
ACCOUNT_NONUS_TAX	NUMBER	DECIMAL(28, 12)	Account Non US Tax
ACCOUNT_NONUS_TAX_TYPE	VARCHAR2(50)	VARCHAR(50)	Account Non US Tax Type
ACCOUNT_NONUS_TAX_TYPE	VARCHAR2(250)	VARCHAR(250)	Account Non US Tax Type
ACCOUNT_NONUS_TAX_PCT	NUMBER	DECIMAL(28, 12)	Account Non US Tax Percentage
ACCOUNT_OVERDRAFT_TYPE	VARCHAR2(40)	VARCHAR(40)	Account Overdraft Type
ACCOUNT_PERIOD_END_ON_DATE	DATE	DATETIME	Account Period End On Date
ACCOUNT_PERIOD_START_ON_DATE	DATE	DATETIME	Account Period Start On Date
ACCOUNT_PRIMARY_KEY	NUMBER	INT	Account Primary Key
ACCOUNT_STATUS	VARCHAR2(20)	VARCHAR(20)	Account Status
ACCOUNT_TOTAL_ACCRUAL	NUMBER	DECIMAL(28, 12)	Account Total Accrual
ACCOUNT_TOTAL_ALLOCATED	NUMBER	DECIMAL(28, 12)	Account Total Allocated
ACCOUNT_TOTAL_USED	NUMBER	DECIMAL(28, 12)	Account Total Used
ACCOUNT_TREE_KEY	VARCHAR2(700)	VARCHAR(700)	Account Tree Key
ACCOUNT_TYPE	VARCHAR2(20)	VARCHAR(20)	Account Type
CREATED_BY_CONTACT_FIRST_NAME	VARCHAR2(50)	VARCHAR(50)	Created By Contact First Name
CREATED_BY_CONTACT_MIDDLE_NAME	VARCHAR2(50)	VARCHAR(50)	Created By Contact Middle Name
CREATED_BY_CONTACT_NAME	VARCHAR2(250)	VARCHAR(250)	Created By Contact Name
CREATED_BY_CONTACT_PK	NUMBER	INT	Created By Contact Primary Key
CREATED_BY_CONTACT_TYPE	VARCHAR2(10)	VARCHAR(10)	Created By Contact Type
CREATED_ON	DATE	DATETIME	Created On
DOCUMENT_FOLDER_PRIMARY_KEY	NUMBER	INT	Document Folder Primary Key
MODIFIED_BY_CONTACT_FIRST_NAME	VARCHAR2(50)	VARCHAR(50)	Modified By Contact First Name
MODIFIED_BY_CONTACT_MID_NAME	VARCHAR2(50)	VARCHAR(50)	Modified By Contact Mid Name
MODIFIED_BY_CONTACT_NAME	VARCHAR2(250)	VARCHAR(250)	Modified By Contact Name
MODIFIED_BY_CONTACT_PK	NUMBER	INT	Modified By Contact Primary Key
MODIFIED_BY_CONTACT_TYPE	VARCHAR2(10)	VARCHAR(10)	Modified By Contact Type
BEHALF_OF_CONTACT_PRIMARY_KEY	NUMBER	INT	Behalf of Contact Primary Key
MODIFIED_ON	DATE	DATETIME	Modified On
PARENT_ACCOUNT_NAME	VARCHAR2(250)	VARCHAR(250)	Parent Account Name
PARENT_ACCOUNT_PRIMARY_KEY	NUMBER	INT	Parent Account Primary Key
POST_ACCOUNT_TO_INVOLVED	VARCHAR2(20)	VARCHAR(20)	Post Account to Involved
POST_ACCOUNT_TO_VENDOR	VARCHAR2(20)	VARCHAR(20)	Post Account to Vendor
POST_EXPENSES_OF_CATEGORY	VARCHAR2(50)	VARCHAR(50)	Post Expenses of Category
POST_EXPENSES_OF_CATEGORY_TP	VARCHAR2(250)	VARCHAR(250)	Post Expenses of Category Type
POST_EXPENSES_TO_THIS_ACCOUNT	VARCHAR2(20)	VARCHAR(20)	Post Expenses to this Account
POST_INVOICE_EXPENSE_OF_TYPE	VARCHAR2(50)	VARCHAR(50)	Post Invoice Expense of Type
POST_INVOICE_EXPENSE_OF_TYPE_TP	VARCHAR2(250)	VARCHAR(250)	Post Invoice Expense of Type
POST_INVOICE_EXPENSES_TO_THIS	VARCHAR2(20)	VARCHAR(20)	Post Invoice Expenses to this
POST_INVOICE_TASK_OF_TYPE	VARCHAR2(50)	VARCHAR(50)	Post Invoice Task of Type
POST_INVOICE_TASK_OF_TYPE_TP	VARCHAR2(250)	VARCHAR(250)	Post Invoice Task of Type
POST_INVOICE_TASKS_TO_THIS	VARCHAR2(20)	VARCHAR(20)	Post Invoice Tasks to this
POST_PROJECT_TO_THIS_ACCOUNT	VARCHAR2(20)	VARCHAR(20)	Post Project to this Account
POST_TASKS_OF_TYPE	VARCHAR2(50)	VARCHAR(50)	Post Tasks of Type
POST_TASKS_OF_TYPE_TP	VARCHAR2(250)	VARCHAR(250)	Post Tasks of Type
POST_TASKS_TO_THIS_ACCOUNT	VARCHAR2(20)	VARCHAR(20)	Post Tasks to this Account
POSTED_EXPENSE_PERCENT	NUMBER	DECIMAL(28, 12)	Post Expense Percentage
POSTED_TASK_PERCENT	NUMBER	DECIMAL(28, 12)	Post Task Percentage
POSTING_INVC_ACCRUAL	VARCHAR2(10)	VARCHAR(10)	Posting Invoice Accrual
POSTING_INVC_CREDIT_NOTE	VARCHAR2(10)	VARCHAR(10)	Posting Invoice Credit Note
POSTING_INVC_STANDARD	VARCHAR2(10)	VARCHAR(10)	Posting Invoice Standard
POSTING_INVOICE_EXPENSE_PERCNT	NUMBER	DECIMAL(28, 12)	Posting Invoice Expense Percentage
POSTING_INVOICE_TASK_PERCENT	NUMBER	DECIMAL(28, 12)	Posting Invoice Task Percentage
POSTING_INVOLVED_CONTACT_FIRST	VARCHAR2(50)	VARCHAR(50)	Posting Involved Contact First Name
POSTING_INVOLVED_CONTACT_MIDDL	VARCHAR2(50)	VARCHAR(50)	Posting Involved Contact Middle Name
POSTING_INVOLVED_CONTACT_NAME	VARCHAR2(250)	VARCHAR(250)	Posting Involved Contact Name
POSTING_INVOLVED_CONTACT_PK	NUMBER	INT	Posting Involved Contact Primary Key
POSTING_INVOLVED_CONTACT_TYPE	VARCHAR2(10)	VARCHAR(10)	Posting Involved Contact Type
POSTING_PROJECT_CATEGORY_NAME	VARCHAR2(50)	VARCHAR(50)	Posting Project Category Name
POSTING_PROJECT_CATEGORY_TREE	VARCHAR2(250)	VARCHAR(250)	Posting Project Category Tree
POSTING_PROJECT_NAME	VARCHAR2(250)	VARCHAR(250)	Posting Project Name
POSTING_PROJECT_NUMBER	VARCHAR2(50)	VARCHAR(50)	Posting Project Number
POSTING_PROJECT_OBJECT_TITLE	VARCHAR2(250)	VARCHAR(250)	Posting Project Object Title
POSTING_PROJECT_PRIMARY_KEY	NUMBER	INT	Posting Project Primary Key
POSTING_PROJECT_UNIQUE_CODE	VARCHAR2(4)	VARCHAR(4)	Posting Project Unique Code
POSTING_VENDOR_CONTACT_FIRST	VARCHAR2(50)	VARCHAR(50)	Posting Vendor Contact First Name
POSTING_VENDOR_CONTACT_MIDDLE	VARCHAR2(50)	VARCHAR(50)	Posting Vendor Contact Middle Name
POSTING_VENDOR_CONTACT_NAME	VARCHAR2(250)	VARCHAR(250)	Posting Vendor Contact Name
POSTING_VENDOR_CONTACT_PK	NUMBER	INT	Posting Vendor Contact Primary Key
POSTING_VENDOR_CONTACT_TYPE	VARCHAR2(10)	VARCHAR(10)	Posting Vendor Contact Type
SECURITY	VARCHAR2(10)	VARCHAR(10)	Account Security
WORKFLOW_CURRENT_STATUS	VARCHAR2(15)	VARCHAR(15)	Workflow Current Status
WORKFLOW_CURRENT_ACTION	VARCHAR2(50)	VARCHAR(50)	Workflow Current Action
NOTES	CLOB	NTEXT	Notes
CURRENT_APPROVER_CONTACT_PK	NUMBER	INT	Current Approver Contact Primary Key
CURRENT_APPROVER_NAME	VARCHAR2(250)	VARCHAR(250)	Current Approver Name
CURRENT_APPROVER_FIRST_NAME	VARCHAR2(50)	VARCHAR(50)	Current Approver First Name
CURRENT_APPROVER_MIDDLE_NAME	VARCHAR2(50)	VARCHAR(50)	Current Approver Middle Name
CURRENT_APPROVER_TYPE	VARCHAR2(7)	VARCHAR(7)	Current Approver Type
LAST_PERFRMR_CONTACT_PK	NUMBER	INT	Last Performer Contact Primary Key
LAST_PERFRMR_NAME	VARCHAR2(250)	VARCHAR(250)	Last Performer Name
LAST_PERFRMR_FIRST_NAME	VARCHAR2(50)	VARCHAR(50)	Last Performer First Name
LAST_PERFRMR_MIDDLE_NAME	VARCHAR2(50)	VARCHAR(50)	Last Performer Middle Name
LAST_PERFRMR_TYPE	VARCHAR2(7)	VARCHAR(7)	Last Performer Type
MULTIPLE_APPROVERS	VARCHAR2(3)	VARCHAR(3)	Multiple Approvers
ACCOUNT_PERIOD_START_ON_DT_KEY	NUMBER	INT	Account Period Start on Date Key
ACCOUNT_PERIOD_END_ON_DATE_KEY	NUMBER	INT	Account Period End on Date Key
CREATED_ON_DATE_KEY	DATE	DATETIME	Created on Date Key
MODIFIED_ON_DATE_KEY	DATE	DATETIME	Modified on Date Key
ACCOUNT_TOTAL_MATTER_FEE_TAX	NVARCHAR2(3)	NVARCHAR(3)	Account Total Matter Fee Tax
ACCOUNT_TOTAL_MATTER_EXP_TAX	NVARCHAR2(3)	NVARCHAR(3)	Account Total Matter Expense Tax

WH_ACCOUNT_CATEGORIES

Column Name	Oracle Data Type	MSSQL Data Type	Friendly Column Name
ACCOUNT_PRIMARY_KEY	NUMBER	INT	Account Primary Key
ACCOUNT_NAME	VARCHAR2(250)	VARCHAR(250)	Account Name
ACCOUNT_TYPE	VARCHAR2(20)	VARCHAR(20)	Account Type
ACCOUNT_OVERDRAFT_TYPE	VARCHAR2(40)	VARCHAR(40)	Account Overdraft Type
ACCOUNT_PERIOD_START_ON_DATE	DATE	DATETIME	Account Period Start on Date
ACCOUNT_PERIOD_END_ON_DATE	DATE	DATETIME	Account Period End on Date
ACCOUNT_STATUS	VARCHAR2(20)	VARCHAR(20)	Account Status
ACCOUNT_ALLOW_POSTING	VARCHAR2(20)	VARCHAR(20)	Account Allow Posting
ACCOUNT_ALLOCATION_LIMIT	NUMBER	DECIMAL(28,12)	Account Allocation Limit
ACCOUNT_TOTAL_ALLOCATED	NUMBER	DECIMAL(28,12)	Account Total Allocated
ACCOUNT_TOTAL_USED	NUMBER	DECIMAL(28,12)	Account Total Used
ACCOUNT_BALANCE	NUMBER	DECIMAL(28,12)	Account Balance
PARENT_ACCOUNT_PRIMARY_KEY	NUMBER	INT	Parent Account Primary Key
PARENT_ACCOUNT_NAME	VARCHAR2(250)	VARCHAR(250)	Parent Account Name
CATEGORY_NAME	VARCHAR2(50)	VARCHAR(50)	Category Name
CATEGORY_TREE_POSITION	VARCHAR2(250)	VARCHAR(250)	Category Tree Position
IS_CATEGORY_MANUALLY_ADDED	VARCHAR2(1)	VARCHAR(1)	Is Category Manually Added?
IS_DEFAULT_CATEGORY	VARCHAR2(5)	VARCHAR(5)	Is Default Cateory?
SECURITY	VARCHAR2(10)	VARCHAR(10)	Account Security

WH_ACCOUNT_DELTA

Column Name	Oracle Date Type	MSSQL Date Type	Friendly Column Name
PRIMARY_KEY	NUMBER	INT	Primary Key

WH_ACCOUNT_TRANSACTIONS

Column Name	Oracle Data Type	MSSQL Data Type	Friendly Column Name
ACCOUNT_PRIMARY_KEY	NUMBER	INT	Account Primary Key
ACCOUNT_NAME	VARCHAR2(250)	VARCHAR(250)	Account Name
ACCOUNT_TYPE	VARCHAR2(20)	VARCHAR(20)	Account Type
ACCOUNT_OVERDRAFT_TYPE	VARCHAR2(40)	VARCHAR(40)	Account Overdraft Type
ACCOUNT_PERIOD_START_ON_DATE	DATE	DATETIME	Account Period Start on Date
ACCOUNT_PERIOD_END_ON_DATE	DATE	DATETIME	Account Period End on Date
ACCOUNT_STATUS	VARCHAR2(20)	VARCHAR(20)	Account Status
ACCOUNT_ALLOW_POSTING	VARCHAR2(20)	VARCHAR(20)	Acccount Allow Posting
ACCOUNT_ALLOCATION_LIMIT	NUMBER	DECIMAL(28,12)	Account Allocation Limit
ACCOUNT_TOTAL_ALLOCATED	NUMBER	DECIMAL(28,12)	Account Total Allocated
ACCOUNT_TOTAL_USED	NUMBER	DECIMAL(28,12)	Account Total Used
ACCOUNT_BALANCE	NUMBER	DECIMAL(28,12)	Account Balance
ACCOUNT_DEFAULT_CATEGORY	VARCHAR2(50)	VARCHAR(50)	Account Default Category
ACCOUNT_DEFAULT_CATEGORY_TREE	VARCHAR2(250)	VARCHAR(250)	Account Default Category Tree
TRANSACTION_PRIMARY_KEY	NUMBER	INT	Transaction Primary Key
TRANSACTION_DATE	DATE	DATETIME	Transaction Date
TRANSACTION_DESCRIPTION	VARCHAR2(250)	VARCHAR(250)	Transaction Description
TRANSACTION_TOTAL_AMOUNT	NUMBER	DECIMAL(28,12)	Transaction Total Amount
DETAIL_PRIMARY_KEY	NUMBER	INT	Details Primary Key
DETAIL_TOTAL_AMOUNT	NUMBER	DECIMAL(28,12)	Detail Total Amount
DETAIL_DESCRIPTION	VARCHAR2(250)	VARCHAR(250)	Detail Description
DETAIL_STATUS	VARCHAR2(20)	VARCHAR(20)	Detail Status
TRANSACTION_CREATED_ON	DATE	DATETIME	Transaction Created on
TRANSACTION_MODIFIED_ON	DATE	DATETIME	Transaction Modified on
CREATED_BY_CONTACT_PK	NUMBER	INT	Created by Contact Primary Key
CREATED_BY_CONTACT_TYPE	VARCHAR2(10)	VARCHAR(10)	Created by Contact Type
CREATED_BY_CONTACT_NAME	VARCHAR2(250)	VARCHAR(250)	Created by Contact Name
CREATED_BY_CONTACT_MIDDLE_NAME	VARCHAR2(50)	VARCHAR(50)	Created by Contact Middle Name
CREATED_BY_CONTACT_FIRST_NAME	VARCHAR2(50)	VARCHAR(50)	Created by Contact First Name
MODIFIED_BY_CONTACT_PK	NUMBER	INT	Modified by Contact Primary Key
MODIFIED_BY_CONTACT_TYPE	VARCHAR2(10)	VARCHAR(10)	Modified by Contact Type
MODIFIED_BY_CONTACT_NAME	VARCHAR2(250)	VARCHAR(250)	Modified by Contact Name
MODIFIED_BY_CONTACT_MID_NAME	VARCHAR2(50)	VARCHAR(50)	Modified by Contact Mid Name
MODIFIED_BY_CONTACT_FIRST_NAME	VARCHAR2(50)	VARCHAR(50)	Modified by Contact First Name
EXPENSE_PRIMARY_KEY	NUMBER	INT	Expense Primary Key
EXPENSE_DESCRIPTION	VARCHAR2(250)	VARCHAR(250)	Expense Description
EXPENSE_DATE	DATE	DATETIME	Expense Date
TASK_PRIMARY_KEY	NUMBER	INT	Task Primary Key
TASK_SUBJECT	VARCHAR2(250)	VARCHAR(250)	Task Subject
TASK_COMPLETED_ON	DATE	DATETIME	Task Completed on
INVOICE_PRIMARY_KEY	NUMBER	INT	Invoice Primary Key
INVOICE_NUMBER	VARCHAR2(50)	VARCHAR(50)	Invoice Number
INVOICE_DATE	DATE	DATETIME	Invoice Date
TRANSFERED_ACCOUNT_PRIMARY_KEY	NUMBER	INT	Transferred Account Primary Key
TRANSFERRED_ACCOUNT_NAME	VARCHAR2(250)	VARCHAR(250)	Transferred Account Name
TRANSFERRED_ACCOUNT_TYPE	VARCHAR2(20)	VARCHAR(20)	Transferred Account Type
WITHDRAWAL	VARCHAR2(1)	VARCHAR(1)	Withdrawal
SECURITY	VARCHAR2(10)	VARCHAR(10)	Account Security

WH_ACCOUNT_GROUP_ACCESS

Column Name	Oracle Data Type	MSSQL Data Type	Friendly Name Column
ACCOUNT_PRIMARY_KEY	NUMBER	INT	Account Primary Key
GROUP_PRIMARY_KEY	NUMBER	INT	Group Primary Key
ALLOW_DENY_IID	CHAR(1)	CHAR(1)	Allow/Deny Identifier
IS_DELETE	NUMBER	INT	Is Deleted
IS_MANUAL	NUMBER	INT	Is Manual
IS_PERM	NUMBER	INT	Is Permanent
IS_READ	NUMBER	INT	Is Read
IS_UPDATE	NUMBER	INT	Is Updated
VERSION	NUMBER	INT	Version Number

WH_ACCOUNT_USER_ACCESS

Column Name	Oracle Data Type	MSSQL Data Type	Friendly Name Column
ACCOUNT_PRIMARY_KEY	NUMBER	INT	Account Primary Key
USER_PRIMARY_KEY	NUMBER	INT	User Primary Key
ALLOW_DENY_IID	CHAR(1)	CHAR(1)	Allow/Deny Identifier
IS_DELETE	NUMBER	INT	Is Deleted
IS_MANUAL	NUMBER	INT	Is Manual
IS_PERM	NUMBER	INT	Is Permanent
IS_READ	NUMBER	INT	Is Read
IS_UPDATE	NUMBER	INT	Is Updated
VERSION	NUMBER	INT	Version Number

WH_ACCOUNT_SECURITY

Column Name	Oracle Data Type	MSSQL Data Type	Friendly Name Column
ACCOUNT_PRIMARY_KEY	NUMBER	INT	Account Primary Key
CREATED_BY_CONTACT_PK	NUMBER	INT	Created by Contact Primary Key
SECURITY	NVARCHAR2(10)	NVARCHAR(10)	Security

WH_ACCOUNT_WORKFLOW

Column Name	Oracle Data Type	MSSQL Data Type	Friendly Name Column
ACCOUNT_PRIMARY_KEY	NUMBER	INT	Account Primary Key
ACCOUNT_NAME	VARCHAR2(250)	VARCHAR(250)	Account Name
ACCOUNT_TYPE	VARCHAR2(7)	VARCHAR(7)	Account Type
ACCOUNT_OVERDRAFT_TYPE	VARCHAR2(30)	VARCHAR(30)	Account Overdraft Type
ACCOUNT_PERIOD_START_ON_DATE	DATE	DATETIME	Account Period Start on Date
ACCOUNT_PERIOD_END_ON_DATE	DATE	DATETIME	Account Period End on Date
ACCOUNT_STATUS	VARCHAR2(8)	VARCHAR(8)	Account Status
ACCOUNT_ALLOW_POSTING	VARCHAR2(1)	VARCHAR(1)	Account Allow Posting
ACCOUNT_ALLOCATION_LIMIT	NUMBER	DECIMAL(28,12)	Account Allocation Limit
ACCOUNT_TOTAL_ALLOCATED	NUMBER	DECIMAL(28,12)	Account Total Allocated
ACCOUNT_TOTAL_USED	NUMBER	DECIMAL(28,12)	Account Total Used
ACCOUNT_BALANCE	NUMBER	DECIMAL(28,12)	Account Balance
PARENT_ACCOUNT_PRIMARY_KEY	NUMBER	INT	Parent Account Primary Key
PARENT_ACCOUNT_NAME	VARCHAR2(250)	VARCHAR(250)	Parent Account Name
WORKFLOW_PRIMARY_KEY	NUMBER	INT	Workflow Primary Key
REQUEST_NAME	VARCHAR2(50)	VARCHAR(50)	Request Name
RULE_SHORT_DESCRIPTION	VARCHAR2(250)	VARCHAR2(250)	Rule Short Description
REQUESTED_BY_CONTACT_PK	NUMBER	INT	Request by Contact Primary Key
REQUESTED_BY_CONTACT_TYPE	VARCHAR2(7)	VARCHAR(7)	Request by Contact Type
REQUESTED_BY_FIRST_NAME	VARCHAR2(50)	VARCHAR(50)	Requested by First Name
REQUESTED_BY_MIDDLE_NAME	VARCHAR2(50)	VARCHAR(50)	Requested by Middle Name
REQUESTED_BY_NAME	VARCHAR2(250)	VARCHAR(250)	Requested by Name
REQUESTED_ON	DATE	DATETIME	Requested on
COMPLETED_ON	DATE	DATETIME	Completed on
WORKFLOW_STATUS	VARCHAR2(30)	VARCHAR(30)	Workflow Status
COMMENT_TO_REQUESTOR	VARCHAR2(2000)	VARCHAR(2000)	Comment to Requestor
EXPIRES_ON	DATE	DATETIME	Expires on
EXPIRE_ACTION	VARCHAR2(30)	VARCHAR(30)	Expires Action
TRANSACTION_STATUS	VARCHAR2(250)	VARCHAR(250)	Transaction Status
CURRENT_STOP_NO	NUMBER	INT	Current Stop Number
REJECT_ACTION	VARCHAR2(30)	VARCHAR(30)	Reject Action
REJECT_REASON	VARCHAR2(50)	VARCHAR(50)	Reject Reason
UPDATE_WHILE_PENDING	VARCHAR(105)	VARCHAR(105)	Update While Pending
PROCESS_MANAGER_CONTACT_PK	NUMBER	INT	Process Manager Contact Primary Key
PROCESS_MANAGER_CONTACT_TYPE	VARCHAR2(7)	VARCHAR(7)	Process Manager Contact Type
PROCESS_MANAGER_FIRST_NAME	VARCHAR2(50)	VARCHAR(50)	Process Manager First Name
PROCESS_MANAGER_MIDDLE_NAME	VARCHAR2(50)	VARCHAR(50)	Process Manager Middle Name
PROCESS_MANAGER_NAME	VARCHAR2(250)	VARCHAR(250)	Process Manager Name
STOP_MEMBER_PRIMARY_KEY	NUMBER	INT	Stop Member Primary Key
STOP_PRIMARY_KEY	NUMBER	INT	Stop Primary Key
STOP	NUMBER	INT	Stop
PERFORMER_CONTACT_PK	NUMBER	INT	Performer Contact Primary Key
PERFORMER_CONTACT_TYPE	VARCHAR2(7)	VARCHAR(7)	Performer Contact Type
PERFORMER_FIRST_NAME	VARCHAR2(50)	VARCHAR(50)	Performer First Name
PERFORMER_MIDDLE_NAME	VARCHAR2(50)	VARCHAR(50)	Performer Middle Name
PERFORMER_NAME	VARCHAR2(250)	VARCHAR(250)	Performer Name
STOP_STATUS	VARCHAR2(40)	VARCHAR(40)	Stop Status
ACTION_DATE	DATE	DATETIME	Action Date
STOP_EXPIRATION_DATE	DATE	DATETIME	Stop Expiration Date
INTERNAL_COMMENT	VARCHAR2(2000)	VARCHAR(2000)	Internal Comment
EMAIL_SENT	VARCHAR2(3)	VARCHAR(3)	Email Sent
CREATED_BY_CONTACT_PK	NUMBER	INT	Created by Contact Primary Key
CREATED_BY_CONTACT_TYPE	VARCHAR2(7)	VARCHAR(7)	Created by Contact Type
CREATED_BY_CONTACT_NAME	VARCHAR2(250)	VARCHAR(250)	Created by Contact Name
CREATED_BY_CONTACT_MIDDLE_NAME	VARCHAR2(50)	VARCHAR(50)	Created by Contact Middle Name
CREATED_BY_CONTACT_FIRST_NAME	VARCHAR2(50)	VARCHAR(50)	Created by Contact First Name
CREATED_ON	DATE	DATETIME	Created On
MODIFIED_BY_CONTACT_PK	NUMBER	INT	Modified by Contact Primary Key
MODIFIED_BY_CONTACT_NAME	VARCHAR2(250)	VARCHAR(250)	Modified by Contact Name
MODIFIED_BY_CONTACT_MID_NAME	VARCHAR2(50)	VARCHAR(50)	Modified by Contact Middle Name
MODIFIED_BY_CONTACT_FIRST_NAME	VARCHAR2(50)	VARCHAR(50)	Modified by Contact First Name
MODIFIED_BY_CONTACT_TYPE	VARCHAR2(7)	VARCHAR(7)	Modified by Contact Type
MODIFIED_ON	DATE	DATETIME	Modified on

WH_ACCOUNT_WORKFLOW_HISTORY

Column Name	Oracle Data Type	MSSQL Data Type	Friendly Name Column
ACCOUNT_PRIMARY_KEY	NUMBER	INT	Account Primary Key
ACCOUNT_NAME	VARCHAR2(250)	VARCHAR(250)	Account Name
ACCOUNT_TYPE	VARCHAR2(7)	VARCHAR(7)	Account Type
ACCOUNT_OVERDRAFT_TYPE	VARCHAR2(30)	VARCHAR(30)	Account Overdraft Type
ACCOUNT_PERIOD_START_ON_DATE	DATE	DATETIME	Account Period Start On Date
ACCOUNT_PERIOD_END_ON_DATE	DATE	DATETIME	Account Period End On Date
ACCOUNT_STATUS	VARCHAR2(8)	VARCHAR(8)	Account Status
ACCOUNT_ALLOW_POSTING	VARCHAR2(1)	VARCHAR(1)	Account Allow Posting
ACCOUNT_ALLOCATION_LIMIT	NUMBER	DECIMAL(28,12)	Account Allocation Limit
ACCOUNT_TOTAL_ALLOCATED	NUMBER	DECIMAL(28,12)	Account Total Allocated
ACCOUNT_TOTAL_USED	NUMBER	DECIMAL(28,12)	Account Total Used
ACCOUNT_BALANCE	NUMBER	DECIMAL(28,12)	Account Balance
PARENT_ACCOUNT_PRIMARY_KEY	NUMBER	INT	Parent Account Primary Key
PARENT_ACCOUNT_NAME	VARCHAR2(250)	VARCHAR(250)	Parent Account Name
WORKFLOW_PRIMARY_KEY	NUMBER	INT	Workflow Primary Key
REQUEST_NAME	VARCHAR2(50)	VARCHAR(50)	Request Name
RULE_SHORT_DESCRIPTION	VARCHAR2(250)	VARCHAR2(250)	Rule Short Description
REQUESTED_BY_CONTACT_PK	NUMBER	INT	Requested By Contact Primary Key
REQUESTED_BY_CONTACT_TYPE	VARCHAR2(7)	VARCHAR(7)	Requested By Contact Type
REQUESTED_BY_FIRST_NAME	VARCHAR2(50)	VARCHAR(50)	Requested By First Name
REQUESTED_BY_MIDDLE_NAME	VARCHAR2(50)	VARCHAR(50)	Requested By Middle Name
REQUESTED_BY_NAME	VARCHAR2(250)	VARCHAR(250)	Requested By Name
REQUESTED_ON	DATE	DATETIME	Requested On
COMPLETED_ON	DATE	DATETIME	Completed On
WORKFLOW_STATUS	VARCHAR2(30)	VARCHAR(30)	Workflow Status
COMMENT_TO_REQUESTOR	VARCHAR2(2000)	VARCHAR(2000)	Comment To Requestor
EXPIRES_ON	DATE	DATETIME	Expires On
EXPIRE_ACTION	VARCHAR2(30)	VARCHAR(30)	Expire Action
TRANSACTION_STATUS	VARCHAR2(250)	VARCHAR(250)	Transaction Status
CURRENT_STOP_NO	NUMBER	INT	Current Stop Number
REJECT_ACTION	VARCHAR2(30)	VARCHAR(30)	Reject Action
REJECT_REASON	VARCHAR2(50)	VARCHAR(50)	Reject Reason
UPDATE_WHILE_PENDING	VARCHAR2(105)	VARCHAR(105)	Update While Pending
PROCESS_MANAGER_CONTACT_PK	NUMBER	INT	Process Manager Contact Primary Key
PROCESS_MANAGER_CONTACT_TYPE	VARCHAR2(7)	VARCHAR(7)	Process Manager Contact Type
PROCESS_MANAGER_FIRST_NAME	VARCHAR2(50)	VARCHAR(50)	Process Manager First Name
PROCESS_MANAGER_MIDDLE_NAME	VARCHAR2(50)	VARCHAR(50)	Process Manager Middle Name
PROCESS_MANAGER_NAME	VARCHAR2(250)	VARCHAR(250)	Process Manager Name
STOP	NUMBER	INT	Stop
PERFORMER_CONTACT_PK	NUMBER	INT	Performer Contact Primary Key
PERFORMER_CONTACT_TYPE	VARCHAR2(7)	VARCHAR(7)	Performer Contact Type
PERFORMER_FIRST_NAME	VARCHAR2(50)	VARCHAR(50)	Performer First Name
PERFORMER_MIDDLE_NAME	VARCHAR2(50)	VARCHAR(50)	Performer Middle Name
PERFORMER_NAME	VARCHAR2(250)	VARCHAR(250)	Performer Name
ACTIVITY	VARCHAR2(250)	VARCHAR(250)	Activity
DATE_TIME	DATE	DATETIME	Date Time
INTERNAL_COMMENT	VARCHAR2(2000)	VARCHAR(2000)	Internal Comment
CREATED_BY_CONTACT_PK	NUMBER	INT	Created By Contact Primary Key
CREATED_BY_CONTACT_TYPE	VARCHAR2(7)	VARCHAR(7)	Created By Contact Type
CREATED_BY_CONTACT_NAME	VARCHAR2(250)	VARCHAR(250)	Created By Contact Name
CREATED_BY_CONTACT_MIDDLE_NAME	VARCHAR2(50)	VARCHAR(50)	Created By Contact Middle Name
CREATED_BY_CONTACT_FIRST_NAME	VARCHAR2(50)	VARCHAR(50)	Created By Contact First Name
CREATED_ON	DATE	DATETIME	Created On
MODIFIED_BY_CONTACT_PK	NUMBER	INT	Modified By Contact Primary Key
MODIFIED_BY_CONTACT_NAME	VARCHAR2(250)	VARCHAR(250)	Modified By Contact Name
MODIFIED_BY_CONTACT_MID_NAME	VARCHAR2(50)	VARCHAR(50)	Modified By Contact Middle Name
MODIFIED_BY_CONTACT_FIRST_NAME	VARCHAR2(50)	VARCHAR(50)	Modified By Contact First Name
MODIFIED_BY_CONTACT_TYPE	VARCHAR2(7)	VARCHAR(7)	Modified By Contact Type
MODIFIED_ON	DATE	DATETIME	Modified On

WH_ACCOUNT_WORKFLOW_RECIPIENT

Column Name	Oracle Data Type	MSSQL Data Type	Friendly Name Column
ACCOUNT_PRIMARY_KEY	NUMBER	INT	Account Primary Key
ACCOUNT_NAME	VARCHAR2(250)	VARCHAR2(250)	Account Name
ACCOUNT_TYPE	VARCHAR2(7)	VARCHAR2(7)	Account Type
ACCOUNT_OVERDRAFT_TYPE	VARCHAR2(30)	VARCHAR2(30)	Account Overdraft Type
ACCOUNT_PERIOD_START_ON_DATE	DATE	DATETIME	Account Period Start On Date
ACCOUNT_PERIOD_END_ON_DATE	DATE	DATETIME	Account Period End On Date
ACCOUNT_STATUS	VARCHAR2(8)	VARCHAR2(8)	Account Status
ACCOUNT_ALLOW_POSTING	VARCHAR2(1)	VARCHAR2(1)	Account Allow Posting
ACCOUNT_ALLOCATION_LIMIT	NUMBER	DECIMAL(28,12)	Account Allocation Limit
ACCOUNT_TOTAL_ALLOCATED	NUMBER	DECIMAL(28,12)	Account Total Allocated
ACCOUNT_TOTAL_USED	NUMBER	DECIMAL(28,12)	Account Total Used
ACCOUNT_BALANCE	NUMBER	DECIMAL(28,12)	Account Balance
PARENT_ACCOUNT_PRIMARY_KEY	NUMBER	INT	Parent Account Primary Key
PARENT_ACCOUNT_NAME	VARCHAR2(250)	VARCHAR2(250)	Parent Account Name
WORKFLOW_PRIMARY_KEY	NUMBER	INT	Workflow Primary Key
REQUEST_NAME	VARCHAR2(50)	VARCHAR2(50)	Request Name
RULE_SHORT_DESCRIPTION	VARCHAR2(250)	VARCHAR2(250)	Rule Short Description
REQUESTED_BY_CONTACT_PK	NUMBER	INT	Requested By Contact Primary Key
REQUESTED_BY_CONTACT_TYPE	VARCHAR2(7)	VARCHAR2(7)	Requested By Contact Type
REQUESTED_BY_FIRST_NAME	VARCHAR2(50)	VARCHAR2(50)	Requested By First Name
REQUESTED_BY_MIDDLE_NAME	VARCHAR2(50)	VARCHAR2(50)	Requested By Middle Name
REQUESTED_BY_NAME	VARCHAR2(250)	VARCHAR2(250)	Requested By Name
REQUESTED_ON	DATE	DATETIME	Requested On
COMPLETED_ON	DATE	DATETIME	Completed On
WORKFLOW_STATUS	VARCHAR2(30)	VARCHAR2(30)	Workflow Status
EXPIRES_ON	DATE	DATETIME	Expires On
CURRENT_STOP_NO	NUMBER	INT	Current Stop Number
PROCESS_MANAGER_CONTACT_PK	NUMBER	INT	Process Manager Contact Primary Key
PROCESS_MANAGER_CONTACT_TYPE	VARCHAR2(7)	VARCHAR2(7)	Process Manager Contact Type
PROCESS_MANAGER_FIRST_NAME	VARCHAR2(50)	VARCHAR2(50)	Process Manager First Name
PROCESS_MANAGER_MIDDLE_NAME	VARCHAR2(50)	VARCHAR2(50)	Process Manager Middle Name
PROCESS_MANAGER_NAME	VARCHAR2(250)	VARCHAR2(250)	Process Manager Name
EVENT	VARCHAR2(250)	VARCHAR2(250)	Event
RECIPIENT_CONTACT_PK	NUMBER	INT	Recipient Contact Primary Key
RECIPIENT_CONTACT_TYPE	VARCHAR2(7)	VARCHAR2(7)	Recipient Contact Type
RECIPIENT_FIRST_NAME	VARCHAR2(50)	VARCHAR2(50)	Recipient First Name
RECIPIENT_MIDDLE_NAME	VARCHAR2(50)	VARCHAR2(50)	Recipient Middle Name
RECIPIENT_NAME	VARCHAR2(250)	VARCHAR2(250)	Recipient Name
VERSION	NUMBER	INT	Version
CREATED_ON	DATE	DATETIME	Created On
CREATED_BY_CONTACT_PK	NUMBER	INT	Created By Contact Primary Key
CREATED_BY_CONTACT_TYPE	VARCHAR2(7)	VARCHAR2(7)	Created By Contact Type
CREATED_BY_CONTACT_NAME	VARCHAR2(250)	VARCHAR2(250)	Created By Contact Name
CREATED_BY_CONTACT_MIDDLE_NAME	VARCHAR2(50)	VARCHAR2(50)	Created By Contact Middle Name
CREATED_BY_CONTACT_FIRST_NAME	VARCHAR2(50)	VARCHAR2(50)	Created By Contact First Name
MODIFIED_ON	DATE	DATETIME	Modified On
MODIFIED_BY_CONTACT_PK	NUMBER	INT	Modified By Contact Pk
MODIFIED_BY_CONTACT_TYPE	VARCHAR2(7)	VARCHAR2(7)	Modified By Contact Type
MODIFIED_BY_CONTACT_NAME	VARCHAR2(250)	VARCHAR2(250)	Modified By Contact Name
MODIFIED_BY_CONTACT_MID_NAME	VARCHAR2(50)	VARCHAR2(50)	Modified By Contact Mid Name
MODIFIED_BY_CONTACT_FIRST_NAME	VARCHAR2(50)	VARCHAR2(50)	Modified By Contact First Name

WH_ACCOUNT_WORKFLOW_REVIEW

Column Name	Oracle Data Type	MSSQL Data Type	Friendly Name Column
ACCOUNT_PRIMARY_KEY	NUMBER	INT	Account Primary Key
ACCOUNT_NAME	VARCHAR2(250)	VARCHAR2(250)	Account Name
ACCOUNT_TYPE	VARCHAR2(7)	VARCHAR2(7)	Account Type
ACCOUNT_OVERDRAFT_TYPE	VARCHAR2(30)	VARCHAR2(30)	Account Overdraft Type
ACCOUNT_PERIOD_START_ON_DATE	DATE	DATETIME	Account Period Start On Date
ACCOUNT_PERIOD_END_ON_DATE	DATE	DATETIME	Account Period End On Date
ACCOUNT_STATUS	VARCHAR2(8)	VARCHAR2(8)	Account Status
ACCOUNT_ALLOW_POSTING	VARCHAR2(1)	VARCHAR2(1)	Account Allow Posting
ACCOUNT_ALLOCATION_LIMIT	NUMBER	DECIMAL(28,12)	Account Allocation Limit
ACCOUNT_TOTAL_ALLOCATED	NUMBER	DECIMAL(28,12)	Account Total Allocated
ACCOUNT_TOTAL_USED	NUMBER	DECIMAL(28,12)	Account Total Used
ACCOUNT_BALANCE	NUMBER	DECIMAL(28,12)	Account Balance
PARENT_ACCOUNT_PRIMARY_KEY	NUMBER	INT	Parent Account Primary Key
PARENT_ACCOUNT_NAME	VARCHAR2(250)	VARCHAR2(250)	Parent Account Name
WORKFLOW_PRIMARY_KEY	NUMBER	INT	Workflow Primary Key
REQUEST_NAME	VARCHAR2(50)	VARCHAR2(50)	Request Name
RULE_SHORT_DESCRIPTION	VARCHAR2(250 CHAR)	VARCHAR2(250 CHAR)	Rule Short Description
REQUESTED_BY_CONTACT_PK	NUMBER	INT	Requested By Contact Primary Key
REQUESTED_BY_CONTACT_TYPE	VARCHAR2(7)	VARCHAR2(7)	Requested By Contact Type
REQUESTED_BY_FIRST_NAME	VARCHAR2(50)	VARCHAR2(50)	Requested By First Name
REQUESTED_BY_MIDDLE_NAME	VARCHAR2(50)	VARCHAR2(50)	Requested By Middle Name
REQUESTED_BY_NAME	VARCHAR2(250)	VARCHAR2(250)	Requested By Name
REQUESTED_ON	DATE	DATETIME	Requested On
COMPLETED_ON	DATE	DATETIME	Completed On
WORKFLOW_STATUS	VARCHAR2(30)	VARCHAR2(30)	Workflow Status
EXPIRES_ON	DATE	DATETIME	Expires On
CURRENT_STOP_NO	NUMBER	INT	Current Stop Number
PROCESS_MANAGER_CONTACT_PK	NUMBER	INT	Process Manager Contact Primary Key
PROCESS_MANAGER_CONTACT_TYPE	VARCHAR2(7)	VARCHAR2(7)	Process Manager Contact Type
PROCESS_MANAGER_FIRST_NAME	VARCHAR2(50)	VARCHAR2(50)	Process Manager First Name
PROCESS_MANAGER_MIDDLE_NAME	VARCHAR2(50)	VARCHAR2(50)	Process Manager Middle Name
PROCESS_MANAGER_NAME	VARCHAR2(250)	VARCHAR2(250)	Process Manager Name
STOP_PRIMARY_KEY	NUMBER	INT	Stop Primary Key
STOP	NUMBER	INT	Stop
STOP_MEMBER_PRIMARY_KEY	NUMBER	INT	Stop Member Primary Key
STOP_STATUS	VARCHAR2(40)	VARCHAR2(40)	Stop Status
EMAIL_SENT	VARCHAR2(3)	VARCHAR2(3)	Email Sent
REVIEW_PRIMARY_KEY	NUMBER	INT	Review Primary Key
REVIEW_PERFORMER_CONTACT_PK	NUMBER	INT	Review Performer Contact Primary Key
REVIEW_PERFORMER_CONTACT_TYPE	VARCHAR2(7)	VARCHAR2(7)	Review Performer Contact Type
REVIEW_PERFORMER_FIRST_NAME	VARCHAR2(50)	VARCHAR2(50)	Review Performer First Name
REVIEW_PERFORMER_MIDDLE_NAME	VARCHAR2(50)	VARCHAR2(50)	Review Performer Middle Name
REVIEW_PERFORMER_NAME	VARCHAR2(250)	VARCHAR2(250)	Review Performer Name
REVIEW_STATUS	VARCHAR2(20)	VARCHAR2(20)	Review Status
REVIEW_ACTION_DATE	DATE	DATETIME	Review Action Date
REVIEW_APPROVAL_COMMENT	VARCHAR2(250)	VARCHAR2(250)	Review Approval Comment
REVIEW_REQUEST_COMMENT	VARCHAR2(250)	VARCHAR2(250)	Review Request Comment
CREATED_ON	DATE	DATETIME	Created On
CREATED_BY_CONTACT_PK	NUMBER	INT	Created By Contact Primary Key
CREATED_BY_CONTACT_TYPE	VARCHAR2(7)	VARCHAR2(7)	Created By Contact Type
CREATED_BY_CONTACT_NAME	VARCHAR2(250)	VARCHAR2(250)	Created By Contact Name
CREATED_BY_CONTACT_MIDDLE_NAME	VARCHAR2(50)	VARCHAR2(50)	Created By Contact Middle Name
CREATED_BY_CONTACT_FIRST_NAME	VARCHAR2(50)	VARCHAR2(50)	Created By Contact First Name
MODIFIED_ON	DATE	DATETIME	Modified On
MODIFIED_BY_CONTACT_PK	NUMBER	INT	Modified By Contact Primary Key
MODIFIED_BY_CONTACT_TYPE	VARCHAR2(7)	VARCHAR2(7)	Modified By Contact Type
MODIFIED_BY_CONTACT_NAME	VARCHAR2(250)	VARCHAR2(250)	Modified By Contact Name
MODIFIED_BY_CONTACT_MID_NAME	VARCHAR2(50)	VARCHAR2(50)	Modified By Contact Mid Name
MODIFIED_BY_CONTACT_FIRST_NAME	VARCHAR2(50)	VARCHAR2(50)	Modified By Contact First Name