lnfee_raw
Pipelined Data Sets
>
SilverLake
>
lnfee_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 | |
| lnfee_num_ | Fee number | DEC(3,0) | NULLABLE | INTEGER | 3 |
| lnfact | Account number | DEC(16,0) | NULLABLE | INTEGER | 16 |
| lnftyp | Account type | CHAR(1) | NULLABLE | STRING | 1 |
| lnfpid | Unit Number | CHAR(30) | NULLABLE | STRING | 30 |
| lnfdsc | Fee Description | CHAR(60) | NULLABLE | STRING | 60 |
| lnfasd | Amount Assessed | DEC(11,2) | NULLABLE | FLOAT | 11.2 |
| lnfrmn | Amount Remaining | DEC(11,2) | NULLABLE | FLOAT | 11.2 |
| lnfas6 | Assessed Date | DEC(6,0) | NULLABLE | INTEGER | 6 |
| lnfas7 | Assessed Date | DEC(7,0) | NULLABLE | INTEGER | 7 |
| lnfbl6 | Billed Date | DEC(6,0) | NULLABLE | INTEGER | 6 |
| lnfbl7 | Billed Date | DEC(7,0) | NULLABLE | INTEGER | 7 |
| lnfpd6 | Paid Date | DEC(6,0) | NULLABLE | INTEGER | 6 |
| lnfpd7 | Paid Date | DEC(7,0) | NULLABLE | INTEGER | 7 |
| lnfcpt | Capitalized | CHAR(1) | NULLABLE | STRING | 1 |
| lnfcd6 | Capitalized Date 6 | DEC(6,0) | NULLABLE | INTEGER | 6 |
| lnfwvd6 | Fee waived date | DEC(6,0) | NULLABLE | INTEGER | 6 |
| lnfwvd7 | Fee waived date | DEC(7,0) | NULLABLE | INTEGER | 7 |
| lnfcd7 | Capitalized Date 7 | DEC(7,0) | NULLABLE | INTEGER | 7 |
| lnfptp | DP Plan Type | CHAR(3) | NULLABLE | STRING | 3 |
| lnfps_num_ | DP Plan Sequence Number | DEC(3,0) | NULLABLE | INTEGER | 3 |
| lnfeeseq | Fee Sequence | CHAR(26) | NULLABLE | STRING | 26 |
| lnfeerowid | Unique row ID | BIGINT(8) | NULLABLE | INTEGER | 8 |
| lnfeecrtts | Row create timestamp | TIMESTAMP LEN(26) | NULLABLE | STRING | 26 |
| lnfeemntts | 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 Developer Office Hours where we answer technical Q&A from the audience.
Did this page help you?
Last updated Wed Mar 4 2026