ORDENT_SSRC_VW

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	TRFT_SRC_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Alternate Source Type 0=All Sources 1=Inventory Business Unit 2=Distribution Network 3=New Requisition 4=New Purchase Order 5=Existing Requisition 6=Existing Purchase Order 7=Existing Interunit Transfer 8=Existing Production Order 9=New Production Order
2	TRFT_DISPOSITION	Character(1)	VARCHAR2(1) NOT NULL	Supply Source disposition 1=Direct Ship 2=Direct Receipt
3	SOURCE_BUS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Source Bus Unit
4	SSRC_TYPE_DESCR	Character(10)	VARCHAR2(10) NOT NULL	Source Type Description
5	SSRC_DISP_DESCR	Character(10)	VARCHAR2(10) NOT NULL	Source Disposition Description
6	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier Prompt Table: ITM_VENDOR
7	VENDOR_NAME_SHORT	Character(14)	VARCHAR2(14) NOT NULL	Short Vendor Name
8	NAME1	Character(40)	VARCHAR2(40) NOT NULL	Name 1
9	VNDR_LOC	Character(10)	VARCHAR2(10) NOT NULL	Vendor Location Prompt Table: VNDR_LOC_VW1
10	PEG_ORDER_KEY	Character(30)	VARCHAR2(30) NOT NULL	Used to store the various Order Number formats in 1 field
11	PEG_LINE_KEY	Character(30)	VARCHAR2(30) NOT NULL	Used to Store the concatenation of Line, Demand, Sched, Kit, etc in 1 field.
12	QTY_AVAILABLE	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Qty Available
13	COST	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Total Cost
14	COST_BASIS_LIMIT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Cost Basis Limit
15	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
16	CURRENCY_CD_BASE	Character(3)	VARCHAR2(3) NOT NULL	Business Unit Base Currency
17	PRICE_MARKUP_PCT	Signed Number(16,2)	DECIMAL(14,2) NOT NULL	Price Markup %
18	STANDARD_PRICE	Signed Number(16,4)	DECIMAL(14,4) NOT NULL	Transfer Price
19	TRANSIT_COST	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Transportation Cost
20	UNIT_COST	Signed Number(16,4)	DECIMAL(14,4) NOT NULL	Unit Cost
21	LEAD_DAYS	Number(4,0)	SMALLINT NOT NULL	Lead Days for Calendar
22	INTRANSIT_HOURS	Number(16,4)	DECIMAL(15,4) NOT NULL	Intransit Hours
23	QTY_REQUESTED	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Qty Requested
24	QTY_REQUESTED_BASE	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Qty Requested Base
25	PRICE_COST	Character(30)	VARCHAR2(30) NOT NULL	Price/Cost
26	PRIORITY_NBR	Number(3,0)	SMALLINT NOT NULL	Priority
27	TRFT_SET_ID	Character(10)	VARCHAR2(10) NOT NULL	Rule Cd
28	SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Sequence
29	TRFT_PRIORITY	Character(2)	VARCHAR2(2) NOT NULL	Priority 01=Quantity Available Descending 02=Quantity Available Ascending 03=Top Priority Break First 04=Alphabetically 05=Shortest Lead Time, Alpha 06=Longest Lead Time, Alpha
30	PEG_STATUS	Character(2)	VARCHAR2(2) NOT NULL	07/21/04 EGS: Created 10=Open 20=Completed 30=Canceled 40=Not Pegged
31	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
32	DEMAND_SOURCE	Character(2)	VARCHAR2(2) NOT NULL	Demand Source IN=Material Request OM=Sales Order PL=Planning Requisition PO=Purchase Order PR=Purchasing Requisition RT=Material Return SF=Production Request WM=Work Order
33	ORDER_NO	Character(10)	VARCHAR2(10) NOT NULL	Identifies a customer order number that appears as a reference on a receivables pending item. Date Initials Issue Description 022701 mv SP2 (F-CJORGENS-3) CSR Desktop
34	ORDER_INT_LINE_NO	Number(5,0)	INTEGER NOT NULL	Order Line
35	SCHED_LINE_NBR	Number(6,0)	INTEGER NOT NULL	Schedule Line Number
36	INV_ITEM_ID	Character(18)	VARCHAR2(18) NOT NULL	Item ID
37	DEMAND_LINE_NO	Number(4,0)	SMALLINT NOT NULL	Demand Line No
38	PO_ID	Character(10)	VARCHAR2(10) NOT NULL	Purchase Order
39	REQ_ID	Character(10)	VARCHAR2(10) NOT NULL	Requisition ID
40	LINE_NBR	Number(5,0)	INTEGER NOT NULL	Line Number: 11/24/08 - Added TARGET label [PC product]
41	SCHED_NBR	Number(3,0)	SMALLINT NOT NULL	Schedule Number
42	DISTRIB_LINE_NUM	Number(5,0)	INTEGER NOT NULL	Distribution Line
43	PRODUCTION_ID	Character(10)	VARCHAR2(10) NOT NULL	Production ID
44	MG_OUTPUT_TYPE	Character(2)	VARCHAR2(2) NOT NULL	10/22/98 (CN#EN800-6.0) LAJ...Created Stores the output item type on a Bill of Materials. The type could represent either a co-product (primary or secondary) or a by-product (waste or recycle). 11/23/98 (CN#SF800-13) JNW added teardown xlat CP=Primary CS=Co-Product RB=Recycle TD=Teardown WB=Waste
45	OP_SEQUENCE	Number(4,0)	SMALLINT NOT NULL	Operation Sequence
46	MG_OUTPUT_QTY_CODE	Character(3)	VARCHAR2(3) NOT NULL	01/28/98 (CN#EN800-6.0) LAJ...Created Stores the quantity code for an output item on a Bill of Materials. It was created with the same values as qty_code, but by separating these two fields, it allows greater flexibility in the future. ASY=Assembly ORD=Order
47	PEG_ORDER_LINE_KEY	Character(30)	VARCHAR2(30) NOT NULL	Used to store concatenation of PEG_ORDER_KEY and PEG_LINE_KEY in 1 field for display.
48	BUYER_ID	Character(30)	VARCHAR2(30) NOT NULL	Buyer
49	QTY	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Quantity
50	QTY_AVAIL	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Quantity Available
51	SEQ_NBR_4	Number(4,0)	SMALLINT NOT NULL	Sequence
52	SCHED_DTTM	DateTime(26)	TIMESTAMP	08/16/01 JNW (CN#PL900-1.0): Added
53	SHIP_TYPE_ID	Character(10)	VARCHAR2(10) NOT NULL	Ship Via Code Prompt Table: SHIP_SRC_IBU_VW
54	CARRIER_ID	Character(10)	VARCHAR2(10) NOT NULL	Carrier ID Prompt Table: CARRIER_SHP_VW
55	OM_CHANGE_STATE	Character(2)	VARCHAR2(2) NOT NULL	Allow OM Changes Thru
56	PRDN_AREA_CODE	Character(10)	VARCHAR2(10) NOT NULL	Production Area
57	BOM_CODE	Number(2,0)	SMALLINT NOT NULL	CN# EN800-3.0, anna 09/21 added new field to database Prompt Table: %EDITTABLE
58	RTG_CODE	Number(2,0)	SMALLINT NOT NULL	Routing Code Prompt Table: %EDITTABLE2
59	REVISION	Character(4)	VARCHAR2(4) NOT NULL	01/27/2000 RML Added "As of" label