planned

object=ue_reservation=planned=<command>=property

 

Concept of planned Document:

 

1. Create a Document with type (issue, transfer and so on)

2. Insert lines per Batchnum/Warehouse

3. Create the issue, transfer and so on

 

Table: beas_plandocument, beas_plandocument_line

 

You can create the planned Document from Reservation or other

 

new=<doctype>

Create new planned Document

set docentry, doctype and lifetime before new

Example:

declare=res=ue_reservation

res=planned=ref2=WO201

res=planned=comments=Issue for Workorder

res=planned=doctype=issue

res=planned=new

res=planned=addline=<..>

docdate=<date>

set the planned document-date. Set this argument first (first docdate, then new)

ref2

set the ref2 for the document. Set this argument first (first ref2, then new)

comments

set the comments for the document. Set this argument first (first comments, then new)

docentry=<pdocentry>

set the current docentry (example if you reopen the object and lost the instance ec WEBAPPS-Developement)

set this bevor you set "new"

doctype=<pdoctype>

set the current doctype

livetime

set livetime - Propertie (set before you set "new")

addline=<properties>

set line to the current planned document (only datastore, not database), delimited with tab

example:itemcode=xxx<char 9>quantity=5<tab> ...

with parameter "save" you create the database-update directly

updateline

save the added lines to database

delete

delete current plan-document

addfromreservation=<filter>

load List from reservation

declare=res=ue_reservation

res=planned=new=issue

res=planned=addfromreservation=beas_reservation_line.base_type='wo' and beas_reservation_line.base_docentry=48

res=issuewo



 

 

doctype

issuewo

Workorder-Issue

btransfer

Batchnum-Transfer (ue_reservation.transfer_batch)

 

AddLine-Properties

res_docentry

docentry reservation-Line

 

res_linenum

linenum of reservation-Line

base_doctype

the base-document, example: wo for Workorder

17 = customer order

wo = work order

 

Purchase

13 = Purchase Reserve Invoice

22 = Purchase Order

540000006 = Purchase Quotation

base_docentry

the base-docentry, example: the beas_fthaupt.belnr_id

base_linenum

the base-linenum, example: the beas_ftpos.belpos_id, customer-order: 0

base_linenum2

the base-linenum2, example: the beas_ftstl.pos_id, customer-order: rdr1.linenum

set_quantity

the Qty to book

quantity

the issue-Quantity

itemcode

itemcode

whscode

warehouse

batchnum, distnumber

the batchnumber or serial-internal-Number

if a receipt-function

then the serial-number or serial/batchnumber, comma-separated or with " &#44; " max 1024 Sign
or empty for automatic-generation

 

status

Status Batchnumber (only for receipt)

mnfserial

Batch Attribut 1 (only for receipt)

lotnumber

Batch Attribut 2 (only for receipt)

indate

Admission Date (only for receipt)

mnfdate

Manufacturing Date (only for receipt)

expdate

Expiry date (only for receipt)

details, notes

Batchnum - Notes (varchar 255):  (only for receipt)

bincode

the bincode or osri.sysserial as string

rfid

rfid

linenum


linetype

type of line

udf1 ... udf4

UDF1 to UDF4

price


currency


save

save the line.

ATTENTION: If you add more then one line, then don't use this propertie!

Add All Lines and after then use "planned=updateline". This is faster

Batch-Properties

generate more entries in one step ...

totalqty

total quantity. beas make entrys with quantity while sum of quantity <= totalqty

counterlen

Length of counter

format

Format for batch/distnumber. Placeholder for counter: {counter]

Example: format=ABC-{counter}

This string is the new batch number / distnumber

counterstart

Begin of Counter

 

 

 

Example Generate Line for 100 Serialnumbers

declare=res=ue_reservation

res=planned=new=incommingpo

res=planned=addline=itemcode=A0002<tab>whscode=01<tab>&

 base_docentry=<5><tab>base_linenum=<1><tab>base_doctype=22<tab>&

 quantity=1<tab>&

 linetype=incommingpo<tab>&

 totalqty=100<tab>format=ABC-{counter}<tab>&

 counterstart=20<tab>counterlen=4<tab>&

 save

 

This Command Generate 100 Serial number-Entrys in beas_plandocument with

"ABC-0020","ABC-00021" ...