BUSINESS_UNITBUSINESS_UNIT_APVENDOR_IDIU_VNDR_VW(SQL View) |
Index Back |
|---|---|
InterUnit suppliersUsed as a prompt table for supplier id on GLBUand InterUnit Pairs, for interunit billing transactions |
| SELECT D.BUSINESS_UNIT_GL , %Substring(C.SETCNTRLVALUE,1,5) , C.SETID , A.VENDOR_ID FROM PS_VENDOR_ADDR A , PS_VENDOR B , PS_SET_CNTRL_REC C , PS_BUS_UNIT_TBL_AP D 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.VNDR_AFFILIATE = D.BUSINESS_UNIT_GL AND B.SETID = C.SETID AND C.RECNAME = 'VENDOR' AND D.BUSINESS_UNIT = C.SETCNTRLVALUE |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | 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 |