| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | CLIENT | Client | nvarchar | 3 | 0 | CLNT | (N'000') | No | * | MANDT | Allow NULL? |
| 2 | RECON_KEY | Revenue Reconciliation Key | nvarchar | 10 | 0 | NUMC | (N'0000000000') | No | | FARR_RECON_KEY | Allow NULL? |
| 3 | POB_ID | Performance Obligation ID | nvarchar | 16 | 0 | NUMC | (N'0000000000000000') | No | | FARR_POB_ID | Allow NULL? |
| 4 | CONDITION_TYPE | Condition type | nvarchar | 4 | 0 | CHAR | (N' ') | No | * | KSCHA | Allow NULL? |
| 5 | DEFERRAL_CAT | Deferral Category | nvarchar | 2 | 0 | CHAR | (N' ') | No | | FARR_DEFERRAL_CATEGORY | Allow NULL? |
| 6 | CONTRACT_ID | Revenue Recognition Contract ID | nvarchar | 14 | 0 | NUMC | (N'00000000000000') | Yes | | FARR_CONTRACT_ID | Allow NULL? |
| 7 | EVENT_TYPE | Fulfillment Event Type | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | FARR_EVENT_TYPE | Allow NULL? |
| 8 | FULFILL_TYPE | Fulfillment Type | char | 1 | 0 | CHAR | (N' ') | Yes | | FARR_FULFILL_TYPE | Allow NULL? |
| 9 | COMPANY_CODE | Company Code | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | BUKRS | Allow NULL? |
| 10 | ACCT_PRINCIPLE | Accounting Principle | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | ACCOUNTING_PRINCIPLE | Allow NULL? |
| 11 | AMOUNT_CURK | Currency Key | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | WAERS | Allow NULL? |
| 12 | QUANTITY_UNIT | Quantity Unit | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | * | FARR_QUANTITY_UNIT | Allow NULL? |
| 13 | SOURCE_ACCT | Source Account Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | FARR_SOURCE_ACCT | Allow NULL? |
| 14 | TARGET_ACCT | Target Account Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | FARR_TARGET_ACCT | Allow NULL? |
| 15 | STATISTIC | Condition is used for statistics | char | 1 | 0 | CHAR | (N' ') | Yes | | KSTAT | Allow NULL? |
| 16 | CATEGORY | Condition is Pricing or Costing | char | 1 | 0 | CHAR | (N' ') | Yes | | FARR_CONDITION_CATEGORY | Allow NULL? |
| 17 | SPEC_INDICATOR | Deferral Item Special Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | FARR_DEFITEM_SPECIAL_INDICATOR | Allow NULL? |
| 18 | IS_PS | Entry from PS (Project System) | char | 1 | 0 | CHAR | (N' ') | Yes | | FARR_IS_PS | Allow NULL? |
| 19 | DOC_AMT_ORG | Amount of Revenue Accounting Item | decimal | 23 | 2 | CURR | ((0)) | Yes | | FARR_AMOUNT | |
| 20 | DOC_AMT_DELTA | Amount of Revenue Accounting Item | decimal | 23 | 2 | CURR | ((0)) | Yes | | FARR_AMOUNT | |
| 21 | DOC_QTY_DELTA | Quantity | decimal | 18 | 6 | QUAN | ((0)) | Yes | | FARR_QUANTITY | |
| 22 | DOC_AMT_CUMULATE | Amount of Revenue Accounting Item | decimal | 23 | 2 | CURR | ((0)) | Yes | | FARR_AMOUNT | |
| 23 | DOC_QTY_CUMULATE | Quantity | decimal | 18 | 6 | QUAN | ((0)) | Yes | | FARR_QUANTITY | |
| 24 | REV_AMT_DELTA | Amount of Revenue Accounting Item | decimal | 23 | 2 | CURR | ((0)) | Yes | | FARR_AMOUNT | |
| 25 | REV_QTY_DELTA | Quantity | decimal | 18 | 6 | QUAN | ((0)) | Yes | | FARR_QUANTITY | |
| 26 | REV_QTY_DELTA_NM | Quantity Nominator | decimal | 25 | 0 | DEC | ((0)) | Yes | | FARR_QUANTITY_NOMINATOR | |
| 27 | REV_QTY_DELTA_DN | Quantity Deominator | decimal | 25 | 0 | DEC | ((0)) | Yes | | FARR_QUANTITY_DENOMINATOR | |
| 28 | REV_AMT_POSTED | Amount of Revenue Accounting Item | decimal | 23 | 2 | CURR | ((0)) | Yes | | FARR_AMOUNT | |
| 29 | REV_QTY_POSTED | Quantity | decimal | 18 | 6 | QUAN | ((0)) | Yes | | FARR_QUANTITY | |
| 30 | REV_QTY_PST_NM | Quantity Nominator | decimal | 25 | 0 | DEC | ((0)) | Yes | | FARR_QUANTITY_NOMINATOR | |
| 31 | REV_QTY_PST_DN | Quantity Deominator | decimal | 25 | 0 | DEC | ((0)) | Yes | | FARR_QUANTITY_DENOMINATOR | |
| 32 | INV_AMT_DELTA | Amount of Revenue Accounting Item | decimal | 23 | 2 | CURR | ((0)) | Yes | | FARR_AMOUNT | |
| 33 | INV_QTY_DELTA | Quantity | decimal | 18 | 6 | QUAN | ((0)) | Yes | | FARR_QUANTITY | |
| 34 | INV_AMT_TOTAL | Amount of Revenue Accounting Item | decimal | 23 | 2 | CURR | ((0)) | Yes | | FARR_AMOUNT | |
| 35 | INV_QTY_TOTAL | Quantity | decimal | 18 | 6 | QUAN | ((0)) | Yes | | FARR_QUANTITY | |
| 36 | PRO_AMT_CUMULATE | Amount of Revenue Accounting Item | decimal | 23 | 2 | CURR | ((0)) | Yes | | FARR_AMOUNT | |
| 37 | PRO_QTY_CUMULATE | Quantity | decimal | 18 | 6 | QUAN | ((0)) | Yes | | FARR_QUANTITY | |
| 38 | PRO_CROSS_PERIOD | Deferral Item Cross-Periods | char | 1 | 0 | CHAR | (N' ') | Yes | | FARR_CROSS_PERIOD | Allow NULL? |
| 39 | PRO_SPLIT | Deferral Item Split Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | FARR_DEFITEM_SPLIT | Allow NULL? |
| 40 | LATEST_DEFITEM | Indicates that the entry is the latest one | char | 1 | 0 | CHAR | (N' ') | Yes | | FARR_LATEST_ENTRY | Allow NULL? |
| 41 | TIMESTAMP | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | DEC | ((0)) | Yes | | TIMESTAMP | |
