| 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 | BUKRS | Company Code | nvarchar | 4 | 0 | CHAR | (N' ') | No | T001 | BUKRS | Allow NULL? |
| 3 | BELNR | Accounting Document Number | nvarchar | 10 | 0 | CHAR | (N' ') | No | | BELNR_D | Allow NULL? |
| 4 | GJAHR | Fiscal Year | nvarchar | 4 | 0 | NUMC | (N'0000') | No | | GJAHR | Allow NULL? |
| 5 | BUZEI | Number of Line Item Within Accounting Document | nvarchar | 3 | 0 | NUMC | (N'000') | No | | BUZEI | Allow NULL? |
| 6 | WELGF | Life of a bill of exchange | decimal | 3 | 0 | DEC | ((0)) | Yes | | WELGF | |
| 7 | WSTKZ | Bill of exchange tax code | char | 1 | 0 | CHAR | (N' ') | Yes | T046 | WSTKZ | Allow NULL? |
| 8 | WSTHW | Bill of exchange tax in local currency | decimal | 13 | 2 | CURR | ((0)) | Yes | | WSTHW_F05A | |
| 9 | WSTFW | Bill of exchange tax in foreign currency | decimal | 13 | 2 | CURR | ((0)) | Yes | | WSTFW_F05A | |
| 10 | WINHW | Charge for bill of exchange collection in local currency | decimal | 13 | 2 | CURR | ((0)) | Yes | | WINHW | |
| 11 | WINFW | Charge for bill of exchange collection in document currency | decimal | 13 | 2 | CURR | ((0)) | Yes | | WINFW | |
| 12 | WMWKZ | Tax code for bill of exchange charges | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | WMWKZ | Allow NULL? |
| 13 | WDATE | Bill of Exchange Issue Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | WDATE | Allow NULL? |
| 14 | WVERD | Date of bill of exchange usage | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | WVERD | Allow NULL? |
| 15 | WEVWV | Planned usage of the bill of exchange | char | 1 | 0 | CHAR | (N' ') | Yes | | WEVWV | Allow NULL? |
| 16 | WBANK | Bank address where a bill of exchange can be paid (domestic) | nvarchar | 60 | 0 | CHAR | (N' ') | Yes | | WBANK | Allow NULL? |
| 17 | WNAME | Name of bill of exchange drawer | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | WNAME | Allow NULL? |
| 18 | WLZBP | State central bank location | nvarchar | 60 | 0 | CHAR | (N' ') | Yes | | WLZBP | Allow NULL? |
| 19 | WORT1 | City of bill of exchange drawer | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | WORT1 | Allow NULL? |
| 20 | WBZOG | Bill of exchange drawee | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | WBZOG | Allow NULL? |
| 21 | WORT2 | City of bill of exchange drawee | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | WORT2 | Allow NULL? |
| 22 | DISKT | Discount Days | decimal | 3 | 0 | DEC | ((0)) | Yes | | DISKT | |
| 23 | DISKP | Percentage Rate for Bill of Exch. Disc. with Passed-On Chrgs | decimal | 7 | 5 | DEC | ((0)) | Yes | | DISKP | |
| 24 | XAKTZ | Indicator: Bill of exchange was accepted | char | 1 | 0 | CHAR | (N' ') | Yes | | XAKTZ | Allow NULL? |
| 25 | REGIO | Region (State, Province, County) | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | T005S | REGIO | Allow NULL? |
| 26 | WSTAT | Bill of Exchange Status | char | 1 | 0 | CHAR | (N' ') | Yes | T031S | WSTAT | Allow NULL? |
| 27 | WGBKZ | Indicator for the bill of exchange protest | char | 1 | 0 | CHAR | (N' ') | Yes | | WGBKZ | Allow NULL? |
| 28 | XSIWE | Indicator: Bill on demand | char | 1 | 0 | CHAR | (N' ') | Yes | | XSIWE | Allow NULL? |
| 29 | BUPLA | Business Place | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | BUPLA | Allow NULL? |
| 30 | SECCO | Section Code | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | SECCO | Allow NULL? |
| 31 | PORTF | Bill of Exchange Portfolio | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | T045P | PORTFO | Allow NULL? |
| 32 | BOENO | Check Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | BOENUM | Allow NULL? |
| 33 | BANK | Bank Keys | nvarchar | 15 | 0 | CHAR | (N' ') | Yes | | BANKK | Allow NULL? |
| 34 | ACCOU | Bank account number | nvarchar | 18 | 0 | CHAR | (N' ') | Yes | | BANKN | Allow NULL? |
| 35 | VENDR | Vendor Account Number | nvarchar | 16 | 0 | CHAR | (N' ') | Yes | | LIF16 | Allow NULL? |
