GPGB_EDI_AUDDTL

(SQL Table)
Index Back

GPUK EDI Audit Detail Record

Retains ee edi transaction detail

  • Parent record: GPGB_EDI_AUDHDR
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 GPGB_EDI_REF Number(14,0) DECIMAL(14) NOT NULL GPUK EDI stores EDI transaction number
    2 SEQNUM Number(3,0) SMALLINT NOT NULL Sequence Number
    3 GPGB_EDI_WORKS_ID Character(35) VARCHAR2(35) NOT NULL GP UK Inland Revenue Works Id (Unique EmplId)
    4 GPGB_EDI_MESSAGE Character(254) VARCHAR2(254) NOT NULL EDI Messages
    5 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    6 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record