| 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 | BUKRS | Company Code | nvarchar | 4 | 0 | CHAR | (N' ') | No | T001 | BUKRS | Allow NULL? |
| 3 | REFDOC | Reference Invoice Document Number | nvarchar | 10 | 0 | CHAR | (N' ') | No | | CFDI_REFDOC_MX | Allow NULL? |
| 4 | REFTYP | Reference Document Type | char | 1 | 0 | CHAR | (N' ') | No | | CFDI_REFDOCTY_MX | Allow NULL? |
| 5 | GJAHR | Fiscal Year | nvarchar | 4 | 0 | NUMC | (N'0000') | No | | GJAHR | Allow NULL? |
| 6 | REFDOCDT | Reference Document Creation/Posting Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | CFDI_REFDOCDT_MX | Allow NULL? |
| 7 | STATUS | Invoice Status (For CFDI Process) | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | CFDI_STATUS_MX | Allow NULL? |
| 8 | CFDIREQT | Timestamp of Request Sent ( ISO 8601 Format ) | nvarchar | 19 | 0 | CHAR | (N' ') | Yes | | CFDI_REQTIM_MX | Allow NULL? |
| 9 | CFDIREQTZ | Timezone of Request Sent (Local Timezone) | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | | CFDI_REQTIMZ_MX | Allow NULL? |
| 10 | REG_TAX_NUMBER | Issuers tax number (rfcEmissor) | nvarchar | 50 | 0 | CHAR | (N' ') | Yes | | CFDI_TAXN_MX | Allow NULL? |
| 11 | FECHA_C | Date and time of cancellation | nvarchar | 19 | 0 | CHAR | (N' ') | Yes | | CFDI_CANCDT_MX | Allow NULL? |
| 12 | ERNAM | Created By (Username) | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | CFDI_ERNAM_MX | Allow NULL? |
| 13 | ERDAT | Created At (Timestamp) | nvarchar | 19 | 0 | CHAR | (N' ') | Yes | | CFDI_ERDAT_MX | Allow NULL? |
| 14 | AENAM | Change By (Username) | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | CFDI_AENAM_MX | Allow NULL? |
| 15 | AEDAT | Change At (Timestamp) | nvarchar | 19 | 0 | CHAR | (N' ') | Yes | | CFDI_AEDAT_MX | Allow NULL? |
| 16 | SELLOCFD_GUID | GUID of the SELLOCFD Character Chain (Request) | varbinary | 16 | 0 | RAW | | Yes | | CFDI_SELLOCFD_MX | |
| 17 | DIGEST_VAL_GUID | GUID of the Digest Value character chain (Cancellation) | varbinary | 16 | 0 | RAW | | Yes | | CFDI_DIGVAL_MX | |
| 18 | SIGN_VALUE_GUID | GUID of the Signed info value (Cancellation) | varbinary | 16 | 0 | RAW | | Yes | | CFDI_SIGN_INFO_MX | |
| 19 | X509_CERT_GUID | GUID for X509 Certificate(Base 64) (Cancellation) | varbinary | 16 | 0 | RAW | | Yes | | CFDI_ISCERT_MX | |
| 20 | SRNR_VALUE_GUID | X509 Serial Number (Cancellation) | varbinary | 16 | 0 | RAW | | Yes | | CFDI_CER_SRNR_MX | |
| 21 | X509_ISN_GUID | GUID for the Issuer Name (Cancellation) | varbinary | 16 | 0 | RAW | | Yes | | CFDI_ISN_MX | |
