Special Forms - SYSPUB
The Special Forms (SYSPUB) page is used to define general information about special forms and check stock. This is a multi-form definition page, used to accommodate a wide variety of form definitions, not all fields are used with every form. The most common purpose of this page is to define check numbers and stub formatting. This page is filled out once for each form stock to be defined and this is usually done with BusinessPlus installations.
Page Header
Form ID: Enter the name used to create this Special Form Definition. For example, the Form Id format for Accounts Payable checks would be "SPFMxxCK", where "xx" is the Bank ID.
File Name: This field is informational reference use only – the file name entered here is not used, in any manner, in BusinessPlus processing. Typically, this will be the same as the Form ID.
Title: Enter up to 30 characters that describe the form stock. For example, "Accounts Payable Check Account".
Stub Location: Select "TOP" for top-stubbed checks. Enter "BOT" for bottom-stubbed.
Stock ID: The stock ID or bank ID. If the form is check stock, the code should be the same as the fifth and sixth characters of the Form ID field. Bank ID codes are defined in NU Common Codes Category/Value CKID/<ID>.
IFAS Version: BusinessPlus version may be entered for informational purposes.
Main Tab
Eject Page Between Forms: Usually left blank (meaning No) indicating that the software is to "count" lines, rather than to depend upon a printer control tape being used to page eject to a new form.
Mount Msg 1, Msg 2, Msg 3: Up to 50 characters available for informational purposes to describe form mounting notes. Not commonly used in BusinessPlus 7.9.8.
Number of Void Starters: Enter the number of form/check stock that will be "wasted" during printer alignment.
Number of Void Enders: Enter the number of form/check stock that will be "wasted" when the printer reaches an "end of box" condition. Many tractor feed printers are not able to print the last check in a box; thus, this field should be set to the number of such checks.
Begin Void Starter on Line: Many tractor feed printers do not print on all lines of the first void alignment-form stock. Use this field to indicate which line is the first printable line on the first stock form when starting a form printing operation. For example, a number of 23 would indicate that the first 22 lines of the starting check stock form are above the printer platen.
Use Form Control Number: This field should be checked if the form number used by the system is pulled from the Starting Number field.
Starting Number: Enter the starting form number to be used. This should be entered as an eight-digit number.
Ending Number: Enter the ending form number to be used. This should be entered as an eight-digit number.
Rewrite File with Form Number: If pre-printed form numbers are used, place a check by clicking this field; otherwise, leave it blank.
Primary Stub Sort: Enter the primary and secondary sort orders of the detail information on the form stub. Allowed codes are:
IN: Invoice Number Order
PO: Purchase Order Number Order
KY: GL Key Order
OB: GL Object Order
JK: JL Key Order
JO: JL Object Order
SR: Second Reference Order
RL: Relate Code One Order
User Defined Records: Checking this box indicates the use of user-defined records, blank indicates the "old" style format. See section "Creating AP Check Formats Using User-Defined Data Records."
Secondary Stub Sort: Enter the secondary sort orders of the detail information on the form stub.
Line Definitions Tab
The Line Definitions Tab is used to define each line on the form stock. Fill out this page once for each line on the form stock. This page identifies each line and specifies which fields are to appear on the line. Fields are identified by number; then, on the Field Definitions tab, the system will be told how it is to get each numbered field. The best way to go about this is to fill out the form (hand-written). Then give a unique number to each field on the form, keeping in mind that repeating lines on the form stub need not have unique numbers (e.g., for multiple Distribution amounts on the check stub, only write numbers for the values in the first line).
Line Number: Enter the line numbers consecutively. The first time this page is filled in, the Line No should be "1", the second, "2," and so on. Every line on the form must be represented by a unique Line No and each Line No must be exactly one larger than the previously defined Line No.
Print Field Numbers: Enter the Field Numbers that are to appear on this line of the form. Fields are identified by number; then, on the Field Definitions tab, the system will be told how to get each numbered field.
Read Records Before: With regard to check forms, four types of records are generated for each Person or Entity that is to receive a check.
- The first type, called Record 01, contains general information such as the Person or Entity name, ID, and address information. There is only one Record 01 per check.
- The second record type, called Record 02, contains specific information relating to individual Distribution amounts on the check. Most checks are for one or more Invoices that contain one or more Distribution amounts. There are as many Record 02s as there are Distribution amounts for a given Invoice.
- The third record type, called Record 03, contains information that is specific to the Invoice. There are as many Record 03s as there are Invoices.
- The fourth record type, called Record 04, contains information used by clients that process Claim Numbers. There is one Record 04 per check.
When planning for the extraction of a field from these records, keep in mind that for each check, the system will sort records by the Distribution amount record, within the Invoice record, within Person/Entity ID. Thus, if a person were to receive a check with two Distribution amounts on the first Invoice and one Distribution amount on the second Invoice, the following would be how the records are defined:
Record 01 (about the Person)
Record 02 (first Distribution amount on first Invoice)
Record 02 (second Distribution amount on first Invoice)
Record 03 (about first Invoice)
Record 02 (Distribution amount on second Invoice)
Record 03 (about second Invoice)
If information about an Invoice is needed on a line where Record 02 information is being printed, enter "03" to have the system "read ahead" so that it has the Record 03 data available for inclusion on the line.
Record 06, 07, and 08: Duplicates of Record 2 used for multi-column stub format.
Record 09, 10, and 11: Duplicates of Record 3 used for multi-column stub format
Record 12: Invoice text.
Record 13: Check stock specific text from CKML Common Code.
Overflow Records: Up to five different Record Numbers may be specified as "overflow" indicators. If, after printing the current line, any of these records are found for the current Person or Entity, then an overflow condition is detected and appropriate action will be taken. Four types of records are generated for each Person or Entity that is to receive a check. The first type, called Record 01, contains general information such as the Person or Entity name, ID, and address information. There is only one Record 01 per check; thus, eliminating the need to put "01" in these fields. It is typical to find either "02" or "03" in one of these fields. What this says to the software is as follows: After printing this line, if there are more detail Distribution amounts (or Invoices) for this Person or Entity, handle the overflow condition.
Resume Printing at Line: If an overflow (e.g., check stub overrun) condition exists, this field specifies which Line Number on the next check stock form is to be used when the system resumes normal processing of Distribution Amount Record Number 02s, Invoice Record Number 03s, and/or Claim Record Number 04. This field is required for overflow testing.
After Printing Lines: If an overflow (e.g., check stub overrun) condition exists, the Line Numbers given in these fields will be processed normally en-route to the line number at which printing is to resume. These fields are used to force the reprinting of information on the top of the next check stock form. For example, on top stubbed check stock forms, most clients prefer to reprint the name and ID on the top of overflow stubs, before continuing to print the additional lines required for the check to be fully printed.
Overflow Message: Up to four (30-character) lines may specify the text that is to print when an overflow condition exists. For check stock overflow, many clients like to print something like " **** VOID, CONTINUED STUB**** " across the face of the voided check(s).
Start: Specify the start of lines which are to receive the given overflow text. If one of these line ranges overlaps the "after printing normal Line No's" lines, the overflow message will not be printed on the overlapped lines. If only one line is to be printed, enter the range as xx-xx (e.g., 09-09).
End: Specify the end of lines which are to receive the given overflow text.
Position: Specify the position given overflow text.
Field Definitions Tab
The Field Definitions page is used to define each value to appear on the check stock form. Every Field Number referenced on the Line Definitions tab must be defined on this page.
Field Number: A unique field number from 01 to 99. This number must match at least one Field Number that was entered on the Line Definitions page. Normally, fields are defined in numeric sequence.
Type: Select the code that specifies the type of field being defined. The five types of Fields are:
- CH – Character
- CO – Constant
- FC – Form Control
- NO – Numeric
- TT – Total
NO (Numeric) and CH (Character) values are extracted from records and are provided for each Person or Entity to receive a form.
Description: If the Field "Type" is "CO", enter up to 30 characters to be used when the form is printed. For all other Field "Types", this should contain a description of the field and is used for informational purposes only. The values placed into these fields will be used when the Void alignment forms are printed. For example, if the field is to be the Distribution amount, "xxx,xxx,xxx.xx Dist. Amt" may be entered as the "Desc".
From Record Num: Record No xx, Start xxxx, Length xxxx: The "Record No" field must contain "01," "02," "03," or "04." If the Field "Type" is "CO," "TT," or "FC," leave this field blank. If the Field "Type" is "CH" or "NO," enter the appropriate Record Number from which the desired field is to be extracted. Four types of records are generated for each Person or Entity that is to receive a form.
- The first type, called Record 01, contains general information such as the Person or Entity name, ID, and address information. There is only one Record 01 per form.
- The second record type, called Record 02, contains specific information relating to individual Distribution amounts on the check. Most checks are for one or more Invoices that contain one or more Distribution amounts. There are as many Record 02s as there are Distribution amounts for a given Invoice.
- The third record type, called Record 03, contains information that is specific to the Invoice. There are as many Record 03s as there are Invoices.
- The fourth record type, called Record 04, contains information used by clients that process Claim Numbers. There is one Record 04 for each check.
When planning for the extraction of a field from these records, keep in mind that for each check, the system will sort records by the Distribution amount record, within Invoice record, within the Person/Entity ID. Thus, if a person were to receive a check with two Distribution amounts on the first Invoice and one Distribution amount on the second Invoice, the following would be how the records are defined:
Record 01 (about the Person)
Record 02 (first Distribution amount on first Invoice)
Record 02 (second Distribution amount on first Invoice)
Record 03 (about first Invoice)
Record 02 (Distribution amount on second Invoice)
Record 03 (about second Invoice)
When defining a Field "Type" of "CH" for a given Record Number, provide the starting byte location of the field (placed in the "Start" field) and enter the length of the field (placed in the "Length" field). When defining a Field "Type" of "NO" for a given Record Number, enter the Number ID of the value (placed in the "Start" field). Needing to enter the starting byte location and length makes this process more difficult than if we had simply created names for each field; however, we have a number of clients that wish to pull out specific byte locations within a given field. The following provides a detailed description of each Record Number and value contained therein:
Record "01" - Character Information (CH)
Start | Length | Description |
---|---|---|
1 | 50 | Person/Entity Name as it appeared on the form. |
51 | 40 | Street or Care Of Addressee. |
91 | 40 | Street; or City, State & Zip address. |
131 | 50 | City, State & Zip; blank if 4 lines not required |
181 | 16 | First phone number associated with address. |
197 | 16 | Second phone number associated with address. |
213 | 16 | Third phone number associated with address. |
229 | 8 | Selection Code 1 from Person/Entity database. |
237 | 8 | Selection Code 2 from Person/Entity database. |
245 | 2 | Address Type Code. |
247 | 12 | Person/Entity ID. |
259 | 50 | Person/Entity Name as it appears in the PEDB |
309 | 40 | Address Line Number 4. |
349 | 40 | Address Line Number 5. |
389 | 32 | Country Name |
Record "02" - Character Information (CH) Item Info
Start | Length | Description |
---|---|---|
1 | 8 | Date of Invoice in MM/DD/YY format. |
9 | 8 | Form date in MM/DD/YY format. |
17 | 2 | Stock ID. |
19 | 4 | A/P Division Code. |
23 | 30 | A/P Division Code description. |
53 | 2 | General Ledger Code. |
55 | 10 | General Ledger Org. Key. |
65 | 30 | General Ledger Org. Key Title. |
95 | 8 | General Ledger Object Code. |
103 | 30 | General Ledger Object Code Title. |
133 | 2 | Job Ledger Code. |
135 | 10 | Job Ledger Org. Key. |
145 | 30 | Job Ledger Org. Key Title. |
175 | 8 | Job Ledger Object Code. |
183 | 30 | Job Ledger Object Code Title. |
213 | 16 | Primary Reference (Invoice Number). |
229 | 16 | Secondary Reference. |
245 | 16 | Encumbrance PO Number. |
261 | 1 | Encumbrance Partial Pay Flag ("P" or "F"). |
262 | 30 | Transaction description (item description). |
292 | 8 | Due Date, in MM/DD/YY format. |
300 | 12 | Product ID. |
312 | 4 | Miscellaneous Code. |
316 | 1 | Person/Entity database identification code. |
317 | 2 | Posting Code. |
319 | 5 | Discount Terms percent. |
324 | 2 | Relate Code number 1. |
326 | 2 | Relate Code number 2. |
328 | 8 | Batch ID. |
336 | 4 | Preparer's Initials. |
340 | 4 | Tax Code number 1. |
344 | 4 | Tax Code number 2. |
348 | 4 | Charge Code. |
352 | 4 | Duty Code. |
356 | 8 | General Ledger background part number 1. |
364 | 8 | General Ledger background part number 2. |
372 | 8 | General Ledger background part number 3. |
380 | 8 | General Ledger background part number 4. |
388 | 8 | General Ledger background part number 5. |
396 | 8 | General Ledger background part number 6. |
404 | 8 | General Ledger background part number 7. |
412 | 8 | General Ledger background part number 8. |
Record "02" - Numeric Values (NO)
Number ID | Description |
---|---|
1 | Distribution amount. |
2 | Reference amount (total Invoice). |
3 | Discount amount. |
4 | Retail amount. |
5 | Distribution amount - Discount amount + Tax amount. |
6 | Distribution amount * Units. |
7 | Number of units. |
8 | Unit price. |
9 | Charge amount. |
10 | Total all positive Distribution amounts. |
11 | Total all negative Distribution amounts. |
12 | Tax amount number 1. |
13 | Tax amount number 2. |
14 | Duty amount. |
15 | Claim # or Batch Key for Open Hold Payments. |
16 | Manually calculated tape total. |
17 | IFAS unique Job Number. |
18 | Sequence number within Job Number. |
19 | Direct Address of Transaction. |
20 | Location where check number is written. |
Record "03" - Character Information (CH) – Invoice Info – Summary
Start | Length | Description |
---|---|---|
1 | 8 | Date of Invoice in MM/DD/YY format. |
9 | 8 | Form date in MM/DD/YY format. |
17 | 2 | Stock ID. |
19 | 16 | Primary Reference (Invoice Number). |
35 | 12 | Person/Entity ID. |
47 | 2 | Relate Code number 1. |
49 | 2 | Relate Code number 2. |
51 | 16 | Encumbrance PO Reference. |
67 | 30 | Description on first Distribution amount. |
97 | 10 | General Ledger Org. Key on first Dist. amount. |
107 | 10 | General Ledger Obj. Code on first Dist. amount. |
117 | 10 | Job Ledger Org. Key on first Distr. amount. |
127 | 10 | Job Ledger Object Code on first Dist. amount. |
137 | 8 | Relating To Codes. |
145 | 16 | Second Reference on first Dist. amount. |
161 | 16 | (Vendor) Account Number |
177 | 8 | GLK Part 1 |
185 | 8 | GLK Part 2 |
193 | 8 | GLK Part 3 |
201 | 8 | GLK Part 4 |
209 | 8 | GLK Part 5 |
217 | 8 | GLK Part 6 |
225 | 8 | GLK Part 7 |
233 | 8 | GLK Part 8 |
241 | 1 | Multiple FQ Accts./Invoice Flag |
242 | 8 | GLO Part 1 |
250 | 8 | GLO Part 2 |
258 | 8 | GLO Part 3 |
266 | 8 | GLO Part 4 |
274 | 8 | GLO Part 5 |
282 | 8 | GLO Part 6 |
290 | 8 | GLO Part 7 |
298 | 8 | GLO Part 8 |
306 | 8 | Invoice Received date |
314 | 16 | Bid Number |
330 | 16 | Contract |
Record "03" - Numeric Values (NO)
Number ID | Description |
---|---|
1 | Total amount for Tax Code number 1. |
2 | Total amount for Reference (e.g., Invoice). |
3 | Total Discount amount. |
4 | Total Invoice - Total Discount + Total Tax 1. |
5 | Total of all Positive amounts. |
6 | Total of all Negative amounts. |
7 | Total amount for Tax Code number 2. |
8 | Total Charge amount. |
9 | Total Duty amount. |
10 | Total number of units. |
11 | Total Unit Price amount. |
Record "04" - Character Information (CH)
Start | Length | Description |
---|---|---|
1 | 40 | Client-defined |
41 | 40 | Client-defined |
81 | 40 | Client-defined |
121 | 40 | Client-defined |
161 | 40 | Client-defined |
201 | 40 | Client-defined |
241 | 40 | Client-defined |
281 | 40 | Client-defined |
321 | 40 | Client-defined |
361 | 40 | Client-defined |
Record "04" can also be printed with five client-defined areas up to 80 characters in length. Values placed are defined in NU Common Codes Category/Value of APCK/SUMMARY. The option is selected by placing "LONG" in the medium description of the common code. In this case, the format of Record "04" would be as follows:
Start | Length | Description |
---|---|---|
1 | 80 | Client-defined |
81 | 80 | Client-defined |
161 | 80 | Client-defined |
241 | 80 | Client-defined |
321 | 80 | Client-defined |
TO Start: Enter the position (left to right) where this field will start printing on the form stock form. First position is 1.
TO Length: Enter the maximum number of positions that may be taken by this field when it is printed on the form stock form.
TO Justify: Enter "L" to have the system Left Justify the value in the print positions reserved for this field: "R" to Right Justify; "C" to Center Justify; or, "A" to have the field printed As Is.
TO Edit Code: If this is a Field "Type" of "CO" or "FC," this field has no effect upon how the value is printed. If the field type is "FC" and the edit code is "01," then the check number will not be incremented in the event of a void-continued check. When the Field "Type" is "NO," "TT," or "CH," enter a value in this field. Select the two-digit number from the bottom of the form that matches how the field is to be edited prior to printing. All dollar amounts are edited with commas; then, if the result will not fit, commas are stripped from the result. The following is a further description of each valid Edit Code:
ED | Meaning |
---|---|
1 | Integer amount, show zero as blank, include commas. |
2 | Integer amount, show zero as blank, no commas. |
3 | Integer, show number of digits as given in Field Length. |
4 | Integer, show num. digits as in Field Length, w/ commas. |
5 | Whole dollars only, showing with the dollar sign ( $ ). |
6 | Whole dollars only, with asterisks before " *** ". |
7 | Show cents part if > 0; else show word "NO." |
8 | Dollars and cents show ( $ ), negatives have "CR." |
9 | Dollars and cents, no decimal point, show zero as blank. |
10 | Dollars and cents, with decimal point, show zero blank |
11 | Dollars and cents, no decimal point. |
12 | Dollars and cents, with decimal point. |
13 | Dollars and cents, w/ decimal point, asterisks before " *** ". |
14 | Dollars and cents, no decimal point, asterisks before " *** ". |
15 | Dollars and cents, no decimal point, show dollar sign ( $ ). |
16 | Edit as words; e.g., "Five Dollars and 27 Cents." |
17 | Dollars and cents, with decimal point, show negative as CR. |
18 | Date shown in words (e.g., June 11, 2014). |
19 | IRS format for dollar values (no commas). |
20 | Open for future use. |
21 | Open for future use. |
Total Plus ( + ) fields: When defining a Field "Type" of "TT," enter up to 10 field numbers to be added in the calculation of the total. Field Numbers must be defined on the Field Definitions tab.
Total Minus ( - ) fields: When defining a Field "Type" of "TT," enter up to 10 field numbers to be added in the calculation of the total. Field Numbers must be defined on the Field Definitions tab.
Total Clear Code: When defining a Field "Type" of "TT," this field is used to specify when the total is to be cleared (reset to zero). Enter "GT" to have the total be a Grand Total across all checks. Enter "PE" to have the total be cleared after each Person or Entity is processed (this is the most typical code). Enter "AP" to have the total be cleared each time it is printed (i.e., line-by-line total).
Record 05 - Character Information (CH)
Start | Length | Description |
---|---|---|
1 | 20 | City |
21 | 2 | State |
23 | 10 | Zip |
33 | 4 | Country Code |
37 | 50 | Contact |
87 | 2 | Salute |
89 | 9 | SSN |
98 | 9 | TIN |
107 | 12 | Nickname |
119 | 4 | Suffix |
123 | 2 | 1099 |
125 | 12 | RALT - ID |
137 | 8 | Owner ID |
145 | 8 | Affiliation Code |
153 | 4 | Due Days |
157 | 2 | ID Status |
159 | 50 | |
209 | 16 | Fax Phone Number |
225 | 50 | Mail/Fax used via common code |
275 | 8 | Bank Acct Type |
283 | 20 | Bank Acct Number |
The Bank Acct Type and Bank Acct Numbers are set up from the PEUPPE page for AP EFTs. If NU Common Codes Category/Value of SYDC/< two-character CKID> exists, the information that is normally written to Records 2 and 3 will be written alternately between Records 2 & 3 and Records 6 & 7. The purpose of this is to allow check stubs with two columns of data. For example:
Invoice Date | Description | Amount | Invoice Date | Description | Amount |
---|---|---|---|---|---|
1/1/2014 | Light Bulbs | 100 | 1/1/2014 | Clean Supl | 15 |
In order to print two or three invoices on one line, place a "3" in the first associated code of SYDC. When this code exists, in addition to writing to records 2 & 3, the process will write additional records as follows:
Normal | Double | Triple |
---|---|---|
2 | 6&7 | 6,7 & 8 |
3 | 9&10 | 9,10 &11 |
The record descriptions for Records 6 & 7 are identical to the descriptions for Records 2 & 3.
Creating AP Check Formats Using User-Defined Data Records
User defined records are enabled by checking the "User Defined Records" option box on the Main tab. When designing a check format decide which data elements will be printed from each record.
- A record #1 will always be first and there can be only one per check.
- A record #2 will exist for every OH transaction that is to be paid.
- A record #3 will exist as a summary of record #2. For example, if sorting by PO#, record #3 will be the summary for a single PO.
Person/Entity Information
Item | Field | Length | Format/Example |
---|---|---|---|
1 | PEID | 12 |
|
2 | PE Name | 50 |
|
3 | PE Name reversed | 50 |
|
4 | Salutation Code | 2 |
|
5 | Salutation Description | 30 |
|
6 | SSN | 11 | xxx-xx-xxxx |
7 | TIN | 10 | xx-xxxxxxx |
8 | Nickname | 12 |
|
9 | Suffix Code | 4 |
|
10 | Suffix Description | 30 |
|
11 | 1099 Flag | 1 |
|
12 | RALT ID | 12 |
|
13 | Owner ID | 12 |
|
14 | Affiliation Code | 8 |
|
15 | Select Code | 18 |
|
16 | Select Code | 28 |
|
17 | Due Days | 3 |
|
18 | PE Status | 2 |
|
19 | Contact | 50 |
|
20 | Type | 2 |
|
21 | Discount Terms | 5 | xx.xx |
22 | Tax Flag | 1 |
|
23 | Tax Rate | 5 | xx.xx |
24 | Bundle Flag | 1 |
|
25 | Address Code Found | 2 |
|
26 | Address line | 140 |
|
27 | Address line | 240 |
|
28 | Address line | 340 |
|
29 | Address line | 440 |
|
30 | City, State & Zip | 40 |
|
31 | City | 20 |
|
32 | State Code | 2 | CA |
33 | State Code Description | 30 | California |
34 | Zip Code | 14 | xxxxx-xxxx |
35 | Country Code | 4 | USA |
36 | Country Code Description | 30 | United States |
37 | Phone Code | 12 |
|
38 | Phone Code | 22 |
|
39 | Phone Code | 32 |
|
40 | Phone Number | 123 | (xxx) xxx-xxxx EXT xxxx |
41 | Phone Number | 223 | (xxx) xxx-xxxx EXT xxxx |
42 | Phone Number | 323 | (xxx) xxx-xxxx EXT xxxx |
50 | RALT ID Name | 50 |
|
51 | RALT ID Name Revers. | 50 |
|
52 | RALT Address line | 140 |
|
53 | RALT Address line | 240 |
|
54 | RALT Address line | 340 |
|
55 | RALT Address line | 440 |
|
56 | RALT City, State & Zip | 40 |
|
57 | RALT City | 20 |
|
58 | RALT State Code | 2 |
|
59 | RALT Zip code | 14 | xxxxx-xxxx |
OH Transaction Information
Item | Field | Length | Format/Example |
---|---|---|---|
100 | PEID | 12 |
|
101 | Invoice Number | 16 |
|
102 | Division Code | 4 |
|
103 | Division Code Description | 30 |
|
104 | GL Ledger Code | 2 |
|
105 | GL Key Code | 10 |
|
106 | GL Object Code | 8 |
|
107 | JL Ledger Code | 2 |
|
108 | JL Key Code | 10 |
|
109 | JL Object Code | 8 |
|
110 | Work Order Number | 12 |
|
111 | Secondary Reference | 16 |
|
112 | Tax Code | 14 |
|
113 | Tax Code | 24 |
|
114 | Charge Code | 4 |
|
115 | Duty Code | 4 |
|
116 | Description of Transaction | 30 |
|
117 | Miscellaneous Code | 4 |
|
118 | Relate-To Code | 12 |
|
119 | Relate-To Code | 22 |
|
120 | Batch ID | 8 |
|
121 | Due Date | 10 | mm/dd/yy or mm/dd/yyyy |
122 | Received Date | 10 | mm/dd/yy or mm/dd/yyyy |
123 | Posting Code | 2 |
|
124 | Transaction Format | 2 |
|
125 | Type |
|
|
126 | Address Code | 2 |
|
127 | Preparer ID | 4 |
|
128 | Product ID | 16 |
|
129 | Measurement | 8 |
|
130 | Partial Pay Flag | 2 |
|
131 | PO Number | 8 |
|
132 | PR Number | 8 |
|
133 | PR Item Number | 4 |
|
134 | Stock (Bank) ID | 2 |
|
135 | Check Date (old) | 10 | mm/dd/yy or mm/dd/yyyy |
136 | Check Date (current) | 10 | mm/dd/yy or mm/dd/yyyy |
137 | Separate Check | 2 |
|
138 | Refund Type | 2 |
|
139 | Vendor Account | 16 |
|
140 | Bid Number | 16 |
|
141 | Contract Number | 16 |
|
142 | Posting Date | 10 | mm/dd/yy or mm/dd/yyyy |
143 | Invoice Date | 10 | mm/dd/yy or mm/dd/yyyy |
144 | Authorize Date | 10 | mm/dd/yy or mm/dd/yyyy |
145 | Former Check Stock ID & Num | 10 | XX9999 |
146 | Check Number | 8 |
|
147 | Current Job Number | 7,999,999 |
|
GL Key Information
Item | Field | Length | Format/Example |
---|---|---|---|
200 | GL Ledger Code | 2 |
|
201 | Key Code | 10 |
|
202 | Key Part 1 Code | 8 |
|
203 | Key Part 2 Code | 8 |
|
204 | Key Part 3 Code | 8 |
|
205 | Key Part 4 Code | 8 |
|
206 | Key Part 5 Code | 8 |
|
207 | Key Part 6 Code | 8 |
|
208 | Key Part 7 Code | 8 |
|
209 | Key Part 8 Code | 8 |
|
210 | Key Part 1 Description | 16 |
|
211 | Key Part 2 Description | 16 |
|
212 | Key Part 3 Description | 16 |
|
213 | Key Part 4 Description | 16 |
|
214 | Key Part 5 Description | 16 |
|
215 | Key Part 6 Description | 16 |
|
216 | Key Part 7 Description | 16 |
|
217 | Key Part 8 Description | 16 |
|
218 | Key Title Medium | 16 |
|
219 | Key Title Long | 30 |
|
220 | Director | 30 |
|
221 | Status | 1 |
|
222 | Type | 1 |
|
223 | Group | 2 |
|
224 | Start Date | 10 | mm/dd/yy or mm/dd/yyyy |
225 | End Date | 10 | mm/dd/yy or mm/dd/yyyy |
226 | Miscellaneous Code | 18 |
|
227 | Miscellaneous Code | 28 |
|
228 | Miscellaneous Code | 38 |
|
229 | Miscellaneous Code | 48 |
|
230 | Miscellaneous Code | 58 |
|
231 | Miscellaneous Code | 68 |
|
232 | Miscellaneous Code | 78 |
|
233 | Miscellaneous Code | 88 |
|
234 | Select Code | 18 |
|
235 | Select Code | 28 |
|
236 | Select Code | 38 |
|
237 | Select Code | 48 |
|
238 | Select Code | 58 |
|
239 | Select Code | 68 |
|
240 | Select Code | 78 |
|
241 | Select Code | 88 |
|
242 | Old Key | 10 |
|
GL Object Information
Item | Field | Length | Format/Example |
---|---|---|---|
300 | GL Ledger Code | 2 |
|
301 | Object Code | 8 |
|
302 | Object Group 1 Code | 8 |
|
303 | Object Group 2 Code | 8 |
|
304 | Object Group 3 Code | 8 |
|
305 | Object Group 4 Code | 8 |
|
306 | Object Group 5 Code | 8 |
|
307 | Object Group 6 Code | 8 |
|
308 | Object Group 7 Code | 8 |
|
309 | Object Group 8 Code | 8 |
|
310 | Object Group 1 Description | 16 |
|
311 | Object Group 2 Description | 16 |
|
312 | Object Group 3 Description | 16 |
|
313 | Object Group 4 Description | 16 |
|
314 | Object Group 5 Description | 16 |
|
315 | Object Group 6 Description | 16 |
|
316 | Object Group 7 Description | 16 |
|
317 | Object Group 8 Description | 16 |
|
318 | Object Title Medium | 16 |
|
319 | Object Title Long | 30 |
|
320 | Director | 30 |
|
321 | Type | 2 |
|
322 | Balance Type | 2 |
|
323 | Start Date | 10 | mm/dd/yy or mm/dd/yyyy |
324 | End Date | 10 | mm/dd/yy or mm/dd/yyyy |
325 | Old Obj | 8 |
|
326 | Status | 2 |
|
JL Key Information
Item | Field | Length | Format/Example |
---|---|---|---|
400 | JL Ledger Code | 2 |
|
401 | Key Code | 10 |
|
402 | Key Part 1 Code | 8 |
|
403 | Key Part 2 Code | 8 |
|
404 | Key Part 3 Code | 8 |
|
405 | Key Part 4 Code | 8 |
|
406 | Key Part 5 Code | 8 |
|
407 | Key Part 6 Code | 8 |
|
408 | Key Part 7 Code | 8 |
|
409 | Key Part 8 Code | 8 |
|
410 | Key Part 1 Description | 16 |
|
411 | Key Part 2 Description | 16 |
|
412 | Key Part 3 Description | 16 |
|
413 | Key Part 4 Description | 16 |
|
414 | Key Part 5 Description | 16 |
|
415 | Key Part 6 Description | 16 |
|
416 | Key Part 7 Description | 16 |
|
417 | Key Part 8 Description | 16 |
|
418 | Key Title Medium | 16 |
|
419 | Key Title Long | 30 |
|
420 | Director | 30 |
|
421 | Status | 1 |
|
422 | Type | 1 |
|
423 | Group | 2 |
|
424 | Start Date | 10 | mm/dd/yy or mm/dd/yyyy |
425 | End Date | 10 | mm/dd/yy or mm/dd/yyyy |
426 | Miscellaneous Code | 18 |
|
427 | Miscellaneous Code | 28 |
|
428 | Miscellaneous Code | 38 |
|
429 | Miscellaneous Code | 48 |
|
430 | Miscellaneous Code | 58 |
|
431 | Miscellaneous Code | 68 |
|
432 | Miscellaneous Code | 78 |
|
433 | Miscellaneous Code | 88 |
|
434 | Select Code | 18 |
|
435 | Select Code | 28 |
|
436 | Select Code | 38 |
|
437 | Select Code | 48 |
|
438 | Select Code | 58 |
|
439 | Select Code | 68 |
|
440 | Select Code | 78 |
|
441 | Select Code | 88 |
|
442 | Old Key | 10 |
|
JL Object Information
Item | Field | Length | Format/Example |
---|---|---|---|
500 | JL Ledger Code | 2 |
|
501 | Object Code | 8 |
|
502 | Object Group 1 Code | 8 |
|
503 | Object Group 2 Code | 8 |
|
504 | Object Group 3 Code | 8 |
|
505 | Object Group 4 Code | 8 |
|
506 | Object Group 5 Code | 8 |
|
507 | Object Group 6 Code | 8 |
|
508 | Object Group 7 Code | 8 |
|
509 | Object Group 8 Code | 8 |
|
510 | Object Group 1 Description | 16 |
|
511 | Object Group 2 Description | 16 |
|
512 | Object Group 3 Description | 16 |
|
513 | Object Group 4 Description | 16 |
|
514 | Object Group 5 Description | 16 |
|
515 | Object Group 6 Description | 16 |
|
516 | Object Group 7 Description | 16 |
|
517 | Object Group 8 Description | 16 |
|
518 | Object Title Medium | 16 |
|
519 | Object Title Long | 30 |
|
520 | Director | 30 |
|
521 | Type | 2 |
|
522 | Balance Type | 2 |
|
523 | Start Date | 10 | mm/dd/yy or mm/dd/yyyy |
524 | End Date | 10 | mm/dd/yy or mm/dd/yyyy |
525 | Old Obj | 8 |
|
526 | Status | 2 |
|
GL Ledger General Information
Item | Field | Length | Format/Example |
---|---|---|---|
600 | GL Ledger Code | 2 |
|
601 | GL Ledger Description | 20 |
|
602 | GL Account formatted | 40 |
|
603 | JL Account formatted | 40 |
|
604 | GL + JL Account | 40 |
|
605 | GL Key Name Short | 4 |
|
606 | GL Key Name Medium | 8 |
|
607 | GL Key Name Long | 16 |
|
608 | GL Object Name Short | 4 |
|
609 | GL Object Name Medium | 8 |
|
610 | GL Object Name Long | 16 |
|
611 | GL Key Part 1 Name Short | 4 |
|
612 | GL Key Part 2 Name Short | 4 |
|
613 | GL Key Part 3 Name Short | 4 |
|
614 | GL Key Part 4 Name Short | 4 |
|
615 | GL Key Part 5 Name Short | 4 |
|
616 | GL Key Part 6 Name Short | 4 |
|
617 | GL Key Part 7 Name Short | 4 |
|
618 | GL Key Part 8 Name Short | 4 |
|
619 | GL Key Part 1 Name Medium | 8 |
|
620 | GL Key Part 2 Name Medium | 8 |
|
621 | GL Key Part 3 Name Medium | 8 |
|
622 | GL Key Part 4 Name Medium | 8 |
|
623 | GL Key Part 5 Name Medium | 8 |
|
624 | GL Key Part 6 Name Medium | 8 |
|
625 | GL Key Part 7 Name Medium | 8 |
|
626 | GL Key Part 8 Name Medium | 8 |
|
627 | GL Key Part 1 Name Long | 16 |
|
628 | GL Key Part 2 Name Long | 16 |
|
629 | GL Key Part 3 Name Long | 16 |
|
630 | GL Key Part 4 Name Long | 16 |
|
631 | GL Key Part 5 Name Long | 16 |
|
632 | GL Key Part 6 Name Long | 16 |
|
633 | GL Key Part 7 Name Long | 16 |
|
634 | GL Key Part 8 Name Long | 16 |
|
635 | GL Object Group 1 Name Short | 4 |
|
636 | GL Object Group 2 Name Short | 4 |
|
637 | GL Object Group 3 Name Short | 4 |
|
638 | GL Object Group 4 Name Short | 4 |
|
639 | GL Object Group 5 Name Short | 4 |
|
640 | GL Object Group 6 Name Short | 4 |
|
641 | GL Object Group 7 Name Short | 4 |
|
642 | GL Object Group 8 Name Short | 4 |
|
643 | GL Object Group 1 Name Med | 8 |
|
644 | GL Object Group 2 Name Med | 8 |
|
645 | GL Object Group 3 Name Med | 8 |
|
646 | GL Object Group 4 Name Med | 8 |
|
647 | GL Object Group 5 Name Med | 8 |
|
648 | GL Object Group 6 Name Med | 8 |
|
649 | GL Object Group 7 Name Med | 8 |
|
650 | GL Object Group 8 Name Med | 8 |
|
651 | GL Object Group 1 Name Long | 16 |
|
652 | GL Object Group 2 Name Long | 16 |
|
653 | GL Object Group 3 Name Long | 16 |
|
654 | GL Object Group 4 Name Long | 16 |
|
655 | GL Object Group 5 Name Long | 16 |
|
656 | GL Object Group 6 Name Long | 16 |
|
657 | GL Object Group 7 Name Long | 16 |
|
658 | GL Object Group 8 Name Long | 16 |
|
JL Ledger General Information
Item | Field | Length | Format/Example |
---|---|---|---|
700 | JL Ledger Code | 2 |
|
701 | JL Ledger Description | 20 |
|
702 | GL Account formatted | 40 |
|
703 | JL Account formatted | 40 |
|
704 | GL + JL Account formatted | 40 |
|
705 | JL Key Name Short | 4 |
|
706 | JL Key Name Medium | 8 |
|
707 | JL Key Name Long | 16 |
|
708 | JL Object Name Short | 4 |
|
709 | JL Object Name Medium | 8 |
|
710 | JL Object Name Long | 16 |
|
711 | JL Key Part 1 Name Short | 4 |
|
712 | JL Key Part 2 Name Short | 4 |
|
713 | JL Key Part 3 Name Short | 4 |
|
714 | JL Key Part 4 Name Short | 4 |
|
715 | JL Key Part 5 Name Short | 4 |
|
716 | JL Key Part 6 Name Short | 4 |
|
717 | JL Key Part 7 Name Short | 4 |
|
718 | JL Key Part 8 Name Short | 4 |
|
719 | JL Key Part 1 Name Medium | 8 |
|
720 | JL Key Part 2 Name Medium | 8 |
|
721 | JL Key Part 3 Name Medium | 8 |
|
722 | JL Key Part 4 Name Medium | 8 |
|
723 | JL Key Part 5 Name Medium | 8 |
|
724 | JL Key Part 6 Name Medium | 8 |
|
725 | JL Key Part 7 Name Medium | 8 |
|
726 | JL Key Part 8 Name Medium | 8 |
|
727 | JL Key Part 1 Name Long | 16 |
|
728 | JL Key Part 2 Name Long | 16 |
|
729 | JL Key Part 3 Name Long | 16 |
|
730 | JL Key Part 4 Name Long | 16 |
|
731 | JL Key Part 5 Name Long | 16 |
|
732 | JL Key Part 6 Name Long | 16 |
|
733 | JL Key Part 7 Name Long | 16 |
|
734 | JL Key Part 8 Name Long | 16 |
|
735 | JL Object Group 1 Name Short | 4 |
|
736 | JL Object Group 2 Name Short | 4 |
|
737 | JL Object Group 3 Name Short | 4 |
|
738 | JL Object Group 4 Name Short | 4 |
|
739 | JL Object Group 5 Name Short | 4 |
|
740 | JL Object Group 6 Name Short | 4 |
|
741 | JL Object Group 7 Name Short | 4 |
|
742 | JL Object Group 8 Name Short | 4 |
|
743 | JL Object Group 1 Name Med | 8 |
|
744 | JL Object Group 2 Name Med | 8 |
|
745 | JL Object Group 3 Name Med | 8 |
|
746 | JL Object Group 4 Name Med | 8 |
|
747 | JL Object Group 5 Name Med | 8 |
|
748 | JL Object Group 6 Name Med | 8 |
|
749 | JL Object Group 7 Name Med | 8 |
|
750 | JL Object Group 8 Name Med | 8 |
|
751 | JL Object Group 1 Name Long | 16 |
|
752 | JL Object Group 2 Name Long | 16 |
|
753 | JL Object Group 3 Name Long | 16 |
|
754 | JL Object Group 4 Name Long | 16 |
|
755 | JL Object Group 5 Name Long | 16 |
|
756 | JL Object Group 6 Name Long | 16 |
|
757 | JL Object Group 7 Name Long | 16 |
|
758 | JL Object Group 8 Name Long | 16 |
|
Product Code Information
Item | Field | Length | Format/Example |
---|---|---|---|
800 | Product ID | 16 |
|
801 | Product Description | 30 |
|
802 | Unit of Measure | 8 |
|
803 | Stock Flag | 2 |
|
804 | Status | 2 |
|
805 | Commodity Code | 16 |
|
806 | Class Code | 2 |
|
807 | Primary Vendor ID | 12 |
|
808 | Secondary Vendor ID | 12 |
|
809 | Buyer ID | 12 |
|
810 | Object Code | 18 |
|
811 | Object Code | 28 |
|
Heading: SYFLSP03
Start: Enter the position (left to right) where this field will start printing on the check stock form. First position is 1.
Length: Enter the maximum number of positions that may be taken by this field when it is printed on the check stock form.
Item Number: The following rules apply to using the Item field:
- The User Defined Record flag on page 1 must be set to "Y."
- When defining a character (CH) type field, you must use an item number.
- Item numbers may only be used with character (CH) type fields.
- Start positions must be within the range 100 through 420.
- The start position plus the length of a field cannot exceed position 420.
An item number of zero indicates that instead of plugging in a predefined data element, simply extract data from that position. This allows you to print a substring of any data element. For example, one field would specify that the invoice date (item 101) is in positions 100 through 107 (in mm/dd/yy format). Another field would have an item number of zero, but a start of 106 and a length of 2. This would result in printing just the year (e.g., "14") from the date.
To Start: Enter the position (left to right) where this field will start printing on the check stock form. First position is 1.
Length: Enter the maximum number of positions that may be taken by this field when it is printed on the check stock form.
Justify: Enter "L" to have the system Left Justify the value in the print positions reserved for this field: "R" to Right Justify; "C" to Center Justify; or, "A" to have the field printed As Is.
Edit Num: If this is a Field "Type" of "CO" or "FC," this field has no effect upon how the value is printed. If the field type is "FC" and the edit code is "01," then the check number will not be incremented in the event of a void-continued check. When the Field "Type" is "NO," "TT," or "CH," enter a value in this field. Select the two-digit number from the bottom of the form that matches how the field is to be edited prior to printing. All dollar amounts are edited with commas; then, if the result will not fit, commas are stripped from the result.
ED Meaning
01 Integer amount, show zero as blank, include commas.
02 Integer amount, show zero as blank, no commas.
03 Integer, show number of digits as given in Field Length.
04 Integer, show number of digits as in Field Length, w/ commas.
05 Whole dollars only, showing with the dollar sign ( $ ).
06 Whole dollars only, with asterisks before " *** ".
Plus Fields: When defining a Field "Type" of "TT," enter up to 10 field numbers to be added in the calculation of the total. Plus Field numbers must be defined on the Field Definition tab.
Minus Fields: When defining a Field "Type" of "TT," enter up to 10 field numbers to be subtracted in the calculation of the total. Minus Field numbers must be defined on the Field Definition tab.
Clear Code: When defining a Field "Type" of "TT," this field is used to specify when the total is to be cleared (reset to zero). Enter "GT" to have the total be a Grand Total across all checks. Enter "PE" to have the total be cleared after each Person or Entity is processed (this is the most typical code). Enter "AP" to have the total be cleared each time it is printed (i.e., line-by-line total).