List of Keywords

The following list of keywords represents keywords that are currently available.
You may enter new keywords as long as they represent files and fields that are available
for the document being mapped.
------------------------------------------------------------------------------------------------------------------------------------
Keyword  Description                        File-name                          Field-name                         Field-type
------------------------------------------------------------------------------------------------------------------------------------

820REFTR reference# on edi-su-pa-tr         edi-su-pa-tr                       reference                          integer
APDISCDY A/P Terms Discount Days            ap-term                            disc-days                          integer
APNETDAY A/P Term's net days                ap-term                            net-days                           integer
ARCOLMEM                                    ar-collect                         memo                               character
AROPIDID A/R Open Item Discount Date        ar-open-item                       disc-date                          date
AROPIDIS A/R Open Item Discount Amount      ar-open-item                       disc-amt                           decimal
AROPIDSA A/R Open Item Discntble Amount     ar-open-item                       discble-amt                        decimal
CTRYDESC Country description                country                            description                        character
CUSTNAME Customer's name                    customer                           name                               character
EDIPKITM EDI Pack Info Item Number          edi-pack-inf                       item-no                            character
EDIPKKIC EDI Pack Info Kit Code             edi-pack-inf                       kit-code                           character
EDIPKQOR EDI Pack Info Quantity Ordered     edi-pack-inf                       qty-ordered                        integer
EDIPKQPK EDI pack info quantity picked      edi-pack-inf                       qty-picked                         integer
GSTCODE  GST Taxation code                  gst                                gst-code                           character
GSTPCT   GST Tax percentage                 gst                                gst-pct                            decimal
INVADDCA Invoice add'l charges amount       invoice-add                        amount                             decimal
INVADDCC Invoice add'l charges code         invoice-add                        charge-code                        character
INVADGSC Invoice add charge's GST code      invoice-add                        gst-code                           character
INVADGST Invoice add. charges GST Amt.      invoice-add                        gst-amt-ext                        decimal
INVADPSC Invoice add charge's PST code      invoice-add                        pst-code                           character
INVADPST Invoice add. charges PST Amt.      invoice-add                        pst-amt-ext                        decimal
INVBOLNO Invoice's BOL number               invoice                            bol-no                             integer
INVBONO  Invoice's Back Order number        invoice                            bo-no                              integer
INVCITY  Invoice's ship-to city             invoice                            ship-city                          character
INVCREDI Invoice/Credit Note Indicator      invoice                            inv-credit                         logical
INVCTRY  Invoice's ship-to country          invoice                            ship-country                       character
INVCURCD Invoice's currency code            invoice                            currency-cod                       character
INVCUSTP Invoice's Customer P/O number      invoice                            cust-po                            character
INVDATE  Invoice's invoice date             invoice                            invoice-date                       date
INVDUE   Invoice's due date                 invoice                            due-date                           date
INVESTNO Invoice's Estimate number          invoice                            estimate-no                        integer
INVEXCRT Invoice's exchange rate            invoice                            conv-money                         decimal
INVJOBNO Invoice's Job number               invoice                            job-no                             character
INVLNATD Invoice line's add to discount     invoice-line                       add-to-disc                        decimal
INVLNATP Invoice line's add to price        invoice-line                       add-to-price                       decimal
INVLNCDI Invoice line customer discount     invoice-line                       cust-disc                          decimal
INVLNDES Invoice line's description         invoice-line                       description                        character
INVLNDPC Invoice line dollar/percent        invoice-line                       dollar-pct                         logical
INVLNGSC Invoice line's GST code            invoice-line                       gst-code                           character
INVLNGST Invoice line's GST Amount          invoice-line                       gst-amt-ext                        decimal
INVLNITM Invoice line item shipped          invoice-line                       item-shipped                       character
INVLNJOB Invoice line's job number          invoice-line                       job-no                             character
INVLNORD Invoice line's order number.       invoice-line                       order-no                           integer
INVLNPRC Invoice line gross price           invoice-line                       gross-price                        decimal
INVLNPSC Invoice line's PST code            invoice-line                       pst-code                           character
INVLNPST Invoice line's PST amount          invoice-line                       pst-amt-ext                        decimal
INVLNQTY Invoice line qty shipped           invoice-line                       qty-shipped                        integer
INVLNRMA Invoice line's RMA number          invoice-line                       rma-no                             integer
INVLNSUM Invoice line selling UOM           invoice-line                       selling-uom                        character
INVLNVDI Invoice line volume discount       invoice-line                       volume-disc                        decimal
INVLSQTY Inv. line serial qty shipped       invoice-ln-s                       qty-shipped                        integer
INVLSSER Invoice line serial number         invoice-ln-s                       serial-no                          character
INVMEMO  Invoice's memo line                invoice                            memo                               character
INVNUMB  Invoice/Credit Note number         invoice                            document                           integer
INVORDDT Invoice's order date               invoice                            order-date                         date
INVORDNO Invoice's Order number             invoice                            order-no                           integer
INVPCKNO Invoice's packing slip number      invoice                            pack-no                            integer
INVPPSNO Invoice's PPS number               invoice                            pps-no                             integer
INVRMANO Invoice's RMA number               invoice                            rma-no                             integer
INVSHADD Invoice's ship-to address          invoice                            ship-address                       character
INVSHPNM Invoice's ship-to name             invoice                            ship-name                          character
INVSTATE Invoice's ship-to prov./state      invoice                            ship-st                            character
INVTAX   Invoice tax amount by level        invoice                            tax-amt                            decimal
INVTAXCD Invoice's tax code                 invoice                            tax-code                           character
INVTRCNO Invoice's tracer number            invoice                            tracer-no                          character
INVVIADE Invoice's Via Description          invoice                            via-desc                           character
INVZIPCD Invoice's zip/postal code          invoice                            ship-zip                           character
ITEMMLI  Item's MLI code                    item                               mli                                character
ITEMSEUM Item's selling UOM                 item                               selling-uom                        character
ORDCURCD Order's currency code              order                              currency-cod                       character
ORDCUSPO Order's Customer P/O number        order                              cust-po                            character
ORDEXCRT Order's exchange rate              order                              conv-money                         decimal
ordfil                                      order                              filler1                            character
ORDLNDES Order line's description           order-line                         description                        character
ORDLNITM Order line item number             order-line                         item-no                            character
ORDLNKIT Order line kit number              order-line                         kit-no                             character
ORDLNQOR Order line quantity open order     order-line                         qty-open-ord                       integer
ORDLNSUM Order line's selling UOM           order-line                         selling-uom                        character
ordshipn order ship number                  order                              ship-no                            character
PO-DATE  P/O Date                           po                                 po-date                            date
PO-DISC  P/O Discount amount                po                                 po-disc                            decimal
PO-NAME  P/O Name                           po                                 name                               character
PO-NO    Purchase order number              po                                 po-no                              character
POCURRCD P/O Currency Code                  po                                 currency-cod                       character
POESTNO  P/O Estimate number                po                                 estimate-no                        integer
POEXCHRT P/O Exchange rate                  po                                 conv-money                         decimal
POFOBDES P/O FOB Description                po                                 fob-desc                           character
POFOBVEN P/O Line FOB Vendor Cost           po-line                            fob-vendor                         decimal
POITEMDE P/O Line Item Description          po-line                            description                        character
POITEMNO P/O Line Item Number               po-line                            item-no                            character
POITEMVE P/O Line Vendor's Item Number      po-line                            item-vendor                        character
POJOBNO  P/O Job number                     po                                 job-no                             character
POLINEJB P/O Line Job Number                po-line                            job-no                             character
POLINENO P/O Line Number                    po-line                            line-no                            integer
POMEMO   P/O Header Memo                    po                                 memo                               character
POPROJNO P/O Project number                 po                                 proj-no                            character
POQTYORD P/O Line quantity orig ordered     po-line                            qty-orig-ord                       integer
POQTYREC P/O Line Quantity to Receive       po-line                            qty-to-rcve                        integer
POUOMVEN P/O Line Vendor UOM                po-line                            uom-vendor                         character
POVENDRF P/O Vendor Reference               po                                 vendor-refer                       character
PPSBOLNO PPS Header's Bill of Lading No     pps-header                         bol-no                             integer
PPSDATE  PPS Date                           pps-header                         pps-date                           date
PPSLNITM PPS Line's Item number             pps-line                           item-pps                           character
PPSLNQTY PPS Line quantity                  pps-line                           qty-on-pps                         integer
PPSLSQTY PPS Line serial quantity           pps-line-s                         qty-on-pps                         integer
PPSLSSER PPS Line's Serial Number           pps-line-s                         serial-no                          character
PPSNO    PPS Number                         pps-header                         pps-no                             integer
PPSORDNO PPS Header's Order Number          pps-header                         order-no                           integer
PPSPACKN PPS Header's packing slip no.      pps-header                         pack-no                            integer
PPSSHADD PPS Header's Ship-to Address       pps-header                         ship-address                       character
PPSSHCOU PPS Header's Ship-to Country       pps-header                         ship-country                       character
PPSSHCTY PPS Header's Ship-to City          pps-header                         ship-city                          character
PPSSHNAM PPS Header's Ship-to Name          pps-header                         ship-name                          character
PPSSHST  PPS Header's Ship-to state         pps-header                         ship-st                            character
PPSSHZIP PPS Header's Ship-to zip code      pps-header                         ship-zip                           character
PPSTRCNO PPS Header's Tracer Number         pps-header                         tracer-no                          character
PSTPCT   PST Percentage                     state-pst                          pst-pct                            decimal
REL-NO   P/O Release number                 po                                 release-no                         integer
REL-NUM  Purchase order release number      po                                 release-no                         integer
TAXRATE  Tax's tax rate                     tax                                tax-rate                           decimal
VENDADDR Vendor's address                   vendor                             address                            character
VENDCITY Vendor's city                      vendor                             city                               character
VENDCTRY Vendor's country code              vendor                             country-code                       character
VENDST   Vendor's state                     vendor                             st                                 character
VENDZIP  Vendor's zip/postal code           vendor                             zip-code                           character
zcashcus cash-jrnl.customer                 cash-jrnl                          cust-no                            character

Last updated October 20, 2006