RMA_LINE

(SQL Table)
 Index Back

RMA Line

Date Initials Issue Description 01/25/01 dms SP2 (DI-EDWONG-2) Deferred processing 05/10/01 dms 7291901 RETURN_TO_IBU default 06/26/01 JJM F-FSELK-11 Proj Gemini chartfield changes 10/28/02 mpm F-CJORGENS-86 Added REF_SOURCE_CD.

  • Parent Record Of RMA_LINE_PROMO RMA_LNPRMO_TEO1 RMA_LNPRMO_TEO2 RMA_LNPRMO_TEO3 RMA_PRCADJ_DATE RMA_PRCADJ_DTL RMA_PRCADJ_FORM RMA_PRICE_ADJST

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT

    Prompt Table: SP_BU_FS_NONVW

    2 RMA_ID Character(10) VARCHAR2(10) NOT NULL RMA Number

    Prompt Table: RMA_HEADER

    3 RMA_LINE_NBR Number(5,0) INTEGER NOT NULL RMA Line Number

    Default Value: 1

    4 PROD_ID_ENTERED Character(20) VARCHAR2(20) NOT NULL Product ID Entered

    Prompt Table: %EDITTABLE10

    5 REF_BUS_UNIT_OM Character(5) VARCHAR2(5) NOT NULL Reference Order Management Business Unit
    6 REF_ORDER_NO Character(10) VARCHAR2(10) NOT NULL Referenced Order Nbr
    7 REF_LINE_NBR Number(5,0) INTEGER NOT NULL Reference Line Number
    8 PROD_ID_SRC Character(1) VARCHAR2(1) NOT NULL Product Source
    C=Customer
    P=UPC
    S=System
    U=Universal

    Default Value: CUST_SLD_OPT_VW.PROD_ID_SRC

    9 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID
    10 PROD_ID_ORDERED Character(20) VARCHAR2(20) NOT NULL Product ID Entered
    11 PROD_ID_ORD_ENT Character(20) VARCHAR2(20) NOT NULL Product ID Entered

    Prompt Table: %EDITTABLE22

    12 REF_BUS_UNIT_IN Character(5) VARCHAR2(5) NOT NULL Ref business unit IN
    13 REF_DEMD_LINE_NBR Number(4,0) SMALLINT NOT NULL Ref Demand Line Nbr
    14 REF_INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Referenced Inv Item ID
    15 REF_SCHED_NBR Number(6,0) INTEGER NOT NULL Referenced Schedule Number
    16 REF_SOURCE_CD Character(6) VARCHAR2(6) NOT NULL Reference Order Source Code
    17 ACCOUNT Character(10) VARCHAR2(10) NOT NULL Account

    Prompt Table: %EDIT_ACCOUNT

    18 ALTACCT Character(10) VARCHAR2(10) NOT NULL Alternate Account

    Prompt Table: %EDIT_ALTACCT

    19 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

    Prompt Table: DEPTID_BUGL_VW

    20 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField

    Prompt Table: SP_PROJFS_NONVW

    21 OPERATING_UNIT Character(8) VARCHAR2(8) NOT NULL Operating Unit ChartField

    Prompt Table: OPERUNT_BUGL_VW

    22 PRODUCT Character(6) VARCHAR2(6) NOT NULL Product ChartField

    Prompt Table: PRODUCT_BUGL_VW

    23 FUND_CODE Character(5) VARCHAR2(5) NOT NULL Fund Code

    Prompt Table: FUND_BUGL_VW

    24 CLASS_FLD Character(5) VARCHAR2(5) NOT NULL Class Field

    Prompt Table: CLASSCF_BUGL_VW

    25 PROGRAM_CODE Character(5) VARCHAR2(5) NOT NULL Program Code ChartField

    Prompt Table: PROGRAM_BUGL_VW

    26 BUDGET_REF Character(8) VARCHAR2(8) NOT NULL Budget Reference

    Prompt Table: BUD_REF_BUGL_VW

    27 AFFILIATE Character(5) VARCHAR2(5) NOT NULL Affiliate

    Prompt Table: AFFILIATE_VW

    28 AFFILIATE_INTRA1 Character(10) VARCHAR2(10) NOT NULL IntraUnit Affiliate1

    Prompt Table: %EDIT_INTRA01

    29 AFFILIATE_INTRA2 Character(10) VARCHAR2(10) NOT NULL Operating Unit Affiliate

    Prompt Table: %EDIT_INTRA02

    30 CHARTFIELD1 Character(10) VARCHAR2(10) NOT NULL Expansion chartfield 1

    Prompt Table: CF1_BUGL_VW

    31 CHARTFIELD2 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 2

    Prompt Table: CF2_BUGL_VW

    32 CHARTFIELD3 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 3

    Prompt Table: CF3_BUGL_VW

    33 ADDRESS_SEQ_NUM Number(5,0) INTEGER NOT NULL Address Sequence Number

    Prompt Table: %EDITTABLE8

    34 ADDR_OVRD_LEVEL Character(1) VARCHAR2(1) NOT NULL Address Override Level
    D=Demand Line
    H=Header
    L=Line
    S=Schedule
    35 BUSINESS_UNIT_OM Character(5) VARCHAR2(5) NOT NULL Order Management Business Unit
    36 CANCEL_DATE Date(10) DATE Cancel Date
    37 CANCEL_REASON Character(10) VARCHAR2(10) NOT NULL Cancel Reason

    Prompt Table: RMA_CNCLRSN_VW

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

    Prompt Table: CARRIER_ID

    39 CNTCT_SEQ_SHIP Number(5,0) INTEGER NOT NULL Primary Contact - Ship To

    Prompt Table: %EDITTABLE14

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

    Prompt Table: RMA_CPCFG_VW

    41 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
    42 CURRENCY_CD_BASE Character(3) VARCHAR2(3) NOT NULL Business Unit Base Currency
    43 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID

    Prompt Table: PROJ_ACT_FS

    44 RESOURCE_TYPE Character(5) VARCHAR2(5) NOT NULL Source Type

    Prompt Table: PROJ_RESTYPE_FS

    45 RESOURCE_CATEGORY Character(5) VARCHAR2(5) NOT NULL Category

    Prompt Table: %EDIT_RES_CAT

    46 RESOURCE_SUB_CAT Character(5) VARCHAR2(5) NOT NULL Subcategory

    Prompt Table: %EDIT_RES_SUB

    47 ANALYSIS_TYPE Character(3) VARCHAR2(3) NOT NULL Analysis Type

    Default Value: INSTALLATION_PC.AN_TYPE_IN

    Prompt Table: PROJ_ANTYPE_FS

    48 BUSINESS_UNIT_PC Character(5) VARCHAR2(5) NOT NULL PC Business Unit

    Prompt Table: SP_BU_PC_NONVW

    49 COMBO_VALID_FLG Character(1) VARCHAR2(1) NOT NULL ChartField Combinatn Valid Flg
    ?=Validation in Progress
    V=Valid ChartField Combination
    X=Invalid ChartField Combo
    50 CREDIT_ACTION Character(2) VARCHAR2(2) NOT NULL Credit Action
    00=No Action
    01=Unknown
    02=Issue Credit Now
    03=Issue Credit Upon Receipt
    51 CREDIT_FLG Character(1) VARCHAR2(1) NOT NULL Credit Flag
    N=No
    Y=Yes

    Y/N Table Edit

    Default Value: N

    52 CUSTOMER_PO Character(25) VARCHAR2(25) NOT NULL Customer PO
    53 DISTRIB_TYPE Character(10) VARCHAR2(10) NOT NULL Distrib. Type

    Prompt Table: DISTR_IBU_VW
    Set Control Field: BUSINESS_UNIT

    54 EST_RETURN_DTTM DateTime(26) TIMESTAMP Estimated Return DateTime
    55 FREIGHT_TERMS Character(10) VARCHAR2(10) NOT NULL Freight Terms Code

    Prompt Table: FREIGHT_TERMS

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

    Prompt Table: RMA_ITM_INV_VW

    57 INVOICE Character(22) VARCHAR2(22) NOT NULL Invoice
    58 IST_TXN_FLG Character(1) VARCHAR2(1) NOT NULL Intrastat Transaction Flag
    N=No
    Y=Yes

    Y/N Table Edit

    Default Value: N

    59 LINE_SEQ_NUM Number(5,0) INTEGER NOT NULL Sequence
    60 NET_UNIT_PRICE Signed Number(16,4) DECIMAL(14,4) NOT NULL Net Unit Price
    61 NET_UNIT_PRICE_BSE Signed Number(16,4) DECIMAL(14,4) NOT NULL Net Unit Price (base)
    62 ORDER_ACTION Character(2) VARCHAR2(2) NOT NULL Sales Order Action
    00=No Action
    01=Unknown
    02=Replace Prior to Receipt
    03=Replace After Receipt
    63 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
    64 ORDER_INT_LINE_NO Number(5,0) INTEGER NOT NULL Order Line
    65 QTY_RETURNED Number(16,4) DECIMAL(15,4) NOT NULL Qty Returned
    66 QTY_RETURNED_BASE Number(16,4) DECIMAL(15,4) NOT NULL Quantity Returned Base
    67 RATE_DATE Date(10) DATE Exchange Rate Date
    68 RATE_DIV Number(16,8) DECIMAL(15,8) NOT NULL Rate Divisor
    69 RATE_MULT Signed Number(17,8) DECIMAL(15,8) NOT NULL Rate Multiplier
    70 REASON_CD Character(10) VARCHAR2(10) NOT NULL Reason Code

    Prompt Table: RMA_REASON_VW

    71 RECEIPT_FLAG Character(1) VARCHAR2(1) NOT NULL Received Complete

    Y/N Table Edit

    Default Value: N

    72 REF_DOCUMENT_ID Character(10) VARCHAR2(10) NOT NULL Reference Document ID
    73 RETURN_FR_CUST_ID Character(15) VARCHAR2(15) NOT NULL Return From Cust ID

    Prompt Table: %EDITTABLE6

    74 RETURN_FROM_BU Character(5) VARCHAR2(5) NOT NULL Return From Location

    Prompt Table: RMA_LOCATION_VW

    75 RETURN_FROM_LOC Character(10) VARCHAR2(10) NOT NULL Return From Location

    Prompt Table: RMA_LOCATION_VW

    76 RETURN_FROM_OPTION Character(1) VARCHAR2(1) NOT NULL Return From Option
    E=External Customer
    I=Internal Location
    77 RETURN_TO_IBU Character(5) VARCHAR2(5) NOT NULL Return To IBU

    Default Value: RMA_HEADER.RETURN_TO_IBU

    Prompt Table: SP_BUIN_NONVW

    78 RETURN_TYPE_CD Character(10) VARCHAR2(10) NOT NULL Return Type Code

    Prompt Table: RMA_RETURN_TYPE

    79 RMA_LINE_STATUS Character(1) VARCHAR2(1) NOT NULL Line Status
    C=Closed
    O=Open
    P=Pending
    X=Canceled

    Default Value: P

    80 RMA_PRINT_METHOD Character(1) VARCHAR2(1) NOT NULL Print Method
    1=Printer
    2=File
    3=Email
    4=Fax

    Default Value: 1

    81 RT_TYPE Character(5) VARCHAR2(5) NOT NULL Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.
    82 SHIP_TYPE_ID Character(10) VARCHAR2(10) NOT NULL Ship Via Code

    Prompt Table: SHIP_METHOD

    83 SPEEDTYPE_KEY Character(10) VARCHAR2(10) NOT NULL SpeedType Key

    Prompt Table: %EDITTABLE40
    Set Control Field: BUSINESS_UNIT

    84 STORE_NUMBER Character(17) VARCHAR2(17) NOT NULL Store Number
    85 TAX_CUST_GROUP Character(10) VARCHAR2(10) NOT NULL Tax Customer Group

    Prompt Table: CUST_TAXGPSH_VW

    86 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: %EDITTABLE11

    87 PRICE_PROTECTED Character(1) VARCHAR2(1) NOT NULL Price Protected

    Y/N Table Edit

    Default Value: N

    88 PRICING_UOM Character(3) VARCHAR2(3) NOT NULL Pricing UOM

    Prompt Table: %EDITTABLE11

    89 PRICING_QTY Number(16,4) DECIMAL(15,4) NOT NULL Pricing quantity.
    90 PARENT_PROD_ID Character(18) VARCHAR2(18) NOT NULL Parent Product Id
    91 RMA_RETURN_OPTION Character(1) VARCHAR2(1) NOT NULL Return to option
    0=Return to IBU
    1=Return To Vendor (Supplier)
    2=No Return Required

    Default Value: 0

    92 PRC_NET_UNIT_BSE Signed Number(16,4) DECIMAL(14,4) NOT NULL Net Unit Price (base)
    93 PRC_NET_UNIT_PRICE Signed Number(16,4) DECIMAL(14,4) NOT NULL Net Unit Price
    94 RMA_PRC_SOURCE Character(1) VARCHAR2(1) NOT NULL RMA price source
    I=Invoice
    P=Pricer
    S=Schedule
    U=User
    95 REF_PAY_GROUP_ID Number(3,0) SMALLINT NOT NULL Refund payment group
    96 REF_BUS_UNIT_BI Character(5) VARCHAR2(5) NOT NULL Reference Billing Business Unit
    97 LIST_PRICE Signed Number(17,4) DECIMAL(15,4) NOT NULL List Price
    98 LIST_PRICE_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL List Price (base)
    99 PRC_LIST_PRICE Signed Number(17,4) DECIMAL(15,4) NOT NULL List Price
    100 PRC_LIST_PRICE_BSE Signed Number(17,4) DECIMAL(15,4) NOT NULL List Price
    101 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier

    Prompt Table: VENDOR

    102 ADDR_SEQ_NUM_VEND Number(5,0) INTEGER NOT NULL Address Sequence Number

    Prompt Table: VENDOR_ADDR_VW3

    103 ORIG_LINE_NBR Number(5,0) INTEGER NOT NULL Original Line number
    104 RMA_HIST_TYPE Character(1) VARCHAR2(1) NOT NULL RMA history type
    D=Demand
    I=Invoice
    105 DATETIME_ADDED DateTime(26) TIMESTAMP DateTime Added
    106 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
    107 LAST_MAINT_OPRID Character(30) VARCHAR2(30) NOT NULL Last Maintained By Operator ID