WELFARE FINANCIAL DETAIL Table
XXX
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ACTUAL_AMOUNT |
The paid dollar amount of the line item. |
NUMBER |
13,2 |
ALLOCATION_NUMBER |
Allocation number for special G/L accounts. Only customer and vendor line items for which a special G/L indicator has been entered are affected. |
VARCHAR2 |
18 |
ALTERNATIVE_ACCOUNT_NUMBER |
A ten digit number, the last three digits of which correspond to the MIT classic system's "object code", now replaced by SAP G/L accounts. |
VARCHAR2 |
10 |
DOCUMENT_DATE |
The date entered by the user when creating the document. Generally the date the financial transaction occurred, but see also the definition for document line date. |
DATE |
|
DOCUMENT_ENTRY_DATE |
The date the document was entered into SAP. |
DATE |
|
DOCUMENT_LAST_CHANGE_DATE |
he date the document was last modified in SAP. |
DATE |
|
DOCUMENT_LINE_DATE |
If not blank, the date the financial transaction occurred. If blank, the document date is the date the financial transaction occurred. |
DATE |
|
DOCUMENT_LINE_ITEM |
Document Line Item Number. |
NUMBER |
|
DOCUMENT_NUMBER |
The number in SAP that uniquely identifies a detailed transaction document. |
VARCHAR2 |
10 |
DOCUMENT_TYPE_KEY |
Key used to join the Document Type 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 |
3 |
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 |
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 |
POSTING_DATE |
The date the financial document was posted in SAP. Effective date of posting, not actual date. For example, a costing sheet posting could be generated in early July, but posted to June 30, if so specified by an authorized users. |
DATE |
|
POSTING_KEY |
Key required by SAP for each document line item, indicating the type of posting represented in the line item. "Posting Key" is the description for "Posting Key Code". |
VARCHAR2 |
3 |
POSTING_KEY_CODE |
2 digit code identifing the type of posting. Example: 09 - Security Deposit, 08 - Payment Clearing, 09 - Pledge, 09 - Special G/L Debit, 09 - Interest Due, 11 - Credit Memo, 40 - Debit, 50 - Credit, etc. |
VARCHAR2 |
2 |
REFERENCE_DOCUMENT_NUMBER |
For FINANCIAL_DETAIL: The reference number of the associated financial document. A value of %N means that there is no backup for the journal voucher. For COMMITMENT tables, the document number from which the commitment was generated. |
VARCHAR2 |
16 |
REFERENCE_TEXT |
The document header text associated with a journal document. Not always completed by the JV document creator. |
VARCHAR2 |
50 |
REVERSE_DOCUMENT_NUMBER |
The document number associated withreversing this transaction. |
VARCHAR2 |
10 |
REVERSE_DOCUMENT_YEAR |
The year of the reversed transaction. |
VARCHAR2 |
4 |
TRANSACTION_CODE |
The code assigned to each transaction by SAP. It may be more meaningful to use the document type. |
VARCHAR2 |
20 |
TRANSACTION_COUNTER |
Used to count records within a group on a report. Always contains a value of 1. |
NUMBER |
|
USER_NAME |
Kerberos ID of the person who entered the purchasing financial detail record in SAP, usually the purchasing agent |
VARCHAR2 |
12 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
|
WELFARE_FINANCIAL_DETAIL_KEY |
XXX |
VARCHAR2 |
17 |
WELFARE_TIME_MONTH_KEY |
XXX |
VARCHAR2 |
100 |