Table: Export Audit

Table: ZCEAUD
View: ZC0009
Record length: 188
Flags: A R 

Keys: 3

Title  Flags  Fields

Export Sequence  EXPSEQNR
Export Unit  D M  UNITID, PROCESS
Export Process  D M  PROCESS, UNITID

Fields: 55

Field  Type  Title  Presentation 

EXPSEQNR  String*4  Export Sequence Number  Mask: %04d
AUDTDATE  Date     
AUDTTIME  Time     
AUDTUSER  String*8     
AUDTORG  String*6     
UNITID  String*4  Process Unit ID  Mask: %-4N
PROCESS  String*8  Process ID  Mask: %-8N
DESTCURN  String*3  Destination Currency   
EXPSEGS  Integer  Export Segments  List: 2 entries
0=No
1=Yes
EXPSRC  Integer  Export Source Codes  List: 2 entries
0=No
1=Yes
EXPACCTS  Integer  Export Accounts  List: 2 entries
0=No
1=Yes
EXPBUDS  Integer  Export Budgets  List: 2 entries
0=No
1=Yes
EXPTRANS  Integer  Export Transactions  List: 2 entries
0=No
1=Yes
EXPMAP  Integer  Export Mapping Table  List: 2 entries
0=No
1=Yes
EXPBUD1  Integer  Export Budget Set 1  List: 2 entries
0=No
1=Yes
EXPBUD2  Integer  Export Budget Set 2  List: 2 entries
0=No
1=Yes
EXPBUD3  Integer  Export Budget Set 3  List: 2 entries
0=No
1=Yes
EXPBUD4  Integer  Export Budget Set 4  List: 2 entries
0=No
1=Yes
EXPBUD5  Integer  Export Budget Set 5  List: 2 entries
0=No
1=Yes
MAPTBL  String*8  Mapping Table   
EXPMETH  Integer  Export Method  List: 4 entries
0=Net Changes
1=Transactions By Posting Sequence
2=Transactions By Fiscal Period
3=Balances
MAPMETH  Integer  Mapping Method  List: 3 entries
0=Generate Error For Unmapped Accounts
1=Only Map Accounts In Table
2=Only Transfer Mapped Accounts
USESEGS  Integer  Use Segments  List: 2 entries
0=No
1=Yes
USESRCCODE  Integer  Use Source Codes  List: 2 entries
0=No
1=Yes
FISCYR  String*4  Fiscal Year  Mask: %04D
FISCPERD  String*2  Fiscal Period  Mask: %02D
PSEQFR  BCD*4.0  From Posting Sequence   
PSEQTO  BCD*4.0  To Posting Sequence   
PSEQHI  BCD*4.0  Highest Posting Sequence   
PSEQLO  BCD*4.0  Lowest Posting Sequence   
FISCYRHI  String*4  Highest Fiscal Year  Mask: %04D
FISCPERDHI  String*2  Highest Fiscal Period  Mask: %02D
FISCYRLO  String*4  Lowest Fiscal Year  Mask: %04D
FISCPERDLO  String*2  Lowest Fiscal Period  Mask: %02D
TOTTRNFILE  Integer  Total Tran. Files In Export   
TOTTRNRECS  Long  Total Tran. Records In Export   
TOTACCRECS  Long  Total Account Records In Export   
TOTSRCRECS  Long  Total Src Code Records In Export   
TOTSEGRECS  Long  Total Segment Records In Export   
TOTBDGRECS  Long  Total Budget Records In Export   
MULTICURN  Integer  Export Was For Multi Curr. Co.  List: 2 entries
0=Single
1=Multi
EXPDATE  Date  Date Exported   
EXPUSER  String*8  User That Did Export   
EXPCOMP  String*6  Exporting Company   
SRCCURN  String*3  Func. Currency Of Exporting Co.  Mask: %-3N
VERSION  String*3  Program Version   
EXPOPTFLD  Integer  Export Opt. Field from G/L Setup  List: 2 entries
0=No
1=Yes
TOTOFDRECS  Long  Total G/L Setup Opt. Flds In Export   
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
EXPCSOFDS  Integer  Export Opt. Field from C/S Setup  List: 2 entries
0=No
1=Yes
TOTCSOFDS  Long  Total C/S Setup Opt. Flds In Export   
EXPACCTGRP  Integer  Export Account Groups  List: 2 entries
0=No
1=Yes
TOTAGPRECS  Long  Total Account Groups In Export   
PRINTED  Integer  Record Printed  List: 2 entries
0=No
1=Yes

This page was generated on 2009-Nov-19

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