Data Warehouse

ADVANCE_BILLING_FLAG

XXX

VARCHAR2

1

BILLED_THRU_DATE

XXX

DATE

8

BILLING_PERIOD_RULE

XXX

VARCHAR2

60

BILLING_PERIOD_RULE_CODE

XXX

VARCHAR2

2

BILLING_PLAN_END_DATE

XXX

DATE

8

BILLING_PLAN_KEY

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

VARCHAR2

10

BILLING_PLAN_START_DATE

XXX

DATE

8

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

CONTRACT_AMOUNT

XXX

NUMBER

22

CONTRACT_CANCELATION_REASON

XXX

VARCHAR2

40

CONTRACT_CANCEL_REASON_CODE

XXX

VARCHAR2

2

CONTRACT_CREATE_DATE

XXX

DATE

8

CONTRACT_CREATE_USER

XXX

VARCHAR2

12

CONTRACT_END_DATE

XXX

DATE

8

CONTRACT_START_DATE

XXX

DATE

8

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

CUMULATIVE_AMOUNT_BILLED

XXX

NUMBER

17.2

CURRENCY_KEY

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

VARCHAR2

3

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

35

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

35

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

35

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

35

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

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

LAST_BILLING_DATE

XXX

DATE

8

LINE_ITEM_AMOUNT

XXX

NUMBER

22

LINE_ITEM_CATEGORY

XXX

VARCHAR2

4

LINE_ITEM_ENTRY_DATE

XXX

DATE

8

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

50

MIT_AWARD_NUMBER

A unique 10 digit number assigned to an award by MIT (OSP).

VARCHAR2

10

PROJECT_WBS_ID

Project work breakdown structure element identifier.

VARCHAR2

7

PURCHASE_ORDER_DATE

XXX

DATE

8

PURCHASE_ORDER_NUMBER

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

VARCHAR2

10

REFERENCE_NUMBER

XXX

VARCHAR2

16

SALES_CONTRACT_LINE_ITEM

XXX

NUMBER

22

SALES_CONTRACT_NUMBER

XXX

VARCHAR2

10

SALES_CONTRACT_TITLE

XXX

VARCHAR2

40

WAREHOUSE_LOAD_DATE

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

DATE

8