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

Keys

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

Table Relations To Other Tables

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

Table Relations From Other Tables

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