Table: LedgerJournalTrans (Journal lines)

Label color codes
Label on fieldLabel on enum type
Label on extended data typeLabel on ancestor
Show table properties
Field Group:
P.idxKeyField Pos.FieldLabelExtended Data Type / Enum TypeTypeMore properties...
FK1JournalNumJournal numberLedgerJournalIdStringShow
2LineNumLine NoLineNumRealShow
TR3AccountTypeAccount typeLedgerJournalACTypeEnumShow
TR4AccountNumAccountLedgerJournalACStringShow
TR5CompanyCompany accountsselectableDataAreaStringShow
TR6TxtTransaction textLedgerJournalTransTxtStringShow
7AmountCurDebitDebitAmountCurDebitRealShow
FK8CurrencyCodeCurrencyCurrencyCodeStringShow
9ExchRateExchange rateExchRateRealShow
TR10TaxGroupSales tax groupTaxGroupJournalStringShow
11QtyQuantityQtyStatisticalRealShow
FK12DimensionDepartmentDimensionStringShow
13PricePricePriceRealShow
14InterCoDimensionDepartmentDimensionLedgerJournalStringShow
15SettleVoucherSettlement typeSettlementTypeEnumShow
TR16PostingProfilePosting profilePostingProfileStringShow
17VoucherVoucherVoucherStringShow
18AmountCurCreditCreditAmountCurCreditRealShow
19PaymentStatusPayment statusCustVendPaymStatusEnumShow
20CashDiscAmountDiscount amountDiscAmountRealShow
21VendTransId---recIdIntegerShow
22CustTransId---recIdIntegerShow
23RemainAmountBalanceAmountRealShow
TR FK24TaxCodeSales tax codeTaxCodeStringShow
TR25OffsetAccountOffset accountLedgerJournalACStringShow
26BankDepositVoucherUse a deposit slipBankDepositVoucherEnumShow
27PaymReferencePayment referencePaymReferenceStringShow
28BankDepositNumDeposit slipBankDepositNumStringShow
TR29PaymSpecPayment specificationPaymSpecStringShow
TR30PaymModeMethod of paymentPaymModeStringShow
TR31OffsetAccountTypeOffset account typeLedgerJournalACTypeEnumShow
FK32BankTransTypeBank transaction typeBankTransactionTypeStringShow
TR33OffsetCompanyOffset company accountsselectableDataAreaStringShow
TR34OffsetTxtOffset-transaction textLedgerJournalTransTxtStringShow
35Tax1099AmountAmountTax1099AmountRealShow
FK36Tax1099Box1099 boxTax1099BoxStringShow
37PaymentNotesNotePaymNoteStringShow
38ForeignVoucherForeign voucherVoucherStringShow
39ForeignCompanyForeign company accountsselectableDataAreaStringShow
40ForeignTaxSales taxNoYesEnumShow
41TransferredTransferredNoYesEnumShow
42CancelCancelledCancelledEnumShow
43NoEdit---NoYesEnumShow
44Invisible---NoYesEnumShow
45TransDateDateTransDateDateShow
46TransactionTypeTransaction typeLedgerTransTypeEnumShow
47DocumentDateDateTransDateDateShow
48DocumentNumDocumentDocumentNumStringShow
49ApprovedApprovedApprovedEnumShow
50ApprovedByApproved byLedgerApprovedByStringShow
51PaymIdPayment IDPaymIdStringShow
52FreqValueNumber of unitsFreqIntegerShow
53FreqCodeUnitPeriodUnitEnumShow
54DueDue dateDueDateDateShow
55DateCashDiscCash discount dateTransDateDateShow
56TransferredByTransferred byuserIdStringShow
57LoadingDateDate of importTransDateDateShow
58FileCreatedFile generated onTransDateDateShow
FK59PaymentAccountPayment accountLedgerAccountStringShow
60InvoiceInvoiceInvoiceIdStringShow
FK61TransferredToTransferred to journalLedgerJournalIdStringShow
62TransferTransferNoYesEnumShow
63LastTransferredLast dateLastTransferredDateShow
64TransferredOnTransferred onTransDateDateShow
65PurchLedgerPostingPurchase postingPurchLedgerPostingEnumShow
66BankChequeNumCheck numberBankChequeNumStringShow
FK67PaymentTerms of paymentPaymTermIdStringShow
FK68CashDiscCodeCash discountCashDiscCodeStringShow
69SalesPriceSales priceSalesPriceRealShow
70ProjQtyQuantityQtyRealShow
71CostPriceCost priceCostPriceRealShow
72ProjCategoryIdCategoryProjCategoryCostIdStringShow
FK73ProjLinePropertyIdLine propertyProjLinePropertyIdStringShow
74ExchRateSecondSecondary exchange rateExchrateSecondaryRealShow
75TriangulationTriangulationEUROTriangulationEnumShow
TR76TaxItemGroupItem sales tax groupTaxGroupJournalStringShow
77VATNumJournalTax exempt numberVATNumJournalStringShow
FK78ProjSalesCurrencyIdSales currencyProjSalesCurrencyCodeStringShow
79ListcodeList codeListcodeIdEnumShow
80FurtherPostingTypeBridging postingFurtherPostingTypeEnumShow
81PurchIdRangePurchase orderPurchIdRangeStringShow
82PoolRecIdInvoice pool record IDRefRecIdIntegerShow
83PrepaymentPrepaymentNoYesEnumShow
84ImportDateImport dateTransDateDateShow
85OCRLineOCR lineOCRLineStringShow
FK86BankCentralBankPurposeCodeCentral Bank Purpose CodeBankCentralBankPurposeCodeStringShow
87BankCentralBankPurposeTextPurpose textBankCentralBankPurposeTextStringShow
88CustVendBankAccountIdAccount identificationBankAccountIDStringShow
89PaymentSequenceNumFile No.PaymentSequenceNumIntegerShow
90AssetTransTypeTransaction typeAssetTransTypeJournalEnumShow
91AssetToFromRecIdRelates to recordrecIdIntegerShow
92AssetBudgetModelBudget modelAssetBudgetModelIdStringShow
FK93AssetIdFixed asset numberAssetIdStringShow
94AssetBudgetPostingStatusPosting statusAssetBudgetPostingStatusEnumShow
95AssetDepreciationTimeDepreciation periodAssetDepreciationTimeRealShow
96AssetRefAssetIdReference table IDAssetRefAssetIdStringShow
TR97ProjTaxGroupSalesSales tax groupTaxGroupJournalStringShow
TR98ProjTaxItemGroupSalesItem sales tax groupTaxGroupJournalStringShow
99DEL_PaymReconciliationRecIdOutdatedRefRecIdIntegerShow
100ErrorCodePaymentError codeErrorCodePaymentStringShow
101FurtherPostingRecId---recIdIntegerShow
102TaxDirectionControlSales tax directionNoYesEnumShow
103ReserveTransIdReferenceRefRecIdIntegerShow
104AssetSection179TransSection 179 write-offAssetSection179TransEnumShow
105AssetRevaluationAmountRevaluation amountAssetRevaluationAmountRealShow
106AssetRevaluationTransRevaluation transactionAssetRevaluationTransEnumShow
107AssetConsumptionQtyConsumption unitAssetConsumptionRealShow
TR108AssetBookIdValue modelAssetBookIdPurchSalesInventStringShow
109CustVendNegInstProtestReasonProtest causeCustVendNegInstProtestReasonEnumShow
110BankRemittanceTypeRemittance typeBankRemittanceTypeEnumShow
TR111BankRemittanceFileIdRemittance numberBankRemittanceFileIdStringShow
FK112BankAccountIdBank accountCompanyBankAccountIdStringShow
FK113BankPromissoryNoteNumPromissory note numberBankPromissoryNoteNumStringShow
FK114ProjEmplIdEmployeeEmplIdStringShow
FK115PaymInstructionId1Payment instruction code 1PaymInstructionIdStringShow
FK116PaymInstructionId2Payment instruction code 2PaymInstructionIdStringShow
FK117PaymInstructionId3Payment instruction code 3PaymInstructionIdStringShow
FK118PaymInstructionId4Payment instruction code 4PaymInstructionIdStringShow
FK119PaymItemCodeIdItem codePaymItemCodeIdStringShow

