BUSINESS_UNITDefault Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
Prompt Table: SP_BU_AP_NONVW
VOUCHER_IDDefault Value: NEXT
M=Multi-Payment Terms
S=Single-Payment Terms
EMVCH_PYMTRM_VW(SQL View) |
Index Back |
|---|---|
Voucher Payment Term InfoVoucher payment term information |
| SELECT a.business_unit , a.voucher_id , a.pymnt_terms_cd , b.pymnt_terms_type , b.descr , b.descrshort FROM PS_EM_VCH_HDR_VW a , ps_pymt_trms_hdr b WHERE a.pymnt_terms_cd = b.pymnt_terms_cd AND b.setid = ( SELECT I.setid FROM PS_SET_CNTRL_REC I WHERE I.SETCNTRLVALUE = a.BUSINESS_UNIT AND I.RECNAME = 'PYMT_TRMS_HDR') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: SP_BU_AP_NONVW |
| 2 | VOUCHER_ID |
Character(8) | VARCHAR2(8) NOT NULL |
Voucher ID
Default Value: NEXT |
| 3 | 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. |
| 4 | PYMNT_TERMS_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Payment Terms Type
M=Multi-Payment Terms S=Single-Payment Terms |
| 5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 6 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |