Function.Global.General.CallwrapperAsync

From GAB Help
Jump to: navigation, search

These commands launch wrapped Global Shop processes (indicated by a long integer mode).

Syntax

Function.Global.General.CallWrapperAsync(mode, parameters) or

Function.Global.General.CallWrapperSync(mode, parameters)

This command will pass the Business Intelligence Override flag to any call wrapper mode related to a Business Intelligence reports. This command will also support all existing call wrapper modes.

Function.Global.General.CallWrapperAsyncBIO(Mode, Parameters)

Function.Global.General.CallWrapperSyncBIO(Mode, Parameters)

Arguments

Mode

Numeric Value that represents the program

Parameters

String Value delimited by !*!

Program Mode Parameters
1SHOTGI 50 - Run 1SHOTGI Program name
FIXBMATL 1000 - Fix BOM calls REBLDALL Company code
BM0050 1010 - Update Inventory Description to BOM

Bill of Material>Administration>Update Inventory Description to BOM - Process

01: Unit Cost Updates

02: Rebuild Browser Index

Beginning BOM Parent

Beginning BOM Rev

End BOM Parent

End BOM Rev

All BOMs Flag

Update Cost

01: Zero Unit Cost For All Parents

02: No Change To Unit Cost For Any Parents

03: No Unit Cost Update

04: Update All Costs From Alt Cost

Refresh Descriptions For Raw Materials Flag

Refresh Descriptions For Parent Parts Flag

Refresh Unit Of Measure Fields Flag

Refresh Source Code Flag

RE0071CW 1500 - Reprice Routers In File

Out File

RE0019 1510 - Admin Reprice Routers/ Estimates

Estimating/Routing & Quote Management>Administration>Reprice Router/Estimates - Mode

“PS”: populate the screen

“NS”: screenless mode

Beginning Router

End Router

All Routers Flag

Pull Setup from Workcenter Flag

Pull Runtime from Workcenter Flag

Pull Description from Workcenter Flag

Pull Description from Inventory (Material) Flag

Pull Description from Inventory (Router) Flag

Pull Product Line from Inventory (Router) Flag

Reprice Labor Steps Only Flag

Reprice Material Steps Only Flag

Update Alternate Cost Router Flag

Alternate Cost Reprice Quantity

Zero Unit Cost for Manufactured Parts Flag

Refresh Lead Time on Material Sequences Flag

Refresh Lead Time on Outside Sequences Flag

Update Rate with Inventory Cost Even if Zero Flag

Update Rate with Workcenter Rate Even if Zero Flag

JB0082 2000 - Manual Time Card Input Screen

Shop Floor Control>Transactions> Manual Time Card Input - Mode

SS-Select Scrap – Opens the scrap selection screen

AS-View Scrap – Opens scrap selection screen in view only mode

AR-Add record – Add a scrap record with the passed properties

UR-Update record – Updates a scrap record with the passed properties

GR-Get record

GN-Get next record

UN-Undo all uncommitted changes for the specified scrap reference ID

SC-Save uncommitted changes for the specified scrap reference ID

CS-Copy scrap from one detail record or scrap reference ID to another

DC-Check for disposals for a detail record or scrap reference ID

DS-Delete scrap for a detail record

GS-Get the scrap data tied to a detail record or scrap reference ID

VS-Validate scrap code

AQ-Assign quality numbers for a detail record or scrap reference ID

Job: The job displayed in select scrap or view scrap mode

Suffix: The suffix displayed in select scrap or view scrap mode

Sequence: The sequence displayed in select scrap or view scrap mode

Total Scrap: The scrap quantity to match in select scrap mode

Scrap Reference: The reference ID used to reference changes done in previous calls to JB0082. If no reference ID is explicitly passed, an unused ID will be assigned to this field. It is a 16 digit numeric

    • The following parameters are the fields of the SCRDT file and are used to send and receive parameters from the SCRDT file but the SCRDT-DTL-* parameters are also used as the job detail key fields

SCRDT-DATE: Date the record was created (CCYYMMDD)

SCRDT-TIME: Time the record was created (HHMMSShh)

SCRDT-SEQ: Sequence for that date/time combination

SCRDT-DTL-JOB: Job for the associated detail record

SCRDT-DTL-SUFFIX: Suffix for the associated detail record

SCRDT-DTL-SEQ: Sequence for the associated detail record

SCRDT-DTL-DATE: Date for the associated detail record (YYMMDD)

SCRDT-DTL-KEY-SEQ: Key sequence for the associated detail record

SCRDT-STAT:

  • 0-Temporary, uncommitted status
  • 1-The record has been saved, but no detail record exists yet
  • 2-The record has been saved and a detail record exists SCRDT-QUALITY: The quality record number

SCRDT-REASON-CODE: The scrap reason code for that record

SCRDT-QTY: The quantity scrapped in that record

SCRDT-SCRAP-REF: Can be populated explicitly, but will also be populated by JB0082 as necessary

STATUS-ON-SAVE:

  • 0-Temporary, uncommitted status
  • 1-The record has been saved, but no detail record exists yet
  • 2-The record has been saved and a detail record exists. The detail key should be passed in SCRDT-DTL-* DEST-DTL-KEY: Destination detail key used for copying scrap

DEST-SCRAP-REF: Destination scrap reference ID

GET-QUALITY-FLAG: Set to Y assign quality numbers to committed data when scrap data records are saved

UPDATE-QUALITY-FLAG: Set to Y to delete existing quality data when quality records are deleted

Output Parameters:

STATUS:

  • 00-Successful
  • 01-No changes made
  • 02-Disposals exist (Used for check for disposals mode.)
  • 10-Invalid scrap reason
  • 99-Failed RET-PRIMARY-REASON: Scrap reason selected with the greatest quantity

RET-PRIMARY-QTY: Greatest scrap quantity for a selected reason

RET-PRIMARY-QUALITY: Quality number with greatest scrap quantity

JB0027 2001 - Quality Reject/Disposition

Quality>File>Quality Reject/Disposition - Company Code

Quality Number

JB0028 2002 - Shop Floor Control Tasks

Shop Floor Control>Transactions>Tasks - Company Code

Type

'W'=Workorders

'S'=Single Job)

Beginning Workorder

Beginning Suffix

End Workorder

End Suffix

Terminal

JB0052GI 2003 - WIP to Finished Goods

Shop Floor Control>Transactions>WIP to Finished Goods - Company Code

Terminal

Calling Program

Mode - "NS": screenless mode

Pass Detail Job^

Pass Detail Suffix^

Pass Detail Sequence

Pass Detail Fill^

Pass Detail Date^

Pass Detail Key Sequence^

Workorder*

Workorder Suffix*

Transfer Date Year*#

Transfer Date Month*#

Transfer Date Date*#

Close Workorder Flag* (Y or N)

Part Description*#

Quantity*

Cost*

Price*

Print Labels Flag* (Y or N)

Cost Method*

Update Inventory Flag* (Y or N)

Inventory Debit Account*

File Name*

A fully qualified path to a tab delimited file (each column separated by a tab, each row separated by a new line).

Each row should have the following columns:

Lot

Bin

Heat

Serial

Quantity

Expiration Date

Warranty Months

User Field 1

User Field 2

User Field 3

User Field 4

User Field 5

User Field 6

User Field 7

User Field 8

User Field 9

If any of the columns are blank, they are assumed to be empty. A valid or empty bin is required and the total quantity of all the rows in the file must match the quantity that was passed as a parameter to the callwrapper.

^ indicates that this parameter is only used when no mode is specified.

  • indicates that this parameter is only used in screenless mode.
  1. indicates that this parameter is optional. If blank, it will be set to its default value.

Other notes:

