REQ DIST RAW Table
View exposing raw requisition account-distribution detail including distribution percentage and amount, cost object and sales-document attributes, controlling and profitability assignments, fund and commitment-item attributes, and settlement reference date.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ACCOUNT_ASSIGNMENT_NUMBER |
Account assignment number associated with the record. |
NUMBER |
2 |
ACCT_ASGMT_NETWORK_NUMBER |
Acct asgmt network number associated with the record. |
VARCHAR2 |
12 |
ACCT_SETTLEMENT_REF_DATE |
Date associated with acct settlement ref. |
DATE |
|
ASSET_MAIN_NUMBER |
Asset main number associated with the record. |
VARCHAR2 |
12 |
ASSET_SUB_NUMBER |
Asset sub number associated with the record. |
VARCHAR2 |
4 |
BUSINESS_AREA |
Business area associated with the record. |
VARCHAR2 |
4 |
COMMITMENT_ITEM |
Commitment item associated with the record. |
VARCHAR2 |
14 |
CONTROLLING_AREA |
Controlling area associated with the record. |
VARCHAR2 |
4 |
COST_COLLECTOR_KEY |
Surrogate key identifying the cost collector. |
VARCHAR2 |
12 |
COST_OBJECT |
Cost object associated with the record. |
VARCHAR2 |
12 |
CREATED_BY |
Created by associated with the record. |
VARCHAR2 |
12 |
DELETION_INDICATOR |
Indicator identifying whether deletion (Y/N). |
VARCHAR2 |
1 |
DISTRIBUTION_AMOUNT |
Distribution amount associated with the record. |
NUMBER |
16,2 |
DISTRIBUTION_PERCENTAGE |
Distribution percentage associated with the record. |
NUMBER |
34,17 |
FUNCTIONAL_AREA |
Functional area associated with the record. |
VARCHAR2 |
16 |
FUND |
Fund associated with the record. |
VARCHAR2 |
10 |
FUND_CENTER |
Fund center associated with the record. |
VARCHAR2 |
16 |
GL_ACCOUNT_KEY |
Surrogate key identifying the gl account. |
VARCHAR2 |
10 |
GOODS_RECIPIENT |
Goods recipient associated with the record. |
VARCHAR2 |
25 |
INTERNAL_COUNTER |
Internal counter associated with the record. |
VARCHAR2 |
8 |
IS_POSTING_TO_COST_CENTER |
Indicator identifying whether posting to cost center (Y/N). |
VARCHAR2 |
1 |
IS_POSTING_TO_ORDER |
Indicator identifying whether posting to order (Y/N). |
VARCHAR2 |
1 |
IS_POSTING_TO_PROJECT |
Indicator identifying whether posting to project (Y/N). |
VARCHAR2 |
1 |
OPERATIONS_ROUTING_NUMBER |
Operations routing number associated with the record. |
VARCHAR2 |
10 |
PARTNER_ACCOUNT_NUMBER |
Partner account number associated with the record. |
VARCHAR2 |
10 |
PROFITABILITY_SEGMENT_NUMBER |
Profitability segment number associated with the record. |
VARCHAR2 |
10 |
PROFIT_CENTER |
Profit center associated with the record. |
VARCHAR2 |
10 |
REAL_ESTATE_KEY |
Surrogate key identifying the real estate. |
VARCHAR2 |
8 |
RECORD_CREATION_DATE |
Date associated with record creation. |
DATE |
|
RECOVERY_INDICATOR |
Indicator identifying whether recovery (Y/N). |
VARCHAR2 |
2 |
REQUISITION_ITEM_NUMBER |
Requisition item number associated with the record. |
NUMBER |
5 |
REQUISITION_NUMBER |
Requisition number associated with the record. |
VARCHAR2 |
10 |
REQ_QUANTITY |
Req quantity associated with the record. |
NUMBER |
13,3 |
SALES_DOCUMENT_ITEM |
Sales document item associated with the record. |
NUMBER |
6 |
SALES_DOCUMENT_NUMBER |
Sales document number associated with the record. |
VARCHAR2 |
10 |
SALES_DOCUMENT_SCHEDULE_LINE |
Sales document schedule line associated with the record. |
NUMBER |
4 |
UNLOADING_POINT |
Unloading point associated with the record. |
VARCHAR2 |
80 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |