PL_PO_DEL_TMP (SQL Table)	Index Back
Temp Red Pepper (PO Delveries) RAG CN#(R-MVAHID-DB68L) Added col chng_type RAG PL800-31.0 Added col INV_ITEM_ID

PL_PO_DEL_TMP

(SQL Table)

Temp Red Pepper (PO Delveries)

RAG CN#(R-MVAHID-DB68L) Added col chng_type RAG PL800-31.0 Added col INV_ITEM_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order

3 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]

4 SCHED_NBR Number(3,0) SMALLINT NOT NULL Schedule Number

5 COMMIT_DT Date(10) DATE Commit Date

6 PO_DT Date(10) DATE Date

7 DUE_DT Date(10) DATE Specifies the date that a transaction is due. It is a generic field used in multiple PeopleSoft applications including Receivables Payables and Purchasing. For example it represents the date that payment is due for a voucher or the date that a scheduled shipment is due to be received.

8 FIRM_ORDER Character(1) VARCHAR2(1) NOT NULL Firm Order

9 PLANNED_QUANTITY Number(16,4) DECIMAL(15,4) NOT NULL Planned Quantity

10 CHNG_TYPE Character(1) VARCHAR2(1) NOT NULL Change Type
C=Change
D=Deleted
H=Hold
I=Inserted
N=New
O=Original
R=Re-open
X=Cancelled

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

12 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID

13 PL_PO_SCHED Character(200) VARCHAR2(200) NOT NULL Purchase Order Sched

14 PL_SC_ORDER_STATUS Character(2) VARCHAR2(2) NOT NULL PL_SC_ORDER_STATUS
05=Planned
10=Entered
15=Firmed
20=Released
30=In Process
40=Pending Complete
50=Completed
60=Open
70=Active
75=Picked
77=Received
80=Intransit
85=Dispatched
90=Canceled
95=Closed

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	PO_ID	Character(10)	VARCHAR2(10) NOT NULL	Purchase Order
3	LINE_NBR	Number(5,0)	INTEGER NOT NULL	Line Number: 11/24/08 - Added TARGET label [PC product]
4	SCHED_NBR	Number(3,0)	SMALLINT NOT NULL	Schedule Number
5	COMMIT_DT	Date(10)	DATE	Commit Date
6	PO_DT	Date(10)	DATE	Date
7	DUE_DT	Date(10)	DATE	Specifies the date that a transaction is due. It is a generic field used in multiple PeopleSoft applications including Receivables Payables and Purchasing. For example it represents the date that payment is due for a voucher or the date that a scheduled shipment is due to be received.
8	FIRM_ORDER	Character(1)	VARCHAR2(1) NOT NULL	Firm Order
9	PLANNED_QUANTITY	Number(16,4)	DECIMAL(15,4) NOT NULL	Planned Quantity
10	CHNG_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Change Type C=Change D=Deleted H=Hold I=Inserted N=New O=Original R=Re-open X=Cancelled
11	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
12	INV_ITEM_ID	Character(18)	VARCHAR2(18) NOT NULL	Item ID
13	PL_PO_SCHED	Character(200)	VARCHAR2(200) NOT NULL	Purchase Order Sched
14	PL_SC_ORDER_STATUS	Character(2)	VARCHAR2(2) NOT NULL	PL_SC_ORDER_STATUS 05=Planned 10=Entered 15=Firmed 20=Released 30=In Process 40=Pending Complete 50=Completed 60=Open 70=Active 75=Picked 77=Received 80=Intransit 85=Dispatched 90=Canceled 95=Closed