DW_NS_DepApplNextTransactionLineLink_F
This fact table contains the transaction which has previous or next transaction as deposit application.
Details
Module:
Key Columns
previousdoc, nextline, previousline, nextdoc, linktype
Columns
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| nextdoc | NUMBER | 38 | 0 | True | Next Transaction Identifier. | ||
| previousdoc | NUMBER | 38 | 0 | True | Previous Transaction Identifier. | ||
| linktype | VARCHAR2 | 16 | True | Link type, holds either previous or next transaction. | |||
| nextline | NUMBER | 38 | 0 | True | Next Transaction Line Identifier. | ||
| previousline | NUMBER | 38 | 0 | True | Previous Transaction Line Identifier. | ||
| SOURCE_RECORD_ID | VARCHAR2 | 256 | This column is for Oracle Internal use only. Composite key that consists of all PK values of the transaction. This consists combination of columns that defines the granularity of the table and identifies a row uniquely. | ||||
| foreignamount | NUMBER | The amount (at the transaction line) in the foreign transaction currency. | |||||
| nexttype | VARCHAR2 | 32 | Next Transaction Type. | ||||
| previoustype | VARCHAR2 | 32 | Previous Transaction Type. | ||||
| anchor_doc | NUMBER | 38 | 0 | Internal Column. It stores transaction identifier of either the next or previous transaction |