AM_SECD_BK_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 ASSET_ID Character(12) VARCHAR2(12) NOT NULL Asset Identification

3 BOOK Character(10) VARCHAR2(10) NOT NULL Asset Book Name

4 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

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

6 PRIMARY_LEDGER Character(1) VARCHAR2(1) NOT NULL A flag that indicates whether or not (Y or N) a ledger is designated as the primary ledger in a ledger group.

7 TRANSL_LEDGER Character(1) VARCHAR2(1) NOT NULL Currency Translation Ledger

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	ASSET_ID	Character(12)	VARCHAR2(12) NOT NULL	Asset Identification
3	BOOK	Character(10)	VARCHAR2(10) NOT NULL	Asset Book Name
4	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
5	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.
6	PRIMARY_LEDGER	Character(1)	VARCHAR2(1) NOT NULL	A flag that indicates whether or not (Y or N) a ledger is designated as the primary ledger in a ledger group.
7	TRANSL_LEDGER	Character(1)	VARCHAR2(1) NOT NULL	Currency Translation Ledger