2.1.9 GL Setup Upload Interface Format

This topic explains the information on GL Setup Upload Interface Format.

Files uploaded using the GL Setup Upload should have the following format:

Table 2-36 GL Setup Upload Interface Format

Field Name Data Type Details
Fund Id Character (6) -
GL Template Id Character (10) The template Id of the GL set up. A dummy value to be provided for this
Account type Character (2) The account type of the GL set up
Business Event Character (2) One of the valid codes for business events
Trigger Event Character (15) The triggering event. One of the valid enumerations for the triggering event
Theoretical Flag Character (1) Y: Theoretical N: Actual
Setup Enabled Character (1) Y: Enabled N: Disabled
Component Id Character (20) One of the valid codes for business events
Component Description Character (255) Description of the component code
Debit credit Flag Character (2) Dr: Debit Cr: Credit
GL set up for primary Character (1) C: CASA G:GL S:SAP P:Payment
Primary Entity Type Character (1)
The primary entity type of the GL set up:
  • U: Uniholder
  • D: Distributor
  • M: AMC
  • F: Fund
Account Number Character (16) -
AccountCurrency Character (3) -
Transaction Currency Character (3) -
Bank branch Character (12) -
Direct DebitApplicable Character (1)
  • 1: Applicable
  • 0: Not applicable
GL setup for Contra Character (1)
  • C: CASA
  • G: GL
  • S: SAP
  • P: Payment
Contra Primary Entity Type Character (1)

U: Uniholder

D: Distributor

M: AMC

F: Fund
Contra Account Number Character (16) -
Contra Account Currency Character (3) -
Contra Transaction Currency Character (3) -
Contra Bank branch Character (12) -
Contra Direct DebitApplicable Character (1)
  • 1: Applicable
  • 0: Not applicable
Restricted reference types Character (255) A semicolon separated list of the restricted reference types
GL Currency Character (3) -
GL reference number Character (10) -
Product Id Character (10) -
Product or Fund Level Character (1)
  • F: Fund Level
  • P: Product level
Mode of upload Character (1)
  • N: new mode
  • A: Amend mode

Parent topic: Fund Rules Upload Formats