INTFC_ID

Interface ID

Key to this table. An interface ID is typically assigned to a group of transactions with the same load type.

Use a unique, previously unused INTFC_ID for each set of transactions with the same load type.

When using a load type of CN1 and NEXT in the ASSET_ID field, you’ll need to use a unique INTFC_ID for each asset.

For FADs and Conversions, if INTFC_ID is the same for multiple lines for an asset, increment the INTFC_LINE_NUM for each individual line.

Used internally.

Y

INTFC_LINE_NUM

Interface Line Number

Key to this table. Interface Line Number is used as a key for multiple lines for the same Interface ID for transactions with similar keys (for example., multiple acquisition details, such as CAP).

For FADs and Conversions, if INTFC_ID is the same for multiple lines for an asset, increment the INTFC_LINE_NUM for each individual line.

Used Internally.

Y

BUSINESS_UNIT

Business Unit

Identifies the business unit of the financial transaction to be processed. (You should never have more than one business unit per interface ID.)

BOOK, COST, DEPRECIATION, RETIREMENT, OPEN_TRANS

Y

ASSET_ID

Asset Identification

Identifies the asset ID of the financial transaction to be processed. For add interface types (ADD, NAD, FAD, CN1, etc.), if this field contains the value ‘NEXT’ then Transaction Loader will assign the next asset ID for this business unit.

BOOK, COST, DEPRECIATION, RETIREMENT, OPEN_TRANS

Y

BOOK

Asset Book Name

Identifies the asset book to be processed. All financial transactions must be assigned a book if the DEFAULT_PROFILE_SW = ‘N’.

The financial information for an asset (book, cost, depreciation, retirements) addition can be entered by creating transactions manually. This is done by putting one row into the INTFC_FIN table for each book that an asset reports to.

This information can also be defaulted via the profile. If a profile is used then the DEFAULT_PROFILE_SW is set to ‘Y.’ The Transaction Loader will then populate the financial tables for all books specified in the profile from the one row in INTFC_FIN. When the DEFAULT_PROFILE_SW is set to ‘Y’, book can be left blank (“ “). Books will default in from the profile, which is populated in INTFC_PHY_A.

If you’re doing a CN1, set the DEFAULT_PR0FILE_SW to ‘N’.

BOOK, COST, DEPRECIATION, RETIREMENT, OPEN_TRANS

Y when Default Profile Switch = N

DTTM_STAMP

Date/Time Stamp

Used to populate the key field of datetime stamp on many tables. Represents the date/time that this transaction was added to the system. While Date/Time Stamp can be set to any value, we recommend that you set it to the date of the conversion. This ensures that it will be earlier than the date of any further transactions.

It’s used as a key because INTFC_LINE_NUM isn’t always incremented (for example, when creating transactions via Mass Change). Making this a key is a safeguard against getting a duplicate insert.

If you have multiple cost rows for one asset, you may want to increment this field by one second for each subsequent row to prevent duplicate inserts into PS_COST.

COST, DEPRECIATION, RETIREMENT, OPEN_TRANS

Y

OPERATING_UNIT

Operating Unit

A ChartField, which can be customized. See the online ChartField customization topic for further discussion.

COST, DEPRECIATION

DEPTID

Department

A ChartField, which can be customized. See the online ChartField customization topic for further discussion.

COST, DEPRECIATION

PRODUCT

Product

A ChartField, which can be customized. See the online ChartField customization topic for further discussion.

COST, DEPRECIATION

FUND_CODE

Fund Code

A ChartField, which can be customized. See the online ChartField customization topic for further discussion.

COST, DEPRECIATION

CLASS_FLD

Class Field

A ChartField, which can be customized. See the online ChartField customization topic for further discussion.

COST, DEPRECIATION

PROGRAM_CODE

Program Code

A ChartField, which can be customized. See the online ChartField customization topic for further discussion.

COST, DEPRECIATION

BUDGET_REF

Budget Reference

A ChartField, which can be customized. See the online ChartField customization topic for further discussion.

COST, DEPRECIATION

AFFILIATE

Affiliate

A ChartField, which can be customized. See the online ChartField customization topic for further discussion.

COST, DEPRECIATION

AFFILIATE_INTRA1

Fund Affiliate

A ChartField, which can be customized. See the online ChartField customization topic for further discussion.

COST, DEPRECIATION

AFFILIATE_INTRA2

Operating Unit Affiliate

A ChartField, which can be customized. See the online ChartField customization topic for further discussion.

COST, DEPRECIATION

CHARTFIELD1

ChartField 1

A ChartField, which can be customized. See the online ChartField customization topic for further discussion.

COST, DEPRECIATION

CHARTFIELD2

ChartField 2

A ChartField, which can be customized. See the online ChartField customization topic for further discussion.

COST, DEPRECIATION

CHARTFIELD3

ChartField 3

A ChartField, which can be customized. See the online ChartField customization topic for further discussion.

COST, DEPRECIATION

PROJECT_ID

Project

A ChartField, which can be customized. See the online ChartField customization topic for further discussion.

COST, DEPRECIATION

CATEGORY

Asset Category

An asset ChartField that is used to derive the GL accounts for any given financial transaction (used in conjunction with Cost Type, Trans Type, and Trans Code - see the topic on accounting entries).

COST, DEPRECIATION

Y

COST_TYPE

Cost Type

An asset ChartField that is used to derive the GL accounts for any given financial transaction (used in conjunction with Cost Type, Trans Type, and Trans Code - see the topic on accounting entries).

COST, DEPRECIATION

CF_SEQNO

Chartfield Sequence Number

Internal Use. Every combination of Chartfield values at the Asset/Book level has a unique ChartField sequence number (CF_SEQNO) and every ChartField sequence number value at the Asset/Book level represents one combination of ChartField values. The values of this field are not shared among assets. When the cost of the asset is transferred to a new combination of ChartFields, the ChartField sequence number is assigned a new value.

COST, DEPRECIATION

VOUCHER_ID

Voucher ID

Identifies the voucher associated with the financial transaction. This is used in AP integration. This field can be used for PeopleSoft or non-PeopleSoft integration. This field is on this table so that the INTFC_FIN transactions can be easily queried by voucher. This should be populated if the transaction is voucher related.

Used internally.

VOUCHER_LINE_NUM

Voucher Line Number

Identifies the voucher line number associated with the financial transaction. This is used in AP integration. This field can be used for PeopleSoft or non-PeopleSoft integration.

Used internally.

DISTRIB_LINE_NUM

Distribution Line Number

Identifies the voucher line distribution number associated with the financials transaction. This is used in AP integration. This field can be used for PeopleSoft or non-PeopleSoft integration.

Used internally.

INTFC_TYPE

Interface Type, also called Load Type

Identifies the type of transaction this is. Transaction Loader will process this transaction based upon this field. A list of interface types and their usage is included at the end of this table.

Used internally.

Y default CN1 or CN2

SYSTEM_SOURCE

System Source

The source system that created this transaction. Valid values are listed in the translate table. This field is used extensively by AM to drill back to source systems. Feel free to add valid values to the translate table for your external systems (or use EXT). You can run Transaction Loader selectively for specific values of system source.

Used internally.

Y default CNV

APPROVAL_SW

Auto-approval Status

Identifies whether the transaction is approved or not. Transaction Loader will only load approved transactions. Valid values are ‘Y’ for approved and ‘N’ for not approved.

Used internally.

Y

PI_ID

Physical Inventory ID

Used for internal processing. Do not populate. The physical inventory ID that was entered when defining physical inventory is used here.

Used internally.

INTFC_STATUS

Interface Status

Used for internal processing. Default this field to ‘DON’.

Used internally.

Y default DON

LOAD_STATUS

Load Status

Identifies the status of this transaction. Updated by the Transaction Loader. Valid values are ‘NEW’ = not processed; ‘ERR’ = an error exists on this transaction and it will not be processed; ‘DON’ = the transaction has been successfully processed; CON = transaction has been consolidated into a different transaction and it will not be loaded. UNI = transaction has been unitized into a different transaction and it will not be loaded.

Used internally.

Y NEW

ORIG_INTFC_ID

Original Interface ID

Used for internal processing. Do not populate.

Used internally.

ORIG_LINE_NUM

Original Interface Line Number

Used for internal processing. Do not populate.

Used internally.

DEFAULT_PROFILE_SW

Default Books from Profile?

Identifies whether a profile will be used for an asset add or capitalization by the Transaction Loader. When this switch is set to ‘Y’ the BOOK table will have its fields defaulted from the profile tables rather than the loader tables (INTFC_). When this switch is set to ‘Y’, the category and group asset ID on the COST table, group asset ID on the OPEN_TRANS table, a few fields on the ASSET and ASSET_ACQ_DET tables, and the retirement convention on the RETIREMENT table will also be defaulted from the profile tables. The profile_id is identified on the INTFC_PHY_A table.

When performing a CN1, you must set the DEFAULT_PROFILE_SW to ‘N’.

The default value of DEFAULT_PROFILE_SW in INTFC_FIN must match the status of DEFAULT_PROFILE_SW in INTFC_PHY_A.

The section on Setting Up Asset Profiles in the topic entitled Establishing Asset Processing, explains profile processing, including which fields default from a profile. Remember, the values from a profile will always override the values on this table if profile processing has been chosen.

Used internally.

Y

TRANS_CODE

Transaction Code

Used to identify special accounting treatment for the transaction. The category, cost type, transaction type, and transaction code together identify the accounting entry template that will be used for a given transaction. The transaction code allows you to specify an alternative template to be used for a transaction.

If you add or modify a TRANS_CODE, you must set up an Accounting Entry Template for each additional Category/Cost Type/Trans Code/Trans Type combination it generates. For more information on Transaction Codes and Accounting Entry Templates, refer to Establishing Asset Processing.

COST, DEPRECIATION

TRANS_IN_OUT

Transaction In/Out

Used to identify which side of a transfer or recategorization this transaction represents. Every such transaction contains two transactions. The outside of the transaction adjusts the asset being transferred/recategorized from. The inside of the transaction adjusts the asset being transferred/recategorized to. Valid values are ‘O’ and ‘I’.

COST, DEPRECIATION

TRANS_DT

Transaction Date

Denotes the date this transaction occurred. Example: An asset was purchased and placed into service on 15 April, 1997, but was added to the system on 5 June, 1997. The company wanted the add to hit the general ledger for period 5 (May). In this example the transaction date would be 15 April, 1997. The accounting date most likely would be 31 May, 1997.

During conversion it is important that this field represent the last period for which depreciation has been calculated.

For CN1 load types, the system increments the TRANS_DT and ACCOUNTING_DT you enter into INTFC_FIN by one day. So if you enter 05/31/95 as your transaction and accounting dates, the system will use 06/01/95.

COST, DEPRECIATION, OPEN_TRANS

Y

ACCOUNTING_DT

Accounting Date

Denotes the date this transaction was accounted for. This is the date that will be passed to the general ledger. It is the difference between the transaction date and the accounting date that identifies a retroactive transaction. Remember, the accounting date must always be greater than or equal to the transaction date.

See the example of transaction date for an illustration.

For CN1 load types, the system increments the TRANS_DT and ACCOUNTING_DT you enter into INTFC_FIN by one day. So if you enter 05/31/95 as your transaction and accounting dates, the system will use 06/01/95.

COST, OPEN_TRANS

Y

IN_SERVICE_DT

In Service Date

