AP_VCHR_INQ_VW

(SQL View)
 Index Back

Voucher Inquiry - Scroll


SELECT A.BUSINESS_UNIT , A.VOUCHER_ID , ' ' , A.INVOICE_ID , A.INVOICE_DT , A.VENDOR_ID , B.SETID , B.VENDOR_NAME_SHORT , %Upper(B.NAME1) , %Upper(B.NAME2) , A.VNDR_LOC , A.TXN_CURRENCY_CD , A.VOUCHER_STYLE , A.GROSS_AMT ,0 ,0 ,0 ,0 ,0 , A.USETAX_AMT + A.SALETX_AMT + A.FREIGHT_AMT + A.MISC_AMT , A.VAT_ENTRD_AMT , A.POST_STATUS_AP , A.APPR_STATUS , A.CLOSE_STATUS , A.DUE_DT , A.TERMS_BASIS_DT , A.ACCOUNTING_DT , A.ENTERED_DT , A.BUDGET_HDR_STATUS , A.BUDGET_MISC_STATUS , A.MATCH_STATUS_VCHR , C.DOC_SEQ , A.ORIGIN , A.ENTRY_STATUS , A.VCHR_SRC , 'N' , A.VCHR_DRAFT_FLG , D.ATTACHMENT_NUM , A.VCHR_APPRVL_FLG FROM PS_VOUCHER A , PS_VENDOR B , PS_BUS_UNIT_TBL_GL C , PS_AP_VCHR_ATT_CNT D WHERE A.VENDOR_SETID = B.SETID AND A.VENDOR_ID = B.VENDOR_ID AND A.VOUCHER_ID = 'ZZZZZzzz' AND A.BUSINESS_UNIT = 'ZZZZZ' AND A.BUSINESS_UNIT_GL = C.BUSINESS_UNIT AND A.BUSINESS_UNIT = D.BUSINESS_UNIT AND A.VOUCHER_ID = D.VOUCHER_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 VOUCHER_ID Character(8) VARCHAR2(8) NOT NULL Voucher ID
3 BANK_SETID Character(5) VARCHAR2(5) NOT NULL The PeopleSoft tableset ID associated with a given bank/counterparty.
4 INVOICE_ID Character(30) VARCHAR2(30) NOT NULL Invoice Number
5 INVOICE_DT Date(10) DATE Invoice Date
6 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
7 SETID Character(5) VARCHAR2(5) NOT NULL SetID
8 VENDOR_NAME_SHORT Character(14) VARCHAR2(14) NOT NULL Short Vendor Name
9 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1
10 NAME2 Character(40) VARCHAR2(40) NOT NULL Name 2
11 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location
12 TXN_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Transaction Currency
13 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
14 GROSS_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Gross Invoice Amount
15 AVAILABLE_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Prepayment Available Amount
16 CONV_GROSS_PAID Signed Number(28,3) DECIMAL(26,3) NOT NULL Used for Voucher Inquiry view to hold the paid amounts converted to the txn currency of the voucher.
17 VCHR_BALANCE_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Left to Balance
18 CONV_DSCNT_PAID Signed Number(28,3) DECIMAL(26,3) NOT NULL Used for Voucher Inquiry to hold the Discount Paid converted to the voucher txn currency.
19 CONV_NET_PAID Signed Number(28,3) DECIMAL(26,3) NOT NULL Used for Voucher inquiry to hold the Net paid for a voucher converted to the txn currency.
20 TOTAL_MISC Signed Number(28,3) DECIMAL(26,3) NOT NULL Misc Charges Total
21 VAT_ENTRD_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Entered VAT Amount
22 POST_STATUS_AP Character(1) VARCHAR2(1) NOT NULL Post Status
N=Payment Not Applied
P=Posted
U=Unposted
23 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
24 CLOSE_STATUS Character(1) VARCHAR2(1) NOT NULL Close Status Indicator
C=Closed
O=Open
25 DUE_DT Date(10) DATE Specifies the date that a transaction is due. It is a generic field used in multiple PeopleSoft applications including Receivables Payables and Purchasing. For example it represents the date that payment is due for a voucher or the date that a scheduled shipment is due to be received.
26 TERMS_BASIS_DT Date(10) DATE Payment Terms Basis Date
27 ACCOUNTING_DT Date(10) DATE The accounting entry construction date for a given transaction (a generic field that crosses multiple
28 ENTERED_DT Date(10) DATE Entered on
29 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
30 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
31 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
32 DOC_SEQ Character(1) VARCHAR2(1) NOT NULL Enable Document Sequencing

Y/N Table Edit

33 ORIGIN Character(3) VARCHAR2(3) NOT NULL Origin
34 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
35 VCHR_SRC Character(4) VARCHAR2(4) NOT NULL Voucher Source
36 HIST_STATUS Character(1) VARCHAR2(1) NOT NULL History Status
N=No
T=Transfer
Y=Yes

Default Value: N

37 VCHR_DRAFT_FLG Character(1) VARCHAR2(1) NOT NULL Voucher Draft Flag
N=Complete Voucher
Y=Incomplete Voucher

Y/N Table Edit

38 ATTACHMENT_NUM Number(5,0) INTEGER NOT NULL Attachment Number
39 VCHR_APPRVL_FLG Character(1) VARCHAR2(1) NOT NULL Voucher Approval Flag
D=Default from Higher Level
P=Pre-Approved
S=Virtual Approver
W=Approval Framework