VCHR_PYM_UPD_HD (SQL View)	Index Back
Selective Payment Update Selective Payment Update Header

VCHR_PYM_UPD_HD

(SQL View)

Selective Payment Update

Selective Payment Update Header

SELECT DISTINCT A.BUSINESS_UNIT , A.VOUCHER_ID , A.INVOICE_ID , A.VENDOR_SETID , A.VENDOR_ID , A.VOUCHER_STYLE , A.VOUCHER_ID_RELATED , A.ENTRY_STATUS , A.VCHR_SRC , A.INVOICE_DT , A.PYMNT_TERMS_CD , A.GROSS_AMT , A.TXN_CURRENCY_CD , A.GRP_AP_ID , A.BUDGET_HDR_STATUS , A.BUDGET_MISC_STATUS , A.BASE_CURRENCY , A.APPR_STATUS , A.VCHR_LINE_APPR , A.BUSINESS_UNIT_GL , A.MATCH_STATUS_VCHR FROM PS_VOUCHER A , PS_PYMNT_VCHR_XREF B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.VOUCHER_ID = B.VOUCHER_ID AND A.VCHR_DRAFT_FLG <> 'Y' AND B.PYMNT_TYPE = 'R' AND B.PYMNT_SELCT_STATUS = 'N' AND B.PYMNT_ACTION = 'S' AND A.ENTRY_STATUS <> 'X' AND A.VOUCHER_STYLE IN ('REG','ADJ')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
Prompt Table: SP_BU_AP_NONVW

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

3 INVOICE_ID Character(30) VARCHAR2(30) NOT NULL Invoice Number
Prompt Table: INVOICE_ID_VW3

4 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
Default Value: VENDOR.SETID

5 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
Prompt Table: VENDOR_PRIM_VW

6 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: REG

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

8 ENTRY_STATUS Character(1) VARCHAR2(1) NOT NULL If translate values are added or changed, modify the following code to make sure the values appear accurately in the dropdown list in the search dialog: VCHR_SRCH_DEL.ENTRY_STATUS.SearchInit. Template Voucher status should not be visibile in the drop down.
C=Complete
D=Through batch defaults
E=Edited by Batch Voucher Module
L=Reviewed through Maintenance
M=Modified
O=Open
P=Postable
R=Recycle
S=Scheduled for Payment
T=Template Voucher
X=Deleted

9 VCHR_SRC Character(4) VARCHAR2(4) NOT NULL Voucher Source

10 INVOICE_DT Date(10) DATE Invoice Date

11 PYMNT_TERMS_CD Character(5) VARCHAR2(5) NOT NULL Specifies how the payment due date and discount due date are calculated. A payment terms code is associated with various business units bill-to customers vendors as well as sales orders purchase orders and vouchers.

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

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

14 GRP_AP_ID Character(10) VARCHAR2(10) NOT NULL Control Group ID

15 BUDGET_HDR_STATUS Character(1) VARCHAR2(1) NOT NULL Budget Checking Header Status
E=Error in Budget Check
I=Document In Processing
N=Not Budget Checked
P=Provisionally Valid
V=Valid

16 BUDGET_MISC_STATUS Character(1) VARCHAR2(1) NOT NULL Budget Checking Misc Status
E=Error in Budget Check
N=Not Budget Checked
P=Provisionally Valid
V=Valid Budget Check

17 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. "

18 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

19 VCHR_LINE_APPR Character(1) VARCHAR2(1) NOT NULL Invoice Line Approval Status
0=Line Routing Not Required
1=Completed
2=Routed for Approval

20 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit

21 MATCH_STATUS_VCHR Character(1) VARCHAR2(1) NOT NULL Match Status
C=Overridden - Credit Note
D=Match Dispute
E=Match Exceptions Exist
M=Matched
N=Not Applicable
O=Manually Overridden
T=To Be Matched

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: SP_BU_AP_NONVW
2	VOUCHER_ID	Character(8)	VARCHAR2(8) NOT NULL	Voucher ID Prompt Table: VCHR_PYM_UPD_HD
3	INVOICE_ID	Character(30)	VARCHAR2(30) NOT NULL	Invoice Number Prompt Table: INVOICE_ID_VW3
4	VENDOR_SETID	Character(5)	VARCHAR2(5) NOT NULL	Vendor SetID Default Value: VENDOR.SETID
5	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier Prompt Table: VENDOR_PRIM_VW
6	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: REG
7	VOUCHER_ID_RELATED	Character(8)	VARCHAR2(8) NOT NULL	Related Voucher
8	ENTRY_STATUS	Character(1)	VARCHAR2(1) NOT NULL	If translate values are added or changed, modify the following code to make sure the values appear accurately in the dropdown list in the search dialog: VCHR_SRCH_DEL.ENTRY_STATUS.SearchInit. Template Voucher status should not be visibile in the drop down. C=Complete D=Through batch defaults E=Edited by Batch Voucher Module L=Reviewed through Maintenance M=Modified O=Open P=Postable R=Recycle S=Scheduled for Payment T=Template Voucher X=Deleted
9	VCHR_SRC	Character(4)	VARCHAR2(4) NOT NULL	Voucher Source
10	INVOICE_DT	Date(10)	DATE	Invoice Date
11	PYMNT_TERMS_CD	Character(5)	VARCHAR2(5) NOT NULL	Specifies how the payment due date and discount due date are calculated. A payment terms code is associated with various business units bill-to customers vendors as well as sales orders purchase orders and vouchers.
12	GROSS_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Gross Invoice Amount
13	TXN_CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Transaction Currency
14	GRP_AP_ID	Character(10)	VARCHAR2(10) NOT NULL	Control Group ID
15	BUDGET_HDR_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Budget Checking Header Status E=Error in Budget Check I=Document In Processing N=Not Budget Checked P=Provisionally Valid V=Valid
16	BUDGET_MISC_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Budget Checking Misc Status E=Error in Budget Check N=Not Budget Checked P=Provisionally Valid V=Valid Budget Check
17	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. "
18	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
19	VCHR_LINE_APPR	Character(1)	VARCHAR2(1) NOT NULL	Invoice Line Approval Status 0=Line Routing Not Required 1=Completed 2=Routed for Approval
20	BUSINESS_UNIT_GL	Character(5)	VARCHAR2(5) NOT NULL	GL Business Unit
21	MATCH_STATUS_VCHR	Character(1)	VARCHAR2(1) NOT NULL	Match Status C=Overridden - Credit Note D=Match Dispute E=Match Exceptions Exist M=Matched N=Not Applicable O=Manually Overridden T=To Be Matched