F1794RetrieveVerifyCalculate

F1794 Retrieve Verify Calculate

Minor Business Rule

Object Name: N1700070

Parent DLL: CCRIN

Location: Client/Server

Language: NER

1.1Purpose
This NER has three different purposes.

1.It can be used to simply retrieve the F1794 record.
2.It can be used to verify if a specific period number has been billed/moved/amortized within the 1794.
3.It can be used to total the amount that has been billed/moved/amortized for a given contract.  This mode can be broken down into 4 different
modes:

a.Calculate total amount moved/billed/amortized for a given contract.
b.Calculate total amount moved/billed/amortized for a specific fiscal year of a contract.
c.Calculate total amount moved/billed/amortized for the period numbers less than or equal to the Period Number passed in, within a
fiscal year.
d.Calculate total amount moved/billed/amortized for the period numbers greater than or equal to the Period Number passed in, within
a fiscal year.

2.4Processing

PeriodFlag = 0
IF Mode = 1 OR Mode = 2
FetchSingle.F1794
IF Record Exists
IF Mode = 2
IF PeriodNumber = 1 AND Period1 <> Blank
PeriodFlag = 1
ELSE

END IF
END IF
END IF
END IF
IF ProcessingMode = 3

IF CalculateMode = 1

Select.F1794
OrderNumber = OrderNumber
OrderType = OrderType
OrderCompany = OrderCompany
ContractChangeNumber = ContractChangeNumber
LineNumber = LineNumber
GenerationType = GenerationType
FetchNext.F1794
Retrieves Amount 1-14
IF File I/O Status <> Success
IF SuppressErrorMessage <> 1

Set NER Error
Error Value = 017F
Parameter = ErrorMessageID
END IF

ErrorMessageID = 017F
END IF
WHILE  File I/O Status = Success
TotalAmount = TotalAmount + Amount1 + Amount2, etc.

FetchNext.F1794
END WHILE

END IF (CalculateMode = 1)
IF CalculateMode = 2 OR 3 OR 4
FetchSingle.F1794
OrderNumber = OrderNumber
OrderType = OrderType
OrderCompany = OrderCompany
ContractChangeNumber = ContractChangeNumber
LineNumber = LineNumber
GenerationType = GenerationType
Century = Century
FiscalYear = FiscalYear
IF CalculateMode = 2

TotalAmount = TotalAmount + Amount1 + Amount2 + Amount3 + Amount4 + Amount5 +  Amount6
+ Amount7 + Amount8 + Amount9 + Amount10 +  Amount11 + Amount12 + Amount13 + Amount14

END IF (CalculateMode = 2)
IF CalculateMode = 3

IF PeriodNumber =1
TotalAmount = Amount01
ELSE
IF PeriodNumber = 2
TotalAmount = Amount01 + Amount02

ELSE

END IF (CalculateMode = 3)
IF CalculateMode = 4

IF PeriodNumber =14
TotalAmount = Amount14
ELSE
IF PeriodNumber = 13
TotalAmount = Amount13 + Amount14
ELSE

END IF (CalculateMode = 4)
END IF (CalculateMode = 2, 3, 4)

END IF (ProcessingMode = 3)

Data Structure

D1700070 - F1794 Retrieve Verify Calculate

Parameter Name Data Item Data Type Req/Opt I/O/Both

mnOrderNumber DOCO MATH_NUMERIC REQ INPUT

A number that identifies an original document. This document can be a voucher, a sales order, an invoice, unapplied cash, a journal entry,
and so on.

szOrderType DCTO char REQ INPUT

A user defined code (00/DT) that identifies the type of document. This code also indicates the origin of the transaction. J.D. Edwards has
reserved document type codes for vouchers, invoices, receipts, and time sheets, which create automatic offset entries during the post
program. (These entries are not self-balancing when you originally enter them.) The following document types are defined by J.D. Edwards and
should not be changed: P Accounts Payable documents   R Accounts Receivable documents   T Payroll documents   I Inventory documents
O Purchase Order Processing documents   J General Accounting/Joint Interest Billing documents   S Sales Order Processing documents

szOrderCompany KCOO char REQ INPUT

A number that, along with order number and order type, uniquely identifies an order document (such as a purchase order, a contract, a
sales order, and so on). If you use the Next Numbers by Company/Fiscal Year facility, the Automatic Next Numbers program (X0010) uses the
order company to retrieve the correct next number for that company. If two or more order documents have the same order number and order
type, the order company lets you locate the desired document. If you use the regular Next Numbers facility, the order company is not used to
assign a next number. In this case, you probably would not use the order company to locate the document.

szContractChangeNum COCH char REQ INPUT

The change number of the contract. The change order number of the base contract is always initialized to 000. Each time you enter a
change order for a contract, the system automatically increases the change order number by one. For example, the base contract is the change
order number 000, the first change order is 001, the second is 002, and so on.

mnLineNumber LNID MATH_NUMERIC REQ INPUT

A number that identifies multiple occurrences, such as line numbers on a purchase order or other document. Generally, the system assigns
this number,but in some cases you can override it.

cGenerationType GENT char REQ INPUT

A code that identifies the type of billing transaction. Examples:    1 Recurring Billings    2 Expense Participation    3 Sales Overage    4
Escalation    5 A/R Fees and Interest    6 Estimated Expense Participation    7 Manual Invoice

cProcessingMode EV01 char REQ INPUT

1 = Retrieve F1794 record.
2 = Verify if specific period number has been billed/moved/amortized within the F1794.
3 = Total the amount billed/moved/amortized for a given contract.

*Century and Fiscal Year are required if Mode = 1 or 2.  Period Number is required if Mode = 2.
^

mnCentury CTRY MATH_NUMERIC OPT NONE

Required for modes 1 & 2.  Required for mode 3, if you are using calculate mode 2, 3, or 4.
^

mnFiscalYear FY MATH_NUMERIC OPT NONE

Required for modes 1 & 2.  Required for mode 3, if you are using calculate mode 2, 3, or 4.
^

mnPeriodNumber PN MATH_NUMERIC OPT NONE

Required for processing mode 2 & 3(if using calculate mode 3 or 4).
^

cSuppressErrorMessage SUPPS char OPT NONE

1 = Suppress Error Messages
Blank = Do not Suppress Error Messages
^

szErrorMessageID DTAI char OPT NONE

A code that identifies and defines a unit of information. It is an alphanumeric code up to 8 characters long that does not allow blanks or
special characters such as %, &, or +. You create new data items using system codes 55-59. You cannot change the alias.

mnTotalAmount AB01 MATH_NUMERIC OPT NONE

The amount that is billed or amortized for period 01.

cPeriodFlag EV01 char OPT NONE

1 = Yes, period has been billed/moved/amortized.
0 = No, period has not been billed/moved/amortized.
^

cPeriod01 BF01 char OPT NONE

Corresponds to Calendar billing period 01, typically January, or to the first fiscal period of the billing year.

cPeriod02 BF01 char OPT NONE

Corresponds to Calendar billing period 01, typically January, or to the first fiscal period of the billing year.

cPeriod03 BF01 char OPT NONE

Corresponds to Calendar billing period 01, typically January, or to the first fiscal period of the billing year.

cPeriod04 BF01 char OPT NONE

Corresponds to Calendar billing period 01, typically January, or to the first fiscal period of the billing year.

cPeriod05 BF01 char OPT NONE

Corresponds to Calendar billing period 01, typically January, or to the first fiscal period of the billing year.

cPeriod06 BF01 char OPT NONE

Corresponds to Calendar billing period 01, typically January, or to the first fiscal period of the billing year.

cPeriod07 BF01 char OPT NONE

Corresponds to Calendar billing period 01, typically January, or to the first fiscal period of the billing year.

cPeriod08 BF01 char OPT NONE

Corresponds to Calendar billing period 01, typically January, or to the first fiscal period of the billing year.

cPeriod09 BF01 char OPT NONE

Corresponds to Calendar billing period 01, typically January, or to the first fiscal period of the billing year.

cPeriod10 BF01 char OPT NONE

Corresponds to Calendar billing period 01, typically January, or to the first fiscal period of the billing year.

cPeriod11 BF01 char OPT NONE

Corresponds to Calendar billing period 01, typically January, or to the first fiscal period of the billing year.

cPeriod12 BF01 char OPT NONE

Corresponds to Calendar billing period 01, typically January, or to the first fiscal period of the billing year.

cPeriod13 BF01 char OPT NONE

Corresponds to Calendar billing period 01, typically January, or to the first fiscal period of the billing year.

cPeriod14 BF01 char OPT NONE

Corresponds to Calendar billing period 01, typically January, or to the first fiscal period of the billing year.

mnAmount01 AB01 MATH_NUMERIC OPT NONE

The amount that is billed or amortized for period 01.

mnAmount02 AB01 MATH_NUMERIC OPT NONE

The amount that is billed or amortized for period 01.

mnAmount03 AB01 MATH_NUMERIC OPT NONE

The amount that is billed or amortized for period 01.

mnAmount04 AB01 MATH_NUMERIC OPT NONE

The amount that is billed or amortized for period 01.

mnAmount05 AB01 MATH_NUMERIC OPT NONE

The amount that is billed or amortized for period 01.

mnAmount06 AB01 MATH_NUMERIC OPT NONE

The amount that is billed or amortized for period 01.

mnAmount07 AB01 MATH_NUMERIC OPT NONE

The amount that is billed or amortized for period 01.

mnAmount08 AB01 MATH_NUMERIC OPT NONE

The amount that is billed or amortized for period 01.

mnAmount09 AB01 MATH_NUMERIC OPT NONE

The amount that is billed or amortized for period 01.

mnAmount10 AB01 MATH_NUMERIC OPT NONE

The amount that is billed or amortized for period 01.

mnAmount11 AB01 MATH_NUMERIC OPT NONE

The amount that is billed or amortized for period 01.

mnAmount12 AB01 MATH_NUMERIC OPT NONE

The amount that is billed or amortized for period 01.

mnAmount13 AB01 MATH_NUMERIC OPT NONE

The amount that is billed or amortized for period 01.

mnAmount14 AB01 MATH_NUMERIC OPT NONE

The amount that is billed or amortized for period 01.

cCalculateMode EV01 char OPT NONE

1 = Calculate amounts for entire contract.
2 = Calculate amounts for a given fiscal year of a contract.
3 = Calculate amounts for periods less than or equal to period number passed in.
4 = Calculate amounts for periods greater than or equal to period number passed in.

*If you are using Processing Mode = 3, this is a required field.
^

Related Functions

None

Related Tables

None

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
mnOrderNumber	DOCO	MATH_NUMERIC	REQ	INPUT
A number that identifies an original document. This document can be a voucher, a sales order, an invoice, unapplied cash, a journal entry, and so on.
szOrderType	DCTO	char	REQ	INPUT
A user defined code (00/DT) that identifies the type of document. This code also indicates the origin of the transaction. J.D. Edwards has reserved document type codes for vouchers, invoices, receipts, and time sheets, which create automatic offset entries during the post program. (These entries are not self-balancing when you originally enter them.) The following document types are defined by J.D. Edwards and should not be changed: P Accounts Payable documents R Accounts Receivable documents T Payroll documents I Inventory documents O Purchase Order Processing documents J General Accounting/Joint Interest Billing documents S Sales Order Processing documents
szOrderCompany	KCOO	char	REQ	INPUT
A number that, along with order number and order type, uniquely identifies an order document (such as a purchase order, a contract, a sales order, and so on). If you use the Next Numbers by Company/Fiscal Year facility, the Automatic Next Numbers program (X0010) uses the order company to retrieve the correct next number for that company. If two or more order documents have the same order number and order type, the order company lets you locate the desired document. If you use the regular Next Numbers facility, the order company is not used to assign a next number. In this case, you probably would not use the order company to locate the document.
szContractChangeNum	COCH	char	REQ	INPUT
The change number of the contract. The change order number of the base contract is always initialized to 000. Each time you enter a change order for a contract, the system automatically increases the change order number by one. For example, the base contract is the change order number 000, the first change order is 001, the second is 002, and so on.
mnLineNumber	LNID	MATH_NUMERIC	REQ	INPUT
A number that identifies multiple occurrences, such as line numbers on a purchase order or other document. Generally, the system assigns this number,but in some cases you can override it.
cGenerationType	GENT	char	REQ	INPUT
A code that identifies the type of billing transaction. Examples: 1 Recurring Billings 2 Expense Participation 3 Sales Overage 4 Escalation 5 A/R Fees and Interest 6 Estimated Expense Participation 7 Manual Invoice
cProcessingMode	EV01	char	REQ	INPUT
1 = Retrieve F1794 record. 2 = Verify if specific period number has been billed/moved/amortized within the F1794. 3 = Total the amount billed/moved/amortized for a given contract. *Century and Fiscal Year are required if Mode = 1 or 2. Period Number is required if Mode = 2. ^
mnCentury	CTRY	MATH_NUMERIC	OPT	NONE
Required for modes 1 & 2. Required for mode 3, if you are using calculate mode 2, 3, or 4. ^
mnFiscalYear	FY	MATH_NUMERIC	OPT	NONE
Required for modes 1 & 2. Required for mode 3, if you are using calculate mode 2, 3, or 4. ^
mnPeriodNumber	PN	MATH_NUMERIC	OPT	NONE
Required for processing mode 2 & 3(if using calculate mode 3 or 4). ^
cSuppressErrorMessage	SUPPS	char	OPT	NONE
1 = Suppress Error Messages Blank = Do not Suppress Error Messages ^
szErrorMessageID	DTAI	char	OPT	NONE
A code that identifies and defines a unit of information. It is an alphanumeric code up to 8 characters long that does not allow blanks or special characters such as %, &, or +. You create new data items using system codes 55-59. You cannot change the alias.
mnTotalAmount	AB01	MATH_NUMERIC	OPT	NONE
The amount that is billed or amortized for period 01.
cPeriodFlag	EV01	char	OPT	NONE
1 = Yes, period has been billed/moved/amortized. 0 = No, period has not been billed/moved/amortized. ^
cPeriod01	BF01	char	OPT	NONE
Corresponds to Calendar billing period 01, typically January, or to the first fiscal period of the billing year.
cPeriod02	BF01	char	OPT	NONE
Corresponds to Calendar billing period 01, typically January, or to the first fiscal period of the billing year.
cPeriod03	BF01	char	OPT	NONE
Corresponds to Calendar billing period 01, typically January, or to the first fiscal period of the billing year.
cPeriod04	BF01	char	OPT	NONE
Corresponds to Calendar billing period 01, typically January, or to the first fiscal period of the billing year.
cPeriod05	BF01	char	OPT	NONE
Corresponds to Calendar billing period 01, typically January, or to the first fiscal period of the billing year.
cPeriod06	BF01	char	OPT	NONE
Corresponds to Calendar billing period 01, typically January, or to the first fiscal period of the billing year.
cPeriod07	BF01	char	OPT	NONE
Corresponds to Calendar billing period 01, typically January, or to the first fiscal period of the billing year.
cPeriod08	BF01	char	OPT	NONE
Corresponds to Calendar billing period 01, typically January, or to the first fiscal period of the billing year.
cPeriod09	BF01	char	OPT	NONE
Corresponds to Calendar billing period 01, typically January, or to the first fiscal period of the billing year.
cPeriod10	BF01	char	OPT	NONE
Corresponds to Calendar billing period 01, typically January, or to the first fiscal period of the billing year.
cPeriod11	BF01	char	OPT	NONE
Corresponds to Calendar billing period 01, typically January, or to the first fiscal period of the billing year.
cPeriod12	BF01	char	OPT	NONE
Corresponds to Calendar billing period 01, typically January, or to the first fiscal period of the billing year.
cPeriod13	BF01	char	OPT	NONE
Corresponds to Calendar billing period 01, typically January, or to the first fiscal period of the billing year.
cPeriod14	BF01	char	OPT	NONE
Corresponds to Calendar billing period 01, typically January, or to the first fiscal period of the billing year.
mnAmount01	AB01	MATH_NUMERIC	OPT	NONE
The amount that is billed or amortized for period 01.
mnAmount02	AB01	MATH_NUMERIC	OPT	NONE
The amount that is billed or amortized for period 01.
mnAmount03	AB01	MATH_NUMERIC	OPT	NONE
The amount that is billed or amortized for period 01.
mnAmount04	AB01	MATH_NUMERIC	OPT	NONE
The amount that is billed or amortized for period 01.
mnAmount05	AB01	MATH_NUMERIC	OPT	NONE
The amount that is billed or amortized for period 01.
mnAmount06	AB01	MATH_NUMERIC	OPT	NONE
The amount that is billed or amortized for period 01.
mnAmount07	AB01	MATH_NUMERIC	OPT	NONE
The amount that is billed or amortized for period 01.
mnAmount08	AB01	MATH_NUMERIC	OPT	NONE
The amount that is billed or amortized for period 01.
mnAmount09	AB01	MATH_NUMERIC	OPT	NONE
The amount that is billed or amortized for period 01.
mnAmount10	AB01	MATH_NUMERIC	OPT	NONE
The amount that is billed or amortized for period 01.
mnAmount11	AB01	MATH_NUMERIC	OPT	NONE
The amount that is billed or amortized for period 01.
mnAmount12	AB01	MATH_NUMERIC	OPT	NONE
The amount that is billed or amortized for period 01.
mnAmount13	AB01	MATH_NUMERIC	OPT	NONE
The amount that is billed or amortized for period 01.
mnAmount14	AB01	MATH_NUMERIC	OPT	NONE
The amount that is billed or amortized for period 01.
cCalculateMode	EV01	char	OPT	NONE
1 = Calculate amounts for entire contract. 2 = Calculate amounts for a given fiscal year of a contract. 3 = Calculate amounts for periods less than or equal to period number passed in. 4 = Calculate amounts for periods greater than or equal to period number passed in. *If you are using Processing Mode = 3, this is a required field. ^