SAC_VCHR_SRCH1(SQL View) |
Index Back |
---|---|
Search record for ext vouchersSearch record for outbound voucher run control. |
SELECT BUSINESS_UNIT , VOUCHER_ID FROM PS_VCHR_HDR_QV WHERE VCHR_BLD_STATUS = 'B' |
# | 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 |