6 OHC GL Accounting

The OHC GL Accounting module is used to generate the payment file and submit to the bank. Once the payout has been processed at the end of the pay period, Credit posting is made available to the crew member of the selected credit card, made through Ocean Pay.

The parameter “Payroll”, “Pay codes for OceanPay Top-Up Transactions” holds the pay code for payroll deduction pay codes that need to be transferred into the payment file when transactions are posted.

Below is the field definition of GL Export Setup.

Figure 6-1 GL Export Setup

Table 6-1 GL Export Field Definition

Column Name	Definition
Name	OceanPay Export used for the file generation.
For Close Period Only	When enabled, you can only generate the transaction file when the pay period is closed.
Output Directory	Location of the output file once generated. For security purposes, the directory/folder defined must be within the network.
File Name Prefix	Output filename. For example: ExampleData120100629 46065.txt.PGP
File Name Formatter (SQL)	An SQL query to select a specific column as part of the filename.
Delimiter ASCII	Use in output file if it has multiple columns. Define blank if file is fixed length field.
Source View	Refers to a database view. For example: PAY_OCEANPAY_TOPUP
Comment	File description
PGP Protected	If enabled, the browser will prompt to upload the public key provided by the bank.
Active	Active if enabled, Inactive if disabled.

The following screenshot shows the transaction listing of the pay code deduction defined in the parameter “Pay codes For OceanPay Top-Up Transactions”.

Figure 6-2 Payroll GL Interface

The Program will export the records by referring to the pre-defined Source View. Only the column with prefix “F_” will be export.

Below are the reserved fields that must exist in the VIEW script.

• PCY_ID

• SPP_ID

The following fields are optional in the VIEW script.

• ROW_NUM

• PAY_ID

• PAY_AMOUNT

The records generated are stored in the PTG table to prevent double postings.