GS1_CL_INIT_EVW(SQL View) |
Index Back |
|---|---|
Classification2 AttributesThis view is Used by the Batch Publish section of the AE Program IN_ITMLOAD to publish the Item Changes/Adds to other Nodes. |
| SELECT A.SETID ,A.INV_ITEM_ID ,A.GS1_GDSN_INF_PROV ,A.GS1_GDSN_INPRF_GLN ,A.COUNTRY ,A.GS1_GBL_PRD_CLASS ,A.GS1_BRANDNAME ,A.GS1_ALT_ITM_NUM_TY ,A.GS1_RETURNABL_PACK ,A.GS1_FDA_LIST_NUM ,A.GS1_FDA_MKT_AUTH_T ,A.GS1_FDA_MKT_AUTH_C ,A.GS1_FDA_PRD_CODE ,A.GS1_GMDN_CODE ,A.GS1_MFG_DATE_CNTRL ,A.GS1_EXPIRE_DTE_CTL , A.GS1_LBLED_SNGL_USE ,A.GS1_PACK_STERILE ,A.GS1_STRLIZ_BFR_USE ,A.GS1_STRLIZ_METHOD ,A.GS1_CONTAIN_DEHP , B.AUDIT_ACTN , B.IN_PROCESS_FLG , E.PROCESS_INSTANCE FROM PS_GS1_CLS2_INV_IT A , PS_GS1_CLS2_IT_EC B , PS_EO_EIP_CTL E , PS_MASTER_ITEM_TBL I WHERE A.SETID = B.SETID AND A.INV_ITEM_ID = B.INV_ITEM_ID AND E.EIP_CTL_ID = B.EIP_CTL_ID AND E.EIP_DTA_STATUS = '2' AND I.SETID = a.setid AND I.INV_ITEM_ID = A.INV_ITEM_ID AND I.ITM_STATUS_CURRENT IN ('1','2','3','4') |
| # | 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 |
| 22 | 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 |
| 23 | PROCESS_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Process Flag
A=Purge All S=Only purge items with at least |
| 24 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |