View: Import Audit

RotoID: ZC0010
Table: ZCIAUD
Protocol: Flat
DLL:ZCIAUDV

Keys: 4

Title Fields

Import Sequence IMPSEQNR
Export Unit And Sequence UNITIDPROCESS
Unit, Fiscal Year And Period UNITIDFISCYRFISCPERD
Import Date IMPDATE

Fields: 58

Field Index Type Title Attributes Presentation

IMPSEQNR 1 Long Import Sequence Number E A K R 
EXPSEQNR 2 String*4 Export Sequence Number E A 
UNITID 3 String*4 Process Unit ID E A  Mask: %-4N
PROCESS 4 String*8 Process ID E A  Mask: %-8N
DESTCURN 5 String*3 Destination Currency E A  Mask: %-3N
IMPSEGS 6 Integer Import Segments E A  List:6 entries
0 = No
1 = Imported Successfully
2 = Not Available
3 = Missing
4 = Aborted
5 = Previously Imported
IMPSRC 7 Integer Import Source Codes E A  List:6 entries
0 = No
1 = Imported Successfully
2 = Not Available
3 = Missing
4 = Aborted
5 = Previously Imported
IMPACCTS 8 Integer Import Accounts E A  List:6 entries
0 = No
1 = Imported Successfully
2 = Not Available
3 = Missing
4 = Aborted
5 = Previously Imported
IMPBUDS 9 Integer Import Budgets E A  List:6 entries
0 = No
1 = Imported Successfully
2 = Not Available
3 = Missing
4 = Aborted
5 = Previously Imported
IMPTRANS 10 Integer Import Transactions E A  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 11 Integer Import Mapping Table E A  List:5 entries
0 = No
1 = Yes
2 = Not Available
3 = Missing
4 = Aborted
IMPBUD1 12 Integer Import Budget Set 1 E A  List:2 entries
0 = No
1 = Yes
IMPBUD2 13 Integer Import Budget Set 2 E A  List:2 entries
0 = No
1 = Yes
IMPBUD3 14 Integer Import Budget Set 3 E A  List:2 entries
0 = No
1 = Yes
IMPBUD4 15 Integer Import Budget Set 4 E A  List:2 entries
0 = No
1 = Yes
IMPBUD5 16 Integer Import Budget Set 5 E A  List:2 entries
0 = No
1 = Yes
MAPTBL 17 String*8 Mapping Table E A  Mask: %-8N
IMPMETH 18 Integer Export Method E A  List:5 entries
0 = Net Changes
1 = Transactions By Posting Sequence
2 = Transactions By Fiscal Period
3 = Balances
4 = N/A
MAPMETH 19 Integer Mapping Method E A  List:3 entries
0 = Generate Error For Unmapped Accounts
1 = Only Map Accounts In Table
2 = Only Transfer Mapped Accounts
USESEGS 20 Integer Use Segments E A  List:2 entries
0 = No
1 = Yes
USESRCCODE 21 Integer Use Source Codes E A  List:2 entries
0 = No
1 = Yes
FISCYR 22 String*4 Fiscal Year E A  Mask: %04D
FISCPERD 23 String*2 Fiscal Period E A  Mask: %02D
PSEQFR 24 BCD*4.0 From Posting Sequence E A 
PSEQTO 25 BCD*4.0 To Posting Sequence E A 
PSEQHI 26 BCD*4.0 Highest Posting Sequence E A 
PSEQLO 27 BCD*4.0 Lowest Posting Sequence E A 
FISCYRHI 28 String*4 Highest Fiscal Year E A  Mask: %04D
FISCPERDHI 29 String*2 Highest Fiscal Period E A  Mask: %02D
FISCYRLO 30 String*4 Lowest Fiscal Year E A  Mask: %04D
FISCPERDLO 31 String*2 Lowest Fiscal Period E A  Mask: %02D
TOTTRNFILE 32 Integer Total Trans. Files In Import E A 
TOTTRNRECS 33 Long Total Trans. Records In Import E A 
TOTACCRECS 34 Long Total Account Records In Import E A 
TOTSRCRECS 35 Long Total Src Code Records In Import E A 
TOTSEGRECS 36 Long Total Segment Records In Import E A 
TOTBDGRECS 37 Long Total Budget Records In Import E A 
MULTICURN 38 Integer Export Was For Multi Curr. Co. E A  List:2 entries
0 = Single
1 = Multi
EXPDATE 39 Date Date Exported E A 
IMPUSER 40 String*8 User That Did Import E A 
EXPCOMP 41 String*6 Exporting Company E A 
SRCCURN 42 String*3 Func. Currency Of Exporting Co. E A  Mask: %-3N
VERSION 43 String*3 Program Version E A 
IMPOFDS 44 Integer Import Opt. Flds from G/L Setup E A  List:6 entries
0 = No
1 = Imported Successfully
2 = Not Available
3 = Missing
4 = Aborted
5 = Previously Imported
TOTOFDRECS 45 Long Total Opt. Flds Recs In Import E A 
IMPACTOPT 46 Integer Import Account Opt. Fields E A  List:2 entries
0 = No
1 = Yes
IMPTRANOPT 47 Integer Import Trans. Opt. Fields E A  List:2 entries
0 = No
1 = Yes
IMPCSOFDS 48 Integer Import Opt. Field from C/S Setup E A  List:6 entries
0 = No
1 = Imported Successfully
2 = Not Available
3 = Missing
4 = Aborted
5 = Previously Imported
TOTCSOFDS 49 Long Total C/S Setup Opt. Flds In Import E A 
IMPACCTGRP 50 Integer Import Account Groups E A  List:6 entries
0 = No
1 = Imported Successfully
2 = Not Available
3 = Missing
4 = Aborted
5 = Previously Imported
TOTAGPRECS 51 Long Total Account Groups In Import E A 
PRINTED 52 Integer Record Printed E A  List:2 entries
0 = No
1 = Yes
IMPDATE 53 Date Date Actually Imported E A 
FIRBTCH 54 String*6 First Batch Created For Import E A 
LSTBTCH 55 String*6 Last Batch Created For Import E A 
CLRSEL 56 Integer Clear Deselected Data E A  List:2 entries
0 = No
1 = Yes
DUPL 57 Integer Duplication Type E A  List:3 entries
0 = None
1 = Same Posting Seq.
2 = Same Fiscal Period
IMPSTATE 58 Integer Import State E A  List:3 entries
0 = Aborted
1 = Deleted
2 = Imported