CData Python Connector for NetSuite

Build 25.0.9454

AccountingPeriod

Manages fiscal periods for financial reporting, ensuring accurate period-based accounting in NetSuite.

Columns

Name Type ReadOnly Description
InternalId [KEY] String True

A unique internal identifier assigned to this accounting period in NetSuite.

AllLocked Boolean False

Indicates whether all transactions within this accounting period are locked from further modifications.

AllowNonGLChanges Boolean False

Specifies whether non-General Ledger (GL) changes, such as tax or reporting adjustments, are permitted in this accounting period.

ApLocked Boolean False

Indicates whether Accounts Payable (AP) transactions are locked for this accounting period, preventing changes to vendor bills and payments.

ArLocked Boolean False

Indicates whether Accounts Receivable (AR) transactions are locked for this accounting period, preventing modifications to invoices and customer payments.

Closed Boolean False

Specifies whether this accounting period has been closed, preventing any further financial transactions or adjustments.

ClosedOnDate Datetime False

The date on which this accounting period was officially closed, ensuring compliance with financial reporting deadlines.

EndDate Datetime False

The last date of this accounting period, marking the end of financial activity for the period.

FiscalCalendar_ExternalId String False

The external identifier for the fiscal calendar associated with this accounting period, used for integrations with external financial systems.

FiscalCalendar_InternalId String False

The internal identifier linking this accounting period to its assigned fiscal calendar in NetSuite.

FiscalCalendar_Name String False

The name of the fiscal calendar to which this accounting period belongs, such as '2024 Fiscal Year.'

FiscalCalendar_Type String False

Defines the type of fiscal calendar associated with this accounting period, such as standard, custom, or regulatory.

The allowed values are account, accountingPeriod, appDefinition, appPackage, assemblyBuild, assemblyUnbuild, assemblyItem, bin, binTransfer, binWorksheet, budget, budgetCategory, calendarEvent, campaign, campaignAudience, campaignCategory, campaignChannel, campaignFamily, campaignOffer, campaignResponse, campaignSearchEngine, campaignSubscription, campaignVertical, cashRefund, cashSale, check, classification, contact, contactCategory, contactRole, costCategory, couponCode, creditMemo, crmCustomField, currency, currencyRate, customList, customRecord, customRecordCustomField, customRecordType, customer, customerCategory, customerDeposit, customerMessage, customerPayment, customerRefund, customerStatus, depositApplication, department, descriptionItem, discountItem, downloadItem, employee, entityCustomField, entityGroup, estimate, expenseCategory, expenseReport, file, folder, giftCertificate, giftCertificateItem, interCompanyJournalEntry, interCompanyTransferOrder, inventoryAdjustment, inventoryItem, inventoryNumber, inventoryTransfer, invoice, itemCustomField, itemDemandPlan, itemFulfillment, itemGroup, itemNumberCustomField, itemOptionCustomField, itemSupplyPlan, itemRevision, issue, job, jobStatus, jobType, itemReceipt, journalEntry, kitItem, leadSource, location, lotNumberedInventoryItem, lotNumberedAssemblyItem, markupItem, message, manufacturingCostTemplate, manufacturingOperationTask, manufacturingRouting, nexus, nonInventoryPurchaseItem, nonInventoryResaleItem, nonInventorySaleItem, note, noteType, opportunity, otherChargePurchaseItem, otherChargeResaleItem, otherChargeSaleItem, otherCustomField, otherNameCategory, partner, partnerCategory, paycheckJournal, paymentItem, paymentMethod, payrollItem, phoneCall, priceLevel, pricingGroup, projectTask, promotionCode, purchaseOrder, returnAuthorization, revRecSchedule, revRecTemplate, salesOrder, salesRole, salesTaxItem, serializedInventoryItem, serializedAssemblyItem, servicePurchaseItem, serviceResaleItem, serviceSaleItem, solution, siteCategory, state, subsidiary, subtotalItem, supportCase, supportCaseIssue, supportCaseOrigin, supportCasePriority, supportCaseStatus, supportCaseType, task, taxGroup, taxType, term, timeBill, topic, transferOrder, transactionBodyCustomField, transactionColumnCustomField, unitsType, vendor, vendorCategory, vendorBill, vendorCredit, vendorPayment, vendorReturnAuthorization, winLossReason, workOrder, workOrderIssue, workOrderCompletion, workOrderClose.

FiscalCalendarsList_ReplaceAll Boolean False

Determines whether all existing fiscal calendar associations should be replaced when updating this accounting period.

IsAdjust Boolean False

Indicates whether this accounting period is an adjustment period, used for year-end closing entries and corrections.

IsQuarter Boolean False

Specifies whether this accounting period represents a financial quarter, such as Q1 or Q2, for reporting purposes.

IsYear Boolean False

Indicates whether this accounting period is a full fiscal year, used in financial statements and annual reporting.

Parent_ExternalId String False

The external identifier for the parent accounting period in a hierarchical structure, used in consolidated reporting.

Parent_InternalId String False

The internal identifier of the parent accounting period, linking related periods for financial analysis.

Parent_Name String False

The name of the parent accounting period, such as 'FY 2024' for a quarterly sub-period.

Parent_Type String False

Defines the classification of the parent accounting period, such as annual, quarterly, or adjustment period.

The allowed values are account, accountingPeriod, appDefinition, appPackage, assemblyBuild, assemblyUnbuild, assemblyItem, bin, binTransfer, binWorksheet, budget, budgetCategory, calendarEvent, campaign, campaignAudience, campaignCategory, campaignChannel, campaignFamily, campaignOffer, campaignResponse, campaignSearchEngine, campaignSubscription, campaignVertical, cashRefund, cashSale, check, classification, contact, contactCategory, contactRole, costCategory, couponCode, creditMemo, crmCustomField, currency, currencyRate, customList, customRecord, customRecordCustomField, customRecordType, customer, customerCategory, customerDeposit, customerMessage, customerPayment, customerRefund, customerStatus, depositApplication, department, descriptionItem, discountItem, downloadItem, employee, entityCustomField, entityGroup, estimate, expenseCategory, expenseReport, file, folder, giftCertificate, giftCertificateItem, interCompanyJournalEntry, interCompanyTransferOrder, inventoryAdjustment, inventoryItem, inventoryNumber, inventoryTransfer, invoice, itemCustomField, itemDemandPlan, itemFulfillment, itemGroup, itemNumberCustomField, itemOptionCustomField, itemSupplyPlan, itemRevision, issue, job, jobStatus, jobType, itemReceipt, journalEntry, kitItem, leadSource, location, lotNumberedInventoryItem, lotNumberedAssemblyItem, markupItem, message, manufacturingCostTemplate, manufacturingOperationTask, manufacturingRouting, nexus, nonInventoryPurchaseItem, nonInventoryResaleItem, nonInventorySaleItem, note, noteType, opportunity, otherChargePurchaseItem, otherChargeResaleItem, otherChargeSaleItem, otherCustomField, otherNameCategory, partner, partnerCategory, paycheckJournal, paymentItem, paymentMethod, payrollItem, phoneCall, priceLevel, pricingGroup, projectTask, promotionCode, purchaseOrder, returnAuthorization, revRecSchedule, revRecTemplate, salesOrder, salesRole, salesTaxItem, serializedInventoryItem, serializedAssemblyItem, servicePurchaseItem, serviceResaleItem, serviceSaleItem, solution, siteCategory, state, subsidiary, subtotalItem, supportCase, supportCaseIssue, supportCaseOrigin, supportCasePriority, supportCaseStatus, supportCaseType, task, taxGroup, taxType, term, timeBill, topic, transferOrder, transactionBodyCustomField, transactionColumnCustomField, unitsType, vendor, vendorCategory, vendorBill, vendorCredit, vendorPayment, vendorReturnAuthorization, winLossReason, workOrder, workOrderIssue, workOrderCompletion, workOrderClose.

PayrollLocked Boolean False

Indicates whether payroll transactions are locked for this accounting period, preventing modifications to payroll data.

PeriodName String False

The official name of this accounting period, such as 'January 2024' or 'Q1 2024,' used in reports and financial statements.

StartDate Datetime False

The first date of this accounting period, marking the beginning of financial activity for the period.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9454