UPG_SBJ_DTL_TBL

(SQL Table)
Index Back

Upgrade Setup Table

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

Default Value: OPR_DEF_TBL_FS.SETID

Prompt Table: SP_SETID_NONVW

2 UPG_CONVER_SUBJECT Character(30) VARCHAR2(30) NOT NULL Conversation Subject
3 UPG_BUSINESS_TRANS Character(2) VARCHAR2(2) NOT NULL Business Transaction
AR=Receivables
BI=Billing
CN=Contracts
DM=Deduction Management
IN=Inventory
OM=Order Management
4 EFFDT Date(10) DATE NOT NULL Effective Date

Default Value: %date

5 UPG_CONVER_SUB_TOP Character(30) VARCHAR2(30) NOT NULL Conversation Sub Topic

Prompt Table: UPG_SUB_TOP_TBL

6 UPG_CONVR_QUAL_CD Character(2) VARCHAR2(2) NOT NULL Conversation Qualifier Code
D=Document
DE=Deduction
I=Item
L=Lading
P=PO Number
PY=Payment ID
7 ROLENAME Character(30) VARCHAR2(30) NOT NULL The name of a Role in the Role Definition Table (see PSROLEDEFN).

Prompt Table: ROLEUSER_VW

8 UPG_LOGGED_IN Character(1) VARCHAR2(1) NOT NULL Logged In

Y/N Table Edit