PC_REQ_TAO (SQL Table)	Index Back
Purchasing keys Table - REQ Purchasing keys Table - REQ Used to hold data during processing, typically used in conjunction with an application engine.

PC_REQ_TAO

(SQL Table)

Purchasing keys Table - REQ

Purchasing keys Table - REQ Used to hold data during processing, typically used in conjunction with an application engine.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

2 BUSINESS_UNIT_PO Character(5) VARCHAR2(5) NOT NULL PO Business Unit

3 REQ_ID Character(10) VARCHAR2(10) NOT NULL Requisition ID

4 REQ_LINE_NBR Number(5,0) INTEGER NOT NULL Requisition Line Number

5 REQ_SCHED_NBR Number(3,0) SMALLINT NOT NULL Requisition Schedule Number

6 REQ_DISTRIB_NBR Number(5,0) INTEGER NOT NULL Requisition Distrib Number

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	BUSINESS_UNIT_PO	Character(5)	VARCHAR2(5) NOT NULL	PO Business Unit
3	REQ_ID	Character(10)	VARCHAR2(10) NOT NULL	Requisition ID
4	REQ_LINE_NBR	Number(5,0)	INTEGER NOT NULL	Requisition Line Number
5	REQ_SCHED_NBR	Number(3,0)	SMALLINT NOT NULL	Requisition Schedule Number
6	REQ_DISTRIB_NBR	Number(5,0)	INTEGER NOT NULL	Requisition Distrib Number