| 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 | VBELN | IS-M/SD: Publishing Sales Order | nvarchar | 10 | 0 | CHAR | (N' ') | No | JKAK | AVNR | Allow NULL? |
| 3 | POSNR_UR | Original Item in Publishing Sales Order | nvarchar | 6 | 0 | NUMC | (N'000000') | No | JKAP | APNR_UR | Allow NULL? |
| 4 | CYCLENR | IS-M/SD: Billing Cycle Number | nvarchar | 3 | 0 | NUMC | (N'000') | No | | CYCLENR | Allow NULL? |
| 5 | ZBETR | IS-M/SD: Payment Amount in Local Currency | decimal | 13 | 2 | CURR | ((0)) | Yes | | BETRZ | |
| 6 | AMOBETR | IS-M/SD: Amortization Amount | decimal | 13 | 2 | CURR | ((0)) | Yes | | AMOBETR | |
| 7 | VAUSGB_F | IS-M/SD: First Issue Delivered in Billing Cycle | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | JDTVAUSGB | VAUSGB_F | Allow NULL? |
| 8 | VAUSGB_L | IS-M/SD: Last Issue Delivered in Billing Cycle | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | JDTVAUSGB | VAUSGB_L | Allow NULL? |
| 9 | VAUSGB_LBI | IS-M/SD: Last issue delivered before billing doc.transfer | nvarchar | 10 | 0 | CHAR | (N' ') | No | JDTVAUSGB | VAUSGB_LBI | Allow NULL? |
| 10 | XCYCLE_FIN | IS-M/SD: Amortization Complete for Liability Account | char | 1 | 0 | CHAR | (N' ') | Yes | | XCYCLE_FIN | Allow NULL? |
| 11 | EXPDATE | IS-M/SD: Expiration Date of Subscription | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | EXP_DATE | Allow NULL? |
| 12 | DELIV_BILL | Number of Deliveries Billed in Billing Cycle | nvarchar | 3 | 0 | NUMC | (N'000') | No | | DELIV_BILL | Allow NULL? |
| 13 | DELIV_AMO | Number of Amortized Deliveries in Billing Cycle | nvarchar | 3 | 0 | NUMC | (N'000') | No | | DELIV_AMO | Allow NULL? |
| 14 | TFBETR | IS-M/SD: Transfer amount | decimal | 13 | 2 | CURR | ((0)) | No | | TFBETR | |
| 15 | WAERK | SD Document Currency | nvarchar | 5 | 0 | CUKY | (N' ') | No | TCURC | WAERK | Allow NULL? |
| 16 | KURST | Exchange Rate Type | nvarchar | 4 | 0 | CHAR | (N' ') | No | TCURV | KURST | Allow NULL? |
| 17 | TRANS_DATE | Translation Date | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | WWERT_D | Allow NULL? |
| 18 | UKURS | Exchange Rate | decimal | 9 | 5 | DEC | ((0)) | No | | UKURS_CURR | |
| 19 | XINVOICE | IS-M/SD: Billing and Transfer Performed for Cycle | char | 1 | 0 | CHAR | (N' ') | No | | XINVOICE | Allow NULL? |
| 20 | XGOLIVE | IS-M/SD: Cycle from Data Transfer | char | 1 | 0 | CHAR | (N' ') | No | | XGOLIVE | Allow NULL? |
| 21 | XFKRUECK | IS-M: Retroactive Billing of Period Already Billed | char | 1 | 0 | CHAR | (N' ') | No | | XFKRUECK | Allow NULL? |
| 22 | POSNR_NP_LAST | Standard Item Last Amortized Within Original Item | nvarchar | 6 | 0 | NUMC | (N'000000') | No | * | POSNR_NP_LAST_AMO | Allow NULL? |
| 23 | XADVANCE_BILL | IS-M/SD: Perform Billing in Advance | char | 1 | 0 | CHAR | (N' ') | No | | XADVANCE_BILL | Allow NULL? |
| 24 | XAMO_ARCHIVED | IS-M/SD: Amortization Data on Cycle Activated | char | 1 | 0 | CHAR | (N' ') | Yes | | XAMO_ARCHIVED | Allow NULL? |
| 25 | DIFFBETR | IS-M/SD: Diff. Amount Due to Retroactive Billing/Recalc. | decimal | 13 | 2 | CURR | ((0)) | Yes | | ISM_DIFFBETR | |
