B03B0120
F03B08 - Sort Ending Date
Functional Description
Purpose
This function ensures that anytime grid records are added or updated to the F03B08, that they have
the correct beginning date (DTBG) and that Period Days(DAYP)is calculated if it was left blank on the
form. This function uses CO, FY, and CTRY to select all records meeting this criteria in the F03B08.
It is called twice from P03B08 on All Grid Records Added to DB and All Grid Records Updated to DB.
Setup Notes and Prerequisites
Special Logic
Technical Specifications
Parameters
Data ItemData Structure DescriptionI/ORequiredNotes
COCompanyIYes
FYFiscal YearIYes
CTRYCenturyIYes
Related Tables
F03B08Credit/Collection Date Pattern
Related Business Functions
None
Processing
Select F03B08.* From F03B08 Where F03B08.CO = lpDS.Company, F03B08.FY=lpDS.FiscalYear, and
F03B08.CTRY=lpDS.Century;
SORT ascending according to F03B08.DTEN;
Fetch records;
If successful
While Fetch successful
^
^
D03B0120 - F03B08 Sort Ending Date
| Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
|---|---|---|---|---|
| szCompany | CO | char | NONE | NONE |
A code that identifies a specific organization, fund, or other reporting entity. The company code must already exist in the Company
| ||||
| mnFiscalYear1 | FY | MATH_NUMERIC | NONE | NONE |
A number that identifies the fiscal year. Generally, you can either enter a number in this field or leave it blank to indicate the current fiscal
| ||||
| mnCentury | CTRY | MATH_NUMERIC | NONE | NONE |
The calendar century associated with the year. Enter is the first two digits of
the year. For example, 19 indicates any year beginning with 19
| ||||
| None |
| F03B08 Credit/Collection Date Pattern |