| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
INTFC_ID |
Number(8,0) |
INTEGER NOT NULL |
Interface ID
|
| 3 |
INTFC_LINE_NUM |
Number(8,0) |
INTEGER NOT NULL |
Interface Line Number
|
| 4 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
|
| 5 |
ASSET_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
Asset Identification
|
| 6 |
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.
|
| 7 |
VOUCHER_ID |
Character(8) |
VARCHAR2(8) NOT NULL |
Voucher ID
|
| 8 |
VOUCHER_LINE_NUM |
Number(5,0) |
INTEGER NOT NULL |
Voucher Line Number
|
| 9 |
DISTRIB_LINE_NUM |
Number(5,0) |
INTEGER NOT NULL |
Distribution Line
|
| 10 |
INTFC_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Trans Load Type
|
| 11 |
MC_DEFN_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Mass Change Definition
|
| 12 |
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.
|
| 13 |
APPROVAL_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Auto Approval Status
Y/N Table Edit
Default Value: Y
|
| 14 |
INTFC_STATUS |
Character(3) |
VARCHAR2(3) NOT NULL |
Interface Status
CON=Consolidated
DON=Mass Changes Generated
ERR=Error
NEW=Mass Changes Not Generated
REP=Replaced by Other Records (AP)
UNI=Unitized
Default Value: DON
|
| 15 |
LOAD_STATUS |
Character(3) |
VARCHAR2(3) NOT NULL |
/* -> JMZ. PSOFT. 11-OCT-2002 */
New Status were added : HLD and INP for Asset Management.
/* <- JMZ. PSOFT. 11-OCT-2002 */
CON=Consolidated
DON=Loaded
ERR=Errored
EXC=Excluded
HLD=On Hold
INP=In Process
NEW=Pending
PGI=PO Grp Incomplete
REP=Replaced
UNI=Unitized
Default Value: NEW
|
| 16 |
ORIG_INTFC_ID |
Number(8,0) |
INTEGER NOT NULL |
Original Interface ID
|
| 17 |
ORIG_LINE_NUM |
Number(8,0) |
INTEGER NOT NULL |
Original Interface Line Number
|
| 18 |
DEFAULT_PROFILE_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Default Books from Profile
Y/N Table Edit
Default Value: N
|
| 19 |
TRANS_IN_OUT |
Character(1) |
VARCHAR2(1) NOT NULL |
Transaction In/Out
I=In
M=IUT Proceeds Markup
O=Out
|
| 20 |
PARENT_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
Parent ID
|
| 21 |
PARENT_DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Parent Asset Description
|
| 22 |
PARENT_DESCRLONG50 |
Character(50) |
VARCHAR2(50) NOT NULL |
Parent Asset Long Description
|
| 23 |
TAGGABLE_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Taggable Asset
N=Non Taggable Asset
Y=Taggable Asset
|
| 24 |
TAG_NUMBER |
Character(12) |
VARCHAR2(12) NOT NULL |
Tag Number
|
| 25 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 26 |
DESCRSHORT |
Character(10) |
VARCHAR2(10) NOT NULL |
Short Description
Default Value: INTFC_PHY_A.DESCR
|
| 27 |
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
Default Value: I
|
| 28 |
FINANCIAL_ASSET_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Capitalized Asset
N=Non Cap
Y=Capitalize
Y/N Table Edit
Default Value: Y
|
| 29 |
REPLACE_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Replacement Asset
Y/N Table Edit
Default Value: N
|
| 30 |
REPLACE_ASSET_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
Replaced Asset ID
|
| 31 |
CONVERSION_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Old Asset ID
|
| 32 |
NEW_ASSET_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
New Asset
N=Used Asset
Y=New Asset
Default Value: Y
|
| 33 |
AVAIL_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Asset is Available
Y/N Table Edit
Default Value: N
|
| 34 |
AVAIL_CONTACT |
Character(30) |
VARCHAR2(30) NOT NULL |
Availability Contact
|
| 35 |
AVAIL_PHONE |
Character(12) |
VARCHAR2(12) NOT NULL |
Availability Phone
|
| 36 |
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
Default Value: P
|
| 37 |
ACQUISITION_DT |
Date(10) |
DATE |
Acquisition Date
|
| 38 |
FINANCING_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
Financing Code
|
| 39 |
ASSET_DTTM_STAMP |
DateTime(26) |
TIMESTAMP |
Asset Date Time Stamp
|
| 40 |
PROFILE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Asset Profile ID
|
| 41 |
ASSET_CLASS |
Character(10) |
VARCHAR2(10) NOT NULL |
Asset Class
|
| 42 |
CAP_NUM |
Character(15) |
VARCHAR2(15) NOT NULL |
Capital Acquisition Plan #
|
| 43 |
MFG_ID |
Character(50) |
VARCHAR2(50) NOT NULL |
Manufacturer ID
|
| 44 |
MANUFACTURER |
Character(60) |
VARCHAR2(60) NOT NULL |
Manufacturer Name
|
| 45 |
MODEL |
Character(30) |
VARCHAR2(30) NOT NULL |
Model
|
| 46 |
PROD_VERSION |
Character(10) |
VARCHAR2(10) NOT NULL |
Product Version
|
| 47 |
SERIAL_ID |
Character(20) |
VARCHAR2(20) NOT NULL |
Serial ID
|
| 48 |
PRODUCTION_DT |
Date(10) |
DATE |
Production Date
|
| 49 |
PLANT |
Character(30) |
VARCHAR2(30) NOT NULL |
Manufacturing Plant
|
| 50 |
MANUFACTUR_CONTACT |
Character(30) |
VARCHAR2(30) NOT NULL |
Manufacturing Contact
|
| 51 |
CAP_SEQUENCE |
Number(3,0) |
SMALLINT NOT NULL |
CAP Sequence
|
| 52 |
REPLACEMENT_COST |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Replacement Cost
|
| 53 |
LEASE_ASSET_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
Lease Asset ID
|
| 54 |
BUSINESS_UNIT_JV |
Character(5) |
VARCHAR2(5) NOT NULL |
Joint Venture BUS Unit
|
| 55 |
INDEX_NAME |
Character(20) |
VARCHAR2(20) NOT NULL |
Index Name
|
| 56 |
INDEX_DETAIL_NAME |
Character(35) |
VARCHAR2(35) NOT NULL |
SubIndex Name
|
| 57 |
LAST_INDEX_VALUE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Last Index Value
|
| 58 |
COMPOSITE_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Composite Asset
|
| 59 |
COMPOSITE_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
Composite Asset ID
|
| 60 |
FERC_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
FERC Code
|
| 61 |
SEQUENCE_NBR_6 |
Number(6,0) |
INTEGER NOT NULL |
Sequence
|
| 62 |
ACQUISITION_DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
DESCR field for ACQ_DETAIL
|
| 63 |
CAPITALIZATION_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Capitalized
0=To Capitalize Later
1=To be Capitalized
2=Already Capitalized
3=Never Capitalize
4=Already Non Capitalized
5=Consolidated
|
| 64 |
BUSINESS_UNIT_AP |
Character(5) |
VARCHAR2(5) NOT NULL |
AP Business Unit
|
| 65 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
|
| 66 |
BUSINESS_UNIT_PO |
Character(5) |
VARCHAR2(5) NOT NULL |
PO Business Unit
|
| 67 |
PO_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Purchase Order
|
| 68 |
PO_LINE_NBR |
Number(5,0) |
INTEGER NOT NULL |
Purchase Order Line Number
|
| 69 |
SCHED_NBR |
Number(3,0) |
SMALLINT NOT NULL |
Schedule Number
|
| 70 |
PO_DIST_LINE_NUM |
Number(5,0) |
INTEGER NOT NULL |
PO Distribution Line Number
|
| 71 |
REFERENCE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Reference ID
|
| 72 |
INVOICE_DT |
Date(10) |
DATE |
Invoice Date
|
| 73 |
VENDOR_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Vendor Identifier
|
| 74 |
VENDOR_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Supplier Name
|
| 75 |
INVOICE_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Invoice Number
|
| 76 |
AMOUNT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Amount
|
| 77 |
QUANTITY |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Qty Interface
|
| 78 |
SALETX_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Sales Tax Amount
|
| 79 |
SALETX_CD |
Character(8) |
VARCHAR2(8) NOT NULL |
Sales Tax Code
|
| 80 |
USETAX_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Amount
|
| 81 |
USETAX_CD |
Character(8) |
VARCHAR2(8) NOT NULL |
Use Tax Code
|
| 82 |
FREIGHT_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Freight Amount
|
| 83 |
BUSINESS_UNIT_RECV |
Character(5) |
VARCHAR2(5) NOT NULL |
Receiving Business Unit
|
| 84 |
RECEIVER_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Receiver number
|
| 85 |
RECV_LN_NBR |
Number(5,0) |
INTEGER NOT NULL |
Receipt Line
|
| 86 |
RECV_SHIP_SEQ_NBR |
Number(3,0) |
SMALLINT NOT NULL |
Receiver Shipping Sequence
|
| 87 |
RECV_DIST_LINE_NUM |
Number(5,0) |
INTEGER NOT NULL |
Receiver Distrib Line
|
| 88 |
DISTRIB_SEQ_NUM |
Number(5,0) |
INTEGER NOT NULL |
Distribution Sequence
|
| 89 |
INV_ITEM_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Item ID
|
| 90 |
OPERATING_UNIT |
Character(8) |
VARCHAR2(8) NOT NULL |
Operating Unit ChartField
|
| 91 |
PRODUCT |
Character(6) |
VARCHAR2(6) NOT NULL |
Product ChartField
|
| 92 |
FUND_CODE |
Character(5) |
VARCHAR2(5) NOT NULL |
Fund Code
|
| 93 |
CLASS_FLD |
Character(5) |
VARCHAR2(5) NOT NULL |
Class Field
|
| 94 |
PROGRAM_CODE |
Character(5) |
VARCHAR2(5) NOT NULL |
Program Code ChartField
|
| 95 |
BUDGET_REF |
Character(8) |
VARCHAR2(8) NOT NULL |
Budget Reference
|
| 96 |
AFFILIATE |
Character(5) |
VARCHAR2(5) NOT NULL |
Affiliate
|
| 97 |
AFFILIATE_INTRA1 |
Character(10) |
VARCHAR2(10) NOT NULL |
IntraUnit Affiliate1
|
| 98 |
AFFILIATE_INTRA2 |
Character(10) |
VARCHAR2(10) NOT NULL |
Operating Unit Affiliate
|
| 99 |
CHARTFIELD1 |
Character(10) |
VARCHAR2(10) NOT NULL |
Expansion chartfield 1
|
| 100 |
CHARTFIELD2 |
Character(10) |
VARCHAR2(10) NOT NULL |
Expansion Chartfield 2
|
| 101 |
CHARTFIELD3 |
Character(10) |
VARCHAR2(10) NOT NULL |
Expansion Chartfield 3
|
| 102 |
PROJECT_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Project Id ChartField
|
| 103 |
DEPTID |
Character(10) |
VARCHAR2(10) NOT NULL |
Department
|
| 104 |
CATEGORY |
Character(5) |
VARCHAR2(5) NOT NULL |
Asset Category
|
| 105 |
COST_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Cost Type
|
| 106 |
BUSINESS_UNIT_PC |
Character(5) |
VARCHAR2(5) NOT NULL |
PC Business Unit
|
| 107 |
MASTER_PROJECT |
Character(15) |
VARCHAR2(15) NOT NULL |
Master Project
|
| 108 |
ACTIVITY_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Activity ID
|
| 109 |
RESOURCE_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Source Type
|
| 110 |
RESOURCE_SUB_CAT |
Character(5) |
VARCHAR2(5) NOT NULL |
Subcategory
|
| 111 |
ANALYSIS_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Analysis Type
|
| 112 |
RESOURCE_CATEGORY |
Character(5) |
VARCHAR2(5) NOT NULL |
Category
|
| 113 |
CUSTODIAN_EFFDT |
Date(10) |
DATE |
Asset Custodian Effective Dt
|
| 114 |
EFFSEQ |
Number(3,0) |
SMALLINT NOT NULL |
Effective Sequence
|
| 115 |
CUSTODIAN |
Character(30) |
VARCHAR2(30) NOT NULL |
Custodian
|
| 116 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
|
| 117 |
CUSTODIAN_DEPTID |
Character(10) |
VARCHAR2(10) NOT NULL |
Asset Custodian Deptid
|
| 118 |
CUSTODIAN_PROJECT |
Character(15) |
VARCHAR2(15) NOT NULL |
Asset Custodian Project
|
| 119 |
OFFSITE_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
This Asset is Offsite
|
| 120 |
AUTH_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Authorization Status
A=Authorized
N=Not Authorized
P=Authorization Pending
|
| 121 |
AUTHORIZATION_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Authorization Name
|
| 122 |
AUTHORIZATION_DT |
Date(10) |
DATE |
Date Authorized
|
| 123 |
LOCATION_EFFDT |
Date(10) |
DATE |
Location Effective Date
|
| 124 |
LOCATION_EFFSEQ |
Number(3,0) |
SMALLINT NOT NULL |
Asset Location Effective Seq
|
| 125 |
LOCATION |
Character(10) |
VARCHAR2(10) NOT NULL |
Location Code
|
| 126 |
PI_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Physical Inventory ID
|
| 127 |
INVENTORY_DT |
Date(10) |
DATE |
Inventory Date
|
| 128 |
PERFORMED_BY |
Character(30) |
VARCHAR2(30) NOT NULL |
Performed By
|
| 129 |
DOCUMENT_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
Document
|
| 130 |
LOC_AUTH_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Location Authorization Status
|
| 131 |
LOC_AUTH_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Location Authorization Name
|
| 132 |
LOC_AUTH_DT |
Date(10) |
DATE |
Location Authorization Date
|
| 133 |
REPLACE_COST_DT |
Date(10) |
DATE |
Last Update
|
| 134 |
GROUP_ASSET_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Group Asset Flag
G=Group Asset
M=Group Member
N=None
Default Value: N
|
| 135 |
GROUP_ASSET_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
Group Asset ID
|
| 136 |
RD_PLANT_ASSET |
Character(1) |
VARCHAR2(1) NOT NULL |
R and D Plant Asset
|
| 137 |
RD_START_DT |
Date(10) |
DATE |
R and D Start Date
|
| 138 |
RD_USE_NBV |
Character(1) |
VARCHAR2(1) NOT NULL |
Use NBV for R and D
|
| 139 |
INCENTIVE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Investment Incentive ID
|
| 140 |
IP_ADDRESS |
Character(39) |
VARCHAR2(39) NOT NULL |
Internet Protocol Address
|
| 141 |
IP_ALIAS |
Character(35) |
VARCHAR2(35) NOT NULL |
Internet Address Alias/UNC
|
| 142 |
MERCH_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Base Merchandise Amount
|
| 143 |
VAT_INV_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
VAT Invoice Amt Base Curr
|
| 144 |
VAT_NRCVR_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
VAT NonRecoverable Amount
|
| 145 |
VAT_RCVRY_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
VAT Recovery Amt in Base Curr
|
| 146 |
AM_AST_UD_CHAR1 |
Character(10) |
VARCHAR2(10) NOT NULL |
User Defined Char Field1
|
| 147 |
AM_AST_UD_CHAR2 |
Character(10) |
VARCHAR2(10) NOT NULL |
User Defined Char Field2
|
| 148 |
AM_AST_UD_DATE1 |
Date(10) |
DATE |
User Defined Date Field1
|
| 149 |
AM_AST_UD_NUM1 |
Number(19,3) |
DECIMAL(18,3) NOT NULL |
User Defined Number Field1
|
| 150 |
AM_AST_UD_NUM2 |
Number(19,3) |
DECIMAL(18,3) NOT NULL |
User Defined Number Field2
|
| 151 |
VAT_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
VAT SetID
|
| 152 |
VAT_USE_ID |
Character(6) |
VARCHAR2(6) NOT NULL |
VAT Use Type
|
| 153 |
BUSINESS_UNIT_VAT |
Character(5) |
VARCHAR2(5) NOT NULL |
Vat Apportionment Business Uni
|
| 154 |
CHARTFIELD_PR1_VAL |
Character(20) |
VARCHAR2(20) NOT NULL |
Chartfield Priority 1 Value
|
| 155 |
CHARTFIELD_PR2_VAL |
Character(20) |
VARCHAR2(20) NOT NULL |
Chartfield Priority 2 Value
|
| 156 |
VAT_RECOVERY_PCT |
Signed Number(7,2) |
DECIMAL(5,2) NOT NULL |
VAT Recovery Percent
|
| 157 |
VAT_CONSTRAINT_PCT |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Coefficient of Constraint
|
| 158 |
VAT_TAXATION_PCT |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Coefficient of Taxation
|
| 159 |
VAT_ADMISSION_PCT |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Coefficient of Admission
|
| 160 |
TAX_CD_VAT |
Character(8) |
VARCHAR2(8) NOT NULL |
Defines the VAT (Value Added Tax) percentage (via link to the Tax Authority) and is used to retrieve VAT accounting ChartFields. The VAT code determines how the VAT amount is calculated on a transaction and how that amount is accounted and reported for.
|