SF_RPL_ITM_EVW2

(SQL View)
 Index Back

Outbound Repl Itm Staging Tbl


SELECT VENDOR_SETID , VENDOR_ID , VNDR_LOC , BUSINESS_UNIT , INV_ITEM_ID , UNIT_OF_MEASURE , ITM_ID_VNDR , INV_ITEM_HEIGHT , INV_ITEM_LENGTH , INV_ITEM_VOLUME , INV_ITEM_WEIGHT , INV_ITEM_WIDTH , VNDR_CATALOG_ID , MFG_ID , MFG_ITM_ID , ITEM_QTY , PROCESS_INSTANCE , AUDIT_ACTN , IN_PROCESS_FLG FROM PS_SF_RPL_ITM_STG

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
2 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
3 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location
4 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
5 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
6 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
7 ITM_ID_VNDR Character(50) VARCHAR2(50) NOT NULL Vendor Item ID
8 INV_ITEM_HEIGHT Signed Number(17,4) DECIMAL(15,4) NOT NULL Item Height
9 INV_ITEM_LENGTH Signed Number(17,4) DECIMAL(15,4) NOT NULL Item Length
10 INV_ITEM_VOLUME Signed Number(17,4) DECIMAL(15,4) NOT NULL Volume
11 INV_ITEM_WEIGHT Signed Number(17,4) DECIMAL(15,4) NOT NULL Item Weight
12 INV_ITEM_WIDTH Signed Number(17,4) DECIMAL(15,4) NOT NULL Item Width
13 VNDR_CATALOG_ID Character(20) VARCHAR2(20) NOT NULL Vendor's Catalog Number
14 MFG_ID Character(50) VARCHAR2(50) NOT NULL Manufacturer ID
15 MFG_ITM_ID Character(50) VARCHAR2(50) NOT NULL Manufacturer's Item ID
16 ITEM_QTY Number(12,4) DECIMAL(11,4) NOT NULL Item Quantity
17 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
18 AUDIT_ACTN Character(1) VARCHAR2(1) NOT NULL Audit Action Code for Application Messages. This tells the subscriber whether the row has been added, changed, or deleted.
A=Add
C=Change Old (PPR Only)
D=Delete
K=Change - Old Values
N=Change - New Values
O=Change - Original Values
19 IN_PROCESS_FLG Character(1) VARCHAR2(1) NOT NULL In process flag