cfacct_raw
Core Schemas
>
Silverlake
>
cfacct_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 | |
| cfacid | Record identifier | CHAR(1) | NULLABLE | STRING | 1 |
| cfcif_num_ | Customer number | CHAR(7) | NULLABLE | STRING | 7 |
| cfatyp | Account type | CHAR(1) | NULLABLE | STRING | 1 |
| cfacc_num_ | Account number | DEC(16,0) | NULLABLE | INTEGER | 16 |
| cfsnme | Short name | CHAR(20) | NULLABLE | STRING | 20 |
| cfrela | Relationship | CHAR(5) | NULLABLE | STRING | 5 |
| cfnotc | Mail notice code | CHAR(1) | NULLABLE | STRING | 1 |
| cfanos | Print name on statement | CHAR(1) | NULLABLE | STRING | 1 |
| cfadlm | Date of Last Maint | DEC(7,0) | NULLABLE | INTEGER | 7 |
| cfadl6 | Date of Last Maint | DEC(6,0) | NULLABLE | INTEGER | 6 |
| cfapct | Percent for Relationship | DEC(7,4) | NULLABLE | FLOAT | 7.4 |
| cfamax | Maximum for Relationship | DEC(11,2) | NULLABLE | FLOAT | 11.2 |
| cfcat | Category Code | CHAR(2) | NULLABLE | STRING | 2 |
| cfins | FDIC Insured | CHAR(1) | NULLABLE | STRING | 1 |
| cfmrg | Merged Account | CHAR(1) | NULLABLE | STRING | 1 |
| cfmrg6 | Merged Date | DEC(6,0) | NULLABLE | INTEGER | 6 |
| cfmrg7 | Merged Date | DEC(7,0) | NULLABLE | INTEGER | 7 |
| cfben | Qual Beneficiary | CHAR(1) | NULLABLE | STRING | 1 |
| cfpown | Percent Owned | DEC(5,2) | NULLABLE | FLOAT | 5.2 |
| cfrpdn | Past due notice for relationship | CHAR(1) | NULLABLE | STRING | 1 |
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