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 |