SHEET_IDEX_EE_V_PYMT_VW(SQL View) |
Index Back |
|---|---|
Expense Sheet Supplier Pymt VwReturns a row for each sheet that has a supplier payment associated with it. |
| select DISTINCT A.SHEET_ID, B.BANK_SETID, B.BANK_CD, B.BANK_ACCT_KEY, B.PYMNT_ID from PS_EX_SHEET_HDR A, PS_EX_SHEET_PYMNT B where A.SHEET_ID = B.SHEET_ID and B.EX_PYMNT_TYPE = 'V' and B.SEQ_NBR = (select max(X.SEQ_NBR) from PS_EX_SHEET_PYMNT X where X.SHEET_ID = A.SHEET_ID and X.EX_PYMNT_TYPE = 'V') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SHEET_ID |
Character(10) | VARCHAR2(10) NOT NULL | Report ID |
| 2 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 3 | BANK_CD | Character(5) | VARCHAR2(5) NOT NULL | Bank Code |
| 4 | BANK_ACCT_KEY | Character(4) | VARCHAR2(4) NOT NULL | A user defined unique identifier that facilitates the identification of a given account with a given bank |
| 5 | PYMNT_ID | Character(10) | VARCHAR2(10) NOT NULL | Payment Number |