PV_PO_ITM_STG_V

(SQL View)
 Index Back

Staging Tbl for PO Batch Load

Date Initials Issue Description 092107 dh F-AHAYT-95051 PRICE_REQ for ePro change from number to Sign to allow negative

SELECT A.PROCESS_INSTANCE , A.BUSINESS_UNIT , A.PO_STG_TYPE , A.PO_STG_ID , A.LINE_NBR , A.SCHED_NBR , A.SHIPTO_SETID , A.SHIPTO_ID , A.SUT_BASE_ID , A.SOURCE_DATE , A.DUE_DT , A.DUE_TIME , A.STAGE_STATUS , A.SYSTEM_SOURCE , A.PO_PROCESS_ID , A.OVERRIDE_SUGG_VNDR , A.CONSOLIDATE_FLG , A.CALC_PRICE_FLG , A.CNTRCT_SPEC_FLG , A.CONVERT_UOM_FLG , A.MESSAGE_SET_NBR , A.MESSAGE_NBR , A.ITM_SETID , A.INV_ITEM_ID , A.DESCR254_MIXED , A.BUYER_ID , A.VENDOR_SETID , A.VENDOR_ID , A.VNDR_LOC , A.ITM_ID_VNDR , A.VNDR_CATALOG_ID , A.CATEGORY_ID , A.UNIT_OF_MEASURE , A.QTY_REQ , A.PRICE_REQ , A.PRICE_PO , A.MFG_ID , A.MFG_ITM_ID , A.INSPECT_CD , A.LEAD_TIME , A.FREIGHT_TERMS , A.SHIP_TYPE_ID , A.CNTRCT_SETID , A.CNTRCT_ID , A.CNTRCT_LINE_NBR , A.RELEASE_NBR , A.MILESTONE_NBR , A.CNTRCT_RATE_MULT , A.CNTRCT_RATE_DIV , A.PCT_UNIT_PRC_TOL , A.PCT_UNIT_PRC_TOL_L , A.UNIT_PRC_TOL , A.UNIT_PRC_TOL_L , A.DISTRIB_MTHD_FLG , A.ROUTING_ID , A.FROZEN_FLG , A.BUSINESS_UNIT_IN , A.PRODUCTION_ID , A.OP_SEQUENCE , A.PO_ID , A.PO_LINE_NBR , A.CONVERSION_RATE , A.MERCHANDISE_AMT , A.BAL_STATUS , A.PO_BUILT_FLG , A.INVENTORY_SRC_FLG , A.REQ_ID , A.REQ_LINE_NBR , A.REQ_SCHED_NBR , A.RFQ_ID , A.RFQ_LINE_NBR , A.DOC_BUILT_FLG , A.CURRENCY_CD , A.OPRID , A.DATETIME_MODIFIED , A.CURRENCY_CD_BASE , A.PRICE_REQ_BSE , A.QTY_REQ_STD , A.UNIT_MEASURE_STD , A.CONFIG_CODE , A.CP_TEMPLATE_ID , A.CARRIER_ID , A.ZERO_PRICE_IND , A.REPLEN_OPT , A.RECV_REQ , A.QTY_DEMAND , A.SRC_METHOD , A.AMT_ONLY_FLG , A.SEQ_NUM , A.ULTIMATE_USE_CD , A.REVISION , %subrec(PUR_USR_LIN_SBR, A) , %subrec(PUR_USR_SHP_SBR, A) , A.LIQUIDATE_METHOD , A.VRBT_ID , A.WORK_ORDER_ID , A.ADD_SCHED_FLG , A.BCKORD_ORG_SCHED , A.CHNG_SOURCE , A.PHYSICAL_NATURE , A.VAT_SVC_PERFRM_FLG , A.CC_SECURITY_ID , A.CC_USE_FLAG , %subrec(WM_WO_SBR, A) , A.ATTN_TO , A.VERSION_NBR , A.CAT_LINE_NBR , A.AUC_GROUP_ID , A.USE_CNTRCT , A.PO_GROUP_ID , A.PRIMARY_UNIT , A.UNIT_ALLOC_QTY , A.UNIT_ALLOC_AMT , A.ORIG_INV_ITEM_ID , A.DESCR254_MIXED2 , A.AUTO_SUB_FLG , A.DEFINE_PO ,A.UPN_TYPE_CD ,A.UPN_ID ,A.LN_TYPE ,A.PRICE_INITIAL , A.PRIORITY_FLG FROM PS_PO_ITM_STG A

