Loader Table INTFC_FIN

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, PeopleSoft recommends 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. 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, 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, 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 , 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, 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, 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, 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, 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, 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, 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, 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, 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, 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, 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, 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, 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, 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 topic: 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.

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.

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.

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.