D48S0260A - Update F4812
Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
---|---|---|---|---|
jdDtForGLAndVouch1 | 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
| ||||
mnParentSequenceNbr | 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
| ||||
mnSequenceNbrServiceBilling | 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
| ||||
mnSecondarySequence | 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
| ||||
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
| ||||
mnSplitLink | SLNK | MATH_NUMERIC | REQ | INPUT |
The split link field ties component records to their base record when a transaction split occurs. | ||||
mnComponentLink | CLNK | MATH_NUMERIC | REQ | INPUT |
A code that attaches the component record to its base work file record. | ||||
szComponentCode | CCOD | char | REQ | INPUT |
A component code identifies a provisional burden that is accounted for at the billing detail transaction level. | ||||
szGlClass | 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
| ||||
szGlOffsetRetention | RGLC | char | OPT | INPUT |
A code that designates the offset accounts for retainage, for example RETN or 1225. You set up the code as an automatic accounting
| ||||
mnPercntRetainage | PRET | MATH_NUMERIC | OPT | INPUT |
The retainage rate for the contract. The rate is a percentage that is expressed as a whole number. For example, you enter a retainage rate
| ||||
mnRetainage | RTNG | MATH_NUMERIC | OPT | INPUT |
This field is the retained dollars for a contract line. | ||||
mnRetainagePriorStoredMatE | RTPS | MATH_NUMERIC | OPT | INPUT |
Stored Material Retainage amount through the last application or adjustment for a specific contract. | ||||
mnForeignRetainage | FRTN | MATH_NUMERIC | OPT | INPUT |
The amount of retainage in foreign currency. | ||||
cDownloadFlagServiceBilli | DWNL | char | OPT | INPUT |
Future Use. This field is designed to be used in the future as a mechanism to control the downloading of information. | ||||
cCodingBlockChange | CBLC | char | OPT | INPUT |
This field is used to detect any changes that might occur in the coding block of a given workfile (F4812) transaction. If the system detects
| ||||
jdDateTransactionEnter | DEJ | JDEDATE | OPT | INPUT |
Date - Transaction Entered | ||||
mnCurrencyConverRateDiv | 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
| ||||
szCurrencyCodeSource | CRCE | char | OPT | INPUT |
szCurrencyCodeOrigin | CRCF | char | OPT | INPUT |
The currency code of the insured amount. | ||||
mnAmountAa2 | AA2 | MATH_NUMERIC | OPT | INPUT |
Amount. | ||||
cTypeOfKey | 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
| ||||
jdDateForGLandVoucherJULIA | DGJ | JDEDATE | OPT | INPUT |
A date that identifies the financial period to which the transaction will be posted. You define financial periods for a date pattern code that you
| ||||
jdDateInvoiceJournalDate | IDGJ | JDEDATE | OPT | INPUT |
A date that identifies the financial period to which the transaction is to be posted. The general accounting constants specify the date range
| ||||
cPassThroughInvoicingFlag | PTFG | char | OPT | INPUT |
A code that identifies a pay when paid record. | ||||
mnIdentifierShortItem | ITM | MATH_NUMERIC | OPT | INPUT |
An inventory item number. The system provides three separate item numbers plus an extensive cross-reference capability to other item
| ||||
mnAmtExtendedCost | PAID | MATH_NUMERIC | OPT | INPUT |
The extended cost or price value of an inventory transaction for an inventory item. | ||||
mnAmountForeignExtPrice | FEA | MATH_NUMERIC | OPT | INPUT |
The product of the foreign price times the number of units. | ||||
cDateExchangeRateDateBasi | 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
| ||||
jdDateExchangeRate | 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. | ||||
szSubsidiaryAlternate | SUBA | char | OPT | INPUT |
An alternate subsidiary account that allows you to comply with a regulatory chart of accounts, parent company requirements, or third party
| ||||
szBatchControlKey | BCTK | char | OPT | INPUT |
Reserved by J.D. Edwards. | ||||
szParentWoNumber | PARS | char | OPT | INPUT |
A number that identifies the parent work order. You can use this number to do the following:
o Enter default values for new work orders,
| ||||
szPricingCategory | PRGR | char | OPT | INPUT |
A user defined code (system 40/type PI) that identifies an inventory price group for an item.
Inventory price groups have unique pricing
| ||||
szGroupCustomerPriceGp | CPGP | char | OPT | INPUT |
A user defined code (40/PC) that identifies a customer group. You can group customers with similar characteristics, such as comparable
| ||||
cBillingBasisFlag9 | BBF | char | OPT | INPUT |
For future use in Trade Price Billing. | ||||
mnMarkUpPercent | MKRP | MATH_NUMERIC | OPT | INPUT |
Percent of markup you want the system to use when it calculates the billing amounts for fee lines for owner pay items. You enter either a
| ||||
cFeeBasisCostOrInv | FBAS | char | OPT | INPUT |
The fee basis the system will use when it derives the billing amount for the fee line.
Valid values:
1 Use Invoice Amount.
2 Use Cost
| ||||
cRevenueFeeBasis | RFBS | char | OPT | INPUT |
The fee basis the system will use when it derives the revenue amount for the fee line.
1 Use Revenue Amount
2 Use Cost Amount
If you
| ||||
cKeyTypeMarkupTableType1 | TKM1 | char | OPT | INPUT |
The invoice markup table used to mark up this transaction. | ||||
cKeyTypeMarkupTableType2 | TKM2 | char | OPT | INPUT |
The revenue markup table used to mark up the revenue side of this transaction.
If a revenue markup table is not specified, the invoice
| ||||
cKeyTypeMarkupTableType3 | TKM3 | char | OPT | INPUT |
The component markup table used to calculate component markup amounts for this transaction. If a specific component markup table is
| ||||
cKeyTypeAcctDerivationTable1 | TKA1 | char | OPT | INPUT |
The table type 1 account derivation table used for journaling. | ||||
cKeyTypeAcctDerivationTable2 | TKA2 | char | OPT | INPUT |
The table type 2 account derivation table used for journaling. | ||||
cKeyTypeAcctDerivationTable3 | TKA3 | char | OPT | INPUT |
The table type 3 account derivation table used for journaling. | ||||
cKeyTypeGLOffsetTable | TKG1 | char | OPT | INPUT |
This field lists the G/L Offset Table used. | ||||
cKeyTypeTaxDerivationTable | TKT1 | char | OPT | INPUT |
The tax derivation table used. | ||||
mnTotalAmountHistoricalRevenue | HBTL | MATH_NUMERIC | OPT | INPUT |
This value represents the revenue amount prior to invoice generation. Use this value to restore the original revenue amount if the record is
| ||||
mnTotalAmountInvoicedHistorica | HITL | MATH_NUMERIC | OPT | INPUT |
This value represents the invoice amount prior to invoice generation. Use this value to restore the original invoice amount if the record is
| ||||
mnInvoiceTaxableHistorical | HITX | MATH_NUMERIC | OPT | INPUT |
This value represents the invoice taxable amount prior to invoice generation.
Use this value to restore the original invoice taxable amount if
| ||||
mnInvoiceTaxAmountHistorical | HTAM | MATH_NUMERIC | OPT | INPUT |
This value represents the invoice tax amount prior to invoice generation. Use this value to restore the original invoice tax amount if the
| ||||
mnUnitPricePerPrimaryForeign | PRIF | MATH_NUMERIC | OPT | INPUT |
This field represents the Foreign Unit price. | ||||
cNTEControlFlag | NCTL | char | OPT | INPUT |
This field is used to identify records subject to Not-To-Exceed (NTE) limitations. | ||||
szUserId | USER | char | OPT | INPUT |
The code that identifies a user profile. | ||||
szWorkStationId | JOBN | char | OPT | INPUT |
The code that identifies the work station ID that executed a particular job. | ||||
szProgramId | PID | char | OPT | INPUT |
The number that identifies the batch or interactive program (batch or interactive object). For example, the number of the Sales Order Entry
| ||||
jdDateUpdated | UPMJ | JDEDATE | OPT | INPUT |
The date that specifies the last update to the file record. | ||||
mnTimeLastUpdated | UPMT | MATH_NUMERIC | OPT | INPUT |
The time that specifies when the program executed the last update to this record. | ||||
szCurrencyCodeFrom | CRCD | char | OPT | INPUT |
A code that identifies the currency of a transaction. | ||||
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
| ||||
szGeocodeShipFrom | TXA1 | char | OPT | 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
| ||||
szGeocodeOrderAccept | TXA1 | char | OPT | 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
| ||||
szVertexTransactionType | VVTY | char | OPT | INPUT |
Vertex Sales and Use Tax transaction type. | ||||
szVertexProductCategory | VVTC | char | OPT | INPUT |
User defined code used in the Vertex Tax Decision Maker for products or services that are non-taxable or are at a non-stanard rate. | ||||
cRetroAdjustmentStatus | RAS | char | OPT | INPUT |
A code that identifies if the transaction is eligible for retro rate adjustments. Valid values are:
Blank
Available for retro adjustments.
1
Not
| ||||
mnRetroAdjustmentGroup | RAG | MATH_NUMERIC | OPT | INPUT |
A number that identifies a group of transactions that the system processed for retro rate adjustments. The system assigns the group
|
None |
None |