UPG_RO_PAP_AET(SQL Table) |
Index Back |
---|---|
Collaborative Selling UpgradeState 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. |