| 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 | * | MANDT | Allow NULL? |
| 2 | DOCNR | External-tax document number | nvarchar | 12 | 0 | CHAR | (N' ') | No | | XTAX_DOCUMENT_NUMBER | Allow NULL? |
| 3 | AWTYP | Reference Transaction | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | * | AWTYP | Allow NULL? |
| 4 | AWREF | Reference Document Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | AWREF | Allow NULL? |
| 5 | AWORG | Reference Organizational Units | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | AWORG | Allow NULL? |
| 6 | AWSYS | Logical system of source document | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | AWSYS | Allow NULL? |
| 7 | DOCSTATUS | Current status of the external tax document | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | ETXDC_STATUS_CUR | Allow NULL? |
| 8 | DOCSTATUSCHANGED | Last date that the status of the document changed | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | ETXDC_STATUS_CHANGED | Allow NULL? |
| 9 | CREATEDON | Date on which the the external tax document was created | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | TAX_CREATEDON | Allow NULL? |
| 10 | CREATEDBY | Name of person who created the external tax document | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | TAX_CREATEDBY | Allow NULL? |
| 11 | TID | Transaction ID for updating external tax system | nvarchar | 24 | 0 | CHAR | (N' ') | Yes | | TAX_TID | Allow NULL? |
| 12 | GLTAX | G/L tax data transferred to external tax document? | char | 1 | 0 | CHAR | (N' ') | Yes | | TAX_GLTAX_ADDED | Allow NULL? |
| 13 | TXDEF | Defaulted tax amounts | char | 1 | 0 | CHAR | (N' ') | Yes | | TAX_DEFAULTED | Allow NULL? |
| 14 | DEFAULT_REASON | Tax Default Reason | char | 1 | 0 | CHAR | (N' ') | Yes | | TAX_DEFAULT_REASON | Allow NULL? |
| 15 | INCON | Internal consistency check with tax data in G/L failed | char | 1 | 0 | CHAR | (N' ') | Yes | | TAX_INCONS_INT | Allow NULL? |
| 16 | EXCON | External consistency check with tax data recalculated failed | char | 1 | 0 | CHAR | (N' ') | Yes | | TAX_INCONS_EXT | Allow NULL? |
| 17 | UFLAG | Audit file update indicator (external interface) | char | 1 | 0 | CHAR | (N' ') | Yes | | UPDATE_FLG | Allow NULL? |
| 18 | UDATE | Audit file update date (external interface) | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | UPDATE_DAT | Allow NULL? |
| 19 | USNAM | user who updated external tax document into external system | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | UPDATE_USER | Allow NULL? |
| 20 | SYST_NAME | Logical system using tax interface | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | TAX_LOGSYS | Allow NULL? |
| 21 | CLIENT | Client using tax interface | nvarchar | 3 | 0 | CLNT | (N'000') | Yes | * | TAX_CLIENT | Allow NULL? |
| 22 | COMP_CODE | Company code using tax interface | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | TAX_COMP_CODE | Allow NULL? |
| 23 | DOC_NUMBER | Tax document number | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | TAX_DOC_NUMBER | Allow NULL? |
| 24 | CURRENCY | Document currency when calculating taxes | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | TAX_CURRENCY | Allow NULL? |
| 25 | CURR_DEC | Number of decimal places for currency (characters) | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | CURDECCHAR | Allow NULL? |
| 26 | TXJCD_L1 | Length of the Nth Part of the Tax Jurisdiction Code | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | LENGX_TXD | Allow NULL? |
| 27 | TXJCD_L2 | Length of the Nth Part of the Tax Jurisdiction Code | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | LENGX_TXD | Allow NULL? |
| 28 | TXJCD_L3 | Length of the Nth Part of the Tax Jurisdiction Code | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | LENGX_TXD | Allow NULL? |
| 29 | TXJCD_L4 | Length of the Nth Part of the Tax Jurisdiction Code | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | LENGX_TXD | Allow NULL? |
| 30 | TAX_PER_ITEM | Tax per Item flag: Tax calculation is done by line item | char | 1 | 0 | CHAR | (N' ') | Yes | | TAX_PER_ITEM | Allow NULL? |
| 31 | NR_LINE_ITEMS | Number of lines in external tax document | nvarchar | 6 | 0 | NUMC | (N'000000') | Yes | | TAX_NR_LINES | Allow NULL? |
| 32 | GL_CURRENCY | Currency of the taxes stored in G/L (local currency) | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | TAX_GLCURRENCY | Allow NULL? |
| 33 | GL_CURR_DEC | Number of decimal places for local (G/L) currency | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | GL_CURDECCHAR | Allow NULL? |
| 34 | REP_DATE | Posting date (internal format) | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | EXTREPDATE | Allow NULL? |
| 35 | RATEDEC | Number of decimals used in the rate (%) | char | 1 | 0 | CHAR | (N' ') | Yes | | TAX_RATEDECCHAR | Allow NULL? |
| 36 | XEXTN | Indicator: External tax calculation | char | 1 | 0 | CHAR | (N' ') | Yes | * | XEXTN_TXP | Allow NULL? |
| 37 | INTERF_VERSION | Tax interface version | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | TAX_INT_VERSION | Allow NULL? |
| 38 | TAX_PROCEDURE | Procedure (Pricing, Output Control, Acct. Det., Costing,...) | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | * | KALSM_D | Allow NULL? |
