Oracle-specific object structure fields
IBM® Maximo® Asset Management has standard object structures that you can use in the integration with the Oracle E-Business Suite.
The value in the Pers (persistent) column indicates whether the field is persistent (value 1) or non‐persistent (0). Depending on that status, you can see the field in the Object Structures application.
Table 2 contains the following information about each new field:
| Column | Description |
|---|---|
| Table | Table name |
| Field | Field name |
| Title | Title |
| Remarks | Description or comments |
| Val | Default value |
| Type | Field type |
| Len | Length |
| Sc | Scale |
| Pers | Persistent |
| Reqd | Required |
| Same as Attribute | Same as attribute |
| Same as Object | Same as object |
| Table | Column | Title | Remarks | Val | Type | Len | Sc | Pers | Reqd | Same As Attribute | Same As Object |
|---|---|---|---|---|---|---|---|---|---|---|---|
|
COMPANIES |
OA_OLD_VNDSITECODE |
Old Vendor Site Code |
Used when vendor site code is changed in Oracle |
Not applicable |
ALN |
15 |
0 |
0 |
0 |
Not applicable |
Not applicable |
|
COMPANIES |
OA_PAYSITE_FLG |
Pay Site |
Pay site flag |
0 |
YORN |
Not applicable |
0 |
1 |
1 |
Not applicable |
Not applicable |
|
COMPANIES |
OA_PURCHSITE_FLG |
Purchasing Site |
Purchasing site flag |
0 |
YORN |
Not applicable |
0 |
1 |
1 |
Not applicable |
Not applicable |
|
CONTRACTLINE |
OA_CATEGORYID |
Category ID |
Oracle category ID |
Not applicable |
Integer |
Not applicable |
0 |
0 |
0 |
Not applicable |
Not applicable |
|
CONTRACTLINE |
OA_IFACEMESSAGE |
Interface Message |
A general message for Oracle interface transaction |
Not applicable |
ALN |
2000 |
0 |
0 |
0 |
Not applicable |
Not applicable |
|
CONTRACTLINE |
OA_IFACESTATUS |
Interface Status |
Oracle interface transaction status |
Not applicable |
ALN |
40 |
0 |
0 |
0 |
Not applicable |
Not applicable |
|
CONTRACTLINE |
OA_IFACETIMESTAMP |
Interface Timestamp |
The date and time the transaction completed or failed |
Not applicable |
Datetime |
Not applicable |
0 |
0 |
0 |
Not applicable |
Not applicable |
|
CONTRACTLINE |
OA_ITEM_ID |
Item ID |
Oracle item ID |
Not applicable |
Integer |
Not applicable |
0 |
0 |
0 |
Not applicable |
Not applicable |
|
CONTRACTLINE |
OA_STORELOC |
Inventory Org |
Oracle inventory organization |
Not applicable |
Not applicable |
Not applicable |
Not applicable |
1 |
0 |
LOCATION |
LOCATIONS |
|
INVBALANCES |
OA_LOC_SEGMENTS |
Locator Segments |
Oracle locator segments |
Not applicable |
ALN |
40 |
0 |
1 |
0 |
Not applicable |
Not applicable |
|
INVENTORY |
EXT_ACTIVE |
Item Active |
Is external item active |
1 |
YORN |
Not applicable |
0 |
1 |
1 |
Not applicable |
Not applicable |
|
INVENTORY |
OA_IFACEMESSAGE |
Interface Message |
A general message for Oracle interface transaction |
Not applicable |
ALN |
2000 |
0 |
0 |
0 |
Not applicable |
Not applicable |
|
INVENTORY |
OA_IFACESTATUS |
Interface Status |
Oracle interface transaction status |
Not applicable |
ALN |
40 |
0 |
0 |
0 |
Not applicable |
Not applicable |
|
INVENTORY |
OA_IFACETIMESTAMP |
Interface Timestamp |
The date and time the transaction completed or failed |
Not applicable |
Datetime |
Not applicable |
0 |
0 |
0 |
Not applicable |
Not applicable |
|
INVENTORY |
OA_IO_FLAG |
Internal Order Enabled |
Oracle internal order enabled flag |
0 |
YORN |
Not applicable |
0 |
1 |
1 |
Not applicable |
Not applicable |
|
INVENTORY |
OA_PURCH_FLAG |
Purchasing Enabled |
Oracle purchasing enabled flag |
1 |
YORN |
Not applicable |
0 |
1 |
1 |
Not applicable |
Not applicable |
|
INVENTORY |
OA_INV_ITEM_FLAG |
Oracle Inventory Item Flag |
Oracle inventory item flag |
1 |
YORN |
Not applicable |
0 |
0 |
0 |
Not applicable |
Not applicable |
|
INVENTORY |
OA_ITEMDESC |
Description |
Item description |
Not applicable |
Not applicable |
Not applicable |
Not applicable |
0 |
0 |
DESCRIPTION |
ITEM |
|
INVENTORY |
OA_LONGDESCRIPTION |
Not applicable |
Long description |
Not applicable |
Not applicable |
Not applicable |
Not applicable |
0 |
0 |
LDTEXT |
LONGDESCRIPTION |
|
INVENTORY |
OA_SERIAL_CTRL |
Not applicable |
Is item rotating item |
Not applicable |
Not applicable |
Not applicable |
Not applicable |
0 |
0 |
ROTATING |
ITEM |
|
INVENTORY |
OA_RCV_RTE_ID |
Not applicable |
Inspection required |
Not applicable |
Not applicable |
Not applicable |
Not applicable |
0 |
0 |
INSPECTION REQUIRED |
ITEM |
|
INVENTORY |
OA_SET_PROCESS_ID |
Set Process ID |
Oracle set process ID |
Not applicable |
Integer |
Not applicable |
0 |
0 |
0 |
Not applicable |
Not applicable |
|
INVOICE |
OA_GLCURNCY |
GL Currency |
Oracle GL currency |
Not applicable |
ALN |
15 |
0 |
0 |
0 |
Not applicable |
Not applicable |
|
INVOICE |
OA_GLCURNCYTYPE |
Currency Type |
Oracle GL currency type |
Not applicable |
ALN |
25 |
0 |
0 |
0 |
Not applicable |
Not applicable |
|
INVOICELINE |
OA_APLINETYPE |
Payables Line Type |
Oracle payables default line type |
Not applicable |
ALN |
25 |
0 |
0 |
0 |
Not applicable |
Not applicable |
|
INVOICELINE |
OA_CONTRACTLINENUM |
Contract Linenum |
Line number of each contract line |
Not applicable |
Not applicable |
Not applicable |
Not applicable |
0 |
0 |
CONTRACT LINENUM |
CONTRACTLINE |
|
INVOICELINE |
OA_IFACEMESSAGE |
Interface Message |
A general message for Oracle interface transaction |
Not applicable |
ALN |
2000 |
0 |
0 |
0 |
Not applicable |
Not applicable |
|
INVOICELINE |
OA_IFACESTATUS |
Interface Status |
Oracle interface transaction status |
Not applicable |
ALN |
40 |
0 |
0 |
0 |
Not applicable |
Not applicable |
|
INVOICELINE |
OA_IFACETIMESTAMP |
Interface Timestamp |
The date and time the transaction completed or failed |
Not applicable |
Datetime |
Not applicable |
0 |
0 |
0 |
Not applicable |
Not applicable |
|
INVOICELINE |
OA_OWNERSYSID |
PO Owner |
PO owner system ID |
Not applicable |
Not applicable |
Not applicable |
Not applicable |
0 |
0 |
OWNER1 SYSID |
MXCOLLAB |
|
INVOICELINE |
OA_POTYPE |
PO Type |
PO type |
Not applicable |
Not applicable |
Not applicable |
Not applicable |
0 |
0 |
POTYPE |
PO |
|
INVRESERVE |
OA_CHANGEBY |
Change By |
Change by |
Not applicable |
Not applicable |
Not applicable |
Not applicable |
0 |
0 |
PERSONID |
PERSON |
|
INVRESERVE |
OA_IFACEMESSAGE |
Interface Message |
A general message for Oracle interface transaction |
Not applicable |
ALN |
2000 |
0 |
0 |
0 |
Not applicable |
Not applicable |
|
INVRESERVE |
OA_IFACESTATUS |
Interface Status |
Oracle interface transaction status |
Not applicable |
ALN |
40 |
0 |
0 |
0 |
Not applicable |
Not applicable |
|
INVRESERVE |
OA_IFACETIMESTAMP |
Interface Timestamp |
The date and time the transaction completed or failed |
Not applicable |
Datetime |
Not applicable |
0 |
0 |
0 |
Not applicable |
Not applicable |
|
INVRESERVE |
OA_ISSUEUNIT |
Issue Unit |
Issue unit |
Not applicable |
Not applicable |
Not applicable |
Not applicable |
0 |
0 |
MEASURE UNITID |
MEASUREUNIT |
|
INVRESERVE |
OA_ITEM_ID |
Inventory Item ID |
Oracle inventory item ID |
Not applicable |
Integer |
Not applicable |
0 |
0 |
0 |
Not applicable |
Not applicable |
|
INVRESERVE |
OA_LOCATOR_ID |
Locator ID |
Oracle locator ID |
Not applicable |
Integer |
Not applicable |
0 |
0 |
0 |
Not applicable |
Not applicable |
|
INVRESERVE |
OA_ORDERUNIT |
Order Unit |
Order unit |
Not applicable |
Not applicable |
Not applicable |
Not applicable |
0 |
0 |
MEASURE UNITID |
MEASUREUNIT |
|
INVRESERVE |
OA_SUBINV_CODE |
Sub Inventory Code |
Oracle subinventory code |
Not applicable |
ALN |
10 |
0 |
0 |
0 |
Not applicable |
Not applicable |
|
ITEM |
OA_SET_OF_BKS_IDS |
Sets of Books |
All SET_OF_ BOOKS_IDs separated by # |
Not applicable |
ALN |
2000 |
0 |
0 |
0 |
Not applicable |
Not applicable |
|
ITEM |
OA_SET_PROCESS_ID |
Set Process ID |
Oracle Set Process ID |
Not applicable |
Integer |
Not applicable |
0 |
0 |
0 |
Not applicable |
Not applicable |
|
ITEM |
OA_IFACEMESSAGE |
Interface Message |
A general message for Oracle interface transaction |
Not applicable |
ALN |
2000 |
0 |
0 |
0 |
Not applicable |
Not applicable |
|
ITEM |
OA_IFACESTATUS |
Interface Status |
Oracle interface transaction status |
Not applicable |
ALN |
40 |
0 |
0 |
0 |
Not applicable |
Not applicable |
|
ITEM |
OA_IFACETIMESTAMP |
Interface Timestamp |
The date and time the transaction completed or failed |
Not applicable |
Datetime |
Not applicable |
0 |
0 |
0 |
Not applicable |
Not applicable |
|
ITEM |
OA_ITM_LOT_NUMBER |
Starting Lot Number |
Starting Lot Number |
Not applicable |
ALN |
30 |
0 |
0 |
0 |
Not applicable |
Not applicable |
|
ITEM |
OA_ITM_LOT_PREFIX |
Starting Lot Prefix |
Starting Lot Prefix |
Not applicable |
ALN |
30 |
0 |
0 |
0 |
Not applicable |
Not applicable |
|
MATRECTRANS |
OA_CATEGORYID |
Category ID |
Oracle category ID |
Not applicable |
Integer |
Not applicable |
0 |
0 |
0 |
Not applicable |
Not applicable |
|
MATRECTRANS |
OA_CONTRACTLINENUM |
Contract Linenum |
Line number of each contract line |
Not applicable |
Not applicable |
Not applicable |
Not applicable |
0 |
0 |
CONTRACT LINENUM |
CONTRACTLINE |
|
MATRECTRANS |
OA_CONTRACTNUM |
Contract Number |
Contract number |
Not applicable |
Not applicable |
Not applicable |
Not applicable |
0 |
0 |
CONTRACT NUM |
CONTRACT |
|
MATRECTRANS |
OA_IFACEMESSAGE |
Interface Message |
A general message for Oracle interface transaction |
Not applicable |
ALN |
2000 |
0 |
0 |
0 |
Not applicable |
Not applicable |
|
MATRECTRANS |
OA_IFACESTATUS |
Interface Status |
Oracle interface transaction status |
Not applicable |
ALN |
40 |
0 |
0 |
0 |
Not applicable |
Not applicable |
|
MATRECTRANS |
OA_IFACETIMESTAMP |
Interface Timestamp |
The date and time the transaction completed or failed |
Not applicable |
Datetime |
Not applicable |
0 |
0 |
0 |
Not applicable |
Not applicable |
|
MATRECTRANS |
OA_ITEM_ID |
Item ID |
Oracle item ID |
Not applicable |
Integer |
Not applicable |
0 |
0 |
0 |
Not applicable |
Not applicable |
|
MATRECTRANS |
OA_LOCATOR_ID |
Locator ID |
Oracle locator ID |
Not applicable |
Integer |
Not applicable |
0 |
0 |
0 |
Not applicable |
Not applicable |
|
MATRECTRANS |
OA_OWNERSYSID |
PO Owner |
PO owner system ID |
Not applicable |
Not applicable |
Not applicable |
Not applicable |
0 |
0 |
OWNER1 SYSID |
MXCOLLAB |
|
MATRECTRANS |
OA_POTYPE |
PO Type |
PO type |
Not applicable |
Not applicable |
Not applicable |
Not applicable |
0 |
0 |
POTYPE |
PO |
|
MATRECTRANS |
OA_REQUIREDDATE |
Required Date |
Required date to Oracle |
Not applicable |
Not applicable |
Not applicable |
Not applicable |
0 |
0 |
REQUIRED DATE |
PO |
|
MATRECTRANS |
OA_SHIPTO |
Ship To |
Oracle ship to location |
Not applicable |
Not applicable |
Not applicable |
Not applicable |
0 |
0 |
ADDRESS CODE |
ADDRESS |
|
MATRECTRANS |
OA_SUBINV_CODE |
Sub Inventory Code |
Oracle subinventory code |
Not applicable |
ALN |
10 |
0 |
0 |
0 |
Not applicable |
Not applicable |
|
MATRECTRANS |
OA_VENDOR |
Company |
Oracle vendor |
Not applicable |
Not applicable |
Not applicable |
Not applicable |
0 |
0 |
COMPANY |
COMPANIES |
|
MATUSETRANS |
OA_GLCURNCY |
GL Currency |
Oracle GL currency |
Not applicable |
ALN |
15 |
0 |
0 |
0 |
Not applicable |
Not applicable |
|
MATUSETRANS |
OA_JE_CATEGORY |
GL Category |
Oracle journal category |
Not applicable |
ALN |
25 |
0 |
0 |
0 |
Not applicable |
Not applicable |
|
PO |
OA_GLCURNCYTYPE |
Currency Type |
Oracle GL currency type |
Not applicable |
ALN |
25 |
0 |
0 |
0 |
Not applicable |
Not applicable |
|
PO |
OA_POAPI |
PO API |
Oracle PO API |
Not applicable |
Upper |
3 |
0 |
0 |
0 |
Not applicable |
Not applicable |
|
POLINE |
OA_CATEGORYID |
Category ID |
Oracle category ID |
Not applicable |
Integer |
Not applicable |
0 |
0 |
0 |
Not applicable |
Not applicable |
|
POLINE |
OA_CHARGEORG |
Charge Org |
Oracle Projects charge organization |
Not applicable |
ALN |
1 |
0 |
0 |
0 |
Not applicable |
Not applicable |
|
POLINE |
OA_DEST_TYPE_CODE |
Destination Type |
Oracle destination type code |
Not applicable |
ALN |
25 |
0 |
0 |
0 |
Not applicable |
Not applicable |
|
POLINE |
OA_EXPENDITEM |
Expenditure Item |
Oracle Projects expenditure item |
Not applicable |
ALN |
1 |
0 |
0 |
0 |
Not applicable |
Not applicable |
|
POLINE |
OA_IFACEMESSAGE |
Interface Message |
A general message for Oracle interface transaction |
Not applicable |
ALN |
2000 |
0 |
0 |
0 |
Not applicable |
Not applicable |
|
POLINE |
OA_IFACESTATUS |
Interface Status |
Oracle Interface transaction status |
Not applicable |
ALN |
40 |
0 |
0 |
0 |
Not applicable |
Not applicable |
|
POLINE |
OA_IFACETIMESTAMP |
Interface Timestamp |
The date and time the transaction completed or failed |
Not applicable |
Datetime |
Not applicable |
0 |
0 |
0 |
Not applicable |
Not applicable |
|
POLINE |
OA_ITEM_ID |
Item ID |
Oracle item ID |
Not applicable |
Integer |
Not applicable |
0 |
0 |
0 |
Not applicable |
Not applicable |
|
POLINE |
OA_RATELINE |
Rate Type PO Line |
Indicates if PO Line is of Rate Type |
Not applicable |
YORN |
1 |
0 |
1 |
0 |
Not applicable |
Not applicable |
|
PR |
OA_GLCURNCY |
GL Currency |
Oracle GL currency |
Not applicable |
ALN |
15 |
0 |
0 |
0 |
Not applicable |
Not applicable |
|
PR |
OA_GLCURNCYTYPE |
GL Currency Type |
GL currency type |
Not applicable |
ALN |
30 |
0 |
0 |
0 |
Not applicable |
Not applicable |
|
PR |
OA_USEPRNUM |
Use PR Number |
Use PR number flag |
0 |
YORN |
Not applicable |
0 |
0 |
1 |
Not applicable |
Not applicable |
|
PRLINE |
OA_CATEGORYID |
Category ID |
Oracle category ID |
Not applicable |
Integer |
Not applicable |
0 |
0 |
0 |
Not applicable |
Not applicable |
|
PRLINE |
OA_CHARGEORG |
Projects Charge Org |
Oracle Projects charge organization |
Not applicable |
ALN |
50 |
0 |
0 |
0 |
Not applicable |
Not applicable |
|
PRLINE |
OA_DEST_TYPE_CODE |
Destination Type |
Oracle destination type code |
Not applicable |
ALN |
25 |
0 |
0 |
0 |
Not applicable |
Not applicable |
|
PRLINE |
OA_EXPENDITEM |
Expenditure Item |
Oracle Projects expenditure item |
Not applicable |
ALN |
50 |
0 |
0 |
0 |
Not applicable |
Not applicable |
|
PRLINE |
OA_IFACEMESSAGE |
Interface Message |
A general message for Oracle interface transaction |
Not applicable |
ALN |
2000 |
0 |
0 |
0 |
Not applicable |
Not applicable |
|
PRLINE |
OA_IFACESTATUS |
Interface Status |
Oracle interface transaction status |
Not applicable |
ALN |
40 |
0 |
0 |
0 |
Not applicable |
Not applicable |
|
PRLINE |
OA_IFACETIMESTAMP |
Interface Timestamp |
The date and time the transaction completed or failed |
Not applicable |
Datetime |
Not applicable |
0 |
0 |
0 |
Not applicable |
Not applicable |
|
PRLINE |
OA_ITEMNUM |
Item Number |
Oracle item number |
Not applicable |
ALN |
30 |
0 |
0 |
0 |
Not applicable |
Not applicable |
|
PRLINE |
OA_ITEM_ID |
Item ID |
Oracle item ID |
Not applicable |
Integer |
Not applicable |
0 |
0 |
0 |
Not applicable |
Not applicable |
|
PRLINE |
OA_PROJECTID |
Project ID |
Oracle Projects ID |
Not applicable |
Integer |
Not applicable |
0 |
0 |
0 |
Not applicable |
Not applicable |
|
PRLINE |
OA_STORELOC |
Storeroom |
Oracle storeroom location |
Not applicable |
ALN |
12 |
0 |
0 |
0 |
Not applicable |
Not applicable |
|
PRLINE |
OA_TASKID |
Task ID |
Oracle task ID |
Not applicable |
Integer |
Not applicable |
0 |
0 |
0 |
Not applicable |
Not applicable |
|
PURCHVIEW |
OA_GLCURNCYTYPE |
Currency Type |
Oracle GL currency type |
Not applicable |
ALN |
25 |
0 |
0 |
0 |
Not applicable |
Not applicable |
|
PURCHVIEW |
OA_POAPI |
PO API |
Oracle PO API |
Not applicable |
Upper |
3 |
0 |
0 |
0 |
Not applicable |
Not applicable |