AP_SGLP_CI_VW (SQL View)	Index Back
EC Voucher Header View used for AP_SGLP_CI

AP_SGLP_CI_VW

(SQL View)

EC Voucher Header

View used for AP_SGLP_CI

SELECT business_unit , vchr_bld_key_c1 , vchr_bld_key_c2 , vchr_bld_key_n1 , vchr_bld_key_n2 , voucher_id , LEASE_PYMNT_DT , voucher_style , invoice_id , invoice_dt , vendor_setid , vendor_id , vndr_loc , address_seq_num , accounting_dt , gross_amt , process_instance , in_process_flg , vchr_src FROM PS_VCHR_HDR_STG

# 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 VCHR_BLD_KEY_C1 Character(25) VARCHAR2(25) NOT NULL Voucher Build Key Char 1

3 VCHR_BLD_KEY_C2 Character(25) VARCHAR2(25) NOT NULL Voucher Build Key Char 1

4 VCHR_BLD_KEY_N1 Number(10,0) DECIMAL(10) NOT NULL Voucher Build Key Num 1

5 VCHR_BLD_KEY_N2 Number(10,0) DECIMAL(10) NOT NULL Vchr Build Key Num 2

6 VOUCHER_ID Character(8) VARCHAR2(8) NOT NULL Voucher ID

7 LEASE_PYMNT_DT Date(10) DATE Lease Payment Date

8 VOUCHER_STYLE Character(4) VARCHAR2(4) NOT NULL Voucher Style
ADJ=Adjustments
AMR=Amortization Voucher
CLBK=Claim Voucher
CORR=Reversal Voucher
JRNL=Journal Voucher
PPAY=Prepaid Voucher
REG=Regular Voucher
RGTR=Register Voucher
SGLP=Single Payment Voucher
THRD=Third Party Voucher
TMPL=Template Voucher
Default Value: SGLP

9 INVOICE_ID Character(30) VARCHAR2(30) NOT NULL Invoice Number

10 INVOICE_DT Date(10) DATE Invoice Date

11 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID

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

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

14 ADDRESS_SEQ_NUM Number(5,0) INTEGER NOT NULL Address Sequence Number

15 ACCOUNTING_DT Date(10) DATE The accounting entry construction date for a given transaction (a generic field that crosses multiple

16 GROSS_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Gross Invoice Amount

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

18 IN_PROCESS_FLG Character(1) VARCHAR2(1) NOT NULL In process flag

19 VCHR_SRC Character(4) VARCHAR2(4) NOT NULL Voucher Source
Default Value: XML

#	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	VCHR_BLD_KEY_C1	Character(25)	VARCHAR2(25) NOT NULL	Voucher Build Key Char 1
3	VCHR_BLD_KEY_C2	Character(25)	VARCHAR2(25) NOT NULL	Voucher Build Key Char 1
4	VCHR_BLD_KEY_N1	Number(10,0)	DECIMAL(10) NOT NULL	Voucher Build Key Num 1
5	VCHR_BLD_KEY_N2	Number(10,0)	DECIMAL(10) NOT NULL	Vchr Build Key Num 2
6	VOUCHER_ID	Character(8)	VARCHAR2(8) NOT NULL	Voucher ID
7	LEASE_PYMNT_DT	Date(10)	DATE	Lease Payment Date
8	VOUCHER_STYLE	Character(4)	VARCHAR2(4) NOT NULL	Voucher Style ADJ=Adjustments AMR=Amortization Voucher CLBK=Claim Voucher CORR=Reversal Voucher JRNL=Journal Voucher PPAY=Prepaid Voucher REG=Regular Voucher RGTR=Register Voucher SGLP=Single Payment Voucher THRD=Third Party Voucher TMPL=Template Voucher Default Value: SGLP
9	INVOICE_ID	Character(30)	VARCHAR2(30) NOT NULL	Invoice Number
10	INVOICE_DT	Date(10)	DATE	Invoice Date
11	VENDOR_SETID	Character(5)	VARCHAR2(5) NOT NULL	Vendor SetID
12	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier
13	VNDR_LOC	Character(10)	VARCHAR2(10) NOT NULL	Vendor Location
14	ADDRESS_SEQ_NUM	Number(5,0)	INTEGER NOT NULL	Address Sequence Number
15	ACCOUNTING_DT	Date(10)	DATE	The accounting entry construction date for a given transaction (a generic field that crosses multiple
16	GROSS_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Gross Invoice Amount
17	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
18	IN_PROCESS_FLG	Character(1)	VARCHAR2(1) NOT NULL	In process flag
19	VCHR_SRC	Character(4)	VARCHAR2(4) NOT NULL	Voucher Source Default Value: XML