Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.


Show if
groupconfluence-administrators

415203329415203329APM 20Create APM Patch Notes

Release 2020.20 of the Adonis Personnel Manager is ready and can be downloaded and installed.


Page Properties


SoftwareVersionRelease DateDownload Link

Latest Patch

Adonis Personnel Manager

2020.20

 

Child pages (Children Display)
sorttitle
reversetrue
first1




Starting from version 2019.10, APM requires one of the following drivers to be installed on your workstation:

-ODBC Driver for SQL Server (v.13 or higher)
Or
-SQL Native Client (v.11 or higher)



Please note that if you are using Brightwell Plugin, it should be updated to ver. 2020.6.4.2 or higher to work properly with APM 2020.20.  




Release Highlights 

Refactoring

The majority of the issues included in this release are important change and bug request in existing functionality. Some major core functionality is refactored increasing  the performance in certain module like Crew Station Bill and Rotation planning. 


Distribute Payslip

In the previous release it was possible to email and distribute the payslip. The distribution of the payslip to the enclosed documents datagroup, enabled the possibility for our customers using the portal to distribute the payslip. In release 2020.20 the distribution is a separate option, that disables emailing the payslip to the employee.  


Gangway Monitoring

For those user using our gangway access module, the monitoring functionality in APM now also shows those persons signing on.    


Start Page

New functionality is added to the start page so that the administrator can define standard layouts, End users can then select from the various predefined layouts.  





Resolved Jira Issues 

Accounting Interface 

KeySummaryIssue TypeComponent(S)Release Notes
APM-4018DIM6 should be exported as blank when no valueBugAccounting Interface

When performing Export to Navision & External Doc No (Dim6) was not defined – the sequence number was still concatenated with empty value. Now if field is not defined – Dim6 value will return empty

APM-3957Navision Accounting export: change AppliesDocNo fieldBugAccounting Interface

Improved Navision Accounting export to populate AppliesDocNo field with value as in Dim defined in dialog window


Bank Interface 

KeySummaryIssue TypeComponent(S)Release Notes
APM-3479Rabobank Electronic payment screen overwrites the files with the same currencyBugBank Interface, Bank Interface/20022

Advance List by Currency for Rabobank balance action now offers option Create Payment File For Rabobank Without Replacement. When set it will always create a new temporary file without overwriting the one created previously.

APM-4071Advance List/Payment ListBugBank Interface, Payroll, Payroll\Fixed Reports, Reports

New option Payout the same recipient's bank accounts into one transaction is added to Advance List. When set – the generated payment file will merge existing multiple transactions into one, if the recipient’s bank details are the same. The accounting vouchers will not be affected though, as these payments might be spread to different accounting balances

Datagroups 

KeySummaryIssue TypeComponent(S)Release Notes
APM-3983Workaround for vessel transfer with 1day overlap stopped workingBugDatagroups\Activities, Modules\Rotation Planning

It was not possible to create one day overlap for sea-service activities, that correspond to Vessel Transfer operation.

APM-3976H30 to return real days when global option hours registration is on.BugDatagroups\Activities

Fixed H30 field to correctly calculate Days if activity datagroup is set to use Register Hours fields under Global Settings

APM-3872Not possible creating training activities with overlappingBugDatagroups\Activities

It was not possible to create overlapping activity for Rotation activity mode

APM-3589Issue during Confirm Sign On from Activities datagroupBugDatagroups\Activities, Modules\Crew Change

Wrong dates appeared for Snapped Crew Change when using Confirm in datagroup

APM-3573DBaction 'Delete' shows twice in Audit Trail for activitiesBugDatagroups\Activities

Delete action was shown twice in Audit trail

APM-3792Slow active PIN change when Enclosed documents or Overview datagroups openedBugDatagroups\Enclosed Documents

Slow pin change if a person had open datagroup & lots of enclosed files for records

APM-3646Add 'Occupation' field for the Family Member recordChange RequestDatagroups\Family

