| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
AE_SECTION |
Character(8) |
VARCHAR2(8) NOT NULL |
Section
|
| 3 |
PRIMARY_BOOK |
Character(10) |
VARCHAR2(10) NOT NULL |
AM Primary Book
|
| 4 |
PRIMARY_BOOK_CURR |
Character(3) |
VARCHAR2(3) NOT NULL |
Primary Book Currency
|
| 5 |
BOOK_BASE_CURR |
Character(3) |
VARCHAR2(3) NOT NULL |
Base Currency
|
| 6 |
OTHER_BOOKS_CHCKD |
Character(1) |
VARCHAR2(1) NOT NULL |
Other Books Checked
|
| 7 |
PREV_BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Previous Business Unit
|
| 8 |
PREV_BOOK |
Character(10) |
VARCHAR2(10) NOT NULL |
Previous Book
|
| 9 |
TRANSL_LEDGER |
Character(1) |
VARCHAR2(1) NOT NULL |
Currency Translation Ledger
Default Value: N
|
| 10 |
HAS_OTHER_BOOKS |
Character(1) |
VARCHAR2(1) NOT NULL |
Has Other Books?
|
| 11 |
SECONDARY_BOOK_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Secondary Book ?
|
| 12 |
MORE_BOOKS_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
More Books?
|
| 13 |
CUR_LEDGER_GROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
Current Ledger Group
|
| 14 |
DUMMY_FIELD |
Character(1) |
VARCHAR2(1) NOT NULL |
Dummy Field for Hiding Groups
|
| 15 |
LAST_BU |
Character(5) |
VARCHAR2(5) NOT NULL |
Last Business unit tagged
|
| 16 |
LAST_BK |
Character(10) |
VARCHAR2(10) NOT NULL |
Previous Book
|
| 17 |
SETID_LEDGER_GROUP |
Character(5) |
VARCHAR2(5) NOT NULL |
Ledger Group SetID
|
| 18 |
SETID_CAL_DETP |
Character(5) |
VARCHAR2(5) NOT NULL |
Calendar SetId
|
| 19 |
SETID_AM_OPT |
Character(5) |
VARCHAR2(5) NOT NULL |
Account Table Setid
|
| 20 |
SETID_DIST_TMPLLN |
Character(5) |
VARCHAR2(5) NOT NULL |
Setid Dist_ln
|
| 21 |
SETID_ACCOUNT |
Character(5) |
VARCHAR2(5) NOT NULL |
Account Table Setid
|
| 22 |
SETID_BOOK_DEFN |
Character(5) |
VARCHAR2(5) NOT NULL |
Book Definition SetId
|
| 23 |
LEASE_BOOK |
Character(10) |
VARCHAR2(10) NOT NULL |
Book used by Lease
|
| 24 |
LEASE_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Leased Assets
|
| 25 |
DEF_LEDGER_GROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
Default Ledger Group
|
| 26 |
DEROGATORY_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Derogatory Depreciation
|
| 27 |
LIKE_KIND_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Like Kind Exchange
|
| 28 |
REVALUATION_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Revaluation
|
| 29 |
SALE_ACCT_METHOD |
Character(1) |
VARCHAR2(1) NOT NULL |
Sale Accounting Method
G=Create Gain/Loss Lines
N=Create Net Book Value lines
|
| 30 |
LC_CNTRY |
Character(3) |
VARCHAR2(3) NOT NULL |
The local country.
|
| 31 |
TXN_AMOUNT_OVR |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Transaction Amount
|
| 32 |
TXN_CURR_CD_OVR |
Character(3) |
VARCHAR2(3) NOT NULL |
Transaction Currency
|
| 33 |
UPDT_SQL |
Character(1) |
VARCHAR2(1) NOT NULL |
Update SQL
|
| 34 |
SUM_GROUP_WHERE_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Sum Group Where SQL ID
|
| 35 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 36 |
BOOK |
Character(10) |
VARCHAR2(10) NOT NULL |
Asset Book Name
|
| 37 |
ASSET_ID_WHERE |
Character(30) |
VARCHAR2(30) NOT NULL |
Asset Id Where
|
| 38 |
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
|
| 39 |
ACCUM_WHERE |
Character(32) |
VARCHAR2(32) NOT NULL |
Asset Id Where
|
| 40 |
DEPR_ASSET_WHERE |
Character(30) |
VARCHAR2(30) NOT NULL |
Asset Id Where
|
| 41 |
GROUP_ASSET_ID_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Group Asset ID SW
|
| 42 |
IU_RECNAME |
Character(15) |
VARCHAR2(15) NOT NULL |
Record (Table) Name
|
| 43 |
IU_SYS_TRAN_CD |
Character(8) |
VARCHAR2(8) NOT NULL |
System Transactions are delivered system data, representing the activities that can require interunit or intraunit accounting entries.
|
| 44 |
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.
|
| 45 |
IAT_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.
|
| 46 |
IUT_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.
|
| 47 |
GROUP_ASSET_WHERE |
Character(30) |
VARCHAR2(30) NOT NULL |
Asset Id Where
|
| 48 |
PAR_GROUP_ASSET_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
Group Asset ID
|
| 49 |
MESSAGE_NBR |
Number(5,0) |
INTEGER NOT NULL |
Message Number. This field refers to the Message Number in the Message Catalog.
|
| 50 |
IATO_RECNAME |
Character(15) |
VARCHAR2(15) NOT NULL |
Record (Table) Name
|
| 51 |
ZERO_AMOUNT_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Zero Amount SW
|
| 52 |
DISPOSAL_CODE |
Character(1) |
VARCHAR2(1) NOT NULL |
Retirement Type
A=Abandonment
C=Cannibalize for Other Assets
D=Disappeared Assets
E=Expensed
F=Disposal Due to Theft
I=Returned to Inventory
L=Like Kind Exchange
M=Missing Asset
N=Donated to External Group
O=ARO Settlement
R=Scrapped Assets
S=Retirement by Sale
T=Traded In for another Asset
V=Auto-Retire Fully Depr Assets
Y=Casualty Loss
|
| 53 |
RETIREMENT_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Retirement Amount
|
| 54 |
ZERO_RETIRE_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Zero Amount SW
|
| 55 |
CUR_RECNAME |
Character(15) |
VARCHAR2(15) NOT NULL |
Record (Table) Name
|
| 56 |
CUR_RQST_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Currency Request Option
|
| 57 |
CUR_EFFDT |
Date(10) |
DATE |
Specifies the effective date associated with the currency used as the base currency for the Business Unit on the Journal Entry Header.
|
| 58 |
CUR_PRCS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 59 |
REVERSE_SIGN |
Signed Number(2,0) |
DECIMAL(1) NOT NULL |
Used to adjust sign for AM trn
|
| 60 |
CC_RATE_DIV |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
Rate Divisor
|
| 61 |
CC_RATE_MULT |
Signed Number(17,8) |
DECIMAL(15,8) NOT NULL |
Rate Multiplier
|
| 62 |
CC_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.
|
| 63 |
BKC_DIST_GRP |
Character(10) |
VARCHAR2(10) NOT NULL |
Book Code Distribution Code
|
| 64 |
RND_RETIRE_FROM |
Character(30) |
VARCHAR2(30) NOT NULL |
SQL Object Identifier
|
| 65 |
RND_RETIRE_WHERE |
Character(30) |
VARCHAR2(30) NOT NULL |
SQL Object Identifier
|
| 66 |
RND_RETIRE_WHERE1 |
Character(30) |
VARCHAR2(30) NOT NULL |
SQL Object Identifier
|
| 67 |
RND_RETIRE_WHERE2 |
Character(30) |
VARCHAR2(30) NOT NULL |
SQL Object Identifier
|
| 68 |
CHECK_FOR_VAT |
Character(1) |
VARCHAR2(1) NOT NULL |
Check for Vat
|
| 69 |
DIST_TYPE_SQL |
Character(30) |
VARCHAR2(30) NOT NULL |
SQL Object Identifier
|
| 70 |
RND_RET_AMOUNT |
Character(30) |
VARCHAR2(30) NOT NULL |
SQL Object Identifier
|
| 71 |
RND_RET_AMOUNT_GRP |
Character(30) |
VARCHAR2(30) NOT NULL |
SQL Object Identifier
|
| 72 |
RND_RET_TXN_AMOUNT |
Character(30) |
VARCHAR2(30) NOT NULL |
SQL Object Identifier
|
| 73 |
VAT_TRANS_EXISTS |
Character(30) |
VARCHAR2(30) NOT NULL |
SQL Object Identifier
|
| 74 |
REQUEST_BOOK |
Character(10) |
VARCHAR2(10) NOT NULL |
Request Book
|
| 75 |
ASSET_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
Asset Identification
|
| 76 |
DTTM_STAMP |
DateTime(26) |
TIMESTAMP |
Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
|
| 77 |
TRANS_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Types of Asset Management Transactions
ACR=Accretion Expense
ADD=Asset Addition
ADJ=Asset Cost Adjustment
BKS=Book Adjustment
BUD=Budgeted Depreciation
DPR=Depreciation
INF=Inflation Adjustment
LEX=Lease Expense
LPB=Budgeted Lease Payments
LPY=Lease Payment
PDP=Prior Period Depreciation
PLP=Prior Lease Payment
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
|
| 78 |
FROM_ASSET_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
From Asset ID
|
| 79 |
TO_ASSET_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
To Asset ID
|
| 80 |
MAX_DT |
Date(10) |
DATE |
Max Date
|
| 81 |
MIN_DT |
Date(10) |
DATE |
Minimum Date
|
| 82 |
PREV_FROM_ASSET_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
Previous from asset id
|
| 83 |
PREV_TO_ASSET_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
Previous to asset id
|
| 84 |
PREV_MAX_DT |
Date(10) |
DATE |
Previous max date
|
| 85 |
PREV_MIN_DT |
Date(10) |
DATE |
previous min date
|
| 86 |
FIRST_TIME |
Character(1) |
VARCHAR2(1) NOT NULL |
First time through process
|
| 87 |
UPDT_TXN_FLDS_SQL |
Character(30) |
VARCHAR2(30) NOT NULL |
SQL Object Identifier
|
| 88 |
IMP_COST_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Cost Type For Impairment Loss
|
| 89 |
REVERSE_COST_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Cost Type for Imp Reversal
|
| 90 |
REVAL_COST_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Cost Type for Revaluation
|
| 91 |
IMP_REVER_CST_TY |
Character(1) |
VARCHAR2(1) NOT NULL |
Cost Type For Reval Reversal
|
| 92 |
REVAL_WRTOFF_CS_TY |
Character(1) |
VARCHAR2(1) NOT NULL |
Cost Type for Reval Write-Off
|
| 93 |
REVAL_TRANS_CODE |
Character(5) |
VARCHAR2(5) NOT NULL |
Rev. Trans. Code
|
| 94 |
COUNT_1 |
Number(3,0) |
SMALLINT NOT NULL |
Count Work Field
|
| 95 |
RT_RATE_INDEX |
Character(10) |
VARCHAR2(10) NOT NULL |
Market Rate Index
|
| 96 |
INV_PROP_TRANS_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
Investment Property Trans Code
|
| 97 |
FIELDNAME_FC |
Character(18) |
VARCHAR2(18) NOT NULL |
Fieldname for Fund Code.
|
| 98 |
SETID_CF |
Character(5) |
VARCHAR2(5) NOT NULL |
KK Control Chartfield SetID
|
| 99 |
VAT_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
VAT Flag
|
| 100 |
COST_TYPE_ARO |
Character(1) |
VARCHAR2(1) NOT NULL |
ARO Cost Type
|
| 101 |
COST_TYPE_RE |
Character(1) |
VARCHAR2(1) NOT NULL |
Rent Expense Cost Type
|
| 102 |
COST_TYPE_LI |
Character(1) |
VARCHAR2(1) NOT NULL |
Lease Incentive Cost Type
|
| 103 |
COST_TYPE_LR |
Character(1) |
VARCHAR2(1) NOT NULL |
Lease Remeasurement Cost Type
|
| 104 |
COST_TYPE_FC |
Character(1) |
VARCHAR2(1) NOT NULL |
Currency Exchange G/L Cost Typ
|
| 105 |
RE_NEW_AC_RULE |
Character(1) |
VARCHAR2(1) NOT NULL |
New RE Acct Rule Flag
|
| 106 |
AE_WHERE_1 |
Character(50) |
VARCHAR2(50) NOT NULL |
AE_WHERE_1
|