BC Observatoryunofficial, made by waldo
tableAdministration & Setupofficial - Microsoftderived - from the source, no model text

Table 40111 "GP SY06000"

HybridGP · Microsoft.DataMigration.GP

Open in Claude40111.mdSource on GitHub

Across versions

  1. BC23-28not present
  2. BC29-30present

HybridGP · Microsoft.DataMigration.GP · BC29-30 · source at ea08af5e · facts from BC29

Properties

Property Value
DataClassification CustomerContent

Fields

Explanation: the field’s ToolTip in the code; without one, the ToolTip of a page control bound to the field (marked via the page); without that, its Caption (marked caption) when that differs from the name.

No. Name Type Explanation Notes
1 SERIES Integer —
2 CustomerVendor_ID Text[15] —
3 ADRSCODE Text[15] —
4 VENDORID Text[15] —
5 CUSTNMBR Text[15] —
6 EFTUseMasterID Integer —
7 EFTBankType Integer —
8 FRGNBANK Boolean —
9 INACTIVE Boolean —
10 BANKNAME Text[31] —
11 EFTBankAcct Text[35] —
12 EFTBankBranch Text[15] —
13 GIROPostType Integer —
14 EFTBankCode Text[15] —
15 EFTBankBranchCode Text[5] —
16 EFTBankCheckDigit Text[3] —
17 BSROLLNO Text[31] —
18 IntlBankAcctNum Text[35] —
19 SWIFTADDR Text[11] —
20 CustVendCountryCode Text[3] —
21 DeliveryCountryCode Text[3] —
22 BNKCTRCD Text[3] —
23 CBANKCD Text[9] —
24 ADDRESS1 Text[61] —
25 ADDRESS2 Text[61] —
26 ADDRESS3 Text[61] —
27 ADDRESS4 Text[61] —
28 RegCode1 Text[31] —
29 RegCode2 Text[31] —
30 BankInfo7 Integer —
31 EFTTransitRoutingNo Text[11] —
32 CURNCYID Text[15] —
33 EFTTransferMethod Integer —
34 EFTAccountType Integer —
35 EFTPrenoteDate DateTime —
36 EFTTerminationDate DateTime —
37 DEX_ROW_ID Integer —

Keys

  • Key1: CustomerVendor_ID, ADRSCODE, SERIES (clustered)
  • Key2: CustomerVendor_ID

Ask your agent

Procedure bodies are not stored here (D10). For a procedure body or the calls of one procedure, ask bc-code-atlas (external, by Stefan Maron, MIT; default corpus w1-28), which the bc-observatory plugin connects: bcatlas_resolve_node(object_type: "table", object_name: "GP SY06000"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.

Evidence 1 sources