NetSuiteSalesOrders
NetSuite sales order approval requests for the specified company.
Columns
| Name | Type | References | |
| RequestId [KEY] | String | ||
| CompanyId | String |
Companies.CompanyId | |
| InternalId | String | ||
| Reference | String | ||
| FriendlyName | String | ||
| RequestStatus | String | ||
| ApprovalStatusName | String | ||
| StatusName | String | ||
| Origin | String | ||
| CurrencyCode | String | ||
| ExchangeRate | Double | ||
| DocumentExchangeRate | Double | ||
| Total | Double | ||
| Subtotal | Double | ||
| TotalAmount | Double | ||
| TotalTaxAmount | Double | ||
| TotalTaxAmount2 | Double | ||
| DiscountTotal | Double | ||
| DiscountRate | Double | ||
| IsDiscountRateAbsolute | Boolean | ||
| IsExcludeCommissions | Boolean | ||
| VatRegistrationNumber | String | ||
| CreditCardNumber | String | ||
| CreditCardCardholderName | String | ||
| CreditCardStreet | String | ||
| CreditCardZipCode | String | ||
| IsCreditCardApproved | Boolean | ||
| CreditCardExpirationDate | Datetime | ||
| PnRef | String | ||
| AuthorizationCode | String | ||
| AvsStreetMatch | String | ||
| AvsZipMatch | String | ||
| RevenueStatus | String | ||
| RecognizedRevenue | Double | ||
| DeferredRevenue | Double | ||
| Memo | String | ||
| Version | Integer | ||
| TransactionDate | Datetime | ||
| SalesEffectiveDate | Datetime | ||
| StartDate | Datetime | ||
| EndDate | Datetime | ||
| ShipDate | Datetime | ||
| CreatedAt | Datetime | ||
| ModifiedAt | Datetime | ||
| DecisionDate | Datetime | ||
| CreatedDate | Datetime | ||
| ModifiedDate | Datetime | ||
| Customer | String | ||
| SalesRep | String | ||
| Opportunity | String | ||
| Partner | String | ||
| Class | String | ||
| Location | String | ||
| Department | String | ||
| Currency | String | ||
| DiscountItem | String | ||
| BillingAddress | String | ||
| Terms | String | ||
| ShipMethod | String | ||
| ShipAddress | String | ||
| BillingSchedule | String | ||
| PaymentMethod | String | ||
| CreditCardProcessor | String | ||
| ItemLines | String | ||
| CustomFields | String | ||
| Attachments | String | ||
| Events | String |