API Data Provider - Online Help

PurchaseOrderDetails

Returns details of a purchase order.

Columns

Name Type References
OrganizationId Long

Organizations.OrganizationId

PurchaseOrderId [KEY] Long

PurchaseOrders.PurchaseOrderId

PurchaseorderNumber String
Status String
Adjustment Double
AdjustmentDescription String
ApproverId String
ApproversList String
AttachmentName String
Attention String
BilledStatus String
Bills String
CanMarkAsBill Boolean
CanMarkAsUnbill Boolean
CanSendInMail Boolean
ClientViewedTime String
ColorCode String
ContactCategory String
ContactPersons String
CreatedById String
CreatedTime Datetime
CurrencyCode String
CurrencyId String
CurrencySymbol String
CurrentSubStatus String
CurrentSubStatusId String
CustomFields String
Date Date
DeliveryAddressAddress String
DeliveryAddressAddress1 String
DeliveryAddressAddress2 String
DeliveryAddressCity String
DeliveryAddressCountry String
DeliveryAddressEmail String
DeliveryAddressIsPrimary Boolean
DeliveryAddressIsValid Boolean
DeliveryAddressIsVerifiable Boolean
DeliveryAddressIsVerified Boolean
DeliveryAddressOrganizationAddressId String
DeliveryAddressPhone String
DeliveryAddressState String
DeliveryAddressZip String
DeliveryCustomerAddressId String
DeliveryCustomerId String
DeliveryDate String
DeliveryOrgAddressId String
Discount Double
DiscountAccountId String
DiscountAmount Double
DiscountAppliedOnAmount Double
DiscountType String
Documents String
ExchangeRate Double
ExpectedDeliveryDate String
HasQtyCancelled Boolean
IsAdvTrackingInReceive Boolean
IsBackorder Boolean
IsDiscountBeforeTax Boolean
IsDropShipment Boolean
IsEmailed Boolean
IsInclusiveTax Boolean
IsViewedByClient Boolean
LastModifiedTime Datetime
LineItems String
Notes String
OrderStatus String
Orientation String
PageHeight String
PageWidth String
PaymentTerms Integer
PaymentTermsLabel String
PricePrecision Integer
Purchasereceives String
ReceivedStatus String
ReferenceNumber String
SalesorderId String
Salesorders String
ShipVia String
ShipViaId String
SubStatuses String
SubTotal Double
SubTotalInclusiveOfTax Double
SubmittedBy String
SubmittedDate String
SubmitterId String
TaxRounding String
TaxTotal Double
Taxes String
TemplateId String
TemplateName String
TemplateType String
Terms String
Total Double
TotalQuantity Double
VendorId String
VendorName String
BillingAddressId String
BillingAddressAddress String
BillingAddressAttention String
BillingAddressCity String
BillingAddressCountry String
BillingAddressFax String
BillingAddressPhone String
BillingAddressState String
BillingAddressStreet2 String
BillingAddressZip String

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839.0