SETIDDefault Value: OPR_DEF_TBL_FS.SETID
Prompt Table: SP_SETID_NONVW
BILL_TO_CUST_IDLOC_REFERENCE_IDD=Detailed
P=Pooled
A=Active
I=Inactive
CA_SPNSR_ALC_VW(SQL View) |
Index Back |
|---|---|
Grants Active LOCsDisplay only active LOCs for a sponsor |
| SELECT LOC.SETID , LOC.CUST_ID , LOC.LOC_REFERENCE_ID , LOC.DESCR , LOC.LOC_REFERENCE_TYPE , LOC.STATUS FROM PS_GM_SPNSR_LOC LOC WHERE LOC.STATUS = 'A' |
| # | 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 | BILL_TO_CUST_ID |
Character(15) | VARCHAR2(15) NOT NULL | Customer |
| 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 |