| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
Prompt Table:
SP_SETID_NONVW
|
| 2 |
TMPLT_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Template ID
|
| 3 |
EFFDT |
Date(10) |
DATE NOT NULL |
Effective Date
Default Value: %date
|
| 4 |
DAYS_ELAPSED |
Number(4,0) |
SMALLINT NOT NULL |
Days Elapsed
Default Value: 0
|
| 5 |
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:
AR_ACTN_CD2_VW
|
| 6 |
DELIVERED_TO |
Character(30) |
VARCHAR2(30) NOT NULL |
Delivered To
|
| 7 |
DELIVERY_METHOD |
Character(1) |
VARCHAR2(1) NOT NULL |
Delivery Method
E=Email
F=Fax
P=Print
|
| 8 |
ACTION_PARM |
Character(6) |
VARCHAR2(6) NOT NULL |
Action Parameter
Prompt Table:
%EDITTABLE
Set Control Field: SETID
|
| 9 |
PROPOSED_AUTOMATED |
Character(1) |
VARCHAR2(1) NOT NULL |
Proposed/Automated
A=Automated
P=Proposed
|
| 10 |
DAYS_NOTIFY_MGR |
Signed Number(4,0) |
DECIMAL(3) NOT NULL |
Days To Notify Supervisor
|
| 11 |
DAYS_NOTIFY_OWNER |
Signed Number(4,0) |
DECIMAL(3) NOT NULL |
Days To Notify Owner
|
| 12 |
DAYS_NOTIFY_SPSLST |
Signed Number(4,0) |
DECIMAL(3) NOT NULL |
Days To Notify Specialist
|
| 13 |
DAYS_NOTIFY_MGRC |
Character(3) |
VARCHAR2(3) NOT NULL |
Days To Notify Supervisor
|
| 14 |
DAYS_NOTIFY_OWNERC |
Character(3) |
VARCHAR2(3) NOT NULL |
Days To Notify Owner
|
| 15 |
DAYS_NOTIFY_SPSLSC |
Character(3) |
VARCHAR2(3) NOT NULL |
Days To Notify Specialist
|
| 16 |
LAST_MAINT_DTTM |
DateTime(26) |
TIMESTAMP |
A system generated value that reflects the date and time a transaction was last modified
|
| 17 |
LAST_MAINT_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Last Maintained By Operator ID
|