If screenless mode is on, all error messages will be suppressed. If an error occurs, the text from the error message will be passed back as a parameter and can be accessed via Variable.Ambient.CallWrapperReturn.

JB0056GI 2005 - Commit Router Material

Shop Floor Control>Transactions>Commit Router Material - Job

Suffix

Sequence

AR002CN 3000 - Customer Order Notes

Accounts Receivable>File>Customer>New/Open>Order Notes - Customer ID

Customer Name

Mode

'CU': Customer Update

'CV': Customer View

'OV': Order View

Type

'C': Customer

'P': Prospect

ORD231 3010 - Contract Part Pricing

Order Entry>File>Contract Part Pricing - Mode

“PS”: populate the screen

“NS”: screenless mode

Effective Date: Date in MMDDYYYY format. If zero, the current date will be used.

Print Modified Rate Tables Flag

Number of Effective Dates to Print

Generate Open Order Price Update Transactions Flag

All Customers Flag

“A”: radio button “All Customers” selected.

“I”: radio button “Include Ranges” selected. If this is used in screenless mode, screenless mode will be turned off so the user can specify the ranges.

“X”: radio button “Exclude Ranges” selected. If this is used in screenless mode, screenless mode will be turned off so the user can specify the ranges.

INVMAIN 3500 - Inventory Master

Inventory>File>New/Open - Company Code

Mode

N- new part

C- copy part

D- delete part

V- view part

O- open part

L- view mode with lead time not protected

E- view mode with product line, description, and UM and Pur UM not protected

P- view mode with source, order qty, and sort, reorder not protected

Switch 2

D- pull up the part options

U- prevent reorder from being disabled

N- screenless mode(for delete only)

Switch 3

S- show cost regardless of option

Part

Part Location

INV220GI 3550 - Issues and Receipts from Inventory

Inventory>Transactions>Stand Alone Issues and Receipts - Company Code

Terminal

Calling Program

User ID

Mode (future use)

Sales Order

Sales Order Line

ENG002 3600 - Maintain Engineering Change Control

Quality>Transactions>Maintain Engineering Change Control - Company Code

Prefix

Number

ENG003 3601 - Engineering Change Control Signoff

Quality>Transactions>Engineering Change Control Signoff - Company Code

Prefix

Number

Part

QL6004 3700 - Cause and Corrective Action Signoff

Quality>Transactions>Cause and Corrective Action Signoff - Company Code

CNC

QL6014 3701 - Vendor Approval Signoff

Quality>Transactions>Vendor Approval Signoff - Company Code

VAP

ORD011 4000 - Order Entry Discounts

Order Entry>File>Discoutns - Company Code

Terminal

Calling Program

User ID

Part

JB0098 5000 - Edit Flex Schedule

Shop Floor Control>File>Flexible Schedule - Mode

VW - View Only

OP or spaces - Open

Schedule (schedule to open)

Suffix (schedule suffix to open)

Return Parameters-

Status

00 - Successful

10 - User canceled

35 - Parameter Error

99 - Failed

UPLSCHED 6000 - Upload Schedule Option

50 Append

51 Delete

52 Append and update

Screen Mode -set to NS for no screen mode

UPLPLDSC 6001 - Upload PL/Discounts Option

50 Append

51 Delete

52 Append and update

Screen Mode -set to NS for no screen mode

UPLQUOTE 6002 - Upload Schedule Screen Mode - set to NS for no screen mode

Option

50 Append

51 Delete

52 Append and update

UPLSALES 6003 - UPSALES MODE: Company Code, Option Selected
ORDUPCM3 6004 - Upload Sales Order Company Code

User

File

UPLSCHED 6006 - Upload Employee Option

50 Append

51 Delete

52 Append and update

Screen Mode -set to NS for no screen mode

UPLITEM 6007 - Item Lot/Bin Master Upload Option

50 Append

51 Delete

52 Append and update

Screen Mode -set to NS for no screen mode

UPLJOBST 6008 - Upload Job Cost Sequence Lines to Router Header Master Option

50 Append

51 Delete

52 Append and update

Screen Mode -set to NS for no screen mode

ORD501GI 7000 - Order History Query by Part Number

Order Entry>View>Orders and History - Customer

Part

Part Location

Hide Cost Fields (Y or N)

Passed parameters to callwrapper:

RPT-ID – The crystal report id

HDG-FLG – Include heading row in response files

0 = Not requested

1 = Requested

OPT01-FLG - Calls module to calculate totals without tax detail

0 = Not requested

1 = Requested

OPT02-FLG – Calls module to calculate totals and return tax detail

0 = Not requested

1 = Requested

Options 03 through 99 are not currently supported

Order Header Request File Columns:

SOURCE TABLE – The table to use to fulfill the request

Q = Quotes

O = Sales orders

D = Detail billing orders

S = Shipments

H = Invoice History

ORDER – The 7 digit order number (always required)

SEQUENCE – The 4 digit shipment sequence (required for shipments and invoice history)

INVOICE – The 6 digit invoice number (only required for invoice history)

Order header response columns:

SOURCE TABLE – The table to use to fulfill the request

Q = Quotes

O = Sales orders

D = Detail billing orders

S = Shipments

H = Invoice History

ORDER – The 7 digit order number (always required)

SEQUENCE – The 4 digit shipment sequence (required for shipments and invoice history)

INVOICE – The 6 digit invoice number (only required for invoice history)

STATUS – Status of the module request for this entry (0 is successful, 1 is failed)

CMP-GROSS – Company currency gross order total

CMP-FRT – Company currency freight amount

CMP-TAXES – Company currency total tax amount

CMP-DISC – Company currency total discount amount

CMP-NET – Company currency net order total

ORD-GROSS – Order currency gross order total

ORD-FRT – Order currency freight amount

ORD-TAXES – Order currency total tax amount

ORD-DISC – Order currrency total discount amount

ORD-NET – Order currency net order total

PROFIT – Percent profit on order total

FRT-COST – Company currency freight cost

TAX-CTR – Number of tax authorities (also number of tax detail records returned)

WEIGHT – Total net weight (not provided for invoice history)

COST – Company currency total cost (not provided for invoice history)

CMP-PRCCLS-DISC – Company currency total price class discount (invoice history only)

CMP-PRDLN-DISC – Company currency total product line discount (invoice history only)

CMP-ORDER-DISC – Company currency total order discount (invoice history only)

ORD-PRCCLS-DISC – Order currency total price class discount (invoice history only)

ORD-PRDLN-DISC – Order currency total product line discount (invoice history only)

ORD-ORDER-DISC – Order currency total order discount (invoice history only)

STD-LINE-CTR – Lines excluding freight, progress bill, and material surcharge (invoice history only)

CMP-MATL-SCHRG – Company currency total material surcharges (invoice history only)

CMP-SHIP-CHRG – Company currency total shipping charges (invoice history only)

ORD-MATL-SCHRG – Order currency total material surcharges (invoice history only)

ORD-SHIP-CHRG – Order currency total shipping charges (invoice history only)

Order header tax detail response columns:

SOURCE TABLE – The table to use to fulfill the request

Q = Quotes

O = Sales orders

D = Detail billing orders

S = Shipments

H = Invoice History

ORDER – The 7 digit order number (always required)

SEQUENCE – The 4 digit shipment sequence (required for shipments and invoice history)

INVOICE – The 6 digit invoice number (only required for invoice history)

TAX-CD – Tax authority code

TAX-DESC – Tax description

TAX-RATE – Tax rate

CMP-TAX-AMT – Company currency total tax amount

CMP-TAXABLE – Company currency total taxable amount

ORD-TAX-AMT – Order currency total tax amount