The date the asset was placed in service. This field is used in conjunction with the convention to determine the begin depreciation date. This field only relates to depreciable assets.

BOOK

Y

IN_SERVICE_PD

In Service Period

The calendar period in which the in service date falls. If this field is not populated, the depreciation calculation program will calculate it.

BOOK

IN_SERVICE_FY

In Service Fiscal Year

The calendar fiscal year in which the in service date falls. If this field is not populated, the depreciation calculation program will calculate it.

BOOK

DEPR_IN_SERVICE_SW

Depreciate When in Service?

This field marks whether the yearly depreciation in the year of acquisition should be spread from the in service date through the end of the year or from the begin depreciation date as calculated using the convention and the in service date. Example: In service date = 1 April 1997, convention = half year, begin depreciation date = 1 July, 1997, 1997 Depreciation = $1,000. If this field = ‘Y’ then the $1,000 will be spread from 1 April to 31 December. If this field = ‘N’ then the $1,000 will be spread from 1 July to 31 December.

BOOK

Y default N

BEGIN_DEPR_DT

Begin Depreciation Date

The date the asset begins depreciating. This field is typically calculated by the depreciation calculation program (AM_DEPR_CALC) using the in service date and the convention, so you should leave this field blank.

BOOK

BEGIN_DEPR_PD

Begin Depreciation Period

Used for internal processing. Do not populate.

BOOK

BEGIN_DEPR_FY

Begin Depreciation Fiscal Year

Used for internal processing. Do not populate.

BOOK

BEGIN_FRACTION

Begin Depreciation Period Fraction

Used for internal processing. Do not populate.

BOOK

DEPR_CALC_SW

Depreciation Calculation Switch

Used for internal processing. Do not populate.

BOOK

BEGIN_CALC_DT

Begin Depreciation Calculation Date

Used for internal processing. Do not populate.

BOOK

BEGIN_CALC_PD

Begin Calculation Period

Used for internal processing. Do not populate.

BOOK

BEGIN_CALC_FY

Begin Calculation Fiscal Year

Used for internal processing. Do not populate.

BOOK

CALCULATION_TYPE

Calculation Type

The type of depreciation calculation that will be performed by the depreciation calculation program (AM_DEPR_CALC). The valid values are ‘R’ for remaining value and ‘L’ for Life-to-Date. Most conversions will use a remaining value type. For a more detailed discussion of these calculation types, please refer to Appendix C: Understanding Depreciation Calculations.

In general, if the Remaining Value option is selected, depreciation will be calculated from the Transaction Date. If the Life-to-Date option is selected, depreciation will be calculated from the Begin Depreciation Date.

BOOK

Y

LAST_CALC_TYPE

Last Calculation Type

Used for internal processing. Do not populate.

BOOK

RSV_FRACTION

Reserve Fraction (RSV/Cost)

Used for internal processing. Do not populate.

BOOK

RECALC_RSV_SW

Recalculate RSV Fraction (RSV/Cost)

Used for internal processing. Do not populate.

BOOK

SCHED_FRACTION

Fraction of Schedule Elapsed

Used for internal processing. Do not populate.

BOOK

YEAR_REM_FRACTION

Year Remaining Fraction

Used for internal processing. Do not populate.

BOOK

DEPR_STATUS

Depreciation Status

Marks the asset book as depreciable or non-depreciable. The valid values are ‘D’ for depreciable and ‘N’ for non-depreciable. If an asset is marked non-depreciable, then the depreciation calculation program (AM_DEPR_CALC) will not process it and no depreciation will be posted. It can still be capitalized, however, and Cost and Book record rows will be tracked.

If you mark an asset book as non-depreciable, you must still enter a life and convention for it.

BOOK

Y

REGULATION

Depreciation Regulation

Identifies the U.S. tax regulation that covers this asset book. Valid values are in the translate table.

BOOK

RECOVERY_LIFE

Recovery Life

Identifies the U.S. tax recovery life for this asset book.

BOOK

RECOVERY_SUBTYPE

Recovery Sub-type

Identifies the U.S. tax recovery sub-type for this asset book.

BOOK

CONVENTION

Prorate Convention

Identifies the depreciation prorate convention to be used with this asset book. The convention is applied to the in service date to calculate the begin depreciation date for the asset book. The valid values must be set up on the convention table prior to implementation. PeopleSoft ships a ‘MODEL’ set of conventions with the system that can be shared by your business units.

Note. If you are using a calendar other than a standard, 12 period calendar, it may be necessary to modify the ‘MODEL’ set of conventions or create new convention definitions to match the calendar(s) you’re using.

BOOK

Y

LIFE

Life

Identifies the depreciable life of this asset book. If the asset is using a depreciation method that uses life (such as straightline, schedule, declining balance switching to straightline, etc.) then life is a required field. Life is measured in periods. If you are using a calendar that is 12 periods, and the life of the asset is 5 years, then the life field would contain 60.

BOOK

Y for most methods

LIFE_REMAINING

Remaining Life

Used for internal processing. Do not populate.

BOOK

TAX_CLASS_AM

Guideline Tax Class

Identifies the U.S. tax class associated with this asset book.

BOOK

DEPR_PERCENT

Percent

Identifies the percent to be used. This field is only used when the depreciation method is flat rate or declining balance.

BOOK

Y for flat rate declining balance depreciation

DB_PERCENT

Declining Balance Percent

Identifies the declining balance percent. This field is only used when the depreciation method is declining balance with switch to straight line.

BOOK

Y for declining balance w/ a straight line switch depreciation

METHOD

Depreciation Method

Identifies the depreciation method to be used. Valid values are in the translate table.

BOOK

Y

DEPR_SCHED_CD

Depreciation Schedule Code

Identifies the depreciation schedule to be used. This field is only used if the depreciation method is schedule. This field must reference a valid depreciation schedule. The schedules are defined by the user in the Establish Asset Processing window. PeopleSoft ships a number of sample schedules in the ‘MODEL’ TableSet.

Note. Life is a key field on the Depreciation Schedule Code table. Verify that the Depreciation Schedule Code selected is valid and life corresponds to the value entered in the life field.

BOOK

Y for depreciation method Schedule

DEPR_LIMIT_CD

Depreciation Limit Code

Identifies the depreciation limits to be used. Depreciation limits are used to limit the amount of depreciation expense that can be taken in a given fiscal year. This field must reference a valid depreciation limit. The limits are defined by the user in the Establish Asset Processing window. PeopleSoft ships a number of sample limits in the ‘MODEL’ TableSet.

BOOK

PROPERTY_CD

Property Code

Identifies what code of property the asset book falls into for U.S. tax processing purposes. Valid values are ‘1’ for section 1245 property and ‘2’ for section 1250 property.

BOOK

PROPERTY_TYPE

Property Type

Identifies the type of property the asset book represents. Valid values are ‘R’ for real property and ‘P’ for personal property.

BOOK

SALVAGE_VALUE

Salvage Value

The salvage or residual value that is to be used in the depreciation calculation for this asset book. It is subtracted from the cost to determine the depreciable basis in depreciation calculations.

COST

TAX_CREDIT_SW

Tax Credit Switch

Used for internal processing. Do not populate.

BOOK

BASIS_RED_TOTAL

Basis Reduction Total

The total amount of the reduction in the cost basis for this asset book.

BOOK

BASIS_RED_RECAP

Basis Reduction Recapture

The total amount of the recapture of the basis reduction for this asset book.

BOOK

SEC179_TAKEN_SW

Section 179 Taken Switch

Identifies whether the asset book has qualified under the U.S. Tax regulation section 179. Valid values are ‘Y’ for yes and ‘N’ for no.

BOOK

SEC179_AMT

Section 179 Taken Amount

If the asset book qualified for section 179 expense, how much was taken?

BOOK

ACTIVITY_SW

Activity Switch

Identifies whether this transaction reflects an active ChartField combination for an asset. This is a numeric field. When the sum of the activity switch for a ChartField combination for an asset = 0 then this ChartField combination is active.

For asset adds, this field will always be 0.

COST, DEPRECIATION

RETIRE_SW

Retirement Switch

Identifies whether this ChartField combination for the asset book has been retired (fully) or not. This is a numeric field and works the same as the activity switch.

COST

LISTED_PROP

Listed Property?

Identifies whether the asset is listed property or not. Only used for tax books.

BOOK

LISTED_PROP_TYPE

Listed Property Type

Identifies the type of listed property the asset is.

BOOK

BUS_USE_PERCENT

Business Use Percent

Percentage that asset is used for business purposes.

BOOK

QUANTITY

Asset Quantity

Represents the quantity of this transaction. Remember, each transaction’s quantity is summed to provide a balance at a given point in time.

COST

COST

Cost

Represents the cost of this transaction. Remember, each transaction’s cost for an asset book is summed to provide a balance at a given point in time.

COST

Y

CURRENCY_CD

Currency Code

This field represents the transaction currency. This field is used to determine the currency conversion that will occur when populating each asset book, which may be in a different currency.

COST, RETIREMENT

Y

TRANSFER_BU

Transfer Business Unit

For an interunit asset transfer to transaction (transaction type=‘TRF’ and Transaction in/out switch=‘I’) this represents the business unit the asset was transferred from. For an interunit asset transfer from transaction (transaction type=‘TRF’ and Transaction in/out switch=‘O’) this represents the business unit the asset was transferred to.

COST

TRANSFER_ASSET_ID

Transfer Asset ID

This field works just like the Transfer Business Unit, only it represents the asset ID used in the transfer transaction.

COST

TRANSFER_BOOK

Transfer From Book

This field works just like the Transfer Business Unit, only it represents the book used in the transfer transaction.

COST

OPRID

Operator ID

The operator ID that initiated this transaction.

COST, OPEN_TRANS

FISCAL_YEAR

Fiscal Year

Represents the fiscal year in which the depreciation was taken.

When converting depreciation you must identify the time period the depreciation covers. If converting an asset for which depreciation has been calculated through June 1997, then the fiscal year would be 1997, the start period would be 6 and the end period would be 6.

DEPRECIATION

Y if the asset has accumulated depreciation

START_PD

Start Period

Represents the start period for which the depreciation was taken. See the example above.

DEPRECIATION

Y if the asset has accumulated depreciation

END_PD

End Period

Represents the end period for which the depreciation was taken. See the example above.

DEPRECIATION

Y if the asset has accumulated depreciation

YTD_FLAG

Original Reserve

Set value to ‘N’ for Depreciation Amount that represents accumulated depreciation as of the conversion date. Default to ‘Y’ for other depreciation transactions.

DEPRECIATION

Y if the asset has accumulated depreciation

DEPR

Depreciation Amount

The depreciation amount of this transaction.

DEPRECIATION

Y if the asset has accumulated depreciation

DEPR_YTD

Year-to-Date Depreciation

Populate with Year To Date Depreciation

DEPRECIATION

Y if Method is Sum of Years, Declining Balance, Declining Balance with Switch to Straight line and you are doing a mid-year conversion.

RETIREMENT_DT

Retirement Date

The retirement date of the transaction. This field is used for retirement transactions only.

RETIREMENT

RETIRE_CONVENTION

Retirement Convention

Represents the convention used for the retirement transaction. The convention is used to determine the end depreciation date for this asset book. This field is used for retirement transactions only.

RETIREMENT

END_DEPR_DT

End Depreciation Date

The end depreciation date for this retirement transaction. This represents the date that depreciation will stop for this asset. The depreciation for that period is then prorated to determine the amount of accumulated depreciation being retired. This field is used for retirement transactions only.

RETIREMENT

DISPOSAL_CODE

Disposal Code

Represents a memo field detailing the method that was used to dispose of this asset. The valid values for this field are in the translate table. This field is used for retirement transactions only.

RETIREMENT

RETIREMENT_TYPE

Retirement Type

Represents whether this retirement transaction was ordinary or extraordinary according to U.S. Tax code. This field is used for retirement transactions only.

RETIREMENT

RETIREMENT_STATUS

Retirement Status

Represents the status of the retirement transaction. The valid values are in the translate table. The initial value should be ‘N’ for a new retirement. This field is used for retirement transactions only.

RETIREMENT

VOLUNTARY

Voluntary Conversion

Represents whether the retirement was voluntary or involuntary. This is required by U.S. tax code. The valid values are in the translate table. This field is used for retirement transactions only.

RETIREMENT

TRADE_IN_ASSET_ID

Asset ID Bought with Trade In

Represents the asset ID that was bought using this asset as a trade-in. This field is only used for retirement transactions.

RETIREMENT

TRADE_IN_DTTM_STMP

Trade In Date/Time Stamp

Represents the date/time stamp of the asset add transaction for the asset that was bought This field is only used for retirement transactions.

RETIREMENT

TRADE_IN_AMT

Trade In Amount

The amount received for the trade-in of an asset. This field is only used for retirement transactions.

RETIREMENT

TRADE_IN_VALUE

Trade In value

To retire an asset by trading it for another asset.

RETIREMENT

Y

CASH

Cash Received/Paid

"Cash received in a like-kind exchange is taxable and is often referred to as “boot”. "

RETIREMENT

Y

REFERENCE

Reference Code

A memo field that can be used to tie this retirement transaction to a reference document. This field is only used for retirement transactions.

RETIREMENT

LIABILITY_ASSUMED

Liabilities Assumed

"If you are surrendering a building with a mortgage of USD 70,000 and acquiring a building with a mortgage of USD 30,000, you would enter 40,000 as the net liability. "

RETIREMENT

Y

NON_LIKE_KIND

FMV Non Like Kind Property

Fair Market Value for Non Like Kind Property.

RETIREMENT

Y

RETIRE_QUANTITY

Retirement Quantity

The quantify of the asset book being retired by this transaction. This field is only used for retirement transactions.

RETIREMENT

RETIREMENT_AMT

Retirement Amount

The amount of cost for the asset book being retired by this transaction. This field is only used for retirement transactions.

RETIREMENT

PROCEEDS

Retirement Proceeds

The proceeds received for this asset. This is used in the depreciation calculation program to derive the gain/loss amount. This field is only used for retirement transactions.

RETIREMENT

REMOVAL_COST

Removal Cost

The cost of removal for this asset. This is used in the depreciation calculation program to derive the gain/loss amount. This field is only used for retirement transactions.

RETIREMENT

RETIREMENT_RSV

Reserve Retired

The accumulated depreciation being retired by this transaction. This is calculated by the depreciation calculation program. This field is only used for retirement transactions.

RETIREMENT

GAIN_LOSS

Retirement Gain/Loss

The gain/loss amount for this retirement transaction. This is calculated by the depreciation calculation program. This field is only used for retirement transactions.

RETIREMENT

LEASE_REM_PAYMNTS

Lease Remaining Payments

The number of payments remaining at the time of the retirement. This field is calculated by the program AM_DEPR_CALC and does not have to be populated. This field is only used for retirement transactions.

RETIREMENT

OPEN_TRANS_ID

Open Transaction ID

The ID (key) for the OPEN_TRANS table. The OPEN_TRANS table is a “to do” list for several programs, such as AM_DEPR_CALC and AM_AMAEDIST. If this transaction requires processing by these programs, an entry is made to the OPEN_TRANS table.

For performance reasons, this field should be populated for conversions. A single unique OPEN_TRANS_ID can be used for a group of the same transaction types, for example, CN1s.

OPEN_TRANS

Y

CALC_DEPR_STATUS

Depreciation

This field is used to determine whether depreciation needs to be calculated on this transaction. Only financial transactions need depreciation calculated. An open transaction (OPEN_TRANS) is created for those transactions that will have depreciation calculated. The OPEN_TRANS entry is then used by AM_DEPR_CALC as a “to do” list of transactions to process.

Transaction Loader will populate this field. It can be left blank.

Note. Open Transactions are still generated for non-depreciable assets.

OPEN_TRANS

CALC_DIST_STATUS

Distribution

This field is used to determine whether accounting entries need to be created for this transaction. Only financial transactions on a book marked for accounting entry creation need to have accounting entries created. An open transaction (OPEN_TRANS) is created for those transactions that will have accounting entries created. The OPEN_TRANS table entry is then used by AM_AMAEDIST as a “to do” list of transactions to process. Transaction Loader will populate this field. It can be left blank.

OPEN_TRANS

MESSAGE_SET_NBR

Message Set Number

Used for internal processing. Do not populate.

Used internally

MESSAGE_NBR

Message Number

Used for internal processing. Do not populate.

Used internally

BUSINESS_UNIT_JV

Joint Venture Business Unit

The “parent” JV business unit, if the asset is part of a joint venture.

Used internally

LIFE_END_DT

Useful Life End Date

This field represents the end date of the useful life on the asset book. This field can be used as an alternate to the life field. Life and life end date are mutually exclusive. When you specify the life end date, the depreciation calculation program will calculate the life field and store it on the BOOK table.

BOOK

DEPR_LOW_LIMIT

Depreciation Low Limit Amount

This field represents the low amount that net book value must reach before an asset stops depreciating. This field is only used by the declining balance depreciation method. Since the declining balance method does not use a life, the low limit is the way to specify when an asset should become fully reserved.

BOOK

SUSPEND_STATUS

Suspend Status

Indicates whether the book is currently “mothballed”. Default value for this field is blank. If the book is “mothballed”, enter a value of ‘Y’ in this field.

BOOK

SUSPEND_DT

Suspend Date

The date that depreciation was suspended.

BOOK

RESUME_DT

Resume Date

The date that depreciation was resumed after a suspension.

BOOK

SUSPENDED_PERIODS

Number of Suspended Periods

The number of periods that depreciation was suspended for.

BOOK

COST_BASIS_LIMIT

Cost Basis Limit

The maximum amount that can be capitalized for this asset book.

BOOK

DEPR_AVG_OPTION

Averaging Option

A special option that applies only to the flat rate depreciation method. Valid values are ‘M’ (Monthly), ‘Y’ (Yearly), or ‘N’ (None).

If you’re doing a conversion (CN1), you must set this field to a value, no matter what depreciation method you’re using.

BOOK

Y default N

UOP_ID

Units of Production ID

Represents the ID of the Units of Production control table that specifies the units of production for this asset book.

BOOK

IU_MAP_KEY

InterUnit Map Key

Used for InterUnit transfers.

Appears on COST.

MC_DEFN_ID

Mass Change ID

Used for internal processing. Do not populate.

Used internally.

GROUP_ASSET_ID

Group Asset ID

Used to identify which group asset group members report to.

BOOK, COST, DEPRECIATION, OPEN_TRANS

UD_METHOD_ID

Method ID

Identities the user-defined depreciation method to be used. This field must reference a valid user-defined depreciation method. The user defined methods are specified in the Establish Asset Processing window.

BOOK

Y for depreciation method user-defined

INCLUDE_CAP_GAINS

CGT Applicable

A flag which determines whether or not capital gains tax should be included in the gain/loss of a book. The INCLUDE_CAP_GAINS is for Australian customers.

BOOK

REDUCED_COST

Reduced Cost Basis

Amount used in calculating gain/loss for Australian Customers.

RETIREMENT

CAPITAL_G_L

Capital Gains and Loss

Amount used in calculating gain/loss for Australian Customers.

RETIREMENT

RET_NON_CAP_AM2

Non-Capitalized CGT amount.

Amount used in calculating gain/loss for Australian Customers.

RETIREMENT

AM_BK_UD_CHAR1

User-Defined character field

BOOK

AM_BK_UD_CHAR2

User-Defined character field

BOOK

AM_BK_UD_DATE1

User-Defined date field

BOOK

AM_BK_UD_NUM1

User-Defined numeric field

BOOK

AM_BK_UD_NUM2

User-Defined numeric field

BOOK

INCREASE_RATE

Increased Rate

Used to calculate special depreciation amount. You can enter a rate and the standard depreciation will be modified by this percentage along all the life of the asset. This is a Japanese Requirement but can be used for any country.

BOOK

FULLY_DEPR_SW

Retire as Fully Depreciated

Used to retire assets as fully depreciated. 

RETIREMENT

ACCOUNTING_MTHD

Accounting Method

Supports 3 different accounting methods in Japan. In Expense method, the standard depreciation is modified with the special depreciation. The accounting entries in this method have standard + special depreciation in the same accounts. In Allowance and Reserve Method, the information must be in separate accounts.

BOOK

FUTURE_DEPR_YEARS

Number of Future Depreciation Years

Number of future years of depreciation to create when AM_DEPR_CALC runs. For example: if value was 3 and accounting fiscal year is 2000, AM_DEPR_CALC will create years: 2000, 2001 and 2002. If left zero, AM_DEPR_CALC will create all years of the life of the asset.

BOOK

SALVAGE_VAL

Salvage Value

Used to populate an absolute amount in COST.SALVAGE_VALUE by Book on future transactions − used only when default profile switch = No

BOOK

SALVAGE_PCT

Salvage Percent

Used to calculate COST.SALVAGE_VALUE as a percentage of the cost by asset book on future transactions - used only when default profile switch = No

BOOK

AUTO_RETIRED_SW

Auto-Retired Fully Depreciated

Internal

RETIREMENT

RATE_DIV

Rate Divisor

Currency Conversion

RETIREMENT, COST, DEPRECIATION

Y

RATE_DIV_2

Rate Divisor

Currency Conversion

RETIREMENT, COST, DEPRECIATION

Y

RATE_MULT

Rate Multiplier

Currency Conversion

RETIREMENT, COST, DEPRECIATION

Y

RATE_MULT_2

Rate Multiplier

Currency Conversion

RETIREMENT, COST, DEPRECIATION

Y

RT_EFFDT

Rate Effective Date

Currency Conversion

RETIREMENT, COST, DEPRECIATION

Y

RT_TYPE

Rate Type

Currency Conversion

RETIREMENT, COST, DEPRECIATION

Y

BILL_TO_CUST_ID

Customer

Bill to Information.

RETIREMENT

Y

ADDRESS_SEQ_NUM

Address Sequence Number

Bill to Information.

RETIREMENT

Y

SHIP_TO_CUST_ID

Ship To Customer

Ship to Information.

RETIREMENT

Y

SHIP_TO_ADDR_NUM

Ship To Address Sequence Num

Ship to Information.

RETIREMENT

Y

SHIP_FROM_LOC

Ship From Location

Ship to Information.

RETIREMENT

Y

SOLD_TO_CUST_ID

Sold To Customer

Sold to Information.

RETIREMENT

Y

SOLD_TO_ADDR_NUM

Sold To Address Sequence Num

Sold to Information.

RETIREMENT

Y

BILL_SOURCE_ID

Bill Source

Billing Source.

AMBI_INTFC_BILL

Y

TOT_OBLIGATION

Lease Total Obligation

Leasing Obligation.

BOOK

Y

TXN_CASH

Transaction Cash

Cash in transaction currency.

COST

Y

TXN_COST

Transaction Cost

Cost in transaction currency.

COST

Y

TXN_CURRENCY_CD

Transaction Currency

Transaction Currency.

COST

Y

TXN_CURRENCY_CD2

Transaction Currency Display

Transaction Currency.

COST

Y

TXN_LIAB_ASSUMED

Transaction Liability Assumed

Liab Assumed in transaction currency.

RETIREMENT

Y

TXN_NON_LIKE_KIND

FMV Non Like-Kind

Non Like Kind in transaction currency.

RETIREMENT

Y

TXN_PROCEEDS

Transaction Proceeds

Used to populate an amount for Billing – Asset Management transactions.

TXN_REMOVAL_COST

Transaction Removal Cost

Removal Cost in transaction currency.

RETIREMENT

Y

TXN_TRADE_IN_VALUE

Transaction Trade-In Value

Trade in value in transaction currency.

RETIREMENT

Y

DEPR_BONUS_SW

Depreciation Bonus

Depreciation Bonus Switch for Derpeciation Calculation.

BOOK

Y

DEPR_BONUS_PCT

Depreciation Bonus Percent

Depreciation Bonus Percentage for Depreciation Calculation.

BOOK

Y

PROCESS_INSTANCE

Process Instance

Internal field / Informational.

SPECIAL_DEPR_SW

Special Depreciation

Depreciation Calculation.

BOOK

Y

ACCELERATED_TERMS

Accelerated Terms

Depreciation Calculation.

BOOK

Y

INITIAL_TERMS

Initial Terms

Depreciation Calculation.

BOOK

Y

SPECIAL_TERMS

Special Terms

Depreciation Calculation.

BOOK

Y

YEAR_CHANGE

Year of Change

Depreciation Calculation.

BOOK

Y

LIFE_IN_YRS

Life in Years

Depreciation Calculation.

BOOK

Y

MULTI_SHIFT_CODE

Multi-Shift Code

Depreciation Calculation.

BOOK

Y

MULTI_SHIFT_NBR

Shift Factor Number

Depreciation Calculation.

BOOK

Y

DEPR_LIMIT_PCT

Depreciation Limit Percent

Depreciation Calculation.

BOOK

Y

DEPR_PASS_LIFE_SW

Depreciate Pass Life SW

Depreciation Calculation.

BOOK

Y

DEROGATORY_SW

Derogatory Depreciation

Depreciation Calculation.

BOOK

Y

ACCEL_DEPR

Accelerated Depreciation

Depreciation Calculation.

BOOK

Y

INCREASE_DEPR

Increased Depreciation

Depreciation Calculation.

BOOK

Y

INITIAL_DEPR

Initial Depreciation

Depreciation Calculation.

BOOK

Y

SPEC_DEPR

Special Depreciation

Depreciation Calculation.

BOOK

Y

STANDARD_DEPR

Standard Depreciation

Depreciation Calculation.

BOOK

Y

IMPAIR_FLG

Impairment Process

Impairment Processing Switch.

BOOK

Y

CC_FLAG

Component Changeout Old/New

Internal Use

INTFC_ID

Interface ID

Key to this table. An interface ID is typically assigned to a group of transactions with the same load type.

Use a unique, previously unused INTFC_ID for each set of transactions with the same load type.

When using a load type of CN1 and NEXT in the ASSET_ID field, you’ll need to use a unique INTFC_ID for each asset.

For FADs and Conversions, if INTFC_ID is the same for multiple lines for an asset, increment the INTFC_LINE_NUM for each individual line.

Used internally.

Y

INTFC_LINE_NUM

Interface Line Number

Key to this table. Interface Line Number is used as a key for multiple lines for the same Interface ID for transactions with similar keys (ex., multiple acquisition details, such as CAP).

For FADs and Conversions, if INTFC_ID is the same for multiple lines for an asset, increment the INTFC_LINE_NUM for each individual line.

Used internally.

Y

BUSINESS_UNIT

Business Unit

The business unit that identifies the asset to be processed. This field is required

ASSET, ASSET_ACQ_DET, ASSET_CUSTODIAN, ASSET_LOCATION, PARENT_ASSET

Y

ASSET_ID

Asset Identification

The asset ID that identifies the asset to be processed. This field is required. If this field contains the value ‘NEXT’ and the interface type is FAD or CN1 then Transaction Loader will assign the next asset ID for this business unit.

ASSET, ASSET_ACQ_DET, ASSET_CUSTODIAN, ASSET_LOCATION, and many others

Y

ASSET_TYPE

Asset Type

Asset Classification.

ASSET

Y

ASSET_SUBTYPE

Asset Subtype

Asset Classification.

ASSET

Y

DTTM_STAMP

Date/Time Stamp

Used to populate the key field of datetime stamp on many tables. Represents the date/time that this transaction was added to the system. During conversion it is important that this field represent the period through which depreciation has been calculated

Y

VOUCHER_ID

Voucher ID

Identifies the voucher associated with the financial transaction. This is used in AP integration. This field can be used for PeopleSoft or non-PeopleSoft integration. This field is on this table so that the INTFC_FIN transactions can be easily queried by voucher. This should be formatted if the transaction is voucher related.

Used internally. ASSET_ACQ_DET

VOUCHER_LINE_NUM

Voucher Line Number

Identifies the voucher line number associated with the financial transaction. This is used in AP integration. This field can be used for PeopleSoft or non-PeopleSoft integration.

Used internally. ASSET_ACQ_DET

DISTRIB_LINE_NUM

Distribution Line Number

Identifies the voucher line distribution number associated with the financials transaction. This is used in AP integration. This field can be used for PeopleSoft or non-PeopleSoft integration.

Used internally. ASSET_ACQ_DET

INTFC_TYPE

Interface Type, also called Load Type

Identifies the type of transaction this is. Transaction loader will process this transaction based upon this field. Valid values are listed in the translate table.

Used internally.

Y

MC_DEFN_ID

Mass Change ID

Used for internal processing. Do not populate.

Used internally.

SYSTEM_SOURCE

System Source

The source system that created this transaction. Valid values are listed in the translate table. This field is used extensively by AM to drill back to source system. Feel free to add valid values to the translate table for your external systems. You can run Transaction Loader selectively for specific values of system source.

ASSET_ACQ_DET

Y default CNV

APPROVAL_SW

Auto Approval Status

Identifies whether the transaction is approved or not. Transaction Loader will only load approved transactions. Valid values are ‘Y’ for approved and ‘N’ for not approved.

Used internally.

y

INTFC_STATUS

Interface Status

Used for internal processing. Default this field to ‘DON’.

Used internally.

Y default DON

LOAD_STATUS

Load Status

Identifies the status of this transaction. Valid values are ‘NEW’ = not processed; ‘ERR’ = an error exists on this transaction and it will not be processed; ‘DON’ = the transaction has been successfully processed. CON = transaction has been consolidated into a different transaction and it will not be loaded. UNI = transaction has been unitized into a different transaction and it will not be loaded.

Used internally.

Y default NEW

ORIG_INTFC_ID

Original Interface ID

Used for internal processing. Do not populate.

Used internally.

ORIG_LINE_NUM

Original Interface Line Number

Used for internal processing. Do not populate.

Used internally.

DEFAULT_PROFILE_SW

Default Books from Profile

Identifies whether a profile will be used for an asset add by the Transaction Loader. When this switch is set to ‘Y’ the BOOK table will have its fields defaulted from the profile tables rather than the load tables (INTFC...). The category on the cost table will also be defaulted from the profile tables. The profile_ID is identified on the INTFC_PHY_A table.

When performing a CN1, you must set the DEFAULT_PROFILE_SW to ‘N’.

The value of DEFAULT_PROFILE_SW in INTFC_FIN must match the value of DEFAULT_PROFILE_SW in INTFC_PHY_A.

Used internally.

Y (Set = N for CN1)

TRANS_IN_OUT

Transaction In/Out

Used to identify which side of a transfer or recategorization this transaction represents. Every such transaction contains two transactions. The outside of the transaction adjusts the asset being transferred/recategorized from. The inside of the transaction adjusts the asset being transferred/recategorized to.

Used internally.

PARENT_ID

Parent Asset ID

Used to identify the parent of this asset. Parent/Child relationships can be built using the Parent ID. A parent can be an existing asset (the parent ID is the asset ID of another asset) or a “virtual” asset (the parent ID is not an actual asset ID). In any case the parent ID should be a valid entry on the record Parent_Asset. If an entry does not exist on Parent_Asset for the parent ID, then Transaction Loader will create one.

ASSET, PARENT_ASSET

PARENT_DESCR

Parent Asset Description

The description of the parent asset that will be entered on the table parent_asset if an entry does not exist.

PARENT_ASSET

PARENT_DESCRLONG50

Parent Asset Long Description

The long description of the parent asset that will be entered on the table parent_asset if an entry does not exist.

PARENT_ASSET

COMPONENT_OF_ID

Component of Asset

Used to establish Asset Components Structure.

ASSET

Y

ASSET_ASSIGNED_TO

Asset Assigned To

"Was to be used by REM. Lease Administration wanted to assign Chairs and other assets to the offices/asset. However, I believe that they agreed to not do that afterall "

ASSET

Y

TAGGABLE_SW

Taggable Asset Switch

Indicates whether the asset is taggable or not. Valid values are ‘Y’ or ‘N’. A tag is the physical tag that is affixed to an asset.

ASSET

TAG_NUMBER

Tag Number

The tag number that is assigned to this asset.

ASSET

DESCR

Description

A description of the asset. 30 characters.

ASSET

DESCRSHORT

Short Description

A short description of the asset. 10 characters.

ASSET

ASSET_STATUS

Asset Status

The status of the asset. The valid values are in the translate table. This field is generally for information purposes only. No accounting events are tied to this status.

ASSET

Y default to I (in service)

FINANCIAL_ASSET_SW

Capitalized Asset?

Identifies whether this asset has been capitalized. Valid values are ‘Y’ for yes and ‘N’ for no. If an asset has not been capitalized, there can be no financial information or transactions for the asset (BOOK, COST, DEPRECIATION, RETIREMENT, OPEN_TRANS, etc.). However, there can be acquisition detail information (ASSET_ACQ_DET). Since acquisition detail is not tied to accounting events - it is an audit trail, you can store as much expense information as you would like.

ASSET

Y

REPLACE_SW

Replacement Asset?

Identifies whether this is a replacement asset.

ASSET

REPLACE_ASSET_ID

Replaced Asset ID

If this is a replacement asset, what is the Asset ID of the asset that was replaced.

ASSET

CONVERSION_ID

Old Asset ID

Identifies the ID in an old system for this asset. We recommend that you do not try to convert your Asset IDs from your old system to AM. Since Asset ID is only an internal key to our system, it is better to let AM assign Asset IDs to your assets. You can then store the ID from the old system in this field.

ASSET

NEW_ASSET_SW

New Asset?

Was this asset acquired new? Valid values are ‘Y’ or ‘N’.

ASSET

Y

AVAIL_SW

Resale?

Is this asset available for resale? Valid values are ‘Y’ or ‘N’. When marked ‘Y’ this field can be queried to identify assets that are not being used by their custodians and are available for resale or internal transfer. A PS/Query is shipped with Asset Management as an example.

ASSET

Y

AVAIL_CONTACT

Availability Contact

If the asset is available, who should be contacted if someone is interested in the asset.

ASSET

AVAIL_PHONE

Availability Phone

Phone number of the contact above.

ASSET

ACQUISITION_CD

Acquisition Code

Identifies how this asset was acquired. The valid values are in the translate table.

ASSET

ACQUISITION_DT

Acquisition Date

Identifies the acquisition date of this asset. This is a memo only field and is not used for any calculations.

ASSET

Y

FINANCING_CD

Financing Code

User defined financing code. Should be a valid value on the FINANCE_CD_TBL.

ASSET

ASSET_DTTM_STAMP

Asset Date/Time Stamp

Used for internal processing. Do not populate.

Used internally.

PROFILE_ID

Asset Profile ID

Identifies the profile to be used to default the book information on an asset add. This field is only used if the INTFC_FIN.DEFAULT_PROFILE_SW = ‘Y’. When that field is set to ‘Y’ then Profile ID must be populated with a valid, effective-dated Profile ID on the PROFILE_DET_TBL.

ASSET

Y

ASSET_CLASS

Asset Class

Identifies the asset class that this asset falls into. This is just another way to categorize your assets. This field must be a valid value on the ASSET_CLASS_TBL. This table is maintained in the Establish Asset Processing menu online.

ASSET

CAP_NUM

Capital Acquisition Plan Number

Combined with CAP_SEQUENCE this field identifies the C.A.P. that this asset is associated with. Capital Acquisition Planning (C.A.P.) is a way of specifying asset budgets or appropriations.

ASSET

MFG_ID

Manufacturer ID

Manufacturer Id of the Asset.

ASSET

Y

MANUFACTURER

Manufacturer Name

Manufacturer of the asset.

ASSET

MODEL

Model

Model of the asset.

ASSET

PROD_VERSION

Product Version

Product version of the asset.

ASSET

SERIAL_ID

Serial ID

Serial number of the asset.

ASSET

PRODUCTION_DT

Production Date

Production date of the asset.

ASSET

PLANT

Manufacturing Plant

Plant that manufactured the asset.

ASSET

MANUFACTUR_CONTACT

Manufacturing Contact

Contact at the plant that manufactured the asset.

ASSET

CAP_SEQUENCE

C.A.P. Sequence

Combined with CAP_NUM this field identifies the C.A.P. that this asset is associated with. Capital Acquisition Planning (C.A.P.) is a way of specifying asset budgets or appropriations.

ASSET

REPLACEMENT_COST

Replacement Cost

Estimated replacement cost of the asset. This field can be processed by the Indexing feature in Asset Management.

The indexing feature only updates replacement cost. It does not perform the initial population of this field.

ASSET

LEASE_ASSET_ID

Lease Asset ID

If this is a non-capitalized asset and is associated with a lease, this is the Asset ID of that lease. This field must identify a capitalized asset ID with an acquisition code of leased.

ASSET

BUSINESS_UNIT_JV

Joint Venture Business Unit

The “parent” JV business unit, if the asset is part of a joint venture.

Used internally

INDEX_NAME

Index Name

Identifies which index to use in revaluing asset cost.

ASSET

INDEX_DETAIL_NAME

Index Detail Name

Same as INDEX_NAME.

ASSET

LAST_INDEX_VALUE

Last Index Value

Last index value used to revalue assets, such as the Consumer Price Index.

ASSET

Y

COMPOSITE_SW

Composite Asset?

Used to indicate whether the asset is a composite asset. Similar to parent/child assets except that a composite asset is not a “virtual” asset. The composite asset exists as a standard asset record within the Asset Management system.

ASSET

COMPOSITE_ID

Composite Asset ID

If applicable, enter the Asset ID of the composite asset that is associated with this asset record.

ASSET

FERC_CD

FERC Code

Identifies the FERC code associated with this asset. The valid values must be set up on the FERC Code table prior to implementation. PeopleSoft ships a ‘MODEL’ set of FERC codes with the system that can be shared by your business units.

ASSET

SEQUENCE_NBR_6

Sequence

Used to sequence the acquisition detail table. This field must be incremented for each acquisition detail row for an asset. The Transaction Loader does not increment this field, it must be assigned correctly on the INTFC_PHY_A table. This means that the feeder system must set this field. For the Payables and Purchasing interface this field is set by AMPS1000.SQR.

ASSET_ACQ_DET

ACQUISITION_DESCR

DESCR field for ACQ_DETAIL

A description for the acquisition detail for this transaction.

ASSET_ACQ_DET

CAPITALIZATION_SW

Capitalized?

Identifies whether this particular transaction should be capitalized. Valid values are on the translate table.

This must be set to 1, 2, 3, or 4 in order for acquisition detail records to be inserted.

ASSET_ACQ_DET

BUSINESS_UNIT_AP

AP Business Unit

The business unit from Accounts Payable that generated this transactions.

ASSET_ACQ_DET

TXN_CURRENCY_CD

Transaction Currency

Transaction Currency Code

ASSET_ACQ_DET

Y

CURRENCY_CD

Currency Code

Represents the currency of the transaction.

ASSET_ACQ_DET

Y

RATE_DIV

Rate Divisor

Currency Conversion.

ASSET_ACQ_DET

Y

RATE_MULT

Rate Multiplier

Currency Conversion.

ASSET_ACQ_DET

Y

RT_TYPE

Rate Type

Currency Conversion.

ASSET_ACQ_DET

Y

BUSINESS_UNIT_PO

PO Business Unit

The business unit from Purchasing that is associated with this transaction.

ASSET_ACQ_DET

PO_ID

Purchase Order Number

The PO number from Purchasing that is associated with this transaction.

ASSET_ACQ_DET

PO_LINE_NBR

Purchase Order Line Number

The PO line number from Purchasing that is associated with this transaction.

ASSET_ACQ_DET

SCHED_NBR

Schedule Number

The schedule number from Purchasing that is associated with this transaction.

ASSET_ACQ_DET

PO_DIST_LINE_NUM

PO Distribution Line Number

The distribution line number from Purchasing that is associated with this transaction.

ASSET_ACQ_DET

REFERENCE_ID

Reference Number

A general reference number associated with the acquisition of this asset.

ASSET_ACQ_DET

INVOICE_DT

Invoice Date

Represents the date of the invoice associated with this transaction.

ASSET_ACQ_DET

VENDOR_ID

Vendor ID

The vendor ID from Accounts Payable or Purchasing that is associated with this transaction.

ASSET_ACQ_DET

VENDOR_NAME

Vendor Name

The name of the vendor associated with this transaction. This would only be used when an external purchasing or payable system is used.

ASSET_ACQ_DET

INVOICE_ID

Invoice Number

The invoice number of the invoice associated with this transaction.

ASSET_ACQ_DET

TXN_AMOUNT

Transaction Amount

Amount in Transaction Currency.

ASSET_ACQ_DET

AMOUNT

Amount

The amount of this transaction. This is the amount that will be capitalized if that is what has been requested. Note that this field is NOT used by Transaction Loader for inserting cost. It is the amount field on Acq Detail. It should match the COST field on INTFC_FIN.

ASSET_ACQ_DET

QUANTITY

Quantity

The quantity of this transaction. This is the quantity that will be capitalized if that is what has been requested. Note that this field is NOT used by Transaction Loader for inserting cost. It is the quantity field on Acq Detail. It should match the QUANTITY field on INTFC_FIN.

ASSET_ACQ_DET

SALETX_AMT

Sales Tax Distribution Amount

The amount of sales tax associated with this transaction.

ASSET_ACQ_DET

SALETX_AMT_BSE

Base Sales Tax Amount

Sale Tax Amount in Transaction Currency

ASSET_ACQ_DET

SALETX_CD

Sales Tax Code

The code representing the sales taxing authority associated with this transaction.

ASSET_ACQ_DET

USETAX_AMT

Use Tax Distribution Amount

The amount of use tax associated with this transaction.

ASSET_ACQ_DET

USETAX_AMT_BSE

Base Use Tax Amount

Use Tax Amount in Transaction Currency.

ASSET_ACQ_DET

USETAX_CD

Use Tax Code

The code representing the use taxing authority associated with this transaction.

ASSET_ACQ_DET

FREIGHT_AMT

Freight Amount

The amount of freight associated with this transaction.

ASSET_ACQ_DET

FREIGHT_AMT_BSE

Base Freight Amount

Freight Amount in Transaction Currency.

ASSET_ACQ_DET

BUSINESS_UNIT_RECV

Business Unit Receive

Identifies the Purchasing receiving business unit that this transaction is associated with.

ASSET_ACQ_DET

RECEIVER_ID

Receiver ID

Identifies the Purchasing receiving receiver ID that this transaction is associated with.

ASSET_ACQ_DET

RECV_LN_NBR

Receiver Line Number

Identifies the Purchasing receiving line number that this transaction is associated with.

ASSET_ACQ_DET

RECV_SHIP_SEQ_NBR

Receiver Shipping Sequence Number

Identifies the Purchasing receiving shipping sequence number that this transaction is associated with.

ASSET_ACQ_DET

RECV_DIST_LINE_NUM

Receiver Distribution Line Number

Identifies the Purchasing receiving distribution line number that this transaction is associated with.

ASSET_ACQ_DET

DISTRIB_SEQ_NUM

Distribution Sequence Number

Identifies the Purchasing receiving distribution sequence number that this transaction is associated with.

ASSET_ACQ_DET

INV_ITEM_ID

Inventory Item ID

Identifies the inventory item ID that this transaction is associated with.

ASSET_ACQ_DET

OPERATING_UNIT

Operating Unit

The operating unit (ChartField) associated with this transaction. This field should be the same as the corresponding ChartField on the INTFC_FIN table. See the online ChartField customization topic for further discussion.

ASSET_ACQ_DET

DEPTID

Department

The department (ChartField) associated with this transaction. This field should be the same as the corresponding ChartField on the INTFC_FIN table.

ASSET_ACQ_DET

PRODUCT

Product

The product (ChartField) associated with this transaction This field should be the same as the corresponding ChartField on the INTFC_FIN table.

ASSET_ACQ_DET

FUND_CODE

Fund Code

A ChartField, which can be customized. See the online ChartField customization topic for further discussion.

ASSET_ACQ_DET

Y

CLASS_FLD

Class Field

A ChartField, which can be customized. See the online ChartField customization topic for further discussion.

ASSET_ACQ_DET

Y

PROGRAM_CODE

Program Code

A ChartField, which can be customized. See the online ChartField customization topic for further discussion.

ASSET_ACQ_DET

Y

BUDGET_REF

Budget Reference

A ChartField, which can be customized. See the online ChartField customization topic for further discussion.

ASSET_ACQ_DET

Y

AFFILIATE

Affiliate

A ChartField, which can be customized. See the online ChartField customization topic for further discussion.

ASSET_ACQ_DET

Y

AFFILIATE_INTRA1

Fund Affiliate

A ChartField, which can be customized. See the online ChartField customization topic for further discussion.

ASSET_ACQ_DET

Y

AFFILIATE_INTRA2

Operating Unit Affiliate

A ChartField, which can be customized. See the online ChartField customization topic for further discussion.

ASSET_ACQ_DET

Y

CHARTFIELD1

ChartField 1

A ChartField, which can be customized. See the online ChartField customization topic for further discussion.

ASSET_ACQ_DET

Y

CHARTFIELD2

ChartField 2

A ChartField, which can be customized. See the online ChartField customization topic for further discussion.

ASSET_ACQ_DET

Y

CHARTFIELD3

ChartField 3

A ChartField, which can be customized. See the online ChartField customization topic for further discussion.

ASSET_ACQ_DET

Y

PROJECT_ID

Project ID

The project (ChartField) associated with this transaction This field should be the same as the corresponding ChartField on the INTFC_FIN table.

ASSET_ACQ_DET

CATEGORY

Asset Category

The category associated with this transaction. This field should be the same as the category on the INTFC_FIN table.

ASSET_ACQ_DET

Y

COST_TYPE

Cost Type

The cost type associated with this transaction. This field should be the same as the cost type on the INTFC_FIN table.

ASSET_ACQ_DET

BUSINESS_UNIT_PC

Projects Business Unit

The business unit in Projects that generated this asset transaction. Can also come from Purchasing/Payables integration.

ASSET_ACQ_DET

MASTER_PROJECT

Master Project

The master project in Projects that generated this asset transaction.

ASSET_ACQ_DET

ACTIVITY_ID

Activity ID

The activity ID in Projects that generated this asset transaction. Can also come from Purchasing/ Payables integration.

ASSET_ACQ_DET

RESOURCE_TYPE

Resource Type

The resource type in Projects that generated this asset transaction. Can also come from Purchasing/ Payables integration.

ASSET_ACQ_DET

RESOURCE_SUB_CAT

Resource subcategory

The resource subcategory from Projects, Purchasing or Payables.

ASSET_ACQ_DET

ANALYSIS_TYPE

Resource Analysis type

The resource analysis type in Projects that generated this asset transaction. Can also come from Purchasing/ Payables integration.

ASSET_ACQ_DET

RESOURCE_CATEGORY

Resource category

The resource category in Projects that generated this asset transaction. Can also come from Purchasing/ Payables integration.

ASSET_ACQ_DET

CUSTODIAN_EFFDT

Asset Custodian Effective Date

The date the custodian of this asset became effective. If the transaction is an add, the date should be the same as the trans_dt. It is very important that this field be formatted with a valid date on an add transaction, whether or not the custodian is known. Transaction loader uses this when inserting custodian entries. If it is null, no custodian entry is loaded.

ASSET_CUSTODIAN

Y

EFFSEQ

Effective Sequence

The sequence number of the custodian. This will be zero unless the asset has had more than one custodian for a given effective date.

ASSET_CUSTODIAN

CUSTODIAN

Custodian

The name of the custodian of this asset.

ASSET_CUSTODIAN

EMPLID

Asset Custodian Employee ID

The employee ID of the custodian of this asset.

ASSET_CUSTODIAN

CUSTODIAN_DEPTID

Asset Custodian Department

The department of the custodian of this asset.

ASSET_CUSTODIAN

CUSTODIAN_PROJECT

Asset Custodian Project

The project associated with the custodian of this asset.

ASSET_CUSTODIAN

OFFSITE_SW

Offsite?

Is this asset offsite? Valid values are ‘Y’ or ‘N’.

ASSET_CUSTODIAN

AUTH_STATUS

Authorization Status

The status of the authorization for this asset to be assigned to this custodian.

ASSET_CUSTODIAN

AUTHORIZATION_NAME

Authorization Name

The name of the person will has authorized this asset to be assigned to this custodian.

ASSET_CUSTODIAN

AUTHORIZATION_DT

Authorization Date

The date of the authorization for this asset to be assigned to this custodian.

ASSET_CUSTODIAN

LOCATION_EFFDT

Location Effective Date

The date the location of this asset became effective. If the transaction is an add, the date should be the same as the trans_dt. It is very important that this field be formatted with a valid date on an add transaction, whether or not the location is known. Transaction loader uses this when inserting location entries. If it is null, a location entry is not loaded.

ASSET_LOCATION

Y

LOCATION_EFFSEQ

Location Effective Sequence

The sequence number of the location. This will be zero unless the asset has been in more than one location for a given effective date.

ASSET_LOCATION

LOCATION

Location

The location of this asset. Should be a valid value on the LOCATION_TBL.

PI_ASSET_HIST

PI_ID

Physical Inventory ID

Used for internal processing. Do not populate. The physical inventory ID that was entered when defining physical inventory is used here.

ASSET_LOCATION

INVENTORY_DT

Last Inventory Date

The last date that this asset was inventoried at this location.

PI_ASSET_HIST

PERFORMED_BY

Performed By

The name of the person who performed the last inventory.

PI_ASSET_HIST

DOCUMENT_ID

Document

A reference document ID associated with this asset.

ASSET_LOCATION

LOC_AUTH_STATUS

Location Authorization Status

The authorization status for this asset at this location.

ASSET_LOCATION

LOC_AUTH_NAME

Location Authorization Name

The name of the person who authorized this asset to be at this location.

ASSET_LOCATION

LOC_AUTH_DT

Location Authorization Date

The date the authorization was given for this asset to be at this location.

ASSET_LOCATION

REPLACE_COST_DT

Replacement Cost Date

Same as INDEX_NAME.

ASSET

GROUP_ASSET_FLAG

Group Asset Flag

Used for Group Asset Processing.

ASSET

GROUP_ASSET_ID

Group Asset ID

Used to identify which group asset group members report to.

BOOK, COST, DEPRECIATION, OPEN_TRANS

RD_PLANT_ASSET

R&D Plant Asset

Flag to indicate this asset is used for R&D.

ASSET

RD_START_DATE

R&D Start Date

Date asset became used for R&D.

ASSET

RD_USE_NBV

Use NBV for R&D

Use net book value in gain/loss calculations for R&D assets.

ASSET

LAST_INDEX_VALUE

Last Index Value

Last index value used to revalue assets, such as the Consumer Price Index.

ASSET

INCENTIVE_ID

Incentive ID

An incentive ID, as would be assigned to a grant. Assigned in Projects and sent to Asset Management.

ASSET_ACQ_DET

IP_ADDRESS

IP Address

The Internet Protocol address of an asset, such as a computer or printer. Can be uploaded from Tangram’s Asset Insight during Physical Inventory.

ASSET

IP_ALIAS

IP Alias

May be used to capture the name of a user associated with an asset, since IP addresses may be dynamic. Can be uploaded from Tangram’s Asset Insight during Physical Inventory.

ASSET

MERCH_AMT_BSE

Merchandise amount

Used in Payables/Assets integration.

ASSET_ACQ_DET

VAT_INV_AMT

VAT Invoice Amount

Vat Invoice in Transaction Currency.

ASSET_ACQ_DET

Y

VAT_INV_AMT_BSE

VAT invoice amount

Used in Payables/Assets integration.

ASSET_ACQ_DET

VAT_NRCVR_AMT

VAT NonRecoverable Amount

Vat Non Recoverable in Transaction Currency.

ASSET_ACQ_DET

Y

VAT_NRCVR_AMT_BSE

VAT Nonrecoverable amount

Used in Payables/Assets integration.

ASSET_ACQ_DET

VAT_RCVRY_AMT

VAT Recovery Amt

Vat Recoverable in Transaction Currency.

ASSET_ACQ_DET

Y

VAT_RCVRY_AMT_BSE

VAT recovery amount

Used in Payables/Assets integration.

ASSET_ACQ_DET

MISC_AMT

Misc Charge Amount

Miscellaneous Charges in transaction Currency.

ASSET_ACQ_DET

Y

MISC_AMT_BSE

Base Misc. Amount

Used in Payables/Assets integration.

ASSET_ACQ_DET

Y

AM_AST_UD_CHAR1

User-defined Asset character field

ASSET

AM_AST_UD_CHAR2

User-defined Asset character field

ASSET

AM_AST_UD_DATE1

User-defined Asset date field

ASSET

AM_AST_UD_NUM1

User-defined Asset numeric field

ASSET

AM_AST_UD_NUM2

User-defined Asset numeric field

ASSET

PROCESS_INSTANCE

Process Instance

Internal

MERCHANDISE_AMT

Merchandise Amt

Merchandise Amount in Transaction Currency.

ASSET_ACQ_DET

Y

SKU

Stock Keeping Unit

Used to identify IT Software

ASSET

UPC_ID

Uniform Product Code ID

Used to identify IT Software

ASSET

VIN

VIN

Vehicle Identification Number

ASSET

ASSET_RESOURCE_SW

Asset Resource Switch

Used by Maintenance Management. Indicates if Asset is "used as a tool".

ASSET

ALLOW_OVERBOOK_SW

Allow Overbooking

Used by Maintenance Management to check if an asset can be double booked for scheduling. MM passes this to RM for Scheduling

ASSET

CHARGE_BACK_SW

Charge Back Switch

Used by Maintenance Management. Allow chargebacks - this is one of the default levels for chargebacks

ASSET

SCHEDULABLE_SW

Schedulable Switch

Used by Maintenance Management. Asset to be used in WO is able to be scheduled for maintenance.

ASSET

EPL_TMPL_ID

Parts List Template

Used by Maintenance Management. Equipment and Parts list.

ASSET

REPAIRABLE_FLG

Repairable Flag

Used by Maintenance Management. Asset is repairable.

ASSET

REPAIR_STATUS

Repair Status

Used by Maintenance Management. Field values are: None, Needs Repair, In Repair.

ASSET

BUSINESS_UNIT_WO

Business Unit

Used by Maintenance Management. The Business Unit of the Work Order where this asset could be used.

ASSET

SHOP_ID

Shop

Used by Maintenance Management. hop/Location where the work order tasks are to be done. The shop for which this asset is used.

ASSET

UNOWNED_FLG

Non-Owned Asset

Used by Maintenance Management. Asset not owned by the organization

ASSET

WO_LOCATION_FLG

Work Order Location

Used by Maintenance Management. This field is used to determine what Location should be defaulted to the Work Location field on the Work Order Task, it contains 3 values: 'Asset' would default the Asset's Location as specified in the Asset definition; 'Shop' would default the Shop's Location; 'Other' will leave the Work Location blank for user entry.

ASSET

OFFLINE_FLG

Asset Offline

Used by Maintenance Management. An indicator to indicate whether it needs to be taken offline for maintenance.

ASSET

ASSET_CRITICALITY

Asset Criticality

Used by Maintenance Management. Indicator of how critical the asset is to help managers identify the priority of maintenance.

ASSET

AVAIL_FOR_USE

Available For Use

Used by Maintenance Management. Asset is available to be used by a Work Order request.

ASSET

PROPERTY_ID

Property I

Used by Real Estate Management. Identifier for an asset property

ASSET_PROPERTY

PROPERTY_DESCR

Property Description

Used by Real Estate Management. Description of asset property

ASSET_PROPERTY

PROPERTY_NM

Property Name

Used by Real Estate Management. Name of the asset property.

ASSET_PROPERTY

PROPERTY_CLASS

Property Class

Used by Real Estate Management. Indicator that the property is a SITE, BUILDING, FLOOR, AREA, or SPACE.

ASSET_PROPERTY

PROPERTY_SUBCLASS

Property Subclass

Used by Real Estate Management. Subcategory of Property Class.

ASSET_PROPERTY

PARENT_PROPERTY_ID

Parent Property ID

Used by Real Estate Management. Parent Asset of the property.

ASSET_PROPERTY

SITE_PROPERTY_ID

Site ID

Used by Real Estate Management. Property ID of the SITE for the asset's property hierarchy.

ASSET_PROPERTY

