EX_LOCAMT_G_DTL (SQL Table)	Index Back
Group Location Amount Table Expenses Location Amount Table For Expense Type Group

EX_LOCAMT_G_DTL

(SQL Table)

Group Location Amount Table

Expenses Location Amount Table For Expense Type Group

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
Default Value: OPR_DEF_TBL_FS.SETID
Prompt Table: SP_SETID_NONVW

2 EXPENSE_TYPE_GROUP Character(7) VARCHAR2(7) NOT NULL Expense Type Group
Prompt Table: EX_TYPE_GRP_TBL

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

4 EFFDT Date(10) DATE NOT NULL Effective Date
Default Value: %date

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

6 ACTIVE_AVG_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Active Average Amount

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

8 LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made 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	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW
2	EXPENSE_TYPE_GROUP	Character(7)	VARCHAR2(7) NOT NULL	Expense Type Group Prompt Table: EX_TYPE_GRP_TBL
3	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Prompt Table: CURRENCY_CD_TBL
4	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
5	TXN_LOCATION	Character(5)	VARCHAR2(5) NOT NULL	Expense Location Prompt Table: EX_LOCATION_TBL
6	ACTIVE_AVG_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Active Average Amount
7	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.
8	LASTUPDOPRID	Character(30)	VARCHAR2(30) NOT NULL	Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.