AG BILLING DETAIL Table
View exposing Airgas billing detail records including charges, invoice attributes, and service information associated with cylinder deliveries and related Airgas services used by MIT organizational units.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
BARCODE_NUMBER |
Barcode number as provided by the source. |
VARCHAR2 |
75 |
BILLED_FROM_DATE |
Date associated with billed from. |
DATE |
|
BILLED_TO_DATE |
Date associated with billed to. |
DATE |
|
BILLING_DATE |
Date associated with billing. |
DATE |
|
CONTAINER_UOM_CODE |
Code identifying container uom. |
VARCHAR2 |
75 |
COST_COLLECTOR_KEY |
Surrogate key identifying the cost collector. |
VARCHAR2 |
12 |
CUSTOMER_PART_NUMBER |
Customer part number as provided by the source. |
VARCHAR2 |
75 |
CYLINDER_SERIAL |
Cylinder serial as provided by the source. |
VARCHAR2 |
75 |
DELIVERY_DOC_NUMBER |
Delivery doc number as provided by the source. |
VARCHAR2 |
75 |
DELIVERY_LOCATION |
Delivery location as provided by the source. |
VARCHAR2 |
75 |
INVOICE_NUMBER |
Invoice number as provided by the source. |
VARCHAR2 |
75 |
MATERIAL_DESCRIPTION |
Description of material. |
VARCHAR2 |
300 |
MONTHLY_RATE |
Monthly rate 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 |
|
SUPPLIER |
Supplier as provided by the source. |
VARCHAR2 |
75 |
SUPPLIER_PART_NUMBER |
Supplier part number as provided by the source. |
VARCHAR2 |
75 |
TIME_MONTH_KEY |
Surrogate key identifying the time month. |
VARCHAR2 |
6 |
VOLUME |
Volume as provided by the source. |
NUMBER |
10,2 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |