TP_DATE

(SQL Table)
Index Back

Contract Date

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract Number
3 FROM_DATE Date(10) DATE NOT NULL From Date
4 TO_DATE Date(10) DATE Latest Date to be sent to PYR
5 USE_DUE_DATE Character(1) VARCHAR2(1) NOT NULL Use Date
D=Due Days
T=Due Date
6 DEFER_DT_CHRG Date(10) DATE Defer Date Charges
7 DEFER_DAYS_CHRG Number(3,0) SMALLINT NOT NULL Defer Days Charges
8 USE_DUE_DATE2 Character(1) VARCHAR2(1) NOT NULL Use Date
D=Due Days
T=Due Date
9 DEFER_DT_ADJ Date(10) DATE Defer Date Adjustments
10 DEFER_DAYS_ADJ Number(3,0) SMALLINT NOT NULL Defer Days Adjustments
11 TRANSFER_AMT Signed Number(18,2) DECIMAL(16,2) NOT NULL Transfer Amt
12 STRM Character(4) VARCHAR2(4) NOT NULL Term

Prompt Table: TERM_VAL_TBL

13 MAX_TERM_AMT Number(15,2) DECIMAL(14,2) NOT NULL Max Term Amount

Default Value: TP_CONTRACT.MAX_TERM_AMT

14 ADJUST_UNTIL_DATE Date(10) DATE Adjust Until Date
15 SCC_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Created By
16 SCC_ROW_ADD_DTTM DateTime(26) TIMESTAMP Created
17 SCC_ROW_UPD_OPRID Character(30) VARCHAR2(30) NOT NULL Updated By
18 SCC_ROW_UPD_DTTM DateTime(26) TIMESTAMP Last Update Date/Time