| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | VBELN | IS-M/SD: Publishing Sales Order | nvarchar | 10 | 0 | | | | Allow NULL? |
| 3 | POSNR_UR | Original Item in Publishing Sales Order | nvarchar | 6 | 0 | | | | Allow NULL? |
| 4 | CYCLENR | IS-M/SD: Billing Cycle Number | nvarchar | 3 | 0 | | | | Allow NULL? |
| 5 | ACC_ACTIVITY | IS-M/SD: Posting Transaction for Revenue Accrual | nvarchar | 2 | 0 | | | | Allow NULL? |
| 6 | SAKNR_FROM | IS-M/SD: G/L Account From (Revenue Accrual) | nvarchar | 10 | 0 | | | | Allow NULL? |
| 7 | SAKNR_TO | IS-M/SD: To G/L Account (Revenue Accrual) | nvarchar | 10 | 0 | | | | Allow NULL? |
| 8 | TRANSFERNR_OLD | IS-M/SD: Number of liability account transfer run | nvarchar | 10 | 0 | | | | Allow NULL? |
| 9 | TRANSFERNR_NEW | IS-M/SD: Number of liability account transfer run | nvarchar | 10 | 0 | | | | Allow NULL? |
| 10 | BETRAG | IS-M/SD: Cumulated Amount | decimal | 13 | 2 | | | | |
| 11 | WAERK | SD Document Currency | nvarchar | 5 | 0 | | | | Allow NULL? |
| 12 | TRANSFERTYPE | IS-M/SD: Liability Account Transfer Type | char | 1 | 0 | | | | Allow NULL? |