This table is used to represent the different product related information. It is a child of the order table which cannot exist on its own.
|
Attribute Name |
Type |
Field Size |
Description |
Required |
|
int |
4 |
Unique internal DB Identifier of the Order Line record. |
Required | |
|
int |
4 |
Unique internal DB Identifier of the Order record. Must exist in the FWOrder table. |
Required | |
|
nvarchar |
50 |
This value is used to reference the Product business key from the external Order Entry TAD system. |
Required | |
|
int |
4 |
See ModifiedBy. |
| |
|
datetime |
8 |
See ModifyDate. |
| |
|
int |
4 |
See CreatedBy. |
| |
|
datetime |
8 |
See CreatedDate. |
| |
|
nvarchar |
500 |
See Comment. |
| |
|
nvarchar |
255 |
This value is used to describe the product being moved. It is needed for online display information. |
| |
|
nvarchar |
255 |
This value is used to describe the product vendor being moved. It is needed for online display information. |
| |
|
float |
8 |
This value cannot be equal to or less than zero. |
Required | |
|
int |
4 |
This numeric value in seconds is added to the other service values from the FWProduct, FWOrder, FWStopTemplate and FWLocation tables. See the StopTemplate table for more details. |
| |
|
int |
4 |
This numeric value in seconds is added to the other pre-service values from the FWOrder and FWStopTemplate and FWLocation. See the StopTemplate for more details. |
| |
|
float |
8 |
This numeric value is added to the other profit values from the FWOrder and FWStopTemplate and FWLocation. |
| |
|
nvarchar |
255 |
This is a string value that is linked with the requirements for the FWOrder, FWStopTemplate, and FWLocation. Each value must exist on the FWCode table for type Requirements. A selection list should be provided where one or more requirements can be selected. See the StopTemplate for more details. |
| |
|
nvarchar |
255 |
This attribute holds the additional commodities at the order line level that is linked with the commodities from the Order, Stop Template, and Location tables whenever an activity is created. Each value must exist on the FWCode table for type Commodities. A selection list should be provided where one or more commodities can be selected. See the StopTemplate for more details. |
| |
|
float |
8 |
This numeric value is added to the other Measure1-9 amount values supplied with the activity input function. |
Measure1 is Required | |
|
float |
8 |
This numeric value is used to adjust the actual corresponding measure amount. It is applied when the FWActivity Measures are created, but only for the OrderLine Measure portion. |
| |
|
float |
8 |
Rate used to calculate the service duration to service Measure x units. Specified in units/second. |
| |
|
int |
4 |
Unique Identifier of the FWActivity record. |
| |
|
nvarchar |
50 |
Business key to identify the activity this Order Line refers to. Must exist in the FWActivity table. |
| |
|
nvarchar |
500 |
User Defined Fields for Strings 1...9 |
| |
|
int |
4 |
User Defined Fields for integers 1..3 |
| |
|
float |
8 |
User Defined fields for numbers 1…3 |
| |
|
float |
8 |
Original reading reported for Measure 1…9 |
| |
|
tinyint |
1 |
Specifies the Measure number to which the specified ServiceRate should be applied. |
| |
|
int |
4 |
Unique Identifier of the FWProductType record. |
| |
|
nvarchar |
50 |
Business key to identify the product type this Order Line refers to. Must exist in the FWProductType table. |
| |
|
int |
4 |
Used in Double ended orders. This field indicates the ServiceDuration at the Pickup location. This number will be added to the total ServiceDuration of the FWActivity ServiceDuration field. |
| |
|
int |
4 |
Used in Double ended orders. This field indicates the PreServiceDuration at the Pickup location. This number will be added to the total PreServiceDuration of the FWActivity PreServiceDuration field. |
| |
|
float |
8 |
Used in Double ended orders. This field indicates the ServiceDuration at the Delivery location. This number will be added to the total ServiceDuration of the FWActivity ServiceDuration field. |
| |
|
float |
8 |
Used in Double ended orders. This field indicates the PreServiceDuration at the Delivery location. This number will be added to the total PreServiceDuration of the FWActivity PreServiceDuration field. |
| |
|
int |
4 |
The Requirement Set ID taken from the FWRequirementSet table. |
| |
|
nvarchar |
|
ProductTypeKey for this order line. If not present, then ActualMeasures must be provided or will be assumed 0. |
| |
|
float |
|
Required if ProductTypeKey is used |
| |
|
int, nvarchar, float, datetime |
|
User defined fields at the Order Line level. |
| |
|
float |
8 |
Actual reading reported for Measure 1…9 |
|