Invoice

WH_INVOICE

Column Name	Oracle Data Type	MSSQL Data Type	Friendly Column Name
INVOICE_PRIMARY_KEY	NUMBER	INT	Invoice Primary Key
INVOICE_NUMBER	VARCHAR2(50)	VARCHAR(50)	Invoice Number
INVOICE_DATE	DATE	DATETIME	Invoice Date
INVOICE_RECEIVED_DATE	DATE	DATETIME	Invoice Received Date
INVOICE_DEFAULT_CATEGORY	VARCHAR2(50)	VARCHAR(50)	Invoice Default Category
INVOICE_DEFAULT_CATEGORY_TREE	VARCHAR2(250)	VARCHAR(250)	Invoice Default Category Tree
VENDOR_CONTACT_PRIMARY_KEY	NUMBER	INT	Vendor Contact Primary Key
VENDOR_CONTACT_TYPE	VARCHAR2(10)	VARCHAR(10)	Vendor Contact Type
VENDOR_CONTACT_NAME	VARCHAR2(250)	VARCHAR(250)	Vendor Contact Name
VENDOR_CONTACT_MIDDLE_NAME	VARCHAR2(50)	VARCHAR(50)	Vendor Contact Middle Name
VENDOR_CONTACT_FIRST_NAME	VARCHAR2(50)	VARCHAR(50)	Vendor Contact First Name
INVOICE_CURRECNY_CODE	VARCHAR2(3)	VARCHAR(3)	Invoice Currecny Code
INVOICE_CURRENCY_NAME	VARCHAR2(50)	VARCHAR(50)	Invoice Currency Name
INVOICE_CURRENCY_SYMBOL	VARCHAR2(3)	VARCHAR(3)	Invoice Currency Symbol
INVOICE_MANUAL_AMOUNT	NUMBER	DECIMAL(28,12)	Invoice Manual Amount
INVOICE_ORIGINAL_FEES	NUMBER	DECIMAL(28,12)	Invoice Original Fees
INVOICE_ORIGINAL_EXPENSES	NUMBER	DECIMAL(28,12)	Invoice Original Expenses
INVOICE_ORIGINAL_LINEITEMS	NUMBER	DECIMAL(28,12)	Invoice Original Lineitems
INVOICE_DISCOUNTS_FEES	NUMBER	DECIMAL(28,12)	Invoice Discounts Fees
INVOICE_DISCOUNTS_EXPENSES	NUMBER	DECIMAL(28,12)	Invoice Discounts Expenses
INVOICE_DISCOUNTS_LINEITEMS	NUMBER	DECIMAL(28,12)	Invoice Discounts Lineitems
INVOICE_ADJUSTMENTS_FEES	NUMBER	DECIMAL(28,12)	Invoice Adjustments Fees
INVOICE_ADJUSTMENTS_EXPENSES	NUMBER	DECIMAL(28,12)	Invoice Adjustments Expenses
INVOICE_ADJUSTMENTS_LINEITEMS	NUMBER	DECIMAL(28,12)	Invoice Adjustments Lineitems
INVOICE_TAXES_FEES	NUMBER	DECIMAL(28,12)	Invoice Taxes Fees
INVOICE_TAXES_EXPENSES	NUMBER	DECIMAL(28,12)	Invoice Taxes Expenses
INVOICE_TAXES_LINEITEMS	NUMBER	DECIMAL(28,12)	Invoice Taxes Lineitems
INVOICE_TOTAL_FEES	NUMBER	DECIMAL(28,12)	Invoice Total Fees
INVOICE_TOTAL_EXPENSES	NUMBER	DECIMAL(28,12)	Invoice Total Expenses
INVOICE_TOTAL_LINEITEMS	NUMBER	DECIMAL(28,12)	Invoice Total Lineitems
INVOICE_PERIOD_START_ON	DATE	DATETIME	Invoice Period Start On
INVOICE_PERIOD_END_ON	DATE	DATETIME	Invoice Period End On
INVOICE_POSTING_STATUS	VARCHAR2(19)	VARCHAR(19)	Invoice Posting Status
INVOICE_COMMENTS	VARCHAR2(2000)	VARCHAR(2000)	Invoice Comments
INVOICE_EXCHANGE_RATE	NUMBER	DECIMAL(28,12)	Invoice Exchange Rate
INVOICE_TAX_RATE	NUMBER	DECIMAL(28,12)	Invoice Tax Rate
INVOICE_WARNINGS	VARCHAR2(2000)	VARCHAR(2000)	Invoice Warnings
INVOICE_IS_PERCENTAGE_DISCOUNT	VARCHAR2(3)	VARCHAR(3)	Invoice Is Percentage Discount
INVOICE_IS_ELECTRONIC	VARCHAR2(3)	VARCHAR(3)	Invoice Is Electronic
INVOICE_TYPE	VARCHAR2(20)	VARCHAR(20)	Invoice Type
INVOICE_REFERENCE NUMBER	VARCHAR2(50)	VARCHAR2(50)	Invoice Reference Number
DOCUMENT_FOLDER_PRIMARY_KEY	NUMBER	INT	Document Folder Primary Key
CREATED_ON	DATE	DATETIME	Created 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_ON	DATE	DATETIME	Modified On
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 Middle Name
MODIFIED_BY_CONTACT_FIRST_NAME	VARCHAR2(50)	VARCHAR(50)	Modified By Contact First Name
INVOICE_CURRENT_PRIMARY_KEY	NUMBER	INT	Invoice Current Primary Key
BEHALF_OF_CONTACT_PRIMARY_KEY	NUMBER	INT	Behalf Of Contact Primary Key
SECURITY	VARCHAR2(10)	VARCHAR(10)	Security
WORKFLOW_CURRENT_STATUS	VARCHAR2(15)	VARCHAR(15)	Workflow Current Status
WORKFLOW_CURRENT_ACTION	VARCHAR2(50)	VARCHAR(50)	Workflow Current Action
INVOICE_NOTES	CLOB	NTEXT	Invoice 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
INVOICE_HAS_NON_US_TAX	NVARCHAR2(3)	NVARCHAR(3)	Invoice Has Non US Tax
INVOICE_DATE_KEY	NUMBER	DATETIME	Invoice Date Key
INVOICE_RECEIVED_DATE_KEY	NUMBER	DATETIME	Invoice Received Date Key
INVOICE_PERIOD_START_ON_DT_KEY	NUMBER	DATETIME	Invoice Period Start On Date Key
INVOICE_PERIOD_END_ON_DATE_KEY	NUMBER	DATETIME	Invoice Period End On Date Key
CREATED_ON_DATE_KEY	NUMBER	DATETIME	Created On Date Key
MODIFIED_ON_DATE_KEY	NUMBER	DATETIME	Modified On Date Key
INVOICE_NONUSTAX_SUMMARY_LVL	NVARCHAR2(3)	NVARCHAR(3)	Invoice Non US tax Summary Level

WH_INVOICE_ADJUSTMENTS

Column Name	Oracle Data Type	MSSQL DATA TYPE	Friendly Column Name
INVOICE_PRIMARY_KEY	NUMBER	INT	Invoice Primary Key
INVOICE_NUMBER	VARCHAR2(50)	VARCHAR(50)	Invoice Number
INVOICE_DATE	DATE	DATETIME	Invoice Date
INVOICE_RECEIVED_DATE	DATE	DATETIME	Invoice Received Date
INVOICE_PERIOD_END_ON	DATE	DATETIME	Invoice Period End On
INVOICE_PERIOD_START_ON	DATE	DATETIME	Invoice Period Start On
ADJUSTMENT_PRIMARY_KEY	NUMBER	INT	Adjustment Primary Key
ADJUSTMENT_DATE	DATE	DATETIME	Adjustment Date
ADJUSTED_BY_CONTACT_TYPE	VARCHAR2(10)	VARCHAR(10)	Adjusted By Contact Type
ADJUSTED_BY_CONTACT_PK	NUMBER	INT	Adjusted By Contact Primary Key
ADJUSTED_BY_CONTACT_NAME	VARCHAR2(250)	VARCHAR(250)	Adjusted By Contact Name
ADJUSTED_BY_CONTACT_MID_NAME	VARCHAR2(50)	VARCHAR(50)	Adjusted By Contact Middle Name
ADJUSTED_BY_CONTACT_FIRST_NAME	VARCHAR2(50)	VARCHAR(50)	Adjusted By Contact First Name
ADJUSTMENT_REASON	VARCHAR2(50)	VARCHAR(50)	Adjustment Reason
ADJUSTMENT_TYPE	VARCHAR2(20)	VARCHAR(20)	Adjustment Type
ADJUSTMENT_TARGET	VARCHAR2(20)	VARCHAR(20)	Adjustment Target
ADJUSTMENT_TOTAL_EXPENSES	NUMBER	DECIMAL(28,12)	Adjustment Total Expenses
ADJUSTMENT_TOTAL_FEES	NUMBER	DECIMAL(28,12)	Adjustment Total Fees
ADJUSTMENT_TOTAL_INVOICE	NUMBER	DECIMAL(28,12)	Adjustment Total Invoice
COMMENT_TO_VENDOR	VARCHAR2(250)	VARCHAR(250)	Comment To Vendor
IN_HOUSE_COMMENT	VARCHAR2(250)	VARCHAR(250)	In House Comment
PREVIOUS_NET_TOTAL	NUMBER	DECIMAL(28,12)	Previous Net Total
SECURITY	VARCHAR2(10)	VARCHAR(10)	Security

WH_INVOICE_CAT_ADJUSTMENTS

Column Name	Oracle Data Type	MSSQL DATA TYPE	Friendly Column Name
INVOICE_PRIMARY_KEY	NUMBER	INT	Invoice Primary Key
INVOICE_NUMBER	VARCHAR2(50)	VARCHAR(50)	Invoice Number
INVOICE_DATE	DATE	DATETIME	Invoice Date
INVOICE_RECEIVED_DATE	DATE	DATETIME	Invoice Received Date
INVOICE_PERIOD_END_ON	DATE	DATETIME	Invoice Period End On
INVOICE_PERIOD_START_ON	DATE	DATETIME	Invoice Period Start On
PROJECT_UNIQUE_CODE	VARCHAR2(4)	VARCHAR(4)	Project Unique Code
PROJECT_OBJECT_TITLE	VARCHAR2(250)	VARCHAR(250)	Project Object Title
PREJECT_PRIMARY_KEY	NUMBER	INT	Project Primary Key
PROJECT_NUMBER	VARCHAR2(50)	VARCHAR(50)	Project Number
PROJECT_NAME	VARCHAR2(250)	VARCHAR(250)	Project Name
ADJUSTMENT_PRIMARY_KEY	NUMBER	INT	Adjustment Primary Key
ADJUSTMENT_DATE	DATE	DATETIME	Adjustment Date
ADJUSTED_BY_CONTACT_TYPE	VARCHAR2(10)	VARCHAR(10)	Adjusted By Contact Type
ADJUSTED_BY_CONTACT_PK	NUMBER	INT	Adjusted By Contact Primary Key
ADJUSTED_BY_CONTACT_NAME	VARCHAR2(250)	VARCHAR(250)	Adjusted By Contact Name
ADJUSTED_BY_CONTACT_MID_NAME	VARCHAR2(50)	VARCHAR(50)	Adjusted By Contact Middle Name
ADJUSTED_BY_CONTACT_FIRST_NAME	VARCHAR2(50)	VARCHAR(50)	Adjusted By Contact First Name
ADJUSTMENT_REASON	VARCHAR2(50)	VARCHAR(50)	Adjustment Reason
ADJUSTMENT_TYPE	VARCHAR2(20)	VARCHAR(20)	Adjustment Type
ADJUSTMENT_AMOUNT	NUMBER	INT	Adjustment Amount
ADJUSTMENT_TARGET	VARCHAR2(20)	VARCHAR(20)	Adjustment Target
ADJUSTMENT_TOTAL_EXPENSES	NUMBER	DECIMAL(28,12)	Adjustment Total Expenses
ADJUSTMENT_TOTAL_FEES	NUMBER	DECIMAL(28,12)	Adjustment Total Fees
ADJUSTMENT_TOTAL_INVOICE	NUMBER	DECIMAL(28,12)	Adjustment Total Invoice
ADJUSTMENT_CATEGORY	VARCHAR2(50)	VARCHAR(50)	Adjustment Category
ADJUSTMENT_CATEGORY_TREE	VARCHAR2(250)	VARCHAR(250)	Adjustment Category Tree
COMMENT_TO_VENDOR	VARCHAR2(250)	VARCHAR(250)	Comment To Vendor
IN_HOUSE_COMMENT	VARCHAR2(250)	VARCHAR(250)	In House Comment
PREVIOUS_NET_TOTAL	NUMBER	DECIMAL(28,12)	Previous Net Total
SECURITY	VARCHAR2(10)	VARCHAR(10)	Security

