BUSINESS_UNITDefault Value: OPR_DEF_TBL_CS.BUSINESS_UNIT
Prompt Table: SP_BU_SF_NONVW
EXT_ORG_IDPAYMENT_ID_NBRSSF_PMTCHORG_VW(SQL View) |
Index Back |
|---|---|
Restricted Payments for OrgsA view of all restricted payments for an Org. |
| SELECT a.business_unit ,a.common_id ,a.payment_id_nbr ,a.item_type ,a.payment_amt ,a.strm ,a.currency_cd ,a.rate_mult ,a.rate_div ,a.cur_rt_type ,a.orignl_item_amt ,a.orignl_currency_cd ,A.SSF_RESTRICT_INV FROM PS_PAYMENT_TBL a WHERE a.sf_reversal_ind = 'N' AND SA_ID_TYPE = 'O' AND A.SSF_PMT_CHG_ALLOC = 'Y' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_CS.BUSINESS_UNIT Prompt Table: SP_BU_SF_NONVW |
| 2 | EXT_ORG_ID |
Character(11) | VARCHAR2(11) NOT NULL | External Org ID |
| 3 | PAYMENT_ID_NBR |
Number(12,0) | DECIMAL(12) NOT NULL | Payment ID Nbr |
| 4 | ITEM_TYPE | Character(12) | VARCHAR2(12) NOT NULL | Item Type |
| 5 | PAYMENT_AMT | Number(19,3) | DECIMAL(18,3) NOT NULL | Payment Amount |
| 6 | STRM | Character(4) | VARCHAR2(4) NOT NULL | Term |
| 7 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 8 | RATE_MULT | Signed Number(17,8) | DECIMAL(15,8) NOT NULL | Rate Multiplier |
| 9 | RATE_DIV | Number(16,8) | DECIMAL(15,8) NOT NULL | Rate Divisor |
| 10 | CUR_RT_TYPE | Character(5) | VARCHAR2(5) NOT NULL | Currency Rate Type |
| 11 | ORIGNL_ITEM_AMT | Signed Number(18,2) | DECIMAL(16,2) NOT NULL | Item Amount |
| 12 | ORIGNL_CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 13 | SSF_RESTRICT_INV | Character(1) | VARCHAR2(1) NOT NULL | This field indicates that the payment will be held until an invoice is provided. |