VNDR_PYINQ_VW4D

(SQL View)
Index Back

select setid, vendor_id, business_unit, voucher_id, pymnt_cnt, vendor_name_short, name1, ar_num, pymnt_gross_amt, dscnt_pay_amt, due_dt, dscnt_due_dt, scheduled_pay_dt, pymnt_method, pymnt_selct_status, pymnt_handling_cd, pymnt_separate, pymnt_hold, pymnt_hold_wthd, post_status_ap, invoice_id, invoice_dt, gross_amt, txn_currency_cd, dscnt_amt, saletx_amt, freight_amt, remit_vendor, pymnt_terms_cd, dscnt_due_dt, due_dt, appr_status, descr254_mixed from PS_VNDR_PYINQ_VW1 where appr_status = 'D'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
2 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
3 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
4 VOUCHER_ID Character(8) VARCHAR2(8) NOT NULL Voucher ID
5 PYMNT_CNT Number(5,0) INTEGER NOT NULL Payments
6 VENDOR_NAME_SHORT Character(14) VARCHAR2(14) NOT NULL Short Vendor Name
7 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1
8 AR_NUM Character(15) VARCHAR2(15) NOT NULL Our Customer Number
9 PYMNT_GROSS_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Gross Payment Amount
10 DSCNT_PAY_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Payment Discount Amount
11 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.
12 DSCNT_DUE_DT Date(10) DATE Discount Due Date
13 SCHEDULED_PAY_DT Date(10) DATE Scheduled to Pay
14 PYMNT_METHOD Character(3) VARCHAR2(3) NOT NULL Payment Method
ACH=Automated Clearing House
BEF=Draft - Customer EFT
BOO=Draft - Customer Initiated
CHK=System Check
D=Deposit
DD=Direct Debit
DFT=Draft - Supplier Initiated
DRA=Draft
EFT=Electronic Funds Transfer
GE=Giro - EFT
GM=Giro - Manual
LC=Letter of Credit
MAN=Manual Check
TRW=Treasury Wire
WIR=Wire Transfer
15 PYMNT_SELCT_STATUS Character(1) VARCHAR2(1) NOT NULL Payment Selection Status
C=Closed
D=Negative Voucher Sum
E=Externally Paid
F=Federal Sanctions Error
I=In Process - EFT
N=Not Selected for Payment
O=Financial Sanctions Review
P=Paid
R=Requested for Payment
S=Settlement Payment
V=Convert Error
X=Canceled
Y=Prepaid
16 PYMNT_HANDLING_CD Character(2) VARCHAR2(2) NOT NULL Payment Handling
17 PYMNT_SEPARATE Character(1) VARCHAR2(1) NOT NULL Separate Payment
18 PYMNT_HOLD Character(1) VARCHAR2(1) NOT NULL Hold Payment
N=No
Y=Yes
19 PYMNT_HOLD_WTHD Character(1) VARCHAR2(1) NOT NULL On Withholding Hold
N=No
Y=Yes
20 POST_STATUS_AP Character(1) VARCHAR2(1) NOT NULL Post Status
N=Payment Not Applied
P=Posted
U=Unposted
21 INVOICE_ID Character(30) VARCHAR2(30) NOT NULL Invoice Number
22 INVOICE_DT Date(10) DATE Invoice Date
23 GROSS_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Gross Invoice Amount
24 TXN_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Transaction Currency
25 DSCNT_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Discount Amount
26 SALETX_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Sales Tax Amount
27 FREIGHT_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Freight Amount
28 REMIT_VENDOR Character(10) VARCHAR2(10) NOT NULL Remit Vendor
29 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.
30 VCHR_DSCNT_DUE_DT Date(10) DATE Voucher Discount Due Date
31 VCHR_DUE_DT Date(10) DATE Voucher Due Date
32 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
33 DESCR254_MIXED Character(254) VARCHAR2(254) NOT NULL Description