Table Relations

AssetBook
LedgerJournalTrans.AccountType == 5
LedgerJournalTrans.Company == AssetBook.dataAreaId
LedgerJournalTrans.AccountNum == AssetBook.AssetId
LedgerJournalTrans.AssetBookId == AssetBook.BookId
AssetLedger
LedgerJournalTrans.AccountType == 5
LedgerJournalTrans.PostingProfile == AssetLedger.PostingProfile
AssetTable
LedgerJournalTrans.Company == AssetTable.dataAreaId
LedgerJournalTrans.AccountType == 5
LedgerJournalTrans.AccountNum == AssetTable.AssetId
Bank
LedgerJournalTrans.Company == BankAccountTable.dataAreaId
LedgerJournalTrans.AccountType == 6
LedgerJournalTrans.AccountNum == BankAccountTable.AccountID
BankRemittanceFilesCust
LedgerJournalTrans.BankRemittanceFileId == BankRemittanceFilesCust.FileId
BankRemittanceFilesVend
LedgerJournalTrans.BankRemittanceFileId == BankRemittanceFilesVend.FileId
CustPaymMode
LedgerJournalTrans.AccountType == 1
LedgerJournalTrans.PaymMode == CustPaymModeTable.PaymMode
CustPaymModeSpec
LedgerJournalTrans.AccountType == 1
LedgerJournalTrans.PaymMode == CustPaymModeSpec.PaymMode
LedgerJournalTrans.PaymSpec == CustPaymModeSpec.Specification
CustPostingProfile
LedgerJournalTrans.AccountType == 1
LedgerJournalTrans.PostingProfile == CustLedger.PostingProfile
CustTable
LedgerJournalTrans.Company == CustTable.dataAreaId
LedgerJournalTrans.AccountType == 1
LedgerJournalTrans.AccountNum == CustTable.AccountNum
CustTransCashDisc
LedgerJournalTrans.RecId == CustTransCashDisc.RefRecId
LedgerJournalTrans.TableId == CustTransCashDisc.RefTableId
InterCoDimension0
LedgerJournalTrans.Company == Dimensions.dataAreaId
0 == Dimensions.DimensionCode
LedgerJournalTrans.InterCoDimension[1] == Dimensions.Num
InterCoDimension1
1 == Dimensions.DimensionCode
LedgerJournalTrans.InterCoDimension[2] == Dimensions.Num
LedgerJournalTrans.Company == Dimensions.dataAreaId
InterCoDimension2
2 == Dimensions.DimensionCode
LedgerJournalTrans.InterCoDimension[3] == Dimensions.Num
LedgerJournalTrans.Company == Dimensions.dataAreaId
LedgerJournalTxt
LedgerJournalTrans.Txt == LedgerJournalTxt.Txt
LedgerJournalTxtOffset
LedgerJournalTrans.OffsetTxt == LedgerJournalTxt.Txt
LedgerTable
LedgerJournalTrans.Company == LedgerTable.dataAreaId
LedgerJournalTrans.AccountType == 0
LedgerJournalTrans.AccountNum == LedgerTable.AccountNum
OffsetAssetTable
LedgerJournalTrans.OffsetCompany == AssetTable.dataAreaId
LedgerJournalTrans.OffsetAccountType == 5
LedgerJournalTrans.OffsetAccount == AssetTable.AssetId
OffsetBank
LedgerJournalTrans.OffsetCompany == BankAccountTable.dataAreaId
LedgerJournalTrans.OffsetAccountType == 6
LedgerJournalTrans.OffsetAccount == BankAccountTable.AccountID
OffsetCustTable
LedgerJournalTrans.OffsetCompany == CustTable.dataAreaId
LedgerJournalTrans.OffsetAccountType == 1
LedgerJournalTrans.OffsetAccount == CustTable.AccountNum
OffsetLedger
LedgerJournalTrans.OffsetCompany == LedgerTable.dataAreaId
LedgerJournalTrans.OffsetAccount == LedgerTable.AccountNum
LedgerJournalTrans.OffsetAccountType == 0
OffsetProject
LedgerJournalTrans.OffsetAccountType == 3
LedgerJournalTrans.OffsetAccount == ProjTable.ProjId
OffsetVendTable
LedgerJournalTrans.OffsetCompany == VendTable.dataAreaId
LedgerJournalTrans.OffsetAccountType == 2
LedgerJournalTrans.OffsetAccount == VendTable.AccountNum
Project
LedgerJournalTrans.AccountType == 3
LedgerJournalTrans.AccountNum == ProjTable.ProjId
ProjTaxGroup
LedgerJournalTrans.ProjTaxGroupSales == TaxGroupHeading.TaxGroup
LedgerJournalTrans.Company == TaxGroupHeading.dataAreaId
ProjTaxItemGroup
LedgerJournalTrans.ProjTaxItemGroupSales == TaxItemGroupHeading.TaxItemGroup
LedgerJournalTrans.Company == TaxItemGroupHeading.dataAreaId
TaxGroup
LedgerJournalTrans.Company == TaxGroupHeading.dataAreaId
LedgerJournalTrans.TaxGroup == TaxGroupHeading.TaxGroup
TaxItemGroup
LedgerJournalTrans.TaxItemGroup == TaxItemGroupHeading.TaxItemGroup
LedgerJournalTrans.Company == TaxItemGroupHeading.dataAreaId
TaxTable
LedgerJournalTrans.TaxCode == TaxTable.TaxCode
LedgerJournalTrans.Company == TaxTable.dataAreaId
VendPaymentMode
LedgerJournalTrans.AccountType == 2
LedgerJournalTrans.PaymMode == VendPaymModeTable.PaymMode
VendPaymentModeCostJournal
LedgerJournalTrans.AccountType == 3
LedgerJournalTrans.OffsetAccountType == 2
LedgerJournalTrans.PaymMode == VendPaymModeTable.PaymMode
VendPaymentModeSpec
LedgerJournalTrans.AccountType == 2
LedgerJournalTrans.PaymMode == VendPaymModeSpec.PaymMode
LedgerJournalTrans.PaymSpec == VendPaymModeSpec.Specification
VendPaymentModeSpecCostJournal
LedgerJournalTrans.AccountType == 3
LedgerJournalTrans.OffsetAccountType == 2
LedgerJournalTrans.PaymMode == VendPaymModeSpec.PaymMode
LedgerJournalTrans.PaymSpec == VendPaymModeSpec.Specification
VendPostingProfile
LedgerJournalTrans.AccountType == 2
LedgerJournalTrans.PostingProfile == VendLedger.PostingProfile
VendPostingProfileCostJournal
LedgerJournalTrans.AccountType == 3
LedgerJournalTrans.OffsetAccountType == 2
LedgerJournalTrans.PostingProfile == VendLedger.PostingProfile
VendTable
LedgerJournalTrans.Company == VendTable.dataAreaId
LedgerJournalTrans.AccountType == 2
LedgerJournalTrans.AccountNum == VendTable.AccountNum
VendTransCashDisc
LedgerJournalTrans.RecId == VendTransCashDisc.RefRecId
LedgerJournalTrans.TableId == VendTransCashDisc.RefTableId

