STD_NOTE_DOC_VW (SQL View)	Index Back
Standard Note Document view This record stores the information as to which documents (Order Acknowledgments, Quotations, etc), standard note text should print on. This is a view for inquiry only. NO PEOPLECODE, NO DEFAULTS, NO PROMPTS.

STD_NOTE_DOC_VW

(SQL View)

Standard Note Document view

This record stores the information as to which documents (Order Acknowledgments, Quotations, etc), standard note text should print on. This is a view for inquiry only. NO PEOPLECODE, NO DEFAULTS, NO PROMPTS.

select setid, std_note_cd, effdt, document_cd from PS_STD_NOTE_DOC

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

2 STD_NOTE_CD Character(10) VARCHAR2(10) NOT NULL Standard Note Code

3 EFFDT Date(10) DATE NOT NULL Effective Date

4 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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
2	STD_NOTE_CD	Character(10)	VARCHAR2(10) NOT NULL	Standard Note Code
3	EFFDT	Date(10)	DATE NOT NULL	Effective Date
4	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