# DW_NS_VendPymtNextTransactionLineLink_F

This fact table contains the transaction which has previous or next transaction as vendor bill payment.

## Details

Module:

## Key Columns

previousdoc, linktype, previousline, nextdoc, nextline

## Columns

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 |  |

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