USERS

Owned by Daniel Hostrup Eriksen
Last updated: 10.11.2021 by Anders Nordbjærg (Deactivated)

Groups

USERS

Column NameData TypeField LengthNull?Data Def.Comments

ID

NUMBER

22

N


Primary key

ACCOUNT_ID

NUMBER

22

N


Foreign key referencing ACCOUNT-table

COMPANY

VARCHAR2

1020

Y



FIRST_NAME

VARCHAR2

240

Y



LAST_NAME

VARCHAR2

240

Y



ADDRESS1

VARCHAR2

360

Y



ADDRESS2

VARCHAR2

360

Y



CITY

VARCHAR2

160

Y



ZIP

VARCHAR2

160

Y



COUNTRY

VARCHAR2

160

Y



PHONE1

VARCHAR2

80

Y


 Deprecated

PHONE2

VARCHAR2

80

Y


 Deprecated

PHONE3

VARCHAR2

80

Y


 Deprecated

FAX

VARCHAR2

80

Y


 Deprecated

EMAIL

VARCHAR2

480

Y


 Deprecated

EMAIL2

VARCHAR2

480

Y


 Deprecated

BIRTHDAY

DATE

7

Y



LAST_CHANGED_DATE

DATE

7

Y



ADVERTISE_EMAIL

NUMBER

22

Y



U_COMMENT

VARCHAR2

1020

Y



STATUS_ID

NUMBER

22

Y



USERNAME

VARCHAR2

400

Y



PASSWORD

VARCHAR2

400

Y



QUESTION

VARCHAR2

4000

Y



ANSWER

VARCHAR2

4000

Y



STREET

VARCHAR2

1024

Y



STREET_NUMBER

VARCHAR2

48

Y



FLOOR

VARCHAR2

48

Y



FLOOR_UNIT

VARCHAR2

128

Y



PERSONAL_ID

VARCHAR2

200

Y



STATE_ID

NUMBER

22

Y



ADDR_ID

VARCHAR2

200

Y



CONT_ID

VARCHAR2

160

Y



CREDIT_RATING

VARCHAR2

4

Y



CREDIT_RATING_DATE

DATE

7

Y



CREDIT_SCORE

VARCHAR2

4

Y



CREDIT_SCORE_DATE

DATE

7

Y



OVERRIDE_CREDIT_SCORE_UNTIL

DATE

7

Y



GENDER

VARCHAR2

4

Y



CREDIT_LIMIT

NUMBER

22

Y



LANGUAGE_CODE

VARCHAR2

40

Y



REG_STATUS

VARCHAR2

4

Y



ADDRESS_CHECK_DATE

DATE

7

Y



PROVINCE

VARCHAR2

240

Y



ADDRESS_PROOF

NUMBER

22

Y



COUNTY

VARCHAR2

200

Y



DISTRICT

VARCHAR2

200

Y



BUILDING

VARCHAR2

200

Y



LAST_NAME_PREFIX

VARCHAR2

160

Y



INITIALS

VARCHAR2

60

Y



TITLE

VARCHAR2

80

Y



BLACKLISTED

NUMBER

22

Y



OLI_ID

VARCHAR2

200

Y



BRAND_ID

NUMBER

22

Y


Foreign key referencing BRAND-table

PERSONAL_ID_EXPIRY_DATE

DATE

7

Y



PERSONAL_ID_TYPE

VARCHAR2

120

Y



ADVERTISING

VARCHAR2

4

Y



ADVERTISING_CUSTOMER_DATA

VARCHAR2

4

Y



ADVERTISING_USAGE_DATA

VARCHAR2

4

Y



COMMUNICATION_TYPE

VARCHAR2

4

Y



ADVERTISE_SMS

NUMBER

22

Y



COMPANY_SUB_ID

VARCHAR2

120

Y



SHIPPING_ADDRESS_ID

NUMBER

22

Y


?

SHIPPING_ADDRESS_USER

VARCHAR2

4

Y


?

INSTALLATION_ADDRESS

VARCHAR2

4

Y



STREET_UNIT

VARCHAR2

48

Y



CONCURRENCY_KEY

NUMBER

22

Y



ACCESS_LEVEL

NUMBER

22

Y



VAT_NUMBER

VARCHAR2

400

Y



DIRECTION

VARCHAR2

40

Y



ZIP_EXT

VARCHAR2

40

Y



ADDRESS_STATE

VARCHAR2

40

Y



PO_BOX

VARCHAR2

160

Y



NATIONALITY

VARCHAR2

12

Y



STREET_UNIT_TYPEVARCHAR21000 BYTESY
With 9.9
STREET_TYPEVARCHAR21000 BYTESY
With 9.9

PASSWORD_PROFILE_KEY

VARCHAR2100Y
With 9.9 - Support for changes to password encryption functionality

PASSWORD_SHORTENED

VARCHAR2100Y
With 9.9 - Support for changes to password encryption functionality

PASSWORD_SALT

VARCHAR2400Y
With 9.9 - Support for random SALT generation in Core
PWD_VALIDATION_TOKENVARCHAR2500 CHAR

With 10.3.1 in support of password validation token on the users object
PWD_VALIDATION_TOKEN_DATEDATE


With 10.3.1 in support of password validation token on the users object

Contains all Users