CSMSUpdateActBillPayAmts

Recalc Actual Billable/Payable Amounts

Minor Business Rule

Object Name: N1702100

Parent DLL: CCRIN

Location: Client/Server

Language: NER

This function will re-extend and update the actual billable and actual payment amounts when a planned
part is issued (F31171) or when time is recorded against routings (F31172).

Mode:
0 = Process issued parts (update F31171).
1 = Process time against routings (update F31172).

Data Structure

D1702100 - Recalc Actual Billable/Payable Amounts

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
cMode_EV01	EV01	char	REQ	INPUT
0 = Update Parts list CSMS extension (F31171) with actual billable and payable amounts. 1 = Update Routing Instructions CSMS extension (F31172) with actual billable and payable amounts.
mnCustomer_AN8	AN8	MATH_NUMERIC	REQ	INPUT
Parts list: Customer number on detail parts list line (from F3111). Routings: Not used.
mnOrderNo_DOCO	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.
mnComponentItem_ITM	ITM	MATH_NUMERIC	REQ	INPUT
An inventory item number. The system provides three separate item numbers plus an extensive cross-reference capability to other item numbers (see data item XRT) to accommodate substitute item numbers, replacements, bar codes, customer numbers, supplier numbers, and so forth. The item numbers are as follows: o Item Number (short) - An eight-digit, computer-assigned item number o 2nd Item Number - The 25-digit, free-form, user defined alphanumeric item number o 3rd Item Number - Another 25-digit, free-form, user defined alphanumeric item number
szCostCenter_MMCU	MMCU	char	REQ	INPUT
Parts list: Branch plant Routings: Work Center
szPartLocation_LOCN	LOCN	char	REQ	INPUT
The storage location from which goods will be moved.
szPartLot_LOTN	LOTN	char	REQ	INPUT
A number that identifies a lot or a serial number. A lot is a group of items with similar characteristics.
szPartLineType_LNTY	LNTY	char	REQ	INPUT
A code that controls how the system processes lines on a transaction. It controls the systems with which the transaction interfaces, such as General Ledger, Job Cost, Accounts Payable, Accounts Receivable, and Inventory Management. It also specifies the conditions under which a line prints on reports, and it is included in calculations. Codes include the following: S Stock item J Job cost N Nonstock item F Freight T Text information M Miscellaneous charges and credits W Work order
jdTransactionDate_TRDJ	TRDJ	JDEDATE	REQ	INPUT
The date that an order was entered into the system. This date determines which effective level the system uses for inventory pricing.
mnActualQuantity_TRQT	TRQT	MATH_NUMERIC	REQ	INPUT
Actual parts list quantity.
szPartUnitOfMeasure_UM	UM	char	REQ	INPUT
A user defined code (00/UM) that identifies the unit of measurement for an amount or quantity. For example, it can represent a barrel, box, cubic meter, liter, hour, and so on.
mnPartUniqueKeyID_UKID	UKID	MATH_NUMERIC	REQ	INPUT
This field is a unique number used to identify a record in a file.
mnRoutingOpSeq_OPSQ	OPSQ	MATH_NUMERIC	REQ	INPUT
A number used to indicate an order of succession. In routing instructions, a number that sequences the fabrication or assembly steps in the manufacture of an item. You can track costs and charge time by operation. In bills of material, a number that designates the routing step in the fabrication or assembly process that requires a specified component part. You define the operation sequence after you create the routing instructions for the item. The Shop Floor Management system uses this number in the backflush/preflush by operation process. In engineering change orders, a number that sequences the assembly steps for the engineering change. For repetitive manufacturing, a number that identifies the sequence in which an item is scheduled to be produced. Skip To fields allow you to enter an operation sequence that you want to begin the display of information. You can use decimals to add steps between existing steps. For example, use 12.5 to add a step between steps 12 and 13.
szRoutingOpCode_OPSC	OPSC	char	REQ	INPUT
A user defined code (30/OT) that indicates the type of operation. Valid values include: A Alternate routing TT Travel time IT Idle time T Text
mnActualHrs_LABA	LABA	MATH_NUMERIC	REQ	INPUT
Actual hours entered for routing instruction
szProgramId_PID	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.
cSuppressErrors_EV01	EV01	char	OPT	NONE
An option that specifies the type of processing for an event.
cErrorCode_ERRC	ERRC	char	OPT	NONE
This error code indicates if any errors occurred during the creation of the Trip Document Detail (F4914) records by the Delivery Document Set Server program (XT4914).
szErrorMsgID_DTAI	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