GL0 G/L Parameters (GL0_CustomFSDescription) Level: 4.40
Record Type: 1 G/L Parameter Record 08/28/2009
File Type: Direct Key Size: 9 Rec Len: 256 Min Len: 67 Define: N
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
'G/L' (Application Code). . . . . . . . GLApplicationCode . . . . . . String *(1,3)
Company Code. . . . . . . . . . . . . . CompanyCode . . . . . . . . . String *(4,3)
New System? . . . . . . . . . . . . . . NewSystem . . . . . . . . . . Yes/No (7,1)
Account No - Segment 1. . . . . . . . . AccountNoSegment1 . . . . . . Zero-Filled (8,1)
Account No - Segment 2. . . . . . . . . AccountNoSegment2 . . . . . . Zero-Filled (9,1)
Account No - Segment 3. . . . . . . . . AccountNoSegment3 . . . . . . Zero-Filled (10,1)
Allow New Accnt Addtn In Data Entry . . AllowNewAccntAddInDataEntry . Yes/No (11,1)
Have Budget Amounts Been Changed? Ents HaveBudgetAmountsBeenChanged. Zero-Filled (12,1)
('0' = No '1' = Yes) . . . . . . . . . . . . . . . . . . . . . . Memo
Must Run F/S Update Again?. . . . . . . MustRunFSUpdateAgain. . . . . Yes/No (13,1)
Last Period Updated In F/S Update . . . LastPeriodUpdatedInFSUpdate . Zero-Filled (14,2)
Reset Journal #'S @ Year End? (Ynp) . . ResetJournalNoAtYrEnd . . . . Uppercase (16,1)
(Yes, No, @ Period End) . . . . . . . . . . . . . . . . . . . . . . Memo
Current Budget Yr End Optn (C23Az). . . CurrentBudgetYrEndOptn. . . . Uppercase (17,1)
C = Copy From Current Budget. . . . . . . . . . . . . . . . . . . Memo
2/3 = Copy From Budget 2 Or 3 . . . . . . . . . . . . . . . . . . . Memo
A = Copy From Actual. . . . . . . . . . . . . . . . . . . . . . . Memo
Z = Zero The Budget Fields. . . . . . . . . . . . . . . . . . . . Memo
N = No Change . . . . . . . . . . . . . . . . . . . . . . . . . . Memo
Default Budget For Financials (C23) . . DefaultBudgetForFinancials. . Uppercase (18,1)
Allow Budget Maint In Acct Maint? . . . AllowBdgtMaintInAccountMaint. Yes/No (19,1)
Integrate To Bank Rec?. . . . . . . . . IntegrateToBankRec. . . . . . Yes/No (20,1)
Period End Allocation Status. . . . . . PeriodEndAllocationStatus . . Zero-Filled (21,1)
0=Not Begun This Period . . . . . . . . . . . . . . . . . . . . . . Memo
1=Selected, 2=Updated . . . . . . . . . . . . . . . . . . . . . . Memo
Retained Earnings Account . . . . . . . RetainedEarningsAccount . . . G/L Account (22,9)
No. Of Acct Prds (For Curr Fisc Yr) . . NoOfAccountingPdCurrFiscYr. . String (31,2)
Current Accounting Period . . . . . . . CurrentAccountingPeriod . . . Zero-Filled (33,2)
Current Calendar Year . . . . . . . . . CurrentCalendarYr . . . . . . Packed Year (35,2)
Curr Fisc Yr Per End Date 1 (Mmdd). . . CurrFiscalYrPer1EndDate . . . Zero-Filled (37,4)
Curr Fisc Yr Per End Date 2 . . . . . . CurrFiscalYrPer2EndDate . . . Zero-Filled (41,4)
Curr Fisc Yr Per End Date 3 . . . . . . CurrFiscalYrPer3EndDate . . . Zero-Filled (45,4)
Curr Fisc Yr Per End Date 4 . . . . . . CurrFiscalYrPer4EndDate . . . Zero-Filled (49,4)
Curr Fisc Yr Per End Date 5 . . . . . . CurrFiscalYrPer5EndDate . . . Zero-Filled (53,4)
Curr Fisc Yr Per End Date 6 . . . . . . CurrFiscalYrPer6EndDate . . . Zero-Filled (57,4)
Curr Fisc Yr Per End Date 7 . . . . . . CurrFiscalYrPer7EndDate . . . Zero-Filled (61,4)
Curr Fisc Yr Per End Date 8 . . . . . . CurrFiscalYrPer8EndDate . . . Zero-Filled (65,4)
Curr Fisc Yr Per End Date 9 . . . . . . CurrFiscalYrPer9EndDate . . . Zero-Filled (69,4)
Curr Fisc Yr Per End Date 10. . . . . . CurrFiscalYrPer10EndDate. . . Zero-Filled (73,4)
Curr Fisc Yr Per End Date 11. . . . . . CurrFiscalYrPer11EndDate. . . Zero-Filled (77,4)
Curr Fisc Yr Per End Date 12. . . . . . CurrFiscalYrPer12EndDate. . . Zero-Filled (81,4)
Curr Fisc Yr Per End Date 13. . . . . . CurrFiscalYrPer13EndDate. . . Zero-Filled (85,4)
Next Allocation Number. . . . . . . . . NextAllocationNumber. . . . . Uppercase (89,7)
Segment 2 Description . . . . . . . . . Segment2Description . . . . . String (96,15)
Segment 3 Description . . . . . . . . . Segment3Description . . . . . String (111,15)
Budget 3 Description. . . . . . . . . . Budget3Description. . . . . . String (126,17)
Current Fiscal Year . . . . . . . . . . CurrentFiscalYr . . . . . . . Packed Year (143,2)
Yrs To Retain Trans Hist. . . . . . . . YrsToRetainTransHistory . . . Zero-Filled (145,2)
Yrs To Retain Summ Post Hist. . . . . . YrsToRetainSummPostHistory. . Zero-Filled (147,2)
Curr Fisc Yr Updated To Fin Stmnts. . . CurrFiscYrUpdatedToFinStmnts. Zero-Filled (149,4)
Rev Bud Var Signs On Custom F.S.. . . . RevBudVarSignsOnCustomFS. . . Uppercase (153,1)
(Yes,No,Debit Lines,Credit Lines) . . . . . . . . . . . . . . . . . Memo
Rev Pr Yr Var Signs On F.S. . . . . . . RevPrYrVarSignsOnFS . . . . . Uppercase (154,1)
(Yes, No, Debit Lns, Credit Lns). . . . . . . . . . . . . . . . . . Memo
Track Changes Made To Accnt Mstrfl? . . TrackChngMadeToAcctMasterfile Uppercase (155,1)
(Yes, No, Deletes, Adds, Changes) . . . . . . . . . . . . . . . . . Memo
Track Additions In Summary/Detail?. . . TrackAddtnsInSummaryOrDetail. Uppercase (156,1)
Open String . . . . . . . . . . . . . . _S1 . . . . . . . . . . . . . Open String (157,69)
Acct No Format (Default Is 0A3A3A3) . . AccountNumberFormat . . . . . String (1,7)
Length Of Account No ). . LengthOfAccountNo . . . . . . Number [0] 1.0
Segment 2 Format - (Default Is 0A3) . . Segment2Format. . . . . . . . String (1,3)
Open Number . . . . . . . . . . . . . . _N1 . . . . . . . . . . . . . Open Number [0] 0.
Segment 3 Format - (Default Is 0A3) . . Segment3Format. . . . . . . . String (1,3)
________
Total Bytes 248
GL0 G/L Parameters (GL0_CustomFSDescription) Level: 4.40
Record Type: 2 G/L Parameters - Record 2 08/28/2009
File Type: Direct Key Size: 9 Rec Len: 256 Min Len: 67 Define: N
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
'G/L' . . . . . . . . . . . . . . . . . GLApplicationCode . . . . . . String *(1,3)
Company Code. . . . . . . . . . . . . . CompanyCode . . . . . . . . . String *(4,3)
'2' . . . . . . . . . . . . . . . . . . RecordNo. . . . . . . . . . . String *(7,1)
Assets Description. . . . . . . . . . . AssetsDescription . . . . . . String (8,30)
Liabilities Description . . . . . . . . LiabilitiesDescription. . . . String (38,30)
Equity Description. . . . . . . . . . . EquityDescription . . . . . . String (68,30)
Revenue Description . . . . . . . . . . RevenueDescription. . . . . . String (98,30)
Expense Description . . . . . . . . . . ExpenseDescription. . . . . . String (128,30)
Cost Of Goods Sold Description. . . . . CostOfGoodsDescription. . . . String (158,30)
Gross Profit Description. . . . . . . . GrossProfitDescription. . . . String (188,30)
Open String . . . . . . . . . . . . . . _S1 . . . . . . . . . . . . . Open String (218,33)
________
Total Bytes 252
GL0 G/L Parameters (GL0_CustomFSDescription) Level: 4.40
Record Type: 3 G/L Description - Record 3 08/28/2009
File Type: Direct Key Size: 9 Rec Len: 256 Min Len: 67 Define: N
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
'G/L' . . . . . . . . . . . . . . . . . GLApplicationCode . . . . . . String *(1,3)
Company Code. . . . . . . . . . . . . . CompanyCode . . . . . . . . . String *(4,3)
'3' . . . . . . . . . . . . . . . . . . RecordNo. . . . . . . . . . . String *(7,1)
Net Income (Loss) Description . . . . . NetIncomeDescription. . . . . String (8,30)
Retained Earnings - Current Description RetainedEarningsCurrentDesc . String (38,30)
Other Income & Expenses . . . . . . . . OtherIncomeAndExpenseDesc . . String (68,30)
Earnings Before Income Tax. . . . . . . EarningsBeforeIncomeTaxDsc. . String (98,30)
Income Taxes. . . . . . . . . . . . . . IncomeTaxesDescription. . . . String (128,30)
Net Income From Operations. . . . . . . NetIncomeFromOperationDesc. . String (158,30)
Open String . . . . . . . . . . . . . . _S1 . . . . . . . . . . . . . Open String (188,63)
________
Total Bytes 252
GL0 G/L Parameters (GL0_CustomFSDescription) Level: 4.40
Record Type: 4 G/L Footnote Record 4 08/28/2009
File Type: Direct Key Size: 9 Rec Len: 256 Min Len: 67 Define: N
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
GL Application Code . . . . . . . . . . GLApplicationCode . . . . . . Uppercase *(1,3)
Company Code. . . . . . . . . . . . . . CompanyCode . . . . . . . . . String *(4,3)
Record Number (4) . . . . . . . . . . . RecordNo. . . . . . . . . . . String *(7,1)
Footnote Present? . . . . . . . . . . . FootnotePresent . . . . . . . Uppercase *(8,1)
N = None, Y = Left Just., C = Centered. . . . . . . . . . . . . . . Memo
Footnote Text . . . . . . . . . . . . . FootnoteText. . . . . . . . . String (9,240)
________
Total Bytes 250
GL0 G/L Parameters (GL0_CustomFSDescription) Level: 4.40
Record Type: 9 G/L Description - Record 9 08/28/2009
File Type: Direct Key Size: 9 Rec Len: 256 Min Len: 67 Define: N
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
'G/L' . . . . . . . . . . . . . . . . . GLApplicationCode . . . . . . String *(1,3)
Company Code. . . . . . . . . . . . . . CompanyCode . . . . . . . . . String *(4,3)
'9' . . . . . . . . . . . . . . . . . . RecordNo. . . . . . . . . . . String *(7,1)
Field1. . . . . . . . . . . . . . . . . Field1. . . . . . . . . . . . Yes/No (8,1)
Field2. . . . . . . . . . . . . . . . . Field2. . . . . . . . . . . . Yes/No (9,1)
________
Total Bytes 11
GL0 G/L Parameters (GL0_CustomFSDescription) Level: 4.40
Record Type: v Version Record 08/28/2009
File Type: Direct Key Size: 9 Rec Len: 256 Min Len: 67 Define: N
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
Version Record. . . . . . . . . . . . . VersionRecord . . . . . . . . String *(1,1)
G/L Application Code. . . . . . . . . . GLApplicationCode . . . . . . Uppercase *(2,3)
Company Code. . . . . . . . . . . . . . CompanyCode . . . . . . . . . String *(5,3)
Version No. . . . . . . . . . . . . . . VersionNo . . . . . . . . . . String (8,10)
Open String . . . . . . . . . . . . . . _S1 . . . . . . . . . . . . . Open String (18,83)
________
Total Bytes 102