BLDG_PROPERTY_ID

Building ID

Used by Real Estate Management. Property ID of the SITE for the asset's property hierarchy.

ASSET_PROPERTY

FLOOR_PROPERTY_ID

Floor ID

Used by Real Estate Management. Property ID of the BUILDING for the asset property hierarchy.

ASSET_PROPERTY

AREA_PROPERTY_ID

Area ID

Used by Real Estate Management. Property ID of the BUILDING for the asset property hierarchy.

ASSET_PROPERTY

SPACE_PROPERTY_ID

Space ID

Used by Real Estate Management. Property ID of the AREA for the asset's property hierarchy.

ASSET_PROPERTY

PARCEL_NUMBER

Parcel Number

Used by Real Estate Management. Property ID of the SPACE for the asset's property hierarchy.

ASSET_PROPERTY

LOT

Lot Number

Used by Real Estate Management. Used to record legal description from surveyors when recorded in Lots and Blocks.

ASSET_PROPERTY

BLOCK

Block Number

Used by Real Estate Management. Used to record legal description from surveyors when recorded in Lots and Blocks.

ASSET_PROPERTY

TOTAL_AREA

Total Area

Used by Real Estate Management. Total measurement in sq. ft or sq. meters for the asset.

ASSET_PROPERTY

SPACE_UOM

Space Unit of Measure

Used by Real Estate Management. Used in conjunction with Total Area. Indicates Sq. Ft and Sq. Meters.

ASSET_PROPERTY

CURRENT_OCCUPANCY

Current Occupancy

Used by Real Estate Management. Number of people currently occupying the asset property.

ASSET_PROPERTY

MAX_OCCUPANCY

Maximum Occupancy

Used by Real Estate Management. Max number of people that can be assigned to the asset property.

ASSET_PROPERTY

OCCUPANCY_STATUS

Occupancy Status

Used by Real Estate Management. Indicates whether it is "occupied" or "unoccupied".

ASSET_PROPERTY

OWNERSHIP_STATUS

Ownership Status

Used by Real Estate Management. Indicates whether it is "owned" or "leased".

ASSET_PROPERTY

LEGAL_DESCR

Legal Description

Used by Real Estate Management. Legal description of asset property using metes and bounds.

ASSET_PROPERTY

IT_UD_CHAR1

IT User Defined Char Field 1

ITAM User Defined Fields

ASSET

IT_UD_CHAR2

IT User Defined Char Field 2

ITAM User Defined Fields

ASSET

IT_UD_DATE1

IT User Defined Date Field

ITAM User Defined Fields

ASSET

IN_SERVICE_DT

In Service Date

Used to determine if the asset is still under warranty.

ASSET

REGION_CD

Region Code

Used by Real Estate Management for Space Utilization metrics. Prompt allows for values for RPT Region Types.

CC_FLAG

Component Changeout Old/New

Internal

INTFC_ID

Interface ID

Key to this table. An interface ID is typically assigned to a group of transactions with the same load type.

Use a unique, previously unused INTFC_ID for each set of transactions with the same load type.

When using a load type of CN1 and NEXT in the ASSET_ID field, you’ll need to use a unique INTFC_ID for each asset.

For FADs and Conversions, if INTFC_ID is the same for multiple lines for an asset, increment the INTFC_LINE_NUM for each individual line.

Used internally.

Y

INTFC_LINE_NUM

Interface Line Number

Key to this table. Interface Line Number is used as a key for multiple lines for the same Interface ID for transactions with similar keys (ex., multiple acquisition details, such as CAP).

For FADs and Conversions, if INTFC_ID is the same for multiple lines for an asset, increment the INTFC_LINE_NUM for each individual line.

Used Internally.

Y

BUSINESS_UNIT

Business Unit

Identifies the business unit of the transaction to be processed. This field is required.

ASSET_ATTRIBUTE, ASSET_COMMENTS, ASSET_LICENSE, ASSET_WARRANTY

Y

ASSET_ID

Asset ID

Identifies the asset ID of the transaction to be processed. This field is required. If this field contains the value ‘NEXT’ and the interface type is FAD then Transaction Loader will assign the next asset ID for this business unit.

ASSET_ATTRIBUTE, ASSET_COMMENTS, ASSET_LICENSE, ASSET_WARRANTY

Y

INTFC_TYPE

Interface Type, also called Load Type

Identifies the type of transaction this is. Transaction loader will process this transaction based upon this field. Valid values are listed in the translate table.

Used internally.

Y

SYSTEM_SOURCE

System Source

The source system that created this transaction. Valid values are listed in the translate table. This field is used extensively by AM to drill back to source system. Feel free to add valid values to the translate table for your external systems. You can run Transaction Loader selectively for specific values of system source.

Used internally.

Y

MC_DEFN_ID

Mass Change ID

Used for internal processing. Do not populate.

Used internally.

APPROVAL_SW

Auto Approval Status

Identifies whether the transaction is approved or not. Transaction Loader will only load approved transactions. Valid values are ‘Y’ for approved and ‘N’ for not approved.

Used internally.

Y

INTFC_STATUS

Interface Status

Used for internal processing. Do not populate.

Used internally.

LOAD_STATUS

Load Status

Identifies the status of this transaction. Valid values are ‘NEW’ = not processed; ‘ERR’ = an error exists on this transaction and it will not be processed; ‘DON’ = the transaction has been successfully processed. ‘CON’ = transaction has been consolidated into a different transaction and it will not be loaded. ‘UNI’ = transaction has been unitized into a different transaction and it will not be loaded.

Used internally.

Y enter NEW

ATTRIBUTE_EFFDT

Asset Attribute Effective Date

These next fields relate to the Asset_Attributes record. This is optional information. If you do not populate these fields then a row of asset attribute information will not be created for the asset (thus saving space). You can populate the asset attributes on as many (or as few) assets as you like. It is not an all or nothing proposition. If you are not planning on tracking attributes (color, weight, height, width, length, capacity, power rating) for an asset, then do not populate these fields for that asset.

The effective date of the attributes of this asset. If the asset is being added, this should be the same as the trans_dt.

ASSET_ATTRIBUTE

ASSET_COLOR

Asset Color

The color of the asset.

ASSET_ATTRIBUTE

ASSET_WEIGHT

Asset Weight

The weight of the asset.

ASSET_ATTRIBUTE

WEIGHT_UM

Asset Weight Unit of Measure

The unit of measure used for the asset weight. Should be a valid unit of measure defined on the units of measure table.

ASSET_ATTRIBUTE

ASSET_HEIGHT

Asset Height

The height of the asset.

ASSET_ATTRIBUTE

HEIGHT_UM

Asset Height Unit of Measure

The unit of measure used for the asset height. Should be a valid unit of measure defined on the units of measure table.

ASSET_ATTRIBUTE

ASSET_WIDTH

Asset Width

The width of the asset.

ASSET_ATTRIBUTE

WIDTH_UM

Asset Width Unit of Measure

The unit of measure used for the asset width. Should be a valid unit of measure defined on the units of measure table.

ASSET_ATTRIBUTE

ASSET_LENGTH

Asset Length

The length of the asset.

ASSET_ATTRIBUTE

LENGTH_UM

Asset Length Unit of Measure

The unit of measure used for the asset length. Should be a valid unit of measure defined on the units of measure table.

ASSET_ATTRIBUTE

ASSET_CAPACITY

Asset Capacity

The capacity of the asset.

ASSET_ATTRIBUTE

CAPACITY_UM

Asset Capacity Unit of Measure

The unit of measure used for the asset capacity. Should be a valid unit of measure defined on the units of measure table.

ASSET_ATTRIBUTE

POWER_RATING

Asset Power Rating

The power rating of the asset.

ASSET_ATTRIBUTE

POWER_RATING_UM

Asset Power Rating Unit of Measure

The unit of measure used for the asset power rating. Should be a valid unit of measure defined on the units of measure table.

ASSET_ATTRIBUTE

COMMENT_DTTM_STAMP

Asset Comments Date/Time Stamp

The date/time stamp of the comments for this asset. This is used as a key to the Asset_Comments record.

ASSET_COMMENTS

NAME

Name

The name of the person who entered the comments.

ASSET_COMMENTS

COMMENTS50

Comments 50 Characters

The comments for the assets. This field is long on the Asset_Comments record, but is a 50 byte character field here due to database restrictions. You can load additional comments online that can be up to 32k in length.

ASSET_COMMENTS

AGENCY_ID

Agency ID

These next fields relate to the Asset_License record. It is used to track the license or registration of an asset with a given agency or vendor. An example may be a vehicle registration with the state or software registration with a vendor (like PeopleSoft!). This is optional information. If you do not populate these fields then a row of asset license information will not be created for the asset (thus saving space). You can populate asset license information on as many (or as few) assets as you like. It is not an all or nothing proposition. If you are not planning on tracking license information for an asset, then do not populate these fields for that asset.

This field is the agency that the asset is registered with and is mutually exclusive of the asset license vendor ID. Should be a valid value on the Agency_Tbl record.

ASSET_LICENSE

LICENSE_VENDOR_ID

Asset License Vendor ID

This is the vendor that the asset is registered with and is mutually exclusive with the agency ID. Should be a valid value on the VNDR_FS record.

ASSET_LICENSE

REGISTRATION_NO

Registration Number

The registration number for the asset.

ASSET_LICENSE

INSPECTION_SW

Inspection Required?

Is an inspection of the asset required? Valid values are ‘Y’ or ‘N’.

ASSET_LICENSE

LIC_START_DT

License Effective Date

The effective date of the license or registration.

ASSET_LICENSE

LIC_END_DT

License Expiration Date

The expiration date of the license or registration.

ASSET_LICENSE

REGISTER_NAME

Name

The name of the person under which the asset is registered.

ASSET_LICENSE

COUNTRY

Country

The country in which the asset is registered.

ASSET_LICENSE, COUNTRY

ADDRESS1

Address 1

The address line 1 under which the asset is registered.

ASSET_LICENSE

ADDRESS2

Address 2

The address line 2 under which the asset is registered.

ASSET_LICENSE

ADDRESS3

Address 3

The address line 3 under which the asset is registered.

ASSET_LICENSE

ADDRESS4

Address 4

The address line 4 under which the asset is registered.

ASSET_LICENSE

CITY

City

The city under which the asset is registered.

ASSET_LICENSE

NUM1

Number 1

ASSET_LICENSE

NUM2

Number 2

ASSET_LICENSE

HOUSE_TYPE

House Type

The type of house, for example houseboat, trailer.

ASSET_LICENSE

ADDR_FIELD1

Address Field 1

Address Field

ASSET_LICENSE

ADDR_FIELD2

Address Field 2

Address Field

ASSET_LICENSE

ADDR_FIELD3

Address Field 3

Address Field

ASSET_LICENSE

COUNTY

County

The county under which the asset is registered.

ASSET_LICENSE

STATE

State

The state under which the asset is registered.

ASSET_LICENSE

POSTAL

Postal Code

The postal code under which the asset is registered.

ASSET_LICENSE

GEO_CODE

Tax Vendor Geographical Code

The tax vendor geographical code.

ASSET_LICENSE

IN_CITY_LIMIT

In City Limit

Is vendor within city limit?

ASSET_LICENSE

LICENSE_COMMENTS50

Asset License Comments 50 Characters

Comments about the license or registration for the asset.

ASSET_LICENSE

WARRANTY_EFFDT

Warranty Effective Date

