brinfo_raw
Core Schemas
>
Silverlake
>
brinfo_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 | |
| brcifno | CIF Number | CHAR(7) | NULLABLE | STRING | 7 |
| bracctno | Account number | DEC(16,0) | NULLABLE | INTEGER | 16 |
| bractype | Account type | CHAR(1) | NULLABLE | STRING | 1 |
| brfldtyp | Field type Character, Date, Amount | CHAR(1) | NULLABLE | STRING | 1 |
| brfldseq | Field Number | DEC(4,0) | NULLABLE | INTEGER | 4 |
| brchar | Character Value | CHAR(3) | NULLABLE | STRING | 3 |
| brdate7 | Date 7 | DEC(7,0) | NULLABLE | INTEGER | 7 |
| brdate6 | Date 6 | DEC(6,0) | NULLABLE | INTEGER | 6 |
| bramount | Amount | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| brentdt7 | Date entered 7 | DEC(7,0) | NULLABLE | INTEGER | 7 |
| brentdt6 | Date entered 6 | DEC(6,0) | NULLABLE | INTEGER | 6 |
Last updated Thu Dec 12 2024