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 |