| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
This field is used to store the value of SetID on various setup tables.
|
| 2 |
AGREEMENT_CODE |
Character(30) |
VARCHAR2(30) NOT NULL |
This field represents the agreement code (name) for an agreement
|
| 3 |
AGR_RENEWAL_NUM |
Number(4,0) |
SMALLINT NOT NULL |
This field represents the agreement renewal number (agreements begin at a value of one and the number is incremented with every renewal)
|
| 4 |
AGREEMENT_LINE |
Character(10) |
VARCHAR2(10) NOT NULL |
This field records the value for the agreement line number
|
| 5 |
PRODUCT_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Product ID
Prompt Table:
%EDITTABLE
|
| 6 |
PURCHASE_OPTN |
Character(4) |
VARCHAR2(4) NOT NULL |
This field is used to represent the purchase option (used in agreement pricing)
FLAT=Flat Rate
PRPD=Prepaid Cases/Services
TM=Time & Material
Prompt Table:
%EDITTABLE5
|
| 7 |
PREPAID_QTY |
Number(6,0) |
INTEGER NOT NULL |
This field is used to store the Prepaid Quantity.
Prompt Table:
%EDITTABLE7
|
| 8 |
RATE_AMOUNT |
Number(11,4) |
DECIMAL(10,4) NOT NULL |
Rate Amount
|
| 9 |
PRPD_UNIT_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
This field is used to represent the prepaid unit type
CASE=Case
DAY=Day
HOUR=Hour
MON=Month
SO=Service Order
WEEK=Week
YEAR=Year
|
| 10 |
AG_LINE_PRICE |
Number(12,2) |
DECIMAL(11,2) NOT NULL |
Agreement Line Price (refers to base price)
|
| 11 |
AGR_UNIT_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
This field represents the agreement price unit type
CASE=Case
DAY=Day
HOUR=Hour
ITEM=Item
MON=Month
SO=Service Order
WEEK=Week
YEAR=Year
|
| 12 |
SVC_PURCH_OPT |
Character(4) |
VARCHAR2(4) NOT NULL |
This field is used to represent the transaction price purchase option
FLAT=Flat Rate
PRPD=Prepaid Services/Cases
TM=Time & Materials
|
| 13 |
AG_SVC_LINE_PRICE |
Number(12,2) |
DECIMAL(11,2) NOT NULL |
Transaction price for service on an agreement line
|
| 14 |
SVC_UNIT_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
This field is used to represent the transaction price unit type
CASE=Case
DAY=Day
HOUR=Hour
MON=Month
SO=Service Order
WEEK=Week
YEAR=Year
|
| 15 |
SERVICE_CTR |
Signed Number(10,2) |
DECIMAL(8,2) NOT NULL |
This field is used to represent the remaining quantity available for pre-paid services
|
| 16 |
BASE_PRICE |
Signed Number(18,5) |
DECIMAL(16,5) NOT NULL |
Base Price Field used in Agreement Line Record to store the Base Price of the Agreement Line
|
| 17 |
QUANTITY_USED |
Number(10,0) |
DECIMAL(10) NOT NULL |
Used to store the product quantity on an installed product.
|
| 18 |
NO_OF_TIME_UNIT |
Number(9,2) |
DECIMAL(8,2) NOT NULL |
Number of Time Units used in the Agreement Line
|
| 19 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
This field stores the Currency Code value.
|
| 20 |
PROD_PREPAID_QTY |
Number(6,0) |
INTEGER NOT NULL |
Product prepaid quantity - store product level prepaid on agreemnt line product grid.
|
| 21 |
PROD_PREPAID_UNIT |
Character(4) |
VARCHAR2(4) NOT NULL |
Prepaid unit for agreement line setup - product grid when agreement category is external no pricing.
CASE=Case
HOUR=Hour
SO=Service Order
|
| 22 |
PROD_REMAINING_QTY |
Number(9,2) |
DECIMAL(8,2) NOT NULL |
product remaining quantity on agreement setup page - product grid when agreement category is external no pricing.
|
| 23 |
ROW_ADDED_DTTM |
DateTime(26) |
TIMESTAMP |
This is a datetime field for record creation.
|
| 24 |
ROW_ADDED_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
ID of user who added the row.
|
| 25 |
ROW_LASTMANT_DTTM |
DateTime(26) |
TIMESTAMP |
The date and time that the row was last updated.
|
| 26 |
ROW_LASTMANT_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
ID of user who last modified the row.
|
| 27 |
SYNCID |
Number(10,0) |
DECIMAL(10) NOT NULL |
The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.
|
| 28 |
SYNCDTTM |
DateTime(26) |
TIMESTAMP |
Synchronization Last Update Date Time
|