SAC_PO_LN_OUT

(SQL View)
 Index Back

PO Line View

PO Line View

SELECT A.BUSINESS_UNIT ,A.PO_ID ,A.LINE_NBR ,'A' ,'G' ,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 ,B.COMMENTS_2000 FROM PS_SAC_PO_ERP_LN_V A , PS_SAC_PO_CMNT_TBL B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.PO_ID = B.PO_ID AND A.LINE_NBR = B.LINE_NBR AND B.COMMENT_TYPE = 'LIN'

# 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 ACTN_CD Character(1) VARCHAR2(1) NOT NULL Action Code
5 PO_TYPE Character(4) VARCHAR2(4) NOT NULL PO Type
GEN=General
KAN=Kanban
6 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

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

Default Value: U

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