Sovos.com Contact Support

Data and Analytics

Sovos Intelligence

Compliance Network source group

Tables and columns available in the Compliance Network source group.

Overview

The Compliance Network source group has 13 models:

  • CN_AR_INVOICE_LINES

  • CN_AR_INVOICES

  • CN_ARCHIVE_INVOICES

  • CN_BR_INVOICE_LINES

  • CN_BR_INVOICES

  • CN_CANONICAL_INVOICES

  • CN_CANONICAL_INVOICES_LINES

  • CN_EC_INVOICE_LINES

  • CN_EC_INVOICES

  • CN_Invoices

  • CN_Invoices_Lines

  • CN_PE_INVOICE_LINES

  • CN_PE_INVOICES

All are available in the query builder's Database panel and in Data > All Data.

CN_AR_INVOICE_LINES (123 columns)

Column Type
DOCUMENTUUID TEXT
LINENUMBER NUMBER
LINEID TEXT
ITEMNAME TEXT
ITEMDESCRIPTION TEXT
INVOICEDQUANTITY NUMBER
QUANTITYUNITCODE TEXT
LINEEXTENSIONAMOUNT NUMBER
LINECURRENCY TEXT
UNITPRICE NUMBER
COUNTRY TEXT
PIPELINERUNID TEXT
LOADEDAT TIMESTAMP_NTZ
ORGANIZATIONID TEXT
COMPANYID TEXT
AR_LINEIDVALUE TEXT
AR_LINEIDSCHEMEID TEXT
AR_INVOICEDQUANTITYRAW NUMBER
AR_QUANTITYUNITCODERAW TEXT
AR_LINEEXTENSIONAMOUNTRAW NUMBER
AR_LINEEXTENSIONCURRENCY TEXT
AR_PRICEAMOUNTRAW NUMBER
AR_PRICECURRENCY TEXT
AR_ITEMNAMEVALUE TEXT
AR_ITEMDESCRIPTIONVALUE TEXT
AR_SELLERSITEMID TEXT
AR_STANDARDITEMID TEXT
AR_ITEMDESCRIPTION1VALUE TEXT
AR_ITEMDESCRIPTION2VALUE TEXT
AR_ITEMDESCRIPTION3VALUE TEXT
AR_ITEMDESCRIPTION4VALUE TEXT
AR_ITEMDESCRIPTION5VALUE TEXT
AR_ITEMDESCRIPTION6VALUE TEXT
AR_ITEMDESCRIPTION7VALUE TEXT
AR_ITEMDESCRIPTION8VALUE TEXT
AR_ITEMDESCRIPTION9VALUE TEXT
AR_ITEMDESCRIPTION10VALUE TEXT
AR_ITEMDESCRIPTIONALLVALUES TEXT
AR_ITEMPROPERTY1NAME TEXT
AR_ITEMPROPERTY1VALUE TEXT
AR_ITEMPROPERTY2NAME TEXT
AR_ITEMPROPERTY2VALUE TEXT
AR_ITEMPROPERTY3NAME TEXT
AR_ITEMPROPERTY3VALUE TEXT
AR_ITEMPROPERTY4NAME TEXT
AR_ITEMPROPERTY4VALUE TEXT
AR_ITEMPROPERTY5NAME TEXT
AR_ITEMPROPERTY5VALUE TEXT
AR_ITEMPROPERTY6NAME TEXT
AR_ITEMPROPERTY6VALUE TEXT
AR_ITEMPROPERTY7NAME TEXT
AR_ITEMPROPERTY7VALUE TEXT
AR_ITEMPROPERTY8NAME TEXT
AR_ITEMPROPERTY8VALUE TEXT
AR_ITEMPROPERTY9NAME TEXT
AR_ITEMPROPERTY9VALUE TEXT
AR_ITEMPROPERTY10NAME TEXT
AR_ITEMPROPERTY10VALUE TEXT
AR_ITEMPROPERTYALLNAMES TEXT
AR_ITEMPROPERTYALLVALUES TEXT
AR_LINETAXSUBTOTAL1SCHEMEID TEXT
AR_LINETAXSUBTOTAL1CATEGORYID TEXT
AR_LINETAXSUBTOTAL1PERCENT NUMBER
AR_LINETAXSUBTOTAL1TAXABLEAMOUNT NUMBER
AR_LINETAXSUBTOTAL1TAXAMOUNT NUMBER
AR_LINETAXSUBTOTAL2SCHEMEID TEXT
AR_LINETAXSUBTOTAL2CATEGORYID TEXT
AR_LINETAXSUBTOTAL2PERCENT NUMBER
AR_LINETAXSUBTOTAL2TAXABLEAMOUNT NUMBER
AR_LINETAXSUBTOTAL2TAXAMOUNT NUMBER
AR_LINETAXSUBTOTAL3SCHEMEID TEXT
AR_LINETAXSUBTOTAL3CATEGORYID TEXT
AR_LINETAXSUBTOTAL3PERCENT NUMBER
AR_LINETAXSUBTOTAL3TAXABLEAMOUNT NUMBER
AR_LINETAXSUBTOTAL3TAXAMOUNT NUMBER
AR_LINETAXSUBTOTAL4SCHEMEID TEXT
AR_LINETAXSUBTOTAL4CATEGORYID TEXT
AR_LINETAXSUBTOTAL4PERCENT NUMBER
AR_LINETAXSUBTOTAL4TAXABLEAMOUNT NUMBER
AR_LINETAXSUBTOTAL4TAXAMOUNT NUMBER
AR_LINETAXSUBTOTAL5SCHEMEID TEXT
AR_LINETAXSUBTOTAL5CATEGORYID TEXT
AR_LINETAXSUBTOTAL5PERCENT NUMBER
AR_LINETAXSUBTOTAL5TAXABLEAMOUNT NUMBER
AR_LINETAXSUBTOTAL5TAXAMOUNT NUMBER
AR_LINETAXSUBTOTAL6SCHEMEID TEXT
AR_LINETAXSUBTOTAL6CATEGORYID TEXT
AR_LINETAXSUBTOTAL6PERCENT NUMBER
AR_LINETAXSUBTOTAL6TAXABLEAMOUNT NUMBER
AR_LINETAXSUBTOTAL6TAXAMOUNT NUMBER
AR_LINETAXSUBTOTAL7SCHEMEID TEXT
AR_LINETAXSUBTOTAL7CATEGORYID TEXT
AR_LINETAXSUBTOTAL7PERCENT NUMBER
AR_LINETAXSUBTOTAL7TAXABLEAMOUNT NUMBER
AR_LINETAXSUBTOTAL7TAXAMOUNT NUMBER
AR_LINETAXSUBTOTAL8SCHEMEID TEXT
AR_LINETAXSUBTOTAL8CATEGORYID TEXT
AR_LINETAXSUBTOTAL8PERCENT NUMBER
AR_LINETAXSUBTOTAL8TAXABLEAMOUNT NUMBER
AR_LINETAXSUBTOTAL8TAXAMOUNT NUMBER
AR_LINETAXSUBTOTAL9SCHEMEID TEXT
AR_LINETAXSUBTOTAL9CATEGORYID TEXT
AR_LINETAXSUBTOTAL9PERCENT NUMBER
AR_LINETAXSUBTOTAL9TAXABLEAMOUNT NUMBER
AR_LINETAXSUBTOTAL9TAXAMOUNT NUMBER
AR_LINETAXSUBTOTAL10SCHEMEID TEXT
AR_LINETAXSUBTOTAL10CATEGORYID TEXT
AR_LINETAXSUBTOTAL10PERCENT NUMBER
AR_LINETAXSUBTOTAL10TAXABLEAMOUNT NUMBER
AR_LINETAXSUBTOTAL10TAXAMOUNT NUMBER
AR_LINETAXSUBTOTALALLSCHEMEIDS TEXT
AR_LINETAXSUBTOTALALLCATEGORYIDS TEXT
AR_LINETAXSUBTOTALALLPERCENTS TEXT
AR_LINETAXSUBTOTALALLTAXABLEAMOUNTS TEXT
AR_LINETAXSUBTOTALALLTAXAMOUNTS TEXT
AR_TACAE TEXT
AR_TACAEEXPIRYRAW TEXT
AR_TAFERESULTADO TEXT
AR_TAERRORCODE TEXT
AR_TAERRORMSG TEXT
AR_ITEMRAW VARIANT
AR_PRICERAW VARIANT
AR_LINERAW VARIANT

CN_AR_INVOICES (223 columns)

Column Type
INVOICEID TEXT
INVOICEUUID TEXT
DOCUMENTUUID TEXT
SENDERDOCUMENTID TEXT
ISSUEDATE DATE
ISSUETIME TEXT
DUEDATE DATE
PAYMENTDUEDATE DATE
ORDERREFERENCEID TEXT
SUPPLIERNAME TEXT
SUPPLIERLEGALNAME TEXT
SUPPLIERTAXID TEXT
SUPPLIERTAXSCHEMEID TEXT
SUPPLIERCITY TEXT
SUPPLIERCOUNTRYCODE TEXT
SUPPLIERADDRESSLINE TEXT
SENDERIDENTIFIER TEXT
SENDERAUTHORITY TEXT
CUSTOMERNAME TEXT
CUSTOMERLEGALNAME TEXT
CUSTOMERTAXID TEXT
CUSTOMERTAXSCHEMEID TEXT
CUSTOMERCITY TEXT
CUSTOMERCOUNTRYCODE TEXT
CUSTOMERBUYERCONTACTID TEXT
RECEIVERIDENTIFIER TEXT
TAXEXCLUSIVEAMOUNT NUMBER
TOTALTAXAMOUNT NUMBER
TAXINCLUSIVEAMOUNT NUMBER
PAYABLEAMOUNT NUMBER
PAYABLECURRENCY TEXT
DOCUMENTCURRENCYCODE TEXT
EXCHANGERATE NUMBER
SOURCECURRENCY TEXT
TARGETCURRENCY TEXT
DOCUMENTSTATUS TEXT
STATUSMESSAGE TEXT
DOCUMENTTYPE TEXT
INVOICETYPECODE TEXT
PROCESSTYPE TEXT
CATEGORY TEXT
COUNTRY TEXT
CREATIONDATETIME TIMESTAMP_NTZ
SENDERSYSTEMID TEXT
LINECOUNT NUMBER
PRODUCT TEXT
COMPANYCODE TEXT
RAWDOCUMENT VARIANT
LOADEDAT TIMESTAMP_NTZ
LEGALEXTENSIONRAW VARIANT
INJECTIONSRAW VARIANT
COMPANYID TEXT
AR_ADDDOCREF1ID TEXT
AR_ADDDOCREF1SCHEMEID TEXT
AR_ADDDOCREF1DESCRIPTION TEXT
AR_ADDDOCREF1STATUSCODE TEXT
AR_ADDDOCREF1DOCUMENTTYPE TEXT
AR_ADDDOCREF2ID TEXT
AR_ADDDOCREF2SCHEMEID TEXT
AR_ADDDOCREF2DESCRIPTION TEXT
AR_ADDDOCREF2STATUSCODE TEXT
AR_ADDDOCREF2DOCUMENTTYPE TEXT
AR_ADDDOCREF3ID TEXT
AR_ADDDOCREF3SCHEMEID TEXT
AR_ADDDOCREF3DESCRIPTION TEXT
AR_ADDDOCREF3STATUSCODE TEXT
AR_ADDDOCREF3DOCUMENTTYPE TEXT
AR_ADDDOCREF4ID TEXT
AR_ADDDOCREF4SCHEMEID TEXT
AR_ADDDOCREF4DESCRIPTION TEXT
AR_ADDDOCREF4STATUSCODE TEXT
AR_ADDDOCREF4DOCUMENTTYPE TEXT
AR_ADDDOCREF5ID TEXT
AR_ADDDOCREF5SCHEMEID TEXT
AR_ADDDOCREF5DESCRIPTION TEXT
AR_ADDDOCREF5STATUSCODE TEXT
AR_ADDDOCREF5DOCUMENTTYPE TEXT
AR_ADDDOCREFALLIDS TEXT
AR_ADDDOCREFALLSCHEMEIDS TEXT
AR_ADDDOCREFALLDESCRIPTIONS TEXT
AR_ADDDOCREFALLSTATUSCODES TEXT
AR_ADDDOCREFALLDOCUMENTTYPES TEXT
AR_PAYMENTMEANS1CODE TEXT
AR_PAYMENTMEANS1DUEDATE TEXT
AR_PAYMENTMEANS1INSTRUCTIONNOTE TEXT
AR_PAYMENTID1VALUE TEXT
AR_PAYMENTID1SCHEMEID TEXT
AR_PAYMENTMEANS2CODE TEXT
AR_PAYMENTMEANS2DUEDATE TEXT
AR_PAYMENTMEANS2INSTRUCTIONNOTE TEXT
AR_PAYMENTID2VALUE TEXT
AR_PAYMENTID2SCHEMEID TEXT
AR_PAYMENTMEANS3CODE TEXT
AR_PAYMENTMEANS3DUEDATE TEXT
AR_PAYMENTMEANS3INSTRUCTIONNOTE TEXT
AR_PAYMENTID3VALUE TEXT
AR_PAYMENTID3SCHEMEID TEXT
AR_PAYMENTMEANS4CODE TEXT
AR_PAYMENTMEANS4DUEDATE TEXT
AR_PAYMENTMEANS4INSTRUCTIONNOTE TEXT
AR_PAYMENTID4VALUE TEXT
AR_PAYMENTID4SCHEMEID TEXT
AR_PAYMENTMEANS5CODE TEXT
AR_PAYMENTMEANS5DUEDATE TEXT
AR_PAYMENTMEANS5INSTRUCTIONNOTE TEXT
AR_PAYMENTID5VALUE TEXT
AR_PAYMENTID5SCHEMEID TEXT
AR_PAYMENTMEANSALLCODES TEXT
AR_PAYMENTMEANSALLDUEDATES TEXT
AR_PAYMENTMEANSALLINSTRUCTIONNOTES TEXT
AR_PAYMENTIDALLVALUES TEXT
AR_PAYMENTIDALLSCHEMEIDS TEXT
AR_TAXTOTAL1AMOUNT NUMBER
AR_TAXTOTAL1CURRENCY TEXT
AR_TAXTOTAL2AMOUNT NUMBER
AR_TAXTOTAL2CURRENCY TEXT
AR_TAXTOTAL3AMOUNT NUMBER
AR_TAXTOTAL3CURRENCY TEXT
AR_TAXTOTAL4AMOUNT NUMBER
AR_TAXTOTAL4CURRENCY TEXT
AR_TAXTOTAL5AMOUNT NUMBER
AR_TAXTOTAL5CURRENCY TEXT
AR_TAXTOTALALLAMOUNTS TEXT
AR_TAXTOTALALLCURRENCIES TEXT
AR_TAXSUBTOTAL1SCHEMEID TEXT
AR_TAXSUBTOTAL1CATEGORYID TEXT
AR_TAXSUBTOTAL1PERCENT NUMBER
AR_TAXSUBTOTAL1TAXABLEAMOUNT NUMBER
AR_TAXSUBTOTAL1TAXAMOUNT NUMBER
AR_TAXSUBTOTAL2SCHEMEID TEXT
AR_TAXSUBTOTAL2CATEGORYID TEXT
AR_TAXSUBTOTAL2PERCENT NUMBER
AR_TAXSUBTOTAL2TAXABLEAMOUNT NUMBER
AR_TAXSUBTOTAL2TAXAMOUNT NUMBER
AR_TAXSUBTOTAL3SCHEMEID TEXT
AR_TAXSUBTOTAL3CATEGORYID TEXT
AR_TAXSUBTOTAL3PERCENT NUMBER
AR_TAXSUBTOTAL3TAXABLEAMOUNT NUMBER
AR_TAXSUBTOTAL3TAXAMOUNT NUMBER
AR_TAXSUBTOTAL4SCHEMEID TEXT
AR_TAXSUBTOTAL4CATEGORYID TEXT
AR_TAXSUBTOTAL4PERCENT NUMBER
AR_TAXSUBTOTAL4TAXABLEAMOUNT NUMBER
AR_TAXSUBTOTAL4TAXAMOUNT NUMBER
AR_TAXSUBTOTAL5SCHEMEID TEXT
AR_TAXSUBTOTAL5CATEGORYID TEXT
AR_TAXSUBTOTAL5PERCENT NUMBER
AR_TAXSUBTOTAL5TAXABLEAMOUNT NUMBER
AR_TAXSUBTOTAL5TAXAMOUNT NUMBER
AR_TAXSUBTOTAL6SCHEMEID TEXT
AR_TAXSUBTOTAL6CATEGORYID TEXT
AR_TAXSUBTOTAL6PERCENT NUMBER
AR_TAXSUBTOTAL6TAXABLEAMOUNT NUMBER
AR_TAXSUBTOTAL6TAXAMOUNT NUMBER
AR_TAXSUBTOTAL7SCHEMEID TEXT
AR_TAXSUBTOTAL7CATEGORYID TEXT
AR_TAXSUBTOTAL7PERCENT NUMBER
AR_TAXSUBTOTAL7TAXABLEAMOUNT NUMBER
AR_TAXSUBTOTAL7TAXAMOUNT NUMBER
AR_TAXSUBTOTAL8SCHEMEID TEXT
AR_TAXSUBTOTAL8CATEGORYID TEXT
AR_TAXSUBTOTAL8PERCENT NUMBER
AR_TAXSUBTOTAL8TAXABLEAMOUNT NUMBER
AR_TAXSUBTOTAL8TAXAMOUNT NUMBER
AR_TAXSUBTOTAL9SCHEMEID TEXT
AR_TAXSUBTOTAL9CATEGORYID TEXT
AR_TAXSUBTOTAL9PERCENT NUMBER
AR_TAXSUBTOTAL9TAXABLEAMOUNT NUMBER
AR_TAXSUBTOTAL9TAXAMOUNT NUMBER
AR_TAXSUBTOTAL10SCHEMEID TEXT
AR_TAXSUBTOTAL10CATEGORYID TEXT
AR_TAXSUBTOTAL10PERCENT NUMBER
AR_TAXSUBTOTAL10TAXABLEAMOUNT NUMBER
AR_TAXSUBTOTAL10TAXAMOUNT NUMBER
AR_TAXSUBTOTALALLSCHEMEIDS TEXT
AR_TAXSUBTOTALALLCATEGORYIDS TEXT
AR_TAXSUBTOTALALLPERCENTS TEXT
AR_TAXSUBTOTALALLTAXABLEAMOUNTS TEXT
AR_TAXSUBTOTALALLTAXAMOUNTS TEXT
AR_TAFECUIT TEXT
AR_TAFEPTOVTA TEXT
AR_TAFECBTETIPO TEXT
AR_TAFEPROCESSDATE TEXT
AR_TAFERESULTADO TEXT
AR_TACBTEDESDE TEXT
AR_TACBTEHASTA TEXT
AR_TACBTEFCH TEXT
AR_TACAE TEXT
AR_TACAEEXPIRYRAW TEXT
AR_TACAEEXPIRY DATE
AR_TAERRORCODE TEXT
AR_TAERRORMSG TEXT
AR_TAEVENTCODE TEXT
AR_TAEVENTMSG TEXT
AR_TAEVENTSJSON ARRAY
AR_TAERRORSJSON ARRAY
AR_VATRECEIVERCONDITIONSID TEXT
AR_NOTE TEXT
AR_INVOICEUUID TEXT
AR_LINECOUNTNUMERIC NUMBER
AR_ADDITIONALDOCREFID TEXT
AR_ORDERREFERENCEID TEXT
AR_PAYMENTMEANSCODE TEXT
AR_PAYMENTTERMSNOTE TEXT
AR_INVOICEPERIODSTART TEXT
AR_INVOICEPERIODEND TEXT
AR_PRICINGEXCHANGESOURCECURRENCY TEXT
AR_PRICINGEXCHANGETARGETCURRENCY TEXT
AR_PRICINGEXCHANGERATE NUMBER
AR_CUSTOMERTAXID TEXT
AR_CUSTOMERNAME TEXT
AR_SUPPLIERTAXID TEXT
AR_SUPPLIERNAME TEXT
AR_ADDITIONALDOCREFRAW VARIANT
AR_ORDERREFERENCERAW VARIANT
AR_PAYMENTMEANSRAW VARIANT
AR_PAYMENTTERMSRAW VARIANT
AR_INVOICEPERIODRAW VARIANT
AR_PRICINGEXCHANGERATERAW VARIANT
AR_ACCOUNTINGCUSTOMERPARTYRAW VARIANT
AR_ACCOUNTINGSUPPLIERPARTYRAW VARIANT
AR_INVOICETAXTOTALRAW VARIANT
AR_UBLEXTENSIONSRAW VARIANT

CN_ARCHIVE_INVOICES (58 columns)

Column Type
DIRECTION TEXT
DOCUMENTID TEXT
DOCUMENTNUMBER TEXT
NATURALKEY TEXT
DOCUMENTDATE DATE
DOCUMENTTOTAL REAL
NETAMOUNT NUMBER
VATAMOUNT NUMBER
INVOICETYPE TEXT
DOCUMENTTYPE TEXT
PROCESSTYPE TEXT
CATEGORY TEXT
BUSINESSCATEGORY TEXT
INVOICEFORMAT TEXT
COUNTRY TEXT
PRODUCT TEXT
PRODUCTCATEGORYID TEXT
ORGANIZATION TEXT
ORGANIZATIONNAME TEXT
COMPANYCODE TEXT
SOURCECOMPANYID TEXT
SENDERNAME TEXT
SENDERIDENTIFIER TEXT
SENDERAUTHORITYIDENTIFIER TEXT
RECEIVERNAME TEXT
RECEIVERIDENTIFIER TEXT
RECEIVERAUTHORITYIDENTIFIER TEXT
RECEIVERCOUNTRYCODE TEXT
SENDERSYSTEMID TEXT
SENDERDOCUMENTID TEXT
CREATIONDATE DATE
UPDATEDATE DATE
ARCHIVEDAT DATE
EXPIRATIONDATE DATE
SCIRESPONSECODE TEXT
SCIRESPONSEDATE DATE
SCICLOUDSTATUSCODE TEXT
SCICLOUDSTATUSREASON TEXT
SCIGOVTSTATUSCODE TEXT
SCIGOVTSTATUSREASON TEXT
SCIACTIONSTATUSCODE TEXT
SCIACTIONSTATUSREASON TEXT
STATUSCODE TEXT
STATUSMESSAGE TEXT
STATUSSEMAPHORE NUMBER
ISFULLYPROCESSED BOOLEAN
TAXAUTHSTATUSCODE TEXT
TAXAUTHSTATUSMESSAGE TEXT
TAXAUTHKEYID TEXT
TAXAUTHUPLOADID TEXT
TAXAUTHMESSAGECOUNT NUMBER
DOCREFSEARCHKEY TEXT
DOCREFKEYCOUNT NUMBER
ATTACHMENTCOUNT NUMBER
HASLEGALDOCUMENT BOOLEAN
COMPANYID TEXT
SDAORGANIZATIONID TEXT
DATASOURCE TEXT

