OPR_DEF_TBL_AM(SQL Table) |
Index Back |
---|---|
Operator Defaults - PS/AMOperator Defaults - PS/AM |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | OPRID | Character(30) | VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Prompt Table: OPRID_VW |
2 | RPT_GROUP_ID | Character(15) | VARCHAR2(15) NOT NULL |
On-Line Reporting Group Id
Prompt Table: RPT_DRILLFLD_VW |
3 | ACCOUNTING_DT | Date(10) | DATE | The accounting entry construction date for a given transaction (a generic field that crosses multiple |
4 | TRANS_DT | Date(10) | DATE | Transaction Date |
5 | EDIT_FIN_TBL | Character(1) | VARCHAR2(1) NOT NULL |
Edit Financial Information
A=All D=Date Only N=None Default Value: N |
6 | EDIT_PHYA_TBL | Character(1) | VARCHAR2(1) NOT NULL |
Edit Phy A Information
A=All N=None Default Value: N |
7 | EDIT_PHYB_TBL | Character(1) | VARCHAR2(1) NOT NULL |
Edit Phy B Information
A=All N=None Default Value: N |
8 | RUN_AMIF1000_IMP | Character(1) | VARCHAR2(1) NOT NULL |
Impairment/Revaluation Process
Y/N Table Edit Default Value: Y |
9 | GRP_IMP_PROC_OPT | Character(30) | VARCHAR2(30) NOT NULL |
Asset Management Integration
Y/N Table Edit Default Value: N |
10 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: SP_BU_AM_NONVW |
11 | SPACE_UOM | Character(3) | VARCHAR2(3) NOT NULL |
Space Unit of measure (Sq Feet or Sq Meters)
Prompt Table:
UNITS_TBL
|
12 | PROPERTY_CLASS | Character(2) | VARCHAR2(2) NOT NULL |
Property Class
10=Site 20=Building 30=Floor 40=Area 50=Space |
13 | ARO_RUN_AMIF1000 | Character(1) | VARCHAR2(1) NOT NULL |
Asset Retirement Obligations
Y/N Table Edit Default Value: N |
14 | EDIT_UNI_SW | Character(1) | VARCHAR2(1) NOT NULL |
Edit Unitization Information
A=All N=None O=Operational Asset Details Default Value: O |
15 | EDIT_CON_SW | Character(1) | VARCHAR2(1) NOT NULL |
Edit Consolidation Information
A=All N=None O=Operational Asset Details Default Value: O |
16 | CON_DFLT_DIST_SW | Character(1) | VARCHAR2(1) NOT NULL |
To Default Distribution Only
Y/N Table Edit Default Value: N |
17 | EDIT_PREAM_SW | Character(1) | VARCHAR2(1) NOT NULL |
Edit Review AP/PO Information
A=All D=Dates Only N=None O=Operational Asset Details Default Value: O |
18 | EDIT_INTFCTXN_SW | Character(1) | VARCHAR2(1) NOT NULL |
Edit Review Transactions Info.
A=All D=Dates Only N=None O=Operational Asset Details Default Value: N |
19 | BUSINESS_UNIT_AT | Character(5) | VARCHAR2(5) NOT NULL |
Asset Tracking Business Unit.
Prompt Table: SP_BU_AM_NONVW |