ASSET_INVOICES Table - Data Element Index   Tables and Data Elements   Assets Home   Data Warehouse Home

ASSET_INVOICES Table

Explanation
The ASSET_INVOICES table contains select accounts payables data related to assets, such as invoice number, PO number, vendor information, clearing account, and invoice line amount. ASSET_INVOICES is replaced in its entirety during nightly updates.

Common Uses
Displaying invoice and PO information related to an asset.

ASSET_INVOICES_PK

ASSET_ID
ASSET_INVOICES_PK
ASSET_NUMBER
INVOICE_ID
PAYABLES_COA_ACCOUNT
PAYABLES_COA_CNAC
PAYABLES_COA_CREF
PAYABLES_COA_FUND
PAYABLES_COA_OBJECT
PAYABLES_COA_ORG
PAYABLES_COA_PROGRAM
PAYABLES_RESPONSIBLE_ORG
PO_NUMBER
SOURCE_LINE_ID
VENDOR_ID
VENDOR_NAME
VENDOR_NUMBER

ASSETS
CENTER_REF_CODES
CNAC_CODES
FUND_CODES
OBJECT_CODES
ORG_CODES
PROGRAM_CODES

Cautions

• For records created in the legacy Property Managment System, prior to the March 2008 implementation of BEN Assets, Invoice, PO and Payables COA fields may be null.
• The ASSET_INVOICES table is stored in the DWGL schema in the Data Warehouse.

ASSET_INVOICES Table - Data Element Index   Tables and Data Elements   Assets Home   Data Warehouse Home