# 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 Character(5) VARCHAR2(5) NOT NULL Business Unit
3 PO_STG_TYPE Character(1) VARCHAR2(1) NOT NULL Used in conjunction with PO_STG_ID to make a unique key on the stage tables.
O=Other
R=Requisition

Default Value: O

4 PO_STG_ID Character(10) VARCHAR2(10) NOT NULL Uniqye key to the PO Staging table
5 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
6 SCHED_NBR Number(3,0) SMALLINT NOT NULL Schedule Number
7 SHIPTO_SETID Character(5) VARCHAR2(5) NOT NULL ShipTo SetID
8 SHIPTO_ID Character(10) VARCHAR2(10) NOT NULL Ship To Location

Prompt Table: SHIPTO_TBL

9 SUT_BASE_ID Character(10) VARCHAR2(10) NOT NULL Sales/Use Tax Destination
10 SOURCE_DATE Date(10) DATE Source Date
11 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.
12 DUE_TIME Time(15) TIMESTAMP Due Time
13 STAGE_STATUS Character(1) VARCHAR2(1) NOT NULL Stage Status
B=Ready to Create
C=Completed
D=Inv Demand Build in Process
E=Error
I=In Process
N=Needs Approval
P=PO Create in Process
R=Error Recycle
S=Staged
V=POCALC in Process
W=Warning Issued
X=Reset Req and Purge

Default Value: I

14 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.
15 PO_PROCESS_ID Character(3) VARCHAR2(3) NOT NULL Shows the process that created the row on the stage table
CON=Contract Releases
CRT=PAR Location Replenishment
OLS=Manual / Expedite Requisitions
OMR=Order Management Referenced
PLL=Planning System
RFQ=Request for Quotation
SFL=Production/Shop Floor
SPO=Services Work Order
SRC=AutoSelect / Quick Source
WKM=Work Order Management
16 OVERRIDE_SUGG_VNDR Character(1) VARCHAR2(1) NOT NULL Override Suggested Vendor

Y/N Table Edit

Default Value: N

17 CONSOLIDATE_FLG Character(1) VARCHAR2(1) NOT NULL Consolidate with other Reqs
N=No
Y=Yes

Y/N Table Edit

Default Value: N

18 CALC_PRICE_FLG Character(1) VARCHAR2(1) NOT NULL Calculate Price?

Y/N Table Edit

Default Value: N

19 CNTRCT_SPEC_FLG Character(1) VARCHAR2(1) NOT NULL Contract Specified Flag

Y/N Table Edit

Default Value: N

20 CONVERT_UOM_FLG Character(1) VARCHAR2(1) NOT NULL Convert Unit of Measure

Y/N Table Edit

Default Value: N

21 MESSAGE_SET_NBR Number(5,0) INTEGER NOT NULL Message Set Number. This field refers to the Message Set Number in the Message Catalog.
22 MESSAGE_NBR Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.
23 ITM_SETID Character(5) VARCHAR2(5) NOT NULL Item SetID
24 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID

Prompt Table: ITM_ITMSETID_VW

25 DESCR254_MIXED Character(254) VARCHAR2(254) NOT NULL Description
26 BUYER_ID Character(30) VARCHAR2(30) NOT NULL Buyer
27 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
28 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
29 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location

Default Value: VENDOR.DEFAULT_LOC

30 ITM_ID_VNDR Character(50) VARCHAR2(50) NOT NULL Vendor Item ID
31 VNDR_CATALOG_ID Character(20) VARCHAR2(20) NOT NULL Vendor's Catalog Number
32 CATEGORY_ID Character(5) VARCHAR2(5) NOT NULL Category ID

Prompt Table: ITM_CAT_VW

33 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage

Prompt Table: UNITS_TBL

34 QTY_REQ Number(16,4) DECIMAL(15,4) NOT NULL Requisition Quantity
35 PRICE_REQ Signed Number(17,5) DECIMAL(15,5) NOT NULL Date Initials Issue Description 092107 dh F-AHAYT-95051 ePro change from number to Sign to allow negative
36 PRICE_PO Signed Number(17,5) DECIMAL(15,5) NOT NULL Purchase Order Price
37 MFG_ID Character(50) VARCHAR2(50) NOT NULL Manufacturer ID

