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