| 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_FROM | IS-M/SD: Publishing Sales Order | nvarchar | 10 | 0 | CHAR | (N' ') | No | JKAK | AVNR | Allow NULL? |
| 3 | POSNR_UR_FROM | Sales Order Item | nvarchar | 6 | 0 | NUMC | (N'000000') | No | JKAP | APNR | Allow NULL? |
| 4 | CYCLENR_FROM | IS-M/SD: Billing Cycle Number | nvarchar | 3 | 0 | NUMC | (N'000') | No | JKACCOUNT | CYCLENR | Allow NULL? |
| 5 | TRANSFERTYPE | IS-M/SD: Liability Account Transfer Type | char | 1 | 0 | CHAR | (N' ') | No | TJK95 | TRANSFERTYPE | Allow NULL? |
| 6 | VBELN_TO | IS-M/SD: Recipient order | nvarchar | 10 | 0 | CHAR | (N' ') | No | * | VBELN_TO | Allow NULL? |
| 7 | POSNR_UR_TO | IS-M/SD: Original item number for recipient | nvarchar | 6 | 0 | NUMC | (N'000000') | No | * | POSNR_UR_TO | Allow NULL? |
| 8 | CYCLENR_TO | IS-M/SD: Billing Cycle Number for Recipient | nvarchar | 3 | 0 | NUMC | (N'000') | No | * | CYCLENR_TO | Allow NULL? |
| 9 | SAKNR | IS-M/SD: G/L account for extraordinary revenue | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | SAKNR_REV_EXTRAS | Allow NULL? |
| 10 | GPNR_RG_TF | IS-M/SD: Payer to Whom Transfer Takes Place | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | GPNR_RG_TF | Allow NULL? |
| 11 | TFBETR | IS-M/SD: Transfer amount | decimal | 13 | 2 | CURR | ((0)) | Yes | | TFBETR | |
| 12 | BELNR | Number of Contract Accts Rec. & Payable Doc. | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | * | OPBEL_KK | Allow NULL? |
| 13 | GJAHR | Fiscal Year | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | GJAHR | Allow NULL? |
| 14 | AWREF | Reference Document Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | AWREF | Allow NULL? |
| 15 | TRANSFERNR | IS-M/SD: Number of liability account transfer run | nvarchar | 10 | 0 | CHAR | (N' ') | No | | TRANSFERNR | Allow NULL? |
| 16 | ERFUSER | Created By | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | ERFUSER | Allow NULL? |
| 17 | ERFDATE | Created On | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | ERFDATE | Allow NULL? |
| 18 | ERFTIME | Time Created | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | ERFTIME | Allow NULL? |
| 19 | ERFPROG | Program Used to Create Object | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | * | ERFPROG | Allow NULL? |
| 20 | COPAOBJNR | Profitability Segment Number (CO-PA) | nvarchar | 10 | 0 | NUMC | (N'0000000000') | Yes | | RKEOBJNR | Allow NULL? |
