EX_TAUTH_LINE_H (SQL Table)	Index Back
Line Information Line Information

EX_TAUTH_LINE_H

(SQL Table)

Line Information

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PSARCH_ID Character(8) VARCHAR2(8) NOT NULL Archive ID (see PSARCHTEMPLATE).

2 PSARCH_BATCHNUM Number(30,0) DECIMAL(30) NOT NULL Archive Batch Number

3 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.

4 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
Default Value: 1

5 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

6 EXPENSE_TYPE Character(7) VARCHAR2(7) NOT NULL Expense Type
Prompt Table: EX_TYPES_TBL

7 TRANS_DT Date(10) DATE Transaction Date

8 PREPAID_EXPENSE Character(1) VARCHAR2(1) NOT NULL Pre-Paid Expense
Y/N Table Edit
Default Value: N

9 REIMBURSEMENT_CD Character(1) VARCHAR2(1) NOT NULL Deny
N=Nonreimburseable
P=Prepaid
R=Reimburseable
Default Value: R

10 REIMB_ACTION Character(5) VARCHAR2(5) NOT NULL Reason
Prompt Table: EX_ACTION_TBL

11 EXPEND_MTHD Character(3) VARCHAR2(3) NOT NULL Payment Type
Prompt Table: EX_EXP_MTHD_TBL
Set Control Field: BUSINESS_UNIT_GL

12 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.

13 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
Default Value: BUS_UNIT_TBL_EX.BASE_CURRENCY
Prompt Table: CURRENCY_CD_TBL

14 TXN_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Transaction Amount

15 TXN_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Transaction Currency
Default Value: BUS_UNIT_TBL_EX.BASE_CURRENCY
Prompt Table: CURRENCY_CD_TBL

16 TXN_LOCATION Character(5) VARCHAR2(5) NOT NULL Expense Location
Prompt Table: EX_LOCATION_VW4

17 RATE_MULT Signed Number(17,8) DECIMAL(15,8) NOT NULL Rate Multiplier
Default Value: 1

18 RATE_DIV Number(16,8) DECIMAL(15,8) NOT NULL Rate Divisor
Default Value: 1

19 RT_TYPE Character(5) VARCHAR2(5) NOT NULL Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.
Default Value: BUS_UNIT_OPT_EX.RT_TYPE
Prompt Table: RT_TYPE_TBL

20 AIRFARE_RCPT_NBR Character(16) VARCHAR2(16) NOT NULL Airfare Receipt Number

21 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.
Prompt Table: EX_LOCATION_VW5

22 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.
Prompt Table: EX_LOCATION_VW3

23 PREF_MRCHNT_FLG Character(1) VARCHAR2(1) NOT NULL Preferred Merchant
N=No
Y=Yes
Y/N Table Edit
Default Value: N

24 MERCHANT_CD Character(10) VARCHAR2(10) NOT NULL Preferred Merchant
Prompt Table: EX_MERCHANT_VW

25 MERCHANT Character(40) VARCHAR2(40) NOT NULL Merchant

26 DESCR60 Character(60) VARCHAR2(60) NOT NULL Description

27 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254

28 DISTANCE Number(8,2) DECIMAL(7,2) NOT NULL Distance Traveled

29 DISTANCE_RT Number(9,4) DECIMAL(8,4) NOT NULL Standard Distance Rate

30 DISTANCE_TYPE Character(1) VARCHAR2(1) NOT NULL Distance Type
3=Metres
K=Kilometers
M=Miles

31 NBR_NIGHTS Number(3,0) SMALLINT NOT NULL Number of Nights
Default Value: 1

32 NBR_DAYS Number(3,0) SMALLINT NOT NULL Used to specify the number of days associated with a particular expense type for Travel Authorizations, i.e. breakfast, lunch. Found on many of the Travel Auth line records and panels.
Default Value: 1

33 EE_LOCAMT_COMMENT Character(60) VARCHAR2(60) NOT NULL Location Amount Comment

34 NONPREFMERCH_JUST Character(10) VARCHAR2(10) NOT NULL Non-Preferred Justification

35 EE_PRFMRC_COMMENT Character(60) VARCHAR2(60) NOT NULL Preferred Vendor Comment

36 OUT_OF_POLICY Character(1) VARCHAR2(1) NOT NULL Authorized Amount Exceeded

