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