| 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 | COKEY | Correspondence key | nvarchar | 36 | 0 | CHAR | (N' ') | No | | COKEY_KK | Allow NULL? |
| 3 | CH_POS | Budget Billing Items After Change | nvarchar | 3 | 0 | CHAR | (N' ') | No | | CH_POS | Allow NULL? |
| 4 | LFDNR | Sequence Number | nvarchar | 3 | 0 | CHAR | (N' ') | No | | LFDNR | Allow NULL? |
| 5 | OPBEL | Number of Contract Accts Rec. & Payable Doc. | nvarchar | 12 | 0 | CHAR | (N' ') | No | * | OPBEL_KK | Allow NULL? |
| 6 | VTREF | Reference Specifications from Contract | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | VTREF_KK | Allow NULL? |
| 7 | LOGNO | Line Number of Budget Billing Plan | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | LOGNO | Allow NULL? |
| 8 | TVORG | Subtransaction for Document Item | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | TVORG_KK | Allow NULL? |
| 9 | FAEDN | Due date for net payment | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | FAEDN_KK | Allow NULL? |
| 10 | FAEDS | Due Date for Cash Discount | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | FAEDS_KK | Allow NULL? |
| 11 | SOLLDAT | Print date for BB requests or generation of partial bill | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | ABSDAT | Allow NULL? |
| 12 | VORAUSZAHL | Budget Billing Plan Item Is Advance Payment | char | 1 | 0 | CHAR | (N' ') | Yes | | VORAUSZAHL | Allow NULL? |
| 13 | XMARK | Indicator: Line selected | char | 1 | 0 | CHAR | (N' ') | Yes | | XMARK | Allow NULL? |
| 14 | AUGST | Clearing status | char | 1 | 0 | CHAR | (N' ') | Yes | | AUGST_KK | Allow NULL? |
| 15 | ABWBL | Number of the substitute FI-CA document | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | ABWBL_KK | Allow NULL? |
| 16 | ABWTP | Category of substitute document in FI-CA | char | 1 | 0 | CHAR | (N' ') | Yes | | ABWTP_KK | Allow NULL? |
| 17 | ABWKT | Alternative contract account for collective bills | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | * | ABWVK_KK | Allow NULL? |
| 18 | MWSKZ | Tax on sales/purchases code | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | MWSKZ | Allow NULL? |
| 19 | GRBBP | Budget Billing: Grouping Key for Tax Determination Code | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | GRBBP | Allow NULL? |
| 20 | OPTXT | Item text | nvarchar | 50 | 0 | CHAR | (N' ') | Yes | | OPTXT_KK | Allow NULL? |
| 21 | VERKZ | Item Can Only Be Cleared | char | 1 | 0 | CHAR | (N' ') | Yes | | VERKZ_KK | Allow NULL? |
| 22 | STUDT | Deferral to | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | STUDT_KK | Allow NULL? |
| 23 | SKTPZ | Cash discount rate | decimal | 5 | 3 | DEC | ((0)) | Yes | | SKTPZ_KK | |
| 24 | XMANL | Exclude Item from Dunning Run | char | 1 | 0 | CHAR | (N' ') | Yes | | XMANL_KK | Allow NULL? |
| 25 | BETRH | Amount In Local Currency With +/- Signs | decimal | 13 | 2 | CURR | ((0)) | Yes | | BETRH_KK | |
| 26 | BETRW | Amount in Transaction Currency with +/- Sign | decimal | 13 | 2 | CURR | ((0)) | Yes | | BETRW_KK | |
| 27 | BETR2 | Amount in second parallel currency with +/- sign | decimal | 13 | 2 | CURR | ((0)) | Yes | | BETR2_KK | |
| 28 | BETR3 | Amount in third parallel currency with +/- sign | decimal | 13 | 2 | CURR | ((0)) | Yes | | BETR3_KK | |
| 29 | SKFBT | Amount eligible for cash discount in document currency | decimal | 13 | 2 | CURR | ((0)) | Yes | | SKFBT_KK | |
| 30 | SBETH | Tax Amount in Local Currency With +/- Sign | decimal | 13 | 2 | CURR | ((0)) | Yes | | SBETH_KK | |
| 31 | SBETW | Tax Amount in Transaction Currency with +/- Sign | decimal | 13 | 2 | CURR | ((0)) | Yes | | SBETW_KK | |
| 32 | SBET2 | Tax amount in second parallel currency | decimal | 13 | 2 | CURR | ((0)) | Yes | | SBET2_KK | |
| 33 | SBET3 | Tax amount in third parallel currency | decimal | 13 | 2 | CURR | ((0)) | Yes | | SBET3_KK | |
| 34 | PYMET | Payment Method | char | 1 | 0 | CHAR | (N' ') | Yes | * | PYMET_KK | Allow NULL? |
| 35 | PERSL | Key for Period Assignment | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | PERSL_KK | Allow NULL? |
| 36 | XAESP | Printing - No Changes Possible | char | 1 | 0 | CHAR | (N' ') | Yes | | XAESP_KK | Allow NULL? |
| 37 | AUGDT | Clearing date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | AUGDT_KK | Allow NULL? |
| 38 | AUGBL | Clearing Document or Printed Document | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | AUGBL_KK | Allow NULL? |
| 39 | AUGBD | Clearing document posting date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | AUGBD_KK | Allow NULL? |
| 40 | AUGRD | Clearing Reason | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | AUGRD_KK | Allow NULL? |
| 41 | AUGWA | Clearing currency | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | AUGWA_KK | Allow NULL? |
| 42 | AUGBT | Clearing amount in clearing currency | decimal | 13 | 2 | CURR | ((0)) | Yes | | AUGBT_KK | |
| 43 | AUGBS | Tax amount in clearing currency | decimal | 13 | 2 | CURR | ((0)) | Yes | | AUGBS_KK | |
| 44 | AUGSK | Cash Discount Granted/Surcharge Levied in Clearing Currency | decimal | 13 | 2 | CURR | ((0)) | Yes | | AUGSK_KK | |
| 45 | AUGVD | Value date for clearing | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | AUGVD_KK | Allow NULL? |
| 46 | AUGOB | Item Canceled | char | 1 | 0 | CHAR | (N' ') | Yes | | AUGOB_KK | Allow NULL? |
| 47 | MAHNV | Dunning Procedure | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | MAHNV_KK | Allow NULL? |
| 48 | MANSP | Dunning Lock Reason | char | 1 | 0 | CHAR | (N' ') | Yes | * | MANSP_KK | Allow NULL? |
| 49 | ABRZU | Lower Limit of Settlement Period | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | ABRZU_KK | Allow NULL? |
| 50 | ABRZO | Upper Limit of the Billing Period | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | ABRZO_KK | Allow NULL? |
| 51 | AUGRS | Clearing restriction | char | 1 | 0 | CHAR | (N' ') | Yes | | AUGRS_KK | Allow NULL? |
| 52 | EMBVT | Bank Details ID of Payee | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | EMBVT_KK | Allow NULL? |
| 53 | IKEY | Interest Key | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | IKEY_KK | Allow NULL? |
| 54 | ERNAM | Name of Person who Created the Object | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | ERNAM | Allow NULL? |
| 55 | ERDAT | Date on Which Record Was Created | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | ERDAT | Allow NULL? |