It is possible to store Occupation for any family member. Access to this field can be regulated by Field H77 Occupation in Adonis Control Centre > Fields > Family

APM-3776Telecommunication are overwritten.BugDatagroups\Personal Details

Covered by APM-3882

APM-3741Can not save info for employed crew if Termination reason is mandatoryBugDatagroups\Personal Details

It was not possible to update person’s name details if Termination reason was set mandatory.

APM-3602Add a field for State in Address section in Personal Details etcChange RequestDatagroups\Personal Details, Regions Editor

It is now possible to display County (State) of the country, when inputting address. This possibility will only be activated if corresponding country has option County Visible set under Setup > Tables > Regions Editor

  1. Open Setup > Tables > Regions Editor > Country list to set if County should be visible when referring to certain country
  2. Corresponding field will appear in each & every APM form that operates with address & country with set option is selected
APM-4125Alternative Receiver is overwritten from one person to anotherBugDatagroups\Personal Details

Crew member’s Alternative Receiver could be copied from another person if navigating in Crew List & instantly save person, before frame was refreshed

APM-3271Audit table for PW001P08Change RequestDatagroups\Travel Documents

We now provide possibility to view audits for Travel documents records

KeySummaryIssue TypeComponent(S)Release Notes
APM-4040Flight Inbox does not refresh while switching ToVessel/FromVessel flightsBuginterfaces\ATPI Crewlink

Flight Inbox was not refreshed when toggling between From Vessel / To Vessel filters

APM-3914Not enough rights to export report in CrewLink embeddedBuginterfaces\ATPI Crewlink

User was forced to login to CrewLink for the second time when trying to export a report.

APM-3837Add Conditions and Taxes fields to APMChange Requestinterfaces\ATPI Crewlink

Added fields for Tax and Conditions for Flight segments

APM-3710Possibility to cancel a booking of any statusChange Requestinterfaces\ATPI Crewlink

It is now possible to cancel flight with any status except Created, None

APM-3704Arrival before/Departure after time is reset after booking a flightBuginterfaces\ATPI Crewlink

Arrival Before / Departure After values were not saved, if modified without removing focus & clicking Book Flight

Modules 

KeySummaryIssue TypeComponent(S)Release Notes
APM-4104Remove a person from previous shift deletes activity no matter payroll and timesheet linkBugACC, Modules\Rotation Planning

We now apply validation for payroll routines related to activity handling not only when evaluating next shifts after modifying a shift, but also if Remove Person From Previous Shift is selected

APM-3973While confirming the crew change critical fields should not be updatedChange RequestModules\Crew Change

When confirming a Crew Change, payroll-critical fields (rank, position, payscale) are not updated in corresponding activity.

APM-3838Issue with Tag/untag function in Crew Change module -> Flight Booking tabBugModules\Crew Change

Tagged state for checkboxes was not reset if switching filters From Vessel/To Vessel

APM-3791Need Organization Column for Travel Info tab > Crew ChangeChange RequestModules\Crew Change

Added Organization Column for Signing On/Off Travel filter of Travel Info tab

APM-3720When updating crew change record the drop-down menu shows passive portsBugModules\Crew Change

Passive ports were available for Port selection.

APM-3999Not all variants from "DateTimeGrouping" work correctlyBugModules\Crew List

General improvement of grid functionality when performing Date Time grouping

APM-3722"Ignore organization properties" works incorrectlyBugModules\Crew List

Now Activated/Terminated state of a crew member is taken to count when creating a crewlist, even if it is registered with option Ignore Organization Properties Settings for Crew List when Selected Client is a Vessel.

APM-3350Using the "DateTimeGrouping>By Year" functionality leads to AV errorBugModules\Crew List

AV when trying to apply grouping by DateTime criteria in any grid.

APM-3975Slow Performance in CSBBugModules\Crew Station Bill

