SF1219_DTL_VW2

(SQL View)
Index Back

SF 1219 Lines View

This view displays the valid choices for the SF1219 Transaction Detail update component.

SELECT DISTINCT BUSINESS_UNIT_1 , VOUCHER_ID FROM PS_SF1219_DTL_TBL WHERE SF1219_SOURCE = 'AP'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT_1 Character(5) VARCHAR2(5) NOT NULL Non-Joint Venture BU
2 VOUCHER_ID Character(8) VARCHAR2(8) NOT NULL Voucher ID