|
|
SAP Business One SDK 10.0 - Database Tables Reference |
Electronic Protocol DI API Properties
Table Name: ECM6
Table Description: Electronic Protocol DI API Properties
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| Code | Communication Type or Protocol | Int | 11 | OECM | Â | 0 | Invalid |
| Â | Â | Â | Â | Â | Â | 1 | GEN |
| Â | Â | Â | Â | Â | Â | 2 | EET |
| Â | Â | Â | Â | Â | Â | 3 | CFDI |
| Â | Â | Â | Â | Â | Â | 4 | FPA |
| Â | Â | Â | Â | Â | Â | 5 | MTD |
| Â | Â | Â | Â | Â | Â | 6 | EWB |
| Â | Â | Â | Â | Â | Â | 7 | PEPPOL |
| Â | Â | Â | Â | Â | Â | 8 | HOI |
| Â | Â | Â | Â | Â | Â | 9 | MYF |
| Â | Â | Â | Â | Â | Â | 10 | EIS |
| Â | Â | Â | Â | Â | Â | 11 | IIS |
| Â | Â | Â | Â | Â | Â | 12 | IIS_ANNUAL |
| Â | Â | Â | Â | Â | Â | 13 | DIGIPOORT |
| Â | Â | Â | Â | Â | Â | 14 | E-Books |
| Â | Â | Â | Â | Â | Â | 15 | DOX |
| Â | Â | Â | Â | Â | Â | 16 | RTIE |
| Â | Â | Â | Â | Â | Â | 17 | E-Billing |
| Â | Â | Â | Â | Â | Â | 18 | Tax Service |
| Â | Â | Â | Â | Â | Â | 19 | AFE |
| Â | Â | Â | Â | Â | Â | 20 | Doc. Sign. |
| Â | Â | Â | Â | Â | Â | 21 | KSeF |
| Â | Â | Â | Â | Â | Â | 22 | GSTReturn |
| Â | Â | Â | Â | Â | Â | 23 | PT Doc. Sign. |
| Â | Â | Â | Â | Â | Â | 24 | Skat DK |
| Â | Â | Â | Â | Â | Â | 25 | EII |
| Â | Â | Â | Â | Â | Â | 27 | PT eInvoicing |
| Â | Â | Â | Â | Â | Â | 28 | PT Electronic Communications |
| Â | Â | Â | Â | Â | Â | 29 | Veri*factu |
| Â | Â | Â | Â | Â | Â | 30 | BAS |
| Â | Â | Â | Â | Â | Â | 31 | PDF with XML Attachment |
| Â | Â | Â | Â | Â | Â | 32 | FReINV |
| Â | Â | Â | Â | Â | Â | 33 | euBP |
| GenType | Generation Type | VarChar | 1 | - | Â | N | Not Relevant |
| Â | Â | Â | Â | Â | Â | G | Generate |
| Â | Â | Â | Â | Â | Â | L | Generate - Later |
| Â | Â | Â | Â | Â | Â | F | Generate - Offline |
| MapID | Electronic Document Format Mapping | Int | 11 | OLLF | Â | Â | Â |
| MapID_WS | eDoc Web Service Format Mapping | Int | 11 | OLLF | Â | Â | Â |
| TestMode | Testing Mode Flag | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| LogInstanc | Log Instance | Int | 6 | - | Â | Â | Â |
| ParamLogic | Logic Value Parameter | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| ParamStr | String Value Parameter | nVarChar | 254 | - | Â | Â | Â |
| ParamLText | Long Text Parameter | Text | 16 | - | Â | Â | Â |
| ActStatus | Action Status | VarChar | 1 | - | N | N | New |
| Â | Â | Â | Â | Â | Â | P | Pending |
| Â | Â | Â | Â | Â | Â | E | Error |
| Â | Â | Â | Â | Â | Â | O | OK |
| Â | Â | Â | Â | Â | Â | S | Sent |
| Â | Â | Â | Â | Â | Â | R | Document Error |
| Â | Â | Â | Â | Â | Â | W | Waiting |
| Â | Â | Â | Â | Â | Â | A | Authorized |
| Â | Â | Â | Â | Â | Â | I | In Process |
| Â | Â | Â | Â | Â | Â | J | Rejected |
| Â | Â | Â | Â | Â | Â | D | Denied |
| Â | Â | Â | Â | Â | Â | C | Canceled |
| Â | Â | Â | Â | Â | Â | B | Aborted |
| Â | Â | Â | Â | Â | Â | Q | Queued |
| Â | Â | Â | Â | Â | Â | M | Imported |
| Â | Â | Â | Â | Â | Â | G | Warning |
| Â | Â | Â | Â | Â | Â | o | Not Approved |
| Â | Â | Â | Â | Â | Â | e | Reverse Charge |
| Â | Â | Â | Â | Â | Â | u | Continued |
| Â | Â | Â | Â | Â | Â | f | Further Objection |
| Â | Â | Â | Â | Â | Â | a | Canceling |
| Â | Â | Â | Â | Â | Â | n | Continuing |
| Â | Â | Â | Â | Â | Â | b | Further Objection in Progress |
| Â | Â | Â | Â | Â | Â | d | Resending |
| Â | Â | Â | Â | Â | Â | w | Pending to CAEA |
| Â | Â | Â | Â | Â | Â | k | Queued |
| Â | Â | Â | Â | Â | Â | z | Updating Response |
| ParamUqc | User Query Category | Int | 11 | OQCN | Â | Â | Â |
| ParamInt | Integer Number | Int | 11 | - | Â | Â | Â |
| ParamPAC | Authority Code | nVarChar | 16 | OPAC | Â | Â | Â |
| ParamTgl | Toggle Value Parameter | VarChar | 1 | - | Â | Â | Â |
| ParamMon | Money Value Parameter (Including Currency) | nVarChar | 254 | - | Â | Â | Â |
| ParamLink | Hyperlink Parameter | Text | 16 | - | Â | Â | Â |
| Frequency | Frequency | Int | 11 | - | 1 | 1 | Daily |
| Â | Â | Â | Â | Â | Â | 7 | Weekly |
| Â | Â | Â | Â | Â | Â | 14 | Fortnightly |
| Â | Â | Â | Â | Â | Â | 30 | Monthly |
| Â | Â | Â | Â | Â | Â | 90 | Quarterly |
| Source | Document Source | VarChar | 1 | - | B | B | Business Logic |
| Â | Â | Â | Â | Â | Â | I | Import |
| ReportID | Report ID | nVarChar | 50 | - | Â | Â | Â |
| AssignedID | Assigned ID | nVarChar | 50 | - | Â | Â | Â |
| Confirm | Confirmation | nVarChar | 5 | - | Â | Â | Â |
| PayMethod | Payment Method | nVarChar | 50 | - | 01 | 01 | Efectivo |
| Â | Â | Â | Â | Â | Â | 02 | Cheque nominativo |
|  |  |  |  |  |  | 03 | Transferencia electr�nica de fondos |
|  |  |  |  |  |  | 04 | Tarjeta de cr�dito |
|  |  |  |  |  |  | 05 | Monedero electr�nico |
|  |  |  |  |  |  | 06 | Dinero electr�nico |
| Â | Â | Â | Â | Â | Â | 08 | Vales de despensa |
|  |  |  |  |  |  | 12 | Daci�n en pago |
|  |  |  |  |  |  | 13 | Pago por subrogaci�n |
|  |  |  |  |  |  | 14 | Pago por consignaci�n |
|  |  |  |  |  |  | 15 | Condonaci�n |
|  |  |  |  |  |  | 17 | Compensaci�n |
|  |  |  |  |  |  | 23 | Novaci�n |
|  |  |  |  |  |  | 24 | Confusi�n |
|  |  |  |  |  |  | 25 | Remisi�n de deuda |
|  |  |  |  |  |  | 26 | Prescripci�n o caducidad |
|  |  |  |  |  |  | 27 | A satisfacci�n del acreedor |
|  |  |  |  |  |  | 28 | Tarjeta de d�bito |
| Â | Â | Â | Â | Â | Â | 29 | Tarjeta de servicios |
|  |  |  |  |  |  | 30 | Aplicaci�n de anticipos |
| Â | Â | Â | Â | Â | Â | 31 | Intermediario pagos |
| Â | Â | Â | Â | Â | Â | 99 | Por definir |
| CancStatus | Cancelation Status | VarChar | 1 | - | T | T | Â |
| Â | Â | Â | Â | Â | Â | N | New Request |
| Â | Â | Â | Â | Â | Â | S | Request Sent |
| Â | Â | Â | Â | Â | Â | A | Approved |
| Â | Â | Â | Â | Â | Â | R | Rejected |
| Â | Â | Â | Â | Â | Â | E | Error |
| Â | Â | Â | Â | Â | Â | C | Canceled |
| Â | Â | Â | Â | Â | Â | I | In Process |
| Â | Â | Â | Â | Â | Â | U | Sent To Authorities |
| Â | Â | Â | Â | Â | Â | W | Canceled Without Approval |
| CancRecons | Canceled Reconciliations | nVarChar | 30 | - | Â | Â | Â |
| EntryTypes | Filter Entry Types | nVarChar | 30 | - | Â | Â | Â |
| EntryStats | Filter Entry Statuses | nVarChar | 30 | - | Â | Â | Â |
| EntryCncSt | Filter Entries by Cancellation Status | nVarChar | 30 | - | Â | Â | Â |
| MaxLines | Filter Max Lines | Int | 6 | - | 0 | Â | Â |
| BPLId | Filter Branch ID | Int | 11 | - | -1 | Â | Â |
| DateFrom | Filter Date From | Date | 8 | - | Â | Â | Â |
| TimeFrom | Filter Time From | Int | 11 | - | Â | Â | Â |
| DateTo | Filter Date To | Date | 8 | - | Â | Â | Â |
| TimeTo | Filter Time To | Int | 11 | - | Â | Â | Â |
| FromEntry | Filter From Entry | Int | 11 | - | Â | Â | Â |
| Ascending | Order Ascending | VarChar | 1 | - | Y | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| CodeStr | Code as a string | nVarChar | 8 | - | Â | Â | Â |
| GUID | Filter GUID | nVarChar | 100 | - | Â | Â | Â |
| LogType | Filter Log Type | VarChar | 1 | - | R | Â | INVALID |
| Â | Â | Â | Â | Â | Â | S | Send |
| Â | Â | Â | Â | Â | Â | R | Receive |
| Â | Â | Â | Â | Â | Â | I | Import |
| Â | Â | Â | Â | Â | Â | N | Note |
| Â | Â | Â | Â | Â | Â | W | Warning |
| Â | Â | Â | Â | Â | Â | E | Error |
| Â | Â | Â | Â | Â | Â | D | WS Data |
| Â | Â | Â | Â | Â | Â | B | Authorities Process Starts |
| Â | Â | Â | Â | Â | Â | F | Authorities Process Finished |
| LogMessage | Log Message | Text | 16 | - | Â | Â | Â |
| LogData | Log Data | Text | 16 | - | Â | Â | Â |
| EDocType | E-Doc Type | Int | 11 | OUNCL | Â | Â | Â |
| EDocNum | E-Doc Number | nVarChar | 100 | - | Â | Â | Â |
| ROText1 | Read Only Text 1 | nVarChar | 254 | - | Â | Â | Â |
| ProcTarget | Processing Target | nVarChar | 40 | - | Â | Â | Â |
| ParticipID | E-Doc Number | nVarChar | 128 | - | Â | Â | Â |
| PositMARK | MARK of Positive Value Invoice | nVarChar | 100 | - | Â | Â | Â |
| NegatMARK | MARK of Negative Value Invoice | nVarChar | 100 | - | Â | Â | Â |
| EbookRelvt | Is E-Books Relevant | VarChar | 1 | - | Â | Â | Â |
| PInvType | Type Abs of Pos. Value Invoice | Int | 11 | OEIT | Â | Â | Â |
| PInvCode | Type of Pos. Value Invoice | nVarChar | 254 | - | Â | Â | Â |
| NInvType | Type Abs of Neg. Value Invoice | Int | 11 | OEIT | Â | Â | Â |
| NInvCode | Type of Neg. Value Invoice | nVarChar | 254 | - | Â | Â | Â |
| BlobCntTyp | Blob Content Type | Int | 11 | - | -1 | -1 | Â |
| Â | Â | Â | Â | Â | Â | 0 | XML |
| Â | Â | Â | Â | Â | Â | 1 | Zipped XML |
| Â | Â | Â | Â | Â | Â | 2 | JSON |
| Â | Â | Â | Â | Â | Â | 3 | Zipped JSON |
| Â | Â | Â | Â | Â | Â | 4 | Text |
| ZipUnzip | Zip or Unzip Blob Content | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| KeepPrefix | Keep Prefix in Blob Content | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| DocFunc | Document Function | VarChar | 1 | - | 0 | 0 | Â |
| Â | Â | Â | Â | Â | Â | 1 | ??? - ????-??????? |
| Â | Â | Â | Â | Â | Â | 2 | ?????? - ????-??????? ? o??????? |
| Â | Â | Â | Â | Â | Â | 3 | ??? - o??????? |
| Â | Â | Â | Â | Â | Â | 4 | ???? - ???????????????? ????-??????? |
| Â | Â | Â | Â | Â | Â | 5 | ??????? - ???????????????? ????-??????? ? o??????? |
| Â | Â | Â | Â | Â | Â | 6 | ??? - o??????? |
| EIRN | IRN of E-Billing | nVarChar | 254 | - | Â | Â | Â |
| PKP | Â | Text | 16 | - | Â | Â | Â |
| BKP | Â | Text | 16 | - | Â | Â | Â |
| SignMsg | Â | Text | 16 | - | Â | Â | Â |
| SignDigest | Â | Text | 16 | - | Â | Â | Â |
| FechaTimbr | Â | nVarChar | 30 | - | Â | Â | Â |
| SelloSAT | Â | Text | 16 | - | Â | Â | Â |
| RFCofPAC | Â | nVarChar | 100 | - | Â | Â | Â |
| PACSATCert | Â | nVarChar | 100 | - | Â | Â | Â |
| SeqNum | Â | Int | 11 | - | Â | Â | Â |
| SndDateSDI | Â | Date | 8 | - | Â | Â | Â |
| Progressiv | Â | nVarChar | 20 | - | Â | Â | Â |
| ExportFile | Â | Text | 16 | - | Â | Â | Â |
| Descriptn | Protocol Description | nVarChar | 200 | - | Â | Â | Â |
| CFDiExport | Â | nVarChar | 2 | - | 01 | 01 | No aplica |
| Â | Â | Â | Â | Â | Â | 02 | Definitiva |
| Â | Â | Â | Â | Â | Â | 03 | Temporal |
|  |  |  |  |  |  | 04 | Definitiva con clave distinta a A1 o cuando no existe enajenaci�n en t�rminos del CFF |
| TaxProvidr | Tax Service Provider | nVarChar | 100 | - | Â | Â | Â |
| CancReason | Cancellation Reason | nVarChar | 2 | - | Â | Â | Â |
| CancResp | Cancellation Response | nVarChar | 3 | - | Â | Â | Â |
| EBAckNo | AckNo of E-Billing | nVarChar | 20 | - | Â | Â | Â |
| EBAckDate | AckDt of E-Billing | nVarChar | 30 | - | Â | Â | Â |
| EBSignINV | SignedINV of E-Billing | Text | 16 | - | Â | Â | Â |
| EBSignedQC | SignedQC of E-Billing | Text | 16 | - | Â | Â | Â |
| EBRespSta | Status of E-Billing | nVarChar | 10 | - | Â | Â | Â |
| FCEID | FCE ID | nVarChar | 20 | - | Â | Â | Â |
| FCEApprSt | Approval Status | nVarChar | 30 | - | Â | Â | Â |
| FCEDcApSt | Doc. Approval Status | nVarChar | 30 | - | Â | Â | Â |
| FCEPaidVal | Paid Value | nVarChar | 50 | - | Â | Â | Â |
| FCETotalV | Total Value | nVarChar | 50 | - | Â | Â | Â |
| FCEDocDate | AFIP Doc. Date | nVarChar | 100 | - | Â | Â | Â |
| FCECBU | CBU | nVarChar | 254 | - | Â | Â | Â |
| FCEApprDt | Approval Date | nVarChar | 100 | - | Â | Â | Â |
| FCEDcApDt | Doc. Approval Date | nVarChar | 100 | - | Â | Â | Â |
| FCEInitAmt | Initial Amount | nVarChar | 50 | - | Â | Â | Â |
| FCERetent | Retentions | nVarChar | 50 | - | Â | Â | Â |
| FCEDocRate | Doc. Exchange Rate | nVarChar | 50 | - | Â | Â | Â |
| CancRef | Cancellation Reference | nVarChar | 50 | - | Â | Â | Â |
| GenTypeAP | Generation Type for A/P | VarChar | 1 | - | Â | N | Not Relevant |
| Â | Â | Â | Â | Â | Â | G | Generate |
| Â | Â | Â | Â | Â | Â | L | Generate - Later |
| AutProcess | Authorities Process | VarChar | 1 | - | Â | Â | None |
| Â | Â | Â | Â | Â | Â | A | Approval Process |
| Â | Â | Â | Â | Â | Â | R | Rejection Process |
| IsEncryptd | Protocol Encryption Enabled | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| FEAPInvTyp | FE-AP Invoice Type | nVarChar | 2 | - | 01 | 01 | Invoice |
| Â | Â | Â | Â | Â | Â | 02 | Debit Memo |
| Â | Â | Â | Â | Â | Â | 03 | Invoice Receipt |
| Â | Â | Â | Â | Â | Â | 04 | Simplified Invoice |
| Â | Â | Â | Â | Â | Â | 05 | Credit Memo |
| FEAPOutID | FE-AP Outbound Financial Doc. ID | nVarChar | 100 | - | Â | Â | Â |
| SttsReason | Status Reason | nVarChar | 3 | - | Â | NON | No Issues |
| Â | Â | Â | Â | Â | Â | REF | Incorrect references |
| Â | Â | Â | Â | Â | Â | LEG | Incorrect legal information |
| Â | Â | Â | Â | Â | Â | REC | Unknown receiver |
| Â | Â | Â | Â | Â | Â | QUA | Insufficient item quality |
| Â | Â | Â | Â | Â | Â | DEL | Issues with delivery |
| Â | Â | Â | Â | Â | Â | PRI | Incorrect prices |
| Â | Â | Â | Â | Â | Â | QTY | Incorrect quantity |
| Â | Â | Â | Â | Â | Â | ITM | Incorrect items |
| Â | Â | Â | Â | Â | Â | PAY | Incorrect payment terms |
| Â | Â | Â | Â | Â | Â | UNR | Not recognized |
| Â | Â | Â | Â | Â | Â | FIN | Incorrect financials |
| Â | Â | Â | Â | Â | Â | PPD | Partially Paid |
| Â | Â | Â | Â | Â | Â | OTH | Other |
| SttsDescr | Status Description | nVarChar | 254 | - | Â | Â | Â |
| PostPerInv | Post Per Invoice | VarChar | 1 | - | Â | Â | Â |
| PosiQRPath | Positive QR Path | nVarChar | 200 | - | Â | Â | Â |
| NegaQRPath | Negative QR Path | nVarChar | 200 | - | Â | Â | Â |
| CartaPorte | Complemento Carta Porte ID | nVarChar | 50 | - | Â | Â | Â |
| CartDocTyp | Carta Porte Document Types | nVarChar | 200 | - | Â | Â | Â |
| CartDocSet | Apply from Document settings | VarChar | 1 | - | Y | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| LogNum | Log Number | Int | 11 | - | Â | Â | Â |
| C5Relevant | Corner 5 Relevant | VarChar | 1 | - | Â | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| DocUUID | Document UUID | nVarChar | 128 | - | Â | Â | Â |
| TransUUID | Transmission UUID | nVarChar | 128 | - | Â | Â | Â |
| UserSign | User Signature | Int | 6 | OUSR | Â | Â | Â |
| DsptchDate | Dispatch Date | Date | 8 | - | Â | Â | Â |
| DsptchTime | Dispatch Time | Int | 11 | - | Â | Â | Â |
| Sensitive | Value is Sensitive | VarChar | 1 | - | Â | N | No |
| Â | Â | Â | Â | Â | Â | Y | Yes |
| Â | Â | Â | Â | Â | Â | Â | None |
| ETypeDesc | E-Doc Type Description | nVarChar | 254 | - | Â | Â | Â |
| MapIDC5 | Electronic Document Format Mapping C5 | Int | 11 | OLLF | Â | Â | Â |
| CAEA | CAEA Number | nVarChar | 14 | - | Â | Â | Â |
| CAEAEnable | CAEA Enabled | VarChar | 1 | - | Â | Â | Â |
| SerialData | Serialized Data | Text | 16 | - | Â | Â | Â |
| Key | Unique | Field |
| PRIMARY | Yes | CodeStr |