WH_INVOICE_DELTA

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

WH_INVOICE_CATEGORIES

Column Name	Oracle Data Type	MSSQL Data Type	Friendly Column Name
INVOICE_PRIMARY_KEY	NUMBER	INT	Invoice Primary Key
INVOICE_NUMBER	VARCHAR2(50)	VARCHAR(50)	Invoice Number
INVOICE_DATE	DATE	DATETIME	Invoice Date
INVOICE_RECEIVED_DATE	DATE	DATETIME	Invoice Received Date
INVOICE_PERIOD_END_ON	DATE	DATETIME	Invoice Period End On
INVOICE_PERIOD_START_ON	DATE	DATETIME	Invoice Period Start On
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 Category
SECURITY	VARCHAR2(10)	VARCHAR(10)	Security

WH_INVOICE_GROUP_ACCESS

Column Name	Oracle Data Type	MSSQL Data Type	Friendly Column Name
INVOICE_PRIMARY_KEY	NUMBER	INT	Invoice 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
OPERATION_IID	NUMBER	INT	Operation Identifier
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_INVOICE_LEVEL_TAX_TYPE

Column Name	Oracle Data Type	MSSQL Data Type	Friendly Column Name
INVOICE_PRIMARY_KEY	NUMBER	INT	Invoice Primary Key
INVOICE_NUMBER	VARCHAR2(50)	VARCHAR(50)	Invoice Number
INVOICE_DATE	DATE	DATETIME	Invoice Date
INVOICE_RECEIVED_DATE	DATE	DATETIME	Invoice Received Date
INVOICE_PERIOD_END_ON	DATE	DATETIME	Invoice Period End On
INVOICE_PERIOD_START_ON	DATE	DATETIME	Invoice Period Start On
TAX_PRIMARY_KEY	NUMBER	DECIMAL(28,12)	Tax Primary Key
TAX_DEFAULT_CURR_TAX_AMOUNT	NUMBER	DECIMAL(28,12)	Tax Default Current Tax Amount
TAX_TAX_AMOUNT	NUMBER	DECIMAL(28,12)	Tax Tax Amount
MATTER_TAXTYPE_TREEPOSITION	VARCHAR2(250)	VARCHAR(250)	Matter Taxtype Tree Position
MATTER_TAXTYPE	VARCHAR2(50)	VARCHAR(50)	Matter Taxtype
PROJECT_PRIMARY_KEY	NUMBER	DECIMAL(28,12)	Project Primary Key
PROJECT_NUMBER	VARCHAR2(50)	VARCHAR(50)	Project Number
PROJECT_NAME	VARCHAR2(250)	VARCHAR(250)	Project Name
PROJECT_UNIQUE_CODE	VARCHAR2(4)	VARCHAR(4)	Project Unique Code
PROJECT_OBJECT_TITLE	VARCHAR2(250)	VARCHAR(250)	Project Object Title
SECURITY	VARCHAR2(10)	VARCHAR(10)	Security

WH_INVOICE_NONUS_TAX

Column Name	Oracle Data Type	MSSQL Data Type	Friendly Column Name
INVOICE_PRIMARY_KEY	NUMBER	INT	Invoice Primary Key
INVOICE_NUMBER	VARCHAR2(50)	VARCHAR(50)	Invoice Number
PROJECT_PRIMARY_KEY	NUMBER	DECIMAL(28,12)	Project Primary Key
INVOICE_DATE	DATE	DATETIME	Invoice Date
INVOICE_RECEIVED_DATE	DATE	DATETIME	Invoice Received Date
PROJECT_NUMBER	VARCHAR2(50)	VARCHAR(50)	Project Number
PROJECT_OBJECT_TITLE	VARCHAR2(250)	VARCHAR(250)	Project Object Title
PROJECT_NAME	VARCHAR2(250)	VARCHAR(250)	Project Name
PROJECT_UNIQUE_CODE	VARCHAR2(4)	VARCHAR(4)	Project Unique Code
NONUS_TAX_PRIMARY_KEY	NUMBER	DECIMAL(28,12)	Nonus Tax Primary Key
NONUS_TAX_DEFAULT_AMOUNT	NUMBER	DECIMAL(28,12)	Nonus Tax Default Amount
NONUS_TAX_AMOUNT	NUMBER	DECIMAL(28,12)	Nonus Tax Amount
NONUS_TAX_TYPE	VARCHAR2(50)	VARCHAR(50)	Nonus Tax Type
SECURITY	VARCHAR2(10)	VARCHAR(10)	Security

WH_INVOICE_NONUS_TAX_RATE

Column Name	Oracle Data Type	MSSQL Data Type	Friendly Column Name
NONUS_TAX_RATE	NUMBER	DECIMAL(28,12)	Nonus Tax Rate
NONUS_TAX_TYPE	NVARCHAR2(50)	NVARCHAR(50)	Nonus Tax Type
NONUS_TAX_RATE_PRIMARY_KEY	NUMBER	INT	Nonus Tax Rate Primary Key
INVOICE_NUMBER	NVARCHAR2(50)	NVARCHAR(50)	Invoice Number
INVOICE_PRIMARY_KEY	NUMBER	INT	Invoice Primary Key
INVOICE_DATE	DATE	DATETIME	Invoice Date
SECURITY	NVARCHAR2(10)	NVARCHAR(10)	Security

WH_INVOICE_PROJECT_RELATIONS

Column Name	Oracle Data Type	MSSQL Data Type	Friendly Column Name
RELATION_NAME	VARCHAR2(50)	VARCHAR(50)	Relation Name
RELATION_TREE_POSITION	VARCHAR2(250)	VARCHAR(250)	Relation Tree Position
INVOICE_PRIMARY_KEY	NUMBER	DECIMAL(28,12)	Invoice Primary Key
INVOICE_NUMBER	VARCHAR2(50)	VARCHAR(50)	Invoice Number
PROJECT_PRIMARY_KEY	NUMBER	DECIMAL(28,12)	Project Primary Key
PROJECT_NUMBER	VARCHAR2(50)	VARCHAR(50)	Project Number
PROJECT_OBJECT_TITLE	VARCHAR2(250)	VARCHAR(250)	Project Object Title
PROJECT_NAME	VARCHAR2(250)	VARCHAR(250)	Project Name
PROJECT_UNIQUE_CODE	VARCHAR2(4)	VARCHAR(4)	Project Unique Code

WH_INVOICE_TIMEKPR_ADJUSTMENTS

