AMBI_INTFC_R_VW (SQL View)	Index Back
AM/BI Interface Assets from/to (range) pending to bill . Used to launch the AM_BI_INTFC AppEngine.

AMBI_INTFC_R_VW

(SQL View)

AM/BI Interface

Assets from/to (range) pending to bill . Used to launch the AM_BI_INTFC AppEngine.

SELECT A.BUSINESS_UNIT , A.ASSET_ID , A.BOOK , A.DTTM_STAMP FROM PS_AMBI_INTFC_BILL A , PS_OPEN_TRANS B WHERE A.AM_TRAN_LOAD = 'P' AND B.ASSET_ID = A.ASSET_ID AND B.BUSINESS_UNIT = A.BUSINESS_UNIT AND B.BOOK = A.BOOK AND B.DTTM_STAMP = A.DTTM_STAMP AND B.CALC_DIST_STATUS = 'C'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

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

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

4 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.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	ASSET_ID	Character(12)	VARCHAR2(12) NOT NULL	Asset Identification
3	BOOK	Character(10)	VARCHAR2(10) NOT NULL	Asset Book Name
4	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.