EM_EXT_BUY_DTL (SQL Table)	Index Back
Voucher Extract - Buyer Detail Record used to store an extracted voucher's payment status and date when extract is executed by the Buyer.

EM_EXT_BUY_DTL

(SQL Table)

Voucher Extract - Buyer Detail

Record used to store an extracted voucher's payment status and date when extract is executed by the Buyer.

Parent record: EM_EXT_BUY

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

2 VOUCHER_ID Character(8) VARCHAR2(8) NOT NULL Voucher ID

3 DTTM_STAMP DateTime(26) TIMESTAMP NOT NULL 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.

4 PYMNT_CNT Number(5,0) INTEGER NOT NULL Payments

5 PYMNT_STATUS Character(1) VARCHAR2(1) NOT NULL Payment Status
A=Alignment
E=ACH/EFT Prenote
L=Stale Dated Payment
N=Reprinted with same ref number
O=Overflow
P=Paid
R=Replaced
S=Stopped
T=Undo Escheatment
U=Undo Cancel
V=Void
W=Escheated Check
X=Deleted

6 PYMNT_DT Date(10) DATE Payment Date

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	VOUCHER_ID	Character(8)	VARCHAR2(8) NOT NULL	Voucher ID
3	DTTM_STAMP	DateTime(26)	TIMESTAMP NOT NULL	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.
4	PYMNT_CNT	Number(5,0)	INTEGER NOT NULL	Payments
5	PYMNT_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Payment Status A=Alignment E=ACH/EFT Prenote L=Stale Dated Payment N=Reprinted with same ref number O=Overflow P=Paid R=Replaced S=Stopped T=Undo Escheatment U=Undo Cancel V=Void W=Escheated Check X=Deleted
6	PYMNT_DT	Date(10)	DATE	Payment Date