ReportDetails_ExpenseEntry
The table below describes the ReportDetails_ExpenseEntry table.
This is a virtual table, and is linked to the ReportDetails table (see ReportDetails).
This table contains the following virtual table:
None of the columns in this table are updatable.
This table contains the following foldable columns:
- Report_Entry_ID
- Report_ID
- Approved_Amount
- Business_Purpose
- Card_Transaction_Account_Number
- Card_Transaction_Account_Number_Last_Segment
- Card_Transaction_Billing_Amount
- Card_Transaction_Card_Description
- Card_Transaction_Card_Type_Code
- Card_Transaction_Description
- Card_Transaction_Exchange_Rate_From_Billing_To_Employee_Currency
- Card_Transaction_Master_Card_Code
- Card_Transaction_Merchant_City
- Card_Transaction_Merchant_Country_Code
- Card_Transaction_Merchant_Reference_Number
- Card_Transaction_Merchant_State
- Card_Transaction_Posted_Alpha_Code
- Card_Transaction_Posted_Amount
- Card_Transaction_Posted_Date
- Card_Transaction_Tax_Amount
- Card_Transaction_Transaction_Alpha_Code
- Card_Transaction_Transaction_Amount
- Card_Transaction_Transaction_CCT_Type
- Card_Transaction_Transaction_Date
- Card_Transaction_Transaction_ID
- Card_Transaction_Transaction_Merchant_Name
- Card_Transaction_Transaction_Reference_Number
- CommentCount
- E_Receipt_ID
- Entry_Image_ID
- Exchange_Rate
- Expense_Pay
- Expense_Type_ID
- Expense_Type_Name
- Form_ID
- Has_Allocation
- Has_Attendees
- Has_Comments
- Has_Exceptions
- Has_Vat
- Image_Required
- Is_Credit_Card_Charge
- Is_Itemized
- Is_Personal
- Is_Personal_Card_Charge
- Last_Modified_Date
- LocationName
- Location_Country
- Location_Subdivision
- Org_Unit_1
- Org_Unit_2
- Org_Unit_3
- Org_Unit_4
- Org_Unit_5
- Org_Unit_6
- Payment_Type_Code
- Payment_Type_Name
- Posted_Amount
- Receipt_Required
- Report_Entry_Receipt_Received
- Report_Entry_Receipt_Type
- Report_Entry_Vendor_Name
- Spend_Category
- Transaction_Currency_Name
- Transaction_Date
- Vendor_Description
| Column Name | SQL Type | Nullable |
|---|---|---|
|
Report_Entry_ID Primary Key |
SQL_VARCHAR(128) | False |
|
Report_ID Primary Key Foreign Key linked to column Report_ID in ReportDetails table |
SQL_VARCHAR(128) | False |
|
Approved_Amount |
SQL_VARCHAR(23) | False |
|
Business_Purpose |
SQL_VARCHAR(64) | False |
|
Card_Transaction_Account_Number |
SQL_VARCHAR(255) | False |
|
Card_Transaction_Account_Number_Last_Segment |
SQL_VARCHAR(4) | False |
|
Card_Transaction_Billing_Amount |
SQL_VARCHAR(23) | False |
|
Card_Transaction_Card_Description |
SQL_VARCHAR(255) | False |
|
Card_Transaction_Card_Type_Code |
SQL_VARCHAR(255) | False |
|
Card_Transaction_Description |
SQL_VARCHAR(42) | False |
|
Card_Transaction_Exchange_Rate_From_Billing_To_Employee_Currency |
SQL_VARCHAR(23) | False |
|
Card_Transaction_Master_Card_Code |
SQL_VARCHAR(5) | False |
|
Card_Transaction_Merchant_City |
SQL_VARCHAR(40) | False |
|
Card_Transaction_Merchant_Country_Code |
SQL_VARCHAR(2) | False |
|
Card_Transaction_Merchant_Reference_Number |
SQL_VARCHAR(15) | False |
|
Card_Transaction_Merchant_State |
SQL_VARCHAR(32) | False |
|
Card_Transaction_Posted_Alpha_Code |
SQL_VARCHAR(3) | False |
|
Card_Transaction_Posted_Amount |
SQL_VARCHAR(23) | False |
|
Card_Transaction_Posted_Date |
SQL_TIMESTAMP | False |
|
Card_Transaction_Tax_Amount |
SQL_VARCHAR(3) | False |
|
Card_Transaction_Transaction_Alpha_Code |
SQL_VARCHAR(3) | False |
|
Card_Transaction_Transaction_Amount |
SQL_VARCHAR(23) | False |
|
Card_Transaction_Transaction_CCT_Type |
SQL_VARCHAR(3) | False |
|
Card_Transaction_Transaction_Date |
SQL_TIMESTAMP | False |
|
Card_Transaction_Transaction_ID |
SQL_VARCHAR(32) | False |
|
Card_Transaction_Transaction_Merchant_Name |
SQL_VARCHAR(50) | False |
|
Card_Transaction_Transaction_Reference_Number |
SQL_VARCHAR(64) | False |
|
CommentCount |
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_21_Code |
SQL_VARCHAR(1024) | True |
|
Custom_21_Type |
SQL_VARCHAR(1024) | True |
|
Custom_21_Value |
SQL_VARCHAR(1024) | True |
|
Custom_22_Code |
SQL_VARCHAR(1024) | True |
|
Custom_22_Type |
SQL_VARCHAR(1024) | True |
|
Custom_22_Value |
SQL_VARCHAR(1024) | True |
|
Custom_23_Code |
SQL_VARCHAR(1024) | True |
|
Custom_23_Type |
SQL_VARCHAR(1024) | True |
|
Custom_23_Value |
SQL_VARCHAR(1024) | True |
|
Custom_24_Code |
SQL_VARCHAR(1024) | True |
|
Custom_24_Type |
SQL_VARCHAR(1024) | True |
|
Custom_24_Value |
SQL_VARCHAR(1024) | True |
|
Custom_25_Code |
SQL_VARCHAR(1024) | True |
|
Custom_25_Type |
SQL_VARCHAR(1024) | True |
|
Custom_25_Value |
SQL_VARCHAR(1024) | True |
|
Custom_26_Code |
SQL_VARCHAR(1024) | True |
|
Custom_26_Type |
SQL_VARCHAR(1024) | True |
|
Custom_26_Value |
SQL_VARCHAR(1024) | True |
|
Custom_27_Code |
SQL_VARCHAR(1024) | True |
|
Custom_27_Type |
SQL_VARCHAR(1024) | True |
|
Custom_27_Value |
SQL_VARCHAR(1024) | True |
|
Custom_28_Code |
SQL_VARCHAR(1024) | True |
|
Custom_28_Type |
SQL_VARCHAR(1024) | True |
|
Custom_28_Value |
SQL_VARCHAR(1024) | True |
|
Custom_29_Code |
SQL_VARCHAR(1024) | True |
|
Custom_29_Type |
SQL_VARCHAR(1024) | True |
|
Custom_29_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_30_Code |
SQL_VARCHAR(1024) | True |
|
Custom_30_Type |
SQL_VARCHAR(1024) | True |
|
Custom_30_Value |
SQL_VARCHAR(1024) | True |
|
Custom_31_Code |
SQL_VARCHAR(1024) | True |
|
Custom_31_Type |
SQL_VARCHAR(1024) | True |
|
Custom_31_Value |
SQL_VARCHAR(1024) | True |
|
Custom_32_Code |
SQL_VARCHAR(1024) | True |
|
Custom_32_Type |
SQL_VARCHAR(1024) | True |
|
Custom_32_Value |
SQL_VARCHAR(1024) | True |
|
Custom_33_Code |
SQL_VARCHAR(1024) | True |
|
Custom_33_Type |
SQL_VARCHAR(1024) | True |
|
Custom_33_Value |
SQL_VARCHAR(1024) | True |
|
Custom_34_Code |
SQL_VARCHAR(1024) | True |
|
Custom_34_Type |
SQL_VARCHAR(1024) | True |
|
Custom_34_Value |
SQL_VARCHAR(1024) | True |
|
Custom_35_Code |
SQL_VARCHAR(1024) | True |
|
Custom_35_Type |
SQL_VARCHAR(1024) | True |
|
Custom_35_Value |
SQL_VARCHAR(1024) | True |
|
Custom_36_Code |
SQL_VARCHAR(1024) | True |
|
Custom_36_Type |
SQL_VARCHAR(1024) | True |
|
Custom_36_Value |
SQL_VARCHAR(1024) | True |
|
Custom_37_Code |
SQL_VARCHAR(1024) | True |
|
Custom_37_Type |
SQL_VARCHAR(1024) | True |
|
Custom_37_Value |
SQL_VARCHAR(1024) | True |
|
Custom_38_Code |
SQL_VARCHAR(1024) | True |
|
Custom_38_Type |
SQL_VARCHAR(1024) | True |
|
Custom_38_Value |
SQL_VARCHAR(1024) | True |
|
Custom_39_Code |
SQL_VARCHAR(1024) | True |
|
Custom_39_Type |
SQL_VARCHAR(1024) | True |
|
Custom_39_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_40_Code |
SQL_VARCHAR(1024) | True |
|
Custom_40_Type |
SQL_VARCHAR(1024) | True |
|
Custom_40_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 |
|
E_Receipt_ID |
SQL_VARCHAR(128) | False |
|
Entry_Image_ID |
SQL_VARCHAR(48) | False |
|
Exchange_Rate |
SQL_VARCHAR(23) | False |
|
Expense_Pay |
SQL_VARCHAR(1) | False |
|
Expense_Type_ID |
SQL_VARCHAR(128) | False |
|
Expense_Type_Name |
SQL_VARCHAR(64) | False |
|
Form_ID |
SQL_VARCHAR(48) | False |
|
Has_Allocation |
SQL_VARCHAR(1) | False |
|
Has_Attendees |
SQL_VARCHAR(1) | False |
|
Has_Comments |
SQL_VARCHAR(1) | False |
|
Has_Exceptions |
SQL_VARCHAR(1) | False |
|
Has_Vat |
SQL_VARCHAR(1) | False |
|
Image_Required |
SQL_VARCHAR(1) | False |
|
Is_Credit_Card_Charge |
SQL_VARCHAR(1) | False |
|
Is_Itemized |
SQL_VARCHAR(1) | False |
|
Is_Personal |
SQL_VARCHAR(1) | False |
|
Is_Personal_Card_Charge |
SQL_VARCHAR(1) | False |
|
Last_Modified_Date |
SQL_TIMESTAMP | False |
|
LocationName |
SQL_VARCHAR(64) | False |
|
Location_Country |
SQL_VARCHAR(64) | False |
|
Location_Subdivision |
SQL_VARCHAR(64) | False |
|
Org_Unit_1 |
SQL_VARCHAR(48) | False |
|
Org_Unit_2 |
SQL_VARCHAR(48) | False |
|
Org_Unit_3 |
SQL_VARCHAR(48) | False |
|
Org_Unit_4 |
SQL_VARCHAR(48) | False |
|
Org_Unit_5 |
SQL_VARCHAR(48) | False |
|
Org_Unit_6 |
SQL_VARCHAR(48) | False |
|
Payment_Type_Code |
SQL_VARCHAR(4) | False |
|
Payment_Type_Name |
SQL_VARCHAR(80) | False |
|
Posted_Amount |
SQL_VARCHAR(23) | False |
|
Receipt_Required |
SQL_VARCHAR(1) | False |
|
Report_Entry_Receipt_Received |
SQL_VARCHAR(1) | False |
|
Report_Entry_Receipt_Type |
SQL_VARCHAR(1) | False |
|
Report_Entry_Vendor_Name |
SQL_VARCHAR(64) | False |
|
Spend_Category |
SQL_VARCHAR(64) | False |
|
Transaction_Currency_Name |
SQL_VARCHAR(512) | False |
|
Transaction_Date |
SQL_TIMESTAMP | False |
|
Vendor_Description |
SQL_VARCHAR(64) | False |