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, 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 line.

Internal use

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 line.

Internal use

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, and so on), 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. To do this, enter one row into the INTFC_FIN table for each book to which an asset reports.

This information can also be provided by default via the profile. 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 be populated by default from the profile, which is populated in INTFC_PHY_A.

If you are 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

Populates the key field of datetime stamp in many tables. Represents the date and 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 to ensure that this date will be earlier than the date of any further transactions.

This value is used as a key because INTFC_LINE_NUM is not always incremented (for example, when creating transactions via Mass Change). Making this a key is a safeguard against getting a duplicate insert.

If a single asset has multiple cost rows, 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

VOUCHER_ID

Voucher ID

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

Internal use

VOUCHER_LINE_NUM

Voucher Line Number

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

Internal use

DISTRIB_LINE_NUM

Distribution Line Number

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

Internal use

OPERATING_UNIT

Operating Unit

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

See PeopleSoft Application Fundamentals 9.1 PeopleBook, Understanding PeopleSoft ChartField Configuration.

COST, DEPRECIATION

DEPTID

Department

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

See PeopleSoft Application Fundamentals 9.1 PeopleBook, Understanding PeopleSoft ChartField Configuration.

COST, DEPRECIATION

PRODUCT

Product

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

See PeopleSoft Application Fundamentals 9.1 PeopleBook, Understanding PeopleSoft ChartField Configuration.

COST, DEPRECIATION

FUND_CODE

Fund Code

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

See PeopleSoft Application Fundamentals 9.1 PeopleBook, Understanding PeopleSoft ChartField Configuration.

COST, DEPRECIATION

CLASS_FLD

Class Field

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

See PeopleSoft Application Fundamentals 9.1 PeopleBook, Understanding PeopleSoft ChartField Configuration.

COST, DEPRECIATION

PROGRAM_CODE

Program Code

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

See PeopleSoft Application Fundamentals 9.1 PeopleBook, Understanding PeopleSoft ChartField Configuration.

COST, DEPRECIATION

BUDGET_REF

Budget Reference

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

See PeopleSoft Application Fundamentals 9.1 PeopleBook, Understanding PeopleSoft ChartField Configuration.

COST, DEPRECIATION

AFFILIATE

Affiliate

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

See PeopleSoft Application Fundamentals 9.1 PeopleBook, Understanding PeopleSoft ChartField Configuration.

COST, DEPRECIATION

AFFILIATE_INTRA1

Fund Affiliate

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

See PeopleSoft Application Fundamentals 9.1 PeopleBook, Understanding PeopleSoft ChartField Configuration.

COST, DEPRECIATION

AFFILIATE_INTRA2

Operating Unit Affiliate

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

See PeopleSoft Application Fundamentals 9.1 PeopleBook, Understanding PeopleSoft ChartField Configuration.

COST, DEPRECIATION

CHARTFIELD1

ChartField 1

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

See PeopleSoft Application Fundamentals 9.1 PeopleBook, Understanding PeopleSoft ChartField Configuration.

COST, DEPRECIATION

CHARTFIELD2

ChartField 2

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

See PeopleSoft Application Fundamentals 9.1 PeopleBook, Understanding PeopleSoft ChartField Configuration.

COST, DEPRECIATION

CHARTFIELD3

ChartField 3

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

See PeopleSoft Application Fundamentals 9.1 PeopleBook, Understanding PeopleSoft ChartField Configuration.

COST, DEPRECIATION

PROJECT_ID

Project

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

See PeopleSoft Application Fundamentals 9.1 PeopleBook, Understanding PeopleSoft ChartField Configuration.

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 PeopleSoft Asset Management 9.1 PeopleBook, Creating PeopleSoft Asset Management Accounting Entries, Accounting Entry Templates.

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 Trans Type, and Trans Code). See the Accounting Entries topic.

See PeopleSoft Asset Management 9.1 PeopleBook, Creating PeopleSoft Asset Management Accounting Entries, Accounting Entry Templates.

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

INTFC_TYPE

Interface Type, also called Load Type

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

Internal Use

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 Asset Management to drill back to source systems. You can add valid values to the translate table for your external systems, or you can use EXT. You can run Transaction Loader selectively for specific values of system source.

Internal Use

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.

Internal Use

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.

Internal Use

INTFC_STATUS

Interface Status

Used for internal processing. Default this field to 'DON'.

Internal Use

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

  The transaction has been consolidated into a different transaction and it will not be loaded.

• UNI

  The transaction has been unitized into a different transaction and it will not be loaded.

• HLD

  The transaction is on hold. This is used to prevent or delay the processing of an entry.

• INP

  The transaction is in process. This is the status while the application engine is working with the row.

Internal Use

Y NEW

ORIG_INTFC_ID

Original Interface ID

Used for internal processing. Do not populate.

Internal Use

ORIG_LINE_NUM

Original Interface Line Number

Used for internal processing. Do not populate.

Internal Use

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 fields in the BOOK table are 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 this switch is set to C, the category from the interface row is retained. If the switch is set to G, the group is retained. If the switch is set to B, both the category and the group are retained.

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 always override the values on this table if profile processing has been chosen.

Internal Use

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, 2007, but was added to the system on 5 June, 2007. The company wanted the add to hit the general ledger for period 5 (May). In this example the transaction date would be 15 April, 2007. The accounting date most likely would be 31 May, 2007.

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 May 31, 2009 as your transaction and accounting dates, the system will use June 1, 2009.

COST, DEPRECIATION, OPEN_TRANS

Y

ACCOUNTING_DT

Accounting Date

Denotes the date this transaction was accounted for. This date is 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 example.

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, you may need to modify the MODEL set of conventions or create new convention definitions that match the calendar or calendars you are 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 straight line, schedule, declining balance switching to straight line, and so on), 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 depreciation 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 with 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 field is numeric. 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 is always 0.

COST, DEPRECIATION

RETIRE_SW

Retirement Switch

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

COST

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 the depreciation 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 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 value 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 value 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 value 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 value 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.

Internal Use

MESSAGE_NBR

Message Number

Used for internal processing. Do not populate.

Internal Use

BUSINESS_UNIT_JV

Joint Venture Business Unit

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

Internal Use

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.

Internal Use

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_AMT2

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 rate is required for Japanese calculations 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

FV 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 Depreciation 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

ADJUST_CONVENTION

Adjust Convention

Adjustment transaction convention populated with values from the CONV_TBL table.

BOOK, COST

CAPVAL_VALUE

Capitalization Value

Internal Use. The Capitalization Threshold Validation process populates this field. The value is used by the system to validate whether the asset still meets the conditions to remain at the status in which it was originally catalogued when it was added. Adjusting the original cost can make an asset fall into a different bracket and, therefore, the asset needs to be recategorized to a different capitalization status.

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 line.

Internal use

Y

INTFC_LINE_NUM

Interface Line Number

The 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 line.

Internal use

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 the 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

Populates the key field of datetime stamp in many tables. Represents the date and time that this transaction was added to the system. During conversion, this field represents the period through which depreciation has been calculated.

Y

VOUCHER_ID

Voucher ID

Identifies the voucher associated with the financial transaction. This value is used in AP integration. This field can be used for PeopleSoft or non-PeopleSoft integrations. This field enables INTFC_FIN transactions to be easily queried by voucher. This value should be formatted if the transaction is voucher related.

Internal use ASSET_ACQ_DET

VOUCHER_LINE_NUM

Voucher Line Number

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

Internal use ASSET_ACQ_DET

DISTRIB_LINE_NUM

Distribution Line Number

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

Internal use ASSET_ACQ_DET

INTFC_TYPE

Interface Type, also called Load Type

Identifies the type of this transaction. The Transaction Loader will process this transaction based on this field. Valid values are listed in the translate table.

Internal use

Y

MC_DEFN_ID

Mass Change ID

Used for internal processing. Do not populate.

Internal use

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 Asset Management to drill back to source system. You can add valid values to the translate table for your external systems. You can run the 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. The Transaction Loader will only load approved transactions. Valid values are Y for approved and N for not approved.

Internal use

Y

INTFC_STATUS

Interface Status

Used for internal processing. The default for this field is DON.