We added optional check for required documents when working with Muster Roll assignments. If it appears unnecessary & time-consuming for your workflow, causing performance degradation – you can switch it off using one-click ribbon command. It can be switched back on when necessary.

Please note that this is a workaround and we are looking further for a more suitable solution

APM-3674Add possibility to view people who are already assigned as relieversChange RequestModules\Crew Station Bill

New field Reliever is added to Add Crew Member & Add Reliever forms to indicate if suggested crew member is already assigned as reliever to a CrewID (its name is also shown)

APM-3666Possibility to remove "Load All" button for certain users levels when assigning people in Crew Station BillChange RequestModules\Crew Station Bill

We added Routine 885 Allow Load All for assigning list in Adonis Control Centre to manage access to button Load All when assigning person to CrewID

APM-3566Number columns sorting incorrectlyBugModules\Crew Station Bill

Fixed natural sorting of CrewId in Muster Stations setup that resulted in numeric values being sorted as text

APM-3780Same person is assigned to the same time drillsBugModules\Drill and Course Registration

It was possible to assign a person to Drills with overlapping time

APM-3956Payroll routines pre-validation for overlapped activities when adding travel activities before and after the onboard shiftChange RequestModules\Rotation Planning

Implemented functionality providing Payroll routines pre-validation for overlapped activities when adding travel activities before and after the onboard shift

APM-3906Adding travel activities before and after the onboard shiftBugModules\Rotation Planning

It was not possible to insert Travel activity if there existed historical activity with overlapped dates but with lower priority.

APM-3826The functionalities of Zoom and Viewing of rotation plan do not work.BugModules\Rotation Planning

Provided possibility to re-set scaling size to default for rotation gantt

APM-3517Handle Gap Sea-service activity in Rotation shift GanttChange RequestModules\Rotation Planning

When trimming a shift length with assigned person, it’s been possible to select a Gap activity to be created. Starting with this version, if selected gap activity is sea-service – module automatically verifies if a gap shift with similar dates is created & person is automatically assigned to this new gap shift

APM-3415Slow performance in RotationBugModules\Rotation Planning, User Options

Increased performance for Promotion operation when moving subsequent shifts & Leave days recalculated based on payroll formulas.

APM-3688A crew member isn't assigned on the shiftBugModules\Rotation Planning

A person was not actually assigned to shift, although assignment performed but after removing from previous shift without clicking Apply.

APM-3879Error in Rotation while moving subsequent shiftsBugModules\Rotation Planning

Changed record not found if a person assigned with option Move Subsequent Shifts, but new shift’s end date crossed next person's assignment.

APM-3694Assigned crew is removed from the shift after saving changesBugModules\Rotation Planning

A person was not actually assigned to shift, although assignment performed but after removing from previous shift without clicking Apply.

Payroll 

KeySummaryIssue TypeComponent(S)Release Notes
APM-3783Error message during sending A-melding (Correction)BugNorwegian Payroll

Could Not Convert Variant when sending A-Melding correction

APM-2739'List index out of bounds' error after balance action has been changed for two personsBugPayroll

List Index error when consequently changing balance action for 2 persons

APM-4061Wrong date format in NAVBugPayroll

Fixed date format for Navision export to MMDDYYYY instead of DDMMYYYY

APM-4053Entry code not calculating when From field is filled inBugPayroll, Payroll\Calculation

For a person terminated in the middle of current period, payroll calculation will include the fixed entry if the Fromperiod and Toperiod is inside the current period.

APM-3527Record missing and corrupted in Payment List reportBugPayroll

Payment report was generated with incorrect page size that resulted in data partly missing on layout

APM-3809Currency rate on manual entries does not change to match the currency codeBugPayroll

Currency rate was not updated after currency code changed

APM-4145PeopleSoft: Direct Deposit vs Physical checkBugPayroll

Implemented new balance action Payment Check for proper integration with PeopleSoft

APM-3870Possibility to add Email report in Enclosed documents without sending by emailChange RequestPayroll\Email reports, Reports

