BCT_D_MG_PRD_VW

(SQL View)
 Index Back

Rec Assembly Serial DTL View

BCT_DTL view for Record Assembly Serial page /* 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.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.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_OUTPUT_SEQ , A.MG_OUTPUT_ITEM , A.MG_OUTPUT_TYPE , 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 , A.LOCATION_ID , A.SHIP_TO_CUST_ID , A.LOAD_ID , A.PICK_BATCH_FROM , A.PICK_BATCH_TO , A.ROUTE_CD , A.WAVE_CD , A.TO_BILL_OF_LADING , A.TO_CARRIER_ID , A.TO_FREIGHT_TERMS , A.TO_PRO_NUMBER , A.TO_SHIP_TYPE_ID , A.DO_NOT_SHIP_FLAG , A.UNIT_MEASURE_SHIP , A.SHORT_SHIP_OPT , A.BCKORDR_CNCL_FLAG , A.LOCATION , A.LOG_ERROR_OPTION , A.UNIT_MEASURE_PICK , A.COMP_SERIAL_ID , A.COMP_LOT_ID , A.NEW_SERIAL , A.MG_SHIFT FROM PS_BCT_DTL A

  • Parent record: BCT_CTL

    • # 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 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number
    4 TRANSACTION_CODE Character(4) VARCHAR2(4) NOT NULL Transaction Code
    5 LAST_DTTIME DateTime(26) TIMESTAMP 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 STAGED_DATE Date(10) DATE Staged Date
    8 INV_LOT_ID Character(15) VARCHAR2(15) NOT NULL Lot ID
    9 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
    10 SERIAL_ID Character(20) VARCHAR2(20) NOT NULL Serial ID

    Prompt Table: %EDITTABLE

    11 STORAGE_AREA Character(5) VARCHAR2(5) NOT NULL Storage Area
    12 STOR_LEVEL_1 Character(4) VARCHAR2(4) NOT NULL Storage Level 1
    13 STOR_LEVEL_2 Character(4) VARCHAR2(4) NOT NULL Storage Level 2
    14 STOR_LEVEL_3 Character(4) VARCHAR2(4) NOT NULL Storage Level 3
    15 STOR_LEVEL_4 Character(4) VARCHAR2(4) NOT NULL Storage Level 4
    16 CONTAINER_ID Character(10) VARCHAR2(10) NOT NULL Container ID
    17 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
    MHR=Muti Hourly
    PER=Percentage
    SQF=Square Footage
    18 RECEIVER_ID Character(10) VARCHAR2(10) NOT NULL Receiver number
    19 RECV_LN_NBR Number(5,0) INTEGER NOT NULL Receipt Line
    20 TO_CONTAINER_ID Character(10) VARCHAR2(10) NOT NULL Container ID
    21 TO_STORAGE_AREA Character(5) VARCHAR2(5) NOT NULL Storage Area
    22 TO_STOR_LEVEL_1 Character(4) VARCHAR2(4) NOT NULL Storage Level 1
    23 TO_STOR_LEVEL_2 Character(4) VARCHAR2(4) NOT NULL Storage Level 2
    24 TO_STOR_LEVEL_3 Character(4) VARCHAR2(4) NOT NULL Storage Level 3
    25 TO_STOR_LEVEL_4 Character(4) VARCHAR2(4) NOT NULL Storage Level 4
    26 QTY Signed Number(17,4) DECIMAL(15,4) NOT NULL Quantity
    27 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
    28 PRODUCTION_ID Character(10) VARCHAR2(10) NOT NULL Production ID
    29 PRDN_AREA_CODE Character(10) VARCHAR2(10) NOT NULL Production Area
    30 COMPL_OP_SEQ Number(4,0) SMALLINT NOT NULL Completion Operation Sequence
    31 UPDATE_OP_SEQ Number(4,0) SMALLINT NOT NULL Back Thru Operation
    32 PICK_BATCH_ID Number(10,0) DECIMAL(10) NOT NULL Pick Batch ID
    33 PICKLIST_LINE_NO Number(7,0) INTEGER NOT NULL Pick List Sorting Line Number
    34 COMPONENT_ID Character(18) VARCHAR2(18) NOT NULL 04/10/00 (Internet Architecture) SCC: Uppercase label Id.
    35 COMPL_QTY Signed Number(13,4) DECIMAL(11,4) NOT NULL Completed Qty
    36 SCRAPPED_QTY Signed Number(13,4) DECIMAL(11,4) NOT NULL Scrapped Qty
    37 REASON_CD Character(10) VARCHAR2(10) NOT NULL Reason Code
    38 PERCENT_COMP Number(6,2) DECIMAL(5,2) NOT NULL Scrap Prdn Pct
    39 DISTRIB_TYPE Character(10) VARCHAR2(10) NOT NULL Distrib. Type
    40 TO_PRODUCTION_ID Character(10) VARCHAR2(10) NOT NULL To Production ID
    41 PTWY_PLAN_ID Number(10,0) DECIMAL(10) NOT NULL Putaway Plan ID
    42 PTWYPLAN_LN_NBR Number(10,0) DECIMAL(10) NOT NULL Putaway Line Number
    43 SHIP_CNTR_ID Character(20) VARCHAR2(20) NOT NULL Shipping Container ID
    44 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
    45 SOURCE_BUS_UNIT Character(5) VARCHAR2(5) NOT NULL Source Bus Unit
    46 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
    47 ORDER_INT_LINE_NO Number(5,0) INTEGER NOT NULL Order Line
    48 SCHED_LINE_NBR Number(6,0) INTEGER NOT NULL Schedule Line Number
    49 DEMAND_LINE_NO Number(4,0) SMALLINT NOT NULL Demand Line No
    50 QTY_CODE Character(3) VARCHAR2(3) NOT NULL Per
    ASY=Assembly
    ORD=Order
    51 OP_SEQUENCE Number(4,0) SMALLINT NOT NULL Operation Sequence
    52 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
    53 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
    54 REVISION Character(4) VARCHAR2(4) NOT NULL 01/27/2000 RML Added "As of" label
    55 DEVICE_DTTIME DateTime(26) TIMESTAMP Device Date Time
    56 UOM_ORIG Character(3) VARCHAR2(3) NOT NULL Original Unit of Measure
    57 ORIG_CONSUMED_QTY Signed Number(13,4) DECIMAL(11,4) NOT NULL Original Consumed Quantity
    58 ORIG_COMP_LOSS_QTY Signed Number(13,4) DECIMAL(11,4) NOT NULL Original Component Loss Qty
    59 YIELD_QTY Number(12,4) DECIMAL(11,4) NOT NULL 10/12/99 SCC CN#SF800-9.0: Added label id TO_YIELD_QTY
    60 SHIPTO_SETID Character(5) VARCHAR2(5) NOT NULL ShipTo SetID
    61 SHIPTO_ID Character(10) VARCHAR2(10) NOT NULL Ship To Location
    62 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
    63 SHIPMENT_NO Character(30) VARCHAR2(30) NOT NULL Shipment Number
    64 CARRIER_ID Character(10) VARCHAR2(10) NOT NULL Carrier ID
    65 BILL_OF_LADING Character(30) VARCHAR2(30) NOT NULL Specifies a bill of lading number associated with a Receivables item.
    66 BUSINESS_UNIT_PO Character(5) VARCHAR2(5) NOT NULL PO Business Unit
    67 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
    68 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
    69 END_TRANS_FLG Character(1) VARCHAR2(1) NOT NULL End of Transaction Flag
    70 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
    71 DOCUMENT_ID Character(12) VARCHAR2(12) NOT NULL Document
    72 EIP_TRANS_SRC_SEQ Number(15,0) DECIMAL(15) NOT NULL Source Transaction Sequence
    73 PACKSLIP_NO Character(22) VARCHAR2(22) NOT NULL Packing Slip Number
    74 BUSINESS_UNIT_IN Character(5) VARCHAR2(5) NOT NULL Inventory Unit
    75 INTERUNIT_ID Character(10) VARCHAR2(10) NOT NULL InterUnit Order ID
    76 INTERUNIT_LINE Number(5,0) INTEGER NOT NULL InterUnit Order Line
    77 CONFIG_CODE Character(50) VARCHAR2(50) NOT NULL Product Configurator
    78 UNIT_MEASURE_COUNT Character(3) VARCHAR2(3) NOT NULL Unit of Measure
    79 SHIP_ID Character(10) VARCHAR2(10) NOT NULL Shipping ID
    80 SHIP_LINE_NO Number(10,2) DECIMAL(9,2) NOT NULL Ship Line No
    81 SHIP_DATE Date(10) DATE Item Shipping Date
    82 SHIP_TIME Time(15) TIMESTAMP Ship Time
    83 SHIP_TYPE_ID Character(10) VARCHAR2(10) NOT NULL Ship Via Code
    84 FREIGHT_TERMS Character(10) VARCHAR2(10) NOT NULL Freight Terms Code
    85 PRO_NUMBER Character(40) VARCHAR2(40) NOT NULL Pro Number
    86 SHIP_FLAG Character(1) VARCHAR2(1) NOT NULL Shippable
    87 BOM_CODE Number(2,0) SMALLINT NOT NULL CN# EN800-3.0, anna 09/21 added new field to database
    88 RTG_CODE Number(2,0) SMALLINT NOT NULL Routing Code
    89 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.
    90 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.
    91 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.
    92 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
    93 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.
    94 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).
    95 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.
    96 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.
    97 MG_UNPLAN_OUTPUT Character(1) VARCHAR2(1) NOT NULL 01/19/99 nas (CN#800-6.0) Created new field.
    98 MG_TRANS_UOM Character(3) VARCHAR2(3) NOT NULL 01/19/99 NAS (CN#800-6.0) Created new field
    99 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
    100 MG_RELATED_TRANS Character(25) VARCHAR2(25) NOT NULL Related Transaction Control Id
    101 CREW_RPT_FLAG Character(1) VARCHAR2(1) NOT NULL Crew Reporting
    102 MACH_RPT_FLAG Character(1) VARCHAR2(1) NOT NULL Machine Reporting
    103 CREWSIZE Number(7,2) DECIMAL(6,2) NOT NULL Crew Size
    104 MACH_RESOURCES Number(7,2) DECIMAL(6,2) NOT NULL Machine Resources
    105 LAB_SETUP Signed Number(10,2) DECIMAL(8,2) NOT NULL Labor Setup
    106 LAB_RUN Signed Number(10,2) DECIMAL(8,2) NOT NULL Labor Run
    107 LAB_FIXED_RUN Signed Number(10,2) DECIMAL(8,2) NOT NULL Labor Fixed Run
    108 LAB_POSTPROD Signed Number(10,2) DECIMAL(8,2) NOT NULL Labor Post Production
    109 MACH_SETUP Signed Number(10,2) DECIMAL(8,2) NOT NULL Machine Setup
    110 MACH_RUN Signed Number(10,2) DECIMAL(8,2) NOT NULL Machine Run
    111 MACH_FIXED_RUN Signed Number(10,2) DECIMAL(8,2) NOT NULL Machine Fixed Run
    112 MACH_POSTPROD Signed Number(10,2) DECIMAL(8,2) NOT NULL Machine Post Production
    113 WORK_CENTER_CODE Character(10) VARCHAR2(10) NOT NULL Work Center
    114 SF_ENTRY_DATE Date(10) DATE Entry Date
    115 MG_ORIG_COMP_ID Character(18) VARCHAR2(18) NOT NULL original component ID
    116 MG_ORIG_QTY_PER Number(16,10) DECIMAL(15,10) NOT NULL original qty per
    117 PARENT_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Parent Item ID
    118 SUB_ITM_ID Character(18) VARCHAR2(18) NOT NULL 11/30/99 RML Added label "Substitute"
    119 VENDOR_LOT_ID Character(15) VARCHAR2(15) NOT NULL Vendor Lot
    120 TAG_NUMBER Character(12) VARCHAR2(12) NOT NULL Tag Number
    121 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.

    Y/N Table Edit

    122 INV_CART_ID Character(15) VARCHAR2(15) NOT NULL Par Location ID
    123 COMPARTMENT Character(10) VARCHAR2(10) NOT NULL Compartment
    124 COUNT_ORDER Signed Number(5,0) DECIMAL(4) NOT NULL Par Location Count Order
    125 CART_COUNT_QTY Signed Number(17,4) DECIMAL(15,4) NOT NULL Par Location Count Quantity
    126 QTY_OPTION Character(2) VARCHAR2(2) NOT NULL Qty Option
    01=Count Qty
    02=Request Qty
    127 SUFFICIENT_STOCK Character(1) VARCHAR2(1) NOT NULL Sufficient Stock
    N=NOT SUFFICIENT STOCK
    Y=SUFFICIENT STOCK
    128 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
    129 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
    130 SPEEDTYPE_KEY Character(10) VARCHAR2(10) NOT NULL SpeedType Key
    131 RTV_ID Character(10) VARCHAR2(10) NOT NULL Return To Vendor ID
    132 RTV_LN_NBR Number(5,0) INTEGER NOT NULL Return To Vendor Line
    133 RTV_DISTRIB_NUM Number(5,0) INTEGER NOT NULL RTV Distribution Number
    134 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
    135 COUNTING_EVENT_ID Number(15,0) DECIMAL(15) NOT NULL Counting Event ID
    136 PORT_OF_UNLOADING Character(10) VARCHAR2(10) NOT NULL Port Of Unloading
    137 IST_RETURN_FLG_IUT Character(1) VARCHAR2(1) NOT NULL Intrastat InterUnit Returns

    Y/N Table Edit

    138 REPLACEMENT_FLG Character(2) VARCHAR2(2) NOT NULL Replacement Flag
    NA=Not Applicable
    RN=Replace Goods Not Returned
    RR=Replacement of Returned Goods
    139 PARENT_SHIP_CNTR Character(20) VARCHAR2(20) NOT NULL Parent Shipping Container ID
    140 SF_KANBAN_ID Character(15) VARCHAR2(15) NOT NULL Kanban ID
    141 FREIGHT_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Freight Amount
    142 FREIGHT_CURRNCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
    143 GROSS_WEIGHT Signed Number(17,4) DECIMAL(15,4) NOT NULL Shipping Weight
    144 UNIT_MEASURE_WT Character(3) VARCHAR2(3) NOT NULL Weight UOM
    145 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location
    146 LOCATION_ID Character(3) VARCHAR2(3) NOT NULL Location ID
    147 SHIP_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Ship To Customer
    148 LOAD_ID Character(10) VARCHAR2(10) NOT NULL Load ID
    149 PICK_BATCH_FROM Number(10,0) DECIMAL(10) NOT NULL From Pick Batch ID
    150 PICK_BATCH_TO Number(10,0) DECIMAL(10) NOT NULL To Pick Batch ID
    151 ROUTE_CD Character(6) VARCHAR2(6) NOT NULL A unique identifier assigned to a delivery route. Route codes can be associated with customer addresses for external orders or locations for internal orders. Route codes can be used to identify the appropriate delivery schedule for a customer/location if you are managing product shipments with your own vehicles.
    152 WAVE_CD Character(6) VARCHAR2(6) NOT NULL A unique identifier used to group together one or more delivery route codes.
    153 TO_BILL_OF_LADING Character(30) VARCHAR2(30) NOT NULL Specifies a bill of lading number associated with a Receivables item.
    154 TO_CARRIER_ID Character(10) VARCHAR2(10) NOT NULL Carrier selection
    155 TO_FREIGHT_TERMS Character(10) VARCHAR2(10) NOT NULL Freight Terms Code
    156 TO_PRO_NUMBER Character(30) VARCHAR2(30) NOT NULL Pro Number
    157 TO_SHIP_TYPE_ID Character(10) VARCHAR2(10) NOT NULL Ship Via selection
    158 DO_NOT_SHIP_FLAG Character(1) VARCHAR2(1) NOT NULL Do Not Ship
    N=Ship
    Y=Do Not Ship
    159 UNIT_MEASURE_SHIP Character(3) VARCHAR2(3) NOT NULL Shipment Unit of Measure
    160 SHORT_SHIP_OPT Character(2) VARCHAR2(2) NOT NULL Short Shipment Option
    01=Scrap the Undershipment
    02=Return to Location Picked From
    161 BCKORDR_CNCL_FLAG Character(1) VARCHAR2(1) NOT NULL Cancel Backorder
    N=Cancel Backorder No
    Y=Cancel Backorder Yes
    162 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code
    163 LOG_ERROR_OPTION Character(2) VARCHAR2(2) NOT NULL Log Errors Option
    BT=Transaction Error Log
    ML=Message Log
    164 UNIT_MEASURE_PICK Character(3) VARCHAR2(3) NOT NULL Phys Location Unit of Measure
    165 COMP_SERIAL_ID Character(20) VARCHAR2(20) NOT NULL Serial ID
    166 COMP_LOT_ID Character(15) VARCHAR2(15) NOT NULL Component Lot ID
    167 NEW_SERIAL Character(20) VARCHAR2(20) NOT NULL New Serial ID mmt 09/18/03 Adding label for use on mult out compl wedge
    168 MG_SHIFT Number(2,0) SMALLINT NOT NULL MG_SHIFT represents the shift code (i.e., 1, 2, 3, etc) for a manufacturing shift. 07/23/98 TKI CN#MG800-5.0 Created to replace SHIFT for the database reconcilation project (8.0)
    1=1
    2=2
    3=3
    C=Compressed
    N=Not Applicable
    R=Rotating