BCT_D_SHP_VW

(SQL View)
 Index Back

Update Shipment Confirmation

BCT_DTL view used to maintain Shipment Confirmation transactions. /* 06/22/04 PWF Change sched line no to sched line nbr */

SELECT A.BUSINESS_UNIT , A.EIP_CTL_ID , A.SEQ_NBR , A.TRANSACTION_CODE , A.PICK_BATCH_ID , A.PICKLIST_LINE_NO , A.LAST_DTTIME , A.BCT_DET_STATUS , A.STAGED_DATE , A.INV_LOT_ID , A.INV_ITEM_ID , A.SERIAL_ID , A.STORAGE_AREA , A.STOR_LEVEL_1 , A.STOR_LEVEL_2 , A.STOR_LEVEL_3 , A.STOR_LEVEL_4 , A.CONTAINER_ID , A.SHIP_CNTR_ID , A.DEMAND_SOURCE , A.SOURCE_BUS_UNIT , A.ORDER_NO , A.ORDER_INT_LINE_NO , A.SCHED_LINE_NBR , A.DEMAND_LINE_NO , A.UNIT_OF_MEASURE , A.QTY , A.EIP_TRANS_SRC_SEQ , A.SHIP_ID , A.SHIP_LINE_NO , A.SHIP_DATE , A.SHIP_TIME , A.SHIP_TYPE_ID , A.FREIGHT_TERMS , A.PRO_NUMBER , A.CARRIER_ID , A.BILL_OF_LADING , A.SHIP_FLAG , A.PARENT_SHIP_CNTR FROM PS_BCT_DTL A

# 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 PICK_BATCH_ID Number(10,0) DECIMAL(10) NOT NULL Pick Batch ID

Prompt Table: BCT_PCK_BTCH_VW

6 PICKLIST_LINE_NO Number(7,0) INTEGER NOT NULL Pick List Sorting Line Number

Prompt Table: BCT_PCK_LINE_VW

7 LAST_DTTIME DateTime(26) TIMESTAMP NOT NULL Last Date Time
8 BCT_DET_STATUS Character(1) VARCHAR2(1) NOT NULL BCTP Detail Status
0=Open
1=Error
2=Complete
3=Cancel
9 STAGED_DATE Date(10) DATE Staged Date

Prompt Table: BCT_STAG_INV_VW

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

Prompt Table: %EDITTABLE

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

Prompt Table: BCT_PCK_ITM_VW

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

Prompt Table: BCT_SRAL_INV_VW

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

Prompt Table: STOR_AREA_VW2

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

Prompt Table: STOR_LEV1_VW2

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

Prompt Table: STOR_LEV2_VW2

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

Prompt Table: STOR_LEV3_VW2

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

Prompt Table: STOR_LEV4_VW2

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

Prompt Table: CNTR_ID_INV

19 SHIP_CNTR_ID Character(20) VARCHAR2(20) NOT NULL Shipping Container ID
20 DEMAND_SOURCE Character(2) VARCHAR2(2) NOT NULL Demand Source
IN=Material Request
OM=Sales Order
PL=Planning Requisition
PO=Purchase Order
PR=Purchasing Requisition
RT=Material Return
SF=Production Request
WM=Work Order
21 SOURCE_BUS_UNIT Character(5) VARCHAR2(5) NOT NULL Source Bus Unit
22 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
23 ORDER_INT_LINE_NO Number(5,0) INTEGER NOT NULL Order Line
24 SCHED_LINE_NBR Number(6,0) INTEGER NOT NULL Schedule Line Number
25 DEMAND_LINE_NO Number(4,0) SMALLINT NOT NULL Demand Line No
26 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

27 QTY Signed Number(17,4) DECIMAL(15,4) NOT NULL Quantity
28 EIP_TRANS_SRC_SEQ Number(15,0) DECIMAL(15) NOT NULL Source Transaction Sequence
29 SHIP_ID Character(10) VARCHAR2(10) NOT NULL Shipping ID
30 SHIP_LINE_NO Number(10,2) DECIMAL(9,2) NOT NULL Ship Line No
31 SHIP_DATE Date(10) DATE Item Shipping Date
32 SHIP_TIME Time(15) TIMESTAMP Ship Time
33 SHIP_TYPE_ID Character(10) VARCHAR2(10) NOT NULL Ship Via Code

Prompt Table: SHIP_METHOD

34 FREIGHT_TERMS Character(10) VARCHAR2(10) NOT NULL Freight Terms Code

Prompt Table: FREIGHT_TERMS

35 PRO_NUMBER Character(40) VARCHAR2(40) NOT NULL Pro Number
36 CARRIER_ID Character(10) VARCHAR2(10) NOT NULL Carrier ID

Prompt Table: CARRIER_ID

37 BILL_OF_LADING Character(30) VARCHAR2(30) NOT NULL Specifies a bill of lading number associated with a Receivables item.
38 SHIP_FLAG Character(1) VARCHAR2(1) NOT NULL Shippable

Y/N Table Edit

39 PARENT_SHIP_CNTR Character(20) VARCHAR2(20) NOT NULL Parent Shipping Container ID