Knowledge base

list/nobanner/title = “Codes Setup Venue Print Notes”/duplicates/nototal cr_venue:cr_venue_key/heading =”Key” cr_description/heading=”Venue” cr_vntxt:cr_tpre_post_flag/heading = “Top-Bottom” cr_tseq/heading = “Seq” cr_text/heading = “Text” /text/width = 50 sorted by cr_venue:cr_venue_key/newlines = 4 end of page “”/newline =3 “Found in Codes Setup>Party Delivery>Venue>Venue Print Notes Tab.” Report Output Example

May 21, 2020

list/nobanner/title = “Codes Setup Venues with Global Tracks Info”/duplicates/nototal cr_venue:cr_venue_active/heading = “Venue Active” cr_venue_key/heading =”Key” cr_description/heading=”Venue” cr_address_1/heading=”Addr 1″ cr_address_2/heading=”Addr 2″ cr_city/heading =”City” al_st_code/heading =”St” al_zipcode/heading =”Zip” st_tax_area/Heading=”Tax Area” cr_mapbook_ref /heading = “Mapbook” cr_contact_name/heading = “Venue Contact” cr_contact_phone/heading = “Contact Phone”cr_venue_room_length/heading =”Rooom Length” cr_venue_room_width/heading = “Width” cr_venue_room_height/heading =”Height” al_gt_geofence_active/heading =”Geofence Active” al_gt_add_geofence/heading = “Name” al_gt_geofence_id/heading = […]

list/nobanner/title = “Codes Setup Salespeople”/dup al_csini:al_csinits al_cs_person al_cs_plan sorted by al_csini:al_csinits end of page “”/newline =3 “Found in Codes Setup>System Codes-Global Misc>Salespeople Tab.”

list/nobanner/title = “Codes Setup Purchase Order Ship To Address”/duplicates/nototal sl_poadr:sl_po_address_key sl_po_address_1 sl_po_address_2 sl_po_address_3 sl_po_address_4 sl_po_address_code sorted by sl_poadr:sl_po_address_key end of page “”/newline =3 “Found in Codes Setup>Purchase Order Setup>PO Ship To/Bill To Addresses Tab.”

list/nobanner/title = “Asset Maintenance Forms List”/dup fa_frmcd:form_no/heading = “Maintenance Form-Code” form_description/heading = “Description” sorted by fa_frmcd:form_no end of page “”/newline =3 “Found in Assets>Edit>Maintenance Forms.”

Report Output Example: *************************************************************************************************** where  ( fa_main:fa_status <> “SO” ) list/domain=”fa_main”/nobanner/Title=”Equipment Setup for EC1/EC2″ fa_main:fr_group/noduplicates fr_group:fr_group_desc fa_main:fa_key fa_main:fa_name fa_main:fa_type fa_main:fa_status fa_main:al_location fa_main:fa_serial_no fa_main:fa_ec1 fa_main:fa_ec2 sorted by   fa_main:fr_group

where   ( fa_main:fa_ec2 = “Y” )   and ( fa_status <> “SO” )   list/domain=”fa_main”/nobanner/Title=”Items Which Do Charge Env2″   fa_main:fr_group/noduplicates   fr_group:fr_group_desc   fa_main:fa_key   fa_main:fa_name   fa_main:fa_type   fa_main:fa_status   fa_main:al_location   fa_main:fa_serial_no   fa_main:fa_ec2

where   ( fa_main:fa_ec1 = “N” )  and ( fa_status <> “SO” )   list/domain=”fa_main”/nobanner/Title=”Items Which Do NOT Charge Env1 “   fa_main:fr_group/noduplicates   fr_group:fr_group_desc   fa_main:fa_key   fa_main:fa_name   fa_main:fa_type   fa_main:fa_status   fa_main:al_location   fa_main:fa_serial_no   fa_main:fa_ec1   sorted by   fa_main:fr_group

Report Output Example: ********************************************************************************************************* /* bulkutillist28d  Trial List report to show bulk utilization historical by out date by Tim M 2/3/05, 2/25/05- fixed auditing lines and added selection for group selection, 4/2/05- changed 14 day to 28 day and added a remark line to show how to change to run future vs past reports. 4/16/2006- […]

–This report gives a list of the items that have a status of “down for maintenace” define file womain = access wo_main,set cr_transaction=fa_main:fa_work_order_transaction, generic where fa_main:fa_status= “DM” list/domain=”FA_MAIN” /nobanner/title = “Equipment Down for Maintenance” fa_main:al_location/heading=”Loc”/noduplicates rc_inv_no/heading = “Rental-Class” fa_ref_no/heading = “Fixed-Asset” fa_name/heading = “Name” womain:cr_contract/heading=”Work-Order#” sorted by fa_main:al_location/newlines=2 fa_key