EX_USER_DFLT_VW(SQL View) |
Index Back |
---|---|
Expenses User Defaults |
SELECT B.EMPLID , CASE WHEN A.EXPENSE_TYPE IS NULL THEN ' ' ELSE A.EXPENSE_TYPE END , CASE WHEN A.PREF_MRCHNT_FLG IS NULL THEN ' ' ELSE A.PREF_MRCHNT_FLG END , CASE WHEN A.MERCHANT_CD IS NULL THEN ' ' ELSE A.MERCHANT_CD END , A.MERCHANT , CASE WHEN A.EXPEND_MTHD IS NULL THEN B.EXPEND_MTHD ELSE A.EXPEND_MTHD END , CASE WHEN A.BILL_CODE_EX IS NULL THEN B.BILL_CODE_EX ELSE A.BILL_CODE_EX END , B.TRAVEL_FROM , B.TXN_LOCATION , B.TRANSPORT_TYPE , B.TRANSPORT_ID , B.CRDMEM_ACCT_NBR , B.BILLING_ACTION , B.NBR_NIGHTS FROM PS_EX_EE_USER_PREF B LEFT OUTER JOIN PS_EX_EE_USER_DTL A ON A.EMPLID = B.EMPLID |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
2 | EXPENSE_TYPE | Character(7) | VARCHAR2(7) NOT NULL | Expense Type |
3 | PREF_MRCHNT_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Preferred Merchant
N=No Y=Yes |
4 | MERCHANT_CD | Character(10) | VARCHAR2(10) NOT NULL | Preferred Merchant |
5 | MERCHANT | Character(40) | VARCHAR2(40) NOT NULL | Merchant |
6 | EXPEND_MTHD | Character(3) | VARCHAR2(3) NOT NULL | Payment Type |
7 | BILL_CODE_EX | Character(3) | VARCHAR2(3) NOT NULL | Expense Billing Code |
8 | TRAVEL_FROM | Character(5) | VARCHAR2(5) NOT NULL | Used to indicate the starting point of travel for a travel authorization for airline expenditures. Defined on the EX_TAUTH_LINE record and used on various travel auth line panels. Used in conjunction with the TRAVEL_TO field to track the cost of flights to and from various locals. |
9 | TXN_LOCATION | Character(5) | VARCHAR2(5) NOT NULL | Expense Location |
10 | TRANSPORT_TYPE | Character(5) | VARCHAR2(5) NOT NULL | Transportation Type |
11 | TRANSPORT_ID | Character(15) | VARCHAR2(15) NOT NULL | Transportation ID |
12 | CRDMEM_ACCT_NBR | Character(44) | VARCHAR2(44) NOT NULL | Cardmember Number |
13 | BILLING_ACTION | Character(1) | VARCHAR2(1) NOT NULL |
Billing Action
B=Billable I=Internal P=Personal U=Nonbillable |
14 | NBR_NIGHTS | Number(3,0) | SMALLINT NOT NULL | Number of Nights |