LINE_ITEM_RELATION
The Line Item Relation table records the relation between line item and a parent line item.
|
Columns |
Type |
Length |
Description |
|||||||||
|
LINE_ITEM_ID |
numeric |
19 |
It is a foreign key. The ID is the primary key for the Line Item dimension. |
|||||||||
|
RELATION_TYPE |
varchar |
255 |
Defines what relation exists between a child and parent line item. Valid values include:
|
|||||||||
|
PARENT_LINE_ITEM_ID |
numeric |
19 |
This is a foreign key. The ID is the primary key for the parent Line Item in the Line Item Dimension table. |