DW_NS_INVENTORY_COST_REVAL_LINES_A
Aggregation table of DW_NS_INVENTORY_COST_REVAL_LINES_F
Details
Module:
Key Columns
id, transaction, accountingbook
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 | ||||
| posting | VARCHAR2 | 16 | |||||
| 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 |