EXTERNALCHARGE table

The EXTERNALCHARGE table in the Infor Public Sector database stores information about external charges as they are added and paid in the Cash Register. When a cashier adds a basic external charge, the system takes the charge setup information from the CHARGESETUP table and adds it to the EXTERNALCHARGE table, which generates an instance of the charge.

For an advanced external charge, the EXTERNALCHARGE table is populated with data from either the external database or the conversion formula. When you set up an advanced external charge, you must ensure that these columns in the EXTERNALCHARGE table are populated:

  • CHARGESETUP
  • CHARGEDETAILS
  • CHGSUBTOT
  • CHGTAX
  • CHGTAXRATE
  • CHGTOT
  • CHGUNITPRC
  • EXTCHGKEY
  • EXTERNALKEY
  • PAID
  • TENDERTYPE