Crew List Email Report now provides possibility to Distribute reports to Enclosed documents without actually sending them by email. These are now separate options

APM-3761The Birthdate is not fetched to a file for BDO bankBugPayroll\Email reports, Payroll\Payroll Additional Info

Date of birth was not fetched to payment file for BDO balance action

APM-4063Some Entry Code options cannot be seenBugPayroll\Entry Codes

Entrycode options are now moved to the separate tab.

APM-3774L165 returns 0 when customer is not using Crew ChangeBugPayroll\Entry Codes, Payroll\Scripts

L165(d) value returned 0 instead of Estimated End date when DateTo was empty

APM-3747It takes too long to work with Payroll module on AzurBugPayroll\Entry Codes

Optimized data-loading in Payroll details for better module performance

APM-3635'Access is denied' message after Export to ADP.BugPayroll\Entry Codes

Access Denied error & application crash if folder for an Export tool is setup but APM user doesn't have access to it

APM-3349The amount is parsed and inserted into Currency Code field, which does not allow numeric input from user screenBugPayroll\Entry Codes

If a currency was added to General Codes with numeric code & Exchange Rate = 1, trimmed amount could have been added into Currency Code field of a transaction

APM-3990Pension Fund 2020 report does not include refundadble sick wages infoBugPayroll\Fixed Reports

Generating Norwegian report for Pension Fund 2020, Sick Wages were not included if corresponding entrycode was set without option Redersandel (Pension for Employer).

APM-3696Payment file report layout corruptedBugPayroll\Fixed Reports

Layout & footer issues in Payment list, resulting to data appearing partly

APM-3671Auto correct sequence counterBugPayroll\Payscales

PK Violation for payscale rates when performing Duplicate operation over Payscale

APM-3868Possibility to add Payslip in Enclosed documents without sending by emailChange RequestPayroll\Payslip

It is now possible to Distribute payroll reports to Enclosed documents without actually sending them by email. These are now separate options. Note that reports should be enabled in Global Options & enclosed document code for distribution must be defined

APM-3740Tag All, Untag All buttons don't work in Process Timesheets screen when method TimesheetsPerDay is selectedBugPayroll\Process Time Sheets

For Process Timesheet grid buttons Tag All / Untag All were not working if timesheets were presented in Per Day mode

APM-4077New option on ISO20022 user interface for PeopleSoftChange RequestPayroll

Extended Receiver Bank tab with checkbox Prenote? for balance action PeopleSoft, for end-user to make a decision if Prenote status should be reported.

APM-4058Balance Action: By default need to be carried forward instead of cashBugPayroll

If a person doesn’t have payroll data from history, his default balance action will be now set as Carry Forward To Next Month instead of Cash offered earlier

APM-4020Navision - possibility for removing certain bank transfer entry codesBugPayroll\Entry Codes

We implemented shared form Entry Codes Excluded Payment Amount for all accounting exports available in Organization Structure > Company > Payroll > Accounting. When generating the Accounting Voucher report it is now possible to optionally exclude the entry codes defined here.

  1. Select your accounting format & entry codes that are not required to be shown per each Company in your Organization Structure
  2. When running Accounting Voucher report select if you require these fields to be excluded or not
APM-3979Allotment priority 11 is not properly displayed as 1 in APMBugPayroll

Allottee priority containing more than one digit was not displayed properly in overview grid

Other 

KeySummaryIssue TypeComponent(S)Release Notes
APM-3475Possibility to limit access to specific Activity Codes in ACC.Change RequestACC

We added field Sec Code to provide possibility setting Control Centre access for specific Code records, same as for other general codes.

  1. Set a numeric security code under General Codes > Activity Codes
  2. Corresponding activity code will appear in Adonis Control Centre > General Codes > Activity Codes for possible limitation of access rights to a User Group
APM-4108Trigger issue when upgrading to APM 2020.10.5.1BugDatabase

Improved automated creation of triggers to exclude fields that were automatically created by replicator & contain REPLFIELD_ prefix

APM-3487Incorrect coding applied to Logisoft export file.BugExport\Logisoft

Provided possibility to export data in various encodings (UTF8 by default).

APM-3380Include US Zip and States codes in APM installation setChange RequestInstallation Set

US Zip codes & State codes are now added by Adonis installation & upgrade by default.

APM-3264Ignore terminated crew during export of Bio and sea service dataBuginterfaces\Seagull

When exporting Biodata, a person will only be updated once when Employment End Date has been set and its value is less or equal than today.

APM-3917The two inherit boxes should be checked by defaultChange RequestOrganization

When creating a Position record checkboxes Inherit access from vessel and Inherit access from department are set On by default under Access Areas

APM-3948To add the "purge database" fields into user interface of Replicator SetupChange RequestReplicator

To allow interface setup of the latest released replicator purge functionality under Setup > Adonis Replicator, we added Is Purge checkbox for Site Properties together with possibility to define a number of days to apply purging & PK query definition under Replication Tasks


APM-3772File not found when sending email with attachment from APM.BugSend Email

File Not Found when trying to send generated report by email

APM-3759APM General Codes - Possible to Add Blank Space When Pasting ValueBugSetup\General Codes

It was possible to create general codes with non-valid symbols (space)

APM-3748Validation for previously planned activities doesn't work for Common EntryBugTools\Common Entry

It was possible to create Current activity with dates after existing Planned using Common Entry -> Embarking-SignOn/Disembarking-SigOff

APM-3549Import activities are not working properly.BugTools\Import

Significantly improved performance for importing process.

APM-3938Link in Installation set links to old documentationBugInstallation Set

Improved installation set with link to the updated manual

APM-3916Include the Access Level settings in the 'Copy structure below to' function. Change Request

We improved functionality Copy Structure Below to so that settings defined at Access Areas tab are copied as well.

APM-3916Include the Access Level settings in the 'Copy structure below to' function. Change Request

We improved functionality Copy Structure Below to so that settings defined at Access Areas tab are copied as well.

APM-3985PWORGCMP Multiple-step operation generated errorsBug

We modified PWORGCMP table, lessening the number of fields, related to various exports setup. These fields are moved to new separate tables

APM-3850Missing Fields in the editor formChange Request

It is now possible to customize all of the fields that are available for a Competence code as Mandatory / Optional / Disabled for input.

APM-3593Error message appears in Vessel LocationBug

Prohibited PK Violation when creating two identical records for Vessel Location. Warning now shows instead.

APM-4019Change the module name to 'Access Areas Module'Change Request

Updated the module name to Access Areas

APM-4001Gangway monitoring On signing tabChange Request

Gangway Control module is extended with new Signing On tab, displaying crew confirmed onboard

APM-3971Start Page Module Layouts management functionalityChange Request
Various improvements of Start Page Module Layout





Database Modifications


Database Modifications

1. We modified PWORGCMP table, lessening the number of fields, related to various exports setup. These fields are moved to new separate tables. 

2. Improved automated creation of triggers to exclude fields that were automatically created by replicator & contain REPLFIELD_ prefix. 

Table 

Field name 

Field Type 

PW001P08 

SESSIONID 

DBACTION 

AUDIT_LINENR 

Int 

Varchar(10) 

Int 

AUDIT_PW001P08 

PIN 

CREATEDBY 

CREATETIME 

CHANGEDBY 

CHANGETIME 

HISTORICAL 

GROUPNO 

CLIENTNO 

SEQUENCENO 

SITEID 

UPDATEFLAGS 

DATEFROM 

DATETO 

CODE 

TDNUMBER 

DATEAPPLIED 

ISSUEDELAY 

COMMENTS 

ISSUEDWHERE 

ISSUEDBY 

ISSUEDBYSCHOOL 

