GS1_CLS2_INV_IT(SQL Table) |
Index Back |
|---|---|
Classification2 |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | Character(5) | VARCHAR2(5) NOT NULL | SetID | |
| 2 | 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 |