FUS_LEDGER_MTBL

(SQL Table)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Prompt Table: SP_BU_GL_NONVW

2 LEDGER Character(10) VARCHAR2(10) NOT NULL Ledger
Prompt Table: SP_BU_LED_NONVW

3 REQUEST_NBR Number(4,0) SMALLINT NOT NULL Request Number
Default Value: 0

4 TRANSFER_ID Number(18,0) DECIMAL(18) NOT NULL Transfer ID
Default Value: 0

5 FUS_LEDGER_NAME Character(30) VARCHAR2(30) NOT NULL Fusion Ledger Name

6 COA_MAPPING_NAME Character(33) VARCHAR2(33) NOT NULL Fusion COA Mapping Name

7 FISCAL_YEAR Number(4,0) SMALLINT NOT NULL Fiscal Year
Default Value: 0

8 LAST_UPDATE_DTTM 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	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Prompt Table: SP_BU_GL_NONVW
2	LEDGER	Character(10)	VARCHAR2(10) NOT NULL	Ledger Prompt Table: SP_BU_LED_NONVW
3	REQUEST_NBR	Number(4,0)	SMALLINT NOT NULL	Request Number Default Value: 0
4	TRANSFER_ID	Number(18,0)	DECIMAL(18) NOT NULL	Transfer ID Default Value: 0
5	FUS_LEDGER_NAME	Character(30)	VARCHAR2(30) NOT NULL	Fusion Ledger Name
6	COA_MAPPING_NAME	Character(33)	VARCHAR2(33) NOT NULL	Fusion COA Mapping Name
7	FISCAL_YEAR	Number(4,0)	SMALLINT NOT NULL	Fiscal Year Default Value: 0
8	LAST_UPDATE_DTTM	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.