SETIDPYMNT_TERMS_CD2EFFDTDefault Value: %date
A=Active
I=Inactive
BI_IMMED_PYT_VW(SQL View) |
Index Back |
|---|---|
Immediate Payment Terms ViewImmediate Payment Terms View |
| SELECT A.SETID , A.PYMNT_TERMS_CD , A.EFFDT , A.EFF_STATUS , A.DESCR50 FROM PS_PAY_TRMS_TBL A , PS_PAY_TRMS_NET B , PS_PAY_TRMS_TIME C WHERE A.SETID = B.SETID AND %EffdtCheck(PAY_TRMS_TBL XX, A, %CurrentDateIn) AND A.EFF_STATUS = 'A' AND A.PS_SYSTEM = 'AR' AND A.PYMNT_TERMS_CD = B.PYMNT_TERMS_CD AND %EffdtCheck(PAY_TRMS_NET YY, B, %CurrentDateIn) AND B.SETID = C.SETID AND B.PAY_TRMS_TIME_ID = C.PAY_TRMS_TIME_ID AND C.MONTH_INCREMENT = 0 AND C.DAY_INCREMENT = 0 AND C.DAY_DUE = 0 AND C.DUE_DT IS NULL |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | PYMNT_TERMS_CD2 |
Character(5) | VARCHAR2(5) NOT NULL | Settlement Terms Code used in Vendor Rebate Agreement (For AR) |
| 3 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 4 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive |
| 5 | DESCR50 | Character(50) | VARCHAR2(50) NOT NULL | Description of length 50 |