lnpar3_raw
Core Schemas
>
Silverlake
>
lnpar3_raw
Column name | Description | Mode | Type | Length |
---|---|---|---|---|
__op | Contains the operation type. Values are I for insert, U for update, D for delete. | REQUIRED | STRING | |
__op_ts | operation timestamp added by export code | REQUIRED | TIMESTAMP | |
__uid | The Unique ID of this entry. Data, UUID, or GUID | REQUIRED | STRING | |
__ver | Mapping and Schema Version | REQUIRED | INTEGER | |
l3tran | Tran Code | DEC(5,0) | NULLABLE | INTEGER | 5 |
l3dorc | Dr/Cr Code | CHAR(1) | NULLABLE | STRING | 1 |
l3afft | Affects Code | CHAR(2) | NULLABLE | STRING | 2 |
l3afnp | Affects Next Pymt Date | CHAR(1) | NULLABLE | STRING | 1 |
l3tcds | Tran Code Description | CHAR(40) | NULLABLE | STRING | 40 |
l3stmd | Tran Code Stmnt Desc | CHAR(40) | NULLABLE | STRING | 40 |
l3fpay | Force Pay Tran Code | CHAR(1) | NULLABLE | STRING | 1 |
l3stmt | Print on statments | CHAR(1) | NULLABLE | STRING | 1 |
l3anal | Auto Analysis code | CHAR(1) | NULLABLE | STRING | 1 |
l3stps | Check Stop Pays | CHAR(1) | NULLABLE | STRING | 1 |
l3encl | Count as enclosure | CHAR(1) | NULLABLE | STRING | 1 |
l3ovzr | Override Close on Zero | CHAR(1) | NULLABLE | STRING | 1 |
l3stcd | Stmt Code | CHAR(2) | NULLABLE | STRING | 2 |
l3xadv | Exclude from Advances | CHAR(1) | NULLABLE | STRING | 1 |
l3lacd | Adv Allocation Code | CHAR(2) | NULLABLE | STRING | 2 |
l3fee_num_ | Fee Number | DEC(3,0) | NULLABLE | INTEGER | 3 |
l3part | Create participation transactions | CHAR(1) | NULLABLE | STRING | 1 |
l3edrf | Escrow disbursement refund credit | CHAR(1) | NULLABLE | STRING | 1 |
l3mone | Non Monetary Trans | CHAR(1) | NULLABLE | STRING | 1 |
l3rcpt | Transaction Receipt | CHAR(1) | NULLABLE | STRING | 1 |
l3mafe | Use Minimum Check Toler | CHAR(1) | NULLABLE | STRING | 1 |
l3ream | Re-amortize | CHAR(1) | NULLABLE | STRING | 1 |
l3waiv | Waive | CHAR(1) | NULLABLE | STRING | 1 |
l3svrs | Servicing Release | CHAR(1) | NULLABLE | STRING | 1 |
l3cash | CASH TRANSACTION | CHAR(1) | NULLABLE | STRING | 1 |
Last updated Thu Dec 12 2024