1. HCM Data Loading Business Objects
  2. Example of Loading Document Records for Mexico

Example of Loading Document Records for Mexico

This example DocumentsOfRecord.dat file creates a Mexico CFDI document for a person.

It includes adding four document attachments:

  • A URL that links to the CFDI XML stored at an external location.
  • A URL that links to the CFDI PDF stored at an external location.
  • The CFDI XML file.
  • The stamped CFDI PDF file.

The zip file that is imported using the Import and Load Data task comprises:

mexico payroll cfdi documents zip file contents

METADATA|DocumentsOfRecord|PersonNumber|DocumentType|Country|DocumentCode|DocumentName|DocumentNumber|DateFrom|DateTo|IssuingCountryName|FLEX:PER_DOC_OF_RECORD_LEG_DDF|folio(PER_DOC_OF_RECORD_LEG_DDF=ORA_HRX_MX_CFDI)|uuid(PER_DOC_OF_RECORD_LEG_DDF=ORA_HRX_MX_CFDI)|satCertificateNumber(PER_DOC_OF_RECORD_LEG_DDF=ORA_HRX_MX_CFDI)|serie(PER_DOC_OF_RECORD_LEG_DDF=ORA_HRX_MX_CFDI)|stampingDate1(PER_DOC_OF_RECORD_LEG_DDF=ORA_HRX_MX_CFDI)|SourceSystemOwner|SourceSystemId
MERGE|DocumentsOfRecord|955160008176849|Mexico CFDI|Mexico|CFDI2023MAR|Mar 2023|202303|2023/03/01|2023/03/31|Mexico|ORA_HRX_MX_CFDI|4812210|112233445566778899012345456781|00001000000406258210|AB0123456789|2023-01-20T12:42:15|VISION|U0122303

METADATA|DocumentAttachment|PersonNumber|DocumentType|Country|DocumentCode|DataTypeCode|URLorTextorFileName|Title|File|URL|FileName
MERGE|DocumentAttachment|955160008176849|Mexico CFDI|Mexico|CFDI2023MAR|WEB_PAGE|https://tinyurl.com/yu7mct3d|CFDI_Mar_2023_P||https://tinyurl.com/yu7mct3d|
MERGE|DocumentAttachment|955160008176849|Mexico CFDI|Mexico|CFDI2023MAR|FILE|Sample.xml|CFDI_Mar_2023_X|Sample.xml||Sample.xml
MERGE|DocumentAttachment|955160008176849|Mexico CFDI|Mexico|CFDI2023MAR|FILE|CFDI Test.pdf|CFDI_Mar_2023_P|CFDI Test.pdf||CFDI Test.pdf
MERGE|DocumentAttachment|955160008176849|Mexico CFDI|Mexico|CFDI2023MAR|WEB_PAGE|https://tinyurl.com/35k6avw4|CFDI_Mar_2023_X||https://tinyurl.com/35k6avw4|

Related Topics