Attribute Name

Type

Field Size

Description

Required

UniqueID

int

4

This attribute is assigned to a unique numeric value by the system when it is created. Once created it cannot be modified by the user or the system. All uniqueIDs are internal and needed for the LNOS server framework and must be on every table.

Required – system assigned

UniqueBusinessKey

varchar

50

This attribute is assigned to a unique string value by the user when it is created. Once created, it cannot be modified by the user or the system. The Unique Key values are typically provided by the user and are more meaningful to the user. Not all LNOS tables will have a unique Key value because certain child table records are always associated with their parent table record and the parent will always have a unique Key. Every child table record must have a unique ID file regardless.

Required – can be user assigned or system defaulted

ForeignID

int

This attribute is assigned to the TableID value that corresponds to the TableBusinessKey value on the FWTableName. It must be assigned whenever the TableBusinessKey value has been modified. It must be validated against the foreign table for existence. Used to link two tables together.

Required or Optional – system assigned

ForeignBusinessKey

varchar

50

This attribute is a foreign lookup key assigned by the user. It must exist on the foreign FWTableName.

Typically a pop-up window is provided for the user to select a valid ForeignBusinessKey from a displayed list of valid keys. As with the foreign ID, the foreign Key is used to link two tables together.

Required or Optional – user assigned

Company

varchar

50

It is used to specify a specific company in a multi-company environment. Currently it is ignored and can be used for display purposes.

Required when multiple companies exist

Comment

varchar

255

It is used to provide additional information about a specific record.

CreatedBy

int

This is an integer field that is set to the user id of the user who created this record. It is not user modifiable. Use same userid as modifiedby.

Required - system assigned

CreatedDate

datetime

8

This is a date field that should be saved in Universal Metric Time (UMT). It is updated only when the record was first created. It is not user modifiable.

Required – system assigned

ModifiedBy

int

This is an integer field that is set to the user id of the user who created or updated this record. It is not user modifiable.

Required - system assigned

ModifyDate

datetime

This is a date field that should be saved in the local time zone of the server with the following precision: yyyy:mm:ddThh:mm:ss:sss. It is updated every time this record is updated and created. It is not user modifiable.

Required - system assigned