/TMF/D_RZ_AUX - Details of Auxiliary Ledger

Details of Auxiliary Ledger information is stored in SAP table /TMF/D_RZ_AUX.
It is part of development package /TMF/CTR in software component FIN-TMF-BR. This development package consists of objects that can be grouped under "Tax Management Framework Brazil: Central Tax Repository".

Fields for table /TMF/D_RZ_AUX

Field Name
Description
Is Key
Data Element
Data Type
Length
Check Table
MANDTClientXMANDTCLNT6
EMPRESACompany CodeX/TMF/DE_EMPRESACHAR8
NAT_SUB_CNTNature of Correlated SubaccountX/TMF/DE_NAT_SUB_CNTCHAR4
COD_SUB_CNTCode of sub-account related to itemX/TMF/DE_COD_SUB_CNTCHAR40
COD_CCUSCost CenterX/TMF/DE_COD_CCUS_20CHAR40
COD_PATR_ITEMItem codeX/TMF/DE_COD_PATR_ITEMCHAR20
NR_LCTOPosting numberX/TMF/DE_NR_LACTOCHAR40
NR_ITEMItem NumberX/TMF/DE_NUM_ITEMCHAR6
IDENT_ITEMGoods codeX/TMF/DE_IDENT_ITEMCHAR60
CNPJ_INVTDCNPJ/TMF/DE_CNPJCHAR28
QTDAmount/TMF/DE_QTDDEC13
DESCR_ITEMItem description/TMF/DE_DESCR_ITEM_50CHAR100
DATA_RECT_INIInitial Date/TMF/DE_DT_INI_CHCHAR16
SLD_ITEM_INICity Added Value/TMF/DE_VALORDEC13
IND_SLD_ITEM_INIIndicator of initial balance/TMF/DE_IND_SLD_ITEM_INICHAR2
REAL_ITEMCity Added Value/TMF/DE_VALORDEC13
IND_REAL_ITEMBalance indicator/TMF/DE_IND_SLD_ITEMCHAR2
SLD_ITEM_FINCity Added Value/TMF/DE_VALORDEC13
IND_SLD_ITEM_FINBalance indicator/TMF/DE_IND_SLD_ITEMCHAR2
SLD_SCNT_INICity Added Value/TMF/DE_VALORDEC13
IND_SLD_SCNT_INIBalance indicator/TMF/DE_IND_SLD_ITEMCHAR2
DEB_SCNTCity Added Value/TMF/DE_VALORDEC13
CRED_SCNTCity Added Value/TMF/DE_VALORDEC13
SLD_SCNT_FINCity Added Value/TMF/DE_VALORDEC13
IND_SLD_SCNT_FINBalance indicator/TMF/DE_IND_SLD_ITEMCHAR2
DATA_LCTOPosting Date/TMF/DE_DT_LANCTOCHAR16
VLR_LCTOCity Added Value/TMF/DE_VALORDEC13
IND_VLR_LCTOInitial Balance Situation/TMF/DE_IND_SLD_INICHAR2
IND_ADOC_INIIndicator of register related to initial adoption/TMF/DE_IND_ADOC_INICHAR2
IND_DT_LANCIgnore Posting Date indicator/TMF/DE_IND_DT_LANCCHAR2
Privacy Policy