| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
---|
| 1 | USRID | String 20 -> Name, Usrname, pwd, ... - use STRING for forms | nvarchar | 40 | 0 | CHAR | (N' ') | No | | AU_STRING | Allow NULL? |
| 2 | USRPWD | String 20 -> Name, Usrname, pwd, ... - use STRING for forms | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | AU_STRING | Allow NULL? |
| 3 | FIRSTNAME | String 20 -> Name, Usrname, pwd, ... - use STRING for forms | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | AU_STRING | Allow NULL? |
| 4 | LASTNAME | String 20 -> Name, Usrname, pwd, ... - use STRING for forms | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | AU_STRING | Allow NULL? |
| 5 | EMAIL | String 20 -> Name, Usrname, pwd, ... - use STRING for forms | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | AU_STRING | Allow NULL? |
| 6 | STREET | String 20 -> Name, Usrname, pwd, ... - use STRING for forms | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | AU_STRING | Allow NULL? |
| 7 | ZIP | String 20 -> Name, Usrname, pwd, ... - use STRING for forms | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | AU_STRING | Allow NULL? |
| 8 | CITY | String 20 -> Name, Usrname, pwd, ... - use STRING for forms | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | AU_STRING | Allow NULL? |
| 9 | COUNTRY | String 20 -> Name, Usrname, pwd, ... - use STRING for forms | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | AU_STRING | Allow NULL? |
| 10 | HEARDFROM | String 20 -> Name, Usrname, pwd, ... - use STRING for forms | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | AU_STRING | Allow NULL? |
| 11 | INTEREST | String 20 -> Name, Usrname, pwd, ... - use STRING for forms | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | AU_STRING | Allow NULL? |
| 12 | ACCOUNT | Auction - Amount | decimal | 10 | 2 | DEC | ((0)) | Yes | | AU_AMOUNT | |