37 TRANS_DT_JULIAN Number(3,0) SMALLINT NOT NULL Julian Transaction Date

38 BILL_CODE_EX Character(3) VARCHAR2(3) NOT NULL Expense Billing Code
Prompt Table: EX_BILL_CD_TBL

39 BILLING_ACTION Character(1) VARCHAR2(1) NOT NULL Billing Action
B=Billable
I=Internal
P=Personal
U=Nonbillable

40 OVRRIDE_SPLT_SW Character(1) VARCHAR2(1) NOT NULL Override Accounting Split
Y/N Table Edit
Default Value: N

41 STARTTM_PERDIEM Time(15) TIMESTAMP Start Time (HH:MI)

42 ENDTM_PERDIEM Time(15) TIMESTAMP End Time (HH:MI)

43 NBR_PASSENGERS Number(2,0) SMALLINT NOT NULL Number of Passengers

44 TRANSPORT_TYPE Character(5) VARCHAR2(5) NOT NULL Transportation Type

45 TRANSPORT_ID Character(15) VARCHAR2(15) NOT NULL Transportation ID
Prompt Table: EX_EE_TRNSPT_VW

46 RANGE_SEQ Number(3,0) SMALLINT NOT NULL Per Diem Range
Prompt Table: EX_DUR_VW

47 PHYSICAL_NATURE Character(1) VARCHAR2(1) NOT NULL Physical Nature
G=Goods
S=Services

48 APPROVE_FLAG Character(1) VARCHAR2(1) NOT NULL Approve Flag
Default Value: Y

49 APPROVER_OPRID Character(30) VARCHAR2(30) NOT NULL Approver Oprid

50 APPROVER_ACTN_DT Date(10) DATE The Date on which the approver takes necessary action

51 APPROVER_ADD_FLAG Character(1) VARCHAR2(1) NOT NULL New Approver Add Flag

52 UNDENY_FLAG Character(1) VARCHAR2(1) NOT NULL Undeny Flag

53 ITINERARY_ID Character(18) VARCHAR2(18) NOT NULL Itinerary ID for Travel Reservations

54 RESERVATION_NBR Number(3,0) SMALLINT NOT NULL reservation sequence number

55 ISCHANGED_FLAG Character(1) VARCHAR2(1) NOT NULL Record has been changed