CN_BR_INVOICE_LINES (136 columns)

Column Type
DOCUMENTUUID TEXT
LINENUMBER NUMBER
LINEID TEXT
ITEMNAME TEXT
ITEMDESCRIPTION TEXT
INVOICEDQUANTITY NUMBER
QUANTITYUNITCODE TEXT
LINEEXTENSIONAMOUNT NUMBER
LINECURRENCY TEXT
UNITPRICE NUMBER
COUNTRY TEXT
PIPELINERUNID TEXT
LOADEDAT TIMESTAMP_NTZ
ORGANIZATIONID TEXT
COMPANYID TEXT
BR_ITEMPRICEEXTENSIONAMOUNT NUMBER
BR_LINENOTE TEXT
BR_BOARDINGAT TEXT
BR_VALIDITYAT TEXT
BR_CREDIT TEXT
BR_ALLOWANCEAMOUNT NUMBER
BR_CHARGEAMOUNT NUMBER
BR_ALLOWANCEREASON TEXT
BR_ALLOWANCEREASONCODE TEXT
BR_ALLOWANCETAXCATEGORYID TEXT
BR_IBSCBSBASETAXABLEAMOUNT NUMBER
BR_IBSCBSBASETAXTYPECODE TEXT
BR_IBSUFTAXAMOUNT NUMBER
BR_IBSUFTAXPERCENT NUMBER
BR_IBSMUNTAXAMOUNT NUMBER
BR_IBSMUNTAXPERCENT NUMBER
BR_IBSTAXAMOUNT NUMBER
BR_CBSTAXAMOUNT NUMBER
BR_CBSTAXPERCENT NUMBER
BR_COMPRAGOVIBSUFTAXAMOUNT NUMBER
BR_COMPRAGOVIBSUFTAXPERCENT NUMBER
BR_COMPRAGOVIBSMUNTAXAMOUNT NUMBER
BR_COMPRAGOVIBSMUNTAXPERCENT NUMBER
BR_COMPRAGOVCBSTAXAMOUNT NUMBER
BR_COMPRAGOVCBSTAXPERCENT NUMBER
BR_ICMSTAXAMOUNT NUMBER
BR_ICMSTAXABLEAMOUNT NUMBER
BR_ICMSTAXPERCENT NUMBER
BR_ICMSFCPTAXAMOUNT NUMBER
BR_PISTAXAMOUNT NUMBER
BR_COFINSTAXAMOUNT NUMBER
BR_FUSTTAXAMOUNT NUMBER
BR_FUNTTELTAXAMOUNT NUMBER
BR_NOICMSTAXAMOUNT NUMBER
BR_IBSUFREDUCAOTAXAMOUNT NUMBER
BR_IBSMUNREDUCAOTAXAMOUNT NUMBER
BR_CBSREDUCAOTAXAMOUNT NUMBER
BR_CBSESTORNOTAXAMOUNT NUMBER
BR_CBSDEVOLUCAOTAXAMOUNT NUMBER
BR_IBSESTORNOTAXAMOUNT NUMBER
BR_IBSUFDEVOLUCAOTAXAMOUNT NUMBER
BR_IBSMUNDEVOLUCAOTAXAMOUNT NUMBER
BR_ICMSFCPCATTAXAMOUNT NUMBER
BR_ICMSEMITAXAMOUNT NUMBER
BR_ICMSDESTTAXAMOUNT NUMBER
BR_IBSCBSBASE410TAXABLEAMOUNT NUMBER
BR_PIS06TAXAMOUNT NUMBER
BR_COFINS06TAXAMOUNT NUMBER
BR_ITEMDESCRIPTIONVALUE TEXT
BR_SELLERSITEMID TEXT
BR_ADDITIONALITEMID TEXT
BR_LINEWITHHOLDINGTAXAMOUNT NUMBER
BR_ITEMDESCRIPTION1VALUE TEXT
BR_ITEMDESCRIPTION2VALUE TEXT
BR_ITEMDESCRIPTION3VALUE TEXT
BR_ITEMDESCRIPTION4VALUE TEXT
BR_ITEMDESCRIPTION5VALUE TEXT
BR_ITEMDESCRIPTION6VALUE TEXT
BR_ITEMDESCRIPTION7VALUE TEXT
BR_ITEMDESCRIPTION8VALUE TEXT
BR_ITEMDESCRIPTION9VALUE TEXT
BR_ITEMDESCRIPTION10VALUE TEXT
BR_ITEMDESCRIPTIONALLVALUES TEXT
BR_ITEMPROPERTY1NAME TEXT
BR_ITEMPROPERTY1VALUE TEXT
BR_ITEMPROPERTY2NAME TEXT
BR_ITEMPROPERTY2VALUE TEXT
BR_ITEMPROPERTY3NAME TEXT
BR_ITEMPROPERTY3VALUE TEXT
BR_ITEMPROPERTY4NAME TEXT
BR_ITEMPROPERTY4VALUE TEXT
BR_ITEMPROPERTY5NAME TEXT
BR_ITEMPROPERTY5VALUE TEXT
BR_ITEMPROPERTY6NAME TEXT
BR_ITEMPROPERTY6VALUE TEXT
BR_ITEMPROPERTY7NAME TEXT
BR_ITEMPROPERTY7VALUE TEXT
BR_ITEMPROPERTY8NAME TEXT
BR_ITEMPROPERTY8VALUE TEXT
BR_ITEMPROPERTY9NAME TEXT
BR_ITEMPROPERTY9VALUE TEXT
BR_ITEMPROPERTY10NAME TEXT
BR_ITEMPROPERTY10VALUE TEXT
BR_ITEMPROPERTYALLNAMES TEXT
BR_ITEMPROPERTYALLVALUES TEXT
BR_LINETAXSUBTOTAL1SCHEMEID TEXT
BR_LINETAXSUBTOTAL1CATEGORYID TEXT
BR_LINETAXSUBTOTAL1PERCENT NUMBER
BR_LINETAXSUBTOTAL1TAXABLEAMOUNT NUMBER
BR_LINETAXSUBTOTAL1TAXAMOUNT NUMBER
BR_LINETAXSUBTOTAL2SCHEMEID TEXT
BR_LINETAXSUBTOTAL2CATEGORYID TEXT
BR_LINETAXSUBTOTAL2PERCENT NUMBER
BR_LINETAXSUBTOTAL2TAXABLEAMOUNT NUMBER
BR_LINETAXSUBTOTAL2TAXAMOUNT NUMBER
BR_LINETAXSUBTOTAL3SCHEMEID TEXT
BR_LINETAXSUBTOTAL3CATEGORYID TEXT
BR_LINETAXSUBTOTAL3PERCENT NUMBER
BR_LINETAXSUBTOTAL3TAXABLEAMOUNT NUMBER
BR_LINETAXSUBTOTAL3TAXAMOUNT NUMBER
BR_LINETAXSUBTOTAL4SCHEMEID TEXT
BR_LINETAXSUBTOTAL4CATEGORYID TEXT
BR_LINETAXSUBTOTAL4PERCENT NUMBER
BR_LINETAXSUBTOTAL4TAXABLEAMOUNT NUMBER
BR_LINETAXSUBTOTAL4TAXAMOUNT NUMBER
BR_LINETAXSUBTOTAL5SCHEMEID TEXT
BR_LINETAXSUBTOTAL5CATEGORYID TEXT
BR_LINETAXSUBTOTAL5PERCENT NUMBER
BR_LINETAXSUBTOTAL5TAXABLEAMOUNT NUMBER
BR_LINETAXSUBTOTAL5TAXAMOUNT NUMBER
BR_LINETAXSUBTOTALALLSCHEMEIDS TEXT
BR_LINETAXSUBTOTALALLCATEGORYIDS TEXT
BR_LINETAXSUBTOTALALLPERCENTS TEXT
BR_LINETAXSUBTOTALALLTAXABLEAMOUNTS TEXT
BR_LINETAXSUBTOTALALLTAXAMOUNTS TEXT
BR_ADDITIONALITEMIDRAW VARIANT
BR_LINEWITHHOLDINGTAXRAW VARIANT
BR_ALLOWANCECHARGERAW VARIANT
BR_TAXTOTALRAW VARIANT
BR_ITEMADDITIONALPROPERTIESRAW VARIANT
BR_LINERAW VARIANT

CN_BR_INVOICES (236 columns)

