Expense
The system object Expense tables include:
- WH_EXPENSE
- WH_EXPENSE_GROUP_ACCESS*
- WH_EXPENSE_USER_ACCESS*
- WH_EXPENSE_SECURITY
- WH_EXPENSE_WORKFLOW
- WH_EXPENSE_WORKFLOW_HISTORY
- WH_EXPENSE_WORKFLOW_RECIPIENT
- WH_EXPENSE_WORKFLOW_REVIEW
* These tables support the user access and security feature and should not be queried directly.
WH_EXPENSE
|
Column Name |
Oracle Data Type |
MSSQL Data Type |
Friendly Column Name |
|---|---|---|---|
|
EXPENSE_PRIMARY_KEY |
NUMBER |
INT |
Expense Primary Key |
|
EXPENSE_DESCRIPTION |
VARCHAR2(250) |
VARCHAR(250) |
Expense Description |
|
EXPENSE_DATE |
DATE |
DATETIME |
Expense Date |
|
EXPENSE_QUANTITY |
NUMBER |
DECIMAL(28,12) |
Expense Quantity |
|
EXPENSE_UNIT_PRICE |
NUMBER |
DECIMAL(28,12) |
Expense Unit Price |
|
EXPENSE_TOTAL_AMOUNT |
NUMBER |
DECIMAL(28,12) |
Expense Total Amount |
|
EXPENSE_POSTING_STATUS |
VARCHAR2(20) |
VARCHAR(20) |
Expense Posting Status |
|
EXPENSED_BY_CONTACT_PK |
NUMBER |
INT |
Expensed By Contact Primary Key |
|
EXPENSED_BY_CONTACT_TYPE |
VARCHAR2(10) |
VARCHAR(10) |
Expensed By Contact Type |
|
EXPENSED_BY_FIRST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
Expensed By First Name |
|
EXPENSED_BY_MIDDLE_NAME |
VARCHAR2(50) |
VARCHAR(50) |
Expensed By Middle Name |
|
EXPENSED_BY_NAME |
VARCHAR2(250) |
VARCHAR(250) |
Expensed By Name |
|
EXPENSE_CATEGORY |
VARCHAR2(50) |
VARCHAR(50) |
Expense Category |
|
EXPENSE_CATEGORY_TREE_POSITION |
VARCHAR2(250) |
VARCHAR(250) |
Expense Category Tree Position |
|
EXPENSE_CONTACT_PRIMARY_KEY |
NUMBER |
INT |
Expense Contact Primary Key |
|
EXPENSE_CONTACT_TYPE |
VARCHAR2(10) |
VARCHAR(10) |
Expense Contact Type |
|
EXPENSE_CONTACT_FIRST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
Expense Contact First Name |
|
EXPENSE_CONTACT_MIDDLE_NAME |
VARCHAR2(50) |
VARCHAR(50) |
Expense Contact Middle Name |
|
EXPENSE_CONTACT_NAME |
VARCHAR2(250) |
VARCHAR(250) |
Expense Contact Name |
|
PROJECT_UNIQUE_CODE |
VARCHAR2(4) |
VARCHAR(4) |
Project Unique Code |
|
PROJECT_OBJECT_TITLE |
VARCHAR2(250) |
VARCHAR(250) |
Project Object Title |
|
PROJECT_PRIMARY_KEY |
NUMBER |
INT |
Project Primary Key |
|
PROJECT_NAME |
VARCHAR2(250) |
VARCHAR(250) |
Project Name |
|
PROJECT_NUMBER |
VARCHAR2(50) |
VARCHAR(50) |
Project Number |
|
PROJECT_DEFAULT_CATEGORY |
VARCHAR2(50) |
VARCHAR(50) |
Project Default Category |
|
DOCUMENT_FOLDER_PRIMARY_KEY |
NUMBER |
INT |
Document Folder Primary Key |
|
CREATED_ON |
DATE |
DATETIME |
Created On |
|
MODIFIED_ON |
DATE |
DATETIME |
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 |
|
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 |
|
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 Perfrmr Contact Primary Key |
|
LAST_PERFRMR_NAME |
VARCHAR2(250) |
VARCHAR(250) |
Last Perfrmr Name |
|
LAST_PERFRMR_FIRST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
Last Perfrmr First Name |
|
LAST_PERFRMR_MIDDLE_NAME |
VARCHAR2(50) |
VARCHAR(50) |
Last Perfrmr Middle Name |
|
LAST_PERFRMR_TYPE |
VARCHAR2(7) |
VARCHAR(7) |
Last Perfrmr Type |
|
MULTIPLE_APPROVERS |
VARCHAR2(3) |
VARCHAR(3) |
Multiple Approvers |
|
EXPENSE_DATE_KEY |
NUMBER |
DATETIME |
Expense Date Key |
|
CREATED_ON_DATE_KEY |
NUMBER |
DATETIME |
Created On Date Key |
|
MODIFIED_ON_DATE_KEY |
NUMBER |
DATETIME |
Modified On Date Key |
WH_EXPENSE_GROUP_ACCESS
|
Column Name |
Oracle Data Type |
MSSQL Data Type |
Friendly Column Name |
|---|---|---|---|
|
EXPENSE_PRIMARY_KEY |
NUMBER |
INT |
Expense 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_EXPENSE_USER_ACCESS
|
Column Name |
Oracle Data Type |
MSSQL Data Type |
Friendly Column Name |
|---|---|---|---|
|
EXPENSE_PRIMARY_KEY |
NUMBER |
INT |
Expense 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 |
|
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_EXPENSE_SECURITY
|
Column Name |
Oracle Data Type |
MSSQL Data Type |
Friendly Column Name |
|---|---|---|---|
|
EXPENSE_PRIMARY_KEY |
NUMBER |
INT |
Expense Primary Key |
|
CREATED_BY_CONTACT_PK |
NUMBER |
INT |
Created By Contact Primary Key |
|
SECURITY |
NVARCHAR2(10) |
NVARCHAR(10) |
Security |
WH_EXPENSE_WORKFLOW
|
Column Name |
Oracle Data Type |
MSSQL Data Type |
Column Name |
|---|---|---|---|
|
EXPENSE_PRIMARY_KEY |
NUMBER |
INT |
Expense Primary Key |
|
EXPENSE_DATE |
DATE |
DATETIME |
Expense Date |
|
EXPENSE_DESCRIPTION |
VARCHAR2(250) |
VARCHAR(250) |
Expense Description |
|
EXPENSE_POSTING_STATUS |
VARCHAR2(19) |
VARCHAR(19) |
Expense Posting Status |
|
EXPENSED_BY_CONTACT_PK |
NUMBER |
INT |
Expensed By Contact Primary Key |
|
EXPENSED_BY_FIRST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
Expensed By First Name |
|
EXPENSED_BY_NAME |
VARCHAR2(250) |
VARCHAR(250) |
Expensed By Name |
|
EXPENSED_BY_MIDDLE_NAME |
VARCHAR2(50) |
VARCHAR(50) |
Expensed By Middle Name |
|
EXPENSED_BY_TYPE |
VARCHAR2(7) |
VARCHAR(7) |
Expensed By Type |
|
EXPENSE_CATEGORY |
VARCHAR2(50) |
VARCHAR(50) |
Expense Category |
|
PROJECT_UNIQUE_CODE |
VARCHAR2(4) |
VARCHAR(4) |
Project Unique Code |
|
PROJECT_OBJECT_TITLE |
VARCHAR2(250) |
VARCHAR(250) |
Project Object Title |
|
PROJECT_PRIMARY_KEY |
NUMBER |
INT |
Project Primary Key |
|
PROJECT_NUMBER |
VARCHAR2(50) |
VARCHAR(50) |
Project Number |
|
PROJECT_NAME |
VARCHAR2(250) |
VARCHAR(250) |
Project Name |
|
WORKFLOW_PRIMARY_KEY |
NUMBER |
INT |
Workflow Primary Key |
|
REQUEST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
Request Name |
| RULE_SHORT_DESCRIPTION | NVARCHAR2(250 CHAR) | 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 No |
|
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 Ke |
|
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 Mid 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_EXPENSE_WORKFLOW_HISTORY
|
Column Name |
Oracle Data Type |
MSSQL Data Type |
Friendly Column Name |
|---|---|---|---|
|
EXPENSE_PRIMARY_KEY |
NUMBER |
INT |
Expense Primary Key |
|
EXPENSE_DATE |
DATE |
DATETIME |
Expense Date |
|
EXPENSE_DESCRIPTION |
VARCHAR2(250) |
VARCHAR(250) |
Expense Description |
|
EXPENSE_POSTING_STATUS |
VARCHAR2(19) |
VARCHAR(19) |
Expense Posting Status |
|
EXPENSED_BY_CONTACT_PK |
NUMBER |
INT |
Expensed By Contact Primary Key |
|
EXPENSED_BY_FIRST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
Expensed By First Name |
|
EXPENSED_BY_NAME |
VARCHAR2(250) |
VARCHAR(250) |
Expensed By Name |
|
EXPENSED_BY_MIDDLE_NAME |
VARCHAR2(50) |
VARCHAR(50) |
Expensed By Middle Name |
|
EXPENSED_BY_TYPE |
VARCHAR2(7) |
VARCHAR(7) |
Expensed By Type |
|
EXPENSE_CATEGORY |
VARCHAR2(50) |
VARCHAR(50) |
Expense Category |
|
PROJECT_UNIQUE_CODE |
VARCHAR2(4) |
VARCHAR(4) |
Project Unique Code |
|
PROJECT_OBJECT_TITLE |
VARCHAR2(250) |
VARCHAR(250) |
Project Object Title |
|
PROJECT_PRIMARY_KEY |
NUMBER |
INT |
Project Primary Key |
|
PROJECT_NUMBER |
VARCHAR2(50) |
VARCHAR(50) |
Project Number |
|
PROJECT_NAME |
VARCHAR2(250) |
VARCHAR(250) |
Project 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 No |
|
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 |
|
ACTION_DATE |
DATE |
DATETIME |
Action Date |
|
INTERNAL_COMMENT |
VARCHAR2(2000) |
VARCHAR(2000) |
Internal Comment |
|
CREATED_BY_CONTACT_PK |
NUMBER |
INT |
Created By Contact Pk |
|
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 Pk |
|
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 |
|
MODIFIED_BY_CONTACT_TYPE |
VARCHAR2(7) |
VARCHAR(7) |
Modified By Contact Type |
|
MODIFIED_ON |
DATE |
DATETIME |
Modified On |
WH_EXPENSE_WORKFLOW_RECIPIENT
|
Column Name |
Oracle Data Type |
MSSQL Data Type |
Friendly Column Name |
|---|---|---|---|
|
EXPENSE_PRIMARY_KEY |
NUMBER |
INT |
Expense Primary Key |
|
EXPENSE_DATE |
DATE |
DATETIME |
Expense Date |
|
EXPENSE_DESCRIPTION |
VARCHAR2(250) |
VARCHAR(250) |
Expense Description |
|
EXPENSE_POSTING_STATUS |
VARCHAR2(19) |
VARCHAR(19) |
Expense Posting Status |
|
EXPENSED_BY_CONTACT_PK |
NUMBER |
INT |
Expensed By Contact Primary Key |
|
EXPENSED_BY_FIRST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
Expensed By First Name |
|
EXPENSED_BY_NAME |
VARCHAR2(250) |
VARCHAR(250) |
Expensed By Name |
|
EXPENSED_BY_MIDDLE_NAME |
VARCHAR2(50) |
VARCHAR(50) |
Expensed By Middle Name |
|
EXPENSED_BY_TYPE |
VARCHAR2(7) |
VARCHAR(7) |
Expensed By Type |
|
EXPENSE_CATEGORY |
VARCHAR2(50) |
VARCHAR(50) |
Expense Category |
|
PROJECT_UNIQUE_CODE |
VARCHAR2(4) |
VARCHAR(4) |
Project Unique Code |
|
PROJECT_OBJECT_TITLE |
VARCHAR2(250) |
VARCHAR(250) |
Project Object Title |
|
PROJECT_PRIMARY_KEY |
NUMBER |
INT |
Project Primary Key |
|
PROJECT_NUMBER |
VARCHAR2(50) |
VARCHAR(50) |
Project Number |
|
PROJECT_NAME |
VARCHAR2(250) |
VARCHAR(250) |
Project Name |
|
WORKFLOW_PRIMARY_KEY |
NUMBER |
INT |
Workflow Primary Key |
|
REQUEST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
Request Name |
| RULE_SHORT_DESCRIPTION | NVARCHAR2(250 CHAR) | 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 No |
|
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(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 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 |
WH_EXPENSE_WORKFLOW_REVIEW
|
Column Name |
Oracle Data Type |
MSSQL Data Type |
Friendly Column Name |
|---|---|---|---|
|
EXPENSE_PRIMARY_KEY |
NUMBER |
INT |
Expense Primary Key |
|
EXPENSE_DATE |
DATE |
DATETIME |
Expense Date |
|
EXPENSE_DESCRIPTION |
VARCHAR2(250) |
VARCHAR(250) |
Expense Description |
|
EXPENSE_POSTING_STATUS |
VARCHAR2(19) |
VARCHAR(19) |
Expense Posting Status |
|
EXPENSED_BY_CONTACT_PK |
NUMBER |
INT |
Expensed By Contact Primary Key |
|
EXPENSED_BY_FIRST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
Expensed By First Name |
|
EXPENSED_BY_NAME |
VARCHAR2(250) |
VARCHAR(250) |
Expensed By Name |
|
EXPENSED_BY_MIDDLE_NAME |
VARCHAR2(50) |
VARCHAR(50) |
Expensed By Middle Name |
|
EXPENSED_BY_TYPE |
VARCHAR2(7) |
VARCHAR(7) |
Expensed By Type |
|
EXPENSE_CATEGORY |
VARCHAR2(50) |
VARCHAR(50) |
Expense Category |
|
PROJECT_UNIQUE_CODE |
VARCHAR2(4) |
VARCHAR(4) |
Project Unique Code |
|
PROJECT_OBJECT_TITLE |
VARCHAR2(250) |
VARCHAR(250) |
Project Object Title |
|
PROJECT_PRIMARY_KEY |
NUMBER |
INT |
Project Primary Key |
|
PROJECT_NUMBER |
VARCHAR2(50) |
VARCHAR(50) |
Project Number |
|
PROJECT_NAME |
VARCHAR2(250) |
VARCHAR(250) |
Project Name |
|
WORKFLOW_PRIMARY_KEY |
NUMBER |
INT |
Workflow Primary Key |
|
REQUEST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
Request Name |
| RULE_SHORT_DESCRIPTION | NVARCHAR2(250 CHAR) | 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 No |
|
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 |
NVARCHAR2(2000 CHAR) |
VARCHAR(250) |
Review Approval Comment |
|
REVIEW_REQUEST_COMMENT |
NVARCHAR2(2000 CHAR) |
VARCHAR(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) |
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 Mid Name |
|
MODIFIED_BY_CONTACT_FIRST_NAME |
VARCHAR2(50) |
VARCHAR(50) |
Modified By Contact First Name |