PSA_IU_AET

(SQL Table)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

2 RECNAME_BU Character(15) VARCHAR2(15) NOT NULL Business Unit Recname

3 RECNAME_UPDATE Character(15) VARCHAR2(15) NOT NULL Record to Update

4 FIELDNAME_BU Character(18) VARCHAR2(18) NOT NULL Business Unit Field Name

5 DST_USE Character(3) VARCHAR2(3) NOT NULL Added the following inactive translates for Contracts 8.4: AP Accounts Payable Liability AS Fixed Asset CA Contra Asset CG Cost of Goods Sold CL Contra Liability EX Expense IN Inventory WP Work In Progress

6 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

7 CHARTFIELD Character(18) VARCHAR2(18) NOT NULL ChartField

8 CHARTFIELD_VALUE Character(30) VARCHAR2(30) NOT NULL ChartField Value

9 CUR_EFFDT Date(10) DATE Specifies the effective date associated with the currency used as the base currency for the Business Unit on the Journal Entry Header.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	RECNAME_BU	Character(15)	VARCHAR2(15) NOT NULL	Business Unit Recname
3	RECNAME_UPDATE	Character(15)	VARCHAR2(15) NOT NULL	Record to Update
4	FIELDNAME_BU	Character(18)	VARCHAR2(18) NOT NULL	Business Unit Field Name
5	DST_USE	Character(3)	VARCHAR2(3) NOT NULL	Added the following inactive translates for Contracts 8.4: AP Accounts Payable Liability AS Fixed Asset CA Contra Asset CG Cost of Goods Sold CL Contra Liability EX Expense IN Inventory WP Work In Progress
6	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
7	CHARTFIELD	Character(18)	VARCHAR2(18) NOT NULL	ChartField
8	CHARTFIELD_VALUE	Character(30)	VARCHAR2(30) NOT NULL	ChartField Value
9	CUR_EFFDT	Date(10)	DATE	Specifies the effective date associated with the currency used as the base currency for the Business Unit on the Journal Entry Header.