Definition of table billing-period-item
No table description available , Table Dump Name bill-itm

Alphabetical Field Summary

  • acct-num: (CHAR) Account Number item should bill
  • billing-group-code: (CHAR) Billing group this period is associated with
  • billing-period-code: (CHAR) Name of this period
  • catalog-num: (CHAR) Catalog # for this item, if any
  • comments: (CHAR) Comments about this item
  • cust-po-num: (CHAR) Customer PO # (optional)
  • description: (CHAR) Description of this periodic billing item
  • detail-desc: (CHAR) Detailed Description of this item
  • ent-id: (CHAR) ID of the Source being billed
  • ent-name: (CHAR) Name of the source being billed
  • extended-price: (DECM) Extended price for this item
  • extern-guid: (CHAR) External Global Unique ID for this record
  • first-billed-date: (DATE) First date this item generated an invoice
  • fiscal-year: (CHAR) Start year of fiscal year (i.e. 1992 for FY 1992/1993)
  • invoiced-amount: (DECM) Total amount invoiced by this item
  • invoiced-amount-limit: (DECM) Maximum amount this item will invoice (0 = no limit)
  • invoiced-count: (INTG) Number of times this item has generated an invoice
  • invoiced-count-limit: (INTG) Maximum # of times to generate an invoice (0 = no limit)
  • item-num: (INTG) Periodic Billing Item #
  • item-on-hold: (LOGC) Yes if item is being held (temporarily not being billed)
  • item-seq: (INTG) Unique Item sequeunce #/identifier
  • last-billed-date: (DATE) Last date this item generated an invoice
  • mail-addr[2]: (CHAR) Mailing address, enter the street address & possibly a build
  • mail-attn: (CHAR) Mailing address, attention of
  • mail-city: (CHAR) Mailing address, city
  • mail-state: (CHAR) Mailing address, state
  • mail-zip: (CHAR) Mailing address, zip code
  • primary-key: (INTG) Unique, Primary key for table/record
  • quantity: (DECM) Quantity for this item
  • reset-on-fiscal: (LOGC) Should this invoices limits (if any) reset every fiscal year
  • seperate-invoice: (LOGC) Yes if this item should appear alone on it's own invoice
  • unit-price: (DECM) Unit price for item, if any

    Alphabetical Index Summary

  • acct-num: fiscal-year, acct-num
  • billing-period-item: (PRIMARY) fiscal-year, billing-group-code, billing-period-code, item-num
  • by-item-seq: fiscal-year, item-seq
  • by-source: fiscal-year, billing-group-code, billing-period-code, ent-name
  • description: fiscal-year, billing-group-code, billing-period-code, description, item-num
  • extern-guid: extern-guid

    Alphabetical Trigger Summary

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

    Tables billing-period-item references

  • acct - Accounts file.
  • acct-class-acct - Account Class Account List
  • billing-catalog - (no description available)
  • billing-group - (no description available)
  • billing-period - (no description available)
  • cash-acct - Cash Accounts definition file. This defines each possible
  • ent-calendar - Entity information on a calendar year basis
  • entity - Definitions for vendors & customers
  • period - Period definition file. This defines the start/stop of each

    Detailed Alphabetical Field Listing
    acct-num Data type: CHARACTER
    Format: x(30)
    Help: Account Number item should bill
    Attributes: Index Component, Mandatory

    billing-group-code Data type: CHARACTER
    Format: x(8)
    Help: Billing group this period is associated with
    Attributes: Index Component

    billing-period-code Data type: CHARACTER
    Format: x(8)
    Help: Name of this period
    Attributes: Index Component

    catalog-num Data type: CHARACTER
    Format: x(10)
    Help: Catalog # for this item, if any

    comments Data type: CHARACTER
    Format: x(48)
    Help: Comments about this item

    cust-po-num Data type: CHARACTER
    Format: x(10)
    Help: Customer PO # (optional)

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

    detail-desc Data type: CHARACTER
    Format: x(68)
    Help: Detailed Description of this item

    ent-id Data type: CHARACTER
    Format: x(6)
    Help: ID of the Source being billed

    ent-name Data type: CHARACTER
    Format: x(32)
    Help: Name of the source being billed
    Attributes: Index Component, Mandatory

    extended-price Data type: DECIMAL (Decimals: 2)
    Format: -zz,zzz,zz9.99 (Initial Value: 0)
    Help: Extended price for this item

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

    first-billed-date Data type: DATE
    Format: 99/99/9999
    Help: First date this item generated an invoice

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

    invoiced-amount Data type: DECIMAL (Decimals: 2)
    Format: zz,zzz,zz9.99 (Initial Value: 0)
    Help: Total amount invoiced by this item

    invoiced-amount-limit Data type: DECIMAL (Decimals: 2)
    Format: zz,zzz,zz9.99 (Initial Value: 0)
    Help: Maximum amount this item will invoice (0 = no limit)

    invoiced-count Data type: INTEGER
    Format: zzzzz9 (Initial Value: 0)
    Help: Number of times this item has generated an invoice

    invoiced-count-limit Data type: INTEGER
    Format: zzzz9 (Initial Value: 0)
    Help: Maximum # of times to generate an invoice (0 = no limit)

    item-num Data type: INTEGER
    Format: zzzzz9 (Initial Value: 0)
    Help: Periodic Billing Item #
    Attributes: Index Component

    item-on-hold Data type: LOGICAL
    Format: Yes/No (Initial Value: No)
    Help: Yes if item is being held (temporarily not being billed)

    item-seq Data type: INTEGER
    Format: zzzzzzzzzzz9
    Description: Unique Item sequeunce #/identifier
    Attributes: Index Component

    last-billed-date Data type: DATE
    Format: 99/99/9999
    Help: Last date this item generated an invoice

    mail-addr Data type: CHARACTER (Extent: 2)
    Format: x(32)
    Help: Mailing address, enter the street address & possibly a build

    mail-attn Data type: CHARACTER
    Format: x(32)
    Help: Mailing address, attention of

    mail-city Data type: CHARACTER
    Format: x(15)
    Help: Mailing address, city

    mail-state Data type: CHARACTER
    Format: !!
    Help: Mailing address, state

    mail-zip Data type: CHARACTER
    Format: x(10)
    Help: Mailing address, zip code

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

    quantity Data type: DECIMAL (Decimals: 3)
    Format: zzz,zz9.999 (Initial Value: 0)
    Help: Quantity for this item

    reset-on-fiscal Data type: LOGICAL
    Format: Yes/No (Initial Value: No)
    Help: Should this invoices limits (if any) reset every fiscal year

    seperate-invoice Data type: LOGICAL
    Format: Yes/No (Initial Value: No)
    Help: Yes if this item should appear alone on it's own invoice

    unit-price Data type: DECIMAL (Decimals: 2)
    Format: -z,zzz,zz9.99 (Initial Value: 0)
    Help: Unit price for item, if any

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