VCHRLN_DIAG_VW

(SQL View)

SELECT BUSINESS_UNIT , VOUCHER_ID , VOUCHER_LINE_NUM , TOTAL_DISTRIBS , MAX_DISTRIB_LINE , BUSINESS_UNIT_PO , PO_ID , LINE_NBR , SCHED_NBR , DESCR , MERCHANDISE_AMT , MERCH_AMT_BSE , INV_ITEM_ID , QTY_VCHR , UNIT_OF_MEASURE , UNIT_PRICE , PROCESS_INSTANCE , WTHD_SW , FINAL_REF_IND , BUSINESS_UNIT_RECV , RECEIVER_ID , RECV_LN_NBR , RECV_SHIP_SEQ_NBR , MATCH_LINE_OPT , DISTRIB_MTHD_FLG , VCHR_AMT_FORCE_FLG , AMT_ONLY_FLG , TXN_CURRENCY_CD , BASE_CURRENCY , CURRENCY_CD , WTHD_CD , BUSINESS_UNIT_RTV , RTV_ID , RTV_LN_NBR , MATCH_LINE_STATUS , CNTRCT_ID , VOUCHER_ID_RELATED , VENDOR_ID , RECEIPT_DT , VNDR_LOC , APPR_STATUS FROM PS_VOUCHER_LINE

# 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
Default Value: 1

4 TOTAL_DISTRIBS Number(5,0) INTEGER NOT NULL Total Number of Distributions

5 MAX_DISTRIB_LINE Number(5,0) INTEGER NOT NULL Highest Distribution Line

6 BUSINESS_UNIT_PO Character(5) VARCHAR2(5) NOT NULL PO Business Unit
Prompt Table: SP_BUS_PM_NONVW

7 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
Prompt Table: %EDITTABLE14

8 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
Prompt Table: %EDITTABLE15

9 SCHED_NBR Number(3,0) SMALLINT NOT NULL Schedule Number
Prompt Table: %EDITTABLE16

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

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

12 MERCH_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Base Merchandise Amount

13 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
Prompt Table: %EDITTABLE13

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

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

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

17 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

18 WTHD_SW Character(1) VARCHAR2(1) NOT NULL Withholding Applicable Flag
B=Global and 1099
G=Global
T=1099
Y/N Table Edit
Default Value: VENDOR.WTHD_SW

19 FINAL_REF_IND Character(1) VARCHAR2(1) NOT NULL Final Reference Indicator
Y/N Table Edit
Default Value: N

20 BUSINESS_UNIT_RECV Character(5) VARCHAR2(5) NOT NULL Receiving Business Unit
Prompt Table: SP_BUS_PM_NONVW

21 RECEIVER_ID Character(10) VARCHAR2(10) NOT NULL Receiver number
Prompt Table: %EDITTABLE12

22 RECV_LN_NBR Number(5,0) INTEGER NOT NULL Receipt Line
Prompt Table: %EDITTABLE8

23 RECV_SHIP_SEQ_NBR Number(3,0) SMALLINT NOT NULL Receiver Shipping Sequence
Prompt Table: %EDITTABLE9

24 MATCH_LINE_OPT Character(1) VARCHAR2(1) NOT NULL Match Line Option
E=ERS
F=Full Match
N=Don't Match
Default Value: N

25 DISTRIB_MTHD_FLG Character(1) VARCHAR2(1) NOT NULL Distribute by
A=Amount
Q=Quantity
Default Value: A

26 VCHR_AMT_FORCE_FLG Character(1) VARCHAR2(1) NOT NULL Force Unit Price
Y/N Table Edit
Default Value: N

27 AMT_ONLY_FLG Character(1) VARCHAR2(1) NOT NULL Amount Only
N=No
Y=Yes
Y/N Table Edit
Default Value: N

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

29 BASE_CURRENCY Character(3) VARCHAR2(3) NOT NULL "Specifies the primary currency for a general ledger business unit, and is sometimes referred to as the ""book"" currency. Each business unit has one base currency. which is usually, but not always, the local currency for the organization. Journal entries are posted to a business unit in its base currency. "

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

31 WTHD_CD Character(5) VARCHAR2(5) NOT NULL Withholding Code
Prompt Table: WTHD_CD_HDR

32 BUSINESS_UNIT_RTV Character(5) VARCHAR2(5) NOT NULL RTV Business Unit

33 RTV_ID Character(10) VARCHAR2(10) NOT NULL Return To Vendor ID

34 RTV_LN_NBR Number(5,0) INTEGER NOT NULL Return To Vendor Line

35 MATCH_LINE_STATUS Character(1) VARCHAR2(1) NOT NULL Match Line Status
E=Match Error
M=Matched
N=Not Matched

36 CNTRCT_ID Character(25) VARCHAR2(25) NOT NULL Buying Agreement ID

37 VOUCHER_ID_RELATED Character(8) VARCHAR2(8) NOT NULL Related Voucher

38 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier

39 RECEIPT_DT Date(10) DATE Received Date

40 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location

41 APPR_STATUS Character(1) VARCHAR2(1) NOT NULL Approval status flag used on appr_inst_log and derived records to track virtual approver status
A=Approved
D=Denied
P=Pending
Default Value: P

#	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 Default Value: 1
4	TOTAL_DISTRIBS	Number(5,0)	INTEGER NOT NULL	Total Number of Distributions
5	MAX_DISTRIB_LINE	Number(5,0)	INTEGER NOT NULL	Highest Distribution Line
6	BUSINESS_UNIT_PO	Character(5)	VARCHAR2(5) NOT NULL	PO Business Unit Prompt Table: SP_BUS_PM_NONVW
7	PO_ID	Character(10)	VARCHAR2(10) NOT NULL	Purchase Order Prompt Table: %EDITTABLE14
8	LINE_NBR	Number(5,0)	INTEGER NOT NULL	Line Number: 11/24/08 - Added TARGET label [PC product] Prompt Table: %EDITTABLE15
9	SCHED_NBR	Number(3,0)	SMALLINT NOT NULL	Schedule Number Prompt Table: %EDITTABLE16
10	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
11	MERCHANDISE_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Merchandise Amt F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label
12	MERCH_AMT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Base Merchandise Amount
13	INV_ITEM_ID	Character(18)	VARCHAR2(18) NOT NULL	Item ID Prompt Table: %EDITTABLE13
14	QTY_VCHR	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Quantity Vouchered
15	UNIT_OF_MEASURE	Character(3)	VARCHAR2(3) NOT NULL	Used on an approval rule set. MHR=Muti Hourly PER=Percentage SQF=Square Footage Prompt Table: UNITS_TBL
16	UNIT_PRICE	Signed Number(17,5)	DECIMAL(15,5) NOT NULL	Unit Price
17	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
18	WTHD_SW	Character(1)	VARCHAR2(1) NOT NULL	Withholding Applicable Flag B=Global and 1099 G=Global T=1099 Y/N Table Edit Default Value: VENDOR.WTHD_SW
19	FINAL_REF_IND	Character(1)	VARCHAR2(1) NOT NULL	Final Reference Indicator Y/N Table Edit Default Value: N
20	BUSINESS_UNIT_RECV	Character(5)	VARCHAR2(5) NOT NULL	Receiving Business Unit Prompt Table: SP_BUS_PM_NONVW
21	RECEIVER_ID	Character(10)	VARCHAR2(10) NOT NULL	Receiver number Prompt Table: %EDITTABLE12
22	RECV_LN_NBR	Number(5,0)	INTEGER NOT NULL	Receipt Line Prompt Table: %EDITTABLE8
23	RECV_SHIP_SEQ_NBR	Number(3,0)	SMALLINT NOT NULL	Receiver Shipping Sequence Prompt Table: %EDITTABLE9
24	MATCH_LINE_OPT	Character(1)	VARCHAR2(1) NOT NULL	Match Line Option E=ERS F=Full Match N=Don't Match Default Value: N
25	DISTRIB_MTHD_FLG	Character(1)	VARCHAR2(1) NOT NULL	Distribute by A=Amount Q=Quantity Default Value: A
26	VCHR_AMT_FORCE_FLG	Character(1)	VARCHAR2(1) NOT NULL	Force Unit Price Y/N Table Edit Default Value: N
27	AMT_ONLY_FLG	Character(1)	VARCHAR2(1) NOT NULL	Amount Only N=No Y=Yes Y/N Table Edit Default Value: N
28	TXN_CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Transaction Currency
29	BASE_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	"Specifies the primary currency for a general ledger business unit, and is sometimes referred to as the ""book"" currency. Each business unit has one base currency. which is usually, but not always, the local currency for the organization. Journal entries are posted to a business unit in its base currency. "
30	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
31	WTHD_CD	Character(5)	VARCHAR2(5) NOT NULL	Withholding Code Prompt Table: WTHD_CD_HDR
32	BUSINESS_UNIT_RTV	Character(5)	VARCHAR2(5) NOT NULL	RTV Business Unit
33	RTV_ID	Character(10)	VARCHAR2(10) NOT NULL	Return To Vendor ID
34	RTV_LN_NBR	Number(5,0)	INTEGER NOT NULL	Return To Vendor Line
35	MATCH_LINE_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Match Line Status E=Match Error M=Matched N=Not Matched
36	CNTRCT_ID	Character(25)	VARCHAR2(25) NOT NULL	Buying Agreement ID
37	VOUCHER_ID_RELATED	Character(8)	VARCHAR2(8) NOT NULL	Related Voucher
38	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier
39	RECEIPT_DT	Date(10)	DATE	Received Date
40	VNDR_LOC	Character(10)	VARCHAR2(10) NOT NULL	Vendor Location
41	APPR_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Approval status flag used on appr_inst_log and derived records to track virtual approver status A=Approved D=Denied P=Pending Default Value: P