| 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 | DOCNUM | Document Number | nvarchar | 10 | 0 | NUMC | (N'0000000000') | No | * | J_1BDOCNUM | Allow NULL? |
| 3 | DOCSTA | Document Status | char | 1 | 0 | CHAR | (N' ') | No | | J_1BNFEDOCSTATUS | Allow NULL? |
| 4 | SCSSTA | System Communication Status | char | 1 | 0 | CHAR | (N' ') | No | | J_1BNFESCSSTATUS | Allow NULL? |
| 5 | COUNTER | Counter (Key Field for History Table) | nvarchar | 3 | 0 | NUMC | (N'000') | No | | J_1BNFE_HISTORY_COUNTER | Allow NULL? |
| 6 | CONTING | Document Posted under Contingency | char | 1 | 0 | CHAR | (N' ') | Yes | | J_1BCONTINGENCY | Allow NULL? |
| 7 | CANCEL | Canceled | char | 1 | 0 | CHAR | (N' ') | Yes | | J_1BCANCEL | Allow NULL? |
| 8 | CODE | Official Status Code | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | * | J_1BSTATUSCODE | Allow NULL? |
| 9 | ACTION_DATE | Date of Change to Document | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | J_1BNFE_ACTION_DATE | Allow NULL? |
| 10 | ACTION_TIME | Time of Change to Document | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | J_1BNFE_ACTION_TIME | Allow NULL? |
| 11 | ACTION_USER | User Who Made Change to Document | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | J_1BNFE_ACTION_USER | Allow NULL? |
| 12 | AUTHCOD | Protocol Number | nvarchar | 15 | 0 | CHAR | (N' ') | Yes | | J_1BNFEAUTHCODE | Allow NULL? |
| 13 | PRINTD | Printed | char | 1 | 0 | CHAR | (N' ') | Yes | | J_1BPRINTD | Allow NULL? |
| 14 | CONTING_S | Switched to Contingency | char | 1 | 0 | CHAR | (N' ') | Yes | | J_1BCONTINGENCY_NFE_SWITCHED | Allow NULL? |
| 15 | MSSTAT | Status from Messaging System | char | 1 | 0 | CHAR | (N' ') | Yes | | J_1BNFE_MS_STATUS | Allow NULL? |
| 16 | REASON | Reason for Cancellation/Skipping | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | J_1BNFE_CANCEL_REASON | Allow NULL? |
| 17 | REASON1 | Text for Cancellation/Skipping Reason | nvarchar | 64 | 0 | CHAR | (N' ') | Yes | | J_1BNFE_CANCEL_TEXT | Allow NULL? |
| 18 | REASON2 | Text for Cancellation/Skipping Reason | nvarchar | 64 | 0 | CHAR | (N' ') | Yes | | J_1BNFE_CANCEL_TEXT | Allow NULL? |
| 19 | REASON3 | Text for Cancellation/Skipping Reason | nvarchar | 64 | 0 | CHAR | (N' ') | Yes | | J_1BNFE_CANCEL_TEXT | Allow NULL? |
| 20 | REASON4 | Text for Cancellation/Skipping Reason | nvarchar | 64 | 0 | CHAR | (N' ') | Yes | | J_1BNFE_CANCEL_TEXT | Allow NULL? |
| 21 | CALLRFC | Control Doc. No. and RFC Execution to Messaging System | char | 1 | 0 | CHAR | (N' ') | Yes | | J_1BNFERFCCALL | Allow NULL? |
| 22 | NFNUM9 | Nine-Digit Document Number | nvarchar | 9 | 0 | CHAR | (N' ') | Yes | | J_1BNFNUM9 | Allow NULL? |
| 23 | REGIO | Region of Document Issuer | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | J_1BREGIO | Allow NULL? |
| 24 | TPAMB | Type of Environment (Test or Production) | char | 1 | 0 | CHAR | (N' ') | Yes | | J_1BNFETPAMB | Allow NULL? |
| 25 | SEFAZ_ACTIVE | SEFAZ Server is Active | char | 1 | 0 | CHAR | (N' ') | Yes | | J_1BNFE_SEFAZ_ACTIVE | Allow NULL? |
| 26 | SCAN_ACTIVE | SCAN Server is Active | char | 1 | 0 | CHAR | (N' ') | Yes | | J_1BNFE_SCAN_ACTIVE | Allow NULL? |
| 27 | CHECKTMPL | UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) | decimal | 21 | 7 | DEC | ((0)) | Yes | | TIMESTAMPL | |
| 28 | AUTHDATE | Processing Timestamp - Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | J_1BAUTHDATE | Allow NULL? |
| 29 | AUTHTIME | Processing Timestamp - Time | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | J_1BAUTHTIME | Allow NULL? |
| 30 | TPEMIS | Issuing Type | char | 1 | 0 | CHAR | (N' ') | Yes | | J_1BNFE_TPEMIS | Allow NULL? |
| 31 | REASON_CONTING | Reason for Contingency | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | J_1BNFE_CONTINGENCY_REASON | Allow NULL? |
| 32 | REASON_CONTING1 | Text for Contingency Reason | nvarchar | 64 | 0 | CHAR | (N' ') | Yes | | J_1BNFE_CONTINGENCY_TEXT | Allow NULL? |
| 33 | REASON_CONTING2 | Text for Contingency Reason | nvarchar | 64 | 0 | CHAR | (N' ') | Yes | | J_1BNFE_CONTINGENCY_TEXT | Allow NULL? |
| 34 | REASON_CONTING3 | Text for Contingency Reason | nvarchar | 64 | 0 | CHAR | (N' ') | Yes | | J_1BNFE_CONTINGENCY_TEXT | Allow NULL? |
| 35 | REASON_CONTING4 | Text for Contingency Reason | nvarchar | 64 | 0 | CHAR | (N' ') | Yes | | J_1BNFE_CONTINGENCY_TEXT | Allow NULL? |
| 36 | CONTING_DATE | Contingency Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | J_1BNFE_CONTINGENCY_DATE | Allow NULL? |
| 37 | CONTING_TIME | Contingency Time | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | J_1BNFE_CONTINGENCY_TIME | Allow NULL? |
| 38 | CONTIN_TIME_ZONE | Time Zone | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | * | TZNZONE | Allow NULL? |
| 39 | CANCEL_ALLOWED | Cancellation Allowed by Authorities | char | 1 | 0 | CHAR | (N' ') | Yes | | J_1BNFE_CANCEL_ALLOWED | Allow NULL? |
| 40 | CANCEL_PA | Cancel Prior to Authorization | char | 1 | 0 | CHAR | (N' ') | Yes | | J_1BNFE_CANCEL_PA | Allow NULL? |
| 41 | ACTIVE_SERVICE | Active Service of Tax Authorities | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | J_1BNFE_ACTIVE_SERVICE | Allow NULL? |
| 42 | ACTION_REQU | Required Process Step | char | 1 | 0 | CHAR | (N' ') | Yes | | J_1BNFE_ACTION_REQUIRED | Allow NULL? |
| 43 | SVC_SP_ACTIVE | SVC SP Contingency Active | char | 1 | 0 | CHAR | (N' ') | Yes | | J_1BNFE_SVCSP_ACTIVE | Allow NULL? |
| 44 | SVC_RS_ACTIVE | SVC RS Contingency Active | char | 1 | 0 | CHAR | (N' ') | Yes | | J_1BNFE_SVCRS_ACTIVE | Allow NULL? |
| 45 | SVC_ACTIVE | Contingency SVC Active | char | 1 | 0 | CHAR | (N' ') | Yes | | J_1BNFE_SVC_ACTIVE | Allow NULL? |
