Definition of table entity

Definitions for vendors & customers , Table Dump Name entity

Alphabetical Field Summary

box-amount[20]: (DECM) Amount for this box

box-number: (CHAR) Box number to print the vendor amount in on the 1099

comment[4]: (CHAR) General comment or notes you wish to include at this time

credate: (DATE) Date of account creation

cust-num: (CHAR) Vendor's Customer # for your district

discount-days: (DECM) Number of days to pay within and receive a discount

discount-pct: (DECM) The percentage discount you are entitled to for early paymen

due-days: (DECM) Number of days from invoice date until payment is due

eft-acct-num: (CHAR) Vendor Account Number

eft-acct-type: (CHAR) Type of account (Checking or Savings)

eft-enabled: (LOGC) Are payments eligible to be sent via EFT?

eft-need-pre-note: (LOGC) Send a pre-note record instead of money?

eft-route-num: (CHAR) Vendor ABA/Routing number

email-address[5]: (CHAR) Vendor Email Address

email-ap[5]: (LOGC) Use this email address for APs?

email-billing[5]: (LOGC) Use this email address for billing?

email-pos[5]: (LOGC) Use this address for POs?

ent-class: (CHAR) Classification code

ent-ein: (CHAR) Employer ID # (corporations), Social Security # (individuals

ent-id: (CHAR) This is a unique identifier for this vendor/customer.

ent-name: (CHAR) The name of the organization

entity-on-hold: (LOGC) No to stop any new transactions against this entity

exp-amount: (DECM) Total amount paid to be paid to an entity

exp-applied: (DECM) Total amount paid to an entity

exp-balance: (DECM) Balance to be paid to an entity

exp-discount: (DECM) Total discounts applied for this vendor

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)

force-1099: (LOGC) `Yes' will force a 1099 to be printed for this organization

format-as-ssn: (LOGC) SSN to format the EIN as SSN, FEIN to format it as an FEIN

is-corp: (LOGC) Is this business Incorporated or Unincorporated

is-vendor: (LOGC) Identify this record as a Vendor or Source of revenue

last-activity: (DATE) Date of last monetary activity for an entity

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-ext: (CHAR) Mailing address, phone extension of `Attention of' person

mail-fax: (CHAR) Mailing address, Phone number for FAX machine

mail-phone: (CHAR) Mailing address, phone number to contact `Attention of' pers

mail-state: (CHAR) Mailing address, state

mail-zip: (CHAR) Mailing address, zip code

pay-addr[2]: (CHAR) Pay to address, enter the street address and/or building

pay-attn: (CHAR) Pay to address, send correspondance `attention to' this pers

pay-city: (CHAR) Pay to address, city

pay-ext: (CHAR) Pay to address, extension of `attention of' person

pay-fax: (CHAR) Pay to address, phone number for FAX machine

pay-name: (CHAR) Make checks "Payable to" this name

pay-phone: (CHAR) Pay to address, phone number to reach `Attention of' person

pay-state: (CHAR) Pay to address, state

pay-zip: (CHAR) Pay to address, zip code

per-exp-amount[12]: (DECM) Total amount to be paid to an entity for a period

per-exp-applied[12]: (DECM) Total amount paid to an entity for a period

per-exp-discount[12]: (DECM) Total amount of discounts applied to a vendor for a period

per-rev-amount[12]: (DECM) Total amount to be collected from an entity for a period

per-rev-applied[12]: (DECM) Total amount received from an entity for a period

primary-key: (INTG) Unique, Primary key for table/record

rev-amount: (DECM) Total amount to be collected from entity

rev-applied: (DECM) Total amount received from entity

rev-balance: (DECM) Balance due from an entity

suppress-1099: (LOGC) Yes to explicitly supress generating a 1099 for this year

terminal-entity: (LOGC) Yes if this entity record should not be carried to next year

upddate: (DATE) Date of last record update

Alphabetical Index Summary

entity-class: fiscal-year, ent-class

entity-id: (UNIQUE, PRIMARY) fiscal-year, ent-id

entity-name: fiscal-year, ent-name

entity-ven-class: fiscal-year, is-vendor, ent-class

entity-ven-id: fiscal-year, is-vendor, ent-id

entity-ven-name: fiscal-year, is-vendor, ent-name

extern-guid: extern-guid

Alphabetical Trigger Summary

CREATE: Overridable, Procedure is tr-c-ent.p (SOURCE NOT AVAILABLE)

DELETE: Overridable, Procedure is tr-d-ent.p (SOURCE NOT AVAILABLE)

REPLICATION-CREATE: Procedure is rp-c-ent.p (SOURCE NOT AVAILABLE)

REPLICATION-DELETE: Procedure is rp-d-ent.p (SOURCE NOT AVAILABLE)

REPLICATION-WRITE: Procedure is rp-u-ent.p (SOURCE NOT AVAILABLE)

WRITE: Overridable, Procedure is tr-u-ent.p (SOURCE NOT AVAILABLE)

Other tables who reference entity

ap-line - AP Transaction Line/Account file

ap-tran - AP Transaction Header file.

ar-line - AR Line item files

ar-tran - Accounts Receivable transactions file

bi-desc - Invoice Line Descriptions

bi-line - Invoice Account Line Items

bi-tran - Billing Transactions file

billing-period-item - (no description available)

ds-desc - Disbursment invoice description file

ds-line - Disbursment Line/Account file

ds-tran - Disbursment transaction file

ent-calendar - Entity information on a calendar year basis

fa-class-code - Fixed Assets Item Class Table

inv-line - Invoice Line items file

invoice - Invoice file. This keeps a detail of vendor invoices.

item-tran - Fixed Assets Item

po-desc - Description items for the PO

po-line - Line/Account file for the PO

po-recv - Receiving detail of PO item

po-tran - PO transaction/file entries

rc-desc - Receipt Invoice lines

rc-line - Receipts Line Item file

rc-tran - Receipts Transaction file

_Segments - (no description available)

Tables entity references

ent-calendar - Entity information on a calendar year basis

ent-class - Vendor/Source classifications

period - Period definition file. This defines the start/stop of each

Detailed Alphabetical Field Listing
box-amount Data type: DECIMAL (Extent: 20, Decimals: 2)
Format: ->>,>>>,>>9.99 (Initial Value: 0)
Help: Amount for this box

box-number Data type: CHARACTER
Format: x(2)
Help: Box number to print the vendor amount in on the 1099

comment Data type: CHARACTER (Extent: 4)
Format: x(32)
Help: General comment or notes you wish to include at this time

credate Data type: DATE
Format: 99/99/9999 (Initial Value: TODAY)
Description: Date of account creation

cust-num Data type: CHARACTER
Format: x(22)
Help: Vendor's Customer # for your district

discount-days Data type: DECIMAL (Decimals: 2)
Format: >>9 (Initial Value: 0)
Help: Number of days to pay within and receive a discount

discount-pct Data type: DECIMAL (Decimals: 2)
Format: zz9.99% (Initial Value: 0)
Help: The percentage discount you are entitled to for early paymen

due-days Data type: DECIMAL (Decimals: 2)
Format: >>9 (Initial Value: 0)
Help: Number of days from invoice date until payment is due

eft-acct-num Data type: CHARACTER
Format: x(30)
Help: Vendor Account Number
Attributes: Mandatory

eft-acct-type Data type: CHARACTER
Format: x(8)
Help: Type of account (Checking or Savings)

eft-enabled Data type: LOGICAL
Format: Yes/No (Initial Value: no)
Help: Are payments eligible to be sent via EFT?

eft-need-pre-note Data type: LOGICAL
Format: Yes/No (Initial Value: no)
Help: Send a pre-note record instead of money?

eft-route-num Data type: CHARACTER
Format: x(9)
Help: Vendor ABA/Routing number

email-address Data type: CHARACTER (Extent: 5)
Format: x(60)
Help: Vendor Email Address

email-ap Data type: LOGICAL (Extent: 5)
Format: Yes/No (Initial Value: No)
Help: Use this email address for APs?

email-billing Data type: LOGICAL (Extent: 5)
Format: Yes/No (Initial Value: No)
Help: Use this email address for billing?

email-pos Data type: LOGICAL (Extent: 5)
Format: Yes/No (Initial Value: No)
Help: Use this address for POs?

ent-class Data type: CHARACTER
Format: x(8)
Help: Classification code
Attributes: Index Component, Mandatory

ent-ein Data type: CHARACTER
Format: 99-9999999
Help: Employer ID # (corporations), Social Security # (individuals

ent-id Data type: CHARACTER
Format: x(6)
Help: This is a unique identifier for this vendor/customer.
Attributes: Index Component

ent-name Data type: CHARACTER
Format: x(32)
Help: The name of the organization
Attributes: Index Component, Mandatory

entity-on-hold Data type: LOGICAL
Format: Yes/No (Initial Value: No)
Help: No to stop any new transactions against this entity

exp-amount Data type: DECIMAL (Decimals: 2)
Format: ->>,>>>,>>9.99 (Initial Value: 0)
Description: Total amount paid to be paid to an entity

