Table: Orders
| Field | Size |
| OrderRef | INT (IDENTITY) |
| PatientRef | INT |
| RxNumber | VARCHAR(15) |
| Status | VARCHAR(1) |
| Type | VARCHAR(30) |
| EnteredDate | DATETIME |
| StartDate | DATETIME |
| StopDate | DATETIME |
| Route | VARCHAR(2) |
| Description | VARCHAR(50) |
| PhysicianOrders | TEXT |
| Instructions | TEXT |
| Comments | TEXT |
| Label | TEXT |
| Rate | SMALLINT |
| Hours | TINYINT |
| Frequency | VARCHAR(3) |
| FillStartDate | DATETIME |
| FillStopDate | DATETIME |
| OrderQuantity | SMALLINT |
| FillQuantity | SMALLINT |
| ExpirationDate | DATETIME |
| DCDate | DATETIME |
| MixDate | DATETIME |
| DeliverDate | DATETIME |
| DoctorRef | INT |
| QuantityCurrent | INT |
| QuantityAuthorized | INT |
| RefillsCurrent | SMALLINT |
| RefillsAuthorized | SMALLINT |
| EnteredByRef | INT |
| VerifiedByRef | INT |
| ClaimDate | DATETIME |
| CommonOrderGroupRef | INT |
| DiscontinuedByRef | INT |
| RefillNumber | SMALLINT |
| DAW | TINYINT |
| CommonOrder | BIT |
| PatientTherapyRef | INT |
| CatheterOrderRef | INT |
| PrescriptionOrigin | TINYINT |
| PriorAuthorizationRef | INT |
| StorageNoteRef | INT |