| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
MULTI_LED_PROC_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
|
| 3 |
DEFAULT_PROFILE_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Default Books from Profile
|
| 4 |
CAL_DEPR_PD |
Character(2) |
VARCHAR2(2) NOT NULL |
Calendar
|
| 5 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 6 |
BOOK |
Character(10) |
VARCHAR2(10) NOT NULL |
Asset Book Name
|
| 7 |
LEDGER_GROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
Ledger Group
|
| 8 |
SETID_PROFILE |
Character(5) |
VARCHAR2(5) NOT NULL |
Profile SetID
|
| 9 |
INSERT_VALUE |
Number(3,0) |
SMALLINT NOT NULL |
|
| 10 |
GROUP_INSERT_VALUE |
Number(3,0) |
SMALLINT NOT NULL |
|
| 11 |
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
|
| 12 |
TRANS_IN_OUT |
Character(1) |
VARCHAR2(1) NOT NULL |
Transaction In/Out
I=In
M=IUT Proceeds Markup
O=Out
|
| 13 |
SUM_GROUP_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Group Consolidation Status
C=Completed Sum Composite
G=Grouped Composite
M=Member Depreciation
N=Never Sum Composite
P=Pending Sum Composite
|
| 14 |
PROCESS_PROFILE_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
|
| 15 |
INVALID_DIST_TMPL |
Character(1) |
VARCHAR2(1) NOT NULL |
Invalid Distribution Template
|
| 16 |
IUT_DEPR_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
InterUnit Depreciation Status
H=Hold Depreciation
N=None
|
| 17 |
BOOK_CHANGE_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Book Change Type
ADD=Add
LFE=Life Ext.
MTH=Method
MUL=Multi Chng
OTH=Other
RCL=Recalc
RES=Resume
RRC=Rate Change
SUS=Suspend
TRF=Transfer
|
| 18 |
SQLID_WHERE_CAP |
Character(30) |
VARCHAR2(30) NOT NULL |
SQL Object Identifier
|
| 19 |
SQLID_WHERE_BOOK |
Character(30) |
VARCHAR2(30) NOT NULL |
SQL Object Identifier
|
| 20 |
SQLID_WHERE_ASSET |
Character(30) |
VARCHAR2(30) NOT NULL |
SQL Object Identifier
|
| 21 |
VAT_ENTITY |
Character(20) |
VARCHAR2(20) NOT NULL |
Specifies an organizational entity that is responsible for VAT reporting and that is registered in one or more countries that require VAT reporting. A single VAT entity is linked to one or more General Ledger Business Units depending on the reporting requirements.
|
| 22 |
AM_UPDTFLD1 |
Character(100) |
VARCHAR2(100) NOT NULL |
|
| 23 |
AM_UPDTFLD2 |
Character(100) |
VARCHAR2(100) NOT NULL |
|
| 24 |
AM_UPDTFLD3 |
Character(100) |
VARCHAR2(100) NOT NULL |
|
| 25 |
AM_UPDTFLD4 |
Character(100) |
VARCHAR2(100) NOT NULL |
|
| 26 |
AM_UPDTFLD5 |
Character(100) |
VARCHAR2(100) NOT NULL |
|
| 27 |
AM_UPDTFLD6 |
Character(100) |
VARCHAR2(100) NOT NULL |
|
| 28 |
AM_UPDTFLD7 |
Character(100) |
VARCHAR2(100) NOT NULL |
|
| 29 |
AM_UPDTFLD8 |
Character(100) |
VARCHAR2(100) NOT NULL |
|
| 30 |
AM_UPDTFLD9 |
Character(100) |
VARCHAR2(100) NOT NULL |
|
| 31 |
AM_UPDTFLD10 |
Character(100) |
VARCHAR2(100) NOT NULL |
|
| 32 |
AM_UPDTFLD11 |
Character(50) |
VARCHAR2(50) NOT NULL |
|
| 33 |
AM_UPDTFLD12 |
Character(50) |
VARCHAR2(50) NOT NULL |
|
| 34 |
AM_UPDTFLD13 |
Character(50) |
VARCHAR2(50) NOT NULL |
|
| 35 |
AM_UPDTFLD14 |
Character(50) |
VARCHAR2(50) NOT NULL |
|
| 36 |
AM_UPDTFLD15 |
Character(50) |
VARCHAR2(50) NOT NULL |
|
| 37 |
AM_UPDTFLD16 |
Character(50) |
VARCHAR2(50) NOT NULL |
|
| 38 |
AM_UPDTFLD17 |
Character(50) |
VARCHAR2(50) NOT NULL |
|
| 39 |
AM_UPDTFLD18 |
Character(50) |
VARCHAR2(50) NOT NULL |
|
| 40 |
AM_UPDTFLD19 |
Character(50) |
VARCHAR2(50) NOT NULL |
|
| 41 |
AM_UPDTFLD20 |
Character(50) |
VARCHAR2(50) NOT NULL |
|
| 42 |
FIELDNAME |
Character(18) |
VARCHAR2(18) NOT NULL |
Field Name (see PSDBFIELD).
|
| 43 |
FIELDNUM |
Number(4,0) |
SMALLINT NOT NULL |
Field Number
|
| 44 |
BOOK_STATUTORY |
Character(10) |
VARCHAR2(10) NOT NULL |
Statutory Book
|
| 45 |
BKC_DIST_GRP |
Character(10) |
VARCHAR2(10) NOT NULL |
Book Code Distribution Code
|
| 46 |
MSG_ACTIVE_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Message active switch
Default Value: Y
|
| 47 |
SQLID_WHERE_CAP2 |
Character(30) |
VARCHAR2(30) NOT NULL |
SQL Object Identifier
|
| 48 |
SQLID_WHERE_CAP3 |
Character(30) |
VARCHAR2(30) NOT NULL |
SQL Object Identifier
|