SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

www.saptables.net

Schema:
 Module:  Table: 
Column: 
Searchbeta 

icon of database logic symbol SAP  TABLESv1Made in Britain

JDETables.com - the webs number one JD Edwards Table Definition reference

ERP 6.0: Top 10 requests

TableColumnsDescription

B1 9.2: Top 10 requests

TableColumnsDescription

B1 8.8: Top 10 requests

TableColumnsDescription
PHPRef.com - the webs number one PHP Function reference tool
Business Partners
ProductVersionTableColumnsIndexesDescriptionModule
1Business One9.3CRD1251BP eDoc SettingsBusiness Partners
SQL:  selectupdate insert create

Use the column checkboxes to build your query. Header columns sets/unsets all columns

SELECT CardCode, ProtCode, GenType, MapID, LogInstanc FROM CRD12
ColumnFieldDescriptionSQL TypeLengthDecimalsRelationDefault ValueConstraintsSQL Create Statement
1CardCodeBP Codenvarchar150OCRD Allow NULL? 
2ProtCodeCommunication Type or Protocolint110OECM0=Invalid, 1=GEN, 2=EET, 3=CFDI Allow NULL? 
3GenTypeGeneration Typechar10NG=Generate, L=Generate Later, N=Not Relevant Allow NULL? 
4MapIDElectronic Document Format Mappingint110 Allow NULL? 
5LogInstancLog Instanceint1100 Allow NULL? 
NamePrimaryUniqueTypeColumns
PRIMARYNoYesCardCode, ProtCode