Data Warehouse

ACCOUNT_DISTRIBUTION_METHOD

XXX

VARCHAR2

1

ACKNOWLEDGMENT_REQUIRED_IND

XXX

VARCHAR2

1

ADDRESS

XXX

VARCHAR2

10

CHAR6_FIELDS

XXX

VARCHAR2

24

COMMITMENT_ITEM

In SAP's FM module, expenses are classified by "commitment item", not G/L account. Each G/L account in SAP's CO module maps to a "commitment item" in the FM module. There are many fewer commitment items that G/L accounts. FM's commitment items represent a more summarized view of expense types.

VARCHAR2

14

CUSTOMER

XXX

VARCHAR2

10

DELETION_INDICATOR

XXX

VARCHAR2

1

EFFECTIVE_ITEM_VALUE

XXX

VARCHAR2

16

FINAL_INVOICE_IND

XXX

VARCHAR2

1

FUND

XXX

VARCHAR2

10

FUNDS_CENTER

Source of revenue.

VARCHAR2

16

GENERAL_CONFIG_MATERIAL

XXX

VARCHAR2

18

GOODS_RECEIPT_IND

XXX

VARCHAR2

1

GOODS_RECEIPT_NV_IND

XXX

VARCHAR2

1

GROSS_PO_VALUE

XXX

NUMBER

16,2

GR_INVOICE_VERIF_IND

XXX

VARCHAR2

1

INVOICE_RECEIPT_IND

XXX

VARCHAR2

1

IS_DELIVERY_COMPLETE

XXX

VARCHAR2

1

ITEM_CHANGE_DATE

XXX

DATE

ITEM_TEXT

XXX

VARCHAR2

200

LINE_ITEM_NUMBER

XXX

NUMBER

5

MATERIAL_CATEGORY

XXX

VARCHAR2

2

MATERIAL_GROUP

A code, usually four digit, defining a Material Group for Purchase Orders to enable reporting by Material Group categories. See also Material Group Description: this latter field gives the text name of the material group defined by the code.

VARCHAR2

9

MATERIAL_NUMBER_1

XXX

VARCHAR2

18

MATERIAL_NUMBER_2

XXX

VARCHAR2

18

MATERIAL_TYPE

XXX

VARCHAR2

4

NET_PO_VALUE

XXX

NUMBER

16,2

NET_PRICE

XXX

NUMBER

14,2

ORDER_ACKNOWLEDGMENT_NUMBER

XXX

VARCHAR2

20

ORDER_PRICE_UNIT

XXX

VARCHAR2

10

ORDER_UNIT

XXX

VARCHAR2

10

PARTIAL_INVOICE_IND

XXX

VARCHAR2

1

PLANT

The plant code associated with the PO line item.

VARCHAR2

4

PO_QUANTITY

The ordered quantity on a PO line item.

NUMBER

17,3

PRICE_DETERMINATION_DATE

XXX

DATE

PRICE_UNIT

XXX

NUMBER

5

PRICING_SUBTOTAL_1

XXX

NUMBER

18,2

PRICING_SUBTOTAL_2

XXX

NUMBER

18,2

PRINC_PURCH_AGREEMENT_ITEM

XXX

VARCHAR2

5

PRINC_PURCH_AGREEMENT_NUMBER

XXX

VARCHAR2

10

PROFIT_CENTER

XXX

VARCHAR2

10

PURCHASE_REQ_ITEM_NUMBER

XXX

NUMBER

5

PURCHASE_REQ_NUMBER

XXX

VARCHAR2

10

PURCHASING_DOCUMENT_CATEGORY

XXX

VARCHAR2

1

PURCHASING_DOCUMENT_NUMBER

XXX

VARCHAR2

10

PURCHASING_INFO_REC_NUMBER

XXX

VARCHAR2

10

REQUIREMENT_TRACKING_NUMBER

Entered on a Purchasing Requisition and copied to subsequent Purchase Orders. Enables grouping of Purchasing Documents by Material Requirement

VARCHAR2

10

STD_REL_ORDER_QUANTITY

XXX

VARCHAR2

17

TARGET_QUANTITY

XXX

NUMBER

17,3

TAX_CODE

XXX

VARCHAR2

2

TAX_CODE_PROCEDURE

XXX

VARCHAR2

6

UNIT_OF_MEASURE

XXX

VARCHAR2

3

UNIVERSAL_PRODUCT_CODE

XXX

VARCHAR2

18

VENDOR_MATERIAL_NUMBER

XXX

VARCHAR2

35

WAREHOUSE_LOAD_DATE

The date the record was loaded into the Data Warehouse from the source system.

DATE