GS1_CLS2_IT_EC(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  EIP_CTL_ID |
Character(25) | VARCHAR2(25) NOT NULL | Enterprise Components EIP (enterprise integration point) control field |
| 2 | SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW |
| 3 | INV_ITEM_ID |
Character(18) | VARCHAR2(18) NOT NULL |
Item ID
Prompt Table: MST_ITM_PRPT_VW |
| 4 | GS1_GDSN_INF_PROV | Character(35) | VARCHAR2(35) NOT NULL | GDSN Information Provider |
| 5 | GS1_GDSN_INPRF_GLN | Character(13) | VARCHAR2(13) NOT NULL | GDSN Information Provider GLN |
| 6 | COUNTRY | Character(3) | VARCHAR2(3) NOT NULL | Country |
| 7 | GS1_GBL_PRD_CLASS | Character(8) | VARCHAR2(8) NOT NULL | Global Product Classification |
| 8 | GS1_BRANDNAME | Character(35) | VARCHAR2(35) NOT NULL | Brand Name |
| 9 | GS1_ALT_ITM_NUM_TY | Character(20) | VARCHAR2(20) NOT NULL | Alternate Item Number Type |
| 10 | GS1_RETURNABL_PACK | Character(1) | VARCHAR2(1) NOT NULL |
Returnable Packaging
Y/N Table Edit Default Value: N |
| 11 | GS1_FDA_LIST_NUM | Character(7) | VARCHAR2(7) NOT NULL | FDA Listing Number |
| 12 | GS1_FDA_MKT_AUTH_T | Character(1) | VARCHAR2(1) NOT NULL | FDA MarketingAuthorizationType |
| 13 | GS1_FDA_MKT_AUTH_C | Character(6) | VARCHAR2(6) NOT NULL | FDA MarketingAuthorizationCode |
| 14 | GS1_FDA_PRD_CODE | Character(3) | VARCHAR2(3) NOT NULL | FDA Product Code |
| 15 | GS1_GMDN_CODE | Character(5) | VARCHAR2(5) NOT NULL | GMDN Code |
| 16 | GS1_MFG_DATE_CNTRL | Character(1) | VARCHAR2(1) NOT NULL |
Manufacturing Date Controlled
Y/N Table Edit Default Value: N |
| 17 | GS1_EXPIRE_DTE_CTL | Character(1) | VARCHAR2(1) NOT NULL |
Expiration Date Controlled
Y/N Table Edit Default Value: N |
| 18 | GS1_LBLED_SNGL_USE | Character(1) | VARCHAR2(1) NOT NULL |
Labeled Single Use
Y/N Table Edit Default Value: N |
| 19 | GS1_PACK_STERILE | Character(1) | VARCHAR2(1) NOT NULL |
Packaged Sterile
Y/N Table Edit Default Value: N |
| 20 | GS1_STRLIZ_BFR_USE | Character(1) | VARCHAR2(1) NOT NULL |
Sterilize Before Use
Y/N Table Edit Default Value: N |
| 21 | GS1_STRLIZ_METHOD | Character(20) | VARCHAR2(20) NOT NULL | Sterilization Method |
| 22 | GS1_CONTAIN_DEHP | Character(1) | VARCHAR2(1) NOT NULL |
Contains DEHP
Y/N Table Edit Default Value: N |
| 23 | AUDIT_ACTN | Character(1) | VARCHAR2(1) NOT NULL |
Audit Action Code for Application Messages. This tells the subscriber whether the row has been added, changed, or deleted.
A=Add C=Change Old (PPR Only) D=Delete K=Change - Old Values N=Change - New Values O=Change - Original Values Default Value: A |
| 24 | IN_PROCESS_FLG | Character(1) | VARCHAR2(1) NOT NULL | In process flag |