EM_VCHR_LN_DISP (SQL View)	Index Back
Voucher Line

EM_VCHR_LN_DISP

(SQL View)

Voucher Line

SELECT F.BUSINESS_UNIT , F.VOUCHER_ID , F.VOUCHER_LINE_NUM , F.PO_ID , F.INV_ITEM_ID , F.DESCR , G.QTY_VCHR , F.UNIT_OF_MEASURE , F.UNIT_PRICE , G.MERCHANDISE_AMT , F.TXN_CURRENCY_CD , G.SALETX_AMT , G.USETAX_AMT , G.CURRENCY_CD , G.VAT_INV_AMT , G.VAT_NONINV_AMT , G.TXN_CURRENCY_CD , G.TAX_CD_SUT_PCT , G.TAX_CD_VAT_PCT FROM PS_VOUCHER_LINE F , PS_DISTRIB_LINE G WHERE F.BUSINESS_UNIT = G.BUSINESS_UNIT AND F.VOUCHER_ID = G.VOUCHER_ID AND F.VOUCHER_LINE_NUM = G.VOUCHER_LINE_NUM

Parent record: VOUCHER

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Prompt Table: BUS_UNIT_TBL_FS

2 VOUCHER_ID Character(8) VARCHAR2(8) NOT NULL Voucher ID
Prompt Table: VOUCHER

3 VOUCHER_LINE_NUM Number(5,0) INTEGER NOT NULL Voucher Line Number

4 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order

5 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID

6 DESCR Character(30) VARCHAR2(30) NOT NULL Description

7 QTY_VCHR Signed Number(17,4) DECIMAL(15,4) NOT NULL Quantity Vouchered

8 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage

9 UNIT_PRICE Signed Number(17,5) DECIMAL(15,5) NOT NULL Unit Price

10 MERCHANDISE_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Merchandise Amt F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label

11 TXN_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Transaction Currency

12 SALETX_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Sales Tax Amount

13 USETAX_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount

14 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

15 VAT_INV_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT Invoice Amount

16 VAT_NONINV_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT Non-Invoice Amount

17 TXN_CURRENCY_CD2 Character(3) VARCHAR2(3) NOT NULL Transaction Currency Display

18 TAX_CD_SUT_PCT Number(8,4) DECIMAL(7,4) NOT NULL Sales/Use Tax Code Percent

19 TAX_CD_VAT_PCT Signed Number(9,4) DECIMAL(7,4) NOT NULL Specifies the tax percentage that corresponds to the VAT code. If more than one VAT authority is linked to a VAT code this will represent an aggregate percentage.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Prompt Table: BUS_UNIT_TBL_FS
2	VOUCHER_ID	Character(8)	VARCHAR2(8) NOT NULL	Voucher ID Prompt Table: VOUCHER
3	VOUCHER_LINE_NUM	Number(5,0)	INTEGER NOT NULL	Voucher Line Number
4	PO_ID	Character(10)	VARCHAR2(10) NOT NULL	Purchase Order
5	INV_ITEM_ID	Character(18)	VARCHAR2(18) NOT NULL	Item ID
6	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
7	QTY_VCHR	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Quantity Vouchered
8	UNIT_OF_MEASURE	Character(3)	VARCHAR2(3) NOT NULL	Used on an approval rule set. MHR=Muti Hourly PER=Percentage SQF=Square Footage
9	UNIT_PRICE	Signed Number(17,5)	DECIMAL(15,5) NOT NULL	Unit Price
10	MERCHANDISE_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Merchandise Amt F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label
11	TXN_CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Transaction Currency
12	SALETX_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Sales Tax Amount
13	USETAX_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Amount
14	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
15	VAT_INV_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	VAT Invoice Amount
16	VAT_NONINV_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	VAT Non-Invoice Amount
17	TXN_CURRENCY_CD2	Character(3)	VARCHAR2(3) NOT NULL	Transaction Currency Display
18	TAX_CD_SUT_PCT	Number(8,4)	DECIMAL(7,4) NOT NULL	Sales/Use Tax Code Percent
19	TAX_CD_VAT_PCT	Signed Number(9,4)	DECIMAL(7,4) NOT NULL	Specifies the tax percentage that corresponds to the VAT code. If more than one VAT authority is linked to a VAT code this will represent an aggregate percentage.