Prompt Table: MANUFACTURER

38 MFG_ITM_ID Character(50) VARCHAR2(50) NOT NULL Manufacturer's Item ID
39 INSPECT_CD Character(1) VARCHAR2(1) NOT NULL Inspection Required
N=No
Y=Yes

Y/N Table Edit

40 LEAD_TIME Number(3,0) SMALLINT NOT NULL Lead Time Days
41 FREIGHT_TERMS Character(10) VARCHAR2(10) NOT NULL Freight Terms Code

Prompt Table: FREIGHT_TERMS

42 SHIP_TYPE_ID Character(10) VARCHAR2(10) NOT NULL Ship Via Code

Prompt Table: SHIP_METHOD

43 CNTRCT_SETID Character(5) VARCHAR2(5) NOT NULL SetID
44 CNTRCT_ID Character(25) VARCHAR2(25) NOT NULL Buying Agreement ID
45 CNTRCT_LINE_NBR Number(5,0) INTEGER NOT NULL Buying Agreement Line Nbr

Prompt Table: CNTRCT_LN_SRCH

46 RELEASE_NBR Number(5,0) INTEGER NOT NULL Release Number
47 MILESTONE_NBR Number(5,0) INTEGER NOT NULL Milestone Line Number
48 CNTRCT_RATE_MULT Number(16,8) DECIMAL(15,8) NOT NULL Contract Rate Multiplier

Default Value: 1

49 CNTRCT_RATE_DIV Number(16,8) DECIMAL(15,8) NOT NULL Contract Rate Divider

Default Value: 1

50 PCT_UNIT_PRC_TOL Number(6,2) DECIMAL(5,2) NOT NULL % Unit Price Tolerance
51 PCT_UNIT_PRC_TOL_L Number(6,2) DECIMAL(5,2) NOT NULL % Unit Price Tolerance - Under
52 UNIT_PRC_TOL Number(14,5) DECIMAL(13,5) NOT NULL Unit Price Tolerance
53 UNIT_PRC_TOL_L Number(14,5) DECIMAL(13,5) NOT NULL Unit Price Tolerance - Under
54 DISTRIB_MTHD_FLG Character(1) VARCHAR2(1) NOT NULL Distribute by
A=Amount
Q=Quantity
55 ROUTING_ID Character(10) VARCHAR2(10) NOT NULL Inspection Routing ID

Prompt Table: ROUTING_HDR

56 FROZEN_FLG Character(1) VARCHAR2(1) NOT NULL Frozen Flag
B=Both
N=No
Y=Yes

Default Value: N

57 BUSINESS_UNIT_IN Character(5) VARCHAR2(5) NOT NULL Inventory Unit
58 PRODUCTION_ID Character(10) VARCHAR2(10) NOT NULL Production ID
59 OP_SEQUENCE Number(4,0) SMALLINT NOT NULL Operation Sequence
60 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
61 PO_LINE_NBR Number(5,0) INTEGER NOT NULL Purchase Order Line Number
62 CONVERSION_RATE Signed Number(17,8) DECIMAL(15,8) NOT NULL Conversion Rate
63 MERCHANDISE_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Merchandise Amt F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label
64 BAL_STATUS Character(1) VARCHAR2(1) NOT NULL A flag that indicates whether or not the control totals for a deposit match the entered totals. A deposit is considered "balanced" when the two sets of totals are equal.
I=Balanced
O=Not Balanced
65 PO_BUILT_FLG Character(1) VARCHAR2(1) NOT NULL Indicates if PO already exists or not.

Y/N Table Edit

Default Value: N

66 INVENTORY_SRC_FLG Character(1) VARCHAR2(1) NOT NULL Inventory Source Flag

Y/N Table Edit

Default Value: N

67 REQ_ID Character(10) VARCHAR2(10) NOT NULL Requisition ID
68 REQ_LINE_NBR Number(5,0) INTEGER NOT NULL Requisition Line Number
69 REQ_SCHED_NBR Number(3,0) SMALLINT NOT NULL Requisition Schedule Number
70 RFQ_ID Character(10) VARCHAR2(10) NOT NULL RFQ ID
71 RFQ_LINE_NBR Number(5,0) INTEGER NOT NULL RFQ Line
72 DOC_BUILT_FLG Character(1) VARCHAR2(1) NOT NULL Document Built Flag

