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

Table Relations From Other Tables

From Table From Field