BP_LED_UPDT_AET

(SQL Table)
Index Back

BP Ledger Export State Rec

BP Ledger Export State Rec

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
3 LEDGER Character(10) VARCHAR2(10) NOT NULL Ledger
4 DEFAULT_LEDGER Character(1) VARCHAR2(1) NOT NULL Default Ledger Type
A=ADB Reporting Ledger
B=Standard Budget Ledger
C=Commitment Control Ledger
G=Standard General Ledger
R=Project Budget Ledger
U=Commitment Budget Ledger
5 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
6 ALL_BU Character(1) VARCHAR2(1) NOT NULL All Business Units
N=Specific Business Unit
Y=All Business Units
7 AE_APPLID Character(12) VARCHAR2(12) NOT NULL Program Name (see PSAEAPPLDEFN).
8 AE_SECTION Character(8) VARCHAR2(8) NOT NULL Section
9 FISCAL_YEAR Number(4,0) SMALLINT NOT NULL Fiscal Year
10 SCENARIO Character(10) VARCHAR2(10) NOT NULL A unique key identifier that allows a treasury to classify distinct revaluation events as varying and divergent ca
11 BUDGET_PERIOD Character(8) VARCHAR2(8) NOT NULL Budget Period
12 BUDG_TYPE Character(1) VARCHAR2(1) NOT NULL Budget Type
E=Expense
R=Revenue
13 LEDGER_GROUP Character(10) VARCHAR2(10) NOT NULL Ledger Group
14 BP_LEDGER_NAME Character(30) VARCHAR2(30) NOT NULL Budget Ledger Name
15 BP_NO_OF_ROWS Number(10,0) DECIMAL(10) NOT NULL Number of rows
16 BP_STAGE_ROWS Number(10,0) DECIMAL(10) NOT NULL Number of Stage rows
17 ACCOUNT Character(10) VARCHAR2(10) NOT NULL Account
18 BP_BC_SKIP_FLG Character(1) VARCHAR2(1) NOT NULL Replace all Ledger Data

Y/N Table Edit

Default Value: N

19 BP_BC_CHARTFIELD1 Character(18) VARCHAR2(18) NOT NULL Budget Center Chartfield
20 BP_BC_CHARTFIELD2 Character(18) VARCHAR2(18) NOT NULL Budget Center Chartfield
21 WHERE_CLAUSE Character(254) VARCHAR2(254) NOT NULL Where Clause