CreateBillingLinesFromChangeMgmt

Get Update Contract Billing Line Detail

Minor Business Rule

Object Name: N5200020

Parent DLL: CCRIN

Location: Client/Server

Language: NER

Data Structure

D5200020A - Create Billing Lines From Change Management

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
mnContractNumber	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.
szContractType	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
szContractCompany	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.
szContractChangeNumber	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.
jdChangeDate	CHD	JDEDATE	REQ	INPUT
The date of last change for the change order. This date will control general ledger processing for the change order.
szChangeOrderDescription	RMK	char	REQ	INPUT
A generic field that you use for a remark, description, name, or address.
szBillingLineItem	OPIM	char	REQ	INPUT
The pay item number as defined by the owner. This field is alphanumeric and can be up to 15 characters in length. It is recommended that you use numeric information for this pay item number.
szBillingLineDescription	DL01	char	REQ	INPUT
A user defined name or remark.
cBillingLineType	PRTP	char	REQ	INPUT
A code that specifies the billing terms that are defined by the billing line on the contract. The system uses the predefined codes for the pricing type to access formulas and other information related to the calculation of billing and revenue amounts for the billing line. Valid alphabetic codes are: B Burden T Time and Materials U Unit Price L Lump Sum F Fee Line C Component M Milestone P Progress D Direct Draw R Rated Draw Valid numeric codes are: 0 Burden 1 Time and Materials 2 Unit Price 3 Lump Sum 4 Fee Line 5 Component 6 Milestone 7 Progress 8 Direct Draw 9 Rated Draw
mnScheduleOfValues	SCOF	MATH_NUMERIC	REQ	INPUT
The expected or budgeted amount assigned to a specific line item of the contract. The system uses this amount in conjunction with the percent of completion to calculate billing and retainage.
szUnitOfMeasure	UM	char	OPT	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.
mnQuantity	U	MATH_NUMERIC	OPT	INPUT
The quantity of something that is identified by a unit of measure. For example, it can be the number of barrels, boxes, cubic yards, gallons, hours, and so on.
mnUnitPrice	UP	MATH_NUMERIC	OPT	INPUT
The list or base price you charge for one primary or pricing unit of this item.
szBusinessUnit	MCU	char	REQ	INPUT
An alphanumeric code that identifies a separate entity within a business for which you want to track costs. For example, a business unit might be a warehouse location, job, project, work center, branch, or plant. You can assign a business unit to a document, entity, or person for purposes of responsibility reporting. For example, the system provides reports of open accounts payable and accounts receivable by business unit to track equipment by responsible department. Business unit security might prevent you from viewing information about business units for which you have no authority.
szSubsidiary	SUB	char	REQ	INPUT
A subset of an object account. Subsidiary accounts include detailed records of the accounting activity for an object account.
szObject	OBJ	char	REQ	INPUT
The portion of a general ledger account that refers to the division of the Cost Code (for example, labor, materials, and equipment) into subcategories. For example, you can divide the Cost Code for labor into regular time, premium time, and burden. Note: If you use a flexible chart of accounts and the object account is set to 6 digits, J.D. Edwards recommends that you use all 6 digits. For example, entering 000456 is not the same as entering 456 because if you enter 456 the system enters three blank spaces to fill a 6-digit object.
szSubledger	SBL	char	OPT	INPUT
A code that identifies a detailed, auxiliary account within a general ledger account. A subledger can be an equipment item number or an address book number. If you enter a subledger, you must also specify the subledger type.
cSubledgerType	SBLT	char	OPT	INPUT
A user defined code (00/ST) that is used with the Subledger field to identify the subledger type and how the system performs subledger editing. On the User Defined Codes form, the second line of the description controls how the system performs editing. This is either hard-coded or user defined. Valid values include: A Alphanumeric field, do not edit N Numeric field, right justify and zero fill C Alphanumeric field, right justify and blank fill
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.
cNewOrExistingChgOrder	EV01	char	REQ	INPUT
An option that specifies the type of processing for an event.
cProofOrFinalMode	EV01	char	OPT	INPUT
An option that specifies the type of processing for an event.
szErrorCode	DTAI	char	OPT	OUTPUT
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.
szCrossRefBusinessUnit	MCU	char	REQ	INPUT
An alphanumeric code that identifies a separate entity within a business for which you want to track costs. For example, a business unit might be a warehouse location, job, project, work center, branch, or plant. You can assign a business unit to a document, entity, or person for purposes of responsibility reporting. For example, the system provides reports of open accounts payable and accounts receivable by business unit to track equipment by responsible department. Business unit security might prevent you from viewing information about business units for which you have no authority.
szCrossRefObject	OBJ	char	REQ	INPUT
The portion of a general ledger account that refers to the division of the Cost Code (for example, labor, materials, and equipment) into subcategories. For example, you can divide the Cost Code for labor into regular time, premium time, and burden. Note: If you use a flexible chart of accounts and the object account is set to 6 digits, J.D. Edwards recommends that you use all 6 digits. For example, entering 000456 is not the same as entering 456 because if you enter 456 the system enters three blank spaces to fill a 6-digit object.
szCrossRefSubsidiary	SUB	char	REQ	INPUT
A subset of an object account. Subsidiary accounts include detailed records of the accounting activity for an object account.
szCrossRefSubledger	SBL	char	REQ	INPUT
A code that identifies a detailed, auxiliary account within a general ledger account. A subledger can be an equipment item number or an address book number. If you enter a subledger, you must also specify the subledger type.
cCrossRefSubledgerType	SBLT	char	REQ	INPUT
A user defined code (00/ST) that is used with the Subledger field to identify the subledger type and how the system performs subledger editing. On the User Defined Codes form, the second line of the description controls how the system performs editing. This is either hard-coded or user defined. Valid values include: A Alphanumeric field, do not edit N Numeric field, right justify and zero fill C Alphanumeric field, right justify and blank fill

