TransferLines

Present the DocumentLines from Document Alias

Transfer -> TransferLines

 

Entity Collections Properties

Typ

Description

Table

WTR1

Primary

DocEntry

Primary mandatory

no

GET

yes

POST

yes

UDF Support

yes (get and 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"

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

 

 

POST:

 

hmtoggle_plus1Create document (Post)

Follow fields available

 

Property

Type

GET

POST

Description

DocEntry

Number

X


Internal DocEntry Number

ItemCode

String(50)

X

X

Item Code

ItemDescription

String(100)

X

X

Item Description

IVersionId

String(20)


X

Item Version Number

Quantity

Decimal

X

X


UoMCode

String(20)

X


Stock Unit

WhsCode

String(20)

X

X

Define the Warehouse

PrjCode

String(20)

X

X

Define the Project Code

UDF1...4

String(20)


X

UDF Fields 1...4

Price

Decimal


X

Price, only if Document.PriceType="fromplandocument"

Currency

String(6)


X

Currency

ResDocEntry

Number


X

Define link to Reservation DocEntry / Line Number

On header level you must define "delReservation":true. In this case the system will update / delete all defined reservations after creation of document

 

Note: This is not the SAP Document Number. This is the Reservation.DocEntry

ResLineNumber

Number


X

Reference to Reservation LineNum

Base_Link

String(1)


X

S=SAP Link

B=beas Link (Default)

 

SAP Link

Use this, if you want to create a document to a base document

Example Delivery Note from Sales Order

In this case you define

Base_DocType=17

Base_DocEntry=RDR1.DocEntry

Base_LineNumber=RDR1.LineNum

 

BEAS Link

Use beas link, if you want to create only a reference

In Base_DocType you define the base type

wo = beas work order

17 = SAP Sales Order

13 = SAP Pre Invoice

Base_DocType

String(5)


X

Document will create from BaseType... example for Work order BoM Position
Base DocType = wo

Base_DocEntry

Number


X

Base Document DocEntry (Example RDR1.DocEntry) or Work order BEAS_FTHAUPT.BELNR_ID

Base_LineNumber

Number


X

Link to BEAS_FTPOS.BELPOS_ID or Base Document RDR1.LineNum

Base_LineNumber2

Number



Link to BEAS_FTSTL.POS_ID

Base_BaseDocument

Number


X

Base document from Base document

Base_BaseLine

Number


X

Base document from Base document

U_xxxx

Any

X

X

Define own UDF fields

CloseEntry

Boolean


x

only for receiptWo document type

if true, the system use price valuation for "last receipt" and close the work order position or Bill of Material position

 

Note:

if receipt document part of a time receipt, then it's not allowed to close the work order position in the receipt document.
Define "doNotClosePosition":true  in the receipt part:

 

TimeReceipt {
"CloseEntry":true /* Last entry. We will close time receipt and work order position */
"Receipt":{
   "doNotClosePosition":true,  /* We want to close, but on time receipt level. Don't close in receipt document  */
   "Lines":[{
    "ItemCode":"FP",
    "WhsCode":"01",
    "Quantity":2,
    "CloseEntry":true /* Close document. We need this only for price valuation */
  }]
 

PTICode

String(5)


X

Reference to table USR8/OPTI. For location Argentinia. Allow to define this on Header and line level. But the system will write this always on Header level. If you define this in more then one line, the system use PTICode always from last line.

Scrap

Number


X

External PO  to External PO Delivery: We can define the scrap.

The System save this on line level i n column u_beas_von_lag. beas2020.09

 

 

Batch- and SerialNumber Informations

Note: You can define 1 document line per Batch/Serial or you can define the Batch/Serial information separatly in

object BatchNumbers, SerialNumbers. See example

Property

Type

GET

POST

Description

DistNumber

String(32)


X

If not defined and the item / batch defintion is not "manual entry", then the system can create the Batch / Serial number automatically

 

Note: Don't use Batchnum or BatchNumber.

 

If serial number, you can define more then one Serial number

With Comma

serial-a,serial-b,serial-c ...

 

With String

The Numbering must be inside brackets: { and }

 

Example: AB{0001}C produce follow serial numbers:

AB0001C, AB0002C, AB0003C,AB004C,...AB012C ...

SystemNumber

Number


X

Internal Batch Number or Serial Number (for Issue Documents, only Serial numbers) OBTN.SysNumber Beas 2020.06

LinkedDistNumber

String(32)


X

Reference to related Serial/Batch Number

Status

String(1)


X

Status of BatchNumber (0-2) only Batch Numbers

BatchAttribut1

String


X

This field became in last year different names:

Batch attribut 1, Manufacture Serial Number, Sub Serial Number

Table: OBTN.MnfSerial Beas 2020.06

BatchAttribut2

String


X

This field became in last years different names:

Lot Number, Internal Serial Number

Table: OBTN.LotNumber Beas 2020.06

Notes

String


X

Notes, Details

AdmissionDate

DateTime


X

In Date (OBTN.InDate) Beas 2020.06

ManufacturingDate

DateTime


X

Production Date (OBTN.MnfDate) Beas 2020.06

ExpirationDate

DateTime


X

ExpirationDate (OBTN.ExpDate) Beas 2020.06

WarrantyStart

DateTime


X

Warranty Start (OSRN.GrntStart) Beas 2020.06

WarrantyEnd

DateTime


X

Warranty End (OSRN.GrntEnd) Beas 2020.06

 

BinLocation Informations

Property

Type

GET

POST

Description

BinCode

String(20)


X

Bin Code

RFID

String(20)


X

RFID Number

 

Information for POST Commands

In this Object you can define BatchNumbers, SerialNumbers and BinLocations in one line

The System make automatically a grouping by ItemCode/WareHouse and allocate all BatchNumbers, SerialNumbers and Locations

But you can use Property BatchNumbers or SerialNumbers or BinLocations to define this separtly

 

 

Example

{"ItemCode":"A001"
"BatchNumbers": [

  {"DistNumber": "O0033", "Quantity":10},

   {"DistNumber": "O0023", "Quantity":5}
   ]

}

 

Beas create a line for ItemCode A001 and insert DistNumber O0033
After this it will copy the line and insert the Information from Second BatchNumbers

You can define all Batch- or Serial- or BinLocation information in the SubObject. It simulate only this subobject, which is in reality not existing.

Attention: Please insert always Quantity 1, if you working with Serial numbers

 

UDF Fields

UDF fields supported on line level. No support on Batch Level or Bin location Level (beas 9.3 PL 3)

It's not allowed to use Tab (char 9) inside the UDF value.

 

beasscript-logo-small
instance bsl b
#define ls_json
{"DocumentLines":
[ {"ItemCode":"1111","Quantity":2, "WhsCode":"01","U_Waste":5}]}
#end
b.post=Issue=<ls_json>
messagebox=<b.ret_code> <b.ret_text> <b.ret_value>
destroy=b

 

 

 

 

Additional fields for Transfer Lines

ToWareHouse

string(20)


X

Transfer object: Target WareHouse

ToBinCode

string(20)


X

Transfer object: Target BinCode

ToRfid

string(20)


X

Transfer object: Target Rfid