Export (0) Print
Expand All
Expand Minimize

LedgerJournalTable Table

The LedgerJournalTable table contains all defaulting and state information pertaining to a single journal. The transaction details of a journal are managed in the LedgerJournalTrans table.

ID: 211

Configuration Key: LedgerBasic

Security Key: LedgerTables

Method

Description

AccountNum

allowPosting_IT

aosValidateDelete

(Inherited from xRecord.)

aosValidateInsert

(Inherited from xRecord.)

aosValidateRead

(Inherited from xRecord.)

aosValidateUpdate

(Inherited from xRecord.)

Approved

ApprovedName

cancelTimeOut

Cancels a previous method call to the Object::setTimeOut Method. (Inherited from Object.)

Caption

checkDepositSlips

CheckJournalMayBeBooked

CheckJournalOpen

CheckNotGroupBlocked

CheckNotSystemBlocked

CheckNotUserBlocked

checkRecord

(Inherited from xRecord.)

checkRestrictedDeleteActions

(Inherited from xRecord.)

clear

(Inherited from xRecord.)

company

(Inherited from xRecord.)

concurrencyModel

(Inherited from xRecord.)

context

(Inherited from xRecord.)

data

(Inherited from xRecord.)

dataSource

(Inherited from xRecord.)

dbOpInTransaction

(Inherited from xRecord.)

defaultField

Sets a field to its default value.

defaultRow

Defaults field values for a LedgerJournalTable table row.

delete

disableCache

(Inherited from xRecord.)

distributeJournalLines

Distributes the lines of a journal into a number of new journals.

doClear

(Inherited from xRecord.)

doDelete

(Inherited from xRecord.)

doInsert

(Inherited from xRecord.)

doUpdate

(Inherited from xRecord.)

doValidateDelete

(Inherited from xRecord.)

editExchRate

editExchRateSecond

equal

(Inherited from xRecord.)

executeCachedDisplayMethods

(Inherited from xRecord.)

ExistVoucher

findOriginalJournalType

Finds the journal type of the original journal.

getPresenceFieldData

(Inherited from xRecord.)

getTimeOutTimerHandle

Returns the timer handle for the object. (Inherited from Object.)

handle

Retrieves the handle of the class of the object. (Inherited from Object.)

helpField

(Inherited from xRecord.)

InitFromLedgerJournalName

initFromLedgerJournalTable

initValue

(Inherited from xRecord.)

initWFApprovalStatus

Sets an initial state of the WorkflowApprovalStatus field of the LedgerJournalTable table.

insert

inUseUserId

isEligableForDistributionBeforePost

Indicates whether the journal has a large number of lines and should be distributed into several journals before attempting to post.

isFormDataSource

(Inherited from xRecord.)

IsGroupPrivate

isInWFApprovalProcess

Indicates whether a journal is in the workflow approval process.

isTmp

(Inherited from xRecord.)

IsUserPrivate

isWFApprovalApproved

Indicates whether a journal has been approved as a result of the workflow approval process.

isWFUserPermittedToEdit

Indicates whether the current user is a valid workflow user for the current workflow status.

joinChild

(Inherited from xRecord.)

joinParent

(Inherited from xRecord.)

JournalBalanceOnAccount

Calculates the balance amount of a specified journal based on account type, and account.

JournalTotalAccountCreditMST

JournalTotalAccountDebitMST

LedgerJournalName

log

MarkApproved

MarkRejected

MarkReportAsReady

MarkUserPrivate

merge

(Inherited from xRecord.)

modifiedField

new

Initializes a new instance of the Object class.. (Inherited from Object.)

notify

Releases the hold on an object that has called a wait method on this object. (Inherited from Object.)

notifyAll

Releases a lock on the object that was issued by a wait method on this object. (Inherited from Object.)

numOfLines

Counts the number of lines in a journal.

numOfVouchers

Counts the number of unique voucher numbers in the journal.

objectOnServer

Determines whether the object is on a server. (Inherited from Object.)

orig

(Inherited from xRecord.)

overwriteSystemfields

(Inherited from xRecord.)

owner

Returns the instance that owns the object. (Inherited from Object.)

postLoad

(Inherited from xRecord.)

queryTimedOut

(Inherited from xRecord.)

queryTimeout

(Inherited from xRecord.)

readPast

(Inherited from xRecord.)

recordLevelSecurity

(Inherited from xRecord.)

Rejected

RejectedName

renamePrimaryKey

(Inherited from xRecord.)

ReportedAsReady

ReportedAsReadyName

reread

(Inherited from xRecord.)

RowCount

(Inherited from xRecord.)

selectForUpdate

(Inherited from xRecord.)

selectLocked

(Inherited from xRecord.)

selectRefRecord

(Inherited from xRecord.)

selectWithRepeatableRead

(Inherited from xRecord.)

setConnection

(Inherited from xRecord.)

setEndBalance

setJournalBalance

setTimeOut

Sets up the scheduled execution of a specified method. (Inherited from Object.)

setTmp

(Inherited from xRecord.)

setTmpData

(Inherited from xRecord.)

skipAosValidation

(Inherited from xRecord.)

skipDatabaseLog

(Inherited from xRecord.)

skipDataMethods

(Inherited from xRecord.)

skipDeleteActions

(Inherited from xRecord.)

skipDeleteMethod

(Inherited from xRecord.)

skipEvents

Provides an option to turn off calling the Application.event* methods for the life time of the xRecord instance. (Inherited from xRecord.)

skipTTSCheck

(Inherited from xRecord.)

suppressWarnings

(Inherited from xRecord.)

toolTipField

(Inherited from xRecord.)

toolTipRecord

(Inherited from xRecord.)

toString

Returns a string that represents the current object. (Inherited from Object.)

ttsabort

(Inherited from xRecord.)

ttsbegin

(Inherited from xRecord.)

ttscommit

(Inherited from xRecord.)

type

Gets the LedgerJournalTableType derivative for the LedgerJournalTable table.

update

(Inherited from xRecord.)

usageCount

(Inherited from xRecord.)

UserBlockIdName

validateDelete

(Inherited from xRecord.)

validateField

Determines whether the value of a field is valid.

validateWrite

Determines whether the current record is valid and ready to be written to the database.

wait

Pauses a process. (Inherited from Object.)

wasCached

(Inherited from xRecord.)

write

(Inherited from xRecord.)

xml

(Inherited from xRecord.)

::aggregateLedgerJournalTrans

::checkExist

::exist

::find

::findByRecId

Finds a record in the LedgerJournalTable table by searching on the RecId field.

::findRecId

::findVendorInvoicePool

::findVendorInvoicePoolNotPosted

::insertJournalsInLedgerJournalMultiPost

Inserts a number of journals into a LedgerJournalMultiPost object.

::journalBalanceMST

::txtNotExist

Gets the message to use when a specific record in the LedgerJournalTable table does not exist.

Field

ID

Type

Configuration key

Description

JournalNum

1

Extended Data Type: LedgerJournalId

Type: str

LedgerBasic

Ledger - Journal batch number.

Name

2

Extended Data Type: Name

Type: str

None

Description of the current journal

VoucherSeries

3

Extended Data Type: NumberSequenceCode

Type: str

None

Journal voucher series

Log

4

Extended Data Type: LogText

Type: str

None

Log error messages

JournalType

5

Enumeration: LedgerJournalType

LedgerBasic

Journal type that determines what the journal is used for.

WorkflowApprovalStatus

6

Enumeration: LedgerJournalWFApprovalStatus

LedgerBasic

Status of the workflow approval for this journal

SystemBlocked

8

Enumeration: NoYes

None

Is the journal locked?

PaymentsGenerated_IT

9

Enumeration: NoYes

CRSEItaly

Payments are generated.

UserBlockId

10

Extended Data Type: JournalBlockUserId

Type: str

None

User that the journal is private to.

OffsetAccount

11

Extended Data Type: LedgerAccount

Type: str

LedgerBasic

Offset account proposal for journal lines

DEL_PostedDate

12

Extended Data Type: TransDate

Type: date

SysDeletedObjects41

Date of the final journal entry

RejectedBy

13

System Data Type: userId

Type: str

LedgerBasic

Has approval of the journal been rejected?

ReportedAsReadyBy

14

System Data Type: userId

Type: str

LedgerBasic

Has the journal been reported as ready?

ApprovedBy

15

Extended Data Type: ApprovedBy

Type: str

LedgerBasic

Employee number.

JournalName

17

Extended Data Type: LedgerJournalNameId

Type: str

LedgerBasic

Identification of the journal name.

Posted

18

Extended Data Type: JournalPosted

Type: NoYes

None

Has the journal been posted?

SessionLoginDateTime

19

Extended Data Type: JournalSessionLoginDateTime

Type: utcdatetime

None

Date and time.

OffsetAccountType

20

Enumeration: LedgerJournalACType

None

Offset account type

InUseBy

21

System Data Type: userId

Type: str

None

User who has locked the journal.

