Expense Post Summary Transactions by Batch Domain

Similar to post domain, except data is summarized by Report total (instead of broken down by activity structure). Examples:

Extracted Reports by Batch

Supported Version	Domain Name	Domain Folder
5.1.x to 5.4.4	Expense Post Summary Domain 5.1.x	Domains
5.5 and higher	Expense Post Summary Transactions by Batch	DomainsV55

The domains consists of the following columns (NOTE: Column names could be renamed so you might see different names based on your side configuration, so the following names are the base names of the system)

Column ID	Column Name (From DBLabels.properties)	Data Type	Description
BATCH_TYPE	Post Status	String	Extract Batch Type for either ACH, GL, AP, Payroll
C_ALC_B	Business Alcohol Amount in CC Currency	Decimal	Business Alcohol Amount in Credit Card Currency
C_ALC_P	Personal Alcohol Amount in CC Currency	Decimal	Personal Alcohol Amount in Credit Card Currency
C_BASE_B	Base Business Amount in CC Currency	Decimal	Base Business Amount in Credit Card Currency
C_BASE_P	Base Personal Amount in CC Currency	Decimal	Base Personal Amount in Credit Card Currency
C_COMP_CC	Due by Company to CC in CC Currency	Decimal	Due by Company to Credit Card in CC Currency
C_EMP_CC	Due by Employee to CC in CC Currency	Decimal	Due by Employee to Credit Card in CC Currency
C_GRAND	Credit Card Billing Amount	Decimal	Credit Card Billing Amount
C_GRAND_BAL	Credit Card Billing Balance Amount	Decimal	Credit Card Billing Balance Amount
C_TAX2_B	Business Tax2 Amount in CC Currency	Decimal	Business Tax2 Amount in Credit Card Currency
C_TAX2_P	Personal Tax2 Amount in C Currency	Decimal	Personal Tax2 Amount in Credit Card Currency
C_TAX1_B	Business Tax1 Amount in CC Currency	Decimal	Business Tax1 Amount in Credit Card Currency
C_TAX1_P	Personal Tax1 Amount in CC Currency	Decimal	Personal Tax1 Amount in Credit Card Currency
C_TIP_B	Business Tip Amount in CC Currency	Decimal	Business Tip Amount in Credit Card Currency
C_TIP_P	Personal Tip Amount in CC Currency	Decimal	Personal Tip Amount in Credit Card Currency
C_TOTAL_B	Total Business Amount in CC Currency	Decimal	Total Business Amount in Credit Card Currency
C_TOTAL_P	Personal Business Amount in CC Currency	Decimal	Personal Business Amount in Credit Card Currency
CC_BILL_CURR	Credit Card Billing Currency	String	Credit Card Billing Currency
EMPLY_TYPE_NAME	Employee Type	String	Employee Type Name
HDR_TITLE	Report Title	String	Report Tile
HOME_DEPT_NAME	Home Department	String	Home Department Name
HOME_OPT_NAME	Home Operating Unit	String	Home Operating Unit Name
LAST_FIRST	Full Name (Last, First)	String	Employee/User Last Name, First Name
LOCK_BY	Locked By	String	Locked by if the expense report is in Status: Open or Closed
OTHER_EMPLY_ID1	Other Employee ID1	String	Employee Other id1 that is mapped to OTHER_EMPLY_ID1 in the employee table
OTHER_EMPLY_ID2	Other Employee ID2	String	Employee Other id2
R_ALC_B	Business Alcohol Amount in Report Currency	Decimal	Expense Line - Reimbursable/ Business Amount for Alcohol to Employee
R_ALC_P	Personal Alcohol Amount in Report Currency	Decimal	Personal Alcohol Amount in Report Currency
R_BASE_B	Base Business Amount in Report Currency	Decimal	Base Business Amount in Report Currency
R_BASE_P	Base Personal Amount in Report Currency	Decimal	Base Personal Amount in Report Currency
R_COMP_CC	Due by Company to CC	Decimal	Expense Report - Company Total Amount due to Credit Card for that specific expense line charge
R_COMP_EMP	Due by Company to Employee	Decimal	Expense Report - Company Total Amount due to Employee for that specific expense line charge
R_EMP_CC	Due by Employee to CC	Decimal	Expense Report - Employee Total Amount due to Credit Card for that specific expense line charge
R_GRAND	Total Amount in Report Currency	Decimal	Expense Report- Total Amount per line item that contains the attendees on the specific report.
R_GRAND_BAL	Grand Total Balance Amount in Report Currency	Decimal	Grand Total Balance Amount in Report Currency
R_TAX2_B	Business Tax2Amount in Report Currency	Decimal	Expense Line - Reimbursable/Business Tax 2 Amount
R_TAX2_P	Personal Tax2 Amount in Report Currency	Decimal	Personal Tax2 Amount in Report Currency
R_TAX_B	Business Tax1 Amount in Report Currency	Decimal	Expense Line - Reimbursable/Business Tax 1 Amount
R_TAX_P	Personal Tax Amount in Report Currency	Decimal	Personal Tax Amount in Report Currency
R_TIP_B	Business Tip Amount in Report Currency	Decimal	Expense Line - Reimbursable/Business Tip Amount
R_TIP_P	Personal Tip Amount in Report Currency	Decimal	Personal Tip Amount in Report Currency
R_TOTAL_B	Total Business Amount in Report Currency	Decimal	Expense Line - Reimbursable/Business Amount
R_TOTAL_B_BAL	Total Business Balance Amount in Report Currency	Decimal	Total Business Balance Amount in Report Currency
R_TOTAL_P	Personal Amount in Report Currency	Decimal	Personal Total Amount in Report Currency
R_TOTAL_P_BAL	Total Personal Balance Amount in Report Currency	Decimal	Total Personal Balance Amount in Report Currency
REPORT_ID	Report ID	Integer	Report ID
REPORT_TYPE_NAME	Report Type	String	Report Type Name
RPT_CURR	Report Currency	String	Expense Report Currency Code
SSN	SSN	String	Employee Other id that is mapped to SSN field.
VENDOR_ID	Vendor ID	String	Vendor ID that is linked to the report that got requested
VENDOR_NAME	Vendor	String	Vendor Name
XP_CERT_STATUS	Certify Status	String	Certify Status by the user for the expense report. Certify Status: Require Certification Certified Already No Action (default)
XP_REPORT_PREV_STATUS	Report Previous Status	String	On Hold Released In Approval Status Rejected Approved
PROC_STATUS	Process Status	String	Process Status could be one of the following: Fully Paid Partially Paid Posted for Payment No action (Default - Not posted)
HDR_STATUS_NAME	Report Status	String	Expense report status: On Hold Open Released Closed In Approval Status Rejected Approved
XP_REPORT_VAILD_STATUS	Report Validation Status	String	Report Validation Status could be one of the following: Incomplete Invalid Charge Passed Passed with warnings *No Action
LAST_APPROVED_DT	Last Approved Datetime	String	Last Approved Datetime (For Display Only)
XP_REPORT_BUS	Business Report Amount	Decimal	Business Report Amount
XP_REPORT_TOTAL	Total Report Amount	Decimal	Total Report Amount
HDR_PLACE_NAME	Cover Page Place Name	String	Expense Report Place Name if existing on the Report Cover Page.
TODAY_DATE	TODAY_DATE	Date	Today's Date
EMP_ACTIVE	Active Employee	String	Employee Active Yes or No
DEPT_CODE	Home Department Code	String	Home Department Code
EMPLY_ID	Employee ID	String	Employee Id
EMPLY_TYPE	Employee Type Code	String	Employee Type ID
REPORT_TYPE	Report Type Code	String	Report Type ID
OPT_CODE	Home Operating Unit Code	String	Home Operating Unit Code
BATCH_NO	Batch ID	Integer	Extract Batch Number
END_DATE	Report End Date	Date	Expense Report End Date
HDR_DT	Report DateTime Stamp	Datetime	Expense Report Header Datetime Stamp - Last Modified Datetime.
LOCKED_DT	Locked Datetime Stamp	Datetime	Locked Datetime if the expense report is in Status: Open or Closed
POST_DATE	Post Date	Date	Extract Post Date that is provided during the extract of expense reports.
START_DATE	START_DATE	Date	Expense Report Start Date