| Data element |
Definition |
ALLOCATION_COST_OBJ_BC
Indexed - no
Format - varchar2(1)
May be null? yes |
1-character budgetary control segment of the allocation Cost Object. |
ALLOCATION_COST_OBJ_CNAC
Indexed - yes
Format - varchar2(3)
May be null? yes |
3-character Center Net Asset Class code segment of the allocation Cost Object. |
ALLOCATION_COST_OBJ_FUND
Indexed - yes
Format - varchar2(6)
May be null? yes |
6-character Fund segment of the allocation Cost Object. |
ALLOCATION_COST_OBJ_ORG
Indexed - yes
Format - varchar2(4)
May be null? yes |
4-character Organization segment of the allocation Cost Object. |
ALLOCATION_COST_OBJ_RESPORG
Indexed - yes
Format - varchar2(4)
May be null? yes |
4-character code for the Organization responsible for managing the Fund of the allocation cost object. |
ALLOCATION_COST_OBJECT
Indexed - no
Format - varchar2(48)
May be null? yes |
Allocation Cost Object (comprised of Penn Chart of Accounts CNAC, ORG, BC, and FUND segments). |
ALLOCATION_KEY
Indexed - no
Format - varchar2(13)
May be null? yes |
Unique system-assigned key identifying an allocation record. |
ALLOCATION_PERCENTAGE
Indexed - no
Format - number
May be null? yes |
Percentage of the expense allocated to the account code. |
ALLOCATION_SCHOOL_CTR
Indexed - yes
Format - varchar2(2)
May be null? yes |
Penn School/Center code associated with the allocation. |
CASH_ADV_REQ_AMOUNT
Indexed - no
Format - number
May be null? yes |
Amount of the cash advance.. |
CASH_ADV_REQ_CURRENCY_CODE
Indexed - no
Format - varchar2(3)
May be null? yes |
Cash advance reimbursement currency. |
CASH_ADVANCE_ISSUE_DATE
Indexed - no
Format - date
May be null? yes |
Date the cash advance was issued. |
CASH_ADVANCE_PAYMENT_CODE
Indexed - yes
Format - varchar2(80)
May be null? yes |
Payment type used to issue the cash advance. A credit card payment type indicates that the employee took a cash advance on their credit card.. |
CASH_ADVANCE_TRX_TYPE
Indexed - no
Format - varchar2(1)
May be null? yes |
Type of cash advance transaction (Issue or Application). |
CCARD_BILL_DATE
Indexed - no
Format - date
May be null? yes |
Credit card bill date, as fed from the credit card vendor.. |
CCARD_BILLING_AMOUNT
Indexed - no
Format - number
May be null? yes |
Amount due to the company card of either CBCP or IBCP type for this detail row. |
CCARD_BILLING_CURRENCY
Indexed - no
Format - varchar2(3)
May be null? yes |
The 3-digit ISO currency code for the billing currency. |
CCARD_EXCHANGE_RATE
Indexed - no
Format - number
May be null? yes |
Currency exchange rate used between the credit card billing currency and the recipient's reimbursement currency. |
CCARD_MERCHANT_BUS_NAME
Indexed - no
Format - varchar2(64)
May be null? yes |
Descriptive name of the merchant. |
CCARD_TRX_AMOUNT
Indexed - no
Format - number
May be null? yes |
Amount of the charge in the spend currency. |
CCARD_TRX_CCT_TYPE
Indexed - no
Format - varchar2(3)
May be null? yes |
Transaction type supplied by card vendor. One of these:
ANF = Annual Fees
CAV = Cash Advance
CCF = Cash and Check Fees
CHG = Other Bank Charges and Fees
FNC = Finance Charges
LAF = Late Fees
NSF = Insufficient Funds Check Fees
PAY = Payment
RPE = Credit Card Transaction |
CCARD_TRX_DESC
Indexed - no
Format - varchar2(42)
May be null? yes |
Description of the charge from the merchant. |
CCARD_TRX_MERCHANT_CITY
Indexed - no
Format - varchar2(40)
May be null? yes |
The merchant's city. |
CCARD_TRX_MERCHANT_CODE
Indexed - no
Format - varchar2(5)
May be null? yes |
Merchant code sent from the credit card vendor. |
CCARD_TRX_MERCHANT_COUNTRY
Indexed - yes
Format - varchar2(2)
May be null? yes |
The 2-digit ISO Merchant country location code. |
CCARD_TRX_MERCHANT_NAME
Indexed - yes
Format - varchar2(50)
May be null? yes |
The name of the merchant. |
CCARD_TRX_MERCHANT_REFNO
Indexed - no
Format - varchar2(15)
May be null? yes |
Merchant reference number passed from the merchant to the credit card. |
CCARD_TRX_MERCHANT_STATE
Indexed - no
Format - varchar2(32)
May be null? yes |
The merchant's state/province.. |
CCARD_TRX_POSTED_AMOUNT
Indexed - no
Format - number
May be null? yes |
Amount of the charge in the billing currency of the card. |
CCARD_TRX_SPEND_CURRENCY
Indexed - no
Format - varchar2(3)
May be null? yes |
The 3-digit ISO currency code for the spend currency. |
CCARD_TRX_TAX_AMOUNT
Indexed - no
Format - number
May be null? yes |
Amount of tax on the transaction amount (if provided by card vendor). |
DESTINATION_COUNTRY_CODE
Indexed - yes
Format - varchar(2)
May be null? yes |
The 2-digit ISO code of the destination country. |
ESTIMATED_PAYMENT_DATE
Indexed - no
Format - date
May be null? yes |
The estimated payment date. |
FIRST_NAME
Indexed - no
Format - varchar2(32)
May be null? yes |
Person’s first name. |
FULL_NAME
Indexed - yes
Format - varchar2(66)
May be null? yes |
Person’s full name (in format LASTNAME,FIRSTNAME MIDDLEINITIAL). |
INTERNET_FEE_BEGIN_DATE
Indexed - no
Format - date
May be null? yes |
Beginning date for Internet Access Fees expenses. |
INTERNET_FEE_END_DATE
Indexed - no
Format - date
May be null? yes |
End date for Internet Access Fees expenses. |
JOUNAL_ACCOUNT_OBJECT_CODE
Indexed - yes
Format - varchar2(4)
May be null? yes |
The expense type account code (Penn's COA object code). |
JOURNAL_AMOUNT
Indexed - no
Format - number
May be null? yes |
Value, as credit or debit, of the amount to be exchanged between the payer and payee for this expense account code (not an absolute value). |
JOURNAL_KEY
Indexed - no
Format - varchar2(48)
May be null? yes |
Unique system-assigned key that identifies the expense report journal. |
LAST_NAME
Indexed - yes
Format - varchar2(32)
May be null? yes |
Person's last name. |
MIDDLE_INITIAL
Indexed - no
Format - varchar2(1)
May be null? yes |
Person’s middle initial. |
PAYEE_PAYMENT_CODE
Indexed - no
Format - varchar2(80)
May be null? yes |
Payment code description for the payee. |
PAYEE_PAYMENT_TYPE
Indexed - no
Format - varchar2(64)
May be null? yes |
Indicates who is getting reimbursed for the expense (Company or Employee). |
PAYER_PAYMENT_CODE
Indexed - no
Format - varchar2(80)
May be null? yes |
Payment code description for the payer. |
PAYER_PAYMENT_TYPE
Indexed - no
Format - varchar2(64)
May be null? yes |
Indicates who is paying for the expense (Company or Employee). |
PAYMENT_REIMB_TYPE
Indexed - no
Format - varchar2(1)
May be null? yes |
Report payment reimbursement type; indicates whether Expense Pay reimbursed this journal entry.
Either:
1 = Expense Pay
blank = not Expense Pay. |
PAYMENT_TYPE
Indexed - no
Format - varchar2(65)
May be null? yes |
Report entry payment type name. Example:
Cash/Personal Credit Card/
Cash Advance Return. |
PAYMENT_TYPE_CODE
Indexed - yes
Format - varchar2(4)
May be null? yes |
Report entry payment code. Examples: CASH/IBCP/CBCP. |
PAYMENT_TYPE_DESC
Indexed - no
Format - varchar2(80)
May be null? yes |
Report Entry Payment Code Name. Examples: Cash/Individual Billed Company Paid/Company Billed Company Paid. |
PENN_COMMENTS
Indexed - no
Format - varchar2(4000)
May be null? yes |
Comments related to manual table adjustments. |
PENN_ID
Indexed - yes
Format - varchar2(8)
May be null? yes |
8-digit identification number assigned to the person by the Penn Community system. |
PERSON_COST_OBJ_BC
Indexed - no
Format - varchar2(1)
May be null? yes |
1-character budgetary control segment of the person’s default Cost Object. |
PERSON_COST_OBJ_CNAC
Indexed - yes
Format - varchar2(3)
May be null? yes |
3-character Center Net Asset Class code segment of the person’s default Cost Object. |
PERSON_COST_OBJ_CREF
Indexed - yes
Format - varchar2(4)
May be null? yes |
Default Center Reference code associated with the person. |
PERSON_COST_OBJ_FUND
Indexed - yes
Format - varchar2(6)
May be null? yes |
6-character Fund segment of the person’s default Cost Object. |
PERSON_COST_OBJ_ORG
Indexed - yes
Format - varchar2(4)
May be null? yes |
4-character Organization segment of the person’s default Cost Object. |
PERSON_COST_OBJ_PROGRAM
Indexed - yes
Format - varchar2(4)
May be null? yes |
Default Penn Program code associated with the person. |
PERSON_COST_OBJ_RESPORG
Indexed - yes
Format - varchar2(4)
May be null? yes |
4-character code for the Organization responsible for managing the Fund of the person’s default Cost Object. |
PERSON_COST_OBJECT
Indexed - yes
Format - varchar2(4)
May be null? yes |
Person’s default Cost Object (comprised of Penn Chart of Accounts CNAC, ORG, BC, and FUND segments). |
PERSON_GROUP_ID
Indexed - no
Format - varchar2(48)
May be null? yes |
Person’s affiliation (e.g., Faculty/Staff, Student). |
PERSON_HOME_ORG
Indexed - yes
Format - varchar2(4)
May be null? yes |
4-digit number used to identify the organization that owns the employee’s record and is responsible for its maintenance in the PennWorks system. |
PERSON_SCHOOL_CTR
Indexed - yes
Format - varchar2(2)
May be null? yes |
Penn School/Center code associated with the person’s default cost object. |
PERSONAL_EXPENSE_FLAG
Indexed - no
Format - varchar2(1)
May be null? yes |
Indicates whether the submitter marked the expense as personal (do not reimburse).. |
RPT_COST_OBJ_ORG
Indexed - yes
Format - varchar2(4)
May be null? yes |
4-character Organization segment of the expense report Cost Object. |
RPT_COST_OBJ_PROGRAM
Indexed - yes
Format - varchar2(4)
May be null? yes |
Penn Program code associated with the expense report. |
RPT_ENTRY_SERVICE_CLASS
Indexed - yes
Format - varchar2(48)
May be null? yes |
Airline travel service code. |
RPT_ENTRY_TRAVEL_TYPE
Indexed - no
Format - varchar2(48)
May be null? yes |
Type of travel used when the expense was incurred. |
SAE_BATCH_DATE
Indexed - yes
Format - date
May be null? no |
Standard Accounting Extract (SAE) batch date. |
SAE_BATCH_ID
Indexed - yes
Format - number
May be null? yes |
Unique identifier for the Standard Accounting Extract (SAE) batch. |
SAE_BATCH_SEQ_NUM
Indexed - no
Format - number
May be null? yes |
Unique sequence for the Standard Accounting Extract (SAE) batch line. |
TA_ALLOWABLE_THRESHOLD
Indexed - no
Format - number
May be null? yes |
This is the maximum allowed amount for the day. |
TA_ALLOWANCE_AMOUNT
Indexed - no
Format - number
May be null? yes |
The allowance amount. |
TA_ALLOWANCE_LIMIT
Indexed - no
Format - number
May be null? yes |
The maximum amount that will be reimbursed for the day. |
TA_BASE_AMOUNT
Indexed - no
Format - number
May be null? yes |
The base amount of the allowance. |
TA_BREAKFAST_PROVIDED
Indexed - no
Format - char(3)
May be null? yes |
Indicates whether breakfast was provided. |
TA_DINNER_PROVIDED
Indexed - no
Format - char(3)
May be null? yes |
Indicates whether dinner was provided |
TA_DISPLAY_LIMIT
Indexed - no
Format - number
May be null? yes |
Limit for the reimbursable travel allowance for a single day; if using fixed allowances, this value will not apply. |
TA_LUNCH_PROVIDED
Indexed - no
Format - char(3)
May be null? yes |
Indicates whether lunch was provided. |
TA_MEAL_LODGING_TYPE
Indexed - no
Format - varchar2(1)
May be null? yes |
Flag that identifies what type of travel allowance was applied to the entry (M = meals only;
L = lodging). |
TA_REIMBURSEMENT_TYPE
Indexed - no
Format - varchar2(1)
May be null? yes |
Flag that identifies what type of travel allowance was applied to this entry (M = meals only;
L = lodging;
C = combined meals/lodging). |
TAX_ADJUSTED_AMOUNT
Indexed - no
Format - number
May be null? yes |
Amount of tax based on approved amount, in the reimbursement currency. |
TAX_ALLOCATION_RECLAIM_CODE
Indexed - no
Format - varchar2(20)
May be null? yes |
Allocation reclaim code. |
TAX_AUTHORITY_LABEL
Indexed - no
Format - varchar2(5)
May be null? yes |
5-digit code that appears on the expense entry pages. |
TAX_CODE
Indexed - no
Format - varchar2(20)
May be null? yes |
Tax code assigned to this tax authority for the expense type entered on the expense entry. |
TAX_NAME
Indexed - no
Format - varchar2(50)
May be null? yes |
Tax authority name. |
TAX_POSTED_AMOUNT
Indexed - no
Format - number
May be null? yes |
Calculated tax amount for this expense entry in the reimbursement currency. |
TAX_RECLAIM_ADJUSTED_AMOUNT
Indexed - no
Format - number
May be null? yes |
Reclaim amount calculated on adjusted tax amount. |
TAX_RECLAIM_CODE
Indexed - no
Format - varchar2(20)
May be null? yes |
Reclaim code from the tax definition. |
TAX_RECLAIM_DOMESTIC_FLAG
Indexed - no
Format - varchar2(1)
May be null? yes |
Indicates whether this tax configuration is defined as a reclaimable local tax jurisdiction |
TAX_RECLAIM_POSTED_AMOUNT
Indexed - no
Format - number
May be null? yes |
Calculated amount of tax eligible for reclaim in the reimbursement currency. |
TAX_RECLAIM_TRX_ADJUSTED_AMOUNT
Indexed - no
Format - number
May be null? yes |
Amount of tax based on approved amount, not total in spend transaction currency. |
TAX_RECLAIM_TRX_AMOUNT
Indexed - no
Format - number
May be null? yes |
Calculated amount of tax eligible for reclaim in the spend currency. |
TAX_SOURCE
Indexed - no
Format - varchar2(4)
May be null? yes |
Specifies how the tax data was derived:
CARD= Provided from company card
USER = Entered by employee
SYST = Calculated by system
PROC = Entered by processor |
TAX_TRX_AMOUNT
Indexed - no
Format - number
May be null? yes |
Calculated tax amount for this expense in the spend currency. |
TEM_RPT_APPROVED_AMOUNT
Indexed - no
Format - number
May be null? yes |
Total amount approved to be reimbursed. |
TEM_RPT_COST_OBJ_BC
Indexed - no
Format - varchar2(1)
May be null? yes |
1-character budgetary control segment of the expense report Cost Object. |
TEM_RPT_COST_OBJ_CNAC
Indexed - yes
Format - varchar2(3)
May be null? yes |
3-character Center Net Asset Class code segment of the expense report Cost Object. |
TEM_RPT_COST_OBJ_CREF
Indexed - yes
Format - varchar2(4)
May be null? yes |
Penn Center Reference code associated with the expense report. |
TEM_RPT_COST_OBJ_FUND
Indexed - yes
Format - varchar2(6)
May be null? yes |
6-character Fund segment of the expense report Cost Object. |
TEM_RPT_COST_OBJ_ORG
Indexed - yes
Format - varchar2(4)
May be null? yes |
4-character Organization segment of the expense report Cost Object. |
TEM_RPT_COST_OBJ_PROGRAM
Indexed - yes
Format - varchar2(4)
May be null? yes |
Penn Program code associated with the expense report. |
TEM_RPT_COST_OBJ_RESPORG
Indexed - yes
Format - varchar2(4)
May be null? yes |
4-character code for the Organization responsible for managing the Fund of the expense report cost object. |
TEM_RPT_COST_OBJECT
Indexed - yes
Format - varchar2(48)
May be null? yes |
Expense report Cost Object (comprised of Penn Chart of Accounts CNAC, ORG, BC, and FUND segments). |
TEM_RPT_COUNTRY_CODE
Indexed - yes
Format - varchar2(48)
May be null? yes |
Country associated with the expense report. |
TEM_RPT_PERSON_AFFILIATION
Indexed - no
Format - varchar2(48)
May be null? yes |
Affiliation of the person associated with the expense report (from the report header) (e.g., Faculty/Staff, Student). |
TEM_RPT_PERSON_GROUP
Indexed - no
Format - varchar2(48)
May be null? yes |
Affiliation of the person associated with the expense report (from the person profile) (e.g., Faculty/Staff, Student). |
TEM_RPT_PERSON_PENN_ID
Indexed - yes
Format - varchar2(8)
May be null? yes |
8-digit identification number assigned to the person by the Penn Community system. |
TEM_RPT_ENTRY_BUSINESS_DIST
Indexed - no
Format - number
May be null? yes |
Car mileage - Number of miles/ kilometers driven for business purposes. |
TEM_RPT_ENTRY_CURRENCY
Indexed - no
Format - varchar2(3)
May be null? yes |
3-character ISO alpha code for the spend currency if not an imported credit card or the invoice currency if this is a credit card (e.g., USD, CAD, AUD, etc.). |
TEM_RPT_ENTRY_DESC
Indexed - yes
Format - varchar2(64)
May be null? yes |
Submitter-entered business purpose or description of the expense entry. |
TEM_RPT_ENTRY_EXCHG_DIR
Indexed - no
Format - varchar2(1)
May be null? yes |
Direction of exchange:
• M = the amount was multiplied by the exchange rate to determine the reimbursement amount
• D = the transaction amount was divided by the exchange rate to determine the reimbursement amount. |
TEM_RPT_ENTRY_EXCHG_RATE
Indexed - no
Format - number
May be null? yes |
Exchange rate used to convert the expense from the transaction currency amount to the reimbursement currency amount. |
TEM_RPT_ENTRY_EXPENSE_DESC
Indexed - no
Format - varchar2(48)
May be null? yes |
Expense description. |
TEM_RPT_ENTRY_EXPENSE_TYPE
Indexed - yes
Format - varchar2(64)
May be null? yes |
Expense type name (e.g., Airfare, Hotel, etc). |
TEM_RPT_ENTRY_FOREIGN_FLAG
Indexed - no
Format - char(4)
May be null? yes |
Indicates whether the expense was incurred in the person's country, either:
FRGN = this expense was incurred in a country other than the employee's home country
HOME = this expense was incurred in the employee's home country |
TEM_RPT_ENTRY_ID
Indexed - yes
Format - number
May be null? no |
Unique system-assigned key that identifies the report entry expense. |
TEM_RPT_ENTRY_LAWSON_ACCT
Indexed - no
Format - varchar2(48)
May be null? yes |
Account number from the University of Pennsylvania Health System (UPHS). |
TEM_RPT_ENTRY_MEAL_TYPE
Indexed - no
Format - varchar2(48)
May be null? yes |
Type of meal. |
TEM_RPT_ENTRY_NET_OF_TAX_AMT
Indexed - yes
Format - number
May be null? no |
Net of tax amount. |
TEM_RPT_ENTRY_NUM_DAYS
Indexed - no
Format - varchar2(48)
May be null? yes |
Number of days. |
TEM_RPT_ENTRY_ORIG_CC_VENDOR
Indexed - no
Format - varchar2(48)
May be null? yes |
Original credit card vendor. |
TEM_RPT_ENTRY_PASSENGER_COUNT
Indexed - yes
Format - number
May be null? no |
Number of passengers entered as traveling in this rental car for this from/to location. |
TEM_RPT_ENTRY_PASSENGER_NAME
Indexed - no
Format - varchar2(48)
May be null? yes |
Passenger name. |
TEM_RPT_ENTRY_PERSONAL_DIST
Indexed - no
Format - number
May be null? yes |
Car mileage - Number of miles/ kilometers driven for personal purposes. |
TEM_RPT_ENTRY_POSTED_AMOUNT
Indexed - no
Format - number
May be null? yes |
Amount of the expense posted (reimbursement currency). |
TEM_RPT_ENTRY_RECEIPT_RECD
Indexed - no
Format - varchar2(1)
May be null? yes |
Indicates whether receipts have been marked as received for the expense. |
TEM_RPT_ENTRY_RECEIPT_TYPE
Indexed - no
Format - varchar2(1)
May be null? yes |
Indicates whether a receipt is available for the expense and, if so, whether the receipt includes tax information (for VAT purposes). |
TEM_RPT_ENTRY_REIMB_AMOUNT
Indexed - no
Format - number
May be null? yes |
Amount approved in the reimbursement currency. |
TEM_RPT_ENTRY_SPEND_COUNTRY
Indexed - no
Format - varchar2(2)
May be null? yes |
Country code for the report entry spend location. |
TEM_RPT_ENTRY_SPEND_CTRY_SUBCD
Indexed - no
Format - varchar2(6)
May be null? yes |
Country subdivision code for the report entry spend location. |
TEM_RPT_ENTRY_TAX_RECLAIM_AMT
Indexed - no
Format - number
May be null? yes |
Report entry tax reclaim amount. |
TEM_RPT_ENTRY_TAX_RECLAIM_CTRY
Indexed - no
Format - varchar2(2)
May be null? yes |
Tax reclaim country code. |
TEM_RPT_ENTRY_TRX_AMT
Indexed - no
Format - number
May be null? yes |
Amount spent in the expense spend currency. |
TEM_RPT_ENTRY_TRX_DATE
Indexed - yes
Format - date
May be null? yes |
Date that this expense was incurred (when the money was spent or credit card receipt/transaction date). |
TEM_RPT_ENTRY_TRX_TYPE
Indexed - yes
Format - varchar2(3)
May be null? yes |
Type of transaction of the expense:
• REG = Regular
• PAR = Parent (when an expense is itemized)
• CHD = Child (when an expense is itemized). |
TEM_RPT_ENTRY_VAT_CONDITIONAL
Indexed - no
Format - varchar2(48)
May be null? yes |
VAT conditional. |
TEM_RPT_ENTRY_VENDOR_DESC
Indexed - yes
Format - varchar2(64)
May be null? yes |
Submitter-entered vendor name. |
TEM_RPT_ENTRY_VENDOR_NAME
Indexed - no
Format - varchar2(32)
May be null? yes |
Vendor associated with the expense. Vendor name, as selected from the corporate vendor list. |
TEM_RPT_ID
Indexed - yes
Format - varchar2(48)
May be null? yes |
Unique system-assigned code that identifies the expense report. |
TEM_RPT_NAME
Indexed - yes
Format - varchar2(40)
May be null? yes |
Submitter-entered name of the expense report. |
TEM_RPT_POLICY_NAME
Indexed - yes
Format - varchar2(64)
May be null? yes |
Name of the policy applying to the expense report. |
TEM_RPT_POSTED_AMOUNT
Indexed - no
Format - number
May be null? yes |
Total posted amount for the expense report. |
TEM_RPT_PROCESS_DATE
Indexed - yes
Format - date
May be null? yes |
The date that the report completed all approvals and was ready to be extracted for payment. This means the date the report reached the status of 'Processing Payment'.. |
TEM_RPT_SCHOOL_CTR
Indexed - yes
Format - varchar2(2)
May be null? yes |
Penn School/Center code associated with the expense report cost object. |
TEM_RPT_SUBMIT_DATE
Indexed - no
Format - date
May be null? yes |
Date that the expense report was last submitted by the submitter for approval. If the person submitted the report more than once, for example, because it was returned to the submitter for corrections, this date is the date the report was last submitted. |
TEM_RPT_TA_ENTRY
Indexed - yes
Format - varchar2(1)
May be null? yes |
If "Y", then this report has at least one expense with travel allowance data. |
TEM_RPT_TRAVEL_TYPE
Indexed - yes
Format - varchar2(48)
May be null? yes |
Type of travel associated with the expense report. |
TEM_RPT_USER_DATE
Indexed - no
Format - date
May be null? yes |
Custom date/time specified by user. |
TEM_RPT_VAT_ENTRY
Indexed - yes
Format - varchar2(1)
May be null? yes |
If "Y", then this report has at least one expense with VAT data. |
TEM_SAE_FILE_CREATION_DATE
Indexed - no
Format - date
May be null? yes |
Date on which the Standard Accounting Extract (SAE) file was created. |
TOTAL_BUSINESS_ATTENDEES
Indexed - no
Format - number
May be null? yes |
Number of Business Guest type attendees. |
TOTAL_EMPLOYEE_ATTENDEES
Indexed - no
Format - number
May be null? yes |
Number of Employee type attendees. |
TOTAL_SPOUSE_ATTENDEES
Indexed - no
Format - number
May be null? yes |
Number of Spouse type attendees. |
VAT_NET_ADJ_RECLAIM_AMOUNT
Indexed - no
Format - number
May be null? yes |
The sum of the reclaimable tax amount calculated from the Total Tax Adjusted Amount. |
VAT_NET_TAX_AMOUNT
Indexed - no
Format - number
May be null? yes |
Calculated as Posted Amount minus Total Tax Posted Amount. |
VAT_RECLAIM_ADJUSTED_AMOUNT
Indexed - no
Format - number
May be null? yes |
The sum of the reclaimable tax amount calculated from the Total Tax Adjusted Amount. |
VAT_TAX_POSTED_AMOUNT
Indexed - no
Format - number
May be null? yes |
The sum of the tax calculated based on the expense amount. |
