Statistical Journal

statisticaljournalentry

Fields

Label ID Type UI Workbook SuiteScript / SuiteTalk REST Web Services Connect
Absolute Balance Update Journal absoluteupdatejournallink select Yes Yes Yes
Absolute Balance Update Offset Journal offsetjournallink select Yes Yes Yes
Accounting Period postingperiod select Yes Yes Yes
Approval Status approvalstatus select Yes Yes Yes
Approved approved checkbox Yes Yes Yes
Created By createdby select Yes Yes Yes
Created from Statistical Schedule parentstat select Yes Yes Yes
Date trandate date Yes Yes Yes
Date Created createddate datetime Yes Yes Yes
Date Last Modified lastmodifieddate datetime Yes Yes Yes
Entry No. tranid text Yes Yes Yes
Exclude from GL Audit Numbering excludefromglnumbering checkbox Yes Yes Yes
External ID externalid text Yes Yes Yes
Internal ID id integer Yes Yes Yes
Is Intercompany Adjustment intercoadj checkbox Yes Yes Yes
Is Reversal isreversal checkbox Yes Yes Yes
Last Modified By lastmodifiedby select Yes Yes Yes
Line line sublist Yes Yes Yes
Memo memo text Yes Yes Yes
Next Approver nextapprover select Yes Yes Yes
-No label- origexchangerate currency2 Yes Yes Yes
Reversal Date reversaldate date Yes Yes Yes
Reversal Doc reversal select Yes Yes Yes
Status status select Yes Yes Yes
Subsidiary subsidiary select Yes Yes Yes
Total total currency Yes Yes Yes
Transaction Number transactionnumber text Yes Yes Yes
Unit of Measure unit select Yes Yes Yes
Unit of Measure Type unitstype select Yes Yes Yes
Voided voided checkbox Yes Yes Yes

Joins

Join Target Record UI Workbook SuiteScript / SuiteTalk REST Web Services Connect
Statistical Journal Line to Account (account.id) statistical journal line (statisticaljournalentryline, statisticaljournalentryline.account) No Yes Yes
Statistical Journal Line to Class (classification.id) statistical journal line (statisticaljournalentryline, statisticaljournalentryline.class) No Yes Yes
Statistical Journal Line to Custom Recognition Event Type (ratableEventType.id) statistical journal line (statisticaljournalentryline, statisticaljournalentryline.createexpenseplanson) No Yes Yes
Statistical Journal Line to Department (department.id) statistical journal line (statisticaljournalentryline, statisticaljournalentryline.department) No Yes Yes
Statistical Journal Line to Entity (entity.id) statistical journal line (statisticaljournalentryline, statisticaljournalentryline.entity) No Yes Yes
Statistical Journal Line to Expense Amortization Rule (expenseAmortizationRule.id) statistical journal line (statisticaljournalentryline, statisticaljournalentryline.expenseamortizationrule) No Yes Yes
Statistical Journal Line to Revenue Plan Status (revenuePlanStatus.key) statistical journal line (statisticaljournalentryline, statisticaljournalentryline.expenseplanstatus) Yes Yes Yes
Statistical Journal Line to Units (unitsTypeUom.internalid) statistical journal line (statisticaljournalentryline, statisticaljournalentryline.lineunit) No Yes Yes
Statistical Journal Line to Location (location.id) statistical journal line (statisticaljournalentryline, statisticaljournalentryline.location) No Yes Yes
Statistical Journal Line to Revenue Recognition Rule (revenueRecognitionRule.id) statistical journal line (statisticaljournalentryline, statisticaljournalentryline.revenuerecognitionrule) No Yes Yes
Statistical Journal Line to Revenue Recognition Schedule (revRecSchedule.id) statistical journal line (statisticaljournalentryline, statisticaljournalentryline.schedule) No Yes Yes
Statistical Journal Line to Revenue Recognition Schedule (revRecSchedule.id) statistical journal line (statisticaljournalentryline, statisticaljournalentryline.schedulenum) No Yes Yes
Statistical Journal to Accounting Book (accountingBook.id) statistical journal (statisticaljournalentry, statisticaljournalentry.accountingbook) No Yes Yes
Statistical Journal to Approval Status (ApprovalStatus.id) statistical journal (statisticaljournalentry, statisticaljournalentry.approvalstatus) Yes Yes Yes
Statistical Journal to Entity (entity.id) statistical journal (statisticaljournalentry, statisticaljournalentry.createdby) No Yes Yes
Statistical Journal to Currency (currency.id) statistical journal (statisticaljournalentry, statisticaljournalentry.currencyprevvalue) No Yes Yes
Statistical Journal to Nexus (Nexus.id) statistical journal (statisticaljournalentry, statisticaljournalentry.entitynexus) No Yes Yes
Statistical Journal to Entity (entity.id) statistical journal (statisticaljournalentry, statisticaljournalentry.lastmodifiedby) No Yes Yes
Statistical Journal Line to Statistical Journal (statisticalJournalEntry.id) statistical journal line (statisticaljournalentryline, statisticaljournalentryline.journal) No Yes Yes
Statistical Journal to Employee (employee.id) statistical journal (statisticaljournalentry, statisticaljournalentry.nextapprover) No Yes Yes
Statistical Journal to Nexus (Nexus.id) statistical journal (statisticaljournalentry, statisticaljournalentry.nexusoverride) No Yes Yes
Statistical Journal to Nexus (Nexus.id) statistical journal (statisticaljournalentry, statisticaljournalentry.originalnexus) No Yes Yes
Statistical Journal to Statistical Schedule (statisticalSchedule.id) statistical journal (statisticaljournalentry, statisticaljournalentry.parentstat) No Yes Yes
Statistical Journal to Accounting Period (accountingPeriod.id) statistical journal (statisticaljournalentry, statisticaljournalentry.postingperiod) No Yes Yes
Statistical Journal to Statistical Journal (statisticalJournalEntry.id) statistical journal (statisticaljournalentry, statisticaljournalentry.reversal) No Yes Yes
Statistical Journal to Subsidiary (subsidiary.id) statistical journal (statisticaljournalentry, statisticaljournalentry.subsidiary) No Yes Yes
Statistical Journal to Units (unitsTypeUom.internalid) statistical journal (statisticaljournalentry, statisticaljournalentry.unit) No Yes Yes
Statistical Journal to Units Type (unitsType.id) statistical journal (statisticaljournalentry, statisticaljournalentry.unitstype) No Yes Yes