PROD_UPNCRES2VW(SQL View) |
Index Back |
---|---|
Customer Product by UPN & TypeCustomer Product by Customer UPN Type |
SELECT ' ' ,' ' ,' ' ,' ' ,' ' ,' ' ,' ' ,' ' ,' ' ,' ' ,' ' ,' ' ,' ' ,' ' FROM PS_INSTALLATION |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
2 | SETID_CUSTOMER | Character(5) | VARCHAR2(5) NOT NULL | Customer SetID |
3 | SOLD_TO_CUST_ID | Character(15) | VARCHAR2(15) NOT NULL | Sold To Customer |
4 | UPN_TYPE_CD | Character(4) | VARCHAR2(4) NOT NULL | Universal Product Number Format Type |
5 | UPN_ID | Character(20) | VARCHAR2(20) NOT NULL | Universal Product Number |
6 | PRODUCT_ID | Character(18) | VARCHAR2(18) NOT NULL | Product ID |
7 | UNIT_OF_MEASURE | Character(3) | VARCHAR2(3) NOT NULL |
Used on an approval rule set.
MHR=Muti Hourly PER=Percentage SQF=Square Footage |
8 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
9 | MODEL_NBR | Character(18) | VARCHAR2(18) NOT NULL | Model Number |
10 | CATALOG_NBR | Character(18) | VARCHAR2(18) NOT NULL | Catalog Number |
11 | TAX_PRODUCT_NBR | Character(18) | VARCHAR2(18) NOT NULL | Tax Product Number |
12 | PRODUCT_KIT_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Product Kit |
13 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive |
14 | INV_ITEM_ID | Character(18) | VARCHAR2(18) NOT NULL | Item ID |