| Name | Type | Length | Precision | Scale | References | In | Description |
|---|---|---|---|---|---|---|---|
| amount_foreign_linked | NUMBER | 20 | 2 | Foreign currency amount linked | |||
| amount_linked | NUMBER | 20 | 2 | Amount linked | |||
| applied_date_posted | TIMESTAMP | Applied date posted | |||||
| applied_transaction_id | NUMBER | 22 | 0 |
transaction_id transaction_id |
Transaction_lines Transactions |
Applied transaction ID | |
| applied_transaction_line_id | NUMBER | 22 | 0 |
transaction_line_id |
Transaction_lines |
Applied transaction line ID | |
| date_last_modified | TIMESTAMP | Date last modified (GMT) | |||||
| discount | VARCHAR2 | 32 | Discount | ||||
| inventory_number | VARCHAR2 | 100 | Inventory number | ||||
| link_type | VARCHAR2 | 128 | Link type | ||||
| original_date_posted | TIMESTAMP | Original date posted | |||||
| original_transaction_id | NUMBER | 22 | 0 |
transaction_id transaction_id |
Transaction_lines Transactions |
Original transaction ID | |
| original_transaction_line_id | NUMBER | 22 | 0 |
transaction_line_id |
Transaction_lines |
Original transaction line ID | |
| quantity_linked | NUMBER | 22 | 0 | Quantity linked |
| PK Column Name |
|---|
| original_transaction_id |
| original_transaction_line_id |
| applied_transaction_id |
| applied_transaction_line_id |
| link_type |
| inventory_number |
| FK Name | FK Column Name | PK Table Name | PK Column Name | Key Seq |
|---|---|---|---|---|
| transaction_links_applied_transaction_lines_fk | applied_transaction_id | Transaction_lines | transaction_id | 1 |
| transaction_links_applied_transaction_lines_fk | applied_transaction_line_id | Transaction_lines | transaction_line_id | 2 |
| transaction_links_applied_transactions_fk | applied_transaction_id | Transactions | transaction_id | 1 |
| transaction_links_original_transaction_lines_fk | original_transaction_id | Transaction_lines | transaction_id | 1 |
| transaction_links_original_transaction_lines_fk | original_transaction_line_id | Transaction_lines | transaction_line_id | 2 |
| transaction_links_original_transactions_fk | original_transaction_id | Transactions | transaction_id | 1 |