IU_PR_ETYP_LNVW

(SQL View)
 Index Back

Valid IU Pairs Entry Types


SELECT B.FIELDVALUE , B.LANGUAGE_CD , B.XLATSHORTNAME , B.XLATLONGNAME FROM PSXLATITEMLANG B , PSXLATITEM A WHERE A.FIELDNAME = 'IU_ENTRY_TYPE' AND %EffdtCheck(PSXLATITEM B, A, %CurrentDateIn) AND A.EFF_STATUS = 'A' AND (A.FIELDVALUE IN ('IUPY','IURC') OR ( A.FIELDVALUE IN ('IUEX','IURV') AND EXISTS ( SELECT 'X' FROM PS_IU_TRAN_MAP_TBL C WHERE C.IU_SYS_TRAN_CD = 'BIIVC')) OR ( A.FIELDVALUE IN ('IUCG','IUAP','IUCS','IUTR') AND EXISTS ( SELECT 'X' FROM PS_IU_TRAN_MAP_TBL D WHERE D.IU_SYS_TRAN_CD = 'CMIUT'))) AND A.FIELDNAME = B.FIELDNAME AND A.FIELDVALUE = B.FIELDVALUE AND A.EFFDT = B.EFFDT

  • Related Language Record for IU_PR_ENTTYP_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 IU_ENTRY_TYPE Character(4) VARCHAR2(4) NOT NULL Entry Type
    AEAP=IntraEntity Accrued Payable
    AECG=IntraEntity Cost of Goods
    AECS=IntraEntity Customer Shipments
    AEEX=IntraEntity Expense
    AEPY=IntraEntity Payable
    AERC=IntraEntity Receivable
    AERV=IntraEntity Revenue
    AETR=IntraEntity In Transit
    AUEX=IntraUnit Expense
    AUPY=IntraUnit Payable
    AURC=IntraUnit Receivable
    AURV=IntraUnit Revenue
    AUTR=IntraUnit In Transit
    IEAP=InterEntity Accrued Payable
    IECG=InterEntity Cost of Goods
    IECS=InterEntity Customer Shipments
    IEEX=InterEntity Expense
    IEPY=InterEntity Payable
    IERC=InterEntity Receivable
    IERV=InterEntity Revenue
    IETR=InterEntity In Transit
    IUAP=InterUnit Accrued Payable
    IUCG=InterUnit Cost of Goods
    IUCS=InterUnit Customer Shipments
    IUEX=InterUnit Expense
    IUPY=InterUnit Payable
    IURC=InterUnit Receivable
    IURV=InterUnit Revenue
    IUTR=InterUnit In Transit
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 XLATSHORTNAME Character(10) VARCHAR2(10) NOT NULL Translate Value Short Name
    4 XLATLONGNAME Character(30) VARCHAR2(30) NOT NULL Translate Long Name