# View: Import Audit

RotoID: ZC0010
Table: ZCIAUD
DLL: ZCIAUDV

## Compositions: 0

## Keys: 4

Title | Fields
--- | ---
Import Sequence | IMPSEQNR
Export Unit And Sequence | UNITID, PROCESS
Unit, Fiscal Year And Period | UNITID, FISCYR, FISCPERD
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 Imp | 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

This page was generated on 2008-Apr-11

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