Table: G/L Integration Options

Table: ARR06
View: AR0006
Record length: 99
Flags: A R 

Keys: 1

Title  Flags  Fields

Integration Options Key  IDR06

Fields: 32

Field  Type  Title  Presentation 

IDR06  String*3  Integration Options Key  Mask: %-3N
AUDTDATE  Date     
AUDTTIME  Time     
AUDTUSER  String*8     
AUDTORG  String*6     
DATELASTMN  Date  Date Last Maintained   
SWGLPSTDFR  Integer  Defer Create G/L Batch  List: 2 entries
0=During Posting
1=On Request Using Create G/L Batch Icon
SWGLAPDBTH  Integer  Create G/L Transactions By  List: 3 entries
1=Adding to an Existing Batch
0=Creating a New Batch
2=Creating and Posting a New Batch
SWGLPSTCON  Integer  Consolidate G/L Transactions  List: 3 entries
0=Do Not Consolidate
1=Consolidate by Post Seq., Account and Fiscal Period
2=Consolidate by Post Seq., Account, Fiscal Period and Source
CODEGLREF  Integer  RESERVED: G/L Reference Field   
CODEGLDESC  Integer  RESERVED: G/L Description Field   
GLPAYMPOST  BCD*5.0  Last Receipt Posting Seq. to G/L   
GLINVCPOST  BCD*5.0  Last Invoice Posting Seq. to G/L   
GLADJPOST  BCD*5.0  Last Adj. Posting Seq. to G/L   
GLRVALPOST  BCD*5.0  Last Reval. Posting Seq. to G/L   
GLRFPOST  BCD*5.0  Last Refund Posting Seq. to G/L   
SRCTYPEIN  String*2  G/L Src code - Invoice  Mask: %-2N
SRCTYPEDB  String*2  G/L Src code - Debit Note  Mask: %-2N
SRCTYPECR  String*2  G/L Src code - Credit Note  Mask: %-2N
SRCTYPEIT  String*2  G/L Src code - Interest  Mask: %-2N
SRCTYPEPY  String*2  G/L Src code - Payment Received  Mask: %-2N
SRCTYPEED  String*2  G/L Src code - Discount  Mask: %-2N
SRCTYPEGL  String*2  G/L Src code - Revaluation  Mask: %-2N
SRCTYPEAD  String*2  G/L Src code - Adjustment  Mask: %-2N
SRCTYPECO  String*2  G/L Src code - Consolidation  Mask: %-2N
SRCTYPEWO  String*2  G/L Src code - Write-Off  Mask: %-2N
SRCTYPEPI  String*2  G/L Src code - Prepayment  Mask: %-2N
SRCTYPEUC  String*2  G/L Src code - Unapplied Cash  Mask: %-2N
SRCTYPERF  String*2  G/L Src code - Refund  Mask: %-2N
SRCTYPERD  String*2  G/L Src code - Rounding  Mask: %-2N
SRCTYPEPYR  String*2  G/L Src code - Payment Reversal  Mask: %-2N
SRCTYPERFR  String*2  G/L Src code - Refund Reversal  Mask: %-2N

This page was generated on 2009-Nov-19

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