YTP_BALANCE_AET

(SQL Table)
 Index Back

State Record

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
3 ASOFDATE Date(10) DATE As of Date
4 TIME_SPAN Character(10) VARCHAR2(10) NOT NULL TimeSpan
5 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
6 LEDGER_GROUP Character(10) VARCHAR2(10) NOT NULL Ledger Group
7 ACCOUNT_TYPE Character(1) VARCHAR2(1) NOT NULL Identifies a category of accounts that appears on the balance sheet or income statement of the enterprise. Each general ledger account (ACCOUNT) is associated with an account type (also called a ""monetary account type""). PeopleSoft delivers standard account types such as asset, liability, expense, and revenue.
8 AE_APPLID Character(12) VARCHAR2(12) NOT NULL Program Name (see PSAEAPPLDEFN).
9 AE_SECTION Character(8) VARCHAR2(8) NOT NULL Section
10 SETID_BUS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit SetId
11 SETID_LEDGER_GROUP Character(5) VARCHAR2(5) NOT NULL Ledger Group SetID
12 SETID_CALENDAR Character(5) VARCHAR2(5) NOT NULL Calendar Setid
13 TIMESPAN_SETID Character(5) VARCHAR2(5) NOT NULL Time Span SetID
14 CALENDAR_ID Character(2) VARCHAR2(2) NOT NULL Calendar ID
15 SQL_TEXT_LONG Long Character(4000) CLOB Dynamic SQL string
16 WHERE_CLAUSE1 Character(254) VARCHAR2(254) NOT NULL Where Clause
17 WHERE_CLAUSE2 Character(254) VARCHAR2(254) NOT NULL Where Clause
18 LEDGER Character(10) VARCHAR2(10) NOT NULL Ledger
19 FISCAL_YEAR Number(4,0) SMALLINT NOT NULL Fiscal Year
20 ACCOUNTING_PERIOD Number(3,0) SMALLINT NOT NULL Identifies a time period to which you post transactions. Typically, an accounting period represents a month, but it can also represent a week, a day, or any user-defined interval. An accounting period has a beginning date and an ending date, and is defined in the calendar table.
21 DATETIME_STAMP DateTime(26) TIMESTAMP DateTime Stamp
22 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
23 RECNAME_YTP Character(15) VARCHAR2(15) NOT NULL Ledger Year to Period
24 OPEN_YEAR_FROM Number(4,0) SMALLINT NOT NULL Open Year From
25 OPEN_PERIOD_FROM Number(3,0) SMALLINT NOT NULL Open Period From
26 OPEN_PERIOD_TO Number(3,0) SMALLINT NOT NULL Open Period To
27 YEAR Character(4) VARCHAR2(4) NOT NULL Year
1=NONE
28 PERIOD Number(3,0) SMALLINT NOT NULL Period
29 YEAR_TO Character(4) VARCHAR2(4) NOT NULL To Year
1=NONE
30 PERIOD_TO Number(3,0) SMALLINT NOT NULL To Period
31 PSFT_PRODUCT Character(2) VARCHAR2(2) NOT NULL PeopleSoft Product
32 FLAG Character(1) VARCHAR2(1) NOT NULL Flag
N=No
Y=Yes
33 TABLENAME Character(30) VARCHAR2(30) NOT NULL Table Name
34 SETID Character(5) VARCHAR2(5) NOT NULL SetID
35 ALL_BU Character(1) VARCHAR2(1) NOT NULL All Business Units
N=Specific Business Unit
Y=All Business Units