IU_PR_ENTTYP_VW

(SQL View)
 Index Back

Valid IU Pairs Entry Types

ICE 637799000 - Yang Hsu, Added record IU_PR_ETYP_LNVW on Language Related Record.

SELECT A.FIELDVALUE , A.XLATSHORTNAME , A.XLATLONGNAME FROM 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')))

  • Related Language Record: IU_PR_ETYP_LNVW

    • # 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 XLATSHORTNAME Character(10) VARCHAR2(10) NOT NULL Translate Value Short Name
    3 XLATLONGNAME Character(30) VARCHAR2(30) NOT NULL Translate Long Name