COUNT_INV_D_EVW

(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 , A.INV_ITEM_ID , B.DESCR60 , B.LOT_CONTROL , B.SERIAL_CONTROL , E.STAGED_DATE_FLAG , A.QTY_COUNT , A.UNIT_MEASURE_COUNT , A.COUNT_STATUS , A.POSTING_ERROR_FLG , A.COUNT_DTTM , A.QTY_PCT_ERROR , A.NEED_TO_RECONCILE , A.QTY_DELTA_BASE , A.QTY_SYSTEM_BASE , A.INVENTORY_TAG_ID , A.CONFIG_CODE , A.EIP_CTL_ID , A.SYNCH_FLAG , A.EIP_TRANS_SRC , A.EIP_TRANS_SRC_REF , A.GROUP_ID_SEQ_NUM , D.MFG_ID , D.MFG_ITM_ID , B.SETID , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , 0 , 0 , 0 , 0 , 0 , 0 , 0 , 0 , 0 , 0 , 0 , 0 , %DateTimeNull , %DateTimeNull , %DateTimeNull , %DateTimeNull , ' ' , 0 , B.CFG_CODE_OPT , U.UNIT_OF_MEASURE , A.QTY_COUNT , A.COUNT_STATUS , LT.EXPIRATION_DATE FROM PS_COUNT_INV A LEFT OUTER JOIN PS_LOT_CONTROL_INV LT ON (A.BUSINESS_UNIT = LT.BUSINESS_UNIT AND A.INV_ITEM_ID = LT.INV_ITEM_ID AND A.INV_LOT_ID=LT.INV_LOT_ID) , PS_SP_BUIN_NONVW BU , PS_MASTER_ITEM_TBL B LEFT OUTER JOIN PS_ITEM_MFG D ON (D.SETID = B.SETID AND D.INV_ITEM_ID = B.INV_ITEM_ID AND D.PREFERRED_MFG = 'Y') LEFT OUTER JOIN PS_INV_ITEM_UOM U ON (U.SETID = B.SETID AND U.INV_ITEM_ID = B.INV_ITEM_ID AND U.DFLT_UOM_STOCK = 'Y') , PS_SET_CNTRL_REC C , PS_BU_ITEMS_INV E WHERE A.BUSINESS_UNIT = BU.BUSINESS_UNIT AND 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 AND A.BUSINESS_UNIT=E.BUSINESS_UNIT AND A.INV_ITEM_ID = E.INV_ITEM_ID

  • Related Language Record: COUNT_INV_DLEVW

    • # 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 ALT_ITEM_ID Character(50) VARCHAR2(50) NOT NULL 05/26/11
    15 DESCR60 Character(60) VARCHAR2(60) NOT NULL Description
    16 LOT_CONTROL Character(1) VARCHAR2(1) NOT NULL Lot Control
    N=N
    Y=Y

    Y/N Table Edit

    17 SERIAL_CONTROL Character(1) VARCHAR2(1) NOT NULL Serial Control
    N=N
    Y=Y

    Y/N Table Edit

    18 STAGED_DATE_FLAG Character(1) VARCHAR2(1) NOT NULL Staged Date Control
    N=Staged Date Tracking OFF
    Y=Staged Date Tracking ON
    19 QTY_COUNT Signed Number(17,4) DECIMAL(15,4) NOT NULL Count Quantity
    20 UNIT_MEASURE_COUNT Character(3) VARCHAR2(3) NOT NULL Unit of Measure

    Prompt Table: INV_STCK_UOM_VW

    21 COUNT_STATUS Character(1) VARCHAR2(1) NOT NULL Count Item Status
    1=New
    2=Counting
    3=Quantity Entered - Hold
    4=Ready to Update Stock Quantity
    5=Stock Quantity Updated
    6=Canceled
    22 POSTING_ERROR_FLG Character(2) VARCHAR2(2) NOT NULL Posting Error Flag
    1=No Average Cost
    11=No Auto-Add of New Container
    13=Standard Qty fail in a whole#
    14=Whole # required for Count Qty
    15=Storage Qty fail in a whole#
    16=From/To UOM Rate must whole#
    17=No Standard Cost
    2=No Lot Control Record
    3=Duplicate Serial Item found
    4=Negative Quantity
    5=Missing UOM Conversion Rate
    6=Serial ID - multiple locations
    7=Container - multiple locations
    8=Wrong Item - Single Item Cntr
    9=Incomplete Item Definition
    D=Duplicate Fix Picking Location
    E=Fix Picking Location UOM Error
    X=In Process
    23 COUNT_DTTM DateTime(26) TIMESTAMP Count Date/Time
    24 QTY_PCT_ERROR Signed Number(12,4) DECIMAL(10,4) NOT NULL Quantity Percent Error
    25 NEED_TO_RECONCILE Character(1) VARCHAR2(1) NOT NULL Needs Reconciliation

    Y/N Table Edit

    26 QTY_DELTA_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL Delta Quantity
    27 QTY_SYSTEM_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL System Quantity
    28 INVENTORY_TAG_ID Number(15,0) DECIMAL(15) NOT NULL Inventory Tag ID
    29 CONFIG_CODE Character(50) VARCHAR2(50) NOT NULL Product Configurator

    Prompt Table: %EDITTABLE2

    30 EIP_CTL_ID Character(25) VARCHAR2(25) NOT NULL Enterprise Components EIP (enterprise integration point) control field
    31 SYNCH_FLAG Character(1) VARCHAR2(1) NOT NULL Synchronization Flag used to indicate the level of synchronization during a physical inventory snapshot.
    0=No Synchronization Required
    1=Synchronize a Business Unit
    2=Synchronize an Item
    3=Synchronize a Storage Location
    4=Synchronize a Lot ID
    5=Synchronize Item at a Stor Loc
    32 EIP_TRANS_SRC Character(30) VARCHAR2(30) NOT NULL 08/02/99 NAS: Created the field for MES but it will be owned by Entreprise, they just don't know it yet :-)
    33 EIP_TRANS_SRC_REF Character(30) VARCHAR2(30) NOT NULL Source Reference
    34 GROUP_ID_SEQ_NUM Number(15,0) DECIMAL(15) NOT NULL Group ID
    35 MFG_ID Character(50) VARCHAR2(50) NOT NULL Manufacturer ID
    36 MFG_ITM_ID Character(50) VARCHAR2(50) NOT NULL Manufacturer's Item ID
    37 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    38 UPN_TYPE_CD Character(4) VARCHAR2(4) NOT NULL Universal Product Number Format Type

    Prompt Table: UPN_TYPE_FS

    39 UPN_ID Character(20) VARCHAR2(20) NOT NULL Universal Product Number
    40 MIN_STOR_AREA_LVL Character(25) VARCHAR2(25) NOT NULL Used to concatenate Storage Area + Levels using the Key Separator from Mobile Inventory Installation Page
    41 FLEX_FIELD_C30_A Character(30) VARCHAR2(30) NOT NULL Flex Field Char 30 A
    42 FLEX_FIELD_C30_B Character(30) VARCHAR2(30) NOT NULL Flex Field Char 30 B
    43 FLEX_FIELD_C30_C Character(30) VARCHAR2(30) NOT NULL Flex Field Char 30 C
    44 FLEX_FIELD_C30_D Character(30) VARCHAR2(30) NOT NULL Flex Field Char 30 D
    45 FLEX_FIELD_C1_A Character(1) VARCHAR2(1) NOT NULL Flex Field Char 1 A
    46 FLEX_FIELD_C1_B Character(1) VARCHAR2(1) NOT NULL Flex Field Char 1 B
    47 FLEX_FIELD_C1_C Character(1) VARCHAR2(1) NOT NULL Flex Field Char 1 C
    48 FLEX_FIELD_C1_D Character(1) VARCHAR2(1) NOT NULL Flex Field Char 1 D
    49 FLEX_FIELD_C10_A Character(10) VARCHAR2(10) NOT NULL Flex Field Char 10 A
    50 FLEX_FIELD_C10_B Character(10) VARCHAR2(10) NOT NULL Flex Field Char 10 B
    51 FLEX_FIELD_C10_C Character(10) VARCHAR2(10) NOT NULL Flex Field Char 10 C
    52 FLEX_FIELD_C10_D Character(10) VARCHAR2(10) NOT NULL Flex Field Char 10 D
    53 FLEX_FIELD_C2 Character(2) VARCHAR2(2) NOT NULL Flex Field Char 2
    54 FLEX_FIELD_C4 Character(4) VARCHAR2(4) NOT NULL Flex Field Char 4
    55 FLEX_FIELD_C6 Character(6) VARCHAR2(6) NOT NULL Flex Field Char 6
    56 FLEX_FIELD_C8 Character(8) VARCHAR2(8) NOT NULL Flex Field Char 8
    57 FLEX_FIELD_N12_A Number(16,3) DECIMAL(15,3) NOT NULL Flex Field Numeric 12 A
    58 FLEX_FIELD_N12_B Number(16,3) DECIMAL(15,3) NOT NULL Flex Field Numeric 12 B
    59 FLEX_FIELD_N12_C Number(16,3) DECIMAL(15,3) NOT NULL Flex Field Numeric 12 C
    60 FLEX_FIELD_N12_D Number(16,3) DECIMAL(15,3) NOT NULL Flex Field Numeric 12 D
    61 FLEX_FIELD_N15_A Number(15,0) DECIMAL(15) NOT NULL Flex Field Numeric 15 A
    62 FLEX_FIELD_N15_B Number(15,0) DECIMAL(15) NOT NULL Flex Field Numeric 15 B
    63 FLEX_FIELD_N15_C Number(15,0) DECIMAL(15) NOT NULL Flex Field Numeric 15 C
    64 FLEX_FIELD_N15_D Number(15,0) DECIMAL(15) NOT NULL Flex Field Numeric 15 D
    65 FLEX_FIELD_S15_A Signed Number(32,15) DECIMAL(30,15) NOT NULL Flex Field Signed 15.15 A
    66 FLEX_FIELD_S15_B Signed Number(32,15) DECIMAL(30,15) NOT NULL Flex Field Signed 15.15 B
    67 FLEX_FIELD_S15_C Signed Number(32,15) DECIMAL(30,15) NOT NULL Flex Field Signed 15.15 C
    68 FLEX_FIELD_S15_D Signed Number(32,15) DECIMAL(30,15) NOT NULL Flex Field Signed 15.15 D
    69 FLEX_FIELD_DT_A DateTime(26) TIMESTAMP Flex Field Datetime A
    70 FLEX_FIELD_DT_B DateTime(26) TIMESTAMP Flex Field Datetime B
    71 FLEX_FIELD_DT_C DateTime(26) TIMESTAMP Flex Field Datetime C
    72 FLEX_FIELD_DT_D DateTime(26) TIMESTAMP Flex Field Datetime D
    73 GROUPBOX Character(1) VARCHAR2(1) NOT NULL Groupbox
    74 ROWNBR Number(7,0) INTEGER NOT NULL Row number
    75 CFG_CODE_OPT Character(1) VARCHAR2(1) NOT NULL Configuration Code Generation
    B=Both
    N=No
    Y=Yes
    76 UNIT_MEASURE_PACK Character(3) VARCHAR2(3) NOT NULL Packing UOM
    77 ORIG_QTY_COUNT Signed Number(17,4) DECIMAL(15,4) NOT NULL Original Count Quantity
    78 ORIG_COUNT_STATUS Character(1) VARCHAR2(1) NOT NULL Count Item Status
    1=New
    2=Counting
    3=Quantity Entered - Hold
    4=Ready to Update Stock Quantity
    5=Stock Quantity Updated
    6=Canceled
    79 EXPIRATION_DATE Date(10) DATE Expiration Date