| 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_REQ_MX | 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 | CFDIRESPT | Timestamp of gen. of dig. stamp by the SAT (ISO 8601 Format) | nvarchar | 19 | 0 | CHAR | (N' ') | Yes | | CFDI_RESPTIM_MX | Allow NULL? |
| 9 | REJCODE | Rejection Code received | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | CFDI_REJC_MX | Allow NULL? |
| 10 | VERSION | (1.a) XML/DI/CFDI Version | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | | CFDI_XML_VERSION | Allow NULL? |
| 11 | UUID | UUID: Unique Identifier | nvarchar | 36 | 0 | CHAR | (N' ') | Yes | | CFDI_UUID | Allow NULL? |
| 12 | SAT_CERTNO | noCertificadoSAT | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | CFDI_NOCERT_SAT | Allow NULL? |
| 13 | FECHA_A | Date and Time of generation of the acknowledgement | nvarchar | 19 | 0 | CHAR | (N' ') | Yes | | CFDI_CACKT_MX | Allow NULL? |
| 14 | CODESTATUS | Status code of the cancellation | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | CFDI_CODESTATUS | Allow NULL? |
| 15 | ESTATUSUUID | Element to define the status of tax folios (UUID) | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | CFDI_ESTAT_UUID | Allow NULL? |
| 16 | ERNAM | Created By (Username) | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | CFDI_ERNAM_MX | Allow NULL? |
| 17 | ERDAT | Created At (Timestamp) | nvarchar | 19 | 0 | CHAR | (N' ') | Yes | | CFDI_ERDAT_MX | Allow NULL? |
| 18 | AENAM | Change By (Username) | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | CFDI_AENAM_MX | Allow NULL? |
| 19 | AEDAT | Change At (Timestamp) | nvarchar | 19 | 0 | CHAR | (N' ') | Yes | | CFDI_AEDAT_MX | Allow NULL? |
| 20 | SELLOSAT_GUID | GUID of the SELLOSAT Character Chain (Response) | varbinary | 16 | 0 | RAW | | Yes | | CFDI_SELLOSAT_MX | |
| 21 | DIGEST_VAL_GUID | GUID of the Digest Value character chain (Cancellation) | varbinary | 16 | 0 | RAW | | Yes | | CFDI_DIGVAL_MX | |
| 22 | SIGN_VALUE_GUID | GUID of the Signed info value (Cancellation) | varbinary | 16 | 0 | RAW | | Yes | | CFDI_SIGN_INFO_MX | |
| 23 | X509_CERT_GUID | GUID for X509 Certificate(Base 64) (Cancellation) | varbinary | 16 | 0 | RAW | | Yes | | CFDI_ISCERT_MX | |
| 24 | SRNR_VALUE_GUID | X509 Serial Number (Cancellation) | varbinary | 16 | 0 | RAW | | Yes | | CFDI_CER_SRNR_MX | |
| 25 | X509_ISN_GUID | GUID for the Issuer Name (Cancellation) | varbinary | 16 | 0 | RAW | | Yes | | CFDI_ISN_MX | |
| 26 | QR_GUID | GUID of the QR code (invoice approval) | varbinary | 16 | 0 | RAW | | Yes | | CFDI_QR_MX | |
