SETIDPYMNT_TERMS_CD2EFFDTDefault Value: %date
LANGUAGE_CDBI_IMMD_PYT_LVW(SQL View) |
Index Back |
|---|---|
Immediate Payment Terms ViewImmediate Payment Terms View |
| SELECT L.SETID , L.PYMNT_TERMS_CD , L.EFFDT , L.LANGUAGE_CD , L.DESCR50 FROM PS_PAY_TRMS_TBL A , PS_PAY_TRMS_NET B , PS_PAY_TRMS_TIME C , PS_PAY_TRMS_TBL_LG L WHERE A.SETID = L.SETID AND A.PYMNT_TERMS_CD = L.PYMNT_TERMS_CD AND A.EFFDT = L.EFFDT AND 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 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 5 | DESCR50 | Character(50) | VARCHAR2(50) NOT NULL | Description of length 50 |