udsalesmall Table (158)

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.