Diagrams


Table

Incoming Document

DynamicsDocs.comIncoming Document«Table 130»Incoming DocumentEntry No. [PK]DescriptionCreated Date-TimeCreated By User IDCreated By User NameReleasedReleased Date-TimeReleased By User IDReleased By User NameLast Date-Time ModifiedLast Modified By User IDLast Modified By User NamePostedPosted Date-TimeDocument Type; [Journal,Sales Invoice,...Document No.Posting DateStatus; [New,Released,Rejected,Posted,...URL1URL2URL3URL4Vendor NameVendor VAT Registration No.Vendor IBANDocument DateVendor Bank Branch No.Vendor Bank Account No.Vendor No.Data Exchange TypeOCR Data Corrected...«Table 1220»Data Exch.Entry No. [PK]File NameFile ContentData Exch. Def CodeData Exch. Line Def CodeTable FiltersIncoming Entry No.Related Record«Table 133»Incoming Document AttachmentIncoming Document Entry No. [PK]Line No. [PK]Created Date-TimeCreated By User NameNameType; [,Image,PDF,Word,Excel,PowerPoin...File ExtensionContentDocument No.Posting DateDocument Table No. FilterDocument Type Filter; [Quote,Order,Inv...Document No. FilterJournal Template Name FilterJournal Batch Name FilterJournal Line No. FilterDefaultUse for OCRExternal Document ReferenceOCR Service Document ReferenceGenerated from OCRMain AttachmentId«Table 137»Inc. Doc. Attachment OverviewIncoming Document Entry No. [PK]Line No.Created Date-TimeCreated By User NameNameType; [,Image,PDF,Word,Excel,PowerPoin...File ExtensionAttachment Type; [,Group,Main Attachme...Sorting Order [PK]Indentation«Table 36»Sales HeaderDocument Type; [Quote,Order,Invoice,Cr...Sell-to Customer No.No. [PK]Bill-to Customer No. [NN]Bill-to NameBill-to Name 2Bill-to AddressBill-to Address 2Bill-to CityBill-to ContactYour ReferenceShip-to CodeShip-to NameShip-to Name 2Ship-to AddressShip-to Address 2Ship-to CityShip-to ContactOrder DatePosting DateShipment DatePosting DescriptionPayment Terms CodeDue DatePayment Discount %Pmt. Discount DateShipment Method CodeLocation CodeShortcut Dimension 1 CodeShortcut Dimension 2 CodeCustomer Posting Group...«Table 38»Purchase HeaderDocument Type; [Quote,Order,Invoice,Cr...Buy-from Vendor No.No. [PK]Pay-to Vendor No. [NN]Pay-to NamePay-to Name 2Pay-to AddressPay-to Address 2Pay-to CityPay-to ContactYour ReferenceShip-to CodeShip-to NameShip-to Name 2Ship-to AddressShip-to Address 2Ship-to CityShip-to ContactOrder DatePosting DateExpected Receipt DatePosting DescriptionPayment Terms CodeDue DatePayment Discount %Pmt. Discount DateShipment Method CodeLocation CodeShortcut Dimension 1 CodeShortcut Dimension 2 CodeVendor Posting Group...«Table 81»Gen. Journal LineJournal Template Name [PK]Line No. [PK]Account Type; [G/L Account,Customer,Ve...Account No.Posting DateDocument Type; [,Payment,Invoice,Credi...Document No.DescriptionVAT %Bal. Account No.Currency CodeAmountDebit AmountCredit AmountAmount [LCY]Balance [LCY]Currency FactorSales/Purch. [LCY]Profit [LCY]Inv. Discount [LCY]Bill-to/Pay-to No.Posting GroupShortcut Dimension 1 CodeShortcut Dimension 2 CodeSalespers./Purch. CodeSource CodeSystem-Created EntryOn HoldApplies-to Doc. Type; [,Payment,Invoic...Applies-to Doc. No.Due Date...«Table 2000000120»UserUser Security ID [PK]User NameFull NameState; [Enabled,Disabled]Expiry DateWindows Security IDChange PasswordLicense Type; [Full User,Limited User,...Authentication EmailContact EmailExchange IdentifierApplication ID«Table 23»VendorNo. [PK]NameSearch NameName 2AddressAddress 2CityContactPhone No.Telex No.Our Account No.Territory CodeGlobal Dimension 1 CodeGlobal Dimension 2 CodeBudgeted AmountVendor Posting GroupCurrency CodeLanguage CodeStatistics GroupPayment Terms CodeFin. Charge Terms CodePurchaser CodeShipment Method CodeShipping Agent CodeInvoice Disc. CodeCountry/Region CodeCommentBlocked; [,Payment,All]Pay-to Vendor No.PriorityPayment Method Code...«Table 1213»Data Exchange TypeCode [PK,NN]DescriptionData Exch. Def. CodeEntity Type; [Invoice,Credit Memo]«Table 1271»OCR Service Document TemplateCode [PK,NN]Name<Created By User ID><Released By User ID><Last Modified By User ID><Vendor No.><Data Exchange Type><OCR Service Doc. Template Code><Incoming Entry No.><Incoming Document Entry No.><Incoming Document Entry No.><Incoming Document Entry No.><Incoming Document Entry No.><Incoming Document Entry No.><Data Exch. Entry No.><Buy-from Vendor No.><Pay-to Vendor No.><Account No.><Bal. Account No.><Bill-to/Pay-to No.><Source No.><Sell-to/Buy-from No.><Pay-to Vendor No.>

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

Fields

# Name Type
1 Entry No. (Entry No.) Integer AutoIncrement: Yes
2 Description (Description) Text50
3 Created Date-Time (Created Date-Time) DateTime Editable: No
4 Created By User ID (Created By User ID) GUID Editable: No
5 Created By User Name (Created By User Name) Code50 Editable: No
FlowField
6 Released (Released) Boolean Editable: No
7 Released Date-Time (Released Date-Time) DateTime Editable: No
8 Released By User ID (Released By User ID) GUID Editable: No
9 Released By User Name (Released By User Name) Code50 Editable: No
FlowField
10 Last Date-Time Modified (Last Date-Time Modified) DateTime Editable: No
11 Last Modified By User ID (Last Modified By User ID) GUID Editable: No
12 Last Modified By User Name (Last Modified By User Name) Code50 Editable: No
FlowField
13 Posted (Posted) Boolean Editable: No
14 Posted Date-Time (Posted Date-Time) DateTime Editable: No
15 Document Type (Document Type) Option Editable: No
16 Document No. (Document No.) Code20 Editable: No
17 Posting Date (Posting Date) Date [ClosingDates:Yes] Editable: No
18 Status (Status) Option Editable: No
19 URL1 (URL1) Text250 Editable: No
20 URL2 (URL2) Text250 Editable: No
21 URL3 (URL3) Text250 Editable: No
22 URL4 (URL4) Text250 Editable: No
23 Vendor Name (Vendor Name) Text50
24 Vendor VAT Registration No. (Vendor VAT Registration No.) Text30
25 Vendor IBAN (Vendor IBAN) Code50
26 Document Date (Document Date) Date
27 Vendor Bank Branch No. (Vendor Bank Branch No.) Text20
28 Vendor Bank Account No. (Vendor Bank Account No.) Text30
29 Vendor No. (Vendor No.) Code20
30 Data Exchange Type (Data Exchange Type) Code20
31 OCR Data Corrected (OCR Data Corrected) Boolean
32 OCR Status (OCR Status) Option Editable: No
38 OCR Service Doc. Template Code (OCR Service Doc. Template Code) Code20
39 OCR Service Doc. Template Name (OCR Service Doc. Template Name) Text50 Editable: No
FlowField
40 OCR Process Finished (OCR Process Finished) Boolean
41 Created Doc. Error Msg. Type (Created Doc. Error Msg. Type) Option
42 Vendor Id (Vendor Id) GUID
50 Currency Code (Currency Code) Code10
51 Amount Excl. VAT (Amount Excl. VAT) Decimal
52 Amount Incl. VAT (Amount Incl. VAT) Decimal
53 VAT Amount (VAT Amount) Decimal
54 Due Date (Due Date) Date
55 Vendor Invoice No. (Vendor Invoice No.) Code35
56 Order No. (Order No.) Code20
57 Vendor Phone No. (Vendor Phone No.) Text30
58 Related Record ID (Related Record ID) RecordID
160 Job Queue Status (Job Queue Status) Option Editable: No
161 Job Queue Entry ID (Job Queue Entry ID) GUID Editable: No
162 Processed (Processed) Boolean

Keys

# Fields
0 Entry No. (Entry No.) Clustered: Yes
1 Status (Status)
2 Document No.,Posting Date (Document No.,Posting Date)

Table Relations To Other Tables

Field Related Table Related Field
Data Exchange Type (Data Exchange Type) Data Exchange Type Code (Code) 1..n
OCR Service Doc. Template Code (OCR Service Doc. Template Code) OCR Service Document Template Code (Code) 1..n
Last Modified By User ID (Last Modified By User ID) User User Security ID (User Security ID) 1..n
Vendor No. (Vendor No.) Vendor No. (No.) 1..n

Table Relations From Other Tables

From Table From Field
Data Exch. Incoming Entry No. (Incoming Entry No.) 1..n
Gen. Journal Line Incoming Document Entry No. (Incoming Document Entry No.) 1..n
Inc. Doc. Attachment Overview Incoming Document Entry No. (Incoming Document Entry No.) 1..n
Incoming Document Attachment Incoming Document Entry No. (Incoming Document Entry No.) 1..n
Purchase Header Incoming Document Entry No. (Incoming Document Entry No.) 1..n
Sales Header Incoming Document Entry No. (Incoming Document Entry No.) 1..n