SF1219_DTL_VW2(SQL View) |
Index Back |
---|---|
SF 1219 Lines ViewThis 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 |