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