RE_AMND_CHG_LOG(SQL Table) |
Index Back |
|---|---|
Change Log Record |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  LS_KEY |
Number(15,0) | DECIMAL(15) NOT NULL | Lease Key, Unique Key |
| 2 | AMND_NBR |
Number(3,0) | SMALLINT NOT NULL | Amendment Number |
| 3 | PROPERTY_ID |
Number(10,0) | DECIMAL(10) NOT NULL | Property ID |
| 4 | LS_MAP_ID |
Character(12) | VARCHAR2(12) NOT NULL | Field For Lease Map ID |
| 5 | TERM_ID |
Number(10,0) | DECIMAL(10) NOT NULL | Financial Term ID |
| 6 | TERM_ESC_ID |
Number(10,0) | DECIMAL(10) NOT NULL | Term Escalation ID |
| 7 | TERM_OPEX_ID |
Number(10,0) | DECIMAL(10) NOT NULL | Operating Expenses Category ID |
| 8 | LS_CLSE_ID |
Number(10,0) | DECIMAL(10) NOT NULL | Clause ID |
| 9 | SLS_CAT_ID |
Number(10,0) | DECIMAL(10) NOT NULL | Sales Category |
| 10 | SLS_BKP_ID |
Number(10,0) | DECIMAL(10) NOT NULL | Sales Breakpoint ID |
| 11 | DEPOSIT_ID |
Character(15) | VARCHAR2(15) NOT NULL | Uniquely identifies a deposit of customer payments. The deposit ID can be manually assigned or system-generated. |
| 12 | LS_SECTION | Character(3) | VARCHAR2(3) NOT NULL |
Lease Section for Amendment Log
1=General Information 2=Financial Summary 3=Lease Property 4=Financial Terms 41=Escalation Terms 411=Operating Expense Details 412=Prorata Basis 413=Cap Min Details 5=Operating Expenses 51=Operating Expenses category 511=Operating Expense Details 512=Prorata Basis 513=Cap Min Details 6=Clauses 7=Sales Category 71=Sales Break Point 9=Security Deposit A=Option and Critical dates |
| 13 | FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL | Field Name (see PSDBFIELD). |
| 14 | TREE_LEVEL_NUM | Number(3,0) | SMALLINT NOT NULL | Parent tree level if this is a part of the PSTREEBRANCH record |
| 15 | FROM_AMOUNT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | From Amount |
| 16 | TO_AMOUNT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | To Amount |
| 17 | FROM_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL | From Currency |
| 18 | TO_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL | Revalue Currency |
| 19 | FROM_PCT | Number(6,2) | DECIMAL(5,2) NOT NULL | From Percentage |
| 20 | TO_PCT | Number(6,2) | DECIMAL(5,2) NOT NULL | To Percentage |
| 21 | FROM_LS_UOM | Character(1) | VARCHAR2(1) NOT NULL | From Unit of Measure |
| 22 | TO_LS_UOM | Character(1) | VARCHAR2(1) NOT NULL | To Unit of Measure |
| 23 | FROM_CHAR100 | Character(100) | VARCHAR2(100) NOT NULL | From Char |
| 24 | TO_CHAR100 | Character(100) | VARCHAR2(100) NOT NULL | To Char |
| 25 | FROM_DATE | Date(10) | DATE | From Date |
| 26 | TO_DATE | Date(10) | DATE | To Date |