sdmast_raw
Core Schemas
>
Silverlake
>
sdmast_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 | |
| sdreci | ID | CHAR(1) | NULLABLE | STRING | 1 |
| branch | BRANCH | DEC(3,0) | NULLABLE | INTEGER | 3 |
| acctno | BOX NUMBER | DEC(16,0) | NULLABLE | INTEGER | 16 |
| boxid | BOX ID | CHAR(16) | NULLABLE | STRING | 16 |
| sname | SHORT NAME | CHAR(20) | NULLABLE | STRING | 20 |
| cifno | CIF NUMBER | CHAR(7) | NULLABLE | STRING | 7 |
| altadd | ALTERNATE ADDRESS | CHAR(1) | NULLABLE | STRING | 1 |
| addnam | ADDITIONAL NAMES | CHAR(1) | NULLABLE | STRING | 1 |
| altnam | ALTERNATE NAME | CHAR(1) | NULLABLE | STRING | 1 |
| actype | ACCT TYPE | CHAR(1) | NULLABLE | STRING | 1 |
| argprdcod | ARGO product type | CHAR(3) | NULLABLE | STRING | 3 |
| glcost | GL Cost Center | DEC(4,0) | NULLABLE | INTEGER | 4 |
| glprod | GL Product Code | DEC(3,0) | NULLABLE | INTEGER | 3 |
| rent | RENT | DEC(9,2) | NULLABLE | FLOAT | 9.2 |
| partpy | Partial Pay Amount | DEC(9,2) | NULLABLE | FLOAT | 9.2 |
| dscamt | Discount amount | DEC(9,2) | NULLABLE | FLOAT | 9.2 |
| dscpct | Discount percentage | DEC(5,4) | NULLABLE | FLOAT | 5.4 |
| duedt7 | DUE DATE | DEC(7,0) | NULLABLE | INTEGER | 7 |
| chgcod | CHARGE CODES | CHAR(1) | NULLABLE | STRING | 1 |
| dtopn7 | DATE OPENED | DEC(7,0) | NULLABLE | INTEGER | 7 |
| lbstat | STATUS | CHAR(1) | NULLABLE | STRING | 1 |
| dnotdt7 | DRILL NOTICE DATE | DEC(7,0) | NULLABLE | INTEGER | 7 |
| keydep | KEY DEPOSIT | DEC(9,2) | NULLABLE | FLOAT | 9.2 |
| prime | PRIME | DEC(3,0) | NULLABLE | INTEGER | 3 |
| chgact | ACCT TO CHARGE | DEC(16,0) | NULLABLE | INTEGER | 16 |
| chgtyp | ACCT TYPE | CHAR(1) | NULLABLE | STRING | 1 |
| msg | MSG CODE | CHAR(1) | NULLABLE | STRING | 1 |
| sdsic1 | SIC #1 | CHAR(1) | NULLABLE | STRING | 1 |
| sdsic2 | SIC #2 | CHAR(1) | NULLABLE | STRING | 1 |
| sdsic3 | SIC #3 | CHAR(1) | NULLABLE | STRING | 1 |
| sdsic4 | SIC #4 | CHAR(1) | NULLABLE | STRING | 1 |
| sigver | VERIFY ENT SIGN | CHAR(1) | NULLABLE | STRING | 1 |
| rstent | ENTRY RESTRICTED | CHAR(1) | NULLABLE | STRING | 1 |
| xclud | INCLUDE ON STMT | CHAR(1) | NULLABLE | STRING | 1 |
| holdm | HOLD MAIL | CHAR(1) | NULLABLE | STRING | 1 |
| sdexem | TAX EXEMPT | CHAR(1) | NULLABLE | STRING | 1 |
| dlmamt | LAST MAINT DATE | DEC(7,0) | NULLABLE | INTEGER | 7 |
| laspd7 | Last Pay Date | DEC(7,0) | NULLABLE | INTEGER | 7 |
| pdflag | PAST DUE FLAG | CHAR(1) | NULLABLE | STRING | 1 |
| duedt6 | DUE DATE-MMDDYY | DEC(6,0) | NULLABLE | INTEGER | 6 |
| dtopn6 | DATE OPEN-MMDDYY | DEC(6,0) | NULLABLE | INTEGER | 6 |
| laspd6 | Last Pay-MMDDYY | DEC(6,0) | NULLABLE | INTEGER | 6 |
| dlmam6 | LAST MAINT DATE | DEC(6,0) | NULLABLE | INTEGER | 6 |
| lctype | Late Charge Type | CHAR(1) | NULLABLE | STRING | 1 |
| cnvdt6 | Conversion Date | DEC(6,0) | NULLABLE | INTEGER | 6 |
| cnvdt7 | Conversion Date | DEC(7,0) | NULLABLE | INTEGER | 7 |
| sdpic1 | Programmer Use #1 | CHAR(2) | NULLABLE | STRING | 2 |
| sdpic2 | Programmer Use #2 | CHAR(2) | NULLABLE | STRING | 2 |
| sdpdt1 | Programmer DATE #1 | DEC(7,0) | NULLABLE | INTEGER | 7 |
| sdpd61 | Programmer DATE #1 | DEC(6,0) | NULLABLE | INTEGER | 6 |
| sdpdt2 | Programmer DATE #2 | DEC(7,0) | NULLABLE | INTEGER | 7 |
| sdpd62 | Programmer DATE #2 | DEC(6,0) | NULLABLE | INTEGER | 6 |
| sdpam1 | Programmer AMT #1 | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| sdpam2 | Programmer AMT #2 | DEC(13,2) | NULLABLE | FLOAT | 13.2 |
| rtrvd7 | RATE REVIEW DATE | DEC(7,0) | NULLABLE | INTEGER | 7 |
| rtrvd6 | RATE REVIEW DATE | DEC(6,0) | NULLABLE | INTEGER | 6 |
| rtrvtm | RATE REVIEW TERM | DEC(3,0) | NULLABLE | INTEGER | 3 |
| rtrvtc | RATE REVIEW TERM CODE | CHAR(1) | NULLABLE | STRING | 1 |
| rtrvvr | RATE VARIANCE | DEC(9,2) | NULLABLE | FLOAT | 9.2 |
| rtrvvc | RATE VARIANCE CODE | CHAR(1) | NULLABLE | STRING | 1 |
| secure | Account Level Security | CHAR(1) | NULLABLE | STRING | 1 |
| sdregp | Privacy Act opt out | CHAR(1) | NULLABLE | STRING | 1 |
| salesac | Sales Associate | CHAR(15) | NULLABLE | STRING | 15 |
| sdlang | LANGUAGE IDENTIFIER | CHAR(3) | NULLABLE | STRING | 3 |
| sdmast_id | Unique row ID | BIGINT(8) | NULLABLE | INTEGER | 8 |
| sdmcrtts | Row create timestamp | TIMESTAMP LEN(26) | NULLABLE | STRING | 26 |
| sdmmntts | 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