Table: G/L Consol. Export Header

Table: ZCESPH
View: ZC0001
Record length: 491
Flags: A R 

Keys: 1

Title  Flags  Fields

Process ID   PROCESS

Fields: 68

Field  Type  Title  Presentation 

PROCESS  String*8  Process ID  Mask: %-8N
AUDTDATE  Date     
AUDTTIME  Time     
AUDTUSER  String*8     
AUDTORG  String*6     
DESCR  String*60  Description   
SRCID  String*4  Source Unit ID  Mask: %-4N
SELMETH  Integer  Selection Method   
SPECSEG  Integer  Specify Segments  List: 2 entries
0=No
1=Yes
SEGNUM  String*6  Segment Number  Mask: %06d
SEGFR  String*15  Segment From  Mask: %-15N
SEGTO  String*15  Segment To  Mask: %-15N
USEMAP  Integer  Use Mapping Table  List: 2 entries
0=No
1=Yes
MAPERR  Integer  Generate Error If Unmapped  List: 2 entries
0=No
1=Yes
MAPACCT  Integer  Only Map Whats In Table  List: 2 entries
0=No
1=Yes
MAPTRNSF  Integer  Only Transfer Whats Mapped  List: 2 entries
0=No
1=Yes
MAPTBL  String*8  Mapping Table  Mask: %-8N
CONSBUD  Integer  Consolidate Budgets  List: 2 entries
0=No
1=Yes
EXPMETH  Integer  Export Method  List: 4 entries
0=Net Changes
3=Balances
1=Transactions By Posting Sequence
2=Transactions By Fiscal Period
TXDESC  String*60  Net Chg. G/L Description   
SUBSRC  Integer  Substitute Source Codes  List: 2 entries
0=No
1=Yes
TRSRCLEDG  String*2  Default Transaction Ledger  Mask: %-2N
DSRCLEDG  String*2  Default Source Ledger  Mask: %-2N
DSRCTYPE  String*2  Default Source Type  Mask: %-2N
PERDOFFS  Integer  Period Offset   
EXPTRANS  Integer  Export Transactions  List: 2 entries
0=No
1=Yes
EXPACCTS  Integer  Export Accounts  List: 2 entries
0=No
1=Yes
EXPACTACC  Integer  Export Inactive Accounts  List: 2 entries
0=No
1=Yes
ACTINACT  Integer  Set Inactive Accounts To Active  List: 2 entries
0=No
1=Yes
EXPSRC  Integer  Export Source Codes  List: 2 entries
0=No
1=Yes
EXPSEGS  Integer  Export Segments  List: 2 entries
0=No
1=Yes
EXPBUDS  Integer  Export Budgets  List: 2 entries
0=No
1=Yes
EXPBUD1  Integer  Export Budget 1  List: 2 entries
0=No
1=Yes
EXPBUD2  Integer  Export Budget 2  List: 2 entries
0=No
1=Yes
EXPBUD3  Integer  Export Budget 3  List: 2 entries
0=No
1=Yes
EXPBUD4  Integer  Export Budget 4  List: 2 entries
0=No
1=Yes
EXPBUD5  Integer  Export Budget 5  List: 2 entries
0=No
1=Yes
EXPBDFRYR  String*4  Export Budget From Yr  Mask: %04D
EXPBDTOYR  String*4  Export Budget To Yr  Mask: %04D
EXPMAP  Integer  Export Mapping Table Changes  List: 2 entries
0=No
1=Yes
EORIGAUD  Integer  Export Orig. Audit Trail  List: 2 entries
0=No
1=Yes
CZRTRANS  Integer  Create Trans. With Zero Value  List: 2 entries
0=No
1=Yes
MAXTRANS  Integer  Max. Trans. Per File   
TRANBALACC  String*45  Entry Balancing Acct.  Mask: %-45C
MULTICURN  Integer  Multi Currency Destination Co.  List: 2 entries
0=No
1=Yes
EXPOTHCUR  Integer  Export In Another Currency  List: 2 entries
0=No
1=Yes
OVRRIDEMC  Integer  Override Multi Currency  List: 2 entries
0=No
1=Yes
MCSW  Integer  Multi Currency Switch  List: 2 entries
0=No
1=Yes
SPECSW  Integer  Specified Currency Switch  List: 2 entries
0=All Currency
1=Specific Currency
EXPCURRID  String*3  Currency Code  Mask: %-3N
RATETYPE  String*2  Dflt Currency Rate Type  Mask: %-2N
XCHGPROF  String*45  Exchange Gain Acct.  Mask: %-45C
XCHGLOS  String*45  Exchange Loss Acct.  Mask: %-45C
BUDRATTYP  String*2  Rate Type For Budgets  Mask: %-2N
UNITBALACC  String*45  Unit Balancing Acct.  Mask: %-45C
TDATEUSE  Integer  Trans. Currency XChange Date  List: 3 entries
0=Fiscal Period
1=Transaction Date
2=User Specified
BDATEUSE  Integer  Buds. Currency XChange Date  List: 2 entries
0=No
1=Yes
RUNTEDIT  Integer  Allow Runtime Edit  List: 2 entries
0=No
1=Yes
LASTYR  String*4  Last Fiscal Year Exported  Mask: %04D
LASTPERD  String*2  Last Fiscal Period Exported  Mask: %02D
EXPSEQNO  Integer  Export Sequence Number   
LOCALEXP  Integer  Retain Orig. G/L Ref And Desc.  List: 2 entries
0=No
1=Yes
TRANSCURN  Integer  Translation Currency  List: 2 entries
0=Functional Currency
1=Source Currency
EXPACTOPT  Integer  Export Account Opt. Fields  List: 2 entries
0=No
1=Yes
EXPTRANOPT  Integer  Export Trans. Opt. Fields  List: 2 entries
0=No
1=Yes
EXPOPTFLD  Integer  Export Opt. Flds from G/L Setup  List: 2 entries
0=No
1=Yes
EXPCSOFDS  Integer  Export Opt. Flds from C/S Setup  List: 2 entries
0=No
1=Yes
EXPACCTGRP  Integer  Export Account Groups  List: 2 entries
0=No
1=Yes

This page was generated on 2008-Apr-11

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