RB_RELATION_SEQ

(SQL Table)
 Index Back

Import Record Relation

defines relations between records(join criteria, in essence)

  • Parent record: RB_RELATION

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 LI_RELATION_ID Character(31) VARCHAR2(31) NOT NULL relation identifier(pk)
    2 RECORDNAME Character(15) VARCHAR2(15) NOT NULL Record Name
    01=MASTER_ITEM_EC
    02=INV_ITEMS_EC
    03=BU_ITM_INV_EC
    04=BU_ITM_WTVL_EC
    05=ITEM_VENDOR_EC
    06=ITM_VNDR_LOC_EC
    07=ITM_VNDR_UOM_EC
    08=ITM_VND_UMPR_EC
    09=INV_ITM_UOM_EC
    10=PUR_ITM_ATTR_EC
    11=MANUFACTURER_EC
    12=ITEM_MFG_EC
    13=EN_REVISION_EC

    Prompt Table: RECDEFN_VW

    3 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number
    4 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).