This chapter describes the open interfaces in Oracle Property Manager.
This chapter covers the following topics:
You can use the space open interface to extract employee space assignment data and space definition data from vendors' applications, and import this data into Oracle Property Manager. You can also export data from Oracle Property Manager into vendors' applications.
Related Topics
Property Manager Open Interface Tables
Computer-Assisted Facilities Management, Oracle Property Manager User Guide
You can export location or space assignment information from Oracle Property Manager to computer-assisted design (CAD) or computer-assisted facilities management (CAFM) applications using the Export to CAD Interface concurrent program. For details, see Export to CAD Interface, Oracle Property Manager User Guide.
You can import employee space assignment entries or location records into Oracle Property Manager by using the Import from CAD concurrent program. After importing the space assignment or location information, you can create, update, or delete employee space assignments or modify location information. For details, see Import to CAD Interface, Oracle Property Manager User Guide.
Use the Purge Open Interface Tables concurrent program after you submit the Export to CAD Interface or Import from CAD concurrent program. This program purges records from the Property Manager open interface tables PN_SPACE_ASSIGN_ITF and PN_LOCATIONS_ITF.
For details on the Purge Interface Tables concurrent program, see Purge Interface Tables, Oracle Property Manager User Guide.
The integration between Oracle Property Manager and eAM enables eAM assets to correspond with locations defined in Oracle Property Manager. The information transferred from Oracle Property Manager are the three-level land or building hierarchies, and the associated Location codes within Oracle Property Manager. See Export Locations to Enterprise Asset Management, Oracle Property Manager User Guide.
Related Topics
Overview of eAM Property Manager, Oracle Enterprise Asset Management User’s Guide
The following sections list the columns in the Oracle Property Manager Open Interface tables and indicate which columns require values for importing and exporting information to and from Oracle Property Manager. For more information, see the Oracle eTechnical Reference Manual. See also: Table Definitions (Oracle Property Manager Technical Reference Manual).
Although columns are validated against columns in other tables, the tables have no foreign key relationships.
Oracle Property Manager includes the following interface tables:
The following sections describe the column names and requirements for the PN_LOCATIONS_ITF table.
Enter the name of the batch. The interface program looks for this column in the table to select the records that need to be processed.
| Variable | Description |
|---|---|
| Validation: | None |
| Destination: | None |
Specify the type of the entry being made.
| Variable | Description |
|---|---|
| Validation: | Value must be one of the following: A: Add (create a new row - used when adding a new location) R: Replace (replace the existing row value only if the column in the interface table is not null - used when changing only selected location data) U: Update (update the existing row value with the null or non-null interface table column value - used when changing all location data) |
| Destination: | None |
Internal identifier for the location, generated from an Oracle database sequence. This should be mapped or tagged to the vendor's own location identifier for reference and subsequent updates to the location record.
| Variable | Description |
|---|---|
| Validation: | If the ENTRY_TYPE is U or R, then the value you enter must be for an existing, valid location, present in PN_LOCATIONS.LOCATION_ID. If the ENTRY_TYPE is A, then the value must be unique and must not be present in PN_LOCATIONS.LOCATION_ID. |
| Destination: | PN_LOCATIONS.LOCATION_ID |
Specify the type of location, for example, building, floor, office, land, parcel, or section.
| Variable | Description |
|---|---|
| Validation: | The value must be a valid value present in the system defined lookup code, PN_LOCATION_TYPES. |
| Destination: | PN_LOCATIONS.LOCATION_TYPE_ LOOKUP_CODE |
Enter the location code. This is a system generated unique value for every location defined in Oracle Property Manager.
| Variable | Description |
|---|---|
| Validation: | If the ENTRY_TYPE is U or R, then the code you enter must be for an existing, valid location, present in PN_LOCATIONS.LOCATION_CODE. If the ENTRY_TYPE is A, then the code must be unique and must not be present in PN_LOCATIONS.LOCATION_CODE. |
| Destination: | PN_LOCATIONS.LOCATION_CODE |
Enter the name of the building or land.
| Variable | Description |
|---|---|
| Validation: | None |
| Destination: | PN_LOCATIONS.BUILDING |
Enter the name of the floor or parcel.
| Variable | Description |
|---|---|
| Validation: | None |
| Destination: | PN_LOCATIONS.FLOOR |
Enter the name of the office or section.
| Variable | Description |
|---|---|
| Validation: | None |
| Destination: | PN_LOCATIONS.OFFICE |
Enter the tenure of the location. Default to Leased.
| Variable | Description |
|---|---|
| Validation: | The value must be a valid one from the system defined lookup code PN_LEASED_OR_OWNED. The pre-seeded values are Leased, Managed, Mixed, and Owned. |
| Destination: | PN_LOCATIONS.LEASED_OR_OWNED |
Enter the address of the building or land.
| Variable | Description |
|---|---|
| Validation: | None |
| Destination: | PN_ADDRESSES.ADDRESS_LINE1 |
Enter the address of the building or land.
| Variable | Description |
|---|---|
| Validation: | None |
| Destination: | PN_ADDRESSES.ADDRESS_LINE2 |
Enter the address of the building or land.
| Variable | Description |
|---|---|
| Validation: | None |
| Destination: | PN_ADDRESSES.ADDRESS_LINE3 |
Enter the address of the building or land.
| Variable | Description |
|---|---|
| Validation: | None |
| Destination: | PN_ADDRESSES.ADDRESS_LINE4 |
Enter the county of the building or land.
| Variable | Description |
|---|---|
| Validation: | None |
| Destination: | PN_ADDRESSES.COUNTY |
Enter the city of the building or land.
| Variable | Description |
|---|---|
| Validation: | None |
| Destination: | PN_ADDRESSES.CITY |
Enter the state of the building or land.
| Variable | Description |
|---|---|
| Validation: | None |
| Destination: | PN_ADDRESSES.STATE |
Enter the province of the building or land.
| Variable | Description |
|---|---|
| Validation: | None |
| Destination: | PN_ADDRESSES.PROVINCE |
Enter the zip code of the building or land.
| Variable | Description |
|---|---|
| Validation: | None |
| Destination: | PN_ADDRESSES.ZIP_CODE |
Enter the country where the building or land is located.
| Variable | Description |
|---|---|
| Validation: | Must be populated only for land and buildings. The value must be a valid value in the system-defined lookup code, FND_TERRITORIES. |
| Destination: | PN_ADDRESSES.COUNTRY |
Used as a context value for the flexible address format descriptive flexfield.
| Variable | Description |
|---|---|
| Validation: | None |
| Destination: | PN_ADDRESSES.ADDRESS_STYLE |
Enter the maximum capacity of the location.
| Variable | Description |
|---|---|
| Validation: | The maximum capacity of a location must always be greater than or equal to its optimum capacity. This field must be populated only for Office and Section. This value rolls up for Buildings, Land, Floors, and Parcels, and therefore, cannot be entered for them. |
| Destination: | PN_LOCATIONS.MAX_CAPACITY |
Enter the optimum capacity of the location.
| Variable | Description |
|---|---|
| Validation: | The optimum capacity of a location must always be less than or equal to its maximum capacity. This field must be populated only for Office and Section. This value is rolled up for Buildings, Land, Floors, and Parcels, and therefore, cannot be entered for them. |
| Destination: | PN_LOCATIONS.OPTIMUM_CAPACITY |
Enter the rentable area of the location. The rentable area is captured in both IFMA and BOMA space measurement standards.
| Variable | Description |
|---|---|
| Validation: | The rentable area of a location must always be less than or equal to its gross area, and greater than or equal to its usable area. This field must be populated only for Office and Section. This value rolls up for Buildings, Land, Floors, and Parcels and therefore, must not be entered for them. |
| Destination: | PN_LOCATIONS.RENTABLE_AREA |
Enter the usable area of the location. The usable area is captured in both IFMA and BOMA space measurement standards.
| Variable | Description |
|---|---|
| Validation: | The usable area of a location must always be less than or equal to its rentable area and greater than or equal to its assignable area. This field must be populated only for Office and Section. This value is rolled up for Buildings, Land, Floors, and Parcels and therefore must not be entered for them. |
| Destination: | PN_LOCATIONS.USABLE_AREA |
Enter the cost center to which the location is allocated.
| Variable | Description |
|---|---|
| Validation: | None |
| Destination: | PN_LOCATIONS.ADDRESS_STYLE |
Enter the unit of measure code. Oracle seeded examples are SFT (square feet), SYD (square yards), and SMT (square meters).
| Variable | Description |
|---|---|
| Validation: | The value must be a valid value present in the system-defined lookup code, PN_UNITS_OF_MEASURE. |
| Destination: | PN_LOCATIONS.UOM_CODE |
Enter the ID of the parent location. In Property Manager, Building is the parent of Floor, and Floor is the parent of Office. Land, Parcel, and Section have a similar parent-child relationship. Also, Land and Buildings are considered children of Property. For example, the PARENT_LOCATION_ID of a floor will be that of the parent building.
| Variable | Description |
|---|---|
| Validation: | The PARENT_LOCATION_ID you enter must belong to a valid location, which is a parent of the current location, and must be present either in PN_LOCATIONS.LOCATION_ID or in PN_LOCATIONS_ITF.LOCATION_ID. |
| Destination: | PN_LOCATIONS.PARENT_LOCATION_ID |
An Oracle Standard Who column. Enter the last update date for this record. Property Manager uses this date for reference and audit purposes only.
| Variable | Description |
|---|---|
| Validation: | Must be in valid date format. Must be populated only if ENTRY_TYPE is U. Must be left null in all other cases. |
| Destination: | None |
This is an Oracle Standard Who column.
| Variable | Description |
|---|---|
| Validation: | When the start date is updated from the interface table, the import program validates for location overlaps, location gaps, and active tenancies dates. |
| Destination: | PN_LOCATIONS.ACTIVE_START_DATE |
This is an Oracle Standard Who column.
| Variable | Description |
|---|---|
| Validation: | When the end date is updated from the interface table, the import program validates for location overlaps, location gaps, and active tenancies dates. |
| Destination: | PN_LOCATIONS.ACTIVE_END_DATE |
This is an Oracle Standard Who column.
| Variable | Description |
|---|---|
| Validation: | This column must be left null. |
| Destination: | None |
This is an Oracle Standard Who column.
| Variable | Description |
|---|---|
| Validation: | This column must be left null. |
| Destination: | None |
This is an Oracle Standard Who column.
| Variable | Description |
|---|---|
| Validation: | This column must be left null. |
| Destination: | None |
Enter the descriptive flexfield category for the descriptive flexfield information you want to import.
| Variable | Description |
|---|---|
| Validation: | None |
| Destination: | PN_LOCATIONS.ATTRIBUTE_CATEGORY |
Enter descriptive flexfield information that you want to import. The structure of the information you enter in these columns ( data types, value sets) must match the structure of the descriptive flexfield segments you have defined for your properties and/or sites, or you will experience validation problems when you try to access the information in the location windows.
| Variable | Description |
|---|---|
| Validation: | None |
| Destination: | PN_LOCATIONS.ATTRIBUTE[1-15] |
Enter the descriptive flexfield category for the descriptive flexfield information you want to import for the location address.
| Variable | Description |
|---|---|
| Validation: | None |
| Destination: | PN_ADDRESSES.ATTRIBUTE_CATEGORY |
Enter descriptive flexfield information that you want to import for the location address. The structure of the information you enter in these columns (data types, value sets) must match the structure of the descriptive flexfield segments you have defined for your addresses, or you will experience validation problems when you try to access the information using the forms.
| Variable | Description |
|---|---|
| Validation: | None |
| Destination: | PN_ADDRESSES.ATTRIBUTE[1-5] |
A flag specifying if the record was transferred from Property Manager to a CAFM vendor.
| Variable | Description |
|---|---|
| Validation: | This column must be left null. |
| Destination: | None |
A flag specifying if the record was transferred from a CAFM vendor to Property Manager.
| Variable | Description |
|---|---|
| Validation: | This column must be left null. |
| Destination: | None |
Used by Property Manager Import/Export programs to indicate validation or other errors encountered while running the program, in conjunction with ERROR_CODE.
| Variable | Description |
|---|---|
| Validation: | This column must be left null. |
| Destination: | None |
Indicates a CAFM vendor or other source (such as a spreadsheet).
| Variable | Description |
|---|---|
| Validation: | The value must be a valid value present in the user defined lookup code, PN_SOURCE. |
| Destination: | PN_LOCATIONS.SOURCE |
Keeps track of the concurrent request during which this row was created or updated.
| Variable | Description |
|---|---|
| Validation: | This column must be left null. |
| Destination: | None |
Keeps track of information about the concurrent program that created or updated each row, in conjunction with the PROGRAM_ID.
| Variable | Description |
|---|---|
| Validation: | This column must be left null. |
| Destination: | None |
Keeps track of information about the concurrent program that created or updated each row, in conjunction with the PROGRAM_APPLICATION_ID.
| Variable | Description |
|---|---|
| Validation: | This column must be left null. |
| Destination: | None |
Stores the date on which the concurrent program created or updated the row.
| Variable | Description |
|---|---|
| Validation: | This column must be left null. |
| Destination: | None |
Used to track how the space is being utilized.
| Variable | Description |
|---|---|
| Validation: | The value must be a valid value present in the user defined lookup code, PN_SPACE_TYPE_LOOKUP_CODE. |
| Destination: | PN_LOCATIONS.SPACE_TYPE_LOOKUP_ CODE |
Enter the gross area of the location. Property Manager measures gross area only for Land and Buildings, as a part of IFMA Space Measurement Standard.
| Variable | Description |
|---|---|
| Validation: | Must be entered only if the location_type_lookup_code is LAND or BUILDING. Also, when populated, the Gross Area must always be greater than or equal to the rentable area. |
| Destination: | PN_LOCATIONS.GROSS_AREA |
Enter the assignable area of the location. The assignable area is captured only by IFMA Space Measurement Standard.
| Variable | Description |
|---|---|
| Validation: | The assignable area of a location must always be less than or equal to its usable area. This field must be populated only for Office and Section. This value rolls up for Buildings, Land, Floors, and Parcels and hence must not be entered for them. |
| Destination: | PN_LOCATIONS.ASSIGNABLE_AREA |
Used to categorize real estate (such as office building).
| Variable | Description |
|---|---|
| Validation: | Must be a valid value in PN_CLASS_TYPE |
| Destination: | PN_LOCATIONS.CLASS |
Indicates whether the location is active or inactive.
| Variable | Description |
|---|---|
| Validation: | Must be either A (active) or I (inactive). |
| Destination: | PN_LOCATIONS.STATUS |
Enter the suite information for an office.
| Variable | Description |
|---|---|
| Validation: | Must be populated only if LOCATION_Type_LOOKUP_CODE is office. The value must be a valid value present in the user defined lookup code, PN_SUITES. |
| Destination: | PN_LOCATIONS.SUITE |
Enter the common area of the location. The common area is captured only by IFMA Space Measurement Standard.
| Variable | Description |
|---|---|
| Validation: | The common area of a location must always be less than or equal to its usable area. This field must be populated only for Office and Section. This value rolls up for Buildings, Land, Floors, and Parcels, and therefore, must not be entered for them. |
| Destination: | PN_LOCATIONS.COMMON_AREA |
If the value is Y, then the office/section being defined is a common area and the COMMON_AREA field becomes mandatory. If the value is N, then the office/section being defined is not a common area and ASSIGNABLE_AREA field becomes mandatory. The default is N.
| Variable | Description |
|---|---|
| Validation: | None |
| Destination: | PN_LOCATIONS.COMMON_AREA_FLAG |
The following sections describe the column names and requirements for the PN_EMP_SPACE_ASSIGN_ITF table.
Enter the name of the batch. The interface program looks for this column in the table to select the records that need to be processed.
| Variable | Description |
|---|---|
| Validation: | None |
| Destination: | None |
Specify the type of the entry being made.
| Variable | Description |
|---|---|
| Validation: | The value must be one of the following: A: Add (Create a new row) U: Update (Modify an existing row) R: Replace (Replace an existing row) |
| Destination: | None |
Enter the cost center of the employee who is being assigned.
| Variable | Description |
|---|---|
| Validation: | The COST_CENTER_CODE you enter must be for an existing one present in COST_CENTER_CODE, defined in Oracle HR. |
| Destination: | PN_SPACE_ASSIGN_EMP.COST_CENTER_CODE |
Enter the Location ID of the location that is being assigned.
| Variable | Description |
|---|---|
| Validation: | The LOCATION_ID you enter must be for an existing, valid location, present in PN_LOCATIONS.LOCATION_ID. |
| Destination: | PN_SPACE_ASSIGN_EMP.LOCATION_ID. |
Enter the area assigned to the employee. Note that this value is not a percent of the location area.
| Variable | Description |
|---|---|
| Validation: | When the Automatic Space Assignment option is set to YES, the allocated area for the space is automatically calculated as USABLE_AREA/total number of space assignments to a location. If the Automatic Space Assignment option is set to NO, this column must be populated, and the assigned area must be less than or equal to the vacant area of the location. |
| Destination: | PN_SPACE_ASSIGN_EMP.ALLOCATED_AREA. |
The internal identifier for the assignment, generated from an Oracle database sequence. This should be mapped or tagged to the vendor's own space assignment identifier for reference and subsequent updates to the space assignment record.
| Variable | Description |
|---|---|
| Validation: | If the ENTRY_TYPE is U or R, then the value you enter must be for an existing, valid assignment, present in PN_SPACE_ASSIGN_EMP.SPACE_ASSIGNMENT_ID. If the ENTRY_TYPE is A, then the value must be unique and must not be present in PN_SPACE_ASSIGN_EMP.SPACE_ASSIGNMENT_ID. |
| Destination: | PN_SPACE_ASSIGN_EMP.SPACE_ASSIGNMENT_ID |
The unique identifier for the employee to whom the space is allocated.
| Variable | Description |
|---|---|
| Validation: | Must be a valid PERSON_ID in PER_PEOPLE_F. |
| Destination: | PN_SPACE_ASSIGN_EMP.PERSON_ID |
The cost center to which the space is charged.
| Variable | Description |
|---|---|
| Validation: | None |
| Destination: | PN_SPACE_ASSIGN_EMP.COST_CENTER_CODE |
An Oracle Standard Who column. Enter the last update date for this record. Property Manager uses this date for reference and audit purposes only.
| Variable | Description |
|---|---|
| Validation: | Must be in valid date format. Must be populated only if ENTRY_TYPE is U. Must be left null in all other cases. |
| Destination: | None |
This is an Oracle Standard Who column.
| Variable | Description |
|---|---|
| Validation: | This column must be left null. |
| Destination: | None |
This is an Oracle Standard Who column.
| Variable | Description |
|---|---|
| Validation: | This column must be left null. |
| Destination: | None |
This is an Oracle Standard Who column.
| Variable | Description |
|---|---|
| Validation: | This column must be left null. |
| Destination: | None |
This is an Oracle Standard Who column.
| Variable | Description |
|---|---|
| Validation: | This column must be left null. |
| Destination: | None |
Enter the descriptive flexfield category for the descriptive flexfield information you want to import.
| Variable | Description |
|---|---|
| Validation: | None |
| Destination: | PN_SPACE_ASSIGN_EMP.ATTRIBUTE_ CATEGORY |
Enter descriptive flexfield information that you want to import. The structure of the information you enter in these columns (data types, value sets) must match the structure of the descriptive flexfield segments you have defined for your locations and/or sites, or you will experience validation problems when you try to access the information in the location windows.
| Variable | Description |
|---|---|
| Validation: | None |
| Destination: | PN_SPACE_ASSIGN_EMP.ATTRIBUTE[1-15] |
A flag specifying if the record was transferred from Property Manager to a CAFM vendor.
| Variable | Description |
|---|---|
| Validation: | This column must be left null. |
| Destination: | None |
A flag specifying if the record was transferred from a CAFM vendor to Property Manager.
| Variable | Description |
|---|---|
| Validation: | This column must be left null. |
| Destination: | None |
This column is used by Property Manager Import/Export programs to indicate validation or other errors encountered while running the program.
| Variable | Description |
|---|---|
| Validation: | This column must be left null. |
| Destination: | None |
Indicates a CAFM vendor or other source (such as a spreadsheet).
| Variable | Description |
|---|---|
| Validation: | The value must be a valid value present in the user-defined lookup code, PN_SOURCE. |
| Destination: | PN_SPACE_ASSIGN_EMP.SOURCE |
Keeps track of the concurrent request during which this row was created or updated.
| Variable | Description |
|---|---|
| Validation: | This column must be left null. |
| Destination: | None |
Keeps track of the information about which concurrent program created or updated each row, in conjunction with the PROGRAM_ID.
| Variable | Description |
|---|---|
| Validation: | This column must be left null. |
| Destination: | None |
Keeps track of the information about which concurrent program created or updated each row, in conjunction with the PROGRAM_APPLICATION_ID.
| Variable | Description |
|---|---|
| Validation: | This column must be left null. |
| Destination: | None |
Stores the date on which the concurrent program created or updated the row.
| Variable | Description |
|---|---|
| Validation: | This column must be left null. |
| Destination: | None |
Enter the number of occupants occupying the space.
| Variable | Description |
|---|---|
| Validation: | None |
| Destination: | PN_SPACE_ASSIGN_EMP.UTILIZED |
Enter the from occupancy date for the entity.
| Variable | Description |
|---|---|
| Validation: | Must be in valid date format. |
| Destination: | PN_SPACE_ASSIGN_EMP.EMP_ASSIGN_START_DATE |
Enter the to occupancy date for the entity.
| Variable | Description |
|---|---|
| Validation: | Must be in valid date format. Must be later than or the same as the start date. |
| Destination: | PN_SPACE_ASSIGN_EMP.EMP_ASSIGN_END_ DATE |
The following sections describe the column names and requirements for the PN_VOL_HIST_BATCH_ITF table.
Volume history batch identifier.
| Variable | Description |
|---|---|
| Validation: | None |
| Destination: | None |
Batch name.
| Variable | Description |
|---|---|
| Validation: | None |
| Destination: | None |
Minimum reporting date for volume history batch.
| Variable | Description |
|---|---|
| Validation: | None |
| Destination: | None |
Maximum reporting date for volume history batch.
| Variable | Description |
|---|---|
| Validation: | None |
| Destination: | None |
Volume type of volume history batch that includes Actual, Forecasted, and Deduction.
| Variable | Description |
|---|---|
| Validation: | The only possible values are Actual, Forecasted, and Deduction. |
| Destination: | None |
Volume history batch status.
| Variable | Description |
|---|---|
| Validation: | None |
| Destination: | None |
An Oracle Standard Who column. Property Manager uses this date for reference and audit purposes only.
| Variable | Description |
|---|---|
| Validation: | None |
| Destination: | None |
An Oracle Standard Who column.
| Variable | Description |
|---|---|
| Validation: | None |
| Destination: | None |
An Oracle Standard Who column.
| Variable | Description |
|---|---|
| Validation: | None |
| Destination: | None |
An Oracle Standard Who column.
| Variable | Description |
|---|---|
| Validation: | None |
| Destination: | None |
An Oracle Standard Who column.
| Variable | Description |
|---|---|
| Validation: | None |
| Destination: | None |
The following sections describe the column names and requirements for the PN_VOL_HIST_LINES_ITF table.
Volume history batch identifier.
| Variable | Description |
|---|---|
| Validation: | None |
| Destination: | None |
Variable rent agreement identifier.
| Variable | Description |
|---|---|
| Validation: | Must be a valid VAR_RENT_ID in PN_VAR_RENTS_ALL table belonging to an existing variable rent term. |
| Destination: | None |
Line item identifier of the variable rent agreement.
| Variable | Description |
|---|---|
| Validation: | This must be a valid Line Item ID in PN_VAR_LINES_ALL for a Period ID defined for Variable Rent ID. |
| Destination: | If Volume Type is Actual or Forecasted: PN_VAR_VOL_HIST_ALL.LINE_ITEM_ID If Volume Type is Deduction: PN_VAR_DEDUCTIONS_ALL.LINE_ITEM_ID |
Reporting start date.
| Variable | Description |
|---|---|
| Validation: | Reporting Start Date should be equal to or greater than the Group Start Date in the PN_VAR_GRP_DATES_ALL table for a Variable Rent ID, Period ID, and Group Date ID. |
| Destination: | If Volume Type is Actual or Forecasted: PN_VAR_VOL_HIST_ALL.START_DATE If Volume Type is Deduction: PN_VAR_DEDUCTIONS_ALL.START_DATE |
Reporting end date.
| Variable | Description |
|---|---|
| Validation: | Reporting End Date should be equal to or greater than the Group End Date in the PN_VAR_GRP_DATES_ALL table for a Variable Rent ID and Period ID. |
| Destination: | If Volume Type is Actual or Forecasted: PN_VAR_VOL_HIST_ALL.END_DATE If Volume Type is Deduction: PN_VAR_DEDUCTIONS_ALL.END_DATE |
Volume history batch line amount.
| Variable | Description |
|---|---|
| Validation: | None |
| Destination: | If Volume Type is Actual: PN_VAR_VOL_HIST_ALL.ACTUAL_AMOUNT If Volume Type is Forecasted: PN_VAR_VOL_HIST_ALL.FORECASTED_ AMOUNT If Volume Type is Deduction: PN_VAR_DEDUCTIONS_ALL.DEDUCTION_ AMOUNT |
Volume history batch line deduction amount.
| Variable | Description |
|---|---|
| Validation: | None |
| Destination: | None |
Volume history batch line deduction type code.
| Variable | Description |
|---|---|
| Validation: | None |
| Destination: | None |
Volume history batch line status.
| Variable | Description |
|---|---|
| Validation: | None |
| Destination: | None |
Error log message for volume history batch line.
| Variable | Description |
|---|---|
| Validation: | None |
| Destination: | None |
Volume history batch line group date.
| Variable | Description |
|---|---|
| Validation: | None |
| Destination: | None |
An Oracle Standard Who column. Property Manager uses this date for reference and audit purposes only.
| Variable | Description |
|---|---|
| Validation: | None |
| Destination: | None |
An Oracle Standard Who column.
| Variable | Description |
|---|---|
| Validation: | None |
| Destination: | None |
An Oracle Standard Who column.
| Variable | Description |
|---|---|
| Validation: | None |
| Destination: | None |
An Oracle Standard Who column.
| Variable | Description |
|---|---|
| Validation: | None |
| Destination: | None |
An Oracle Standard Who column.
| Variable | Description |
|---|---|
| Validation: | None |
| Destination: | None |
The reporting date for the volume record.
| Variable | Description |
|---|---|
| Validation: | None |
| Destination: | If Volume Type is Actual or Forecasted: PN_VAR_VOL_HIST_ALL.REPORTING_DATE If Volume Type is Deduction: None |
The code specifying the status of the volume.
| Variable | Description |
|---|---|
| Validation: | Must be a valid volume history status as defined in the PN_BATCH_TRANS_STATUS lookup |
| Destination: | If Volume Type is Actual or Forecasted: PN_VAR_VOL_HIST_ALL.VOL_HIST_STATUS_CODE If Volume Type is Deduction: None |
The code specifying the report type of the volume.
| Variable | Description |
|---|---|
| Validation: | Must be a valid report type as defined in the PN_REPORT_TYPE lookup |
| Destination: | If Volume Type is Actual or Forecasted: PN_VAR_VOL_HIST_ALL.REPORT_TYPE_CODE If Volume Type is Deduction: None |
The identifier of the volume or deduction record.
| Variable | Description |
|---|---|
| Validation: | None (value is automatically generated) |
| Destination: | If Volume Type is Actual or Forecasted: PN_VAR_VOL_HIST_ALL.VOL_HIST_ID If Volume Type is Deduction: PN_VAR_DEDUCTIONS_ALL.DEDUCTION_ID |
The following sections describe the column names and requirements for the PN_REC_EXP_ITF table.
The internal identifier for the expense lines generated from an Oracle database sequence. It is populated by the extraction process and used to identify the expense line detail associated with the line of data.
| Variable | Description |
|---|---|
| Validation: | None |
| Destination: | None |
Enter the property identifier from the properties table associated with the information in this row. The Property ID or the Location ID field, or both, must be entered.
| Variable | Description |
|---|---|
| Validation: | The property type ID must validly exist in the PN_PROPERTIES table. |
| Destination: | PN_REC_EXP_LINE_DTL_ALL.PROPERTY_ID |
Enter the location identifier from the locations table associated with the information in this row. The Property ID or the Location ID field, or both. must be entered.
| Variable | Description |
|---|---|
| Validation: | The location ID must validly exist in the PN_LOCATIONS table. |
| Destination: | PN_REC_EXP_LINE_DTL_ALL.LOCATION_ID |
Enter the code of the Payment Term Purpose Type associated with the information in this row.
| Variable | Description |
|---|---|
| Validation: | This column cannot be null. The purpose type code has to exist in FND LOOKUPS for the lookup type of PN_PAYMENT_PURPOSE_TYPE. |
| Destination: | PN_REC_EXP_LINE_DTL_ALL.EXPENSE_TYPE_CODE |
Enter the Account Code Combination ID associated with the information in this row.
| Variable | Description |
|---|---|
| Validation: | This column cannot be null. The account code combination ID has to exist in the GL_CODE_COMBINATIONS table. |
| Destination: | PN_REC_EXP_LINE_DTL_ALL.EXPENSE_ACCOUNT_ID |
Enter the General Ledger account description. This user specified field is optional.
| Variable | Description |
|---|---|
| Validation: | None |
| Destination: | PN_REC_EXP_LINE_DTL_ALL.ACCOUNT_DESCRIPTION |
Enter the actual expense amount.
| Variable | Description |
|---|---|
| Validation: | This column cannot be null. |
| Destination: | PN_REC_EXP_LINE_DTL_ALL.BUDGETED_AMOUNT |
Enter the budgeted expense amount.
| Variable | Description |
|---|---|
| Validation: | None |
| Destination: | PN_REC_EXP_LINE_DTL_ALL.BUDGETED_AMOUNT |
Enter the currency code of the recovery expense.
| Variable | Description |
|---|---|
| Validation: | This column cannot be null. |
| Destination: | PN_REC_EXP_LINE_ALL.CURRENCY_CODE |
Enter the period start date to identify the beginning extraction period boundary.
| Variable | Description |
|---|---|
| Validation: | This column cannot be null. |
| Destination: | PN_REC_EXP_LINE_ALL.FROM_DATE |
Enter the period end date to identify the ending extraction period boundary.
| Variable | Description |
|---|---|
| Validation: | This column cannot be null |
| Destination: | PN_REC_EXP_LINE_ALL.TO_DATE |
This flag indicates if the record was transferred from the interface table to the recoveries module. Choose N (not transferred) for all new records. The system will set the flag to Y (transferred) if export was successful and to E (erroneous) if it ended with an error.
| Variable | Description |
|---|---|
| Validation: | This column cannot be null |
| Destination: | None |
This parameter is reserved for future use when expense line corrections are allowed during a re-extraction process.
| Variable | Description |
|---|---|
| Validation: | None |
| Destination: | None |
This is an Oracle standard who column.
| Variable | Description |
|---|---|
| Validation: | This column cannot be null. |
| Destination: | None. |
This is an Oracle standard who column.
| Variable | Description |
|---|---|
| Validation: | This column cannot be null. |
| Destination: | None. |
This is an Oracle standard who column.
| Variable | Description |
|---|---|
| Validation: | This column cannot be null. |
| Destination: | None. |
This is an Oracle standard who column.
| Variable | Description |
|---|---|
| Validation: | This column cannot be null. |
| Destination: | None. |
This is an Oracle standard who column.
| Variable | Description |
|---|---|
| Validation: | None. |
| Destination: | None. |
Enter the descriptive flexfield category of the descriptive flexfield information you want to import.
| Variable | Description |
|---|---|
| Validation: | None |
| Destination: | PN_REC_EXP_LINE_DTL_ALL.ATTRIBUTE_ CATEGORY |
Enter the descriptive flexfield information that you want to import. The structure of the information you enter in these columns, such as the datatypes and value sets, must match the structure of the descriptive flexfield segments defined for the properties or sites. If not, validation errors will occur when the information is accessed in the location windows.
| Variable | Description |
|---|---|
| Validation: | None |
| Destination: | PN_REC_EXP_LINE_DTL_ALL.ATTRIBUTE[1-15] |
Enter the ID of the operating unit identifier.
| Variable | Description |
|---|---|
| Validation: | None |
| Destination: | None |