SalesDeliveryLines

Present the DocumentLines from Document Alias

SalesDelivery -> SalesDeliveryLine

 

Entity Collections Properties

Typ

Description

Table

DLN1

Primary

DocEntry

Primary mandatory

no

GET

yes

POST

no

UDF Support

yes (get and post)

 

SalesDeliveryLines

 

Property

Description

Table

DLN1

Primary key

DocEntry/i,LineNum/i

$transaction

no

$branch

no

$mask

no

 

Fields

Name

Type

Description

DocEntry

Edm.Int32

Database: "DLN1"."DocEntry"

LineNum

Edm.Int32

Database: "DLN1"."LineNum"

LineStatus

Edm.String(1)

Database: "DLN1"."LineStatus"

LineType

Edm.Int32

Database: "DLN1"."LineType"

LineType

Edm.Int32

Database: "DLN1"."LineType"

VisualOrder

Edm.Int32

Database: "DLN1"."VisOrder"

ItemCode

Edm.String(50)

Entity Relation: Item -> ItemCode

Database: "DLN1"."ItemCode"

ItemDescription

Edm.String(100)

Database: "DLN1"."Dscription"

ItemDetails

Edm.String(16000)

Database: "DLN1"."Text"

OpenQty

Edm.Decimal

Database: "DLN1"."OpenQty"

Quantity

Edm.Decimal

Database: "DLN1"."Quantity"

UoMCode

Edm.String(20)

Entity Relation: UoM -> UoMCode

Database: "DLN1"."unitMsr"

QuantityPerStockUnit

Edm.String(20)

Database: case when coalesce("DLN1"."NumPerMsr",0)=0 then 1 else "DLN1"."NumPerMsr" end

WhsCode

Edm.String(20)

Entity Relation: WareHouse -> WhsCode

Database: "DLN1"."WhsCode"

ShipDate

Edm.String

Database: "DLN1"."ShipDate"

BarCode

Edm.String(16)

Database: "DLN1"."CodeBars"

BaseType

Edm.String(10)

Database: "DLN1"."BaseType"

BaseEntry

Edm.Int32

Database: "DLN1"."BaseEntry"

BaseLine

Edm.Int32

Database: "DLN1"."BaseLine"

BaseOpenQuantity

Edm.Decimal

Database: "DLN1"."BaseOpnQty"

WorkOrderNumber

Edm.Int32

Database: "DLN1"."U_belnrid"

WorkOrderPosition

Edm.Int32

Database: "DLN1"."U_belposid"

WorkOrderBoM

Edm.Int32

Database: "DLN1"."U_posid"

PrjCode

Edm.String(20)

Database: "DLN1"."Project"

 

Relations

Join to Entiy Object

Relation

Item

ItemCode

UoM

UoMCode

WareHouse

WhsCode