APB_PY_S_NDS_VW (SQL View)	Index Back
APBU Pay Trms Simple/No Dsc Vw Maintenance Note: This SQL View is designed for specific use in AP Payment Terms processing; it returns AP Business Unit/Payment Terms code combinations for all Payment Terms codes with the following attributes: (1) Single-Payment Terms only; (2) No Split-Payment Terms; (3) No Discount Terms; and (4) Corresponding Net Due Date Timing Codes are simple 'N' option ("Basis Date Only") with Timing Day Increment Days only (i.e., no Month or Year increment factors defined).

APB_PY_S_NDS_VW

(SQL View)

APBU Pay Trms Simple/No Dsc Vw

Maintenance Note: This SQL View is designed for specific use in AP Payment Terms processing; it returns AP Business Unit/Payment Terms code combinations for all Payment Terms codes with the following attributes: (1) Single-Payment Terms only; (2) No Split-Payment Terms; (3) No Discount Terms; and (4) Corresponding Net Due Date Timing Codes are simple 'N' option ("Basis Date Only") with Timing Day Increment Days only (i.e., no Month or Year increment factors defined).

SELECT A.BUSINESS_UNIT , A.PYMNT_TERMS_CD , B.NET_TRMS_SEQ_NBR , B.BASIS_FROM_DAY , B.BASIS_TO_DAY , C.TMG_DAY_INCR_VAL FROM PS_APBU_PYT_EFF_VW A , PS_PYMT_TRMS_NET B , PS_PYTR_TM_DAYS_VW C WHERE A.PYMNT_TERMS_TYPE = 'S' AND A.NBR_OF_TERMS = 1 AND B.SETID = A.SETID AND B.PYMNT_TERMS_CD = A.PYMNT_TERMS_CD AND B.EFFDT = A.EFFDT AND B.DSC_TRMS_AVAIL_FLG = 'N' AND C.SETID = B.SETID AND C.PAY_TRMS_TIME_ID = B.NET_TRMS_TIME_ID

# 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 NET_TRMS_SEQ_NBR Number(2,0) SMALLINT NOT NULL Net Terms Sequence Number

4 BASIS_FROM_DAY Number(2,0) SMALLINT NOT NULL Basis From Day

5 BASIS_TO_DAY Number(2,0) SMALLINT NOT NULL Basis To Day

6 NET_DUE_ADD_DAYS Signed Number(4,0) DECIMAL(3) NOT NULL Net Due Date Days Increment

#	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	NET_TRMS_SEQ_NBR	Number(2,0)	SMALLINT NOT NULL	Net Terms Sequence Number
4	BASIS_FROM_DAY	Number(2,0)	SMALLINT NOT NULL	Basis From Day
5	BASIS_TO_DAY	Number(2,0)	SMALLINT NOT NULL	Basis To Day
6	NET_DUE_ADD_DAYS	Signed Number(4,0)	DECIMAL(3) NOT NULL	Net Due Date Days Increment