Y/N Table Edit

Default Value: N

73 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
74 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
75 DATETIME_MODIFIED DateTime(26) TIMESTAMP Datetime Modified
76 CURRENCY_CD_BASE Character(3) VARCHAR2(3) NOT NULL Business Unit Base Currency
77 PRICE_REQ_BSE Signed Number(17,5) DECIMAL(15,5) NOT NULL Date Initials Issue Description 092107 dh F-AHAYT-95051 ePro change from number to Sign to allow negative
78 QTY_REQ_STD Number(16,4) DECIMAL(15,4) NOT NULL Quantity Requested Stand. UOM
79 UNIT_MEASURE_STD Character(3) VARCHAR2(3) NOT NULL Standard Unit of Measure
80 CONFIG_CODE Character(50) VARCHAR2(50) NOT NULL Product Configurator
81 CP_TEMPLATE_ID Character(10) VARCHAR2(10) NOT NULL Template ID Field
82 CARRIER_ID Character(10) VARCHAR2(10) NOT NULL Carrier ID
83 ZERO_PRICE_IND Character(1) VARCHAR2(1) NOT NULL Zero Price Indicator

Default Value: N

84 REPLEN_OPT Character(2) VARCHAR2(2) NOT NULL Replenish Code
01=Standard
02=Stockless
85 RECV_REQ Character(1) VARCHAR2(1) NOT NULL Receiving Required
N=Optional
X=Do Not
Y=Required

Y/N Table Edit

86 QTY_DEMAND Number(16,4) DECIMAL(15,4) NOT NULL Qty Sourced from Demand
87 SRC_METHOD Character(1) VARCHAR2(1) NOT NULL Sourcing Method
B=Basic
F=Flexible
H=Cumulative Split
S=Sched Split
88 AMT_ONLY_FLG Character(1) VARCHAR2(1) NOT NULL Amount Only
N=No
Y=Yes

Default Value: N

89 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence
90 ULTIMATE_USE_CD Character(8) VARCHAR2(8) NOT NULL Ultimate Use Code
91 REVISION Character(4) VARCHAR2(4) NOT NULL 01/27/2000 RML Added "As of" label
92 USER_LINE_CHAR1 Character(1) VARCHAR2(1) NOT NULL Custom Character 1
93 CUSTOM_C100_B1 Character(100) VARCHAR2(100) NOT NULL Custom Field 1
94 CUSTOM_C100_B2 Character(100) VARCHAR2(100) NOT NULL Custom Field 2
95 CUSTOM_C100_B3 Character(100) VARCHAR2(100) NOT NULL Custom Field 3
96 CUSTOM_C100_B4 Character(100) VARCHAR2(100) NOT NULL Custom Field 4
97 CUSTOM_DATE_B Date(10) DATE Custom Date
98 CUSTOM_C1_B Character(1) VARCHAR2(1) NOT NULL Custom Character 2
99 USER_SCHED_CHAR1 Character(1) VARCHAR2(1) NOT NULL Custom Character 1
100 CUSTOM_C100_C1 Character(100) VARCHAR2(100) NOT NULL Custom Field 1
101 CUSTOM_C100_C2 Character(100) VARCHAR2(100) NOT NULL Custom Field 2
102 CUSTOM_C100_C3 Character(100) VARCHAR2(100) NOT NULL Custom Field 3
103 CUSTOM_DATE_C1 Date(10) DATE Custom Date 1
104 CUSTOM_DATE_C2 Date(10) DATE Custom Date 2
105 CUSTOM_C1_C Character(1) VARCHAR2(1) NOT NULL Custom Character 2
106 LIQUIDATE_METHOD Character(1) VARCHAR2(1) NOT NULL Liquidate by
A=Amount
Q=Quantity
107 VRBT_ID Character(25) VARCHAR2(25) NOT NULL Vendor Rebate ID
108 WORK_ORDER_ID Character(15) VARCHAR2(15) NOT NULL Work Order ID
109 ADD_SCHED_FLG Character(1) VARCHAR2(1) NOT NULL Indicates if schedule is being added to a PO
110 BCKORD_ORG_SCHED Number(3,0) SMALLINT NOT NULL Original schedule number
111 CHNG_SOURCE Character(3) VARCHAR2(3) NOT NULL Change Source
BPA=Contract Release to Single PO
CAP=Contract Batch Auto Approval
CRT=PAR Replenish/Close Backorders
CST=Close Short Purchase Orders
DRP=Order Management Referenced
EDX=PO Acknowledgments
EMC=Req. Requester Mass Change
EPO=eProcurement Change Request
EPR=User Change Request
IMC=Inventory Mass Change
ONL=On-line Purchase Order
PLN=Planning System
PMC=PO Buyer Mass Change
POC=PO Change Batch Process
PRD=Production/Shop Floor
112 PHYSICAL_NATURE Character(1) VARCHAR2(1) NOT NULL Physical Nature
G=Goods
S=Services
113 VAT_SVC_PERFRM_FLG Character(1) VARCHAR2(1) NOT NULL Where VAT Services Physically Performed Flag
1=Ship To Location
2=Ship From Location
3=Buyer's Location
4=Supplier's Location
114 CC_SECURITY_ID Number(10,0) DECIMAL(10) NOT NULL Procurement Card Number
115 CC_USE_FLAG Character(1) VARCHAR2(1) NOT NULL Use Procurement Card