exp-applied Data type: DECIMAL (Decimals: 2)
Format: ->>,>>>,>>9.99 (Initial Value: 0)
Description: Total amount paid to an entity

exp-balance Data type: DECIMAL (Decimals: 2)
Format: ->>,>>>,>>9.99 (Initial Value: 0)
Description: Balance to be paid to an entity

exp-discount Data type: DECIMAL (Decimals: 2)
Format: zzz,zzz,zz9.99 (Initial Value: 0)
Description: Total discounts applied for this vendor

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

force-1099 Data type: LOGICAL
Format: Yes/No (Initial Value: no)
Help: `Yes' will force a 1099 to be printed for this organization

format-as-ssn Data type: LOGICAL
Format: SSN/FEIN (Initial Value: No)
Help: SSN to format the EIN as SSN, FEIN to format it as an FEIN

is-corp Data type: LOGICAL
Format: Incorporated/Unincorporated (Initial Value: I)
Help: Is this business Incorporated or Unincorporated

is-vendor Data type: LOGICAL
Format: Vendor/Source (Initial Value: V)
Help: Identify this record as a Vendor or Source of revenue
Attributes: Index Component

last-activity Data type: DATE
Format: 99/99/9999 (Initial Value: TODAY)
Description: Date of last monetary activity for an entity

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-ext Data type: CHARACTER
Format: ~xxxxx
Help: Mailing address, phone extension of `Attention of' person

mail-fax Data type: CHARACTER
Format: (xxx) 999-9999
Help: Mailing address, Phone number for FAX machine

mail-phone Data type: CHARACTER
Format: (xxx) 999-9999
Help: Mailing address, phone number to contact `Attention of' pers

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

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

pay-addr Data type: CHARACTER (Extent: 2)
Format: x(32)
Help: Pay to address, enter the street address and/or building

pay-attn Data type: CHARACTER
Format: x(32)
Help: Pay to address, send correspondance `attention to' this pers

pay-city Data type: CHARACTER
Format: x(15)
Help: Pay to address, city

pay-ext Data type: CHARACTER
Format: ~xxxxx
Help: Pay to address, extension of `attention of' person

pay-fax Data type: CHARACTER
Format: (xxx) 999-9999
Help: Pay to address, phone number for FAX machine

pay-name Data type: CHARACTER
Format: x(32)
Help: Make checks "Payable to" this name

pay-phone Data type: CHARACTER
Format: (xxx) 999-9999
Help: Pay to address, phone number to reach `Attention of' person

pay-state Data type: CHARACTER
Format: !!
Help: Pay to address, state

pay-zip Data type: CHARACTER
Format: x(10)
Help: Pay to address, zip code

per-exp-amount Data type: DECIMAL (Extent: 12, Decimals: 2)
Format: -zz,zzz,zz9.99 (Initial Value: 0)
Description: Total amount to be paid to an entity for a period

per-exp-applied Data type: DECIMAL (Extent: 12, Decimals: 2)
Format: -zz,zzz,zz9.99 (Initial Value: 0)
Description: Total amount paid to an entity for a period

per-exp-discount Data type: DECIMAL (Extent: 12, Decimals: 2)
Format: zzz,zzz,zz9.99 (Initial Value: 0)
Description: Total amount of discounts applied to a vendor for a period

per-rev-amount Data type: DECIMAL (Extent: 12, Decimals: 2)
Format: -zz,zzz,zz9.99 (Initial Value: 0)
Description: Total amount to be collected from an entity for a period

per-rev-applied Data type: DECIMAL (Extent: 12, Decimals: 2)
Format: -zz,zzz,zz9.99 (Initial Value: 0)
Description: Total amount received from an entity for a period

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

rev-amount Data type: DECIMAL (Decimals: 2)
Format: ->>,>>>,>>9.99 (Initial Value: 0)
Description: Total amount to be collected from entity

rev-applied Data type: DECIMAL (Decimals: 2)
Format: ->>,>>>,>>9.99 (Initial Value: 0)
Description: Total amount received from entity

rev-balance Data type: DECIMAL (Decimals: 2)
Format: ->>,>>>,>>9.99 (Initial Value: 0)
Description: Balance due from an entity

suppress-1099 Data type: LOGICAL
Format: Yes/No (Initial Value: No)
Help: Yes to explicitly supress generating a 1099 for this year

terminal-entity Data type: LOGICAL
Format: Yes/No (Initial Value: No)
Help: Yes if this entity record should not be carried to next year

upddate Data type: DATE
Format: 99/99/9999 (Initial Value: TODAY)
Description: Date of last record update

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