Internal use

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 was successfully processed), CON (the transaction was consolidated into a different transaction and it will not be loaded), UNI (the transaction was unitized into a different transaction and it will not be loaded).

Internal use

Y default NEW

ORIG_INTFC_ID

Original Interface ID

Used for internal processing. Do not populate.

Internal use

ORIG_LINE_NUM

Original Interface Line Number

Used for internal processing. Do not populate.

Internal use

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 be populated by default from the profile tables rather than the load tables (INTFC...). The category in the cost table will also be populated by default from the profile tables. The profile_ID is identified in 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.

Internal use

Y (Set = N for CN1)

TRANS_IN_OUT

Transaction In/Out

Identifies 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 or recategorized from. The inside of the transaction adjusts the asset being transferred/recategorized to.

Internal use

PARENT_ID

Parent Asset ID

Identifies the parent of this asset. You can build Parent/Child relationships 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). The parent ID should always be a valid entry in the record Parent_Asset. If an entry does not exist in Parent_Asset for the parent ID, then the Transaction Loader will create one.

ASSET, PARENT_ASSET

PARENT_DESCR

Parent Asset Description

Describes 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

Indicates 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

Establishes the Asset Components structure.

ASSET

Y

ASSET_ASSIGNED_TO

Asset Assigned To

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

Provides a 30-character description of the asset.

ASSET

DESCRSHORT

Short Description

Provides a 10–character (short) description of the asset.

ASSET

ASSET_STATUS

Asset Status

Indicates 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, the asset can have no financial information or transactions, such as BOOK, COST, DEPRECIATION, RETIREMENT, OPEN_TRANS, and so on. However, it can have 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 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, identifies 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 Asset Management. Since Asset ID is only an internal key to this system, you should let Asset Management assign Asset IDs to your assets. Then, you can store the ID from the old system in this field.

ASSET

NEW_ASSET_SW

New Asset

Indicates if this asset was acquired new. Valid values are 'Y' or 'N'.

ASSET

Y

AVAIL_SW

Asset is Available

Indicates if this asset is 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

Indicates who should be contacted if the asset is available and if someone is interested in it.

ASSET

AVAIL_PHONE

Availability Phone

Indicates the phone number of the Availability Contact.

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 field is memo-only and is not used for any calculations.

ASSET

Y

FINANCING_CD

Financing Code

Identifies the user-defined financing code. Should be a valid value in the FINANCE_CD_TBL.

ASSET

ASSET_DTTM_STAMP

Asset Date/Time Stamp

Used for internal processing. Do not populate.

Internal use

PROFILE_ID

Asset Profile ID

Identifies the profile to be used for providing default book information for 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 in the PROFILE_DET_TBL.

ASSET

Y

ASSET_CLASS

Asset Class

Identifies the asset class of this asset. This field is another way to categorize your assets. This field must be a valid value in the ASSET_CLASS_TBL, which is maintained in the Establish Asset Processing menu online.

ASSET

CAP_NUM

Capital Acquisition Plan Number

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

ASSET

MFG_ID

Manufacturer ID

Identifies the Manufacturer ID of the asset.

ASSET

Y

MANUFACTURER

Manufacturer Name

Identifies the manufacturer of the asset.

ASSET

MODEL

Model

Identifies the model of the asset.

ASSET

PROD_VERSION

Product Version

Identifies the product version of the asset.

ASSET

SERIAL_ID

Serial ID

Identifies the serial number of the asset.

ASSET

PRODUCTION_DT

Production Date

Identifies the production date of the asset.

ASSET

PLANT

Manufacturing Plant

Identifies the plant that manufactured the asset.

ASSET

MANUFACTUR_CONTACT

Manufacturing Contact

Identifies the 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. with which this asset is associated. C.A.P. is a way of specifying asset budgets or appropriations.

ASSET

REPLACEMENT_COST

Replacement Cost

Identifies the 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 populate this field initially.

ASSET

LEASE_ASSET_ID

Lease Asset ID

For a noncapitalized asset that is associated with a lease, indicates 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

Identifies 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

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

ASSET

Y

COMPOSITE_SW

Composite Asset

Indicates whether the asset is a composite asset. Although similar to parent/child assets, composite assets are not virtual assets. A 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 before 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

Sequences 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, its value must be assigned correctly in the INTFC_PHY_A table. Therefore, the feeder system must set this field. For the Payables and Purchasing interface, this field is set by AMPS1000.

Note. The value of this field should be zero for ADD rows.

ASSET_ACQ_DET

ACQUISITION_DESCR

DESCR field for ACQ_DETAIL

Describes the acquisition detail for this transaction.

ASSET_ACQ_DET

CAPITALIZATION_SW

Capitalized

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

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

ASSET_ACQ_DET

Y

BUSINESS_UNIT_AP

AP Business Unit

Identifies the business unit from Accounts Payable that generated this transactions.

ASSET_ACQ_DET

TXN_CURRENCY_CD

Transaction Currency

Identifies the 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

Identifies the currency conversion rate divisor.

ASSET_ACQ_DET

Y

RATE_MULT

Rate Multiplier

Identifies the currency conversion rate multiplier.

ASSET_ACQ_DET

Y

RT_TYPE

Rate Type

Identifies the currency conversion rate type.

ASSET_ACQ_DET

Y

BUSINESS_UNIT_PO

PO Business Unit

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

ASSET_ACQ_DET

PO_ID

Purchase Order Number

Identifies the PO number from Purchasing that is associated with this transaction.

ASSET_ACQ_DET

PO_LINE_NBR

Purchase Order Line Number

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

ASSET_ACQ_DET

SCHED_NBR

Schedule Number

Identifies the schedule number from Purchasing that is associated with this transaction.

ASSET_ACQ_DET

PO_DIST_LINE_NUM

PO Distribution Line Number

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

ASSET_ACQ_DET

REFERENCE_ID

Reference Number

Identifies 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

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

ASSET_ACQ_DET

VENDOR_NAME

Vendor Name

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

ASSET_ACQ_DET

INVOICE_ID

Invoice Number

Identifies the invoice number of the invoice associated with this transaction.

ASSET_ACQ_DET

TXN_AMOUNT

Transaction Amount

Identifies the amount in the transaction currency.

ASSET_ACQ_DET

AMOUNT

Amount

Identifies the amount of this transaction. This amount will be capitalized if capitalization is requested. The Transaction Loader does not use this field for inserting cost. It uses the amount field on Acq Detail. The AMOUNT field should match the COST field on INTFC_FIN.

ASSET_ACQ_DET

Y

QUANTITY

Quantity

Identifies the quantity of this transaction. This quantity will be capitalized if capitalization was requested. The Transaction Loader does not use this field for inserting cost. It uses the quantity field on Acq Detail. The QUANTITY field should match the QUANTITY field on INTFC_FIN.

ASSET_ACQ_DET

SALETX_AMT

Sales Tax Distribution Amount

Identifies the amount of sales tax associated with this transaction.

ASSET_ACQ_DET

SALETX_AMT_BSE

Base Sales Tax Amount

Identifies the Sale Tax Amount in the transaction currency

ASSET_ACQ_DET

SALETX_CD

Sales Tax Code

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

ASSET_ACQ_DET

USETAX_AMT

Use Tax Distribution Amount

Identifies the amount of use tax associated with this transaction.

ASSET_ACQ_DET

USETAX_AMT_BSE

Base Use Tax Amount

Identifies the Use Tax Amount in the transaction currency.

ASSET_ACQ_DET

USETAX_CD

Use Tax Code

Identifies the code that represents the use taxing authority associated with this transaction.

ASSET_ACQ_DET

FREIGHT_AMT

Freight Amount

Identifies the amount of freight associated with this transaction.

ASSET_ACQ_DET

FREIGHT_AMT_BSE

Base Freight Amount

Identifies the Freight Amount in the transaction currency.

ASSET_ACQ_DET

BUSINESS_UNIT_RECV

Business Unit Receive

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

ASSET_ACQ_DET

RECEIVER_ID

Receiver ID

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

ASSET_ACQ_DET

RECV_LN_NBR

Receiver Line Number

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

ASSET_ACQ_DET

RECV_SHIP_SEQ_NBR

Receiver Shipping Sequence Number

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

ASSET_ACQ_DET

RECV_DIST_LINE_NUM

Receiver Distribution Line Number

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

ASSET_ACQ_DET

DISTRIB_SEQ_NUM

Distribution Sequence Number

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

ASSET_ACQ_DET

INV_ITEM_ID

Inventory Item ID

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

ASSET_ACQ_DET

OPERATING_UNIT

Operating Unit

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

ASSET_ACQ_DET

DEPTID

Department

Identifies 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

Identifies 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

Identifies a customizable ChartField. See the online ChartField customization topic for further discussion.

ASSET_ACQ_DET

Y

CLASS_FLD

Class Field

Identifies a customizable ChartField. See the online ChartField customization topic for further discussion.

ASSET_ACQ_DET

Y

PROGRAM_CODE

Program Code

Identifies a customizable ChartField. See the online ChartField customization topic for further discussion.

ASSET_ACQ_DET

Y

BUDGET_REF

Budget Reference

Identifies a customizable ChartField. See the online ChartField customization topic for further discussion.

ASSET_ACQ_DET

Y

AFFILIATE

Affiliate

Identifies a customizable ChartField. See the online ChartField customization topic for further discussion.

ASSET_ACQ_DET

Y

AFFILIATE_INTRA1

Fund Affiliate

Identifies a customizable ChartField. See the online ChartField customization topic for further discussion.

ASSET_ACQ_DET

Y

AFFILIATE_INTRA2

Operating Unit Affiliate

Identifies a customizable ChartField. See the online ChartField customization topic for further discussion.

ASSET_ACQ_DET

Y

CHARTFIELD1

ChartField 1

Identifies a customizable ChartField. See the online ChartField customization topic for further discussion.

ASSET_ACQ_DET

Y

CHARTFIELD2

ChartField 2

Identifies a customizable ChartField. See the online ChartField customization topic for further discussion.

ASSET_ACQ_DET

Y

CHARTFIELD3

ChartField 3

Identifies a customizable ChartField. See the online ChartField customization topic for further discussion.

ASSET_ACQ_DET

Y

PROJECT_ID

Project ID

Identifies 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

Identifies 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

Identifies 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

Identifies the business unit in Projects that generated this asset transaction. This value can also come from the Purchasing/Payables integration.

ASSET_ACQ_DET

MASTER_PROJECT

Master Project

Identifies the master project in Projects that generated this asset transaction.

ASSET_ACQ_DET

ACTIVITY_ID

Activity ID

Identifies the activity ID in Projects that generated this asset transaction. This value can also come from the Purchasing/Payables integration.

ASSET_ACQ_DET

RESOURCE_TYPE

Resource Type

Identifies the resource type in Projects that generated this asset transaction. This value can also come from the Purchasing/Payables integration.

ASSET_ACQ_DET

RESOURCE_SUB_CAT

Resource subcategory

Identifies the resource subcategory from Projects, Purchasing or Payables.

ASSET_ACQ_DET

ANALYSIS_TYPE

Resource Analysis type

Identifies the resource analysis type in Projects that generated this asset transaction. This value can also come from the Purchasing/Payables integration.

ASSET_ACQ_DET

RESOURCE_CATEGORY

Resource category

Identifies the resource category in Projects that generated this asset transaction. This value can also come from the Purchasing/Payables integration.

ASSET_ACQ_DET

CUSTODIAN_EFFDT

Asset Custodian Effective Date

Identifies 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. This field must be formatted with a valid date on an add transaction, whether or not the custodian is known. The Transaction Loader uses this value when inserting custodian entries. If it is null, no custodian entry is loaded.

ASSET_CUSTODIAN

Y

EFFSEQ

Effective Sequence

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

ASSET_CUSTODIAN

CUSTODIAN

Custodian

Identifies the name of the custodian of this asset.

ASSET_CUSTODIAN

EMPLID

Asset Custodian Employee ID

Identifies the employee ID of the custodian of this asset.

ASSET_CUSTODIAN

CUSTODIAN_DEPTID

Asset Custodian Department

Identifies the department of the custodian of this asset.

ASSET_CUSTODIAN

CUSTODIAN_PROJECT

Asset Custodian Project

Identifies the project associated with the custodian of this asset.

ASSET_CUSTODIAN

OFFSITE_SW

This Asset is 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. This field must 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

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 Non Recoverable 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 appears by default in the Work Location field on the Work Order Task. It contains three values: 'Asset' provides the Asset Location specified in the Asset definition; 'Shop' provides the Shops Location, and 'Other' leaves 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

CREW_ID

Crew

Used by Maintenance Management to represent the Crew definition associated with the asset.

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 property hierarchy of the asset.

ASSET_PROPERTY

BLDG_PROPERTY_ID

Building ID

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

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 property hierarchy of the asset.

ASSET_PROPERTY

PARCEL_NUMBER

Parcel Number

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

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 of the asset in square feet or square meters for the asset.

ASSET_PROPERTY

SPACE_UOM

Space Unit of Measure

Used by Real Estate Management. Used in conjunction with Total Area. Indicates square feet and square 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. Maximum number of people who can be assigned to the asset property.

ASSET_PROPERTY

OCCUPANCY_STATUS

Occupancy Status

Used by Real Estate Management. Indicates whether the asset is occupied or unoccupied.

ASSET_PROPERTY

OWNERSHIP_STATUS

Ownership Status

Used by Real Estate Management. Indicates whether the asset 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

DESCR_LONG

Description

Long description for informational purposes.

ASSET

AREA_ID

Area ID

Detailed asset location information used to identify areas.

ASSET, LOCATION

LINEAR_ASSET_SW

Linear Asset

Identifies linear assets and facilitates potential third-party integrations.

ASSET

NBR_OF_CPU

Number of CPU's

Used by ITAM. Identifies the number of CPUs in servers and desktop computers. A separate software license is needed for each CPU.

ASSET

CAP_THRSHLD_ID

Capitalization Threshold ID

Used by Asset Management to automatically capitalize assets based upon user-defined capitalization thresholds.

ASSET, PROFILE_TBL

IN_PHY_USE

In Physical Use

This flag is used by ITAM to process nonfinancial IT assets through the comparison process between discovery and asset repository. This designation is available via the Basic Add page and the Define Asset Operational Info page.

ASSET

CAPVAL_VALUE

Capitalization Value

This value is used to validate whether the asset still meets the conditions to remain in the status at which it was originally catalogued when it was added. Adjustment to the original cost can make an asset fall into a different bracket and, therefore, the asset needs to be recategorized to a different capitalization status.

VAT_SETID

Value Added Tax SetID

VAT SetID

VAT_USE_ID

Value Added Tax Use ID

VAT Use Type can be used to specify the ratio of taxable activity to nontaxable activity. The system uses the VAT Use Type and the VAT Apportionment to store the temporary recoverable VAT at purchase time.

BUSINESS_UNIT_VAT

VAT business unit

VAT business unit

CHARTFIELD_PR1_VAL

ChartField Priority 1 Value

VAT mixed apportionment is a mechanism that enables VAT recoverability to be determined based on either the VAT apportionment control business unit or one of the two priority ChartFields that you specify on the VAT Apportionment page and to which a transaction is posted. For each business unit, Priority 1 or Priority 2 ChartField value, you enter the percentage of activity that is taxable or exempt.

CHARTFIELD_PR2_VAL

ChartField Priority 2 Value

VAT mixed apportionment is a mechanism that enables recoverability to be determined based on either the VAT apportionment control business unit or one of the two priority ChartFields you specify on the VAT Apportionment page and to which a transaction is posted. For each business unit, Priority 1 or Priority 2 ChartField value, you enter the percentage of activity that is taxable or exempt.

VAT_RECOVERY_PCT

VAT Coefficient of Recoverability

This coefficient is used to calculate yearly adjustments or global adjustments for assets; it is made up of the product of reference coefficient of constraint, coefficient of taxation, and coefficient of admission. Those reference coefficients are the ones used to calculate the recoverable VAT amount at invoice time or import time. They can be modified over time based on well-identified events justifying reconsideration of status.

VAT_CONSTRAINT_PCT

VAT Coefficient of Constraint

This coefficient is the first component of the Recoverability formula made of the product the Coefficient of Constraint, Coefficient of Taxation, and Coefficient of Admission. This coefficient measures the proportion of a good or service use for purpose of taxable operations.

VAT_TAXATION_PCT

VAT Coefficient of Taxation

This coefficient is the second component of the Recoverability formula made of the product the Coefficient of Constraint, Coefficient of Taxation, and coefficient of Admission. This coefficient translates the fact that only VAT putting a strain on a good or service allows in turn to determine the recoverable VAT amount related to this good or service.

VAT_ADMISSION_ PCT

VAT Coefficient of Admission

This coefficient is the last component of the Recoverability formula made of the product the Coefficient of Constraint, Coefficient of Taxation, and coefficient of Admission. This coefficient of Admission takes into account the existence of exclusions or restrictions to the deductions of VAT. Restrictions and exclusions are set by tax authorities.

TAX_CD_VAT

VAT Code

VAT Code

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, 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 line.

Internal use

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 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 this transaction. Transaction Loader will process this transaction based on this field. Valid values are listed in the translate table.

Internal use

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 Asset Management to drill back to source system. You can add valid values to the translate table for your external systems. You can run Transaction Loader selectively for specific values of system source.

Internal use

Y

MC_DEFN_ID

Mass Change ID

Used for internal processing. Do not populate.

Internal use

APPROVAL_SW

Auto Approval Status

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

Internal use

Y

INTFC_STATUS

Interface Status

Used for internal processing. Do not populate.

Internal use

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 w successfully processed), 'CON' (the transaction was consolidated into a different transaction and it will not be loaded), 'UNI' (the transaction was unitized into a different transaction and it will not be loaded).

Internal use

Y enter NEW

ATTRIBUTE_EFFDT

Asset Attribute Effective Date

These fields relate to the Asset_Attributes record. This information is optional. 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 for as many (or as few) assets as you like. If you do not plan to track 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 value 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 value 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 it is a 50-byte character field because of database restrictions. Online, you can enter up to 32K of information into this field.

ASSET_COMMENTS

AGENCY_ID

Agency ID

These fields relate to the Asset_License record. This record is used to track the license or registration of an asset with a given agency or vendor. Examples are a vehicle registration with the state or a software registration with a vendor. This information is optional. 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 for as many (or as few) assets as you like. If you do not plan to track 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. This value should be valid value on the Agency_Tbl record.

ASSET_LICENSE

LICENSE_VENDOR_ID

Asset License Vendor ID

The vendor to which the asset is registered. This value is mutually exclusive with the agency ID. This value should appear in the VNDR_FS record.

ASSET_LICENSE

REGISTRATION_NO

Registration Number

The registration number for the asset.

ASSET_LICENSE

INSPECTION_SW

Inspection Required

Indicates if an inspection of the asset is 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 to whom 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 in 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 or trailer.

ASSET_LICENSE

ADDR_FIELD1

Address Field 1

An address field.

ASSET_LICENSE

ADDR_FIELD2

Address Field 2

An address field.

ASSET_LICENSE

ADDR_FIELD3

Address Field 3

An address field.

ASSET_LICENSE

COUNTY

County

The county in which the asset is registered.

ASSET_LICENSE

STATE

State

The state in which the asset is registered.

ASSET_LICENSE

POSTAL

Postal Code

The postal code in 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

Indicates if the vendor is within city limit.

ASSET_LICENSE

JURISDICTION

Jurisdiction

Identifies the municipal authority of which it is a part.

Can be used by property tax to identify a taxing authority.

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 information is optional. 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 for as many (or as few) assets as you like. If you do not plan to track 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 provided the warranty. This value should appear in 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 it is only 50 characters here. Online, you can enter up to 32K of information into this field.

ASSET_WARRANTY

AM_AST_UD_CHAR1

User Defined Char Field 1

User-defined field.

ASSET

AM_AST_UD_CHAR2

User Defined Char Field 2

User-defined field.

ASSET

AM_AST_UD_DATE1

User Defined Date Field 1

User-defined field.

ASSET

