Skip to main content

CustomerDocumentLine

CustomerDocumentLines. Lines belonging to a CustomerDocument (ARInvoice / CreditMemo / etc).

type CustomerDocumentLine {
  lineNumber: Int!
  refNbr: String!
  tranType: String!
  drTermStartDate: DateTime
  drTermEndDate: DateTime
  isRotRutDeductible: Boolean!
  rotRutItemType: String
  rotRutType: String
  rotRutTypeOfWorkDescription: String
  rotRutXmlTag: String
  rotRutDeductibleAmount: Decimal!
  inventoryId: Int
  description: String
  quantity: Decimal
  unitPrice: Decimal!
  unitPriceInCurrency: Decimal!
  amount: Decimal
  amountInCurrency: Decimal
  cost: Decimal!
  accountNumber: Int!
  vatCodeId: String
  uom: String
  discountPercent: Decimal
  discountAmount: Decimal
  discountAmountInCurrency: Decimal
  manualDiscount: Boolean
  subAccountId: Int!
  salesPersonId: Int
  deferralScheduleId: Int
  deferralCode: String
  discountCodeId: String
  note: String
  soShipmentNumber: String
  soOrderType: String
  soOrderNumber: String
  companyId: Int!
  id: String!
  createdInDataMartDateTime: DateTime!
  updatedInDataMartDateTime: DateTime!
}

Fields​

CustomerDocumentLine.lineNumber ● Int! non-null scalar​

lineNumber > (PK) The line number within the customer document.

CustomerDocumentLine.refNbr ● String! non-null scalar​

refNbr > (PK) The reference number of the customer document line.

CustomerDocumentLine.tranType ● String! non-null scalar​

tranType > (PK) The transaction type of the customer document line.

CustomerDocumentLine.drTermStartDate ● DateTime scalar​

drTermStartDate > The start date of the deferral/revenue recognition term.

CustomerDocumentLine.drTermEndDate ● DateTime scalar​

drTermEndDate > The end date of the deferral/revenue recognition term.

CustomerDocumentLine.isRotRutDeductible ● Boolean! non-null scalar​

isRotRutDeductible > Indicates if the line is ROT/RUT deductible (Sweden specific).

CustomerDocumentLine.rotRutItemType ● String scalar​

rotrutItemType > The ROT/RUT item type.

CustomerDocumentLine.rotRutType ● String scalar​

rotRutType > The ROT/RUT type.

CustomerDocumentLine.rotRutTypeOfWorkDescription ● String scalar​

rotRutTypeOfWorkDescription > Description of the type of work for ROT/RUT.

CustomerDocumentLine.rotRutXmlTag ● String scalar​

rotRutXmlTag > XML tag used for ROT/RUT export.

CustomerDocumentLine.rotRutDeductibleAmount ● Decimal! non-null scalar​

rotRutDeductibleAmount > ROT/RUT deductible amount.

CustomerDocumentLine.inventoryId ● Int scalar​

inventoryId > The inventory identifier.

CustomerDocumentLine.description ● String scalar​

description > The line description.

CustomerDocumentLine.quantity ● Decimal scalar​

quantity > The quantity of the item or service.

CustomerDocumentLine.unitPrice ● Decimal! non-null scalar​

unitPrice > The unit price in base currency.

CustomerDocumentLine.unitPriceInCurrency ● Decimal! non-null scalar​

unitPriceInCurrency > The unit price in the document currency.

CustomerDocumentLine.amount ● Decimal scalar​

amount > The extended line amount in base currency (Qty * UnitPrice).

CustomerDocumentLine.amountInCurrency ● Decimal scalar​

amountInCurrency > The extended line amount in document currency.

CustomerDocumentLine.cost ● Decimal! non-null scalar​

cost > The cost associated with the line (base currency).

CustomerDocumentLine.accountNumber ● Int! non-null scalar​

accountNumber > The financial account number.

CustomerDocumentLine.vatCodeId ● String scalar​

vatCodeId > The VAT code applied to the line.

CustomerDocumentLine.uom ● String scalar​

uom > The unit of measure.

CustomerDocumentLine.discountPercent ● Decimal scalar​

discountPercent > The discount percent applied to the line.

CustomerDocumentLine.discountAmount ● Decimal scalar​

discountAmount > The discount amount in base currency.

CustomerDocumentLine.discountAmountInCurrency ● Decimal scalar​

discountAmountInCurrency > The discount amount in document currency.

CustomerDocumentLine.manualDiscount ● Boolean scalar​

manualDiscount > Indicates if the discount was manually entered.

CustomerDocumentLine.subAccountId ● Int! non-null scalar​

subAccountId > The subaccount identifier.

CustomerDocumentLine.salesPersonId ● Int scalar​

salesPersonId > The salesperson identifier.

CustomerDocumentLine.deferralScheduleId ● Int scalar​

deferralScheduleId > The deferral schedule identifier.

CustomerDocumentLine.deferralCode ● String scalar​

deferralCode > The deferral code.

CustomerDocumentLine.discountCodeId ● String scalar​

discountCodeId > The discount code applied to the line.

CustomerDocumentLine.note ● String scalar​

note > The note text attached to the line.

CustomerDocumentLine.soShipmentNumber ● String scalar​

soShipmentNumber > Related shipment number (if originating from SO).

CustomerDocumentLine.soOrderType ● String scalar​

soOrderType > Related sales order type (if originating from SO).

CustomerDocumentLine.soOrderNumber ● String scalar​

soOrderNumber > Related sales order number (if originating from SO).

CustomerDocumentLine.companyId ● Int! non-null scalar​

companyId > (PK) The unique identifier of the company

CustomerDocumentLine.id ● String! non-null scalar​

id > The unique identifier of the document in DataMart

CustomerDocumentLine.createdInDataMartDateTime ● DateTime! non-null scalar​

createdInDataMartDateTime > The UTC DateTime when this document has been added to DataMart

CustomerDocumentLine.updatedInDataMartDateTime ● DateTime! non-null scalar​

updatedInDataMartDateTime > The UTC DateTime when this document has been updated in DataMart

Returned By​

customerDocumentLines query