This DDE transport protocol downloads Glaxo Transaction data onto the PC's hard disc for later processing by the PC's Glaxo Agency System Package (GASP). At monthend, the protocol uploads to the Host any Glaxo settlement discounts calculated by the GASP.
“DOPE” is an alias for the “GAS” protocol.
The protocol is enabled/disabled on the PC by the /D switch on the MS-DOS command line when starting GO.EXE.
PIC X(4) | DDE Protocol Identifier: VALUE “GAS ” |
---|
PIC X | Software Platform: VALUE “C” to use COBOL conventions. VALUE “M” to use Machine Code conventions |
---|---|
PIC XX | Software Schema: VALUE “1” if Version 1. VALUE “E” if Emergency mode (disable format checking). |
Each Data Block comprises a single record as defined in the Glaxo Agents' Programming Specification (version 2). The first byte indicates the Record Type:
Associated Sales Data Header, Lines and Trailer records must be transferred consecutively. A Stock Header must precede any Stock Item records. Prior to and during any stock reconciliation transfer, the Host must ensure that no invoices/credits are awaiting processing and that all Glaxo goods received notes have been processed. Any Glaxo items in transit (not yet received) at the instant of reconciliation must subsequently also be loaded onto the standalone PC system as these must be included in the reconciliation data despatched to Glaxo.
Where a COBOL platform is specified, record layouts match the TRANSFER file formats. All numeric fields are to be zero filled and right justified, the decimal point is never to be presented. All alphanumeric fields are to be left justified and space filled. Do not append the CR LF.
A Machine Code platform follows the COBOL rules, except that Name, Address and Post Code are moved to the end of the record and are presented in the traditional format (variable length lines with separators) prefixed by the separator (CR, LF or “~”).
PIC XX | VALUE("MD") |
---|---|
PIC X(17) | Customer Account Number |
PIC 9(13)V99 | Settlement Discount Amount |
A single Monthend Discount frame is sent for each Customer Account with non-zero Settlement Discount amount.
PIC XX | VALUE("MT") |
---|
A single Monthend Trailer frame is sent after the last Monthend Discount frame.
PIC X(17) | Agent's Customer Code |
---|---|
PIC 9(13)V99 | Settlement Discount Amount |
PIC X | VALUE “A” |
---|---|
PIC X(17 | Agent's Customer Code |
PIC X(35) | Name |
PIC X(35) | Address Line 1 |
PIC X(35) | Address Line 2 |
PIC X(35) | Address Line 3 |
PIC X(35) | Address Line 4 |
PIC X(8) | Post Code |
PIC 99 | Customer Category |
PIC X(35) | Serial Number |
PIC XXX | Transaction Code (“INV” or “CRE”) |
PIC 9(6) | Transaction Date (YYMMDD) |
PIC X | VALUE “L” |
---|---|
PIC X(35) | Original Serial Number (if Back Order Invoice) |
PIC 9(9) | Agent's Product Code |
PIC 9(15) | Quantity |
PIC 9(13)V99 | Value at List (Trade) Price |
PIC 9(13)V99 | Invoice Line Value |
PIC 9(4)V999 | VAT Rate % |
PIC X | VALUE “T” |
---|---|
PIC 9(4)V999 | VAT Code 3 Rate % |
PIC 9(13)V99 | VAT Code 3 VAT Value |
PIC 9(13)V99 | VAT Code 3 Goods Value |
PIC 9(4)V999 | VAT Code 4 Rate % |
PIC 9(13)V99 | VAT Code 4 VAT Value |
PIC 9(13)V99 | VAT Code 4 Goods Value |
PIC 9(4)V999 | VAT Code 5 Rate % |
PIC 9(13)V99 | VAT Code 5 VAT Value |
PIC 9(13)V99 | VAT Code 5 Goods Value |
PIC X | VALUE “B” |
---|---|
PIC 9(6) | Date (YYMMDD) |
PIC X | VALUE “S” |
---|---|
PIC 9(9) | Agent's Product Code |
PIC 9(15) | Stock Level |
PIC 9(13)V99 | List (Trade) Price |
PIC X | VALUE “C” |
---|---|
PIC X(17) | Agent's Customer Code |
PIC X(35) | Name |
PIC X(35) | Address Line 1 |
PIC X(35) | Address Line 2 |
PIC X(35) | Address Line 3 |
PIC X(35) | Address Line 4 |
PIC X(8) | Post Code |
PIC 9(13)V99 | VAT Code 3 List Price Value |
PIC 9(13)V99 | VAT Code 3 Rebate Value |
PIC 9(4)V999 | VAT Code 3 Rate % |
PIC 9(13)V99 | VAT Code 3 VAT Value |
PIC 9(13)V99 | VAT Code 4 List Price Value |
PIC 9(13)V99 | VAT Code 4 Rebate Value |
PIC 9(4)V999 | VAT Code 4 Rate % |
PIC 9(13)V99 | VAT Code 4 VAT Value |
PIC 9(13)V99 | VAT Code 5 List Price Value |
PIC 9(13)V99 | VAT Code 5 Rebate Value |
PIC 9(4)V999 | VAT Code 5 Rate % |
PIC 9(13)V99 | VAT Code 5 VAT Value |