Data Warehouse

ACCRUAL_PERIOD

XXX

NUMBER

2

ADVANCE_BILLING_FLAG

XXX

VARCHAR2

1

AMOUNT

The total actual dollar amount charged for the fiscal period or periods selected. In GRADUATE AWARDS, this field contains the graduate award (RA, TA, etc.) amount.

NUMBER

13,2

BILLING_BLOCK

XXX

VARCHAR2

2

BILLING_DATE

Date telephone charges are billed to a cost collector.

VARCHAR2

8

BILLING_PERIOD_RULE

XXX

VARCHAR2

60

BILLING_PERIOD_RULE_CODE

XXX

VARCHAR2

2

BILLING_PLAN_TYPE

XXX

VARCHAR2

30

BILLING_PLAN_TYPE_CODE

XXX

VARCHAR2

2

BILLING_SPECIAL_HANDLING

XXX

VARCHAR2

30

BILL_SPECIAL_HANDLING_CODE

XXX

VARCHAR2

4

CONDITION_CODE

XXX

VARCHAR2

4

CONDITION_COUNTER

XXX

VARCHAR2

3

CONDITION_STEP

XXX

VARCHAR2

3

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

CURRENCY_KEY

Key used to join to the LIBRARY_CURRENCY table. This field should only be used for joining data, NOT for reporting.

VARCHAR2

5

CUSTOMER_BILL_TO_CITY

XXX

VARCHAR2

35

CUSTOMER_BILL_TO_COUNTRY

XXX

VARCHAR2

15

CUSTOMER_BILL_TO_KEY

XXX

VARCHAR2

11

CUSTOMER_BILL_TO_NAME

XXX

VARCHAR2

50

CUSTOMER_BILL_TO_NUMBER

XXX

VARCHAR2

10

CUSTOMER_BILL_TO_PHONE

XXX

VARCHAR2

16

CUSTOMER_BILL_TO_STATE

XXX

VARCHAR2

3

CUSTOMER_BILL_TO_STREET

XXX

VARCHAR2

35

CUSTOMER_BILL_TO_ZIP

XXX

VARCHAR2

10

CUSTOMER_PAYER_CITY

XXX

VARCHAR2

35

CUSTOMER_PAYER_COUNTRY

XXX

VARCHAR2

15

CUSTOMER_PAYER_KEY

XXX

VARCHAR2

11

CUSTOMER_PAYER_NAME

XXX

VARCHAR2

50

CUSTOMER_PAYER_NUMBER

XXX

VARCHAR2

10

CUSTOMER_PAYER_PHONE

XXX

VARCHAR2

16

CUSTOMER_PAYER_STATE

XXX

VARCHAR2

3

CUSTOMER_PAYER_STREET

XXX

VARCHAR2

35

CUSTOMER_PAYER_ZIP

XXX

VARCHAR2

10

CUSTOMER_SHIP_TO_CITY

XXX

VARCHAR2

35

CUSTOMER_SHIP_TO_COUNTRY

XXX

VARCHAR2

15

CUSTOMER_SHIP_TO_KEY

XXX

VARCHAR2

11

CUSTOMER_SHIP_TO_NAME

XXX

VARCHAR2

50

CUSTOMER_SHIP_TO_NUMBER

XXX

VARCHAR2

10

CUSTOMER_SHIP_TO_PHONE

XXX

VARCHAR2

16

CUSTOMER_SHIP_TO_STATE

XXX

VARCHAR2

3

CUSTOMER_SHIP_TO_STREET

XXX

VARCHAR2

35

CUSTOMER_SHIP_TO_ZIP

XXX

VARCHAR2

10

CUSTOMER_SOLD_TO_CITY

XXX

VARCHAR2

35

CUSTOMER_SOLD_TO_COUNTRY

XXX

VARCHAR2

15

CUSTOMER_SOLD_TO_KEY

XXX

VARCHAR2

11

CUSTOMER_SOLD_TO_NAME

XXX

VARCHAR2

50

CUSTOMER_SOLD_TO_NUMBER

XXX

VARCHAR2

10

CUSTOMER_SOLD_TO_PHONE

XXX

VARCHAR2

16

CUSTOMER_SOLD_TO_STATE

XXX

VARCHAR2

3

CUSTOMER_SOLD_TO_STREET

XXX

VARCHAR2

35

CUSTOMER_SOLD_TO_ZIP

XXX

VARCHAR2

10

DELIVERY_BLOCK

XXX

VARCHAR2

2

DEVIATING_BILL_DATE_RULE

XXX

VARCHAR2

60

DEVIATING_BILL_DATE_RULE_CODE

XXX

VARCHAR2

2

DOCUMENT_CATEGORY

XXX

VARCHAR2

1

DOCUMENT_CATEGORY_DESC

XXX

VARCHAR2

10

DOCUMENT_TYPE

XXX

VARCHAR2

4

INVOICE_PRINTING

XXX

VARCHAR2

30

INVOICE_PRINTING_CODE

XXX

VARCHAR2

4

ITEM_BILLING_BLOCK_STATUS

XXX

VARCHAR2

1

ITEM_DELIVERY_BLOCK_STATUS

XXX

VARCHAR2

1

ITEM_REJECTION_STATUS

XXX

VARCHAR2

1

ITEM_REJECTION_STAT_DESC

XXX

VARCHAR2

45

LINE_ITEM_AMOUNT

XXX

NUMBER

15,2

LINE_ITEM_CATEGORY

XXX

VARCHAR2

4

LINE_ITEM_ENTRY_DATE

XXX

DATE

LINE_ITEM_ENTRY_USER

XXX

VARCHAR2

12

LINE_ITEM_REJECTION_REASON

XXX

VARCHAR2

40

LINE_ITEM_REJECT_REASON_CODE

XXX

VARCHAR2

2

LINE_ITEM_TEXT

The short description of the line item. Also appears on the SAP DTR for the cost collector associated with this financial detail.

VARCHAR2

40

MATERIAL_ENTERED

XXX

VARCHAR2

18

MATERIAL_KEY

XXX

VARCHAR2

18

PRICING_ELEMENT_KEY

Key field used to join to the PRICING_ELEMENT table. This field should only be used for joining data, NOT for reporting

VARCHAR2

10

PROJECT_WBS_ID

Project work breakdown structure element identifier.

VARCHAR2

7

PURCHASE_ORDER_DATE

XXX

DATE

PURCHASE_ORDER_NUMBER

Identifies the purchase order. In SAP this is the Document Number for a Purchasing Document.

VARCHAR2

35

REQUESTED_DELIVERY_DATE

XXX

DATE

SALES_ORDER_AMOUNT

XXX

NUMBER

15,2

SALES_ORDER_CREATE_DATE

XXX

DATE

SALES_ORDER_CREATE_USER

XXX

VARCHAR2

12

SALES_ORDER_END_DATE

XXX

DATE

SALES_ORDER_LINE_ITEM

XXX

NUMBER

6

SALES_ORDER_NUMBER

XXX

VARCHAR2

10

SALES_ORDER_ORGANIZATION

XXX

VARCHAR2

10

SALES_ORDER_PARTNER_KEY

Key field used to join to the SALES_ORDER_PARTNER table. This field should only be used for joining data, NOT for reporting

VARCHAR2

20

SALES_ORDER_START_DATE

XXX

DATE

WAREHOUSE_CURRENT_TIMESTAMP

XXX

DATE

WAREHOUSE_LOAD_DATE

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

DATE