How Can We Help?
(A110) Upload transaction detail (ZUPDTL)
| Field Name | Key | Data Type | Description |
|---|---|---|---|
| UPTMST | K | CHAR(26) | Transaction timestamp e.g. CURRENT_TIMESTAMP for MS SQL Server e.g. NOW(3) for MySQL |
| UPTRXN | K | CHAR(10) | Transaction code |
| UPLIB | K | CHAR(10) | AS400 library name |
| UPOBJ | K | CHAR(10) | AS400 file name |
| UPMBR | K | CHAR(10) | AS400 member name |
| UPCODE | K | CHAR(1) | Upload code (I/U/D) |
| UPRRN | K | NUMBER(10,0) | AS400 relative record number For insertion, use negative unique number |
| UPRMRK | CHAR(64) | User remark | |
| UPRTN | CHAR(4) | Return code | |
| UPUDAT | NUMBER(8,0) | Upload date | |
| UPUTIM | NUMBER(8,0) | Upload time |