RFP PARKED DATA Table
XXX
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ACTION |
XXX |
VARCHAR2 |
35 |
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 |
CLIENT |
XXX |
VARCHAR2 |
3 |
COMPANY_CODE |
Shows to which "company" in SAP a cost collector is attached. MIT uses separate "companies" in SAP to differentiate financial transactions for different legal entities with differing business rules or reporting requirements. There are currently three company codes, "CUR" for main campus, "TECR" for MIT's alumni magazine, Technology Review, and "LCP1" for Lincoln Laboratory. |
VARCHAR2 |
4 |
COST_CENTER |
XXX |
VARCHAR2 |
10 |
CO_STATUS |
XXX |
VARCHAR2 |
10 |
DATE_CREATED |
XXX |
VARCHAR2 |
8 |
DATE_LAST_ACTION |
XXX |
VARCHAR2 |
8 |
DESCRIPTION |
the description |
VARCHAR2 |
40 |
DOC_NUMBER |
XXX |
VARCHAR2 |
10 |
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) |
VARCHAR2 |
4 |
FUND |
XXX |
VARCHAR2 |
10 |
FUNDS_CENTER |
Source of revenue. |
VARCHAR2 |
16 |
ORDER_NUMBER |
Order number from Acquisitions order record (Z30-ORDER-NUMBER) |
VARCHAR2 |
12 |
PAYEE |
XXX |
VARCHAR2 |
35 |
PROFIT_CENTER |
XXX |
VARCHAR2 |
10 |
RECEIVER |
XXX |
VARCHAR2 |
12 |
SENDER |
XXX |
VARCHAR2 |
12 |
SEQ_NO |
XXX |
NUMBER |
|
TIME_SENT |
XXX |
VARCHAR2 |
6 |