AG DAILY CYLINDER HISTORY Table
View exposing historical Airgas cylinder inventory and activity data used for trend analysis and historical reporting of cylinder usage across MIT locations.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ACCOUNT |
Account as provided by the source. |
VARCHAR2 |
75 |
AIM_ORDER_NUMBER |
Aim order number as provided by the source. |
VARCHAR2 |
75 |
BARCODE_NUMBER |
Barcode number as provided by the source. |
VARCHAR2 |
300 |
BASE_UNIT_OF_MEASURE |
Base unit of measure as provided by the source. |
VARCHAR2 |
75 |
CONTAINER_QUANTITY_UOM_CODE |
Code identifying container quantity uom. |
VARCHAR2 |
75 |
COST_COLLECTOR_KEY |
Surrogate key identifying the cost collector. |
VARCHAR2 |
75 |
CYLINDER_SERIAL |
Cylinder serial as provided by the source. |
VARCHAR2 |
300 |
DAYS_ON_SITE |
Days on site as provided by the source. |
NUMBER |
|
DELIVERY_LOCATION |
Delivery location as provided by the source. |
VARCHAR2 |
300 |
DELIVERY_LOCATION_ACCOUNT |
Delivery location account as provided by the source. |
VARCHAR2 |
75 |
DELIVERY_NAME |
Delivery name as provided by the source. |
VARCHAR2 |
75 |
MATERIAL_DESCRIPTION |
Description of material. |
VARCHAR2 |
1200 |
MATERIAL_PART_NUMBER |
Material part number as provided by the source. |
VARCHAR2 |
300 |
PROCESS_DATE |
Date associated with process. |
DATE |
|
PURCHASE_ORDER_NUMBER |
Purchase order number as provided by the source. |
VARCHAR2 |
300 |
SAP_ACCOUNT_NUMBER |
Sap account number as provided by the source. |
VARCHAR2 |
300 |
SAP_SALES_ORDER_NUMBER |
Sap sales order number as provided by the source. |
VARCHAR2 |
300 |
SHIP_DATE |
Date associated with ship. |
DATE |
|
SOURCE |
Source as provided by the source. |
VARCHAR2 |
14 |
UN_NUMBER |
Un number as provided by the source. |
VARCHAR2 |
300 |
VOLUME |
Volume as provided by the source. |
VARCHAR2 |
300 |
VOLUME_UNIT |
Volume unit as provided by the source. |
VARCHAR2 |
75 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |