PYCYCL_SBU_VW1(SQL View) |
Index Back |
---|---|
Supplier Reqs by BU Search Rec |
SELECT DISTINCT a.pay_cycle , a.pay_cycle_seq_num , a.business_unit , a.remit_vendor , b.vendor_name_short , b.name1 FROM PS_PYCYCL_DATA a , ps_vendor b WHERE a.pymnt_selct_status = 'R' AND b.setid=a.remit_setid AND b.vendor_id=a.remit_vendor |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | PAY_CYCLE | Character(6) | VARCHAR2(6) NOT NULL |
Pay Cycle
Prompt Table: PYCYCL_NORM_VW |
2 | PAY_CYCLE_SEQ_NUM | Number(6,0) | INTEGER NOT NULL | Pay Cycle Sequence Number |
3 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: SP_BU_AP_NONVW |
4 | REMIT_VENDOR | Character(10) | VARCHAR2(10) NOT NULL |
Remit Vendor
Prompt Table: VNDR_BU_VW |
5 | VENDOR_NAME_SHORT | Character(14) | VARCHAR2(14) NOT NULL |
Short Vendor Name
Prompt Table: VNDR_BU_VW |
6 | NAME1 | Character(40) | VARCHAR2(40) NOT NULL |
Name 1
Prompt Table: VNDR_BU_VW |