| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | CLNT | (N'000') | No | T000 | MANDT | Allow NULL? |
| 2 | DOCNUM | Document Number | nvarchar | 10 | 0 | NUMC | (N'0000000000') | No | J_1BNFDOC | J_1BDOCNUM | Allow NULL? |
| 3 | PARVW | Nota Fiscal Partner Function | nvarchar | 2 | 0 | CHAR | (N' ') | No | J_1BAD | J_1BPARVW | Allow NULL? |
| 4 | NAME1 | Name 1 | nvarchar | 35 | 0 | CHAR | (N' ') | Yes | | NAME1_GP | Allow NULL? |
| 5 | NAME2 | Name 2 | nvarchar | 35 | 0 | CHAR | (N' ') | Yes | | NAME2_GP | Allow NULL? |
| 6 | NAME3 | Name 3 | nvarchar | 35 | 0 | CHAR | (N' ') | Yes | | NAME3_GP | Allow NULL? |
| 7 | NAME4 | Name 4 | nvarchar | 35 | 0 | CHAR | (N' ') | Yes | | NAME4_GP | Allow NULL? |
| 8 | PSTLZ | Postal Code | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | PSTLZ | Allow NULL? |
| 9 | ORT01 | City | nvarchar | 35 | 0 | CHAR | (N' ') | Yes | | ORT01_GP | Allow NULL? |
| 10 | LAND1 | Country Key | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | T005 | LAND1_GP | Allow NULL? |
| 11 | STRAS | House number and street | nvarchar | 35 | 0 | CHAR | (N' ') | Yes | | STRAS_GP | Allow NULL? |
| 12 | PFACH | PO Box | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | PFACH | Allow NULL? |
| 13 | PSTL2 | P.O. Box Postal Code | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | PSTL2 | Allow NULL? |
| 14 | PSKTO | Account Number of Bank Account At Post Office | nvarchar | 16 | 0 | CHAR | (N' ') | Yes | | PSKTO | Allow NULL? |
| 15 | BANKN | Bank account number | nvarchar | 18 | 0 | CHAR | (N' ') | Yes | | BANKN | Allow NULL? |
| 16 | BANKL | Bank Keys | nvarchar | 15 | 0 | CHAR | (N' ') | Yes | | BANKK | Allow NULL? |
| 17 | BANKS | Bank country key | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | T005 | BANKS | Allow NULL? |
| 18 | STCD1 | Tax Number 1 | nvarchar | 16 | 0 | CHAR | (N' ') | Yes | | STCD1 | Allow NULL? |
| 19 | STCD2 | Tax Number 2 | nvarchar | 11 | 0 | CHAR | (N' ') | Yes | | STCD2 | Allow NULL? |
| 20 | STKZU | Liable for VAT | char | 1 | 0 | CHAR | (N' ') | Yes | | STKZU | Allow NULL? |
| 21 | STKZA | Indicator: Business Partner Subject to Equalization Tax? | char | 1 | 0 | CHAR | (N' ') | Yes | | STKZA | Allow NULL? |
| 22 | REGIO | Region (State, Province, County) | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | T005S | REGIO | Allow NULL? |
| 23 | BKONT | Bank Control Key | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | BKONT | Allow NULL? |
| 24 | DTAWS | Instruction key for data medium exchange | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | T015W | DTAWS | Allow NULL? |
| 25 | DTAMS | Indicator for Data Medium Exchange | char | 1 | 0 | CHAR | (N' ') | Yes | | DTAMS | Allow NULL? |
| 26 | XCPDK | Indicator: Is the account a one-time account? | char | 1 | 0 | CHAR | (N' ') | Yes | | XCPDK | Allow NULL? |
| 27 | EMPFG | Payee code | nvarchar | 16 | 0 | CHAR | (N' ') | Yes | | EMPFG | Allow NULL? |
| 28 | SPRAS | Language Key | char | 1 | 0 | LANG | (N' ') | Yes | T002 | SPRAS | Allow NULL? |
| 29 | STKZN | Natural Person | char | 1 | 0 | CHAR | (N' ') | Yes | | STKZN | Allow NULL? |
| 30 | J_1BSTAINS | State Tax Number | nvarchar | 18 | 0 | CHAR | (N' ') | Yes | | J_1BSTAINS | Allow NULL? |
| 31 | J_1BMUNINS | Municipal Tax Number | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | J_1BMUNINS | Allow NULL? |
| 32 | NAME_CO | c/o name | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | AD_NAME_CO | Allow NULL? |
| 33 | CITY1 | City | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | AD_CITY1 | Allow NULL? |
| 34 | CITY2 | District | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | AD_CITY2 | Allow NULL? |
| 35 | CITY_CODE | City code for city/street file | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | ADRCITY | AD_CITYNUM | Allow NULL? |
| 36 | CITYP_CODE | District code for City and Street file | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | ADRCITYPRT | AD_CITYPNM | Allow NULL? |
| 37 | HOME_CITY | City (different from postal city) | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | AD_CITY3 | Allow NULL? |
| 38 | CITYH_CODE | Different city for city/street file | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | ADRCITY | AD_CITYHNM | Allow NULL? |
| 39 | CHCKSTATUS | City file test status | char | 1 | 0 | CHAR | (N' ') | Yes | | AD_CHECKST | Allow NULL? |
| 40 | REGIOGROUP | Regional structure grouping | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | ADRREGGRP | REGIOGROUP | Allow NULL? |
| 41 | POST_CODE1 | City postal code | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | AD_PSTCD1 | Allow NULL? |
| 42 | POST_CODE2 | PO Box Postal Code | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | AD_PSTCD2 | Allow NULL? |
| 43 | POST_CODE3 | Company Postal Code (for Large Customers) | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | AD_PSTCD3 | Allow NULL? |
| 44 | PCODE1_EXT | (Not Supported)City Postal Code Extension, e.g. ZIP+4+2 Code | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | AD_PST1XT | Allow NULL? |
| 45 | PCODE2_EXT | (Not Supported) PO Box Postal Code Extension | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | AD_PST2XT | Allow NULL? |
| 46 | PCODE3_EXT | (Not Supported) Major Customer Postal Code Extension | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | AD_PST3XT | Allow NULL? |
| 47 | PO_BOX | PO Box | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | AD_POBX | Allow NULL? |
| 48 | DONT_USE_P | PO Box Address Undeliverable Flag | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TSAD12 | AD_NO_USEP | Allow NULL? |
| 49 | PO_BOX_NUM | Flag: PO Box Without Number | char | 1 | 0 | CHAR | (N' ') | Yes | | AD_POBXNUM | Allow NULL? |
| 50 | PO_BOX_LOC | PO Box city | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | AD_POBXLOC | Allow NULL? |
| 51 | CITY_CODE2 | City PO box code (City file) | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | ADRCITY | AD_CIT2NUM | Allow NULL? |
| 52 | PO_BOX_REG | Region for PO Box (Country, State, Province, ...) | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | T005S | AD_POBXREG | Allow NULL? |
| 53 | PO_BOX_CTY | PO box country | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | T005 | AD_POBXCTY | Allow NULL? |
| 54 | POSTALAREA | (Not Supported) Post Delivery District | nvarchar | 15 | 0 | CHAR | (N' ') | Yes | | AD_PSTLAR | Allow NULL? |
| 55 | TRANSPZONE | Transportation zone to or from which the goods are delivered | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | TZONE | LZONE | Allow NULL? |
| 56 | STREET | Street | nvarchar | 60 | 0 | CHAR | (N' ') | Yes | | AD_STREET | Allow NULL? |
| 57 | DONT_USE_S | Street Address Undeliverable Flag | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TSAD12 | AD_NO_USES | Allow NULL? |
| 58 | STREETCODE | Street Number for City/Street File | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | ADRSTREET | AD_STRNUM | Allow NULL? |
| 59 | STREETABBR | (Not Supported) Abbreviation of Street Name | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | ADRSTRTYPE | AD_STRABBR | Allow NULL? |
| 60 | HOUSE_NUM1 | House Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | AD_HSNM1 | Allow NULL? |
| 61 | HOUSE_NUM2 | House number supplement | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | AD_HSNM2 | Allow NULL? |
| 62 | HOUSE_NUM3 | (Not supported) House Number Range | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | AD_HSNM3 | Allow NULL? |
| 63 | STR_SUPPL1 | Street 2 | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | AD_STRSPP1 | Allow NULL? |
| 64 | STR_SUPPL2 | Street 3 | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | AD_STRSPP2 | Allow NULL? |
| 65 | STR_SUPPL3 | Street 4 | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | AD_STRSPP3 | Allow NULL? |
| 66 | LOCATION | Street 5 | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | AD_LCTN | Allow NULL? |
| 67 | BUILDING | Building (Number or Code) | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | AD_BLDNG | Allow NULL? |
| 68 | FLOOR | Floor in building | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | AD_FLOOR | Allow NULL? |
| 69 | ROOMNUMBER | Room or Appartment Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | AD_ROOMNUM | Allow NULL? |
| 70 | COUNTRY | Country Key | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | T005 | LAND1 | Allow NULL? |
| 71 | LANGU | Language Key | char | 1 | 0 | LANG | (N' ') | Yes | T002 | SPRAS | Allow NULL? |
| 72 | REGION | Region (State, Province, County) | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | T005S | REGIO | Allow NULL? |
| 73 | SORT1 | Search Term 1 | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | AD_SORT1UL | Allow NULL? |
| 74 | SORT2 | Search Term 2 | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | AD_SORT2UL | Allow NULL? |
| 75 | SORT_PHN | (Not Supported) Phonetic Search Sort Field | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | AD_SRTPHN | Allow NULL? |
| 76 | ADDRORIGIN | (Not Supported) Address Data Source (Key) | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TSAD6 | AD_ORIGINA | Allow NULL? |
| 77 | EXTENSION1 | Extension (only for data conversion) (e.g. data line) | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | AD_EXTENS1 | Allow NULL? |
| 78 | EXTENSION2 | Extension (only for data conversion) (e.g. telebox) | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | AD_EXTENS2 | Allow NULL? |
| 79 | TIME_ZONE | Address time zone | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | TTZZ | AD_TZONE | Allow NULL? |
| 80 | TAXJURCODE | Tax Jurisdiction | nvarchar | 15 | 0 | CHAR | (N' ') | Yes | | AD_TXJCD | Allow NULL? |
| 81 | ADDRESS_ID | (Not supported) Physical address ID | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | AD_ADDR_ID | Allow NULL? |
| 82 | REMARK | Address notes | nvarchar | 50 | 0 | CHAR | (N' ') | Yes | | AD_REMARK1 | Allow NULL? |
| 83 | LANGU_CREA | Address record creation original language | char | 1 | 0 | LANG | (N' ') | Yes | T002 | AD_LANGUCR | Allow NULL? |
| 84 | PO_BOX_LOBBY | PO Box Lobby | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | AD_PO_BOX_LBY | Allow NULL? |
| 85 | DELI_SERV_TYPE | Type of Delivery Service | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | ADDRC_DELI_SERV | AD_DELIVERY_SERVICE_TYPE | Allow NULL? |
| 86 | DELI_SERV_NUMBER | Number of Delivery Service | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | AD_DELIVERY_SERVICE_NUMBER | Allow NULL? |
| 87 | COUNTY_CODE | County code for county | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | ADRCOUNTY | AD_CNTYNUM | Allow NULL? |
| 88 | COUNTY | County | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | AD_COUNTY | Allow NULL? |
| 89 | TOWNSHIP_CODE | Township code for Township | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | ADRTOWNSHIP | AD_TWSHPNUM | Allow NULL? |
| 90 | TOWNSHIP | Township | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | AD_TOWNSHIP | Allow NULL? |
| 91 | TEL_NUMBER | First telephone no.: dialling code+number | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | AD_TLNMBR1 | Allow NULL? |
| 92 | TEL_EXTENS | First Telephone No.: Extension | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | AD_TLXTNS1 | Allow NULL? |
| 93 | FAX_NUMBER | First fax no.: dialling code+number | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | AD_FXNMBR1 | Allow NULL? |
| 94 | FAX_EXTENS | First fax no.: extension | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | AD_FXXTNS1 | Allow NULL? |
