AMDP2150_RQST

(SQL Table)
Index Back

Request for program AMDP2150

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

Default Value: PRCSRUNCNTL.OPRID

2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID

Default Value: PRCSRUNCNTL.RUN_CNTL_ID

3 REQUEST_ID Character(10) VARCHAR2(10) NOT NULL Request ID
4 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: SP_BU_AM_NONVW

5 BOOK Character(10) VARCHAR2(10) NOT NULL Asset Book Name

Prompt Table: SP_BOOKG1_NONVW

6 ASSET_ID_FROM Character(12) VARCHAR2(12) NOT NULL From Asset ID

Prompt Table: ASSET_BOOK_VW

7 ASSET_ID_TO Character(12) VARCHAR2(12) NOT NULL Asset ID to

Prompt Table: ASSET_BOOK_VW

8 GROUP_ASSET_ID Character(12) VARCHAR2(12) NOT NULL Group Asset ID

Prompt Table: BU_GRP_ASSET_VW

9 FISCAL_YEAR Number(4,0) SMALLINT NOT NULL Fiscal Year
10 ACCOUNTING_PERIOD Number(3,0) SMALLINT NOT NULL Identifies a time period to which you post transactions. Typically, an accounting period represents a month, but it can also represent a week, a day, or any user-defined interval. An accounting period has a beginning date and an ending date, and is defined in the calendar table.
11 TRANS_DT Date(10) DATE Transaction Date
12 INSERT_REQUEST_SW Character(1) VARCHAR2(1) NOT NULL Insert Depr Request Switch

Y/N Table Edit

Default Value: N