Field Name | Type | Lgth | Dec. | Indx | Description |
SRC | C | 2 | Y | Source Code | |
SRCDESC | C | 30 | Y | Source Description | |
LDATE | D | 8 | N | Date of Last entry for the source | |
LREF | C | 8 | N | Last Reference Number | |
SRCREF | C | 4 | N | Left characters of the Reference for the Source (e.g. JE-) | |
NEXTNO | C | 8 | N | Next Reference Number | |
BDGREF | C | 4 | N | Left characters of Budget Reference for the Source | |
NEXTBNO | C | 8 | N | Next Reference Number | |
CRCY | C | 3 | N | Currency of Source | |
CRCYACCT | C | 7 | Y | G/L Account number for Currency exchange | |
CONTROL | C | 1 | N | Control Account Indicator | |
SRCGL | C | 7 | N | Source G/L number | |
SRCTYPE | C | 10 | N | Source Type (e.g. JOURNAL, BANKIN, BANKOUT) | |
DDESC | C | 25 | N | Document Description (e.g. Invoice, Journal Entry, Deposit) |
Field Name | Type | Lgth | Dec. | Indx | Description |
C | 12 | Y | |||
N |
Field Name | Type | Lgth | Dec. | Indx | Description |
ACCTNO | C | 7 | Y | Account Number - must agree with the G/L Account Number | |
COMPANY | C | 50 | N | Company Name | |
ADD | C | 25 | N | Address | |
CTY | C | 20 | N | City | |
STATE | C | 5 | N | State/Province | |
ZIP | C | 10 | N | Zip code/Postal Code | |
COUNTRY | C | 20 | N | Country | |
TEL | C | 14 | N | Telephone Number | |
FAX | C | 14 | N | Fax Number | |
MODEM | C | 14 | N | Modem Number | |
FST | C | 15 | N | Federal Tax Number | |
PST | C | 10 | N | Provincial/State Tax Number | |
CRCY | C | 3 | N | Account Currency | |
LDATE | D | 10 | N | Last Aging Date | |
LBALANCE | N | 12 | 2 | N | Last Aging Balance |
LAGE1 | N | 12 | 2 | N | Age 1 (e.g. 1-30 days) |
LAGE2 | N | 12 | 2 | N | Age 2 (e.g. 31-60 days) |
LAGE3 | N | 12 | 2 | N | Age 3 (e.g. 61-90 days) |
LAGE4 | N | 12 | 2 | N | Age 4 (e.g. 91-120 days) |
LAGE5 | N | 12 | 2 | N | Age 5 (e.g. 121-150 days) |
LAGE6 | N | 12 | 2 | N | Age 6 (e.g. over 150 days) |
Index TAG: CNME
Key: substr(COMPANY,1,10)
Index TAG: CACCT
Key: CRCY+ACCTNO
Field Name | Type | Lgth | Dec. | Indx | Description |
DATE | D | 8 | N | Date of Check or Journal Entry | |
NAME | C | 25 | N | Name of Employee | |
REFERENCE | C | 8 | N | Check No. or Journal Entry No. | |
AMOUNT | N | 12 | 2 | N | Amount of Check or Journal Entry |
GL | C | 7 | N | General Ledger Account No. | |
SOURCE | C | 2 | N | Source Code (e.g. AR, AP, CK, DP, JE, PR) |
Field Name | Type | Lgth | Dec. | Indx | Description |
CONTENTS | C | 65 | A | Help Contents | |
KEYS | C | 5 | N | Key stoke sequence from Master Menu | |
SCREEN_NO | C | 15 | N | Screen No from Upper left of screen | |
TEXT_HELP | M | 10 | N | Help Text |