ORD-TAXABLE – Order currency total taxable amount

The core program sets the RETURN variable to one of the following values:

00 = Successful

01 = Passed parameter error

23 = No order header request records found

35 = File error

99 = Cancel

Parameters:

RPT-ID – The crystal report id

HDG-FLG – Include heading row in response files

0 = Not requested

1 = Requested

OPT01-FLG – Calls module to calculate total discount percentage

0 = Not requested

1 = Requested

OPT02-FLG – Calls module to calculate extenstion for back order quantity

0 = Not requested

1 = Requested

OPT03-FLG – Calls module to return tax authorities and amounts

0 = Not requested

1 = Requested

Options 04 through 99 are not currently supported

Order Line Request File Columns:

SOURCE TABLE – The table to use to fulfill the request

Q Quotes

O Sales orders

D Detail billing orders

S Shipments

H Invoice History

ORDER – The 7 digit order number (always required)

LINE – The 4 digit line numer (always required). The first 3 digits are always the line number number.

For quotes, the 4th digit is the line suffix

For all other sources, the 4th digit is always zero

SEQUENCE – The 4 digit shipment sequence (required for shipments and invoice history)

INVOICE – The 6 digit invoice number (only required for invoice history)

Order header response columns:

SOURCE TABLE – The table to use to fulfill the request

Q = Quotes

O = Sales orders

D = Detail billing orders

S = Shipments

H = Invoice History

ORDER – The 7 digit order number (always required)

LINE – The 4 digit line numer (always required). The first 3 digits are always the line number number. For quotes, the 4th digit is the line suffix. For all other sources, the 4th digit is always zero.

SEQUENCE – The 4 digit shipment sequence (required for shipments and invoice history)

INVOICE – The 6 digit invoice number (only required for invoice history)

STATUS – Status of the module request for this entry (0 is successful, 1 is failed)

Option 01

TOTAL-DISC-PCT – Total discount percentage

Option 02

CMP-BO-QTY-DISC – Company currency total discount based on back order quantity

CMP-BO-QTY-EXT – Company currency extension based on back order quantity

ORD-BO-QTY-DISC – Order currency total discount based on back order quantity

ORD-BO-QTY-EXT – Order currency extension based on back order quantity

Option 03

CMP-TOTAL-TAX – Company currency total tax amount

ORD-TOTAL-TAX – Order currency total tax amount

TAX-CTR – Number of tax authorities assigned

One set of data for each tax authority (maximum of 10)

TAX-ZONE – Tax authority zone (state or country)

TAX-CD – Tax authority code

TAX-APPLY – Whether taxes should be applied (Y is applied)

TAX-AUTH-TYPE – Tax authority type

1 = State

2 = County

3 = City

4 = Other

5 = Country

6 = Province

7 = Local

TAX-TYPE – Tax type

S = Sales or Use Tax

V = VAT Tax

TAX-RATE – Tax rate

TAX-DESC – Tax description

CMP-TAX-AMT – Company currency total tax amount

ORD-TAX-AMT – Order currency total tax amount

CMP-TAXABLE – Company currency total taxable amount

ORD-TAXABLE – Order currency total taxable amount

The core program sets the RETURN variable to one of the following values:

00 = Successful

01 = Passed parameter error

23 = No order line request records found

35 = File error

99 = Cancel

JB032BGI 93000 - Build Payroll Report Table Start Date (CCYYMMDD)

End Date (CCYYMMDD)

Process By

E - Employee

D - Department

G - Group

Starting - Start of the range of the employee, department or group

Ending - End of the range of the employee, department or group

Print - Y to print balance only

Page Flag - Y to insert page break for each employee

Exclude Absences Flag

AR0020GI 100000 - Launch Customer Master

Accounts Receivable>File>Customers - Mode

F - ?

O - Open

N - New

D - Delete

V - View

E - Edit

Customer/Prospect Switch

P - Prospect, leave blank for customer

Customer Number

AR0026B 100050 - Customer Note Maintenance Customer Number

Customer/Prospect Switch

P - Prospect, leave blank for customer

ORD064GM 100100 - Add a Ship-To To a Customer

Accounts Receivable>File>Customers>New/Open>Add'l Ship-To - Customer number

AR0170GI 100200 - View Open AR

Accounts Receivable>View>AR Open Items and History - Customer number

PUR021GI 175000 - Vendor Quotes

Purchasing>File>Vendor Quotes - Part number (full 20)

PURA64GI 175100 - Generate PO From File File Name

Auto Number Flag (Y or N)

Add Comments Flag (Y or N)

Open Po Flag (Y or N)

Tab Delimited File Layout:

Vendor

Part

Location

Due Date

Description

Inventory Unit of Measure

Inventory Cost

Inventory Quantity

Purchase Order Unit of Measure

Purchase Order Cost

Purchase Order Quantity

GL Account

Extension

PUR064GH 175200 - Opens Purchase Order

Purchasing>File>Purchase Orders Manual - Mode

O to open

N for new

D for delete

V for view

H for view history

C for copy

Purchase Order Number

Vendor Number (only used for New)

ORD200 200000 - Sales Orders

Order Entry>File>Sales Orders - Sales Order Number

Mode

V - View

O - Open

N - New

C - Copy

D - Delete

Customer Number

ORD201 200050 - Delete Sales Order Line

Order Entry>File>Sales Orders>Open/Delete>Lines - Order Number

Line

Terminal

ORD803 200060 - Sales Order Total
ORD602 200070 - Sales Order Delete Payment
ORD195GI 200500 - Sales Order History by Customer/ Ship-To

Order Entry>View>Sales Order History>Order History by Customer/Ship-To - Customer number

QL3060 200700 - Sales Order History by Invoice

Order Entry>View> - Invoice number

ORD880 200800 - Create WO from Sales Order Type

C - Cylce

D - Detail

O - Order

Order Number

QL3060 200900 - Reprint Invoice (Screenless)
SHP150 201000 - Quick Ship Simple 1 order 1 Bin
ORD503GI 202000 - Part history by customer and part Customer number

Part/Rev

Location

Hide cost switch: Y to hide costs, N to show costs

ORD0FRT 203000 - Freight Maintenance
ORDUSRT 203100 - User Value Table Maint For Sales Orders

System Support> Administration> Company Options (Standard) > Order Entry Tables > User Fields - Header/Line Flag

H - Header

L - Line

User Field 1 Label

User Field 2 Label

User Field 3 Label

User Field 4 Label

User Field 5 Label

Apply to Items Defined in Tables

A to apply

V for normal

Default User Field

Default Customer

Default Ship-to

Default Part

Default Location

QL1000 205000 - Warranty

Quality > File > Warranty Maintenance - Customer number

QTE200 251000 - Quick quote

Estimating/Routing & Quote Management > File > Quick Quotes - Quote Number

Mode

V - View

O - Open

N - New

C - Copy

D - Delete

QTE504 201500 - Quote History by Part
251001 - New Quick quote Quote Number

Customer

Note: If no quote number is passed, then the quote number will be automatically generated.

QL2002 251100 - New RMA

Quality > Transactions > RMA - Invoice

Order

Order Sequence

INVMAIN 300000 - Inventory Maintenance/View

Mode

N - New

C - Copy

D - Delete

V - View

O - Open

L - Lines

E - ?

P - ?

X - ?

Part/Rev

Location

INV500GI 300010 - Supply and Demand Part/Rev

Location

INV500GI 300011 - Supply and Demand Part/Rev

Location

Switches

INV455 300050 - Contract Part Pricing

Order Entry > File > Contract Part Pricing - Part/Rev

Location

Description

Uses Revision Flag

LOT155GI 300060 - Updates Item Master For Issued Parts Part

Location

