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 |