Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
---|---|---|---|---|---|---|---|---|---|---|
payerid | int | 4 | √ | null |
|
|
||||
payercode | varchar | 5 | √ | null |
|
|
||||
payercode2 | varchar | 10 | √ | null |
|
|
||||
payername | varchar | 50 | √ | null |
|
|
||||
payertype | varchar | 20 | √ | null |
|
|
||||
payeraccountid | int | 4 | √ | null |
|
|
||||
createddate | datetime | 16,3 | √ | null |
|
|
||||
revisiondate | datetime | 16,3 | √ | null |
|
|
||||
deleted | varchar | 1 | √ | null |
|
|
||||
roomchargebilldesc | varchar | 50 | √ | null |
|
|
||||
useratedesc | char | 1 | √ | null |
|
|
||||
showcarelevel | char | 1 | √ | null |
|
|
||||
facilityid | int | 4 | √ | null |
|
|
||||
mpprflag | char | 1 | √ | null |
|
|
||||
ppsflag | char | 1 | √ | null |
|
|
||||
collectionstemplateid | int | 4 | √ | null |
|
|
||||
dss_update_time | datetime | 16,3 | √ | null |
|
|