EODC_FRMXRF_VW2 (SQL View)	Index Back
Document/Form Cross Ref View Document Form Cross Reference View used in the Related Document Grid on the Form Pages.

EODC_FRMXRF_VW2

(SQL View)

Document/Form Cross Ref View

Document Form Cross Reference View used in the Related Document Grid on the Form Pages.

SELECT DISTINCT SEQ_NBR , %Substring(SD_RECNAME,1,10) , EODC_DOC_KEY , BCNAME , EODC_DOC_RECHDR , LASTUPDOPRID , LASTUPDDTTM FROM PS_EODC_FORM_XREF

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number

2 FORM_TYPE Character(10) VARCHAR2(10) NOT NULL Form and Builder Field
ADV=Remittance Advice Only
CAV=Check with Separate Advice
CRA=Crystal Check w/Advice
CRW=Crystal Check
CSA=Check over Stub with Advice
CSO=Check over Stub with Overflow
EFA=EFT File with Advice
EFT=EFT File
SCA=Stub over Check with Advice
SCO=Stub over Check with Overflow

3 EODC_DOC_KEY Character(150) VARCHAR2(150) NOT NULL Document Key String

4 BCNAME Character(30) VARCHAR2(30) NOT NULL Business Component Name (see PSBCDEFN).

5 EODC_DOC_RECHDR Character(15) VARCHAR2(15) NOT NULL Document Header Record

6 LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

7 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SEQ_NBR	Number(15,0)	DECIMAL(15) NOT NULL	Sequence Number
2	FORM_TYPE	Character(10)	VARCHAR2(10) NOT NULL	Form and Builder Field ADV=Remittance Advice Only CAV=Check with Separate Advice CRA=Crystal Check w/Advice CRW=Crystal Check CSA=Check over Stub with Advice CSO=Check over Stub with Overflow EFA=EFT File with Advice EFT=EFT File SCA=Stub over Check with Advice SCO=Stub over Check with Overflow
3	EODC_DOC_KEY	Character(150)	VARCHAR2(150) NOT NULL	Document Key String
4	BCNAME	Character(30)	VARCHAR2(30) NOT NULL	Business Component Name (see PSBCDEFN).
5	EODC_DOC_RECHDR	Character(15)	VARCHAR2(15) NOT NULL	Document Header Record
6	LASTUPDOPRID	Character(30)	VARCHAR2(30) NOT NULL	Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
7	LASTUPDDTTM	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.