GS1_CLS2_INV_IT(SQL Table) |
Index Back |
---|---|
Classification2 |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
2 | INV_ITEM_ID | Character(18) | VARCHAR2(18) NOT NULL | Item ID |
3 | GS1_GDSN_INF_PROV | Character(35) | VARCHAR2(35) NOT NULL | GDSN Information Provider |
4 | GS1_GDSN_INPRF_GLN | Character(13) | VARCHAR2(13) NOT NULL | GDSN Information Provider GLN |
5 | COUNTRY | Character(3) | VARCHAR2(3) NOT NULL | Country |
6 | GS1_GBL_PRD_CLASS | Character(8) | VARCHAR2(8) NOT NULL | Global Product Classification |
7 | GS1_BRANDNAME | Character(35) | VARCHAR2(35) NOT NULL | Brand Name |
8 | GS1_ALT_ITM_NUM_TY | Character(20) | VARCHAR2(20) NOT NULL | Alternate Item Number Type |
9 | GS1_RETURNABL_PACK | Character(1) | VARCHAR2(1) NOT NULL |
Returnable Packaging
Y/N Table Edit Default Value: N |
10 | GS1_FDA_LIST_NUM | Character(7) | VARCHAR2(7) NOT NULL | FDA Listing Number |
11 | GS1_FDA_MKT_AUTH_T | Character(1) | VARCHAR2(1) NOT NULL | FDA MarketingAuthorizationType |
12 | GS1_FDA_MKT_AUTH_C | Character(6) | VARCHAR2(6) NOT NULL | FDA MarketingAuthorizationCode |
13 | GS1_FDA_PRD_CODE | Character(3) | VARCHAR2(3) NOT NULL | FDA Product Code |
14 | GS1_GMDN_CODE | Character(5) | VARCHAR2(5) NOT NULL | GMDN Code |
15 | GS1_MFG_DATE_CNTRL | Character(1) | VARCHAR2(1) NOT NULL |
Manufacturing Date Controlled
Y/N Table Edit Default Value: N |
16 | GS1_EXPIRE_DTE_CTL | Character(1) | VARCHAR2(1) NOT NULL |
Expiration Date Controlled
Y/N Table Edit Default Value: N |
17 | GS1_LBLED_SNGL_USE | Character(1) | VARCHAR2(1) NOT NULL |
Labeled Single Use
Y/N Table Edit Default Value: N |
18 | GS1_PACK_STERILE | Character(1) | VARCHAR2(1) NOT NULL |
Packaged Sterile
Y/N Table Edit Default Value: N |
19 | GS1_STRLIZ_BFR_USE | Character(1) | VARCHAR2(1) NOT NULL |
Sterilize Before Use
Y/N Table Edit Default Value: N |
20 | GS1_STRLIZ_METHOD | Character(20) | VARCHAR2(20) NOT NULL | Sterilization Method |
21 | GS1_CONTAIN_DEHP | Character(1) | VARCHAR2(1) NOT NULL |
Contains DEHP
Y/N Table Edit Default Value: N |