| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
Prompt Table:
SETID_TBL
|
| 2 |
CONDITION_ID |
Character(4) |
VARCHAR2(4) NOT NULL |
Condition ID
ACLA=Approaching Credit Limit
ACLD=Approaching Credit Limit Exp
CCEX=Approaching CC expiration date
CCHD=Cancel Credit Hold
CFLU=Conversation Follow Up
CHLD=Credit Hold Code Exists
COLL=Collection
CPDB=Customer Promise Date Broken
CPDR=Customer Promise Date Review
DEDN=Deduction Item
DISP=Disputed Item
EBIL=eBill selection by user
ECLA=Exceeded Credit Limit
ECLD=Exceed CR Limit Expiration Dt
ETRC=Entry Type / Reason Code
KSTE=Key Statistics Exceeded
LACD=Large Amount Coming Due
ONLN=Online selection by user
RISK=Risk Score
WBDC=Welcome Back Dormant Customer
WCNC=Welcome New Customer
|
| 3 |
LANGUAGE_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Language Code
|
| 4 |
DESCR50 |
Character(50) |
VARCHAR2(50) NOT NULL |
Description of length 50
|
| 5 |
STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Status Indicator
A=Active
I=Inactive
Default Value: A
|
| 6 |
PRIORITY |
Number(3,0) |
SMALLINT NOT NULL |
Priority
|
| 7 |
MULTIPLE_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Multiple Values per Attr
Y/N Table Edit
|
| 8 |
COND_AMOUNT |
Character(1) |
VARCHAR2(1) NOT NULL |
Condition Amount
|
| 9 |
COND_COUNT |
Character(1) |
VARCHAR2(1) NOT NULL |
Condition Count Flag
|
| 10 |
COND_DAYS |
Character(1) |
VARCHAR2(1) NOT NULL |
Condition Days
|
| 11 |
COND_PERIOD |
Character(1) |
VARCHAR2(1) NOT NULL |
Condition Period
|
| 12 |
COND_PERCENT |
Character(1) |
VARCHAR2(1) NOT NULL |
Condition Percent
|
| 13 |
TYPE_MULTIPLE |
Character(1) |
VARCHAR2(1) NOT NULL |
Type Multiple
|
| 14 |
DEFINITION_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Definition Type
S=System Defined
U=User Defined
|
| 15 |
COND_ROLE |
Character(1) |
VARCHAR2(1) NOT NULL |
Condition Role
B=Bill To Customer
C=Corporate Customer
P=Correspondence Customer
R=Remit From Customer
|
| 16 |
MONITOR_BU |
Character(1) |
VARCHAR2(1) NOT NULL |
Monitor Business Unit
Y/N Table Edit
|
| 17 |
LAST_MAINT_DTTM |
DateTime(26) |
TIMESTAMP |
A system generated value that reflects the date and time a transaction was last modified
|
| 18 |
LAST_MAINT_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Last Maintained By Operator ID
|