EX_SHT_PHN_TMP

(SQL Table)
Index Back

Sheet/Travel Auth Line Info

View displaying link between expense sheet and travel auth.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 TRANS_DT Date(10) DATE Transaction Date

Default Value: EX_SHEET_LINE.TRANS_DT

2 TXN_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Transaction Amount
3 TXN_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Transaction Currency

Default Value: BUS_UNIT_TBL_EX.BASE_CURRENCY

4 TXN_LOCATION Character(5) VARCHAR2(5) NOT NULL Expense Location
5 EXPENSE_TYPE Character(7) VARCHAR2(7) NOT NULL Expense Type
6 EE_LOCAMT_COMMENT Character(60) VARCHAR2(60) NOT NULL Location Amount Comment
7 PERSONAL_EXPENSE Character(1) VARCHAR2(1) NOT NULL Personal Expense
N=No
Y=Yes

Y/N Table Edit

Default Value: N