| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 ROLENAME |
Character(30) |
VARCHAR2(30) NOT NULL |
The name of a Role in the Role Definition Table (see PSROLEDEFN).
|
| 2 |
SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
Prompt Table:
SP_SETID_NONVW
|
| 3 |
CUST_GRP_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Customer Group Type
ACCT=Accounting
ALOC=Allocation Group
BO=Backorder/Reservations
CDT=Canceled Debt Reporting
CLMB=Claimback Contract
COLL=Collection
DD=Direct Debit
DRFT=Draft
FCST=Forecasting
FRT=Freight
PBIL=Pay/Bill Management
PRC=Pricing
PRUL=Pricing Arbitration Plan
RPT=Reporting
SCON=Buying Agreement
SSRC=Alternate Sources Of Supply
TAX=Tax
TRPT=Transportation
|
| 4 |
CUSTOMER_GROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
Customer Group
Prompt Table:
CUST_GROUP_TBL
Set Control Field: SETID
|
| 5 |
CUST_CHANNEL |
Character(15) |
VARCHAR2(15) NOT NULL |
Customer Channel
Prompt Table:
CHANNEL_VW
Set Control Field: SETID
|
| 6 |
CLASSIFICATION |
Character(10) |
VARCHAR2(10) NOT NULL |
Classification
Prompt Table:
PM_CLASSIFICATE
Set Control Field: SETID
|
| 7 |
PM_DIVISION |
Character(15) |
VARCHAR2(15) NOT NULL |
Division
Prompt Table:
PM_DIVISION
Set Control Field: SETID
|
| 8 |
PM_REGION |
Character(10) |
VARCHAR2(10) NOT NULL |
Region
Prompt Table:
CUST_REGION_VW
Set Control Field: SETID
|
| 9 |
PM_TERRITORY |
Character(15) |
VARCHAR2(15) NOT NULL |
Territory
Prompt Table:
PM_TERRITORY
Set Control Field: SETID
|
| 10 |
PRODUCT_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Product ID
Prompt Table:
PROD_ITEM
Set Control Field: SETID
|
| 11 |
PRODUCT_GROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
Product Group
Prompt Table:
PROD_GRP_WC_VW
Set Control Field: SETID
|
| 12 |
DATE_FROM |
Date(10) |
DATE |
Date From
|
| 13 |
DATE_TO |
Date(10) |
DATE |
Date To
|
| 14 |
LAST_PROC_DTTM |
DateTime(26) |
TIMESTAMP |
last processed datetime.
|
| 15 |
USER_COUNT |
Number(9,0) |
DECIMAL(9) NOT NULL |
Number of users assigned.
|
| 16 |
LAST_MAINT_DTTM |
DateTime(26) |
TIMESTAMP |
A system generated value that reflects the date and time a transaction was last modified
|
| 17 |
LAST_MAINT_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Last Maintained By Operator ID
|