RE_MFT_CHARGE

(SQL Table)
 Index Back

Manual Fee Charges

Manual Fee Charges for a Transaction Group

  • Parent record: RE_MFT_GROUP

    • # 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 TXN_CHARGE_ID Number(15,0) DECIMAL(15) NOT NULL Transaction Charge Identifier, a sequence number used to identify a constituent charge of a transaction
    3 TXN_GRP Character(1) VARCHAR2(1) NOT NULL Transaction Group
    1=Base Rent
    2=Security Deposit
    3=Straightline Accounting
    4=Operating Expense
    5=Percent Rent
    6=Miscellaneous Rent
    7=Manual Fee
    8=Lease Obligation
    9=Lease Interest Expense
    A=Prior Period Lease Obligation
    B=Prior Period Lease Interest
    C=Rent Expense
    D=Lease Incentive

    Default Value: 7

    4 CHG_GRP_CD Character(10) VARCHAR2(10) NOT NULL This field holds the Charge Group Code for the Transaction Groups.

    Prompt Table: RE_SUNDRY_CHG

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

    Prompt Table: CURRENCY_CD_TBL

    6 AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount
    7 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    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