PL_PO_DISTRIB_C

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROBINST	Character(20)	VARCHAR2(20) NOT NULL	Optimization Problem Instance Prompt Table: SP_PRBINS_NONVW
2	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
3	PO_ID	Character(10)	VARCHAR2(10) NOT NULL	Purchase Order
4	LINE_NBR	Number(5,0)	INTEGER NOT NULL	Line Number: 11/24/08 - Added TARGET label [PC product]
5	SCHED_NBR	Number(3,0)	SMALLINT NOT NULL	Schedule Number
6	DST_ACCT_TYPE	Character(4)	VARCHAR2(4) NOT NULL	07/20/04 st: added RCN for Advance Reconciliation 02/16/98 ebn CN#CM800-2.0 : Added for MISC type for Landed Cost Enhancement 11/11/99 llr: Added ADVP for Payables Advance Payment
7	DISTRIB_LINE_NUM	Number(5,0)	INTEGER NOT NULL	Distribution Line
8	ITM_SETID	Character(5)	VARCHAR2(5) NOT NULL	Item SetID
9	INV_ITEM_ID	Character(18)	VARCHAR2(18) NOT NULL	Item ID
10	UNIT_OF_MEASURE	Character(3)	VARCHAR2(3) NOT NULL	Used on an approval rule set. MHR=Muti Hourly PER=Percentage SQF=Square Footage
11	CONFIG_CODE	Character(50)	VARCHAR2(50) NOT NULL	Product Configurator
12	DUE_DTTM	DateTime(26)	TIMESTAMP	Due Datetime
13	PLAN_DUE_DTTM	DateTime(26)	TIMESTAMP NOT NULL	Planning Due Date/Time
14	PL_PO_LEAD_TIME	Number(10,0)	DECIMAL(10) NOT NULL	11/01/01 PCL (CN#PL900-1): Added
15	PLAN_RELEASE_DTTM	DateTime(26)	TIMESTAMP	Plan Release Date Time
16	ORIG_FROZEN_FLG	Character(1)	VARCHAR2(1) NOT NULL	03/14/02 EGS (CN#PL900-1): Added. Y/N Table Edit
17	FROZEN_FLG	Character(1)	VARCHAR2(1) NOT NULL	Frozen Flag B=Both N=No Y=Yes Y/N Table Edit
18	ORIG_CANCEL_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Original Cancel Status
19	CANCEL_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Cancel Status A=Active C=Closed D=Denied H=Hold O=Open P=Pending Approval X=Canceled
20	SYSTEM_SOURCE	Character(3)	VARCHAR2(3) NOT NULL	Identifies the application or source system that generated a journal entry. Release 8.80 - 11/14/2002 - RVlasic - Removed GDM (JrnlGen - Deduction Management) from Translate Values. SUJ---Included a label as Product. Release 8.9 - 05/11/2005 - RVlasic - Added PRV (Variance Pricing) and PKK (KK Budget Journal) and deleted GLK for Project Costing per Brian Cohen.
21	QTY_PO	Number(16,4)	DECIMAL(15,4) NOT NULL	Purchase Order Quantity
22	QTY_PO_STD	Number(16,4)	DECIMAL(15,4) NOT NULL	PO Quantity Standard
23	PLAN_QTY_PO_STD	Number(16,4)	DECIMAL(15,4) NOT NULL	11/01/01 PCL (CN#PL900-1): Added
24	PURCHASE_YIELD	Number(5,1)	DECIMAL(4,1) NOT NULL	Purchase Yield
25	ORIG_QTY_MOVED_INV	Number(16,4)	DECIMAL(15,4) NOT NULL	Quantity Received
26	QTY_MOVED_INV	Number(16,4)	DECIMAL(15,4) NOT NULL	Received Base
27	ORIG_QTYAMSHIPSUOM	Number(16,4)	DECIMAL(15,4) NOT NULL	Quantity Returned
28	QTY_AM_SHIP_SUOM	Number(16,4)	DECIMAL(15,4) NOT NULL	Returned Base
29	REMAINING_QTY	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	08/16/01 JNW (CN#PL900-1.0): Added
30	BUSINESS_UNIT_IN	Character(5)	VARCHAR2(5) NOT NULL	Inventory Unit
31	INCL_QTY_FLG	Character(1)	VARCHAR2(1) NOT NULL	Include Quantity B=Both N=No Y=Yes Y/N Table Edit
32	BUYER_ID	Character(30)	VARCHAR2(30) NOT NULL	Buyer
33	PLANNER_CD	Character(12)	VARCHAR2(12) NOT NULL	Planner Code
34	APPROVED_FLG	Character(1)	VARCHAR2(1) NOT NULL	Approved by Auditor D=Denied N=Not Approved Y=Approved Y/N Table Edit Default Value: N
35	PEG_STATUS	Character(2)	VARCHAR2(2) NOT NULL	07/21/04 EGS: Created 10=Open 20=Completed 30=Canceled 40=Not Pegged Default Value: 40
36	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
37	VERSION	Number(10,0)	DECIMAL(10) NOT NULL	Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference