Mapping for Expense Report Data

Mapping details for PeopleSoft Payables (PYCYCL_DATA) and PeopleSoft Expenses (EX_SHEET_PYMNT) tables are as follows:

Field or Control	Description
Description	From PeopleSoft Payables table.
Field Name	From PeopleSoft Payables table.
Input Field Name	From PeopleSoft Expense table.
Constant	Defined in pay cycle mapping.
Output Field Name	From PeopleSoft Expenses table.

The following is the mapping for expense report data:

Description	Field Name	Input Field Name	Constant	Output Field Name
Accounting Date	ACCOUNTING_DT	N/A	N/A	ACCOUNTING_DT
Address Line 1	ADDRESS1	ADDRESS1	N/A	N/A
Address Line 2	ADDRESS2	ADDRESS2	N/A	N/A
Address Line 3	ADDRESS3	ADDRESS3	N/A	N/A
Address Line 4	ADDRESS4	ADDRESS4	N/A	N/A
Address Sequence Number	ADDRESS_SEQ_NUM	ADDRESS_SEQ_NUM	N/A	N/A
Address Field 1	ADDR_FIELD1	N/A	N/A	N/A
Address Field 2	ADDR_FIELD2	N/A	N/A	N/A
Address Field 3	ADDR_FIELD3	N/A	N/A	N/A
Apply Credit Status	APPL_CREDIT_STATUS	N/A	"N" (Not Applicable)	N/A
Bank Account	BANK_ACCT_KEY	BANK_ACCT_KEY	N/A	BANK_ACCT_KEY
Bank Account Sequence Number	BANK_ACCT_SEQ_NBR	N/A	N/A	N/A
Bank Code	BANK_CD	BANK_CD	N/A	BANK_CD
Replacement Status	BANK_RPL_STATUS	N/A	N/A	N/A
Bank SetID	BANK_SETID	BANK_SETID	N/A	BANK_SETID
Base Currency	BASE_CURRENCY	BASE_CURRENCY	N/A	N/A
Base Currency of Bank GL Unit	BASE_CURRENCY_BNK	N/A	N/A	BASE_CURRENCY_BNK
Bank Exchange Rate Divisor	BNK_RATE_DIV	N/A	N/A	BNK_RATE_DIV
Exchange Rate	BNK_RATE_MULT	N/A	N/A	BNK_RATE_MULT
Business Unit	BUSINESS_UNIT	BUSINESS_UNIT_GL	N/A	BUSINESS_UNIT_GL
General Ledger Unit	BUSINESS_UNIT_GL	N/A	N/A	BUSINESS_UNIT_BANK
AP Business Unit	BUS_UNIT_RELATED	N/A	N/A	N/A
City	CITY	CITY	N/A	N/A
Country	COUNTRY	COUNTRY	N/A	N/A
County	COUNTY	COUNTY	N/A	N/A
Payment Currency	CURRENCY_PYMNT	N/A	N/A	CURRENCY_PYMNT
Exchange Rate Type	CUR_RT_TYPE	RT_TYPE	N/A	N/A
Currency Rate Type	CUR_RT_TYPE_BNK	N/A	N/A	RT_TYPE_BNK
Payment Rate Type	CUR_RT_TYPE_PAID	N/A	N/A	N/A
Payment Currency Rate Type	CUR_RT_TYPE_PYMNT	N/A	N/A	CUR_RT_TYPE_PYMNT
More Information	DESCR254_MIXED	N/A	N/A	N/A
Draft Create Key	DFT_CREATE_KEY	N/A	N/A	N/A
Draft Group Code	DFT_GROUP_CD	N/A	N/A	N/A
Draft Master ID	DFT_MASTER_ID	N/A	N/A	N/A
Draft Maturity Date	DFT_MAT_DT	N/A	N/A	N/A
Draft Scheduled Maturity Date	DFT_SCHED_MAT_DT	N/A	N/A	N/A
Draft Sight Code	DFT_SIGHT_CD	N/A	N/A	N/A
Document Sequence Date	DOC_SEQ_DATE	N/A	N/A	DOC_SEQ_DATE
Document Sequence Number	DOC_SEQ_NBR	N/A	N/A	DOC_SEQ_NBR
Document Sequencing Status	DOC_SEQ_STATUS	N/A	N/A	N/A
Document Type	DOC_TYPE	N/A	N/A	DOC_TYPE
Base Discount Amount	DSCNT_AMT_BSE	N/A	N/A	N/A
Discount Due Date	DSCNT_DUE_DT	N/A	N/A	N/A
Payment Discount Amount	DSCNT_PAY_AMT	N/A	N/A	N/A
Due Date	DUE_DT	DUE_DT	N/A	N/A
Discount Denied	ECN_DSCNT_DNIE_FLG	N/A	"N" (No)	N/A
Bank Check Drawn On	EFT_CHECK_DRAW_CD	EFT_CHECK_DRAW_CD	N/A	N/A
Check Forwarding	EFT_CHECK_FWRD_CD	EFT_CHECK_FWRD_CD	N/A	N/A
Correspondent's Costs	EFT_CORR_COSTS_CD	EFT_CORR_COSTS_CD	N/A	N/A
Crossed Check	EFT_CROSSED_CHECK	EFT_CROSSED_CHECK	N/A	N/A
Domestic Costs	EFT_DOM_COSTS_CD	EFT_DOM_COSTS_CD	N/A	N/A
SetID	EFT_KEY_FIELD1	N/A	N/A	N/A
Supplier ID	EFT_KEY_FIELD2	N/A	N/A	N/A
Supplier Location	EFT_KEY_FIELD3	N/A	N/A	N/A
Effective Date	EFT_KEY_FIELD4	N/A	N/A	N/A
Bank Account Seq Number	EFT_KEY_FIELD5	N/A	N/A	N/A
Bank Account Seq Number	EFT_KEY_FIELD6	N/A	N/A	N/A
Payment Instruction 1	EFT_PAY_INST_CD1	EFT_PAY_INST_CD1	N/A	N/A
Payment Instruction 2	EFT_PAY_INST_CD2	EFT_PAY_INST_CD2	N/A	N/A
Payment Instruction 3	EFT_PAY_INST_CD3	EFT_PAY_INST_CD3	N/A	N/A
Payment Instruction 4	EFT_PAY_INST_CD4	EFT_PAY_INST_CD4	N/A	N/A
Payment Instruction Ref 1	EFT_PAY_INST_REF1	EFT_PAY_INST_REF1	N/A	N/A
Payment Instruction Ref 2	EFT_PAY_INST_REF2	EFT_PAY_INST_REF2	N/A	N/A
Payment Format	EFT_PYMNT_FMT_CD	EFT_PYMNT_FMT_CD	N/A	N/A
Complex Routing	EFT_RTNG_FLG	N/A	"D" (Use DFI ID)	N/A
Routing Status	EFT_RTNG_STATUS	EFT_RTNG_STATUS	N/A	N/A
Transaction Handlings	EFT_TRANS_HANDLING	EFT_TRANS_HANDLING	N/A	N/A
EmplID	EMPLID	EMPLID	N/A	N/A
Exception Flag	EXCEPTION_FLAG	N/A	N/A	N/A
Tax Supplier Geographical Code	GEO_CODE	GEO_CODE	N/A	N/A
Base Gross Amount	GROSS_AMT_BSE	GROSS_AMT_BSE	N/A	N/A
Control Group ID	GRP_AP_ID	N/A	N/A	N/A
Group by Payment Date	GRP_PYMNT_DT	N/A	"N" (No)	N/A
Days Before/After Holiday	HOL_PROC_DAYS	N/A	N/A	N/A
Holiday Processing Option	HOL_PROC_OPT	N/A	N/A	N/A
Allow Due Date in Next Month	HOL_PROC_OVERFL	N/A	N/A	N/A
House Type	HOUSE_TYPE	HOUSE_TYPE	N/A	N/A
Informational Only	INFO_ONLY_FLG	N/A	"N" (No)	N/A
Invoice Number	INVOICE_ID	INVOICE_ID	N/A	N/A
In City Limit	IN_CITY_LIMIT	IN_CITY_LIMIT	N/A	N/A
IPAC Payment	IPAC_PYMNT_FLG	N/A	N/A	N/A
Late Charge Amount	LATE_CHRG_AMT	N/A	N/A	N/A
Late Charge Amount Base	LATE_CHRG_AMT_BSE	N/A	N/A	N/A
Late Charge Code	LATE_CHRG_CD	N/A	N/A	N/A
Late Charge Denied	LATE_CHRG_DNIE	N/A	N/A	N/A
Late Charge Denied Base	LATE_CHRG_DNIE_BSE	N/A	N/A	N/A
Late Charge Option	LATE_CHRG_OPT	N/A	"N" (Not Applicable)	N/A
Late Charge Paid	LATE_CHRG_PAID	N/A	N/A	N/A
Late Charge Paid Base	LATE_CHRG_PAID_BSE	N/A	N/A	N/A
Letter of Credit ID	LC_ID	N/A	N/A	N/A
Name 1	NAME1	NAME1	N/A	N/A
Name 1 Alternate Char Set	NAME1_AC	NAME1_AC	N/A	N/A
Name 2	NAME2	NAME2	N/A	N/A
Name 2 Alternate Char Set	NAME2_AC	NAME2_AC	N/A	N/A
Number 1	NUM1	NUM1	N/A	N/A
Number 2	NUM2	NUM2	N/A	N/A
Paid Amount	PAID_AMT	N/A	N/A	PAID_AMT
Paid Amount - Base Bank Unit	PAID_AMT_BNK_BSE	N/A	N/A	PAID_AMT_BNK_BSE
Base Paid Amount	PAID_AMT_BSE	N/A	N/A	PAID_AMT_BSE
Discount on Paid Amount	PAID_AMT_DSCNT	N/A	N/A	N/A
Base Discount Paid Amount	PAID_AMT_DSCNT_BSE	N/A	N/A	N/A
Gross Paid Amount	PAID_AMT_GROSS	N/A	N/A	N/A
Base Gross Payment Amount	PAID_AMT_GROSS_BSE	N/A	N/A	N/A
Payment Exchange Rate Divisor	PAID_RATE_DIV	N/A	N/A	N/A
Payment Exchange Rate Multiplier	PAID_RATE_MULT	N/A	N/A	N/A
Pay Cycle	PAY_CYCLE	N/A	N/A	PAY_CYCLE
Pay Cycle Sequence Number	PAY_CYCLE_SEQ_NUM	N/A	N/A	N/A
Advice Date	PAY_DOC_DT	TRANS_DT	N/A	N/A
Advice ID	PAY_DOC_ID	SHEET_ID	N/A	SHEET_ID
Advice Sequence	PAY_DOC_SEQ	LINE_NBR	N/A	LINE_NBR
Pay Schedule Type	PAY_SCHEDULE_TYPE	N/A	N/A	N/A
Postal Code	POSTAL	POSTAL	N/A	N/A
Preferred Language	PREFERRED_LANGUAGE	PREFERRED_LANGUAGE	N/A	N/A
Prenotification Status	PRENOTE_STATUS	N/A	N/A	N/A
Process Instance	PROCESS_INSTANCE	N/A	N/A	N/A
Pay Cycle Place Holder 1	PYCYCL_FIELD1	N/A	N/A	N/A
Pay Cycle Place Holder 10	PYCYCL_FIELD10	N/A	N/A	N/A
Pay Cycle Place Holder 2	PYCYCL_FIELD2	N/A	N/A	N/A
Pay Cycle Place Holder 3	PYCYCL_FIELD3	N/A	N/A	N/A
Pay Cycle Place Holder 4	PYCYCL_FIELD4	N/A	N/A	N/A
Pay Cycle Place Holder 5	PYCYCL_FIELD5	N/A	N/A	N/A
Pay Cycle Place Holder 6	PYCYCL_FIELD6	N/A	N/A	N/A
Pay Cycle Place Holder 7	PYCYCL_FIELD7	N/A	N/A	N/A
Pay Cycle Place Holder 8	PYCYCL_FIELD8	N/A	N/A	N/A
Pay Cycle Place Holder 9	PYCYCL_FIELD9	N/A	N/A	N/A
Pay Cycle Mapping Key Field 1	PYCYCL_KEY_FIELD1	N/A	N/A	N/A
Pay Cycle Mapping Key Field 2	PYCYCL_KEY_FIELD2	N/A	N/A	N/A
Pay Cycle Mapping Key Field 3	PYCYCL_KEY_FIELD3	SEQ_NBR	N/A	SEQ_NBR
Payment	PYMNT_CNT_RELATED	N/A	N/A	N/A
Payment Date	PYMNT_DT	N/A	N/A	PYMNT_DT
Gross Payment Amount	PYMNT_GROSS_AMT	PYMNT_GROSS_AMT	N/A	N/A
Pay Group Code	PYMNT_GROUP_CD	N/A	N/A	N/A
Payment Handling	PYMNT_HANDLING_CD	N/A	N/A	N/A
Payment Number	PYMNT_ID	N/A	N/A	PYMNT_ID
Payment Image ID	PYMNT_IMAGE_ID	N/A	N/A	N/A
Payment Message	PYMNT_MESSAGE	REFERENCE_ID	N/A	N/A
Payment Method	PYMNT_METHOD	PYMNT_METHOD	N/A	PYMNT_METHOD
Payment Exchange Rate Divisor	PYMNT_RATE_DIV	N/A	N/A	PYMNT_RATE_DIV
Payment Exchange Rate Multiplier	PYMNT_RATE_MULT	N/A	N/A	PYMNT_RATE_MULT
Payment Reason Code	PYMNT_REASON_CD	N/A	N/A	N/A
Payment Selection Status	PYMNT_SELCT_STATUS	PYMNT_SELCT_STATUS	N/A	PYMNT_SELCT_STATUS
Separate Payment	PYMNT_SEPARATE	N/A	"N" (No)	N/A
Sort Code	PYMNT_SORT_CD	N/A	N/A	N/A
Rate Divisor	RATE_DIV	RATE_DIV	N/A	N/A
Rate Multiplier	RATE_MULT	RATE_MULT	N/A	N/A
Maximum Rebate Percent	REBATE_MAX_PERCENT	N/A	N/A	N/A
Daily Rebate Percent	REBATE_PERCENT	N/A	N/A	N/A
Rebate Term Available	REBATE_TERM_FLG	N/A	N/A	N/A
Remit Bank Code	REMIT_BANK_CD	REMIT_BANK_CD	N/A	N/A
Remit Bank SetID	REMIT_BANK_SETID	REMIT_BANK_SETID	N/A	N/A
Remit Bank Account	REMIT_BNK_ACCT_KEY	REMIT_BNK_ACCT_KEY	N/A	N/A
Remit SetID	REMIT_SETID	REMIT_SETID	N/A	N/A
Remit Supplier	REMIT_VENDOR	REMIT_VENDOR	N/A	N/A
Schedule ID	SCHEDULE_ID	N/A	N/A	N/A
Scheduled to Pay	SCHEDULED_PAY_DT	SCHEDULED_PAY_DT	N/A	N/A
Single Payment	SINGLE_PYMNT_FLG	N/A	"N" (No)	N/A
Source Transaction	SOURCE_TXN	N/A	N/A	N/A
Specify Payment Exchange Rate	SPEC_PYMNT_EX_RT	N/A	"N" (No)	N/A
State	STATE	STATE	N/A	N/A
Est Settlement Date	STTLMNT_DT_EST	STTLMNT_DT_EST	N/A	N/A
Transaction Currency	TXN_CURRENCY_CD	TXN_CURRENCY_CD	N/A	N/A
Short Supplier Name	VENDOR_NAME_SHORT	VENDOR_NAME_SHORT	N/A	N/A
Supplier Location	VNDR_LOC	VNDR_LOC	N/A	N/A
Service Type	VNDR_SERVICE_TYPE	N/A	N/A	N/A
Voucher ID	VOUCHER_ID	N/A	N/A	N/A
Related Voucher	VOUCHER_ID_RELATED	N/A	N/A	N/A
Withholding Applicable	WTHD_SW	N/A	N/A	N/A