REG_LED_DATAERR

(SQL Table)
 Index Back

Reg Ledger Data Error Table

Stores LEDGER rows that cannot be translated into the Regulatory Ledger ChartField structure

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT

Prompt Table: SP_BU_GL_NONVW

2 LEDGER Character(10) VARCHAR2(10) NOT NULL Ledger

Default Value: OPR_DEF_TBL_FS.LEDGER

Prompt Table: SP_BULEDD_NONVW

3 ACCOUNT Character(10) VARCHAR2(10) NOT NULL Account
4 ALTACCT Character(10) VARCHAR2(10) NOT NULL Alternate Account
5 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
6 OPERATING_UNIT Character(8) VARCHAR2(8) NOT NULL Operating Unit ChartField
7 PRODUCT Character(6) VARCHAR2(6) NOT NULL Product ChartField
8 FUND_CODE Character(5) VARCHAR2(5) NOT NULL Fund Code
9 CLASS_FLD Character(5) VARCHAR2(5) NOT NULL Class Field
10 PROGRAM_CODE Character(5) VARCHAR2(5) NOT NULL Program Code ChartField
11 BUDGET_REF Character(8) VARCHAR2(8) NOT NULL Budget Reference
12 AFFILIATE Character(5) VARCHAR2(5) NOT NULL Affiliate
13 AFFILIATE_INTRA1 Character(10) VARCHAR2(10) NOT NULL IntraUnit Affiliate1
14 AFFILIATE_INTRA2 Character(10) VARCHAR2(10) NOT NULL Operating Unit Affiliate
15 CHARTFIELD1 Character(10) VARCHAR2(10) NOT NULL Expansion chartfield 1
16 CHARTFIELD2 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 2
17 CHARTFIELD3 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 3
18 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField
19 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
20 STATISTICS_CODE Character(3) VARCHAR2(3) NOT NULL Statistics Code
21 FISCAL_YEAR Number(4,0) SMALLINT NOT NULL Fiscal Year
22 ACCOUNTING_PD_FROM Number(3,0) SMALLINT NOT NULL Range From Accounting Period
23 ACCOUNTING_PD_TO Number(3,0) SMALLINT NOT NULL Range To Accounting Period
24 BUDGET_PERIOD Character(8) VARCHAR2(8) NOT NULL Budget Period
25 REG_ENTITY Character(10) VARCHAR2(10) NOT NULL Regulatory Entity ID
26 REG_ENTRY_TYPE Character(2) VARCHAR2(2) NOT NULL External Entry Type for Regulatory Ledgers
F=Financial
FS=Financial and Statistical
S=Statistical
27 POSTED_TOTAL_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Specifies the net balance of debit and credit amounts that have been posted to a particular ChartField combination.
28 REG_BODY_ID Character(20) VARCHAR2(20) NOT NULL Reg Ledger - Regulatory Body ID
29 REG_LEDGER_ERR_CD Character(4) VARCHAR2(4) NOT NULL Regulatory Ledger Translation Error Code
ATTR=Missing Reg Led Acct Attribute
IVAL=Missing Reqd Internal CF Value
VMAP=Missing CF Value Mapping