QAD Functions Available
  PPT
QAD Functions Available
 
Function Name
Description
Parameters
Return Value
Name
getCumShipped
Get cumulative qty shipped for SO line.
1 AN ShipFromSite
2 AN ShipToAddr
3 AN MfgProItem
4 AN PurchaseOrder
R
edfct032.i
get_po_no
Get PO Number
1 AN i_tad_itm
2 AN i_po_no
AN
edfct024.i
isblank
Check whether the string is blank
1 AN str1
L
edfct031.i
SysDate
Returns the system date
None
D
edfct033.i
Add
Add to values (integer or decimal)
1 R val1
2 R val2
R
edfct032.i
Check-Hash
Check Hash table to write new record used for inbound record processing.
Check hash on the Application Repository.
1 an PARAM1
2 an PARAM2
3 an PARAM3
4 an PARAM4
5 an PARAM5
6 an PARAM6
7 an PARAM7
8 an PARAM8
9 an PARAM9
10 an PARAM10
R
edfct017.i
CheckHashOut
Check Hash table to write new record used for outbound processing.
Check hash on the Exchange Repository.
1 an PARAM1
2 an PARAM2
3 an PARAM3
4 an PARAM4
5 an PARAM5
6 an PARAM6
7 an PARAM7
8 an PARAM8
9 an PARAM9
10 an PARAM10
R
edfct067.i
Comment
Func to add Comment line between maps
1 AN line-1
2 AN line-2
3 AN line-3
4 AN line-4
5 AN line-5
6 AN line-6
7 AN line-7
8 AN line-8
9 AN line-9
10 AN line-10
AN
edfct050.i
compare
Compares equality of two passed params
1 an param1
2 an param2
L
edfct022.i
ComparePairs
Compares equality of pairs of data passed as sets of params. Five pairs are maximum.
param1=param2
param3=param4
param5=param6
param7=param8
param9=param10
1 an param1
2 an param2
3 an param3
4 an param4
5 an param5
6 an param6
7 an param7
8 an param8
9 an param9
10 an param10
L
edfct064.i
Concat
Concatenates two strings together.
1 AN str1
2 AN str2
AN
edfct001.i
create-addr-mstr
Creates a customer address record in QAD Enterprise Applications
1 an cust-id
2 an shipto-id
3 an addr-name
4 an addr-line1
5 an addr-line2
6 an addr-line3
7 an addr-city
8 an addr-state
9 an addr-zip
10 an tax-status
 
AN
edfct.57.i
Date-Offset
Modifies input date by the number of days specified in i-days either positive or negative.
1 d i-date
2 i i-date
AN
edfct053.i
DateToString
Converts date into MMDDYY, etc., formats
1 d InputDate
2 an OutputFormat
AN
edfct035.i
DetailHash
This functions the same as the Check-hash function except it checks at the inbound application repository detail level.
1 an Identifier
2 an param1
3 an param2
4 an param 3
5 an param 4
6 an param 5
7 an param6
8 an param7
9 an param8
10 an param9
R
edfct063.i
Divide
Divides two values
val1/val2
1 r val1
2 r val2
R
edfct006.i
get-release-id
Get Release ID from Planning Schedule
1 i schd-type
2 an ship-from
3 an ship-to
4 an part-number
5 an po-number
AN
edfct037.i
get-schd-po
Get PO from Schedule
1 i chd-type
2 an ship-from
3 an ship-to
4 an part-number
5 an model-year
AN
edfct036.i
get-val-chkhash
This function is the complement of the put-val-chkhash function. It retrieves a value from the outbound hash table (exchange repository) that has been stored with the put-val-chkhash function.
1 an param1
2 an param2
3 an param3
4 an param4
5 an param5
6 an param6
7 an param7
8 an param8
9 an param9
AN
edfct055.i
GetBatchNo
Retrieves the batch number controlling the current session.
1 i order-type
2 an supplier-addr
3 an shipto-site
4 an part-number
5 an po-number
an
edfct068.i
getMFGPROAddress
Get the QAD Enterprise Applications Address
1 AN tp_id
2 AN tp_doc
3 AN L doc_in
4 AN tp_site
5 AN tp_addr
AN
edfct008.i
getMFGPROSite
Get the QAD Enterprise Applications Site Code
1 AN tp_id
2 AN tp_doc
3 L doc_in
4 AN tp_site
5 AN tp_addr
AN
edfct041.i
getTPAddress
Get the TP Address
1 an tp_id
2 an tp_doc
3 L doc_in
4 an mfg_site
5 an mfg_addr
AN
edfct041.i
get TPSite
Get the TP site Code
1 an tp_id
2 an tp_doc
3 L doc_in
4 an mfg_site
5 an mfg_addr
AN
edfct042.i
getXrefValue
Get the Cross-Reference Value
1 AN tp_id
2 AN tp_doc
3 L doc_in
4 AN mfd_name
5 I mfd_vers
6 I mfd_rec_seq
7 I mfd_fld_seq
8 AN init_value
AN
edfct010.i
get_abs_field
Get shipment file abs_mstr field value
1 an i_tad_item
2 an shipper
3 an field-name
AN
edfct066.i
get_addr_mstr
Get Address Master Turnaround Data
1 an i_tad-item
2 an i_ad_addr
AN
edfct016.i
get_comm_code
Get Commodity Code based on Part Number
1 an part-number
AN
edfct049.i
get_custpart
Get the Customer’s Part Number
1 an mfg_addr
2 an mfg_item_no
AN
edfct040.i
get_custpart_field
Get any field from Customer/Part Master
1 an field-name
2 an cust-no
3 an cust-part
AN
edfct048.i
get_mfgpart
Get the internal QAD Enterprise Applications part number
1 an mfg_addr
2 an cust_part_no
AN
edfct046.i
get_partshipto_TA
Get TurnAround data using Part# & ShipTo from cp_mstr
1 an TA_data-item
2 an part_number
3 an ship_to
AN
edfct039.i
get_part_field
To get any field value from Part Master
1 an field-name
2 an part-number
AN
edfct045.i
get_pod_field
To get any field value from Purchase Order Detail File
1 an order_type
2 an supplier-addr
3 an shipto-site
4 an part-number
5 an po-number
6 an field-name
AN
edfct056.i
get_shipto_TA
Get TurnAround data using the ShipTo
1 an TA_Data_Item
2 an ship_to
AN
edfct047.i
get_sod_det
Get Sales Order Detail Turnaround data
1 AN i_tad_item
2 AN i_sod-no
3 AN i_sod_line
AN
edfct015.i
get_sod_field
Get any field value from the Sales Order Detail File
1 an Order_Number
2 I Line_Number
3 an Field_Name
AN
edfct060.i
get_so_field
Get any field value from the Sales Order File
1 an Order_Number
2 an Field_Name
AN
edfct065.i
get_so_nbr
Get Sales Order Header Turnaround Data
1 AN i_tad_item
2 AN i_so_nbr
AN
edfct014.i
isgreater
Checks to see if 1st param is>the 2nd
1 r first_value
2 r second_value
L
edfct038.i
Modulo
Takes the modulo of val1 and val2
1 I val1
2 I val2
L
edfct011.i
Multiply
Multiplies two values
1 R val1
2 R val2
R
edfct005.i
Progress
Calls any Progress function
1 an Function_Name
2-10 an param1....9
R
edfct061.i
put-val-chkhash
Stores a passed value into the outbound hash table associated with the exchange repository using the parameters 1-9 specified as a key.
The value to be stored os passed as the 10th parameter.
1 an param1
2 an param2
3 an param3
4 an param4
5 an param5
6 an param6
7 an param7
8 an param8
9 an param9
10 an value-to-store
R
edfct054.i
Raise-Error
Raise an ERROR or WARNING flag
1 an E_or_W
2 an i_Text
AN
edfct051.i
Round
Rounds a decimal value
1 r dec_value
2 i precision
R
edfct043.i
Saturn-Kanban
Generates kanban sequence numbers where only a starting number is given.
1 i MFG-PRO-Req-Seq
2 an Starting
AN
edfct058.i
SetXrefValue
Stores a record in the EDI eCommerce cross-reference table.
1 an tp-id
2 an tp-doc
3 an doc-in
4 an mfd-name
5 i mfd-vers
6 i mfd-rec-seq
7 i mfd-fld-seq
8 an init-value
9 an conv-value
R
edfct059.i
Substring
Returns a protion of a string
1 an src_text
2 i start_pos
3 i total_len
AN
edfct007.i
Subtract
Subtract two values
1 R val1
2 R val2
R
edfct004.i
Systime
Get system time
None
AN
edfct034.i
ToDate
Converts to Progress Date from Character
1 AN i-date
2 AN i-format
D
edfct003.i
Truncate
Truncates a decimal value
1 r dec_value
2 i precision
R
edfct044.i