Integrating With PeopleSoft Payables
When expense reports and cash advances are approved for payment, PeopleSoft Expenses stages data for payment processing by PeopleSoft Payables. Expense report data is staged in EX_SHEET_PYMNT, and cash advance data is staged in EX_ADVNCE_PYMNT.
This topic discusses how to:
Map for expense report data.
Map for cash advance data.
Generate payments.
Define a pay cycle for PeopleSoft Expenses.
Process escheated payments.
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 |
Mapping details for PeopleSoft Payables (PYCYCL_DATA) and PeopleSoft Expense (EX_ADVNCE_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 cash advance 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 Handling |
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 |
N/A |
N/A |
N/A |
In City Limit |
IN_CITY_LIMIT |
IN_CITY_LIMIT |
N/A |
N/A |
IPAC Payment |
IPAC_PYMNT_FLT |
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 |
ACCOUNTING_DT |
N/A |
N/A |
Advice ID |
PAY_DOC_ID |
ADVANCE_ID |
N/A |
ADVANCE_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 |
0 |
N/A |
Payment Message |
PYMNT_MESSAGE |
N/A |
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 |
0 |
N/A |
Rate Divisor |
RATE_DIV |
RATE_DIV |
N/A |
N/A |
Rate Multiplier |
RATE_MULT |
RATE_MULT |
N/A |
N/A |
Rebate Term Available |
REBATE_TERM_FLG |
N/A |
N/A |
N/A |
Daily Rebate Percent |
REBATE_PERCENT |
N/A |
N/A |
N/A |
Maximum Rebate Percent |
REBATE_MAX_PERCENT |
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/A |
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 |
To stage payments for expense reports and cash advances, run the staging process from the Expense Processes page.
After staging expense data, your PeopleSoft Payables system completes the process of generating payments through Pay Cycle Manager. Oracle's PeopleSoft delivers three pay cycles with your database:
EX-CA for cash advance payments.
EX-ER for expense report payments.
CA-ER for cash advance and expense report payments.
You can set up your own pay cycle, but it must have several components specifically for PeopleSoft Expenses.
The Pay Cycle Manager needs to know where payment data is staged and how the data is mapped to the corresponding tables in PeopleSoft Payables. This information is defined in a payment source, also known as a source transaction, on the pay cycle mapping page. Use the Accounts Payable, Payments, Pay Cycle Definition, Mapping navigation to access the Paycycle Map page.
Expenses delivers these source transactions:
EXPN for expense reports.
EXAD for cash advances.
Mapping a Pay Cycle for EXPN
When using the source transaction EXPN for Pay Cycle mapping, select these values:
Pay Cycle Mapping Field |
Field Value |
---|---|
Input Record (Table) Name |
EX_SUMM_PYMNT |
Output Record to Update |
EX_SUMM_PYMNT |
Copy of Record to Update |
EX_SHEET_CPY |
Mapping a Pay Cycle for EXAD
When using the source transaction EXAD for Pay Cycle mapping, select these values:
Pay Cycle Mapping Field |
Field Value |
---|---|
Input Record (Table) Name |
EX_ADVNCE_PYMNT |
Output Record to Update |
EX_ADVNCE_PYMNT |
Copy of Record to Update |
EX_ADVNCE_CPY |
Note: When Pay Cycle Mapping is set up, the payment sources you define can be used any time without being defined again.
When defining a pay cycle, you must select EXPN as the source transaction for expense reports or EXAD as the source transaction for cash advances.
The SetID, Bank, Account, and Payment Method fields defined in the pay cycle must be identical to the corresponding fields you select when you review payments for cash advances, expense reports, and suppliers.
Escheated payments refer to expense report payments that have has not clear your bank. You have determined that the amount will not be cashed and you need to send the amount to a federal agency.
A business use case for this process is:
An employee creates an expense report using PeopleSoft Expenses.
The expense report is approved for payment.
The PeopleSoft Payables, pay cycle is run and the check is generated.
Expense liabilities and payment liabilities are created.
After a period of time, you realize the check has not cleared your bank and you discover that the employee is deceased and the check will not be cashed.
Using the Payment Escheatment Page to put the amount in an Escheatment account.
See also Payment Escheatment.
Using the Expense Processes Page to mark the expense as Escheated in PeopleSoft Expenses and to generate accounting entries to reverse the liability.