REQ DIST RAW Table
XXX
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ACCOUNT_ASSIGNMENT_NUMBER |
Account distribution assignment serial number. This number identifies a single account distribution for a line item. |
NUMBER |
2 |
ACCT_ASGMT_NETWORK_NUMBER |
XXX |
VARCHAR2 |
12 |
ACCT_SETTLEMENT_REF_DATE |
XXX |
DATE |
|
ASSET_MAIN_NUMBER |
XXX |
VARCHAR2 |
12 |
ASSET_SUB_NUMBER |
XXX |
VARCHAR2 |
4 |
BUSINESS_AREA |
XXX |
VARCHAR2 |
4 |
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 |
CONTROLLING_AREA |
XXX |
VARCHAR2 |
4 |
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 |
COST_OBJECT |
a seven digit number used to categorize the costs and revenues associated with a particular project or activity at MIT; The terms cost object and cost collector are used interchangeably. |
VARCHAR2 |
12 |
CREATED_BY |
User account or user name of the person who created the record. |
VARCHAR2 |
12 |
DELETION_INDICATOR |
XXX |
VARCHAR2 |
1 |
DISTRIBUTION_AMOUNT |
XXX |
NUMBER |
16,2 |
DISTRIBUTION_PERCENTAGE |
The percentage of the line item value which has been assigned to a particular cost collector/GL account. The percentage values of the account distributions for a given PO line item will total 100. |
NUMBER |
34,17 |
FUNCTIONAL_AREA |
XXX |
VARCHAR2 |
16 |
FUND |
XXX |
VARCHAR2 |
10 |
FUND_CENTER |
XXX |
VARCHAR2 |
16 |
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 |
GOODS_RECIPIENT |
The person or group who will receive the goods. |
VARCHAR2 |
25 |
INTERNAL_COUNTER |
XXX |
VARCHAR2 |
8 |
IS_POSTING_TO_COST_CENTER |
XXX |
VARCHAR2 |
1 |
IS_POSTING_TO_ORDER |
XXX |
VARCHAR2 |
1 |
IS_POSTING_TO_PROJECT |
XXX |
VARCHAR2 |
1 |
OPERATIONS_ROUTING_NUMBER |
XXX |
VARCHAR2 |
10 |
PARTNER_ACCOUNT_NUMBER |
XXX |
VARCHAR2 |
10 |
PROFITABILITY_SEGMENT_NUMBER |
XXX |
VARCHAR2 |
10 |
PROFIT_CENTER |
XXX |
VARCHAR2 |
10 |
REAL_ESTATE_KEY |
XXX |
VARCHAR2 |
8 |
RECORD_CREATION_DATE |
XXX |
DATE |
|
RECOVERY_INDICATOR |
XXX |
VARCHAR2 |
2 |
REQUISITION_ITEM_NUMBER |
XXX |
NUMBER |
5 |
REQUISITION_NUMBER |
Purchase Requisition Document Number |
VARCHAR2 |
10 |
REQ_QUANTITY |
XXX |
NUMBER |
13,3 |
SALES_DOCUMENT_ITEM |
XXX |
NUMBER |
6 |
SALES_DOCUMENT_NUMBER |
XXX |
VARCHAR2 |
10 |
SALES_DOCUMENT_SCHEDULE_LINE |
XXX |
NUMBER |
4 |
UNLOADING_POINT |
The location to which the goods should be delivered. |
VARCHAR2 |
80 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |