CData Python Connector for NetSuite

Build 25.0.9454

PurchaseOrder

Records purchase orders for goods and services, including vendor details and approval status in NetSuite.

Columns

Name Type ReadOnly Description
InternalId [KEY] String True

The internal identifier of the purchase order. This unique ID is used to reference and manage the purchase order within the system, ensuring it can be tracked and updated as needed.

ApprovalStatus_ExternalId String False

The external identifier of the approval status associated with the purchase order. This ID links the order's approval status to an external system or process.

ApprovalStatus_InternalId String False

The internal identifier of the approval status associated with the purchase order. This ID helps track and manage the approval stage within the internal system.

ApprovalStatus_Name String False

The name of the approval status for the purchase order. It provides a clear label to indicate the current approval state, such as 'Pending,' 'Approved,' or 'Rejected.'

ApprovalStatus_Type String False

The type of approval status for the purchase order. This can help categorize the status, such as 'Approval Required' or 'Awaiting Review,' to streamline the approval process.

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.

BillAddress String False

The billing address for the purchase order. This field contains the address where invoices or bills related to the order will be sent.

BillAddressList_ExternalId String False

The external identifier for the bill address list associated with the purchase order. This ID links to an external list of billing addresses used in transactions.

BillAddressList_InternalId String False

The internal identifier for the bill address list linked to the purchase order. This ID helps the system manage and track associated billing addresses within the company.

BillAddressList_Name String False

The name of the bill address list for the purchase order. This name helps categorize and identify the set of billing addresses that apply to the order.

BillAddressList_Type String False

The type of the bill address list linked to the purchase order. It helps classify the address list, such as 'Customer Billing Address' or 'Default Billing Address.'

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.

Class_ExternalId String False

The external identifier for the class associated with the purchase order. This ID ties the order to a specific classification in an external system or accounting framework.

Class_InternalId String False

The internal identifier for the class associated with the purchase order. This helps the internal system classify the order according to its business function or department.

Class_Name String False

The name of the class linked to the purchase order. This could represent the business unit or category under which the purchase order falls, such as 'Sales,' 'Procurement,' or 'Operations.'

Class_Type String False

The type of class associated with the purchase order. This categorizes the class for reporting or accounting purposes, such as 'Cost Center' or 'Profit Center.'

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.

CreatedDate Datetime False

The date and time when the purchase order was created. This timestamp provides a reference for when the order was initiated and can be useful for tracking and auditing.

CreatedFrom_ExternalId String False

The external identifier for the transaction or document that created the purchase order. This ties the order to its origin, such as a sales order or requisition.

CreatedFrom_InternalId String False

The internal identifier for the transaction or document that created the purchase order. This ID helps track the source of the order within the internal system.

CreatedFrom_Name String False

The name of the transaction or document that created the purchase order. This label helps identify the originating document, such as 'Sales Order #123' or 'Requisition #456.'

CreatedFrom_Type String False

The type of transaction or document that created the purchase order. This classification, such as 'Sales Order' or 'Purchase Requisition,' provides context for the origin of the order.

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.

Currency_ExternalId String False

The external identifier for the currency used in the purchase order. This ID links the order to a specific currency in external systems, such as 'USD' or 'EUR.'

Currency_InternalId String False

The internal identifier for the currency used in the purchase order. This ID is used within the internal system to manage the currency associated with the order.

Currency_Name String False

The name of the currency used in the purchase order. This provides a readable label for the currency, such as 'U.S. Dollar' or 'Euro,' for easy reference.

Currency_Type String False

The type of currency used in the purchase order. This can help classify the currency, such as 'Base Currency' or 'Foreign Currency,' depending on the business's needs.

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.

CurrencyName String False

The name of the currency used in the purchase order, specified as a string for clarity. This is typically used for display purposes, such as 'USD' or 'GBP.'

CustomForm_ExternalId String False

The external identifier for the custom form associated with the purchase order. This ID links to a specific form used to capture additional details about the order from an external system.

CustomForm_InternalId String False

The internal identifier for the custom form associated with the purchase order. This ID helps the internal system track the customized form that applies to the order.

CustomForm_Name String False

The name of the custom form used for the purchase order. This provides a label to help identify the form, such as 'Purchase Order Form' or 'Requisition Form.'

CustomForm_Type String False

The type of custom form applied to the purchase order. This field helps categorize the form, such as 'Invoice Form' or 'Procurement Form,' for proper processing.

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.

Department_ExternalId String False

The external identifier for the department associated with the purchase order. This ID links the order to a specific department in an external system.

Department_InternalId String False

The internal identifier for the department associated with the purchase order. This ID is used within the company to manage departmental classifications for orders.

Department_Name String False

The name of the department linked to the purchase order. This field identifies the department, such as 'Procurement' or 'Operations,' that initiated or is responsible for the order.

Department_Type String False

The type of department linked to the purchase order. It helps classify the department based on its role, such as 'Purchasing Department' or 'Finance Department.'

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.

DueDate Datetime False

The due date for the purchase order. This is the date by which the goods or services ordered are expected to be delivered or the payment is due.

Email String False

The email address associated with the purchase order. This is typically used for communication purposes, such as order confirmations or inquiries related to the order.

Employee_ExternalId String False

The external identifier for the employee associated with the purchase order. This ID links the order to a specific employee in an external system, such as an HR or payroll system.

Employee_InternalId String False

The internal identifier for the employee associated with the purchase order. This ID helps track the employee responsible for initiating or processing the order within the internal system.

Employee_Name String False

The name of the employee associated with the purchase order. This is typically used for reference or reporting purposes to identify the employee responsible for the order.

Employee_Type String False

The type of employee associated with the purchase order. This helps classify the employee, such as 'Procurement Officer' or 'Account Manager,' for role-based reporting or approval workflows.

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.

Entity_ExternalId String False

The external identifier for the entity associated with the purchase order. This ID links the order to a specific entity, such as a company or vendor, in an external system.

Entity_InternalId String False

The internal identifier for the entity associated with the purchase order. This ID helps the internal system track the entity that the order is being placed with or for.

Entity_Name String False

The name of the entity associated with the purchase order. This could be the vendor, supplier, or business unit involved in the transaction, such as 'ABC Supplies' or 'XYZ Corporation.'

Entity_Type String False

The type of entity associated with the purchase order. This classification helps differentiate between suppliers, customers, or internal departments that the order relates to.

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.

ExchangeRate Double False

The exchange rate applied to the purchase order when converting between different currencies. This value helps ensure accurate currency conversion for international transactions.

ExpenseList_ReplaceAll Boolean False

A flag indicating whether the list of expenses associated with the purchase order should be replaced entirely. This is used to manage expense tracking and reporting.

ExternalId String False

The external identifier of the purchase order. This ID is used to reference the order in external systems, such as a supplier's system or an integration platform.

Fax String False

The fax number associated with the purchase order. This is typically used for sending physical copies of the order or related documents to the recipient.

Fob String False

The FOB (Free On Board) term associated with the purchase order. This indicates the shipping terms, specifying the point at which responsibility for the goods transfers from the seller to the buyer.

IntercoStatus String False

The intercompany status for the purchase order. This field is used when dealing with transactions between different subsidiaries or entities within the same parent company.

The allowed values are _paired, _pending, _rejected.

IntercoTransaction_ExternalId String False

The external identifier for the intercompany transaction linked to the purchase order. This ID links the order to the corresponding intercompany transaction in an external system.

IntercoTransaction_InternalId String False

The internal identifier for the intercompany transaction linked to the purchase order. This ID helps track and manage the transaction within the internal system.

IntercoTransaction_Name String False

The name of the intercompany transaction linked to the purchase order. This name provides context to the intercompany relationship, such as 'Transfer to Subsidiary X.'

IntercoTransaction_Type String False

The type of intercompany transaction associated with the purchase order. This could represent different types of intercompany activities, such as 'Internal Transfer' or 'Cross-entity Order.'

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.

ItemList_ReplaceAll Boolean False

A flag indicating whether the list of items in the purchase order should be replaced entirely. This helps manage item additions and removals in the order.

LastModifiedDate Datetime False

The date and time when the purchase order was last modified. This helps track updates and changes to the order over its lifecycle.

LinkedTrackingNumbers String False

A list of tracking numbers associated with the purchase order. These numbers can be used to track the delivery of goods or services ordered through the purchase.

Location_ExternalId String False

The external identifier for the location associated with the purchase order. This ID ties the order to a specific location, such as a warehouse or distribution center, in an external system.

Location_InternalId String False

The internal identifier for the location associated with the purchase order. This ID helps manage and track the location within the internal system.

Location_Name String False

The name of the location associated with the purchase order. This field identifies the physical location, such as 'Main Warehouse' or 'Supplier Facility,' related to the order.

Location_Type String False

The type of location associated with the purchase order. This helps classify locations, such as 'Warehouse,' 'Store,' or 'Vendor Location,' for operational purposes.

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.

Memo String False

A note or comment related to the purchase order. This field can contain additional context, such as instructions, special requests, or comments about the order.

Message String False

A custom message associated with the purchase order. This message can be used to communicate special instructions or additional details about the order to the vendor or other parties involved.

NextApprover_ExternalId String False

The external identifier for the next approver in the approval workflow of the purchase order. This helps track the progress of the approval process, especially in a multi-step workflow.

NextApprover_InternalId String False

The internal identifier for the next approver in the approval workflow of the purchase order. This ID helps the internal system route the order for approval within the organization.

NextApprover_Name String False

The name of the next approver in the approval workflow of the purchase order. This identifies the person responsible for reviewing and approving the order.

NextApprover_Type String False

The type of the next approver in the approval workflow of the purchase order. This field helps identify the role of the approver, such as 'Manager' or 'Procurement Officer.'

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.

OrderStatus String False

The current status of the purchase order. This can include statuses such as 'Pending,' 'Approved,' 'Shipped,' or 'Closed,' providing an overview of where the order is in its lifecycle.

The allowed values are _closed, _fullyBilled, _partiallyReceived, _pendingBillingPartiallyReceived, _pendingBilling, _pendingReceipt, _pendingSupervisorApproval, _rejectedBySupervisor.

OtherRefNum String False

An external reference number related to the purchase order. This could be a vendor’s reference number, a purchase request number, or any other number used to track the order externally.

ShipAddress String False

The shipping address for the purchase order. This address is used for delivery and can include details such as street address, city, postal code, and country.

ShipAddressList_ExternalId String False

The external identifier for the list of shipping addresses associated with the purchase order. This ID links the order to the shipping address details in an external system.

ShipAddressList_InternalId String False

The internal identifier for the list of shipping addresses associated with the purchase order. This helps manage and track the list of shipping addresses within the internal system.

ShipAddressList_Name String False

The name of the shipping address list associated with the purchase order. This can represent a specific address or group of addresses related to the order, such as 'Main Delivery Address.'

ShipAddressList_Type String False

The type of shipping address list associated with the purchase order. This classification helps differentiate between various address types, such as 'Shipping,' 'Billing,' or 'Return Address.'

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.

ShipDate Datetime False

The expected or actual ship date for the purchase order. This indicates when the goods or services should be shipped or have been shipped, helping track delivery timelines.

ShipMethod_ExternalId String False

The external identifier for the shipping method associated with the purchase order. This ID links the order to the specific shipping method in an external logistics or transportation system.

ShipMethod_InternalId String False

The internal identifier for the shipping method associated with the purchase order. This helps the internal system track and manage the shipping method used for delivering the order.

ShipMethod_Name String False

The name of the shipping method associated with the purchase order. This can be something like 'Standard Shipping,' 'Expedited Delivery,' or 'Freight,' indicating the delivery method.

ShipMethod_Type String False

The type of shipping method associated with the purchase order. This field helps classify the shipping method, such as 'Ground,' 'Air,' or 'Ocean Freight,' for logistics reporting.

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.

ShipTo_ExternalId String False

