PO_SPND_RQDT_RQ

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	REPORT_ENTITY	Character(5)	VARCHAR2(5) NOT NULL	Reporting Entity ID
2	REQUESTOR_ID	Character(30)	VARCHAR2(30) NOT NULL	Requestor id
3	VENDOR_SETID	Character(5)	VARCHAR2(5) NOT NULL	Vendor SetID
4	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier
5	VNDR_LOC	Character(10)	VARCHAR2(10) NOT NULL	Vendor Location
6	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
7	REQ_ID	Character(10)	VARCHAR2(10) NOT NULL	Requisition ID
8	FISCAL_YEAR	Number(4,0)	SMALLINT NOT NULL	Fiscal Year
9	ACCOUNTING_PERIOD	Number(3,0)	SMALLINT NOT NULL	Identifies a time period to which you post transactions. Typically, an accounting period represents a month, but it can also represent a week, a day, or any user-defined interval. An accounting period has a beginning date and an ending date, and is defined in the calendar table.
10	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
11	MERCHANDISE_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Merchandise Amt F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label
12	AMT_OPEN	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Open Amount
13	REQ_DT	Date(10)	DATE	Requisition Date
14	PEND_FR_DT	Date(10)	DATE	Select Pend-Cmpl Prdn From Dat
15	REQ_STATUS	Character(4)	VARCHAR2(4) NOT NULL	Req status A=Approved C=Complete D=Denied I=Initial LA=Line Approved O=Open P=Pending Approval V=Preview X=Canceled
16	ENTERED_DT	Date(10)	DATE	Entered on
17	BUDGET_HDR_STS_NP	Character(1)	VARCHAR2(1) NOT NULL	Budget Ch'k Hdr Sts NonProrate E=Error in Budget Check N=Not Budget Checked P=Provisionally Valid V=Valid Budget Check Default Value: V
18	BUDGET_HDR_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Budget Checking Header Status E=Error in Budget Check I=Document In Processing N=Not Budget Checked P=Provisionally Valid V=Valid
19	APPROVAL_DT	Date(10)	DATE	Date of Approval
20	HOLD_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Hold From Further Processing Y/N Table Edit Default Value: N