INIU_TRANTPL_VW

(SQL View)
 Index Back

NonPairs Intercompany attribs


SELECT DISTINCT ISBU.BUSINESS_UNIT , IDBU.BUSINESS_UNIT , GSBU.BUSINESS_UNIT , GDBU.BUSINESS_UNIT , ISBU.BASE_CURRENCY , IDBU.BASE_CURRENCY , GSBU.BUSINESS_UNIT_BI , GDBU.CUST_ID , IDBU.SHIP_TO_CUST_ID , IDBU.ADDRESS_SEQ_NUM , IDBU.AUTO_PUTAWAY_FLAG , ISDF.ALLOW_ADDR_OVRRIDE , A.INTERCOMPANY_FLG , A.IU_OWNERSHIP , A.IU_TYPE , '0' FROM PS_IU_TRAN_MAP_OPT A , PS_CM_ACCTG_GRP_D B , PS_IU_TRAN_MAP_TBL C , PS_BUS_UNIT_TBL_GL GDBU , PS_BUS_UNIT_TBL_GL GSBU , PS_BUS_UNIT_TBL_IN IDBU , PS_BUS_UNIT_TBL_IN ISBU , PS_DF_SETUP_INV ISDF , PS_INSTALLATION_FS IFS , PS_INSTALLATION_IN IIN WHERE A.IU_SYS_TRAN_CD = B.IU_SYS_TRAN_CD AND A.IU_SYS_TRAN_CD = C.IU_SYS_TRAN_CD AND A.IU_TRAN_CD = C.IU_TRAN_CD AND GDBU.BUSINESS_UNIT = IDBU.BUSINESS_UNIT_GL AND GSBU.BUSINESS_UNIT = ISBU.BUSINESS_UNIT_GL AND ISDF.BUSINESS_UNIT = ISBU.BUSINESS_UNIT AND ( (A.IU_TYPE = 'IE' AND GDBU.BUSINESS_UNIT <> GSBU.BUSINESS_UNIT AND IFS.IU_LEGAL_ENT_FLG = 'Y' AND GDBU.IU_LEGAL_ENT_BU <> GSBU.IU_LEGAL_ENT_BU ) OR (A.IU_TYPE = 'AE' AND GDBU.BUSINESS_UNIT <> GSBU.BUSINESS_UNIT AND IFS.IU_LEGAL_ENT_FLG = 'Y' AND GDBU.IU_LEGAL_ENT_BU = GSBU.IU_LEGAL_ENT_BU ) OR (A.IU_TYPE = 'AU' AND GDBU.BUSINESS_UNIT = GSBU.BUSINESS_UNIT ) OR (A.IU_TYPE = 'IU' AND GDBU.BUSINESS_UNIT <> GSBU.BUSINESS_UNIT AND IFS.IU_LEGAL_ENT_FLG = 'N' ) ) AND C.DEFAULT_FLAG = 'Y' AND B.TRANSACTION_GROUP IN ('031','035') AND IFS.IU_METHOD IN ('D','I') 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 SOURCE_CURR_CODE Character(3) VARCHAR2(3) NOT NULL Source Currency
6 TARGET_CURRENCY Character(3) VARCHAR2(3) NOT NULL Target Currency
7 BUSINESS_UNIT_BI Character(5) VARCHAR2(5) NOT NULL Billing Business Unit
8 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.
9 SHIP_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Ship To Customer
10 ADDRESS_SEQ_NUM Number(5,0) INTEGER NOT NULL Address Sequence Number
11 AUTO_PUTAWAY_FLAG Character(1) VARCHAR2(1) NOT NULL Flag Items for Auto-Putaway
12 ALLOW_ADDR_OVRRIDE Character(1) VARCHAR2(1) NOT NULL Allow Address Override
13 INTERCOMPANY_FLG Character(1) VARCHAR2(1) NOT NULL /* GMG 02/1999 R-CJOHNS-0E8DU InterCompany transfer enhancement*/
14 IU_OWNERSHIP Character(1) VARCHAR2(1) NOT NULL Ownership Unit
D=Destination
S=Source
15 IU_TYPE Character(2) VARCHAR2(2) NOT NULL Used for interunit bill options, to distinguish the different types of inter/intraunit entries.
AE=IntraEntity
AU=IntraUnit
IE=InterEntity
IU=InterUnit
16 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