| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
---|
| 1 | OFFID | | int | 10 | 0 | INT4 | ((0)) | No | | AU_INDEX | Allow NULL? |
| 2 | USERID | String 20 -> Name, Usrname, pwd, ... - use STRING for forms | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | AU_STRING | Allow NULL? |
| 3 | HEADDESC | String 20 -> Name, Usrname, pwd, ... - use STRING for forms | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | AU_STRING | Allow NULL? |
| 4 | ENDDATE | Auction Date Format | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | AU_DATE | Allow NULL? |
| 5 | ENDTIME | Auction Time Format | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | AU_TIME | Allow NULL? |
| 6 | OFFCOND | String 20 -> Name, Usrname, pwd, ... - use STRING for forms | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | AU_STRING | Allow NULL? |
| 7 | PAYMENT | String 20 -> Name, Usrname, pwd, ... - use STRING for forms | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | AU_STRING | Allow NULL? |
| 8 | SHIPPING | String 20 -> Name, Usrname, pwd, ... - use STRING for forms | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | AU_STRING | Allow NULL? |
| 9 | PICURL | String 20 -> Name, Usrname, pwd, ... - use STRING for forms | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | AU_STRING | Allow NULL? |
| 10 | EXPIRED | 0 for false, 1 for true | tinyint | 3 | 0 | INT1 | ((0)) | Yes | | AU_BOOLEAN | |
| 11 | CATEGORY | | int | 10 | 0 | INT4 | ((0)) | Yes | | AU_INDEX | Allow NULL? |
| 12 | LOCCITY | String 20 -> Name, Usrname, pwd, ... - use STRING for forms | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | AU_STRING | Allow NULL? |
| 13 | LOCZIP | String 20 -> Name, Usrname, pwd, ... - use STRING for forms | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | AU_STRING | Allow NULL? |
| 14 | LOCCOUNTRY | String 20 -> Name, Usrname, pwd, ... - use STRING for forms | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | AU_STRING | Allow NULL? |