Overridden System Defined Methods

void delete(boolean _deleteVoucher = true)
void initValue()
void insert()
public void modifiedField(fieldId _fieldId)
void update()
boolean validateDelete()
boolean validateField(fieldId field)
server boolean validateWrite()

Public Static Methods

server static AmountMST balanceOnVoucher(LedgerJournalId _ledgerJournalId, Voucher _voucher)
server static amountMST bankAccountTrans(CompanyBankAccountId _bankAccountNum)
Server static TaxAmountCur calcTaxOnInvoice(LedgerJournalTrans _ledgerJournalTrans)
static boolean CheckSettledAmount(ledgerJournalTrans _ledgerJournalTrans)
server static void deleteIfZeroAmount(LedgerJournalId _ledgerJournalId)
server static void deleteLineAfterPosting(LedgerJournalId _ledgerJournalId)
server static void deleteTransFromVoucher(LedgerJournalId _journalNum, Voucher _voucher)
static boolean exist(LedgerJournalId _ledgerJournalId, Voucher _voucher, LineNum _lineNum)
static boolean existJournalTrans(LedgerJournalId _ledgerJournalId)
static boolean existTrans(LedgerJournalId _ledgerJournalId, Voucher _voucher, RecId _recId = 0)
static boolean existTransMinusThis(LedgerJournalId _ledgerJournalId, Voucher _voucher, recId _recId)
static LedgerJournalTrans find(LedgerJournalId _ledgerJournalId, Voucher _voucher, boolean _forUpdate)
static LedgerJournalTrans findRecId(recId _recId, boolean _forUpdate)
server static recId findVendTransId(LedgerJournalId _ledgerJournalId, Voucher _voucher)
static boolean isCreated(recId _recId)
server Static Container journalBalanceMST(LedgerJournalId _ledgerJournalId, boolean _addTax = false)
static LineNum lastLineNum(LedgerJournalId _ledgerJournalId)
server static LedgerJournalTrans mainAccount(LedgerJournalId _ledgerJournalId, Voucher _voucher)
server static boolean mixedAccountTypes(LedgerJournalId _ledgerJournalId, Voucher _voucher)
static void MixedDueDate(ledgerJournalTrans _ledgerJournalTrans)
server Static void rejectCheque(LedgerJournalTrans _ledgerJournalTrans, BankAccountID _bankAccountID)
static voucher splitCreateNewVoucher(LedgerJournalId _ledgerJournalId)
server static AmountMST sumJournalAccount(LedgerJournalId _ledgerJournalId, LedgerJournalACType _accountType, LedgerJournalAC _accountNum)
server static boolean useErrorAccount(LedgerJournalId _ledgerJournalId, Voucher _voucher)

