Tables Used in Advanced Stock Valuation

This table identifies the primary JD Edwards EnterpriseOne Advanced Stock Valuation tables and their contents:

Table

Description

Item Pool Valuation Master table (F3904)

Contains information for these valuation methods:

  • Item number or pool.

  • Valuation method.

  • User identification and update information.

Valuation Category Master table (F39041)

Contains information for these valuation methods:

  • Unit of measure

  • GL class

Company G/L Update Method Master table (F39042)

Contains information for these valuation methods:

  • GL update method

  • Default branch/plant

Valuation Method Master table (F3905)

Contains information for all valuation methods that you define for the company.

Item Pool Valuation Cost Master table (F3908)

Maintains the replacement cost of the items and pools.

G/L Adjustment Table (F3910)

Displays the adjustments made to the GL table.

Valuation Period Table (F39061)

Contains these stock valuation methods for the period:

  • Opening quantities and amounts.

  • Period incoming quantities and amounts.

  • Period outgoing quantities and amounts.

  • Closing quantities and amounts.

  • Inventory and COGS adjustment.

  • LIFO adjustment and adjustment cost.

  • General ledger classification.

  • Posted and closed information.

  • User identification and update. information.

Valuation Layers Table (F39062)

Contains all of the information for the historical layers for all stock valuation methods that you define for the company, including:

  • Receipt information.

  • Current quantity, amount, and allocations.

  • Last allocation amount, quantity, and date.

  • User identification and update information.

Period Additional Quantity Table (F39063)

Contains the valuation information for those methods that you defined to include not-in-stock inventory, in-transit inventory, or loan and borrow accommodations.

Valuation Document Summary Table (F39064)

Contains the cost information summarized by document type.