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 |