| # |
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 |
EPAY_PROFILE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
ePayment Profile
Prompt Table:
AR_EPAY_PRFL
|
| 3 |
EFFDT |
Date(10) |
DATE NOT NULL |
Effective Date
Default Value: %date
|
| 4 |
EFF_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Effective Status
A=Active
I=Inactive
Default Value: A
|
| 5 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 6 |
DESCRSHORT |
Character(10) |
VARCHAR2(10) NOT NULL |
Short Description
|
| 7 |
EXCL_FIN_ITEMS |
Character(1) |
VARCHAR2(1) NOT NULL |
Exclude Overdue Charges
Y/N Table Edit
Default Value: N
|
| 8 |
EXCL_DISP_ITEMS |
Character(1) |
VARCHAR2(1) NOT NULL |
Exclude Disputed Items
Y/N Table Edit
Default Value: N
|
| 9 |
EXCL_CREDIT_ITEMS |
Character(1) |
VARCHAR2(1) NOT NULL |
Exclude Credit Items
Y/N Table Edit
Default Value: N
|
| 10 |
EXCL_CLCT_ITEMS |
Character(1) |
VARCHAR2(1) NOT NULL |
Exclude Collection Items
Y/N Table Edit
Default Value: N
|
| 11 |
EXCL_CLCT_CUST |
Character(1) |
VARCHAR2(1) NOT NULL |
Customers in Collection
Y/N Table Edit
Default Value: N
|
| 12 |
EXCL_DISP_CUST |
Character(1) |
VARCHAR2(1) NOT NULL |
Customers in Dispute
Y/N Table Edit
Default Value: N
|
| 13 |
CONTROL_CURRENCY |
Character(3) |
VARCHAR2(3) NOT NULL |
Specifies the currency for all Receivables items in a control group. If this field is not blank the system will accept items with the specified currency only.
Default Value: USD
Prompt Table:
CURRENCY_CD_TBL
|
| 14 |
CUR_RT_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Currency Rate Type
Default Value: CRRNT
Prompt Table:
RT_TYPE_TBL
|
| 15 |
ROW_ADDED_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Added By
Default Value: OPR_DEF_TBL_FS.OPRID
|
| 16 |
ROW_ADDED_DTTM |
DateTime(26) |
TIMESTAMP |
Added Date/Time
|
| 17 |
LAST_MAINT_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Last Maintained By Operator ID
Default Value: OPR_DEF_TBL_FS.OPRID
|
| 18 |
LAST_MAINT_DTTM |
DateTime(26) |
TIMESTAMP |
A system generated value that reflects the date and time a transaction was last modified
|