Quantity Issued

Sequence

Order

File Name

Tab Delimited File Layout:

Lot, Bin, Heat, Serial and Quantity

INV756 300070 - Updates Inventory Usage Beginning Month

Beginning Year

End Month

End Year

LOT054GI 300080 - Show Bin to Bin Transfer Screen with Part Selected Part

Bin

Single Update Mode (Y for the screen to close after first update)

RE0010GI 400000 - Estimating/Standard Routers

Estimating/Routing & Quote Management>File>Estimating/Standard Routers - Mode

O - Open

V - View

N - New

D - Delete

C - Copy

L - Load

Router

1SHOTGI 400050 - Router Upload runs 1Shot in append only for UPLRTRH loading in ROUTERHD.txt from files - None
BM0048 410000 - Export BOM from TAB File
WOQUERY 450000 - Work Order Query

Shop Floor Control>View>Work Orders - Mode

1 select work order

2 chose work order by customer

3 chose work order by PO

4 chose work order by user code

5 chose work order by work order discount

6 chose work order by part

7 show specific work order

8 show specific work order without cost

9 show specific work order without labor dollars

Workorder Number

Suffix

Active/History switch

A for active

H for history

WIR100 450100 - Issue Material to Job From File File Name

File Layout (Comma Delimited):

Part Length(20)

Rev Length(03)

Location Length(02)

Quantity Length(16)

Lot Length(15)

Bin Length(06)

Heat Length(15)

Serial Length(30)

Workorder Number Length(6)

Workorder Suffix Length(3)

Workorder Sequence Length(6)

WIR100 450101 - Issue Material to Job From File File Name

File Layout (Tab Delimited):

Part Length(20)

Rev Length(03)

Location Length(02)

Quantity Length(16)

Lot Length(15)

Bin Length(06)

Heat Length(15)

Serial Length(30)

Workorder Number Length(6)

Workorder Suffix Length(3)

Workorder Sequence Length(6)

JB0075GI 450150 - Bring Up Reverse Issue Material

Shop Floor Control>Transactions>Reverse Issued Material - Workorder

Suffix

Sequence

Date (CCYYMMDD)

Time (HHMMSShh)

Transaction Date (CCYYMMDD)

Previous Issue Made - Y to not delete the previous issues that were made in the same thread.

SQLGSLOD 500000 - APS Scheduling Information Download

Capacity Planning & Scheduling>File>Download Scheduling File - Mode

Blank to accept input

SP for show progress (progress will be displayed, and window will close when finished)

SI for silent, no visible screens

Default Date(CCYYMMDD)

Valid ReRead-Lead-Flags:

1: The reread for lead time when zero box is checked

2: The reread for lead time when zero on seq is checked

3: Both checkboxes are checked

1SHOTGI 500010 - Runs APS 83 Schedule None
1SHOTGI 500020 - APS 3 Backward
JB0011CL 500030 - Schedule Job Start Date (YYMMDD)

Due Date (YYMMDD)

Workorder

Suffix

Sequence

Schedule

F: Forward Schedule

B: Backward Schedule

H: Scheduling from Current Sequence

HOOK02 600000 - Activate/Inactivate Hook

System Support>Administration>GAB Script Hook Maintenance - Hook

Hook Active Flag (Y or N)

Hook Description

Script

Sync Flag (A for Asynchronous or S for Synchronous)

PR0805 700100 - Access to Paygroup Pay Group

Return Parameters:

Return

00: Successful

04: Read Failed

35: Unsuccessful

Security

Y: Has security

N: No security

TSCH01 800000 - Add to Task Scheduler

System Support>Administration>Task Scheduler Maintenance - Mode

“SA”: Screenless add mode

Task ID - Used only if the task type is Global.

Item to Run - Used only if the task type is NOT Global.

Frequency

“O”: Once

“D”: Daily

'W': Weekly

'M': Monthly

Task Type

'M': Global

'C': Custom

'G': GAB Script

Task Description

Task Active Flag

Start Yet

Start Month

Start Day

Start Hour

Start Minute

Start Second

BJ020LZ 900100 - Print barcode work order extended Work order number, work order suffix, report ID
JB0053 900200 - Print work order pick list
- Starting work order number, starting work order suffix, ending work order number, ending work order suffix
JB0095N 900300 - Print flex schedule
- Starting date, ending date, starting FS number, starting FS suffix, ending FS number, ending FS suffix, show material (Y if so), use extended barcode (Y if so)
ORD175 910040 - Print Order Bookings Begin Date - MMDDYY format for the start date

End Date - MMDDYY format for the end date

Switch - B (Build Data No Preview) L (Runs Report ID 72)

All - Set to Y to use no criteria

Stamp Date - Used when switch is B an written to the BIBK file for all records

Stamp Time - Used when switch is B an written to the BIBK file for all records

ORD0ACKN 910050 - Print Sales Order Order Number

Mode (P)

Ack Title

SHP300 910060 - Print BOL
SHP205 910070 - Print Packing List INVOICE-NO Can use invoice, order & seq, or pck-no

ORDER Can use invoice, order & seq, or pck-no

SEQ Can use invoice, order & seq, or pck-no

SUPPRESS-DATE Set to “Y” to hide the due date

SUPPRESS-CNDN Set to “Y” to bypass Customs Invoice

LABELS-ONLY Set to “Y” to only print labels

NO-SCREENS Set to “Y” to bypass user input

PCK-NO Can use invoice, order & seq, or pck-no

QKPRT-NAME File name of a btrieve file that contains the PCK-NO and order of the shipments to be printed

SHIP-DATE CCYYMMDD

ORD054 910100 - Print sales order pick list Sales order number
ORD054 910200 - Print Sales Order Pick List Beginning Order Numer

Ending Order

All Orders Flag

Start Date(CCYYMMDD)

End Date (CCYYMMDD)

All Dates Flag

ORD055 910201 - Print Shipment Pick List Beginning Order Number

Ending Order Number

All Orders Flag

Start Date

End Date

All Dates Flag

PUR1LZ 915000 - Print PO

Purchasing>Reports>Purchase Orders - Purchase Order Number

Switch

S- Screenless

Screenless History Flag

Print Open Qty Flag

Use Vendor Currency Flag

QTL010 920000 - Print Quote

Estimating/Routing & Quote Management>Reports>Quotes -

JB032BGI 930000 - Build Payroll Report Table Start Date

End Date

Process By

Starting

Ending

Print

Page Flag

Excl Absences

Empl By

FIXBMATL 1001 - Print barcode work order extended Parameters:

0. Beginning router

1. Ending router

BM0034P 1020 - Print barcode work order extended Parameters:

0. RUNID

1. LOCATION

2. QTY

3. PARENT-PT-RNG-FILE

4. PRINT-ALL-PARTS

BMR060E 1030 - BOM Cost Buildup Description
JB0052GI 2004 - WIP to FG Description
JB0083 2006 - Edit Work Order Detail Parameters:

Date (MMDDYY)

Employee#

JB0010GI 2007 - New/Edit/View Work Order Description
JB0083 2008 - Edit Work Order Detail Description
JB0010GI 2009 - New/Edit/View Work Order Parameters:

Work Order

Work Order Suffix

Switch

O: Open

N: New

V: View

JB0079 2020- Description Parameters:

0. Transaction ID

BMJ501 2050 - Description Parameters:

0. Work Order

1. Quantity

2. Due Date

3. Part Number

JB0066 2060 - Description Parameters:

0. From Work Order

1. From Work Order Suffix

2. To Work Order

3. To Work Order Suffix

4. To Work Order Seq

5. Transfer Date

6. Closed Flag

7. Quantity

8. Cost

9. Price

