Table: Account Fiscal Sets

Table: GLAFS
View: GL0103
Record length: 249
Flags: A R 

Keys: 2

Title  Flags  Fields

Account Fiscal Set  ACCTID, FSCSYR, FSCSDSG, FSCSCURN, CURNTYPE
Fiscal Set Designator  D M  FSCSDSG

Fields: 29

Field  Type  Title  Presentation 

ACCTID  String*45  Account Number  Mask: %-45C
FSCSYR  String*4  Fiscal set year  Mask: %04D
FSCSDSG  String*1  Fiscal set Designator  List: 11 entries
A=Actuals
Q=Quantity
R=Reporting
P=Provisional Actuals
O=Provisional Quantity
T=Provisional Reporting
1=Budget 1
2=Budget 2
3=Budget 3
4=Budget 4
5=Budget 5
FSCSCURN  String*3  Currency code  Mask: %-3N
CURNTYPE  String*1  Currency type  List: 3 entries
S=Source
E=Equivalent
F=Functional
AUDTDATE  Date     
AUDTTIME  Time     
AUDTUSER  String*8     
AUDTORG  String*6     
SWRVL  Integer  RESERVED Revaluation switch   
CODERVL  String*6  RESERVED Revaluation code   
SCURNDEC  String*1  Source currency decimals   
OPENBAL  BCD*10.3  Beginning balance   
NETPERD1  BCD*10.3  Period 01 net amount   
NETPERD2  BCD*10.3  Period 02 net amount   
NETPERD3  BCD*10.3  Period 03 net amount   
NETPERD4  BCD*10.3  Period 04 net amount   
NETPERD5  BCD*10.3  Period 05 net amount   
NETPERD6  BCD*10.3  Period 06 net amount   
NETPERD7  BCD*10.3  Period 07 net amount   
NETPERD8  BCD*10.3  Period 08 net amount   
NETPERD9  BCD*10.3  Period 09 net amount   
NETPERD10  BCD*10.3  Period 10 net amount   
NETPERD11  BCD*10.3  Period 11 net amount   
NETPERD12  BCD*10.3  Period 12 net amount   
NETPERD13  BCD*10.3  Period 13 net amount   
NETPERD14  BCD*10.3  Period 14 net amount   
NETPERD15  BCD*10.3  Period 15 net amount   
ACTIVITYSW  Integer  Activity switch  List: 3 entries
0=Inactive
1=Periods Active
2=Balance Forward Active

This page was generated on 2008-May-01

Copyright © 2001–2008 Sage Software, Inc. All rights reserved.