DocumentTypeKey

SalesDocumentTypeKey

N/A

N/A

The sales document type key object that uniquely identifies the document type ID of the sales document.

Key

SalesDocumentKey

N/A

N/A

The sales document key object that uniquely identifies a sales document.

MasterNumber

int

N/A

0

The master number of the sales document. The value 0 indicates master numbers are not being tracked.

CustomerKey

CustomerKey

N/A

N/A

The customer key object that uniquely identifies the customer on the sales document

CustomerPONumber

string

20

N/A

The customer's purchase order number for the sales document.

CustomerName

string

64

N/A

The full name of the customer on the sales document.

SalespersonKey

SalespersonKey

N/A

N/A

The salesperson key object that uniquely identifies the salesperson for the sales document.

Date

dateTime

N/A

N/A

The date of the sales document.

CurrencyKey

CurrencyKey

N/A

N/A

The currency key object that uniquely identifies the currency for the sales document.

LineTotalAmount

MoneyAmount

N/A

N/A

The subtotal amount of the sales document.

TradeDiscountAmount

MoneyAmount

N/A

N/A

The trade discount amount on the sales document.

FreightAmount

MoneyAmount

N/A

N/A

The total freight amount for the sales document.

MiscellaneousAmount

MoneyAmount

N/A

N/A

The total miscellaneous amount for the sales document.

TaxAmount

MoneyAmount

N/A

N/A

The total tax amount for the sales document.

TotalAmount

MoneyAmount

N/A

N/A

The total document amount.

CreatedDate

dateTime

N/A

N/A

The date the sales document was created.

ModifiedDate

dateTime

N/A

Set to the system date.

The date the sales document was last modified. The value is in Coordinated Universal Time (UTC).

LastModifiedDate

dateTime

N/A

Set to the system date.

The date the sales document was last modified. The value is in Coordinated Universal Time (UTC).

TransactionState

SalesTransactionState

N/A

N/A

Indicates whether the sales document was retrieved from the open table or the history table.

BatchKey

BatchKey

N/A

N/A

The batch the sales document is included in.