Diagrams

Table

Jobs Setup

DynamicsDocs.comJobs Setup«Table 315»Jobs SetupPrimary Key [PK]Job Nos.Apply Usage Link by DefaultDefault WIP MethodDefault Job Posting GroupDefault WIP Posting Method; [Per Job,P...Allow Sched/Contract Lines DefLogo Position on Documents; [No Logo,L...Job WIP Nos.Automatic Update Job Item Cost«Table 308»No. SeriesCode [PK,NN]DescriptionDefault Nos.Manual Nos.Date Order«Table 1006»Job WIP MethodCode [PK,NN]DescriptionWIP CostWIP SalesRecognized Costs; [At Completion,Cost...Recognized Sales; [At Completion,Contr...ValidSystem DefinedSystem-Defined Index«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<Job Nos.><Job WIP Nos.><Default WIP Method><Default Job Posting Group>

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

Fields

# Name Type
1 Primary Key (Primary Key) Code10
2 Job Nos. (Job Nos.) Code10
3 Apply Usage Link by Default (Apply Usage Link by Default) Boolean
4 Default WIP Method (Default WIP Method) Code20
5 Default Job Posting Group (Default Job Posting Group) Code10
6 Default WIP Posting Method (Default WIP Posting Method) Option
7 Allow Sched/Contract Lines Def (Allow Sched/Contract Lines Def) Boolean
31 Logo Position on Documents (Logo Position on Documents) Option
40 Job WIP Nos. (Job WIP Nos.) Code10
1001 Automatic Update Job Item Cost (Automatic Update Job Item Cost) Boolean

Keys

# Fields
0 Primary Key (Primary Key) Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field
Default Job Posting Group (Default Job Posting Group) Job Posting Group Code (Code) 1..n
Default WIP Method (Default WIP Method) Job WIP Method Code (Code) 1..n
Job WIP Nos. (Job WIP Nos.) No. Series Code (Code) 1..n

Table Relations From Other Tables

From Table From Field