DW_NS_WAVE_LINES_F
This fact table contains line level information about wave transaction which includes committed orders or order lines of sales order or transfer order that needs to release from a warehouse location.
Details
Module:
Key Columns
wave, order_number, line_number
Columns
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| wave | NUMBER | 38 | 0 | True | Wave transaction identifier. | ||
| order_number | NUMBER | 38 | 0 | True | Sales/Transfer order identifier which are associated with the wave. | DW_NS_SALES_ORDER_LINES_F | transaction |
| line_number | NUMBER | 38 | 0 | True | Sales/Transfer order line numbers of items which are processed as a part of the wave. | DW_NS_SALES_ORDER_LINES_F | id |
| 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. | ||||
| item | NUMBER | 38 | 0 | Identifier of an item used in transaction line. | DW_NS_item_D | id | |
| quantity | NUMBER | Number of items created in the line. | |||||
| description | VARCHAR2 | 999 | Description of the wave line items. | ||||
| createdby | NUMBER | 38 | 0 | Transaction creator identifier. | DW_NS_entity_D | id | |
| type | VARCHAR2 | 16 | Type of transaction. | DW_NS_STATUS_D | key | ||
| trandate | TIMESTAMP | Date when a transaction occurred or was posted. Examples include when a sale or payment was made. | |||||
| location | NUMBER | 38 | 0 | Location identifier associated with transaction. | DW_NS_location_D | id | |
| trandisplayname | VARCHAR2 | 999 | Name of transaction, which also contains the transaction type info. The name is a combination of transaction type and document number. | ||||
| lastmodifieddate | TIMESTAMP | Date when the transaction was last changed. | |||||
| postingperiod | NUMBER | 38 | 0 | Period to which this transaction is posted. | DW_NS_accountingPeriod_D | id | |
| releaseddate | TIMESTAMP | The release date of the wave. | |||||
| status | VARCHAR2 | 16 | Transaction status code, For example, Sales Order - Pending Approval, or Invoice - Paid In Full. | DW_NS_STATUS_D | code | ||
| createddate | TIMESTAMP | Transaction creation date. | |||||
| wavetype | VARCHAR2 | 64 | The transaction type of orders that are included in the wave. | ||||
| picktype | VARCHAR2 | 32 | The picking type that will apply to orders in the wave. | ||||
| lastmodifiedby | NUMBER | 38 | 0 | Entity identifier of the last person to edit a transaction. | DW_NS_entity_D | id |