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  UNITIDEXPSEQNR
Unit, Fiscal Year And Period D M  UNITIDFISCYRFISCPERD
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 Import
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