GetContractMasterInformation

Get Update Contract Master Record

Minor Business Rule

Object Name: N5200010

Parent DLL: CCRIN

Location: Client/Server

Language: NER

This Business Function will retrieve one Contract Master (F5201) record. If no record is found, an error will be passed back to the calling program. The
function will also update a Contract Master record. The specific fields updated will depend on the value of the processing flag. The function will also
determine if a contract is a parent contract of another contract.
If the Contract is in an active invoice or revenue batch and that batch or invoice is deleted then the invoice or revenue batch number will be set to zero.

Data Structure

D5200010 - Get Contract Master Information

DOCOContract Number   I/OYes
DCTOType                        I/O                Yes
KCOOContract Compa                 I/O
ICUInvoice Batch                 I/O
ICUJRevenue Batch                 I/O
DL01Description01                   O
DL02Description02                   O
DL03Description03                   O
DCCompressed Description   O
ODCMOwner Contract                    O
OCNCOwner Contract Compress   O
AN8OCustomer Address Number   O
ANOBAlternate Billing Address   O
AN8KArchitect Address Number   O
ADCMArchitect Contract   O
USA1User Add Num1                   O
USA2User Add Num2                   O
USA3User Add Num3                   O
USA4Remit To Address   O
USA5Send To Address                   O
DSContract Status                   O
CTContract Type                   O
MCUSProject Job                   O
JMCUHost Business Unit   O
COCompany                   O
PCTNParent Contract Number   O
PCTTParent Contract Type   O
PCKOParent Contract Company   O
RTNRRetainage Rule                   O
RGLCGL Offset Retention   O
RTN1Retainage Rule Stored Mat   O
RCTLRetainage Control Flag   O
EXR1Tax Explanation Code   O
TXA1Tax Area                   O
INVFInvoice Format Code   O
AIABAIA Billing Form                   O
CTOVContract Override Rule   O
PTCPayment Terms Code   O
BLWPBill When Paid                   O
PYWPPay When Paid                   O
BROVBurden Override                   O
FSLVFee Summarization Level   O
CRCDBase Currency                    O
CRCFBilling Currency                   O
CRRMContract Currency Mode   O
CRRContract Exchange Rate I/O
NTEXNot To Exceed                 I/O
NTEFNot To Exceed  Foreign I/O
RNTENot To Exceed Amount RestatedO
ERDBDate Exchange Rate Date BasisO
LMEXLimit Exceeded Flag  I/O
MCIAMinimum Contract Amount I/O
MCIFMinimum Contract Amount  Foreign I/O
CSDTContract Start Date    O
CDTEContract End Date    O
USD1Planned Start Date    O
USD2Planned Completion Date    O
USD3User Date 3                    O
USD4User Date 4                    O
AI01Aia Cat Code1                    O
AI02Aia Cat Code2                    O
AI03Aia Cat Code3                    O
AI04Aia Cat Code4                    O
AI05Aia Cat Code5                    O
AI11Aia Cat Code11                    O
AI12Aia Cat Code12                    O
AI13Aia Cat Code13                    O
AI14Aia Cat Code14                    O
AI15Aia Cat Code15                    O
CRRDCurrency Conversion Rate DivO
CTF2Cntl Flag 2                  I/O
CTF3Cntl Flag 3                     O
CTF4Cntl Flag 4                     O
CTF5Cntl Flag 5                     O
BCTKBatch Control Key     O
PIDProgram ID                  I/O
JOBNWorkstation ID                     O
USERUser ID                                     O
MUPMDate Record Updated     O
UPMTTime Last Updated     O
DTAIError Message                      O
EV01Process Flag                   I/O

^

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
mnContractNumber	DOCO	MATH_NUMERIC	REQ	BOTH
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	BOTH
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	OPT	BOTH
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.
mnRevenueBatch	ICU	MATH_NUMERIC	OPT	BOTH
A number that identifies a group of transactions that the system processes and balances as a unit. When you enter a batch, you can either assign a batch number or let the system assign it using the Next Numbers program.
mnInvoiceBatch	ICUJ	MATH_NUMERIC	OPT	BOTH
A batch number the system automatically assigns when you run Revenue Journal Generation.
szDescription01	DL01	char	OPT	OUTPUT
A user defined name or remark.
szDescription02	DL02	char	OPT	OUTPUT
Additional text that further describes or clarifies a field in the system.
szDescription03	DL03	char	OPT	OUTPUT
Additional text that further describes or clarifies an element.
szCompressedDescription	DC	char	OPT	OUTPUT
The compressed description contains the alpha name without slashes, dashes, commas, and other special characters. The compressed description is the field used in the Name Search.
szOwnerContract	ODCM	char	OPT	OUTPUT
The contract number as recorded on the owner's books. If you enter this number on the Contract Master Revisions form, you can use it as a search criterion on the Contract Search form. The system updates this number in the reference field (VR01) of the accounts receivable record for billing.
szOwnerContractCompress	OCNC	char	OPT	OUTPUT
The compressed owner contract number contains the number without spaces,slashes, dashes, commas, and other special characters. The compressed number is the field used in Contract Search.
mnCustomerAddressNumber	AN8O	MATH_NUMERIC	OPT	OUTPUT
The address book number to which the system posts billing and accounts receivable transactions.
mnAlternateBillingAddress	ANOB	MATH_NUMERIC	OPT	OUTPUT
The address number of an alternate location to which the owner wants the invoice (application) sent.
mnArchitectAddressNumber	AN8K	MATH_NUMERIC	OPT	OUTPUT
The address number of the architect for the contract or project.
mnUserAddNum1	USA1	MATH_NUMERIC	OPT	OUTPUT
User defined address book number. This will be verified against Address Book.
mnUserAddNum2	USA2	MATH_NUMERIC	OPT	OUTPUT
User defined address book number. This will be verified against Address Book.
mnUserAddNum3	USA3	MATH_NUMERIC	OPT	OUTPUT
Address Number 3 - User
mnRemitToAddress	USA4	MATH_NUMERIC	OPT	OUTPUT
Address Number - Remit To
mnSendToAddress	USA5	MATH_NUMERIC	OPT	OUTPUT
User defined address book number. This will be verified against Address Book.
szContrctStatus	DS	char	OPT	OUTPUT
A two-character code that provides status information about a contract. This status is edited against user defined codes (52/CS).
szContractType	CT	char	OPT	OUTPUT
A user defined code (51/CT) that identifies the type of contract.
szProjectJob	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.
szHostBusinessUnit	JMCU	char	OPT	OUTPUT
The Business Unit responsible for the job. This is particularly useful during transfer pricing.
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.
mnParentContractNumber	PCTN	MATH_NUMERIC	OPT	OUTPUT
The parent contract number to which this particular contract is attached.
szParentContractType	PCTT	char	OPT	OUTPUT
The parent contract type to which this particular contract is attached.
szParentContractCompany	PCKO	char	OPT	OUTPUT
Parent Contract Document Company.
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.
szGlOffsetRetention	RGLC	char	OPT	OUTPUT
A code that designates the offset accounts for retainage, for example RETN or 1225. You set up the code as an automatic accounting instruction. Note: Do not use code 9999. This is reserved for the post program and indicates that offsets should not be created.
cRetainageControlFlag	RCTL	char	OPT	OUTPUT
An option that determines whether the retainage amount is stored in the Accounts Receivable or General Accounting system and whether tax is calculated on the whole amount, including the retainage, or on each amount as it is billed. Valid values are: Blank The retainage is stored in the Accounts Receivable system and the tax is computed from the total taxable amount. 1 The retainage is stored in the Accounts Receivable system and the tax on the retainage amount is calculated and then subtracted from the total tax amount. This tax on retainage is deferred until the retainage is released. 2 The retainage is stored in the General Accounting system and the tax is computed from the total taxable amount. 3 The retainage is stored in the General Accounting system and the tax on the retainage amount is calculated and then subtracted from the total tax amount. This tax on retainage is deferred until the retainage is released.
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.
szInvoiceFormatCode	INVF	char	OPT	OUTPUT
A code that uniquely identifies a series of formats and determines the overall layout of the invoice.
szPaymentTermsCode01	PTC	char	OPT	OUTPUT
A code that specifies the terms of payment, including the percentage of discount available if the invoice is paid by the discount due date. Use a blank code to indicate the most frequently-used payment term. You define each type of payment term on the Payment Terms Revisions form. Examples of payment terms include: Blank Net 15 001 1/10 net 30 002 2/10 net 30 003 Due on the 10th day of every month 006 Due upon receipt This code prints on customer invoices.
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.
cFeeSummarizationLevel	FSLV	char	OPT	OUTPUT
The level of detail at which the system creates work file records for fee lines. o If you leave this field blank, the system creates fees at a summarized level, with one work file record (F4812) per fee line. o A value of "1" in this field indicates that the system should create the F4812 records at a detailed level, with one work file record for each unique combination of key values. "Key Values" refers to any value that could be used as a key or a result in the Account Derivation Table. Key value fields include: Subledger - Customer Subledger Type - Home Business Unit Work Order Class - Company Job - Equipment Number Job Class - Component Code
szBaseCurrency	CRCD	char	OPT	OUTPUT
A code that identifies the currency of a transaction.
szBillingCurrency	CRCF	char	OPT	OUTPUT
The currency code of the insured amount.
cContractCurrencyMode	CRRM	char	OPT	OUTPUT
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	BOTH
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.
mnNotToExceedForeign	NTEF	MATH_NUMERIC	OPT	BOTH
The maximum foreign not-to-exceed amount. The foreign not-to-exceed amount applies to the entire contract and all related change orders.
cLimitExceededFlag	LMEX	char	OPT	BOTH
A field that identifies any row (pay item, change order, or contract) for which the NTE limit has been exceeded. If the Billed to Date amount is greater than the NTE limit, the Limit Exceeded field is checked for the affected row. If the billed to date amount is less than the minimum invoice amount for the contract, the Limit Not Reached field is checked for the affected row, indicating that you have underbilled.
mnMinimumContractAmt	MCIA	MATH_NUMERIC	OPT	BOTH
The minimum amount required for the contract. If the billing amount is less than the amount in this field, the system will not generate an invoice.
mnMinimumContractAmtForeign	MCIF	MATH_NUMERIC	OPT	BOTH
The foreign minimum amount required for the contract. If the billing amount is less than the amount in this field, the system does not generate an invoice.
jdContractStartDate	CSDT	JDEDATE	OPT	OUTPUT
The date you actually start work on the contract.
jdContractEndDate	CDTE	JDEDATE	OPT	OUTPUT
The date you actually completed work on the contract.
jdPlannedStartDate	USD1	JDEDATE	OPT	OUTPUT
User defined Julian Date 1.
jdPlannedCompletionDate	USD2	JDEDATE	OPT	OUTPUT
User defined Julian Date 2.
jdUserDate3	USD3	JDEDATE	OPT	OUTPUT
A Julian date.
jdUserDate4	USD4	JDEDATE	OPT	OUTPUT
A Julian date.
szAiaCatCode1	AI01	char	OPT	OUTPUT
A user defined category code (52/01) that you can use to meet the specific needs of a contract.
szAiaCatCode2	AI02	char	OPT	OUTPUT
A user-defined category code (52/02) that you can use to meet the specific needs of a contract.
szAiaCatCode3	AI03	char	OPT	OUTPUT
A user defined category code (52/03) that you can use to meet the specific needs of a contract.
szAiaCatCode4	AI04	char	OPT	OUTPUT
A user defined category code (52/04) that you can use to meet the specific needs of a contract.
szAiaCatCode5	AI05	char	OPT	OUTPUT
A user defined category code (52/05) that you can use to meet the specific needs of a contract.
szContractCatCode11	AI11	char	OPT	OUTPUT
A user defined category code (system 52, code 11) that can be defined to meet the specific needs of a contract.
szContractCatCode12	AI12	char	OPT	OUTPUT
A user defined category code (system 52, code 12) that can be defined to meet the specific needs of a contract.
szContractCatCode13	AI13	char	OPT	OUTPUT
A user defined category code (system 52, code 13) that can be defined to meet the specific needs of a contract.
szContractCatCode14	AI14	char	OPT	OUTPUT
A user defined category code (system 52, code 14) that can be defined to meet the specific needs of a contract.
szContractCatCode15	AI15	char	OPT	OUTPUT
A user defined category code (system 52, code 15) that can be defined to meet the specific needs of a contract.
mnContractExchangeRate	CRR	MATH_NUMERIC	OPT	BOTH
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.
cCntlFlag2	CTF2	char	OPT	BOTH
A marker that is used internally to determine whether a Not-To-Exceed limit has been set at any level in the contract.
cCntlFlag4	CTF4	char	OPT	OUTPUT
Reserved by J.D. Edwards.
cCntlFlag5	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.
szErrorMessage	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.
szArchitectContract	ADCM	char	OPT	OUTPUT
The Architect Contract Number as recorded on the owners books. This information will be for reference and kept for use in Contract Search.
szRetainageRuleStoredMt	RTN1	char	OPT	OUTPUT
The Retainage Rule defined for Stored Material. See Data Item "RTNR".
cAiaBillingForm	AIAB	char	OPT	OUTPUT
A Y is used to indicate that the AIA Form G702/G703 is to be printed;otherwise, you can select a specific format using the Invoice Writer.
cContractOverrideRule	CTOV	char	OPT	OUTPUT
A control field for controlling revenue recognition with overrides.
cBurdenOverride	BROV	char	OPT	OUTPUT
The following values are allowed for this field: = Burden billed and recognized 1 Burden billed but not recognized 2 Burden recognized but not billed 3 Burden not recognized and not billed
mnNottoExceedAmountRestate	RNTE	MATH_NUMERIC	OPT	OUTPUT
Reserved by J.D. Edwards.
cDateExchangeRateDateBasi	ERDB	char	OPT	OUTPUT
A code that controls which date the system uses to retrieve the exchange rate for the invoice. Valid values are: 1 Use the invoice date (default). 2 Use the G/L date of the invoice.
mnCurrencyConverRateDiv	CRRD	MATH_NUMERIC	OPT	OUTPUT
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.
cCntlFlag3	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.
szBatchControlKey	BCTK	char	OPT	OUTPUT
Reserved by J.D. Edwards.
szProgramId	PID	char	OPT	BOTH
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.
cProcessFlag	EV01	char	OPT	BOTH
^

