PeopleSoft 9
Asset Management

Table Name INTFC_PHY_A

Table Description
INTFC_PHY_A
Columns
Name Datatype Is PK Is FK
INTFC_ID int Yes No
INTFC_LINE_NUM int Yes No
BUSINESS_UNIT char(5) Yes No
ASSET_ID char(12) Yes No
DTTM_STAMP PSDATETIME Yes No
VOUCHER_ID char(8) Yes No
VOUCHER_LINE_NUM int Yes No
DISTRIB_LINE_NUM int Yes No
INTFC_TYPE char(3) Yes No
MC_DEFN_ID char(30) Yes No
ASSET_TYPE char(3) No No
ASSET_SUBTYPE char(15) No No
SYSTEM_SOURCE char(3) No No
APPROVAL_SW char(1) No No
INTFC_STATUS char(3) No No
LOAD_STATUS char(3) No No
ORIG_INTFC_ID int No No
ORIG_LINE_NUM int No No
DEFAULT_PROFILE_SW char(1) No No
TRANS_IN_OUT char(1) No No
PARENT_ID char(12) No No
PARENT_DESCR char(30) No No
PARENT_DESCRLONG50 char(50) No No
COMPONENT_OF_ID char(12) No No
ASSET_ASSIGNED_TO char(12) No No
TAGGABLE_SW char(1) No No
TAG_NUMBER char(12) No No
DESCR char(30) No No
DESCRSHORT char(10) No No
ASSET_STATUS char(1) No No
FINANCIAL_ASSET_SW char(1) No No
REPLACE_SW char(1) No No
REPLACE_ASSET_ID char(12) No No
CONVERSION_ID char(15) No No
NEW_ASSET_SW char(1) No No
AVAIL_SW char(1) No No
AVAIL_CONTACT char(30) No No
AVAIL_PHONE char(12) No No
ACQUISITION_CD char(1) No No
ACQUISITION_DT PSDATE No No
FINANCING_CD char(5) No No
ASSET_DTTM_STAMP PSDATETIME No No
PROFILE_ID char(10) No No
ASSET_CLASS char(10) No No
CAP_NUM char(15) No No
MFG_ID char(50) No No
MANUFACTURER char(30) No No
MODEL char(30) No No
PROD_VERSION char(10) No No
SERIAL_ID char(20) No No
PRODUCTION_DT PSDATE No No
PLANT char(30) No No
MANUFACTUR_CONTACT char(30) No No
CAP_SEQUENCE smallint No No
REPLACEMENT_COST decimal(26,3) No No
LEASE_ASSET_ID char(12) No No
BUSINESS_UNIT_JV char(5) No No
INDEX_NAME char(20) No No
INDEX_DETAIL_NAME char(35) No No
LAST_INDEX_VALUE decimal(26,3) No No
COMPOSITE_SW char(1) No No
COMPOSITE_ID char(12) No No
FERC_CD char(10) No No
SEQUENCE_NBR_6 int No No
ACQUISITION_DESCR char(30) No No
CAPITALIZATION_SW char(1) No No
BUSINESS_UNIT_AP char(5) No No
TXN_CURRENCY_CD char(3) No No
CURRENCY_CD char(3) No No
RATE_DIV decimal(15,8) No No
RATE_MULT decimal(15,8) No No
RT_TYPE char(5) No No
BUSINESS_UNIT_PO char(5) No No
PO_ID char(10) No No
PO_LINE_NBR int No No
SCHED_NBR smallint No No
PO_DIST_LINE_NUM int No No
REFERENCE_ID char(10) No No
INVOICE_DT PSDATE No No
VENDOR_ID char(10) No No
VENDOR_NAME char(30) No No
INVOICE_ID char(30) No No
TXN_AMOUNT decimal(26,3) No No
AMOUNT decimal(26,3) No No
QUANTITY decimal(15,4) No No
SALETX_AMT decimal(26,3) No No
SALETX_AMT_BSE decimal(26,3) No No
SALETX_CD char(8) No No
USETAX_AMT decimal(26,3) No No
USETAX_AMT_BSE decimal(26,3) No No
USETAX_CD char(8) No No
FREIGHT_AMT decimal(26,3) No No
FREIGHT_AMT_BSE decimal(26,3) No No
BUSINESS_UNIT_RECV char(5) No No
RECEIVER_ID char(10) No No
RECV_LN_NBR int No No
RECV_SHIP_SEQ_NBR smallint No No
RECV_DIST_LINE_NUM int No No
DISTRIB_SEQ_NUM int No No
INV_ITEM_ID char(18) No No
OPERATING_UNIT char(8) No No
PRODUCT char(6) No No
FUND_CODE char(5) No No
CLASS_FLD char(5) No No
PROGRAM_CODE char(5) No No
BUDGET_REF char(8) No No
AFFILIATE char(5) No No
AFFILIATE_INTRA1 char(10) No No
AFFILIATE_INTRA2 char(10) No No
CHARTFIELD1 char(10) No No
CHARTFIELD2 char(10) No No
CHARTFIELD3 char(10) No No
PROJECT_ID char(15) No No
DEPTID char(10) No No
CATEGORY char(5) No No
COST_TYPE char(1) No No
BUSINESS_UNIT_PC char(5) No No
MASTER_PROJECT char(15) No No
ACTIVITY_ID char(15) No No
RESOURCE_TYPE char(5) No No
RESOURCE_SUB_CAT char(5) No No
ANALYSIS_TYPE char(3) No No
RESOURCE_CATEGORY char(5) No No
CUSTODIAN_EFFDT PSDATE No No
EFFSEQ smallint No No
CUSTODIAN char(30) No No
EMPLID char(11) No No
CUSTODIAN_DEPTID char(10) No No
CUSTODIAN_PROJECT char(15) No No
OFFSITE_SW char(1) No No
AUTH_STATUS char(1) No No
AUTHORIZATION_NAME char(30) No No
AUTHORIZATION_DT PSDATE No No
LOCATION_EFFDT PSDATE No No
LOCATION_EFFSEQ smallint No No
LOCATION char(10) No No
PI_ID char(10) No No
INVENTORY_DT PSDATE No No
PERFORMED_BY char(30) No No
DOCUMENT_ID char(12) No No
LOC_AUTH_STATUS char(1) No No
LOC_AUTH_NAME char(30) No No
LOC_AUTH_DT PSDATE No No
REPLACE_COST_DT PSDATE No No
GROUP_ASSET_FLAG char(1) No No
GROUP_ASSET_ID char(12) No No
RD_PLANT_ASSET char(1) No No
RD_START_DT PSDATE No No
RD_USE_NBV char(1) No No
INCENTIVE_ID char(10) No No
IP_ADDRESS char(15) No No
IP_ALIAS char(35) No No
MERCH_AMT_BSE decimal(26,3) No No
VAT_INV_AMT decimal(26,3) No No
VAT_INV_AMT_BSE decimal(26,3) No No
VAT_NRCVR_AMT decimal(26,3) No No
VAT_NRCVR_AMT_BSE decimal(26,3) No No
VAT_RCVRY_AMT decimal(26,3) No No
VAT_RCVRY_AMT_BSE decimal(26,3) No No
MISC_AMT decimal(26,3) No No
MISC_AMT_BSE decimal(26,3) No No
AM_AST_UD_CHAR1 char(10) No No
AM_AST_UD_CHAR2 char(10) No No
AM_AST_UD_DATE1 PSDATE No No
AM_AST_UD_NUM1 decimal(18,3) No No
AM_AST_UD_NUM2 decimal(18,3) No No
PROCESS_INSTANCE decimal(10) No No
MERCHANDISE_AMT decimal(26,3) No No
SKU char(50) No No
UPC_ID char(18) No No
VIN char(18) No No
ASSET_RESOURCE_SW char(1) No No
ALLOW_OVERBOOK_SW char(1) No No
CHARGE_BACK_SW char(1) No No
SCHEDULABLE_SW char(1) No No
EPL_TMPL_ID char(15) No No
REPAIRABLE_FLG char(1) No No
REPAIR_STATUS char(1) No No
BUSINESS_UNIT_WO char(5) No No
SHOP_ID char(10) No No
UNOWNED_FLG char(1) No No
WO_LOCATION_FLG char(1) No No
OFFLINE_FLG char(1) No No
ASSET_CRITICALITY char(2) No No
CREW_ID CHAR(10) No No
AVAIL_FOR_USE char(1) No No
PROPERTY_ID decimal(10) No No
PROPERTY_DESCR char(50) No No
PROPERTY_NM char(50) No No
PROPERTY_CLASS char(2) No No
PROPERTY_SUBCLASS char(20) No No
PARENT_PROPERTY_ID decimal(10) No No
SITE_PROPERTY_ID decimal(10) No No
BLDG_PROPERTY_ID decimal(10) No No
FLOOR_PROPERTY_ID decimal(10) No No
AREA_PROPERTY_ID decimal(10) No No
SPACE_PROPERTY_ID decimal(10) No No
PARCEL_NUMBER char(30) No No
LOT char(20) No No
BLOCK char(20) No No
TOTAL_AREA decimal(17,3) No No
SPACE_UOM char(1) No No
CURRENT_OCCUPANCY int No No
MAX_OCCUPANCY int No No
OCCUPANCY_STATUS char(2) No No
OWNERSHIP_STATUS char(2) No No
IT_UD_CHAR1 char(50) No No
IT_UD_CHAR2 char(50) No No
IT_UD_DATE1 PSDATE No No
IN_SERVICE_DT PSDATE No No
REGION_CD char(10) No No
CC_FLAG char(3) No No
DESCR_LONG CHAR(254) No No
AREA_ID CHAR(10) No No
LINEAR_ASSET_SW CHAR(1) No No
NBR_OF_CPU SMALLINT No No
LEGAL_DESCR TEXT No No
Index
Name Type Unique Member
PS_INTFC_PHY_A PK Yes
PS0INTFC_PHY_A IE1 No
PSAINTFC_PHY_A IE1 No
PSBINTFC_PHY_A IE2 No
Member(s) of "PS_INTFC_PHY_A" Index
INTFC_ID
INTFC_LINE_NUM
BUSINESS_UNIT
ASSET_ID
DTTM_STAMP
VOUCHER_ID
VOUCHER_LINE_NUM
DISTRIB_LINE_NUM
INTFC_TYPE
MC_DEFN_ID
Member(s) of "PS0INTFC_PHY_A" Index
PROPERTY_ID
INTFC_ID
INTFC_LINE_NUM
BUSINESS_UNIT
ASSET_ID
DTTM_STAMP
VOUCHER_ID
VOUCHER_LINE_NUM
DISTRIB_LINE_NUM
INTFC_TYPE
MC_DEFN_ID
Member(s) of "PSAINTFC_PHY_A" Index
INTFC_ID
LOAD_STATUS
APPROVAL_SW
INTFC_TYPE
DEFAULT_PROFILE_SW
Member(s) of "PSBINTFC_PHY_A" Index
PROCESS_INSTANCE

Published December 16, 2006