HDL to load default expense account
Hi team,
I am using the following layout to load Default Expense Account field in the worker assignment:
METADATA|WorkTerms|AssignmentNumber|DateStart|WorkerType|LegalEmployerName|PersonNumber|EffectiveStartDate|EffectiveEndDate|EffectiveLatestChange|EffectiveSequence|ActionCode|ReasonCode|DefaultExpenseAccount
MERGE|WorkTerms|ET14854|2021/11/03|E|CI&T SOFTWARE S.A.|14854|2024/12/13|4712/12/31|Y|1|IMPLEMENTATION_LINE|U_AJT|10017.2107040001.00000000.00000.0.0.0
METADATA|Assignment|DateStart|WorkerType|LegalEmployerName|AssignmentNumber|EffectiveStartDate|EffectiveEndDate|EffectiveSequence|EffectiveLatestChange|ActionCode|ReasonCode|PrimaryAssignmentFlag|DefaultExpenseAccount|WorkTermsNumber
MERGE|Assignment|2024/12/13|E|CI&T SOFTWARE S.A.|ET14854|2024/12/13|4712/12/31|1|Y|IMPLEMENTATION_LINE|U_AJT|Y|10017.2107040001.00000000.00000.0.0.0|ET14854
This is the error: The corresponding date effective record in the {PARENTNAME} for date {DATE}, action {ACTION}, and effective sequence {SEQ} is missing for the {CHILDNAME}.