COUNT_INV_DLEVW

(SQL View)
 Index Back

Physical/Cycle Count Item


SELECT A.BUSINESS_UNIT , A.COUNTING_EVENT_ID , A.INV_ITEM_ID , A.STORAGE_AREA , A.STOR_LEVEL_1 , A.STOR_LEVEL_2 , A.STOR_LEVEL_3 , A.STOR_LEVEL_4 , A.CONTAINER_ID , A.STAGED_DATE , A.SERIAL_ID , A.INV_LOT_ID , A.UNIT_OF_MEASURE , B.LANGUAGE_CD , B.DESCR60 FROM PS_COUNT_INV A , PS_MASTER_ITM_LANG B , PS_SET_CNTRL_REC C WHERE A.BUSINESS_UNIT = C.SETCNTRLVALUE AND C.RECNAME = 'MASTER_ITEM_TBL' AND A.INV_ITEM_ID = B.INV_ITEM_ID AND C.SETID = B.SETID

  • Related Language Record for COUNT_INV_D_EVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Prompt Table: SP_BUIN_NONVW

    2 COUNTING_EVENT_ID Number(15,0) DECIMAL(15) NOT NULL Counting Event ID
    3 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID

    Prompt Table: BU_ITM_INV_VW

    4 STORAGE_AREA Character(5) VARCHAR2(5) NOT NULL Storage Area

    Prompt Table: STOR_AREA_VW2

    5 STOR_LEVEL_1 Character(4) VARCHAR2(4) NOT NULL Storage Level 1

    Prompt Table: STOR_LEV1_VW2

    6 STOR_LEVEL_2 Character(4) VARCHAR2(4) NOT NULL Storage Level 2

    Prompt Table: STOR_LEV2_VW2

    7 STOR_LEVEL_3 Character(4) VARCHAR2(4) NOT NULL Storage Level 3

    Prompt Table: STOR_LEV3_VW2

    8 STOR_LEVEL_4 Character(4) VARCHAR2(4) NOT NULL Storage Level 4

    Prompt Table: STOR_LEV4_VW2

    9 CONTAINER_ID Character(10) VARCHAR2(10) NOT NULL Container ID

    Prompt Table: CNTR_ID_INV

    10 STAGED_DATE Date(10) DATE NOT NULL Staged Date

    Prompt Table: STAGED_DT2IN_VW

    11 SERIAL_ID Character(20) VARCHAR2(20) NOT NULL Serial ID
    12 INV_LOT_ID Character(15) VARCHAR2(15) NOT NULL Lot ID

    Prompt Table: %EDITTABLE

    13 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
    MHR=Muti Hourly
    PER=Percentage
    SQF=Square Footage

    Prompt Table: INV_STCK_UOM_VW

    14 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    15 DESCR60 Character(60) VARCHAR2(60) NOT NULL Description