DFT_CONTROL_IDAPD_DFTCNTID_VW(SQL View) |
Index Back |
|---|---|
Selection View for Draft Cntr |
| SELECT DISTINCT PYMNT_ID_REF , DFT_CONTROL_ID , PYMNT_ID , REMIT_VENDOR , PYMNT_AMT FROM PS_PAYMENT_TBL WHERE PYMNT_METHOD IN ('BOO', 'BEF', 'DFT') AND POST_STATUS_AP = 'P' AND PYMNT_STATUS = 'P' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PYMNT_ID_REF | Character(20) | VARCHAR2(20) NOT NULL | Payment Reference |
| 2 | DFT_CONTROL_ID |
Character(20) | VARCHAR2(20) NOT NULL | Draft Control ID |
| 3 | PYMNT_ID | Character(10) | VARCHAR2(10) NOT NULL | Payment Number |
| 4 | REMIT_VENDOR | Character(10) | VARCHAR2(10) NOT NULL | Remit Vendor |
| 5 | PYMNT_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Payment Amount |