AMBI_INTFC_PROC

(SQL Table)
Index Back

AM Bill process

Populate AM/Billing background process.

# 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 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: P

6 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
7 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT

Prompt Table: SP_BUAMBI_NONVW

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

Prompt Table: AMBI_INTFC_R_VW

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

Prompt Table: AMBI_INTFC_R_VW