PeopleSoft 9
Asset Management

Table Name INTFC_BI

Table Description
INTFC_BI
Columns
Name Datatype Is PK Is FK
INTFC_ID int Yes No
INTFC_LINE_NUM int Yes No
TRANS_TYPE_BI char(4) Yes No
TRANS_TYPE_BI_SEQ smallint Yes No
HDR_FIELDS_KEY char(30) No No
HDR_FIELDS_BILL_BY char(1) No No
ADJ_TRANS_TYPE char(5) No No
CREATE_NEW_BILL char(1) No No
TMP_BILL_FLG char(1) No No
ENTRY_TYPE char(5) No No
ENTRY_REASON char(5) No No
ENTRY_EVENT char(10) No No
LOAD_STATUS_BI char(3) No No
ERROR_STATUS_BI char(4) No No
BUSINESS_UNIT char(5) No No
BUSINESS_UNIT_GL char(5) No No
BILL_TO_CUST_ID char(15) No No
ADDRESS_SEQ_NUM INT No No
BILL_TO_COPIES smallint No No
CNTCT_SEQ_NUM INT No No
NAME1 char(40) No No
INTERUNIT_FLG char(1) No No
BUSINESS_UNIT_TO char(5) No No
DIRECT_INVOICING char(1) No No
RANGE_SELECTION_ID char(30) No No
BILL_SOURCE_ID char(10) No No
BILL_TYPE_ID char(3) No No
BILL_CYCLE_ID char(10) No No
BILL_BY_ID char(10) No No
PAYMENT_METHOD char(3) No No
PYMNT_TERMS_CD char(5) No No
BANK_CD char(5) No No
BANK_ACCT_KEY char(4) No No
BI_CURRENCY_CD char(3) No No
BASE_CURRENCY char(3) No No
CUR_RT_TYPE char(5) No No
RATE_MULT decimal(15,8) No No
RATE_DIV decimal(15,8) No No
CUR_RT_SOURCE char(1) No No
INVOICE_DT PSDATE No No
ACCOUNTING_DT PSDATE No No
ACCRUE_UNBILLED char(1) No No
TARGET_INVOICE char(22) No No
INVOICE char(22) No No
DOC_TYPE char(8) No No
CONSOL_SETID char(5) No No
CONSOL_CUST_ID char(15) No No
CONSOL_KEY char(22) No No
INVOICE_TO_ADJ char(22) No No
ADJ_DELTA_ACTION char(3) No No
LINE_SEQ_TO_ADJ int No No
LINE_SEQ_NUM int No No
LINE_DST_SEQ_NUM smallint No No
LINE_DFR_SEQ_NUM smallint No No
LINE_UAR_SEQ_NUM smallint No No
LAST_NOTE_SEQ_NUM smallint No No
NOTES_SEQ_NUM smallint No No
LINE_TYPE char(4) No No
IDENTIFIER char(18) No No
DESCR char(30) No No
UNIT_OF_MEASURE char(3) No No
QTY decimal(15,4) No No
ORIG_QTY decimal(15,4) No No
UNIT_AMT decimal(15,4) No No
LIST_PRICE decimal(15,4) No No
PPRC_PROMO_CD char(20) No No
MERCH_TYPE char(10) No No
TAX_CD char(8) No No
TAX_EXEMPT_CERT char(30) No No
TAX_EXEMPT_FLG char(1) No No
TAX_EXEMPT_RC char(2) No No
TAX_JOB_NUM char(10) No No
BI_TAX_TIMING char(1) No No
CUSTOMER_GROUP char(10) No No
VAT_TXN_TYPE_CD char(4) No No
TAX_CD_VAT char(8) No No
VAT_APPLICABILITY char(1) No No
VAT_PRODUCT_GROUP char(10) No No
PROD_GRP_SETID char(5) No No
IST_TXN_FLG char(1) No No
IDENTIFIER_TBL char(3) No No
SHIP_FROM_LOC char(10) No No
ORD_ACCEPT_LOC char(10) No No
ORD_ORIGIN_LOC char(10) No No
STORE_LOC char(10) No No
TITLE_PASSAGE char(1) No No
TAX_GROUP char(10) No No
TAX_USER_AREA char(25) No No
TAX_TRANS_TYPE char(1) No No
TAX_TRANS_SUB_TYPE char(1) No No
NET_EXTENDED_AMT decimal(26,3) No No
GROSS_EXTENDED_AMT decimal(26,3) No No
REV_RECOG_BASIS char(3) No No
PROJECT_ID char(15) No No
BUSINESS_UNIT_OM char(5) No No
ORDER_NO char(10) No No
ORDER_INT_LINE_NO int No No
SCHED_LINE_NBR int No No
DEMAND_SOURCE char(2) No No
DEMAND_LINE_NO smallint No No
BUSINESS_UNIT_RMA char(5) No No
RMA_ID char(10) No No
RMA_LINE_NBR int No No
PRODUCT_ID char(18) No No
ORDER_DATE PSDATE No No
PO_REF char(30) No No
PO_LINE smallint No No
CONTRACT_NUM char(25) No No
CONTRACT_DT PSDATE No No
CONTRACT_TYPE char(15) No No
CONTRACT_LINE_NUM smallint No No
FREIGHT_TERMS char(10) No No
BILL_OF_LADING char(30) No No
COUNTRY_SHIP_FROM char(3) No No
COUNTRY_SHIP_TO char(3) No No
SHIP_TO_CUST_ID char(15) No No
SHIP_TO_ADDR_NUM INT No No
SHIP_ID char(10) No No
SHIP_TYPE_ID char(10) No No
SHIP_FROM_BU char(5) No No
SHIP_DATE PSDATE No No
SHIP_TIME PSTIME No No
PACKSLIP_NO char(22) No No
LC_ID char(12) No No
LOC_DOC_ID char(15) No No
SEQUENCE_NBR smallint No No
SOLD_TO_CUST_ID char(15) No No
SOLD_TO_ADDR_NUM INT No No
BUSINESS_UNIT_PC char(5) No No
BUSINESS_UNIT_CA char(5) No No
RT_EFFDT PSDATE No No
BILL_PLAN_ID char(10) No No
PC_DISTRIB_STATUS char(1) No No
BPLAN_LN_NBR smallint No No
EVENT_OCCURRENCE smallint No No
XREF_SEQ_NUM int No No
CONTRACT_PPD_SEQ int No No
ANALYSIS_TYPE char(3) No No
RESOURCE_ID char(40) No No
RESOURCE_TYPE char(5) No No
RESOURCE_CATEGORY char(5) No No
RESOURCE_SUB_CAT char(5) No No
ACTIVITY_ID char(15) No No
ACTIVITY_TYPE char(5) No No
DIST_CFG_FLAG char(1) No No
PRODUCT_KIT_ID char(18) No No
SYSTEM_SOURCE char(3) No No
EMPLID char(11) No No
EMPL_RCD smallint No No
START_DT PSDATE No No
END_DT PSDATE No No
FROM_DT PSDATE No No
TO_DT PSDATE No No
SERVICE_CUST_ID char(15) No No
SERVICE_ADDR_NUM INT No No
NOTE_TYPE char(10) No No
STD_NOTE_FLAG char(1) No No
INTERNAL_FLAG char(1) No No
HDR_OR_LINE_NOTE char(1) No No
AR_LVL char(1) No No
AR_DST_OPT char(1) No No
GL_LVL char(1) No No
ENABLE_DFR_REV_FLG char(1) No No
BILLING_SPECIALIST char(8) No No
BILLING_AUTHORITY char(8) No No
BILLING_FREQUENCY char(3) No No
BILL_INQUIRY_PHONE char(24) No No
SALES_PERSON char(8) No No
COLLECTOR char(8) No No
CR_ANALYST char(8) No No
INVOICE_FORM_ID char(10) No No
STD_NOTE_CD char(10) No No
TOT_LINE_DST_AMT decimal(26,3) No No
TOT_LINE_DST_PCT decimal(5,2) No No
TOT_LINE_DFR_PCT decimal(5,2) No No
TOT_LINE_DFR_AMT decimal(26,3) No No
TOT_LINE_UAR_AMT decimal(26,3) No No
TOT_LINE_UAR_PCT decimal(5,2) No No
SSN char(9) No No
CHARGE_FROM_DT PSDATE No No
CHARGE_TO_DT PSDATE No No
SUBCUST_QUAL1 char(15) No No
SUBCUST_QUAL2 char(15) No No
REIMB_AGREEMENT char(25) No No
TOT_DISCOUNT_AMT decimal(26,3) No No
TOT_SURCHARGE_AMT decimal(26,3) No No
ACCUMULATE char(1) No No
VAT_TREATMENT_GRP char(4) No No
COUNTRY_VAT_BILLFR char(3) No No
COUNTRY_VAT_BILLTO char(3) No No
VAT_TREATMENT char(4) No No
PHYSICAL_NATURE char(1) No No
COUNTRY_LOC_BUYER char(3) No No
STATE_LOC_BUYER char(6) No No
COUNTRY_LOC_SELLER char(3) No No
STATE_LOC_SELLER char(6) No No
VAT_SVC_SUPPLY_FLG char(1) No No
VAT_SERVICE_TYPE char(1) No No
COUNTRY_VAT_PERFRM char(3) No No
STATE_VAT_PERFRM char(6) No No
COUNTRY_VAT_SUPPLY char(3) No No
STATE_VAT_SUPPLY char(6) No No
STATE_SHIP_FROM char(6) No No
STATE_SHIP_TO char(6) No No
MAST_CONTR_ID char(25) No No
TAX_CUST_ID char(15) No No
BUSINESS_UNIT_AM char(5) No No
BUSINESS_UNIT_AMTO char(5) No No
ASSET_ID char(12) No No
PROFILE_ID char(10) No No
COST_TYPE char(1) No No
STATE_VAT_DEFAULT char(6) No No
SO_ID CHAR(15) No No
BUSINESS_UNIT_RF char(5) No No
SOURCE_REF_TYPE char(3) No No
SOURCE_REF_NO char(35) No No
SOURCE_REF_KEY char(5) No No
ACCEPTGIRO_IND char(1) No No
CA_PGP_SEQ smallint No No
SUM_TEMPLATE_ID char(16) No No
SUM_GROUP_TYPE char(4) No No
SUM_GROUP_ID char(16) No No
CUST_DEPOSIT_ID char(15) No No
TAX_DATE PSDATE No No
GROUP_CODE int No No
SRV_PERFORM_LOC char(10) No No
TAX_DIVISION char(5) No No
TAX_DEPARTMENT char(5) No No
PT_SALE_FLG char(1) No No
CUST_PICKUP char(1) No No
CUSTOMER_PO_LINE CHAR(11) No No
CUSTOMER_PO_SCHED CHAR(11) No No
USER_AMT1 decimal(26,3) No No
USER_AMT2 decimal(26,3) No No
USER_DT1 PSDATE No No
USER_DT2 PSDATE No No
USER1 char(1) No No
USER2 char(1) No No
USER3 char(1) No No
USER4 char(1) No No
USER5 char(1) No No
USER6 char(1) No No
USER7 char(1) No No
USER8 char(1) No No
USER9 char(1) No No
SETID char(5) No No
PROCESS_INSTANCE decimal(10) No No
ADD_DTTM PSDATETIME No No
LAST_UPDATE_DTTM PSDATETIME No No
Index
Name Type Unique Member
PS_INTFC_BI PK Yes
PSAINTFC_BI IE1 No
PSBINTFC_BI IE2 No
PSCINTFC_BI IE3 No
PSDINTFC_BI IE4 No
Member(s) of "PS_INTFC_BI" Index
INTFC_ID
INTFC_LINE_NUM
TRANS_TYPE_BI
TRANS_TYPE_BI_SEQ
Member(s) of "PSAINTFC_BI" Index
INTFC_LINE_NUM
TRANS_TYPE_BI
INTFC_ID
TRANS_TYPE_BI_SEQ
BUSINESS_UNIT
LOAD_STATUS_BI
PROCESS_INSTANCE
Member(s) of "PSBINTFC_BI" Index
HDR_FIELDS_KEY
INTFC_ID
Member(s) of "PSCINTFC_BI" Index
INVOICE
INTFC_LINE_NUM
TRANS_TYPE_BI
INTFC_ID
BUSINESS_UNIT
Member(s) of "PSDINTFC_BI" Index
BILL_TO_CUST_ID
INTFC_LINE_NUM
TRANS_TYPE_BI
BUSINESS_UNIT

Published December 16, 2006