BCT_E_MG_MCP_VW

(SQL View)
Index Back

BCTP Detail Mfg CompletionView

990105 nas (CN# EN800-6.0) New barcode - Added output fields nas 01-21-99 (cn# EN800-1.0) Added substitute key 990125 nas (CN# SF800-10.0) Added Changed Actual Hours fields 990202 nas (CN# EN800-6.0) Added and moved fields around. 990209 nas (CN#EN800-6.0) Renamed MG_OUTPUT_QTY for MG_NEW_OUTPUT_QTY. 990223 nas (CN# EN800-6.0) Made MG_OUTPUT_COMPL signed and added MG_OUTPUT_SEQ 990316 nas (CN#EN800-1.0) Added SUB_ITM_ID 042299 nas: added Inventory fields (Merge) 061599 nas: Added Purch new fields (Supplier Lot & tag number) 092899 nas: Added MG_ISSUE_COMP_FLG for MES EIP 112299 nas: Added Inv.'s fields per D.P. 000121 nas: Added INV and MFG fields #136 - 144 011703 pwf: Modified sql to ensure the fields and sql are consistent. 062204 PWF Change sched line no to sched line nbr

SELECT a.BUSINESS_UNIT , a.EIP_CTL_ID , a.MG_OUTPUT_SEQ , a.MG_OUTPUT_ITEM , a.SEQ_NBR , a.TRANSACTION_CODE , a.MG_OUTPUT_TYPE , a.LAST_DTTIME , a.BCT_DET_STATUS , a.STAGED_DATE , a.INV_LOT_ID , a.INV_ITEM_ID , a.SERIAL_ID , a.NEW_SERIAL , a.STORAGE_AREA , a.STOR_LEVEL_1 , a.STOR_LEVEL_2 , a.STOR_LEVEL_3 , a.STOR_LEVEL_4 , a.CONTAINER_ID , a.UNIT_OF_MEASURE , a.RECEIVER_ID , a.RECV_LN_NBR , a.TO_CONTAINER_ID , a.TO_STORAGE_AREA , a.TO_STOR_LEVEL_1 , a.TO_STOR_LEVEL_2 , a.TO_STOR_LEVEL_3 , a.TO_STOR_LEVEL_4 , a.QTY , a.COMPLETE_FLG , a.PRODUCTION_ID , a.PRDN_AREA_CODE , a.COMPL_OP_SEQ , a.UPDATE_OP_SEQ , a.PICK_BATCH_ID , a.PICKLIST_LINE_NO , a.COMPONENT_ID , a.COMPL_QTY , a.SCRAPPED_QTY , a.REASON_CD , a.PERCENT_COMP , a.DISTRIB_TYPE , a.TO_PRODUCTION_ID , a.PTWY_PLAN_ID , a.PTWYPLAN_LN_NBR , 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.QTY_CODE , a.OP_SEQUENCE , a.PEND_CONSUME_QTY , a.PEND_LOSS_QTY , a.REVISION , a.DEVICE_DTTIME , a.UOM_ORIG , a.ORIG_CONSUMED_QTY , a.ORIG_COMP_LOSS_QTY , a.YIELD_QTY , a.SHIPTO_SETID , a.SHIPTO_ID , a.VENDOR_ID , a.SHIPMENT_NO , a.CARRIER_ID , a.BILL_OF_LADING , a.BUSINESS_UNIT_PO , a.PO_ID , a.LINE_NBR , a.END_TRANS_FLG , a.ADJUST_TYPE , a.DOCUMENT_ID , a.EIP_TRANS_SRC_SEQ , a.PACKSLIP_NO , a.BUSINESS_UNIT_IN , a.INTERUNIT_ID , a.INTERUNIT_LINE , a.CONFIG_CODE , a.UNIT_MEASURE_COUNT , a.SHIP_ID , a.SHIP_LINE_NO , a.SHIP_DATE , a.SHIP_TIME , a.SHIP_TYPE_ID , a.FREIGHT_TERMS , a.PRO_NUMBER , a.SHIP_FLAG , a.BOM_CODE , a.RTG_CODE , a.SF_BOM_RTG_EFFDT , a.MG_NEW_OUTPUT_QTY , a.MG_OUTPUT_RES_PCT , a.MG_OUTPUT_COMPL , a.BOM_QTY , a.MG_UNPLAN_OUTPUT , a.MG_TRANS_UOM , a.MG_OUTPUT_QTY_CODE , a.MG_RELATED_TRANS , a.CREW_RPT_FLAG , a.MACH_RPT_FLAG , a.CREWSIZE , a.MACH_RESOURCES , a.LAB_SETUP , a.LAB_RUN , a.LAB_FIXED_RUN , a.LAB_POSTPROD , a.MACH_SETUP , a.MACH_RUN , a.MACH_FIXED_RUN , a.MACH_POSTPROD , a.WORK_CENTER_CODE , a.SF_ENTRY_DATE , a.MG_ORIG_COMP_ID , a.MG_ORIG_QTY_PER , a.PARENT_ITEM_ID , a.SUB_ITM_ID , A.VENDOR_LOT_ID , A.TAG_NUMBER , A.MG_ISSUE_COMP_FLG , A.INV_CART_ID , A.COMPARTMENT , A.COUNT_ORDER , A.CART_COUNT_QTY , A.QTY_OPTION , A.SUFFICIENT_STOCK , A.IU_REC_ID_GRP_FLG , A.IU_REC_SEL_GRP_FLG , A.SPEEDTYPE_KEY , A.RTV_ID , A.RTV_LN_NBR , A.RTV_DISTRIB_NUM , A.SYNCH_FLAG , A.COUNTING_EVENT_ID , A.PORT_OF_UNLOADING , A.IST_RETURN_FLG_IUT , A.REPLACEMENT_FLG , A.PARENT_SHIP_CNTR , A.SF_KANBAN_ID , A.FREIGHT_AMT , A.FREIGHT_CURRNCY_CD , A.GROSS_WEIGHT , A.UNIT_MEASURE_WT , A.VNDR_LOC 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
2 EIP_CTL_ID Character(25) VARCHAR2(25) NOT NULL Enterprise Components EIP (enterprise integration point) control field
3 MG_OUTPUT_SEQ Number(4,0) SMALLINT NOT NULL NAS 022399 (CN# EN800-6.0) Field required for Message Agent definition of Multiple Outputs Completion.
4 MG_OUTPUT_ITEM Character(18) VARCHAR2(18) NOT NULL 04/10/00 (Internet Architecture) SCC: Uppercase label Id. 10/22/98 (CN#EN800-6.0) LAJ...Created Stores the output item number on a Bill of Materials. This item may be either a co-product or a by-product on the BOM. The output type field determines which one it represents. There should always be at least one output item on the BOM at all times; this output item is the same as the BOMs item id.
5 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number
6 TRANSACTION_CODE Character(4) VARCHAR2(4) NOT NULL Transaction Code
7 MG_OUTPUT_TYPE Character(2) VARCHAR2(2) NOT NULL 10/22/98 (CN#EN800-6.0) LAJ...Created Stores the output item type on a Bill of Materials. The type could represent either a co-product (primary or secondary) or a by-product (waste or recycle). 11/23/98 (CN#SF800-13) JNW added teardown xlat
CP=Primary
CS=Co-Product
RB=Recycle
TD=Teardown
WB=Waste
8 LAST_DTTIME DateTime(26) TIMESTAMP Last Date Time
9 BCT_DET_STATUS Character(1) VARCHAR2(1) NOT NULL BCTP Detail Status
0=Open
1=Error
2=Complete
3=Cancel
10 STAGED_DATE Date(10) DATE Staged Date
11 INV_LOT_ID Character(15) VARCHAR2(15) NOT NULL Lot ID
12 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID

Prompt Table: SF_OUTPUT_LIST

13 SERIAL_ID Character(20) VARCHAR2(20) NOT NULL Serial ID
14 NEW_SERIAL Character(20) VARCHAR2(20) NOT NULL New Serial ID mmt 09/18/03 Adding label for use on mult out compl wedge
15 STORAGE_AREA Character(5) VARCHAR2(5) NOT NULL Storage Area
16 STOR_LEVEL_1 Character(4) VARCHAR2(4) NOT NULL Storage Level 1
17 STOR_LEVEL_2 Character(4) VARCHAR2(4) NOT NULL Storage Level 2
18 STOR_LEVEL_3 Character(4) VARCHAR2(4) NOT NULL Storage Level 3
19 STOR_LEVEL_4 Character(4) VARCHAR2(4) NOT NULL Storage Level 4
20 CONTAINER_ID Character(10) VARCHAR2(10) NOT NULL Container ID
21 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
22 RECEIVER_ID Character(10) VARCHAR2(10) NOT NULL Receiver number
23 RECV_LN_NBR Number(5,0) INTEGER NOT NULL Receipt Line
24 TO_CONTAINER_ID Character(10) VARCHAR2(10) NOT NULL Container ID
25 TO_STORAGE_AREA Character(5) VARCHAR2(5) NOT NULL Storage Area
26 TO_STOR_LEVEL_1 Character(4) VARCHAR2(4) NOT NULL Storage Level 1
27 TO_STOR_LEVEL_2 Character(4) VARCHAR2(4) NOT NULL Storage Level 2
28 TO_STOR_LEVEL_3 Character(4) VARCHAR2(4) NOT NULL Storage Level 3
29 TO_STOR_LEVEL_4 Character(4) VARCHAR2(4) NOT NULL Storage Level 4
30 QTY Signed Number(17,4) DECIMAL(15,4) NOT NULL Quantity
31 COMPLETE_FLG Character(1) VARCHAR2(1) NOT NULL Complete Flag
0=Process Location
1=Pick Line Complete
2=Pick Batch Complete
3=Pick Line as Planned
4=Pick Batch as Planned
5=Process Location - Incomplete
6=Complete Pick - Zero Quantity
7=Complete Pick - Leave Alone
8=Complete Pick - Dft Ship Loc
A=Use Defaults
B=No Action
32 PRODUCTION_ID Character(10) VARCHAR2(10) NOT NULL Production ID
33 PRDN_AREA_CODE Character(10) VARCHAR2(10) NOT NULL Production Area
34 COMPL_OP_SEQ Number(4,0) SMALLINT NOT NULL Completion Operation Sequence
35 UPDATE_OP_SEQ Number(4,0) SMALLINT NOT NULL Back Thru Operation
36 PICK_BATCH_ID Number(10,0) DECIMAL(10) NOT NULL Pick Batch ID
37 PICKLIST_LINE_NO Number(7,0) INTEGER NOT NULL Pick List Sorting Line Number
38 COMPONENT_ID Character(18) VARCHAR2(18) NOT NULL 04/10/00 (Internet Architecture) SCC: Uppercase label Id.
39 COMPL_QTY Signed Number(13,4) DECIMAL(11,4) NOT NULL Completed Qty
40 SCRAPPED_QTY Signed Number(13,4) DECIMAL(11,4) NOT NULL Scrapped Qty
41 REASON_CD Character(10) VARCHAR2(10) NOT NULL Reason Code
42 PERCENT_COMP Number(6,2) DECIMAL(5,2) NOT NULL Scrap Prdn Pct
43 DISTRIB_TYPE Character(10) VARCHAR2(10) NOT NULL Distrib. Type
44 TO_PRODUCTION_ID Character(10) VARCHAR2(10) NOT NULL To Production ID
45 PTWY_PLAN_ID Number(10,0) DECIMAL(10) NOT NULL Putaway Plan ID
46 PTWYPLAN_LN_NBR Number(10,0) DECIMAL(10) NOT NULL Putaway Line Number
47 SHIP_CNTR_ID Character(20) VARCHAR2(20) NOT NULL Shipping Container ID
48 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
49 SOURCE_BUS_UNIT Character(5) VARCHAR2(5) NOT NULL Source Bus Unit
50 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
51 ORDER_INT_LINE_NO Number(5,0) INTEGER NOT NULL Order Line
52 SCHED_LINE_NBR Number(6,0) INTEGER NOT NULL Schedule Line Number
53 DEMAND_LINE_NO Number(4,0) SMALLINT NOT NULL Demand Line No
54 QTY_CODE Character(3) VARCHAR2(3) NOT NULL Per
ASY=Assembly
ORD=Order
55 OP_SEQUENCE Number(4,0) SMALLINT NOT NULL Operation Sequence
56 PEND_CONSUME_QTY Signed Number(13,4) DECIMAL(11,4) NOT NULL 10/12/99 SCC CN#SF800-9.0: Added label id TO_PEND_CONSUME
57 PEND_LOSS_QTY Signed Number(13,4) DECIMAL(11,4) NOT NULL 10/12/99 SCC CN#SF800-9.0: Added label id TO_PEND_LOSS
58 REVISION Character(4) VARCHAR2(4) NOT NULL 01/27/2000 RML Added "As of" label
59 DEVICE_DTTIME DateTime(26) TIMESTAMP Device Date Time
60 UOM_ORIG Character(3) VARCHAR2(3) NOT NULL Original Unit of Measure
61 ORIG_CONSUMED_QTY Signed Number(13,4) DECIMAL(11,4) NOT NULL Original Consumed Quantity
62 ORIG_COMP_LOSS_QTY Signed Number(13,4) DECIMAL(11,4) NOT NULL Original Component Loss Qty
63 YIELD_QTY Number(12,4) DECIMAL(11,4) NOT NULL 10/12/99 SCC CN#SF800-9.0: Added label id TO_YIELD_QTY
64 SHIPTO_SETID Character(5) VARCHAR2(5) NOT NULL ShipTo SetID
65 SHIPTO_ID Character(10) VARCHAR2(10) NOT NULL Ship To Location
66 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
67 SHIPMENT_NO Character(30) VARCHAR2(30) NOT NULL Shipment Number
68 CARRIER_ID Character(10) VARCHAR2(10) NOT NULL Carrier ID
69 BILL_OF_LADING Character(30) VARCHAR2(30) NOT NULL Specifies a bill of lading number associated with a Receivables item.
70 BUSINESS_UNIT_PO Character(5) VARCHAR2(5) NOT NULL PO Business Unit
71 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
72 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
73 END_TRANS_FLG Character(1) VARCHAR2(1) NOT NULL End of Transaction Flag
74 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
75 DOCUMENT_ID Character(12) VARCHAR2(12) NOT NULL Document
76 EIP_TRANS_SRC_SEQ Number(15,0) DECIMAL(15) NOT NULL Source Transaction Sequence
77 PACKSLIP_NO Character(22) VARCHAR2(22) NOT NULL Packing Slip Number
78 BUSINESS_UNIT_IN Character(5) VARCHAR2(5) NOT NULL Inventory Unit
79 INTERUNIT_ID Character(10) VARCHAR2(10) NOT NULL InterUnit Order ID
80 INTERUNIT_LINE Number(5,0) INTEGER NOT NULL InterUnit Order Line
81 CONFIG_CODE Character(50) VARCHAR2(50) NOT NULL Product Configurator
82 UNIT_MEASURE_COUNT Character(3) VARCHAR2(3) NOT NULL Unit of Measure
83 SHIP_ID Character(10) VARCHAR2(10) NOT NULL Shipping ID
84 SHIP_LINE_NO Number(10,2) DECIMAL(9,2) NOT NULL Ship Line No
85 SHIP_DATE Date(10) DATE Item Shipping Date
86 SHIP_TIME Time(15) TIMESTAMP Ship Time
87 SHIP_TYPE_ID Character(10) VARCHAR2(10) NOT NULL Ship Via Code
88 FREIGHT_TERMS Character(10) VARCHAR2(10) NOT NULL Freight Terms Code
89 PRO_NUMBER Character(40) VARCHAR2(40) NOT NULL Pro Number
90 SHIP_FLAG Character(1) VARCHAR2(1) NOT NULL Shippable
91 BOM_CODE Number(2,0) SMALLINT NOT NULL CN# EN800-3.0, anna 09/21 added new field to database
92 RTG_CODE Number(2,0) SMALLINT NOT NULL Routing Code
93 SF_BOM_RTG_EFFDT Date(10) DATE 12/28/98,eyz, CN#EN800-4.0, new this as a workfield in Completions for the Recipe Management feature.
94 MG_NEW_OUTPUT_QTY Number(12,4) DECIMAL(11,4) NOT NULL 10/22/98 (CN#EN800-6.0) LAJ...Created Stores the output item quantity on a Bill of Materials. This value is assumed to be in the UOM of the output item it's associated to.
95 MG_OUTPUT_RES_PCT Number(3,0) SMALLINT NOT NULL 10/22/98 (CN#EN800-6.0) LAJ...Created Stores the output item's resource allocation percentage on a Bill of Material. Since it is a percentage, it cannot store a value greater than 100. It is used to determine what percentage of the inputs (components) on the BOM are used to produce the output (co-product).
96 MG_OUTPUT_COMPL Signed Number(13,4) DECIMAL(11,4) NOT NULL 990105 nas (CN# EN800-6.0) This field will contain the user inputted quantity completed of a specific output within completion process.
97 BOM_QTY Number(7,0) INTEGER NOT NULL 06/02/00 LAJ (8.0) Changed field length from 8.0 to 7.0. All other quantity fields have a standardized length of 7, so this change will make bom_qty standard.
98 MG_UNPLAN_OUTPUT Character(1) VARCHAR2(1) NOT NULL 01/19/99 nas (CN#800-6.0) Created new field.
99 MG_TRANS_UOM Character(3) VARCHAR2(3) NOT NULL 01/19/99 NAS (CN#800-6.0) Created new field
100 MG_OUTPUT_QTY_CODE Character(3) VARCHAR2(3) NOT NULL 01/28/98 (CN#EN800-6.0) LAJ...Created Stores the quantity code for an output item on a Bill of Materials. It was created with the same values as qty_code, but by separating these two fields, it allows greater flexibility in the future.
ASY=Assembly
ORD=Order
101 MG_RELATED_TRANS Character(25) VARCHAR2(25) NOT NULL Related Transaction Control Id
102 CREW_RPT_FLAG Character(1) VARCHAR2(1) NOT NULL Crew Reporting
103 MACH_RPT_FLAG Character(1) VARCHAR2(1) NOT NULL Machine Reporting
104 CREWSIZE Number(7,2) DECIMAL(6,2) NOT NULL Crew Size
105 MACH_RESOURCES Number(7,2) DECIMAL(6,2) NOT NULL Machine Resources
106 LAB_SETUP Signed Number(10,2) DECIMAL(8,2) NOT NULL Labor Setup
107 LAB_RUN Signed Number(10,2) DECIMAL(8,2) NOT NULL Labor Run
108 LAB_FIXED_RUN Signed Number(10,2) DECIMAL(8,2) NOT NULL Labor Fixed Run
109 LAB_POSTPROD Signed Number(10,2) DECIMAL(8,2) NOT NULL Labor Post Production
110 MACH_SETUP Signed Number(10,2) DECIMAL(8,2) NOT NULL Machine Setup
111 MACH_RUN Signed Number(10,2) DECIMAL(8,2) NOT NULL Machine Run
112 MACH_FIXED_RUN Signed Number(10,2) DECIMAL(8,2) NOT NULL Machine Fixed Run
113 MACH_POSTPROD Signed Number(10,2) DECIMAL(8,2) NOT NULL Machine Post Production
114 WORK_CENTER_CODE Character(10) VARCHAR2(10) NOT NULL Work Center
115 SF_ENTRY_DATE Date(10) DATE Entry Date
116 MG_ORIG_COMP_ID Character(18) VARCHAR2(18) NOT NULL original component ID
117 MG_ORIG_QTY_PER Number(16,10) DECIMAL(15,10) NOT NULL original qty per
118 PARENT_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Parent Item ID
119 SUB_ITM_ID Character(18) VARCHAR2(18) NOT NULL 11/30/99 RML Added label "Substitute"
120 VENDOR_LOT_ID Character(15) VARCHAR2(15) NOT NULL Vendor Lot
121 TAG_NUMBER Character(12) VARCHAR2(12) NOT NULL Tag Number
122 MG_ISSUE_COMP_FLG Character(1) VARCHAR2(1) NOT NULL NAS - 09-27-99 Created - Will be used to determine if the program must issue components a standard or will we be expecting component consuption transactions from user/external source.
N=Use comp.issue trans. provided
Y=Program Generate Issue Trans.
123 INV_CART_ID Character(15) VARCHAR2(15) NOT NULL Par Location ID
124 COMPARTMENT Character(10) VARCHAR2(10) NOT NULL Compartment
125 COUNT_ORDER Signed Number(5,0) DECIMAL(4) NOT NULL Par Location Count Order
126 CART_COUNT_QTY Signed Number(17,4) DECIMAL(15,4) NOT NULL Par Location Count Quantity
127 QTY_OPTION Character(2) VARCHAR2(2) NOT NULL Qty Option
01=Count Qty
02=Request Qty
128 SUFFICIENT_STOCK Character(1) VARCHAR2(1) NOT NULL Sufficient Stock
N=NOT SUFFICIENT STOCK
Y=SUFFICIENT STOCK
129 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
130 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
131 SPEEDTYPE_KEY Character(10) VARCHAR2(10) NOT NULL SpeedType Key
132 RTV_ID Character(10) VARCHAR2(10) NOT NULL Return To Vendor ID
133 RTV_LN_NBR Number(5,0) INTEGER NOT NULL Return To Vendor Line
134 RTV_DISTRIB_NUM Number(5,0) INTEGER NOT NULL RTV Distribution Number
135 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
136 COUNTING_EVENT_ID Number(15,0) DECIMAL(15) NOT NULL Counting Event ID
137 PORT_OF_UNLOADING Character(10) VARCHAR2(10) NOT NULL Port Of Unloading
138 IST_RETURN_FLG_IUT Character(1) VARCHAR2(1) NOT NULL Intrastat InterUnit Returns
139 REPLACEMENT_FLG Character(2) VARCHAR2(2) NOT NULL Replacement Flag
NA=Not Applicable
RN=Replace Goods Not Returned
RR=Replacement of Returned Goods
140 PARENT_SHIP_CNTR Character(20) VARCHAR2(20) NOT NULL Parent Shipping Container ID
141 SF_KANBAN_ID Character(15) VARCHAR2(15) NOT NULL Kanban ID
142 FREIGHT_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Freight Amount
143 FREIGHT_CURRNCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
144 GROSS_WEIGHT Signed Number(17,4) DECIMAL(15,4) NOT NULL Shipping Weight
145 UNIT_MEASURE_WT Character(3) VARCHAR2(3) NOT NULL Weight UOM
146 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location