The external identifier for the recipient of the shipment in the purchase order. This ID links the order to a specific entity, such as a customer or department, in an external system.

ShipTo_InternalId String False

The internal identifier for the recipient of the shipment in the purchase order. This ID helps track the recipient within the organization or system, such as the warehouse or recipient department.

ShipTo_Name String False

The name of the recipient for the shipment in the purchase order. This could represent an individual, department, or entity responsible for receiving the goods.

ShipTo_Type String False

The type of recipient for the shipment in the purchase order. This could indicate whether the shipment is going to an internal department, a customer, or a third-party recipient.

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.

Source String False

The source of the purchase order. This field helps track how the order was generated, such as 'Manual Entry,' 'Online Order,' 'Vendor System,' or 'Internal Requisition.'

Status String False

The status of the purchase order, which can include 'Pending,' 'Approved,' 'Fulfilled,' or 'Closed.' This provides an overview of the order's progress through the purchasing process.

Subsidiary_ExternalId String False

The external identifier for the subsidiary associated with the purchase order. This links the order to a specific subsidiary in an external system for intercompany transactions.

Subsidiary_InternalId String False

The internal identifier for the subsidiary associated with the purchase order. This helps track and manage intercompany transactions and financial reporting across different business units or locations.

Subsidiary_Name String False

The name of the subsidiary associated with the purchase order. This helps identify the specific branch or division of the company involved in the purchase.

Subsidiary_Type String False

The type of the subsidiary associated with the purchase order. This classification helps distinguish between various types of subsidiaries, such as 'Sales Subsidiary,' 'Manufacturing Subsidiary,' or 'Logistics Subsidiary.'

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.

SubTotal Double False

The subtotal of the purchase order, representing the total value of the order before tax and other charges. This is used to calculate the final total cost of the order.

SupervisorApproval Boolean False

Indicates whether supervisor approval is required for the purchase order. This field helps enforce additional oversight or controls before the order can be processed or approved.

Tax2Total Double False

The total tax amount for a second-level tax (if applicable) in the purchase order. This is used for managing multiple tax rates, such as state and local taxes.

TaxTotal Double False

The total tax amount for the purchase order. This is the sum of all applicable taxes based on the items and shipping method, used for calculating the final cost of the order.

Terms_ExternalId String False

The external identifier for the terms associated with the purchase order. This links the order to specific payment or delivery terms, such as 'Net 30,' 'COD,' or 'Installment Payments.'

Terms_InternalId String False

The internal identifier for the terms associated with the purchase order. This helps track the payment and delivery conditions within the organization.

Terms_Name String False

The name of the terms associated with the purchase order. This could represent specific financial terms, such as 'Net 30 Days,' 'Prepaid,' or 'Cash on Delivery,' determining how and when payment is made.

Terms_Type String False

The type of terms associated with the purchase order. This field categorizes the payment or delivery terms, such as 'Cash,' 'Credit,' or 'Deferred Payment.'

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.

ToBeEmailed Boolean False

Indicates whether the purchase order is to be emailed to the recipient or another party. This option is useful for automating communication and ensuring that stakeholders are notified about the order.

ToBeFaxed Boolean False

Indicates whether the purchase order is to be faxed to the recipient or another party. This option allows for traditional communication methods to be used when needed.

ToBePrinted Boolean False

Indicates whether the purchase order is to be printed for physical distribution. This can be used for compliance, record-keeping, or handing the document over in physical form.

Total Double False

The total amount of the purchase order after all charges, taxes, discounts, and adjustments have been applied. This is the final amount payable for the order.

TrackingNumbers String False

The tracking numbers associated with the purchase order shipment. These are used to track the package during transit and provide visibility into the status of the delivery.

TranDate Datetime False

The transaction date of the purchase order, representing the date on which the purchase was initiated or processed. This helps with accounting, reporting, and historical tracking of purchases.

TranId String False

The unique transaction identifier for the purchase order. This ID helps track the order across different systems and can be used for referencing, reporting, or audit purposes.

TransactionBillAddress_BillAddr1 String False

The first line of the billing address for the purchase order. This address is used for invoicing and billing purposes.

TransactionBillAddress_BillAddr2 String False

The second line of the billing address for the purchase order. It is used to capture additional address details such as apartment numbers or building names.

TransactionBillAddress_BillAddr3 String False

The third line of the billing address for the purchase order. This can include further address information, such as floor numbers or suite identifiers.

TransactionBillAddress_BillAddressee String False

The name of the individual or entity to whom the bill for the purchase order is addressed. This could be a department, a company, or an individual.

TransactionBillAddress_BillAttention String False

The attention line of the billing address, indicating the person or department to contact for issues related to the purchase order's billing.

TransactionBillAddress_BillCity String False

The city portion of the billing address for the purchase order. This helps ensure accurate and complete billing information for invoicing.

TransactionBillAddress_BillCountry String False

The country of the billing address for the purchase order. This is necessary for international billing and for ensuring the correct country-specific rules are followed.

The allowed values are _afghanistan, _alandIslands, _albania, _algeria, _americanSamoa, _andorra, _angola, _anguilla, _antarctica, _antiguaAndBarbuda, _argentina, _armenia, _aruba, _australia, _austria, _azerbaijan, _bahamas, _bahrain, _bangladesh, _barbados, _belarus, _belgium, _belize, _benin, _bermuda, _bhutan, _bolivia, _bonaireSaintEustatiusAndSaba, _bosniaAndHerzegovina, _botswana, _bouvetIsland, _brazil, _britishIndianOceanTerritory, _bruneiDarussalam, _bulgaria, _burkinaFaso, _burundi, _cambodia, _cameroon, _canada, _canaryIslands, _capeVerde, _caymanIslands, _centralAfricanRepublic, _ceutaAndMelilla, _chad, _chile, _china, _christmasIsland, _cocosKeelingIslands, _colombia, _comoros, _congoDemocraticPeoplesRepublic, _congoRepublicOf, _cookIslands, _costaRica, _coteDIvoire, _croatiaHrvatska, _cuba, _curacao, _cyprus, _czechRepublic, _denmark, _djibouti, _dominica, _dominicanRepublic, _eastTimor, _ecuador, _egypt, _elSalvador, _equatorialGuinea, _eritrea, _estonia, _ethiopia, _falklandIslands, _faroeIslands, _fiji, _finland, _france, _frenchGuiana, _frenchPolynesia, _frenchSouthernTerritories, _gabon, _gambia, _georgia, _germany, _ghana, _gibraltar, _greece, _greenland, _grenada, _guadeloupe, _guam, _guatemala, _guernsey, _guinea, _guineaBissau, _guyana, _haiti, _heardAndMcDonaldIslands, _holySeeCityVaticanState, _honduras, _hongKong, _hungary, _iceland, _india, _indonesia, _iranIslamicRepublicOf, _iraq, _ireland, _isleOfMan, _israel, _italy, _jamaica, _japan, _jersey, _jordan, _kazakhstan, _kenya, _kiribati, _koreaDemocraticPeoplesRepublic, _koreaRepublicOf, _kosovo, _kuwait, _kyrgyzstan, _laoPeoplesDemocraticRepublic, _latvia, _lebanon, _lesotho, _liberia, _libyanArabJamahiriya, _liechtenstein, _lithuania, _luxembourg, _macau, _macedonia, _madagascar, _malawi, _malaysia, _maldives, _mali, _malta, _marshallIslands, _martinique, _mauritania, _mauritius, _mayotte, _mexico, _micronesiaFederalStateOf, _moldovaRepublicOf, _monaco, _mongolia, _montenegro, _montserrat, _morocco, _mozambique, _myanmar, _namibia, _nauru, _nepal, _netherlands, _newCaledonia, _newZealand, _nicaragua, _niger, _nigeria, _niue, _norfolkIsland, _northernMarianaIslands, _norway, _oman, _pakistan, _palau, _palestinianTerritories, _panama, _papuaNewGuinea, _paraguay, _peru, _philippines, _pitcairnIsland, _poland, _portugal, _puertoRico, _qatar, _reunionIsland, _romania, _russianFederation, _rwanda, _saintBarthelemy, _saintHelena, _saintKittsAndNevis, _saintLucia, _saintMartin, _saintVincentAndTheGrenadines, _samoa, _sanMarino, _saoTomeAndPrincipe, _saudiArabia, _senegal, _serbia, _seychelles, _sierraLeone, _singapore, _sintMaarten, _slovakRepublic, _slovenia, _solomonIslands, _somalia, _southAfrica, _southGeorgia, _southSudan, _spain, _sriLanka, _stPierreAndMiquelon, _sudan, _suriname, _svalbardAndJanMayenIslands, _swaziland, _sweden, _switzerland, _syrianArabRepublic, _taiwan, _tajikistan, _tanzania, _thailand, _togo, _tokelau, _tonga, _trinidadAndTobago, _tunisia, _turkey, _turkmenistan, _turksAndCaicosIslands, _tuvalu, _uganda, _ukraine, _unitedArabEmirates, _unitedKingdomGB, _unitedStates, _uruguay, _uSMinorOutlyingIslands, _uzbekistan, _vanuatu, _venezuela, _vietnam, _virginIslandsBritish, _virginIslandsUSA, _wallisAndFutunaIslands, _westernSahara, _yemen, _zambia, _zimbabwe.

