IU_FROM_GLBUBUSINESS_UNIT_APSETIDVENDOR_IDIU_VNDR_VW2(SQL View) |
Index Back |
|---|---|
InterUnit suppliersUsed as a prompt table for supplier id on GLBUand InterUnit Pairs, for interunit billing transactions |
| SELECT DISTINCT B.VNDR_AFFILIATE , %Substring(C.SETCNTRLVALUE,1,5) , C.SETID , A.VENDOR_ID FROM PS_VENDOR_ADDR A , PS_VENDOR B , PS_SET_CNTRL_REC C WHERE A.EFF_STATUS = 'A' AND A.SETID = B.SETID AND A.VENDOR_ID = B.VENDOR_ID AND A.ADDRESS_SEQ_NUM = B.PRIM_ADDR_SEQ_NUM AND B.VENDOR_STATUS = 'A' AND B.INTERUNIT_VNDR_FLG = 'Y' AND B.SETID = C.SETID AND C.RECNAME = 'VENDOR' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | IU_FROM_GLBU |
Character(5) | VARCHAR2(5) NOT NULL | From GL Business Unit |
| 2 | BUSINESS_UNIT_AP |
Character(5) | VARCHAR2(5) NOT NULL | AP Business Unit |
| 3 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 4 | VENDOR_ID |
Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |