AM_INTFC_SRCH(SQL View) |
Index Back |
|---|---|
Asset Unitization Search |
| SELECT A.INTFC_ID , A.INTFC_LINE_NUM , A.BUSINESS_UNIT , A.ASSET_ID , A.VOUCHER_ID , A.VOUCHER_LINE_NUM , A.PO_ID , A.RECEIVER_ID , A.PROJECT_ID , A.SYSTEM_SOURCE , A.INTFC_TYPE , A.PI_ID , A.MC_DEFN_ID , A.MC_DEFN_ID , A.DESCR , A.SERIAL_ID , A.QUANTITY , A.LOAD_STATUS , A.APPROVAL_SW FROM PS_INTFC_PHY_A A UNION ALL SELECT A.INTFC_ID , A.INTFC_LINE_NUM , A.BUSINESS_UNIT , A.ASSET_ID , A.VOUCHER_ID , A.VOUCHER_LINE_NUM , ' ' , ' ' , A.PROJECT_ID , A.SYSTEM_SOURCE , A.INTFC_TYPE , A.PI_ID , A.MC_DEFN_ID , A.MC_DEFN_ID , B.DESCR , B.SERIAL_ID , A.QUANTITY , A.LOAD_STATUS , A.APPROVAL_SW FROM PS_INTFC_FIN A , PS_ASSET B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.ASSET_ID = B.ASSET_ID AND NOT EXISTS ( SELECT 'X' FROM PS_INTFC_PHY_A C WHERE C.INTFC_ID = A.INTFC_ID AND C.INTFC_LINE_NUM = A.INTFC_LINE_NUM AND C.MC_DEFN_ID = A.MC_DEFN_ID AND C.PI_ID = A.PI_ID) UNION ALL SELECT A.INTFC_ID , A.INTFC_LINE_NUM , A.BUSINESS_UNIT , A.ASSET_ID , A.VOUCHER_ID , A.VOUCHER_LINE_NUM , ' ' , ' ' , A.PROJECT_ID , A.SYSTEM_SOURCE , A.INTFC_TYPE , A.PI_ID , A.MC_DEFN_ID , A.MC_DEFN_ID , ' ' , ' ' , A.QUANTITY , A.LOAD_STATUS , A.APPROVAL_SW FROM PS_INTFC_FIN A WHERE A.INTFC_TYPE = 'ASD' AND LOAD_STATUS = 'DON' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  INTFC_ID |
Number(8,0) | INTEGER NOT NULL | Interface ID |
| 2 | INTFC_LINE_NUM |
Number(8,0) | INTEGER NOT NULL | Interface Line Number |
| 3 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: SP_BU_AM_NONVW |
| 4 | ASSET_ID |
Character(12) | VARCHAR2(12) NOT NULL | Asset Identification |
| 5 | VOUCHER_ID |
Character(8) | VARCHAR2(8) NOT NULL | Voucher ID |
| 6 | VOUCHER_LINE_NUM |
Number(5,0) | INTEGER NOT NULL | Voucher Line Number |
| 7 | PO_ID |
Character(10) | VARCHAR2(10) NOT NULL | Purchase Order |
| 8 | RECEIVER_ID |
Character(10) | VARCHAR2(10) NOT NULL | Receiver number |
| 9 | PROJECT_ID |
Character(15) | VARCHAR2(15) NOT NULL |
Project Id ChartField
Prompt Table: SP_PROJ4_NONVW |
| 10 | SYSTEM_SOURCE |
Character(3) | VARCHAR2(3) NOT NULL | Identifies the application or source system that generated a journal entry. Release 8.80 - 11/14/2002 - RVlasic - Removed GDM (JrnlGen - Deduction Management) from Translate Values. SUJ---Included a label as Product. Release 8.9 - 05/11/2005 - RVlasic - Added PRV (Variance Pricing) and PKK (KK Budget Journal) and deleted GLK for Project Costing per Brian Cohen. |
| 11 | INTFC_TYPE |
Character(3) | VARCHAR2(3) NOT NULL | Trans Load Type |
| 12 | PI_ID | Character(10) | VARCHAR2(10) NOT NULL | Physical Inventory ID |
| 13 | MC_DEFN_ID | Character(30) | VARCHAR2(30) NOT NULL | Mass Change Definition |
| 14 | PSDMUNIT_ID | Character(30) | VARCHAR2(30) NOT NULL |
Transaction
Prompt Table: PSDMT_RUN_AM_VW |
| 15 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 16 | SERIAL_ID | Character(20) | VARCHAR2(20) NOT NULL | Serial ID |
| 17 | QUANTITY | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Qty Interface |
| 18 | LOAD_STATUS | Character(3) | VARCHAR2(3) NOT NULL |
/* -> JMZ. PSOFT. 11-OCT-2002 */
New Status were added : HLD and INP for Asset Management.
/* <- JMZ. PSOFT. 11-OCT-2002 */
CON=Consolidated DON=Loaded ERR=Errored EXC=Excluded HLD=On Hold INP=In Process NEW=Pending PGI=PO Grp Incomplete REP=Replaced UNI=Unitized Default Value: NEW |
| 19 | APPROVAL_SW | Character(1) | VARCHAR2(1) NOT NULL |
Auto Approval Status
Y/N Table Edit Default Value: Y |