ITINERARYRESOURCE (4.0SP17)

Lists the resources used by an itinerary.

Primary Key
Primary Key Field Type

ID

uniqueidentifier

Foreign Key Fields
Foreign Key Field Type Null Notes Description

ITINERARYID

uniqueidentifier

false

The itinerary that the resource is used for.

RESOURCEID

uniqueidentifier

false

The resource associated with the itinerary.

ADDEDBYID

uniqueidentifier

false

FK to CHANGEAGENT.

CHANGEDBYID

uniqueidentifier

false

FK to CHANGEAGENT.

Fields
Field Field Type Null Notes Description

QUANTITYNEEDED

int

false

0

The quantity of the resource needed for this itinerary.

DATEADDED

datetime

false

getdate()

Indicates the date this record was added.

DATECHANGED

datetime

false

getdate()

Indicates the date this record was last changed.

TS

timestamp

false

Timestamp.

TSLONG

bigint (Computed)

true

Numeric representation of the timestamp.

PRICE

money

false

0

The price of the resource.

PRICINGSTRUCTURECODE

tinyint

false

0

Indicates the pricing structure for the resource.

PRICINGSTRUCTURE

nvarchar(24) (Computed)

true

Provides a translation for the 'PRICINGSTRUCTURECODE' field.

IGNORESQUANTITYFORCAPACITY

bit

false

0

For group check-in, bypass constraint on quantity required for capacity.

PERTICKETQUANTITY

int

false

0

The number of items used per each ticket sold, only valid when this is a per ticket item.

PERTICKETDIVISOR

int

false

1

The number of tickets PERTICKETQUANTITY should be divided by to get the actual per ticket quantity.

Indexes
Index Name Field(s) Unique Primary Clustered

IX_ITINERARYRESOURCE_DATEADDED

DATEADDED

False

False

True

IX_ITINERARYRESOURCE_DATECHANGED

DATECHANGED

False

False

False

PK_ITINERARYRESOURCE

ID

True

True

False

UIX_ITINERARYRESOURCE_ITINERARYID_RESOURCEID

ITINERARYID

RESOURCEID

True

False

False

Triggers
Trigger Name Description

TR_ITINERARYRESOURCE_DELETE_REQUIREDRESOURCECANNOTBEDELETED

TR_ITINERARYRESOURCE_AUDIT_UPDATE

TR_ITINERARYRESOURCE_AUDIT_DELETE

TR_ITINERARYRESOURCE_INSERT_RESOURCE_UPDATE

TR_ITINERARYRESOURCE_UPDATE_RESOURCE_UPDATE

TR_ITINERARYRESOURCE_DELETE_RESOURCE_UPDATE

Referenced by
Referenced by Field

SALESORDERITEMITINERARYRESOURCE

ITINERARYRESOURCEID