# View: Accounts

RotoID: GL0110
Table:
DLL: FRAMF

## Compositions: 0

## Keys: 14

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

## Fields: 76

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 | Consolidate Journals | E A C P | List: 2 entries
0 | = | Do not consolidate journals
1 | = | Consolidate journals
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
MCSW | 13 | Integer | Multicurrency | E A C P | List: 2 entries
0 | = | No
1 | = | Yes
SPECSW | 14 | Integer | Specific Currency | E A C P | List: 2 entries
0 | = | All Currencies
1 | = | Specific Currencies
ACCTGRPCOD | 15 | String*12 | Account Group Code | E A C | Mask: %-12N
CTRLACCTSW | 16 | Integer | Control Account | E A C P | List: 2 entries
0 | = | No
1 | = | Yes
SRCELDGID | 17 | String*2 | Reserved | E A C P | Mask: %-2A
ALLOCTOT | 18 | BCD*8.7 | Allocation Percent Total | E A C |
ABRKID | 19 | String*6 | Structure Code | E A C P | Mask: %-6N
YRACCTCLOS | 20 | BCD*4.0 | Year Last Closed | E A C |
ACCTFMTTD | 21 | String*45 | Account Number | E A C |
ACSEGVAL01 | 22 | String*15 | Account Segment Code 1 | E A C |
ACSEGVAL02 | 23 | String*15 | Account Segment Code 2 | E A C |
ACSEGVAL03 | 24 | String*15 | Account Segment Code 3 | E A C |
ACSEGVAL04 | 25 | String*15 | Account Segment Code 4 | E A C |
ACSEGVAL05 | 26 | String*15 | Account Segment Code 5 | E A C |
ACSEGVAL06 | 27 | String*15 | Account Segment Code 6 | E A C |
ACSEGVAL07 | 28 | String*15 | Account Segment Code 7 | E A C |
ACSEGVAL08 | 29 | String*15 | Account Segment Code 8 | E A C |
ACSEGVAL09 | 30 | String*15 | Account Segment Code 9 | E A C |
ACSEGVAL10 | 31 | String*15 | Account Segment Code 10 | E A C |
ACCTSEGVAL | 32 | String*15 | Segment Code | E A C |
ACCTGRPSCD | 33 | String*12 | Account Group Sort Code | E A C | Mask: %-12N
POSTOSEGID | 34 | String*6 | Post to Segment ID | E A C |
DEFCURNCOD | 35 | String*3 | Default Currency Code | E A C P | Mask: %-3N
FISCALYR | 36 | String*4 | Fiscal Year | E A C | Mask: %04D
FISCALPERD | 37 | String*2 | Fiscal Period | E A C | Mask: %02D
SRCECURN | 38 | String*3 | Source Currency Code | E A C P | Mask: %-3N
SRCELEDGER | 39 | String*2 | Source Ledger Code | E A C P | Mask: %-2A
SRCETYPE | 40 | String*2 | Source Type Code | E A C P | Mask: %-2N
POSTINGSEQ | 41 | BCD*4.0 | Posting Sequence Number | E A C |
CNTDETAIL | 42 | BCD*4.0 | Detail Count | E A C |
JRNLDATE | 43 | Date | Journal Date | E A C |
BATCHNBR | 44 | String*6 | Batch Number | E A C P | Mask: %06D
ENTRYNBR | 45 | String*5 | Journal Entry Number | E A C P | Mask: %05D
TRANSNBR | 46 | BCD*4.0 | Journal Transaction Number | E A C |
CONSOLIDAT | 47 | Integer | Consolidation Occurred on Post | E A C P | List: 2 entries
0 | = | No
1 | = | Yes
JNLDTLDESC | 48 | String*60 | Journal Detail Description | E A C |
JNLDTLREF | 49 | String*60 | Journal Detail Reference | E A C |
TRANSAMT | 50 | BCD*10.3 | Journal Transaction Amount | E A C |
TRANSQTY | 51 | BCD*10.3 | Journal Transaction Quantity | E A C |
SCURNAMT | 52 | BCD*10.3 | Source Currency Amount | E A C |
RPTAMT | 53 | BCD*10.3 | Report Currency Amount | E A C |
RATETYPE | 54 | String*2 | Currency Rate Table Type | E A C P | Mask: %-2N
RATEDATE | 55 | Date | Date of Currency Rate Selected | E A C |
CONVRATE | 56 | BCD*8.7 | Currency Rate for Conversion | E A C |
RATEOPER | 57 | String*1 | Currency Rate Operator | E A C P | List: 2 entries
1 | = | Multiply
2 | = | Divide
VALUES | 58 | Long | No. of glposto records | E A |
AVALUES | 59 | Long | Total Account Optional Fields | E A C |
TVALUES | 60 | Long | Total Trans. Optional Fields | E A C |
TBLSW | 61 | Integer | Table switch | E A C | List: 2 entries
0 | = | No
1 | = | Yes
OPTFIELD | 62 | String*14 | Optional Field | E A C |
LOCATION | 63 | Integer | Optional Field Location | E A C | List: 2 entries
0 | = | Accounts
1 | = | Transaction Details
FDESC | 64 | String*60 | Optional Field Desc | E A C |
A~FLD00001 | 65 | String*60 | Account Class | E A C P | Mask: %-60c@
A~FLD00002 | 66 | String*20 | Cash Flow Type | E A C P | Mask: %-20c@
T~FLD00001 | 67 | String*3 | Approved | E A C P | Mask: %-3c`Ë@
T~FLD00002 | 68 | String*60 | Freight Method | E A C P | Mask: %-60c@
T~FLD00003 | 69 | Date | Lease Expiry Date | E A C P |
T~FLD00004 | 70 | String*60 | Packer | E A C P | Mask: %-60c@
T~FLD00005 | 71 | BCD*10.0 | Quantity | E A C P |
T~FLD00006 | 72 | String*30 | Sales Rep | E A C P | Mask: %-30c@
T~FLD00007 | 73 | String*12 | Square Footage | E A C P | Mask: %-12c@
T~FLD00008 | 74 | String*10 | UOM | E A C P | Mask: %-10c@
T~FLD00009 | 75 | String*60 | User | E A C P | Mask: %-60c@
T~FLD00010 | 76 | String*10 | Warranty Period | E A C P | Mask: %-10c@

This page was generated on 2006-Sep-07

Copyright © 2001–2005 Sage Accpac International, Inc.