| 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 | LOGSYS | Logical system | nvarchar | 10 | 0 | CHAR | (N' ') | No | * | LOGSYS | Allow NULL? |
| 3 | KUNNR | Customer Number | nvarchar | 10 | 0 | CHAR | (N' ') | No | KNA1 | KUNNR | Allow NULL? |
| 4 | KKBER | Credit control area | nvarchar | 4 | 0 | CHAR | (N' ') | No | T014 | KKBER | Allow NULL? |
| 5 | REGUL | FI checks only against current payer | char | 1 | 0 | CHAR | (N' ') | No | | REGUL_CM | Allow NULL? |
| 6 | TMSTMP | Time at which data was created (date and time) | nvarchar | 14 | 0 | CHAR | (N' ') | Yes | | TMSTMP | Allow NULL? |
| 7 | SFAEL | A/R Summary: Open Items Total | decimal | 15 | 2 | CURR | ((0)) | Yes | | CV_SFAEL | |
| 8 | WAERS | A/R Summary: Currency Key (Total Open Items) | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | TCURC | CV_WAERS_OP | Allow NULL? |
| 9 | BUKRSM | A/R Summary: Company Code (Highest Dunning Level) | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | CV_BUKRS | Allow NULL? |
| 10 | KUNNRM | A/R Summary: Customer Number (Highest Dunning Level) | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | CV_KUNNR | Allow NULL? |
| 11 | MABER | A/R Summary: Dunning Area (Highest Dunning Level) | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | CV_MABER | Allow NULL? |
| 12 | MAHNS | A/R Summary: Dunning Level (Highest Dunning Level) | char | 1 | 0 | NUMC | (N'0') | Yes | | CV_MAHNS | Allow NULL? |
| 13 | BELNR | A/R Summary: Document Number of Oldest Open Item | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | CV_BELNR | Allow NULL? |
| 14 | BUKRSOOI | A/R Summary: Company Code (Oldest Open Item) | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | CV_BUKRS_OOI | Allow NULL? |
| 15 | FAEDT | A/R Summary: Net Due Date (Oldest Open Item) | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | CV_FAEDT | Allow NULL? |
| 16 | GJAHR | A/R Summary: Fiscal Year (Oldest Open Item) | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | CV_GJAHR | Allow NULL? |
| 17 | INFAE | A/R Summary: Inverted Net Due Date (Oldest Open Item) | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | | CV_INFAE | Allow NULL? |
| 18 | KUNNROOI | A/R Summary: Customer Number (Oldest Open Item) | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | CV_KUNNR_OOI | Allow NULL? |
| 19 | VERZN | A/R Summary: Days in Arrears after Net Due Date (Old. OI) | decimal | 5 | 0 | DEC | ((0)) | Yes | | CV_VERZN | |
| 20 | WAERSOOI | A/R Summary: Currency Key (Oldest Open Item) | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | CV_WAERS_OOI | Allow NULL? |
| 21 | WRBTR | A/R Summary: Amount in Document Currency | decimal | 13 | 2 | CURR | ((0)) | Yes | | CV_WRBTR | |
| 22 | KLIMK | A/R Summary: Customer Credit Limit | decimal | 15 | 2 | CURR | ((0)) | Yes | | CV_KLIMK | |
| 23 | KNKLI | A/R Summary: Credit Account | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | CV_KNKLI | Allow NULL? |
| 24 | SKFOR | A/R Summary: Total Receivables | decimal | 15 | 2 | CURR | ((0)) | Yes | | CV_SKFOR | |
| 25 | SSOBL | A/R Summary: Special Debts | decimal | 15 | 2 | CURR | ((0)) | Yes | | CV_SSOBL | |
| 26 | WAERS_KNKK | A/R Summary: Currency Key (Control Area) | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | TCURC | CV_WAERS_MD | Allow NULL? |
| 27 | CTLPC | A/R Summary: Risk Category | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | * | CV_CTLPC | Allow NULL? |
| 28 | CRBLB | A/R Summary: Block | char | 1 | 0 | CHAR | (N' ') | Yes | | CV_CRBLB | Allow NULL? |
| 29 | NXTRV | A/R Summary: Date of Next Check | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | CV_NXTRV | Allow NULL? |
| 30 | ABSBT | Total Secured Receivables | decimal | 15 | 2 | CURR | ((0)) | Yes | | ABSBT_SUM | |
