This export pulls voucher and expense data. It retains a record of the vouchers that have been included in each export by the Select Voucher Status value. A voucher can appear on the payables export once per the Select Voucher Status value.

This export excludes denied expenses, and it will only include denied vouchers if you explicitly run it for them by specifying Denied in the Select Voucher Status parameter. When undoing a payables export with a Set Voucher Status parameter, the voucher status change will only be rolled-back if the voucher status still matches the status set by the export.

1. Select Voucher Status: The export will limit the exported data to only those vouchers that are currently in the selected voucher status

2. Voucher Status Date: Data is exported if the Last Update Date field of the Voucher History table is between the most recent parameter from export history that is less than the entered parameter, and the entered parameter.

3. Set Voucher Status: If a value is specified in the Select Voucher Status parameter, the export will update the status of the exported vouchers to the status specified in this parameter.

[VOUCHER].[ID] VOUCHER_ID [VOUCHER].[MULTI_MOVE] [VOUCHER].[PAYEE_TYPE] [VOUCHER].[VOUCHER_STATUS_ID] [VOUCHER_STATUS].NAME as VOUCHER_STATUS_NAME [VOUCHER_STATUS].PROCESS_STAGE [VOUCHER].[SUBMITTED_CURRENCY_MODE] [VOUCHER].[SUBMITTED_AMOUNT] [VOUCHER].[SUBMITTED_CURRENCY] [VOUCHER].[PAYMENT_AMOUNT_MODE] [VOUCHER].[SUBMITTED_TO_PAYMENT_EXCHANGE_RATE] [VOUCHER].[SUBMITTED_TO_PAYMENT_EXCHANGE_RATE_DATE] [VOUCHER].[TOTAL_COST_MODE] [VOUCHER].[TOTAL_COST_AMOUNT] [VOUCHER].[TOTAL_COST_CURRENCY] [VOUCHER].[VOUCHER_TYPE] [VOUCHER].[INVOICE_NUMBER] [VOUCHER].[INVOICE_DATE] [VOUCHER].[PAYOR] [VOUCHER].[DESCRIPTION] [VOUCHER].[DATE_COVERED_FROM] [VOUCHER].[DATE_COVERED_TO] [VOUCHER].[DATE_ENTERED] [VOUCHER].[DATE_RECEIVED] [VOUCHER].[RECEIPTS_RECEIVED] [VOUCHER].[RECEIPTS_RECEIVED_LAST_UPDATE_DATE] [VOUCHER].[RECEIPTS_RECEIVED_LAST_UPDATE_BY] [VOUCHER].[DATE_TO_PAY]

If paid to Employee

[VOUCHER].[ASSIGNMENT_ID] as PAYEE_ASSIGNMENT_ID [ASSIGNMENT].[NUMBER] as ASSIGNMENT_NUMBER [ASSIGNMENT].[EMPLOYEE_ID] as PAYEE_EMPLOYEE_ID [EMPLOYEE].[SYSTEM_NUMBER] as EMPLOYEE_SYSTEM_NUMBER

If paid to Vendor

[VOUCHER].[PAYEE_VENDOR_ID] as PAYEE_VENDOR_ID [VENDOR].[SYSTEM_NUMBER] as VENDOR_SYSTEM_NUMBER

If paid to either Payee Type

