| Data element |
Definition |
ASSET_ID
Indexed - yes
Format - number(15)
May be null? no |
The unique system identifier for an asset. |
ASSET_INVOICES_PK
Indexed - yes
Format - number
May be null? no |
The unique sequence for the ASSET_INVOICES table. |
ASSET_NUMBER
Indexed - yes
Format - varchar2(15)
May be null? no |
The unique identifier for an asset. |
FEEDER_SYSTEM_NAME
Indexed - no
Format - varchar2(40)
May be null? yes |
The source of the asset invoice record. |
FIXED_ASSET_COST
Indexed - no
Format - number
May be null? yes |
The asset cost, as imported on the source line from Oracle Payables. Note that multiple source lines may comprise the total cost. This column does not include any cost changes made in BEN Assets once the item has been imported from Oracle Payables. |
INVOICE_DATE
Indexed - no
Format - date
May be null? yes |
The date the invoice was created in Oracle Payables.
|
INVOICE_DESCRIPTION
Indexed - no
Format - varchar2(240)
May be null? yes |
The description for the invoice as created in Oracle Payables. |
INVOICE_ID
Indexed - yes
Format - number(15)
May be null? yes |
The unique system identifier for the invoice as established in Oracle Payables. |
INVOICE_NUMBER
Indexed - no
Format - varchar2(100)
May be null? yes |
The supplier's invoice number. This is not a unique identifier, as multiple suppliers may use the same invoice numbers. For a unique identifer of an invoice within BEN Financials, refer to INVOICE_ID. |
PAYABLES_COA_ACCOUNT
Indexed - no
Format - char(26)
May be null? yes |
The 26-digit account used in the accounts payable transaction. The Payables_COA_Account consists of seven segments:
Payables_COA_CNAC
Payables_COA_Org
Payables_COA_BC
Payables_COA_Fund
Payables_COA_Object
Payables_COA_Program
Payables_COA_Center_Ref
See also the definitions for Payables_COA_CNAC, Payables_COA_Org, Payables_COA_BC, Payables_COA_Fund, Payables_COA_Object, Payables_COA_Program, and Payables_COA_Center_Ref.
|
PAYABLES_COA_BC
Indexed - no
Format - char(1)
May be null? yes |
The budgetary control (BC) code used in the accounts payable transaction. |
PAYABLES_COA_CNAC
Indexed - yes
Format - char(3)
May be null? yes |
The 3-character center net asset class (CNAC) code used in the accounts payable transaction. |
PAYABLES_COA_CREF
Indexed - yes
Format - char(4)
May be null? yes |
The 4-character Center Reference (CREF) code used in the accounts payable transaction. |
PAYABLES_COA_FUND
Indexed - yes
Format - char(6)
May be null? yes |
The 6-character fund number used in the accounts payable transaction. |
PAYABLES_COA_OBJECT
Indexed - yes
Format - char(4)
May be null? yes |
The 4-character object code used in the accounts payable transaction. |
PAYABLES_COA_ORG
Indexed - yes
Format - char(4)
May be null? yes |
The 4-character organization code used in the accounts payable transaction. |
PAYABLES_COA_PROGRAM
Indexed - yes
Format - char(4)
May be null? yes |
The 4-character program code used in the accounts payable transaction. |
PAYABLES_RESPONSIBLE_ORG
Indexed - yes
Format - char(4)
May be null? yes |
The 4-character code for the organization responsible for managing the fund used in the accounts payable transaction. |
PAYABLES_UNITS
Indexed - no
Format - number
May be null? yes |
The number of units associated with the payables transaction. |
PO_NUMBER
Indexed - yes
Format - varchar2(20)
May be null? yes |
The purchase order number under which the asset was bought. |
SOURCE_LINE_ID
Indexed - yes
Format - number(15)
May be null? yes |
The unique system identifier for the asset invoice source line. |
VENDOR_ID
Indexed - yes
Format - number(15)
May be null? yes
|
The unique system identifier for the asset supplier, as established in Oracle Purchasing. |
VENDOR_NAME
Indexed - yes
Format - varchar2(240)
May be null? yes |
The name of the asset supplier, as established in Oracle Purchasing. |
VENDOR_NUMBER
Indexed - yes
Format - varchar2(30)
May be null? yes |
The unique identifier for the asset supplier, as established in Oracle Purchasing. |
