AP_APPR_LNM_VW

(SQL View)
 Index Back

Voucher Line data for Mobile

Voucher Line data for Mobile approvals

SELECT B.BUSINESS_UNIT , B.VOUCHER_ID , B.VOUCHER_LINE_NUM , B.DESCR , B.MERCHANDISE_AMT , B.TXN_CURRENCY_CD , B.INV_ITEM_ID , B.QTY_VCHR , B.UNIT_PRICE , B.UNIT_OF_MEASURE , B.BUSINESS_UNIT_PO , B.PO_ID , B.LINE_NBR , B.SCHED_NBR , B.SHIPTO_ID FROM PS_VCHR_AF_HDR_VW A , PS_VOUCHER_LINE B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.VOUCHER_ID = B.VOUCHER_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: SP_BU_AP_NONVW

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 DESCR Character(30) VARCHAR2(30) NOT NULL Description
5 MERCHANDISE_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Merchandise Amt F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label
6 TXN_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Transaction Currency
7 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
8 QTY_VCHR Signed Number(17,4) DECIMAL(15,4) NOT NULL Quantity Vouchered
9 UNIT_PRICE Signed Number(17,5) DECIMAL(15,5) NOT NULL Unit Price
10 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
11 BUSINESS_UNIT_PO Character(5) VARCHAR2(5) NOT NULL PO Business Unit
12 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
13 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
14 SCHED_NBR Number(3,0) SMALLINT NOT NULL Schedule Number
15 SHIPTO_ID Character(10) VARCHAR2(10) NOT NULL Ship To Location