RE_MFT_GROUP

(SQL Table)
 Index Back

Manual Fee Txn Group

Manual Fee Transaction Group

  • Parent Record Of RE_MFT_CHARGE RE_MFT_TXN

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 TXN_GRP_ID Number(15,0) DECIMAL(15) NOT NULL Row Key for Transaction Group
    2 LEASE_OBLG Character(1) VARCHAR2(1) NOT NULL Lease Obligation either Payables or Receivables Lease
    1=Payables
    2=Receivables
    3 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Prompt Table: SP_BU_RE_NONVW

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

    Prompt Table: CURRENCY_CD_TBL

    5 SCHED_DATE Date(10) DATE Schedule Date

    Default Value: %date

    6 ALLOC_BY Character(1) VARCHAR2(1) NOT NULL Method of allocation
    1=Amount
    2=Percent

    Default Value: 1

    7 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254
    8 DST_ALLOC_METHOD Character(1) VARCHAR2(1) NOT NULL Distribution Allocation Method
    1=Percentage
    2=Amount
    3=Area
    4=None
    5=Quantity

    Default Value: 4

    9 INVOICE_ID Character(30) VARCHAR2(30) NOT NULL Invoice Number
    10 FROM_PANELNAME Character(18) VARCHAR2(18) NOT NULL From Panel Name
    11 FMS_DTTM_STAMP DateTime(26) TIMESTAMP Specifies the date and time of the original entry.
    12 FMS_OPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the original entry.
    13 FMS_LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry.
    14 FMS_LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry.