AR_WC_ACTN_F_VW (SQL View)	Index Back
Broken Promise Action

AR_WC_ACTN_F_VW

(SQL View)

Broken Promise Action

SELECT DISTINCT ACTION_CODE , DESCR FROM PS_ACTION_TBL

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 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

2 DESCR Character(30) VARCHAR2(30) NOT NULL Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	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
2	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description