Column Type
INVOICEID TEXT
INVOICEUUID TEXT
DOCUMENTUUID TEXT
SENDERDOCUMENTID TEXT
ISSUEDATE DATE
ISSUETIME TEXT
DUEDATE DATE
PAYMENTDUEDATE DATE
ORDERREFERENCEID TEXT
SUPPLIERNAME TEXT
SUPPLIERLEGALNAME TEXT
SUPPLIERTAXID TEXT
SUPPLIERTAXSCHEMEID TEXT
SUPPLIERCITY TEXT
SUPPLIERCOUNTRYCODE TEXT
SUPPLIERADDRESSLINE TEXT
SENDERIDENTIFIER TEXT
SENDERAUTHORITY TEXT
CUSTOMERNAME TEXT
CUSTOMERLEGALNAME TEXT
CUSTOMERTAXID TEXT
CUSTOMERTAXSCHEMEID TEXT
CUSTOMERCITY TEXT
CUSTOMERCOUNTRYCODE TEXT
CUSTOMERBUYERCONTACTID TEXT
RECEIVERIDENTIFIER TEXT
TAXEXCLUSIVEAMOUNT NUMBER
TOTALTAXAMOUNT NUMBER
TAXINCLUSIVEAMOUNT NUMBER
PAYABLEAMOUNT NUMBER
PAYABLECURRENCY TEXT
DOCUMENTCURRENCYCODE TEXT
EXCHANGERATE NUMBER
SOURCECURRENCY TEXT
TARGETCURRENCY TEXT
DOCUMENTSTATUS TEXT
STATUSMESSAGE TEXT
DOCUMENTTYPE TEXT
INVOICETYPECODE TEXT
PROCESSTYPE TEXT
CATEGORY TEXT
COUNTRY TEXT
CREATIONDATETIME TIMESTAMP_NTZ
SENDERSYSTEMID TEXT
LINECOUNT NUMBER
PRODUCT TEXT
COMPANYCODE TEXT
RAWDOCUMENT VARIANT
LOADEDAT TIMESTAMP_NTZ
LEGALEXTENSIONRAW VARIANT
INJECTIONSRAW VARIANT
COMPANYID TEXT
BR_ADDDOCREF1ID TEXT
BR_ADDDOCREF1SCHEMEID TEXT
BR_ADDDOCREF1DESCRIPTION TEXT
BR_ADDDOCREF1STATUSCODE TEXT
BR_ADDDOCREF1DOCUMENTTYPE TEXT
BR_ADDDOCREF2ID TEXT
BR_ADDDOCREF2SCHEMEID TEXT
BR_ADDDOCREF2DESCRIPTION TEXT
BR_ADDDOCREF2STATUSCODE TEXT
BR_ADDDOCREF2DOCUMENTTYPE TEXT
BR_ADDDOCREF3ID TEXT
BR_ADDDOCREF3SCHEMEID TEXT
BR_ADDDOCREF3DESCRIPTION TEXT
BR_ADDDOCREF3STATUSCODE TEXT
BR_ADDDOCREF3DOCUMENTTYPE TEXT
BR_ADDDOCREF4ID TEXT
BR_ADDDOCREF4SCHEMEID TEXT
BR_ADDDOCREF4DESCRIPTION TEXT
BR_ADDDOCREF4STATUSCODE TEXT
BR_ADDDOCREF4DOCUMENTTYPE TEXT
BR_ADDDOCREF5ID TEXT
BR_ADDDOCREF5SCHEMEID TEXT
BR_ADDDOCREF5DESCRIPTION TEXT
BR_ADDDOCREF5STATUSCODE TEXT
BR_ADDDOCREF5DOCUMENTTYPE TEXT
BR_PAYMENTMEANS1CODE TEXT
BR_PAYMENTMEANS1DUEDATE TEXT
BR_PAYMENTMEANS1INSTRUCTIONNOTE TEXT
BR_PAYMENTID1VALUE TEXT
BR_PAYMENTID1SCHEMEID TEXT
BR_PAYMENTMEANS2CODE TEXT
BR_PAYMENTMEANS2DUEDATE TEXT
BR_PAYMENTMEANS2INSTRUCTIONNOTE TEXT
BR_PAYMENTID2VALUE TEXT
BR_PAYMENTID2SCHEMEID TEXT
BR_PAYMENTMEANS3CODE TEXT
BR_PAYMENTMEANS3DUEDATE TEXT
BR_PAYMENTMEANS3INSTRUCTIONNOTE TEXT
BR_PAYMENTID3VALUE TEXT
BR_PAYMENTID3SCHEMEID TEXT
BR_PAYMENTMEANS4CODE TEXT
BR_PAYMENTMEANS4DUEDATE TEXT
BR_PAYMENTMEANS4INSTRUCTIONNOTE TEXT
BR_PAYMENTID4VALUE TEXT
BR_PAYMENTID4SCHEMEID TEXT
BR_PAYMENTMEANS5CODE TEXT
BR_PAYMENTMEANS5DUEDATE TEXT
BR_PAYMENTMEANS5INSTRUCTIONNOTE TEXT
BR_PAYMENTID5VALUE TEXT
BR_PAYMENTID5SCHEMEID TEXT
BR_PAYMENTMEANSALLCODES TEXT
BR_PAYMENTMEANSALLDUEDATES TEXT
BR_PAYMENTMEANSALLINSTRUCTIONNOTES TEXT
BR_PAYMENTIDALLVALUES TEXT
BR_PAYMENTIDALLSCHEMEIDS TEXT
BR_TAXTOTAL1AMOUNT NUMBER
BR_TAXTOTAL1CURRENCY TEXT
BR_TAXTOTAL2AMOUNT NUMBER
BR_TAXTOTAL2CURRENCY TEXT
BR_TAXTOTAL3AMOUNT NUMBER
BR_TAXTOTAL3CURRENCY TEXT
BR_TAXTOTAL4AMOUNT NUMBER
BR_TAXTOTAL4CURRENCY TEXT
BR_TAXTOTAL5AMOUNT NUMBER
BR_TAXTOTAL5CURRENCY TEXT
BR_TAXTOTALALLAMOUNTS TEXT
BR_TAXTOTALALLCURRENCIES TEXT
BR_TAXSUBTOTAL1SCHEMEID TEXT
BR_TAXSUBTOTAL1CATEGORYID TEXT
BR_TAXSUBTOTAL1PERCENT NUMBER
BR_TAXSUBTOTAL1TAXABLEAMOUNT NUMBER
BR_TAXSUBTOTAL1TAXAMOUNT NUMBER
BR_TAXSUBTOTAL2SCHEMEID TEXT
BR_TAXSUBTOTAL2CATEGORYID TEXT
BR_TAXSUBTOTAL2PERCENT NUMBER
BR_TAXSUBTOTAL2TAXABLEAMOUNT NUMBER
BR_TAXSUBTOTAL2TAXAMOUNT NUMBER
BR_TAXSUBTOTAL3SCHEMEID TEXT
BR_TAXSUBTOTAL3CATEGORYID TEXT
BR_TAXSUBTOTAL3PERCENT NUMBER
BR_TAXSUBTOTAL3TAXABLEAMOUNT NUMBER
BR_TAXSUBTOTAL3TAXAMOUNT NUMBER
BR_TAXSUBTOTAL4SCHEMEID TEXT
BR_TAXSUBTOTAL4CATEGORYID TEXT
BR_TAXSUBTOTAL4PERCENT NUMBER
BR_TAXSUBTOTAL4TAXABLEAMOUNT NUMBER
BR_TAXSUBTOTAL4TAXAMOUNT NUMBER
BR_TAXSUBTOTAL5SCHEMEID TEXT
BR_TAXSUBTOTAL5CATEGORYID TEXT
BR_TAXSUBTOTAL5PERCENT NUMBER
BR_TAXSUBTOTAL5TAXABLEAMOUNT NUMBER
BR_TAXSUBTOTAL5TAXAMOUNT NUMBER
BR_TAXSUBTOTAL6SCHEMEID TEXT
BR_TAXSUBTOTAL6CATEGORYID TEXT
BR_TAXSUBTOTAL6PERCENT NUMBER
BR_TAXSUBTOTAL6TAXABLEAMOUNT NUMBER
BR_TAXSUBTOTAL6TAXAMOUNT NUMBER
BR_TAXSUBTOTAL7SCHEMEID TEXT
BR_TAXSUBTOTAL7CATEGORYID TEXT
BR_TAXSUBTOTAL7PERCENT NUMBER
BR_TAXSUBTOTAL7TAXABLEAMOUNT NUMBER
BR_TAXSUBTOTAL7TAXAMOUNT NUMBER
BR_TAXSUBTOTAL8SCHEMEID TEXT
BR_TAXSUBTOTAL8CATEGORYID TEXT
BR_TAXSUBTOTAL8PERCENT NUMBER
BR_TAXSUBTOTAL8TAXABLEAMOUNT NUMBER
BR_TAXSUBTOTAL8TAXAMOUNT NUMBER
BR_TAXSUBTOTAL9SCHEMEID TEXT
BR_TAXSUBTOTAL9CATEGORYID TEXT
BR_TAXSUBTOTAL9PERCENT NUMBER
BR_TAXSUBTOTAL9TAXABLEAMOUNT NUMBER
BR_TAXSUBTOTAL9TAXAMOUNT NUMBER
BR_TAXSUBTOTAL10SCHEMEID TEXT
BR_TAXSUBTOTAL10CATEGORYID TEXT
BR_TAXSUBTOTAL10PERCENT NUMBER
BR_TAXSUBTOTAL10TAXABLEAMOUNT NUMBER
BR_TAXSUBTOTAL10TAXAMOUNT NUMBER
BR_TAXSUBTOTALALLSCHEMEIDS TEXT
BR_TAXSUBTOTALALLCATEGORYIDS TEXT
BR_TAXSUBTOTALALLPERCENTS TEXT
BR_TAXSUBTOTALALLTAXABLEAMOUNTS TEXT
BR_TAXSUBTOTALALLTAXAMOUNTS TEXT
BR_BUYERTAXID TEXT
BR_BUYERTAXSCHEMEID TEXT
BR_BUYERNAME TEXT
BR_SELLERTAXID TEXT
BR_SELLERNAME TEXT
BR_INVOICEUUID TEXT
BR_CUSTOMIZATIONID TEXT
BR_PAYABLEALTERNATIVEAMOUNT NUMBER
BR_PAYABLEALTCURRENCY TEXT
BR_WITHHOLDINGTAXAMOUNT NUMBER
BR_PAYMENTTERMSAMOUNT TEXT
BR_AUTHORIZATIONDATE TEXT
BR_CSTAT TEXT
BR_DIGVAL TEXT
BR_DHCONT TEXT
BR_ICMSDESON TEXT
BR_NFCOMKEY TEXT
BR_NFCOMNUMBER TEXT
BR_NFCOMPROTOCOL TEXT
BR_QRCODNFCOM TEXT
BR_RECEPTIONDATE TEXT
BR_VERAPLIC TEXT
BR_XJUST TEXT
BR_XMOTIVO TEXT
BR_LEGALMOD TEXT
BR_LEGALTPAMB TEXT
BR_LEGALCNF TEXT
BR_LEGALCDV TEXT
BR_LEGALTPEMIS TEXT
BR_LEGALNROBPIATA TEXT
BR_LEGALTPCOMPRA TEXT
BR_LEGALVTROCO TEXT
BR_LEGALINFADFISCO TEXT
BR_LEGALINFCPL TEXT
BR_LEGALTAXREFORM TEXT
BR_LEGALTPFAT TEXT
BR_LEGALINDIEDEST TEXT
BR_LEGALESTABELECIMENTO TEXT
BR_LEGALSISTEMA TEXT
BR_LEGALCICLO TEXT
BR_LEGALINDCESSAOMEIOSREDE TEXT
BR_LEGALFILIAL TEXT
BR_LEGALCUF TEXT
BR_LEGALCOMPETFAT TEXT
BR_PAYMENTMEANSCODE TEXT
BR_INVOICEPERIODSTART TEXT
BR_INVOICEPERIODEND TEXT
BR_CONTRACTDOCREFID TEXT
BR_ADDITIONALDOCREFID TEXT
BR_PAYEETAXID TEXT
BR_PAYEENAME TEXT
BR_TAXREPRESENTATIVETAXID TEXT
BR_DELIVERYTERMSID TEXT
BR_PAYMENTMEANSRAW VARIANT
BR_INVOICEPERIODRAW VARIANT
BR_DELIVERYTERMSRAW VARIANT
BR_CONTRACTDOCREFRAW VARIANT
BR_TAXREPRESENTATIVERAW VARIANT
BR_PAYEEPARTYRAW VARIANT
BR_ADDITIONALDOCREFRAW VARIANT
BR_INVOICETAXTOTALRAW VARIANT
BR_UBLEXTENSIONSRAW VARIANT

CN_CANONICAL_INVOICES (52 columns)

Column Type
SOVOSURL TEXT
COUNTRY TEXT
DOCUMENTSTATUS TEXT
INVOICEID TEXT
SENDERDOCUMENTID TEXT
CREATIONDATETIME TIMESTAMP_NTZ
INVOICETYPECODE TEXT
INVOICEUUID TEXT
DOCUMENTUUID TEXT
SENDERSYSTEMID TEXT
ORDERREFERENCEID TEXT
SENDERIDENTIFIER TEXT
SENDERAUTHORITY TEXT
SUPPLIERTAXID TEXT
SUPPLIERTAXSCHEMEID TEXT
SUPPLIERNAME TEXT
SUPPLIERLEGALNAME TEXT
SUPPLIERCITY TEXT
SUPPLIERCOUNTRYCODE TEXT
SUPPLIERADDRESSLINE TEXT
RECEIVERIDENTIFIER TEXT
CUSTOMERTAXID TEXT
CUSTOMERTAXSCHEMEID TEXT
CUSTOMERNAME TEXT
CUSTOMERLEGALNAME TEXT
CUSTOMERCITY TEXT
CUSTOMERCOUNTRYCODE TEXT
CUSTOMERBUYERCONTACTID TEXT
ISSUEDATE DATE
ISSUETIME TEXT
DUEDATE DATE
PAYMENTDUEDATE DATE
LINECOUNT NUMBER
TAXEXCLUSIVEAMOUNT NUMBER
TOTALTAXAMOUNT NUMBER
TAXINCLUSIVEAMOUNT NUMBER
PAYABLEAMOUNT NUMBER
PAYABLECURRENCY TEXT
DOCUMENTCURRENCYCODE TEXT
EXCHANGERATE NUMBER
SOURCECURRENCY TEXT
TARGETCURRENCY TEXT
PRODUCT TEXT
PROCESSTYPE TEXT
DOCUMENTTYPE TEXT
CATEGORY TEXT
RAWDOCUMENT VARIANT
STATUSMESSAGE TEXT
LOADEDAT TIMESTAMP_NTZ
ORGANIZATIONID TEXT
COMPANYID TEXT
SOURCECOMPANYCODE TEXT

CN_CANONICAL_INVOICES_LINES (24 columns)

Column Type
SOVOSURL TEXT
COUNTRY TEXT
INVOICEID TEXT
DOCUMENTUUID TEXT
INVOICEUUID TEXT
INVOICETYPECODE TEXT
PROCESSTYPE TEXT
DOCUMENTTYPE TEXT
ISSUEDATE DATE
CREATIONDATETIME TIMESTAMP_NTZ
CATEGORY TEXT
LINENUMBER NUMBER
LINEID TEXT
ITEMNAME TEXT
ITEMDESCRIPTION TEXT
INVOICEDQUANTITY NUMBER
QUANTITYUNITCODE TEXT
UNITPRICE NUMBER
LINEEXTENSIONAMOUNT NUMBER
LINECURRENCY TEXT
LOADEDAT TIMESTAMP_NTZ
ORGANIZATIONID TEXT
COMPANYID TEXT
SOURCECOMPANYCODE TEXT

CN_EC_INVOICE_LINES (96 columns)

Column Type
DOCUMENTUUID TEXT
LINENUMBER NUMBER
LINEID TEXT
ITEMNAME TEXT
ITEMDESCRIPTION TEXT
INVOICEDQUANTITY NUMBER
QUANTITYUNITCODE TEXT
LINEEXTENSIONAMOUNT NUMBER
LINECURRENCY TEXT
UNITPRICE NUMBER
COUNTRY TEXT
PIPELINERUNID TEXT
LOADEDAT TIMESTAMP_NTZ
ORGANIZATIONID TEXT
COMPANYID TEXT
EC_LINEIDVALUE TEXT
EC_LINEIDSCHEMEID TEXT
EC_LINEEXTENSIONAMOUNTRAW NUMBER
EC_LINEEXTENSIONCURRENCY TEXT
EC_INVOICEDQUANTITYRAW NUMBER
EC_QUANTITYUNITCODERAW TEXT
EC_PRICEAMOUNTRAW NUMBER
EC_PRICECURRENCY TEXT
EC_ITEMPRICEEXTENSIONAMOUNT NUMBER
EC_LINEUUID TEXT
EC_ITEMDESCRIPTIONVALUE TEXT
EC_ITEMNAMEVALUE TEXT
EC_ITEMDESCRIPTION1VALUE TEXT
EC_ITEMDESCRIPTION2VALUE TEXT
EC_ITEMDESCRIPTION3VALUE TEXT
EC_ITEMDESCRIPTION4VALUE TEXT
EC_ITEMDESCRIPTION5VALUE TEXT
EC_ITEMDESCRIPTION6VALUE TEXT
EC_ITEMDESCRIPTION7VALUE TEXT
EC_ITEMDESCRIPTION8VALUE TEXT
EC_ITEMDESCRIPTION9VALUE TEXT
EC_ITEMDESCRIPTION10VALUE TEXT
EC_ITEMDESCRIPTIONALLVALUES TEXT
EC_ITEMPROPERTY1NAME TEXT
EC_ITEMPROPERTY1VALUE TEXT
EC_ITEMPROPERTY2NAME TEXT
EC_ITEMPROPERTY2VALUE TEXT
EC_ITEMPROPERTY3NAME TEXT
EC_ITEMPROPERTY3VALUE TEXT
EC_ITEMPROPERTY4NAME TEXT
EC_ITEMPROPERTY4VALUE TEXT
EC_ITEMPROPERTY5NAME TEXT
EC_ITEMPROPERTY5VALUE TEXT
EC_ITEMPROPERTY6NAME TEXT
EC_ITEMPROPERTY6VALUE TEXT
EC_ITEMPROPERTY7NAME TEXT
EC_ITEMPROPERTY7VALUE TEXT
EC_ITEMPROPERTY8NAME TEXT
EC_ITEMPROPERTY8VALUE TEXT
EC_ITEMPROPERTY9NAME TEXT
EC_ITEMPROPERTY9VALUE TEXT
EC_ITEMPROPERTY10NAME TEXT
EC_ITEMPROPERTY10VALUE TEXT
EC_ITEMPROPERTYALLNAMES TEXT
EC_ITEMPROPERTYALLVALUES TEXT
EC_LINETAXSUBTOTAL1SCHEMEID TEXT
EC_LINETAXSUBTOTAL1CATEGORYID TEXT
EC_LINETAXSUBTOTAL1PERCENT NUMBER
EC_LINETAXSUBTOTAL1TAXABLEAMOUNT NUMBER
EC_LINETAXSUBTOTAL1TAXAMOUNT NUMBER
EC_LINETAXSUBTOTAL2SCHEMEID TEXT
EC_LINETAXSUBTOTAL2CATEGORYID TEXT
EC_LINETAXSUBTOTAL2PERCENT NUMBER
EC_LINETAXSUBTOTAL2TAXABLEAMOUNT NUMBER
EC_LINETAXSUBTOTAL2TAXAMOUNT NUMBER
EC_LINETAXSUBTOTAL3SCHEMEID TEXT
EC_LINETAXSUBTOTAL3CATEGORYID TEXT
EC_LINETAXSUBTOTAL3PERCENT NUMBER
EC_LINETAXSUBTOTAL3TAXABLEAMOUNT NUMBER
EC_LINETAXSUBTOTAL3TAXAMOUNT NUMBER
EC_LINETAXSUBTOTAL4SCHEMEID TEXT
EC_LINETAXSUBTOTAL4CATEGORYID TEXT
EC_LINETAXSUBTOTAL4PERCENT NUMBER
EC_LINETAXSUBTOTAL4TAXABLEAMOUNT NUMBER
EC_LINETAXSUBTOTAL4TAXAMOUNT NUMBER
EC_LINETAXSUBTOTAL5SCHEMEID TEXT
EC_LINETAXSUBTOTAL5CATEGORYID TEXT
EC_LINETAXSUBTOTAL5PERCENT NUMBER
EC_LINETAXSUBTOTAL5TAXABLEAMOUNT NUMBER
EC_LINETAXSUBTOTAL5TAXAMOUNT NUMBER
EC_LINETAXSUBTOTALALLSCHEMEIDS TEXT
EC_LINETAXSUBTOTALALLCATEGORYIDS TEXT
EC_LINETAXSUBTOTALALLPERCENTS TEXT
EC_LINETAXSUBTOTALALLTAXABLEAMOUNTS TEXT
EC_LINETAXSUBTOTALALLTAXAMOUNTS TEXT
EC_ALLOWANCECHARGERAW VARIANT
EC_SUBINVOICELINERAW VARIANT
EC_LINENOTERAW VARIANT
EC_TAXTOTALRAW VARIANT
EC_ITEMRAW VARIANT
EC_LINERAW VARIANT

CN_EC_INVOICES (205 columns)

Column Type
INVOICEID TEXT
INVOICEUUID TEXT
DOCUMENTUUID TEXT
SENDERDOCUMENTID TEXT
ISSUEDATE DATE
ISSUETIME TEXT
DUEDATE DATE
PAYMENTDUEDATE DATE
ORDERREFERENCEID TEXT
SUPPLIERNAME TEXT
SUPPLIERLEGALNAME TEXT
SUPPLIERTAXID TEXT
SUPPLIERTAXSCHEMEID TEXT
SUPPLIERCITY TEXT
SUPPLIERCOUNTRYCODE TEXT
SUPPLIERADDRESSLINE TEXT
SENDERIDENTIFIER TEXT
SENDERAUTHORITY TEXT
CUSTOMERNAME TEXT
CUSTOMERLEGALNAME TEXT
CUSTOMERTAXID TEXT
CUSTOMERTAXSCHEMEID TEXT
CUSTOMERCITY TEXT
CUSTOMERCOUNTRYCODE TEXT
CUSTOMERBUYERCONTACTID TEXT
RECEIVERIDENTIFIER TEXT
TAXEXCLUSIVEAMOUNT NUMBER
TOTALTAXAMOUNT NUMBER
TAXINCLUSIVEAMOUNT NUMBER
PAYABLEAMOUNT NUMBER
PAYABLECURRENCY TEXT
DOCUMENTCURRENCYCODE TEXT
EXCHANGERATE NUMBER
SOURCECURRENCY TEXT
TARGETCURRENCY TEXT
DOCUMENTSTATUS TEXT
STATUSMESSAGE TEXT
DOCUMENTTYPE TEXT
INVOICETYPECODE TEXT
PROCESSTYPE TEXT
CATEGORY TEXT
COUNTRY TEXT
CREATIONDATETIME TIMESTAMP_NTZ
SENDERSYSTEMID TEXT
LINECOUNT NUMBER
PRODUCT TEXT
COMPANYCODE TEXT
RAWDOCUMENT VARIANT
LOADEDAT TIMESTAMP_NTZ
LEGALEXTENSIONRAW VARIANT
INJECTIONSRAW VARIANT
COMPANYID TEXT
EC_ADDDOCREF1ID TEXT
EC_ADDDOCREF1SCHEMEID TEXT
EC_ADDDOCREF1DESCRIPTION TEXT
EC_ADDDOCREF1STATUSCODE TEXT
EC_ADDDOCREF1DOCUMENTTYPE TEXT
EC_ADDDOCREF2ID TEXT
EC_ADDDOCREF2SCHEMEID TEXT
EC_ADDDOCREF2DESCRIPTION TEXT
EC_ADDDOCREF2STATUSCODE TEXT
EC_ADDDOCREF2DOCUMENTTYPE TEXT
EC_ADDDOCREF3ID TEXT
EC_ADDDOCREF3SCHEMEID TEXT
EC_ADDDOCREF3DESCRIPTION TEXT
EC_ADDDOCREF3STATUSCODE TEXT
EC_ADDDOCREF3DOCUMENTTYPE TEXT
EC_ADDDOCREF4ID TEXT
EC_ADDDOCREF4SCHEMEID TEXT
EC_ADDDOCREF4DESCRIPTION TEXT
EC_ADDDOCREF4STATUSCODE TEXT
EC_ADDDOCREF4DOCUMENTTYPE TEXT
EC_ADDDOCREF5ID TEXT
EC_ADDDOCREF5SCHEMEID TEXT
EC_ADDDOCREF5DESCRIPTION TEXT
EC_ADDDOCREF5STATUSCODE TEXT
EC_ADDDOCREF5DOCUMENTTYPE TEXT
EC_ADDDOCREFALLIDS TEXT
EC_ADDDOCREFALLSCHEMEIDS TEXT
EC_ADDDOCREFALLDESCRIPTIONS TEXT
EC_ADDDOCREFALLSTATUSCODES TEXT
EC_ADDDOCREFALLDOCUMENTTYPES TEXT
EC_PAYMENTMEANS1CODE TEXT
EC_PAYMENTMEANS1DUEDATE TEXT
EC_PAYMENTMEANS1INSTRUCTIONNOTE TEXT
EC_PAYMENTID1VALUE TEXT
EC_PAYMENTID1SCHEMEID TEXT
EC_PAYMENTMEANS2CODE TEXT
EC_PAYMENTMEANS2DUEDATE TEXT
EC_PAYMENTMEANS2INSTRUCTIONNOTE TEXT
EC_PAYMENTID2VALUE TEXT
EC_PAYMENTID2SCHEMEID TEXT
EC_PAYMENTMEANS3CODE TEXT
EC_PAYMENTMEANS3DUEDATE TEXT
EC_PAYMENTMEANS3INSTRUCTIONNOTE TEXT
EC_PAYMENTID3VALUE TEXT
EC_PAYMENTID3SCHEMEID TEXT
EC_PAYMENTMEANS4CODE TEXT
EC_PAYMENTMEANS4DUEDATE TEXT
EC_PAYMENTMEANS4INSTRUCTIONNOTE TEXT
EC_PAYMENTID4VALUE TEXT
EC_PAYMENTID4SCHEMEID TEXT
EC_PAYMENTMEANS5CODE TEXT
EC_PAYMENTMEANS5DUEDATE TEXT
EC_PAYMENTMEANS5INSTRUCTIONNOTE TEXT
EC_PAYMENTID5VALUE TEXT
EC_PAYMENTID5SCHEMEID TEXT
EC_PAYMENTMEANSALLCODES TEXT
EC_PAYMENTMEANSALLDUEDATES TEXT
EC_PAYMENTMEANSALLINSTRUCTIONNOTES TEXT
EC_PAYMENTIDALLVALUES TEXT
EC_PAYMENTIDALLSCHEMEIDS TEXT
EC_TAXTOTAL1AMOUNT NUMBER
EC_TAXTOTAL1CURRENCY TEXT
EC_TAXTOTAL2AMOUNT NUMBER
EC_TAXTOTAL2CURRENCY TEXT
EC_TAXTOTAL3AMOUNT NUMBER
EC_TAXTOTAL3CURRENCY TEXT
EC_TAXTOTAL4AMOUNT NUMBER
EC_TAXTOTAL4CURRENCY TEXT
EC_TAXTOTAL5AMOUNT NUMBER
EC_TAXTOTAL5CURRENCY TEXT
EC_TAXTOTALALLAMOUNTS TEXT
EC_TAXTOTALALLCURRENCIES TEXT
EC_TAXSUBTOTAL1SCHEMEID TEXT
EC_TAXSUBTOTAL1CATEGORYID TEXT
EC_TAXSUBTOTAL1PERCENT NUMBER
EC_TAXSUBTOTAL1TAXABLEAMOUNT NUMBER
EC_TAXSUBTOTAL1TAXAMOUNT NUMBER
EC_TAXSUBTOTAL2SCHEMEID TEXT
EC_TAXSUBTOTAL2CATEGORYID TEXT
EC_TAXSUBTOTAL2PERCENT NUMBER
EC_TAXSUBTOTAL2TAXABLEAMOUNT NUMBER
EC_TAXSUBTOTAL2TAXAMOUNT NUMBER
EC_TAXSUBTOTAL3SCHEMEID TEXT
EC_TAXSUBTOTAL3CATEGORYID TEXT
EC_TAXSUBTOTAL3PERCENT NUMBER
EC_TAXSUBTOTAL3TAXABLEAMOUNT NUMBER
EC_TAXSUBTOTAL3TAXAMOUNT NUMBER
EC_TAXSUBTOTAL4SCHEMEID TEXT
EC_TAXSUBTOTAL4CATEGORYID TEXT
EC_TAXSUBTOTAL4PERCENT NUMBER
EC_TAXSUBTOTAL4TAXABLEAMOUNT NUMBER
EC_TAXSUBTOTAL4TAXAMOUNT NUMBER
EC_TAXSUBTOTAL5SCHEMEID TEXT
EC_TAXSUBTOTAL5CATEGORYID TEXT
EC_TAXSUBTOTAL5PERCENT NUMBER
EC_TAXSUBTOTAL5TAXABLEAMOUNT NUMBER
EC_TAXSUBTOTAL5TAXAMOUNT NUMBER
EC_TAXSUBTOTAL6SCHEMEID TEXT
EC_TAXSUBTOTAL6CATEGORYID TEXT
EC_TAXSUBTOTAL6PERCENT NUMBER
EC_TAXSUBTOTAL6TAXABLEAMOUNT NUMBER
EC_TAXSUBTOTAL6TAXAMOUNT NUMBER
EC_TAXSUBTOTAL7SCHEMEID TEXT
EC_TAXSUBTOTAL7CATEGORYID TEXT
EC_TAXSUBTOTAL7PERCENT NUMBER
EC_TAXSUBTOTAL7TAXABLEAMOUNT NUMBER
EC_TAXSUBTOTAL7TAXAMOUNT NUMBER
EC_TAXSUBTOTAL8SCHEMEID TEXT
EC_TAXSUBTOTAL8CATEGORYID TEXT
EC_TAXSUBTOTAL8PERCENT NUMBER
EC_TAXSUBTOTAL8TAXABLEAMOUNT NUMBER
EC_TAXSUBTOTAL8TAXAMOUNT NUMBER
EC_TAXSUBTOTAL9SCHEMEID TEXT
EC_TAXSUBTOTAL9CATEGORYID TEXT
EC_TAXSUBTOTAL9PERCENT NUMBER
EC_TAXSUBTOTAL9TAXABLEAMOUNT NUMBER
EC_TAXSUBTOTAL9TAXAMOUNT NUMBER
EC_TAXSUBTOTAL10SCHEMEID TEXT
EC_TAXSUBTOTAL10CATEGORYID TEXT
EC_TAXSUBTOTAL10PERCENT NUMBER
EC_TAXSUBTOTAL10TAXABLEAMOUNT NUMBER
EC_TAXSUBTOTAL10TAXAMOUNT NUMBER
EC_TAXSUBTOTALALLSCHEMEIDS TEXT
EC_TAXSUBTOTALALLCATEGORYIDS TEXT
EC_TAXSUBTOTALALLPERCENTS TEXT
EC_TAXSUBTOTALALLTAXABLEAMOUNTS TEXT
EC_TAXSUBTOTALALLTAXAMOUNTS TEXT
EC_ACCESSKEY TEXT
EC_ESTADO TEXT
EC_STATUS TEXT
EC_ENVIRONMENT TEXT
EC_APPROVALDATE TEXT
EC_AUTHORIZATIONPROTOCOL TEXT
EC_LEGALRESPONSE TEXT
EC_PROFILEID TEXT
EC_PROFILEEXECUTIONID TEXT
EC_CUSTOMIZATIONID TEXT
EC_INVOICEUUID TEXT
EC_SUPPLIERENDPOINTID TEXT
EC_ORDERREFERENCEID TEXT
EC_RECEIPTDOCREFID TEXT
EC_PAYMENTMEANSCODE TEXT
EC_PAYMENTTERMSNOTE TEXT
EC_CUSTOMERTAXID TEXT
EC_SUPPLIERTAXID TEXT
EC_DELIVERYRAW VARIANT
EC_RECEIPTDOCREFRAW VARIANT
EC_ORDERREFERENCERAW VARIANT
EC_PAYMENTTERMSRAW VARIANT
EC_ACCOUNTINGCUSTOMERPARTYRAW VARIANT
EC_ACCOUNTINGSUPPLIERPARTYRAW VARIANT
EC_INVOICETAXTOTALRAW VARIANT
EC_UBLEXTENSIONSRAW VARIANT

CN_Invoices (81 columns)

Column Type
ORGANIZATIONID TEXT
COMPANYID TEXT
SOURCECOMPANYCODE TEXT
COUNTRY TEXT
PRODUCT TEXT
PROCESSTYPE TEXT
DOCUMENTTYPE TEXT
SOURCEFORMAT TEXT
PIPELINERUNID TEXT
LOADEDAT TIMESTAMP_NTZ
DOCUMENTUUID TEXT
INVOICEUUID TEXT
INVOICEID TEXT
SENDERDOCUMENTID TEXT
ORDERREFERENCEID TEXT
INVOICETYPECODE TEXT
DOCUMENTCURRENCYCODE TEXT
LINECOUNT NUMBER
CREATIONDATETIME TIMESTAMP_NTZ
ISSUEDATE DATE
ISSUETIME TEXT
DUEDATE DATE
PAYMENTDUEDATE DATE
SENDERSYSTEMID TEXT
SENDERIDENTIFIER TEXT
SENDERAUTHORITY TEXT
SUPPLIERTAXID TEXT
SUPPLIERTAXSCHEMEID TEXT
SUPPLIERNAME TEXT
SUPPLIERLEGALNAME TEXT
SUPPLIERCITY TEXT
SUPPLIERCOUNTRYCODE TEXT
SUPPLIERADDRESSLINE TEXT
RECEIVERIDENTIFIER TEXT
CUSTOMERTAXID TEXT
CUSTOMERTAXSCHEMEID TEXT
CUSTOMERNAME TEXT
CUSTOMERLEGALNAME TEXT
CUSTOMERCITY TEXT
CUSTOMERCOUNTRYCODE TEXT
CUSTOMERBUYERCONTACTID TEXT
TAXEXCLUSIVEAMOUNT NUMBER
TOTALTAXAMOUNT NUMBER
TAXINCLUSIVEAMOUNT NUMBER
PAYABLEAMOUNT NUMBER
PAYABLECURRENCY TEXT
EXCHANGERATE NUMBER
SOURCECURRENCY TEXT
TARGETCURRENCY TEXT
DOCUMENTSTATUS TEXT
STATUSMESSAGE TEXT
ARFECUIT TEXT
ARFEPTOVTA TEXT
ARFECBTETIPO TEXT
ARFEPROCESSDATE TEXT
ARFERESULTADO TEXT
ARCAE TEXT
ARCAEEXPIRY TEXT
AREVENTMSG TEXT
AREVENTCODE TEXT
BRBUYERTAXID TEXT
BRBUYERTAXSCHEMEID TEXT
BRBUYERNAME TEXT
BRSELLERTAXID TEXT
BRSELLERNAME TEXT
BRPAYABLEALTERNATIVEAMOUNT NUMBER
BRPAYABLEALTCURRENCY TEXT
BRWITHHOLDINGTAXAMOUNT NUMBER
BRPAYMENTTERMSAMOUNT TEXT
BRLEGALMOD TEXT
BRLEGALTPAMB TEXT
BRLEGALCNF TEXT
BRLEGALCDV TEXT
BRLEGALTPEMIS TEXT
BRLEGALNROBPIATA TEXT
BRLEGALTPCOMPRA TEXT
BRLEGALVTROCO TEXT
BRLEGALINFADFISCO TEXT
BRLEGALINFCPL TEXT
BRLEGALQRCOD TEXT
BRLEGALTAXREFORM TEXT

CN_Invoices_Lines (95 columns)

Column Type
ORGANIZATIONID TEXT
COMPANYID TEXT
SOURCECOMPANYCODE TEXT
COUNTRY TEXT
PRODUCT TEXT
PROCESSTYPE TEXT
DOCUMENTTYPE TEXT
SOURCEFORMAT TEXT
PIPELINERUNID TEXT
LOADEDAT TIMESTAMP_NTZ
DOCUMENTUUID TEXT
INVOICEUUID TEXT
INVOICEID TEXT
SENDERDOCUMENTID TEXT
ORDERREFERENCEID TEXT
INVOICETYPECODE TEXT
DOCUMENTCURRENCYCODE TEXT
LINECOUNT NUMBER
CREATIONDATETIME TIMESTAMP_NTZ
ISSUEDATE DATE
ISSUETIME TEXT
DUEDATE DATE
PAYMENTDUEDATE DATE
SENDERSYSTEMID TEXT
SENDERIDENTIFIER TEXT
SENDERAUTHORITY TEXT
SUPPLIERTAXID TEXT
SUPPLIERTAXSCHEMEID TEXT
SUPPLIERNAME TEXT
SUPPLIERLEGALNAME TEXT
SUPPLIERCITY TEXT
SUPPLIERCOUNTRYCODE TEXT
SUPPLIERADDRESSLINE TEXT
RECEIVERIDENTIFIER TEXT
CUSTOMERTAXID TEXT
CUSTOMERTAXSCHEMEID TEXT
CUSTOMERNAME TEXT
CUSTOMERLEGALNAME TEXT
CUSTOMERCITY TEXT
CUSTOMERCOUNTRYCODE TEXT
CUSTOMERBUYERCONTACTID TEXT
TAXEXCLUSIVEAMOUNT NUMBER
TOTALTAXAMOUNT NUMBER
TAXINCLUSIVEAMOUNT NUMBER
PAYABLEAMOUNT NUMBER
PAYABLECURRENCY TEXT
EXCHANGERATE NUMBER
SOURCECURRENCY TEXT
TARGETCURRENCY TEXT
DOCUMENTSTATUS TEXT
STATUSMESSAGE TEXT
LINEORGANIZATIONID TEXT
LINECOMPANYID TEXT
LINENUMBER NUMBER
LINEID TEXT
ITEMNAME TEXT
ITEMDESCRIPTION TEXT
INVOICEDQUANTITY NUMBER
QUANTITYUNITCODE TEXT
LINEEXTENSIONAMOUNT NUMBER
LINECURRENCY TEXT
UNITPRICE NUMBER
LINEPIPELINERUNID TEXT
LINELOADEDAT TIMESTAMP_NTZ
ARLINEIDVALUE TEXT
ARLINEIDSCHEMEID TEXT
ARLINEEXTENSIONAMOUNT NUMBER
ARLINEEXTENSIONCURRENCY TEXT
ARPRICEAMOUNT NUMBER
ARPRICECURRENCY TEXT
ARCAE TEXT
ARFERESULTADO TEXT
BRITEMPRICEEXTENSIONAMOUNT NUMBER
BRBOARDINGAT TEXT
BRVALIDITYAT TEXT
BRALLOWANCEAMOUNT NUMBER
BRCHARGEAMOUNT NUMBER
BRALLOWANCEREASON TEXT
BRALLOWANCEREASONCODE TEXT
BRALLOWANCETAXCATEGORYID TEXT
BRIBSCBSBASETAXABLEAMOUNT NUMBER
BRIBSCBSBASETAXTYPECODE TEXT
BRIBSUFTAXAMOUNT NUMBER
BRIBSUFTAXPERCENT NUMBER
BRIBSMUNTAXAMOUNT NUMBER
BRIBSMUNTAXPERCENT NUMBER
BRIBSTAXAMOUNT NUMBER
BRCBSTAXAMOUNT NUMBER
BRCBSTAXPERCENT NUMBER
BRCOMPRAGOVIBSUFTAXAMOUNT NUMBER
BRCOMPRAGOVIBSUFTAXPERCENT NUMBER
BRCOMPRAGOVIBSMUNTAXAMOUNT NUMBER
BRCOMPRAGOVIBSMUNTAXPERCENT NUMBER
BRCOMPRAGOVCBSTAXAMOUNT NUMBER
BRCOMPRAGOVCBSTAXPERCENT NUMBER

CN_PE_INVOICE_LINES (103 columns)

Column Type
DOCUMENTUUID TEXT
LINENUMBER NUMBER
LINEID TEXT
ITEMNAME TEXT
ITEMDESCRIPTION TEXT
INVOICEDQUANTITY NUMBER
QUANTITYUNITCODE TEXT
LINEEXTENSIONAMOUNT NUMBER
LINECURRENCY TEXT
UNITPRICE NUMBER
COUNTRY TEXT
PIPELINERUNID TEXT
LOADEDAT TIMESTAMP_NTZ
ORGANIZATIONID TEXT
COMPANYID TEXT
PE_LINEIDVALUE TEXT
PE_LINEIDSCHEMEID TEXT
PE_LINEEXTENSIONAMOUNTRAW NUMBER
PE_LINEEXTENSIONCURRENCY TEXT
PE_INVOICEDQUANTITYRAW NUMBER
PE_QUANTITYUNITCODERAW TEXT
PE_PRICEAMOUNTRAW NUMBER
PE_PRICECURRENCY TEXT
PE_PAYMENTPURPOSECODE TEXT
PE_ORDERLINEID TEXT
PE_ITEMNAMEVALUE TEXT
PE_ITEMDESCRIPTIONVALUE TEXT
PE_COMMODITYCLASSCODE TEXT
PE_SELLERSITEMID TEXT
PE_STANDARDITEMID TEXT
PE_CLASSIFIEDTAXCATEGORYID TEXT
PE_CLASSIFIEDTAXPERCENT NUMBER
PE_TAX1000AMOUNT NUMBER
PE_TAX1000TAXABLEAMOUNT NUMBER
PE_TAX1000PERCENT NUMBER
PE_ITEMDESCRIPTION1VALUE TEXT
PE_ITEMDESCRIPTION2VALUE TEXT
PE_ITEMDESCRIPTION3VALUE TEXT
PE_ITEMDESCRIPTION4VALUE TEXT
PE_ITEMDESCRIPTION5VALUE TEXT
PE_ITEMDESCRIPTION6VALUE TEXT
PE_ITEMDESCRIPTION7VALUE TEXT
PE_ITEMDESCRIPTION8VALUE TEXT
PE_ITEMDESCRIPTION9VALUE TEXT
PE_ITEMDESCRIPTION10VALUE TEXT
PE_ITEMDESCRIPTIONALLVALUES TEXT
PE_ITEMPROPERTY1NAME TEXT
PE_ITEMPROPERTY1VALUE TEXT
PE_ITEMPROPERTY2NAME TEXT
PE_ITEMPROPERTY2VALUE TEXT
PE_ITEMPROPERTY3NAME TEXT
PE_ITEMPROPERTY3VALUE TEXT
PE_ITEMPROPERTY4NAME TEXT
PE_ITEMPROPERTY4VALUE TEXT
PE_ITEMPROPERTY5NAME TEXT
PE_ITEMPROPERTY5VALUE TEXT
PE_ITEMPROPERTY6NAME TEXT
PE_ITEMPROPERTY6VALUE TEXT
PE_ITEMPROPERTY7NAME TEXT
PE_ITEMPROPERTY7VALUE TEXT
PE_ITEMPROPERTY8NAME TEXT
PE_ITEMPROPERTY8VALUE TEXT
PE_ITEMPROPERTY9NAME TEXT
PE_ITEMPROPERTY9VALUE TEXT
PE_ITEMPROPERTY10NAME TEXT
PE_ITEMPROPERTY10VALUE TEXT
PE_ITEMPROPERTYALLNAMES TEXT
PE_ITEMPROPERTYALLVALUES TEXT
PE_LINETAXSUBTOTAL1SCHEMEID TEXT
PE_LINETAXSUBTOTAL1CATEGORYID TEXT
PE_LINETAXSUBTOTAL1PERCENT NUMBER
PE_LINETAXSUBTOTAL1TAXABLEAMOUNT NUMBER
PE_LINETAXSUBTOTAL1TAXAMOUNT NUMBER
PE_LINETAXSUBTOTAL2SCHEMEID TEXT
PE_LINETAXSUBTOTAL2CATEGORYID TEXT
PE_LINETAXSUBTOTAL2PERCENT NUMBER
PE_LINETAXSUBTOTAL2TAXABLEAMOUNT NUMBER
PE_LINETAXSUBTOTAL2TAXAMOUNT NUMBER
PE_LINETAXSUBTOTAL3SCHEMEID TEXT
PE_LINETAXSUBTOTAL3CATEGORYID TEXT
PE_LINETAXSUBTOTAL3PERCENT NUMBER
PE_LINETAXSUBTOTAL3TAXABLEAMOUNT NUMBER
PE_LINETAXSUBTOTAL3TAXAMOUNT NUMBER
PE_LINETAXSUBTOTAL4SCHEMEID TEXT
PE_LINETAXSUBTOTAL4CATEGORYID TEXT
PE_LINETAXSUBTOTAL4PERCENT NUMBER
PE_LINETAXSUBTOTAL4TAXABLEAMOUNT NUMBER
PE_LINETAXSUBTOTAL4TAXAMOUNT NUMBER
PE_LINETAXSUBTOTAL5SCHEMEID TEXT
PE_LINETAXSUBTOTAL5CATEGORYID TEXT
PE_LINETAXSUBTOTAL5PERCENT NUMBER
PE_LINETAXSUBTOTAL5TAXABLEAMOUNT NUMBER
PE_LINETAXSUBTOTAL5TAXAMOUNT NUMBER
PE_LINETAXSUBTOTALALLSCHEMEIDS TEXT
PE_LINETAXSUBTOTALALLCATEGORYIDS TEXT
PE_LINETAXSUBTOTALALLPERCENTS TEXT
PE_LINETAXSUBTOTALALLTAXABLEAMOUNTS TEXT
PE_LINETAXSUBTOTALALLTAXAMOUNTS TEXT
PE_PRICINGREFERENCERAW VARIANT
PE_ORDERLINEREFERENCERAW VARIANT
PE_TAXTOTALRAW VARIANT
PE_ITEMRAW VARIANT
PE_LINERAW VARIANT

CN_PE_INVOICES (215 columns)

