LATE_CHRG_TBL

(SQL Table)
Index Back

Late Charge Information

# 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 LATE_CHRG_CD Character(4) VARCHAR2(4) NOT NULL Late Charge Code
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 MIN_LATE_CHRG Signed Number(28,3) DECIMAL(26,3) NOT NULL Minimum Late Charge
6 NO_PAY_DAYS Number(3,0) SMALLINT NOT NULL No Pay Days
7 SIMPLE_INTR_DAYS Number(3,0) SMALLINT NOT NULL Simple Interest Days
8 COMPOUND_INTR_DAYS Number(3,0) SMALLINT NOT NULL Compound Interest Days
9 DAYS_IN_YEAR Number(3,0) SMALLINT NOT NULL Days in Year

Default Value: 365

10 CALENDAR_DAYS Number(3,0) SMALLINT NOT NULL Calendar Days
11 INTEREST_RATE Number(9,5) DECIMAL(8,5) NOT NULL Interest Rate
12 PENALTY_FLG Character(1) VARCHAR2(1) NOT NULL Penalty Applicable

Y/N Table Edit

Default Value: N

13 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

Default Value: USD

Prompt Table: CURR_TXN_VW