UPG_RO_PAP_AET

(SQL Table)
Index Back

Collaborative Selling Upgrade

State record for Application Program UPG_RO: Upgrade script for Regions and products.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.
3 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID
4 APPL_TYPE Character(4) VARCHAR2(4) NOT NULL Application Type
APPL=Application Form
BRSC=Branch Script
URL=URL
5 NUM_ROWS_1 Number(10,0) DECIMAL(10) NOT NULL Number of Rows
6 NUM_ROWS_2 Number(10,0) DECIMAL(10) NOT NULL Number of Rows
7 INST_PROD_ID Character(20) VARCHAR2(20) NOT NULL This field is used to represent the installed product ID (key field)
8 CAPTURE_ID Character(20) VARCHAR2(20) NOT NULL Field use to store the capture ID in order capture.
9 UPG_ELEMENT_LEN Number(2,0) SMALLINT NOT NULL ELEMENT LENGTH
10 UPG_NDC_POS Number(3,0) SMALLINT NOT NULL Communication Minimum digits for National Destination Code.
11 UPG_NDC_LEN Number(3,0) SMALLINT NOT NULL Communication: National destination code length in the Phone number string.
12 UPG_LSP_POS Number(3,0) SMALLINT NOT NULL Communication: Local Significant part position in the Phone number string.
13 UPG_LSP_LEN Number(3,0) SMALLINT NOT NULL Communication: Local Significant part length in the Phone number string.