Y/N Table Edit

Default Value: N

116 BUSINESS_UNIT_WO Character(5) VARCHAR2(5) NOT NULL Business Unit Work Order

Prompt Table: SP_BU_WM_NONVW

117 WO_ID Character(10) VARCHAR2(10) NOT NULL Work Order Identification

Prompt Table: %EDIT_WO_ID

118 WO_TASK_ID Number(5,0) INTEGER NOT NULL Task Number

Prompt Table: %EDIT_WO_TASK

119 RSRC_TYPE Character(1) VARCHAR2(1) NOT NULL Work Order Management Resource Types
1=Labor
2=Tools
3=Material
120 RES_LN_NBR Number(5,0) INTEGER NOT NULL Resource Line No.

Prompt Table: %EDIT_RES_LINE

121 ATTN_TO Character(30) VARCHAR2(30) NOT NULL Attention
122 VERSION_NBR Number(5,0) INTEGER NOT NULL Contract Version number
123 CAT_LINE_NBR Number(5,0) INTEGER NOT NULL Contract Category Line Number
124 AUC_GROUP_ID Character(18) VARCHAR2(18) NOT NULL GroupID
125 USE_CNTRCT Character(1) VARCHAR2(1) NOT NULL Use Contract if Available
N=No
Y=Yes

Default Value: Y

126 PO_GROUP_ID Character(18) VARCHAR2(18) NOT NULL GroupID
127 PRIMARY_UNIT Character(1) VARCHAR2(1) NOT NULL Primary Unit
N=No
Y=Yes
128 UNIT_ALLOC_QTY Number(16,4) DECIMAL(15,4) NOT NULL Unit Allocation Qty
129 UNIT_ALLOC_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Unit Allocation Amt
130 ORIG_INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Used to identify the original item ordered, in case an item substitution has taken place.
131 DESCR254_MIXED2 Character(254) VARCHAR2(254) NOT NULL Long Description
132 AUTO_SUB_FLG Character(1) VARCHAR2(1) NOT NULL Auto Item Substitution
N=No
S=Substituted by Sourcing
Y=Yes

Y/N Table Edit

Default Value: Y

133 DEFINE_PO Character(1) VARCHAR2(1) NOT NULL Define PO

Default Value: N

134 UPN_TYPE_CD Character(4) VARCHAR2(4) NOT NULL Universal Product Number Format Type
135 UPN_ID Character(20) VARCHAR2(20) NOT NULL Universal Product Number
136 LN_TYPE Character(4) VARCHAR2(4) NOT NULL Line Type
CAT=Catalog Item
CUST=Custom Item
DC=Direct Connect Item
DCEX=Exchange Item
DCPO=Punchout Item
DCRT=Round Trip
DCTP=Transparent Punchout Item
DESR=Ad-hoc Item
EF=Express Form Item
OS=Order Sheet
SDF=Supplemental Data Form
SPRO=Service
SR=ePro Special Request Item
SRFC=Fixed Cost Service Item
SRTM=Time and Material Service Item
SRVC=Variable Cost Service Item
137 PRICE_INITIAL Signed Number(17,5) DECIMAL(15,5) NOT NULL Punchout Price
138 PRIORITY_FLG Character(1) VARCHAR2(1) NOT NULL Priority Flag
1=High
2=Medium
3=Low