EM_SSINV_VW(SQL View) |
Index Back |
|---|
| SELECT DISTINCT B.INVOICE_ID , B.INVOICE_DT , B.GROSS_AMT , A.VENDOR_ID , B.BUSINESS_UNIT , B.VOUCHER_ID , A.SETID , B.DUE_DT , B.DSCNT_DUE_DT , B.TXN_CURRENCY_CD , B.APPR_STATUS , B.MATCH_STATUS_VCHR , B.DSCNT_AMT , B.DSCNT_DUE_DT , B.PYMNT_TERMS_CD , B.VAT_INV_AMT , B.SALETX_AMT , B.FREIGHT_AMT , B.USETAX_AMT , B.MISC_AMT , B.OPRID , B.VCHR_SRC , B.ENTERED_DT , B.LAST_UPDATE_DT FROM PS_VENDOR A , PS_VCHR_FS B WHERE A.SETID = B.VENDOR_SETID AND A.VENDOR_ID = B.VENDOR_ID AND B.ENTRY_STATUS = 'P' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | INVOICE_ID | Character(30) | VARCHAR2(30) NOT NULL | Invoice Number |
| 2 |  INVOICE_DT |
Date(10) | DATE | Invoice Date |
| 3 | GROSS_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Gross Invoice Amount |
| 4 | VENDOR_ID |
Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |
| 5 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 6 | VOUCHER_ID |
Character(8) | VARCHAR2(8) NOT NULL | Voucher ID |
| 7 | SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_FS.SETID |
| 8 | 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. |
| 9 | DSCNT_DUE_DT | Date(10) | DATE | Discount Due Date |
| 10 | TXN_CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Transaction Currency |
| 11 | 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 |
| 12 | 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 |
| 13 | DISCOUNT_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Represents the discount amount deducted from the par price of a given deal transaction such as a bond. |
| 14 | DISC_END_DATE | Date(10) | DATE | Discount End Date |
| 15 | 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.
Prompt Table: PYMT_TR_EFF_VW |
| 16 | VAT_INV_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | VAT Invoice Amount |
| 17 | SALETX_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Sales Tax Amount |
| 18 | FREIGHT_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Freight Amount |
| 19 | USETAX_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Amount |
| 20 | MISC_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Misc. Amount |
| 21 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 22 | VCHR_SRC | Character(4) | VARCHAR2(4) NOT NULL | Voucher Source |
| 23 | ENTERED_DT | Date(10) | DATE | Entered on |
| 24 | LAST_UPDATE_DT | Date(10) | DATE | Last Updated |