scanneddocno 

PASSPORTPRIORITY 

SCANVALIDITY 

EXPIRYNOTIFICATIONDATE 

repl_ModifiedBySite 

repl_ModifiedDate 

repl_GMTModifiEDDate 

ISSUE_COUNTRY 

NATIVENAME 

SESSIONID 

DBACTION 

AUDIT_LINENR 

int 

varchar 

datetime 

varchar 

datetime 

varchar 

int 

int 

int 

int 

varchar 

datetime 

datetime 

varchar 

varchar 

datetime 

varchar 

varchar 

varchar 

varchar 

int 

int 

int 

int 

datetime 

int 

datetime 

datetime 

varchar 

nvarchar 

int 

varchar 

int 

PWORGCMP_PFA 

NUMORGID 

CONTRIBUTION_EMPLOYEE 

CONTRIBUTION_EMPLOYER 

VOLUNTEER_PENSION 

AMB 

CODE_LEAVE 

LINE_PAYSCALE 

MONTHLY_SALARY 

CONTRACT_CODE 

CREATEDBY 

CREATETIME 

CHANGEDBY 

CHANGETIME 

repl_ModifiedBySite 

repl_ModifiedDate 

repl_GMTModifiedDate 

Int 

Varchar (25) 

Varchar (25) 

Varchar (25) 

Varchar (25) 

Varchar (25) 

Varchar (25) 

Varchar (25) 

Varchar (25) 

Varchar (32) 

Datetime 

Varchar (32) 

Datetime 

Int 

Datetime 

Datetime 

PWORGCMP_PFA_INSURANCE 

SEQUENCENO 

NUMORGID 

ENTRYCODE 

repl_ModifiedBySite 

repl_ModifiedDate 

repl_GMTModifiedDate 

Int 

Int 

Int 

Int 

Datetime 

Datetime 

PWORGCMP_BUR 

NUMORGID 

ENTRYCODE_FOR_ATP 

ENTRYCODE_FOR_BARSEL 

ATP_EMLOYEE 

ATP_EMLOYER 

AMOUNT_BARSEL 

ATP_VOLUNTARY 

CONTRACT_CODE 

CREATEDBY 

CREATETIME 

CHANGEDBY 

CHANGETIME 

repl_ModifiedBySite 

repl_ModifiedDate 

repl_GMTModifiedDate 

Int 

Int 

Int 

Varchar (25) 

Varchar (25) 

Varchar (25) 

Varchar (25) 

Varchar (25) 

Varchar (32) 

Datetime 

Varchar (32) 

Datetime 

Int 

Datetime 

Datetime 

PWORGCMP_DAN 

NUMORGID 

CONTRACT_CODE 

PERCENT_FIELD 

CONTRIBUTION_CODE 

CREATEDBY 

CREATETIME 

CHANGEDBY 

CHANGETIME 

repl_ModifiedBySite 

repl_ModifiedDate 

repl_GMTModifiedDate 

Int 

Varchar (32) 

Varchar (32) 

Varchar (32) 

Varchar (32) 

Datetime 

Varchar (32) 

Datetime 

Int 

Datetime 

Datetime 

PWORGCMP_ACS 

NUMORGID 

CLIENT_PLAN 

COVERED_COMP 

CURRENT_PAY_PERIOD_HOURS 

DEFERRAL 

DIVISION_CODE 

EC_FOR_COVERED_COMP 

EC_FOR_DEFERRAL 

EC_FOR_ERMATCH 

EC_FOR_LOAN_REPAYMENT 

EC_FOR_LOAN_ROTH_DEFERRAL 

EC_LOAN 

ER_MATCH 

EXTRA_ACCOUNT 

LOAN_REPAYMENT 

ROTH_DEFERRAL 

CREATEDBY 

CREATETIME 

CHANGEDBY 

CHANGETIME 

repl_ModifiedBySite 

repl_ModifiedDate 

