# DW_NS_CASH_SALE_NEXT_LINK_F

This fact table contains the transaction which has next transaction as cash sale.

## Details

Module:

## Key Columns

previousdoc, linktype, previousline, nextdoc, nextline

## Columns

Columns
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column
--- | --- | --- | --- | --- | --- | --- | ---
linktype | VARCHAR2 | 16 |  | True | Link type, holds either previous or next transaction. |  |
nextdoc | NUMBER | 38 | 0 | True | Next Transaction Identifier. |  |
nextline | NUMBER | 38 | 0 | True | Next Transaction Line Identifier. |  |
previousdoc | NUMBER | 38 | 0 | True | Previous Transaction Identifier. |  |
previousline | NUMBER | 38 | 0 | True | Previous Transaction Line Identifier. |  |
SOURCE_RECORD_ID | VARCHAR2 | 999 |  |  | 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. |  |

Copyright © 2019, 2025, Oracle and/or its affiliates.