ReportDetails
The table below describes the ReportDetails table.
This table contains the following virtual table:
None of the columns in this table are updatable.
This table contains the following foldable column:
- Report_ID
| Column Name | SQL Type | Nullable |
|---|---|---|
|
Report_ID Primary Key |
SQL_VARCHAR(128) | False |
|
Amount_Due_Company_Card |
SQL_VARCHAR(32) | False |
|
Amount_Due_Employee |
SQL_VARCHAR(32) | False |
|
Approval_Status_Code |
SQL_VARCHAR(32) | False |
|
Approval_Status_Name |
SQL_VARCHAR(128) | False |
|
Country |
SQL_VARCHAR(16) | True |
|
Country_Subdivision |
SQL_VARCHAR(16) | True |
|
Creation_Date |
SQL_TIMESTAMP | True |
|
Currency_Code |
SQL_VARCHAR(16) | False |
|
Custom_10_Code |
SQL_VARCHAR(1024) | True |
|
Custom_10_Type |
SQL_VARCHAR(1024) | True |
|
Custom_10_Value |
SQL_VARCHAR(1024) | True |
|
Custom_11_Code |
SQL_VARCHAR(1024) | True |
|
Custom_11_Type |
SQL_VARCHAR(1024) | True |
|
Custom_11_Value |
SQL_VARCHAR(1024) | True |
|
Custom_12_Code |
SQL_VARCHAR(1024) | True |
|
Custom_12_Type |
SQL_VARCHAR(1024) | True |
|
Custom_12_Value |
SQL_VARCHAR(1024) | True |
|
Custom_13_Code |
SQL_VARCHAR(1024) | True |
|
Custom_13_Type |
SQL_VARCHAR(1024) | True |
|
Custom_13_Value |
SQL_VARCHAR(1024) | True |
|
Custom_14_Code |
SQL_VARCHAR(1024) | True |
|
Custom_14_Value |
SQL_VARCHAR(1024) | True |
|
Custom_15_Code |
SQL_VARCHAR(1024) | True |
|
Custom_15_List_Item_Id |
SQL_VARCHAR(1024) | True |
|
Custom_15_Type |
SQL_VARCHAR(1024) | True |
|
Custom_15_Value |
SQL_VARCHAR(1024) | True |
|
Custom_16_Code |
SQL_VARCHAR(1024) | True |
|
Custom_16_Type |
SQL_VARCHAR(1024) | True |
|
Custom_16_Value |
SQL_VARCHAR(1024) | True |
|
Custom_17_Code |
SQL_VARCHAR(1024) | True |
|
Custom_17_Type |
SQL_VARCHAR(1024) | True |
|
Custom_17_Value |
SQL_VARCHAR(1024) | True |
|
Custom_18_Code |
SQL_VARCHAR(1024) | True |
|
Custom_18_Type |
SQL_VARCHAR(1024) | True |
|
Custom_18_Value |
SQL_VARCHAR(1024) | True |
|
Custom_19_Code |
SQL_VARCHAR(1024) | True |
|
Custom_19_Type |
SQL_VARCHAR(1024) | True |
|
Custom_19_Value |
SQL_VARCHAR(1024) | True |
|
Custom_1_Code |
SQL_VARCHAR(1024) | True |
|
Custom_1_Type |
SQL_VARCHAR(1024) | True |
|
Custom_1_Value |
SQL_VARCHAR(1024) | True |
|
Custom_20_Code |
SQL_VARCHAR(1024) | True |
|
Custom_20_Type |
SQL_VARCHAR(1024) | True |
|
Custom_20_Value |
SQL_VARCHAR(1024) | True |
|
Custom_2_Code |
SQL_VARCHAR(1024) | True |
|
Custom_2_Type |
SQL_VARCHAR(1024) | True |
|
Custom_2_Value |
SQL_VARCHAR(1024) | True |
|
Custom_3_Code |
SQL_VARCHAR(1024) | True |
|
Custom_3_Type |
SQL_VARCHAR(1024) | True |
|
Custom_3_Value |
SQL_VARCHAR(1024) | True |
|
Custom_4_Code |
SQL_VARCHAR(1024) | True |
|
Custom_4_Type |
SQL_VARCHAR(1024) | True |
|
Custom_4_Value |
SQL_VARCHAR(1024) | True |
|
Custom_5_Code |
SQL_VARCHAR(1024) | True |
|
Custom_5_Type |
SQL_VARCHAR(1024) | True |
|
Custom_5_Value |
SQL_VARCHAR(1024) | True |
|
Custom_6_Code |
SQL_VARCHAR(1024) | True |
|
Custom_6_Type |
SQL_VARCHAR(1024) | True |
|
Custom_6_Value |
SQL_VARCHAR(1024) | True |
|
Custom_7_Code |
SQL_VARCHAR(1024) | True |
|
Custom_7_Type |
SQL_VARCHAR(1024) | True |
|
Custom_7_Value |
SQL_VARCHAR(1024) | True |
|
Custom_8_Code |
SQL_VARCHAR(1024) | True |
|
Custom_8_Type |
SQL_VARCHAR(1024) | True |
|
Custom_8_Value |
SQL_VARCHAR(1024) | True |
|
Custom_9_Code |
SQL_VARCHAR(1024) | True |
|
Custom_9_Type |
SQL_VARCHAR(1024) | True |
|
Custom_9_Value |
SQL_VARCHAR(1024) | True |
|
Employee_Bank_Account_Account_Name |
SQL_VARCHAR(128) | True |
|
Employee_Bank_Account_Account_Number |
SQL_VARCHAR(100) | True |
|
Employee_Bank_Account_Bank_Name |
SQL_VARCHAR(48) | True |
|
Employee_Bank_Account_Bank_Number |
SQL_VARCHAR(11) | True |
|
Employee_Bank_Account_Branch_Location |
SQL_VARCHAR(30) | True |
|
Employee_Bank_Account_Postal_Address_City |
SQL_VARCHAR(24) | True |
|
Employee_Bank_Account_Postal_Address_Code |
SQL_VARCHAR(20) | True |
|
Employee_Bank_Account_Postal_Address_Country |
SQL_VARCHAR(20) | True |
|
Employee_Bank_Account_Postal_Address_Line_1 |
SQL_VARCHAR(48) | True |
|
Employee_Bank_Account_Postal_Address_Line_2 |
SQL_VARCHAR(48) | True |
|
Employee_Bank_Account_Postal_Address_Region |
SQL_VARCHAR(20) | True |
|
Employee_Name |
SQL_VARCHAR(128) | False |
|
Ever_Sent_Back |
SQL_VARCHAR(1) | True |
|
Has_Exception |
SQL_VARCHAR(1) | True |
|
Ledger_Name |
SQL_VARCHAR(128) | True |
|
Org_Unit_1 |
SQL_VARCHAR(128) | False |
|
Org_Unit_2 |
SQL_VARCHAR(128) | False |
|
Org_Unit_3 |
SQL_VARCHAR(128) | False |
|
Org_Unit_4 |
SQL_VARCHAR(128) | False |
|
Org_Unit_5 |
SQL_VARCHAR(128) | False |
|
Org_Unit_6 |
SQL_VARCHAR(128) | False |
|
Paid_Date |
SQL_TIMESTAMP | True |
|
Payment_Status_Code |
SQL_VARCHAR(32) | False |
|
Payment_Status_Name |
SQL_VARCHAR(128) | False |
|
Personal_Expenses |
SQL_VARCHAR(32) | False |
|
Policy_ID |
SQL_VARCHAR(128) | True |
|
Processing_Payment_Date |
SQL_VARCHAR(32) | True |
|
Purpose |
SQL_VARCHAR(1024) | False |
|
Receipts_Received |
SQL_VARCHAR(1) | True |
|
ReportDate |
SQL_TIMESTAMP | True |
|
Report_Key |
SQL_VARCHAR(32) | False |
|
Report_Name |
SQL_VARCHAR(128) | False |
|
Report_Owner_Employee_Custom_21 |
SQL_VARCHAR(48) | True |
|
Report_Owner_Employee_ID |
SQL_VARCHAR(48) | True |
|
Report_Owner_Employee_Org_Unit_1 |
SQL_VARCHAR(48) | True |
|
Report_Owner_Employee_Org_Unit_2 |
SQL_VARCHAR(48) | True |
|
Report_Owner_Employee_Org_Unit_3 |
SQL_VARCHAR(48) | True |
|
Report_Owner_Employee_Org_Unit_4 |
SQL_VARCHAR(48) | True |
|
Report_Owner_Employee_Org_Unit_5 |
SQL_VARCHAR(48) | True |
|
Report_Owner_Employee_Org_Unit_6 |
SQL_VARCHAR(48) | True |
|
Report_Owner_First_Name |
SQL_VARCHAR(32) | True |
|
Report_Owner_Last_Name |
SQL_VARCHAR(32) | True |
|
Report_Owner_Middle_Initial |
SQL_VARCHAR(1) | True |
|
Report_Owner_Reimbursement_Method_Code |
SQL_VARCHAR(1) | True |
|
Report_Total |
SQL_VARCHAR(32) | False |
|
Submit_Date |
SQL_TIMESTAMP | True |
|
Total_Approved_Amount |
SQL_VARCHAR(32) | False |
|
Total_Claimed_Amount |
SQL_VARCHAR(32) | False |
|
User_Login_ID |
SQL_VARCHAR(128) | False |
|
Workflow_Action_URL |
SQL_VARCHAR(1024) | True |