AG DAILY CYLINDER Table
View exposing daily Airgas cylinder inventory and activity data used to track cylinder usage and location for MIT departments and facilities.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
BARCODE_NUMBER |
Barcode number as provided by the source. |
VARCHAR2 |
75 |
BASE_UNIT_OF_MEASURE |
Base unit of measure as provided by the source. |
VARCHAR2 |
75 |
COST_COLLECTOR_KEY |
Surrogate key identifying the cost collector. |
VARCHAR2 |
12 |
CYLINDER_SERIAL |
Cylinder serial as provided by the source. |
VARCHAR2 |
75 |
DAYS_ON_SITE |
Days on site as provided by the source. |
NUMBER |
20 |
DELIVERY_LOCATION |
Delivery location as provided by the source. |
VARCHAR2 |
75 |
DELIVERY_NAME |
Delivery name as provided by the source. |
VARCHAR2 |
75 |
MATERIAL_DESCRIPTION |
Description of material. |
VARCHAR2 |
300 |
MATERIAL_PART_NUMBER |
Material part number as provided by the source. |
VARCHAR2 |
75 |
PROCESS_DATE |
Date associated with process. |
DATE |
|
PURCHASE_ORDER_NUMBER |
Purchase order number as provided by the source. |
VARCHAR2 |
75 |
SAP_ACCOUNT_NUMBER |
Sap account number as provided by the source. |
VARCHAR2 |
75 |
SAP_SALES_ORDER_NUMBER |
Sap sales order number as provided by the source. |
VARCHAR2 |
75 |
SHIP_DATE |
Date associated with ship. |
DATE |
|
UN_NUMBER |
Un number as provided by the source. |
VARCHAR2 |
75 |
VOLUME |
Volume as provided by the source. |
VARCHAR2 |
75 |
VOLUME_UNIT |
Volume unit as provided by the source. |
VARCHAR2 |
75 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |