Cantara Business Function to add records to the Timecard Entry Interoperability table F06116Z1.
Oracle Doc:
Please refer to the Oracle documentation available at https://docs.oracle.com/cd/E16582_01/doc.91/e15081/proc_interop_for_cam.htm#EOAAI00088 on the operation of the F06116Z1 interface table.
This function uses a simplified list of only the commonly required fields to create the table.
This table can be used to batch load the Timecards to JDE.
Calls
This function calls the following Q35 functions.
Data Structure
|
Name |
Type |
Inclusion |
Direction |
Parameter Notes |
|---|---|---|---|---|
|
EV01_cSuppressErrors |
CHARACTER |
OPTIONAL |
IN |
|
|
DTAI_szErrorMessage |
ERRORALIAS |
OPTIONAL |
OUT |
|
|
PHRW_mnHoursWork |
FLOAT |
REQUIRED |
IN |
|
|
PDBA_mnPayDeductBenAccType |
INTEGER |
REQUIRED |
IN |
|
|
SBL_szSubledger |
STRING |
REQUIRED |
IN |
|
|
SBLT_cSubledgerType |
UDC |
REQUIRED |
IN |
|
|
AN8_mnAddressNumber |
ADDRESSNUMBER |
OPTIONAL |
BOTH |
|
|
DWK_jdDtWorkJulian |
DATE |
OPTIONAL |
BOTH |
|
|
EDUS_szEdiUserId |
STRING |
OPTIONAL |
BOTH |
|
|
EDBT_szEdiBatchNumber |
STRING |
OPTIONAL |
BOTH |
|
|
EDTN_szEdiTransactNumber |
STRING |
OPTIONAL |
BOTH |
|
|
EDLN_mnEdiLineNumber |
FLOAT |
OPTIONAL |
BOTH |
|
|
EDTC_cEdiTransactionAction |
CHARACTER |
OPTIONAL |
BOTH |
|
|
EXR_szNameRemarkExplanation |
STRING |
OPTIONAL |
BOTH |
|
|
OPSQ_mnSequenceNoOperations |
FLOAT |
OPTIONAL |
BOTH |
|
|
RCCD_cRechargeCode |
CHARACTER |
OPTIONAL |
BOTH |
|
|
AUSPTWW_szAUStateWhereWorked |
UDC |
OPTIONAL |
BOTH |
UDC 06|SC |