Loader Table INTFC_PHY_B
When used, INTFC_PHY_B fields are most commonly loaded at conversion. They are not currently interfaced from Purchasing, Payables, or Projects, but they could be with some customization.
Note: This table does not need to be inserted for conversion. However, if you insert any values into it, the ones marked Y are required.
|
Field Name |
Long Name |
Use and Processing Considerations |
Tables Updated |
Required for Conversion |
|---|---|---|---|---|
|
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. |
When converting a blank character field (a character field with a null value), you should assign it a value of a single space, regardless of the field length. For example, to convert a blank character field with a length of five characters, you should give it a value of one space, not five spaces. This conversion is particularly important for ChartFields.
When converting character fields, do not add any trailing spaces to the field value. For example, the value in Book should be CORP, notCORP .
When loading rows into any interface tables, the intfc_id, intfc_line_num, and dttm_stamp must be the same across all used loader tables (that is, INTFC_FIN, INTFC_PHY_A).