Importing VAT Data from Third-Party Systems

External Flat Files - Flat File Journal Import Request Page

LOAD_JRNL_PNL

Import journal data contained in a flat file and insert it into PeopleSoft journal tables.

GL_JRNL_IMP

Use this utility to insert rows into the PS_JRNL_HEADER, PS_JRNL_LN, PS_JRNL_VAT, PS_OPEN_ITEM_GL, and PS_JRNL_CF_BAL_TBL tables from data contained in a flat file. A commit is performed after all data in the file loads successfully. If the commit process fails, the entire load process is rolled back. You can run multiple instances of this Application Engine process with smaller flat files in a logical unit of work.

Group the flat file rows in hierarchical order with the header first, followed by the associated journal lines and control lines.

The system uses two system sources, EXT and EXV, to import data. System Source EXT enables the system to recognize that VAT Applicable/VAT Account selection is associated with an account and proceeds to calculate VAT and generates the additional accounting lines to be posted to the VAT accounts.

System source EXV prevents the system from processing the journal for VAT so you can load all VAT information from a flat file. Therefore, use EXV to import VAT information and populate the JRNL_VAT table with transactions exactly as they are in the flat file, and use EXT to load journals to populate any missing values with default values and VAT lines when necessary. Once the system populates JRNL_VAT, the imported VAT information is picked up by the VAT Transaction Loader.