POST

ReceiptLines

 

Property

Description

Table

IGN1

Primary key

DocEntry/i,LineNum/i

$transaction

no

$branch

no

$mask

no

 

Fields

Name

Type

Description

DocEntry

Edm.Int32

Database: "IGN1"."DocEntry"

LineNum

Edm.Int32

Database: "IGN1"."LineNum"

LineStatus

Edm.String(1)

Database: "IGN1"."LineStatus"

LineType

Edm.Int32

Database: "IGN1"."LineType"

VisualOrder

Edm.Int32

Database: "IGN1"."VisOrder"

ItemCode

Edm.String(50)

Entity Relation: Item -> ItemCode

Database: "IGN1"."ItemCode"

ItemDescription

Edm.String(100)

Database: "IGN1"."Dscription"

ItemDetails

Edm.String(16000)

Database: "IGN1"."Text"

OpenQty

Edm.Decimal

Database: "IGN1"."OpenQty"

Quantity

Edm.Decimal

Database: "IGN1"."Quantity"

UoMCode

Edm.String(20)

Entity Relation: UoM -> UoMCode

Database: "IGN1"."unitMsr"

QuantityPerStockUnit

Edm.String(20)

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

WhsCode

Edm.String(20)

Entity Relation: WareHouse -> WhsCode

Database: "IGN1"."WhsCode"

ShipDate

Edm.String

Database: "IGN1"."ShipDate"

BarCode

Edm.String(16)

Database: "IGN1"."CodeBars"

BaseType

Edm.String(10)

Database: "IGN1"."BaseType"

BaseEntry

Edm.Int32

Database: "IGN1"."BaseEntry"

BaseLine

Edm.Int32

Database: "IGN1"."BaseLine"

BaseOpenQuantity

Edm.Decimal

Database: "IGN1"."BaseOpnQty"

WorkOrderNumber

Edm.Int32

Database: "IGN1"."U_belnrid"

WorkOrderPosition

Edm.Int32

Database: "IGN1"."U_belposid"

WorkOrderBoM

Edm.Int32

Database: "IGN1"."U_posid"

PrjCode

Edm.String(20)

Database: "IGN1"."Project"

 

Relations

Join to Entiy Object

Relation

Item

ItemCode

UoM

UoMCode

WareHouse

WhsCode

Enter topic text here.