Transaction Bundles

Transaction Bundles are groups of pre-fabricated transaction records loaded by the Transaction Data Entry application dynamically, during the data entry. What Bundle will be loaded depends on the GL and Subledger account used for the given transaction. Bundles are maintained by the Suggested Distribution utility of the Transaction Data Entry application.

Information on the Bundles is stored in table SF_SYSBundle of the following structure:

Column Generalized data type Use
Name VARCHAR(255) Name of the bundle
Description VARCHAR(255) Description of the bundle
GLPrefix VARCHAR(255) GL prefix that triggers loading of the bundle
GLNumber VARCHAR(255) GL number that triggers loading of the bundle
SLNumber VARCHAR(255) Subledger number that triggers loading of the bundle
AmountOption TINYINT Units of amount (% or $)
Distribution BLOB Archived array of transaction records
SF_UserId VARCHAR(255) User-id of the user that last updated the bundle
SF_DateChanged CHAR(8) Date of the last update of the row (CCYYMMDD)
SF_TimeChanged CHAR(6) Time of the last update of the row (HHMMSS)
SF_TimeStamp SMALLINT Version of the row (incremented with each update)

Notes:

The table contains one row for each Transaction Bundle.

AmountOption is set to 0 for suggested amount values recorded as $ amounts, and 1 for the amount values recorded as % of the distributed amount (amount of the transaction line that triggers loading of the bundle).

Distribution stores an archived object that encapsulates transaction records that are loaded by the Transaction Data Entry application as the suggested distribution.

The following is a partial sample of contents of SF_SYSSpecialGL table:

Name                 GLPrefix   GLNumber   SLNumber   AmountOption
-------------------- ---------- ---------- ---------- ------------
PakSak               10         330        2434       0
BusForms             10         330        1689       0
YellowFreight        10         330        1257       0
Bertsch              10         330        1027       0
RiverCityElectronics 10         330        2169       0
NorthMed             10         330        2370       0
MMAServiceCorp       10         330        2077       0
FortisBenefits       10         330        2367       0
PriorityHealth       10         330        1980       0
Vanguard             10         330        2313       0
SmartLease           10         330        2333       0
PayrollTax           10         330        1274       1
Payroll              10         330        1220       0
USPostOffice         10         330        2410       0
RJLProperties        10         330        2377       0
RAGraf               10         330        1968       0
Brigade              10         330        2043       0
ComputerNetwork      10         330        2525       0
OccupationalHealth   10         330        1341       0
WebbChemical         10         330        2339       0