56 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PSARCH_ID	Character(8)	VARCHAR2(8) NOT NULL	Archive ID (see PSARCHTEMPLATE).
2	PSARCH_BATCHNUM	Number(30,0)	DECIMAL(30) NOT NULL	Archive Batch Number
3	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.
4	LINE_NBR	Number(5,0)	INTEGER NOT NULL	Line Number: 11/24/08 - Added TARGET label [PC product] Default Value: 1
5	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
6	EXPENSE_TYPE	Character(7)	VARCHAR2(7) NOT NULL	Expense Type Prompt Table: EX_TYPES_TBL
7	TRANS_DT	Date(10)	DATE	Transaction Date
8	PREPAID_EXPENSE	Character(1)	VARCHAR2(1) NOT NULL	Pre-Paid Expense Y/N Table Edit Default Value: N
9	REIMBURSEMENT_CD	Character(1)	VARCHAR2(1) NOT NULL	Deny N=Nonreimburseable P=Prepaid R=Reimburseable Default Value: R
10	REIMB_ACTION	Character(5)	VARCHAR2(5) NOT NULL	Reason Prompt Table: EX_ACTION_TBL
11	EXPEND_MTHD	Character(3)	VARCHAR2(3) NOT NULL	Payment Type Prompt Table: EX_EXP_MTHD_TBL Set Control Field: BUSINESS_UNIT_GL
12	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.
13	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Default Value: BUS_UNIT_TBL_EX.BASE_CURRENCY Prompt Table: CURRENCY_CD_TBL
14	TXN_AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Transaction Amount
15	TXN_CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Transaction Currency Default Value: BUS_UNIT_TBL_EX.BASE_CURRENCY Prompt Table: CURRENCY_CD_TBL
16	TXN_LOCATION	Character(5)	VARCHAR2(5) NOT NULL	Expense Location Prompt Table: EX_LOCATION_VW4
17	RATE_MULT	Signed Number(17,8)	DECIMAL(15,8) NOT NULL	Rate Multiplier Default Value: 1
18	RATE_DIV	Number(16,8)	DECIMAL(15,8) NOT NULL	Rate Divisor Default Value: 1
19	RT_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical. Default Value: BUS_UNIT_OPT_EX.RT_TYPE Prompt Table: RT_TYPE_TBL
20	AIRFARE_RCPT_NBR	Character(16)	VARCHAR2(16) NOT NULL	Airfare Receipt Number
21	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. Prompt Table: EX_LOCATION_VW5
22	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. Prompt Table: EX_LOCATION_VW3
23	PREF_MRCHNT_FLG	Character(1)	VARCHAR2(1) NOT NULL	Preferred Merchant N=No Y=Yes Y/N Table Edit Default Value: N
24	MERCHANT_CD	Character(10)	VARCHAR2(10) NOT NULL	Preferred Merchant Prompt Table: EX_MERCHANT_VW
25	MERCHANT	Character(40)	VARCHAR2(40) NOT NULL	Merchant
26	DESCR60	Character(60)	VARCHAR2(60) NOT NULL	Description
27	DESCR254	Character(254)	VARCHAR2(254) NOT NULL	Description of length 254
28	DISTANCE	Number(8,2)	DECIMAL(7,2) NOT NULL	Distance Traveled
29	DISTANCE_RT	Number(9,4)	DECIMAL(8,4) NOT NULL	Standard Distance Rate
30	DISTANCE_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Distance Type 3=Metres K=Kilometers M=Miles
31	NBR_NIGHTS	Number(3,0)	SMALLINT NOT NULL	Number of Nights Default Value: 1
32	NBR_DAYS	Number(3,0)	SMALLINT NOT NULL	Used to specify the number of days associated with a particular expense type for Travel Authorizations, i.e. breakfast, lunch. Found on many of the Travel Auth line records and panels. Default Value: 1
33	EE_LOCAMT_COMMENT	Character(60)	VARCHAR2(60) NOT NULL	Location Amount Comment
34	NONPREFMERCH_JUST	Character(10)	VARCHAR2(10) NOT NULL	Non-Preferred Justification
35	EE_PRFMRC_COMMENT	Character(60)	VARCHAR2(60) NOT NULL	Preferred Vendor Comment
36	OUT_OF_POLICY	Character(1)	VARCHAR2(1) NOT NULL	Authorized Amount Exceeded
37	TRANS_DT_JULIAN	Number(3,0)	SMALLINT NOT NULL	Julian Transaction Date
38	BILL_CODE_EX	Character(3)	VARCHAR2(3) NOT NULL	Expense Billing Code Prompt Table: EX_BILL_CD_TBL
39	BILLING_ACTION	Character(1)	VARCHAR2(1) NOT NULL	Billing Action B=Billable I=Internal P=Personal U=Nonbillable
40	OVRRIDE_SPLT_SW	Character(1)	VARCHAR2(1) NOT NULL	Override Accounting Split Y/N Table Edit Default Value: N
41	STARTTM_PERDIEM	Time(15)	TIMESTAMP	Start Time (HH:MI)
42	ENDTM_PERDIEM	Time(15)	TIMESTAMP	End Time (HH:MI)
43	NBR_PASSENGERS	Number(2,0)	SMALLINT NOT NULL	Number of Passengers
44	TRANSPORT_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Transportation Type
45	TRANSPORT_ID	Character(15)	VARCHAR2(15) NOT NULL	Transportation ID Prompt Table: EX_EE_TRNSPT_VW
46	RANGE_SEQ	Number(3,0)	SMALLINT NOT NULL	Per Diem Range Prompt Table: EX_DUR_VW
47	PHYSICAL_NATURE	Character(1)	VARCHAR2(1) NOT NULL	Physical Nature G=Goods S=Services
48	APPROVE_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Approve Flag Default Value: Y
49	APPROVER_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Approver Oprid
50	APPROVER_ACTN_DT	Date(10)	DATE	The Date on which the approver takes necessary action
51	APPROVER_ADD_FLAG	Character(1)	VARCHAR2(1) NOT NULL	New Approver Add Flag
52	UNDENY_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Undeny Flag
53	ITINERARY_ID	Character(18)	VARCHAR2(18) NOT NULL	Itinerary ID for Travel Reservations
54	RESERVATION_NBR	Number(3,0)	SMALLINT NOT NULL	reservation sequence number
55	ISCHANGED_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Record has been changed
56	LASTUPDDTTM	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.