D48S0540 - Build Detail Journal
| Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
|---|---|---|---|---|
| mnBatchNo | ICU | MATH_NUMERIC | REQ | INPUT |
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
| ||||
| mnActiveBatchNo | ICUA | MATH_NUMERIC | REQ | INPUT |
This is the batch number assigned during the Service Billing generation. This batch number will be used as a linking mechanism to allow
| ||||
| cBatchType | BCTY | char | REQ | INPUT |
A code that specifies whether the batch is from the Service Billing system or the Contract Billing system. Valid values are:
3
Service
| ||||
| cGenerationType | GTYP | char | REQ | INPUT |
A code that determines the batch types and markup rules for invoice, revenue, and component amounts. The system assigns the batch
| ||||
| cCreditDebit | CRDB | char | REQ | INPUT |
This field is used to indicate whether a line in the Automatic Accounting Instructions table is to be used for Debit or Credit entries when
| ||||
| szCompanyNo | CO | char | REQ | INPUT |
A code that identifies a specific organization, fund, or other reporting entity. The company code must already exist in the Company
| ||||
| szDocType | DCT | char | OPT | INPUT |
A user defined code (00/DT) that identifies the origin and purpose of the transaction. PeopleSoft reserves several prefixes for document
| ||||
| mnDocNo | DOC | MATH_NUMERIC | OPT | INPUT |
A number that identifies the original document, such as a voucher, invoice, or journal entry. On entry forms, you can assign the document
| ||||
| szInvPayItem | SFX | char | OPT | INPUT |
A number that identifies the pay item for a voucher or an invoice. The system assigns the pay item number. If the voucher or invoice has
| ||||
| szBusinessUnit | MCU | char | OPT | INPUT |
An alphanumeric code that identifies a separate entity within a business for which you want to track costs. For example, a business unit
| ||||
| szObjectAccount | OBJ | char | OPT | INPUT |
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 | OPT | INPUT |
A subset of an object account. Subsidiary accounts include detailed records of the accounting activity for an object account. | ||||
| 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
| ||||
| 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
| ||||
| szShortAcctID | AID | char | OPT | INPUT |
A number that the system assigns to each general ledger account in the Account Master table (F0901) to uniquely identify it. | ||||
| szLedgerType | LT | char | REQ | INPUT |
A user defined code (09/LT) that specifies the type of ledger, such as AA (Actual Amounts), BA (Budget Amount), or AU (Actual Units). You
| ||||
| szJournalDescription | DL01 | char | OPT | INPUT |
A user defined name or remark. | ||||
| szGLOffset | GLC | char | OPT | INPUT |
A code that determines the trade account that the system uses as the offset when you post invoices or vouchers. The system concatenates
| ||||
| mnEmpSuppNo | AN8 | MATH_NUMERIC | OPT | INPUT |
A number that identifies an entry in the Address Book system, such as employee, applicant, participant, customer, supplier, tenant, or
| ||||
| szEquipWorked | EQCG | char | OPT | INPUT |
The ID number of the equipment an employee used to perform a job. For example, an employee might drive a company dump truck or
| ||||
| mnJrnlAmt | AA | MATH_NUMERIC | REQ | INPUT |
A number that identifies the amount that the system will add to the account balance of the associated account number. Enter credits with a
| ||||
| mnJrnlAmtF | ACR | MATH_NUMERIC | OPT | INPUT |
The foreign currency amount entered on the transaction. If the Multi-Currency Conversion option on the General Accounting constants is set
| ||||
| mnUnits | U | MATH_NUMERIC | REQ | 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,
| ||||
| szUnitOfMeasure | UM | char | REQ | INPUT |
A user defined code (00/UM) that identifies the unit of measurement for an amount or quantity. For example, it can represent a barrel, box,
| ||||
| mnJrnlTaxAmt | JTAX | MATH_NUMERIC | REQ | INPUT |
The portion of the tax amount calculated for this entry that is not automatically generated by the post program. | ||||
| mnJrnlTaxAmtF | JTXF | MATH_NUMERIC | OPT | INPUT |
The portion of the tax amount calculated for this entry that is not automatically generated by the post program. | ||||
| szBaseCurrency | CRCD | char | OPT | INPUT |
A code that identifies the currency of a transaction. | ||||
| szSourceCurrency | CRCE | char | OPT | INPUT |
| szForeignCurrency | CRCF | char | OPT | INPUT |
The currency code of the insured amount. | ||||
| cCurrencyMode | CRRM | char | OPT | INPUT |
An option that specifies whether the system displays amounts in the domestic or foreign currency.
On
The system displays amounts in the
| ||||
| mnExchRate | CRR | MATH_NUMERIC | OPT | INPUT |
A number (exchange rate) that a foreign currency amount is multiplied by to calculate a domestic currency amount.
The number in this field
| ||||
| mnInvExchRate | CRRD | MATH_NUMERIC | OPT | INPUT |
A number (exchange rate) that a foreign currency amount is divided by to calculate a domestic currency amount. The number you enter in
| ||||
| cExchRateDateBasis | ERDB | char | OPT | INPUT |
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
| ||||
| jdExchRateDate | ERDT | JDEDATE | OPT | INPUT |
This is the date that was used to establish the exchange rate at the time the billing detail transaction was being created. | ||||
| szTaxExplanationCode | EXR1 | char | REQ | INPUT |
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
| ||||
| szTaxArea | TXA1 | char | REQ | INPUT |
A code that identifies a tax or geographic area that has common tax rates and tax authorities. The system validates the code you enter
| ||||
| szPhase | WR01 | char | REQ | INPUT |
A user defined code (00/W1) that indicates the current stage or phase of development for a work order. You can assign a work order to only
| ||||
| szJobType | JBCD | char | REQ | INPUT |
A user defined code (07/G) that defines the jobs within your organization. You can associate pay and benefit information with a job type and
| ||||
| szJobStep | JBST | char | REQ | INPUT |
A user defined code (07/GS) that designates a specific level within a particular job type. The system uses this code in conjunction with job
| ||||
| szHomeBusinessUnit | HMCU | char | REQ | INPUT |
The number of the business unit in which the employee generally resides. | ||||
| szHostBusinessUnit | JMCU | char | REQ | INPUT |
The Business Unit responsible for the job. This is particularly useful during transfer pricing. | ||||
| mnAAITableNo | ANUM | MATH_NUMERIC | OPT | INPUT |
A number used to specify sequence and retrieve accounting information. | ||||
| cTableKeyType | TYKY | char | OPT | INPUT |
A code that the system uses in combination with the table key to locate and validate the source and workfile transactions against the
| ||||
| szTableKeyValue | TKEY | char | OPT | INPUT |
A value that the system uses in combination with the key type to locate and validate workfile transactions against the various tables in the
| ||||
| jdTableBasisDate | TBDT | JDEDATE | REQ | INPUT |
This date is used as the basis for comparison to the effective dates of the various tables used by the Service Billing system. This date is
| ||||
| mnCustomerNo | AN8O | MATH_NUMERIC | REQ | INPUT |
The address book number to which the system posts billing and accounts receivable transactions. | ||||
| mnContractNo | 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,
| ||||
| szContractDocType | 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
| ||||
| szContractKeyCo | 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
| ||||
| mnParentContractNo | PCTN | MATH_NUMERIC | REQ | INPUT |
The parent contract number to which this particular contract is attached. | ||||
| szParentContractDocType | PCTT | char | REQ | INPUT |
The parent contract type to which this particular contract is attached. | ||||
| szParentContractKeyCo | PCKO | char | REQ | INPUT |
Parent Contract Document Company. | ||||
| szContractChgOrder | 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
| ||||
| szFromBusinessUnit | MCUF | char | REQ | INPUT |
The lowest value of the range a given user is authorized to view and process data. It is used in conjunction with the Business Unit Through
| ||||
| szFromObjectAcct | OBJF | char | REQ | INPUT |
Identifies the beginning object account in a range of accounts. The From Object Account must be less than or equal to the Thru Object
| ||||
| szFromSubsidiaryAcct | SUBSID | char | REQ | INPUT |
A subdivision of an object account. Subsidiary accounts include more detailed records of the accounting activity for an object account. If
| ||||
| szFromSubledger | SBLC | char | REQ | INPUT |
A code that identifies a detailed auxiliary account within a general ledger account. A subledger can be an equipment item number, an
| ||||
| cFromSubledgerType | SBTC | char | REQ | INPUT |
A user defined code (00/ST) that is used with the Subledger field to identify the subledger type and subledger editing. On the User Defined
| ||||
| szServiceType | WR07 | char | REQ | INPUT |
A user defined code (00/W7) that indicates the service type for the work order. | ||||
| szJobClass | RP11 | char | REQ | INPUT |
Category code 11 associated with the Business Unit Master file (F0006). This is a user defined code (system 00, type 11) for use in flex
| ||||
| mnInvTaxAmt | ITAM | MATH_NUMERIC | REQ | INPUT |
The tax amount in the invoice. This can be either the sales, use or VAT tax. | ||||
| mnInvTaxAmtF | CITX | MATH_NUMERIC | OPT | INPUT |
The tax amount on the invoice in foreign currency. This can be either the sales, use or VAT tax. | ||||
| mnBillingControlId | BCI | MATH_NUMERIC | REQ | INPUT |
A unique number that the system assigns to each billing record. The system assigns the number from the Next Numbers - Automatic table
| ||||
| jdGLDate | DGL | JDEDATE | REQ | INPUT |
A date that identifies the financial period to which the transaction is to be posted.
The company constants specify the date range for each
| ||||
| mnParentSeqNo | PRSQ | MATH_NUMERIC | REQ | INPUT |
A number that provides an audit trail to the original transaction of a billing detail transaction. The system initially assigns 000 as the parent
| ||||
| mnSeqNo | SBSQ | MATH_NUMERIC | REQ | INPUT |
A number that provides an audit trail for the billing detail transactions related to the same billing control ID. The system initially assigns 001
| ||||
| mnSecSeqNo | SCSQ | MATH_NUMERIC | REQ | INPUT |
A number you can use to track the changes applied to a billing detail transaction. The system initially assigns 001 as the secondary
| ||||
| mnSplitLink | SLNK | MATH_NUMERIC | REQ | INPUT |
The split link field ties component records to their base record when a transaction split occurs. | ||||
| mnCompLink | CLNK | MATH_NUMERIC | REQ | INPUT |
A code that attaches the component record to its base work file record. | ||||
| szCompCode | CCOD | char | REQ | INPUT |
A component code identifies a provisional burden that is accounted for at the billing detail transaction level. | ||||
| jdServTaxDate | DSVJ | JDEDATE | REQ | INPUT |
A date that indicates when you purchased goods or services, or when you incurred a tax liability. | ||||
| mnPayrollTransNo | PRTR | MATH_NUMERIC | REQ | INPUT |
A unique number that the system assigns to each timecard. You can use this field in the Time Entry By Job program to retrieve a specific
| ||||
| cAllowPBCO | PBCO | char | REQ | INPUT |
An option that specifies whether to allow posting to prior accounting periods (Post Before Cutoff). Turn on this option to allow posting to prior
| ||||
| cAllowInvalidAccts | ALIA | char | REQ | INPUT |
An option that specifies whether to allow entry of invalid account numbers for the distribution of vouchers, invoices, and journal entries. If you
| ||||
| cGLShortAcctSymbol | SYMS | char | REQ | INPUT |
A code, such as * or /, that precedes the general ledger short account number (the eight-digit code) during data entry. When you leave this
| ||||
| cGLLongAcctSymbol | SYML | char | REQ | INPUT |
A code (such as blank, *, or /) that precedes the long (business unit.object.sub) account number during data entry. When you leave this field
| ||||
| cGLThirdAcctSymbol | SYMU | char | REQ | INPUT |
A code (such as * or /) that precedes the third, or unstructured, account number during data entry. If you leave this field blank, the system
| ||||
| jdOverrideGLDate | DTE | JDEDATE | REQ | INPUT |
You can enter a date with or without slashes (/) or dashes (-) as separators.
If you leave a date entry field blank, the system supplies the
| ||||
| cAccountDescriptionSelect | EV02 | char | REQ | INPUT |
An option that specifies the type of processing for an event. | ||||
| idF48S910Handle | HF48S910 | ID | REQ | INPUT |
In OneWorld, a table handle for table F48S910. | ||||
| cTransactionClass | TCLS | char | REQ | INPUT |
A code that identifies the classification of a billing transaction. Valid codes are:
Blank
An ad hoc entry in the active Billing Detail Workfile
| ||||
| szUpdateProgramId | 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
| ||||
| mnContractLineNo | LNID | MATH_NUMERIC | REQ | INPUT |
A number that identifies multiple occurrences, such as line numbers on a purchase order or other document. Generally, the system assigns
| ||||
| cEligibilityCode | ELGC | char | REQ | INPUT |
A code that specifies how the system processes a transaction at the single-transaction level. Valid values are:
0
Available for invoicing and
| ||||
| mnCostAmt | AA1 | MATH_NUMERIC | OPT | INPUT |
A number that identifies the actual amount. | ||||
| mnCostAmtF | AA2 | MATH_NUMERIC | OPT | INPUT |
Amount. | ||||
| szCacheName | DL01 | char | OPT | BOTH |
A user defined name or remark. | ||||
| mnOriginalTransactionNoPay | PRTO | MATH_NUMERIC | OPT | INPUT |
This field is used in the Service Billing application to identify the original payroll transaction number that initiated a journal correction during
| ||||
| mnParentKeyIDInternal | PUKID | MATH_NUMERIC | OPT | NONE |
A unique number that the system uses to identify a record in a file. | ||||
| szOwnerPayItem | OPIM | char | OPT | NONE |
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
| ||||
| mnCentury | CTRY | MATH_NUMERIC | OPT | 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
| ||||
| mnFiscalYear1 | FY | MATH_NUMERIC | OPT | 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
| ||||
| mnPeriodNoGeneralLedge | PN | MATH_NUMERIC | OPT | NONE |
A number indicating the current accounting period. This number, used in conjunction with the Company Constants table (F0010) and the
| ||||
| cHoldCodeBilling | HLD | char | OPT | NONE |
A code that identifies the type of hold status applied to a billing detail transaction. Valid alpha values are:
Blank
Not on hold.
A
On hold for
| ||||
| cOriginalorAdjustRecord | OORA | char | OPT | NONE |
This flag indicates whether the record is the original or is a subsequently recorded adjustment; which, when summed with any other
| ||||
| mnOriginalUnits | U | MATH_NUMERIC | OPT | NONE |
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,
| ||||
| cRevenueRecognition | PRRR | char | REQ | INPUT |
A constant that controls the process for journal generation in the Service Billing and Contract Billing systems. Codes are:
1
Invoicing only
2
| ||||
| szUserId | USER | char | REQ | INPUT |
The code that identifies a user profile. | ||||
| jdDateUpdated | UPMJ | JDEDATE | REQ | INPUT |
The date that specifies the last update to the file record. | ||||
| mnTimeLastUpdated | UPMT | MATH_NUMERIC | REQ | INPUT |
The time that specifies when the program executed the last update to this record. | ||||
| szWorkStationId | JOBN | char | REQ | INPUT |
The code that identifies the work station ID that executed a particular job. | ||||
| None |
| None |