SeanHoppe.com > ERP > VAI/S2K > Amazon.com Outbound 753 > Field Mappings

Cleo/VAI :: Amazon.com Outbound 753-- Field Mappings

  CLEO Integrator                        Message class format fields           
                                                                                                                          MMFPF3R
 Message ID . . . . . . :   753        Message class  :   O753_AMZN   Amazon.com Outbound Routing Request
 Message class status . :   d          Direction  . . :   S  Send
 Standard class . . . . :   X          Industry group :   X           Version-release :   004030
 Application file set . :   VAI753S
 File name  Format     K Field      Seq Field text                Typ Len   Start Dgt Dec S/D Misc  Sub Clr Trn Edit Qual Code table
 Frml inst  Formula      Parm
 VEDRTL     EDRTLR       RTLAFS       1 Application File Set/AFS/  A     10   236
 VEDRTL     EDRTLR       RTLCDAT      1 CREATION DATE              S      8    47   8   0
 VEDRTL     EDRTLR       RTLCLOC      1 CONSOLIDATED LOCATION      A      7    32
 VEDRTL     EDRTLR       RTLCLOE      1 CONSOLIDATOR               A     17   119
 VEDRTL     EDRTLR       RTLCMP       1 Company No.                S      3     8   3   0
 VEDRTL     EDRTLR       RTLCTL       1 SHIPPING CONTROL #         S      7     1   7   0
 VEDRTL     EDRTLR       RTLCUST      1 Customer No.               A      7    11
 VEDRTL     EDRTLR       RTLDSTC      1 DISTRIBUTION CENTER        A      7    25
 VEDRTL     EDRTLR       RTLDSTE      1 DISTRIBUTION CENTER        A     17   102
 VEDRTL     EDRTLR       RTLEDOC      1 Mailbox #/Message Log#     A     10   226
 VEDRTL     EDRTLR       RTLEDPF      1 Processed Flag             A      1   246
 VEDRTL     EDRTLR       RTLPRID      1 Trading Partner Id         A     15   186
 VEDRTL     EDRTLR       RTLPRQL      1 Trading Partner QL         A     25   201
 VEDRTL     EDRTLR       RTLSDAT      1 SHIP DATE                  S      8    39   8   0  D0
 VEDRTL     EDRTLR       RTLSHIP      1 Ship-To No.                A      7    18          D0
 VEDRTL     EDRTLR       RTLSHPE      1 SHIP TO STORE              A     17    85
 VEDRTL     EDRTLR       RTLVND       1 EDI Supplier Number        A     30    55
 VEDRTL     EDRTLR       RTL1101      1 RRC CONTROL #              A     50   136          D0
 VEDRTO     EDRTOR       RTOAFS       1 Application File Set/AFS/  A     10   286
 VEDRTO     EDRTOR       RTOAORB      1 RECORD 1 OR 2              A      1   221
 VEDRTO     EDRTOR       RTOBOCD      1 Backorder Code             S      3    20   3   0
 VEDRTO     EDRTOR       RTOCDAT      1 CREATION DATE              S      8    95   8   0
 VEDRTO     EDRTOR       RTOCLOE      1 CONSOLIDATOR               A     17   154
 VEDRTO     EDRTOR       RTOCMP       1 Company No.                S      3     8   3   0
 VEDRTO     EDRTOR       RTOCPO       1 Customer P.O.              A     20    37          D0
 VEDRTO     EDRTOR       RTOCTL       1 SHIPPING CONTROL #         S      7     1   7   0
 VEDRTO     EDRTOR       RTOCUBE      1 TOTAL CUBES                P      5    82   9   4  D0
 VEDRTO     EDRTOR       RTOCUST      1 Customer No.               A      7    23
 VEDRTO     EDRTOR       RTODSTE      1 DISTRIBUTION CENTER        A     17   120
 VEDRTO     EDRTOR       RTOEDOC      1 Mailbox #/Message Log#     A     10   276
 VEDRTO     EDRTOR       RTOEDPF      1 Processed Flag             A      1   296
 VEDRTO     EDRTOR       RTOGWGH      1 GROSS WEIGHT               P      6    67  11   4  D0
 VEDRTO     EDRTOR       RTOMAPN1     1 MAPPING LOCATION           A      7   222
 VEDRTO     EDRTOR       RTOOIDC      1 OID CONSTANT               A      3   229          D0
 VEDRTO     EDRTOR       RTOOIDQ      1 OID QUANTITY               P      4   232   7   0  D0
 VEDRTO     EDRTOR       RTOORD       1 Order Number               S      9    11   9   0  D0
 VEDRTO     EDRTOR       RTOPCKS      1 TOTAL PACKAGES             P      4    73   7   0
 VEDRTO     EDRTOR       RTOPRID      1 Trading Partner Id         A     15   236
 VEDRTO     EDRTOR       RTOPRQL      1 Trading Partner QL         A     25   251
 VEDRTO     EDRTOR       RTOQTY       1 TOTAL QTY                  P      5    77   9   2
 VEDRTO     EDRTOR       RTOSDAT      1 SHIP DATE                  S      8    87   8   0
 VEDRTO     EDRTOR       RTOSHIP      1 Ship-To No.                A      7    30
 VEDRTO     EDRTOR       RTOSHPE      1 SHIP TO STORE              A     17   103
 VEDRTO     EDRTOR       RTOSHTE      1 EDI SHIP TO LOCATION       A     17   137
 VEDRTO     EDRTOR       RTOTCRT      1 TOTAL CARTONS              P      4    57   7   0
 VEDRTO     EDRTOR       RTOWGHT      1 NET ORDER WEIGHT           P      6    61  11   4
 VEDRTO     EDRTOR       RTO1101      1 RRC CONTROL #              A     50   171
 VEDRTS     EDRTSR       RTSAFS       1 Application File Set/AFS/  A     10   671
 VEDRTS     EDRTSR       RTSCCTD      1 Creation Date              S      8   692   8   0

 File name  Format     K Field      Seq Field text                Typ Len   Start Dgt Dec S/D Misc  Sub Clr Trn Edit Qual Code table
 Frml inst  Formula      Parm
 VEDRTS     EDRTSR       RTSCCTP      1 Creation Pgm               A     10   716
 VEDRTS     EDRTSR       RTSCCTT      1 Creation Time              S      6   700   6   0
 VEDRTS     EDRTSR       RTSCCTU      1 Creation User              A     10   706
 VEDRTS     EDRTSR       RTSCDAT      1 CREATION DATE              S      8   187   8   0  D0
 VEDRTS     EDRTSR       RTSCMP       1 Company No.                S      3     8   3   0
 VEDRTS     EDRTSR       RTSCTL       1 SHIPPING CONTROL #         S      7     1   7   0  D0
 VEDRTS     EDRTSR       RTSCTL       2 SHIPPING CONTROL #         S      7     1   7   0  D0
 VEDRTS     EDRTSR       RTSCUST      1 Customer No.               A      7    11
 VEDRTS     EDRTSR       RTSEDDT      1 Transmission Date          S      8   606   8   0
 VEDRTS     EDRTSR       RTSEDFT      1 Translation Format         A     10   661
 VEDRTS     EDRTSR       RTSEDGC      1 Group Control#             A     10   631
 VEDRTS     EDRTSR       RTSEDIC      1 Interchange Control#       A     10   621
 VEDRTS     EDRTSR       RTSEDOC      1 Mailbox #/Message Log#     A     10   596
 VEDRTS     EDRTSR       RTSEDPF      1 Processed Flag             A      1   691
 VEDRTS     EDRTSR       RTSEDPT      1 Test/Production            A      1   620
 VEDRTS     EDRTSR       RTSEDST      1 Transaction Set 830/DELFO  A     10   651
 VEDRTS     EDRTSR       RTSEDTC      1 Transaction Control#       A     10   641
 VEDRTS     EDRTSR       RTSEDTM      1 Transmission Time          S      6   614   6   0
 VEDRTS     EDRTSR       RTSFAD1      1 Ship From Addr1            A     30    55          D0
 VEDRTS     EDRTSR       RTSFAD2      1 Ship From Addr2            A     30    85          D0
 VEDRTS     EDRTSR       RTSFAD3      1 Ship From Addr2            A     30   115
 VEDRTS     EDRTSR       RTSFCTY      1 Ship From City             A     17   145          D0
 VEDRTS     EDRTSR       RTSFNAM      1 Ship From Name             A     30    25          D0
 VEDRTS     EDRTSR       RTSFST       1 Ship From State            A      2   162          D0
 VEDRTS     EDRTSR       RTSFZP       1 Ship From Zip              A     15   164          D0
 VEDRTS     EDRTSR       RTSGRP       1 Transaction Set Group IN/  A     10   681
 VEDRTS     EDRTSR       RTSGWGH      1 Gross Weight               P      6   250  11   4
 VEDRTS     EDRTSR       RTSLCGD      1 Change Date                S      8   726   8   0
 VEDRTS     EDRTSR       RTSLCGP      1 Change Pgm                 A     10   750
 VEDRTS     EDRTSR       RTSLCGT      1 Change Time                S      6   734   6   0
 VEDRTS     EDRTSR       RTSLCGU      1 Change User                A     10   740
 VEDRTS     EDRTSR       RTSNETW      1 EDI Network ID             A      2   273
 VEDRTS     EDRTSR       RTSPCKS      1 Total Packages             P      4   246   7   0
 VEDRTS     EDRTSR       RTSPRID      1 Trading Partner Id         A     15   556
 VEDRTS     EDRTSR       RTSPRQL      1 Trading Partner QL         A     25   571
 VEDRTS     EDRTSR       RTSSCAC      1 EDI Ship Via /Carrier Des  A     35   205
 VEDRTS     EDRTSR       RTSSDAT      1 SHIP DATE                  S      8   179   8   0
 VEDRTS     EDRTSR       RTSSHTE      1 EDI SHIP TO                A     17   256
 VEDRTS     EDRTSR       RTSSHTO      1 SHIP TO NUMBER             A      7    18
 VEDRTS     EDRTSR       RTSSTIM      1 SHIP TIME                  S      6   195   6   0  D0
 VEDRTS     EDRTSR       RTSVIA       1 Ship VIA Code              A      4   201
 VEDRTS     EDRTSR       RTSVND       1 EDI Supplier Number        A     30   275          D0
 VEDRTS     EDRTSR       RTSWGHT      1 Net Order Weight           P      6   240  11   4
 VEDRTS     EDRTSR       RTS1101      1 RRC CONTROL #              A     50   491
 VEDRTS     EDRTSR       XCCMN1       1 COMMUNICATION 1            A     50   337          D0
 VEDRTS     EDRTSR       XCCMN2       1 COMMUNICATION 3            A     50   389          D0
 VEDRTS     EDRTSR       XCCMN3       1 COMMUNICATION 3            A     50   441          D0
 VEDRTS     EDRTSR       XCCMQ1       1 COMMUNICATION QUAL.1       A      2   335          D0
 VEDRTS     EDRTSR       XCCMQ2       1 COMMUNICATION QUAL.2       A      2   387          D0
 VEDRTS     EDRTSR       XCCMQ3       1 COMMUNICATION QUAL.3       A      2   439          D0
 VEDRTS     EDRTSR       XCCONTC      1 CONTACT PERSON             A     30   305          D0
 VEDRTS     EDRTSR       XCPRID       1 PARTNER INTERNAL ID        A     15   541
 ** End of report **



By: on