Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse NIMBUD CARRY FORWARDS Table


XXX


Field Name

Description

Data Type

Length

CREATED_BY_USER

XXX

VARCHAR2

8

CREATED_DATE

XXX

DATE

FISCAL_YEAR

The 4 digit year. The fiscal year at MIT runs from July 1st through June 30th. (e.g.: June 30, 1997 would be fiscal year 1997, July 1, 1997 would be fiscal year 1998)

NUMBER

GL_ACCOUNT_KEY

Key used to join the GL_ACCOUNT 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

10

MODIFIED_BY_USER

XXX

VARCHAR2

8

MODIFIED_DATE

XXX

DATE

NIMBUD_CF_BASE

XXX

NUMBER

12,2

NIMBUD_CF_COMMENT

XXX

VARCHAR2

2000

NIMBUD_CF_DRAFT

XXX

NUMBER

12,2

NIMBUD_CF_NON_BASE

XXX

NUMBER

12,2

NIMBUD_CF_RULE_CODE

XXX

VARCHAR2

1

NIMBUD_CF_STATUS_CODE

XXX

VARCHAR2

1

NIMBUD_CF_TRANS_TYPE

XXX

VARCHAR2

1

NIMBUD_CF_TYPE

XXX

VARCHAR2

1

NIMBUD_COST_COLLECTOR_ID

XXX

VARCHAR2

10

NIMBUD_DOCUMENT_NUMBER

XXX

NUMBER

REQUESTED_BY_USER

XXX

VARCHAR2

8