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 |