Table: Import Audit

Table: ZCIAUD
View: ZC0010
Record length: 215
Flags: A R 

Keys: 4

Title  Flags  Fields

Import Sequence   IMPSEQNR
Export Unit And Sequence   D M  UNITID, EXPSEQNR
Unit, Fiscal Year And Period   D M  UNITID, FISCYR, FISCPERD
Import Date   D M  IMPDATE

Fields: 62

Field  Type  Title  Presentation 

IMPSEQNR  Long  Import Sequence Number   
AUDTDATE  Date     
AUDTTIME  Time     
AUDTUSER  String*8     
AUDTORG  String*6     
EXPSEQNR  String*4  Export Sequence Number   
UNITID  String*4  Process Unit ID  Mask: %-4N
PROCESS  String*8  Process ID  Mask: %-8N
DESTCURN  String*3  Destination Currency  Mask: %-3N
IMPSEGS  Integer  Import Segments  List: 6 entries
0=No
1=Imported Successfully
2=Not Available
3=Missing
4=Aborted
5=Previously Imported
IMPSRC  Integer  Import Source Codes  List: 6 entries
0=No
1=Imported Successfully
2=Not Available
3=Missing
4=Aborted
5=Previously Imported
IMPACCTS  Integer  Import Accounts  List: 6 entries
0=No
1=Imported Successfully
2=Not Available
3=Missing
4=Aborted
5=Previously Imported
IMPBUDS  Integer  Import Budgets  List: 6 entries
0=No
1=Imported Successfully
2=Not Available
3=Missing
4=Aborted
5=Previously Imported
IMPTRANS  Integer  Import Transactions  List: 8 entries
0=No
1=Imported Successfully
2=Not Available
3=Different Method
4=Different Period
5=Missing
6=Aborted
7=Previously Imported
IMPMAP  Integer  Import Mapping Table  List: 5 entries
0=No
1=Yes
2=Not Available
3=Missing
4=Aborted
IMPBUD1  Integer  Import Budget Set 1  List: 2 entries
0=No
1=Yes
IMPBUD2  Integer  Import Budget Set 2  List: 2 entries
0=No
1=Yes
IMPBUD3  Integer  Import Budget Set 3  List: 2 entries
0=No
1=Yes
IMPBUD4  Integer  Import Budget Set 4  List: 2 entries
0=No
1=Yes
IMPBUD5  Integer  Import Budget Set 5  List: 2 entries
0=No
1=Yes
MAPTBL  String*8  Mapping Table  Mask: %-8N
IMPMETH  Integer  Export Method  List: 5 entries
0=Net Changes
1=Transactions By Posting Sequence
2=Transactions By Fiscal Period
3=Balances
4=N/A
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 Trans. Files In Import   
TOTTRNRECS  Long  Total Trans. Records In Import   
TOTACCRECS  Long  Total Account Records In Import   
TOTSRCRECS  Long  Total Src Code Records In Import   
TOTSEGRECS  Long  Total Segment Records In Import   
TOTBDGRECS  Long  Total Budget Records In Import   
MULTICURN  Integer  Export Was For Multi Curr. Co.  List: 2 entries
0=Single
1=Multi
EXPDATE  Date  Date Exported   
IMPUSER  String*8  User That Did Import   
EXPCOMP  String*6  Exporting Company   
SRCCURN  String*3  Func. Currency Of Exporting Co.  Mask: %-3N
VERSION  String*3  Program Version   
IMPOFDS  Integer  Import Opt. Flds from G/L Setup  List: 6 entries
0=No
1=Imported Successfully
2=Not Available
3=Missing
4=Aborted
5=Previously Imported
TOTOFDRECS  Long  Total Opt. Flds Recs In Import   
IMPACTOPT  Integer  Import Account Opt. Fields  List: 2 entries
0=No
1=Yes
IMPTRANOPT  Integer  Import Trans. Opt. Fields  List: 2 entries
0=No
1=Yes
IMPCSOFDS  Integer  Import Opt. Field from C/S Setup  List: 6 entries
0=No
1=Imported Successfully
2=Not Available
3=Missing
4=Aborted
5=Previously Imported
TOTCSOFDS  Long  Total C/S Setup Opt. Flds In Imp   
IMPACCTGRP  Integer  Import Account Groups  List: 6 entries
0=No
1=Imported Successfully
2=Not Available
3=Missing
4=Aborted
5=Previously Imported
TOTAGPRECS  Long  Total Account Groups In Import   
PRINTED  Integer  Record Printed  List: 2 entries
0=No
1=Yes
IMPDATE  Date  Date Actually Imported   
FIRBTCH  String*6  First Batch Created For Import   
LSTBTCH  String*6  Last Batch Created For Import   
CLRSEL  Integer  Clear Deselected Data  List: 2 entries
0=No
1=Yes
DUPL  Integer  Duplication Type  List: 3 entries
0=None
1=Same Posting Seq.
2=Same Fiscal Period
IMPSTATE  Integer  Import State  List: 3 entries
0=Aborted
1=Deleted
2=Imported

This page was generated on 2008-Apr-11

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