Related Functions

None

Related Tables

None

GetContractBillingLineDetail

Get Update Contract Billing Line Detail

Minor Business Rule

Object Name: N5200020

Parent DLL: CCRIN

Location: Client/Server

Language: NER

This Business Function will retrieve one Contract Billing Line Detail (F5202) record. If no record is found, a Read Flag will be set to "0" and sent back to
the calling program. If a record is found the Read Flag will be set to "1" and sent back to the calling program. The function will also update a Contract
Billing Line Detail record. ( not in BSFN yet ).
Modes flags will determine what keys are being sent to fetch data from the F5202. The modes are as follows:
Blank = DOCO, DCTO, KCOO and COCH (P5201 / P5202)
1 = DOCO, DCTO, KCOO, COCH, LNID, and OPIM (P5222)
2= DOCO, DCTO, KCOO. (P52250)

Data Structure

D5200020 - Get Update Contract Billing Line Detail

DOCOContract Number                       I/O
DCTOType                                     I/O
KCOOContract Company                    I/O
COCHContract Change Number     I/O
LnidLine Number                     I/O
opimOwner Pay Item                      I/O
DL01Description01                     I/O
sd1Planned Start Date       O
sd3Planned Completion Date       O
chdChange Date                       O
trmoTerms Only                       O
chstChange Status                       O
rtnrRetainage Rule                       O
rtn1Retainage Rule Stored MaterialO
rtncRetainage Rule Change Order   O
mcusProject Number                       O
mcuBusiness Unit                       O
objObject Account                       O
subSubsidiary                       O
sblSubledger                       O
sbltSubledger Type                       O
coCompany                       O
glcG/L Offset                       O
prtpPricing Type                       O
scofSchedule of Values       O
fsofSchedule of Values  Foreign   O
rsofSchedule of Values  Restated O
uUnits                                       O
umUnit of Measure                       O
up Price per Unit                       O
fupForeign Unit Price       O
rupRestated Unit Price       O
exr1Tax Explanation Code       O
txa1Tax Rate/Area                       O
stamTax                                       O
atxnNon-Taxable Amount       O
atxaTaxable Amount                       O
ntexNot to Exceed                       O
FnteNot to Exceed - Foreign       O
rnteNot to Exceed - Restated       O
ntecNot to Exceed - Change Order Amount O
fntoNot to Exceed - Chg Ord Amt - ForeignO
rntoNot to Exceed - Chg Ord Amt - RestatedO
nteuNot to Exceed - Units       O
rrbcRecurring Billing Code       O
rrbaRecurring Billing Amount       O
FrbaRecurring Billing Amount -  Foreign O
rrraRecurring Billing Amount - RestatedO
exmpExempt Code                       O
alsqAlternate Sequence Code       O
blspBill Suspend                       O
blwpBill When Paid                       O
pywpPay When Paid                       O
mcblCurrent Billing Method       O
mkrpMark Up Percent                       O
fbasInvoice Fee Basis                       O
rfbsRevenue Fee Basis       O
racdRate Code Contract       O
roluRoll Units                       O
r001Bill Item Code                       O
accoAccount Override Flag       O
ad01Contract Category Code 1       O
ad02Contract Category Code 2       O
ad03Contract Category Code 3       O
ad04Contract Category Code 4       O
ad05Contract Category Code 5       O
ctf1Control Flag 1                       O
CTF2Control Flag 2                       O
CTF3Control Flag 3                       O
CTF4Control Flag 4                       O
CTF5Control Flag 5                       O
rmkRemark                                       O
tagReference Tag                       O
crrExchange Rate                       O
crcdCurrency Code From       O
crcfCurrency Code Origin       O
CRRDCurrency Conversion Rate Div I/O
crrmCurrency Mode                       O
PIDProgram ID                       O
JOBNWorkstation ID                       O
USERUser ID                                       O
MUPMDate Record Updated       O
UPMTTime Last Updated       O
EV01Read Flag                     I/O
EV01Mode Flag                     I

