INSTITUTION_SETBUSINESS_UNITDefault Value: OPR_DEF_TBL_CS.BUSINESS_UNIT
Prompt Table: SP_BU_SF_NONVW
A=Accounts Payable
O=Other
P=Payroll
Default Value: P
SSF_AP_REF_VW(SQL View) |
Index Back |
|---|---|
Refunding View |
| SELECT A.institution_set ,A.BUSINESS_UNIT ,B.REFUND_METHODE FROM PS_ISET_BU_DTL A ,PS_BUS_UNIT_TBL_SF B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND B.REFUND_METHODE = 'A' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | INSTITUTION_SET |
Character(5) | VARCHAR2(5) NOT NULL | Institution Set |
| 2 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_CS.BUSINESS_UNIT Prompt Table: SP_BU_SF_NONVW |
| 3 | REFUND_METHODE | Character(1) | VARCHAR2(1) NOT NULL |
Refund Method
A=Accounts Payable O=Other P=Payroll Default Value: P |