RTBL_CAF_DFTPRS

(SQL Table)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SCE_ID Character(10) VARCHAR2(10) NOT NULL ID

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

3 LEDGER Character(10) VARCHAR2(10) NOT NULL Ledger
Prompt Table: SP_BUL_SD_NONVW

4 FISCAL_YEAR_FROM Number(4,0) SMALLINT NOT NULL Fiscal Year
Prompt Table: CAL_DETP_FY_VW

5 FISCAL_YEAR_TO Number(4,0) SMALLINT NOT NULL Range To Fiscal Year
Prompt Table: CAL_DETP_FY_VW

6 FROM_PERIOD Number(3,0) SMALLINT NOT NULL From Period
Prompt Table: CAL_DETP_ZRO_VW

7 TO_PERIOD Number(3,0) SMALLINT NOT NULL To Period
Prompt Table: CAL_DETP_ZRO_VW

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

9 INCLUDE_BAL_FRWD Character(1) VARCHAR2(1) NOT NULL Include Balance Forward
Y/N Table Edit
Default Value: N

10 ASOFDATE2 Date(10) DATE As of Date

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

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SCE_ID	Character(10)	VARCHAR2(10) NOT NULL	ID
2	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Prompt Table: SP_BU_GL_NONVW
3	LEDGER	Character(10)	VARCHAR2(10) NOT NULL	Ledger Prompt Table: SP_BUL_SD_NONVW
4	FISCAL_YEAR_FROM	Number(4,0)	SMALLINT NOT NULL	Fiscal Year Prompt Table: CAL_DETP_FY_VW
5	FISCAL_YEAR_TO	Number(4,0)	SMALLINT NOT NULL	Range To Fiscal Year Prompt Table: CAL_DETP_FY_VW
6	FROM_PERIOD	Number(3,0)	SMALLINT NOT NULL	From Period Prompt Table: CAL_DETP_ZRO_VW
7	TO_PERIOD	Number(3,0)	SMALLINT NOT NULL	To Period Prompt Table: CAL_DETP_ZRO_VW
8	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Prompt Table: CUR_CD_ALL_VW
9	INCLUDE_BAL_FRWD	Character(1)	VARCHAR2(1) NOT NULL	Include Balance Forward Y/N Table Edit Default Value: N
10	ASOFDATE2	Date(10)	DATE	As of Date
11	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.
12	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.