TransactionBillAddress_BillPhone String False

The phone number associated with the billing address for the purchase order. This is important for communication regarding payment, disputes, or billing inquiries.

TransactionBillAddress_BillState String False

The state or province of the billing address for the purchase order. This is needed for completing the full billing address and ensuring accurate invoicing.

TransactionBillAddress_BillZip String False

The zip or postal code of the billing address for the purchase order. This is essential for accurate address validation and timely delivery of invoices.

TransactionShipAddress_ShipAddr1 String False

The first line of the shipping address for the purchase order. This address is used for delivering the purchased goods or services to the recipient.

TransactionShipAddress_ShipAddr2 String False

The second line of the shipping address for the purchase order. This can include unit numbers, building names, or other additional address details.

TransactionShipAddress_ShipAddr3 String False

The third line of the shipping address for the purchase order, if necessary, capturing additional details such as floor numbers or complex identifiers.

TransactionShipAddress_ShipAddressee String False

The name of the person or entity receiving the shipment of the purchase order. This is crucial for accurate delivery and communication.

TransactionShipAddress_ShipAttention String False

The attention line of the shipping address, directing the shipment to the correct individual or department within the receiving organization.

TransactionShipAddress_ShipCity String False

The city portion of the shipping address for the purchase order. It helps identify the correct delivery area within the region.

TransactionShipAddress_ShipCountry String False

The country associated with the shipping address for the purchase order. This is necessary for international shipments and ensuring the correct shipping methods and customs regulations are applied.

The allowed values are _afghanistan, _alandIslands, _albania, _algeria, _americanSamoa, _andorra, _angola, _anguilla, _antarctica, _antiguaAndBarbuda, _argentina, _armenia, _aruba, _australia, _austria, _azerbaijan, _bahamas, _bahrain, _bangladesh, _barbados, _belarus, _belgium, _belize, _benin, _bermuda, _bhutan, _bolivia, _bonaireSaintEustatiusAndSaba, _bosniaAndHerzegovina, _botswana, _bouvetIsland, _brazil, _britishIndianOceanTerritory, _bruneiDarussalam, _bulgaria, _burkinaFaso, _burundi, _cambodia, _cameroon, _canada, _canaryIslands, _capeVerde, _caymanIslands, _centralAfricanRepublic, _ceutaAndMelilla, _chad, _chile, _china, _christmasIsland, _cocosKeelingIslands, _colombia, _comoros, _congoDemocraticPeoplesRepublic, _congoRepublicOf, _cookIslands, _costaRica, _coteDIvoire, _croatiaHrvatska, _cuba, _curacao, _cyprus, _czechRepublic, _denmark, _djibouti, _dominica, _dominicanRepublic, _eastTimor, _ecuador, _egypt, _elSalvador, _equatorialGuinea, _eritrea, _estonia, _ethiopia, _falklandIslands, _faroeIslands, _fiji, _finland, _france, _frenchGuiana, _frenchPolynesia, _frenchSouthernTerritories, _gabon, _gambia, _georgia, _germany, _ghana, _gibraltar, _greece, _greenland, _grenada, _guadeloupe, _guam, _guatemala, _guernsey, _guinea, _guineaBissau, _guyana, _haiti, _heardAndMcDonaldIslands, _holySeeCityVaticanState, _honduras, _hongKong, _hungary, _iceland, _india, _indonesia, _iranIslamicRepublicOf, _iraq, _ireland, _isleOfMan, _israel, _italy, _jamaica, _japan, _jersey, _jordan, _kazakhstan, _kenya, _kiribati, _koreaDemocraticPeoplesRepublic, _koreaRepublicOf, _kosovo, _kuwait, _kyrgyzstan, _laoPeoplesDemocraticRepublic, _latvia, _lebanon, _lesotho, _liberia, _libyanArabJamahiriya, _liechtenstein, _lithuania, _luxembourg, _macau, _macedonia, _madagascar, _malawi, _malaysia, _maldives, _mali, _malta, _marshallIslands, _martinique, _mauritania, _mauritius, _mayotte, _mexico, _micronesiaFederalStateOf, _moldovaRepublicOf, _monaco, _mongolia, _montenegro, _montserrat, _morocco, _mozambique, _myanmar, _namibia, _nauru, _nepal, _netherlands, _newCaledonia, _newZealand, _nicaragua, _niger, _nigeria, _niue, _norfolkIsland, _northernMarianaIslands, _norway, _oman, _pakistan, _palau, _palestinianTerritories, _panama, _papuaNewGuinea, _paraguay, _peru, _philippines, _pitcairnIsland, _poland, _portugal, _puertoRico, _qatar, _reunionIsland, _romania, _russianFederation, _rwanda, _saintBarthelemy, _saintHelena, _saintKittsAndNevis, _saintLucia, _saintMartin, _saintVincentAndTheGrenadines, _samoa, _sanMarino, _saoTomeAndPrincipe, _saudiArabia, _senegal, _serbia, _seychelles, _sierraLeone, _singapore, _sintMaarten, _slovakRepublic, _slovenia, _solomonIslands, _somalia, _southAfrica, _southGeorgia, _southSudan, _spain, _sriLanka, _stPierreAndMiquelon, _sudan, _suriname, _svalbardAndJanMayenIslands, _swaziland, _sweden, _switzerland, _syrianArabRepublic, _taiwan, _tajikistan, _tanzania, _thailand, _togo, _tokelau, _tonga, _trinidadAndTobago, _tunisia, _turkey, _turkmenistan, _turksAndCaicosIslands, _tuvalu, _uganda, _ukraine, _unitedArabEmirates, _unitedKingdomGB, _unitedStates, _uruguay, _uSMinorOutlyingIslands, _uzbekistan, _vanuatu, _venezuela, _vietnam, _virginIslandsBritish, _virginIslandsUSA, _wallisAndFutunaIslands, _westernSahara, _yemen, _zambia, _zimbabwe.

TransactionShipAddress_ShipIsResidential Boolean False

Indicates whether the shipping address is residential. This field can impact shipping costs or delivery options depending on the carrier.

TransactionShipAddress_ShipPhone String False

The phone number associated with the shipping address for the purchase order. This is important for tracking deliveries and for communication with the recipient.

TransactionShipAddress_ShipState String False

The state or province of the shipping address for the purchase order. This ensures the shipping details are complete and facilitates accurate delivery.

TransactionShipAddress_ShipZip String False

The zip or postal code of the shipping address for the purchase order. This is used to verify the delivery address and ensure the goods are shipped to the correct location.

VatRegNum String False

The VAT registration number for the purchase order, which is used for tax purposes in many jurisdictions. This number is required for compliance with tax regulations, particularly for cross-border transactions.

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