BUSINESS_UNITVOUCHER_IDVOUCHER_LINE_NUMDISTRIB_LINE_NUMVCH_IPAC_SRC_VW(SQL View) |
Index Back |
|---|---|
Voucher IPAC Source ViewSQL View on stored voucher data, used to source initial data and defaults for AP_IPAC_DTL scroll lines. |
| SELECT A.BUSINESS_UNIT , A.VOUCHER_ID , B.VOUCHER_LINE_NUM , C.DISTRIB_LINE_NUM , %Substring(A.INVOICE_ID,1,22) , A.INVOICE_DT , (A.BUSINESS_UNIT %Concat A.VOUCHER_ID) , B.CNTRCT_LINE_NBR , %Substring(B.CNTRCT_ID,1,17) , B.PO_ID , C.QTY_VCHR , %Substring(B.UNIT_OF_MEASURE,1,2) , B.UNIT_PRICE , C.MERCHANDISE_AMT , %subrec(CF12_AN_SBR, C) , C.BUSINESS_UNIT_GL , B.PO_ID FROM PS_VOUCHER A , PS_VOUCHER_LINE B , PS_DISTRIB_LINE C WHERE B.BUSINESS_UNIT_PO <> ' ' AND B.PO_ID <> ' ' AND B.BUSINESS_UNIT = A.BUSINESS_UNIT AND B.VOUCHER_ID = A.VOUCHER_ID AND C.BUSINESS_UNIT = B.BUSINESS_UNIT AND C.VOUCHER_ID = B.VOUCHER_ID AND C.VOUCHER_LINE_NUM = B.VOUCHER_LINE_NUM |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | VOUCHER_ID |
Character(8) | VARCHAR2(8) NOT NULL | Voucher ID |
| 3 | VOUCHER_LINE_NUM |
Number(5,0) | INTEGER NOT NULL | Voucher Line Number |
| 4 | DISTRIB_LINE_NUM |
Number(5,0) | INTEGER NOT NULL | Distribution Line |
| 5 | INVOICE_ID | Character(30) | VARCHAR2(30) NOT NULL | Invoice Number |
| 6 | INVOICE_DT | Date(10) | DATE | Invoice Date |
| 7 | IPAC_TRACE_NUM | Character(15) | VARCHAR2(15) NOT NULL | IPAC Trace ID |
| 8 | CNTRCT_LINE_NBR | Number(5,0) | INTEGER NOT NULL | Buying Agreement Line Nbr |
| 9 | IPAC_CNTRCT_NUM | Character(17) | VARCHAR2(17) NOT NULL | Contract Number |
| 10 | IPAC_PO_ID | Character(22) | VARCHAR2(22) NOT NULL | IPAC Purchase Order |
| 11 | IPAC_QUANTITY | Signed Number(18,4) | DECIMAL(16,4) NOT NULL | IPAC Quantity |
| 12 | UNIT_OF_ISSUE | Character(2) | VARCHAR2(2) NOT NULL | Unit of Issue |
| 13 | IPAC_UNIT_PRICE | Signed Number(26,5) | DECIMAL(24,5) NOT NULL | IPAC Unit Price |
| 14 | IPAC_LN_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Line Amount |
| 15 | OPERATING_UNIT | Character(8) | VARCHAR2(8) NOT NULL | Operating Unit ChartField |
| 16 | PRODUCT | Character(6) | VARCHAR2(6) NOT NULL | Product ChartField |
| 17 | FUND_CODE | Character(5) | VARCHAR2(5) NOT NULL | Fund Code |
| 18 | CLASS_FLD | Character(5) | VARCHAR2(5) NOT NULL | Class Field |
| 19 | PROGRAM_CODE | Character(5) | VARCHAR2(5) NOT NULL | Program Code ChartField |
| 20 | BUDGET_REF | Character(8) | VARCHAR2(8) NOT NULL | Budget Reference |
| 21 | AFFILIATE | Character(5) | VARCHAR2(5) NOT NULL | Affiliate |
| 22 | AFFILIATE_INTRA1 | Character(10) | VARCHAR2(10) NOT NULL | IntraUnit Affiliate1 |
| 23 | AFFILIATE_INTRA2 | Character(10) | VARCHAR2(10) NOT NULL | Operating Unit Affiliate |
| 24 | CHARTFIELD1 | Character(10) | VARCHAR2(10) NOT NULL | Expansion chartfield 1 |
| 25 | CHARTFIELD2 | Character(10) | VARCHAR2(10) NOT NULL | Expansion Chartfield 2 |
| 26 | CHARTFIELD3 | Character(10) | VARCHAR2(10) NOT NULL | Expansion Chartfield 3 |
| 27 | BUSINESS_UNIT_GL | Character(5) | VARCHAR2(5) NOT NULL | GL Business Unit |
| 28 | IPAC_OBL_DOC_NBR | Character(17) | VARCHAR2(17) NOT NULL | Obligation Document Number |