Invoice documents (headers)

Sorting Limitations: When using fields longer than 10 chars, the extension tests will only work on the first 10 characters.  The sort key maximum length is 150 characters, that is, the sum of the lengths of fields used for one sort code must be less or equal to 150 chars.

TMSDS/SORT-IHA Sort Key Invoice Header Sequence

This Control File defines different groups of documents that can have sort sequences (specified in SORT-IHB). Different sort sequences for invoice documents (or sort codes) can be defined by any or a combination of codes.

Document types:

DPRNT – Document Print Run Type

N = Normal document generation (immediate or batch print via DSO135)

M = Mailing copy of document via EOD batch program (proper invoice).

F = Filing copy of document via EOD batch program.

Reprint of document will set the document run type via the ‘which part option – normal = N, invoice only = M

STTY – Stationery: uses TMSDS/CM-STTY

DT – Document Type: uses TMSDS/TR-DT

DST – Document Subtype: uses TMSDS/TR-DST

PCKM – Picking Method: uses TMSDS/TR-PCKM

SRCT – Source of Transaction TMSDS/TR-SRCT.

TOS – Type of Sale uses control file TMSDS/TR-TOS.

TMSDS/SORT-IHB Sort Key Invoice Header Definition

This Control File sorts key invoice header definitions. It allows the definition of document sort sequences by field name for each sort code defined in SORT-IHA.  As well as set fields relating to document headers, user defined fields can also be used to sort documents – these are called Extension fields.  Extension fields are identified with an asterisk prefix.  The contents of an Extension field are described by formulas setup in SORT-IHC.

Sort code: this is the sort code.  This code tells the system how the invoices are to be sorted.

Sequence: this is the sequence in which the fields are to be displayed on the screen.

Field name or Extension name: this is the field or extension name.

They can include the following.

BDXSTA – Delivery DX State

BDXLOC – Delivery DX Location

BDXNO – DX Billing Number

DDXLOC – DX Billing Location

DT – Document type

DOCN – Document Number

PN – Process Number

Input String – From: this is the number it starts from.

Input String – Length: this is the length of the input string.

TMSDS/SORT-IHC Sort Key Invoice Header Definition Extensions

