SETIDPYMNT_TERMS_CDEFFDTDefault Value: %date
NET_TRMS_SEQ_NBRNET_TRMS_EFF_VW(SQL View) |
Index Back |
|---|---|
Net Terms Effective View |
| SELECT a.setid , a.pymnt_terms_cd , b.effdt , c.net_trms_seq_nbr , c.basis_from_day , c.basis_to_day , c.net_trms_time_id , c.dsc_trms_avail_flg FROM ps_pymt_trms_hdr a , ps_pymt_trms_cntl b , PS_PYMT_TRMS_NET c WHERE b.setid = a.setid AND b.pymnt_terms_cd = a.pymnt_terms_cd AND b.eff_status = 'A' AND c.setid = b.setid AND c.pymnt_terms_cd = b.pymnt_terms_cd AND c.effdt = b.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 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 4 | NET_TRMS_SEQ_NBR |
Number(2,0) | SMALLINT NOT NULL | Net Terms Sequence Number |
| 5 | BASIS_FROM_DAY | Number(2,0) | SMALLINT NOT NULL | Basis From Day |
| 6 | BASIS_TO_DAY | Number(2,0) | SMALLINT NOT NULL | Basis To Day |
| 7 | NET_TRMS_TIME_ID | Character(3) | VARCHAR2(3) NOT NULL | Net Terms Timing ID |
| 8 | DSC_TRMS_AVAIL_FLG | Character(1) | VARCHAR2(1) NOT NULL | Discount Terms Available |