repl_GMTModifiedDate 

Int 

Varchar (32) 

Varchar (32) 

Varchar (32) 

Varchar (32) 

Varchar (32) 

Varchar (max) 

Varchar (max) 

Varchar (max) 

Varchar (max) 

Varchar (max) 

Varchar (max) 

Varchar (32) 

Varchar (32) 

Varchar (32) 

Varchar (32) 

Varchar (32) 

Datetime 

Varchar (32) 

Datetime 

Int 

Datetime 

Datetime 

PWORGCMP_NAV 

NUMORGID 

EXTERNAL_DOCNO 

APPLIES_DOCNO 

PAYEE 

COMPANY_CODE 

BATCH_NAME 

DOCUMENT_TYPE 

DESCRIPTION 

DIM1 

DIM2 

DIM3 

DIM4 

DIM5 

DIM6 

DIM7 

DIM8 

CREATEDBY 

CREATETIME 

CHANGEDBY 

CHANGETIME 

repl_ModifiedBySite 

repl_ModifiedDate 

repl_GMTModifiedDate 

Int 

Varchar (10) 

Varchar (100) 

Varchar (100) 

Varchar (100) 

Varchar (10) 

Varchar (10) 

Varchar (10) 

Varchar (10) 

Varchar (10) 

Varchar (10) 

Varchar (10) 

Varchar (10) 

Varchar (10) 

Varchar (10) 

Varchar (10) 

Varchar (32) 

Datetime 

Varchar (32) 

Datetime 

Int 

Datetime 

Datetime 

PWORGCMP_VSM 

NUMORGID 

COMPANID 

TEXT 

PAYROLL_TYPE 

PAYMENT_TYPE 

PAYROLL_NUM 

PAYMENT_NUM 

DIM_R1 

DIM_R2 

DIM_R3 

DIM_R4 

DIM_R5 

DIM_R6 

DIM_R7 

DIM_R8 

DIM_R9 

DIM_R10 

DIM_R11 

DIM_E1 

DIM_E2 

DIM_E3 

DIM_E4 

DIM_E5 

DIM_E6 

DIM_E7 

DIM_E8 

DIM_E9 

DIM_E10 

DIM_E11 

CREATEDBY 

CREATETIME 

CHANGEDBY 

CHANGETIME 

repl_ModifiedBySite 

repl_ModifiedDate 

repl_GMTModifiedDate 

Int 

Int 

Varchar (10) 

Varchar (4) 

Varchar (4) 

Varchar (12) 

Varchar (12) 

Varchar (30) 

Varchar (30) 

Varchar (30) 

Varchar (30) 

Varchar (30) 

Varchar (30) 

Varchar (30) 

Varchar (30) 

Varchar (30) 

Varchar (30) 

Varchar (30) 

Varchar (1) 

Varchar (1) 

Varchar (1) 

Varchar (1) 

Varchar (1) 

Varchar (1) 

Varchar (1) 

Varchar (1) 

Varchar (1) 

Varchar (1) 

Varchar (1) 

Varchar (32) 

Datetime 

Varchar (32) 

Datetime 

Int 

Datetime 

Datetime 

PEOPLESOFT_VENDOR 

PIN 

NAME1 

BANK_ACCOUNT_NUM 

ADDRESS1 

ADDRESS2 

CITY 

STATE 

COUNTRY 

ZIP 

PRENOTE_STATUS 

DFI_ID_NUM 

BANK_ACCOUNT_NUM1 

BANK_ACCT_TYPE 

EMAILID 

REGISTERED 

CREATEDBY 

CREATETIME 

CHANGEDBY 

CHANGETIME 

repl_ModifiedBySite 

repl_ModifiedDate 

repl_GMTModifiedDate 

Int 

Varchar (46) 

Varchar (41) 

Varchar (61) 

Varchar (61) 

Varchar (36) 

Varchar (12) 

Varchar (9) 

Varchar (16) 

Varchar (1) 

