# DW_NS_INVENTORY_COST_REVAL_LINES_A

Aggregation table of DW_NS_INVENTORY_COST_REVAL_LINES_F

## Details

Module:

## Key Columns

transaction, accountingbook, id

## Columns

Columns
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column
--- | --- | --- | --- | --- | --- | --- | ---
transaction | NUMBER | 38 | 0 | True |  |  |
id | NUMBER | 38 | 0 | True |  |  |
accountingbook | NUMBER | 38 | 0 | True |  |  |
SOURCE_RECORD_ID | VARCHAR2 | 999 |  |  | This column is for Oracle Internal use only. |  |
commitinventory | NUMBER | 38 | 0 |  |  |  |
mainline | VARCHAR2 | 16 |  |  |  |  |
expenseaccount | NUMBER | 38 | 0 |  |  |  |
costestimatetype | VARCHAR2 | 64 |  |  |  |  |
inventoryreportinglocation | NUMBER | 38 | 0 |  |  |  |
inventorylocation | NUMBER | 38 | 0 |  |  |  |
class | NUMBER | 38 | 0 |  |  |  |
itemtype | VARCHAR2 | 32 |  |  |  |  |
department | NUMBER | 38 | 0 |  |  |  |
item | NUMBER | 38 | 0 |  |  |  |
subsidiary | NUMBER | 38 | 0 |  |  |  |
location | NUMBER | 38 | 0 |  |  |  |
inventorysubsidiary | NUMBER | 38 | 0 |  |  |  |
isinventoryaffecting | VARCHAR2 | 16 |  |  |  |  |
linelastmodifieddate | TIMESTAMP |  |  |  |  |  |
fulfillable | VARCHAR2 | 16 |  |  |  |  |
is_ratepercent | VARCHAR2 | 16 |  |  |  |  |
transactionlinetype | VARCHAR2 | 64 |  |  |  |  |
isscrap | VARCHAR2 | 16 |  |  |  |  |
createdfrom | NUMBER | 38 | 0 |  |  |  |
trandisplayname | VARCHAR2 | 999 |  |  |  |  |
createddate | TIMESTAMP |  |  |  |  |  |
type | VARCHAR2 | 16 |  |  |  |  |
typebaseddocumentnumber | VARCHAR2 | 512 |  |  |  |  |
lastmodifiedby | NUMBER | 38 | 0 |  |  |  |
trandate | TIMESTAMP |  |  |  |  |  |
currency | NUMBER | 38 | 0 |  |  |  |
status | VARCHAR2 | 16 |  |  |  |  |
postingperiod | NUMBER | 38 | 0 |  |  |  |
nexus | NUMBER | 38 | 0 |  |  |  |
account | NUMBER | 38 | 0 |  |  |  |
credit | NUMBER |  |  |  |  |  |
debit | NUMBER |  |  |  |  |  |
accountingbook_credit | NUMBER |  |  |  |  |  |
accountingbook_debit | NUMBER |  |  |  |  |  |
creditforeignamount | NUMBER |  |  |  |  |  |
debitforeignamount | NUMBER |  |  |  |  |  |
netamount | NUMBER |  |  |  |  |  |
foreignamount | NUMBER |  |  |  |  |  |
base_creditamount | NUMBER |  |  |  |  |  |
base_debitamount | NUMBER |  |  |  |  |  |
base_netamount | NUMBER |  |  |  |  |  |
base_amount | NUMBER |  |  |  |  |  |
base_currency | NUMBER | 38 | 0 |  |  |  |
base_exchangerate | NUMBER |  |  |  |  |  |
accountingbook_currency | NUMBER | 38 | 0 |  |  |  |
accountingbook_exchangerate | NUMBER |  |  |  |  |  |
accountingbook_amount | NUMBER |  |  |  |  |  |
accountingbook_netamount | NUMBER |  |  |  |  |  |

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