Related Functions

None

Related Tables

None

IsContractAParentContract

Get Update Contract Master Record

Minor Business Rule

Object Name: N5200010

Parent DLL: CCRIN

Location: Client/Server

Language: NER

Data Structure

D5200010 - Get Contract Master Information

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
mnContractNumber	DOCO	MATH_NUMERIC	REQ	BOTH
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	BOTH
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	OPT	BOTH
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.
mnRevenueBatch	ICU	MATH_NUMERIC	OPT	BOTH
A number that identifies a group of transactions that the system processes and balances as a unit. When you enter a batch, you can either assign a batch number or let the system assign it using the Next Numbers program.
mnInvoiceBatch	ICUJ	MATH_NUMERIC	OPT	BOTH
A batch number the system automatically assigns when you run Revenue Journal Generation.
szDescription01	DL01	char	OPT	OUTPUT
A user defined name or remark.
szDescription02	DL02	char	OPT	OUTPUT
Additional text that further describes or clarifies a field in the system.
szDescription03	DL03	char	OPT	OUTPUT
Additional text that further describes or clarifies an element.
szCompressedDescription	DC	char	OPT	OUTPUT
The compressed description contains the alpha name without slashes, dashes, commas, and other special characters. The compressed description is the field used in the Name Search.
szOwnerContract	ODCM	char	OPT	OUTPUT
The contract number as recorded on the owner's books. If you enter this number on the Contract Master Revisions form, you can use it as a search criterion on the Contract Search form. The system updates this number in the reference field (VR01) of the accounts receivable record for billing.
szOwnerContractCompress	OCNC	char	OPT	OUTPUT
The compressed owner contract number contains the number without spaces,slashes, dashes, commas, and other special characters. The compressed number is the field used in Contract Search.
mnCustomerAddressNumber	AN8O	MATH_NUMERIC	OPT	OUTPUT
The address book number to which the system posts billing and accounts receivable transactions.
mnAlternateBillingAddress	ANOB	MATH_NUMERIC	OPT	OUTPUT
The address number of an alternate location to which the owner wants the invoice (application) sent.
mnArchitectAddressNumber	AN8K	MATH_NUMERIC	OPT	OUTPUT
The address number of the architect for the contract or project.
mnUserAddNum1	USA1	MATH_NUMERIC	OPT	OUTPUT
User defined address book number. This will be verified against Address Book.
mnUserAddNum2	USA2	MATH_NUMERIC	OPT	OUTPUT
User defined address book number. This will be verified against Address Book.
mnUserAddNum3	USA3	MATH_NUMERIC	OPT	OUTPUT
Address Number 3 - User
mnRemitToAddress	USA4	MATH_NUMERIC	OPT	OUTPUT
Address Number - Remit To
mnSendToAddress	USA5	MATH_NUMERIC	OPT	OUTPUT
User defined address book number. This will be verified against Address Book.
szContrctStatus	DS	char	OPT	OUTPUT
A two-character code that provides status information about a contract. This status is edited against user defined codes (52/CS).
szContractType	CT	char	OPT	OUTPUT
A user defined code (51/CT) that identifies the type of contract.
szProjectJob	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.
szHostBusinessUnit	JMCU	char	OPT	OUTPUT
The Business Unit responsible for the job. This is particularly useful during transfer pricing.
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.
mnParentContractNumber	PCTN	MATH_NUMERIC	OPT	OUTPUT
The parent contract number to which this particular contract is attached.
szParentContractType	PCTT	char	OPT	OUTPUT
The parent contract type to which this particular contract is attached.
szParentContractCompany	PCKO	char	OPT	OUTPUT
Parent Contract Document Company.
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.
szGlOffsetRetention	RGLC	char	OPT	OUTPUT
A code that designates the offset accounts for retainage, for example RETN or 1225. You set up the code as an automatic accounting instruction. Note: Do not use code 9999. This is reserved for the post program and indicates that offsets should not be created.
cRetainageControlFlag	RCTL	char	OPT	OUTPUT
An option that determines whether the retainage amount is stored in the Accounts Receivable or General Accounting system and whether tax is calculated on the whole amount, including the retainage, or on each amount as it is billed. Valid values are: Blank The retainage is stored in the Accounts Receivable system and the tax is computed from the total taxable amount. 1 The retainage is stored in the Accounts Receivable system and the tax on the retainage amount is calculated and then subtracted from the total tax amount. This tax on retainage is deferred until the retainage is released. 2 The retainage is stored in the General Accounting system and the tax is computed from the total taxable amount. 3 The retainage is stored in the General Accounting system and the tax on the retainage amount is calculated and then subtracted from the total tax amount. This tax on retainage is deferred until the retainage is released.
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.
szInvoiceFormatCode	INVF	char	OPT	OUTPUT
A code that uniquely identifies a series of formats and determines the overall layout of the invoice.
szPaymentTermsCode01	PTC	char	OPT	OUTPUT
A code that specifies the terms of payment, including the percentage of discount available if the invoice is paid by the discount due date. Use a blank code to indicate the most frequently-used payment term. You define each type of payment term on the Payment Terms Revisions form. Examples of payment terms include: Blank Net 15 001 1/10 net 30 002 2/10 net 30 003 Due on the 10th day of every month 006 Due upon receipt This code prints on customer invoices.
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.
cFeeSummarizationLevel	FSLV	char	OPT	OUTPUT
The level of detail at which the system creates work file records for fee lines. o If you leave this field blank, the system creates fees at a summarized level, with one work file record (F4812) per fee line. o A value of "1" in this field indicates that the system should create the F4812 records at a detailed level, with one work file record for each unique combination of key values. "Key Values" refers to any value that could be used as a key or a result in the Account Derivation Table. Key value fields include: Subledger - Customer Subledger Type - Home Business Unit Work Order Class - Company Job - Equipment Number Job Class - Component Code
szBaseCurrency	CRCD	char	OPT	OUTPUT
A code that identifies the currency of a transaction.
szBillingCurrency	CRCF	char	OPT	OUTPUT
The currency code of the insured amount.
cContractCurrencyMode	CRRM	char	OPT	OUTPUT
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	BOTH
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.
mnNotToExceedForeign	NTEF	MATH_NUMERIC	OPT	BOTH
The maximum foreign not-to-exceed amount. The foreign not-to-exceed amount applies to the entire contract and all related change orders.
cLimitExceededFlag	LMEX	char	OPT	BOTH
A field that identifies any row (pay item, change order, or contract) for which the NTE limit has been exceeded. If the Billed to Date amount is greater than the NTE limit, the Limit Exceeded field is checked for the affected row. If the billed to date amount is less than the minimum invoice amount for the contract, the Limit Not Reached field is checked for the affected row, indicating that you have underbilled.
mnMinimumContractAmt	MCIA	MATH_NUMERIC	OPT	BOTH
The minimum amount required for the contract. If the billing amount is less than the amount in this field, the system will not generate an invoice.
mnMinimumContractAmtForeign	MCIF	MATH_NUMERIC	OPT	BOTH
The foreign minimum amount required for the contract. If the billing amount is less than the amount in this field, the system does not generate an invoice.
jdContractStartDate	CSDT	JDEDATE	OPT	OUTPUT
The date you actually start work on the contract.
jdContractEndDate	CDTE	JDEDATE	OPT	OUTPUT
The date you actually completed work on the contract.
jdPlannedStartDate	USD1	JDEDATE	OPT	OUTPUT
User defined Julian Date 1.
jdPlannedCompletionDate	USD2	JDEDATE	OPT	OUTPUT
User defined Julian Date 2.
jdUserDate3	USD3	JDEDATE	OPT	OUTPUT
A Julian date.
jdUserDate4	USD4	JDEDATE	OPT	OUTPUT
A Julian date.
szAiaCatCode1	AI01	char	OPT	OUTPUT
A user defined category code (52/01) that you can use to meet the specific needs of a contract.
szAiaCatCode2	AI02	char	OPT	OUTPUT
A user-defined category code (52/02) that you can use to meet the specific needs of a contract.
szAiaCatCode3	AI03	char	OPT	OUTPUT
A user defined category code (52/03) that you can use to meet the specific needs of a contract.
szAiaCatCode4	AI04	char	OPT	OUTPUT
A user defined category code (52/04) that you can use to meet the specific needs of a contract.
szAiaCatCode5	AI05	char	OPT	OUTPUT
A user defined category code (52/05) that you can use to meet the specific needs of a contract.
szContractCatCode11	AI11	char	OPT	OUTPUT
A user defined category code (system 52, code 11) that can be defined to meet the specific needs of a contract.
szContractCatCode12	AI12	char	OPT	OUTPUT
A user defined category code (system 52, code 12) that can be defined to meet the specific needs of a contract.
szContractCatCode13	AI13	char	OPT	OUTPUT
A user defined category code (system 52, code 13) that can be defined to meet the specific needs of a contract.
szContractCatCode14	AI14	char	OPT	OUTPUT
A user defined category code (system 52, code 14) that can be defined to meet the specific needs of a contract.
szContractCatCode15	AI15	char	OPT	OUTPUT
A user defined category code (system 52, code 15) that can be defined to meet the specific needs of a contract.
mnContractExchangeRate	CRR	MATH_NUMERIC	OPT	BOTH
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.
cCntlFlag2	CTF2	char	OPT	BOTH
A marker that is used internally to determine whether a Not-To-Exceed limit has been set at any level in the contract.
cCntlFlag4	CTF4	char	OPT	OUTPUT
Reserved by J.D. Edwards.
cCntlFlag5	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.
szErrorMessage	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.
szArchitectContract	ADCM	char	OPT	OUTPUT
The Architect Contract Number as recorded on the owners books. This information will be for reference and kept for use in Contract Search.
szRetainageRuleStoredMt	RTN1	char	OPT	OUTPUT
The Retainage Rule defined for Stored Material. See Data Item "RTNR".
cAiaBillingForm	AIAB	char	OPT	OUTPUT
A Y is used to indicate that the AIA Form G702/G703 is to be printed;otherwise, you can select a specific format using the Invoice Writer.
cContractOverrideRule	CTOV	char	OPT	OUTPUT
A control field for controlling revenue recognition with overrides.
cBurdenOverride	BROV	char	OPT	OUTPUT
The following values are allowed for this field: = Burden billed and recognized 1 Burden billed but not recognized 2 Burden recognized but not billed 3 Burden not recognized and not billed
mnNottoExceedAmountRestate	RNTE	MATH_NUMERIC	OPT	OUTPUT
Reserved by J.D. Edwards.
cDateExchangeRateDateBasi	ERDB	char	OPT	OUTPUT
A code that controls which date the system uses to retrieve the exchange rate for the invoice. Valid values are: 1 Use the invoice date (default). 2 Use the G/L date of the invoice.
mnCurrencyConverRateDiv	CRRD	MATH_NUMERIC	OPT	OUTPUT
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.
cCntlFlag3	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.
szBatchControlKey	BCTK	char	OPT	OUTPUT
Reserved by J.D. Edwards.
szProgramId	PID	char	OPT	BOTH
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.
cProcessFlag	EV01	char	OPT	BOTH
^

