OI_DOCTYP_VW

(SQL View)
 Index Back

Document Type

Primary record for Document Type

SELECT DT.SETID , DT.DOC_TYPE , DT.DESCR , DT.JRNL_CODE , JC.DESCR JRNL_DESCR , DT.JRNL_TYPE , JT.DESCR JRNL_TYPE_DESCR , DT.SEQ_RANGE_ID , SRD.DESCR SEQ_RANGE_DESCR , XLI1.DESCR SEQ_TYPE_DESC FROM PS_DOC_TYPE_TBL DT LEFT OUTER JOIN PS_JRNL_CODE_TBL JC ON DT.SETID=JC.SETID AND DT.JRNL_CODE=JC.JRNL_CODE AND DT.JRNL_TYPE=JC.JRNL_TYPE LEFT OUTER JOIN PS_JRNL_TYPE_TBL JT ON DT.SETID=JT.SETID AND DT.JRNL_TYPE=JT.JRNL_TYPE LEFT OUTER JOIN PS_SEQ_RANGE_DEFN SRD ON DT.SEQ_RANGE_ID=SRD.SEQ_RANGE_ID LEFT OUTER JOIN PS_OI_COMMON_VW XLI1 ON XLI1.CODESETNAME = DT.SEQ_TYPE AND XLI1.CODESETGROUPNAME ='SEQ_TYPE' UNION SELECT SETID , ' ' , 'Not Available' , 'NA' , '-' , '-' , '-' , '-' , '-' , '-' FROM PS_SETID_TBL UNION SELECT ' ' , ' ' , 'Not Available' , 'NA' , '-' , '-' , '-' , '-' , '-' , '-' FROM PS_INSTALLATION

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
2 DOC_TYPE Character(8) VARCHAR2(8) NOT NULL Specifies the business purpose of a financial transaction in countries that require all financial transactions to be tracked as "documents". A Document Type is associated with one and only one Journal Code.
3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
4 JRNL_CODE Character(8) VARCHAR2(8) NOT NULL Journal Code
5 JRNL_DESCR Character(30) VARCHAR2(30) NOT NULL Journal Description
6 JRNL_TYPE Character(2) VARCHAR2(2) NOT NULL Journal Type
7 JRNL_TYPE_DESCR Character(30) VARCHAR2(30) NOT NULL Journal type description
8 SEQ_RANGE_ID Character(2) VARCHAR2(2) NOT NULL Sequence Range
9 SEQ_RANGE_DESCR Character(60) VARCHAR2(60) NOT NULL CF Description
10 SEQ_TYPE_DESC Character(30) VARCHAR2(30) NOT NULL Commitment Control Amount Type description