Loader Table INTFC_PHY_A

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. PeopleSoft recommends 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 non capitalized 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.

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 Lease Administration. Identifier for an asset property

ASSET_PROPERTY

PROPERTY_DESCR

Property Description

Used by Lease Administration. Description of asset property

ASSET_PROPERTY

PROPERTY_NM

Property Name

Used by Lease Administration. Name of the asset property.

ASSET_PROPERTY

PROPERTY_CLASS

Property Class

Used by Lease Administration. Indicator that the property is a SITE, BUILDING, FLOOR, AREA, or SPACE.

ASSET_PROPERTY

PROPERTY_SUBCLASS

Property Subclass

Used by Lease Administration. Subcategory of Property Class.

ASSET_PROPERTY

PARENT_PROPERTY_ID

Parent Property ID

Used by Lease Administration. Parent Asset of the property.

ASSET_PROPERTY

SITE_PROPERTY_ID

Site ID

Used by Lease Administration. Property ID of the SITE for the property hierarchy of the asset.

ASSET_PROPERTY

BLDG_PROPERTY_ID

Building ID

Used by Lease Administration. Property ID of the SITE for the property hierarchy of the asset.

ASSET_PROPERTY

FLOOR_PROPERTY_ID

Floor ID

Used by Lease Administration. Property ID of the BUILDING for the asset property hierarchy.

ASSET_PROPERTY

AREA_PROPERTY_ID

Area ID

Used by Lease Administration. Property ID of the BUILDING for the asset property hierarchy.

ASSET_PROPERTY

SPACE_PROPERTY_ID

Space ID

Used by Lease Administration. Property ID of the AREA for the property hierarchy of the asset.

ASSET_PROPERTY

PARCEL_NUMBER

Parcel Number

Used by Lease Administration. Property ID of the SPACE for the property hierarchy of the asset.

ASSET_PROPERTY

LOT

Lot Number

Used by Lease Administration. Used to record legal description from surveyors when recorded in Lots and Blocks.

ASSET_PROPERTY

BLOCK

Block Number

Used by Lease Administration. Used to record legal description from surveyors when recorded in Lots and Blocks.

ASSET_PROPERTY

TOTAL_AREA

Total Area

Used by Lease Administration. Total measurement of the asset in square feet or square meters for the asset.

ASSET_PROPERTY

SPACE_UOM

Space Unit of Measure

Used by Lease Administration. Used in conjunction with Total Area. Indicates square feet and square meters.

ASSET_PROPERTY

CURRENT_OCCUPANCY

Current Occupancy

Used by Lease Administration. Number of people currently occupying the asset property.

ASSET_PROPERTY

MAX_OCCUPANCY

Maximum Occupancy

Used by Lease Administration. Maximum number of people who can be assigned to the asset property.

ASSET_PROPERTY

OCCUPANCY_STATUS

Occupancy Status

Used by Lease Administration. Indicates whether the asset is occupied or unoccupied.

ASSET_PROPERTY

OWNERSHIP_STATUS

Ownership Status

Used by Lease Administration. Indicates whether the asset is owned or leased.

ASSET_PROPERTY

LEGAL_DESCR

Legal Description

Used by Lease Administration. 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 Lease Administration 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