AM_STD_AET

(SQL Table)
Index Back

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 AE_APPL_ID Character(8) VARCHAR2(8) NOT NULL Application
3 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
4 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
5 ASSET_ID Character(12) VARCHAR2(12) NOT NULL Asset Identification
6 TRANS_DT Date(10) DATE Transaction Date
7 ACCOUNTING_DT Date(10) DATE The accounting entry construction date for a given transaction (a generic field that crosses multiple
8 OPEN_TRANS_ID Number(10,0) DECIMAL(10) NOT NULL Open Transaction ID
9 INTFC_ID Number(8,0) INTEGER NOT NULL Interface ID
10 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
11 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
12 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.
13 APPROVAL_SW Character(1) VARCHAR2(1) NOT NULL Auto Approval Status
14 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.
15 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
16 BUSINESS_UNIT_JV Character(5) VARCHAR2(5) NOT NULL Joint Venture BUS Unit
17 INTFC_TYPE Character(3) VARCHAR2(3) NOT NULL Trans Load Type
18 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.
19 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
20 BOOK Character(10) VARCHAR2(10) NOT NULL Asset Book Name
21 OPERATING_UNIT Character(8) VARCHAR2(8) NOT NULL Operating Unit ChartField
22 PRODUCT Character(6) VARCHAR2(6) NOT NULL Product ChartField
23 FUND_CODE Character(5) VARCHAR2(5) NOT NULL Fund Code
24 CLASS_FLD Character(5) VARCHAR2(5) NOT NULL Class Field
25 PROGRAM_CODE Character(5) VARCHAR2(5) NOT NULL Program Code ChartField
26 BUDGET_REF Character(8) VARCHAR2(8) NOT NULL Budget Reference
27 AFFILIATE Character(5) VARCHAR2(5) NOT NULL Affiliate
28 AFFILIATE_INTRA1 Character(10) VARCHAR2(10) NOT NULL IntraUnit Affiliate1
29 AFFILIATE_INTRA2 Character(10) VARCHAR2(10) NOT NULL Operating Unit Affiliate
30 CHARTFIELD1 Character(10) VARCHAR2(10) NOT NULL Expansion chartfield 1
31 CHARTFIELD2 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 2
32 CHARTFIELD3 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 3
33 DEPTID_TO Character(10) VARCHAR2(10) NOT NULL To Department
34 TRANSFER_OPTN Character(3) VARCHAR2(3) NOT NULL Dept/Prod/Proj Option
35 TEMP_FLD Character(1) VARCHAR2(1) NOT NULL Temporary Field for App Engine
36 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField
37 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
38 PROJECT_ID_TO Character(15) VARCHAR2(15) NOT NULL Project ID To
39 COST Signed Number(28,3) DECIMAL(26,3) NOT NULL Total Cost
40 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
41 PROCEEDS Signed Number(28,3) DECIMAL(26,3) NOT NULL Retirement Proceeds
42 QUANTITY Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Interface
43 REMOVAL_COST Signed Number(28,3) DECIMAL(26,3) NOT NULL Removal Cost
44 RETIREMENT_TYPE Character(1) VARCHAR2(1) NOT NULL Retirement Type
E=Extraordinary
O=Ordinary Retirement
45 RETIRE_CONVENTION Character(2) VARCHAR2(2) NOT NULL Retirement Convention
46 VOLUNTARY Character(1) VARCHAR2(1) NOT NULL Voluntary Conversion
I=Involuntary
V=Voluntary Conversion
47 ARITH_OPERATION Character(3) VARCHAR2(3) NOT NULL Arithmetic Operation
<=Less Than
<==Less Than or Equal To
<>=Not Equal To
==Equal To
>=Greater Than
>==Greater Than or Equal To
BLK=Is Blank
BTW=Between Value A and Value B
IN=In Subset
LIK=Like
NBL=Is Not Blank
NBT=Not Between
NIN=Not In
NLK=Not Like
NNL=Is Not Null
NUL=Is Null

Default Value: =