| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
AE_APPLID |
Character(12) |
VARCHAR2(12) NOT NULL |
Program Name (see PSAEAPPLDEFN).
|
| 3 |
AE_SECTION |
Character(8) |
VARCHAR2(8) NOT NULL |
Section
|
| 4 |
SETID_LEDGER |
Character(5) |
VARCHAR2(5) NOT NULL |
Ledger Table Setid
|
| 5 |
SETID_CALENDAR |
Character(5) |
VARCHAR2(5) NOT NULL |
Calendar Setid
|
| 6 |
SETID_SOURCE |
Character(5) |
VARCHAR2(5) NOT NULL |
Source Setid
|
| 7 |
SETID_APPL_ID |
Character(5) |
VARCHAR2(5) NOT NULL |
Journal Template SETID
|
| 8 |
SETID_LEDGERCODE |
Character(5) |
VARCHAR2(5) NOT NULL |
Ledger Code Setid
|
| 9 |
BUSINESS_UNIT_GL |
Character(5) |
VARCHAR2(5) NOT NULL |
GL Business Unit
|
| 10 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 11 |
LEDGER_GROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
Ledger Group
|
| 12 |
UPD_OPENPER |
Character(1) |
VARCHAR2(1) NOT NULL |
Update Open Periods options - By Ledger Group or By Ledger Code
C=By Ledger Code
G=By Ledger Group
|
| 13 |
BOOK_CODE |
Character(4) |
VARCHAR2(4) NOT NULL |
Book Code
|
| 14 |
CALENDAR_ID |
Character(2) |
VARCHAR2(2) NOT NULL |
Calendar ID
|
| 15 |
OPEN_YEAR_FROM |
Number(4,0) |
SMALLINT NOT NULL |
Open Year From
|
| 16 |
OPEN_PERIOD_FROM |
Number(3,0) |
SMALLINT NOT NULL |
Open Period From
|
| 17 |
OPEN_YEAR_TO |
Number(4,0) |
SMALLINT NOT NULL |
Open Year To
|
| 18 |
OPEN_PERIOD_TO |
Number(3,0) |
SMALLINT NOT NULL |
Open Period To
|
| 19 |
FROM_BEGIN_DT |
Date(10) |
DATE |
Journal Generator date range date.
|
| 20 |
FROM_END_DT |
Date(10) |
DATE |
Journal Generator date range date.
|
| 21 |
TO_BEGIN_DT |
Date(10) |
DATE |
Journal Generator date range date.
|
| 22 |
TO_END_DT |
Date(10) |
DATE |
Journal Generator date range date.
|
| 23 |
FROM_DATE |
Date(10) |
DATE |
From Date
|
| 24 |
TO_DATE |
Date(10) |
DATE |
To Date
|
| 25 |
DEFAULT_LEDGER_GRP |
Character(1) |
VARCHAR2(1) NOT NULL |
Jrnl Generator Dflt Ledger Grp
|
| 26 |
SEPARATE_DRCR |
Character(1) |
VARCHAR2(1) NOT NULL |
Enable Separate Debit/Credit
|
| 27 |
JRNL_FOREIGN_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Foreign Currencies per Journal
D=Default to Higher Level Value
M=Multiple Foreign Currencies
N=No Foreign Currencies
O=Only One Foreign Currency
|
| 28 |
ALTACCT_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Enable Alternate Account
|
| 29 |
JRNL_FORGN_OPTN_BU |
Character(1) |
VARCHAR2(1) NOT NULL |
Foreign Currency Option BU
D=Default to Higher Level Value
M=Multiple Foreign Currencies
N=No Foreign Currencies
O=Only One Foreign Currency
|
| 30 |
BASE_CURRENCY |
Character(3) |
VARCHAR2(3) NOT NULL |
"Specifies the primary currency for a general ledger business unit, and is sometimes referred to as the ""book"" currency. Each business unit has one base currency. which is usually, but not always, the local currency for the organization. Journal entries are posted to a business unit in its base currency. "
|
| 31 |
DOC_SEQ |
Character(1) |
VARCHAR2(1) NOT NULL |
Enable Document Sequencing
|
| 32 |
POST_DATE_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Journal Process Date Option
C=Current Date
P=Process Date
|
| 33 |
PROCESS_DATE |
Date(10) |
DATE |
Process Date
|
| 34 |
TRANSL_LEDGER |
Character(1) |
VARCHAR2(1) NOT NULL |
Currency Translation Ledger
|
| 35 |
LEDGER_TEMPLATE |
Character(10) |
VARCHAR2(10) NOT NULL |
Ledger Template
|
| 36 |
LEDGERS_SYNC |
Character(1) |
VARCHAR2(1) NOT NULL |
Keep Ledgers in Sync
|
| 37 |
SECOND_LEDGERS |
Character(1) |
VARCHAR2(1) NOT NULL |
Secondary Ledgers Exist
|
| 38 |
RECNAME_JRNL_HDR |
Character(15) |
VARCHAR2(15) NOT NULL |
Journal Header
|
| 39 |
RECNAME_JRNL_LN |
Character(15) |
VARCHAR2(15) NOT NULL |
Journal Line
|
| 40 |
RECNAME_JRNLGEN |
Character(15) |
VARCHAR2(15) NOT NULL |
Jrnl Gen Tmp
|
| 41 |
FIELDNAME_ACCOUNT |
Character(18) |
VARCHAR2(18) NOT NULL |
Account
|
| 42 |
FIELDNAME_MON_AMT |
Character(18) |
VARCHAR2(18) NOT NULL |
Monetary Amount
|
| 43 |
FIELDNAME_STAT_AMT |
Character(18) |
VARCHAR2(18) NOT NULL |
Statistical Amount
|
| 44 |
LEDGER |
Character(10) |
VARCHAR2(10) NOT NULL |
Ledger
|
| 45 |
INHERIT_BASE_CUR |
Character(1) |
VARCHAR2(1) NOT NULL |
Inherit Base Currency
|
| 46 |
BASE_CURRENCY_LED |
Character(3) |
VARCHAR2(3) NOT NULL |
Ledger Base Currency
|
| 47 |
APPL_JRNL_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Journal Template
|
| 48 |
EFFDT |
Date(10) |
DATE |
Effective Date
|
| 49 |
JOURNAL_ID_MASK |
Character(6) |
VARCHAR2(6) NOT NULL |
Journal ID Mask
|
| 50 |
JRNL_DT_OPTN |
Character(2) |
VARCHAR2(2) NOT NULL |
Journal Date Option
A=Accounting Date on Transaction
BF=Begin Date - From Period
BT=Begin Date - To Period
C=Current Date
EF=End Date - From Period
ET=End Date - To Period
PR=Process Date
PT=Period End - Accounting Date
S=Specify Date
|
| 51 |
JOURNAL_DATE |
Date(10) |
DATE |
Specifies the date the journal was created.
|
| 52 |
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.
|
| 53 |
JRNL_DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Journal Description
|
| 54 |
LINE_DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Describes the nature of a journal line. It is defaulted from the description of the Account ChartField or manually entered.
|
| 55 |
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.
|
| 56 |
JRNL_LN_REF |
Character(10) |
VARCHAR2(10) NOT NULL |
Identifies a document, person, invoice, date, or any other piece of information that is associated with a journal line. It can be manually entered, or be defaulted from an accounting entry definition or from a Journal Generator Template. The journal line reference is optional, but helpful if you need to trace back to the source of the transaction.
|
| 57 |
HOW_SPECIFY |
Character(1) |
VARCHAR2(1) NOT NULL |
How Specified Option
A=Summarize to Account, AltAcct
C=Summarize to All ChartFields
D=Retain Detail
S=Summarize by Selected CF's
|
| 58 |
ACCOUNT_SPECIFY |
Character(1) |
VARCHAR2(1) NOT NULL |
How Account Specified
1=All Account Values
2=Selected Account Values
3=Selected Tree Nodes
|
| 59 |
DEFAULT_SPECIFY |
Character(1) |
VARCHAR2(1) NOT NULL |
How Default Specified
A=Summarize to Account, AltAcct
C=Summarize to All ChartFields
D=Retain Detail
S=Summarize by Selected CF's
|
| 60 |
TREE_NAME |
Character(18) |
VARCHAR2(18) NOT NULL |
Tree Name
|
| 61 |
TREE_LEVEL |
Character(10) |
VARCHAR2(10) NOT NULL |
Tree Level Number
|
| 62 |
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
|
| 63 |
ENTRY_SYNC |
Character(1) |
VARCHAR2(1) NOT NULL |
Accounting Entry In Sync
|
| 64 |
BUS_UNIT_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Journal Generator Group By option
A=Application Business Unit
G=General Ledger Business Unit
|
| 65 |
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.
|
| 66 |
JRNL_DT_ALT_OPTN |
Character(2) |
VARCHAR2(2) NOT NULL |
Alternate Journal Date Option
BF=Begin Date - From Period
BT=Begin Date - To Period
EF=End Date - From Period
ET=End Date - To Period
RD=Retain Primary Journal Date
|
| 67 |
STAY_IN_PERIOD |
Character(1) |
VARCHAR2(1) NOT NULL |
Stay in Period Date
|
| 68 |
CURR_EFFDT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Currency Effective Date
A=ADB Date
J=Journal Date
|
| 69 |
DOC_TYPE_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Document Type Option
D=Default to Higher Level Value
S=Specify
|
| 70 |
DOC_TYPE_GL |
Character(8) |
VARCHAR2(8) NOT NULL |
GL Document Type
|
| 71 |
ADB_DATE_EXISTS |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicates if the field ADB_DATE exists in the application's accounting record. Used by Journal Generator.
|
| 72 |
DOC_TYPE_EXISTS |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicates if the field DOC_TYPE exists in the application's accounting record. Used by Journal Generator.
|
| 73 |
KK_TYPE_EXISTS |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicates if the field KK_AMOUNT_TYPE exists in the application's accounting record. Used by Journal Generator.
|
| 74 |
ADJ_ENT_EXISTS |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicates if the field ADJUSTING_ENTRY exists in the application's accounting record. Used by Journal Generator.
|
| 75 |
BUSINESS_UNIT_LAST |
Character(5) |
VARCHAR2(5) NOT NULL |
Last Business_Unit
|
| 76 |
RECNAME_JNLN_TMP |
Character(15) |
VARCHAR2(15) NOT NULL |
Closing Journal Line Tmp
|
| 77 |
SYSTEM_DATE |
Date(10) |
DATE |
System Date
|
| 78 |
AE_APPSTATUS |
Number(1,0) |
SMALLINT NOT NULL |
AE Application Warning Status
|