BCT_D_IURV_VW

#	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 Prompt Table: BCT_XIUR_INV_VW
5	LAST_DTTIME	DateTime(26)	TIMESTAMP NOT NULL	Last Date Time
6	BCT_DET_STATUS	Character(1)	VARCHAR2(1) NOT NULL	BCTP Detail Status 0=Open 1=Error 2=Complete 3=Cancel
7	INV_LOT_ID	Character(15)	VARCHAR2(15) NOT NULL	Lot ID
8	INV_ITEM_ID	Character(18)	VARCHAR2(18) NOT NULL	Item ID
9	SERIAL_ID	Character(20)	VARCHAR2(20) NOT NULL	Serial ID
10	STORAGE_AREA	Character(5)	VARCHAR2(5) NOT NULL	Storage Area
11	STOR_LEVEL_1	Character(4)	VARCHAR2(4) NOT NULL	Storage Level 1
12	STOR_LEVEL_2	Character(4)	VARCHAR2(4) NOT NULL	Storage Level 2
13	STOR_LEVEL_3	Character(4)	VARCHAR2(4) NOT NULL	Storage Level 3
14	STOR_LEVEL_4	Character(4)	VARCHAR2(4) NOT NULL	Storage Level 4
15	CONTAINER_ID	Character(10)	VARCHAR2(10) NOT NULL	Container ID
16	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
17	RECEIVER_ID	Character(10)	VARCHAR2(10) NOT NULL	Receiver number
18	RECV_LN_NBR	Number(5,0)	INTEGER NOT NULL	Receipt Line
19	QTY	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Quantity
20	DISTRIB_TYPE	Character(10)	VARCHAR2(10) NOT NULL	Distrib. Type Prompt Table: CM_DISTR_TYPE
21	SHIP_CNTR_ID	Character(20)	VARCHAR2(20) NOT NULL	Shipping Container ID
22	SOURCE_BUS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Source Bus Unit Prompt Table: SP_BU_FS_NONVW
23	DEVICE_DTTIME	DateTime(26)	TIMESTAMP	Device Date Time
24	CARRIER_ID	Character(10)	VARCHAR2(10) NOT NULL	Carrier ID
25	BILL_OF_LADING	Character(30)	VARCHAR2(30) NOT NULL	Specifies a bill of lading number associated with a Receivables item.
26	EIP_TRANS_SRC_SEQ	Number(15,0)	DECIMAL(15) NOT NULL	Source Transaction Sequence
27	PACKSLIP_NO	Character(22)	VARCHAR2(22) NOT NULL	Packing Slip Number
28	BUSINESS_UNIT_IN	Character(5)	VARCHAR2(5) NOT NULL	Inventory Unit Prompt Table: SP_BUIN_NONVW
29	INTERUNIT_ID	Character(10)	VARCHAR2(10) NOT NULL	InterUnit Order ID
30	INTERUNIT_LINE	Number(5,0)	INTEGER NOT NULL	InterUnit Order Line
31	CONFIG_CODE	Character(50)	VARCHAR2(50) NOT NULL	Product Configurator
32	IU_REC_ID_GRP_FLG	Character(1)	VARCHAR2(1) NOT NULL	Interunit Receipt Identification Group Flag 0 = Group by Receiving Business Unit, Receiver ID. (Default) 1 = Group by Receiving Business Unit, Source Business Unit (origination), Interunit ID, Dest Inventory Business Unit. 2 = Receiving Business Unit, Carrier, Bill of Lading 0=Receiver ID 1=Source BU,InterUnit ID,Dest BU 2=Carrier, Bill of Lading Default Value: 0
33	IU_REC_SEL_GRP_FLG	Character(1)	VARCHAR2(1) NOT NULL	Interunit Receipt Selection Group Flag 0 = Source Business Unit, Interunit ID, Destination Inventory Business Unit (Default) 1 = Source Business Unit, Shipping Container 0=Source BU, IU ID, Dest BU 1=Source BU, Shipping Container Default Value: 0
34	SPEEDTYPE_KEY	Character(10)	VARCHAR2(10) NOT NULL	SpeedType Key
35	PORT_OF_UNLOADING	Character(10)	VARCHAR2(10) NOT NULL	Port Of Unloading Prompt Table: PORT_AIRPRT_VW3
36	IST_RETURN_FLG_IUT	Character(1)	VARCHAR2(1) NOT NULL	Intrastat InterUnit Returns Y/N Table Edit Default Value: N
37	REPLACEMENT_FLG	Character(2)	VARCHAR2(2) NOT NULL	Replacement Flag NA=Not Applicable RN=Replace Goods Not Returned RR=Replacement of Returned Goods Default Value: NA
38	VMI_OM_BU	Character(5)	VARCHAR2(5) NOT NULL	OM Business Unit Related to VMI Prompt Table: OM_BU_NONVW
39	SHIP_TO_CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Ship To Customer Prompt Table: VMI_CUSTSHP2_VW
40	PRODUCT_ID	Character(18)	VARCHAR2(18) NOT NULL	Product ID Prompt Table: INFUL_DMDPRD_VW