SETIDDefault Value: OPR_DEF_TBL_FS.SETID
Prompt Table: SP_SETID_NONVW
SPONSOR_IDLOC_REFERENCE_IDD=Detailed
P=Pooled
A=Active
I=Inactive
CA_SPNSR_LC2_VW(SQL View) |
Index Back |
|---|---|
Grants Valid LOC'sView of GM_SPONSR_LOC, renaming Customer to Sponsor. (Similar to GM_SPONSR_LOC_VW but allows the user to select a SETID when used as a prompt table.) Used in WC Exception - Sponsor Data Not in Peoplesoft |
| SELECT LOC.SETID , LOC.CUST_ID , LOC.LOC_REFERENCE_ID , LOC.DESCR , LOC.LOC_REFERENCE_TYPE , LOC.STATUS FROM PS_GM_SPNSR_LOC LOC |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW |
| 2 | SPONSOR_ID |
Character(15) | VARCHAR2(15) NOT NULL | SPONSOR_ID |
| 3 | LOC_REFERENCE_ID |
Character(10) | VARCHAR2(10) NOT NULL | Letter of Credit ID |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 5 | LOC_REFERENCE_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
LOC Type
D=Detailed P=Pooled |
| 6 | STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Status Indicator
A=Active I=Inactive |