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 | 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. |