XM_ER_TR_ITEM_LINKS
Entity Name | XM_ER_TR_ITEM_LINKS |
---|---|
Entity Type | Independent |
Definition | This table is used with ER-TP integration. It defines a link between an ER and a TP line item. The TP line item will not be the child of a travel plan. Instead, it will be the child of a Bob in this table. |
Attribute | Datatype | Width | Definition |
---|---|---|---|
LINE_ITEM_ID | Integer | 38 | ER line item id PK |
TR_TRACKING_NUM | Varchar | 255 | Tracking number of source TP |
PREAPPROVED_AMT_CURRENCY | varchar | 3 | Pre-approved amount currency iso code |
PREAPPROVED_AMT | Float (28,10) | 3 | Pre-approved amount |
LINE_ITEM_DATE | date | T ravel line item from date | |
CHANGE_TIMESTAMP | date | ||
TR_ITEM_ID | Integer | 38 | Linked travel item |