This table stores information pertaining to a sales order.
Fields
| Field |
Field Type |
Null |
Notes |
Description |
|
TRANSACTIONDATE
|
datetime
|
true
|
|
The date of the order transaction.
|
|
STATUSCODE
|
tinyint
|
false
|
|
Status of the condition of the order.
|
|
COMMENTS
|
nvarchar(1000)
|
false
|
|
Remarks about this sales order.
|
|
CUSTOMIDENTIFIER
|
nvarchar(100)
|
false
|
|
User-definable custom identifier.
|
|
SEQUENCEID
|
int
|
false
|
|
Identity column used to increment the default lookupid.
|
|
DATEADDED
|
datetime
|
false
|
|
Indicates the date this record was added.
|
|
DATECHANGED
|
datetime
|
false
|
|
Indicates the date this record was last changed.
|
|
TS
|
timestamp
|
false
|
|
Timestamp.
|
|
TSLONG
|
bigint (Computed)
|
true
|
|
Numeric representation of the timestamp.
|
|
SALESMETHODTYPECODE
|
tinyint
|
false
|
|
The type of sales method.
|
|
SALESMETHODTYPE
|
nvarchar(13) (Computed)
|
true
|
|
Provides a translation for the 'SALESMETHODTYPECODE' field.
|
|
LOOKUPID
|
nvarchar(100) (Computed)
|
true
|
|
Unique identifer that supports user defined values as well as system generated values.
|
|
SAMEASPATRON
|
bit
|
false
|
|
Determines if delivery information is same as patron information
|
|
TRANSACTIONDATEWITHTIMEOFFSET
|
datetimeoffset
|
true
|
|
The date of the order transaction.
|
|
LASTRECALCULATIONDATE
|
datetime
|
true
|
|
The date of the last recalculation of taxes, fees, and discounts.
|
|
STATUS
|
nvarchar(10) (Computed)
|
true
|
|
Provides a translation for the 'STATUSCODE' field.
|
|
REFUNDSTATUS
|
int (Computed)
|
true
|
|
|
|
AMOUNT
|
money (Computed)
|
true
|
|
|
|
ITEMDISCOUNTSCALCULATED
|
bit
|
false
|
|
|
