| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_FS.SETID
|
| 2 |
PROCESS_STEP |
Character(10) |
VARCHAR2(10) NOT NULL |
Process Step
|
| 3 |
VERSION_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Version Number
Default Value: 0
|
| 4 |
EFFDT |
Date(10) |
DATE NOT NULL |
Effective Date
Default Value: %date
|
| 5 |
EFF_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Effective Status
A=Active
I=Inactive
Default Value: A
|
| 6 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 7 |
BUDGET_COPY |
Character(1) |
VARCHAR2(1) NOT NULL |
Budget Copy Flag
Y/N Table Edit
Default Value: N
|
| 8 |
ALLOC_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Allocation Type
1=Spread Evenly
2=Arithmetic Operation
3=Prorata with Record Basis
4=Allocate on Fixed Basis
5=Copy
Default Value: 3
|
| 9 |
EXTENSION_OPCODE |
Character(1) |
VARCHAR2(1) NOT NULL |
Extension opcode
1=Add
2=Subtract
3=Multiply
4=Divide
Default Value: 1
|
| 10 |
POOL_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Pool Record Type
F=Fixed Amount
L=Ledger Group
T=Any Table
Default Value: L
|
| 11 |
POOL_FACTOR |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Pool factor
Default Value: 100
|
| 12 |
POOL_LEDGER |
Character(10) |
VARCHAR2(10) NOT NULL |
Pool Ledger
Prompt Table:
SP_LGRP_A_NONVW
|
| 13 |
POOL_TIME_SPAN |
Character(10) |
VARCHAR2(10) NOT NULL |
Pool Time Span
Prompt Table:
TIME_SPANS
|
| 14 |
POOL_RECNAME |
Character(15) |
VARCHAR2(15) NOT NULL |
Pool Table Record Name
Prompt Table:
RECDEFN_VW
|
| 15 |
BASIS_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Basis Record Type
L=Ledger Group
T=Any Table
Default Value: L
|
| 16 |
BASIS_FACTOR |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Basis factor
Default Value: 100
|
| 17 |
BASIS_LEDGER |
Character(10) |
VARCHAR2(10) NOT NULL |
Basis Ledger
Prompt Table:
SP_LGRP_A_NONVW
|
| 18 |
BASIS_TIME_SPAN |
Character(10) |
VARCHAR2(10) NOT NULL |
Basis Time Span
Prompt Table:
TIME_SPANS
|
| 19 |
BASIS_SPAN_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Basis TimeSpan Option
C=Combine Periods for Basis
S=Split Basis by Period
Default Value: C
|
| 20 |
BASIS_RECNAME |
Character(15) |
VARCHAR2(15) NOT NULL |
Basis Table Record Name
Prompt Table:
RECDEFN_VW
|
| 21 |
DISTR_ODD_CENTS |
Character(1) |
VARCHAR2(1) NOT NULL |
Distribute Odd Cents options used in GL allocations
F=First Target Line
L=Last Target Line
M=Largest Target
S=Specify Chartfields
Default Value: F
|
| 22 |
ALLOC_ROUND_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Allocations rounding options
1=Normal
2=Round Up
3=Round Down
4=Truncate
Default Value: 1
|
| 23 |
TARGET_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Target Record Type
J=Journal Records
T=Any Table
Default Value: J
|
| 24 |
TARGET_LEDGER |
Character(10) |
VARCHAR2(10) NOT NULL |
Target Ledger
Prompt Table:
SP_LGRP_A_NONVW
|
| 25 |
TARGET_TIME_SPAN |
Character(10) |
VARCHAR2(10) NOT NULL |
Target Time Span
Prompt Table:
TIME_SPANS
|
| 26 |
TARGET_SPAN_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Target TimeSpan Option
D=Divide Target Across Periods
R=Repeat Target Each Period
Default Value: D
|
| 27 |
TARGET_RECNAME |
Character(15) |
VARCHAR2(15) NOT NULL |
Target Table Record Name
Prompt Table:
RECDEFN_VW
|
| 28 |
OFFSET_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Offset Record Type
J=Journal Records
T=Any Table
|
| 29 |
OFFSET_LEDGER |
Character(10) |
VARCHAR2(10) NOT NULL |
Offset Ledger
Prompt Table:
SP_LGRP_A_NONVW
|
| 30 |
OFFSET_RECNAME |
Character(15) |
VARCHAR2(15) NOT NULL |
Offset Table Record Name
Prompt Table:
RECDEFN_VW
|
| 31 |
JOURNAL_ID_MASK |
Character(6) |
VARCHAR2(6) NOT NULL |
Journal ID Mask
Default Value: NEXT
|
| 32 |
JOURNAL_DATE_CD |
Character(1) |
VARCHAR2(1) NOT NULL |
Journal Date Code
B=Beginning of the Period
E=End of the Period
R=Request As of Date
Default Value: R
|
| 33 |
MSGTP_NO_JRNL |
Character(1) |
VARCHAR2(1) NOT NULL |
When No Journals are Created
E=Issue Error Message
W=Issue Warning Message
Default Value: E
|
| 34 |
SOURCE |
Character(3) |
VARCHAR2(3) NOT NULL |
Identifies the origin of a journal entry and defines journal entry error handling options. The journal source provides a means of selectively tracking, reporting, and inquiring on journal entries. It can be almost anything within the enterprise - a subsystem that generates transactions, a department, or even an individual.
Prompt Table:
SOURCE_TBL
|
| 35 |
TRANS_REF_NUM |
Character(8) |
VARCHAR2(8) NOT NULL |
Identifies a document, person, invoice, date, or any other piece of information that is associated with a journal entry. The journal reference is helpful if you need to trace back to the source of the transaction.
|
| 36 |
REVERSAL_CD |
Character(1) |
VARCHAR2(1) NOT NULL |
A flag that indicates if a journal entry should be automatically reversed, and if so, with what date. When associated with a reversal entry, it indicates that the entry was created automatically by the reversal process.
B=Beginning of Next Period
D=On Date Specified By User
E=End of Next Period
N=Do Not Generate Reversal
R=Created by Reversal Process
U=Adjustment Period
X=Next Day
Default Value: N
|
| 37 |
REVERSAL_DATE |
Date(10) |
DATE |
Specifies the date for an automatic reversal journal entry. The date must be within the calendar of the target (posting) ledger. PeopleSoft General Ledger automatically creates and populates a journal entry with this date.
|
| 38 |
REVERSAL_ADJ_PER |
Number(3,0) |
SMALLINT NOT NULL |
Adjustment Period
Prompt Table:
CAL_ADJP_TBL
|
| 39 |
REVERSAL_CD_ADB |
Character(1) |
VARCHAR2(1) NOT NULL |
ADB Reversal Code
D=On Date Specified By User
S=Same As Journal Reversal
Default Value: S
|
| 40 |
REVERSAL_DATE_ADB |
Date(10) |
DATE |
ADB Reversal Date
|
| 41 |
CUR_RT_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Currency Rate Type
Prompt Table:
RT_TYPE_VW
|
| 42 |
CUR_EFFDT_CD |
Character(1) |
VARCHAR2(1) NOT NULL |
Currency Effective Date Code
J=Jrnl Date
R=Req Date
Default Value: J
|
| 43 |
UPDATE_LEDGER_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Update Ledger Directly
Y/N Table Edit
Default Value: N
|
| 44 |
JRNL_EDIT_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Edit Journal(s)
Y/N Table Edit
Default Value: N
|
| 45 |
JRNL_BGTCHK_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Journal Budget Check option. Used in Journal Edit request or other GL processes (e.g. Allocations, Closing, Revaluation, ...) to flag if journals will be budget checked after they are edited valid.
Y/N Table Edit
Default Value: N
|
| 46 |
TABLE_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Table Output Option
R=Replace Existing Amounts
U=Update Existing Amounts
Default Value: U
|
| 47 |
MULTI_PD_BASIS |
Character(1) |
VARCHAR2(1) NOT NULL |
Multiple Period Basis Flag
Y/N Table Edit
Default Value: N
|
| 48 |
MULTI_PD_TGT |
Character(1) |
VARCHAR2(1) NOT NULL |
Multiple Period Target Flag
Y/N Table Edit
Default Value: N
|
| 49 |
INTER_UNIT_ALLOC |
Character(1) |
VARCHAR2(1) NOT NULL |
Inter/IntraUnit indicator
Y/N Table Edit
Default Value: N
|
| 50 |
ZERO_AMT_BASIS |
Character(1) |
VARCHAR2(1) NOT NULL |
Zero Basis Amount Option
B=Select Next Basis
C=Calculate This Basis
N=Calc. No Rows as Zero
S=Stop Processing
Default Value: S
|
| 51 |
ZERO_AMT_POOL |
Character(1) |
VARCHAR2(1) NOT NULL |
Zero Pool Amount Option
C=Calculate This Pool
N=Calc. No Rows as Zero
P=Select Next Pool
S=Stop Processing
Default Value: P
|
| 52 |
RECNAME_ALLOC_LOG |
Character(15) |
VARCHAR2(15) NOT NULL |
Allocation Calc Log
Default Value: ALLOC_CALC_LOG
Prompt Table:
RECDEFN_VW
|
| 53 |
RECNAME_CLOG_TAO |
Character(15) |
VARCHAR2(15) NOT NULL |
Calculation log record name
Default Value: ALC_CLOG_TAO
Prompt Table:
RECDEFN_VW
|
| 54 |
RECNAME_ALLOC_TMP |
Character(15) |
VARCHAR2(15) NOT NULL |
Allocation Tmp
Default Value: ALC_GL_B_TAO
Prompt Table:
RECDEFN_VW
|
| 55 |
RECNAME_ALLOC_WRK |
Character(15) |
VARCHAR2(15) NOT NULL |
Target/Offset Working Record
Default Value: ALC_GL_T_TAO
Prompt Table:
RECDEFN_VW
|
| 56 |
RECNAME_OFFSET_TAO |
Character(15) |
VARCHAR2(15) NOT NULL |
Target balance record name
Default Value: ALC_GL_O_TAO
Prompt Table:
RECDEFN_VW
|
| 57 |
RECNAME_TSUM_TAO |
Character(15) |
VARCHAR2(15) NOT NULL |
Target balance record name
Default Value: ALC_GL_TS_TAO
Prompt Table:
RECDEFN_VW
|
| 58 |
RECNAME_OSUM_TAO |
Character(15) |
VARCHAR2(15) NOT NULL |
Target balance record name
Default Value: ALC_GL_OS_TAO
Prompt Table:
RECDEFN_VW
|
| 59 |
RECNAME_POOL_TAO |
Character(15) |
VARCHAR2(15) NOT NULL |
Pool Temporary Table
Default Value: ALC_GL_P_TAO
Prompt Table:
RECDEFN_VW
|
| 60 |
RECNAME_BSUM_TAO |
Character(15) |
VARCHAR2(15) NOT NULL |
Basis Summary Temp Table
Default Value: ALC_GL_BS_TAO
Prompt Table:
RECDEFN_VW
|
| 61 |
RECNAME_TBAL_TAO |
Character(15) |
VARCHAR2(15) NOT NULL |
Target balance record name
Default Value: ALC_GL_TB_TAO
Prompt Table:
RECDEFN_VW
|
| 62 |
DOC_TYPE |
Character(8) |
VARCHAR2(8) NOT NULL |
Specifies the business purpose of a financial transaction in countries that require all financial transactions to be tracked as "documents". A Document Type is associated with one and only one Journal Code.
Prompt Table:
DOC_TYPE_A_VW
|
| 63 |
BYPASS_VAT |
Character(1) |
VARCHAR2(1) NOT NULL |
Bypass VAT Processing
Y/N Table Edit
Default Value: Y
|
| 64 |
ADJUSTING_ENTRY |
Character(1) |
VARCHAR2(1) NOT NULL |
Adjusting Entry
C=Fiscal Year Close
N=Non-Adjusting Entry
Y=Adjusting Entry
Default Value: N
|
| 65 |
IU_TRAN_CD |
Character(8) |
VARCHAR2(8) NOT NULL |
Transaction Codes are user-defined. They are mapped to the delivered System Transactions. InterUnit and IntraUnit Templates are keyed by Transaction code, allowing users to vary their accounting by transaction.
Default Value: GL_IU_TR_DFT_VW.IU_TRAN_CD
Prompt Table:
GL_IU_TR_MAP_VW
|
| 66 |
KK_BUDG_TRANS_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Budget Entry Type
0=Original
1=Adjustment
2=Transfer Adjustment
3=Transfer Original
4=Closing
5=Roll Forward
Default Value: 0
|
| 67 |
KK_AMOUNT_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Commitment Control Amount Type
0=Budget
1=Actuals and Recognized
2=Encumbrance
3=Pre-Encumbrance
4=Collected Revenue
5=Planned
7=Actuals, Recognize and Collect
9=Dynamic
Default Value: 1
|
| 68 |
KK_TRAN_BYPAS_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Bypass Budget Checking
Y/N Table Edit
Default Value: N
|
| 69 |
KK_TRAN_OVER_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Commitment Control source transaction override flag
N=No
Y=Yes
Default Value: N
|
| 70 |
KK_TRAN_OVER_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Commitment Control source transaction override operator
|
| 71 |
KK_TRAN_OVER_DTTM |
DateTime(26) |
TIMESTAMP |
Commitment Control source transaction override datetime
|
| 72 |
KK_GEN_PARENT |
Character(1) |
VARCHAR2(1) NOT NULL |
Yes/No Indicator - Generate Parent Budgets
Y/N Table Edit
Default Value: N
|
| 73 |
KK_DEFAULT_EE |
Character(1) |
VARCHAR2(1) NOT NULL |
Yes/No Indicator - Use Default Entry Event
Y/N Table Edit
Default Value: N
|
| 74 |
KK_PARENT_ENT_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicator - Parent Budget Entry Type
0=Original
1=Adjustment
2=Transfer Adjustment
3=Transfer Original
|
| 75 |
DEPLOYED |
Character(1) |
VARCHAR2(1) NOT NULL |
Identify whether an element has been deployed or not.
N=No
Y=Yes
Y/N Table Edit
Default Value: N
|