JB0019GI 2070 - Description Parameters:

0. Beginning Work Order

1. Beginning Work Order Suffix

2. Ending Work Order

3. Ending Work Order Suffix

JB0122 2080 - Description Parameters:

0. Report Selection 

0 – Current (Default) 

1 - History 


1. Work Orders

0 – Closed and Open Workorders (Default) 

1 – Closed Workorders 

2 – Open Workorders 


2. Print Detail 

0 – Yes (Default) 

1 – No 


3. Separate Prem Time 

0 – No (Default) 

1 - Yes 


4. Use Projected Sales 

0 – No (Default) 

1 - Yes 


5. Print Detail Comments 

0 – No (Default) 

1 - yes 


6. Beginning Date CCYYMMDD 


7. Ending Date CCYYMMDD 


8. All Dates 

0 – No (Default) 

1 - Yes 


9.Type of Detail 

0 – All Detail (Default) 

1 – Labor Detail 

2 – Material Detail 

3 – Outside Detail 


10. Beginning WO 


11. Beginning Suffix 


12. Ending WO 


13. Ending Suffix 


14. All Work Orders 

0 – No (Default) 

1 - Yes 

Note: Dates and Type of Detail only used when Print Detail is set to Yes. 

GL0806 2100 - Description Description
GL0806 2101 - Description Description
AP043IVC 2110 - Description Description
LOT001 2200 - Description Parameters:

0. ITMST-FILENAME

AR0140GI 3050 - AR0140GI - Print customer statements Parameters:

Start

End

Date

Attn

"Y": Yes

"N": No


Country

"Y": Yes

"N": No


Total

"Y": Yes

"N": No


Heading Date

Beginning Branch

Ending Branch


Branch

"Y": Yes

"N": No


Print Zero

"Y": Yes

"N": No

SHP150 3100 - Quick Ship - Screenless - All Customers/Orders/Bins Quick Ship - Screenless - All Customers/Orders/Bins - SHP150

Parameters:

All Carriers Flag 

Carrier 

All Promise Dates Flag 

Beginning Promise Date 

Ending Promise Date 

Print Packing List Flag 

Print Bill of Lading Flag 

Print BOL Labels Flag 

Print Shipping Labels Flag 

No Delivery Before Date 

Must Deliver By Date 

Use Customer Bill To for 3rd Party Freight Customer Flag

SHP150 3101 - Quick Ship - Screenless - All Customers/Orders/Bins Parameters:

All Carriers Flag 

Carrier 

All Promise Dates Flag 

Beginning Promise Date 

Ending Promise Date 

Print Packing List Flag 

Print Bill of Lading Flag 

Print BOL Labels Flag 

Print Shipping Labels Flag 

No Delivery Before Date 

Must Deliver By Date 

Use Customer Bill To for 3rd Party Freight Customer Flag

Service Type

Must Ship Complete

PUR100GI 3200 - PO Receipts Description
PUR011GI 3210 - Description Parameters:

0. REQ-NUMBER

PR0002GI 3300 - Description Parameters:

0. MODE ("N"=New, "O"=Open, "V"=View)

1. EMPLOYEE NUMBER

PR0064P 3310- Description Parameters:

0. RUNID

1. BEG-DATE

2. END-DATE

3. EC-RANGE-FILENAME

4. ALL-EC-SELECTED

5. DD-RANGE-FILENAME

6. ALL-DD-CD-SELECTED

7. DD-401K-SELECTED

QTE003GI 3800 - Description Parameters:

Quote Number

Screenless

"Y": Turns on screenless mode


Mode

"W": Won all lines

"L": Loss all lines

"C": Close all lines

QTE003GI 3801 - Description Description
ORD011 4001 - Order Entry Discounts PARAMS:

CMPNY 

TRMNL 

CALLING-PGM 

USER-ID

PART

ORD098 4010 - New Shipments Description
JBUTL001 5100 - Add router lines to a work order Parameters:

1. WO

2. WO Suffix

3. Router Number

4. Schedule

"B": Backward schedule

"F": Forward schedule

"H": schedule from here

JBUTL001 5101 - Delete all sequences from a work order Parameters:

1. WO

2. WO Suffix

6005 - Description Description
UPLBOMTX 6009 - Upload BOM Text Description
UPLBOMH 6010 - Upload BOM Master Description
UPLPRHIS 6011 - Upload Payroll history master Description
UPLCUTL/#$#2#$# 6012 - Cutlist master upload Description
UPLCUST 6013 - Customer upload Parameters:

1) Mode

  "1": Append
  "2": Delete
  "3": Update
UPLPROSP 6014 - Prospect upload Parameters:

1) Mode

  "1": Append
  "2": Delete
  "3": Update
UPLTIMA3/U 6015 - Time & Attendance upload Description
PUR102 6016 - PO Receipts upload Description
UPLJBMUL 6017 - Job Master upload Description
UPLBOMC 6018 - Description Parameters:

0. MODE:

1 = Append

2 = Delete

UPLRTRH 6020 - Description Parameters:

0. MODE

    1 = append

    2 = delete

1. PASSED-FILE-NAME

UPLRTRH/A 6021 - Description Parameters:

0. MODE

1 = append

2 = delete

1. PASSED-FILE-NAME

XGL006 6030 - Description Parameters:

0. INPUT FILENAME

1. BATCH

2. POST DATE (CCYYMMDD)

3. ACCOUNT

4. TRANSACTION TYPE ("10" = INVOICE, "20" = JE, "21" = BRANCH JE)

ORD805 7010 - OE/Quote Delete Module Parameters:

File Type

Is Transaction

Order

Line

Seq

Invoice Only

PO

User

Action

Shipped

Parent

Ignore Backings

No Messages

OEFLU

ORDADLN 7020- Add Orders/Quotes Detail Line - ORDADLN Parameters:

Order/Quote Number

Transaction

Full Path

ORDADLN 7021 - Description Description
ORD143 7030 - Create default order entry invoice job stream for the specified company code Description
ORD740 7035 - Update XSRVY(survey) file for a quote line Description
ORD742 7039 - Description Description
ORD743 7040 - Transfer/Moved Orders Module Description
ORD743 7041 - Transfer/Moved Orders Module Parameters:

1. ORDER

2. NEW LOCATION

3. MOVE FLAG ("Y" = Move, " " = Transfer, "B" = Blanket)

4. LINE FILE

5. SHIP TO (shipto to be used on new blanket release sales order)

6. HEADER DUE DATE (due date that should be put on the order header. If it is not sent, the due date will default to the current date. Should be in CCYYMMDD format)

XOR746 7045 - Updates part location Description
ORD748 7048 - Description Description
ORD888 7050 - Description Description
ORD107 7060 - Create and update an invoice batch for all shipments in open invoice status for an order Parameters:

0) Order Number

ORD193GI 7070 - Order Entry History Inquiry Parameters:

0. Order

1. Customer

INV060 7100 - update allocations Part Allocation to Sales Order

Parameters:

- 0. "R" - Screenless Mode (this probably is required on 7102/7103?)

- 1. PART-Char(17)

- 2. PART-REV-Char(3)

- 3. LOCN

- 4. QTY-TO-ALLOCATE

- 5. ORDER_NO as LPad(Order_No,"0",7)example "0019750"

- 6. ORDER_LINE as Left(RECORD_NO,3) example "001"

- 7. LOT

- 8. BIN

- 9. HEAT

-10. SERIAL

INV060 7101 - update allocations Part Allocation Delete (UnAllocate)

Parameters:

- 0. "R"

- 1. Part(17)

- 2. Rev(3)

- 3. Location

- 4. Order_No(0000000)

- 5. Line_No(001)