Column Name	Oracle Data Type	MSSQL DATA TYPE	Friendly Column Name
INVOICE_PRIMARY_KEY	NUMBER	INT	Invoice Primary Key
INVOICE_NUMBER	VARCHAR2(50)	VARCHAR(50)	Invoice Number
INVOICE_DATE	DATE	DATETIME	Invoice Date
INVOICE_RECEIVED_DATE	DATE	DATETIME	Invoice Received Date
INVOICE_PERIOD_END_ON	DATE	DATETIME	Invoice Period End On
INVOICE_PERIOD_START_ON	DATE	DATETIME	Invoice Period Start On
PROJECT_PRIMARY_KEY	NUMBER	DECIMAL(28,12)	Project Primary Key
PROJECT_NUMBER	VARCHAR2(50)	VARCHAR(50)	Project Number
PROJECT_OBJECT_TITLE	VARCHAR2(250)	VARCHAR(250)	Project Object Title
PROJECT_NAME	VARCHAR2(250)	VARCHAR(250)	Project Name
PROJECT_UNIQUE_CODE	VARCHAR2(4)	VARCHAR(4)	Project Unique Code
ADJUSTMENT_PRIMARY_KEY	NUMBER	INT	Adjustment Primary Key
ADJUSTMENT_DATE	DATE	DATETIME	Adjustment Date
ADJUSTED_BY_CONTACT_TYPE	VARCHAR2(10)	VARCHAR(10)	Adjusted By Contact Type
ADJUSTED_BY_CONTACT_PK	NUMBER	INT	Adjusted By Contact Primary Key
ADJUSTED_BY_CONTACT_NAME	VARCHAR2(250)	VARCHAR(250)	Adjusted By Contact Name
ADJUSTED_BY_CONTACT_MID_NAME	VARCHAR2(50)	VARCHAR(50)	Adjusted By Contact Mid Name
ADJUSTED_BY_CONTACT_FIRST_NAME	VARCHAR2(50)	VARCHAR(50)	Adjusted By Contact First Name
ADJUSTMENT_REASON	VARCHAR2(50)	VARCHAR(50)	Adjustment Reason
ADJUSTMENT_TYPE	VARCHAR2(20)	VARCHAR(20)	Adjustment Type
ADJUSTMENT_AMOUNT	NUMBER	DECIMAL(28,12)	Adjustment Amount
TIMEKEEPER_CONTACT_TYPE	VARCHAR2(10)	VARCHAR(10)	Timekeeper Contact Type
TIMEKEEPER_CONTACT_PK	NUMBER	INT	Timekeeper Contact Primary Key
TIMEKEEPER_CONTACT_NAME	VARCHAR2(250)	VARCHAR(250)	Timekeeper Contact Name
TIMEKEEPER_CONTACT_MID_NAME	VARCHAR2(50)	VARCHAR(50)	Timekeeper Contact Middle Name
TIMEKEEPER_CONTACT_FIRST_NAME	VARCHAR2(50)	VARCHAR(50)	Timekeeper Contact First Name
COMMENT_TO_VENDOR	VARCHAR2(250)	VARCHAR(250)	Comment To Vendor
IN_HOUSE_COMMENT	VARCHAR2(250)	VARCHAR(250)	In House Comment
PREVIOUS_NET_TOTAL	NUMBER	DECIMAL(28,12)	Previous Net Total
SECURITY	VARCHAR2(10)	VARCHAR(10)	Security

WH_INVOICE_USER_ACCESS

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

WH_INVOICE_SECURITY

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

WH_INVOICE_WORKFLOW

Column Name	Oracle Data Type	MSSQL Data Type	Friendly Column Name
INVOICE_PRIMARY_KEY	NUMBER	INT	Invoice Primary Key
INVOICE_NUMBER	VARCHAR2(50)	VARCHAR(50)	Invoice Number
INVOICE_DATE	DATE	DATETIME	Invoice Date
INVOICE_RECEIVED_DATE	DATE	DATETIME	Invoice Received Date
INVOICE_PERIOD_END_ON	DATE	DATETIME	Invoice Period End On
INVOICE_PERIOD_START_ON	DATE	DATETIME	Invoice Period Start On
WORKFLOW_PRIMARY_KEY	NUMBER	INT	Workflow Primary Key
REQUEST_NAME	VARCHAR2(50)	VARCHAR(50)	Request Name
RULE_SHORT_DESCRIPTION	VARCHAR2(250)	VARCHAR(250)	Rule Short Description
REQUESTED_BY_CONTACT_PK	NUMBER	INT	Requested By Contact Primary Key
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_BY_CONTACT_TYPE	VARCHAR2(7)	VARCHAR(7)	Requested By Contact Type
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_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_INVOICE_WORKFLOW_HISTORY

Column Name	Oracle Data Type	MSSQL Data Type	Friendly Column Name
INVOICE_PRIMARY_KEY	NUMBER	INT	Invoice Primary Key
INVOICE_NUMBER	VARCHAR2(50)	VARCHAR(50)	Invoice Number
INVOICE_DATE	DATE	DATETIME	Invoice Date
INVOICE_RECEIVED_DATE	DATE	DATETIME	Invoice Received Date
INVOICE_PERIOD_END_ON	DATE	DATETIME	Invoice Period End On
INVOICE_PERIOD_START_ON	DATE	DATETIME	Invoice Period Start On
WORKFLOW_PRIMARY_KEY	NUMBER	INT	Workflow Primary Key
REQUEST_NAME	VARCHAR2(50)	VARCHAR(50)	Request Name
RULE_SHORT_DESCRIPTION	VARCHAR2(250)	VARCHAR(250)	Rule Short Description
REQUESTED_BY_CONTACT_PK	NUMBER	INT	Requested By Contact Primary Key
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_BY_CONTACT_TYPE	VARCHAR2(7)	VARCHAR(7)	Requested By Contact Type
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_INVOICE_WORKFLOW_RECIPIENT

