EX_TAUTH_DIST_H (SQL Table)	Index Back
Travel Authorizations Dist This record holds accounting chartfields for each Travel Authorization Line.

EX_TAUTH_DIST_H

(SQL Table)

Travel Authorizations Dist

This record holds accounting chartfields for each Travel Authorization Line.

# 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]

5 DISTRIB_LINE_NUM Number(5,0) INTEGER NOT NULL Distribution Line
Default Value: 1

6 DST_ACCT_TYPE Character(4) VARCHAR2(4) NOT NULL 07/20/04 st: added RCN for Advance Reconciliation 02/16/98 ebn CN#CM800-2.0 : Added for MISC type for Landed Cost Enhancement 11/11/99 llr: Added ADVP for Payables Advance Payment
Default Value: DST

7 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit
Default Value: BUS_UNIT_TBL_EX.BUSINESS_UNIT_GL
Prompt Table: SP_BU_GL_NONVW

8 ACCOUNT Character(10) VARCHAR2(10) NOT NULL Account
Prompt Table: %EDIT_ACCOUNT
Set Control Field: BUSINESS_UNIT_GL

9 ALTACCT Character(10) VARCHAR2(10) NOT NULL Alternate Account
Prompt Table: %EDIT_ALTACCT

10 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
Prompt Table: %EDIT_DEPT
Set Control Field: BUSINESS_UNIT_GL

11 OPERATING_UNIT Character(8) VARCHAR2(8) NOT NULL Operating Unit ChartField
Prompt Table: %EDIT_OPER_UNIT

12 PRODUCT Character(6) VARCHAR2(6) NOT NULL Product ChartField
Prompt Table: %EDIT_PRODUCT

13 FUND_CODE Character(5) VARCHAR2(5) NOT NULL Fund Code
Prompt Table: %EDIT_FUND_CODE

14 CLASS_FLD Character(5) VARCHAR2(5) NOT NULL Class Field
Prompt Table: %EDIT_CLASS_FLD

15 PROGRAM_CODE Character(5) VARCHAR2(5) NOT NULL Program Code ChartField
Prompt Table: %EDIT_PROG_CODE

16 BUDGET_REF Character(8) VARCHAR2(8) NOT NULL Budget Reference
Prompt Table: %EDIT_BUD_REF

17 AFFILIATE Character(5) VARCHAR2(5) NOT NULL Affiliate
Prompt Table: AFFILIATE_VW

18 AFFILIATE_INTRA1 Character(10) VARCHAR2(10) NOT NULL IntraUnit Affiliate1
Prompt Table: %EDIT_INTRA01

19 AFFILIATE_INTRA2 Character(10) VARCHAR2(10) NOT NULL Operating Unit Affiliate
Prompt Table: %EDIT_INTRA02

20 CHARTFIELD1 Character(10) VARCHAR2(10) NOT NULL Expansion chartfield 1
Prompt Table: %EDIT_CHARTFLD1

21 CHARTFIELD2 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 2
Prompt Table: %EDIT_CHARTFLD2

22 CHARTFIELD3 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 3
Prompt Table: %EDIT_CHARTFLD3

23 BUSINESS_UNIT_PC Character(5) VARCHAR2(5) NOT NULL PC Business Unit
Prompt Table: %EDIT_BU_PC

24 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField
Prompt Table: %EDIT_PROJECT

25 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID
Prompt Table: %EDIT_ACTIVITY

26 RESOURCE_TYPE Character(5) VARCHAR2(5) NOT NULL Source Type
Prompt Table: PROJ_RESTYPE_FS
Set Control Field: BUSINESS_UNIT_PC

27 RESOURCE_CATEGORY Character(5) VARCHAR2(5) NOT NULL Category
Prompt Table: %EDIT_RES_CAT
Set Control Field: BUSINESS_UNIT_PC

28 RESOURCE_SUB_CAT Character(5) VARCHAR2(5) NOT NULL Subcategory
Prompt Table: %EDIT_RES_SUB
Set Control Field: BUSINESS_UNIT_PC

29 ANALYSIS_TYPE Character(3) VARCHAR2(3) NOT NULL Analysis Type
Prompt Table: %EDIT_ANALYSIS
Set Control Field: BUSINESS_UNIT_PC

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

31 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
Prompt Table: CURRENCY_CD_TBL

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

33 TXN_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Transaction Currency
Prompt Table: CURRENCY_CD_TBL

34 RATE_MULT Signed Number(17,8) DECIMAL(15,8) NOT NULL Rate Multiplier

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

36 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

37 GL_DISTRIB_STATUS Character(1) VARCHAR2(1) NOT NULL Distribution Status
C=Available to Contracts
D=Distributed
G=Generated
H=Hold
I=Ignored
J=Creating Journals
M=Modified
N=None
P=To be processed
X=Waiting for Reversal
Default Value: N

38 BI_DISTRIB_STATUS Character(1) VARCHAR2(1) NOT NULL Billing Distribution Status
D=Distributed
I=Ignore
N=Not Distributed
P=Priced
U=Unbillable/Non-billable
W=Billing Worksheet
Default Value: I

39 ACCOUNTING_DT Date(10) DATE The accounting entry construction date for a given transaction (a generic field that crosses multiple

40 BUDGET_DT Date(10) DATE Budget Date
Default Value: EX_TAUTH_HDR.ACCOUNTING_DT

41 BUDGET_LINE_STATUS Character(1) VARCHAR2(1) NOT NULL -> SL - 15-AUG-2002 MISC_CRITERIA label has been added <-
B=Bypass
E=Error
N=Not Chk'd
V=Valid
W=Warning
Default Value: N

42 LEDGER_GROUP Character(10) VARCHAR2(10) NOT NULL Ledger Group

43 LEDGER Character(10) VARCHAR2(10) NOT NULL Ledger

44 KK_PROCESS_PRIOR Character(1) VARCHAR2(1) NOT NULL Process Prior Document

45 KK_CLOSE_FLAG Character(1) VARCHAR2(1) NOT NULL Commitment Control Close Flag

46 ORIG_BUDGET_DT Date(10) DATE Original Budget Date

47 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]
5	DISTRIB_LINE_NUM	Number(5,0)	INTEGER NOT NULL	Distribution Line Default Value: 1
6	DST_ACCT_TYPE	Character(4)	VARCHAR2(4) NOT NULL	07/20/04 st: added RCN for Advance Reconciliation 02/16/98 ebn CN#CM800-2.0 : Added for MISC type for Landed Cost Enhancement 11/11/99 llr: Added ADVP for Payables Advance Payment Default Value: DST
7	BUSINESS_UNIT_GL	Character(5)	VARCHAR2(5) NOT NULL	GL Business Unit Default Value: BUS_UNIT_TBL_EX.BUSINESS_UNIT_GL Prompt Table: SP_BU_GL_NONVW
8	ACCOUNT	Character(10)	VARCHAR2(10) NOT NULL	Account Prompt Table: %EDIT_ACCOUNT Set Control Field: BUSINESS_UNIT_GL
9	ALTACCT	Character(10)	VARCHAR2(10) NOT NULL	Alternate Account Prompt Table: %EDIT_ALTACCT
10	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department Prompt Table: %EDIT_DEPT Set Control Field: BUSINESS_UNIT_GL
11	OPERATING_UNIT	Character(8)	VARCHAR2(8) NOT NULL	Operating Unit ChartField Prompt Table: %EDIT_OPER_UNIT
12	PRODUCT	Character(6)	VARCHAR2(6) NOT NULL	Product ChartField Prompt Table: %EDIT_PRODUCT
13	FUND_CODE	Character(5)	VARCHAR2(5) NOT NULL	Fund Code Prompt Table: %EDIT_FUND_CODE
14	CLASS_FLD	Character(5)	VARCHAR2(5) NOT NULL	Class Field Prompt Table: %EDIT_CLASS_FLD
15	PROGRAM_CODE	Character(5)	VARCHAR2(5) NOT NULL	Program Code ChartField Prompt Table: %EDIT_PROG_CODE
16	BUDGET_REF	Character(8)	VARCHAR2(8) NOT NULL	Budget Reference Prompt Table: %EDIT_BUD_REF
17	AFFILIATE	Character(5)	VARCHAR2(5) NOT NULL	Affiliate Prompt Table: AFFILIATE_VW
18	AFFILIATE_INTRA1	Character(10)	VARCHAR2(10) NOT NULL	IntraUnit Affiliate1 Prompt Table: %EDIT_INTRA01
19	AFFILIATE_INTRA2	Character(10)	VARCHAR2(10) NOT NULL	Operating Unit Affiliate Prompt Table: %EDIT_INTRA02
20	CHARTFIELD1	Character(10)	VARCHAR2(10) NOT NULL	Expansion chartfield 1 Prompt Table: %EDIT_CHARTFLD1
21	CHARTFIELD2	Character(10)	VARCHAR2(10) NOT NULL	Expansion Chartfield 2 Prompt Table: %EDIT_CHARTFLD2
22	CHARTFIELD3	Character(10)	VARCHAR2(10) NOT NULL	Expansion Chartfield 3 Prompt Table: %EDIT_CHARTFLD3
23	BUSINESS_UNIT_PC	Character(5)	VARCHAR2(5) NOT NULL	PC Business Unit Prompt Table: %EDIT_BU_PC
24	PROJECT_ID	Character(15)	VARCHAR2(15) NOT NULL	Project Id ChartField Prompt Table: %EDIT_PROJECT
25	ACTIVITY_ID	Character(15)	VARCHAR2(15) NOT NULL	Activity ID Prompt Table: %EDIT_ACTIVITY
26	RESOURCE_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Source Type Prompt Table: PROJ_RESTYPE_FS Set Control Field: BUSINESS_UNIT_PC
27	RESOURCE_CATEGORY	Character(5)	VARCHAR2(5) NOT NULL	Category Prompt Table: %EDIT_RES_CAT Set Control Field: BUSINESS_UNIT_PC
28	RESOURCE_SUB_CAT	Character(5)	VARCHAR2(5) NOT NULL	Subcategory Prompt Table: %EDIT_RES_SUB Set Control Field: BUSINESS_UNIT_PC
29	ANALYSIS_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Analysis Type Prompt Table: %EDIT_ANALYSIS Set Control Field: BUSINESS_UNIT_PC
30	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.
31	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Prompt Table: CURRENCY_CD_TBL
32	TXN_AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Transaction Amount
33	TXN_CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Transaction Currency Prompt Table: CURRENCY_CD_TBL
34	RATE_MULT	Signed Number(17,8)	DECIMAL(15,8) NOT NULL	Rate Multiplier
35	RATE_DIV	Number(16,8)	DECIMAL(15,8) NOT NULL	Rate Divisor Default Value: 1
36	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
37	GL_DISTRIB_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Distribution Status C=Available to Contracts D=Distributed G=Generated H=Hold I=Ignored J=Creating Journals M=Modified N=None P=To be processed X=Waiting for Reversal Default Value: N
38	BI_DISTRIB_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Billing Distribution Status D=Distributed I=Ignore N=Not Distributed P=Priced U=Unbillable/Non-billable W=Billing Worksheet Default Value: I
39	ACCOUNTING_DT	Date(10)	DATE	The accounting entry construction date for a given transaction (a generic field that crosses multiple
40	BUDGET_DT	Date(10)	DATE	Budget Date Default Value: EX_TAUTH_HDR.ACCOUNTING_DT
41	BUDGET_LINE_STATUS	Character(1)	VARCHAR2(1) NOT NULL	-> SL - 15-AUG-2002 MISC_CRITERIA label has been added <- B=Bypass E=Error N=Not Chk'd V=Valid W=Warning Default Value: N
42	LEDGER_GROUP	Character(10)	VARCHAR2(10) NOT NULL	Ledger Group
43	LEDGER	Character(10)	VARCHAR2(10) NOT NULL	Ledger
44	KK_PROCESS_PRIOR	Character(1)	VARCHAR2(1) NOT NULL	Process Prior Document
45	KK_CLOSE_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Commitment Control Close Flag
46	ORIG_BUDGET_DT	Date(10)	DATE	Original Budget Date
47	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.