Related Functions

None

Related Tables

None

UpdateContractMasterRecord

Get Update Contract Master Record

Minor Business Rule

Object Name: N5200010

Parent DLL: CCRIN

Location: Client/Server

Language: NER

Data Structure

D5200010 - Get Contract Master Information

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
mnContractNumber	DOCO	MATH_NUMERIC	REQ	BOTH
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	BOTH
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	OPT	BOTH
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.
mnRevenueBatch	ICU	MATH_NUMERIC	OPT	BOTH
A number that identifies a group of transactions that the system processes and balances as a unit. When you enter a batch, you can either assign a batch number or let the system assign it using the Next Numbers program.
mnInvoiceBatch	ICUJ	MATH_NUMERIC	OPT	BOTH
A batch number the system automatically assigns when you run Revenue Journal Generation.
szDescription01	DL01	char	OPT	OUTPUT
A user defined name or remark.
szDescription02	DL02	char	OPT	OUTPUT
Additional text that further describes or clarifies a field in the system.
szDescription03	DL03	char	OPT	OUTPUT
Additional text that further describes or clarifies an element.
szCompressedDescription	DC	char	OPT	OUTPUT
The compressed description contains the alpha name without slashes, dashes, commas, and other special characters. The compressed description is the field used in the Name Search.
szOwnerContract	ODCM	char	OPT	OUTPUT
The contract number as recorded on the owner's books. If you enter this number on the Contract Master Revisions form, you can use it as a search criterion on the Contract Search form. The system updates this number in the reference field (VR01) of the accounts receivable record for billing.
szOwnerContractCompress	OCNC	char	OPT	OUTPUT
The compressed owner contract number contains the number without spaces,slashes, dashes, commas, and other special characters. The compressed number is the field used in Contract Search.
mnCustomerAddressNumber	AN8O	MATH_NUMERIC	OPT	OUTPUT
The address book number to which the system posts billing and accounts receivable transactions.
mnAlternateBillingAddress	ANOB	MATH_NUMERIC	OPT	OUTPUT
The address number of an alternate location to which the owner wants the invoice (application) sent.
mnArchitectAddressNumber	AN8K	MATH_NUMERIC	OPT	OUTPUT
The address number of the architect for the contract or project.
mnUserAddNum1	USA1	MATH_NUMERIC	OPT	OUTPUT
User defined address book number. This will be verified against Address Book.
mnUserAddNum2	USA2	MATH_NUMERIC	OPT	OUTPUT
User defined address book number. This will be verified against Address Book.
mnUserAddNum3	USA3	MATH_NUMERIC	OPT	OUTPUT
Address Number 3 - User
mnRemitToAddress	USA4	MATH_NUMERIC	OPT	OUTPUT
Address Number - Remit To
mnSendToAddress	USA5	MATH_NUMERIC	OPT	OUTPUT
User defined address book number. This will be verified against Address Book.
szContrctStatus	DS	char	OPT	OUTPUT
A two-character code that provides status information about a contract. This status is edited against user defined codes (52/CS).
szContractType	CT	char	OPT	OUTPUT
A user defined code (51/CT) that identifies the type of contract.
szProjectJob	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.
szHostBusinessUnit	JMCU	char	OPT	OUTPUT
The Business Unit responsible for the job. This is particularly useful during transfer pricing.
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.
mnParentContractNumber	PCTN	MATH_NUMERIC	OPT	OUTPUT
The parent contract number to which this particular contract is attached.
szParentContractType	PCTT	char	OPT	OUTPUT
The parent contract type to which this particular contract is attached.
szParentContractCompany	PCKO	char	OPT	OUTPUT
Parent Contract Document Company.
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.
szGlOffsetRetention	RGLC	char	OPT	OUTPUT
A code that designates the offset accounts for retainage, for example RETN or 1225. You set up the code as an automatic accounting instruction. Note: Do not use code 9999. This is reserved for the post program and indicates that offsets should not be created.
cRetainageControlFlag	RCTL	char	OPT	OUTPUT
An option that determines whether the retainage amount is stored in the Accounts Receivable or General Accounting system and whether tax is calculated on the whole amount, including the retainage, or on each amount as it is billed. Valid values are: Blank The retainage is stored in the Accounts Receivable system and the tax is computed from the total taxable amount. 1 The retainage is stored in the Accounts Receivable system and the tax on the retainage amount is calculated and then subtracted from the total tax amount. This tax on retainage is deferred until the retainage is released. 2 The retainage is stored in the General Accounting system and the tax is computed from the total taxable amount. 3 The retainage is stored in the General Accounting system and the tax on the retainage amount is calculated and then subtracted from the total tax amount. This tax on retainage is deferred until the retainage is released.
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.
szInvoiceFormatCode	INVF	char	OPT	OUTPUT
A code that uniquely identifies a series of formats and determines the overall layout of the invoice.
szPaymentTermsCode01	PTC	char	OPT	OUTPUT
A code that specifies the terms of payment, including the percentage of discount available if the invoice is paid by the discount due date. Use a blank code to indicate the most frequently-used payment term. You define each type of payment term on the Payment Terms Revisions form. Examples of payment terms include: Blank Net 15 001 1/10 net 30 002 2/10 net 30 003 Due on the 10th day of every month 006 Due upon receipt This code prints on customer invoices.
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.
cFeeSummarizationLevel	FSLV	char	OPT	OUTPUT
The level of detail at which the system creates work file records for fee lines. o If you leave this field blank, the system creates fees at a summarized level, with one work file record (F4812) per fee line. o A value of "1" in this field indicates that the system should create the F4812 records at a detailed level, with one work file record for each unique combination of key values. "Key Values" refers to any value that could be used as a key or a result in the Account Derivation Table. Key value fields include: Subledger - Customer Subledger Type - Home Business Unit Work Order Class - Company Job - Equipment Number Job Class - Component Code
szBaseCurrency	CRCD	char	OPT	OUTPUT
A code that identifies the currency of a transaction.
szBillingCurrency	CRCF	char	OPT	OUTPUT
The currency code of the insured amount.
cContractCurrencyMode	CRRM	char	OPT	OUTPUT
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	BOTH
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.
mnNotToExceedForeign	NTEF	MATH_NUMERIC	OPT	BOTH
The maximum foreign not-to-exceed amount. The foreign not-to-exceed amount applies to the entire contract and all related change orders.
cLimitExceededFlag	LMEX	char	OPT	BOTH
A field that identifies any row (pay item, change order, or contract) for which the NTE limit has been exceeded. If the Billed to Date amount is greater than the NTE limit, the Limit Exceeded field is checked for the affected row. If the billed to date amount is less than the minimum invoice amount for the contract, the Limit Not Reached field is checked for the affected row, indicating that you have underbilled.
mnMinimumContractAmt	MCIA	MATH_NUMERIC	OPT	BOTH
The minimum amount required for the contract. If the billing amount is less than the amount in this field, the system will not generate an invoice.
mnMinimumContractAmtForeign	MCIF	MATH_NUMERIC	OPT	BOTH
The foreign minimum amount required for the contract. If the billing amount is less than the amount in this field, the system does not generate an invoice.
jdContractStartDate	CSDT	JDEDATE	OPT	OUTPUT
The date you actually start work on the contract.
jdContractEndDate	CDTE	JDEDATE	OPT	OUTPUT
The date you actually completed work on the contract.
jdPlannedStartDate	USD1	JDEDATE	OPT	OUTPUT
User defined Julian Date 1.
jdPlannedCompletionDate	USD2	JDEDATE	OPT	OUTPUT
User defined Julian Date 2.
jdUserDate3	USD3	JDEDATE	OPT	OUTPUT
A Julian date.
jdUserDate4	USD4	JDEDATE	OPT	OUTPUT
A Julian date.
szAiaCatCode1	AI01	char	OPT	OUTPUT
A user defined category code (52/01) that you can use to meet the specific needs of a contract.
szAiaCatCode2	AI02	char	OPT	OUTPUT
A user-defined category code (52/02) that you can use to meet the specific needs of a contract.
szAiaCatCode3	AI03	char	OPT	OUTPUT
A user defined category code (52/03) that you can use to meet the specific needs of a contract.
szAiaCatCode4	AI04	char	OPT	OUTPUT
A user defined category code (52/04) that you can use to meet the specific needs of a contract.
szAiaCatCode5	AI05	char	OPT	OUTPUT
A user defined category code (52/05) that you can use to meet the specific needs of a contract.
szContractCatCode11	AI11	char	OPT	OUTPUT
A user defined category code (system 52, code 11) that can be defined to meet the specific needs of a contract.
szContractCatCode12	AI12	char	OPT	OUTPUT
A user defined category code (system 52, code 12) that can be defined to meet the specific needs of a contract.
szContractCatCode13	AI13	char	OPT	OUTPUT
A user defined category code (system 52, code 13) that can be defined to meet the specific needs of a contract.
szContractCatCode14	AI14	char	OPT	OUTPUT
A user defined category code (system 52, code 14) that can be defined to meet the specific needs of a contract.
szContractCatCode15	AI15	char	OPT	OUTPUT
A user defined category code (system 52, code 15) that can be defined to meet the specific needs of a contract.
mnContractExchangeRate	CRR	MATH_NUMERIC	OPT	BOTH
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.
cCntlFlag2	CTF2	char	OPT	BOTH
A marker that is used internally to determine whether a Not-To-Exceed limit has been set at any level in the contract.
cCntlFlag4	CTF4	char	OPT	OUTPUT
Reserved by J.D. Edwards.
cCntlFlag5	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.
szErrorMessage	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.
szArchitectContract	ADCM	char	OPT	OUTPUT
The Architect Contract Number as recorded on the owners books. This information will be for reference and kept for use in Contract Search.
szRetainageRuleStoredMt	RTN1	char	OPT	OUTPUT
The Retainage Rule defined for Stored Material. See Data Item "RTNR".
cAiaBillingForm	AIAB	char	OPT	OUTPUT
A Y is used to indicate that the AIA Form G702/G703 is to be printed;otherwise, you can select a specific format using the Invoice Writer.
cContractOverrideRule	CTOV	char	OPT	OUTPUT
A control field for controlling revenue recognition with overrides.
cBurdenOverride	BROV	char	OPT	OUTPUT
The following values are allowed for this field: = Burden billed and recognized 1 Burden billed but not recognized 2 Burden recognized but not billed 3 Burden not recognized and not billed
mnNottoExceedAmountRestate	RNTE	MATH_NUMERIC	OPT	OUTPUT
Reserved by J.D. Edwards.
cDateExchangeRateDateBasi	ERDB	char	OPT	OUTPUT
A code that controls which date the system uses to retrieve the exchange rate for the invoice. Valid values are: 1 Use the invoice date (default). 2 Use the G/L date of the invoice.
mnCurrencyConverRateDiv	CRRD	MATH_NUMERIC	OPT	OUTPUT
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.
cCntlFlag3	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.
szBatchControlKey	BCTK	char	OPT	OUTPUT
Reserved by J.D. Edwards.
szProgramId	PID	char	OPT	BOTH
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.
cProcessFlag	EV01	char	OPT	BOTH
^

