CC_PPAY_XREF (SQL Table)	Index Back
ProCard Prepay Reference Log This internal table keeps track of the Prepay Reference created for each Billing Date.

CC_PPAY_XREF

(SQL Table)

ProCard Prepay Reference Log

This internal table keeps track of the Prepay Reference created for each Billing Date.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
Default Value: OPR_DEF_TBL_FS.SETID
Prompt Table: SP_SETID_NONVW

2 CREDIT_CARD_VENDOR Character(5) VARCHAR2(5) NOT NULL Corporate Card Vendor
Prompt Table: CC_CARD_TBL_EX

3 BILLING_DATE Date(10) DATE NOT NULL Billing Date

4 PREPAID_REF Character(10) VARCHAR2(10) NOT NULL Prepayment Reference

5 DTTM_STAMP DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

6 CC_PREPAY_OPTION Character(1) VARCHAR2(1) NOT NULL Prepayment Voucher Options
A=Auto Apply
B=Specify

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW
2	CREDIT_CARD_VENDOR	Character(5)	VARCHAR2(5) NOT NULL	Corporate Card Vendor Prompt Table: CC_CARD_TBL_EX
3	BILLING_DATE	Date(10)	DATE NOT NULL	Billing Date
4	PREPAID_REF	Character(10)	VARCHAR2(10) NOT NULL	Prepayment Reference
5	DTTM_STAMP	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
6	CC_PREPAY_OPTION	Character(1)	VARCHAR2(1) NOT NULL	Prepayment Voucher Options A=Auto Apply B=Specify