| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 LEDGER_TEMPLATE |
Character(10) |
VARCHAR2(10) NOT NULL |
Ledger Template
|
| 2 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 3 |
LEDGER_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Ledger Type
D=Detail Ledger
K=Commitment Control Ledger
S=Summary Ledger
Default Value: D
|
| 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
Default Value: G
|
| 5 |
RECNAME |
Character(15) |
VARCHAR2(15) NOT NULL |
Record (Table) Name (see PSRECDEFN).
Prompt Table:
RECDEFN_VW
|
| 6 |
RECNAME_LED_TMP |
Character(15) |
VARCHAR2(15) NOT NULL |
Ledger Tmp
Prompt Table:
RECDEFN_VW
|
| 7 |
RECNAME_LED_TMP1 |
Character(15) |
VARCHAR2(15) NOT NULL |
Ledger Tmp1
Prompt Table:
RECDEFN_VW
|
| 8 |
RECNAME_LED_TMP2 |
Character(15) |
VARCHAR2(15) NOT NULL |
Ledger Tmp2
Prompt Table:
RECDEFN_VW
|
| 9 |
RECNAME_JRNL_HDR |
Character(15) |
VARCHAR2(15) NOT NULL |
Journal Header
Prompt Table:
RECDEFN_VW
|
| 10 |
RECNAME_JHDR_TMP |
Character(15) |
VARCHAR2(15) NOT NULL |
Journal Header Tmp
Prompt Table:
RECDEFN_VW
|
| 11 |
RECNAME_JRNL_LN |
Character(15) |
VARCHAR2(15) NOT NULL |
Journal Line
Prompt Table:
RECDEFN_VW
|
| 12 |
RECNAME_JRNL_TMP |
Character(15) |
VARCHAR2(15) NOT NULL |
Journal Line Tmp
Prompt Table:
RECDEFN_VW
|
| 13 |
RECNAME_RPTG_VW |
Character(15) |
VARCHAR2(15) NOT NULL |
Secured Rptg Vw
Prompt Table:
RECDEFN_VW
|
| 14 |
RECNAME_ACCOUNT |
Character(15) |
VARCHAR2(15) NOT NULL |
Account ChartField
Prompt Table:
RECDEFN_VW
|
| 15 |
RECNAME_ADB_LED |
Character(15) |
VARCHAR2(15) NOT NULL |
ADB Ledger
Prompt Table:
RECDEFN_VW
|
| 16 |
RECNAME_ADBADJ_HLD |
Character(15) |
VARCHAR2(15) NOT NULL |
ADB Ledger Adj. Holding Tbl
Prompt Table:
RECDEFN_VW
|
| 17 |
RECNM_ADBADJ_HLD2 |
Character(15) |
VARCHAR2(15) NOT NULL |
ADB Ledger Adj. Holding Tbl 2
Prompt Table:
RECDEFN_VW
|
| 18 |
RECNAME_ADBLD_TAO |
Character(15) |
VARCHAR2(15) NOT NULL |
Ledger ADB Tmp
Prompt Table:
RECDEFN_VW
|
| 19 |
RECNAME_ADBLD_TAO2 |
Character(15) |
VARCHAR2(15) NOT NULL |
Ledger ADB Tmp2
Prompt Table:
RECDEFN_VW
|
| 20 |
RECNAME_ADBLD_TAO3 |
Character(15) |
VARCHAR2(15) NOT NULL |
Ledger ADB Tmp3
Prompt Table:
RECDEFN_VW
|
| 21 |
RECNAME_ADBLD_TAO4 |
Character(15) |
VARCHAR2(15) NOT NULL |
Ledger ADB Tmp4
Prompt Table:
RECDEFN_VW
|
| 22 |
RECNAME_JRNLGEN |
Character(15) |
VARCHAR2(15) NOT NULL |
Jrnl Gen Tmp
Prompt Table:
RECNAME_JGEN_VW
|
| 23 |
RECNAME_CONSOL_LOG |
Character(15) |
VARCHAR2(15) NOT NULL |
Consolidations Log
Prompt Table:
RECDEFN_VW
|
| 24 |
RECNAME_CONS_EQTY |
Character(15) |
VARCHAR2(15) NOT NULL |
Consolidation Work Table for holding Equity Amounts
Prompt Table:
RECDEFN_VW
|
| 25 |
RECNAME_CURR_LOG |
Character(15) |
VARCHAR2(15) NOT NULL |
MultiCurrency Log
Prompt Table:
RECDEFN_VW
|
| 26 |
RECNAME_CURR_WRK |
Character(15) |
VARCHAR2(15) NOT NULL |
MultiCurrency Tmp
Prompt Table:
RECDEFN_VW
|
| 27 |
RECNAME_CUR_WRK1 |
Character(15) |
VARCHAR2(15) NOT NULL |
MultiCurrency Tmp1
Prompt Table:
RECDEFN_VW
|
| 28 |
RECNAME_CLOSE_LOG |
Character(15) |
VARCHAR2(15) NOT NULL |
Closing Log
Prompt Table:
RECDEFN_VW
|
| 29 |
RECNAME_CLOSE_TMP |
Character(15) |
VARCHAR2(15) NOT NULL |
Closing Tmp
Prompt Table:
RECDEFN_VW
|
| 30 |
RECNAME_EARN_TMP |
Character(15) |
VARCHAR2(15) NOT NULL |
Closing RE Tmp
Prompt Table:
RECDEFN_VW
|
| 31 |
RECNAME_CLO_CF |
Character(15) |
VARCHAR2(15) NOT NULL |
Chartfield temp table for closing definitions
Prompt Table:
RECDEFN_VW
|
| 32 |
RECNAME_ACCT_TMP |
Character(15) |
VARCHAR2(15) NOT NULL |
Closing Account Tmp
Prompt Table:
RECDEFN_VW
|
| 33 |
RECNAME_JNHD_TMP |
Character(15) |
VARCHAR2(15) NOT NULL |
Closing Journal Header Tmp
Prompt Table:
RECDEFN_VW
|
| 34 |
RECNAME_JNLN_TMP |
Character(15) |
VARCHAR2(15) NOT NULL |
Closing Journal Line Tmp
Prompt Table:
RECDEFN_VW
|
| 35 |
RECNAME_JLN2_TMP |
Character(15) |
VARCHAR2(15) NOT NULL |
Temp table name for general ledger daily close
Prompt Table:
RECDEFN_VW
|
| 36 |
RECNAME_COMBO_DATA |
Character(15) |
VARCHAR2(15) NOT NULL |
Combination Data Table
Prompt Table:
RECDEFN_VW
|
| 37 |
RECNAME_FB_OPERAND |
Character(15) |
VARCHAR2(15) NOT NULL |
Flex Budgets Operands
Prompt Table:
RECDEFN_VW
|
| 38 |
RECNAME_FB_RESULT |
Character(15) |
VARCHAR2(15) NOT NULL |
Flex Budgets Results
Prompt Table:
RECDEFN_VW
|
| 39 |
RECNAME_BD_NOTE |
Character(15) |
VARCHAR2(15) NOT NULL |
Budgets Notes
Prompt Table:
RECDEFN_VW
|
| 40 |
RECNAME_BD_ITEM |
Character(15) |
VARCHAR2(15) NOT NULL |
Budgets Itemizations
Prompt Table:
RECDEFN_VW
|
| 41 |
RECNAME_BD_ASSET |
Character(15) |
VARCHAR2(15) NOT NULL |
Budgets Asset Data
Prompt Table:
RECDEFN_VW
|
| 42 |
RECNAME_BD_DEPR |
Character(15) |
VARCHAR2(15) NOT NULL |
Budgets Depreciation Data
Prompt Table:
RECDEFN_VW
|
| 43 |
RECNAME_BD_POSI |
Character(15) |
VARCHAR2(15) NOT NULL |
Budgets Position Data
Prompt Table:
RECDEFN_VW
|
| 44 |
FIELDNAME_TOTAL_NT |
Character(18) |
VARCHAR2(18) NOT NULL |
Posted Total Amount
Prompt Table:
RECFLDDB_VW
|
| 45 |
FIELDNAME_TOTAL_DR |
Character(18) |
VARCHAR2(18) NOT NULL |
Posted Total Debits
Prompt Table:
RECFLDDB_VW
|
| 46 |
FIELDNAME_TOTAL_CR |
Character(18) |
VARCHAR2(18) NOT NULL |
Posted Total Credits
Prompt Table:
RECFLDDB_VW
|
| 47 |
FIELDNAME_MON_AMT |
Character(18) |
VARCHAR2(18) NOT NULL |
Monetary Amount
Prompt Table:
RECFLD_JRNL_VW
|
| 48 |
FIELDNAME_STAT_AMT |
Character(18) |
VARCHAR2(18) NOT NULL |
Statistical Amount
Prompt Table:
RECFLD_JRNL_VW
|
| 49 |
FIELDNAME_ACCOUNT |
Character(18) |
VARCHAR2(18) NOT NULL |
Account
Prompt Table:
RECFLD_ACCT2_VW
|
| 50 |
COMBO_EDIT_TMPL |
Character(10) |
VARCHAR2(10) NOT NULL |
Record Template
Prompt Table:
COMBO_EDIT_TMPL
|
| 51 |
RECNAME_SLED_STG |
Character(15) |
VARCHAR2(15) NOT NULL |
Incremental Ledger Stage Tbl
Prompt Table:
RECDEFN_VW
|
| 52 |
RECNAME_LL_STG |
Character(15) |
VARCHAR2(15) NOT NULL |
Ledger Load Staging table
Prompt Table:
RECDEFN_VW
|
| 53 |
RECNAME_LL_TAO1 |
Character(15) |
VARCHAR2(15) NOT NULL |
Led Load Temp Record
Prompt Table:
RECDEFN_VW
|
| 54 |
RECNAME_LL_TAO2 |
Character(15) |
VARCHAR2(15) NOT NULL |
Led Load Temp Record
Prompt Table:
RECDEFN_VW
|
| 55 |
RECNAME_YTP |
Character(15) |
VARCHAR2(15) NOT NULL |
Ledger Year to Period
Prompt Table:
RECDEFN_VW
|
| 56 |
RECNAME_INCR_TAO |
Character(15) |
VARCHAR2(15) NOT NULL |
Incremental Ledger Tmp
Prompt Table:
RECDEFN_VW
|