AMPARCHDIU_RQST

(SQL Table)
Index Back

AM Parent-Child IUT Request

Request panel for parent-child interunit transfer application engine

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
3 REQUEST_ID Character(10) VARCHAR2(10) NOT NULL Request ID

Default Value: 1

4 PROCESS_FREQUENCY Character(1) VARCHAR2(1) NOT NULL Process Frequency
A=Always Process
N=Don't Run
O=Process Once

Default Value: N

5 PROCESS_STATUS Character(1) VARCHAR2(1) NOT NULL Process Status
A=Active
C=Successfully Completed
E=Completed With Errors
N=Not Yet Processed
P=Processing Now
X=No Success

Default Value: N

6 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT

Prompt Table: SP_BU_AM_NONVW

7 ASSET_ID Character(12) VARCHAR2(12) NOT NULL Asset Identification

Prompt Table: PARENTASSET_VW2

8 NEW_BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL New Business Unit

Prompt Table: SP_BU_AM_NONVW

9 PROFILE_ID Character(10) VARCHAR2(10) NOT NULL Asset Profile ID

Prompt Table: PROFILE_IU_VW

10 CONVENTION Character(2) VARCHAR2(2) NOT NULL Book Depreciation Convention or Cost Convention

Default Value: AM

Prompt Table: CONV_BU_VW

11 TRANS_DT Date(10) DATE NOT NULL Transaction Date

Default Value: %DATE

12 ACCOUNTING_DT Date(10) DATE NOT NULL The accounting entry construction date for a given transaction (a generic field that crosses multiple

Default Value: %DATE

13 TRANS_CODE Character(5) VARCHAR2(5) NOT NULL Transaction Code

Prompt Table: TRANS_CODE_TBL

14 NUM_CHILD_ASSETS Number(5,0) INTEGER NOT NULL Number of Child Assets
15 INCL_PARENT_ASSET Character(1) VARCHAR2(1) NOT NULL Include Parent Asset

Default Value: Y

16 WHERE_CLAUSE_LONG Long Character(4000) CLOB Where Clause
17 GROUP_ASSET_ID Character(12) VARCHAR2(12) NOT NULL Group Asset ID

Prompt Table: BU_GRP_ASST2_VW