| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 2 |
IT_TIMESPAN_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Inventory Age
|
| 3 |
IT_TIMESPAN_SEQ |
Number(5,0) |
INTEGER NOT NULL |
Inventory Age Seq
|
| 4 |
IT_SUBTYPE |
Character(15) |
VARCHAR2(15) NOT NULL |
IT Subtype
|
| 5 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
|
| 6 |
RT_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.
|
| 7 |
QUANTITY |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Qty Interface
|
| 8 |
COST |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Total Cost
|
| 9 |
FMV |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Fair (Market) Value Amount
|
| 10 |
NET_BK_VALUE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Net Book Value
|
| 11 |
DTTM_STAMP |
DateTime(26) |
TIMESTAMP |
Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
|