Table: Import Audit

Table: ZCIAUD
View: ZC0010
Record length: 217
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: 54


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   
PROCESS  String*8  Process ID   
DESTCURN  String*3  Destination Currency   
IMPSEGS  Integer  Import Segments  List: 5 entries
0=No
1=Yes
2=Not Available
3=Missing
4=Abort
IMPSRC  Integer  Import Source Codes  List: 5 entries
0=No
1=Yes
2=Not Available
3=Missing
4=Abort
IMPACCTS  Integer  Import Accounts  List: 5 entries
0=No
1=Yes
2=Not Available
3=Missing
4=Abort
IMPBUDS  Integer  Import Budgets  List: 5 entries
0=No
1=Yes
2=Not Available
3=Missing
4=Abort
IMPTRANS  Integer  Import Transactions  List: 7 entries
0=No
1=Yes
2=Not Available
3=Different Method
4=Different Period
5=Missing
6=Abort
IMPMAP  Integer  Import Mapping Table  List: 5 entries
0=No
1=Yes
2=Not Available
3=Missing
4=Abort
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   
IMPMETH  Integer  Import 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   
FISCPERD  String*2  Fiscal Period   
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   
FISCPERDHI  String*2  Highest Fiscal Period   
FISCYRLO  String*4  Lowest Fiscal Year   
FISCPERDLO  String*2  Lowest Fiscal Period   
TOTTRNFILE  Integer  Total Transaction Files In Impo   
TOTTRNRECS  Long  Total Transaction Records In Im   
TOTACCRECS  Long  Total Account Records In Import   
TOTSRCRECS  Long  Total Source Code Records In Im   
TOTSEGRECS  Long  Total Segment Records In Import   
TOTBDGRECS  Long  Total Budget Records In Import   
MULTICURN  Integer  Export Was For Multi Currency C  List: 2 entries
0=Single
1=Multi
EXPDATE  Date  Date Exported   
IMPUSER  String*5  User That Did Import   
EXPCOMP  String*6  Exporting Company   
SRCCURN  String*3  Func. Currency Of Exporting Com   
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
XTRAFLD1  String*30  Future Field   

Copyright © 2001 ACCPAC International, Inc. All rights reserved.