BCT_D_QOH_VW

(SQL View)
 Index Back

Update VMI QOH Transactions

BCT_DTL view used to maintain VMI QOH transactions.

SELECT BUSINESS_UNIT , EIP_CTL_ID , SEQ_NBR , TRANSACTION_CODE , EIP_TRANS_SRC_SEQ , LAST_DTTIME , BCT_DET_STATUS , STAGED_DATE , INV_LOT_ID , INV_ITEM_ID , SERIAL_ID , STORAGE_AREA , STOR_LEVEL_1 , STOR_LEVEL_2 , STOR_LEVEL_3 , STOR_LEVEL_4 , CONTAINER_ID , UNIT_OF_MEASURE , QTY , REASON_CD , DISTRIB_TYPE , DEVICE_DTTIME , DOCUMENT_ID , ADJUST_TYPE , SPEEDTYPE_KEY , CONFIG_CODE , VMI_OM_BU , SHIP_TO_CUST_ID , SHIP_TO_CUST_ID , PRODUCT_ID , ORDER_NO FROM PS_BCT_DTL

# 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 EIP_CTL_ID Character(25) VARCHAR2(25) NOT NULL Enterprise Components EIP (enterprise integration point) control field
3 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number
4 TRANSACTION_CODE Character(4) VARCHAR2(4) NOT NULL Transaction Code
5 EIP_TRANS_SRC_SEQ Number(15,0) DECIMAL(15) NOT NULL Source Transaction Sequence
6 LAST_DTTIME DateTime(26) TIMESTAMP NOT NULL Last Date Time
7 BCT_DET_STATUS Character(1) VARCHAR2(1) NOT NULL BCTP Detail Status
0=Open
1=Error
2=Complete
3=Cancel
8 STAGED_DATE Date(10) DATE Staged Date

Prompt Table: BCT_STAG_INV_VW

9 INV_LOT_ID Character(15) VARCHAR2(15) NOT NULL Lot ID

Prompt Table: %EDITTABLE

10 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID

Prompt Table: BU_ITM_INV_VW

11 SERIAL_ID Character(20) VARCHAR2(20) NOT NULL Serial ID

Prompt Table: BCT_SRAL_INV_VW

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

Prompt Table: STOR_AREA_VW2

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

Prompt Table: STOR_LEV1_VW2

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

Prompt Table: STOR_LEV2_VW2

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

Prompt Table: STOR_LEV3_VW2

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

Prompt Table: STOR_LEV4_VW2

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

Prompt Table: CNTR_ID_INV

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

Default Value: MASTER_ITEM_TBL.UNIT_MEASURE_STD

Prompt Table: %EDITTABLE2

19 QTY Signed Number(17,4) DECIMAL(15,4) NOT NULL Quantity
20 REASON_CD Character(10) VARCHAR2(10) NOT NULL Reason Code

Prompt Table: %EDITTABLE3

21 DISTRIB_TYPE Character(10) VARCHAR2(10) NOT NULL Distrib. Type

Default Value: CM_TRANS_GROUP.DISTRIB_TYPE

Prompt Table: CM_DISTR_TYPE

22 DEVICE_DTTIME DateTime(26) TIMESTAMP Device Date Time
23 DOCUMENT_ID Character(12) VARCHAR2(12) NOT NULL Document
24 ADJUST_TYPE Character(1) VARCHAR2(1) NOT NULL Adjustment Type
0=CM Only
A=VMI Return
D=Decrease
I=Increase
M=Misc Issue
R=Misc Return
S=Scrap
V=Scrap RTV
25 SPEEDTYPE_KEY Character(10) VARCHAR2(10) NOT NULL SpeedType Key
26 CONFIG_CODE Character(50) VARCHAR2(50) NOT NULL Product Configurator

Prompt Table: %EDITTABLE4

27 VMI_OM_BU Character(5) VARCHAR2(5) NOT NULL OM Business Unit Related to VMI

Prompt Table: OM_BU_NONVW

28 SHIP_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Ship To Customer

Prompt Table: VMI_CUSTSHP2_VW

29 SOLD_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Sold To Customer

Prompt Table: VMI_CUSTSLD2_VW

30 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID
31 ORDER_NO Character(10) VARCHAR2(10) NOT NULL Identifies a customer order number that appears as a reference on a receivables pending item. Date Initials Issue Description 022701 mv SP2 (F-CJORGENS-3) CSR Desktop