PeopleSoft 9
Asset Management

Table Name INTFC_BI_HDR

Table Description
INTFC_BI_HDR
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
HDR_FIELDS_KEY char(30) Yes No
HDR_TRANS_TYPE char(3) Yes No
PROCESS_INSTANCE decimal(10) No No
LOAD_STATUS_BI char(3) No No
ERROR_STATUS_BI char(4) No No
BUSINESS_UNIT char(5) No No
INVOICE char(22) No No
BUSINESS_UNIT_GL char(5) No No
BUSINESS_UNIT_TO char(5) No No
TARGET_INVOICE char(22) No No
DST_ID_AR char(10) No No
ACCOUNT char(10) No No
ALTACCT char(10) No No
DEPTID char(10) 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
STATISTICS_CODE char(3) No No
PAID_AMT decimal(26,3) No No
PAID_REFERENCE char(30) No No
BI_PAID_AT_SRC char(1) No No
VAT_CALC_GROSS_NET char(1) No No
VAT_DCLRTN_DT PSDATE No No
VAT_DCLRTN_DT_SRC char(1) No No
VAT_DCLRTN_POINT char(1) No No
VAT_DST_ACCT_TYPE char(4) No No
VAT_EXCPTN_CERTIF char(20) No No
VAT_EXCPTN_TYPE char(1) No No
VAT_RECALC_FLG char(1) No No
VAT_ROUND_RULE char(1) No No
VAT_RGSTRN_BUYER char(12) No No
VAT_RGSTRN_SELLER char(12) No No
PROVINCE char(1) No No
CR_CARD_DIGITS char(4) No No
CR_CARD_EXPMO char(2) No No
CR_CARD_EXPYR char(4) No No
CR_CARD_FNAME char(40) No No
CR_CARD_LNAME char(40) No No
CR_CARD_NBR char(44) No No
CR_CARD_TYPE char(2) No No
NAME_EXACT char(40) No No
EXPIRATION_DT PSDATE No No
ADDRESS1 char(55) No No
ADDRESS2 char(55) No No
ADDRESS3 char(55) No No
ADDRESS4 char(55) No No
NUM1 char(6) No No
NUM2 char(4) No No
CITY char(30) No No
COUNTY char(30) No No
STATE char(6) No No
POSTAL char(12) No No
GEO_CODE char(11) No No
COUNTRY char(3) No No
PHONE char(24) No No
EMAILID char(70) 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
IN_CITY_LIMIT char(1) No No
CR_CARD_RQST_ID char(30) No No
CR_CARD_AUTH_STAT char(1) No No
CR_CARD_AUTH_CD char(10) No No
CR_CARD_A_DTTM char(20) No No
CR_CARD_AUTH_DTTM PSDATETIME No No
CR_CARD_MSG1 char(50) No No
CR_CARD_MSG2 char(50) No No
CR_CARD_MSG3 char(50) 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
VAT_HDR_IND char(1) No No
STATE_VAT_DEFAULT char(6) No No
OPEN_ITEM_KEY char(30) No No
JRNL_LN_REF char(10) No No
ADD_DTTM PSDATETIME No No
LAST_UPDATE_DTTM PSDATETIME No No
Index
Name Type Unique Member
PS_INTFC_BI_HDR PK Yes
PSAINTFC_BI_HDR IE1 No
Member(s) of "PS_INTFC_BI_HDR" Index
INTFC_ID
INTFC_LINE_NUM
TRANS_TYPE_BI
TRANS_TYPE_BI_SEQ
HDR_FIELDS_KEY
HDR_TRANS_TYPE
Member(s) of "PSAINTFC_BI_HDR" Index
TARGET_INVOICE
HDR_FIELDS_KEY

Published December 16, 2006