Table | Field name | Field Type | Default | Comments |
PW001P20AUDIT_LINENR | INT | NOT NULL (0) | PW001P20 | SESSIONID | INT | NOT NULL (-2) | PW001P20 | DBACTION | VARCHAR(10) | NOT NULL ("") | PW001P20 | PROGRAM_NAME | nvarchar(128) | NULL | AUDIT_PW001P20 | SELECT * INTO AUDIT_PW001P20 FROM PW001P20
UPDATE AUDIT_PW001P20 SET DBACTION = 'INITIALISE', AUDIT_LINENR = -1 | initalizationContracts (PW001P20) audit table matching PW001P20 structureACTIVITYCODES | VARCHAR(4000) | | · Extended field length | PWPSC000 | ACTIVITYCODES | VARCHAR(4000) | | · Extended field length | PWPSC000 | SENIORITY_CALC_ACTCODES | VARCHAR(4000) | | · Extended field length | AUDIT_PWPSC001 | ACTIVITYCODES | VARCHAR(4000) | | · Extended field length | AUDIT_PWPSC000 | ACTIVITYCODES | VARCHAR(4000) | | · Extended field length | AUDIT_PWPSC000 | SENIORITY_CALC_ACTCODES | VARCHAR(4000) | | · Extended field length | PW001C88 | FILTER_BY_CURRENT_CLIENT | BIT | | | PWCMPPAY | TIMECARDSTARTDATE | DATETIME | | | PWCMPPAY | TIMECARDSENDDATE | DATETIME | | | PWCMPPAY | TIMECARDMANUALDATES | BIT | | |
|