^

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
mnContractNumber	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.
szType	DCTO	char	REQ	INPUT

szContractCompany	KCOO	char	REQ	INPUT
^
szDescription001	DL01	char	OPT	OUTPUT
A user defined name or remark.
szCostCenterSubsequent	MCUS	char	OPT	OUTPUT
Either a subsequent business unit or a project number. A subsequent business unit specifies where to charge costs (or revenues) when the original business unit has been closed or suspended. For example, the subsequent business unit can be used in corporate reorganizations when you close a business unit and direct all costs to the subsequent business unit. In this situation, you must enter journal entries to transfer existing balances. A project number is used to group business units within an overall business unit. For example, you can group jobs by project. In this case, the project business unit can also have accounts for tracking overhead costs that can be allocated to jobs.
szCompany	CO	char	OPT	OUTPUT
A code that identifies a specific organization, fund, or other reporting entity. The company code must already exist in the Company Constants table (F0010) and must identify a reporting entity that has a complete balance sheet. At this level, you can have intercompany transactions. Note: You can use company 00000 for default values such as dates and automatic accounting instructions. You cannot use company 00000 for transaction entries.
szRetainageRule	RTNR	char	OPT	OUTPUT
A rule the system uses to calculate retainage on a contract. For example: Retn % - 10.00; Percent Complete - 50.00 Retn % - 5.00; Percent Complete - 95.00 This rule indicates that there is a 10% retainage until 50% of the job is complete. Then a 5% retainage is calculated for the next 45% of the job until 95% of the job is complete. Once 95% of the job is complete, retainage is no longer withheld.
szCurrencyCodeFrom	CRCD	char	OPT	OUTPUT
A code that identifies the currency of a transaction.
szCurrencyCodeOrigin	CRCF	char	OPT	OUTPUT
The currency code of the insured amount.
cCurrencyMode	CRRM	char	OPT	BOTH
An option that specifies whether the system displays amounts in the domestic or foreign currency. On The system displays amounts in the foreign currency of the transaction. Off The system displays amounts in the domestic currency of the transaction.
mnNotToExceed	NTEX	MATH_NUMERIC	OPT	OUTPUT
The maximum billing amount. You can specify not-to-exceed amounts for: o Contracts, which apply to the entire contract and all related change orders. o Change orders, which apply only to specific change orders. o Billing lines, which apply only to individual billing lines.
mnNottoExceedAmountRestate	RNTE	MATH_NUMERIC	OPT	OUTPUT
Reserved by J.D. Edwards.
mnCurrencyConverRateOv	CRR	MATH_NUMERIC	OPT	OUTPUT
A number (exchange rate) that a foreign currency amount is multiplied by to calculate a domestic currency amount. The number in this field can have a maximum of seven decimal positions. If more are entered, the system adjusts to the nearest seven decimal positions.
mnCurrencyConverRateDiv	CRRD	MATH_NUMERIC	OPT	BOTH
A number (exchange rate) that a foreign currency amount is divided by to calculate a domestic currency amount. The number you enter in this field can have a maximum of seven decimal positions. If more are entered, the system adjusts to the nearest seven decimal positions.
szProgramId	PID	char	OPT	OUTPUT
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.
szWorkStationId	JOBN	char	OPT	OUTPUT
The code that identifies the work station ID that executed a particular job.
szUserId	USER	char	OPT	OUTPUT
The code that identifies a user profile.
jdDateRecordUpdated	MUPM	JDEDATE	OPT	OUTPUT
The date of last update. Used in the Financial Reporting Merge file (F1011) where field name is duplicated.
mnTimeLastUpdated	UPMT	MATH_NUMERIC	OPT	OUTPUT
The time that specifies when the program executed the last update to this record.
cReadFlag	EV01	char	OPT	BOTH
An option that specifies the type of processing for an event.
szContractChangeNum	COCH	char	OPT	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	OPT	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.
szOwnerPayItem	OPIM	char	OPT	INPUT
The pay item number as defined by the owner. This field is alphanumeric and can be up to 15 characters in length. It is recommended that you use numeric information for this pay item number.
jdPlannedStartDate	SD1	JDEDATE	OPT	OUTPUT
The date you plan to start work on the contract.
jdPlannedCompDate	SD3	JDEDATE	OPT	OUTPUT
The date of planned completion for the contract.
jdDateChange	CHD	JDEDATE	OPT	OUTPUT
The date of last change for the change order. This date will control general ledger processing for the change order.
cTermsOnly	TRMO	char	OPT	OUTPUT
A code that specifies whether this change affects contract terms other than price, such as an extension in time or a change in schedule. Valid vaules are: Y Yes, the change does affect terms. N No, the change does not affect terms.
szChangeStatus	CHST	char	OPT	OUTPUT
A user defined code (system 52, code CH) that indicates the change order status of a contract.
szRetainageRuleStoredMt	RTN1	char	OPT	OUTPUT
The Retainage Rule defined for Stored Material. See Data Item "RTNR".
szRetainageRuleChange	RTNC	char	OPT	OUTPUT
Retainage Rule defined at the Change Order Level.
szCostCenter	MCU	char	OPT	OUTPUT
An alphanumeric code that identifies a separate entity within a business for which you want to track costs. For example, a business unit might be a warehouse location, job, project, work center, branch, or plant. You can assign a business unit to a document, entity, or person for purposes of responsibility reporting. For example, the system provides reports of open accounts payable and accounts receivable by business unit to track equipment by responsible department. Business unit security might prevent you from viewing information about business units for which you have no authority.
szObjectAccount	OBJ	char	OPT	OUTPUT
The portion of a general ledger account that refers to the division of the Cost Code (for example, labor, materials, and equipment) into subcategories. For example, you can divide the Cost Code for labor into regular time, premium time, and burden. Note: If you use a flexible chart of accounts and the object account is set to 6 digits, J.D. Edwards recommends that you use all 6 digits. For example, entering 000456 is not the same as entering 456 because if you enter 456 the system enters three blank spaces to fill a 6-digit object.
szSubsidiary	SUB	char	OPT	OUTPUT
A subset of an object account. Subsidiary accounts include detailed records of the accounting activity for an object account.
szSubledger	SBL	char	OPT	OUTPUT
A code that identifies a detailed, auxiliary account within a general ledger account. A subledger can be an equipment item number or an address book number. If you enter a subledger, you must also specify the subledger type.
cSubledgerType	SBLT	char	OPT	OUTPUT
A user defined code (00/ST) that is used with the Subledger field to identify the subledger type and how the system performs subledger editing. On the User Defined Codes form, the second line of the description controls how the system performs editing. This is either hard-coded or user defined. Valid values include: A Alphanumeric field, do not edit N Numeric field, right justify and zero fill C Alphanumeric field, right justify and blank fill
szGlClass	GLC	char	OPT	OUTPUT
A code that determines the trade account that the system uses as the offset when you post invoices or vouchers. The system concatenates the value that you enter to the AAI item RC (for Accounts Receivable) or PC (for Accounts Payable) to locate the trade account. For example, if you enter TRAD, the system searches for the AAI item RCTRAD (for receivables) or PCTRAD (for payables). You can assign up to four alphanumeric characters to represent the G/L offset or you can assign the three-character currency code (if you enter transactions in a multicurrency environment). You must, however, set up the corresponding AAI item for the system to use; otherwise, the system ignores the G/L offset and uses the account that is set up for PC or RC for the company specified. If you set up a default value in the G/L Offset field of the customer or supplier record, the system uses the value during transaction entry unless you override it. Note: Do not use code 9999. It is reserved for the post program and indicates that offsets should not be created.
cPricingType	PRTP	char	OPT	OUTPUT
A code that specifies the billing terms that are defined by the billing line on the contract. The system uses the predefined codes for the pricing type to access formulas and other information related to the calculation of billing and revenue amounts for the billing line. Valid alphabetic codes are: B Burden T Time and Materials U Unit Price L Lump Sum F Fee Line C Component M Milestone P Progress D Direct Draw R Rated Draw Valid numeric codes are: 0 Burden 1 Time and Materials 2 Unit Price 3 Lump Sum 4 Fee Line 5 Component 6 Milestone 7 Progress 8 Direct Draw 9 Rated Draw
mnScheduleOfValues	SCOF	MATH_NUMERIC	OPT	OUTPUT

mnScheduleofValuesForeign	FSOF	MATH_NUMERIC	OPT	OUTPUT

mnScheduleofValuesRestated	RSOF	MATH_NUMERIC	OPT	OUTPUT
Reserved by J.D. Edwards.
mnUnits	U	MATH_NUMERIC	OPT	OUTPUT
The quantity of something that is identified by a unit of measure. For example, it can be the number of barrels, boxes, cubic yards, gallons, hours, and so on.
szUnitOfMeasure	UM	char	OPT	OUTPUT
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.
mnPricePerUnit	UP	MATH_NUMERIC	OPT	OUTPUT
The list or base price you charge for one primary or pricing unit of this item.
mnAmtForPricePerUnit	FUP	MATH_NUMERIC	OPT	OUTPUT
The foreign price per unit.
mnAmountRestatedPriceperUn	RUP	MATH_NUMERIC	OPT	OUTPUT
Reserved by J.D. Edwards.
szTaxExplanationCode1	EXR1	char	OPT	OUTPUT
A hard-coded user defined code (00/EX) that controls the algorithm that the system uses to calculate tax and G/L distribution amounts. The system uses the tax explanation code in conjunction with the tax rate area and tax rules to determine how the tax is calculated. Each transaction pay item can be defined with a different tax explanation code.
szTaxArea1	TXA1	char	OPT	OUTPUT
A code that identifies a tax or geographic area that has common tax rates and tax authorities. The system validates the code you enter against the Tax Areas table (F4008). The system uses the tax rate area in conjunction with the tax explanation code and tax rules to calculate tax and G/L distribution amounts when you create an invoice or voucher.
mnAmtTax2	STAM	MATH_NUMERIC	OPT	OUTPUT
The amount assessed and payable to tax authorities. It is the total of the VAT, use, and sales taxes (PST).
mnAmountTaxExempt	ATXN	MATH_NUMERIC	OPT	OUTPUT
The amount upon which taxes are not assessed. This is the portion of the transaction not subject to sales, use, or VAT taxes because the products are tax-exempt or zero-rated.
mnAmountTaxable	ATXA	MATH_NUMERIC	OPT	OUTPUT
The amount on which taxes are assessed.
mnNottoExceedAmountForeign	FNTE	MATH_NUMERIC	OPT	OUTPUT
The foreign maximum billing amount. This amount applies only to individual billing lines.
mnNotToExceedChgOrd	NTEC	MATH_NUMERIC	OPT	OUTPUT
The contracted amount beyond which you have agreed not to bill the customer. You can speccify a Not-to-Exceed (NTE) amount at any of the following three levels of a contract: o Contract. The amount applies to the entire contract and all subsequent change orders. o Change order. The amount applies to the specific change order. o Billing line. The amount applies to the specific billing line.
mnNotToExceedChgOrderForei	FNTO	MATH_NUMERIC	OPT	OUTPUT
The maximum foreign billing amount. This amount applies to the change order.
mnNottoExceedChgOrderAmt-R	RNTO	MATH_NUMERIC	OPT	OUTPUT
Reserved by J.D. Edwards.
mnNotToExceedUnits	NTEU	MATH_NUMERIC	OPT	OUTPUT
This field specifies the unit limit for a contract at the owner pay item level.
szRecurringBillingCode	RRBC	char	OPT	OUTPUT
A code that specifies the frequency of the recurring billing amount for the billing line, such as M, MO, or MON for monthly. You can generate invoices that include a recurring billing amount by specifying the recurring billing code in the processing options for the Invoice Generation program (R52121) or on the Create Manual Invoice form of the Create Manual Invoice program (P52121). Valid values are stored in UDC 52/RB.
mnRecurringBillingAmt	RRBA	MATH_NUMERIC	OPT	OUTPUT
A fixed amount you want to bill with each recurring frequency.
mnRecurringBillingAmountRe	RRRA	MATH_NUMERIC	OPT	OUTPUT
Reserved by J.D. Edwards.
cExemptCode	EXMP	char	OPT	OUTPUT
An option that allows you to override, on a billing line-by-billing line basis, the Not to Exceed limit expressed at the contract header or change order level. Valid values are: Blank No NTE rule specified. 1 Exempt from NTE limits for revenue and invoice processing. 2 The NTE limit applies to invoice and revenue amounts at this level. 3 The NTE limit applies to revenue amounts at this level. If invoice processing exceeds the limit, the system issues a warning. 4 The NTE limit applies to invoice amounts at this level. If revenue processing exceeds the limit, the system issues a warning
szAlternateSequenceCode	ALSQ	char	OPT	OUTPUT
Alternate Sequence Code used to display contract information in a sequence other than the default line number sequence (Future Use).
cBillSuspend	BLSP	char	OPT	OUTPUT
The Billing Rule Flag attaches to each pay item on a contract. The flag indicates: blank Add billing records to the Invoice Summary Work file (F4822) and bill the appropriate amounts. 1 Add billing records to the work file but do not bill any amounts. 2 Do not create billing records for the work file. 3 Add billing records to the work file and ignore any Not to Exceed Limits. Note: This field works with the NTE field. The flag determines how the system handles a situation where the NTE has been exceeded.
cBillWhenPaid	BLWP	char	OPT	OUTPUT
An option that indicates when invoices can be billed to the owner of the contract. Valid values are: Blank Supplier invoices, both paid and unpaid, can be billed. 1 Only supplier invoices that have been paid can be billed.
cPayWhenPaid	PYWP	char	OPT	OUTPUT
This field is used to identify Pay When Paid transactions. Accounts Payable A 'W' will be used to identify Pay When Paid Voucher transactions.
cCurrentBillingMethod	MCBL	char	OPT	OUTPUT
This field controls how pro-forma current billing amount is calculated. blank Method based on percent complete for referenced costs. 1 Method based on contract header percent complete using percent complete correlated with billing date.
mnMarkUpPercent	MKRP	MATH_NUMERIC	OPT	OUTPUT
Percent of markup you want the system to use when it calculates the billing amounts for fee lines for owner pay items. You enter either a percent in this field or a rate code in the Rate Code field. Enter the percentage as a whole number. For example, you enter 10% as 10
cFeeBasisCostOrInv	FBAS	char	OPT	OUTPUT
The fee basis the system will use when it derives the billing amount for the fee line. Valid values: 1 Use Invoice Amount. 2 Use Cost Amount.
cRevenueFeeBasis	RFBS	char	OPT	OUTPUT
The fee basis the system will use when it derives the revenue amount for the fee line. 1 Use Revenue Amount 2 Use Cost Amount If you leave this field blank, the system automatically selects the revenue amount.
szRateCodeContract	RACD	char	OPT	OUTPUT
Rate Code used in the Contract Billing System for Owner Pay Items which are Fee based lines. By defining a specific rate code, you have the ability to set up date sensitive fee percentages.
cRollUnits	ROLU	char	OPT	OUTPUT
This is a flag for Time and Material items to tell the system whether or not to roll the sum of the detail workfile (F4812) units into the summary billing workfile (F4822). blank Do not roll units 1 Add units if the unit of measure in the F4812 file matches that in Owner Pay Item Detail (F5202).
szCategoryCodeGl001	R001	char	OPT	OUTPUT
Category code 1 associated with the Account Master table (F0901). This is a user defined code (09/01) for use in flex account mapping and in printing selected information on reports.
cAccountOverrideFlag	ACCO	char	OPT	OUTPUT
An option that specifies whether the account information for a billing line identifies a revenue or cost (source) account. The system automatically supplies the account information (business unit, object, subsidiary, subledger, and subledger type) from the automatic accounting instructions (system 52, code BC). You can also enter a specific account. All billing lines, with the exception of T and M, use the account information. Note: When this option is set to 1, the account information identifies a cost account. The system processes the billing line against the Billing AAI Information table (F48S95) during journal generation. This is similar to how the system processes a T and M billing line.
szContractCode1	AD01	char	OPT	OUTPUT
Contract Category Code 1. A user defined category code (system 52, code A1) you can define to meet the specific needs of a contract.
szContractCode2	AD02	char	OPT	OUTPUT
Contract Category Code 2. A user defined category code (system 52, code A2) you can define to meet the specific needs of a contract.
szContractCode3	AD03	char	OPT	OUTPUT
Contract Category Code 3. A user defined category code (system 52, code A3) you can define to meet the specific needs of this line item in the contract.
szContractCode4	AD04	char	OPT	OUTPUT
Contract Category Code 4
szContractCode5	AD05	char	OPT	OUTPUT
Contract Category Code 5
cControlFlag1	CTF1	char	OPT	OUTPUT
This control flag is used to override the service billing constants eligibility code when work file records (F4812) are created during invoicing. Possible Values Are: 0 Eligible For Invoicing and Revenue Recognition. 1 Eligible for Invoicing only. 2 Eligible for Revenue Recognition only. 3 Non Billable. 4 Eligible for Cost only. blank No override.
cControlFlag2	CTF2	char	OPT	OUTPUT
A marker that is used internally to determine whether a Not-To-Exceed limit has been set at any level in the contract.
cControlFlag3	CTF3	char	OPT	OUTPUT
A value that determines how progress billing lines are cross referenced. 1 This value defines this progress billing line as a basis line; it's billing events are determined by it's own cross-reference. A progress billing line becomes a basis line when another progress billing line is cross-referenced to it. 2 This value defines this progress billing line as a dependent line; it's billing events are determined by the progress basis line to which it is cross-referenced. A progress billing line becomes a dependent when it is cross-referenced to another progress line.
cControlFlag4	CTF4	char	OPT	OUTPUT
Reserved by J.D. Edwards.
cControlFlag5	CTF5	char	OPT	OUTPUT
A code that specifies how the system processes the Not-to-Exceed (NTE) limits for a contract. You can define this code at the contract level, change order level, or billing line level, or any combination of the three. Valid values are: Blank No NTE rule is specified. 1 Exempt from NTE limits for revenue and invoice processing. This code is valid only at the change order or billing line level. 2 The NTE limit applies to invoice and revenue amounts at this level. 3 The NTE limit applies to revenue amounts at this level. If invoice processing exceeds the limit, the system issues a warning. 4 The NTE limit applies to invoice amounts at his level. If revenue processing exceeds the limit, the system issues a warning.
szNameRemark	RMK	char	OPT	OUTPUT
A generic field that you use for a remark, description, name, or address.
szTagReference	TAG	char	OPT	OUTPUT
(Future Use) In anticipation of the future creation of a Physical Count facility within the inventory system which allows for the use of pre-numbered multi-part tags.
mnRecurrBillingAmountFo	FRBA	MATH_NUMERIC	OPT	OUTPUT
A fixed amount that you want to bill with each recurring frequency.
cModeFlag	EV02	char	OPT	INPUT
An option that specifies the type of processing for an event.
szVertexTransactionType	VVTY	char	OPT	OUTPUT
Vertex Sales and Use Tax transaction type.
szVertexProductCategory	VVTC	char	OPT	OUTPUT
User defined code used in the Vertex Tax Decision Maker for products or services that are non-taxable or are at a non-stanard rate.

Related Functions

None

Related Tables

None

UpdateRtngRuleForChgOrdZero

Get Update Contract Billing Line Detail

Minor Business Rule

Object Name: N5200020

Parent DLL: CCRIN

Location: Client/Server

Language: NER

Data Structure

D5200020B - Update Retainage Rule for Chg Order Zero Data Structure

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
mnDocumentOrderInvoiceE_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.
szOrderType_DCTO	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
szCompanyKeyOrderNo_KCOO	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	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.
szRetainageRule_RTNR	RTNR	char	REQ	INPUT
A rule the system uses to calculate retainage on a contract. For example: Retn % - 10.00; Percent Complete - 50.00 Retn % - 5.00; Percent Complete - 95.00 This rule indicates that there is a 10% retainage until 50% of the job is complete. Then a 5% retainage is calculated for the next 45% of the job until 95% of the job is complete. Once 95% of the job is complete, retainage is no longer withheld.

Related Functions

None

Related Tables

None