ASSET_CON_SRCH

(SQL View)
 Index Back

Asset Consolidation Add Search


SELECT A.INTFC_ID , A.INTFC_LINE_NUM , A.VOUCHER_ID , A.INVOICE_ID , A.PO_ID , A.RECEIVER_ID , A.RECV_LN_NBR , A.INV_ITEM_ID , A.PROJECT_ID , A.DEPTID , A.ACTIVITY_ID , %subrec(CF12_AN_SBR, A) , A.CATEGORY , A.VENDOR_ID FROM PS_INTFC_PHY_A A

# 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 VOUCHER_ID Character(8) VARCHAR2(8) NOT NULL Voucher ID
4 INVOICE_ID Character(30) VARCHAR2(30) NOT NULL Invoice Number
5 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
6 RECEIVER_ID Character(10) VARCHAR2(10) NOT NULL Receiver number
7 RECV_LN_NBR Number(5,0) INTEGER NOT NULL Receipt Line
8 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
9 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField
10 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
11 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID
12 OPERATING_UNIT Character(8) VARCHAR2(8) NOT NULL Operating Unit ChartField
13 PRODUCT Character(6) VARCHAR2(6) NOT NULL Product ChartField
14 FUND_CODE Character(5) VARCHAR2(5) NOT NULL Fund Code
15 CLASS_FLD Character(5) VARCHAR2(5) NOT NULL Class Field
16 PROGRAM_CODE Character(5) VARCHAR2(5) NOT NULL Program Code ChartField
17 BUDGET_REF Character(8) VARCHAR2(8) NOT NULL Budget Reference
18 AFFILIATE Character(5) VARCHAR2(5) NOT NULL Affiliate
19 AFFILIATE_INTRA1 Character(10) VARCHAR2(10) NOT NULL IntraUnit Affiliate1
20 AFFILIATE_INTRA2 Character(10) VARCHAR2(10) NOT NULL Operating Unit Affiliate
21 CHARTFIELD1 Character(10) VARCHAR2(10) NOT NULL Expansion chartfield 1
22 CHARTFIELD2 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 2
23 CHARTFIELD3 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 3
24 CATEGORY Character(5) VARCHAR2(5) NOT NULL Asset Category
25 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier