| Data element |
Definition |
ADJUSTMENT_AMOUNT
Indexed - no
Format - number
May be null? yes |
The amount of the adjustment. |
ADJUSTMENT_COA_ACCOUNT
Indexed - no
Format - char(26)
May be null? yes |
The 26-digit account used in the adjustment transaction. The Adjustment_COA_Account consists of seven segments:
Adjustment_COA_CNAC
Adjustment_COA_Org
Adjustment_COA_BC
Adjustment_COA_Fund
Adjustment_COA_Object
Adjustment_COA_Program
Adjustment_COA_Center_Ref
See also the definitions for Adjustment_COA_CNAC, Adjustment_COA_Org, Adjustment_COA_BC, Adjustment_COA_Fund, Adjustment_COA_Object, Adjustment_COA_Program, and Adjustment_COA_Center_Ref.
|
ADJUSTMENT_COA_BC
Indexed - no
Format - char(1)
May be null? yes |
The budgetary control (BC) code used in the adjustment transaction. |
ADJUSTMENT_COA_CNAC
Indexed - yes
Format - char(3)
May be null? yes |
The 3-character center net asset class (CNAC) code used in the adjustment transaction. |
ADJUSTMENT_COA_CREF
Indexed - yes
Format - char(4)
May be null? yes |
The 4-character Center Reference (CREF) code used in the adjustment transaction. |
ADJUSTMENT_COA_FUND
Indexed - yes
Format - char(6)
May be null? yes |
The 6-character fund number used in the adjustment transaction. |
ADJUSTMENT_COA_OBJECT
Indexed - yes
Format - char(4)
May be null? yes |
The 4-character object code used in the adjustment transaction. |
ADJUSTMENT_COA_ORG
Indexed - yes
Format - char(4)
May be null? yes |
The 4-character organization code used in the adjustment transaction. |
ADJUSTMENT_COA_PROGRAM
Indexed - yes
Format - char(4)
May be null? yes |
The 4-character program code used in the adjustment transaction. |
ADJUSTMENT_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 adjustment transaction. |
ADJUSTMENT_TYPE
Indexed - yes
Format - varchar2(15)
May be null? yes |
Identifies the type of adjustment. |
ASSET_ADJ_PK
Indexed - yes
Format - number
May be null? no |
The unique sequence for the ASSET_ADJUSTMENTS table. |
ASSET_ID
Indexed - yes
Format - number(15)
May be null? no |
The unique system identifier for an asset. |
ASSET_INVOICE_ID
Indexed - no
Format - number(15)
May be null? yes |
The ASSET_INVOICES record associated with the adjustment. |
ASSET_NUMBER
Indexed - yes
Format - varchar2(15)
May be null? no |
The unique identifier for an asset. |
DEBIT_CREDIT_FLAG
Indexed - no
Format - varchar2(2)
May be null? yes |
Indicates if the amount is a debit (DR) or a credit (CR). |
EXTRACT_DATE
Indexed - yes
Format - date
May be null? no |
The date the record was extracted from BEN Assets, the Oracle Fixed Assets system, and loaded into the Data Warehouse. |
JOURNAL_HEADER_ID
Indexed - no
Format - number(15)
May be null? yes |
The header ID of the journal associated with adjustment.
|
JOURNAL_LINE_NUMBER
Indexed - no
Format - number(15)
May be null? yes |
The journal line number associated with the adjustment. |
LAST_UPDATED_BY_USER
Indexed - no
Format - varchar2(100)
May be null? yes |
The BEN Financials login identification (ID) for the person or batch job that last updated the asset record. |
LAST_UPDATE_DATE
Indexed - no
Format - date
May be null? yes |
The date on which the asset was last updated in BEN Assets. |
PERIOD_ADJUSTED
Indexed - yes
Format - varchar2(15)
May be null? yes |
The period to which the adjustment applies. It is the same as Period_Created, unless a reserve adjustment was created, in which case Period_Adjusted is the last period of the fiscal year to which the adjustment applies. |
PERIOD_CREATED
Indexed - yes
Format - varchar2(15)
May be null? yes |
The period the adjustment was entered into Oracle Assets. |
SOURCE_TYPE_CODE
Indexed - yes
Format - varchar2(15)
May be null? yes |
Indicates the source of the adjustment. |
