lnhist_raw
Core Schemas
>
Silverlake
>
lnhist_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 | |
| lhacct | Account number | DEC(16,0) | NULLABLE | INTEGER | 16 |
| lhatyp | Account type | CHAR(1) | NULLABLE | STRING | 1 |
| jhtranid | JH transaction ID | CHAR(10) | NULLABLE | STRING | 10 |
| lhtran | Tran code | DEC(5,0) | NULLABLE | INTEGER | 5 |
| lhafft | Affects code | CHAR(2) | NULLABLE | STRING | 2 |
| lhdorc | Dr/Cr code | CHAR(1) | NULLABLE | STRING | 1 |
| lhpstd | Posting date | DEC(7,0) | NULLABLE | INTEGER | 7 |
| lhpst6 | Posting date | DEC(6,0) | NULLABLE | INTEGER | 6 |
| lhamt | Transaction amount | DEC(11,2) | NULLABLE | FLOAT | 11.2 |
| lhefdt | Effective date | DEC(7,0) | NULLABLE | INTEGER | 7 |
| lhefd6 | Effective date | DEC(6,0) | NULLABLE | INTEGER | 6 |
| lhdudt | Payment Due date | DEC(7,0) | NULLABLE | INTEGER | 7 |
| lhdud6 | Payment Due date | DEC(6,0) | NULLABLE | INTEGER | 6 |
| lhsrc | Input source | CHAR(2) | NULLABLE | STRING | 2 |
| lhosts | Old status | DEC(1,0) | NULLABLE | INTEGER | 1 |
| lhnsts | New status | DEC(1,0) | NULLABLE | INTEGER | 1 |
| lhorat | Old rate | DEC(9,8) | NULLABLE | FLOAT | 9.8 |
| lhnrat | New rate | DEC(9,8) | NULLABLE | FLOAT | 9.8 |
| lhbat_num_ | Batch number | DEC(4,0) | NULLABLE | INTEGER | 4 |
| lhseq_num_ | Sequence number | DEC(10,0) | NULLABLE | INTEGER | 10 |
| lhpsq_num_ | Posted sequence | DEC(7,0) | NULLABLE | INTEGER | 7 |
| lhcqsq | CQ tran sequence | DEC(7,0) | NULLABLE | INTEGER | 7 |
| lheftp | EFT type | CHAR(3) | NULLABLE | STRING | 3 |
| lhefcd | EFT desc key | DEC(13,0) | NULLABLE | INTEGER | 13 |
| lhserl | Serial number | DEC(10,0) | NULLABLE | INTEGER | 10 |
| lhetyp | Escrow type | CHAR(2) | NULLABLE | STRING | 2 |
| lheseq | Escrow distribution seq# | DEC(3,0) | NULLABLE | INTEGER | 3 |
| lhstat | Transaction status | CHAR(1) | NULLABLE | STRING | 1 |
| lhshad | Shadow flag | CHAR(1) | NULLABLE | STRING | 1 |
| image_num_ | Image item # | DEC(15,0) | NULLABLE | INTEGER | 15 |
| hifrd6 | Interest from date | DEC(6,0) | NULLABLE | INTEGER | 6 |
| hifrd7 | Interest from date | DEC(7,0) | NULLABLE | INTEGER | 7 |
| hitod6 | Interest to date | DEC(6,0) | NULLABLE | INTEGER | 6 |
| hitod7 | Interest to date | DEC(7,0) | NULLABLE | INTEGER | 7 |
| lhabal | Accrual balance | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| lhlacd | Adv allocation code | CHAR(2) | NULLABLE | STRING | 2 |
| lhrvnpd6 | Reversed next payment due date | DEC(6,0) | NULLABLE | INTEGER | 6 |
| lhrvnpd7 | Reversed next payment due date | DEC(7,0) | NULLABLE | INTEGER | 7 |
| lhfee_num_ | Fee number | DEC(3,0) | NULLABLE | INTEGER | 3 |
| acfilk | ACH file key | CHAR(25) | NULLABLE | STRING | 25 |
| acbatn | ACH batch | DEC(7,0) | NULLABLE | INTEGER | 7 |
| acseqn | ACH seq | DEC(6,0) | NULLABLE | INTEGER | 6 |
| lnfpid | Unit number | CHAR(30) | NULLABLE | STRING | 30 |
| lhachsec | ACH standard entry class | CHAR(3) | NULLABLE | STRING | 3 |
| lhachcoi | ACH company ID | CHAR(10) | NULLABLE | STRING | 10 |
| lhfptp | DP plan Type | CHAR(3) | NULLABLE | STRING | 3 |
| lhfps_num_ | DP plan sequence number | DEC(3,0) | NULLABLE | INTEGER | 3 |
| lhuiytd | DP update YTD interest | CHAR(1) | NULLABLE | STRING | 1 |
| lhmuid | User ID | CHAR(24) | NULLABLE | STRING | 24 |
| lhepayee | Escrow payee | CHAR(35) | NULLABLE | STRING | 35 |
| lhfeeseq | Fee sequence | CHAR(26) | NULLABLE | STRING | 26 |
| lhpashst | Pass to servicing hist | CHAR(1) | NULLABLE | STRING | 1 |
| lhrefseq | Refund sequence | CHAR(26) | NULLABLE | STRING | 26 |
| lhjxpd | jXchange product | CHAR(15) | NULLABLE | STRING | 15 |
| lhjxvd | jXchange vendor | CHAR(15) | NULLABLE | STRING | 15 |
| lhtset_num_ | Transaction set number | DEC(3,0) | NULLABLE | INTEGER | 3 |
| lhtseq_num_ | Transaction set sequence number | DEC(3,0) | NULLABLE | INTEGER | 3 |
| lhprepst | Preposted code | CHAR(1) | NULLABLE | STRING | 1 |
| lnhrowid | Unique row ID | BIGINT(8) | NULLABLE | INTEGER | 8 |
| lnhrowcrt | Row create timestamp | TIMESTAMP LEN(26) | NULLABLE | STRING | 26 |
| lnhrowmnt | Row last maint timestamp | TIMESTAMP LEN(26) | NULLABLE | STRING | 26 |
Have a Question?
Have a how-to question? Seeing a weird error? Get help on
StackOverflow.
Register for the Digital Toolkit Meetup
where we answer technical Q&A from the audience.
Last updated Thu Dec 12 2024