| 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 | * | MANDT | Allow NULL? |
| 2 | UNAME | Logon name of user | nvarchar | 12 | 0 | CHAR | (N' ') | No | | FBWE_UNAME | Allow NULL? |
| 3 | BUKRS | Company Code | nvarchar | 4 | 0 | CHAR | (N' ') | No | T001 | BUKRS | Allow NULL? |
| 4 | WEKON | Special G/L account for bills of exchange receivable | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | SKA1 | WEKON_FBWE | Allow NULL? |
| 5 | IDNTK | Worklist Key | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | IDENT_FAV | Allow NULL? |
| 6 | VONFKD | Days before System Date | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | MIND_FBWE | Allow NULL? |
| 7 | BISFKD | Days after system date | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | PLUSD_FBWE | Allow NULL? |
| 8 | ZWELS | Payment methods to be included | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | PYMOD_FBWE | Allow NULL? |
| 9 | BLAR1 | Document types which are to be considered | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | BLAR1_FBWE | Allow NULL? |
| 10 | GSBE1 | Business area | nvarchar | 50 | 0 | CHAR | (N' ') | Yes | | GSBE1_FBWE | Allow NULL? |
| 11 | REGI1 | | nvarchar | 30 | 0 | | (N' ') | Yes | | | Allow NULL? |
| 12 | SHKZ | Special G/L indicator used for selection | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | SHKZ_FBWE | Allow NULL? |
| 13 | BANKG | Bank group of b/exch. drawee | nvarchar | 15 | 0 | CHAR | (N' ') | Yes | | BANKG | Allow NULL? |
| 14 | FWAER | Foreign currency key for b/exchange in foreign currency | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | TCURC | FWAER_FBWE | Allow NULL? |
| 15 | TABST | Target tab page for transaction FBWE (Bill/Ex.Presentation) | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | TABST_FBWE | Allow NULL? |
| 16 | VERWE | Bill/exchange usage indicator for the b/exch.usage posting | char | 1 | 0 | CHAR | (N' ') | Yes | | VERWE_FBWE | Allow NULL? |
| 17 | HBKID | Presenting Bank | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | T012 | HBKID_FBWE | Allow NULL? |
| 18 | HKTID | Bank Account for Bill of Exchange Presentation | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | T012K | HKTID_FBWE | Allow NULL? |
| 19 | GROUPID | Batch input session name | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | ALLGMANA | Allow NULL? |
| 20 | SAMBU | Collective posting: Bill/exchange for discount or collection | char | 1 | 0 | CHAR | (N' ') | Yes | | SAMBU_FBWE | Allow NULL? |
| 21 | BLART | Document Type | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | T003 | BLART | Allow NULL? |
| 22 | DIRBU | Direct posting via Call Transaction | char | 1 | 0 | CHAR | (N' ') | Yes | | DIRBU | Allow NULL? |
| 23 | VARIA | Layout | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | SLIS_VARI | Allow NULL? |
| 24 | WEDRU | Generate print dataset for printing bills of exchange | char | 1 | 0 | CHAR | (N' ') | Yes | | WEDRU_FBWE | Allow NULL? |
| 25 | LAUFI | Additional Identification | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | | LAUFI | Allow NULL? |
| 26 | DTAFI | Generate DME file | char | 1 | 0 | CHAR | (N' ') | Yes | | DTAFI_FBWE | Allow NULL? |
| 27 | DTATY | DME file type | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | DTATY_FBWE | Allow NULL? |
| 28 | LAUFI1 | Additional Identification | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | | LAUFI | Allow NULL? |
| 29 | XAUTO | Automatically record input parameters | char | 1 | 0 | CHAR | (N' ') | Yes | | XAUTO_FBWE | Allow NULL? |
| 30 | BILD1 | Complete Name (URL) of Graphic on Hard Disk | nvarchar | 60 | 0 | CHAR | (N' ') | Yes | | BILD_FBWE | Allow NULL? |
| 31 | BILD2 | Complete Name (URL) of Graphic on Hard Disk | nvarchar | 60 | 0 | CHAR | (N' ') | Yes | | BILD_FBWE | Allow NULL? |
| 32 | FORMT | Form Preparation Type in Bill of Exchange Process | char | 1 | 0 | CHAR | (N' ') | Yes | | BOE_FORMTYPE | Allow NULL? |
| 33 | SAPSC | Create Form for Bill of Exchange Presentation | char | 1 | 0 | CHAR | (N' ') | Yes | | SAPSC | Allow NULL? |
