Diagrams


Table

Job Posting Buffer

DynamicsDocs.comJob Posting Buffer«Table 212»Job Posting BufferJob No. [PK]Entry Type; [Usage,Sale] [PK]Posting Group Type; [Resource,Item,G/L...No. [PK]Posting Group [PK]Global Dimension 1 CodeGlobal Dimension 2 CodeUnit of Measure Code [PK]Work Type Code [PK]AmountQuantityTotal CostTotal PriceApplies-to IDGen. Bus. Posting Group [PK]Gen. Prod. Posting Group [PK]Additional-Currency AmountDimension Entry No. [PK]Variant Code [PK]Dimension Set ID«Table 167»JobNo. [PK]Search DescriptionDescriptionDescription 2Bill-to Customer No.Creation DateStarting DateEnding DateStatus; [Planning,Quote,Order,Complete...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 208»Job Posting GroupCode [PK,NN]WIP Costs AccountWIP Accrued Costs AccountJob Costs Applied AccountJob Costs Adjustment AccountG/L Expense Acc. [Contract]Job Sales Adjustment AccountWIP Accrued Sales AccountWIP Invoiced Sales AccountJob Sales Applied AccountRecognized Costs AccountRecognized Sales AccountItem Costs Applied AccountResource Costs Applied AccountG/L Costs Applied Account«Table 349»Dimension ValueDimension Code [PK,NN]Code [PK,NN]NameDimension Value Type; [Standard,Headin...TotalingBlockedConsolidation CodeIndentationGlobal Dimension No.Map-to IC Dimension CodeMap-to IC Dimension Value CodeDimension Value ID«Table 200»Work TypeCode [PK,NN]DescriptionUnit of Measure Code«Table 250»Gen. Business Posting GroupCode [PK,NN]DescriptionDef. VAT Bus. Posting GroupAuto Insert Default«Table 251»Gen. Product Posting GroupCode [PK,NN]DescriptionDef. VAT Prod. Posting GroupAuto Insert Default«Table 480»Dimension Set EntryDimension Set ID [PK]Dimension Code [PK,NN]Dimension Value Code [NN]Dimension Value IDDimension NameDimension Value Name<Job No.><Posting Group><Global Dimension 1 Code><Global Dimension 2 Code><Work Type Code><Gen. Bus. Posting Group><Gen. Prod. Posting Group><Dimension Set ID><Global Dimension 1 Code><Global Dimension 2 Code><Job Posting Group><Dimension Value Code>

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

Fields

# Name Type
1 Job No. Code20
2 Entry Type Option
3 Posting Group Type Option
4 No. Code20
5 Posting Group Code10
6 Global Dimension 1 Code Code20
7 Global Dimension 2 Code Code20
8 Unit of Measure Code Code10
9 Work Type Code Code10
20 Amount Decimal
21 Quantity Decimal (0:5)
22 Total Cost Decimal
23 Total Price Decimal
24 Applies-to ID Code50
25 Gen. Bus. Posting Group Code10
26 Gen. Prod. Posting Group Code10
27 Additional-Currency Amount Decimal
28 Dimension Entry No. Integer
29 Variant Code Code10
480 Dimension Set ID Integer Editable: No

Keys

# Fields
0 Job No.,Entry Type,Posting Group Type,No.,Variant Code,Posting Group,Gen. Bus. Posting Group,Gen. Prod. Posting Group,Unit of Measure Code,Work Type Code,Dimension Entry No. Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field
Dimension Set ID Dimension Set Entry 1..n
Global Dimension 2 Code Dimension Value Code 1..n
Gen. Bus. Posting Group Gen. Business Posting Group Code 1..n
Gen. Prod. Posting Group Gen. Product Posting Group Code 1..n
Job No. Job No. 1..n
Posting Group Job Posting Group Code 1..n
Work Type Code Work Type Code 1..n

Table Relations From Other Tables

From Table From Field