AM_AST_UD_NUM1

User Defined Number Field 1

User-defined field.

ASSET

AM_AST_UD_NUM2

User Defined Number Field 2

User-defined field.

ASSET

PROCESS_INSTANCE

Process Instance

Internal use.

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 *

ADP

Depreciation * Open Trans

FAD

Asset, Asset Acquisition Detail, Asset Custodian, Asset Location

NAD

Asset, Asset Acquisition Detail, 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 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. Adds cost information to an asset. Mainly used for joint venture and composite rollups.

Cost, Open Trans

ACQ

Insert Acquisition Detail

Inserts into Acquisition Detail.

Acquisition Detail

ADD

Asset Add

Asset add - Financial only. For details, see load type CN2.

Book, Cost, Depr, Open Trans

ADJ

Asset Cost Adjustment

Adjusts the cost of an existing asset.

Cost, Open Trans

ADP

Asset Depreciation

Inserts depreciation information created by the revaluation in mass programs.

Depreciation, Open Trans

ADQ

Adjust Cost and Acquisition Detail

Adjusts the cost and acquisition details of an existing asset.

Acquisition Detail, Cost, Open Trans

ARA

Add Retired Asset

Adds 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

Deletes an existing asset. Only assets that have not been used to generate any journals will be deleted.

Asset, Acquisition Detail, Asset Fair Value, 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

Updates the asset table only. Rarely used, except in physical inventory.

Asset, Component of Asset History

BKD

Book Deletion

Deletes a book for an asset or business unit. For example, you can use it to delete dummy books used for performing "what if" analyses.

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

BKS

Book Change

Makes any change to an asset book.

Book, Open Trans

BSD

Selective Book Delete

Deletes a book from a range of asset IDs. Similar to BKD.

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

CAP

Asset Capitalization

Adds a line of acquisition detail and capitalizes 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

Capitalizes 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

During conversion, converts 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, Component of Asset History, Parent Asset, Attribute, Comments, License, Warranty

CN2

Conversion of Subsequent Books

During conversion, converts any subsequent books. Inserts only into financial tables.

Book, Cost, Depr, Component of Asset History, Open Trans

FAD

Financial and Physical Add

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

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

IHI

Physical Inventory History Insert

Inserts asset history. Used by the Physical Inventory SQR (AMPI1000).

PI Asset History

IUI

InterUnit Transfer, In Side

Provides the IN side of an InterUnit Transfer. Valid values for ACTIVITY_SW are:

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 into the same department (ACTIVITY_SW = –1). The activity switch values for the two transactions then cancel each other, resulting in an active ChartField combination (ACTIVITY_SW = 0).

Asset, Book, Cost, Asset Fair Value, Open Trans, Component of Asset History

IUO

InterUnit Transfer, Out Side

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

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 into the same department (ACTIVITY_SW = -1). The activity switch values for the two transactions then cancel each other, resulting in an active ChartField combination (ACTIVITY_SW = 0).

Cost, Open Trans

LAD

Leased Asset Add

Adds leased assets.

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

NAD

Non-Financial Add

Adds an asset with only physical information.

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

OPT

Open Transaction Generator

Creates open transactions for a set of assets. Rarely used.

Open Trans

PHY

Physical Asset Change

Performs 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

Performs partial retirements.

Cost, Retirement, Open Trans, Asset

RAQ

Replace Acquisition Detail

Replaces acquisition details using AMIF1000.

Acquisition Detail

RCT

Asset Recategorization

Performs recategorizations.

Cost, Open Trans

REI

Asset Reinstatement

Performs reinstatements.

Cost, Retirement, Open Trans, Asset

RET

Asset Retirement

Performs full retirements.

Cost, Retirement, Open Trans, Asset

RNA

Non-Financial Retirements

Performs retirements of non-financial assets.

Asset, Asset Retirement

TRF

IntraUnit Transfer

Performs transfers within the same business unit. Valid values for ACTIVITY_SW are:

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 into the same department (ACTIVITY_SW = –1). The activity switch values for the two transactions then cancel each other, resulting in an active ChartField combination (ACTIVITY_SW = 0).

Cost, Open Trans