GroupBlockId

22

Extended Data Type: JournalBlockUserGroupId

Type: str

None

User group that the journal is private to.

Dimension

23

Extended Data Type: Dimension

Type: str

None

Department number.

OriginalJournalNum

24

Extended Data Type: LedgerJournalId

Type: str

LedgerBasic

Identification of the originating journal.

CurrencyCode

25

Extended Data Type: CurrencyCode

Type: str

None

Current currency code.

FixedExchRate

26

Extended Data Type: FixedExchRate

Type: NoYes

Currency

Specify whether forced exchange rate is to be used.

DetailSummaryPosting

27

Enumeration: DetailSummary

None

Specify summation level

DocumentNum

28

Extended Data Type: DocumentNum

Type: str

None

Number of the document that generated the voucher.

ExchrateSecondary

29

Extended Data Type: ExchrateSecondary

Type: real

CurrencyEuro

Rate of the secondary part of the currency calculation, when triangulation is used.

ExchRate

30

Extended Data Type: ExchRate

Type: real

Currency

Specify the cost in the foreign currency.

EUROTriangulation

31

Extended Data Type: EUROTriangulation

Type: NoYes

CurrencyEuro

Specify whether the exchange rate is included in triangulation.

FixedOffsetAccount

32

Extended Data Type: FixedOffsetAccount

Type: NoYes

LedgerBasic

Specifies whether posting may be made to one specific offset account only.

JournalTotalCredit

33

Extended Data Type: AmountMST

Type: real

None

Specifies the total of all vendor transactions in the journal

JournalTotalDebit

34

Extended Data Type: AmountMST

Type: real

None

Specifies the total of all customer transactions in the journal

journalTotalOffsetBalance

35

Extended Data Type: AmountMST

Type: real

None

Transaction amount in default currency.

RemoveLineAfterPosting

36

Extended Data Type: LedgerJournalDelLine

Type: NoYes

None

Delete journal lines when posting is completed?

CurrentOperationsTax

37

Enumeration: CurrentOperationsTax

LedgerBasic

Code for current, operating or fiscal transaction

LedgerJournalInclTax

38

Extended Data Type: LedgerJournalInclTax

Type: NoYes

LedgerBasicSalesTax

Amount entered in the journals includes sales tax

OriginalCompany

39

System Data Type: selectableDataArea

Type: str

LedgerAdvIntercompanyAccounting

Company that the journal is created from when intercompany accounting.

SessionId

40

Extended Data Type: JournalSessionId

Type: int

None

ID for the current session.

DEL_SessionLoginTime

41

Extended Data Type: DEL_JournalSessionLoginTime

Type: int

SysDeletedObjects41

Logon time of the owner of the current transaction.

DEL_SessionLoginDate

42

Extended Data Type: DEL_JournalSessionLoginDate

Type: date

SysDeletedObjects41

Logon date of the owner of the current transaction.

BankRemittanceType

43

Enumeration: BankRemittanceType

CustVendNegotiableInstrument

Specify the type of remittance made to the bank.

BankAccountId

44

Extended Data Type: CompanyBankAccountId

Type: str

CustVendNegotiableInstrument

Own number of the account in the bank.

ProtestSettledBill

45

Extended Data Type: NoYesId

Type: NoYes

CustVendNegotiableInstrument

Protest of settled negotiable instruments

JournalBalance

46

Extended Data Type: LedgerJournalBalance

Type: real

CRSEBelgium

Amount in currency.

EndBalance

47

Extended Data Type: LedgerJournalEndBalance

Type: real

CRSEBelgium

Amount in currency.

CustVendNegInstProtestProcess

48

Enumeration: CustVendNegInstProtestProcess

None

How must protest of settled transactions be handled: as invoice (France/Belgium) or as open payment (Spain)?

VoucherAllocatedAtPosting

49

Extended Data Type: VoucherAllocatedAtPosting

Type: NoYes

None

Voucher number allocation in journals at posting.

NumOfLines

50

Extended Data Type: JournalNumOfLines

Type: int

None

Number of journal lines.

LinesLimitBeforeDistribution

51

Extended Data Type: LedgerJournalLinesLimit

Type: int

None

If the number of lines in a journal exceeds this number, posting will distribute the lines into several smaller journals.

PostedDateTime

53

Extended Data Type: JournalPostedDateTime

Type: utcdatetime

None

Date of the final journal entry

ReverseEntry

56

Enumeration: NoYes

LedgerBasicReversingEntries

Indicates that the current voucher is a reversing entry.

ReverseDate

57

