AG BILLING DETAIL Table
XXX
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
BARCODE_NUMBER |
XXX |
VARCHAR2 |
75 |
BILLED_FROM_DATE |
XXX |
DATE |
|
BILLED_TO_DATE |
XXX |
DATE |
|
BILLING_DATE |
Date telephone charges are billed to a cost collector. |
DATE |
|
CONTAINER_UOM_CODE |
XXX |
VARCHAR2 |
75 |
COST_COLLECTOR_KEY |
Key used to join the Cost Collector to the financial transaction, and to get the master data that were current at the time of the transaction. This field should only be used for joining data, NOT for reporting. |
VARCHAR2 |
12 |
CUSTOMER_PART_NUMBER |
XXX |
VARCHAR2 |
75 |
CYLINDER_SERIAL |
XXX |
VARCHAR2 |
75 |
DELIVERY_DOC_NUMBER |
XXX |
VARCHAR2 |
75 |
DELIVERY_LOCATION |
XXX |
VARCHAR2 |
75 |
INVOICE_NUMBER |
Invoice number. |
VARCHAR2 |
75 |
MATERIAL_DESCRIPTION |
XXX |
VARCHAR2 |
300 |
MONTHLY_RATE |
XXX |
VARCHAR2 |
75 |
PROCESS_DATE |
XXX |
DATE |
|
PURCHASE_ORDER_NUMBER |
Identifies the purchase order. In SAP this is the Document Number for a Purchasing Document. |
VARCHAR2 |
75 |
SAP_ACCOUNT_NUMBER |
XXX |
VARCHAR2 |
75 |
SAP_SALES_ORDER_NUMBER |
XXX |
VARCHAR2 |
75 |
SHIP_DATE |
XXX |
DATE |
|
SUPPLIER |
XXX |
VARCHAR2 |
75 |
SUPPLIER_PART_NUMBER |
XXX |
VARCHAR2 |
75 |
TIME_MONTH_KEY |
Key used only for joining the TIME_MONTH table to other tables, NOT for reporting. |
VARCHAR2 |
6 |
VOLUME |
XXX |
NUMBER |
10,2 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |