RE_TEST_ALLOC

(SQL Table)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT_AM Character(5) VARCHAR2(5) NOT NULL AM Business Unit

2 ASSET_ID Character(12) VARCHAR2(12) NOT NULL Asset Identification

3 STATISTIC_AMOUNT2 Signed Number(17,2) DECIMAL(15,2) NOT NULL Statistic Amount 2

4 SPACE_UOM Character(3) VARCHAR2(3) NOT NULL Space Unit of measure (Sq Feet or Sq Meters)
Prompt Table: UNITS_TBL

5 STATISTICS_ACCT Character(10) VARCHAR2(10) NOT NULL Statistical Account

6 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

7 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit

8 STATISTIC_AMOUNT Signed Number(17,2) DECIMAL(15,2) NOT NULL Specifies the amount associated with a statistical account on a journal line or a distribution line. It represents a quantity rather than a monetary amount and is qualified by the Unit of Measure associated with the STATISTICS_CODE or statistics ACCOUNT.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT_AM	Character(5)	VARCHAR2(5) NOT NULL	AM Business Unit
2	ASSET_ID	Character(12)	VARCHAR2(12) NOT NULL	Asset Identification
3	STATISTIC_AMOUNT2	Signed Number(17,2)	DECIMAL(15,2) NOT NULL	Statistic Amount 2
4	SPACE_UOM	Character(3)	VARCHAR2(3) NOT NULL	Space Unit of measure (Sq Feet or Sq Meters) Prompt Table: UNITS_TBL
5	STATISTICS_ACCT	Character(10)	VARCHAR2(10) NOT NULL	Statistical Account
6	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department
7	BUSINESS_UNIT_GL	Character(5)	VARCHAR2(5) NOT NULL	GL Business Unit
8	STATISTIC_AMOUNT	Signed Number(17,2)	DECIMAL(15,2) NOT NULL	Specifies the amount associated with a statistical account on a journal line or a distribution line. It represents a quantity rather than a monetary amount and is qualified by the Unit of Measure associated with the STATISTICS_CODE or statistics ACCOUNT.