This Control File sorts invoice header definition extensions. It is used to define sort “Extension” fields which are like user defined sort fields.  SORT-IHC uses the same valid fields as SORT-IHB (except those marked #).  An “extension” formula can consist of many rules.

An example is: an invoice print run is required to be sorted by say Branch, but NOT alphabetically.  The documents (for whatever reason) must print in the following branch sequence: 04,01,03,02.  Within each branch the documents are then to be sorted by Customer number, then by Document number for each customer. In this example SORT-IHB must be setup with Sort Code INV and in Extension the first Seq must be and Extension name e.g. *Branch, the second sequence will be the field CN and the third sequence will be the field DOCN.  In SORT-IHC the Extension is repeated 4 times with the same field name of BR and the for the Condition of EQ the From column must have 04 for sequence 001, 01 for sequence 002, 03 for sequence 003 and 02 for sequence 004.

The contents of the “extension” field *BRANCH in SORT-IHB will be the Result value of the above condition as executed for each document.

Note: The condition RG (range) uses the From and To fields, the other conditions use only From.

Invoice lines (details)

TMSDS/SORT-IDA Sort Key Invoice Detail Sequence

This Control File defines different groups of documents that can have different sort sequences (specified in SORT-IDB) for the document detail lines.  Different sort sequences (or sort codes) for document detail lines can be defined by any or a combination of Document Types.

Document types:

* DPRNT – Document Print Run Type this is a new field added to the file.  The value in this field will come from DSO136 (Doc Print workfile generation) and be one of the following codes depending on the origin of the document print run.  The code indicates to the print program what type of document print to print:

N = Normal document generation (immediate or batch print via DSO135) where a normal print will generate either a delivery docket type invoice or a real invoice depending on the customer.

M = Mailing copy of document via EOD batch program (proper invoice).

F = Filing copy of document via EOD batch program.

Reprint of document will set the document run type via the ‘which part option – normal = N, invoice only = M

* STTY – Stationery: uses Control File TMSDS/CM-STTY

* DT – Document Type: uses Control File TMSDS/TR-DT

* DST – Document Subtype: uses Control File TMSDS/TR-DST

* PCKM – Picking Method: uses Control File TMSDS/TR-PCKM

* SRCT – Source of Transaction TMSDS/TR-SRCT.

* TOS – Type of Sale: uses Control File TMSDS/TR-TOS.

TMSDS/SORT-IDB Sort Key Invoice Detail Definition

This Control File allows the definition of invoice detail line sorting by field name for each sort code defined in SORT-IDA.  As well as set fields relating to invoice line items, user defined fields can also be used to sort the lines – these are called Extension fields.  Extension fields are identified with an asterisk prefix.  The contents of an Extension field are described by formulas setup in the SORT-IDC.  The concept of Extensions is the same for document header and document detail sorting.  See the example described in SORT-IHC text for further information.

Field name or Extension name: this is the field or extension name.

They can include the following.

CREF – customer reference

LNO – line number

SLNO – sub line number.

Input String – From: this is the number it starts from.

Input String – Length: this is the length of the input string.

In order to use / sort invoices by billing number, the field BN Billing number is now added to this control file.

TMSDS/SORT-IDC Sort Key Invoice Detail Definition Extensions

This Control File is used to define sort “Extension” fields which are like user defined sort fields.  SORT-IDC uses the same valid fields as SORT-IDB listed above (except those marked #). The concept of Extensions is the same for document header and document detail sorting. Refer to the example in SORT-IHC text for more information.

Picking slips (headers)

TMSDS/SORT-PHA Sort Key Picking Slip Header Sequence

This control file defines different groups of picking slips that can have different sort sequences (specified in SORT-PHB).  Different sort sequences (or ‘sort codes’) for picking slips can be defined by any or a combination of the following codes.

 * STTY – Stationery: uses TMSDS/CM-STTY

 * DT – Document Type: uses TMSDS/TR-DT

 * DST – Document Subtype: uses TMSDS/TR-DST

 * PCKM – Picking Method: uses TMSDS/TR-PCKM

 * TOS – Type of Sale TMSDS/TR-TOS

TMSDS/SORT-PHB Sort Key Picking Slip Header Definition

This control file defines picking slip sort sequences by field name for each sort code defined in SORT-PHA.  As well as set fields relating to picking slip headers, user defined fields can also be used to sort picking slips – these are called Extension fields.

Extension fields are identified with an asterisk prefix.  The contents of an Extension field are described by formulas setup in SORT-PHC. The concept of Extensions is the same as it is for document sorting.  See the previous example under the SORT-IHC control file description for document sorting for further information.

The following fields can be used to sort picking slips.

PCKM – Picking Method

PSN – Picking Slip Number

PN – Process Number

ORDP – Order Priority

WZNE – Warehouse Zone

LOC – Location

CAR – Carrier

CN – Customer Number

OCNM – Order Customer Name

OAD5 – Order Address 5 (post code)

BR – Branch

NOL – No lines on picking slip

DLVQ – Total delivery quantity

TMSDS/SORT-PHC Sort Key Picking Slip Header Definition Extensions

This Control file is used to define sort ‘Extension’ fields which are like user defined sort fields. SORT-PHC uses the same valid fields as SORT-PHB listed above.  The concept of picking slip Extension fields is the same as it is for document sorting.  Refer to the example in the text of SORT-IHC for more information.

Picking slip lines (details)

This Control File defines different groups of picking slips that can have different sort sequences (specified in TMSDS/SORT-PDB) for the picking slip detail lines.  Different sort sequences (or sort codes) for picking slip detail lines can be defined by any or a combination of codes which can include the following.

* STTY – Stationery: uses TMSDS/CM-STTY

* DT – Document Type: uses TMSDS/TR-DT

* DST – Document Subtype: uses TMSDS/TR-DST

* PCKM – Picking Method: uses TMSDS/TR-PCKM

* SRCT – Source of Transaction: uses TMSDS/TR-SRCT.

* TOS – Type of Sale: uses TMSDS/TR-TOS

TMSDS/SORT-PDB Sort Key Picking Slip Detail Definition

This Control File allows the definition of picking slip detail line sorting by field name for each sort code defined in SORT-PDA. As well as set fields relating to picking slip line items, user defined fields can also be used to sort the lines – these are called Extension fields. Extension fields are identified with an asterisk prefix. The contents of an Extension field are described by formulas set up in SORT-PDC. The concept of Extensions is the same as it is for document detail sorting. Refer to the example in the text of SORT-IHC for more information.

The following fields can be used to sort picking slip detail lines.

I          Item                                     SLNO     Sub line number 

ILEXT Item location extension        PKLN     Picking line number

IDSC  Item description                    LOC       Location

IEDC  Item extended description    WZNE    Warehouse zone

IBCD  Item barcode                        PKG        Packaging(binding)

CLS   Class (IL1)                            PACK      Pack system identifier

DIV    Division (IL2)                         CTNQ     Carton quantity 

GRP   Group (IL3)                          SLTQTY  Selected quantity

CAT   Category (IL4)                      PCKSEQ  Pick sequence

SCT   Sub category (IL5)                PN            Process number

LNO   Line number

TMSDS/SORT-PDC Sort Key Picking Slip Detail Definition Extensions

This control file is used to define sort “Extension” fields which are like user defined sort fields. SORT-PDC uses the same valid fields as SORT-PDB. The concept of picking slip Extension fields is the same as it is for document sorting.  See the previous example under the SORT-IHC Control File description for further information.