PeopleSoft 9
Asset Management

Table Name INTFC_BI2

Table Description
INTFC_BI2
Columns
Name Datatype Is PK Is FK
INTFC_ID int Yes Yes
INTFC_LINE_NUM int Yes Yes
TRANS_TYPE_BI char(4) Yes Yes
TRANS_TYPE_BI_SEQ smallint Yes Yes
PROCESS_INSTANCE decimal(10) No No
ADDRESS1 char(55) No No
ADDRESS2 char(55) No No
ADDRESS3 char(55) No No
ADDRESS4 char(55) No No
IN_CITY_LIMIT char(1) No No
GEO_CODE char(11) No No
CITY char(30) No No
HOUSE_TYPE char(2) No No
ADDR_FIELD1 char(2) No No
ADDR_FIELD2 char(4) No No
ADDR_FIELD3 char(4) No No
NUM1 char(6) No No
NUM2 char(4) No No
COUNTY char(30) No No
STATE char(6) No No
POSTAL char(12) No No
COUNTRY char(3) No No
TAX_AMT decimal(26,3) No No
TAX_PCT decimal(6,4) No No
MAX_TAX_FLG char(1) No No
TAX_JUR_IND char(1) No No
VAT_BASIS_AMT decimal(26,3) No No
VAT_AMT decimal(26,3) No No
VAT_TRANS_AMT decimal(26,3) No No
TAX_CD_VAT_PCT decimal(7,4) No No
EXD_INVOICE_NO char(10) No No
EXD_INVOICE_LINE int No No
EXD_APPL_FLG char(1) No No
STX_APPL_FLG char(1) No No
STX_TAX_AUTH_CD char(8) No No
EXD_TAX_RATE_CD char(10) No No
STX_TAX_RATE_CD char(10) No No
INV_ITEM_ID char(18) No No
ORG_SETID char(5) No No
ORG_CODE char(6) No No
ORG_TAX_LOC_CD char(10) No No
EXD_CONVERSION_RT decimal(15,8) No No
QTY_BASE decimal(15,4) No No
EXS_TAX_TXN_TYPE char(4) No No
EXD_CUST_CATG_CD char(10) No No
STX_CUST_CATG_CD char(10) No No
EXD_ITM_CATG_CD char(10) No No
STX_ITM_CATG_CD char(10) No No
EXS_SERV_TAX_FLG char(1) No No
EXD_ASSESS_VALUE decimal(26,3) No No
EXD_UOM char(3) No No
EXD_USE_AV_FLG char(1) No No
BI_CURRENCY_CD char(3) No No
BASE_CURRENCY char(3) No No
EXS_CURRENCY_RPTG char(3) No No
EXD_TAX_AMT decimal(26,3) No No
EXD_TAX_AMT_BSE decimal(26,3) No No
EXD_TAX_AMT_RPT decimal(26,3) No No
STX_TAX_AMT decimal(26,3) No No
STX_TAX_AMT_BSE decimal(26,3) No No
STX_TAX_AMT_RPT decimal(26,3) No No
STX_FORM_CD char(8) No No
LOAD_STATUS_BI char(3) No No
ERROR_STATUS_BI char(4) No No
ADD_DTTM PSDATETIME No No
LAST_UPDATE_DTTM PSDATETIME No No
Index
Name Type Unique Member
PS_INTFC_BI2 PK Yes
Member(s) of "PS_INTFC_BI2" Index
INTFC_ID
INTFC_LINE_NUM
TRANS_TYPE_BI
TRANS_TYPE_BI_SEQ

Published December 16, 2006