/PRA/ND_TAXSTG - Tax 2.0 - NDTax Transactions Staging
Tax 2.0 - NDTax Transactions Staging information is stored in SAP table /PRA/ND_TAXSTG.
It is part of development package /PRA/TAX_ND in software component IS-OIL-PRA. This development package consists of objects that can be grouped under "Tax Reporting - North Dakota".
It is part of development package /PRA/TAX_ND in software component IS-OIL-PRA. This development package consists of objects that can be grouped under "Tax Reporting - North Dakota".
Fields for table /PRA/ND_TAXSTG
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| MANDT | Client | X | MANDT | CLNT | 6 | |
| .INCLUDE | /PRA/S_ND_TAXTXN_KEY | X | /PRA/S_ND_TAXTXN_KEY | 0 | ||
| .INCLUDE | /PRA/S_ND_TAXREV_KEY | X | /PRA/S_ND_TAXREV_KEY | 0 | ||
| BUKRS | Company Code | X | BUKRS | CHAR | 8 | OIU_CM_COMPC |
| SALES_DT | Sales Date / Month | X | OIU_SALE_DT | DATS | 16 | |
| PDCD | Full three char. product code (Major and Detail Products) | X | OIU_FULL_PD_CD | CHAR | 6 | OIUX3_PDCD |
| WL_NO | Well ID number | X | OIU_WL_NO | CHAR | 30 | OIU_PR_WELL |
| WC_NO | Well Completion Number | X | OIU_WC_NO | CHAR | 10 | OIU_PR_WC |
| MP_NO | Measurement point number | X | OIU_MP_NO | CHAR | 40 | OIU_PR_MP |
| VNAME | Joint venture | X | JV_NAME | CHAR | 12 | OIU_DO_JV |
| DOI_NO | Division of interest (DOI) | X | OIU_DOI_NO | CHAR | 10 | OIU_DO_DI |
| DN_NO | Delivery network number | X | OIU_DN_NO | CHAR | 40 | OIU_PR_DN |
| CT_NO | Contract Number | X | OIU_CT_NO | CHAR | 20 | OIU_RV_CT |
| VL_TYPE_CD | Volume type code | X | OIU_VT_CD | CHAR | 4 | OIU_PR_VLTYP |
| TAX_CLS | Tax Class | X | OIU_TAX_CLS | CHAR | 8 | OIU_CM_TAXCLS |
| REV_BOOK_ADJ_IND | Reversal/Booking/Adjustment | X | /PRA/ND_REV_BOOKING_ADJ_IND | CHAR | 2 | |
| .INCLUDE | /PRA/S_ND_TAXTXN_NONKEY | /PRA/S_ND_TAXTXN_NONKEY | 0 | |||
| PROD_PURC_IND | Producer or Purchaser | OIUX3_PRODUCER_PURCHASER_IND | CHAR | 2 | ||
| UNIT_VNAME | Joint venture | JV_NAME | CHAR | 12 | OIU_DO_JV | |
| PAY_FL | Tax Severance Tax Calculation Payment Obligations Types | OIU_SEVT_PAY_FL | CHAR | 2 | ||
| RPT_FL | State Severance Tax Reporting Indicators | OIU_SEVT_RPT_FL | CHAR | 2 | ||
| UOM | Measurement unit | OIU_MEAS_U | UNIT | 6 | T006 | |
| .INCLUDE | /PRA/S_ND_PRDT_NUMFIELDS | /PRA/S_ND_PRDT_NUMFIELDS | 0 | |||
| BRL_OIL_PUR_SLD | Tax 2.0 - ND Barrels Of Oil Purchased or Sold | /PRA/ND_BARREL_OIL_PUR_SOL | DEC | 7 | ||
| VAL_OIL_PUR_SLD | Tax 2.0 - ND Oil Value Purchased Or Sold | /PRA/ND_OIL_VALUE | CURR | 7 | ||
| EXEMPT_VALUE | Tax 2.0 ND Ex Val Pur/Sold | /PRA/ND_EXEMPT_VALUE | CURR | 7 | ||
| TAX_VALUE_OIL | Tax 2.0 - ND Oil Taxable Value | /PRA/ND_TAX_VALUE | CURR | 7 | ||
| PR_TAX_DUE | Tax 2.0 - ND Production Tax Due | /PRA/ND_PR_TAX_DUE | CURR | 7 | ||
| PR_TAX_PREV | Tax 2.0 - ND Tax Previously Paid | /PRA/ND_PR_TAX_PREV | CURR | 7 | ||
| PR_TAX_OTHERS | Tax 2.0 ND Production Tax Paid By Others | /PRA/ND_PR_TAX_OTHERS | CURR | 7 | ||
| PR_TAX_PAID | Tax 2.0 - ND Production Tax Paid By Report | /PRA/ND_PR_TAX_REPORT | CURR | 7 | ||
| EX_TAX_DUE | Tax 2.0 - ND Extraction Tax Due | /PRA/ND_EX_TAX_DUE | CURR | 7 | ||
| EX_TAX_PREV | Tax 2.0 - ND Extraction Tax Previously Paid | /PRA/ND_EX_TAX_PREV | CURR | 7 | ||
| EX_TAX_OTHERS | Tax 2.0 - ND Extraction Tax Paid By Others | /PRA/ND_EX_TAX_OTHERS | CURR | 7 | ||
| EX_TAX_PAID | Tax 2.0 - ND Extraction Tax Paid By Report | /PRA/ND_EX_TAX_REPORT | CURR | 7 | ||
| ADDITIONAL_VAL | Tax 2.0 : ND Additional Value | /PRA/ND_ADDITIONAL_VAL | CURR | 4 | ||
| MKT_COST_01 | Marketing Cost | OIUX3_MARKETING_COST | CURR | 6 | ||
| MKT_COST_02 | Marketing Cost | OIUX3_MARKETING_COST | CURR | 6 | ||
| MKT_COST_03 | Marketing Cost | OIUX3_MARKETING_COST | CURR | 6 | ||
| MKT_COST_04 | Marketing Cost | OIUX3_MARKETING_COST | CURR | 6 | ||
| MKT_COST_05 | Marketing Cost | OIUX3_MARKETING_COST | CURR | 6 | ||
| MKT_COST_06 | Marketing Cost | OIUX3_MARKETING_COST | CURR | 6 | ||
| MKT_COST_07 | Marketing Cost | OIUX3_MARKETING_COST | CURR | 6 | ||
| MKT_COST_08 | Marketing Cost | OIUX3_MARKETING_COST | CURR | 6 | ||
| MKT_COST_09 | Marketing Cost | OIUX3_MARKETING_COST | CURR | 6 | ||
| MKT_COST_10 | Marketing Cost | OIUX3_MARKETING_COST | CURR | 6 | ||
| MKT_COST_REIMB | Marketing Cost Reimbursement | OIUX3_MARKETING_COST_REIMB | CURR | 6 | ||
| WELL_CODE | Tax 2.0: ND Well Code | /PRA/ND_WELL_CODE | CHAR | 4 | ||
| POSTING_CODE | Tax 2.0: ND Posting Code | /PRA/ND_POSTING_CODE | CHAR | 8 | ||
| API_NUMBER | Tax 2.0 ND API Number | /PRA/ND_API_NUMBER | CHAR | 16 | ||
| API_NAME | Tax 2.0 North Dakota API Name | /PRA/ND_API_NAME | CHAR | 70 | ||
| OIL_GRAVITY | Tax 2.0 : ND Oil Gravity | /PRA/ND_OIL_GRAVITY | DEC | 2 | ||
| OTHER_NO | Customer / Vendor Number | /PRA/CM_CUSTOMER_VENDOR_NUMBER | CHAR | 20 | ||
| OTH_FED_ID_NO_1 | Tax 2.0: Federal ID Number | /PRA/ND_FEDERAL_ID_NO | NUMC | 18 | ||
| TAXPAYER_NUMBER | Tax 2.0 ND Taxpayer Number | /PRA/ND_TAX_PAYER_NO | CHAR | 18 | ||
| OPTION1 | CHAR | 2 | ||||
| OPTION2 | PPN Flag | CHAR | 2 | |||
| OPTION3 | CHAR | 2 | ||||
| POOL_CODE | Tax 2.0: ND Pool Code | /PRA/ND_POOL_CODE | CHAR | 6 | ||
| DOC_NO | Val. document number | OIURV_DOCNR | CHAR | 40 | ||
| DOC_YEAR | Document year | OIU_DOC_YEAR | NUMC | 8 | ||
| REJ_SUSP_IND | Rejection-Suspension Status | OIUX3_REJECT_SUSPEND_IND | CHAR | 2 | ||
| REJ_CD | Tax 2.0 - ND Reject code | /PRA/ND_REJ_CODE | CHAR | 4 | ||
| OIU_CRUSER | Name of Person Responsible for Creating the Object | ERNAM | CHAR | 24 | ||
| OIU_TIMESTAMP | Tax 2.0 Data Element for Timestamp | /PRA/ND_TMP | DEC | 8 |