APBU_PYT_EFF_VW

(SQL View)
 Index Back

AP Bus Unit Pymt Trms Xref Vw


SELECT A.BUSINESS_UNIT , B.PYMNT_TERMS_CD , C.EFFDT , B.SETID , B.PYMNT_TERMS_TYPE , B.DESCR , B.DESCRSHORT , C.PYMNT_TERMS_APPLIC , C.NBR_OF_TERMS FROM PS_BUS_UNIT_TBL_AP A , PS_PYMT_TRMS_HDR B , PS_PYMT_TRMS_CNTL C WHERE B.SETID = ( SELECT I.SETID FROM PS_SET_CNTRL_REC I WHERE I.SETCNTRLVALUE = A.BUSINESS_UNIT AND I.REC_GROUP_ID = 'FS_14' AND I.RECNAME = 'PYMT_TRMS_HDR') AND C.SETID = B.SETID AND C.PYMNT_TERMS_CD = B.PYMNT_TERMS_CD AND C.EFFDT = ( SELECT MAX(J.EFFDT) FROM PS_PYMT_TRMS_CNTL J WHERE J.SETID = C.SETID AND J.PYMNT_TERMS_CD = C.PYMNT_TERMS_CD AND J.EFFDT <= %CurrentDateIn AND J.EFF_STATUS = 'A') AND C.PYMNT_TERMS_APPLIC IN ('B','V')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 PYMNT_TERMS_CD Character(5) VARCHAR2(5) NOT NULL Specifies how the payment due date and discount due date are calculated. A payment terms code is associated with various business units bill-to customers vendors as well as sales orders purchase orders and vouchers.
3 EFFDT Date(10) DATE NOT NULL Effective Date

Default Value: %date

4 SETID Character(5) VARCHAR2(5) NOT NULL SetID
5 PYMNT_TERMS_TYPE Character(1) VARCHAR2(1) NOT NULL Payment Terms Type
M=Multi-Payment Terms
S=Single-Payment Terms
6 DESCR Character(30) VARCHAR2(30) NOT NULL Description
7 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
8 PYMNT_TERMS_APPLIC Character(1) VARCHAR2(1) NOT NULL Terms Applicability
A=All (Unrestricted)
C=Customer-Only Terms
V=Supplier-Only Terms

Default Value: V

9 NBR_OF_TERMS Number(2,0) SMALLINT NOT NULL Number of Terms