SAC_PO_ERP_LN_V

(SQL View)
 Index Back

Line View


SELECT A.BUSINESS_UNIT ,A.PO_ID ,A.LINE_NBR ,A.CANCEL_STATUS ,A.CHANGE_STATUS ,A.ITM_SETID ,A.INV_ITEM_ID ,A.CATEGORY_ID ,A.VNDR_CATALOG_ID ,A.ITM_ID_VNDR ,A.MFG_ID ,A.MFG_ITM_ID ,A.CHNG_ORD_SEQ ,A.UNIT_OF_MEASURE ,A.CNTRCT_SETID ,A.CNTRCT_ID ,A.CNTRCT_LINE_NBR ,A.DESCR254_MIXED ,A.PACKING_WEIGHT ,A.PACKING_VOLUME ,A.UNIT_MEASURE_WT ,A.UNIT_MEASURE_VOL ,A.PHYSICAL_NATURE ,A.AMT_ONLY_FLG FROM PS_SAC_PO_LINE_VW A

# 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 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

Default Value: A

5 CHANGE_STATUS Character(1) VARCHAR2(1) NOT NULL Change Order Status
C=Changed
U=Unchanged

Default Value: U

6 ITM_SETID Character(5) VARCHAR2(5) NOT NULL Item SetID
7 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
8 CATEGORY_ID Character(5) VARCHAR2(5) NOT NULL Category ID
9 VNDR_CATALOG_ID Character(20) VARCHAR2(20) NOT NULL Vendor's Catalog Number
10 ITM_ID_VNDR Character(50) VARCHAR2(50) NOT NULL Vendor Item ID
11 MFG_ID Character(50) VARCHAR2(50) NOT NULL Manufacturer ID
12 MFG_ITM_ID Character(50) VARCHAR2(50) NOT NULL Manufacturer's Item ID
13 CHNG_ORD_SEQ Number(3,0) SMALLINT NOT NULL Change Order Sequence Number
14 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
15 CNTRCT_SETID Character(5) VARCHAR2(5) NOT NULL SetID
16 CNTRCT_ID Character(25) VARCHAR2(25) NOT NULL Buying Agreement ID
17 CNTRCT_LINE_NBR Number(5,0) INTEGER NOT NULL Buying Agreement Line Nbr
18 DESCR254_MIXED Character(254) VARCHAR2(254) NOT NULL Description
19 PACKING_WEIGHT Signed Number(17,4) DECIMAL(15,4) NOT NULL Packing Weight
20 PACKING_VOLUME Signed Number(17,4) DECIMAL(15,4) NOT NULL Packing Volume
21 UNIT_MEASURE_WT Character(3) VARCHAR2(3) NOT NULL Weight UOM
22 UNIT_MEASURE_VOL Character(3) VARCHAR2(3) NOT NULL Volume UOM
23 PHYSICAL_NATURE Character(1) VARCHAR2(1) NOT NULL Physical Nature
G=Goods
S=Services
24 AMT_ONLY_FLG Character(1) VARCHAR2(1) NOT NULL Amount Only
N=No
Y=Yes