[VOUCHER_PAYMENT].[PAYEE_NAME] [VOUCHER_PAYMENT].[PAYMENT_METHOD] [VOUCHER_PAYMENT].[INT_BANK_NAME] [VOUCHER_PAYMENT].[INT_BANK_SWIFT_BIC_CODE] [VOUCHER_PAYMENT].[INT_BANK_ABA_ROUTE_CODE] [VOUCHER_PAYMENT].[INT_BANK_IBAN] [VOUCHER_PAYMENT].[FINAL_BANK_ACCOUNT_NUMBER] [VOUCHER_PAYMENT].[FINAL_BANK_NAME_ON_ACCOUNT] [VOUCHER_PAYMENT].[FINAL_BANK_NAME] [VOUCHER_PAYMENT].[FINAL_BANK_SWIFT_BIC_CODE] [VOUCHER_PAYMENT].[FINAL_BANK_ABA_ROUTE_CODE] [VOUCHER_PAYMENT].[FINAL_BANK_IBAN] [VOUCHER_PAYMENT].[FINAL_BANK_ADDRESS_CITY] [VOUCHER_PAYMENT].[FINAL_BANK_ADDRESS_STATE_PROVINCE_CODE] [VOUCHER_PAYMENT].[FINAL_BANK_ADDRESS_COUNTRY_CODE] [VOUCHER_PAYMENT].[FURTHER_CREDIT_ACCOUNT_NUMBER] [VOUCHER_PAYMENT].[FURTHER_CREDIT_NAME_ON_ACCOUNT] [VOUCHER_PAYMENT].[REFERENCE] [VOUCHER_PAYMENT].[SPECIAL_INSTRUCTIONS] [VOUCHER_PAYMENT].[WIRE_NUMBER] [VOUCHER_PAYMENT].[WIRE_DATE] [VOUCHER_PAYMENT].[CHECK_NUMBER] [VOUCHER_PAYMENT].[CHECK_DATE] [VOUCHER_PAYMENT].[ADDRESS_LINE_1] [VOUCHER_PAYMENT].[ADDRESS_LINE_2] [VOUCHER_PAYMENT].[ADDRESS_LINE_3] [VOUCHER_PAYMENT].[CITY] [VOUCHER_PAYMENT].[COUNTRY_CODE] [VOUCHER_PAYMENT].[STATE_PROVINCE_CODE] [VOUCHER_PAYMENT].[POSTAL_CODE] [VOUCHER_PAYMENT].[DELIVERY_METHOD] [vwEQ_VOUCHER_PAYMENT].[VOUCHER_CURRENCY] [vwEQ_VOUCHER_PAYMENT].[SUBMITTED_IN_PAYMENT_CURRENCY_AMOUNT] [vwEQ_VOUCHER_PAYMENT].[DENIED_AMOUNT] [vwEQ_VOUCHER_PAYMENT].[REIMBURSABLE_AMOUNT] [vwEQ_VOUCHER_PAYMENT].[CLIENT_PAYMENT_AMOUNT] [vwEQ_VOUCHER_PAYMENT].[TAX_ADJUSTMENT_AMOUNT] [vwEQ_VOUCHER_PAYMENT].[PAYMENT_AMOUNT] [vwEQ_VOUCHER_PAYMENT].[PAYMENT_CURRENCY] [VOUCHER].[CREATE_DATE] [VOUCHER].[CREATE_BY] [VOUCHER].[LAST_UPDATE_DATE] [VOUCHER].[LAST_UPDATE_BY] [VOUCHER].[SOURCE] [VOUCHER].[SOURCE_ID] [VOUCHER].[SOURCE_SYSTEM] [VOUCHER].[SOURCE_SYSTEM_TEXT_KEY]
[ENTRY].[ASSIGNMENT_ID] [ENTRY].[ID] ENTRY_ID [ACCOUNT].[ACCOUNT_NUMBER] [ACCOUNT].[SUB_ACCOUNT_NUMBER] [ENTRY_TYPE].[NAME] ENTRY_TYPE [ENTRY].[SOURCE] [ENTRY].[AMOUNT] [ENTRY].[CURRENCY] [ENTRY].[ENTRY_DATE] [ENTRY].[PAYOR] [ENTRY].[POLICY_STANDING] [ENTRY].[REFERENCE] [ENTRY].[CREATE_DATE] [ENTRY].[CREATE_BY] [ENTRY].[LAST_UPDATE_DATE] [ENTRY].[LAST_UPDATE_BY] [ENTRY].[SOURCE_ID] [ENTRY].[SOURCE_SYSTEM] [ENTRY].[SOURCE_SYSTEM_TEXT_KEY] [ENTRY_EXPENSE].[VOUCHER_ID] [ENTRY_EXPENSE].[SUBMITTED_AMOUNT] [ENTRY_EXPENSE].[SUBMITTED_CURRENCY] [ENTRY_EXPENSE].[SUBMITTED_TO_ENTRY_EXCHANGE_RATE] [ENTRY_EXPENSE].[SUBMITTED_TO_ENTRY_EXCHANGE_RATE_DATE] [ENTRY_EXPENSE].[VAT_AMOUNT] [ENTRY_EXPENSE].[VAT_CURRENCY] [ENTRY_EXPENSE].[REPORT_DATE] [ENTRY_EXPENSE].[EFFECTIVE_DATE] [ENTRY_EXPENSE].[TAX_YEAR] [ENTRY_EXPENSE].[TAX_STATE] [ENTRY_EXPENSE].[PAID_TO] [ENTRY_EXPENSE].[ALLOWABILITY] [ENTRY_EXPENSE].[PAID_DATE] [ENTRY_EXPENSE].[PAYROLL_DATE] [ENTRY_EXPENSE].[BEGIN_DATE] [ENTRY_EXPENSE].[END_DATE] [ENTRY_EXPENSE].[TAX_CALC_AMOUNT] [ENTRY_EXPENSE].[TAX_CALC_CURRENCY] [ENTRY_EXPENSE].[TAX_CALC_EXCHANGE_RATE_DATE] [ENTRY_EXPENSE].[TAX_CALC_EXCHANGE_RATE]