Related Functions

None

Related Tables

None

OUTPUT

A user defined category code (system 52, code 15) that can be defined to meet the specific needs of a contract.

mnContractExchangeRateCRRMATH_NUMERICOPTBOTH

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.

cCntlFlag2CTF2charOPTBOTH

A marker that is used internally to determine whether a Not-To-Exceed limit has been set at any level in the contract.

cCntlFlag4CTF4charOPTOUTPUT

Reserved by J.D. Edwards.

cCntlFlag5CTF5charOPTOUTPUT

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.

szErrorMessageDTAIcharOPTOUTPUT

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.

szArchitectContractADCMcharOPTOUTPUT

The Architect Contract Number as recorded on the owners books. This information will be for reference and kept for use in Contract
Search.

szRetainageRuleStoredMtRTN1charOPTOUTPUT

The Retainage Rule defined for Stored Material. See Data Item "RTNR".

cAiaBillingFormAIABcharOPTOUTPUT

A Y is used to indicate that the AIA Form G702/G703 is to be printed;otherwise, you can select a specific format using the Invoice Writer.

cContractOverrideRuleCTOVcharOPTOUTPUT

A control field for controlling revenue recognition with overrides.

cBurdenOverrideBROVcharOPTOUTPUT

The following values are allowed for this field: = Burden billed and recognized 1 Burden billed but not recognized 2 Burden recognized
but not billed 3 Burden not recognized and not billed

mnNottoExceedAmountRestateRNTEMATH_NUMERICOPTOUTPUT

Reserved by J.D. Edwards.

cDateExchangeRateDateBasiERDBcharOPTOUTPUT

A code that controls which date the system uses to retrieve the exchange rate for the invoice. Valid values are: 1 Use the invoice date
(default). 2 Use the G/L date of the invoice.

mnCurrencyConverRateDivCRRDMATH_NUMERICOPTOUTPUT

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.

cCntlFlag3CTF3charOPTOUTPUT

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.

szBatchControlKeyBCTKcharOPTOUTPUT

Reserved by J.D. Edwards.

szProgramIdPIDcharOPTBOTH

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.

szWorkStationIdJOBNcharOPTOUTPUT

The code that identifies the work station ID that executed a particular job.

szUserIdUSERcharOPTOUTPUT

The code that identifies a user profile.

jdDateRecordUpdatedMUPMJDEDATEOPTOUTPUT

The date of last update. Used in the Financial Reporting Merge file (F1011) where field name is duplicated.

mnTimeLastUpdatedUPMTMATH_NUMERICOPTOUTPUT

The time that specifies when the program executed the last update to this record.

cProcessFlagEV01charOPTBOTH