ACCOUNT

Owned by Daniel Hostrup Eriksen
Last updated: 20.09.2017 by Søren Duusgaard (Deactivated)

Groups

ACCOUNT

Column NameData TypeField LengthNot Null?Data Def.Comment

ID

NUMBER

22

N

 'Primary' key

ACCOUNT_TYPE

VARCHAR2

15

Y

 The account type (Business/Private)

OWNER_ID

NUMBER

22

Y

 Foreign key to USER-table

STATUS_ID

NUMBER

22

Y

 Status table check

INVOICE_CYCLE_DAY

NUMBER

22

Y

 Day for the Invoice cycle

INVOICE_CYCLE_LENGTH

NUMBER

22

Y

 Length of the invoice cycle in days

SMALL_INVOICE_LIMIT

NUMBER

22

Y

 The minimum amount for the invoice a invoice must have before it is closed

OLDID

NUMBER

22

Y

  

LAST_CHANGED_DATE

DATE

7

Y

 The date of the last change made to the account

PARTNER_CODE

VARCHAR2

15

Y

 Sales partner code

CURRENT_BALANCE

NUMBER

22

Y

 The current balance for the account

CUSTOMER_NUMBER

VARCHAR2

50

Y

 Customer number

WARNING

VARCHAR2

1000

Y

 Warning message

SALES_REP

VARCHAR2

50

Y

 The name or initials of the Sales rep.

REFERENCED_BY

VARCHAR2

30

Y

 The name or code of the reference for creation of the account

CAMPAIGN

VARCHAR2

30

Y

 NOT USED Campaign description

INSURANCE

VARCHAR2

30

Y

 NOT USED Insurance name

ACC_ROW_ID

VARCHAR2

40

Y

  

ACCOUNT_GROUP_ID

NUMBER

22

Y

 The ID for the account group

BRAND_ID

NUMBER

22

Y

 Foreign key - BRAND-table

ACCOUNT_SIGNUP_SHOP_ID

NUMBER

22

Y

 The ID for the sales Shop

OWNER_CHECKED

CHAR

1

Y

  

SIGNED

VARCHAR2

10

Y

  

COMPANY_NO

VARCHAR2

200

Y

 Company number (VAT no./CVR)

PARENT_ID

NUMBER

22

Y

 Foreign key - ACCOUNT-table

ALIAS

VARCHAR2

100

Y

 Alias for the account (Account name)

Contains all Accounts