PROD_NOTDOC_SRC

(SQL View)
 Index Back

Product Notes Documents Search

Search record for Product Notes Documents table.

SELECT DISTINCT STG.EIP_PROGRAM ,STG.EIP_CTL_ID ,ERR.FIELDNAME ,STG.SETID ,STG.PRODUCT_ID ,STG.SEQ_NUM ,STG.DOCUMENT_CD FROM PS_EO_EIP_CTL EO , PS_PROD_LOAD_ERR ERR , PS_PROD_NOTEDOC_MD STG WHERE EO.EIP_DTA_STATUS = '1' AND EO.EIP_PROGRAM = ERR.EIP_PROGRAM AND EO.EIP_CTL_ID = ERR.EIP_CTL_ID AND ERR.EIP_PROGRAM = STG.EIP_PROGRAM AND ERR.EIP_CTL_ID = STG.EIP_CTL_ID AND ERR.RECNAME = 'PROD_NOTEDOC_MD' AND STG.SETID = ERR.KEY_CHAR_25_01 AND STG.PRODUCT_ID = ERR.KEY_CHAR_25_02 AND STG.SEQ_NUM = ERR.KEY_NUM_01 AND STG.DOCUMENT_CD = ERR.KEY_CHAR_25_03

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EIP_PROGRAM Character(10) VARCHAR2(10) NOT NULL Enterprise Components EIP (enterprise integration point) program field
601=Consumer Sync
701=BOM Sync
801=Item Revision
901=Item Bus Unit Sync
902=Item Sync

Default Value: OM_EIP_PRD_VW.EIP_PROGRAM

Prompt Table: OM_EIP_PRD_VW

2 EIP_CTL_ID Character(25) VARCHAR2(25) NOT NULL Enterprise Components EIP (enterprise integration point) control field

Prompt Table: OM_EIP_PRD2_VW

3 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
4 SETID Character(5) VARCHAR2(5) NOT NULL SetID

Prompt Table: SP_SETID_NONVW

5 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID

Prompt Table: PROD_ITEM

6 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence

Default Value: 1

7 DOCUMENT_CD Character(4) VARCHAR2(4) NOT NULL Document Code
ACKN=Order Acknowledgment
ASN=Advance Shipping Notification
BOL=Bill of Lading
CACK=Order Change Acknowledgement
CREN=Buying Agreement Renewal
CSTS=Buying Agreement Status
INCC=Invoice Courtesy Copy
INVC=Invoice
INVN=Invoice Notification
PACK=Packing List
PICK=Picking Plan
PPRC=Product Price List
PRAD=Payment Remittance Advice
QUOT=Quotation
RMA=Return Material Authorization