VCHR_GRP_ID_VW(SQL View) |
Index Back |
---|---|
Vchr Procurement Grp ViewVoucher 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 |