# Table: Import Audit

Table: ZCIAUD
View: ZC0010
Record length: 203
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: 58

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
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 2006-Sep-07

Copyright © 2001–2005 Sage Accpac International, Inc.