ORDER_DISP_INFO_4

Description: |
This table contains dispense information for orders.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
ORDER_MED_ID | 1 |
CONTACT_DATE_REAL | 2 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | ORDER_MED_ID | NUMERIC | No |
The unique identifier (.1 item) for the order record.
2 | CONTACT_DATE_REAL | FLOAT | No |
A unique contact date in decimal format. The integer portion of the number indicates the date of contact. The digits after the decimal distinguish different contacts on the same date and are unique for each contact on that date. For example, .00 is the first/only contact, .01 is the second contact, etc.
3 | CONTACT_DATE | DATETIME | No |
The date of this contact in calendar format.
4 | RX_DROPSHIP_QUANTITY | INTEGER | No |
Specifies the quantity of the requested product from the drop shipping vendor.
5 | RX_DROPSHIP_QUANTITY_UNIT_C_NAME | VARCHAR | No |
Specifies the external unit of measure used when requesting products from the drop shipment vendor.
May contain organization-specific values: No
Category Entries:
Each
Bag
Bottle
Case
Can
Carton
Dozen
Gallon
Kit
Pad
Package
Pair
Roll
Sleeve
Set
Tube
Tray
Vial
Assortment
Bale
Book
Barrel
Container
Coil
Drum
Display
Eleven-pack
Gross
Hundred Count
Keg
Two-pack
Three-pack
Four-pack
Five-pack
Six-pack
Seven-pack
Eight-pack
Nine-pack
Piece
Pallet (Lift)
Slip Sheet
Shipment
Tote
Thousand
Tank
Unit
Pouch
Box
Skid
Shares
Half Gallon
Hundred Weight (Short)
Capsule
Double-time Hours
Fahrenheit
Centigram
Ten
Each per Month
Hundred Square Feet
Pounds per Inch of Length
Mega Joule per Kilogram
Wine Gallon
Joule Per Kilogram
Fifty Square Feet
Square Millimeter
Work Days
Minim
Ball
Joule per Gram
Telecommunications Lines in Service - Average
Inches Per Second Per Second (Acceleration)
Pound
Thousand Cubic Meters
Portion
Thousand pounds gross
Batting Pound
Number of Lines
Cartridge Needle
Horsepower
Ampere Turn Per Centimeter
British Thermal Unit (BTU)
Mesh
Grams per Square Centimeter
Parts Per Million
Volt
Feet, Inches and Fraction
Ten Square Feet
Bushel, Dry Imperial
Coil Group
Micromolar
Gallons per Thousand
Percent Topical Only
100 Board Feet
Million Units
Total Car Mile
Cake
Pounds per Gallon
Thousand Cubic Feet Per Day
Telecommunications Ports
40 Foot Container
Leaf
Standard Advertising Units (SAUs)
Kilograms Per Kilogram of Product
Cap
Milliliters of Water
Counts per Inch
Bucket
Inhalation
Car Count
Pack (PAK)
Unitless
Quart, Imperial
Nautical Mile
Million British Thermal Units per One Thousand Cubic Feet
Picofarad
Volt-ampere per Kilogram
Centipoise (CPS)
Coulomb
Pump
Lifetime
Volts Per Meter
Frames
Billboard
Newton-Meter
Pascal
Micrometer
Parts
Net Kilograms
Centimeter
Deciliter
Tablet
Micro Mho
Statute Mile
Milliliters per Kilogram
Data Records
Metric Long Ton
1000 Pounds per Square Inch
Deci Newton-Meter
Fibers
Kilograms/Millimeter Width
Kilocurie
Thousand Linear Yards
Person
Therms
25 Kilogram Bulk Bag
Seismic Level
Net Gallons
Draize Score
Million Cubic Feet
Weight per Square Inch
115 Kilogram Drum
Syringe
Gauss
Miles
Wet Pound
Job
Actual Tons
Truckload
Number of Mults
Test Specific Scale
Seismic Line
10 Kilogram Drum
Angstrom
Reel
Tablespoon
Inches, Decimal-Minimum
Impressions
Feet, Inches and Decimal
Slice
Deciliter per Gram
Pennyweight
100 Pound Drum
Board
Pounds, Decimal - Pounds per Square Foot - Pound Gage
55 Gallon Drum
Bulk Pack
British Thermal Units (BTUs) per Pound
Pounds per Ream
Millibar
Assembly
SITAs
Milligrams Per Hour
Microfarad
Decigram
MOL
Board Feet
Thousand Cubic Feet
Degree
Liters Per Minute
Pounds Equivalent
Cassette
Actual Tonnes
Teaspoon
Bytes
Additional Minutes
Sack
Mass Pounds
Hundred Pounds (CWT)
Shot
Revenue Ton Miles
Millimeter
Volts (Direct Current)
Milliamperes
Percent
Microliter
Equivalent Gallons
Kilosegments
Ten Square Yards
Cubic Meter
Count per Minute
Peck, Dry U.S.
Ream
Volt-Ampere Per Pound
Parts Per Thousand
Five Hundred
Cubic Feet Per Hour
Quart
Beam
Head
20000 Gallon Tankcar
Carset
Kilopascals per Millimeter
Watts Per Pound
Miles Per Hour
Dry Ton
Years
Thousand Linear Inches
Kilogram Per Square Centimeter
Season
Link
10000 Gallon Tankcar
Fuel Usage (Gallons)
Metric
Calendar Days
Gross Yard
Linear Foot
Milligrams per Square Meter
Carload
Square Centimeter
Hydraulic Horse Power
Base Box
Lozenge
Joules
Hundred Feet - Linear
Farad
Directory Books
Suppository
Lug
Magnetic Tapes
Powder-Filled Vials
Seconds
Billions of Dollars
Peaks per Inch (PPI)
Bun
Wheel
Millivolts
Grams per Milliliter
Volts (Alternating Current)
Skein
Bundle
Pounds per 1000 Square Feet
Theoretical Pounds
Milligram
Locations
Train Mile
Hectometer
Calls
Trimester
Kilograms per Square Meter
Megagram
Hank
Megabecquerel
Linear Yard
Inches, Fraction-Nominal
Grams per Kilogram
Meter
Pint U.S. Dry
U.S. Gallons Per Minute
Megajoule/Cubic Meter
Thousand Sheets
Pages per Inch
Twenty
Tenth Hours
Ration
Theoretical Tons
Becquerel
Monetary Value
Square Foot
Access Lines
Thousand Square Inches
Pica
Inches, Decimal--Actual
Ocular Insert System
Hundred
Loaf
Feet Per Second
Manmonth
Pounds-Percentage
Cord
Kilowatt Demand
Kilovolt Amperes Reactive Hour
Rack
Thousand Feet (Board)
Storage Units
Transactions
Thousand Kilograms
Strip
Liter
1000 Meters
Millequivalence Caustic Potash per Gram of Product
Siemens
Lot
Fibers per Cubic Centimeter of Air
Dosage Form
Ounce Foot
1000 Cubic Feet
Stokes
Ohm
Session
Kilopascal
Newton
Kilo Pounds Per Square Inch (KSI)
Thousand Feet
Flat
Pint
Feet and Decimal
Cycles
100 Lineal Yards
Kilograms per Millimeter Squared (KG/MM2)
Kilogauss
Twenty-Five
Horsepower Days per Air Dry Metric Tons
Project
Megagrams Per Hour
Locomotive Count
Kilogram
Pallet/Unit Load
Average Minutes Per Call
Caboose Mile
Square Feet per Second
Flake Ton
Pounds per Inch of Width
Milli-inch
Half Dozen
Decibels
Carat
Kilograms per Square Meter, Kilograms, Decimal
Machine/Unit
Millimeter-Average
Liquid Pounds
Milligrams per Cubic Meter
Joint
Fifty Count
Pounds Per Piece of Product
Hundred Boxes
Barrel, Imperial
Liters Per Day
Basis Points
Aluminum Pounds Only
Bunch
Calorie
Section
Roll-Metric Measure
Pounds per Sq. Ft.
Chest
Metric Net Ton
Price Per Share
British Thermal Units (BTUs) per Cubic Foot
Mho
Half Hour
Pitch
Radian
Acre
Short Ton
Credits
Transdermal Patch
Microgram
International Unit
Inches of Water
Catchweight
Grams per Sq. Meter
Millicurie
Fixed Rate
Kilobecquerel
Amperes per Meter
Electronic Mail Boxes
Thousand Kilowatt Hours
Pages - Hardcopy
Square Meters per Second
Program
Chains (Land Survey)
Cup
Length
Half Pint
Jug
Kilovolt Amperes Reactive Demand
Pages - Electronic
Cubic Feet
Percent Volume
Dry Pounds
Inches Per Second (Vibration Velocity)
Cubic Meters (Net)
Meal
Working Months
Pounds Per Square Inch Absolute
Square Rod
Milliliters per Square Centimeter Second
Thousand Casings
Roentgen
Equivalent
Thousand Gallons
Mega Pascals
Milliliter
Pounds Per Square Inch Gauge
Load
Newspaper Agate Line
Megajoule
Shelf Package
Knots
Tenth Cubic Foot
Barrels per Minute
Joule Per Kelvin
Dozen Pair
Digits
Bobbin
100 Kilograms
Square Kilometer
Kilograms per Millimeter
Number of Screens
Revolutions Per Minute
Kilometers Per Hour
Small Spray
Cone
Kelvin
Grams per 100 Grams
Card
Hundred Weight (Long)
Square Yard
Theoretical Tonnes
Total Car Count
Split Tanktruck
Pounds per Cubic Foot
Solid Pounds
Kilograms Per Liter of Product
Ounces per Square Foot
Net Barrels
Car Mile
Brush
Ampere
Drop
Hundredth of a Carat
Semester
Half Liter
Overtime Hours
Dynes per Centimeter
Photographs
Hundred Kilograms
Quarter Mile
Disk (Disc)
Trailer
Track Foot
Microcurie
Crate
Kilopascal Square Meters per Gram
Hundred Cubic Meters
Cubic Yard
Basket
Ring
Curie
Band
Pounds Per Hour
Employees
Kilobyte
Clove
Billet
Failure Rate In Time
Poise
Run
Bulk Car Load
Pen Calories
Net Imperial Gallons
Application
Square Meter
Segment
Envelope
Kilopackets
Tub
Ampere-turn
Meters Per Minute
300 Kilogram Bulk Bag
Empty Car
Imperial Gallons
Jumbo
Square Decimeter
Quarter (Time)
Kilograms per Cubic Meter
Tank Car
Milligrams Per Square Inch
Quart, Dry U.S.
Microns (Micrometers)
Foot Pounds
Milligrams per Kilogram
Cartridge
Biweekly
Deal
Peck, Dry Imperial
Mat
20-Pack
Dollars per Hours
Linear Centimeter
Hours
Outfit
Thousands of Dollars
Pint, Imperial
Yard
Pen Grams (Protein)
Caboose Count
Days
Lifts
Hundred Yards
Centimeters Per Second
Message Hours
Milli Pascals
Bar
Volt-ampere-reactive
Fluid Ounce
Column-Inches
Centiliter
Minutes or Messages
Linear Inch
Inches Per Second (Linear Speed)
Quire
Resets
Hectare
Task
Inches Per Second Per Second (Vibration Acceleration)
20 Foot Container
Dyne per Square Centimeter
Semiannual
Conference Points
Troy Ounce
Gigabecquerel
Milliliter per Second
Cylinder
Stage
Gram
Ton Per Hour
Square
Milliliter per Minute
Twenty-Four
Hertz
Base Weight
Theoretical Kilograms
Hogshead
Half Pages - Electronic
Hundred Sheets
Kilowatt
Sandwich
Kilograms per Air Dry Metric Tons
Bushel
Grain
Actual Pounds
Net Ton (2,000 LB).
Millimeters of Mercury
Messages
Cubic Centimeters Per Second
Cover
Mixed
Super Bulk Bag
Base Box per Pound
Kiloliter Per Hour
Pages - Facsimile
Round
Radians Per Second
Thirty-Six
Packet
Bunks
Cubic Meter Per Hour
Thousand Bags
Parts Per Billion
Channel
Watt
Kilowatt Hour
Gallons Per Thousand Cubic Feet
Cubic Feet Per Minute
Saybolt Universal Second
Microfiche Sheet
Millions of Dollars
Bimonthly
Radians Per Second Squared
Wet Ton
Sessions
Rod (area) - 16.25 Square Yards
Metric Gross Ton
Square Mile
Rod (length) - 5.5 Yards
Centistokes
Ampoule
Kilograms/Meter
Linear Yards Per Pound
Cost
Dispenser
Roentgen Equivalent in Man (REM)
Kilograms Per Piece of Product
Newtons Per Meter
Milligram per Sq. Ft. per Side
Meters Per Second Per Second
Calories per Cubic Centimeter
Actual Kilograms
Millimeter H20
Thousand Square Feet
Gross Kilogram
Ten-pack
Dram
Brake horse power
Million Particles per Cubic Foot
Long Ton
Strand
Week
Milliroentgen
Inch
Plate
Thousand Sq. Centimeters
Inch Pound
Kilocharacters
Dollars, U.S.
Counts per Centimeter
Foot
Tank Truck
Dyne
Sheet-Metric Measure
Lite
Inches, Fraction--Actual
Kilograms Decimal
Connector
Decagram
Linear Meter
Heart
Gigajoules
Percent Per 1000 Hours
Pounds per Foot
Belt
Inches, Decimal--Nominal
Ten Thousand Yards
Thousand Linear Meters
Usage per Telecommunications Line - Average
Hundred Troy Ounces
100-Pack
British Thermal Units (BTUs) Per Hour
Meters Per Second
Carboy
Fathom
Decimeter
Anti-hemophilic Factor (AHF) Units
Combo
500 Kilogram Bulk Bag
Tenth Minutes
Pounds Per Air-Dry Metric Ton
Lift Van
Torr
Lump Sum
Metric Ton Kilograms
Electron Volt
Troy Pound
Gross Barrels
Batch
Cubic Centimeter
Labor Hours
Sixty-fourths of an Inch
Net Liters
Thousand Pieces
Train
Page
Henry
Wet Kilo
Feet Per Minute
Layer(s)
Pounds Gross
Bin
Wrap
Million BTU's
Quarter Hours
Car
Gill (Imperial)
Panel
Kilometers
Thousand Feet (Linear)
MMSCF/Day
Barge
Heat Lots
Running or Operating Hours
Standard Cubic Foot
Pounds Per Cubic Inch
Jar
Gallons/Day
Treatments
Insurance Policy
Months
Spool
Cubic Decimeter
Troche
Millimeter-minimum
Large Spray
Ounces per Square Yard
Thousand Impressions
Sizing Factor
Percent Weight
Pail
Telecommunications Lines in Service
Atmosphere
Duty
Inches, Fraction--Average
Kiloroentgen
Megabyte
Cubic Feet per Minute per Square Foot
Gage Systems
Grams per Liter
50 Pound Bag
Wafer
Hectogram
Micro Inch
Count
Ounce - Av
Minutes
Vehicle
Thousandths of an Inch
Curl Units
Grams per Cubic Centimeter
Square Inch
15 Kilogram Drum
Megahertz
Composite Product Pounds (Total Weight)
Millimeter-Nominal
Gauss per Oersteds
Cop
Fifty
Quarter Kilogram
Tire
Hundred Feet
Milligrams per Liter
Great Gross (Dozen Gross)
Pounds per Sq. Inch
Bulk
Pair Inches
Hectoliter
Oersteds
Stick
Millimeter-Actual
Watts per Kilogram
Cask
Ton Miles
Fields
Cell
Milliequivalent
Inhaler
Kilovolt Amperes Reactive
Bolt
Pounds Net
Micrograms per Cubic Meter
Calories per Gram
Dram (Minim)
Block
Fluid Ounce (Imperial)
Quarter Dozen
Visit
Ten Yards
Print Point
Grams per 100 Centimeters
Barrels per Day
Two Hundred Fifty
Kilovolt Amperes
Gross Gallons
Air Dry Metric Ton
Batt
Inches, Decimal--Average
Metric Ton
Locomotive Mile
Group
English, (Feet, Inches)
Cubic Inches
Inches per Minute
Pounds Per Pound of Product
Ounces per Square Foot per 0.01 Inch
Sheet
Kiloliter
Inches, Fraction--Minimum
Imperial Gallons Per Minute
Pounds per Thousand
Ream-Metric Measure
Ounce Inch
Hundred Cubic Feet
Centigrade, Celsius
Gross Ton
Mutually Defined
6 | RX_DROPSHIP_PACKAGE_COUNT | INTEGER | No |
Represents the number of packages that comprise one request unit (I ORD 48631-RX Drop Shipment Unit) from the drop shipment vendor. For example, if the unit of measure is “Package” and the value is 3, then one “Package” consists of three individual packages.
7 | RX_DROP_SHIP_NEEDS_REVIEW_YN | VARCHAR | No |
Stores whether the drop shipment order request requires review based on electronic messages from the drop shipper.
May contain organization-specific values: No
Category Entries:
No
Yes
8 | RX_DROP_SHIP_QTY_ORIG | INTEGER | No |
Stores the quantity of the originally requested product from the drop shipping vendor when the quantity to be shipped is changed externally.
9 | RX_DROP_SHIP_QTY_ORIG_UNIT_C_NAME | NUMERIC | No |
Stores the external unit of measure for the originally requested product from the drop shipping vendor when the quantity to be shipped is changed externally.
The category values for this column were already listed for column: RX_DROPSHIP_QUANTITY_UNIT_C_NAME
10 | RX_DROP_SHIP_PACKAGE_CNT_ORIG | INTEGER | No |
Stores the number of packages that make up one ordered unit from the drop shipment vendor, as defined in I ORD 48637 (RX Drop Shipment Unit Original).