VCHR_GRP_ID_VW

(SQL View)
Index Back

Vchr Procurement Grp View

Voucher Procurement Group ID View

SELECT C.SETID , B.PO_GROUP_ID , A.BUSINESS_UNIT , A.VOUCHER_ID , B.VOUCHER_LINE_NUM , B.INV_ITEM_ID , B.BUSINESS_UNIT_PO , B.PO_ID , B.BUSINESS_UNIT_RECV , B.RECEIVER_ID , B.QTY_VCHR , B.DESCR254_MIXED , B.PRIMARY_UNIT , B.UNIT_ALLOC_QTY , B.UNIT_ALLOC_AMT , B.VENDOR_ID , A.INVOICE_DT , A.INVOICE_ID FROM PS_VOUCHER A , PS_VOUCHER_LINE B , PS_SET_CNTRL_REC C WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.VOUCHER_ID = B.VOUCHER_ID AND A.BUSINESS_UNIT = C.SETCNTRLVALUE AND C.RECNAME = 'PO_GROUP_TBL'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

Default Value: OPR_DEF_TBL_FS.SETID

2 PO_GROUP_ID Character(18) VARCHAR2(18) NOT NULL GroupID
3 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
4 VOUCHER_ID Character(8) VARCHAR2(8) NOT NULL Voucher ID
5 VOUCHER_LINE_NUM Number(5,0) INTEGER NOT NULL Voucher Line Number
6 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
7 BUSINESS_UNIT_PO Character(5) VARCHAR2(5) NOT NULL PO Business Unit
8 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
9 BUSINESS_UNIT_RECV Character(5) VARCHAR2(5) NOT NULL Receiving Business Unit
10 RECEIVER_ID Character(10) VARCHAR2(10) NOT NULL Receiver number
11 QTY_VCHR Signed Number(17,4) DECIMAL(15,4) NOT NULL Quantity Vouchered
12 DESCR254_MIXED Character(254) VARCHAR2(254) NOT NULL Description
13 PRIMARY_UNIT Character(1) VARCHAR2(1) NOT NULL Primary Unit
N=No
Y=Yes
14 UNIT_ALLOC_QTY Number(16,4) DECIMAL(15,4) NOT NULL Unit Allocation Qty
15 UNIT_ALLOC_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Unit Allocation Amt
16 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
17 INVOICE_DT Date(10) DATE Invoice Date
18 INVOICE_ID Character(30) VARCHAR2(30) NOT NULL Invoice Number