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 |