SSF_LATE_FEE_CD(SQL Table) |
Index Back |
|---|---|
Late Fee Code Table |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_CS.SETID Prompt Table: SP_SETID_NONVW |
| 2 | LATE_FEE_CODE |
Character(6) | VARCHAR2(6) NOT NULL | Late Fee Code |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 4 | SSF_LATE_RUN_MIN | Signed Number(18,2) | DECIMAL(16,2) NOT NULL | Late Fee Run Minimum |
| 5 | SSF_LATE_RUN_MAX | Signed Number(18,2) | DECIMAL(16,2) NOT NULL | Late Fee Run Maximum |
| 6 | SSF_LATE_PER_MAX | Signed Number(18,2) | DECIMAL(16,2) NOT NULL | Late Fee Period Maximum |
| 7 | ITEM_TYPE_LATE_FEE | Character(12) | VARCHAR2(12) NOT NULL |
Late Fee Item Type
Prompt Table:
ITEM_TYPE_CH_VW
|
| 8 | ACCOUNT_TYPE_SF | Character(3) | VARCHAR2(3) NOT NULL |
Account Type
Prompt Table:
ACCT_TYP_TBL_SF
|
| 9 | SSF_FROM_DATE | Date(10) | DATE | From Date |
| 10 | SERVICE_IMPACT | Character(5) | VARCHAR2(5) NOT NULL |
Service Impact
Prompt Table: SSF_SVCIMP_D_VW |
| 11 | ITEM_TYPE_GROUP | Character(10) | VARCHAR2(10) NOT NULL |
Item Type Group
Prompt Table:
ITEM_GROUP_TBL
|
| 12 | SSF_EXCL_CHG_RVRSL | Character(1) | VARCHAR2(1) NOT NULL |
Exclude Charge Reversals
Default Value: N |