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
SF_Name VARCHAR(255) Name of the bundle
SF_Description VARCHAR(255) Description of the bundle
SF_GLPrefix VARCHAR(255) GL prefix that triggers loading of the bundle
SF_GLNumber VARCHAR(255) GL number that triggers loading of the bundle
SF_SLNumber VARCHAR(255) Subledger number that triggers loading of the bundle
SF_AmountOption TINYINT Units of amount (% or $)
SF_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.

SF_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).

SF_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:

SF_Name              SF_GLPrefix SF_GLNumber SF_SLNumber SF_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