INV_FUL_DTL_VW

(SQL View)
 Index Back

Fulfillment Request Details

Stage record containing detail information within a fulfillment request group (such as a line on an order). /* 06/09/2004 pwf Change reference from SCHED_LINE_NO to SCHED_LINE_NBR */

SELECT A.BUSINESS_UNIT , A.EIP_CTL_ID , A.GRP_SEQ_NBR , A.DTL_SEQ_NBR , A.BCT_DET_STATUS , A.EIP_TRANS_SRC_SEQ , A.DEVICE_DTTIME , A.EXCLUDE_FLG , A.SELECT_UNFULFILLED , A.SELECT_RELEASABLE , A.SELECT_RELEASED , A.SELECT_CONFIRMED , A.SL_DEMAND_SOURCE , A.SL_SOURCE_BUS_UNIT , A.SL_ORDER_NO , A.TO_ORDER_NO , A.SL_ORDER_INT_LINE , A.TO_ORDER_INT_LINE , A.SL_SCHED_LINE_NBR , A.TO_SCHED_LINE_NBR , A.SL_INV_ITEM_ID , A.SL_DEMAND_LINE_NO , A.SL_SHIP_TO_CUST_ID , A.SL_CUST_ID , A.SL_ADDRESS_SEQ_NUM , A.SL_LOCATION , A.SL_LOAD_ID , A.SL_SHIP_TYPE_ID , A.TO_SHIP_TYPE_ID , A.SL_CARRIER_ID , A.TO_CARRIER_ID , A.SL_ROUTE_CD , A.SL_WAVE_CD , A.TO_WAVE_CD , A.SL_PRODUCT_ID , A.SL_PARENT_PROD_ID , A.SL_DEMAND_DATE , A.TO_DEMAND_DATE , A.SL_SCHED_SHIP_DATE , A.SL_SCHED_SHIP_TIME , A.TO_SCHED_SHIP_DATE , A.TO_SCHED_SHIP_TIME , A.SL_SHIP_EARLY_DATE , A.SL_SHIP_EARLY_TIME , A.TO_SHIP_EARLY_DATE , A.TO_SHIP_EARLY_TIME , A.SL_SHIP_ID , A.SL_CUSTOMER_PO , A.SL_CNTRCT_ID , A.SL_PICK_BATCH_ID , A.TO_PICK_BATCH_ID , A.SL_PICKLIST_LINE , A.TO_PICKLIST_LINE , A.SL_SHIP_CNTR_ID , A.SL_TMS_EXT_REF_ID , A.SL_TMS_EXT_REF_LN , A.SL_EXT_REF_NBR , A.SL_EXT_REF_LN_NBR , A.SL_PRIORITY_NBR , A.TO_PRIORITY_NBR , A.SL_DELIVERY_ID , A.TO_DELIVERY_ID , A.AUTO_PICK_SEL , A.AUTO_SHIP_SEL , A.QTY , A.UNIT_OF_MEASURE , A.STORAGE_AREA , A.STOR_LEVEL_1 , A.STOR_LEVEL_2 , A.STOR_LEVEL_3 , A.STOR_LEVEL_4 , A.PRO_NUMBER , A.PRO_NUMBER_FLG , A.TRACKING_NBR , A.TRACKING_NBR_FLG , A.SHORT_SHIP_OPT , A.FREIGHT_CALC_FLAG , A.FREIGHT_AMT , A.FREIGHT_AMT_FLG , A.FREIGHT_TERMS , A.CARRIER_ID , A.CARRIER_ID_FLG , A.SHIP_ID , A.SHIP_DATE , A.SHIP_TIME , A.SHIP_TYPE_ID , A.SHIP_CNTR_ID , A.COMPLETE_FLG , A.IN_DFR_DPL_OVRD , A.ORDER_INT_LINE_NO , A.SCHED_LINE_NBR , A.INV_ITEM_ID , A.DEMAND_DATE , A.REQUEST_DATE , A.SCHED_DATE , A.SCHED_TIME , A.LOAD_ID , A.SHIP_EARLY_DATE , A.SHIP_EARLY_TIME , A.SHIP_LATE_DATE , A.SHIP_LATE_TIME , A.SCHED_ARRV_DATE , A.SCHED_ARRV_TIME , A.PRIORITY_NBR , A.DISTRIB_TYPE , A.CHARGE_FLAG , A.FERC_CD , A.PRICE_MARKUP_PCT , A.TRANSFER_CALC_TYPE , A.LOCATION , A.CUST_ID , A.CUST_NAME , A.SHIP_TO_CUST_ID , A.SHIP_CUST_NAME1 , A.ADDRESS_SEQ_NUM , A.TRANSFER_COST , A.PACKAGING_CD , A.BCKORDR_CNCL_FLAG , A.PARTIAL_QTY_FLAG , A.IN_LINE_BO_RULE , A.IN_LINE_RESV_RULE , A.IN_LN_RESV_BO_RULE , A.IN_ORDER_RESV_RULE , A.CONFIG_CODE , A.DIRECT_INVOICING , A.BUSINESS_UNIT_PO , A.RTV_ID , A.RTV_LN_NBR , A.RTV_DISTRIB_NUM , A.HOLD_FLAG , A.HOLD_CD , A.ROUTE_CD , A.REPLACEMENT_FLG , A.IST_RETURN_FLG_IUT , A.REASON_CD , A.DELIVERY_ID , %subrec(IN_DMD_USER_SBR, A) FROM %Table(INV_FUL_DTL_EC) A

  • Parent record: INV_FUL_GRP_EC

    • # 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 GRP_SEQ_NBR Number(10,0) DECIMAL(10) NOT NULL Sequence used to uniquely identify a row in the Fulfillment Group stage table.
    4 DTL_SEQ_NBR Number(10,0) DECIMAL(10) NOT NULL Sequence used to uniquely identify a row in the Fulfillment Details stage table.
    5 BCT_DET_STATUS Character(1) VARCHAR2(1) NOT NULL BCTP Detail Status
    0=Open
    1=Error
    2=Complete
    3=Cancel

    Default Value: 0

    6 EIP_TRANS_SRC_SEQ Number(15,0) DECIMAL(15) NOT NULL Source Transaction Sequence
    7 DEVICE_DTTIME DateTime(26) TIMESTAMP Device Date Time

    Default Value: %DateTime

    8 EXCLUDE_FLG Character(1) VARCHAR2(1) NOT NULL Indicates a line of a request fed to the Fulfillment Engine should be excluded from the selection instead of included.

    Y/N Table Edit

    Default Value: N

    9 SELECT_UNFULFILLED Character(1) VARCHAR2(1) NOT NULL Indicates requests fed to the Fulfillment Engine should include data in an unfulfilled state.

    Y/N Table Edit

    Default Value: N

    10 SELECT_RELEASABLE Character(1) VARCHAR2(1) NOT NULL Indicates requests fed to the Fulfillment Engine should include data in a releasable state.

    Y/N Table Edit

    Default Value: N

    11 SELECT_RELEASED Character(1) VARCHAR2(1) NOT NULL Indicates requests fed to the Fulfillment Engine should include data in an Released state.

    Y/N Table Edit

    Default Value: N

    12 SELECT_CONFIRMED Character(1) VARCHAR2(1) NOT NULL Indicates requests fed to the Fulfillment Engine should include data in a confirmed state.

    Y/N Table Edit

    Default Value: N

    13 SL_DEMAND_SOURCE Character(2) VARCHAR2(2) NOT NULL Demand Source selection
    IN=Material Request
    OM=Sales Order
    PL=Planning Requisition
    PO=Sourced Demand
    PR=Purchasing Requisition
    RT=Material Return
    SF=Production Request
    WM=Work Order Demand
    14 SL_SOURCE_BUS_UNIT Character(5) VARCHAR2(5) NOT NULL Source Business Unit selection

    Prompt Table: SP_BU_FS_NONVW

    15 SL_ORDER_NO Character(10) VARCHAR2(10) NOT NULL Order Number selection

    Prompt Table: %EDITTABLE10

    16 TO_ORDER_NO Character(10) VARCHAR2(10) NOT NULL Order Number selection

    Prompt Table: %EDITTABLE10

    17 SL_ORDER_INT_LINE Number(5,0) INTEGER NOT NULL Order Line selection

    Prompt Table: %EDITTABLE11

    18 TO_ORDER_INT_LINE Number(5,0) INTEGER NOT NULL Order Line selection

    Prompt Table: %EDITTABLE11

    19 SL_SCHED_LINE_NBR Number(6,0) INTEGER NOT NULL 05/07/04 PWF Added field for new 8.9 data model changes

    Prompt Table: %EDITTABLE12

    20 TO_SCHED_LINE_NBR Number(6,0) INTEGER NOT NULL 05/07/04 PWF Added field for 8.9 data model changes

    Prompt Table: %EDITTABLE12

    21 SL_INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item selection

    Prompt Table: %EDITTABLE22

    22 SL_DEMAND_LINE_NO Number(4,0) SMALLINT NOT NULL Demand Line Number selection

    Prompt Table: %EDITTABLE13

    23 SL_SHIP_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Ship To Customer selection

    Prompt Table: INV_CST_SHP_VW

    24 SL_CUST_ID Character(15) VARCHAR2(15) NOT NULL Customer ID selection

    Prompt Table: INV_CUST_SLD_VW

    25 SL_ADDRESS_SEQ_NUM Number(5,0) INTEGER NOT NULL Address Sequence Number selection

    Prompt Table: INV_CST_ADDR_VW

    26 SL_LOCATION Character(10) VARCHAR2(10) NOT NULL Location selection

    Prompt Table: LOCATION_VW

    27 SL_LOAD_ID Character(10) VARCHAR2(10) NOT NULL Load selection

    Prompt Table: INRSV_DMDLOD_VW

    28 SL_SHIP_TYPE_ID Character(10) VARCHAR2(10) NOT NULL Ship Via selection

    Prompt Table: SHIP_METHOD_VW

    29 TO_SHIP_TYPE_ID Character(10) VARCHAR2(10) NOT NULL Ship Via selection

    Prompt Table: SHIP_METHOD_VW

    30 SL_CARRIER_ID Character(10) VARCHAR2(10) NOT NULL Carrier selection

    Prompt Table: CARRIER_VW

    31 TO_CARRIER_ID Character(10) VARCHAR2(10) NOT NULL Carrier selection

    Prompt Table: CARRIER_VW

    32 SL_ROUTE_CD Character(6) VARCHAR2(6) NOT NULL Route selection

    Prompt Table: INRSV_DMDRT_VW

    33 SL_WAVE_CD Character(6) VARCHAR2(6) NOT NULL Route Group selection

    Prompt Table: INFUL_DMDWAV_VW

    34 TO_WAVE_CD Character(6) VARCHAR2(6) NOT NULL Route Group selection

    Prompt Table: INFUL_DMDWAV_VW

    35 SL_PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product selection
    36 SL_PARENT_PROD_ID Character(18) VARCHAR2(18) NOT NULL Parent Product Id
    37 SL_DEMAND_DATE Date(10) DATE Demand Date selection
    38 TO_DEMAND_DATE Date(10) DATE Demand Date selection
    39 SL_SCHED_SHIP_DATE Date(10) DATE Scheduled Ship Date selection
    40 SL_SCHED_SHIP_TIME Time(15) TIMESTAMP Scheduled Ship Time
    41 TO_SCHED_SHIP_DATE Date(10) DATE Scheduled Ship Date selection
    42 TO_SCHED_SHIP_TIME Time(15) TIMESTAMP Scheduled Ship Time selection
    43 SL_SHIP_EARLY_DATE Date(10) DATE Ship Early Date selection
    44 SL_SHIP_EARLY_TIME Time(15) TIMESTAMP Ship Early Time selection
    45 TO_SHIP_EARLY_DATE Date(10) DATE Ship Early Date selection
    46 TO_SHIP_EARLY_TIME Time(15) TIMESTAMP Ship Early Time selection
    47 SL_SHIP_ID Character(10) VARCHAR2(10) NOT NULL Ship ID Selection

    Prompt Table: INFUL_DMDSID_VW

    48 SL_CUSTOMER_PO Character(25) VARCHAR2(25) NOT NULL Customer Purchase Order selection
    49 SL_CNTRCT_ID Character(25) VARCHAR2(25) NOT NULL Contract ID selection
    50 SL_PICK_BATCH_ID Number(10,0) DECIMAL(10) NOT NULL Pick Batch ID selection

    Prompt Table: %EDITTABLE14

    51 TO_PICK_BATCH_ID Number(10,0) DECIMAL(10) NOT NULL Pick Batch ID selection

    Prompt Table: %EDITTABLE15

    52 SL_PICKLIST_LINE Number(7,0) INTEGER NOT NULL Pick List Line Number selection

    Prompt Table: %EDITTABLE16

    53 TO_PICKLIST_LINE Number(7,0) INTEGER NOT NULL Pick List Line Number selection

    Prompt Table: %EDITTABLE17

    54 SL_SHIP_CNTR_ID Character(20) VARCHAR2(20) NOT NULL Ship Container selection

    Prompt Table: SHIP_CNTR_ID_VW

    55 SL_TMS_EXT_REF_ID Character(10) VARCHAR2(10) NOT NULL Transportation Management System (TMS) Reference ID selection

    Prompt Table: %EDITTABLE18

    56 SL_TMS_EXT_REF_LN Number(7,0) INTEGER NOT NULL Transportation Management System (TMS) Reference Line

    Prompt Table: %EDITTABLE19

    57 SL_EXT_REF_NBR Number(10,0) DECIMAL(10) NOT NULL External Reference Number selection

    Prompt Table: %EDITTABLE20

    58 SL_EXT_REF_LN_NBR Number(5,0) INTEGER NOT NULL External Reference Line selection

    Prompt Table: %EDITTABLE21

    59 SL_PRIORITY_NBR Number(3,0) SMALLINT NOT NULL Priority
    60 TO_PRIORITY_NBR Number(3,0) SMALLINT NOT NULL Priority
    61 SL_DELIVERY_ID Character(15) VARCHAR2(15) NOT NULL From Delivery ID
    62 TO_DELIVERY_ID Character(15) VARCHAR2(15) NOT NULL To Delivery ID
    63 AUTO_PICK_SEL Character(1) VARCHAR2(1) NOT NULL The field is used to select the auto pick options for fulfillment.
    0=Use Default Values
    1=Override to "Yes"
    2=Override to "No"

    Default Value: 0

    64 AUTO_SHIP_SEL Character(1) VARCHAR2(1) NOT NULL Used to capture the auto ship options for fulfillment.
    0=Use Default Values
    1=Override to "Yes"
    2=Override to "No"

    Default Value: 0

    65 QTY Signed Number(17,4) DECIMAL(15,4) NOT NULL Quantity
    66 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
    MHR=Muti Hourly
    PER=Percentage
    SQF=Square Footage

    Prompt Table: %EDITTABLE23
    Set Control Field: SETID

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

    Prompt Table: STOR_AREA_VW2

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

    Prompt Table: STOR_LEV1_VW2

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

    Prompt Table: STOR_LEV2_VW2

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

    Prompt Table: STOR_LEV3_VW2

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

    Prompt Table: STOR_LEV4_VW2

    72 PRO_NUMBER Character(40) VARCHAR2(40) NOT NULL Pro Number
    73 PRO_NUMBER_FLG Character(1) VARCHAR2(1) NOT NULL Indicates Pro Number should be overridden with a blank value

    Y/N Table Edit

    Default Value: N

    74 TRACKING_NBR Character(30) VARCHAR2(30) NOT NULL Tracking Number
    75 TRACKING_NBR_FLG Character(1) VARCHAR2(1) NOT NULL Clear Tracking Number

    Y/N Table Edit

    Default Value: N

    76 SHORT_SHIP_OPT Character(2) VARCHAR2(2) NOT NULL Short Shipment Option
    01=Scrap the Undershipment
    02=Return to Location Picked From

    Default Value: 02

    77 FREIGHT_CALC_FLAG Character(1) VARCHAR2(1) NOT NULL Freight Calculate Flag

    Y/N Table Edit

    Default Value: N

    78 FREIGHT_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Freight Amount
    79 FREIGHT_AMT_FLG Character(1) VARCHAR2(1) NOT NULL Indicates Freight Amount should be overridden with a blank (zero) value
    80 FREIGHT_TERMS Character(10) VARCHAR2(10) NOT NULL Freight Terms Code

    Prompt Table: FREIGHT_TERMS

    81 CARRIER_ID Character(10) VARCHAR2(10) NOT NULL Carrier ID

    Prompt Table: CARRIER_VW

    82 CARRIER_ID_FLG Character(1) VARCHAR2(1) NOT NULL Indicates Carrier ID should be overridden with a blank value
    83 SHIP_ID Character(10) VARCHAR2(10) NOT NULL Shipping ID
    84 SHIP_DATE Date(10) DATE Item Shipping Date
    85 SHIP_TIME Time(15) TIMESTAMP Ship Time
    86 SHIP_TYPE_ID Character(10) VARCHAR2(10) NOT NULL Ship Via Code

    Prompt Table: SHIP_METHOD_VW

    87 SHIP_CNTR_ID Character(20) VARCHAR2(20) NOT NULL Shipping Container ID
    88 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

    Prompt Table: BCT_CDTL_INV_VW

    89 IN_DFR_DPL_OVRD Character(1) VARCHAR2(1) NOT NULL used to override the defer depletions field on in_demand
    1=Override to Yes
    2=Override to No
    90 ORDER_INT_LINE_NO Number(5,0) INTEGER NOT NULL Order Line
    91 SCHED_LINE_NBR Number(6,0) INTEGER NOT NULL Schedule Line Number
    92 INV_ITEM_ID2 Character(18) VARCHAR2(18) NOT NULL Item ID

    Prompt Table: %EDITTABLE24

    93 DEMAND_DATE Date(10) DATE Demand Date
    94 REQUEST_DATE Date(10) DATE Requested
    95 SCHED_DATE Date(10) DATE Schedule Date
    96 SCHED_TIME Time(15) TIMESTAMP Schedule Time
    97 LOAD_ID Character(10) VARCHAR2(10) NOT NULL Load ID

    Prompt Table: LOAD_INV_OPN_VW

    98 SHIP_EARLY_DATE Date(10) DATE Earliest Ship Date
    99 SHIP_EARLY_TIME Time(15) TIMESTAMP Earliest Ship Time
    100 SHIP_LATE_DATE Date(10) DATE Latest Ship Date
    101 SHIP_LATE_TIME Time(15) TIMESTAMP Latest Ship Time
    102 SCHED_ARRV_DATE Date(10) DATE Scheduled Arrival Date
    103 SCHED_ARRV_TIME Time(15) TIMESTAMP Scheduled Arrival Time
    104 PRIORITY_NBR Number(3,0) SMALLINT NOT NULL Priority
    105 DISTRIB_TYPE Character(10) VARCHAR2(10) NOT NULL Distrib. Type

    Prompt Table: CM_DISTR_TYPE

    106 CHARGE_FLAG Character(1) VARCHAR2(1) NOT NULL Charged Out

    Y/N Table Edit

    107 FERC_CD Character(10) VARCHAR2(10) NOT NULL FERC Code

    Prompt Table: FERC_CD_TBL

    108 PRICE_MARKUP_PCT Signed Number(16,2) DECIMAL(14,2) NOT NULL Price Markup %
    109 TRANSFER_CALC_TYPE Character(1) VARCHAR2(1) NOT NULL Holds information regarding when the transfer price is calculated.
    0=Calculate Cost at Depletions
    1=Transfer at Zero Cost
    110 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code

    Prompt Table: %EDITTABLE25

    111 CUST_ID Character(15) VARCHAR2(15) NOT NULL Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.

    Prompt Table: %EDITTABLE26

    112 CUST_NAME Character(40) VARCHAR2(40) NOT NULL Name
    113 SHIP_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Ship To Customer

    Prompt Table: %EDITTABLE27

    114 SHIP_CUST_NAME1 Character(40) VARCHAR2(40) NOT NULL Ship To Name
    115 ADDRESS_SEQ_NUM Number(5,0) INTEGER NOT NULL Address Sequence Number

    Prompt Table: INV_CST_ADR2_VW

    116 TRANSFER_COST Signed Number(16,4) DECIMAL(14,4) NOT NULL Transfer Price
    117 PACKAGING_CD Character(4) VARCHAR2(4) NOT NULL Packaging Code

    Prompt Table: PACKAGNG_CD_INV

    118 BCKORDR_CNCL_FLAG Character(1) VARCHAR2(1) NOT NULL Cancel Backorder
    N=Cancel Backorder No
    Y=Cancel Backorder Yes
    119 PARTIAL_QTY_FLAG Character(1) VARCHAR2(1) NOT NULL Partial Qtys Can Ship

    Y/N Table Edit

    120 IN_LINE_BO_RULE Character(10) VARCHAR2(10) NOT NULL Line Backorder Rule

    Prompt Table: IN_RULE_B_VW

    121 IN_LINE_RESV_RULE Character(10) VARCHAR2(10) NOT NULL Line Reservation Rule

    Prompt Table: IN_RULE_R_VW

    122 IN_LN_RESV_BO_RULE Character(10) VARCHAR2(10) NOT NULL Line Reservation - Backorder

    Prompt Table: IN_RULE_R_VW

    123 IN_ORDER_RESV_RULE Character(10) VARCHAR2(10) NOT NULL Order Reservation Rule

    Prompt Table: IN_RULE_O_VW

    124 CONFIG_CODE Character(50) VARCHAR2(50) NOT NULL Product Configurator

    Prompt Table: CP_CONFIG_VW

    125 DIRECT_INVOICING Character(1) VARCHAR2(1) NOT NULL Direct Invoicing

    Y/N Table Edit

    126 BUSINESS_UNIT_PO Character(5) VARCHAR2(5) NOT NULL PO Business Unit

    Prompt Table: SP_BU_PM_NONVW

    127 RTV_ID Character(10) VARCHAR2(10) NOT NULL Return To Vendor ID

    Prompt Table: RTV_HDR_INV_VW2

    128 RTV_LN_NBR Number(5,0) INTEGER NOT NULL Return To Vendor Line

    Prompt Table: RTV_LN_INV_VW2

    129 RTV_DISTRIB_NUM Number(5,0) INTEGER NOT NULL RTV Distribution Number

    Prompt Table: RTV_DST_INV_VW2

    130 HOLD_FLAG Character(1) VARCHAR2(1) NOT NULL Hold
    N=Hold
    Y=Hold
    131 HOLD_CD Character(6) VARCHAR2(6) NOT NULL Hold Code

    Prompt Table: HOLD_CD

    132 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.

    Prompt Table: ROUTE_INV_VW

    133 REPLACEMENT_FLG Character(2) VARCHAR2(2) NOT NULL Replacement Flag
    NA=Not Applicable
    RN=Replace Goods Not Returned
    RR=Replacement of Returned Goods
    134 IST_RETURN_FLG_IUT Character(1) VARCHAR2(1) NOT NULL Intrastat InterUnit Returns

    Y/N Table Edit

    135 REASON_CD Character(10) VARCHAR2(10) NOT NULL Reason Code

    Prompt Table: REASON_SHIP_VW

    136 DELIVERY_ID Character(10) VARCHAR2(10) NOT NULL Delivery ID
    137 LINE_FIELD_C1_A Character(1) VARCHAR2(1) NOT NULL User Defined C1 A
    138 LINE_FIELD_C1_B Character(1) VARCHAR2(1) NOT NULL User Defined C1 B
    139 LINE_FIELD_C1_C Character(1) VARCHAR2(1) NOT NULL User Defined C1 C
    140 LINE_FIELD_C1_D Character(1) VARCHAR2(1) NOT NULL User Defined C1 D
    141 LINE_FIELD_C2 Character(2) VARCHAR2(2) NOT NULL User Defined C2
    142 LINE_FIELD_C4 Character(4) VARCHAR2(4) NOT NULL User Defined C4
    143 LINE_FIELD_C6 Character(6) VARCHAR2(6) NOT NULL User Defined C6
    144 LINE_FIELD_C8 Character(8) VARCHAR2(8) NOT NULL User Defined C8
    145 LINE_FIELD_C10_A Character(10) VARCHAR2(10) NOT NULL User Defined C10 A
    146 LINE_FIELD_C10_B Character(10) VARCHAR2(10) NOT NULL User Defined C10 B
    147 LINE_FIELD_C10_C Character(10) VARCHAR2(10) NOT NULL User Defined C10 C
    148 LINE_FIELD_C10_D Character(10) VARCHAR2(10) NOT NULL Line Fld C10 D
    149 LINE_FIELD_C30_A Character(30) VARCHAR2(30) NOT NULL User Defined C30 A
    150 LINE_FIELD_C30_B Character(30) VARCHAR2(30) NOT NULL User Defined C30 B
    151 LINE_FIELD_C30_C Character(30) VARCHAR2(30) NOT NULL User Defined C30 C
    152 LINE_FIELD_C30_D Character(30) VARCHAR2(30) NOT NULL User Defined C30 D
    153 LINE_FIELD_DTTM_A DateTime(26) TIMESTAMP User Defined DTTM A
    154 LINE_FIELD_DTTM_B DateTime(26) TIMESTAMP User Defined DTTM B
    155 LINE_FIELD_DTTM_C DateTime(26) TIMESTAMP User Defined DTTM C
    156 LINE_FIELD_DTTM_D DateTime(26) TIMESTAMP User Defined DTTM D
    157 LINE_FIELD_N11_A Signed Number(17,4) DECIMAL(15,4) NOT NULL User Defined N11.4 A
    158 LINE_FIELD_N11_B Signed Number(17,4) DECIMAL(15,4) NOT NULL User Defined N11.4 B
    159 LINE_FIELD_N11_C Signed Number(17,4) DECIMAL(15,4) NOT NULL User Defined N11.4 C
    160 LINE_FIELD_N11_D Signed Number(17,4) DECIMAL(15,4) NOT NULL User Defined N11.4 D
    161 LINE_FIELD_N15_A Number(15,0) DECIMAL(15) NOT NULL User Defined N15.0 A
    162 LINE_FIELD_N15_B Number(15,0) DECIMAL(15) NOT NULL User Defined N15.0 B
    163 LINE_FIELD_N15_C Number(15,0) DECIMAL(15) NOT NULL User Defined N15.0 C
    164 LINE_FIELD_N15_D Number(15,0) DECIMAL(15) NOT NULL User Defined N15.0 D