| # |
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 |
DUN_ID |
Character(5) |
VARCHAR2(5) NOT NULL |
Dunning ID
Prompt Table:
DUNNING_TBL
|
| 3 |
EFFDT |
Date(10) |
DATE NOT NULL |
Effective Date
Default Value: %date
|
| 4 |
DUN_METHOD |
Character(1) |
VARCHAR2(1) NOT NULL |
Dunning Method
A=Dunning by Action List
D=Dunning by Days
L=Dunning by Level
Default Value: D
|
| 5 |
EFF_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Effective Status
A=Active
I=Inactive
Default Value: A
|
| 6 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 7 |
DESCRSHORT |
Character(10) |
VARCHAR2(10) NOT NULL |
Short Description
|
| 8 |
EXCL_DISP_ITEMS |
Character(1) |
VARCHAR2(1) NOT NULL |
Exclude Disputed Items
Y/N Table Edit
Default Value: N
|
| 9 |
EXCL_CLCT_ITEMS |
Character(1) |
VARCHAR2(1) NOT NULL |
Exclude Collection Items
Y/N Table Edit
Default Value: N
|
| 10 |
EXCL_CREDIT_ITEMS |
Character(1) |
VARCHAR2(1) NOT NULL |
Exclude Credit Items
Y/N Table Edit
Default Value: N
|
| 11 |
EXCL_SMALL_ITEMS |
Character(1) |
VARCHAR2(1) NOT NULL |
Exclude Items <
Y/N Table Edit
Default Value: N
|
| 12 |
EXCL_DED_ITEMS |
Character(1) |
VARCHAR2(1) NOT NULL |
Exclude Deduction Items
|
| 13 |
ITEM_MINIMUM |
Number(27,3) |
DECIMAL(26,3) NOT NULL |
Item Minimum Amount
|
| 14 |
ITEM_MIN_CURRENCY |
Character(3) |
VARCHAR2(3) NOT NULL |
Statements Item Minimum Currency Code
Prompt Table:
CURRENCY_CD_TBL
|
| 15 |
CANCEL_DISP_CUST |
Character(1) |
VARCHAR2(1) NOT NULL |
Customer Is In Dispute
Y/N Table Edit
Default Value: N
|
| 16 |
CANCEL_CLCT_CUST |
Character(1) |
VARCHAR2(1) NOT NULL |
Cancel Collection Customer
Y/N Table Edit
Default Value: N
|
| 17 |
CANCEL_CREDIT_TOT |
Character(1) |
VARCHAR2(1) NOT NULL |
Document Has Credit Total
Y/N Table Edit
Default Value: N
|
| 18 |
CANCEL_SMALL_TOT |
Character(1) |
VARCHAR2(1) NOT NULL |
Document Total <
Y/N Table Edit
Default Value: N
|
| 19 |
CANCEL_NO_ACTIVITY |
Character(1) |
VARCHAR2(1) NOT NULL |
Cancel No Activity
|
| 20 |
DOCUMENT_MINIMUM |
Number(27,3) |
DECIMAL(26,3) NOT NULL |
Document Minimum
|
| 21 |
DOC_MIN_CURRENCY |
Character(3) |
VARCHAR2(3) NOT NULL |
Statements Document Minimum Currency
Prompt Table:
CURRENCY_CD_TBL
|
| 22 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
Default Value: BUS_UNIT_OPT_AR.FORMAT_CURRENCY
|
| 23 |
INCLUDE_FC |
Character(1) |
VARCHAR2(1) NOT NULL |
Include Finance Charge
Y/N Table Edit
Default Value: N
|
| 24 |
INCLUDE_DC |
Character(1) |
VARCHAR2(1) NOT NULL |
Include Dunning Letter Charge Indicator
N=Not Include Letter Charge
Y=Include Letter Charge
Y/N Table Edit
Default Value: N
|
| 25 |
GRACE_DUN_DAYS |
Number(3,0) |
SMALLINT NOT NULL |
Grace days for dunning.
|
| 26 |
DUN_INTERVAL_ACTLS |
Number(3,0) |
SMALLINT NOT NULL |
Dunning Interval.Used by Dunning by Action List Dunning Method.
|
| 27 |
EXCL_GRACE_CR_ITEM |
Character(1) |
VARCHAR2(1) NOT NULL |
Apply Grace Days to Cred Items
Y/N Table Edit
|
| 28 |
EXCL_CURRENT_ITEMS |
Character(1) |
VARCHAR2(1) NOT NULL |
Exclude Current Items
Y/N Table Edit
Default Value: Y
|