SF_PMT_REF_NBRSEQNUMBUSINESS_UNITSF_PAY_DTL_VW0(SQL View) |
Index Back |
|---|---|
SF electronic payments viewView of SF_PAYMENT_DTL for self service payments. |
| SELECT SF_PMT_REF_NBR , SEQNUM , BUSINESS_UNIT , ITEM_TYPE , ITEM_TERM FROM PS_SF_PAYMENT_DTL |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SF_PMT_REF_NBR |
Character(12) | VARCHAR2(12) NOT NULL | Reference Nbr |
| 2 | SEQNUM |
Number(3,0) | SMALLINT NOT NULL | Sequence Number |
| 3 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 4 | ITEM_TYPE | Character(12) | VARCHAR2(12) NOT NULL | Item Type |
| 5 | ITEM_TERM | Character(4) | VARCHAR2(4) NOT NULL | Item Term |