Functional Description
Purpose
This function is the main interface to update the commitment ledger
Technical Specification
D00COM - Update Commitment Ledger
Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
---|---|---|---|---|
cDocumentAction | ACTN | char | NONE | NONE |
A code that specifies the action that is performed. Valid values are: A Add C Change | ||||
mnPO_ContractNumber | DOCO | MATH_NUMERIC | NONE | NONE |
A number that identifies an original document. This document can be a voucher, a sales order, an invoice, unapplied cash, a journal entry,
| ||||
szPODocumentType | DCTO | char | NONE | NONE |
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
| ||||
szPODocumentCompany | KCOO | char | NONE | NONE |
A number that, along with order number and order type, uniquely identifies an order document (such as a purchase order, a contract, a
| ||||
szPODocumentSuffix | SFXO | char | NONE | NONE |
In the A/R and A/P systems, a code that corresponds to the pay item. In the Sales Order and Procurement systems, this code identifies
| ||||
mnPODocumentLine | LNID | MATH_NUMERIC | NONE | NONE |
A number that identifies multiple occurrences, such as line numbers on a purchase order or other document. Generally, the system assigns
| ||||
szPA_PUAccountNumberShort | AID | char | NONE | NONE |
A number that the system assigns to each general ledger account in the Account Master table (F0901) to uniquely identify it. | ||||
szBusinessUnit | OMCU | char | NONE | NONE |
The business unit from an account number. The account number business unit is usually found in the data item MCU, however, Distribution
| ||||
szObjectAccount | OBJ | char | NONE | NONE |
The portion of a general ledger account that refers to the division of the Cost Code (for example, labor, materials, and equipment) into
| ||||
szSubsidiary | SUB | char | NONE | NONE |
A subset of an object account. Subsidiary accounts include detailed records of the accounting activity for an object account. | ||||
szCompany | CO | char | NONE | NONE |
A code that identifies a specific organization, fund, or other reporting entity. The company code must already exist in the Company
| ||||
mnCentury | CTRY | MATH_NUMERIC | NONE | NONE |
The calendar century associated with the year. Enter is the first two digits of
the year. For example, 19 indicates any year beginning with 19
| ||||
mnFiscalYear | FY | MATH_NUMERIC | NONE | NONE |
A number that identifies the fiscal year. Generally, you can either enter a number in this field or leave it blank to indicate the current fiscal
| ||||
mnPeriodNumber | PN | MATH_NUMERIC | NONE | NONE |
A number indicating the current accounting period. This number, used in conjunction with the Company Constants table (F0010) and the
| ||||
jdGeneralLedgerDate | DGL | JDEDATE | NONE | NONE |
A date that identifies the financial period to which the transaction is to be posted.
The company constants specify the date range for each
| ||||
szSubledger | SBL | char | NONE | NONE |
A code that identifies a detailed, auxiliary account within a general ledger account. A subledger can be an equipment item number or an
| ||||
cSubledgerType | SBLT | char | NONE | NONE |
A user defined code (00/ST) that is used with the Subledger field to identify the subledger type and how the system performs subledger
| ||||
mnQuantityRelatedToAction | QTY | MATH_NUMERIC | NONE | NONE |
The number of units associated with an asset. | ||||
mnAmountRelatedToAction | AA | MATH_NUMERIC | NONE | NONE |
A number that identifies the amount that the system will add to the account balance of the associated account number. Enter credits with a
| ||||
mnTaxAmountRelatedToAction | STAM | MATH_NUMERIC | NONE | NONE |
The amount assessed and payable to tax authorities. It is the total of the VAT, use, and sales taxes (PST). | ||||
mnPO_ContractQuantity | UORG | MATH_NUMERIC | NONE | NONE |
The quantity of units affected by this transaction. | ||||
mnPO_ContractUnitCost | PRRC | MATH_NUMERIC | NONE | NONE |
The unit cost of one item, as purchased from the supplier, excluding freight,taxes, discounts, and other factors that might modify the actual
| ||||
mnPO_ContractAmount | AEXP | MATH_NUMERIC | NONE | NONE |
The number of units multiplied by the unit price. | ||||
mnPO_ContractOpenQuantity | UOPN | MATH_NUMERIC | NONE | NONE |
The original quantity for the order detail line, plus or minus any changes to that quantity, minus all quantities shipped, received, and
| ||||
mnPO_ContractOpenAmount | AOPN | MATH_NUMERIC | NONE | NONE |
The amount of the order, invoice, or voucher that is still unpaid or open.
When you enter a document (for example, an order, invoice, or
| ||||
mnPO_ContractReceivedQuantity | UREC | MATH_NUMERIC | NONE | NONE |
The original quantity of the order line, plus or minus any changes to that quantity, less all quantities shipped, received and/or vouchered to
| ||||
mnPO_ContractReceivedAmount | AREC | MATH_NUMERIC | NONE | NONE |
The value of the goods received to date against the original order line. | ||||
mnPO_ContractTaxAmount | FTN1 | MATH_NUMERIC | NONE | NONE |
The total tax amount committed to the PA ledger. The system uses this amount to relieve taxes at the committed rate. | ||||
cRecalculateProjectedFinalsFlg | PROJ | char | NONE | NONE |
Projection Code | ||||
mnWriteAuditRecordToPOLedger | AUDT | MATH_NUMERIC | NONE | NONE |
The person or company who performed the last audit of company documents.
The coding considerations for this number are the same as
| ||||
cCurrencyProcessingFlag | CRYR | char | NONE | NONE |
A code that specifies whether to use multi-currency accounting, and the method of multi-currency accounting to use:
Codes are:
N Do not
| ||||
mnProjectionsMultiplePeriods | PMP | MATH_NUMERIC | NONE | NONE |
The maximum percentage of the premium amount that can be charged for COBRA qualified beneficiaries. | ||||
mnProjectionsThruPeriodNumber | CRPR | MATH_NUMERIC | NONE | NONE |
This week or month. This is usually a number between 1 and 52 that designates the relative position in the year. For example, on a
| ||||
mnProjectionsThruFiscalYear | YR | MATH_NUMERIC | NONE | NONE |
The calendar year for this calendar. | ||||
szJournalEntryDocumentCompany | KCO | char | NONE | NONE |
A number that, with the document number, document type and G/L date, uniquely identifies an original document, such as invoice, voucher,
| ||||
mnJournalEntryDocumentNumber | DOC | MATH_NUMERIC | NONE | NONE |
A number that identifies the original document, such as a voucher, invoice, or journal entry. On entry forms, you can assign the document
| ||||
szJournalEntryDocumentType | DCT | char | NONE | NONE |
A user defined code (00/DT) that identifies the origin and purpose of the transaction. PeopleSoft reserves several prefixes for document
| ||||
mnJournalEntryLineNumber | JELN | MATH_NUMERIC | NONE | NONE |
A number that designates a line within a journal entry. The system uses this field to sequence the journal entry lines for inquiry purposes. | ||||
cPostQuantitiesFlag | FUF2 | char | NONE | NONE |
In the Contract Management system, a code that specifies whether the system will post quantities to the general ledger during progress
| ||||
mnCurrencyExchangeRate | CRR | MATH_NUMERIC | NONE | NONE |
A number (exchange rate) that a foreign currency amount is multiplied by to calculate a domestic currency amount.
The number in this field
| ||||
cCommitmentReliefFlag | ALT7 | char | NONE | NONE |
This field determines how the journal entry should impact a commitment made in the Purchasing and/or Contract Management systems.
| ||||
cErrorOnUpdate | ERR | char | NONE | NONE |
The Data Field Error Code field is simply a generic data field to pass an error condition flag. This field is one of the fields that make up the
| ||||
idPointerToF4311DS | GENLNG | ID | NONE | NONE |
General purpose ID variable. | ||||
szCallingApplication | PID | char | NONE | NONE |
The number that identifies the batch or interactive program (batch or interactive object). For example, the number of the Sales Order Entry
| ||||
mnTriangulationRateFromCurrenc | TRR1 | MATH_NUMERIC | OPT | NONE |
The triangulation currency rate used to convert the From currency code to the Triangulation currency code. | ||||
mnTriangulationRateToCurrency | TRR2 | MATH_NUMERIC | OPT | NONE |
The triangulation currency rate that used to convert from the Triangulation currency code to the To currency code. | ||||
cCurrencyConversionMethod | CRCM | char | OPT | NONE |
A value that specifies which method to use when converting from one currency to another. Valid values are:
Y
Multiplier method. The
| ||||
idPointerToF4316DS | GENLNG | ID | OPT | NONE |
General purpose ID variable. | ||||
cCalledForMultiplesRecord | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
mnDistributionLineNumber | DLNID | MATH_NUMERIC | OPT | NONE |
B0000027 CurrencyConvForAndDom | ||||
B0000128 Retrieve Company Currency Code | ||||
B0000130 Retrieve Company From Business Unit | ||||
B0000131 Retrieve Currency Conversion | ||||
B0000173 Determine Date, Conversion Method and Rates | ||||
B4300110 Get Purchase Order Detail | ||||
B9800100 Get Audit Information | ||||
X0005 Get User Defined Codes | ||||
X43199 Insert Purchase Ledger | ||||
XX0901 Validate Account Number |
F0010 Company Constants | ||||
F0902 Account Balances | ||||
F4311 Purchase Order Detail File | ||||
F43199 P.O. Detail Ledger File - Flexible Version |