CS_PO_PYMT_VW(SQL View) |
Index Back |
---|---|
po Payment Terms DetailUsed in Contract Management -- bind mapping to get the payment terms details for purchase orders |
SELECT A.BUSINESS_UNIT , A.PO_ID , A.PYMNT_TERMS_CD , B.DESCR FROM PS_PO_HDR 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.REC_GROUP_ID = 'FS_14' 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 |
2 | PO_ID | Character(10) | VARCHAR2(10) NOT NULL | Purchase Order |
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 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |