View: Accounts

RotoID: GL0110

Protocol: Superview
DLL:FRAMF

Keys: 14

Title Fields
Account ID ACCTID
Account Group Code POSTINGSEQ, ACSEGVAL10, ALLOCTOT, ACCTID
Account ACCTFMTTD, ACSEGVAL10, ALLOCTOT, ACCTID
Division ACSEGVAL01, ACSEGVAL10, ALLOCTOT, ACCTID
Region ACSEGVAL02, ACSEGVAL10, ALLOCTOT, ACCTID
Unused Key - Segment 4 ACSEGVAL03, ACSEGVAL10, ALLOCTOT, ACCTID
Unused Key - Segment 5 ACSEGVAL04, ACSEGVAL10, ALLOCTOT, ACCTID
Unused Key - Segment 6 ACSEGVAL05, ACSEGVAL10, ALLOCTOT, ACCTID
Unused Key - Segment 7 ACSEGVAL06, ACSEGVAL10, ALLOCTOT, ACCTID
Unused Key - Segment 8 ACSEGVAL07, ACSEGVAL10, ALLOCTOT, ACCTID
Unused Key - Segment 9 ACSEGVAL08, ACSEGVAL10, ALLOCTOT, ACCTID
Unused Key - Segment 10 ACSEGVAL09, ACSEGVAL10, ALLOCTOT, ACCTID
Formatted Account ID YRACCTCLOS
Sort Order - Account Group CNTDETAIL, POSTINGSEQ, ACSEGVAL10, ALLOCTOT, ACCTID

Fields: 77

Field Index Type Title Attributes Presentation
ACCTID 1 String*45 Unformatted Account E A C P  Mask: %-45C
CREATEDATE 2 Date Date Created E A C 
ACCTDESC 3 String*60 Description E A C 
ACCTTYPE 4 String*1 Type E A C P  List:3 entries
I = Income Statement
B = Balance Sheet
R = Retained Earnings
ACCTBAL 5 String*1 Normal Balance DR/CR E A C P  List:2 entries
1 = Debit
2 = Credit
ACTIVESW 6 Integer Status E A C P  List:2 entries
0 = Inactive
1 = Active
CONSLDSW 7 Integer Post to Account E A C P  List:3 entries
0 = Detail
1 = Consolidated
2 = Prohibited
QTYSW 8 Integer Quantities Allowed E A C P  List:2 entries
0 = No
1 = Yes
UOM 9 String*6 Unit of Measure E A C 
ALLOCSW 10 Integer Allocations Allowed E A C P  List:3 entries
0 = No Allocation
1 = Allocated by Account Balance
2 = Allocated by Account Quantity
ACCTOFSET 11 String*45 Alloc Offset Account E A C P  Mask: %-45C
ACCTSRTY 12 String*2 Alloc Source Type E A C P  Mask: %-2N
ROLLUPSW 13 Integer Rollup E A C P  List:2 entries
0 = No
1 = Yes
MCSW 14 Integer Multicurrency E A C P  List:2 entries
0 = No
1 = Yes
SPECSW 15 Integer Specific Currency E A C P  List:2 entries
0 = All Currencies
1 = Specific Currencies
ACCTGRPCOD 16 String*12 Account Group Code E A C  Mask: %-12N
CTRLACCTSW 17 Integer Control Account E A C P  List:2 entries
0 = No
1 = Yes
SRCELDGID 18 String*2 Reserved E A C P  Mask: %-2A
ALLOCTOT 19 BCD*8.7 Allocation Percent Total E A C 
ABRKID 20 String*6 Structure Code E A C P  Mask: %-6N
YRACCTCLOS 21 BCD*4.0 Year Last Closed E A C 
ACCTFMTTD 22 String*45 Account Number E A C 
ACSEGVAL01 23 String*15 Account Segment Code 1 E A C 
ACSEGVAL02 24 String*15 Account Segment Code 2 E A C 
ACSEGVAL03 25 String*15 Account Segment Code 3 E A C 
ACSEGVAL04 26 String*15 Account Segment Code 4 E A C 
ACSEGVAL05 27 String*15 Account Segment Code 5 E A C 
ACSEGVAL06 28 String*15 Account Segment Code 6 E A C 
ACSEGVAL07 29 String*15 Account Segment Code 7 E A C 
ACSEGVAL08 30 String*15 Account Segment Code 8 E A C 
ACSEGVAL09 31 String*15 Account Segment Code 9 E A C 
ACSEGVAL10 32 String*15 Account Segment Code 10 E A C 
ACCTSEGVAL 33 String*15 Segment Code E A C 
ACCTGRPSCD 34 String*12 Account Group Sort Code E A C  Mask: %-12N
POSTOSEGID 35 String*6 Post to Segment ID E A C 
DEFCURNCOD 36 String*3 Default Currency Code E A C P  Mask: %-3N
FISCALYR 37 String*4 Fiscal Year E A C  Mask: %04D
FISCALPERD 38 String*2 Fiscal Period E A C  Mask: %02D
SRCECURN 39 String*3 Source Currency Code E A C P  Mask: %-3N
SRCELEDGER 40 String*2 Source Ledger Code E A C P  Mask: %-2A
SRCETYPE 41 String*2 Source Type Code E A C P  Mask: %-2N
POSTINGSEQ 42 BCD*4.0 Posting Sequence Number E A C 
CNTDETAIL 43 BCD*4.0 Detail Count E A C 
JRNLDATE 44 Date Journal Date E A C 
BATCHNBR 45 String*6 Batch Number E A C P  Mask: %06D
ENTRYNBR 46 String*5 Journal Entry Number E A C P  Mask: %05D
TRANSNBR 47 BCD*4.0 Journal Transaction Number E A C 
CONSOLIDAT 48 Integer Consolidation Occurred on Post E A C P  List:2 entries
0 = No
1 = Yes
JNLDTLDESC 49 String*60 Journal Detail Description E A C 
JNLDTLREF 50 String*60 Journal Detail Reference E A C 
TRANSAMT 51 BCD*10.3 Journal Transaction Amount E A C 
TRANSQTY 52 BCD*10.3 Journal Transaction Quantity E A C 
SCURNAMT 53 BCD*10.3 Source Currency Amount E A C 
RPTAMT 54 BCD*10.3 Report Currency Amount E A C 
RATETYPE 55 String*2 Currency Rate Table Type E A C P  Mask: %-2N
RATEDATE 56 Date Date of Currency Rate Selected E A C 
CONVRATE 57 BCD*8.7 Currency Rate for Conversion E A C 
RATEOPER 58 String*1 Currency Rate Operator E A C P  List:2 entries
1 = Multiply
2 = Divide
VALUES 59 Long No. of glposto records E A 
AVALUES 60 Long Total Account Optional Fields E A C 
TVALUES 61 Long Total Trans. Optional Fields E A C 
TBLSW 62 Integer Table switch E A C  List:2 entries
0 = No
1 = Yes
OPTFIELD 63 String*14 Optional Field E A C 
LOCATION 64 Integer Optional Field Location E A C  List:2 entries
0 = Accounts
1 = Transaction Details
FDESC 65 String*60 Optional Field Desc E A C 
A~FLD00001 66 String*60 Account Class E A C P  Mask: %-60c
A~FLD00002 67 String*20 Cash Flow Type E A C P  Mask: %-20c
T~FLD00001 68 String*3 Approved E A C P  Mask: %-3c
T~FLD00002 69 String*60 Freight Method E A C P  Mask: %-60c
T~FLD00003 70 Date Lease Expiry Date E A C P 
T~FLD00004 71 String*60 Packer E A C P  Mask: %-60c
T~FLD00005 72 BCD*10.0 Quantity E A C P 
T~FLD00006 73 String*30 Sales Rep E A C P  Mask: %-30c
T~FLD00007 74 String*12 Square Footage E A C P  Mask: %-12c
T~FLD00008 75 String*10 UOM E A C P  Mask: %-10c
T~FLD00009 76 String*60 User E A C P  Mask: %-60c
T~FLD00010 77 String*10 Warranty Period E A C P  Mask: %-10c

This page was generated on 2023-Aug-31

© 2023 Sage Software, Inc. All rights reserved. Reproduction of part or all of the contents in any form is prohibited unless for personal use. None of the content of this article may be copied or otherwise incorporated into any other document, publication or other work in any form (whether written, electronic or other format).

Sage Software, Inc. makes no warranties, representations or undertakings about any of the content of articles (including, without limitation, any as to the quality, accuracy, completeness or fitness for any particular purpose of such content).