udsalesmall Table (158)

• 8 minutes to read
 • 8 minutes to read

User-defined fields

Fields

Name Description Type Null
udsalesmall_id Primary key PK
long01 long value 1, indexed Id ●
long02 long value 2, indexed Id ●
long03 long value 3, indexed Id ●
long04 long value 4, indexed Id ●
long05 long value 5, not indexed Id ●
long06 long value 6, not indexed Id ●
long07 long value 7, not indexed Id ●
long08 long value 8, not indexed Id ●
long09 long value 9, not indexed Id ●
long10 long value 10, not indexed Id ●
long11 long value 11, not indexed Id ●
long12 long value 12, not indexed Id ●
long13 long value 13, not indexed Id ●
long14 long value 14, not indexed Id ●
long15 long value 15, not indexed Id ●
long16 long value 16, not indexed Id ●
long17 long value 17, not indexed Id ●
long18 long value 18, not indexed Id ●
long19 long value 19, not indexed Id ●
long20 long value 20, not indexed Id ●
long21 long value 21, not indexed Id ●
long22 long value 22, not indexed Id ●
long23 long value 23, not indexed Id ●
long24 long value 24, not indexed Id ●
long25 long value 25, not indexed Id ●
long26 long value 26, not indexed Id ●
long27 long value 27, not indexed Id ●
long28 long value 28, not indexed Id ●
long29 long value 29, not indexed Id ●
long30 long value 30, not indexed Id ●
long31 long value 31, not indexed Id ●
long32 long value 32, not indexed Id ●
long33 long value 33, not indexed Id ●
long34 long value 34, not indexed Id ●
long35 long value 35, not indexed Id ●
long36 long value 36, not indexed Id ●
long37 long value 37, not indexed Id ●
long38 long value 38, not indexed Id ●
long39 long value 39, not indexed Id ●
long40 long value 40, not indexed Id ●
long41 long value 41, not indexed Id ●
long42 long value 42, not indexed Id ●
long43 long value 43, not indexed Id ●
long44 long value 44, not indexed Id ●
long45 long value 45, not indexed Id ●
long46 long value 46, not indexed Id ●
long47 long value 47, not indexed Id ●
long48 long value 48, not indexed Id ●
long49 long value 49, not indexed Id ●
long50 long value 50, not indexed Id ●
long51 long value 51, not indexed Id ●
long52 long value 52, not indexed Id ●
long53 long value 53, not indexed Id ●
long54 long value 54, not indexed Id ●
long55 long value 55, not indexed Id ●
long56 long value 56, not indexed Id ●
long57 long value 57, not indexed Id ●
long58 long value 58, not indexed Id ●
long59 long value 59, not indexed Id ●
long60 long value 60, not indexed Id ●
string01 string value 1, indexed String(39) ●
string02 string value 2, indexed String(39) ●
string03 string value 3, indexed String(39) ●
string04 string value 4, indexed String(39) ●
string05 string value 5, not indexed String(39) ●
string06 string value 6, not indexed String(39) ●
string07 string value 7, not indexed String(39) ●
string08 string value 8, not indexed String(39) ●
string09 string value 9, not indexed String(39) ●
string10 string value 10, not indexed String(39) ●
string11 string value 11, not indexed String(39) ●
string12 string value 12, not indexed String(39) ●
string13 string value 13, not indexed String(39) ●
string14 string value 14, not indexed String(39) ●
string15 string value 15, not indexed String(39) ●
string16 string value 16, not indexed String(39) ●
string17 string value 17, not indexed String(39) ●
string18 string value 18, not indexed String(39) ●
string19 string value 19, not indexed String(39) ●
string20 string value 20, not indexed String(39) ●
string21 string value 21, not indexed String(39) ●
string22 string value 22, not indexed String(39) ●
string23 string value 23, not indexed String(39) ●
string24 string value 24, not indexed String(39) ●
string25 string value 25, not indexed String(39) ●
string26 string value 26, not indexed String(39) ●
string27 string value 27, not indexed String(39) ●
string28 string value 28, not indexed String(39) ●
string29 string value 29, not indexed String(39) ●
string30 string value 30, not indexed String(39) ●
string31 string value 31, not indexed String(39) ●
string32 string value 32, not indexed String(39) ●
string33 string value 33, not indexed String(39) ●
string34 string value 34, not indexed String(39) ●
string35 string value 35, not indexed String(39) ●
string36 string value 36, not indexed String(39) ●
string37 string value 37, not indexed String(39) ●
string38 string value 38, not indexed String(39) ●
string39 string value 39, not indexed String(39) ●
string40 string value 40, not indexed String(39) ●
double01 double value 1, indexed Double ●
double02 double value 2, indexed Double ●
double03 double value 3, indexed Double ●
double04 double value 4, indexed Double ●
double05 double value 5, not indexed Double ●
double06 double value 6, not indexed Double ●
double07 double value 7, not indexed Double ●
double08 double value 8, not indexed Double ●
double09 double value 9, not indexed Double ●
double10 double value 10, not indexed Double ●

udsalesmall table relationship diagram

Indexes

Fields Types Description
udsalesmall_id PK Clustered, Unique
long01 Id Index
long02 Id Index
long03 Id Index
long04 Id Index
string01 String(39) Index
string02 String(39) Index
string03 String(39) Index
string04 String(39) Index
double01 Double Index
double02 Double Index
double03 Double Index
double04 Double Index

Relationships

Table Description
sale Sales For every Sale record edited through the SuperOffice GUI, a copy of the current version of the record will be saved in the SaleHist table. This also applies to editing done through the SaleModel COM interface, but not to editing done through the OLE DB Provider or other channels.
SaleHist Mirror image of the Sale table, providing a full transaction history. Every time you edit a sale, the current record of the sale is also saved here.

Replication Flags

  • Area Management controlled table. Contents replicated to satellites and traveller databases.
  • Replicate changes UP from satellites and travellers back to central.
  • Copy to satellite and travel prototypes.

Security Flags

  • Sentry controls access to items in this table using user's Role and data rights matrix on the table's parent.