| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 3 |
BOOK |
Character(10) |
VARCHAR2(10) NOT NULL |
Asset Book Name
|
| 4 |
ASSET_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
Asset Identification
|
| 5 |
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.
|
| 6 |
FISCAL_YEAR |
Number(4,0) |
SMALLINT NOT NULL |
Fiscal Year
|
| 7 |
START_PD |
Number(3,0) |
SMALLINT NOT NULL |
Start Period
|
| 8 |
END_PD |
Number(3,0) |
SMALLINT NOT NULL |
End Period
|
| 9 |
OPERATING_UNIT |
Character(8) |
VARCHAR2(8) NOT NULL |
Operating Unit ChartField
Prompt Table:
OPER_UNIT_TBL
|
| 10 |
PRODUCT |
Character(6) |
VARCHAR2(6) NOT NULL |
Product ChartField
Prompt Table:
PRODUCT_TBL
|
| 11 |
FUND_CODE |
Character(5) |
VARCHAR2(5) NOT NULL |
Fund Code
Prompt Table:
FUND_TBL
|
| 12 |
CLASS_FLD |
Character(5) |
VARCHAR2(5) NOT NULL |
Class Field
Prompt Table:
CLASS_CF_TBL
|
| 13 |
PROGRAM_CODE |
Character(5) |
VARCHAR2(5) NOT NULL |
Program Code ChartField
Prompt Table:
PROGRAM_TBL
|
| 14 |
BUDGET_REF |
Character(8) |
VARCHAR2(8) NOT NULL |
Budget Reference
Prompt Table:
BUD_REF_TBL
|
| 15 |
AFFILIATE |
Character(5) |
VARCHAR2(5) NOT NULL |
Affiliate
Prompt Table:
AFFILIATE_VW
|
| 16 |
AFFILIATE_INTRA1 |
Character(10) |
VARCHAR2(10) NOT NULL |
IntraUnit Affiliate1
Prompt Table:
%EDIT_INTRA01
|
| 17 |
AFFILIATE_INTRA2 |
Character(10) |
VARCHAR2(10) NOT NULL |
Operating Unit Affiliate
Prompt Table:
%EDIT_INTRA02
|
| 18 |
CHARTFIELD1 |
Character(10) |
VARCHAR2(10) NOT NULL |
Expansion chartfield 1
Prompt Table:
CHARTFIELD1_TBL
|
| 19 |
CHARTFIELD2 |
Character(10) |
VARCHAR2(10) NOT NULL |
Expansion Chartfield 2
Prompt Table:
CHARTFIELD2_TBL
|
| 20 |
CHARTFIELD3 |
Character(10) |
VARCHAR2(10) NOT NULL |
Expansion Chartfield 3
Prompt Table:
CHARTFIELD3_TBL
|
| 21 |
PROJECT_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Project Id ChartField
|
| 22 |
DEPTID |
Character(10) |
VARCHAR2(10) NOT NULL |
Department
|
| 23 |
CATEGORY |
Character(5) |
VARCHAR2(5) NOT NULL |
Asset Category
|
| 24 |
COST_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Cost Type
|
| 25 |
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
|
| 26 |
TRANS_CODE |
Character(5) |
VARCHAR2(5) NOT NULL |
Transaction Code
|
| 27 |
GROUP_ASSET_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
Group Asset ID
|
| 28 |
DEPR |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Depreciation Amt
|
| 29 |
DEPR_YTD |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Year to Date Depreciation
|
| 30 |
COST |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Total Cost
|
| 31 |
COST1 |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Total Cost
|
| 32 |
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.
|
| 33 |
TRANS_DT |
Date(10) |
DATE |
Transaction Date
|
| 34 |
TRANS_IN_OUT |
Character(1) |
VARCHAR2(1) NOT NULL |
Transaction In/Out
I=In
M=IUT Proceeds Markup
O=Out
|
| 35 |
CONVENTION |
Character(2) |
VARCHAR2(2) NOT NULL |
Book Depreciation Convention
or Cost Convention
|
| 36 |
SALVAGE_VALUE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Salvage Value
|
| 37 |
SALVAGE_PCT |
Number(16,14) |
DECIMAL(15,14) NOT NULL |
Salvage Percentage
|
| 38 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
|
| 39 |
TO_CURRENCY |
Character(3) |
VARCHAR2(3) NOT NULL |
Revalue Currency
|
| 40 |
SERVICE_DT |
Date(10) |
DATE |
Service Date
|
| 41 |
LIFE |
Number(4,0) |
SMALLINT NOT NULL |
Useful Life
|
| 42 |
PERIOD_COUNTER |
Number(7,0) |
INTEGER NOT NULL |
PERIOD COUNTER
|
| 43 |
LIFE_REMAINING |
Signed Number(17,11) |
DECIMAL(15,11) NOT NULL |
Remaining Life
|
| 44 |
ASSET_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Asset Status
A=Received (Not in Service)
B=Budgeted
C=Commitment
D=Disposed
I=In Service
M=Suspended
R=Requisitioned
T=Transferred
W=Work In Progress
|
| 45 |
DEFAULT_PROFILE_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Default Books from Profile
|
| 46 |
ACCOUNTING_DT |
Date(10) |
DATE |
The accounting entry construction date for a given transaction (a generic field that crosses multiple
|
| 47 |
DEPR_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Depreciation Status
D=Depreciable
N=Non Depreciable
|
| 48 |
INTFC_ID |
Number(8,0) |
INTEGER NOT NULL |
Interface ID
|
| 49 |
INTFC_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Trans Load Type
|
| 50 |
SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
|
| 51 |
PROFILE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Asset Profile ID
|
| 52 |
COUNT_1 |
Number(3,0) |
SMALLINT NOT NULL |
Count Work Field
|
| 53 |
EFFDT |
Date(10) |
DATE |
Effective Date
Default Value: %date
|
| 54 |
PAR_PROFILE_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Asset Profile
|
| 55 |
PAR_TAG_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Tag Number
|
| 56 |
PAR_DESCR_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Copy Description
|
| 57 |
PAR_ASSET_CLASS_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Copy Asset Class from Parent
|
| 58 |
PAR_ACQUIS_CD_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Acquisition Code
|
| 59 |
PAR_INDEX_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Index
|
| 60 |
PAR_CUSTODIAN_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Custodian Fields
|
| 61 |
PAR_LOCATION_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Location Fields
|
| 62 |
PAR_LICENSE_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
License Fields
|
| 63 |
TAG_NUMBER |
Character(12) |
VARCHAR2(12) NOT NULL |
Tag Number
|
| 64 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 65 |
DESCRSHORT |
Character(10) |
VARCHAR2(10) NOT NULL |
Short Description
|
| 66 |
ASSET_CLASS |
Character(10) |
VARCHAR2(10) NOT NULL |
Asset Class
|
| 67 |
ACQUISITION_CD |
Character(1) |
VARCHAR2(1) NOT NULL |
Acquisition Code
C=Constructed
D=Donated
I=Trade In
K=Like Exchange
L=Leased
P=Purchased
T=Transferred
|
| 68 |
INDEX_NAME |
Character(20) |
VARCHAR2(20) NOT NULL |
Index Name
|
| 69 |
INDEX_DETAIL_NAME |
Character(35) |
VARCHAR2(35) NOT NULL |
SubIndex Name
|
| 70 |
CUSTODIAN |
Character(30) |
VARCHAR2(30) NOT NULL |
Custodian
|
| 71 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
|
| 72 |
CUSTODIAN_DEPTID |
Character(10) |
VARCHAR2(10) NOT NULL |
Asset Custodian Deptid
|
| 73 |
OFFSITE_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
This Asset is Offsite
|
| 74 |
AUTH_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Authorization Status
A=Authorized
N=Not Authorized
P=Authorization Pending
|
| 75 |
AUTHORIZATION_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Authorization Name
|
| 76 |
AUTHORIZATION_DT |
Date(10) |
DATE |
Date Authorized
|
| 77 |
AGENCY_ID |
Character(20) |
VARCHAR2(20) NOT NULL |
Agency ID
|
| 78 |
VENDOR_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Vendor Identifier
|
| 79 |
REGISTRATION_NO |
Character(25) |
VARCHAR2(25) NOT NULL |
Registration #
|
| 80 |
INSPECTION_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Inspection Required
N=Not Inspected
Y=Inspected
|
| 81 |
LIC_START_DT |
Date(10) |
DATE |
License Effective Date
|
| 82 |
LIC_END_DT |
Date(10) |
DATE |
License Expiry Date
|
| 83 |
REGISTER_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Name
|
| 84 |
JURISDICTION |
Character(5) |
VARCHAR2(5) NOT NULL |
Jurisdiction
|
| 85 |
PAR_CONVENTION_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Copy Convention from Parent?
|
| 86 |
PAR_SALVAGE_VAL_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Copy Salvage Value from Parent
|
| 87 |
PAR_METHOD_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Copy Method from Parent Asset?
|
| 88 |
PAR_MULTI_SHIFT_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Multi-Shift Code
|
| 89 |
PAR_DEPR_LIMIT_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Copy Depr Limit from Parent?
|
| 90 |
PAR_COST_BASLIM_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Cost Basis Limit
|
| 91 |
DEPR_IN_SERVICE_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Depreciate When In Service
N=No
X=Used to be set to 'Y'
Y=Yes
|
| 92 |
BEGIN_FRACTION |
Signed Number(17,13) |
DECIMAL(15,13) NOT NULL |
Begin Depr Period Fraction
|
| 93 |
DEPR_CALC_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Depreciation Calculation Sw
|
| 94 |
LAST_CALC_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Last Calculation Type
|
| 95 |
RSV_FRACTION |
Signed Number(17,13) |
DECIMAL(15,13) NOT NULL |
Reserve Fraction (RSV/Cost)
|
| 96 |
RECALC_RSV_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Recalculate RSV Fraction (Y/N)
|
| 97 |
SCHED_FRACTION |
Signed Number(17,13) |
DECIMAL(15,13) NOT NULL |
Fraction of Schedule Elapsed
|
| 98 |
YEAR_REM_FRACTION |
Signed Number(17,13) |
DECIMAL(15,13) NOT NULL |
Year Remaining Fraction
|
| 99 |
REGULATION |
Character(1) |
VARCHAR2(1) NOT NULL |
Depreciation Regulation
A=Accelerated Cost Recovery Sys
D=Asset Depreciation Range
F=Conventional/Facts& Circumstan
G=Guideline
M=Modified Accel Cost Recovery
|
| 100 |
DEPR_LIMIT_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
Depreciation Limit Code
|
| 101 |
SALVAGE_VAL |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Salvage Value
|
| 102 |
LIFE_END_DT |
Date(10) |
DATE |
Useful Life End Date
|
| 103 |
COST_BASIS_LIMIT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Cost Basis Limit
|
| 104 |
ACCOUNTING_MTHD |
Character(3) |
VARCHAR2(3) NOT NULL |
Accounting Method
ALL=Allowance
EXP=Expense
RES=Reserve
|
| 105 |
MULTI_SHIFT_CODE |
Character(6) |
VARCHAR2(6) NOT NULL |
Multi_Shift Code is used to assign and specify the Multi_Shift factor. A Multi_Shift factor is used to indicate the % of increase of annual depreciation during a multi_shift operation.
For example a shift factor of 50% means there will be a 50% increase of the annual depreciation.
|
| 106 |
MULTI_SHIFT_NBR |
Number(1,0) |
SMALLINT NOT NULL |
This field is used to indicate the number of shifts operated within a fiscal year during a multi-shift operation.
|
| 107 |
LIFE_IN_YRS |
Number(6,1) |
DECIMAL(5,1) NOT NULL |
Life in Years
|
| 108 |
METHOD |
Character(2) |
VARCHAR2(2) NOT NULL |
Method
DL=DB w/SL By Limit%
DX=Declining Balance w/SL
F1=France Derogatory Balance
FL=Flat Rate %
G1=Germany Staffel Method
J1=Japan- Tangible/Declining Bal
J2=Japan- Tangible/Strt Line
J3=Japan- Intangible/Strt Line
J4=Japan - Lease Depreciation
J5=Japan-Changes DB to SL
J6=Japan - Changes DB to SL 250
J7=Japan-Tangible/Strt Line Rev
J8=Japan - Changes DB to SL 200
J9=JPN - Changes 200/250 DB to SL
JE=Japan - Extended/Strt Line
MN=Manual Depreciation
PC=Declining Balance
SC=Depreciation Schedule
SL=Straight Line
SP=Straight Line Percent
SY=Sum of the Years
UD=User Defined Method
UP=Units of Production
|
| 109 |
DEPR_PERCENT |
Number(10,8) |
DECIMAL(9,8) NOT NULL |
Depreciation Percent
|
| 110 |
DB_PERCENT |
Number(16,14) |
DECIMAL(15,14) NOT NULL |
Declining Balance Percent
|
| 111 |
CALCULATION_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Calculation Type
L=Life-to-Date
R=Remaining Value
|
| 112 |
DEPR_LIMIT_PCT |
Signed Number(7,2) |
DECIMAL(5,2) NOT NULL |
Depreciation Limit Percent
|
| 113 |
DEPR_LOW_LIMIT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Depr Low Limit Amount
|
| 114 |
UOP_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Units of Production ID
|
| 115 |
DEPR_SCHED_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
Schedule Code
|
| 116 |
UD_METHOD_ID |
Character(5) |
VARCHAR2(5) NOT NULL |
Method ID
|
| 117 |
FUTURE_DEPR_YEARS |
Number(3,0) |
SMALLINT NOT NULL |
No of Future Depreciation Year
|
| 118 |
PERIOD_DEPR_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Depreciate By Period
|
| 119 |
LOW_VALUE_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Low Value Asset Only
|
| 120 |
DEPR_AVG_OPTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Depreciation Averaging Option
M=Monthly Averaging
N=No Averaging
Y=Yearly Averaging
|
| 121 |
DEPR_PASS_LIFE_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Depreciate Pass Life SW
|
| 122 |
DEROGATORY_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Derogatory Depreciation
|
| 123 |
CURRENCY_CD_2 |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency code 2
|
| 124 |
DECIMAL_POSITIONS |
Number(2,0) |
SMALLINT NOT NULL |
Decimal Positions
|
| 125 |
BUSINESS_UNIT_1 |
Character(5) |
VARCHAR2(5) NOT NULL |
Non-Joint Venture BU
|
| 126 |
ASSET_ID_PREV |
Character(12) |
VARCHAR2(12) NOT NULL |
Previous Asset ID
|
| 127 |
DTTM_STAMP_OLD |
DateTime(26) |
TIMESTAMP |
Data Time Stamp - Old
|
| 128 |
DTTM_TO |
DateTime(26) |
TIMESTAMP |
To Date/Time
|
| 129 |
REMOVAL_COST |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Removal Cost
|
| 130 |
PROCEEDS |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Retirement Proceeds
|
| 131 |
COST_ROUND_8 |
Signed Number(33,8) |
DECIMAL(31,8) NOT NULL |
Cost Round 8 decimals
|
| 132 |
PROCEEDS_ROUND_8 |
Signed Number(33,8) |
DECIMAL(31,8) NOT NULL |
Proceeds Round 8 Decimals
|
| 133 |
REMOVAL_COST_RND_8 |
Signed Number(33,8) |
DECIMAL(31,8) NOT NULL |
Removal Cost Round 8 Decimals
|
| 134 |
ROUND_FACTOR |
Number(15,7) |
DECIMAL(14,7) NOT NULL |
Rounding Factor
|
| 135 |
ROUND_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Round Type
C=Currency
G=Generic
|
| 136 |
ROUND_RULE_AM |
Character(1) |
VARCHAR2(1) NOT NULL |
Rounding Rule
D=Round Down
N=Natural Round
U=Round Up
|
| 137 |
ROUND_PRECISION |
Signed Number(4,0) |
DECIMAL(3) NOT NULL |
Rounding Precision
|
| 138 |
TRUNCATE_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Used for Round Up. 'Y'es - truncate 1 decimal place past the round precision. 'N' - do not truncate
|
| 139 |
PRIMARY_BOOK |
Character(10) |
VARCHAR2(10) NOT NULL |
AM Primary Book
|
| 140 |
LEDGER_GROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
Ledger Group
|
| 141 |
BOOK2 |
Character(10) |
VARCHAR2(10) NOT NULL |
Asset Book Name
|
| 142 |
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. "
|
| 143 |
OPEN_TRANS_ID |
Number(10,0) |
DECIMAL(10) NOT NULL |
Open Transaction ID
|
| 144 |
IN_SERVICE_DT |
Date(10) |
DATE |
In Service Date
|
| 145 |
BKC_DIST_GRP |
Character(10) |
VARCHAR2(10) NOT NULL |
Book Code Distribution Code
|
| 146 |
LOCATION |
Character(10) |
VARCHAR2(10) NOT NULL |
Location Code
|
| 147 |
DOCUMENT_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
Document
|
| 148 |
AREA_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Area ID
|
| 149 |
WARRANTY_EFFDT |
Date(10) |
DATE |
Asset Warranty Effdt
|
| 150 |
WARRANTY_DURATION |
Number(5,0) |
INTEGER NOT NULL |
Warranty Duration (months)
|
| 151 |
END_DT |
Date(10) |
DATE |
End Date
|
| 152 |
LOCATION_EFFDT |
Date(10) |
DATE |
Location Effective Date
|
| 153 |
LOCATION_EFFSEQ |
Number(3,0) |
SMALLINT NOT NULL |
Asset Location Effective Seq
|
| 154 |
CUSTODIAN_EFFDT |
Date(10) |
DATE |
Asset Custodian Effective Dt
|
| 155 |
CUSTODIAN_EFFSEQ |
Number(3,0) |
SMALLINT NOT NULL |
Asset Custodian Effective Seq
|
| 156 |
OLD_LOCATION |
Character(10) |
VARCHAR2(10) NOT NULL |
Old Location
|
| 157 |
OLD_AREA_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Area ID
|
| 158 |
OLD_CUSTODIAN |
Character(30) |
VARCHAR2(30) NOT NULL |
Old Custodian
|
| 159 |
OLD_EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Old Emplid
|
| 160 |
OLD_CUSTODIAN_DEPT |
Character(10) |
VARCHAR2(10) NOT NULL |
Asset Custodian Deptid
|
| 161 |
BUSINESS_UNIT_PC |
Character(5) |
VARCHAR2(5) NOT NULL |
PC Business Unit
|
| 162 |
ACTIVITY_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Activity ID
|
| 163 |
RESOURCE_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Source Type
|
| 164 |
RESOURCE_CATEGORY |
Character(5) |
VARCHAR2(5) NOT NULL |
Category
|
| 165 |
RESOURCE_SUB_CAT |
Character(5) |
VARCHAR2(5) NOT NULL |
Subcategory
|
| 166 |
ANALYSIS_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Analysis Type
|
| 167 |
IU_MAP_KEY |
Number(7,0) |
INTEGER NOT NULL |
InterUnit transfer map key
|
| 168 |
CF_SEQNO |
Number(6,0) |
INTEGER NOT NULL |
Chartfield Sequence Number
|