Definition of table billing-group
No table description available , Table Dump Name bill-grp

Alphabetical Field Summary

  • billing-group-code: (CHAR) Name of this billing group
  • description: (CHAR) Description of this billing group
  • extern-guid: (CHAR) External Global Unique ID for this record
  • fiscal-year: (CHAR) Start year of fiscal year (i.e. 1992 for FY 1992/1993)
  • form-print-mod: (CHAR) Name of the Invoice Form Printing Module
  • image-path: (CHAR) Image path for download based form printers
  • invoice-prefix: (CHAR) Prefix for invoice #s created under this billing group
  • journal-code: (CHAR) Journal code for recording billing in G/L
  • next-invoice-num: (INTG) Next Invoice # to assign for this billing group
  • next-tran-num: (INTG) Next transaction number to use
  • primary-key: (INTG) Unique, Primary key for table/record

    Alphabetical Index Summary

  • billing-group: (UNIQUE, PRIMARY) fiscal-year, billing-group-code
  • description: fiscal-year, description
  • extern-guid: extern-guid
  • invoice-prefix: (UNIQUE) fiscal-year, invoice-prefix

    Alphabetical Trigger Summary

  • CREATE: Overridable, Procedure is tr-c-blg.p (SOURCE NOT AVAILABLE)
  • DELETE: Overridable, Procedure is tr-d-blg.p (SOURCE NOT AVAILABLE)
  • REPLICATION-CREATE: Procedure is rp-c-blg.p (SOURCE NOT AVAILABLE)
  • REPLICATION-DELETE: Procedure is rp-d-blg.p (SOURCE NOT AVAILABLE)
  • REPLICATION-WRITE: Procedure is rp-u-blg.p (SOURCE NOT AVAILABLE)
  • WRITE: Overridable, Procedure is tr-u-blg.p (SOURCE NOT AVAILABLE)

    Other tables who reference billing-group

  • bi-desc - Invoice Line Descriptions
  • bi-line - Invoice Account Line Items
  • bi-tran - Billing Transactions file
  • billing-catalog - (no description available)
  • billing-period - (no description available)
  • billing-period-item - (no description available)

    Tables billing-group references

  • journal - Journal Codes file
  • period - Period definition file. This defines the start/stop of each

    Detailed Alphabetical Field Listing
    billing-group-code Data type: CHARACTER
    Format: x(8)
    Help: Name of this billing group
    Attributes: Index Component

    description Data type: CHARACTER
    Format: x(28)
    Help: Description of this billing group
    Attributes: Index Component

    extern-guid Data type: CHARACTER
    Format: x(32)
    Description: External Global Unique ID for this record
    Attributes: Index Component

    fiscal-year Data type: CHARACTER
    Format: 9999
    Description: Start year of fiscal year (i.e. 1992 for FY 1992/1993)
    Attributes: Index Component

    form-print-mod Data type: CHARACTER
    Format: x(32)
    Help: Name of the Invoice Form Printing Module

    image-path Data type: CHARACTER
    Format: x(32)
    Help: Image path for download based form printers

    invoice-prefix Data type: CHARACTER
    Format: x(4)
    Help: Prefix for invoice #s created under this billing group
    Attributes: Index Component

    journal-code Data type: CHARACTER
    Format: x(6)
    Help: Journal code for recording billing in G/L
    Attributes: Mandatory

    next-invoice-num Data type: INTEGER
    Format: zzzzz9 (Initial Value: 1)
    Help: Next Invoice # to assign for this billing group

    next-tran-num Data type: INTEGER
    Format: zzzzz9 (Initial Value: 1)
    Help: Next transaction number to use

    primary-key Data type: INTEGER
    Format: zzzzzzzzz9
    Help: Unique, Primary key for table/record

    Created on 04/17/2012 by DBHTML V1.2