Public Instance Methods

display LedgerJournalAccountName accountName()
LedgerJournalAccountName accountNameFind(LedgerJournalACType _accountType, LedgerJournalAC _accountNum)
display LedgerJournalACType accountType()
display Amount amount()
void amountCur2DebCred(AmountCur _amountCur, Boolean _correction = false)
AmountMST calcAmountMST()
Amount calcCreditMST()
Amount calcDebitMST()
void calcPaymentFee()
server void calcTax()
void categoryModified()
boolean checkAccountTypesProject()
boolean checkAllowEdit()
boolean checkAllowPosting(LedgerJournalAC _ledgerAccount, LedgerJournalACType _ledgerJournalACType, selectableDataArea _company)
void checkAmount()
boolean checkCurrency()
boolean checkExchRate()
server boolean checkJournalAccountControl()
boolean checkNegInstPosting()
boolean checkPaymentFilledOk(LedgerJournalTable _ledgerJournalTable)
boolean checkVATNumJournal()
boolean checkVATPosting()
boolean checkVatTransaction()
server boolean checkVoucherNotUsed(LedgerJournalTable _ledgerJournalTable)
boolean checkVoucherSeries(LedgerJournalTable _ledgerJournalTable)
boolean correct()
void createNewPayment(SpecTrans _specTrans, CustVendTrans _custVendTrans)
server void createTransferTrans(LedgerJournalTrans ledgerJournalOld, LedgerJournalId _ledgerJournalId)
display ExchrateSecondary crossrate()
display CurrencyCode currencyCode()
boolean custPaymentFilledOk()
DebCredProposal debCredProposal()
ExchRate decimateExchRate()
server void deleteVoucher(Voucher _voucher)
display ExchRateSecondTxt exchRateTxt()
void fillAssetBookTableDerivedJournal()
server void fillPaymentNotes()
ProjTable findProjTable(boolean _offsetAccount = false)
client boolean formSelectSettledNegInst(LedgerJournalEngine _ledgerJournalEngine)
client boolean formSettlement(LedgerJournalEngine _ledgerJournalEngine)
void generateRemittanceFeeTrans()
server void initAssetBookid()
server void initAssetBookidOffset()
void initFromLedgerTrans(LedgerTrans _ledgerTrans)
void initPostingProfile()
LedgerAccount ledgerAccountNum()
LedgerJournalTable ledgerJournalTable()
display LedgerJournalACType mainAccountType()
Display LedgerJournalAccountName offsetAccountName()
void paymModeModified()
Common setAccountTableBuffer()
CustVendSettlement setCustVendSettlementbuffer()
CustVendTransOpen setCustVendTransOpenbuffer()
void setLedgerTaxGroup()
void setListCode()
void setOffsetAccount(LedgerJournalTable _ledgerJournalTable, LedgerJournalACType _ledgerJournalACType, LedgerJournalAC _ledgerJournalAccount)
void setProjAmount()
void setProjectEmptyValues()
display NoYes settledTrans()
boolean settlement()
server void splitPaymentInvoice(LedgerJournalEngine _ledgerJournalEngine, TransDate _transDate = dateNull())
server void splitPaymentInvoiceSettled(LedgerJournalEngine _ledgerJournalEngine, TransDate _transDate = dateNull())
server void splitPaymentTransDate(LedgerJournalEngine _ledgerJournalEngine, Boolean _splitPaymentWeek = false, TransDate _transDate = dateNull())
server void splitPaymentWeek(LedgerJournalEngine _ledgerJournalEngine, TransDate _transDate = dateNull())
void swapAccountOffsetaccount()
server display TaxAmountJournal taxAmountInCostPrice()
server display TaxAmountJournal taxAmountJournal()
boolean validateInvoice()
display VendAccount vendor()
boolean vendPaymentFilledOk()
void warnAboutOpeningTrans()
Generated by Axapta Doc Generator v. 0.5.2 on 05 Dec 2006
Axapta Doc Generator is licensed under the MIT License. Axapta is a registered trademark of Microsoft Corporation.