PC_AM_DEFN(SQL Table) |
Index Back |
---|---|
Projects Defined AssetsAssets Defined in the Projects system to be sent to Asset Management via the PC to AM integration. |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | BUSINESS_UNIT_AM | Character(5) | VARCHAR2(5) NOT NULL |
AM Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: SP_BU_AM_NONVW |
2 | ASSET_ID | Character(12) | VARCHAR2(12) NOT NULL |
Asset Identification
Prompt Table: PC_AM_DEFN_VW |
3 | INTFC_ID | Number(8,0) | INTEGER NOT NULL | Interface ID |
4 | INTFC_LINE_NUM | Number(8,0) | INTEGER NOT NULL | Interface Line Number |
5 | PROFILE_ID | Character(10) | VARCHAR2(10) NOT NULL |
Asset Profile ID
Prompt Table: PROFILE_PCAM_VW |
6 | GROUP_ASSET_ID | Character(12) | VARCHAR2(12) NOT NULL |
Group Asset ID
Prompt Table: %EDITTABLE6 |
7 | PARENT_ID | Character(12) | VARCHAR2(12) NOT NULL |
Parent ID
Prompt Table: %EDITTABLE2 |
8 | PARENT_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Parent Asset Description |
9 | AM_DISTRIB_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
AM Distribution Status
D=Distributed I=Ignore M=Modified N=Not Distributed P=Pending V=Reversed Default Value: N |
10 | BOOK | Character(10) | VARCHAR2(10) NOT NULL |
Asset Book Name
Prompt Table: %EDITTABLE3 |
11 | CATEGORY | Character(5) | VARCHAR2(5) NOT NULL |
Asset Category
Prompt Table:
%EDITTABLE4
|
12 | QUANTITY | Signed Number(17,4) | DECIMAL(15,4) NOT NULL |
Qty Interface
Default Value: 1 |
13 | COST_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Cost Type
Prompt Table:
%EDITTABLE5
|
14 | LOCATION | Character(10) | VARCHAR2(10) NOT NULL |
Location Code
Prompt Table:
LOCATION_TBL
|
15 | RESOURCE_TYPE | Character(5) | VARCHAR2(5) NOT NULL | Source Type |
16 | RESOURCE_CATEGORY | Character(5) | VARCHAR2(5) NOT NULL | Category |
17 | RESOURCE_SUB_CAT | Character(5) | VARCHAR2(5) NOT NULL | Subcategory |
18 | ASSET_OPTION | Character(3) | VARCHAR2(3) NOT NULL |
Asset Creation Option
ADD=Auto Assign New Asset ID ADJ=Adjust Existing Asset MAN=Manually Assign Asset ID Default Value: MAN |
19 | GROUP_ASSET_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Group Asset Flag
G=Group Asset M=Group Member N=None |
20 | TRANS_DT | Date(10) | DATE |
Transaction Date
Default Value: %DATE |
21 | ACCOUNTING_DT | Date(10) | DATE |
The accounting entry construction date for a given transaction (a generic field that crosses multiple
Default Value: %DATE |
22 | IN_SERVICE_DT | Date(10) | DATE |
In Service Date
Default Value: %DATE |
23 | RETIREMENT_DT | Date(10) | DATE | Projected Retirement Date |
24 | RETIRE_CONVENTION | Character(2) | VARCHAR2(2) NOT NULL | Retirement Convention |
25 | 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 Default Value: S |
26 | RETIREMENT_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Retirement Type
E=Extraordinary O=Ordinary Retirement Default Value: O |
27 | RETIREMENT_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Retirement Status
C=Depreciation Calculated N=New Retirement P=Posted to General Ledger R=Reinstated Retirement U=No Retirements Exist Default Value: U |
28 | RETIRE_QUANTITY | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Retirement Quantity |
29 | RETIREMENT_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Retirement Amount |
30 | PROCEEDS | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Retirement Proceeds |
31 | REMOVAL_COST | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Removal Cost |
32 | TRADE_IN_ASSET_ID | Character(12) | VARCHAR2(12) NOT NULL |
Trade In Asset
Prompt Table: ASSET |
33 | TRADE_IN_DTTM_STMP | DateTime(26) | TIMESTAMP | Trade In DateTime Stamp |
34 | TRADE_IN_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Trade In Amount |
35 | GAIN_LOSS | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Retirement Gain/Loss |
36 | CASH | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Cash Received/Paid |
37 | TRADE_IN_VALUE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Trade In value |
38 | NON_LIKE_KIND | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | FMV Non Like Kind Property |
39 | LIABILITY_ASSUMED | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Liabilities Assumed |
40 | FULLY_DEPR_SW | Character(1) | VARCHAR2(1) NOT NULL |
Retire As Fully Depreciated SW
F=Fully Depr with Future Expense N=Calculate Gain/Loss Y=Fully Depr no Future Expense |
41 | TXN_PROCEEDS | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Transaction Proceeds |
42 | TXN_REMOVAL_COST | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Transaction Removal Cost |
43 | TXN_CASH | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Transaction Cash |
44 | TXN_TRADE_IN_VALUE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Transaction Trade-In Value |
45 | TXN_NON_LIKE_KIND | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | FMV Non Like-Kind |
46 | TXN_LIAB_ASSUMED | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Transaction Liability Assumed |
47 | TXN_CURRENCY_CD2 | Character(3) | VARCHAR2(3) NOT NULL | Transaction Currency Display |
48 | RATE_MULT_2 | Signed Number(17,8) | DECIMAL(15,8) NOT NULL | Rate Multiplier |
49 | RATE_DIV_2 | Number(16,8) | DECIMAL(15,8) NOT NULL | Rate Divisor |
50 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
51 | TAGGABLE_SW | Character(1) | VARCHAR2(1) NOT NULL |
Taggable Asset
N=Non Taggable Asset Y=Taggable Asset |
52 | TAG_NUMBER | Character(12) | VARCHAR2(12) NOT NULL | Tag Number |
53 | 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 |
54 | REPLACE_SW | Character(1) | VARCHAR2(1) NOT NULL |
Replacement Asset
Default Value: N |
55 | REPLACE_ASSET_ID | Character(12) | VARCHAR2(12) NOT NULL | Replaced Asset ID |
56 | 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: C |
57 | CUSTODIAN | Character(30) | VARCHAR2(30) NOT NULL | Custodian |
58 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
59 | DEFAULT_PROFILE_SW | Character(1) | VARCHAR2(1) NOT NULL |
Default Books from Profile
Y/N Table Edit Default Value: Y |
60 | 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: NEW |
61 | INTFC_TYPE | Character(3) | VARCHAR2(3) NOT NULL |
Trans Load Type
Default Value: FAD |
62 | 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 |
63 | TRANS_CODE | Character(5) | VARCHAR2(5) NOT NULL | Transaction Code |
64 | 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.
Default Value: BPC |
65 | OPEN_TRANS_ID | Number(10,0) | DECIMAL(10) NOT NULL | Open Transaction ID |
66 | APPROVAL_SW | Character(1) | VARCHAR2(1) NOT NULL |
Auto Approval Status
Y/N Table Edit Default Value: Y |
67 | BOOK_EFFDT | Date(10) | DATE | Book Effective Date |
68 | LOCATION_EFFDT | Date(10) | DATE | Location Effective Date |
69 | ASSET_ALLOC_QTY | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Asset Allocation Basis Qty |
70 | ASSET_ALLOC_AMT | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Asset Allocation Basis Amt |
71 | IN_PROCESS_FLG | Character(1) | VARCHAR2(1) NOT NULL | In process flag |
72 | BOOK_PROCESSING_SW | Character(1) | VARCHAR2(1) NOT NULL |
Enable Book Processing
N=No Y=Yes Y/N Table Edit Default Value: N |
73 | PARENT_ASSET_SW | Character(1) | VARCHAR2(1) NOT NULL |
Parent Asset
N=No Y=Yes Default Value: N |
74 | DEPTID | Character(10) | VARCHAR2(10) NOT NULL |
Department
Prompt Table:
%EDIT_DEPT
|
75 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |
76 | MANUFACTURER | Character(60) | VARCHAR2(60) NOT NULL |
Manufacturer Name
Prompt Table:
MANUF_FS_VW
|
77 | MODEL | Character(30) | VARCHAR2(30) NOT NULL | Model |
78 | SERIAL_ID | Character(20) | VARCHAR2(20) NOT NULL | Serial ID |
79 | FILTER_DTTM | DateTime(26) | TIMESTAMP | Filter date time stamp |
80 | TXN_CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Transaction Currency |
81 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |