Job Journal Line Table

Specifies posting the usage for jobs. With the job journal, you can:

  • Post all job usage on resources, items and general ledger accounts

  • Reconcile resources

The Jobs application area also contains recurring journals. These journals have special fields to keep control of entries posted periodically.

As with all journals, the entries can be approved before posting.

List of Fields in the Table

Field Location
Dimension Set ID Field, Job Journal Line Table Jobs
Description Field, Job Journal Line Table Jobs
Unit Price Field, Job Journal Line Table Jobs
Service Order No. Field, Job Journal Line Table Jobs
Expiration Date Field, Job Journal Line Table Jobs
Type Field, Job Journal Line Table Jobs
Source Currency Line Amount Field, Job Journal Line Table Jobs
Line Discount Amount Field, Job Journal Line Table Jobs
Posting Group Field, Job Journal Line Table Jobs
Job Posting Only Field, Job Journal Line Table Jobs
Line Discount % Field, Job Journal Line Table Jobs
Document No. Field, Job Journal Line Table Jobs
Line Amount Field, Job Journal Line Table Jobs
Total Cost (LCY) Field, Job Journal Line Table Jobs
Transaction Type Field, Job Journal Line Table Jobs
Currency Factor Field, Job Journal Line Table Jobs
Transport Method Field, Job Journal Line Table Jobs
Ledger Entry No. Field, Job Journal Line Table Jobs
Reserved Qty. (Base) Field, Job Journal Line Table Jobs
Applies-to Entry Field, Job Journal Line Table Jobs
Source Currency Total Price Field, Job Journal Line Table Jobs
Unit Cost Field, Job Journal Line Table Jobs
Resource Group No. Field, Job Journal Line Table Jobs
Posting Date Field, Job Journal Line Table Jobs
Serial No. Field, Job Journal Line Table Jobs
Reason Code Field, Job Journal Line Table Jobs
Cost Factor Field, Job Journal Line Table Jobs
Source Currency Total Cost Field, Job Journal Line Table Jobs
Line No. Field, Job Journal Line Table Jobs
Country/Region Code Field, Job Journal Line Table Jobs
Job No. Field, Job Journal Line Table Jobs
Document Date Field, Job Journal Line Table Jobs
Unit Price (LCY) Field, Job Journal Line Table Jobs
Journal Batch Name Field, Job Journal Line Table Jobs
Location Code Field, Job Journal Line Table Jobs
Journal Template Name Field, Job Journal Line Table Jobs
Job Planning Line No. Field, Job Journal Line Table Jobs
Job Task No. Field, Job Journal Line Table Jobs
Qty. per Unit of Measure Field, Job Journal Line Table Jobs
External Document No. Field, Job Journal Line Table Jobs
Work Type Code Field, Job Journal Line Table Jobs
Customer Price Group Field, Job Journal Line Table Jobs
Line Discount Amount (LCY) Field, Job Journal Line Table Jobs
Total Price (LCY) Field, Job Journal Line Table Jobs
Unit Cost (LCY) Field, Job Journal Line Table Jobs
Ledger Entry Type Field, Job Journal Line Table Jobs
Source Code Field, Job Journal Line Table Jobs
Total Cost Field, Job Journal Line Table Jobs
Lot No. Field, Job Journal Line Table Jobs
Variant Code Field, Job Journal Line Table Jobs
Recurring Method Field, Job Journal Line Table Jobs
Area Field, Job Journal Line Table Jobs
No. Field, Job Journal Line Table Jobs
Remaining Qty. Field, Job Journal Line Table Jobs
Remaining Qty. (Base) Field, Job Journal Line Table Jobs
Gen. Bus. Posting Group Field, Job Journal Line Table Jobs
Direct Unit Cost (LCY) Field, Job Journal Line Table Jobs
Total Price Field, Job Journal Line Table Jobs
Recurring Frequency Field, Job Journal Line Table Jobs
Applies-from Entry Field, Job Journal Line Table Jobs
Line Type Field, Job Journal Line Table Jobs
Chargeable Field, Job Journal Line Table Jobs
Unit of Measure Code Field, Job Journal Line Table Jobs
Gen. Prod. Posting Group Field, Job Journal Line Table Jobs
Shortcut Dimension 1 Code Field, Job Journal Line Table Jobs
Posting No. Series Field, Job Journal Line Table Jobs
Shortcut Dimension 2 Code Field, Job Journal Line Table Jobs
Line Amount (LCY) Field, Job Journal Line Table Jobs
Quantity Field, Job Journal Line Table Jobs
Quantity (Base) Field, Job Journal Line Table Jobs
Source Currency Code Field, Job Journal Line Table Jobs
Bin Code Field, Job Journal Line Table Jobs
Description 2 Field, Job Journal Line Table Jobs
Entry/Exit Point Field, Job Journal Line Table Jobs
Transaction Specification Field, Job Journal Line Table Jobs
Currency Code Field, Job Journal Line Table Jobs
Posted Service Shipment No. Field, Job Journal Line Table Jobs
Entry Type Field, Job Journal Line Table Jobs
Shipment Method Code Field, Job Journal Line Table United Kingdom Local Functionality
CWIP G/L Type Field, Job Journal Line Table India Local Functionality
Shipment Method Code Field, Job Journal Line Table Spain Local Functionality
Time Sheet No. Field, Job Journal Line Table Resources
Time Sheet Line No. Field, Job Journal Line Table Resources
Time Sheet Date Field, Job Journal Line Table Resources
CWIP G/L Type Field, Job Journal Line Table India Local Functionality
CWIP G/L Type Field, Job Journal Line Table India Local Functionality

See Also

Reference

Job Journal

Other Resources

How to: View Job Ledger Entries
How to: View Resource Ledger Entries