Diagrams

Table

Job Planning Line Invoice

DynamicsDocs.comJob Planning Line Invoice«Table 1022»Job Planning Line InvoiceJob No. [PK]Job Task No. [PK]Job Planning Line No. [PK]Document Type; [,Invoice,Credit Memo,P...Document No. [PK]Line No. [PK]Quantity TransferredTransferred DateInvoiced DateInvoiced Amount [LCY]Invoiced Cost Amount [LCY]Job Ledger Entry No.«Table 167»JobNo. [PK]Search DescriptionDescriptionDescription 2Bill-to Customer No.Creation DateStarting DateEnding DateStatus; [Planning,Quote,Open,Completed...Person ResponsibleGlobal Dimension 1 CodeGlobal Dimension 2 CodeJob Posting GroupBlocked; [,Posting,All]Last Date ModifiedCommentCustomer Disc. GroupCustomer Price GroupLanguage CodeScheduled Res. Qty.Resource FilterPosting Date FilterResource Gr. FilterScheduled Res. Gr. Qty.PictureBill-to NameBill-to AddressBill-to Address 2Bill-to CityBill-to CountyBill-to Post Code...«Table 1001»Job TaskJob No. [PK,NN]Job Task No. [PK,NN]DescriptionJob Task Type; [Posting,Heading,Total,...WIP-Total; [,Total,Excluded]Job Posting GroupWIP MethodSchedule [Total Cost]Schedule [Total Price]Usage [Total Cost]Usage [Total Price]Contract [Total Cost]Contract [Total Price]Contract [Invoiced Price]Contract [Invoiced Cost]Posting Date FilterPlanning Date FilterTotalingNew PageNo. of Blank LinesIndentationRecognized Sales AmountRecognized Costs AmountRecognized Sales G/L AmountRecognized Costs G/L AmountGlobal Dimension 1 CodeGlobal Dimension 2 CodeOutstanding OrdersAmt. Rcd. Not InvoicedRemaining [Total Cost]Remaining [Total Price]...«Table 1003»Job Planning LineLine No. [PK]Job No. [PK,NN]Planning DateDocument No.Type; [Resource,Item,G/L Account,Text]No.DescriptionQuantityDirect Unit Cost [LCY]Unit Cost [LCY]Total Cost [LCY]Unit Price [LCY]Total Price [LCY]Resource Group No.Unit of Measure CodeLocation CodeLast Date ModifiedUser IDWork Type CodeCustomer Price GroupCountry/Region CodeGen. Bus. Posting GroupGen. Prod. Posting GroupDocument DateJob Task No. [PK,NN]Line Amount [LCY]Unit CostTotal CostUnit PriceTotal PriceLine Amount...«Table 169»Job Ledger EntryEntry No. [PK]Job No.Posting DateDocument No.Type; [Resource,Item,G/L Account]No.DescriptionQuantityDirect Unit Cost [LCY]Unit Cost [LCY]Total Cost [LCY]Unit Price [LCY]Total Price [LCY]Resource Group No.Unit of Measure CodeLocation CodeJob Posting GroupGlobal Dimension 1 CodeGlobal Dimension 2 CodeWork Type CodeCustomer Price GroupUser IDSource CodeAmt. to Post to G/LAmt. Posted to G/LEntry Type; [Usage,Sale]Journal Batch NameReason CodeTransaction TypeTransport MethodCountry/Region Code...<Job No.><Job Task No.><Job Planning Line No.><Job Ledger Entry No.><Job No.><Job No.><Job No.><Job Task No.><Job Task No.><Job Ledger Entry No.>

Drag with mouse | Use controls on the right | Click on tables | Write to me with ideas and feedback

Fields

# Name Type
1 Job No. (Job No.) Code20 Editable: No
2 Job Task No. (Job Task No.) Code20 Editable: No
3 Job Planning Line No. (Job Planning Line No.) Integer Editable: No
4 Document Type (Document Type) Option Editable: No
5 Document No. (Document No.) Code20 Editable: No
6 Line No. (Line No.) Integer
7 Quantity Transferred (Quantity Transferred) Decimal Editable: No
8 Transferred Date (Transferred Date) Date Editable: No
9 Invoiced Date (Invoiced Date) Date Editable: No
10 Invoiced Amount (LCY) (Invoiced Amount (LCY)) Decimal Editable: No
11 Invoiced Cost Amount (LCY) (Invoiced Cost Amount (LCY)) Decimal Editable: No
12 Job Ledger Entry No. (Job Ledger Entry No.) Integer BlankZero: Yes
Editable: No

Keys

# Fields
0 Job No.,Job Task No.,Job Planning Line No.,Document Type,Document No.,Line No. (Job No.,Job Task No.,Job Planning Line No.,Document Type,Document No.,Line No.) Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field
Job No. (Job No.) Job No. (No.) 1..n
Job Ledger Entry No. (Job Ledger Entry No.) Job Ledger Entry Entry No. (Entry No.) 1..n
Job Planning Line No. (Job Planning Line No.) Job Planning Line Line No. (Line No.) 1..n
Job Task No. (Job Task No.) Job Task Job Task No. (Job Task No.) 1..n

Table Relations From Other Tables

From Table From Field