SETIDPYMNT_TERMS_CDDefault Value: %date
ORDENT_EPYTM_VW(SQL View) |
Index Back |
|---|---|
Early Payment Terms Disc ViewThis view provides the max early payment disc for each payment terms code. The early payment discount is used in determining the vat amount for an order. |
| SELECT PTT.SETID , PTT.PYMNT_TERMS_CD , PTN.BASIS_FROM_DAY , PTN.BASIS_TO_DAY , PTT.EFFDT , MAX(PTD.DSCNT_PCT) FROM PS_PAY_TRMS_TBL PTT , PS_PAY_TRMS_NET PTN , PS_PAY_TRMS_DSCNT PTD WHERE PTT.PS_SYSTEM = 'AR' AND PTT.SETID = PTN.SETID AND PTT.PYMNT_TERMS_CD = PTN.PYMNT_TERMS_CD AND PTT.EFFDT = PTN.EFFDT AND PTN.SETID = PTD.SETID AND PTN.PYMNT_TERMS_CD = PTD.PYMNT_TERMS_CD AND PTN.EFFDT = PTD.EFFDT AND PTN.BASIS_FROM_DAY = PTD.BASIS_FROM_DAY GROUP BY PTT.SETID, PTT.PYMNT_TERMS_CD, PTN.BASIS_FROM_DAY, PTN.BASIS_TO_DAY, PTT.EFFDT |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 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 | BASIS_FROM_DAY | Number(2,0) | SMALLINT NOT NULL | Basis From Day |
| 4 | BASIS_TO_DAY | Number(2,0) | SMALLINT NOT NULL | Basis To Day |
| 5 | EFFDT | Date(10) | DATE |
Effective Date
Default Value: %date |
| 6 | DSCNT_PCT | Number(7,3) | DECIMAL(6,3) NOT NULL | Discount Percentage |