cdpar6_raw
Core Schemas
>
Silverlake
>
cdpar6_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 | |
p6plan | Plan Code | CHAR(3) | NULLABLE | STRING | 3 |
p6desc | Description | CHAR(35) | NULLABLE | STRING | 35 |
p6type | Type of Plan | CHAR(3) | NULLABLE | STRING | 3 |
p6fee | Fee Code | DEC(5,2) | NULLABLE | FLOAT | 5.2 |
p6dord | Distribution order | CHAR(2) | NULLABLE | STRING | 2 |
p6dist | Auto Distribution | CHAR(1) | NULLABLE | STRING | 1 |
p6dlay | Auto Delay 1ST Dist | CHAR(1) | NULLABLE | STRING | 1 |
p6rclc | Auto Recalculate | CHAR(1) | NULLABLE | STRING | 1 |
p6rdce | Auto Reduce Final Dist | CHAR(1) | NULLABLE | STRING | 1 |
Last updated Thu Dec 12 2024