Column Name	Oracle Data Type	MSSQL Data Type	Friendly Column Name
INVOICE_PRIMARY_KEY	NUMBER	INT	Invoice Primary Key
INVOICE_NUMBER	VARCHAR2(50)	VARCHAR(50)	Invoice Number
INVOICE_DATE	DATE	DATETIME	Invoice Date
INVOICE_RECEIVED_DATE	DATE	DATETIME	Invoice Received Date
INVOICE_PERIOD_END_ON	DATE	DATETIME	Invoice Period End On
INVOICE_PERIOD_START_ON	DATE	DATETIME	Invoice Period Start On
WORKFLOW_PRIMARY_KEY	NUMBER	INT	Workflow Primary Key
REQUEST_NAME	VARCHAR2(50)	VARCHAR(50)	Request Name
RULE_SHORT_DESCRIPTION	VARCHAR2(250)	VARCHAR(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
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)	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
EVENT	VARCHAR2(20)	VARCHAR2(20)	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 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_FIRST_NAME	VARCHAR2(50)	VARCHAR2(50)	Modified By Contact First Name
MODIFIED_BY_CONTACT_MID_NAME	VARCHAR2(50)	VARCHAR2(50)	Modified By Contact Middle Name

WH_INVOICE_WORKFLOW_REVIEW

Column Name	Oracle Data Type	MSSQL Data Type	Friendly Column Name
INVOICE_PRIMARY_KEY	NUMBER	INT	Invoice Primary Key
INVOICE_NUMBER	VARCHAR2(50)	VARCHAR(50)	Invoice Number
INVOICE_DATE	DATE	DATETIME	Invoice Date
INVOICE_RECEIVED_DATE	DATE	DATETIME	Invoice Received Date
INVOICE_PERIOD_END_ON	DATE	DATETIME	Invoice Period End On
INVOICE_PERIOD_START_ON	DATE	DATETIME	Invoice Period Start On
WORKFLOW_PRIMARY_KEY	NUMBER	INT	Workflow Primary Key
RULE_SHORT_DESCRIPTION	VARCHAR2(250)	VARCHAR(250)	Rule Short Description
REQUEST_NAME	VARCHAR2(50)	VARCHAR(50)	Request Name
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
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)	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_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)	VARCHAR(40)	Stop Status
EMAIL_SENT	VARCHAR2(3)	VARCHAR(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)	VARCHAR(7)	Review Performer Contact Type
REVIEW_PERFORMER_FIRST_NAME	VARCHAR2(50)	VARCHAR(50)	Review Performer First Name
REVIEW_PERFORMER_MIDDLE_NAME	VARCHAR2(50)	VARCHAR(50)	Review Performer Middle Name
REVIEW_PERFORMER_NAME	VARCHAR2(250)	VARCHAR(250)	Review Performer Name
REVIEW_STATUS	VARCHAR2(20)	VARCHAR(20)	Review Status
REVIEW_ACTION_DATE	DATE	DATETIME	Review Action Date
REVIEW_APPROVAL_COMMENT	VARCHAR2(2000)	VARCHAR(2000)	Review Approval Comment
REVIEW_REQUEST_COMMENT	VARCHAR2(2000)	VARCHAR(2000)	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)	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
MODIFIED_ON	DATE	DATETIME	Modified On
MODIFIED_BY_CONTACT_PK	NUMBER	INT	Modified By Contact Primary Key
MODIFIED_BY_CONTACT_TYPE	VARCHAR2(7)	VARCHAR(7)	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 Middle Name
MODIFIED_BY_CONTACT_FIRST_NAME	VARCHAR2(50)	VARCHAR(50)	Modified By Contact First Name