Column Type
INVOICEID TEXT
INVOICEUUID TEXT
DOCUMENTUUID TEXT
SENDERDOCUMENTID TEXT
ISSUEDATE DATE
ISSUETIME TEXT
DUEDATE DATE
PAYMENTDUEDATE DATE
ORDERREFERENCEID TEXT
SUPPLIERNAME TEXT
SUPPLIERLEGALNAME TEXT
SUPPLIERTAXID TEXT
SUPPLIERTAXSCHEMEID TEXT
SUPPLIERCITY TEXT
SUPPLIERCOUNTRYCODE TEXT
SUPPLIERADDRESSLINE TEXT
SENDERIDENTIFIER TEXT
SENDERAUTHORITY TEXT
CUSTOMERNAME TEXT
CUSTOMERLEGALNAME TEXT
CUSTOMERTAXID TEXT
CUSTOMERTAXSCHEMEID TEXT
CUSTOMERCITY TEXT
CUSTOMERCOUNTRYCODE TEXT
CUSTOMERBUYERCONTACTID TEXT
RECEIVERIDENTIFIER TEXT
TAXEXCLUSIVEAMOUNT NUMBER
TOTALTAXAMOUNT NUMBER
TAXINCLUSIVEAMOUNT NUMBER
PAYABLEAMOUNT NUMBER
PAYABLECURRENCY TEXT
DOCUMENTCURRENCYCODE TEXT
EXCHANGERATE NUMBER
SOURCECURRENCY TEXT
TARGETCURRENCY TEXT
DOCUMENTSTATUS TEXT
STATUSMESSAGE TEXT
DOCUMENTTYPE TEXT
INVOICETYPECODE TEXT
PROCESSTYPE TEXT
CATEGORY TEXT
COUNTRY TEXT
CREATIONDATETIME TIMESTAMP_NTZ
SENDERSYSTEMID TEXT
LINECOUNT NUMBER
PRODUCT TEXT
COMPANYCODE TEXT
RAWDOCUMENT VARIANT
LOADEDAT TIMESTAMP_NTZ
LEGALEXTENSIONRAW VARIANT
INJECTIONSRAW VARIANT
COMPANYID TEXT
PE_ADDDOCREF1ID TEXT
PE_ADDDOCREF1SCHEMEID TEXT
PE_ADDDOCREF1DESCRIPTION TEXT
PE_ADDDOCREF1STATUSCODE TEXT
PE_ADDDOCREF1DOCUMENTTYPE TEXT
PE_ADDDOCREF2ID TEXT
PE_ADDDOCREF2SCHEMEID TEXT
PE_ADDDOCREF2DESCRIPTION TEXT
PE_ADDDOCREF2STATUSCODE TEXT
PE_ADDDOCREF2DOCUMENTTYPE TEXT
PE_ADDDOCREF3ID TEXT
PE_ADDDOCREF3SCHEMEID TEXT
PE_ADDDOCREF3DESCRIPTION TEXT
PE_ADDDOCREF3STATUSCODE TEXT
PE_ADDDOCREF3DOCUMENTTYPE TEXT
PE_ADDDOCREF4ID TEXT
PE_ADDDOCREF4SCHEMEID TEXT
PE_ADDDOCREF4DESCRIPTION TEXT
PE_ADDDOCREF4STATUSCODE TEXT
PE_ADDDOCREF4DOCUMENTTYPE TEXT
PE_ADDDOCREF5ID TEXT
PE_ADDDOCREF5SCHEMEID TEXT
PE_ADDDOCREF5DESCRIPTION TEXT
PE_ADDDOCREF5STATUSCODE TEXT
PE_ADDDOCREF5DOCUMENTTYPE TEXT
PE_ADDDOCREFALLIDS TEXT
PE_ADDDOCREFALLSCHEMEIDS TEXT
PE_ADDDOCREFALLDESCRIPTIONS TEXT
PE_ADDDOCREFALLSTATUSCODES TEXT
PE_ADDDOCREFALLDOCUMENTTYPES TEXT
PE_PAYMENTMEANS1CODE TEXT
PE_PAYMENTMEANS1DUEDATE TEXT
PE_PAYMENTMEANS1INSTRUCTIONNOTE TEXT
PE_PAYMENTID1VALUE TEXT
PE_PAYMENTID1SCHEMEID TEXT
PE_PAYMENTMEANS2CODE TEXT
PE_PAYMENTMEANS2DUEDATE TEXT
PE_PAYMENTMEANS2INSTRUCTIONNOTE TEXT
PE_PAYMENTID2VALUE TEXT
PE_PAYMENTID2SCHEMEID TEXT
PE_PAYMENTMEANS3CODE TEXT
PE_PAYMENTMEANS3DUEDATE TEXT
PE_PAYMENTMEANS3INSTRUCTIONNOTE TEXT
PE_PAYMENTID3VALUE TEXT
PE_PAYMENTID3SCHEMEID TEXT
PE_PAYMENTMEANS4CODE TEXT
PE_PAYMENTMEANS4DUEDATE TEXT
PE_PAYMENTMEANS4INSTRUCTIONNOTE TEXT
PE_PAYMENTID4VALUE TEXT
PE_PAYMENTID4SCHEMEID TEXT
PE_PAYMENTMEANS5CODE TEXT
PE_PAYMENTMEANS5DUEDATE TEXT
PE_PAYMENTMEANS5INSTRUCTIONNOTE TEXT
PE_PAYMENTID5VALUE TEXT
PE_PAYMENTID5SCHEMEID TEXT
PE_PAYMENTMEANSALLCODES TEXT
PE_PAYMENTMEANSALLDUEDATES TEXT
PE_PAYMENTMEANSALLINSTRUCTIONNOTES TEXT
PE_PAYMENTIDALLVALUES TEXT
PE_PAYMENTIDALLSCHEMEIDS TEXT
PE_TAXTOTAL1AMOUNT NUMBER
PE_TAXTOTAL1CURRENCY TEXT
PE_TAXTOTAL2AMOUNT NUMBER
PE_TAXTOTAL2CURRENCY TEXT
PE_TAXTOTAL3AMOUNT NUMBER
PE_TAXTOTAL3CURRENCY TEXT
PE_TAXTOTAL4AMOUNT NUMBER
PE_TAXTOTAL4CURRENCY TEXT
PE_TAXTOTAL5AMOUNT NUMBER
PE_TAXTOTAL5CURRENCY TEXT
PE_TAXTOTALALLAMOUNTS TEXT
PE_TAXTOTALALLCURRENCIES TEXT
PE_TAXSUBTOTAL1SCHEMEID TEXT
PE_TAXSUBTOTAL1CATEGORYID TEXT
PE_TAXSUBTOTAL1PERCENT NUMBER
PE_TAXSUBTOTAL1TAXABLEAMOUNT NUMBER
PE_TAXSUBTOTAL1TAXAMOUNT NUMBER
PE_TAXSUBTOTAL2SCHEMEID TEXT
PE_TAXSUBTOTAL2CATEGORYID TEXT
PE_TAXSUBTOTAL2PERCENT NUMBER
PE_TAXSUBTOTAL2TAXABLEAMOUNT NUMBER
PE_TAXSUBTOTAL2TAXAMOUNT NUMBER
PE_TAXSUBTOTAL3SCHEMEID TEXT
PE_TAXSUBTOTAL3CATEGORYID TEXT
PE_TAXSUBTOTAL3PERCENT NUMBER
PE_TAXSUBTOTAL3TAXABLEAMOUNT NUMBER
PE_TAXSUBTOTAL3TAXAMOUNT NUMBER
PE_TAXSUBTOTAL4SCHEMEID TEXT
PE_TAXSUBTOTAL4CATEGORYID TEXT
PE_TAXSUBTOTAL4PERCENT NUMBER
PE_TAXSUBTOTAL4TAXABLEAMOUNT NUMBER
PE_TAXSUBTOTAL4TAXAMOUNT NUMBER
PE_TAXSUBTOTAL5SCHEMEID TEXT
PE_TAXSUBTOTAL5CATEGORYID TEXT
PE_TAXSUBTOTAL5PERCENT NUMBER
PE_TAXSUBTOTAL5TAXABLEAMOUNT NUMBER
PE_TAXSUBTOTAL5TAXAMOUNT NUMBER
PE_TAXSUBTOTAL6SCHEMEID TEXT
PE_TAXSUBTOTAL6CATEGORYID TEXT
PE_TAXSUBTOTAL6PERCENT NUMBER
PE_TAXSUBTOTAL6TAXABLEAMOUNT NUMBER
PE_TAXSUBTOTAL6TAXAMOUNT NUMBER
PE_TAXSUBTOTAL7SCHEMEID TEXT
PE_TAXSUBTOTAL7CATEGORYID TEXT
PE_TAXSUBTOTAL7PERCENT NUMBER
PE_TAXSUBTOTAL7TAXABLEAMOUNT NUMBER
PE_TAXSUBTOTAL7TAXAMOUNT NUMBER
PE_TAXSUBTOTAL8SCHEMEID TEXT
PE_TAXSUBTOTAL8CATEGORYID TEXT
PE_TAXSUBTOTAL8PERCENT NUMBER
PE_TAXSUBTOTAL8TAXABLEAMOUNT NUMBER
PE_TAXSUBTOTAL8TAXAMOUNT NUMBER
PE_TAXSUBTOTAL9SCHEMEID TEXT
PE_TAXSUBTOTAL9CATEGORYID TEXT
PE_TAXSUBTOTAL9PERCENT NUMBER
PE_TAXSUBTOTAL9TAXABLEAMOUNT NUMBER
PE_TAXSUBTOTAL9TAXAMOUNT NUMBER
PE_TAXSUBTOTAL10SCHEMEID TEXT
PE_TAXSUBTOTAL10CATEGORYID TEXT
PE_TAXSUBTOTAL10PERCENT NUMBER
PE_TAXSUBTOTAL10TAXABLEAMOUNT NUMBER
PE_TAXSUBTOTAL10TAXAMOUNT NUMBER
PE_TAXSUBTOTALALLSCHEMEIDS TEXT
PE_TAXSUBTOTALALLCATEGORYIDS TEXT
PE_TAXSUBTOTALALLPERCENTS TEXT
PE_TAXSUBTOTALALLTAXABLEAMOUNTS TEXT
PE_TAXSUBTOTALALLTAXAMOUNTS TEXT
PE_INJECTIONID TEXT
PE_INJECTIONISSUEDATE TEXT
PE_INJECTIONISSUETIME TEXT
PE_RESPONSEDATE TEXT
PE_RESPONSETIME TEXT
PE_SERIECORRELATIVE TEXT
PE_EXTREFERENCEDH TEXT
PE_INJECTIONNA TEXT
PE_UBLVERSIONID TEXT
PE_NOTE TEXT
PE_PROFILEEXECUTIONID TEXT
PE_CUSTOMIZATIONID TEXT
PE_INVOICEUUID TEXT
PE_ADDITIONALDOCREFID TEXT
PE_BILLINGREFERENCEID TEXT
PE_ORDERREFERENCEID TEXT
PE_PAYMENTMEANSCODE TEXT
PE_PAYMENTTERMSNOTE TEXT
PE_CONTRACTDOCREFID TEXT
PE_DELIVERYTERMSID TEXT
PE_BUYERTAXID TEXT
PE_BUYERNAME TEXT
PE_SUPPLIERTAXID TEXT
PE_SUPPLIERNAME TEXT
PE_ADDITIONALDOCREFRAW VARIANT
PE_BILLINGREFERENCERAW VARIANT
PE_ORDERREFERENCERAW VARIANT
PE_DELIVERYTERMSRAW VARIANT
PE_DELIVERYRAW VARIANT
PE_CONTRACTDOCREFRAW VARIANT
PE_PAYMENTTERMSRAW VARIANT
PE_BUYERCUSTOMERPARTYRAW VARIANT
PE_ACCOUNTINGCUSTOMERPARTYRAW VARIANT
PE_ACCOUNTINGSUPPLIERPARTYRAW VARIANT
PE_INVOICETAXTOTALRAW VARIANT
PE_UBLEXTENSIONSRAW VARIANT

Last updated: July 24, 2026