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 |