- Possible that the following may be optional to use Lot/Bin/Heat/Serial

- 6. blank (Lot leave blank for Order/line delete)

- 7. blank (Bin leave blank for Order/line delete)

- 8. blank (Heat leave blank for Order/line delete)

- 9. blank (Serial leave blank for Order/line delete)

-10. "D" for delete

INV060 7102 - User Mode Parameters:

0. PART-17

1. PART-REV

2. LOCN

3. LOT

4. BIN

5. HEAT

6. SERIAL

7. ORD-QTY

8. USER

INV060 7103 - Work Order Mode Parameters:

0. PART-17

1. PART-REV

2. LOCN

3. LOT

4. BIN

5. HEAT

6. SERIAL

7. ORD-QTY

8. JOB

9. WO-SUFFIX

10. WO-SEQ

INV304P 7110 - Description Description
INV304P 7111 - Description Description
INV921 7120 - Description No parameters.
INV308P 7130 - Description Parameters: 

0. RunID 

1. All Dates selected (1 is yes, 0 is no) 

2. Beginning Date (ccyymmdd format) 

3. Ending Date (ccyymmdd format) 

4 All Transaction Codes selected (1 is yes, 0 is no) 

5. Transaction Code range filename (can hold more than one range)

INV500GI 7200 - Description Parameters:

0. PART

1. LOCN

2. MODE

PSA040P 8015 - Summary by customer/month report - PSA040P Parameters:

0. Run ID

1. Beginning Date

2. End Date

psa050p 8020 - Profitability by Customer - core preprocessor Description
psa050p 8021 - Profitability by Customer - core preprocessor Description
PSA001P 8100 - Description Description
PSA000P 8101 - Description Description
PSA000P 8102 - Preprocessor for GAB/Crystal for All Sales Analysis in Detail Reports - PSA000P  Parameters:

0. Run ID

1. BI Report ID

2. All Dates Selected

3. Start Date

4. End Date

5. All Parts Selected

6. Part Range File Name

7. All Product Lines Selected

8. Product Line Range File Name

9. All Customers Selected

10. Customer Range File Name

11. All Sales Reps Selected

12. Sales Rep Range File Name

13. All Branches Selected

14. Branch Range File Name

15. All Orders Selected

16. Order Range File Name

17. Ignore Parent Cost

PSA002P 8110 - Description Description
INV502P 8120 - Description Parameters:

0. RUNID

1. ALL-PARTS-SELECTED

2. PART-RANGE-FILENAME

3. ALL-SORT-SELECTED

4. SORT-RANGE-FILENAME

5. ALL-PL-SELECTED

6. PL-RANGE-FILENAME

7. NEG-NET

PSA015P 8130 - Description Parameters:

0. RUNID

1. BI-REPORT-ID

2. ALL-CUST-SELECTED

3. CUST-RANGE-FILENAME

4. ALL-DATES-SELECTED

5. START-DATE

6. END-DATE

7. ALL-STATES-SELECTED

8. STATE-RANGE-FILENAME

9. STATE-TYPE

10. PROGRESS-BILL-FLAG

PSA013P 8140 - Sales Taxes by State report GAB Preprocessor Parameters:

0. RunID 

1. All Dates selected (1 is yes, 0 is no) 

2. Beginning Date (format CCYYMMDD) 

3. Ending Date (format CCYYMMDD) 

4. All States/Zones selected (1 is yes, 0 is no) 

5. State/Zone range filename (can hold more than one range) 

6. VAT instead of Sales Tax (1 is yes, 0 is no)

XPSA13P 8170 - Description Parameters:

0. RUNID

1. START-DATE

2. END-DATE

PSA085P 8180 - Description Parameters:

0. RUNID

1. ALL-CUST-SELECTED

2. CUST-RANGE-FILENAME

3. ALL-DATES-SELECTED

4. START-DATE

5. END-DATE

APPINIT 8200 - Create the initial file dump for the requested data sources and initial load to the CRM App. Multiple data sources may be requested. Parameters:

0. Prospect Flag

"Y" = create file dump for prospects


1. Customer Flag

"Y" = create file dump for customers


2. Ship To Flag

"Y" = create file dump for additional ship to ids


3. Part Flag

"Y" = create file dump for parts and part cross references


4. Quote Flag

Y” create file dump for quote headers and lines


5. Sales Order Flag

"Y" = create file dump for sales order headers, lines, and ship schedules


6. Shipment Flag

"Y" = create file dump for shipment headers, lines, and ship schedules


7. Invoice History Flag

"Y" = create file dump for history headers and lines


8. Work Order Flag

"Y" = create file dump for work order headers and operations as well as work order to sales order cross references

ARHSTPP 8300 - Description Parameters:

0. RUNID

1. START-DATE

2. END-DATE

3. ALL-DATES-SELECTED

4. ALL-CUSTS-SELECTED

5. CUST-RANGE-FILENAME

OPTCHG 9000 - Description Parameters:

0. Option ID

1. Option sequence

2. Option value

OLL304W 9200 - Log a passed employee into a Work Order Operation on the Shop Floor Parameters:

0. Work Order

1. Work Order Suffix

2. Work Order Sequence

3. Work Center

4. Employee

OLL304W 9201 - Description Description
1SHOTGI 51 - Description Parameters:

Company Code

Program

AR0020GI 100001 - AR / customer Description
PUR064GH 175200 - PO Opens PO 

Params

MODE - O to open 

- N for new 

- D for delete 

- V for view 

- H for view history 

- C for copy 

PO-NUM – The PO selected for V, H, D , or O 

VENDOR-NUM – Only used on new order to skip the vendor selection screen 


ORD880 200801 - sales order generate WO Parameters:

0. FILE-TYPE

"C" - Cycle, "D" - Detail, "O" - Order

1. ORDER

2. LINE

3. LINE FLAG

ORD880 200802 - Sales Order Generate WO - ORD880 Parameters:

0. FILE-TYPE

"C" - Cycle, "D" - Detail, "O" - Order

1. ORDER

2. LINE

3. LINE FLAG

4. GEN WO FLAG

ORD880 200803 - Sales Order Generate WO Parameters:

0. FILE TYPE

1. ORDER

2. LINE

3. LINE FLAG (1=YES, 0=NO)

4. GENERATE WO FLAG (1=YES, 0=NO)

5. DUE-DATE

6. PART

7. ROUTER

8. NO RTR BOM FLAG (1=YES, 0=NO)

9. NO DATE BYPASS FLAG (1=YES, 0=NO)

10. SCREENLESS FLAG (1=YES, 0=NO)

11. PROCESS NO ORD FLAG (1=YES, 0=NO)

12. LOCATION

13. ORD QTY

QTE200 251001 - New Quick quote Parameter:

Quote Number

Customer

JB0075GI 450150 - Reverse Issue material from job Bring Up Reverse Issue Material

PARAMS: 

WO

SUFF

SEQ

DATE CCYYMMDD

TIME HHMMSShh

TRAN-DATE CCYYMMDD

PREV-ISSUE-MADE Send Y to not delete the previous issues that were made in the same thread.

1SHOTGI 500040 - aps3 40 APS 40

No Parameters.

1SHOTGI 500050 - aps3 0 APS 0

No Parameters.

1SHOTGI 500060 - aps3 77 Description
BJ020LZ/LE 900101 - print bar coded work order extended Description
SEC005 100 - Validate User functions Description
ORD876 4100 - Determine customer sales for a specific period Determine customer sales for a specific period

Parameters:

PASS-CUST – Customer number (required)

PASS-BEG-DATE – Beginning invoice date (required)

PASS-END-DATE – Ending invoice data (required)

GROSS – Gross sales in company currency

FREIGHT – Freight in company currency

