Sage 50 UK CREDIT_BUREAU Columns
Name | Type | Length | Precision | Notes | Example |
---|---|---|---|---|---|
NUMBER | SMALLINT | 2 | 5 | Bureau Number | 1 |
NAME | VARCHAR | 60 | 60 | Bureau Name | |
WEB_ADDRESS | VARCHAR | 255 | 255 | Web Site Address | |
CHECK_ADDRESS | VARCHAR | 255 | 255 | Credit Check Web Address | |
RECORD_CREATE_DATE | 16 | 0 | Date and time when the record was created. | 22/07/2008 16:37:55 | |
RECORD_MODIFY_DATE | 16 | 0 | Date and time when the record was modified. | 04/08/2017 14:18:53 | |
RECORD_DELETED | TINYINT | 2 | 3 | Flag denoting if the record has been deleted or not. | 0 |