Check Adjustment Amount in TAX_CALC_CURRENCY TAX_CALC_CHECK_ADJUSTMENT_AMOUNT

[ENTRY_CURRENCY_TRUE_UP].[BASIS_AMOUNT] [ENTRY_CURRENCY_TRUE_UP].[BASIS_CURRENCY] [ENTRY_CURRENCY_TRUE_UP].[BASIS_EFFECTIVE_DATE] [ENTRY_CURRENCY_TRUE_UP].[FROM_AMOUNT] [ENTRY_CURRENCY_TRUE_UP].[FROM_CURRENCY] [ENTRY_CURRENCY_TRUE_UP].[BASIS_TO_FROM_EXCHANGE_RATE] [ENTRY_CURRENCY_TRUE_UP].[BASIS_TO_FROM_EXCHANGE_RATE_DATE] [ENTRY_CURRENCY_TRUE_UP].[TO_AMOUNT] [ENTRY_CURRENCY_TRUE_UP].[TO_CURRENCY] [ENTRY_CURRENCY_TRUE_UP].[BASIS_TO_TO_EXCHANGE_RATE] [ENTRY_CURRENCY_TRUE_UP].[BASIS_TO_TO_EXCHANGE_RATE_DATE] [ENTRY_CURRENCY_TRUE_UP].[COMPANY_AMOUNT] [ENTRY_CURRENCY_TRUE_UP].[COMPANY_CURRENCY] [ENTRY_CURRENCY_TRUE_UP].[BASIS_TO_COMPANY_EXCHANGE_RATE] [ENTRY_CURRENCY_TRUE_UP].[BASIS_TO_COMPANY_EXCHANGE_RATE_DATE] [ENTRY_CURRENCY_TRUE_UP].[SYSTEM_AMOUNT] [ENTRY_CURRENCY_TRUE_UP].[SYSTEM_CURRENCY] [ENTRY_CURRENCY_TRUE_UP].[BASIS_TO_SYSTEM_EXCHANGE_RATE] [ENTRY_CURRENCY_TRUE_UP].[BASIS_TO_SYSTEM_EXCHANGE_RATE_DATE]

Based on ENTRY.ID, a custom function, EQ_COL_VOUCHER_ENTRY_EXPENSE_EXPORT_LOOKUP can be written to do a lookup. A Custom Field could be returned, for example.

CUSTOM_LOOKUP [COMPANY].[NUMBER] [COMPANY].[SHORT_NAME] [COMPANY].[LONG_NAME]