RB_RELATION

(SQL Table)
 Index Back

Import Record Relation

defines relations between records(join criteria, in essence)

  • Parent Record Of RB_RELATION_SEQ

    • # 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
    3 LI_IS_MANY Character(1) VARCHAR2(1) NOT NULL one to many?

    Y/N Table Edit

    Default Value: N

    4 LI_IS_REQUIRED Character(1) VARCHAR2(1) NOT NULL zero to one or zero to many?

    Y/N Table Edit

    Default Value: N