COST_GRP_TRF_T(SQL Table) |
Index Back |
---|---|
Asset Cost Group Transfer Temp |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | ASSET_ID | Character(12) | VARCHAR2(12) NOT NULL | Asset Identification |
2 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
3 | BOOK | Character(10) | VARCHAR2(10) NOT NULL |
Asset Book Name
Prompt Table: SP_BU_BK_NONVW |
4 | DTTM_STAMP_TRANS | DateTime(26) | TIMESTAMP | Trans Date Time Stamp |
5 | CF_SEQNO | Number(6,0) | INTEGER NOT NULL | Chartfield Sequence Number |
6 | GROUP_ASSET_ID | Character(12) | VARCHAR2(12) NOT NULL | Group Asset ID |
7 | 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. |
8 | PROJECT_ID | Character(15) | VARCHAR2(15) NOT NULL |
Project Id ChartField
Prompt Table: PROJECT_ID_VW |
9 | DEPTID | Character(10) | VARCHAR2(10) NOT NULL | Department |
10 | CATEGORY | Character(5) | VARCHAR2(5) NOT NULL |
Asset Category
Prompt Table: CATEGORY_TBL |
11 | COST_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Cost Type
Prompt Table: COST_TYPE_TBL |
12 | 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 |
13 | TRANS_IN_OUT | Character(1) | VARCHAR2(1) NOT NULL |
Transaction In/Out
I=In M=IUT Proceeds Markup O=Out |
14 | OPERATING_UNIT | Character(8) | VARCHAR2(8) NOT NULL | Operating Unit ChartField |
15 | PRODUCT | Character(6) | VARCHAR2(6) NOT NULL | Product ChartField |
16 | FUND_CODE | Character(5) | VARCHAR2(5) NOT NULL | Fund Code |
17 | CLASS_FLD | Character(5) | VARCHAR2(5) NOT NULL | Class Field |
18 | PROGRAM_CODE | Character(5) | VARCHAR2(5) NOT NULL | Program Code ChartField |
19 | BUDGET_REF | Character(8) | VARCHAR2(8) NOT NULL | Budget Reference |
20 | AFFILIATE | Character(5) | VARCHAR2(5) NOT NULL | Affiliate |
21 | AFFILIATE_INTRA1 | Character(10) | VARCHAR2(10) NOT NULL | IntraUnit Affiliate1 |
22 | AFFILIATE_INTRA2 | Character(10) | VARCHAR2(10) NOT NULL | Operating Unit Affiliate |
23 | CHARTFIELD1 | Character(10) | VARCHAR2(10) NOT NULL | Expansion chartfield 1 |
24 | CHARTFIELD2 | Character(10) | VARCHAR2(10) NOT NULL | Expansion Chartfield 2 |
25 | CHARTFIELD3 | Character(10) | VARCHAR2(10) NOT NULL | Expansion Chartfield 3 |
26 | BUSINESS_UNIT_PC | Character(5) | VARCHAR2(5) NOT NULL | PC Business Unit |
27 | ACTIVITY_ID | Character(15) | VARCHAR2(15) NOT NULL | Activity ID |
28 | RESOURCE_TYPE | Character(5) | VARCHAR2(5) NOT NULL | Source Type |
29 | RESOURCE_CATEGORY | Character(5) | VARCHAR2(5) NOT NULL | Category |
30 | RESOURCE_SUB_CAT | Character(5) | VARCHAR2(5) NOT NULL | Subcategory |
31 | ANALYSIS_TYPE | Character(3) | VARCHAR2(3) NOT NULL | Analysis Type |
32 | TRANS_DT | Date(10) | DATE | Transaction Date |
33 | COST | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Total Cost |
34 | SALVAGE_VALUE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Salvage Value |
35 | COUNT_1 | Number(3,0) | SMALLINT NOT NULL | Count Work Field |
36 | TRANSFER_BU | Character(5) | VARCHAR2(5) NOT NULL | Transfer Business Unit |
37 | TRANSFER_ASSET_ID | Character(12) | VARCHAR2(12) NOT NULL | Transfer Asset ID |
38 | TRANSFER_BOOK | Character(10) | VARCHAR2(10) NOT NULL | Transfer From Book |
39 | CONVENTION | Character(2) | VARCHAR2(2) NOT NULL |
Book Depreciation Convention
or Cost Convention
Prompt Table: CONV_TBL |
40 | GRP_ACCUM_DEPR | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Group Accum Depreciation |
41 | GRP_DEPR_YTD | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Group Member Depreciation YTD |
42 | TO_GROUP_ASSET | Character(12) | VARCHAR2(12) NOT NULL | To Group Asset ID |
43 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |