NameDescriptionTypeAdditional information
Identifier

Collection of byte

None.

IdentifierGuid

globally unique identifier

None.

StoreID

integer

None.

TradingPartner

InvoiceTradingPartner

None.

SupplierIdentifier

Collection of byte

None.

SupplierIdentifierGuid

globally unique identifier

None.

Xfer

True if stock transfer

boolean

None.

SourceStore

string

None.

SourceCode

string

None.

SourceAbn

string

None.

TargetCode

string

None.

TargetState

string

None.

WhouseRef

string

None.

StateSource

string

None.

Status

InvoiceStatus

None.

FileID

string

String length: inclusive between 0 and 255

Created

Time invoice was created

date

None.

CreatedByUser

User who created in invoice

string

None.

Updated

date

None.

TransType

InvoiceType

None.

TransDateTime

date

None.

InvoiceNo

Invoice number

string

None.

InvoiceText

string

String length: inclusive between 0 and 40

AdjustmentNo

integer

None.

InvoiceDate

date

None.

ClaimNo

integer

None.

CountReceivedReset

Invoice received counts have been reset

boolean

None.

AccountingExported

Invoice has been exported by accounting services

boolean

None.

OrderReceived

The order has already received the inventory

boolean

None.

OrderGuid

Collection of byte

None.

OrderIdentifier

Order identifier of the order attached to this invoice

globally unique identifier

None.

OrderNo

Order number in emc system

integer

None.

OrderText

string

None.

SupplierNotes

string

None.

DefaultStockReceiveDocumentId

integer

None.

ReceiptEmailSent

boolean

None.

ReceiptEmailSentId

string

String length: inclusive between 0 and 100

ReceiptEmailSentStatus

string

String length: inclusive between 0 and 20

CustomerCd

string

None.

StoreName

string

None.

Street

string

None.

Suburb

string

None.

PostCd

string

None.

DebtorCd

string

None.

LiquorLicense

string

None.

Bond

string

None.

Url

string

None.

Completed

Time invoice was completed

date

None.

Received

Time invoice was received into system

date

None.

InvoiceSubTotal

Invoice total excluding fees

decimal number

None.

ItemTotalCost

decimal number

None.

AdminFee

decimal number

None.

FinanceFee

decimal number

None.

InvoiceTotal

decimal number

None.

Weight

decimal number

None.

SalesTax

decimal number

None.

TobaccoTax

decimal number

None.

ShrinkWrap

decimal number

None.

GstTotal

decimal number

None.

Margin

decimal number

None.

DeliveryFee

Invoiced delivery fee, gst inclusive, exported to accounting services

decimal number

None.

TransportFee

Delivery or freight fee not included in invoice, will be ignored in accounting

decimal number

None.

ServiceFee

decimal number

None.

GstOnService

decimal number

None.

GstOnDelivery

decimal number

None.

GstOnShrinkWrap

decimal number

None.

WetTotal

decimal number

None.

GstApplicable

decimal number

None.

GstExempt

decimal number

None.

SupplierMatchRequired

Temporary supplier, invoice requires a supplier match before it can be completed

boolean

None.

Temperature

Temperature recorded of order on receive. Null indicates no temperature recorded

decimal number

None.

TemperatureScale

Temperature scale that temperature is recorded in

TemperatureScale

None.

Rating

Quality rating of the order

integer

None.

CompleteInvoiceInventory

Complete invoice setting used during invoice complete

UpdateInventory

None.

WineLitres

decimal number

None.

WineValue

decimal number

None.

SpiritLitres

decimal number

None.

SpiritValue

decimal number

None.

BeerLitres

decimal number

None.

BeerValue

decimal number

None.

MidBeerLitres

decimal number

None.

MidBeerValue

decimal number

None.

LowBeerLitres

decimal number

None.

LowBeerValue

decimal number

None.

LowWineLitres

decimal number

None.

LowWineValue

decimal number

None.

Deleted

boolean

None.

SupplierName

string

Relation. This field may not always be loaded or used for updates.

InvoiceSuffix

string

Relation. This field may not always be loaded or used for updates.

CostVariance

decimal number

Relation. This field may not always be loaded or used for updates.

Store

Store

Relation. This field may not always be loaded or used for updates.

Supplier

Supplier

Relation. This field may not always be loaded or used for updates.

Order

OrderHeader

Relation. This field may not always be loaded or used for updates.

Details

Collection of InvoiceDetail

Relation. This field may not always be loaded or used for updates.

OrderStatus

integer

Relation. This field may not always be loaded or used for updates.

ProcessLockedInvoice

option to process the locked invoice

boolean

Relation. This field may not always be loaded or used for updates.