ACTN_CD_SRCH_VW(SQL View) |
Index Back |
---|---|
Action Search |
SELECT SETID , ACTION_CODE , DESCR FROM PS_ACTION_TBL |
# | 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 | ACTION_CODE | Character(4) | VARCHAR2(4) NOT NULL |
Action Code
ALRT=Alert CALL=Call the Customer CRDT=Review Customer Credit Limit DLTR=Dunning Letter DNGD=Downgrade Credit Rating FEBN=Follow up eBill Note HOLD=Place Customer on Hold OLTR=Send Other Letter POD=Proof of Delivery PRBK=Review Broken Promise Date PRFO=Review Promise Date REFR=Refer to Collection Agency STMT=Send Statement of Account WOFF=Write off Customer Balance Prompt Table: ACTN_CD_XLT_VW |
3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |