| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
REQUEST_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Request ID
|
| 3 |
PROCESS_FREQUENCY |
Character(1) |
VARCHAR2(1) NOT NULL |
Process Frequency
A=Always Process
N=Don't Run
O=Process Once
|
| 4 |
SYSTEM_SOURCE |
Character(3) |
VARCHAR2(3) NOT NULL |
Identifies the application or source system that generated a journal entry.
Release 8.80 - 11/14/2002 - RVlasic - Removed GDM (JrnlGen - Deduction Management) from Translate Values.
SUJ---Included a label as Product.
Release 8.9 - 05/11/2005 - RVlasic - Added PRV (Variance Pricing) and PKK (KK Budget Journal) and deleted GLK for Project Costing per Brian Cohen.
|
| 5 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
Prompt Table:
SP_BU_AM_NONVW
|
| 6 |
BOOK |
Character(10) |
VARCHAR2(10) NOT NULL |
Asset Book Name
Prompt Table:
SP_BOOKB3_NONVW
|
| 7 |
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. "
|
| 8 |
FROM_ASSET_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
From Asset ID
Prompt Table:
ASSET
|
| 9 |
TO_ASSET_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
To Asset ID
Prompt Table:
ASSET
|
| 10 |
DOCUMENT_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Document Type
123=Lotus 1-2-3
AVI=Video for Windows
CAD=AutoCad Document
DOC=Microsoft Winword
MPP=MicroSoft Project
NON=No Document Type
PST=PeopleSoft PeopleTools
SCR=Lotus ScreenCam
TLP=TimeLine for Windows
TXT=Notepad for ASCII Text
XLS=Microsoft Excel
|
| 11 |
RATE_DIV |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
Rate Divisor
|
| 12 |
RATE_MULT |
Signed Number(17,8) |
DECIMAL(15,8) NOT NULL |
Rate Multiplier
|
| 13 |
RT_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.
|
| 14 |
RATE_EFFDT |
Date(10) |
DATE |
Rate Effective Date
|
| 15 |
RATE_INDEX |
Character(10) |
VARCHAR2(10) NOT NULL |
Rate index
|
| 16 |
LOOP_COUNT |
Number(4,0) |
SMALLINT NOT NULL |
Number of Program Loops
|
| 17 |
PREV_BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Previous Business Unit
|
| 18 |
PREV_BOOK |
Character(10) |
VARCHAR2(10) NOT NULL |
Previous Book
|
| 19 |
PRIMARY_BOOK |
Character(10) |
VARCHAR2(10) NOT NULL |
AM Primary Book
|
| 20 |
PRIMARY_BOOK_CURR |
Character(3) |
VARCHAR2(3) NOT NULL |
Primary Book Currency
|
| 21 |
BOOK_BASE_CURR |
Character(3) |
VARCHAR2(3) NOT NULL |
Base Currency
|
| 22 |
OTHER_BOOKS_CHCKD |
Character(1) |
VARCHAR2(1) NOT NULL |
Other Books Checked
|
| 23 |
FIRST_TIME |
Character(1) |
VARCHAR2(1) NOT NULL |
First time through process
|
| 24 |
SETID_LEDGER_GROUP |
Character(5) |
VARCHAR2(5) NOT NULL |
Ledger Group SetID
|
| 25 |
CUR_LEDGER_GROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
Current Ledger Group
|
| 26 |
HAS_OTHER_BOOKS |
Character(1) |
VARCHAR2(1) NOT NULL |
Has Other Books?
|
| 27 |
TRANSL_LEDGER |
Character(1) |
VARCHAR2(1) NOT NULL |
Currency Translation Ledger
|
| 28 |
MORE_BOOKS_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
More Books?
|
| 29 |
SECONDARY_BOOK_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Secondary Book ?
|
| 30 |
BKC_DIST_GRP |
Character(10) |
VARCHAR2(10) NOT NULL |
Book Code Distribution Code
|
| 31 |
REQUEST_BOOK |
Character(10) |
VARCHAR2(10) NOT NULL |
Request Book
|
| 32 |
SETID_DIST_TMPLLN |
Character(5) |
VARCHAR2(5) NOT NULL |
Setid Dist_ln
|
| 33 |
ACCT_ENT_TMPL_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Account Entry Template ID
|
| 34 |
DEROGATORY_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Derogatory Depreciation
|
| 35 |
PAR_TRANS_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Types of Asset Management Transactions
ADD=Asset Addition
ADJ=Asset Cost Adjustment
BKS=Book Adjustment
BUD=Budgeted Depreciation
DPR=Depreciation
INF=Inflation Adjustment
LPB=Budgeted Lease Payments
LPY=Lease Payment
PDP=Prior Period Depreciation
RAD=Manual Reserve Adjustment
RCT=Asset Recategorization
REI=Asset Reinstatement
RES=Resume Depreciation
RET=Asset Retirement
RRC=Retro rate change for grp ast
SUS=Suspend Depreciation
TRF=Asset Transfer
|
| 36 |
LAST_BU |
Character(5) |
VARCHAR2(5) NOT NULL |
Last Business unit tagged
|
| 37 |
LAST_BK |
Character(10) |
VARCHAR2(10) NOT NULL |
Previous Book
|
| 38 |
DEF_LEDGER_GROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
Default Ledger Group
|
| 39 |
SETID_CAL_DETP |
Character(5) |
VARCHAR2(5) NOT NULL |
Calendar SetId
|
| 40 |
RT_RATE_INDEX |
Character(10) |
VARCHAR2(10) NOT NULL |
Market Rate Index
|
| 41 |
SETID_BOOK_DEFN |
Character(5) |
VARCHAR2(5) NOT NULL |
Book Definition SetId
|