Apicosoft

ERP iScala Database Structure
iScala Supprort & Customization

Business processes implementation, ad-hock services, end-users training and education, maintenance support.

Read More Contact Us
Epicor Service Connect

Integration with any third-party services. Customize internal workflows.

Read More Contact Us
Reporting

SAP Crystal Reports, SQL Server Reporting Services, Excel.

Read More Contact Us
Tables
Name Description Dependences Example
GL00 Ordered Reports File Company GL000100
GL03 Accounting Dimensions Company Year GL030112
GL06 General Ledger Transactions Company Year GL060112
GL07 Daybook Journal Transactions Company Year GL070112
GL08 Opening Balance Journal Transactions Company Year GL080112
GL09 Report Layouts Company GL090100
GL10 General Ledger Parameters Company Year GL100112
GL11 Automatic Allocations Company GL110100
GL12 Chart of Account Headings Company Year GL120112
GL14 Simulation Transactions Company Year GL140112
GL15 Transaction Workfile C Company GL150100
GL16 General Ledger Parameters 2 Company Year GL160112
GL18 Phrase File Company GL180100
GL19 Transaction Workfile D Company GL190100
GL1A GL Budget Profiles Company Year GL1A0112
GL21 Project History Transactions Company GL210100
GL22 Transaction Workfile A Company GL220100
GL23 Report Generator Company GL230100
GL24 Report Notes Company GL240100
GL25 Report Interactive Notes Company GL250100
GL26 Cash Flow Planned Transaction Setup Company GL260100
GL27 Cash Flow Accounts Company GL270100
GL28 Parameter File Interest Charge Project Company GL280100
GL29 Account Number Alias Company GL290100
GL30 Transaction Workfile B Company GL300100
GL34 WrkDepreciation GL340000
GL40 Consolidated Currencies Company Year GL400112
GL41 Consolidation Account Translations Company Year GL410112
GL42 Cash-Book Reconciliation Accounts Company GL420100
GL43 Cash-Book Reconciliation Transactions Company GL430100
GL44 Workfile Cheques Company GL440100
GL45 Transaction Text Company Year GL450112
GL46 Valid Coding Combinations Company Year GL460112
GL52 General Ledger Balances Company Year GL520112
GL53 Account Schedule Company Year GL530112
GL55 Foreign Descriptions Company Year GL550112
GL56 Commitments Company Year GL560112
GL57 Bank Statement Header Company GL570100
GL58 Bank Statement Transactions Company GL580100
GL59 Reconcilation Proposal Company GL590100
GL5A Multi-Currency Links Company Year GL5A0112
GL5B Multi-Currency General Ledger Balances Company Year GL5B0112
GL5C Bank Definition Company GL5C0100
GL5D Multi-Link Statistical Account Balances Company Year GL5D0112
GL5S SPED parameters Company Year GL5S0112
GL60 Compound Allocations Company GL600100
GL61 Compound Allocation Descriptions Company GL610100
GL62 Compound Allocation Lines Company GL620100
GL65 Compound Allocation Remeasurement Transactions Company GL650100
GL67 Compound Allocation Selection History Company GL670100
GL77 EMU Conversion Set-up Company GL770100
GL80 Un-Authorized Transactions (Greece) Company Year GL800112
GLB2 Operation Details Company GLB20100
GLB3 Receipt Information Company GLB30100
GLBT Converted GL06 transactions Company Year GLBT0112
GLC1 Statement- or Debit/Credit Notification Message Company GLC10100
GLC2 Statement- or Debit/Credit Notification Message Page Company GLC20100
GLC3 Statement- or Debit/Credit Notification Company GLC30100
GLC4 Statement- or Debit/Credit Notification Entry Company GLC40100
GLC5 Statement- or Debit/Credit Notification Entry Detail Company GLC50100
GLC6 Statement- or Debit/Credit Notification Entry Detail Transaction Company GLC60100
GLC7 Statement- or Debit/Credit Notification Entry Detail Transaction Unstructured Remittance Company GLC70100
GLC8 Statement- or Debit/Credit Notification Entry Detail Transaction Structured Remittance Company GLC80100
GLC9 Charges Company GLC90100
GLCB Petty Cash Master Table Company Year GLCB0112
GLCD Petty Cash Desk Parameters Company Year GLCD0112
GLCE Cash Office Company GLCE0100
GLCF Cash Office Language Dependent Description Company GLCF0100
GLCG Reason Code Company GLCG0100
GLCH Notification processing template header Company GLCH0100
GLCI Reason Code Language Dependent Description Company GLCI0100
GLCL Notification processing template Line Company GLCL0100
GLCW Compound Periodic Allocation Work File GLCW0000
GLCX Petty Cash Extension File Company Year GLCX0112
GLCY Petty Cash Transaction File Company Year GLCY0112
GLEB Extended General Ledger Balance Company Year GLEB0112
GLF1 Financial Reporting Report Definition Company GLF10100
GLF2 Financial Reporting RowSet Company GLF20100
GLF3 Financial Reporting Row Company GLF30100
GLF4 Financial Reporting Leaf Row Properties Company GLF40100
GLF5 Financial Reporting ColumnSet Company GLF50100
GLF6 Financial Reporting Column Company GLF60100
GLF7 Accounting Dimension Categories Company GLF70100
GLF8 Accounting Dimension Categories Leaf Properties Company GLF80100
GLFA Financial Reporting Report Definition Descriptions Company GLFA0100
GLFB Financial Reporting RowSet Descriptions Company GLFB0100
GLFC Financial Reporting Row Descriptions Company GLFC0100
GLFD Financial Reporting ColumnSet Descriptions Company GLFD0100
GLFE Financial Reporting Column Descriptions Company GLFE0100
GLFF Accounting Dimension Categories Descriptions Company GLFF0100
GLGL GL Consolidation Company GLGL0100
GLH0 PMS Interface File Structure Definition (Header) Company GLH00100
GLH1 PMS Interface File Structure Definition (Records) Company GLH10100
GLH2 PMS Interface Mapping File Company GLH20100
GLHI FA Transaction History Company GLHI0100
GLII Company fiscal parameters for Italian fiscal reports Company GLII0100
GLR1 Company GLR10100
GLR2 Company GLR20100
GLR6 GL Reversed Transactions Company Year GLR60112
GLR7 GL Reversed Transactions in Daybook Journal Company Year GLR70112
GLRD Company GLRD0100
GLRH Revenue Recognition History WIP Journal Company GLRH0100
GLRJ Company Year GLRJ0112
GLRM Revenue Recognition Model Codes Company GLRM0100
GLRR Company GLRR0100
GLTH BLiner functionality Company Year GLTH0112
GLTM Transaction Mapping Company GLTM0100
GLTR Transformation Rules for BLiner functionality Company Year GLTR0112
GLXX Wrk. Acc.Spec. GLXX0000
GLXZ SQL work file GLXZ0000
GLZZ Hyperion Export Parameters Company GLZZ0100
sca_trg_Audit_GL03 Audit trigger for GL03 table Company Year sca_trg_Audit_GL030112
sca_trg_Audit_GL10 Audit trigger for GL10 table Company Year sca_trg_Audit_GL100112
sca_trg_Audit_GL16 Audit trigger for GL16 table Company Year sca_trg_Audit_GL160112
sca_trg_Audit_GL53 Audit trigger for GL53 table Company Year sca_trg_Audit_GL530112
sca_trg_Audit_GLCD Audit trigger for GLCD table Company Year sca_trg_Audit_GLCD0112
sca_trg_Audit_GLCE Audit trigger for GLCE table Company sca_trg_Audit_GLCE0100
sca_trg_Audit_GLCF Audit trigger for GLCF table Company sca_trg_Audit_GLCF0100
sca_trg_Audit_GLCG Audit trigger for GLCG table Company sca_trg_Audit_GLCG0100
sca_trg_Audit_GLCI Audit trigger for GLCI table Company sca_trg_Audit_GLCI0100

Fields
PK Table Name Description Type Length Precision Note
1 GL28 GL28001 IndexKey STRING 2 2 0 Index Key
GL28 GL28002 PriIncl_0_0 VSTRING 12 12 0 Interval 0 Minimum Project to Include
GL28 GL28003 PriIncl_1_0 VSTRING 12 12 0 Interval 0 Maximum Project to Include
GL28 GL28004 PrxIncl0 VSTRING 1 1 0 Interval 0 Include Type d - Only debit transactions (positive amounts) are included.
c - Only credit transactions (negative amounts) are included.
x - All transactions will be included.
GL28 GL28005 PriExcl_0_0 VSTRING 12 12 0 Interval 0 Minimum Project to Exclude
GL28 GL28006 PriExcl_1_0 VSTRING 12 12 0 Interval 0 Maximum Project to Exclude
GL28 GL28007 PrxExcl0 VSTRING 1 1 0 Interval 0 Exclude Type d - Only debit transactions (positive amounts) are not included.
c - Only credit transactions (negative amounts) are not included
x - No transactions for these Accounts are included.
GL28 GL28008 PriIncl_0_1 VSTRING 12 12 0 Interval 1 Minimum Project to Include
GL28 GL28009 PriIncl_1_1 VSTRING 12 12 0 Interval 1 Maximum Project to Include
GL28 GL28010 PrxIncl1 VSTRING 1 1 0 Interval 1 Include Type
GL28 GL28011 PriExcl_0_1 VSTRING 12 12 0 Interval 1 Minimum Project to Exclude
GL28 GL28012 PriExcl_1_1 VSTRING 12 12 0 Interval 1 Maximum Project to Exclude
GL28 GL28013 PrxExcl1 VSTRING 1 1 0 Interval 1 Exclude Type
GL28 GL28014 PriIncl_0_2 VSTRING 12 12 0 Interval 2 Minimum Project to Include
GL28 GL28015 PriIncl_1_2 VSTRING 12 12 0 Interval 2 Maximum Project to Include
GL28 GL28016 PrxIncl2 VSTRING 1 1 0 Interval 2 Include Type
GL28 GL28017 PriExcl_0_2 VSTRING 12 12 0 Interval 2 Minimum Project to Exclude
GL28 GL28018 PriExcl_1_2 VSTRING 12 12 0 Interval 2 Maximum Project to Exclude
GL28 GL28019 PrxExcl2 VSTRING 1 1 0 Interval 2 Exclude Type
GL28 GL28020 PriIncl_0_3 VSTRING 12 12 0 Interval 3 Minimum Project to Include
GL28 GL28021 PriIncl_1_3 VSTRING 12 12 0 Interval 3 Maximum Project to Include
GL28 GL28022 PrxIncl3 VSTRING 1 1 0 Interval 3 Include Type
GL28 GL28023 PriExcl_0_3 VSTRING 12 12 0 Interval 3 Minimum Project to Exclude
GL28 GL28024 PriExcl_1_3 VSTRING 12 12 0 Interval 3 Maximum Project to Exclude
GL28 GL28025 PrxExcl3 VSTRING 1 1 0 Interval 3 Exclude Type
GL28 GL28026 PriIncl_0_4 VSTRING 12 12 0 Interval 4 Minimum Project to Include
GL28 GL28027 PriIncl_1_4 VSTRING 12 12 0 Interval 4 Maximum Project to Include
GL28 GL28028 PrxIncl4 VSTRING 1 1 0 Interval 4 Include Type
GL28 GL28029 PriExcl_0_4 VSTRING 12 12 0 Interval 4 Minimum Project to Exclude
GL28 GL28030 PriExcl_1_4 VSTRING 12 12 0 Interval 4 Maximum Project to Exclude
GL28 GL28031 PrxExcl4 VSTRING 1 1 0 Interval 4 Exclude Type
GL28 GL28032 PriIncl_0_5 VSTRING 12 12 0 Interval 5 Minimum Project to Include
GL28 GL28033 PriIncl_1_5 VSTRING 12 12 0 Interval 5 Maximum Project to Include
GL28 GL28034 PrxIncl5 VSTRING 1 1 0 Interval 5 Include Type
GL28 GL28035 PriExcl_0_5 VSTRING 12 12 0 Interval 5 Minimum Project to Exclude
GL28 GL28036 PriExcl_1_5 VSTRING 12 12 0 Interval 5 Maximum Project to Exclude
GL28 GL28037 PrxExcl5 VSTRING 1 1 0 Interval 5 Exclude Type
GL28 GL28038 PriIncl_0_6 VSTRING 12 12 0 Interval 6 Minimum Project to Include
GL28 GL28039 PriIncl_1_6 VSTRING 12 12 0 Interval 6 Maximum Project to Include
GL28 GL28040 PrxIncl6 VSTRING 1 1 0 Interval 6 Include Type
GL28 GL28041 PriExcl_0_6 VSTRING 12 12 0 Interval 6 Minimum Project to Exclude
GL28 GL28042 PriExcl_1_6 VSTRING 12 12 0 Interval 6 Maximum Project to Exclude
GL28 GL28043 PrxExcl6 VSTRING 1 1 0 Interval 6 Exclude Type
GL28 GL28044 PriIncl_0_7 VSTRING 12 12 0 Interval 7 Minimum Project to Include
GL28 GL28045 PriIncl_1_7 VSTRING 12 12 0 Interval 7 Maximum Project to Include
GL28 GL28046 PrxIncl7 VSTRING 1 1 0 Interval 7 Include Type
GL28 GL28047 PriExcl_0_7 VSTRING 12 12 0 Interval 7 Minimum Project to Exclude
GL28 GL28048 PriExcl_1_7 VSTRING 12 12 0 Interval 7 Maximum Project to Exclude
GL28 GL28049 PrxExcl7 VSTRING 1 1 0 Interval 7 Exclude Type
GL28 GL28050 PriIncl_0_8 VSTRING 12 12 0 Interval 8 Minimum Project to Include
GL28 GL28051 PriIncl_1_8 VSTRING 12 12 0 Interval 8 Maximum Project to Include
GL28 GL28052 PrxIncl8 VSTRING 1 1 0 Interval 8 Include Type
GL28 GL28053 PriExcl_0_8 VSTRING 12 12 0 Interval 8 Minimum Project to Exclude
GL28 GL28054 PriExcl_1_8 VSTRING 12 12 0 Interval 8 Maximum Project to Exclude
GL28 GL28055 PrxExcl8 VSTRING 1 1 0 Interval 8 Exclude Type
GL28 GL28056 PriIncl_0_9 VSTRING 12 12 0 Interval 9 Minimum Project to Include
GL28 GL28057 PriIncl_1_9 VSTRING 12 12 0 Interval 9 Maximum Project to Include
GL28 GL28058 PrxIncl9 VSTRING 1 1 0 Interval 9 Include Type
GL28 GL28059 PriExcl_0_9 VSTRING 12 12 0 Interval 9 Minimum Project to Exclude
GL28 GL28060 PriExcl_1_9 VSTRING 12 12 0 Interval 9 Maximum Project to Exclude
GL28 GL28061 PrxExcl9 VSTRING 1 1 0 Interval 9 Exclude Type
GL28 GL28062 PriIncl_0_10 VSTRING 12 12 0 Interval 10 Minimum Project to Include
GL28 GL28063 PriIncl_1_10 VSTRING 12 12 0 Interval 10 Maximum Project to Include
GL28 GL28064 PrxIncl10 VSTRING 1 1 0 Interval 10 Include Type
GL28 GL28065 PriExcl_0_10 VSTRING 12 12 0 Interval 10 Minimum Project to Exclude
GL28 GL28066 PriExcl_1_10 VSTRING 12 12 0 Interval 10 Maximum Project to Exclude
GL28 GL28067 PrxExcl10 VSTRING 1 1 0 Interval 10 Exclude Type
GL28 GL28068 PriIncl_0_11 VSTRING 12 12 0 Interval 11 Minimum Project to Include
GL28 GL28069 PriIncl_1_11 VSTRING 12 12 0 Interval 11 Maximum Project to Include
GL28 GL28070 PrxIncl11 VSTRING 1 1 0 Interval 11 Include Type
GL28 GL28071 PriExcl_0_11 VSTRING 12 12 0 Interval 11 Minimum Project to Exclude
GL28 GL28072 PriExcl_1_11 VSTRING 12 12 0 Interval 11 Maximum Project to Exclude
GL28 GL28073 PrxExcl11 VSTRING 1 1 0 Interval 11 Exclude Type
GL28 GL28074 PriIncl_0_12 VSTRING 12 12 0 Interval 12 Minimum Project to Include
GL28 GL28075 PriIncl_1_12 VSTRING 12 12 0 Interval 12 Maximum Project to Include
GL28 GL28076 PrxIncl12 VSTRING 1 1 0 Interval 12 Include Type
GL28 GL28077 PriExcl_0_12 VSTRING 12 12 0 Interval 12 Minimum Project to Exclude
GL28 GL28078 PriExcl_1_12 VSTRING 12 12 0 Interval 12 Maximum Project to Exclude
GL28 GL28079 PrxExcl12 VSTRING 1 1 0 Interval 12 Exclude Type
GL28 GL28080 PriIncl_0_13 VSTRING 12 12 0 Interval 13 Minimum Project to Include
GL28 GL28081 PriIncl_1_13 VSTRING 12 12 0 Interval 13 Maximum Project to Include
GL28 GL28082 PrxIncl13 VSTRING 1 1 0 Interval 13 Include Type
GL28 GL28083 PriExcl_0_13 VSTRING 12 12 0 Interval 13 Minimum Project to Exclude
GL28 GL28084 PriExcl_1_13 VSTRING 12 12 0 Interval 13 Maximum Project to Exclude
GL28 GL28085 PrxExcl13 VSTRING 1 1 0 Interval 13 Exclude Type
GL28 GL28086 PriIncl_0_14 VSTRING 12 12 0 Interval 14 Minimum Project to Include
GL28 GL28087 PriIncl_1_14 VSTRING 12 12 0 Interval 14 Maximum Project to Include
GL28 GL28088 PrxIncl14 VSTRING 1 1 0 Interval 14 Include Type
GL28 GL28089 PriExcl_0_14 VSTRING 12 12 0 Interval 14 Minimum Project to Exclude
GL28 GL28090 PriExcl_1_14 VSTRING 12 12 0 Interval 14 Maximum Project to Exclude
GL28 GL28091 PrxExcl14 VSTRING 1 1 0 Interval 14 Exclude Type
GL28 GL28092 PriIncl_0_15 VSTRING 12 12 0 Interval 15 Minimum Project to Include
GL28 GL28093 PriIncl_1_15 VSTRING 12 12 0 Interval 15 Maximum Project to Include
GL28 GL28094 PrxIncl15 VSTRING 1 1 0 Interval 15 Include Type
GL28 GL28095 PriExcl_0_15 VSTRING 12 12 0 Interval 15 Minimum Project to Exclude
GL28 GL28096 PriExcl_1_15 VSTRING 12 12 0 Interval 15 Maximum Project to Exclude
GL28 GL28097 PrxExcl15 VSTRING 1 1 0 Interval 15 Exclude Type
GL28 GL28098 PriIncl_0_16 VSTRING 12 12 0 Interval 16 Minimum Project to Include
GL28 GL28099 PriIncl_1_16 VSTRING 12 12 0 Interval 16 Maximum Project to Include
GL28 GL28100 PrxIncl16 VSTRING 1 1 0 Interval 16 Include Type
GL28 GL28101 PriExcl_0_16 VSTRING 12 12 0 Interval 16 Minimum Project to Exclude
GL28 GL28102 PriExcl_1_16 VSTRING 12 12 0 Interval 16 Maximum Project to Exclude
GL28 GL28103 PrxExcl16 VSTRING 1 1 0 Interval 16 Exclude Type
GL28 GL28104 PriIncl_0_17 VSTRING 12 12 0 Interval 17 Minimum Project to Include
GL28 GL28105 PriIncl_1_17 VSTRING 12 12 0 Interval 17 Maximum Project to Include
GL28 GL28106 PrxIncl17 VSTRING 1 1 0 Interval 17 Include Type
GL28 GL28107 PriExcl_0_17 VSTRING 12 12 0 Interval 17 Minimum Project to Exclude
GL28 GL28108 PriExcl_1_17 VSTRING 12 12 0 Interval 17 Maximum Project to Exclude
GL28 GL28109 PrxExcl17 VSTRING 1 1 0 Interval 17 Exclude Type
GL28 GL28110 PriIncl_0_18 VSTRING 12 12 0 Interval 18 Minimum Project to Include
GL28 GL28111 PriIncl_1_18 VSTRING 12 12 0 Interval 18 Maximum Project to Include
GL28 GL28112 PrxIncl18 VSTRING 1 1 0 Interval 18 Include Type
GL28 GL28113 PriExcl_0_18 VSTRING 12 12 0 Interval 18 Minimum Project to Exclude
GL28 GL28114 PriExcl_1_18 VSTRING 12 12 0 Interval 18 Maximum Project to Exclude
GL28 GL28115 PrxExcl18 VSTRING 1 1 0 Interval 18 Exclude Type
GL28 GL28116 PriIncl_0_19 VSTRING 12 12 0 Interval 19 Minimum Project to Include
GL28 GL28117 PriIncl_1_19 VSTRING 12 12 0 Interval 19 Maximum Project to Include
GL28 GL28118 PrxIncl19 VSTRING 1 1 0 Interval 19 Include Type
GL28 GL28119 PriExcl_0_19 VSTRING 12 12 0 Interval 19 Minimum Project to Exclude
GL28 GL28120 PriExcl_1_19 VSTRING 12 12 0 Interval 19 Maximum Project to Exclude
GL28 GL28121 PrxExcl19 VSTRING 1 1 0 Interval 19 Exclude Type
GL28 GL28122 PriIncl_0_20 VSTRING 12 12 0 Interval 20 Minimum Project to Include
GL28 GL28123 PriIncl_1_20 VSTRING 12 12 0 Interval 20 Maximum Project to Include
GL28 GL28124 PrxIncl20 VSTRING 1 1 0 Interval 20 Include Type
GL28 GL28125 PriExcl_0_20 VSTRING 12 12 0 Interval 20 Minimum Project to Exclude
GL28 GL28126 PriExcl_1_20 VSTRING 12 12 0 Interval 20 Maximum Project to Exclude
GL28 GL28127 PrxExcl20 VSTRING 1 1 0 Interval 20 Exclude Type
GL28 GL28128 PriIncl_0_21 VSTRING 12 12 0 Interval 21 Minimum Project to Include
GL28 GL28129 PriIncl_1_21 VSTRING 12 12 0 Interval 21 Maximum Project to Include
GL28 GL28130 PrxIncl21 VSTRING 1 1 0 Interval 21 Include Type
GL28 GL28131 PriExcl_0_21 VSTRING 12 12 0 Interval 21 Minimum Project to Exclude
GL28 GL28132 PriExcl_1_21 VSTRING 12 12 0 Interval 21 Maximum Project to Exclude
GL28 GL28133 PrxExcl21 VSTRING 1 1 0 Interval 21 Exclude Type
GL28 GL28134 PriIncl_0_22 VSTRING 12 12 0 Interval 22 Minimum Project to Include
GL28 GL28135 PriIncl_1_22 VSTRING 12 12 0 Interval 22 Maximum Project to Include
GL28 GL28136 PrxIncl22 VSTRING 1 1 0 Interval 22 Include Type
GL28 GL28137 PriExcl_0_22 VSTRING 12 12 0 Interval 22 Minimum Project to Exclude
GL28 GL28138 PriExcl_1_22 VSTRING 12 12 0 Interval 22 Maximum Project to Exclude
GL28 GL28139 PrxExcl22 VSTRING 1 1 0 Interval 22 Exclude Type
GL28 GL28140 PriIncl_0_23 VSTRING 12 12 0 Interval 23 Minimum Project to Include
GL28 GL28141 PriIncl_1_23 VSTRING 12 12 0 Interval 23 Maximum Project to Include
GL28 GL28142 PrxIncl23 VSTRING 1 1 0 Interval 23 Include Type
GL28 GL28143 PriExcl_0_23 VSTRING 12 12 0 Interval 23 Minimum Project to Exclude
GL28 GL28144 PriExcl_1_23 VSTRING 12 12 0 Interval 23 Maximum Project to Exclude
GL28 GL28145 PrxExcl23 VSTRING 1 1 0 Interval 23 Exclude Type
GL28 GL28146 PriIncl_0_24 VSTRING 12 12 0 Interval 24 Minimum Project to Include
GL28 GL28147 PriIncl_1_24 VSTRING 12 12 0 Interval 24 Maximum Project to Include
GL28 GL28148 PrxIncl24 VSTRING 1 1 0 Interval 24 Include Type
GL28 GL28149 PriExcl_0_24 VSTRING 12 12 0 Interval 24 Minimum Project to Exclude
GL28 GL28150 PriExcl_1_24 VSTRING 12 12 0 Interval 24 Maximum Project to Exclude
GL28 GL28151 PrxExcl24 VSTRING 1 1 0 Interval 24 Exclude Type
GL28 GL28152 PriIncl_0_25 VSTRING 12 12 0 Interval 25 Minimum Project to Include
GL28 GL28153 PriIncl_1_25 VSTRING 12 12 0 Interval 25 Maximum Project to Include
GL28 GL28154 PrxIncl25 VSTRING 1 1 0 Interval 25 Include Type
GL28 GL28155 PriExcl_0_25 VSTRING 12 12 0 Interval 25 Minimum Project to Exclude
GL28 GL28156 PriExcl_1_25 VSTRING 12 12 0 Interval 25 Maximum Project to Exclude
GL28 GL28157 PrxExcl25 VSTRING 1 1 0 Interval 25 Exclude Type
GL28 GL28158 PriIncl_0_26 VSTRING 12 12 0 Interval 26 Minimum Project to Include
GL28 GL28159 PriIncl_1_26 VSTRING 12 12 0 Interval 26 Maximum Project to Include
GL28 GL28160 PrxIncl26 VSTRING 1 1 0 Interval 26 Include Type
GL28 GL28161 PriExcl_0_26 VSTRING 12 12 0 Interval 26 Minimum Project to Exclude
GL28 GL28162 PriExcl_1_26 VSTRING 12 12 0 Interval 26 Maximum Project to Exclude
GL28 GL28163 PrxExcl26 VSTRING 1 1 0 Interval 26 Exclude Type
GL28 GL28164 PriIncl_0_27 VSTRING 12 12 0 Interval 27 Minimum Project to Include
GL28 GL28165 PriIncl_1_27 VSTRING 12 12 0 Interval 27 Maximum Project to Include
GL28 GL28166 PrxIncl27 VSTRING 1 1 0 Interval 27 Include Type
GL28 GL28167 PriExcl_0_27 VSTRING 12 12 0 Interval 27 Minimum Project to Exclude
GL28 GL28168 PriExcl_1_27 VSTRING 12 12 0 Interval 27 Maximum Project to Exclude
GL28 GL28169 PrxExcl27 VSTRING 1 1 0 Interval 27 Exclude Type
GL28 GL28170 PriIncl_0_28 VSTRING 12 12 0 Interval 28 Minimum Project to Include
GL28 GL28171 PriIncl_1_28 VSTRING 12 12 0 Interval 28 Maximum Project to Include
GL28 GL28172 PrxIncl28 VSTRING 1 1 0 Interval 28 Include Type
GL28 GL28173 PriExcl_0_28 VSTRING 12 12 0 Interval 28 Minimum Project to Exclude
GL28 GL28174 PriExcl_1_28 VSTRING 12 12 0 Interval 28 Maximum Project to Exclude
GL28 GL28175 PrxExcl28 VSTRING 1 1 0 Interval 28 Exclude Type
GL28 GL28176 PriIncl_0_29 VSTRING 12 12 0 Interval 29 Minimum Project to Include
GL28 GL28177 PriIncl_1_29 VSTRING 12 12 0 Interval 29 Maximum Project to Include
GL28 GL28178 PrxIncl29 VSTRING 1 1 0 Interval 29 Include Type
GL28 GL28179 PriExcl_0_29 VSTRING 12 12 0 Interval 29 Minimum Project to Exclude
GL28 GL28180 PriExcl_1_29 VSTRING 12 12 0 Interval 29 Maximum Project to Exclude
GL28 GL28181 PrxExcl29 VSTRING 1 1 0 Interval 29 Exclude Type
GL28 GL28182 PriIncl_0_30 VSTRING 12 12 0 Interval 30 Minimum Project to Include
GL28 GL28183 PriIncl_1_30 VSTRING 12 12 0 Interval 30 Maximum Project to Include
GL28 GL28184 PrxIncl30 VSTRING 1 1 0 Interval 30 Include Type
GL28 GL28185 PriExcl_0_30 VSTRING 12 12 0 Interval 30 Minimum Project to Exclude
GL28 GL28186 PriExcl_1_30 VSTRING 12 12 0 Interval 30 Maximum Project to Exclude
GL28 GL28187 PrxExcl30 VSTRING 1 1 0 Interval 30 Exclude Type
GL28 GL28188 PriIncl_0_31 VSTRING 12 12 0 Interval 31 Minimum Project to Include
GL28 GL28189 PriIncl_1_31 VSTRING 12 12 0 Interval 31 Maximum Project to Include
GL28 GL28190 PrxIncl31 VSTRING 1 1 0 Interval 31 Include Type
GL28 GL28191 PriExcl_0_31 VSTRING 12 12 0 Interval 31 Minimum Project to Exclude
GL28 GL28192 PriExcl_1_31 VSTRING 12 12 0 Interval 31 Maximum Project to Exclude
GL28 GL28193 PrxExcl31 VSTRING 1 1 0 Interval 31 Exclude Type
GL28 GL28194 PriIncl_0_32 VSTRING 12 12 0 Interval 32 Minimum Project to Include
GL28 GL28195 PriIncl_1_32 VSTRING 12 12 0 Interval 32 Maximum Project to Include
GL28 GL28196 PrxIncl32 VSTRING 1 1 0 Interval 32 Include Type
GL28 GL28197 PriExcl_0_32 VSTRING 12 12 0 Interval 32 Minimum Project to Exclude
GL28 GL28198 PriExcl_1_32 VSTRING 12 12 0 Interval 32 Maximum Project to Exclude
GL28 GL28199 PrxExcl32 VSTRING 1 1 0 Interval 32 Exclude Type
GL28 GL28200 PriIncl_0_33 VSTRING 12 12 0 Interval 33 Minimum Project to Include
GL28 GL28201 PriIncl_1_33 VSTRING 12 12 0 Interval 33 Maximum Project to Include
GL28 GL28202 PrxIncl33 VSTRING 1 1 0 Interval 33 Include Type
GL28 GL28203 PriExcl_0_33 VSTRING 12 12 0 Interval 33 Minimum Project to Exclude
GL28 GL28204 PriExcl_1_33 VSTRING 12 12 0 Interval 33 Maximum Project to Exclude
GL28 GL28205 PrxExcl33 VSTRING 1 1 0 Interval 33 Exclude Type
GL28 GL28206 MinDat DATE 8 0 0 Minimum Date
GL28 GL28207 MaxDat DATE 8 0 0 Maximum Date
GL28 GL28208 MinPro VSTRING 12 12 0 Minimum Project
GL28 GL28209 MaxPro VSTRING 12 12 0 Maximum Project
GL28 GL28210 MinKat VSTRING 2 2 0 Minimum Category
GL28 GL28211 MaxKat VSTRING 2 2 0 Maximum Category
GL28 GL28212 InclClo INTEGER 2 0 0 Include Closed Projects
GL28 GL28213 Proint X_NUMERIC 7 15 8 Interest to Charge (Year)
GL28 GL28214 SimNo VSTRING 2 2 0 Simulation Number
GL28 GL28215 IntAc VSTRING 12 12 0 Account Interest
GL28 GL28216 BalAc VSTRING 12 12 0 Account Contra