TO_SETID_COLLECTCOLLECTORPrompt Table: COLLECTOR_TBL
EFFDTA=Active
I=Inactive
Default Value: A
TRN_COLLECTR_VW(SQL View) |
Index Back |
|---|---|
Transfer WS - Collectors |
| SELECT A.setid , collector , effdt , eff_status , name1 FROM PS_COLLECTOR_TBL A |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | TO_SETID_COLLECT |
Character(5) | VARCHAR2(5) NOT NULL | To Setid Collector |
| 2 | COLLECTOR |
Character(8) | VARCHAR2(8) NOT NULL |
Specifies the personnel code for the person who works with a customer to collect overdue payments.
Prompt Table: COLLECTOR_TBL |
| 3 | EFFDT |
Date(10) | DATE NOT NULL | Effective Date |
| 4 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive Default Value: A |
| 5 | NAME1 | Character(40) | VARCHAR2(40) NOT NULL | Name 1 |