TAXES – Taxes in company currency

DISCOUNT – Discount amount in company currency (sign reversed from other values)

SHIP-CHRG – Shipping charges in company currency

MATL-SCHRG – Material surcharges in company currency

NET – Net sales in company currency (equal to sum of all other company currency values)

CUR-GROSS – Gross sales in order currency

CUR-FREIGHT – Freight in order currency

CUR-TAXES – Taxes in order currency

CUR-DISCOUNT – Discount amount in order currency (sign reversed from other values)

CUR-SHIP-CHRG – Shipping charges in order currency

CUR-MATL-SCHRG – Material surcharges in order currency

CUR-NET – Net sales in order currency (equal to sum of all other order currency values)

ORD877 4110 - Update external order discount on all quotes or orders for a customer Update external order discount on all quotes or orders for a customer

Parameters:

FILE-TYPE – Designate what file to update (required)

       O:      Orders
       Q:      Quotes

PASS-CUST – Customer number (required)

Passed parameters to callwrapper:

RPT-ID – The crystal report id

HDG-FLG – Include heading row in response files

0 = Not requested

1 = Requested


OPT01-FLG – Calls module to calculate totals without tax detail

0 = Not requested

1 = Requested


OPT02-FLG – Calls module to calculate totals and return tax detail

0 = Not requested

1 = Requested


Options 03 through 99 are not currently supported


Order Header Request File Columns:

SOURCE TABLE – The table to use to fulfill the request

Q = Quotes

O = Sales orders

D = Detail billing orders

S = Shipments

H = Invoice History


ORDER – The 7 digit order number (always required)

SEQUENCE – The 4 digit shipment sequence (required for shipments and invoice history)

INVOICE – The 6 digit invoice number (only required for invoice history)


Order header response columns:

SOURCE TABLE – The table to use to fulfill the request

Q = Quotes

O = Sales orders

D = Detail billing orders

S = Shipments

H = Invoice History

ORDER – The 7 digit order number (always required)

SEQUENCE – The 4 digit shipment sequence (required for shipments and invoice history)

INVOICE – The 6 digit invoice number (only required for invoice history)

STATUS – Status of the module request for this entry (0 is successful, 1 is failed)

CMP-GROSS – Company currency gross order total

CMP-FRT – Company currency freight amount

CMP-TAXES – Company currency total tax amount

CMP-DISC – Company currency total discount amount

CMP-NET – Company currency net order total

ORD-GROSS – Order currency gross order total

ORD-FRT – Order currency freight amount

ORD-TAXES – Order currency total tax amount

ORD-DISC – Order currrency total discount amount

ORD-NET – Order currency net order total

PROFIT – Percent profit on order total

FRT-COST – Company currency freight cost

TAX-CTR – Number of tax authorities (also number of tax detail records returned)

WEIGHT – Total net weight (not provided for invoice history)

COST – Company currency total cost (not provided for invoice history)

CMP-PRCCLS-DISC – Company currency total price class discount (invoice history only)

CMP-PRDLN-DISC – Company currency total product line discount (invoice history only)

CMP-ORDER-DISC – Company currency total order discount (invoice history only)

ORD-PRCCLS-DISC – Order currency total price class discount (invoice history only)

ORD-PRDLN-DISC – Order currency total product line discount (invoice history only)

ORD-ORDER-DISC – Order currency total order discount (invoice history only)

STD-LINE-CTR – Lines excluding freight, progress bill, and material surcharge (invoice history only)

CMP-MATL-SCHRG – Company currency total material surcharges (invoice history only)

CMP-SHIP-CHRG – Company currency total shipping charges (invoice history only)

ORD-MATL-SCHRG – Order currency total material surcharges (invoice history only)

ORD-SHIP-CHRG – Order currency total shipping charges (invoice history only)


Order header tax detail response columns:

SOURCE TABLE – The table to use to fulfill the request

Q = Quotes

O = Sales orders

D = Detail billing orders

S = Shipments

H = Invoice History

ORDER – The 7 digit order number (always required)

SEQUENCE – The 4 digit shipment sequence (required for shipments and invoice history)

INVOICE – The 6 digit invoice number (only required for invoice history)

TAX-CD – Tax authority code

TAX-DESC – Tax description

TAX-RATE – Tax rate

CMP-TAX-AMT – Company currency total tax amount

CMP-TAXABLE – Company currency total taxable amount

ORD-TAX-AMT – Order currency total tax amount

ORD-TAXABLE – Order currency total taxable amount


The core program sets the RETURN variable to one of the following values:

00 = Successful

01 = Passed parameter error

23 = No order header request records found

35 = File error

99 = Cancel

AR0020GI 100000 - AR / customer Launch customer master

Parameters: mode, customer/prospect switch, customer number

Modes available: F, O, N, D, V, and E

Customer/prospect switch: P for prospect, *!*ZDR*!* for customer

AR0026B 100050 - customer notes Customer note maintenance

Parameters: customer number, customer/prospect switch

ORD064GM 100100 - Description Add a ship-to to a customer

Parameters: customer number

AR0170GI 100200- view open AR View open AR

Parameters: customer number

PUR021GI 175000 - vendor quotes Vendor Quotes

Parameters: part number (full 20)

PURA64GI 175100 - Generate PO Generate PO From File

Parameter: 

FILE-NAME

AUTO-NUMBER-FLAG: Y or N

ADD-COMMENTS-FLAG: Y or N

OPEN-PO-FLAG: Y or N


Tab Delimited File Layout:

VENDOR, PART, LOCN, DUE DATE, DESC, INV UM, INV-COST, INV QTY, PO UM, PO COST, PO QTY, GL ACCT, EXTENSION

ORD201 200050 - open sales order line Delete Sales Order Line

Parameters: Order, Line, Terminal

ORD201 200051 - view sales order line Description
ORD803 200060 - sales order total Description
ORD602 200070 - sales order delete payment Description
QL3060 200700- reprint invoice Sales order history by invoice

Parameters: invoice number

ORD880 200800- sales order generate WO Create WO from Sales Order

The new program will generate work orders for every sales order line that doesn't have one already

Parameters: Type, OrderNumber

Valid Types: C - Cycle, D - Detail, O - Order

QL3060 200900- reprint invoice (screenless) Description
QL3060 200905- reprint credit memo (screenless) Description
SHP150 201000 - Quick Ship Simple 1 order 1 bin Description
ORD503GI 202000 - part history by customer and part Part history by customer and part

Parameters: customer number, part/rev, location, hide cost switch

Hide cost switch: Y to hide costs, N to show costs

ORD0FRT 203000- freight maint Description
ORDUSRT 203100 - Launchs User Value Table Maint For Sales Orders User Value Table Maint For Sales Orders

Parameter: Header/Line Flag,User Field 1 Label,User Field 2 Label, User Field 3 Label, User Field 4 Label, User Field 5 Label, Mode

Valid Header/Line Flag: H or L for header or line 

Valid Sync Flag Values: A to maintain the user field apply table or V for normal mode

This will launch the user field maintenance tables for sales orders.

QL1000 205000 - warranty Warranty

Parameters: customer number

QL2002 251100 - New RMA New RMA

Parameters: 

Invoice

Order Order Sequence

QTE504 201500- quote history by part Description
INVMAIN 300000- inventory maint/view Inventory maintenance/view

Parameters: mode, part/rev, loc

Mode: N, C, D, V, O, L, E, P and X are valid

INV455 300050- part price Contract Part Pricing

Parameters: Part (including Rev), Loc, Description, Uses Rev

Mode: Uses Rev should be "Y" if true

LOT155GI 300060- Updates Item master for issued parts Updates Item Master For Issued Parts

