PeopleSoft 9
Asset Management

Table Name AMBI_INTFC_BILL

Table Description
AMBI_INTFC_BILL
Columns
Name Datatype Is PK Is FK
BUSINESS_UNIT char(5) Yes Yes
ASSET_ID char(12) Yes Yes
BOOK char(10) Yes Yes
DTTM_STAMP PSDATETIME Yes Yes
INTFC_ID int No No
INTFC_LINE_NUM int No No
INVOICE char(22) No No
LINE_SEQ_NUM int No No
BILL_SOURCE_ID char(10) No No
AM_TRAN_LOAD char(1) No No
ORIGINAL_INVOICE char(22) No No
BUSINESS_UNIT_BI char(5) No No
BUSINESS_UNIT_GL char(5) No No
BUSINESS_UNIT_AM char(5) No No
PROFILE_ID char(10) No No
ASSET_ID_TO char(12) No No
COST_TYPE char(1) No No
AM_BILL_LOAD char(3) No No
TEXT254 char(254) No No
PROCESS_INSTANCE decimal(10) No No
Index
Name Type Unique Member
PS_AMBI_INTFC_BILL PK Yes
Member(s) of "PS_AMBI_INTFC_BILL" Index
BUSINESS_UNIT
ASSET_ID
BOOK
DTTM_STAMP

Published December 16, 2006