8.4.3 Record definition

The record definition comes right after the statement header.

If the import file only contains one record type (LAYOUT = SINGLE_REC) the record is not given a name.

[IMPORT::O]

Transformation

  

   TRANSFORM=#7;A:10;B:20;C:30;OTHERWISE:40;

 

!     Field  Type    Default             Offset  Length  R  Description

!     -----  ------  ---------------     ------  ------  -  -------------------

      #1    ;CHAR   ;""                 ;1029   ;1    ; "O" EXRTYP  Record type

      #2    ;CHAR   ;""                 ;9      ;12   ;     COHPEG  Peg ID

      #3    ;CHAR   ;"NULL:ERROR"       ;113    ;25   ;     COHITM  Item number

If the import file contains more than one record type (LAYOUT = MULTI_REC) record definitions are separated by a name.

[IMPORT]

   ID=#1

   [O]

!     Field  Type    Default             Offset  Length  R  Description

!     -----  ------  ---------------     ------  ------  -  -------------------

      #1    ;CHAR   ;                   ;1029   ;1    ; "O" EXRTYP  Record type

      #2    ;CHAR   ;                   ;9      ;12   ;     COHPEG  Peg ID

      #3    ;CHAR   ;NULL:ERROR         ;113    ;25   ;     COHITM  Item number

      #4    ;LONG   ;NULL:ERROR         ;8      ;     ;     MOHMRP  Order number

!   O's definition follows on.

 

 

   [R]

   TRANSFORM=#7;A:10;B:20;C:30;OTHERWISE:40;

!     Field  Type    Default             Offset  Length  R  Description

!     -----  ------  ---------------     ------  ------  -  -------------------

      #1    ;CHAR   ;                   ;1029   ;1    ; "R" EXRTYP  Record type

      #2    ;CHAR   ;                   ;1071   ;12   ;     CXRPEG  Peg ID

      #3    ;CHAR   ;NULL:ERROR         ;1030   ;25   ;     CXRITM  Item number

      #4    ;LONG   ;NULL:ERROR         ;257    ;     ;     MXRMRP  Order number

!   R's definition follows on.

 

 

   [M]

!     Field  Type    Default             Offset  Length  R  Description

!     -----  ------  ---------------     ------  ------  -  -------------------

      #1    ;CHAR   ;                   ;1029   ;1    ; "M" EXRTYP  Record type

      #3    ;CHAR   ;NULL:ERROR         ;65     ;25   ;     CRSPIT  Parent item number

      #4    ;LONG   ;NULL:ERROR         ;14     ;     ;     MRSPON  Parent order number

!   M's definition follows on.

 

 

   [N]

!     Field  Type    Default             Offset  Length  R  Description

!     -----  ------  ---------------     ------  ------  -  -------------------

      #1    ;CHAR   ;                   ;1029   ;1    ; "N" EXRTYP  Record type

      #3    ;CHAR   ;NULL:ERROR         ;65     ;25   ;     CRSPIT  Parent item number

      #4    ;LONG   ;NULL:ERROR         ;14     ;     ;     MRSPON  Parent order number

!   N's definition follows on.

 

 

   [H]                               

!     Field  Type    Default             Offset  Length  R  Description

!     -----  ------  ---------------     ------  ------  -  -------------------

      #1    ;CHAR   ;                   ;1029   ;1    ; "H" EXRTYP  Record type

      #2    ;CHAR   ;                   ;158    ;12   ;     CCOPEG  Peg ID

      #3    ;DATE   ;                   ;2      ;     ;     MCOEDD  Earliest order line

!   H's definition follows on.

Transformation

To transform field contents, use the TRANSFORM variable when you import or export data. This variable must be placed immediately before the field defining the actual record.

Example:

[IMPORT]

   ID=#1

   [R]

   TRANSFORM=#5;A:10;B:20;C:30;OTHERWISE:40;

!     Field  Type    Default             Offset  Length  R  Description

!     -----  ------  ---------------     ------  ------  -  -------------------

      #1    ;CHAR   ;                   ;1029   ;1    ; "R" EXRTYP  Record type

      #2    ;CHAR   ;                   ;1071   ;12   ;     CXRPEG  Peg ID

      #3    ;CHAR   ;NULL:ERROR         ;1030   ;25   ;     CXRITM  Item number

      #4    ;LONG   ;NULL:ERROR         ;257    ;     ;     MXRMRP  Order number

      #5    ;LONG   ;NULL:ERROR         ;9      ;     ;     MOPNUM  Operation number

The value in field 5 is transformed in this way:
Old value Transformed value
A 10
B 20
C 30
Others 40

OTHERWISE transforms all values different from A, B and C to 40. OTHERWISE does not must be used.

If you also want to transform back again when the data is exported, you must add reverse transformations as follows.

TRANSFORM=#5;10:A;20:B;30:C;OTHERWISE:D;

Record name

The record name defines the type of record. The options are:
  • O (order header)
  • R (operation)
  • M/N (material)
  • H (end item)