EX_SHEET_HLN_VW

(SQL View)
 Index Back

Expense Report Header Line

Expense Report Header and Line information.

SELECT A.SHEET_ID , A.LINE_NBR , HDR.SETID , A.EXPENSE_TYPE , A.EXPEND_MTHD , A.TXN_LOCATION , A.BILLING_ACTION , A.REIMBURSEMENT_CD , A.DESCR254 , A.MERCHANT_CD , A.MERCHANT , A.TRANS_DT , A.PERSONAL_EXPENSE , A.RECEIPT_VERIFIED , A.RECEIPT_REQ_EX , A.NO_RECEIPT_FLG , A.MONETARY_AMOUNT , A.CURRENCY_CD , A.TXN_AMOUNT , A.TXN_CURRENCY_CD , A.EE_NORCPT_COMMENT , A.EX_LINE_STATUS FROM PS_EX_SHEET_LINE A , PS_EX_SHEET_HDR HDR WHERE HDR.SHEET_ID = A.SHEET_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SHEET_ID Character(10) VARCHAR2(10) NOT NULL Report ID
2 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]

Default Value: 1

3 SETID Character(5) VARCHAR2(5) NOT NULL SetID
4 EXPENSE_TYPE Character(7) VARCHAR2(7) NOT NULL Expense Type
5 EXPEND_MTHD Character(3) VARCHAR2(3) NOT NULL Payment Type
6 TXN_LOCATION Character(5) VARCHAR2(5) NOT NULL Expense Location
7 BILLING_ACTION Character(1) VARCHAR2(1) NOT NULL Billing Action
B=Billable
I=Internal
P=Personal
U=Nonbillable
8 REIMBURSEMENT_CD Character(1) VARCHAR2(1) NOT NULL Deny
N=Nonreimburseable
P=Prepaid
R=Reimburseable
9 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254
10 MERCHANT_CD Character(10) VARCHAR2(10) NOT NULL Preferred Merchant
11 MERCHANT Character(40) VARCHAR2(40) NOT NULL Merchant
12 TRANS_DT Date(10) DATE Transaction Date
13 PERSONAL_EXPENSE Character(1) VARCHAR2(1) NOT NULL Personal Expense
N=No
Y=Yes
14 RECEIPT_VERIFIED Character(1) VARCHAR2(1) NOT NULL Receipt Verified
15 RECEIPT_REQ_EX Character(1) VARCHAR2(1) NOT NULL Receipt Required
16 NO_RECEIPT_FLG Character(1) VARCHAR2(1) NOT NULL No Receipt
17 MONETARY_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Specifies the monetary amount of a debit or credit in the business unit base currency. Debit entries are positive and credit entries are negative. This amount is only zero if associated with a statistical account.
18 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
19 TXN_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Transaction Amount
20 TXN_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Transaction Currency
21 EE_NORCPT_COMMENT Character(60) VARCHAR2(60) NOT NULL No Receipt Comment
22 EX_LINE_STATUS Character(3) VARCHAR2(3) NOT NULL The Line Status of an Expenses transaction (i.e. Expense Report, Cash Advance, Travel Authorization, Time Report)
ADJ=Adjusted
APR=Approved
APY=Approved for Payment
CLS=Closed
DEN=Denied
DNA=Denied by Approver
DNC=Denied
DNU=Denied by Auditor
ESC=Escheated Payment
HDA=Hold by Approver
HDU=Hold by Auditor
HLD=Hold
MFS=Marked For Submit
OPN=Open
PAR=Approvals in Process
PD=Paid
PND=Pending
PRO=In Process
RAP=Approved
STG=Staged
SUB=Submitted
XML=Submitted, Pending Validation

Default Value: PND