BUSINESS_UNITDefault Value: OPR_DEF_TBL_CS.BUSINESS_UNIT
Prompt Table: BUS_UNIT_TBL_SF
COLLECTION_IDPrompt Table: COLLECTION_SF
Prompt Table: EXT_ORG_TBL
COLL_ORG_SRCH(SQL View) |
Index Back |
|---|---|
Org Collection ID ViewThis view is used as a search record for Collection Dunning Letter |
| SELECT A.BUSINESS_UNIT , A.COLLECTION_ID , A.EXT_ORG_ID FROM PS_COLLECTION_SF A WHERE A.EXT_ORG_ID <> ' ' AND A.TEMPLATE_CODE <> ' ' |
| # | 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: BUS_UNIT_TBL_SF |
| 2 | COLLECTION_ID |
Number(12,0) | DECIMAL(12) NOT NULL |
Collection ID
Prompt Table: COLLECTION_SF |
| 3 | EXT_ORG_ID | Character(11) | VARCHAR2(11) NOT NULL |
External Org ID
Prompt Table: EXT_ORG_TBL |