(A110) Upload transaction detail (ZUPDTL)

Field NameKeyData TypeDescription
UPTMSTKCHAR(26)Transaction timestamp
e.g. CURRENT_TIMESTAMP for MS SQL Server
e.g. NOW(3) for MySQL
UPTRXNKCHAR(10)Transaction code
UPLIBKCHAR(10)AS400 library name
UPOBJKCHAR(10)AS400 file name
UPMBRKCHAR(10)AS400 member name
UPCODEKCHAR(1)Upload code (I/U/D)
UPRRNKNUMBER(10,0)AS400 relative record number
For insertion, use negative unique number
UPRMRKCHAR(64)User remark
UPRTNCHAR(4)Return code
UPUDATNUMBER(8,0)Upload date
UPUTIMNUMBER(8,0)Upload time
Refer to (590) Upload data from PC database to AS400

Table of Contents
Scroll to Top