Table of Contents
Subtables: #
FIELD NAME | DATA TYPE | QUERYABLE | UPDATEABLE | REQUIRED ON UPDATE | INSERTABLE | REQUIRED ON INSERT |
Id | Guid | true | ||||
SyncToken | string | true | ||||
CreateTime | DateTime | true | ||||
LastUpdatedTime | DateTime | true | ||||
sparse | bool | true | ||||
Name | string | true | ||||
TxnDate | DateTime | true | ||||
DocNumber | string | true | ||||
DepartmentRef_Id | string | true | ||||
DepartmentRef_Name | string | true | ||||
CurrencyRef_Id | string | true | ||||
CurrencyRef_Name | string | true | ||||
PrivateNote | string | true | ||||
TxnStatus | string | true | ||||
ExchangeRate | decimal | true | ||||
ExchangeRateSpecified | bool | true | ||||
TransactionLocationType | string | true | ||||
PrintStatus | string | true | ||||
PrintStatusSpecified | bool | true | ||||
EmailStatus | string | true | ||||
EmailStatusSpecified | bool | true | ||||
BillEmailAddress | string | true | ||||
DeliveryType | string | true | ||||
DeliveryTypeSpecified | bool | true | ||||
DeliveryTime | DateTime | true | ||||
DeliveryTimeSpecified | bool | true | ||||
DeliveryErrorType | string | true | ||||
DeliveryErrorTypeSpecified | bool | true | ||||
ApplyTaxAfterDiscount | bool | true | ||||
ApplyTaxAfterDiscountSpecified | bool | true | ||||
CustomerRef_Id | string | true | ||||
CustomerRef_Name | string | true | ||||
CustomerMemo | string | true | ||||
FreeFormAddress | bool | true | ||||
FreeFormAddressSpecified | bool | true | ||||
ClassRef_Id | string | true | ||||
ClassRef_Name | string | true | ||||
SalesTermRef_Id | string | true | ||||
SalesTermRef_Name | string | true | ||||
DueDate | DateTime | true | ||||
DueDateSpecified | bool | true | ||||
ShipMethodRef_Id | string | true | ||||
ShipMethodRef_Name | string | true | ||||
ShipDate | DateTime | true | ||||
ShipDateSpecified | bool | true | ||||
GlobalTaxCalculation | string | true | ||||
GlobalTaxCalculationSpecified | bool | true | ||||
TotalAmt | decimal | true | ||||
TotalAmtSpecified | bool | true | ||||
HomeTotalAmt | decimal | true | ||||
HomeTotalAmtSpecified | bool | true | ||||
TaxExemptionRef_Id | string | true | ||||
TaxExemptionRef_Name | string | true | ||||
ExpirationDate | DateTime | true | ||||
ExpirationDateSpecified | bool | true | ||||
AcceptedBy | string | true | ||||
AcceptedDate | DateTime | true | ||||
AcceptedDateSpecified | bool | true | ||||
TotalTax | decimal | true | ||||
TotalTaxSpecified | bool | true | ||||
TxnTaxCodeRef_Id | string | true | ||||
TxnTaxCodeRef_Name | string | true | ||||
DefaultTaxCodeRef_Id | string | true | ||||
DefaultTaxCodeRef_Name | string | true | ||||
BillAddr_Id | string | true | ||||
BillAddr_Line1 | string | true | ||||
BillAddr_Line2 | string | true | ||||
BillAddr_Line3 | string | true | ||||
BillAddr_Line4 | string | true | ||||
BillAddr_Line5 | string | true | ||||
BillAddr_City | string | true | ||||
BillAddr_Country | string | true | ||||
BillAddr_PostalCode | string | true | ||||
BillAddr_CountryCode | string | true | ||||
BillAddr_CountrySubDivisionCode | string | true | ||||
BillAddr_PostalCodeSuffix | string | true | ||||
BillAddr_Long | string | true | ||||
BillAddr_Lat | string | true | ||||
BillAddr_Note | string | true | ||||
BillAddr_Tag | string | true | ||||
ShipFromAddr_Id | string | true | ||||
ShipFromAddr_Line1 | string | true | ||||
ShipFromAddr_Line2 | string | true | ||||
ShipFromAddr_Line3 | string | true | ||||
ShipFromAddr_Line4 | string | true | ||||
ShipFromAddr_Line5 | string | true | ||||
ShipFromAddr_City | string | true | ||||
ShipFromAddr_Country | string | true | ||||
ShipFromAddr_PostalCode | string | true | ||||
ShipFromAddr_CountryCode | string | true | ||||
ShipFromAddr_CountrySubDivisionCode | string | true | ||||
ShipFromAddr_PostalCodeSuffix | string | true | ||||
ShipFromAddr_Long | string | true | ||||
ShipFromAddr_Lat | string | true | ||||
ShipFromAddr_Note | string | true | ||||
ShipFromAddr_Tag | string | true | ||||
ShipAddr_Id | string | true | ||||
ShipAddr_Line1 | string | true | ||||
ShipAddr_Line2 | string | true | ||||
ShipAddr_Line3 | string | true | ||||
ShipAddr_Line4 | string | true | ||||
ShipAddr_Line5 | string | true | ||||
ShipAddr_City | string | true | ||||
ShipAddr_Country | string | true | ||||
ShipAddr_PostalCode | string | true | ||||
ShipAddr_CountryCode | string | true | ||||
ShipAddr_CountrySubDivisionCode | string | true | ||||
ShipAddr_PostalCodeSuffix | string | true | ||||
ShipAddr_Long | string | true | ||||
ShipAddr_Lat | string | true | ||||
ShipAddr_Note | string | true | ||||
ShipAddr_Tag | string | true | ||||
CustomField1 | string | true | ||||
CustomField2 | string | true | ||||
CustomField3 | string | true | ||||
CustomField4 | string | true | ||||
CustomField5 | string | true | ||||
CustomField6 | string | true | ||||
CustomField7 | string | true | ||||
CustomField8 | string | true | ||||
CustomField9 | string | true | ||||
CustomField10 | string | true | ||||
UserData | string | true | ||||
Operation | string | true | ||||
LSData | string | true |