View: G/L Consol. Export Header

RotoID: ZC0001
Table: ZCESPH
Protocol: Header
DLL:ZCESPHV

Compositions: 2

RotoID Tables Title DLL
ZC0002 ZCESPD G/L Consol. Export Detail ZCESPDV
ZC0014 ZCSEGS Segment Number Substitution ZCSEGSV

Keys: 1

Title Fields
Process ID PROCESS

Fields: 64

Field Index Type Title Attributes Presentation
PROCESS 1 String*8 Process ID E A K R  Mask: %-8N
DESCR 2 String*60 Description E A 
SRCID 3 String*4 Source Unit ID E A  Mask: %-4N
SELMETH 4 Integer Selection Method E A 
SPECSEG 5 Integer Specify Segments E A  List:2 entries
0 = No
1 = Yes
SEGNUM 6 String*6 Segment Number E A  Mask: %06d
SEGFR 7 String*15 Segment From E A  Mask: %-15N
SEGTO 8 String*15 Segment To E A  Mask: %-15N
USEMAP 9 Integer Use Mapping Table E A  List:2 entries
0 = No
1 = Yes
MAPERR 10 Integer Generate Error If Unmapped E A  List:2 entries
0 = No
1 = Yes
MAPACCT 11 Integer Only Map Whats In Table E A  List:2 entries
0 = No
1 = Yes
MAPTRNSF 12 Integer Only Transfer Whats Mapped E A  List:2 entries
0 = No
1 = Yes
MAPTBL 13 String*8 Mapping Table E A  Mask: %-8N
CONSBUD 14 Integer Consolidate Budgets E A  List:2 entries
0 = No
1 = Yes
EXPMETH 15 Integer Export Method E A  List:4 entries
0 = Net Changes
3 = Balances
1 = Transactions By Posting Sequence
2 = Transactions By Fiscal Period
TXDESC 16 String*60 Net Chg. G/L Description E A 
SUBSRC 17 Integer Substitute Source Codes E A  List:2 entries
0 = No
1 = Yes
TRSRCLEDG 18 String*2 Default Transaction Ledger E A  Mask: %-2N
DSRCLEDG 19 String*2 Default Source Ledger E A  Mask: %-2N
DSRCTYPE 20 String*2 Default Source Type E A  Mask: %-2N
PERDOFFS 21 Integer Period Offset E A 
EXPTRANS 22 Integer Export Transactions E A  List:2 entries
0 = No
1 = Yes
EXPACCTS 23 Integer Export Accounts E A  List:2 entries
0 = No
1 = Yes
EXPACTACC 24 Integer Export Inactive Accounts E A  List:2 entries
0 = No
1 = Yes
ACTINACT 25 Integer Set Inactive Accounts To Active E A  List:2 entries
0 = No
1 = Yes
EXPSRC 26 Integer Export Source Codes E A  List:2 entries
0 = No
1 = Yes
EXPSEGS 27 Integer Export Segments E A  List:2 entries
0 = No
1 = Yes
EXPBUDS 28 Integer Export Budgets E A  List:2 entries
0 = No
1 = Yes
EXPBUD1 29 Integer Export Budget 1 E A  List:2 entries
0 = No
1 = Yes
EXPBUD2 30 Integer Export Budget 2 E A  List:2 entries
0 = No
1 = Yes
EXPBUD3 31 Integer Export Budget 3 E A  List:2 entries
0 = No
1 = Yes
EXPBUD4 32 Integer Export Budget 4 E A  List:2 entries
0 = No
1 = Yes
EXPBUD5 33 Integer Export Budget 5 E A  List:2 entries
0 = No
1 = Yes
EXPBDFRYR 34 String*4 Export Budget From Year E A  Mask: %04D
EXPBDTOYR 35 String*4 Export Budget To Year E A  Mask: %04D
EXPMAP 36 Integer Export Mapping Table Changes E A  List:2 entries
0 = No
1 = Yes
EORIGAUD 37 Integer Export Orig. Audit Trail E A  List:2 entries
0 = No
1 = Yes
CZRTRANS 38 Integer Create Trans. With Zero Value E A  List:2 entries
0 = No
1 = Yes
MAXTRANS 39 Integer Max. Trans. Per File E A 
TRANBALACC 40 String*45 Entry Balancing Acct. E A  Mask: %-45C
MULTICURN 41 Integer Multi Currency Destination Co. E A  List:2 entries
0 = No
1 = Yes
EXPOTHCUR 42 Integer Export In Another Currency E A  List:2 entries
0 = No
1 = Yes
OVRRIDEMC 43 Integer Override Multi Currency E A  List:2 entries
0 = No
1 = Yes
MCSW 44 Integer Multi Currency Switch E A  List:2 entries
0 = No
1 = Yes
SPECSW 45 Integer Specified Currency Switch E A  List:2 entries
0 = All Currency
1 = Specific Currency
EXPCURRID 46 String*3 Currency Code E A  Mask: %-3N
RATETYPE 47 String*2 Dflt Currency Rate Type E A  Mask: %-2N
XCHGPROF 48 String*45 Exchange Gain Acct. E A  Mask: %-45C
XCHGLOS 49 String*45 Exchange Loss Acct. E A  Mask: %-45C
BUDRATTYP 50 String*2 Rate Type For Budgets E A  Mask: %-2N
UNITBALACC 51 String*45 Unit Balancing Acct. E A  Mask: %-45C
TDATEUSE 52 Integer Trans. Currency XChange Date E A  List:3 entries
0 = Fiscal Period
1 = Transaction Date
2 = User Specified
BDATEUSE 53 Integer Buds. Currency XChange Date E A  List:2 entries
0 = No
1 = Yes
RUNTEDIT 54 Integer Allow Runtime Edit E A  List:2 entries
0 = No
1 = Yes
LASTYR 55 String*4 Last Fiscal Year Exported E A  Mask: %04D
LASTPERD 56 String*2 Last Fiscal Period Exported E A  Mask: %02D
EXPSEQNO 57 Integer Export Sequence Number E A 
LOCALEXP 58 Integer Retain Orig. G/L Ref And Desc. E A  List:2 entries
0 = No
1 = Yes
TRANSCURN 59 Integer Translation Currency E A  List:2 entries
0 = Functional Currency
1 = Source Currency
EXPACTOPT 60 Integer Export Account Opt. Fields E A  List:2 entries
0 = No
1 = Yes
EXPTRANOPT 61 Integer Export Trans. Opt. Fields E A  List:2 entries
0 = No
1 = Yes
EXPOPTFLD 62 Integer Export Opt. Flds from G/L Setup E A  List:2 entries
0 = No
1 = Yes
EXPCSOFDS 63 Integer Export Opt. Flds from C/S Setup E A  List:2 entries
0 = No
1 = Yes
EXPACCTGRP 64 Integer Export Account Groups E A  List:2 entries
0 = No
1 = Yes

This page was generated on 2022-Aug-18

© 2021 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).