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:

  1. An employee creates an expense report using PeopleSoft Expenses.

  2. The expense report is approved for payment.

  3. The PeopleSoft Payables, pay cycle is run and the check is generated.

  4. Expense liabilities and payment liabilities are created.

  5. 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.

  6. Using the Payment Escheatment Page to put the amount in an Escheatment account.

    See also Payment Escheatment.

  7. Using the Expense Processes Page to mark the expense as Escheated in PeopleSoft Expenses and to generate accounting entries to reverse the liability.