Varchar (18) 

Varchar (41) 

Varchar (8) 

Varchar (76) 

Varchar (1) 

Varchar (32) 

Datetime 

Varchar (32) 

Datetime 

Int 

Datetime 

Datetime 

PWORGCMP_GRATUITY 

SEQUENCENO 

NUMORGID 

ENTRYCODE 

API_METHOD 

CONDITION 

CREATEDBY 

CREATETIME 

CHANGEDBY 

CHANGETIME 

repl_ModifiedBySite 

repl_ModifiedDate 

repl_GMTModifiedDate 

Int 

Int 

Int 

Varchar (max) 

Varchar (max) 

Varchar (32) 

Datetime 

Varchar (32) 

Datetime 

Int 

Datetime 

Datetime 

PWORGCMP_GRATUITY_FIELDS 

SEQUENCENO 

GRATUITY_SEQ 

PAY_FIELD 

API_FIELD 

CREATEDBY 

CREATETIME 

CHANGEDBY 

CHANGETIME 

repl_ModifiedBySite 

repl_ModifiedDate 

repl_GMTModifiedDate 

Int 

Int 

Varchar (10) 

Varchar (32) 

Varchar (32) 

Datetime 

Varchar (32) 

Datetime 

Int 

Datetime 

Datetime 

SPM_LAYOUTS 

SEQUENCENO 

NAME 

DESCRIPTION 

TYPELAYOUT 

LAYOUT 

USERID 

VISIBLE 

repl_ModifiedBySite 

repl_ModifiedDate 

repl_GMTModifiedDate 

Int 

Varchar (128) 

Varchar (256) 

Int 

Varchar (max) 

Varchar (6) 

Int 

Int 

Datetime 

Datetime 

PWCCMAIRSEGMENTS 

TAX 

CONDITIONS 

Decimal (19,6) 

Varchar (50) 

PW001C12 

SECCODE 

Int 

PW001P06 

OCCUPATION 

ALLOTM_PRENOTE 

Varchar (50) 

Varchar (1) 

AUDIT_PW001P06 

OCCUPATION 

ALLOTM_PRENOTE 

Varchar (50) 

Varchar (1) 

PWCOUNTRY 

CONTINENTCODE 

COUNTY_VISIBLE 

Varchar (2) 

Int 

PWORGPOS 

ACCESS_AREAS_INHERIT_VESSEL 

ACCESS_AREAS_INHERIT_DEPARTMENT 

Renamed 

renamed 

AUDIT_PWORGPOS 

ACCESS_AREAS_INHERIT_VESSEL 

ACCESS_AREAS_INHERIT_DEPARTMENT 

Renamed 

Renamed 

 

PW_CREW_ACCESS_AREAS 

 

renamed 

PW_CREW_ACCESS_AREAS_DETAILS 

 

renamed 

PW001P0Y 

PRENOTE 

Varchar (1) 

AUDIT_PW001P0Y 

PRENOTE 

Varchar (1) 

PW001PAI 

PRENOTE 

Varchar (1) 

PWCTCCMP 

PRENOTE 

Varchar (1) 

PW_PAYMENT_FILE_TRANSACTIONS 

ID 

SEQNO 

PS_VENDOR_ID 

repl_ModifiedDate 

repl_ModifiedBySite 

repl_GMTModifiedDate 

Int 

Int 

Varchar (41) 

Datetime 

Int 

Datetime 

PW_PAYMENT_FILE 

ID 

FILE_NAME 

LOCATION  

EXPORTED  

SESSIONID 

COMMENTS 

BANKFORMAT 

repl_ModifiedDate 

repl_ModifiedBySite 

repl_GMTModifiedDate 

Int 

Varchar (50) 

Varchar (100) 

Datetime 

Int 

Varchar (100) 

Varchar (50) 

Datetime 

Int 

Datetime 




Other Versions 

Page Properties Report
cqllabel = "apm-rn"