F1794AddUpdate

F1794 Add Update

Minor Business Rule

Object Name: N1700110

Parent DLL: CCRIN

Location: Client/Server

Language: NER

1.1Purpose
The NER will first attempt to add an F1794 record.  The record will be added with the Period fields set to 'Blank' and the 'Amount' fields set to '0'.  The
NER will then update the record according to the Period Number and Amount passed in.  The update is not dependant on if a record was added, as the
record could already exist and just needs to be updated.

2.4Processing
Get Audit Information
Insert.F1794
IF File I/O Staus <> Success
FetchSingle.F1794
END IF
IF PeriodActionFlag = 1
Change appropriate Period Flag to 'X'
ELSE
IF PeriodActionFlag = 2
Change appropriate Period Flag to 'Blank'
END IF
END IF
IF AmountActionFlag = 1
Replace current amount with Amount passed in for appropriate period
ELSE
IF AmountActionFlag = 2
Add Amount passed in to current amount for appropriate period
ELSE
IF AmountActionFlag = 3
Subtract Amount passed in from the current amount for appropriate period
END IF
END IF
END IF
Update.F1794

Data Structure

D1700110 - F1794 Add Update

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

szProgramId PID char REQ INPUT

The number that identifies the batch or interactive program (batch or interactive object). For example, the number of the Sales Order Entry
interactive program is P4210, and the number of the Print Invoices batch process report is R42565. The program ID is a variable length value.
It is assigned according to a structured syntax in the form TSSXXX, where: T The first character of the number is alphabetic and identifies the
type, such as P for Program, R for Report, and so on. For example, the value P in the number P4210 indicates that the object is a
program. SS The second and third characters of the number are numeric and identify the system code. For example, the value 42 in the number P4210
indicates that this program belongs to system 42, which is the Sales Order Processing system. XXX The remaining characters of the numer are
numeric and identify a unique program or report. For example, the value 10 in the number P4210 indicates that this is the Sales Order Entry
program.

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 = CSMS Amortization
B = CSMS Billing
C = CSMS Reallocations
^

mnCentury CTRY MATH_NUMERIC REQ INPUT

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
(1998, 1999), 20 indicates any year beginning with 20 (2000, 2001), and so on.

mnFiscalYear FY MATH_NUMERIC REQ INPUT

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
year (as defined on the Company Setup form). Specify the year at the end of the first period rather than the year at the end of the fiscal period.
For example, a fiscal year begins October 1, 1998 and ends September 30, 1999. The end of the first period is October 31, 1998. Specify the
year 98 rather than 99.

cAmountActionFlag EV01 char REQ INPUT

1 = Replace current amount with new Amount passed in.
2 = Add Amount passed in to current amount.
3 = Subtract Amount passed in from current amount.
^

cPeriodActionFlag EV01 char REQ INPUT

1 = Change file flag to on.
2 = Change file flag to off.
^

mnPeriodNumber PN MATH_NUMERIC REQ INPUT

A number indicating the current accounting period.  This number, used in conjunction with the Company Constants table (F0010) and the
General Constants table (F0009), allows the user to define up to 14 accounting periods. See General Ledger Date.  The current period number
is used to determine posted before and posted after cut off warning messages.  It is also used as the default accounting period in the
preparation of financial reports.

mnAmount AB01 MATH_NUMERIC REQ INPUT

The amount that is billed or amortized for period 01.

cSuppressErrorMessage SUPPS char OPT NONE

Blank = Do not suppress error messages
1 = 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.

Related Functions

None

Related Tables

None

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
szProgramId	PID	char	REQ	INPUT
The number that identifies the batch or interactive program (batch or interactive object). For example, the number of the Sales Order Entry interactive program is P4210, and the number of the Print Invoices batch process report is R42565. The program ID is a variable length value. It is assigned according to a structured syntax in the form TSSXXX, where: T The first character of the number is alphabetic and identifies the type, such as P for Program, R for Report, and so on. For example, the value P in the number P4210 indicates that the object is a program. SS The second and third characters of the number are numeric and identify the system code. For example, the value 42 in the number P4210 indicates that this program belongs to system 42, which is the Sales Order Processing system. XXX The remaining characters of the numer are numeric and identify a unique program or report. For example, the value 10 in the number P4210 indicates that this is the Sales Order Entry program.
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 = CSMS Amortization B = CSMS Billing C = CSMS Reallocations ^
mnCentury	CTRY	MATH_NUMERIC	REQ	INPUT
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 (1998, 1999), 20 indicates any year beginning with 20 (2000, 2001), and so on.
mnFiscalYear	FY	MATH_NUMERIC	REQ	INPUT
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 year (as defined on the Company Setup form). Specify the year at the end of the first period rather than the year at the end of the fiscal period. For example, a fiscal year begins October 1, 1998 and ends September 30, 1999. The end of the first period is October 31, 1998. Specify the year 98 rather than 99.
cAmountActionFlag	EV01	char	REQ	INPUT
1 = Replace current amount with new Amount passed in. 2 = Add Amount passed in to current amount. 3 = Subtract Amount passed in from current amount. ^
cPeriodActionFlag	EV01	char	REQ	INPUT
1 = Change file flag to on. 2 = Change file flag to off. ^
mnPeriodNumber	PN	MATH_NUMERIC	REQ	INPUT
A number indicating the current accounting period. This number, used in conjunction with the Company Constants table (F0010) and the General Constants table (F0009), allows the user to define up to 14 accounting periods. See General Ledger Date. The current period number is used to determine posted before and posted after cut off warning messages. It is also used as the default accounting period in the preparation of financial reports.
mnAmount	AB01	MATH_NUMERIC	REQ	INPUT
The amount that is billed or amortized for period 01.
cSuppressErrorMessage	SUPPS	char	OPT	NONE
Blank = Do not suppress error messages 1 = 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.