RE_GENTRANS_AET(SQL Table) |
Index Back |
|---|---|
State Record for Txn GeneratorState Record for Txn Generator |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | AE_SECTION | Character(8) | VARCHAR2(8) NOT NULL | Section |
| 3 | NEW_ACCT_RULE | Character(1) | VARCHAR2(1) NOT NULL | New Lease Accounting Rule |
| 4 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 5 | LEAD_BIL_TIME | Number(9,0) | DECIMAL(9) NOT NULL | Billables Transaction Lead Time |
| 6 | LEAD_PMT_TIME | Number(9,0) | DECIMAL(9) NOT NULL | Payables Transaction Lead Time |
| 7 | AP_TEMP_DT | Date(10) | DATE | Temp Date |
| 8 | BILLING_DT_TO | Date(10) | DATE | To Billing Date |
| 9 | SCHED_DATE | Date(10) | DATE | Schedule Date |
| 10 | LS_KEY | Number(15,0) | DECIMAL(15) NOT NULL | Lease Key, Unique Key |
| 11 | TERM_ID | Number(10,0) | DECIMAL(10) NOT NULL | Financial Term ID |
| 12 | TERM_SCHED_ID | Number(30,0) | DECIMAL(30) NOT NULL | Lease Term Schedule ID |
| 13 | TXN_GRP | Character(1) | VARCHAR2(1) NOT NULL |
Transaction Group
1=Base Rent 2=Security Deposit 3=Straightline Accounting 4=Operating Expense 5=Percent Rent 6=Miscellaneous Rent 7=Manual Fee 8=Lease Obligation 9=Lease Interest Expense A=Prior Period Lease Obligation B=Prior Period Lease Interest C=Rent Expense D=Lease Incentive |
| 14 | CHG_GRP_CD | Character(10) | VARCHAR2(10) NOT NULL | This field holds the Charge Group Code for the Transaction Groups. |
| 15 | LEASE_OBLG | Character(1) | VARCHAR2(1) NOT NULL |
Lease Obligation either Payables or Receivables Lease
1=Payables 2=Receivables |
| 16 | AMOUNT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Amount |
| 17 | STRLN_AMOUNT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Straight Line Amount |
| 18 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 19 | SCHED_NUM | Number(5,0) | INTEGER NOT NULL | Team sequence number |
| 20 | PRIOR_PER_DIF | Signed Number(13,2) | DECIMAL(11,2) NOT NULL | Prior Period Difference for Opex Audit |
| 21 | TOTAL_ROW_COUNT | Number(8,0) | INTEGER NOT NULL | Total Row Count |
| 22 | LS_TXN_ID | Number(25,0) | DECIMAL(25) NOT NULL | Lease Transaction ID |
| 23 | MESSAGE_TEXT | Character(100) | VARCHAR2(100) NOT NULL | Message Text This field refers to the Text for a particular Message Number in the Message Catalog. |
| 24 | MESSAGE_TEXT_2 | Character(100) | VARCHAR2(100) NOT NULL | Message Text |
| 25 | LS_TXN_DTL_SEQ | Number(15,0) | DECIMAL(15) NOT NULL | Lease Transaction Detail ID |
| 26 | CATCH_UP_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Catch Up Amount |
| 27 | WHERE_CLAUSE | Character(254) | VARCHAR2(254) NOT NULL | Where Clause |
| 28 | LS_NBR | Character(10) | VARCHAR2(10) NOT NULL | Lease Number, User Enterable or Generated Sequence Number |
| 29 | WHERE_CLAUSE1 | Character(254) | VARCHAR2(254) NOT NULL | Where Clause |
| 30 | WHERE_CLAUSE2 | Character(254) | VARCHAR2(254) NOT NULL | Where Clause |
| 31 | CHECK_STATUS | Character(1) | VARCHAR2(1) NOT NULL | Work field used to store status values |
| 32 | FS_CHK_ENABLED | Character(1) | VARCHAR2(1) NOT NULL |
Check box for Enable/Disable
N=Disabled Y=Enabled |
| 33 | EFFDT_TO | Date(10) | DATE | Effective Date To |
| 34 | EFFDT_FROM | Date(10) | DATE | Effective Date From |
| 35 | RE_MTM_DURATION | Number(4,0) | SMALLINT NOT NULL | MTM Duration Field |
| 36 | LEASE_START_DT | Date(10) | DATE | Lease Start Date |
| 37 | LEASE_END_DT | Date(10) | DATE | Lease End Date |
| 38 | RE_OVERRIDE_STLINE | Character(1) | VARCHAR2(1) NOT NULL |
Override
D=Default from Lease O=Override |
| 39 | RE_STLINE_END_DT | Date(10) | DATE | Straightline End Date |