# Table: G/L Consol. Export Header

Table: ZCESPH
View: ZC0001
Record length: 487
Flags: A R

## Keys: 1

Title | Flags | Fields
--- | --- | ---
Process ID |  | PROCESS

## Fields: 66

Field | Type | Title | Presentation
--- | --- | --- | ---
PROCESS | String*8 | Process ID | Mask: %-8N
AUDTDATE | Date |  |
AUDTTIME | Time |  |
AUDTUSER | String*8 |  |
AUDTORG | String*6 |  |
DESCR | String*60 | Description |
SRCID | String*4 | Source Unit ID | Mask: %-4N
SELMETH | Integer | Selection Method |
SPECSEG | Integer | Specify Segments | List: 2 entries
0 | = | No
1 | = | Yes
SEGNUM | String*6 | Segment Number | Mask: %06d
SEGFR | String*15 | Segment From | Mask: %-15N
SEGTO | String*15 | Segment To | Mask: %-15N
USEMAP | Integer | Use Mapping Table | List: 2 entries
0 | = | No
1 | = | Yes
MAPERR | Integer | Generate Error If Unmapped | List: 2 entries
0 | = | No
1 | = | Yes
MAPACCT | Integer | Only Map Whats In Table | List: 2 entries
0 | = | No
1 | = | Yes
MAPTRNSF | Integer | Only Transfer Whats Mapped | List: 2 entries
0 | = | No
1 | = | Yes
MAPTBL | String*8 | Mapping Table | Mask: %-8N
CONSBUD | Integer | Consolidate Budgets | List: 2 entries
0 | = | No
1 | = | Yes
EXPMETH | Integer | Export Method | List: 4 entries
0 | = | Net Changes
3 | = | Balances
1 | = | Transactions By Posting Sequence
2 | = | Transactions By Fiscal Period
TXDESC | String*60 | Net Chg. G/L Description |
SUBSRC | Integer | Substitute Source Codes | List: 2 entries
0 | = | No
1 | = | Yes
TRSRCLEDG | String*2 | Default Transaction Ledger | Mask: %-2N
DSRCLEDG | String*2 | Default Source Ledger | Mask: %-2N
DSRCTYPE | String*2 | Default Source Type | Mask: %-2N
PERDOFFS | Integer | Period Offset |
EXPTRANS | Integer | Export Transactions | List: 2 entries
0 | = | No
1 | = | Yes
EXPACCTS | Integer | Export Accounts | List: 2 entries
0 | = | No
1 | = | Yes
EXPACTACC | Integer | Export Inactive Accounts | List: 2 entries
0 | = | No
1 | = | Yes
ACTINACT | Integer | Set Inactive Accounts To Active | List: 2 entries
0 | = | No
1 | = | Yes
EXPSRC | Integer | Export Source Codes | List: 2 entries
0 | = | No
1 | = | Yes
EXPSEGS | Integer | Export Segments | List: 2 entries
0 | = | No
1 | = | Yes
EXPBUDS | Integer | Export Budgets | List: 2 entries
0 | = | No
1 | = | Yes
EXPBUD1 | Integer | Export Budget 1 | List: 2 entries
0 | = | No
1 | = | Yes
EXPBUD2 | Integer | Export Budget 2 | List: 2 entries
0 | = | No
1 | = | Yes
EXPBUD3 | Integer | Export Budget 3 | List: 2 entries
0 | = | No
1 | = | Yes
EXPBUD4 | Integer | Export Budget 4 | List: 2 entries
0 | = | No
1 | = | Yes
EXPBUD5 | Integer | Export Budget 5 | List: 2 entries
0 | = | No
1 | = | Yes
EXPBDFRYR | String*4 | Export Budget From Yr | Mask: %04D
EXPBDTOYR | String*4 | Export Budget To Yr | Mask: %04D
EXPMAP | Integer | Export Mapping Table Changes | List: 2 entries
0 | = | No
1 | = | Yes
EORIGAUD | Integer | Export Orig. Audit Trail | List: 2 entries
0 | = | No
1 | = | Yes
CZRTRANS | Integer | Create Trans. With Zero Value | List: 2 entries
0 | = | No
1 | = | Yes
MAXTRANS | Integer | Max. Trans. Per File |
TRANBALACC | String*45 | Entry Balancing Acct. | Mask: %-45C
MULTICURN | Integer | Multi Currency Destination Co. | List: 2 entries
0 | = | No
1 | = | Yes
EXPOTHCUR | Integer | Export In Another Currency | List: 2 entries
0 | = | No
1 | = | Yes
OVRRIDEMC | Integer | Override Multi Currency | List: 2 entries
0 | = | No
1 | = | Yes
MCSW | Integer | Multi Currency Switch | List: 2 entries
0 | = | No
1 | = | Yes
SPECSW | Integer | Specified Currency Switch | List: 2 entries
0 | = | All Currency
1 | = | Specific Currency
EXPCURRID | String*3 | Currency Code | Mask: %-3N
RATETYPE | String*2 | Dflt Currency Rate Type | Mask: %-2N
XCHGPROF | String*45 | Exchange Gain Acct. | Mask: %-45C
XCHGLOS | String*45 | Exchange Loss Acct. | Mask: %-45C
BUDRATTYP | String*2 | Rate Type For Budgets | Mask: %-2N
UNITBALACC | String*45 | Unit Balancing Acct. | Mask: %-45C
TDATEUSE | Integer | Trans. Currency XChange Date | List: 3 entries
0 | = | Fiscal Period
1 | = | Transaction Date
2 | = | User Specified
BDATEUSE | Integer | Buds. Currency XChange Date | List: 2 entries
0 | = | No
1 | = | Yes
RUNTEDIT | Integer | Allow Runtime Edit | List: 2 entries
0 | = | No
1 | = | Yes
LASTYR | String*4 | Last Fiscal Year Exported | Mask: %04D
LASTPERD | String*2 | Last Fiscal Period Exported | Mask: %02D
EXPSEQNO | Integer | Export Sequence Number |
LOCALEXP | Integer | Retain Orig. G/L Ref And Desc. | List: 2 entries
0 | = | No
1 | = | Yes
TRANSCURN | Integer | Translation Currency | List: 2 entries
0 | = | Functional Currency
1 | = | Source Currency
EXPACTOPT | Integer | Export Account Opt. Fields | List: 2 entries
0 | = | No
1 | = | Yes
EXPTRANOPT | Integer | Export Trans. Opt. Fields | List: 2 entries
0 | = | No
1 | = | Yes
EXPOPTFLD | Integer | Export Opt. Flds from G/L Setup | List: 2 entries
0 | = | No
1 | = | Yes

This page was generated on 2006-Sep-07

Copyright © 2001–2005 Sage Accpac International, Inc.