Parameter: PART, LOCATION, QTY-ISSUE, SEQ, ORDER, TAB DELIMITED FILE

Tab Delimited File Layout:

Lot, Bin, Heat, Serial and Quantity

INV756 300070- Updates Inventory Usage Updates Inventory Usage

Parameter: Beginning Month, Beginning Year, End Month, End Year

LOT054GI 300080- Show bin to bin transfer screen Show bin to bin transfer screen with part selected

Parameter: Part, Bin, Single Update Mode (Y for the screen to close after first update)

BM0048 410000- Export BOM From TAB File Description
WOQUERY 450000- work orders query Work order query

Parameters: mode, work order number, suffix, active/history switch

Mode: 0 - 8 are valid

Active/history switch: A for active, H for history

450000 - Work order query

Valid Modes:

1 select work order 

2 chose work order by customer 

3 chose work order by PO 

4 chose work order by user code 

5 chose work order by work order discount 

6 chose work order by part 

7 show specific work order 

8 show specific work order without cost 

9 show specific work order without labor dollars

WIR100 450100- ISsue material to Job from file Issue Material to Job From File

Parameters: 

File

File Layout:

PART Length(20)

REV Length(03)

LOCN Length(02)

QTY Length(16)

LOT Length(15)

BIN Length(06)

HEAT Length(15)

SERIAL Length(30)

WO-NUM Length(6)

WO-SUF Length(3)

WO-SEQ Length(6)


WIR100/T 450101- ISsue material to Job from file Issue Material to Job From File

Parameters: 

File


File Layout:

PART Length(20)

REV Length(03)

LOCN Length(02)

QTY Length(16)

LOT Length(15)

BIN Length(06)

HEAT Length(15)

SERIAL Length(30)

WO-NUM Length(6)

WO-SUF Length(3)

WO-SEQ Length(6)

This is the same as mode 450100, except the file should be tab-delimited, instead of comma-delmited.

SQLGSLOD 500000- Download Scheduling Files APS Scheduling information download

Parameter: Mode, Default Date(CCYYMMDD), ReRead-Lead-Flag

Valid Modes: 

- Blank to accept input 

- SP for show progress (progress will be displayed, and window will close when finished) 

- SI for silent, no visible screens 


Valid ReRead-Lead-Flags:

- 1: The reread for lead time when zero box is checked 

- 2: The reread for lead time when zero on seq is checked 

- 3: Both checkboxes are checked

JB0011CL 500030- APS3 Schedule Job Schedule Job

Parameters:

START-DATE- a number with the format of YYMMDD 

DUE-DATE- a number with the format of YYMMDD 

WO 

SUFFIX 

SEQ 

SCHEDULE -a flag with the following values 

F: Forward Schedule 

B: Backward Schedule 

H: Scheduling from Current Sequence


HOOK02 600000 - Activate hook Activate/Inactivate Hook 

Parameter: Hook, Hook Active, Hook Description, Script, Sync Flag

Valid Hook Active Values: A for active N for inactive

Valid Sync Flag Values: A to be asynchronous or S to be synchronous

This will add the script as a new sequence for the hook number passed.

HOOK02 600001- Activate hook w/ widget Description
HOOK02 600002- Activate hook w/ widget and runtime Activate/Inactivate Hook 

Parameters:

0. Hook

1. Hook Active ("A" for active, "N" for inactive)

2. Hook Description

3. Script

4. Sync Flag ("A" to be asynchronous, "S" to be synchronous)

5. Widget ("1" for Widget, "0" for Normal)

6. Runtime Version ("1.00" or "2.00")

This will add the script as a new sequence for the hook number passed.

OPTINST 700000- Initiliizes company options (Internal use ONLY!) Description
OPTINST 700001- Initiliizes company options (Internal use ONLY!) Description
PR0805 700100- Checks if user has access to pass- pay group Checks if active user has access to pay group 

Parameters:

Pay Group


Return Parameters:

RETURN 

00: Successful 

04: Read Failed 

35: Unsuccessful 

RET-SECURITY 

Y: Has security 

N: No security 

JB0053 900200- print work order pick list Print work order pick list

Parameters: starting work order number, starting work order suffix, ending work order number, ending work order suffix

ORD175 910040- Order Booking Report Print Order Bookings 

Parameters: 

Begin Date - MMDDYY format for the start date 

End Date - MMDDYY format for the end date 

Switch - B (Build Data No Preview) L (Runs Report ID 72)

All - Set to Y to use no criteria 

Stamp Date - Used when switch is B an written to the BIBK file for all records 

Stamp Time - Used when switch is B an written to the BIBK file for all records

ORD0ACKN 910050- print sales order Order Number

Mode (P)

Ack Title

SHP300 910060- print BOL Description
SHP205 910070 - Printing packing list INVOICE-NO Can use invoice, order & seq, or pck-no

ORDER Can use invoice, order & seq, or pck-no

SEQ Can use invoice, order & seq, or pck-no

SUPPRESS-DATE Set to “Y” to hide the due date

SUPPRESS-CNDN Set to “Y” to bypass Customs Invoice

LABELS-ONLY Set to “Y” to only print labels

NO-SCREENS Set to “Y” to bypass user input

PCK-NO Can use invoice, order & seq, or pck-no

QKPRT-NAME File name of a btrieve file that contains the PCK-NO and order of the shipments to be printed

SHIP-DATE CCYYMMDD

ORD054/C 910100- print sales order pick list Print sales order pick list

Parameters: sales order number

ORD054 910200- print sales order pick list more opitons Print Sales Order Pick Lists

Parameter: Order, Last Order, All Orders Flag(Set to Y to print all orders),Start Date(CCYYMMDD),End Date (CCYYMMDD), All Dates Flag (Set to Y to print all dates)

ORD055 910201- print shipment pick list more opitons Print shipment pick list

PARAMS:

ORDER 

LAST-ORDER 

ALL-ORDERS-FLAG 

- “Y”: Select all orders 

START-DATE 

END-DATE 

ALL-DATES-FLAG 

- “Y”: Select all dates

QTL010 915000- print quote print PO
                       "PUR1LZ/I" 

Purchasing>Reports>Purchase Orders

Purchase Order Number

Switch

S- Screenless

Screenless History Flag

Print Open Qty Flag

Use Vendor Currency Flag

QTL010 920000- print quote Print Quote

  Estimating/Routing & Quote Management>Reports>Quotes

JB032BGI 930000- build payroll report table. Start Date

End Date

Process By

Starting

Ending

Print

Page Flag

Excl Absences

Empl By

XJB120G 990000- Description Description

Example

F.Intrinsic.Control.If(V.Local.sQuoteText.Trim,<>,"")
	F.Intrinsic.String.Concat(V.Caller.FilesDir,"\QUOTE.TXT",V.Local.sParam)
	F.Intrinsic.File.String2File(V.Local.sParam,V.Local.sQuoteText)
	F.Intrinsic.File.Exists(V.Local.sParam,V.Local.bExist)
	F.Intrinsic.Control.If(V.Local.bExist,=,True)
		F.Global.General.CallWrapperSync(6002,"NS!*!52")
	F.Intrinsic.Control.EndIf
F.Intrinsic.Control.EndIf

Remarks

  • This applies to:

Function.Global.General.CallWrapperAsync

Function.Global.General.CallWrapperSync

  • This command requires you to be on the current version of Global Shop
  • Parameters are delimited with !*!
  • Blank parameters should be denoted as *!*ZDR*!*
  • Parameters must have leading zeroes, when appropriate.
  • Due to the way data is stored in the background, only a single instance of each wrapper may be active at any given time.
  • Variable.Ambient.CallWrapperReturn returns the information for the program called using the callwrapper