Q35DeleteF06116Z1Records
Cantara Business Function to delete record(s) from the Timecard Entry Interoperability table F06116Z1.
The F06116Z1 table's Primary Key matches the 4 input parameters described in the data structure below. The function deletes records based upon which parameters are provided, with the following fall-through priority:
- If all 4 parameters are provided, and the matching record exists, then this single record is deleted, else error ID 0002 is set
- If EDUS, EDBT and EDTN are provided, and at least one record exists, then all records matching this key are deleted, else error ID 0002 is set
- If EDUS and EDBT are provided, and at least one record exists, then all records matching this key are deleted, else error ID 0002 is set
- If none of the above conditions are met, then the function will not perform any actions.
NOTE: EDUS, EDBT and EDTN are tested as 'greater than <Blank>' and EDLN is tested as 'greater than "0" ' to indicate that a value is provided. If, for example EDUS and EDLN only are provided, then the 4th test will still apply.
Data Structure
Name | Type | Inclusion | Direction |
---|---|---|---|
EDUS_szEdiUserId | STRING | OPTIONAL | IN |
EDBT_szEdiBatchNumber | STRING | OPTIONAL | IN |
EDTN_szEdiTransactNumber | STRING | OPTIONAL | IN |
EDLN_mnEdiLineNumber | FLOAT | OPTIONAL | IN |