RMA_HEADER

(SQL Table)
Index Back

RMA Header

Date Initials Issue # Description 11/30/00 dms 5744301 Add CNTCT_SEQ_BILL 01/25/01 dms SP2 (DI-EDWONG-2) Deferred processing 06/26/01 JJM F-FSELK-11 Proj. Gemini chartfield changes 07/16/01 dms --- Remove PAYMENT_TYPE

  • Parent Record Of BI_RMARPG_TAO RMA_PAY_GROUP
  • # 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
    3 RETURN_FROM_OPTION Character(1) VARCHAR2(1) NOT NULL Return From Option
    E=External Customer
    I=Internal Location

    Default Value: I

    4 SOLD_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Sold To Customer

    Prompt Table: %EDITTABLE5

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

    Prompt Table: RMA_LOCATION_VW

    6 RETURN_FR_CUST_ID Character(15) VARCHAR2(15) NOT NULL Return From Cust ID

    Prompt Table: %EDITTABLE6

    7 ACCOUNT Character(10) VARCHAR2(10) NOT NULL Account

    Prompt Table: %EDIT_ACCOUNT

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

    Prompt Table: %EDIT_ALTACCT

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

    Prompt Table: DEPTID_BUGL_VW

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

    Prompt Table: SP_PROJFS_NONVW

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

    Prompt Table: OPERUNT_BUGL_VW

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

    Prompt Table: PRODUCT_BUGL_VW

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

    Prompt Table: FUND_BUGL_VW

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

    Prompt Table: CLASSCF_BUGL_VW

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

    Prompt Table: PROGRAM_BUGL_VW

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

    Prompt Table: BUD_REF_BUGL_VW

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

    Prompt Table: AFFILIATE_VW

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

    Prompt Table: %EDIT_INTRA01

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

    Prompt Table: %EDIT_INTRA02

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

    Prompt Table: CF1_BUGL_VW

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

    Prompt Table: CF2_BUGL_VW

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

    Prompt Table: CF3_BUGL_VW

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

    Prompt Table: %EDITTABLE7

    24 ADDRESS_SEQ_SHIP Number(5,0) INTEGER NOT NULL Primary Address - Ship To

    Prompt Table: %EDITTABLE8

    25 ADDRESS_SEQ_SOLD Number(5,0) INTEGER NOT NULL Primary Address - Sold To

    Prompt Table: %EDITTABLE9

    26 ADDR_OVRD_LEVEL Character(1) VARCHAR2(1) NOT NULL Address Override Level
    D=Demand Line
    H=Header
    L=Line
    S=Schedule
    27 ADDR_OVRDSD_FLAG Character(1) VARCHAR2(1) NOT NULL Sold-to Override Level
    28 ADJUSTED_FLAG Character(1) VARCHAR2(1) NOT NULL Adjusted Flag
    H=Header Level Adjustment
    L=Line Level Adjustment
    N=No Adjustments
    29 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID

    Prompt Table: PROJ_ACT_FS

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

    Prompt Table: PROJ_RESTYPE_FS

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

    Prompt Table: %EDIT_RES_CAT

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

    Prompt Table: %EDIT_RES_SUB

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

    Default Value: INSTALLATION_PC.AN_TYPE_IN

    Prompt Table: PROJ_ANTYPE_FS

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

    Prompt Table: SP_BU_PC_NONVW

    35 COMBO_VALID_FLG Character(1) VARCHAR2(1) NOT NULL ChartField Combinatn Valid Flg
    ?=Validation in Progress
    V=Valid ChartField Combination
    X=Invalid ChartField Combo
    36 CNTCT_SEQ_BILL Number(5,0) INTEGER NOT NULL Contact Sequence - Bill To

    Prompt Table: %EDITTABLE15

    37 CNTCT_SEQ_NUM Number(5,0) INTEGER NOT NULL Contact Sequence Number

    Prompt Table: %EDITTABLE3

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

    Prompt Table: %EDITTABLE14

    39 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Prompt Table: CURRENCY_CD_TBL

    40 CURRENCY_CD_BASE Character(3) VARCHAR2(3) NOT NULL Business Unit Base Currency
    41 BILL_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Customer

    Prompt Table: %EDITTABLE4

    42 CANCEL_DATE Date(10) DATE Cancel Date
    43 CANCEL_REASON Character(10) VARCHAR2(10) NOT NULL Cancel Reason

    Prompt Table: RMA_CNCLRSN_VW

    44 DISTRIB_TYPE Character(10) VARCHAR2(10) NOT NULL Distrib. Type

    Prompt Table: DISTR_IBU_VW
    Set Control Field: BUSINESS_UNIT

    45 EST_RETURN_DTTM DateTime(26) TIMESTAMP Estimated Return DateTime
    46 IST_TXN_FLG Character(1) VARCHAR2(1) NOT NULL Intrastat Transaction Flag
    N=No
    Y=Yes

    Y/N Table Edit

    Default Value: N

    47 PAYMENT_METHOD Character(3) VARCHAR2(3) NOT NULL Specifies the preferred method of payment by a customer. Examples of payment method are check direct debit and draft. 10/28/2003 edw 655070000 - Removed LTC and CSH xlats.
    ACH=ACH
    CC=Credit Card
    CHK=Check
    CSH=Cash
    DD=Direct Debit
    DR=Draft
    EC=Electronic Check
    EFT=Electronic Fund Transfer
    GE=Giro - EFT
    PL=PayPal
    WIR=Wire Report

    Prompt Table: OM_PAY_MTHD_VW

    48 PYMNT_TERMS_CD Character(5) VARCHAR2(5) NOT NULL Specifies how the payment due date and discount due date are calculated. A payment terms code is associated with various business units bill-to customers vendors as well as sales orders purchase orders and vouchers.

    Prompt Table: AR_TRMS_VW
    Set Control Field: BUSINESS_UNIT

    49 RATE_DATE Date(10) DATE Exchange Rate Date
    50 RATE_DIV Number(16,8) DECIMAL(15,8) NOT NULL Rate Divisor
    51 RATE_MULT Signed Number(17,8) DECIMAL(15,8) NOT NULL Rate Multiplier
    52 REASON_CD Character(10) VARCHAR2(10) NOT NULL Reason Code

    Prompt Table: RMA_REASON_VW

    53 RESTOCK_FEE_FLAG Character(1) VARCHAR2(1) NOT NULL Restocking Fee

    Y/N Table Edit

    Default Value: N

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

    Prompt Table: RMA_LOCATION_VW

    55 RETURN_TO_IBU Character(5) VARCHAR2(5) NOT NULL Return To IBU

    Prompt Table: SP_BUIN_NONVW

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

    Default Value: BUS_UNIT_TBL_OM.RETURN_TYPE_CD

    Prompt Table: RMA_RETURN_TYPE

    57 RMA_APPROVED_FLAG Character(1) VARCHAR2(1) NOT NULL Approval Required

    Y/N Table Edit

    Default Value: Y

    58 RMA_DATE Date(10) DATE NOT NULL RMA Date

    Default Value: %date

    59 RMA_STATUS Character(2) VARCHAR2(2) NOT NULL RMA Status
    C=Closed
    O=Open
    P=Pending
    X=Canceled

    Default Value: P

    60 RMA_PRINT_COUNT Number(3,0) SMALLINT NOT NULL RMA Print Count
    61 RMA_TYPE Character(1) VARCHAR2(1) NOT NULL RMA Type
    I=Inventory RMA
    O=Order Management RMA

    Default Value: O

    62 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.
    63 SPEEDTYPE_KEY Character(10) VARCHAR2(10) NOT NULL SpeedType Key

    Prompt Table: %EDITTABLE40
    Set Control Field: BUSINESS_UNIT

    64 CA_SHIPMENTS Character(1) VARCHAR2(1) NOT NULL Field for determining whether to search for Contracts generated shipment history or other shipment history on an RMA.

    Y/N Table Edit

    Default Value: N

    65 RMA_EOEP_ARB_ID Character(10) VARCHAR2(10) NOT NULL RMA Arbitration Plan

    Prompt Table: EOEP_ARB_SO_VW

    66 PRC_RMA_DATE Date(10) DATE RMA Pricing Date
    67 LAST_RMA_PRINT_DT Date(10) DATE Last RMA Print Date
    68 DATETIME_ADDED DateTime(26) TIMESTAMP DateTime Added
    69 LAST_DTTM_RMA_UPD DateTime(26) TIMESTAMP Last dttm RMA update
    70 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.
    71 LAST_MAINT_OPRID Character(30) VARCHAR2(30) NOT NULL Last Maintained By Operator ID