You are here: Reference Guide > Table Structures > General Ledger > GL_Sets

GL_Sets

Purpose    

Maintains the header record for each journal set, including type of journal, repeating instructions for template journals and reversal details.

Path        

General Ledger Journal Transactions Journals

Name

Type

Linked To/Supplied

GLSetID

Text (20)

 

LastSavedDateTime

Date/Time

 

SetNo

Text (20)

 

PostDateTime

Date/Time

 

PostedToPeriodNo

Number (Integer)

 

Description

Text (250)

 

Source

Text (50)

 

SourceID

Text (20)

BR_Main.BankRecID;CB_BatchTrans.CBBatchID;CR_BatchTrans.ReceiptID;DB_BatchTrans.ReceiptID;IN_Assembly.INAssemblyID

IN_CostChange.ChangeID;IN_StandCost.INStandCostID;IN_StockTakeMain.StockTakeID;IN_Transfer.TransferID;PO_Main.OrderID

PI_Main.PIMain.ID;RE_Main.PackSlipID;SO_Main.InvoiceID;WH_Transfer.WH_TransferID

UserName

Text (50)

 

SetType

Number (Integer)

0 = Posted;1 = Template;2 = Pending;3 = Error

QuickSet

Yes/No

0 = No;1 = Cash book

QuickSetGLLedgerID

Text (20)

 

QuickSetDebitCredit

Yes/No

0 = No; 1 = Yes

RepeatingType

Number (Integer)

0 = None;1 = Day;2 = Month

RepeatingUnits

Number (Integer)

 

NextRepeatingDate

Date/Time

 

RepeatingWillEnd

Yes/No

 

RepeatingEndDate

Date/Time

 

ReverseType Number (Integer) 0 = None;1 = At set period start;2 = At specific date start;3 = At reverse date
ReversePeriod Number (Integer)  
ReverseDate Date/Time  
Reversed Yes/No 0 = No; 1 = Yes
YearNo Number (Integer)  

Copyright © 2012 Jiwa Financials. All rights reserved.