Diagrams


Table

DO Payment Credit Card

DynamicsDocs.comDO Payment Credit Card«Table 827»DO Payment Credit CardNo. [PK]Type [NN]Credit Card NumberExpiry Date [NN]Card Holder Name [NN]Customer No. [NN]Contact No. [NN]Cvc No.No. Series«Table 112»Sales Invoice HeaderSell-to Customer No. [NN]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 GroupCurrency Code...«Table 114»Sales Cr.Memo HeaderSell-to Customer No. [NN]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 ContactPosting DateShipment DatePosting DescriptionPayment Terms CodeDue DatePayment Discount %Pmt. Discount DateShipment Method CodeLocation CodeShortcut Dimension 1 CodeShortcut Dimension 2 CodeCustomer Posting GroupCurrency CodeCurrency Factor...«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 5107»Sales Header ArchiveDocument 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 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 828»DO Payment Credit Card NumberNo. [PK]Data«Table 829»DO Payment Trans. Log EntryEntry No. [PK]Document Type; [,Order,Invoice,Payment...Document No.Customer No.Credit Card No.Transaction Type; [Authorization,Void,...Transaction Result; [Success,Failed]Transaction DescriptionAmountTransaction Date-TimeTransaction Status; [,Voided,Expired,C...Cust. Ledger Entry No.Currency CodeTransaction GUIDTransaction IDUser IDParent Entry No.Reference GUID«Table 830»DO Payment Card TypeSort OrderName [PK,NN]Validation Rule [NN]Numeric OnlyAllow SpacesMin. LengthMax. Length«Table 18»CustomerNo. [PK]NameSearch NameName 2AddressAddress 2CityContactPhone No.Telex No.Document Sending ProfileOur Account No.Territory CodeGlobal Dimension 1 CodeGlobal Dimension 2 CodeChain NameBudgeted AmountCredit Limit [LCY]Customer Posting GroupCurrency CodeCustomer Price GroupLanguage CodeStatistics GroupPayment Terms CodeFin. Charge Terms CodeSalesperson CodeShipment Method CodeShipping Agent CodePlace of ExportInvoice Disc. CodeCustomer Disc. Group...«Table 308»No. SeriesCode [PK,NN]DescriptionDefault Nos.Manual Nos.Date Order<Type><Customer No.><No. Series><Credit Card No.><Credit Card No.><Credit Card No.><Credit Card No.><Credit Card No.><No.><Credit Card No.><Sell-to Customer No.><Bill-to Customer No.><Pre-Assigned No. Series><No. Series><Order No. Series><Prepayment No. Series><Canceled By><Last Posting No.><Last Prepayment No.><Last Posting No.><Last Prepayment No.><Last Prepmt. Cr. Memo No.><Sell-to Customer No.><Bill-to Customer No.><Pre-Assigned No. Series><No. Series><Prepmt. Cr. Memo No. Series><Return Order No. Series><Last Prepmt. Cr. Memo No.><Sell-to Customer No.><Bill-to Customer No.><No. Series><Posting No. Series><Shipping No. Series><Prepayment No. Series><Prepmt. Cr. Memo No. Series><Return Receipt No. Series><Sell-to Customer No.><Bill-to Customer No.><No. Series><Posting No. Series><Shipping No. Series><Prepayment No. Series><Prepmt. Cr. Memo No. Series><Return Receipt No. Series><Account No.><Bal. Account No.><Bill-to/Pay-to No.><Source No.><Sell-to/Buy-from No.><Posting No. Series><Customer No.><Bill-to Customer No.><No. Series>

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

Fields

# Name Type
1 No. Code20
2 Type Code20 NotBlank: Yes
3 Credit Card Number Text20
4 Expiry Date Code4 NotBlank: Yes
5 Card Holder Name Text50 NotBlank: Yes
6 Customer No. Code20 NotBlank: Yes
7 Contact No. Code20 NotBlank: Yes
8 Cvc No. Text4
10 No. Series Code10

Keys

# Fields
0 No. Clustered: Yes
1 Customer No.

Table Relations To Other Tables

Field Related Table Related Field
Customer No. Customer No. 1..n
Type DO Payment Card Type Name 1..n
No. Series No. Series Code 1..n

Table Relations From Other Tables

From Table From Field
DO Payment Credit Card Number No. 1..1
DO Payment Trans. Log Entry Credit Card No. 1..n
Gen. Journal Line Credit Card No. 1..n
Sales Cr.Memo Header Credit Card No. 1..n
Sales Header Credit Card No. 1..n
Sales Header Archive Credit Card No. 1..n
Sales Invoice Header Credit Card No. 1..n