| 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 | SETTLE_POST_YEAR | Posting Year of Settlement Document | nvarchar | 4 | 0 | NUMC | (N'0000') | No | | CACSDOCYEARSETTLE | Allow NULL? |
| 3 | SETTLE_DOC_ID | Settlement Document Number | nvarchar | 10 | 0 | CHAR | (N' ') | No | | CACSDOCIDSETTLE | Allow NULL? |
| 4 | ITEM | Number of Items Transferred | int | 10 | 0 | INT4 | ((0)) | No | | CACSCOUNTPOS | Allow NULL? |
| 5 | CCODE | Company Code | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | BUKRS | Allow NULL? |
| 6 | PMNT_BLOCK | Payment Block Key | char | 1 | 0 | CHAR | (N' ') | Yes | * | DZLSPR | Allow NULL? |
| 7 | KONTO | Payment Rec. in Collections/Disbursements (Insurance Object) | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | CACSPAYEEISCD | Allow NULL? |
| 8 | AKTYP | Activity Category | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | BU_AKTYP | Allow NULL? |
| 9 | BLTYP | Document Type for Connection with FS-CD | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | CACS_FSCD_BLTYP | Allow NULL? |
| 10 | BLART | Document Type | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | CACS_BLART | Allow NULL? |
| 11 | HVORG | Main Transaction for Document Item | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | CACS_HVORG_KK | Allow NULL? |
| 12 | TVORG | Subtransaction for Document Item | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | CACS_TVORG_KK | Allow NULL? |
| 13 | GPART | Business Partner to Receive Commission | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | CACS_GPART_INV | Allow NULL? |
| 14 | PARTNER | Business Partner to Receive Commission | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | CACS_GPART_INV | Allow NULL? |
| 15 | EMGPA | Business Partner to Receive Commission | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | CACS_GPART_INV | Allow NULL? |
| 16 | BLINE_DATE | Baseline Date for Due Date Calculation | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | DZFBDT | Allow NULL? |
| 17 | TAX_CODE | Tax on sales/purchases code | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | MWSKZ | Allow NULL? |
| 18 | TAX_DIFF | Indicator for Tax Difference | char | 1 | 0 | CHAR | (N' ') | Yes | | CACSTAXDIFFERENCE | Allow NULL? |
| 19 | PSNGL | Indicator for One-Time Payment for Connection to FS-CD | char | 1 | 0 | CHAR | (N' ') | Yes | | CACS_FSCD_PSNGL | Allow NULL? |
| 20 | PAY_REASON_DAYS | Validity Days of Object for Connection with FS-CD | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | CACS_FSCD_PYDYS | Allow NULL? |
| 21 | DUE_CONAMNT | Amount in document currency | decimal | 13 | 2 | CURR | ((0)) | Yes | | WRBTR | |
| 22 | PMTFR | Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | DATUM | Allow NULL? |
| 23 | PMTTO | Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | DATUM | Allow NULL? |
| 24 | FAEDN | Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | DATUM | Allow NULL? |
| 25 | COMPRS_UUID | Compression Reference UUID for Settlement | varbinary | 16 | 0 | RAW | | No | | CACSCMPREFUUID | |