Extended Data Type: TransDate

Type: date

LedgerBasicReversingEntries

Enter a posting date for the reversing voucher.

createdBy

61446

System Data Type: createdBy

Type: str

None

dataAreaId

61448

System Data Type: dataAreaId

Type: str

None

recVersion

61450

System Data Type: recVersion

Type: int

None

RecId

65534

System Data Type: recId

Type: int64

None

Field Group

Fields

Amount

ApprovalProcedure

ReportedAsReadyBy

ApprovedBy

RejectedBy

WorkflowApprovalStatus

AutoReport

JournalNum

JournalName

Name

JournalType

VoucherSeries

OffsetAccountType

OffsetAccount

Posted

BillOfExchange

BankRemittanceType

BankAccountId

DefaultValues

OffsetAccountType

OffsetAccount

FixedOffsetAccount

CurrencyCode

FixedExchRate

ExchRate

ExchrateSecondary

EUROTriangulation

CurrentOperationsTax

Description

Name

DocumentNum

Dimension

Dimension

Dimension

Dimension

Identification

JournalNum

JournalTotals

JournalBalance

JournalTotalDebit

JournalTotalCredit

journalTotalOffsetBalance

EndBalance

Log

Log

OriginalJournalNum

Named

JournalName

JournalType

Origin

OriginalCompany

OriginalJournalNum

PaymentsGenerated

PaymentsGenerated_IT

Post

Posted

PostedDateTime

DetailSummaryPosting

RemoveLineAfterPosting

LinesLimitBeforeDistribution

PromissoryNote

BankAccountId

Protest

ProtestSettledBill

CustVendNegInstProtestProcess

ReversingEntry

ReverseEntry

ReverseDate

SalesTax

LedgerJournalInclTax

Session

SessionId

SessionLoginDateTime

SystemLog

SystemBlocked

UserBlockId

GroupBlockId

InUseBy

Totals

NumOfLines

UnifiedWorkListPreview

Name

JournalNum

VoucherAllocation

VoucherAllocatedAtPosting

VoucherJournalTable

VoucherSeries

Relation

Table

Lines

AssetBook

AssetBook Table

LedgerJournalTable.OffsetAccountType == 5

LedgerJournalTable.OffsetAccount == AssetBook.AssetId

Bank

BankAccountTable Table

LedgerJournalTable.OffsetAccountType == 6

LedgerJournalTable.OffsetAccount == BankAccountTable.AccountID

BankAccountTable

BankAccountTable Table

LedgerJournalTable.BankAccountId == BankAccountTable.AccountID

Currency

Currency Table

LedgerJournalTable.CurrencyCode == Currency.CurrencyCode

CustTable

CustTable Table

LedgerJournalTable.OffsetAccount == CustTable.AccountNum

LedgerJournalTable.OffsetAccountType == 1

DataArea

DataArea Table

LedgerJournalTable.dataAreaId == DataArea.id

Dimensions

Dimensions Table

LedgerJournalTable.Dimension == Dimensions.Num

0 == Dimensions.DimensionCode

EmplTable

EmplTable Table

LedgerJournalTable.ApprovedBy == EmplTable.EmplId

LedgerJournalName

LedgerJournalName Table

LedgerJournalTable.JournalName == LedgerJournalName.JournalName

LedgerJournalTable

LedgerJournalTable Table

LedgerJournalTable.JournalNum == LedgerJournalTable.JournalNum

LedgerTable

LedgerTable Table

LedgerJournalTable.OffsetAccount == LedgerTable.AccountNum

LedgerJournalTable.OffsetAccountType == 0

NumberSequenceTable

NumberSequenceTable Table

LedgerJournalTable.VoucherSeries == NumberSequenceTable.NumberSequence

Project

ProjTable Table

LedgerJournalTable.OffsetAccountType == 3

LedgerJournalTable.OffsetAccount == ProjTable.ProjId

UserGroupInfo

UserGroupInfo Table

LedgerJournalTable.GroupBlockId == UserGroupInfo.id

UserInfo

UserInfo Table

LedgerJournalTable.InUseBy == UserInfo.id

VendTable

VendTable Table

LedgerJournalTable.OffsetAccount == VendTable.AccountNum

LedgerJournalTable.OffsetAccountType == 2

Index

AllowDuplicates

Enabled

Fields

PostedJournalNumIdx

Yes

Yes

JournalType

Posted

JournalNum

RecId

No

Yes

RecId

TypeNumIdx

No

Yes

JournalNum

Community Additions

ADD
Show:
© 2015 Microsoft