The following fields relate to the Asset_Warranty record. This is optional information. If you do not populate these fields then a row of asset warranty information will not be created for the asset (thus saving space). You can populate asset warranty information on as many (or as few) assets as you like. It is not an all or nothing proposition. If you are not planning on tracking warranty information for an asset, then do not populate these fields for that asset.

This field represents the date the warranty for this asset became effective.

ASSET_WARRANTY

EFF_STATUS

Status as of Effective Date

The status of the warranty as of the effective date. Valid values are ‘A’ for active, or ‘I’ for inactive.

ASSET_WARRANTY

WARRANTY_VENDOR_ ID

Warranty Vendor ID

The vendor ID that has provided the warranty. This should be a valid value on the VNDR.FS record.

ASSET_WARRANTY

WARRANTY_NUM

Warranty Number

The number of the warranty.

ASSET_WARRANTY

WARRANTY_DURATION

Warranty Duration (Months)

The duration of the warranty in months.

ASSET_WARRANTY

COVERAGE50

Asset Warranty Coverage 50 Characters

The comments on the coverage of the warranty. This field is a long field on the Asset_Warranty record, but is only 50 characters here. Online you can enter up to 32K of information into this field.

ASSET_WARRANTY

JURISDICTION

Jurisdiction

Identifies the municipal authority of which it is a part.

Could be used by property tax to identify taxing authority.

ASSET_LICENSE

AM_AST_UD_CHAR1

User Defined Char Field 1

User defined.

ASSET

AM_AST_UD_CHAR2

User Defined Char Field 2

User defined.

ASSET

AM_AST_UD_DATE1

User Defined Date Field 1

User defined.

ASSET

AM_AST_UD_NUM1

User Defined Number Field 1

User defined.

ASSET

AM_AST_UD_NUM2

User Defined Number Field 2

User defined.

ASSET

PROCESS_INSTANCE

Process Instance

Internal

FAD

Book* Book Profile # Cost * Cost Profile # Depreciation * Depreciation Profile # Open Trans * Open Trans Profile #

ADD

Book * Book Profile # Cost * Cost Profile # Depreciation * Depreciation Profile # Open Trans * Open Trans Profile #

CN1

Book * Book Profile # Cost * Cost Profile # Depreciation * Depreciation Profile #

Process Conversion Open Trans 1

CN2

Book * Book Profile # Cost * Cost Profile # Depreciation * Depreciation Profile #

Process Conversion Open Trans 1

CAP

Book * Book Profile # Cost * Cost Profile # Depreciation * Depreciation Profile # Open Trans * Open Trans Profile #

CIC

Book * Book Profile # Cost * Cost Profile # Open Trans * Open Trans Profile #

Validate Distribution Templates

AAD

Cost * Cost Profile # Open Trans * Open Trans Profile #

IUI

Book * Cost # Open Trans *

Set Trans Type to TRF Set Trans_In_Out to I Validate Distribution Templates Process IUI Asset ID

IUO

Cost * Open Trans *

Set Trans Type to TRF Set Trans_In_Out to O Validate Distribution Templates

TRF

Cost (positive amount for transfer in) * Cost (negative amount for transfer out) * Open Trans *

ADJ

Cost * Open Trans *

RCT

Cost * Open Trans *

RET

Cost * Retirement Open Trans *

Set Asset Status to Disposed

PRT

Cost * Retirement Open Trans *

REI

Cost * Retirement Open Trans *

Update Asset Status to In Service

BKS

Open Trans *

Update Book Processing

BKD

Delete Book

BSD

Delete only BU/Book/Asset ID combinations

OPT

Open Trans *

ASD

Deletes from all base tables

Check DIST_LN

Delete Asset Processing

ADQ

Cost * Cost Profile # Open Trans * Open Trans Profile #

ARA

Book * Book Profile # Cost * Cost Profile # Depreciation * Depreciation Profile # Retirement * Retirement Profile #

LAD

Book * Book Profile # Cost * Cost Profile # Depreciation * Depreciation Profile # Retirement * Retirement Profile # Open Trans *

FAD

Asset, Asset Acquisition Detail, Asset Custodian, Asset Location

NAD

Asset, Asset Acquisition Detai,l Asset Custodian, Asset Location

IUI

Asset, Asset Acquisition Detail, Asset Custodian, Asset Location

CN1

Asset, Asset Acquisition Detail, Asset Custodian ,Asset Location

AUP

Update Asset

PHY

Asset Acquisition Detail Asset Custodian Asset Location

CAP

Asset Acquisition Detail

Capitalize Asset Acquisition Detail

ACQ

Asset Acquisition Detail

ADQ

Asset Acquisition Detail

CLC

Asset Custodian Asset Location

LAD

Asset, Asset Custodian, Asset Location

CIC

Update Asset Acquisition Detail = CIC

IHI

Physical Inventory History

RAQ

Asset Acquisition Detail

Replace Acquisition Detail - Used solely by AMPS1000 and AMIF1000

ARA

Asset Custodian, Asset Location, Physical Inventory History, Parent Asset

FAD

Asset Attribute Asset Comments Asset License Asset Warranty

NAD

Asset Attribute Asset Comments Asset License Asset Warranty

PHY

Asset Attribute Asset Comments Asset License Asset Warranty

CN1

Asset Attribute Asset Comments Asset License Asset Warranty

ARA

Asset Attribute Asset Comments Asset License Asset Warranty

LAD

Asset Attribute Asset Comments Asset License Asset Warranty

AAD

Additional Cost Add

Rarely used. Used to add additional cost information to an asset. Mainly used for joint venture and composite rollups. Inserts into cost and open trans.

Cost, Open Trans

ACQ

Insert Acquisition Detail

Inserts into Acquisition Detail.

Acquisition Detail

ADD

Asset Add

Asset add - Financial only. Inserts into book, cost, depr, and open trans. For details see load type CN2.

Book, Cost, Depr, Open Trans

ADJ

Asset Cost Adjustment

To adjust the cost of an existing asset.

Cost, Open Trans

ADQ

Adjust Cost and Acquisition Detail

To adjust the cost and acquisition details of an existing asset.

Acquisition Detail, Cost, Open Trans

ARA

Add Retired Asset

To add an asset that has been fully reserved and retired.

Book, Cost, Depr, Asset, and if applicable Custodian, Asset Location, Warranty, Attribute, License, Comments, and Acquisition Detail

ASD

Asset Deletion

To delete an existing asset. This will only delete assets that have not been used to generate any journals.

Asset, Acquisition Detail, Attribute, Comments, Custodian, Location, Maintenance, Warranty, Book, Book Tax Credit, Cost, Depr, Dist Line, Open Trans, Retirement, Lease, Lease Schedule, PI Asset History,

AUP

Asset Information Update

To update the asset table only. Rarely used except in physical inventory.

Asset

BKD

Book Deletion

To delete a book for an asset or business unit. For example, this can be used to delete any dummy books used for performing ‘what if?’ analyses.

Book, Book Tax Credit, Depr, Dist Line, Retirement, Open Trans

BKS

Book Change

To make any change to an asset book.

Book, Open Trans

BSD

Selective Book Delete

To delete a book from a range of asset IDs. Very similar to BKD.

Book, Book Tax Credit, Depr, Dist Line, Retirement, Open Trans

CAP

Asset Capitalization

To add a line of acquisition detail and capitalize it. If the acquisition detail line is originally uncapitalized, the interface will insert book, cost, and open trans as well as acquisition detail. If it is originally capitalized, the book information will not be inserted.

Acquisition Detail, Book, Cost, Open Trans

CIC

Capitalize into Composite

Used to capitalize composite assets. Similar to CAP.

Acquisition Detail, Book, Cost, Open Trans

CLC

Custodian/Location Change

Updates custodian/location information.

Custodian, Location

CN1

Conversion of First Book

Used during conversion to convert the first asset book. Inserts into all asset tables, as well as financial tables.

Book, Cost, Depr, Open Trans, Asset, Acquisition Detail, Location, PI Asset History, Parent Asset, Attribute, Comments, License, Warranty

CN2

Conversion of Subsequent Books

Used during conversion to convert any subsequent books. Inserts only into financial tables.

Book, Cost, Depr, Open Trans

FAD

Financial and Physical Add

Used for adding assets with both physical and financial information. This is the Interface Type most commonly used for adding assets.

Book, Cost, Depr, Open Trans, Asset, Acquisition Detail, Location, PI Asset History, Parent Asset, Attribute, Comments, License, Warranty

IHI

Physical Inventory History Insert

Used by the Physical Inventory SQR (AMPI1000).

PI Asset History

IUI

InterUnit Transfer, In Side

Used for the IN side of an InterUnit Transfer. Valid values for ACTIVITY_SW include:

1 Full Transfer 0 Active ChartField combination -1 Reactivated ChartField combination

For example, one ChartField combination is fully transferred out of a department (ACTIVITY_SW = 1) and an identical ChartField combination is transferred in to the same department (ACTIVITY_SW = -1). The activity switch values for the two transactions then cancel each other out, resulting in an active ChartField combination (ACTIVITY_SW = 0).

Asset, Book, Cost, Open Trans

IUO

InterUnit Transfer, Out Side

Used for the OUT side of an InterUnit Transfer. Valid values for ACTIVITY_SW include:

1 Full Transfer 0 Active ChartField combination -1 Reactivated ChartField combination

For example, one ChartField combination is fully transferred out of a department (ACTIVITY_SW = 1) and an identical ChartField combination is transferred in to the same department (ACTIVITY_SW = -1). The activity switch values for the two transactions then cancel each other out, resulting in an active ChartField combination (ACTIVITY_SW = 0).

Cost, Open Trans

LAD

Leased Asset Add

Used to add leased assets.

Lease, Lease Schedule, Book, Cost, Depr, Open Trans, Asset, Acquisition Detail, Location, PI Asset History, Parent Asset, Attribute, Comments, License, Warranty

NAD

Non-financial Add

Used to add an asset with only physical information.

Asset, Custodian, Location, PI Asset History, Parent Asset, Attribute, Comments, License, Warranty, Open Trans

OPT

Open Transaction Generator

Used to create open transactions for a set of assets. Rarely used.

Open Trans

PHY

Physical Asset Change

Used to perform inserts to any physical asset tables other than the Asset Table, for example, location, custodian, or manufacturer.

Acquisition Detail, Custodian, Location, Attribute, Comments, License, Warranty

PRT

Partial Retirement

Used to perform partial retirements.

Cost, Retirement, Open Trans, Asset

RAQ

Replace Acquisition Detail

Used by AMPS1000 and AMIF1000

Acquisition Detail

RCT

Asset Recategorization

Used to perform recategorizations.

Cost, Open Trans

REI

Asset Reinstatement

Used to perform reinstatements.

Cost, Retirement, Open Trans, Asset

RET

Asset Retirement

Used to perform full retirements.

Cost, Retirement, Open Trans, Asset

TRF

IntraUnit Transfer

Used to perform transfers within the same business unit. Valid values for ACTIVITY_SW include:

1 Full Transfer 0 Active ChartField Combination -1 Reactivated ChartField Combination

For example, one ChartField combination is fully transferred out of a department (ACTIVITY_SW = 1) and an identical ChartField combination is transferred in to the same department (ACTIVITY_SW = -1). The activity switch values for the two transactions then cancel each other out, resulting in an active ChartField combination (ACTIVITY_SW = 0).

Cost, Open Trans