WELFARE FINANCIAL DETAIL Table
View exposing welfare-related financial detail records including benefit financial transactions, amounts, and related processing attributes.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ACTUAL_AMOUNT |
Actual amount associated with the record. |
NUMBER |
13,2 |
ALLOCATION_NUMBER |
Allocation number associated with the record. |
VARCHAR2 |
18 |
ALTERNATIVE_ACCOUNT_NUMBER |
Alternative account number associated with the record. |
VARCHAR2 |
10 |
DOCUMENT_DATE |
Date associated with document. |
DATE |
|
DOCUMENT_ENTRY_DATE |
Date associated with document entry. |
DATE |
|
DOCUMENT_LAST_CHANGE_DATE |
Date associated with document last change. |
DATE |
|
DOCUMENT_LINE_DATE |
Date associated with document line. |
DATE |
|
DOCUMENT_LINE_ITEM |
Document line item associated with the record. |
NUMBER |
|
DOCUMENT_NUMBER |
Document number associated with the record. |
VARCHAR2 |
10 |
DOCUMENT_TYPE_KEY |
Surrogate key identifying the document type. |
VARCHAR2 |
3 |
GL_ACCOUNT_KEY |
Surrogate key identifying the gl account. |
VARCHAR2 |
10 |
LINE_ITEM_TEXT |
Line item text associated with the record. |
VARCHAR2 |
50 |
POSTING_DATE |
Date associated with posting. |
DATE |
|
POSTING_KEY |
Surrogate key identifying the posting. |
VARCHAR2 |
3 |
POSTING_KEY_CODE |
Code identifying posting key. |
VARCHAR2 |
2 |
REFERENCE_DOCUMENT_NUMBER |
Reference document number associated with the record. |
VARCHAR2 |
16 |
REFERENCE_TEXT |
Reference text associated with the record. |
VARCHAR2 |
50 |
REVERSE_DOCUMENT_NUMBER |
Reverse document number associated with the record. |
VARCHAR2 |
10 |
REVERSE_DOCUMENT_YEAR |
Reverse document year associated with the record. |
VARCHAR2 |
4 |
TRANSACTION_CODE |
Code identifying transaction. |
VARCHAR2 |
20 |
TRANSACTION_COUNTER |
Transaction counter associated with the record. |
NUMBER |
|
USER_NAME |
User name associated with the record. |
VARCHAR2 |
12 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |
|
WELFARE_FINANCIAL_DETAIL_KEY |
Surrogate key identifying the welfare financial detail. |
VARCHAR2 |
17 |
WELFARE_TIME_MONTH_KEY |
Surrogate key identifying the welfare time month. |
VARCHAR2 |
100 |