INIU_TRANPR_VW

(SQL View)
 Index Back

Pairs Intercompany attributes


SELECT S.BUSINESS_UNIT , D.BUSINESS_UNIT , S.BUSINESS_UNIT_GL , D.BUSINESS_UNIT_GL , A.BUSINESS_UNIT_BI , A.CUST_ID , D.SHIP_TO_CUST_ID , D.ADDRESS_SEQ_NUM , D.AUTO_PUTAWAY_FLAG , SDF.ALLOW_ADDR_OVRRIDE , A.INTERCOMPANY_FLG , A.IU_OWNERSHIP , '0' FROM PS_IU_INTER_PR_TR A , PS_IU_TRAN_MAP_TBL B , PS_BUS_UNIT_TBL_IN S , PS_BUS_UNIT_TBL_IN D , PS_DF_SETUP_INV SDF , PS_INSTALLATION_IN IIN , PS_INSTALLATION_FS IFS WHERE A.IU_FROM_GLBU = S.BUSINESS_UNIT_GL AND A.IU_TO_GLBU = D.BUSINESS_UNIT_GL AND S.BUSINESS_UNIT = SDF.BUSINESS_UNIT AND A.IU_TRAN_CD = B.IU_TRAN_CD AND B.DEFAULT_FLAG = 'Y' AND B.IU_SYS_TRAN_CD = 'CMIUT' AND IFS.IU_METHOD = 'P' AND IIN.IUNIT_VALUES IN ('1', '3')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SOURCE_BUS_UNIT Character(5) VARCHAR2(5) NOT NULL Source Bus Unit
2 DESTIN_BU Character(5) VARCHAR2(5) NOT NULL Destination Unit
3 SOURCE_GL_BU Character(5) VARCHAR2(5) NOT NULL Source GL Business Unit
4 DESTIN_GL_BU Character(5) VARCHAR2(5) NOT NULL Destination GL Business Unit
5 BUSINESS_UNIT_BI Character(5) VARCHAR2(5) NOT NULL Billing Business Unit
6 CUST_ID Character(15) VARCHAR2(15) NOT NULL Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.
7 SHIP_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Ship To Customer
8 ADDRESS_SEQ_NUM Number(5,0) INTEGER NOT NULL Address Sequence Number
9 AUTO_PUTAWAY_FLAG Character(1) VARCHAR2(1) NOT NULL Flag Items for Auto-Putaway
10 ALLOW_ADDR_OVRRIDE Character(1) VARCHAR2(1) NOT NULL Allow Address Override
11 INTERCOMPANY_FLG Character(1) VARCHAR2(1) NOT NULL /* GMG 02/1999 R-CJOHNS-0E8DU InterCompany transfer enhancement*/
12 IU_OWNERSHIP Character(1) VARCHAR2(1) NOT NULL Ownership Unit
D=Destination
S=Source
13 TRANSFER_CALC_TYPE Character(1) VARCHAR2(1) NOT NULL Holds information regarding when the transfer price is calculated.
0=Calculate Cost at Depletions
1=Transfer at Zero Cost