| # |
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.
Prompt Table:
SP_SETID_NONVW
|
| 2 |
TAX_DEFN_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Tax Parameter Definition Types.
001=Service Sales and Use
002=Material Sales and Use
003=Labor Sales and Use
004=Expense Sales and Use
005=Case Sales and Use
Default Value: 003
|
| 3 |
SEQ_NBR |
Number(15,0) |
DECIMAL(15) NOT NULL |
Sequence Number
|
| 4 |
SERVICE_TYPE_CD |
Character(8) |
VARCHAR2(8) NOT NULL |
User-definable code to classify the type of service.
Prompt Table:
RF_SERVICE_TYPE
|
| 5 |
SERVICE_ID |
Character(20) |
VARCHAR2(20) NOT NULL |
Service ID
Prompt Table:
%EDITTABLE
|
| 6 |
INV_ITEM_GROUP |
Character(15) |
VARCHAR2(15) NOT NULL |
Item Group
Prompt Table:
INV_ITEM_GROUP
|
| 7 |
INV_ITEM_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Item ID
Prompt Table:
%EDITTABLE2
|
| 8 |
COST_CAT_CD |
Character(6) |
VARCHAR2(6) NOT NULL |
Code used to define cost categories.
Prompt Table:
RF_COST_CAT
|
| 9 |
EXP_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
This field is used to store the type of expense.
AIR=Airfare
ENT=Entertainment
FDB=Food - Breakfast
FDD=Food - Dinner
FDL=Food - Lunch
GAS=Gas
LOD=Lodging
MIL=Mileage
MIS=Miscellaneous
PAR=Parking
PHO=Phone
REN=Rental Car
TOL=Tolls
|
| 10 |
CASE_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Case Type
Prompt Table:
RC_CASETYPE_TBL
|
| 11 |
RC_SOURCE |
Character(5) |
VARCHAR2(5) NOT NULL |
Case Source
How this case origianated
Prompt Table:
RC_SOURCE_TBL
|
| 12 |
PRODUCT_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Product ID
Prompt Table:
PROD_ITEM
|
| 13 |
TAX_GROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
Duration Frequency Units, usually paired with the DURATION, to form a 2 part entry field - ie 12 Months.
Prompt Table:
RF_TAX_GROUP_VW
|
| 14 |
TAX_TRANS_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Transaction Type
1=Sale
2=Rental
3=Service
|
| 15 |
TAX_TRANS_SUB_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Transaction Sub Type
1=Property
2=Freight
3=Service
4=Rental or Lease
5=Expense
6=Misc
N=None
|
| 16 |
ROW_ADDED_DTTM |
DateTime(26) |
TIMESTAMP |
This is a datetime field for record creation.
|
| 17 |
ROW_ADDED_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
ID of user who added the row.
|
| 18 |
ROW_LASTMANT_DTTM |
DateTime(26) |
TIMESTAMP |
The date and time that the row was last updated.
|
| 19 |
ROW_LASTMANT_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
ID of user who last modified the row.
|
| 20 |
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.
|
| 21 |
SYNCDTTM |
DateTime(26) |
TIMESTAMP |
Synchronization Last Update Date Time
|