Table ptms..TripTransactions

Column Name Type Length Nullable Description Relationships

Identity ID int identity No

TransactionNumber numeric Yes

Vehicle varchar 4 Yes

Tripdate datetime Yes

JDATE numeric Yes

Date varchar 4 Yes

ClientID varchar 10 Yes

LastName varchar 20 Yes

FirstName varchar 10 Yes

Agency varchar 3 Yes

Funding varchar 3 Yes

Purpose varchar 3 Yes

DriverInstructions varchar 100 Yes

ProcedureModifier varchar 2 Yes

PickupTime varchar 5 Yes

ActualPickupTime varchar 5 Yes

PickupLocation varchar 50 Yes

DropTime varchar 5 Yes

ActualDropTime varchar 5 Yes

Destination varchar 50 Yes

Tripcode varchar 3 Yes

Fare money Yes

TakeOrReturn varchar 1 Yes

Status varchar 1 Yes

Miles numeric Yes

Rate0 money Yes

Special varchar 3 Yes

DemandOrRoutine varchar 1 Yes

PickupZone varchar 6 Yes

DropZone varchar 6 Yes

Keydate varchar 6 Yes

Keytime varchar 5 Yes

WebVerified varchar 1 Yes

Verified varchar 1 Yes

InvoiceFlag varchar 1 Yes

InvoiceDate numeric Yes

Invnum varchar 12 Yes

ReferenceNumber varchar 20 Yes

InvoiceAmount money Yes

PaymentAmount money Yes

ScheduleRecordNumber numeric Yes

PaymentDate datetime Yes

CreditAmount money Yes

CreditDate datetime Yes

WriteOffAmount money Yes

WriteOffDate datetime Yes

Balance money Yes

SpecialStatus varchar 1 Yes

ActualVehicle varchar 4 Yes

Driver varchar 3 Yes

Provider varchar 4 Yes

OdometerOn numeric Yes

OdometerOff numeric Yes

DateTripRequest datetime Yes

TimeTripRequest varchar 5 Yes

UserTripRequest varchar 30 Yes

DefaultPickupTime varchar 5 Yes

DefaultDropTime varchar 5 Yes

DispatchTime varchar 5 Yes

CalculatedMiles numeric Yes

Timestamp datetime Yes

DestinationID numeric Yes

DestinationSource varchar 1 Yes

PickupLocationID numeric Yes

PickupLocationSource varchar 1 Yes

ScheduleRecordID numeric Yes

LastUpdate datetime Yes

LastUpTime varchar 5 Yes

LastUpUser varchar 30 Yes

Note varchar 100 Yes

BillNote varchar 100 Yes

Renew bit Yes

StatusReason varchar 50 Yes

Indexes on this table

Index Name Index Description Index Keys

PK_TripTransactions clustered, unique, primary key located on PRIMARY ID

U_TransactionNumberTripdate nonclustered, unique located on PRIMARY TransactionNumber,
Tripdate

	Column Name	Type	Length	Nullable	Description	Relationships
Identity	ID	int identity		No
	TransactionNumber	numeric		Yes
	Vehicle	varchar	4	Yes
	Tripdate	datetime		Yes
	JDATE	numeric		Yes
	Date	varchar	4	Yes
	ClientID	varchar	10	Yes
	LastName	varchar	20	Yes
	FirstName	varchar	10	Yes
	Agency	varchar	3	Yes
	Funding	varchar	3	Yes
	Purpose	varchar	3	Yes
	DriverInstructions	varchar	100	Yes
	ProcedureModifier	varchar	2	Yes
	PickupTime	varchar	5	Yes
	ActualPickupTime	varchar	5	Yes
	PickupLocation	varchar	50	Yes
	DropTime	varchar	5	Yes
	ActualDropTime	varchar	5	Yes
	Destination	varchar	50	Yes
	Tripcode	varchar	3	Yes
	Fare	money		Yes
	TakeOrReturn	varchar	1	Yes
	Status	varchar	1	Yes
	Miles	numeric		Yes
	Rate0	money		Yes
	Special	varchar	3	Yes
	DemandOrRoutine	varchar	1	Yes
	PickupZone	varchar	6	Yes
	DropZone	varchar	6	Yes
	Keydate	varchar	6	Yes
	Keytime	varchar	5	Yes
	WebVerified	varchar	1	Yes
	Verified	varchar	1	Yes
	InvoiceFlag	varchar	1	Yes
	InvoiceDate	numeric		Yes
	Invnum	varchar	12	Yes
	ReferenceNumber	varchar	20	Yes
	InvoiceAmount	money		Yes
	PaymentAmount	money		Yes
	ScheduleRecordNumber	numeric		Yes
	PaymentDate	datetime		Yes
	CreditAmount	money		Yes
	CreditDate	datetime		Yes
	WriteOffAmount	money		Yes
	WriteOffDate	datetime		Yes
	Balance	money		Yes
	SpecialStatus	varchar	1	Yes
	ActualVehicle	varchar	4	Yes
	Driver	varchar	3	Yes
	Provider	varchar	4	Yes
	OdometerOn	numeric		Yes
	OdometerOff	numeric		Yes
	DateTripRequest	datetime		Yes
	TimeTripRequest	varchar	5	Yes
	UserTripRequest	varchar	30	Yes
	DefaultPickupTime	varchar	5	Yes
	DefaultDropTime	varchar	5	Yes
	DispatchTime	varchar	5	Yes
	CalculatedMiles	numeric		Yes
	Timestamp	datetime		Yes
	DestinationID	numeric		Yes
	DestinationSource	varchar	1	Yes
	PickupLocationID	numeric		Yes
	PickupLocationSource	varchar	1	Yes
	ScheduleRecordID	numeric		Yes
	LastUpdate	datetime		Yes
	LastUpTime	varchar	5	Yes
	LastUpUser	varchar	30	Yes
	Note	varchar	100	Yes
	BillNote	varchar	100	Yes
	Renew	bit		Yes
	StatusReason	varchar	50	Yes

Index Name	Index Description	Index Keys
PK_TripTransactions	clustered, unique, primary key located on PRIMARY	ID
U_TransactionNumberTripdate	nonclustered, unique located on PRIMARY	TransactionNumber, Tripdate