OData Status ID Definition

Modified on Wed, 29 Jan at 2:53 PM

Statuses for Driverworkhistory:

0 = on duty

1 = away

2 = off duty

Statuses for Order table

0 = received or dispatched but not yet accepted by driver

1 = assigned (accepted by driver)

2 = picked up

4 = delivered

91 = cancelled

Order Types

0 = Standard (normal order)
1 = MultiSegment (Multisegment/parent order)
2 = Segment (child of multisegment order)

Statuses for Transactions table

100 = Open

101 = Partially Paid

102 = Paid

200 = Unapplied

201 = Partially Applied

202 = Closed

400 = Open

401 = Partially Applied

402 = Paid

500 = Unapplied

501 = Partially Applied

502 = Closed

999 = Cancelled

Types for Transactions table

0 = Invoice

1 = Payment

2 = Adjustment

3 = Debit Note

4 = Credit Note

Tracked Items Log

0 = Checkpoint

1 = PickedUp

2 = Delivered

Invoice Table

0 = Paid on Account

1 = Paid by Credit Card

2 = Open by Account

3 = Settled (Basic Billing, NOT Transactions)

4 = Cancelled

5 = Cancelled (Basic Billing, NOT Transactions)