EX_TAUTH_HLN_VW(SQL View) |
Index Back |
|---|---|
Expense Report Header LineExpense Report Header and Line information. |
| SELECT A.TRAVEL_AUTH_ID , A.LINE_NBR , HDR.SETID , A.EXPENSE_TYPE , A.EXPEND_MTHD , A.TRAVEL_FROM , A.TRAVEL_TO , A.TXN_LOCATION , A.BILLING_ACTION , A.REIMBURSEMENT_CD , A.DESCR254 , A.MERCHANT_CD , A.MERCHANT , A.TRANS_DT , A.MONETARY_AMOUNT , A.CURRENCY_CD , A.TXN_AMOUNT , A.TXN_CURRENCY_CD , A.EX_LINE_STATUS FROM PS_EX_TAUTH_LINE A , PS_EX_TAUTH_HDR HDR WHERE HDR.TRAVEL_AUTH_ID = A.TRAVEL_AUTH_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  TRAVEL_AUTH_ID |
Character(10) | VARCHAR2(10) NOT NULL | Travel Authorization Identification. Number used to define travel authorizations. Key field on most travel authorization records and exists at level 0 for travel authorization panels. |
| 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 | 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. |
| 7 | TRAVEL_TO | Character(5) | VARCHAR2(5) NOT NULL | Used to indicate the ending 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_FROM field to track the cost of flights to and from various locals. |
| 8 | TXN_LOCATION | Character(5) | VARCHAR2(5) NOT NULL | Expense Location |
| 9 | BILLING_ACTION | Character(1) | VARCHAR2(1) NOT NULL |
Billing Action
B=Billable I=Internal P=Personal U=Nonbillable |
| 10 | REIMBURSEMENT_CD | Character(1) | VARCHAR2(1) NOT NULL |
Deny
N=Nonreimburseable P=Prepaid R=Reimburseable |
| 11 | DESCR254 | Character(254) | VARCHAR2(254) NOT NULL | Description of length 254 |
| 12 | MERCHANT_CD | Character(10) | VARCHAR2(10) NOT NULL | Preferred Merchant |
| 13 | MERCHANT | Character(40) | VARCHAR2(40) NOT NULL | Merchant |
| 14 | TRANS_DT | Date(10) | DATE | Transaction Date |
| 15 | 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. |
| 16 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 17 | TXN_AMOUNT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Transaction Amount |
| 18 | TXN_CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Transaction Currency |
| 19 | 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 |