JDBC Driver for Exact Online

Build 22.0.8462

PurchaseOrders

Usage information for the operation PurchaseOrders.rsd.

Columns

Name Type Description
PurchaseOrderID [KEY] String The PurchaseOrderID column for the table PurchaseOrders.
AmountDC Double The AmountDC column for the table PurchaseOrders.
AmountFC Double The AmountFC column for the table PurchaseOrders.
Created Datetime The Created column for the table PurchaseOrders.
Creator String The Creator column for the table PurchaseOrders.
CreatorFullName String The CreatorFullName column for the table PurchaseOrders.
Currency String The Currency column for the table PurchaseOrders.
DeliveryAccount String The DeliveryAccount column for the table PurchaseOrders.
DeliveryAccountCode String The DeliveryAccountCode column for the table PurchaseOrders.
DeliveryAccountName String The DeliveryAccountName column for the table PurchaseOrders.
DeliveryAddress String The DeliveryAddress column for the table PurchaseOrders.
DeliveryContact String The DeliveryContact column for the table PurchaseOrders.
DeliveryContactPersonFullName String The DeliveryContactPersonFullName column for the table PurchaseOrders.
Description String The Description column for the table PurchaseOrders.
Division Int The Division column for the table PurchaseOrders.
Document String The Document column for the table PurchaseOrders.
DocumentSubject String The DocumentSubject column for the table PurchaseOrders.
DropShipment Bool The DropShipment column for the table PurchaseOrders.
ExchangeRate Double The ExchangeRate column for the table PurchaseOrders.
InvoiceStatus Int The InvoiceStatus column for the table PurchaseOrders.
Modified Datetime The Modified column for the table PurchaseOrders.
Modifier String The Modifier column for the table PurchaseOrders.
ModifierFullName String The ModifierFullName column for the table PurchaseOrders.
OrderDate Datetime The OrderDate column for the table PurchaseOrders.
OrderNumber Int The OrderNumber column for the table PurchaseOrders.
OrderStatus Int The OrderStatus column for the table PurchaseOrders.
PaymentCondition String The PaymentCondition column for the table PurchaseOrders.
PaymentConditionDescription String The PaymentConditionDescription column for the table PurchaseOrders.
PurchaseAgent String The PurchaseAgent column for the table PurchaseOrders.
PurchaseAgentFullName String The PurchaseAgentFullName column for the table PurchaseOrders.
ReceiptDate Datetime The ReceiptDate column for the table PurchaseOrders.
ReceiptStatus Int The ReceiptStatus column for the table PurchaseOrders.
Remarks String The Remarks column for the table PurchaseOrders.
SalesOrder String The SalesOrder column for the table PurchaseOrders.
SalesOrderNumber Int The SalesOrderNumber column for the table PurchaseOrders.
ShippingMethod String The ShippingMethod column for the table PurchaseOrders.
ShippingMethodDescription String The ShippingMethodDescription column for the table PurchaseOrders.
Source Int The Source column for the table PurchaseOrders.
Supplier String The Supplier column for the table PurchaseOrders.
SupplierCode String The SupplierCode column for the table PurchaseOrders.
SupplierContact String The SupplierContact column for the table PurchaseOrders.
SupplierContactPersonFullName String The SupplierContactPersonFullName column for the table PurchaseOrders.
SupplierName String The SupplierName column for the table PurchaseOrders.
VATAmount Double The VATAmount column for the table PurchaseOrders.
Warehouse String The Warehouse column for the table PurchaseOrders.
WarehouseCode String The WarehouseCode column for the table PurchaseOrders.
WarehouseDescription String The WarehouseDescription column for the table PurchaseOrders.
YourRef String The YourRef column for the table PurchaseOrders.
LinkedPurchaseOrderLines String The LinkedPurchaseOrderLines column for the table PurchaseOrders.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462