Data Dictionary Table CIF - ICMSST Re. Reas. Detail Code Key | Name | Mode | Pyme | CIF | ICMSST Re. Reas. Detail Code | Shared | Yes |
Fields Field | CIF_FILIAL | Type | Character | Size | 2 | Decimal | 0 | Title | Branch | Description | System branch | Used | No | Required | No | Browser | No | Context | Real | Ownership | View | Field Group | 033 - Branch Size | Order | 01 |
Field | CIF_CODIGO | Type | Character | Size | 5 | Decimal | 0 | Format | @! | Title | Code | Description | Code of table 5.7 | Used | Yes | Required | Yes | Browser | Yes | Context | Real | Ownership | Edit | Order | 02 |
Field | CIF_DESCRV | Type | Character | Size | 150 | Decimal | 0 | Format | @! | Title | Description | Description | Description of code | Used | Yes | Required | No | Browser | Yes | Context | Real | Ownership | Edit | Order | 03 |
Field | CIF_DTINI | Type | Date | Size | 8 | Decimal | 0 | Title | Start date | Description | Start of effective date | Used | Yes | Required | Yes | Browser | Yes | Context | Real | Ownership | Edit | Order | 04 |
Field | CIF_DTFIM | Type | Date | Size | 8 | Decimal | 0 | Title | End Date | Description | Final effective date | Used | Yes | Required | No | Browser | Yes | Context | Real | Ownership | Edit | Order | 05 |
Indexes Index | CIF | Order | 1 | Key | CIF_FILIAL + CIF_CODIGO + DTOS(CIF_DTINI) | Description | Code + Start Date | Display Search | Yes |
Table CIG - Total Reimbursement Calc. Key | Name | Mode | Pyme | CIG | Total Reimbursement Calc. | Exclusive | Yes |
Fields Field | CIG_FILIAL | Type | Character | Size | 2 | Decimal | 0 | Title | Branch | Description | System Branch | Used | No | Required | No | Browser | Yes | Context | Real | Ownership | Edit | Field Group | 033 - Branch Size | Order | 01 |
Field | CIG_PERIOD | Type | Character | Size | 6 | Decimal | 0 | Format | @! | Title | Year/Month | Description | Year/Month of Calculation | Used | Yes | Required | No | Browser | Yes | Context | Real | Ownership | Edit | Order | 02 |
Field | CIG_IDAPUR | Type | Character | Size | 36 | Decimal | 0 | Format | @! | Title | Calculation ID | Description | ID of Calculation | Used | Yes | Required | No | Browser | No | Context | Real | Ownership | View | Order | 03 |
Field | CIG_VCREDI | Type | Numeric | Size | 14 | Decimal | 2 | Format | @E 99,999,999,999.99 | Title | Val. Credit | Description | Vl. Own ICMS Credit | Used | Yes | Required | No | Browser | Yes | Context | Real | Ownership | Edit | Order | 04 |
Field | CIG_VRESSA | Type | Numeric | Size | 14 | Decimal | 2 | Format | @E 99,999,999,999.99 | Title | Reimb. Value | Description | Value of Reimbursement | Used | Yes | Required | No | Browser | Yes | Context | Real | Ownership | Edit | Order | 05 |
Field | CIG_REFECP | Type | Numeric | Size | 14 | Decimal | 2 | Format | @E 99,999,999,999.99 | Title | FC Reim. Val | Description | FECP Reimbursement Value | Used | Yes | Required | No | Browser | Yes | Context | Real | Ownership | Edit | Order | 06 |
Field | CIG_VCMPL | Type | Numeric | Size | 14 | Decimal | 2 | Format | @E 99,999,999,999.99 | Title | Complem. Val. | Description | ICMS Complement Value | Used | Yes | Required | No | Browser | Yes | Context | Real | Ownership | Edit | Order | 07 |
Field | CIG_VCMFCP | Type | Numeric | Size | 14 | Decimal | 2 | Format | @E 99,999,999,999.99 | Title | FC Comp. Val. | Description | FECP Complement Value | Used | Yes | Required | No | Browser | Yes | Context | Real | Ownership | Edit | Order | 08 |
Indexes Index | CIG | Order | 1 | Key | CIG_FILIAL + CIG_PERIOD | Description | Year/Month | Display Search | Yes |
Index | CIG | Order | 2 | Key | CIG_FILIAL + CIG_IDAPUR | Description | Calculation ID | Display Search | Yes |
Table CIH - Framework Reimb. Calc. Key | Name | Mode | Pyme | CIH | Framework Reimb. Calc. | Exclusive | Yes |
Fields Field | CIH_FILIAL | Type | Character | Size | 2 | Decimal | 0 | Title | Branch | Description | System Branch | Used | No | Required | No | Browser | Yes | Context | Real | Ownership | Edit | Field Group | 033 - Branch Size | Order | 01 |
Field | CIH_PERIOD | Type | Character | Size | 6 | Decimal | 0 | Format | @R 9999/99 | Title | Year/Month | Description | Year/Month of Calculation | Used | Yes | Required | No | Browser | Yes | Context | Real | Ownership | Edit | Order | 02 |
Field | CIH_IDAPUR | Type | Character | Size | 36 | Decimal | 0 | Format | @! | Title | Calculation ID | Description | Calculation ID | Used | Yes | Required | No | Browser | No | Context | Real | Ownership | View | Order | 03 |
Field | CIH_ENQLEG | Type | Character | Size | 5 | Decimal | 0 | Format | @! | Title | Legal Fra. | Description | Legal Framework | Used | Yes | Required | No | Browser | Yes | Context | Real | Ownership | Edit | Order | 04 |
Field | CIH_VCREDI | Type | Numeric | Size | 14 | Decimal | 2 | Format | @E 99,999,999,999.99 | Title | ICM Cred Val | Description | Own ICMS Cred Val | Used | Yes | Required | No | Browser | Yes | Context | Real | Ownership | Edit | Order | 05 |
Field | CIH_VRESSA | Type | Numeric | Size | 14 | Decimal | 2 | Format | @E 99,999,999,999.99 | Title | Reimb. Val | Description | Value of Reimbursement | Used | Yes | Required | No | Browser | Yes | Context | Real | Ownership | Edit | Order | 06 |
Field | CIH_REFECP | Type | Numeric | Size | 14 | Decimal | 2 | Format | @E 99,999,999,999.99 | Title | FCP Re. Val. | Description | FECP Reimbursement Val. | Used | Yes | Required | No | Browser | Yes | Context | Real | Ownership | Edit | Order | 07 |
Field | CIH_VCOMPL | Type | Numeric | Size | 14 | Decimal | 2 | Format | @E 99,999,999,999.99 | Title | Compl. Val. | Description | Complement Value | Used | Yes | Required | No | Browser | Yes | Context | Real | Ownership | Edit | Order | 08 |
Field | CIH_VCMFCP | Type | Numeric | Size | 14 | Decimal | 2 | Format | @E 99,999,999,999.99 | Title | FCP Com. Val. | Description | FECP Complement Val. | Used | Yes | Required | No | Browser | Yes | Context | Real | Ownership | Edit | Order | 09 |
Field | CIH_REGRA | Type | Character | Size | 2 | Decimal | 0 | Format | @! | Title | Rule | Description | Calculation Rule | Used | Yes | Required | No | Browser | Yes | Context | Real | Ownership | Edit | Order | 10 |
Indexes Index | CIH | Order | 1 | Key | CIH_FILIAL + CIH_PERIOD + CIH_ENQLEG + CIH_REGRA | Description | Year/Month + Legal Fra. + Rule | Display Search | Yes |
Index | CIH | Order | 2 | Key | CIH_FILIAL + CIH_IDAPUR | Description | Calculation ID | Display Search | Yes |
Table CII - Item Breakd. Reimb. Calc. Key | Name | Mode | Pyme | CII | Item Breakd. Reimb. Calc. | Exclusive | Yes |
Fields Field | CII_FILIAL | Type | Character | Size | 2 | Decimal | 0 | Title | Branch | Description | System Branch | Used | No | Required | No | Browser | Yes | Context | Real | Ownership | Edit | Field Group | 033 - Branch Size | Order | 01 |
Field | CII_PERIOD | Type | Character | Size | 6 | Decimal | 0 | Format | @R 9999/99 | Title | Year/Month | Description | Year/Month of Calculation | Used | Yes | Required | No | Browser | Yes | Context | Real | Ownership | Edit | Order | 02 |
Field | CII_LIVRO | Type | Character | Size | 1 | Decimal | 0 | Format | @! | Title | Record | Description | Tax Record Number | Used | Yes | Required | No | Browser | Yes | Context | Real | Ownership | Edit | Order | 03 |
Field | CII_IDAPUR | Type | Character | Size | 36 | Decimal | 0 | Format | @! | Title | Calculation ID | Description | Calculation ID | Used | Yes | Required | No | Browser | Yes | Context | Real | Ownership | Edit | Order | 04 |
Field | CII_NFISCA | Type | Character | Size | 9 | Decimal | 0 | Format | @! | Title | Invoice | Description | Invoice | Used | Yes | Required | No | Browser | Yes | System Val. | ExistCpo("SFT", M->CII_TPMOV + M->CII_NFISCA, 1) | Context | Real | Ownership | Edit | Order | 05 |
Field | CII_SERIE | Type | Character | Size | 3 | Decimal | 0 | Format | @! | Title | Series | Description | Invoice Series | Used | Yes | Required | No | Browser | Yes | System Val. | ExistCpo("SFT", M->CII_TPMOV + M->CII_NFISCA + M->CII_SERIE, 1) | Context | Real | Ownership | Edit | Order | 06 |
Field | CII_PARTIC | Type | Character | Size | 6 | Decimal | 0 | Format | @! | Title | Participant | Description | Participant Code | Used | Yes | Required | No | Browser | Yes | Val. System | ExistCpo("SA1") | Context | Real | Ownership | Edit | Order | 07 |
Field | CII_LOJA | Type | Character | Size | 2 | Decimal | 0 | Format | @! | Title | Store | Description | Participant's Store | Used | Yes | Required | No | Browser | Yes | Val. System | ExistCpo("SA1", M->CII_PARTIC + M->CII_LOJA) | Context | Real | Ownership | Edit | Order | 08 |
Field | CII_DTMOV | Type | Date | Size | 8 | Decimal | 0 | Title | Transact. Date | Description | Date of Transaction | Used | Yes | Required | No | Browser | Yes | Context | Real | Ownership | Edit | Order | 09 |
Field | CII_TPMOV | Type | Character | Size | 1 | Decimal | 0 | Format | @! | Title | Trans Type | Description | Type of Transaction | Used | Yes | Required | No | Browser | Yes | Context | Real | Ownership | Edit | Order | 10 |
Field | CII_ESPECI | Type | Character | Size | 5 | Decimal | 0 | Format | @! | Title | Inv Kind | Description | Invoice Kind | Used | Yes | Required | No | Browser | Yes | System Val. | EXISTCPO("SX5", "42" + M->CII_ESPECI) | Context | Real | Ownership | Edit | Order | 11 |
Field | CII_ITEM | Type | Character | Size | 4 | Decimal | 0 | Format | @! | Title | Inv Item | Description | Invoice Item | Used | Yes | Required | No | Browser | Yes | Context | Real | Ownership | Edit | Order | 12 |
Field | CII_PRODUT | Type | Character | Size | 30 | Decimal | 0 | Format | @! | Title | Product | Description | Product Code | Used | Yes | Required | No | Browser | Yes | Val. System | ExistCpo("SB1") | Context | Real | Ownership | Edit | Order | 13 |
Field | CII_CST | Type | Character | Size | 3 | Decimal | 0 | Format | @! | Title | CST | Description | CST of ICMS | Used | Yes | Required | No | Browser | Yes | Val. System | ExistCpo("SX5", "S2" + M->CII_CST) | Context | Real | Ownership | Edit | Order | 14 |
Field | CII_CFOP | Type | Character | Size | 5 | Decimal | 0 | Format | @! | Title | CFOP | Description | Oper/Provis. Tax Code | Used | Yes | Required | No | Browser | Yes | Val. System | ExistCpo("SX5", "13"+M->CII_CFOP) | Context | Real | Ownership | Edit | Order | 15 |
Field | CII_ENQLEG | Type | Character | Size | 5 | Decimal | 0 | Format | @! | Title | Legal Fra. | Description | Legal Fra. | Used | Yes | Required | No | Browser | Yes | System Val. | ExistCpo("CIF") | Context | Real | Ownership | Edit | Order | 16 |
Field | CII_QTDMOV | Type | Numeric | Size | 16 | Decimal | 6 | Format | @E 999999999,999999 | Title | Quantity | Description | Quantity of Transaction | Used | Yes | Required | No | Browser | Yes | Context | Real | Ownership | Edit | Order | 17 |
Field | CII_UNID | Type | Character | Size | 2 | Decimal | 0 | Format | @! | Title | Unit | Description | Measurement Unit | Used | Yes | Required | No | Browser | Yes | System Val. | ExistCpo("SAH") | Context | Real | Ownership | Edit | Order | 18 |
Field | CII_VUNIT | Type | Numeric | Size | 16 | Decimal | 6 | Format | @E 999999999,999999 | Title | Unit Value | Description | Unit Value | Used | Yes | Required | No | Browser | Yes | Context | Real | Ownership | Edit | Order | 19 |
Field | CII_ICMEFS | Type | Numeric | Size | 16 | Decimal | 6 | Format | @E 999999999,999999 | Title | Out Eff ICM | Description | Outflow Effective ICMS | Used | Yes | Required | No | Browser | Yes | Context | Real | Ownership | Edit | Order | 20 |
Field | CII_VUCRED | Type | Numeric | Size | 16 | Decimal | 6 | Format | @E 999,999,999.999999 | Title | Cred Unit Val | Description | ICMS Cred Unit Val | Used | Yes | Required | No | Browser | Yes | Context | Real | Ownership | Edit | Order | 21 |
Field | CII_MUBST | Type | Numeric | Size | 16 | Decimal | 6 | Format | @E 999999999,999999 | Title | Ba. Un. Avg. | Description | ST Base Unit Average | Used | Yes | Required | No | Browser | Yes | Context | Real | Ownership | Edit | Order | 22 |
Field | CII_MUVSTF | Type | Numeric | Size | 16 | Decimal | 6 | Format | @E 999999999,999999 | Title | FCP ST Avg. | Description | ST and FECP Average Value | Used | Yes | Required | No | Browser | Yes | Context | Real | Ownership | Edit | Order | 23 |
Field | CII_MUVSF | Type | Numeric | Size | 16 | Decimal | 6 | Format | @E 999999999,999999 | Title | Sto.FCP Avg. | Description | Stock FECP ST Average Value | Used | Yes | Required | No | Browser | Yes | Context | Real | Ownership | Edit | Order | 24 |
Field | CII_VUREST | Type | Numeric | Size | 16 | Decimal | 6 | Format | @E 999999999,999999 | Title | Rest. Avg. | Description | ST and FECP Rest. Avg. Val. | Used | Yes | Required | No | Browser | Yes | Context | Real | Ownership | Edit | Order | 25 |
Field | CII_VURTFC | Type | Numeric | Size | 16 | Decimal | 6 | Format | @E 999999999,999999 | Title | FCP Rest.Un. | Description | FCP Restitution Unit Val. | Used | Yes | Required | No | Browser | Yes | Context | Real | Ownership | Edit | Order | 26 |
Field | CII_VUCST | Type | Numeric | Size | 16 | Decimal | 6 | Format | @E 999999999,999999 | Title | ST.FC Compl. | Description | ST and FCP Compl. Unit. Val. | Used | Yes | Required | No | Browser | Yes | Context | Real | Ownership | Edit | Order | 27 |
Field | CII_VUCFC | Type | Numeric | Size | 16 | Decimal | 6 | Format | @E 999999999,999999 | Title | FCP Com.Unit | Description | FECP Complement Unit | Used | Yes | Required | No | Browser | Yes | Context | Real | Ownership | Edit | Order | 28 |
Field | CII_CODRES | Type | Character | Size | 1 | Decimal | 0 | Format | @! | Title | Resp. Code | Description | Responsible Party Code | Used | Yes | Required | No | Browser | Yes | Context | Real | Ownership | Edit | Order | 29 |
Field | CII_ICMEFE | Type | Numeric | Size | 16 | Decimal | 6 | Format | @E 999999999,999999 | Title | Inf Eff ICM | Description | Inflow Effective ICMS | Used | Yes | Required | No | Browser | Yes | Context | Real | Ownership | Edit | Order | 30 |
Field | CII_BURET | Type | Numeric | Size | 16 | Decimal | 6 | Format | @E 999999999,999999 | Title | Prev. Wthh.Un.B | Description | Previously Wthh. Un. B | Used | Yes | Required | No | Browser | Yes | Context | Real | Ownership | Edit | Order | 31 |
Field | CII_VURET | Type | Numeric | Size | 16 | Decimal | 6 | Format | @E 999999999,999999 | Title | FCP Pd.Un.V. | Description | Previously Paid Value | Used | Yes | Required | No | Browser | Yes | Context | Real | Ownership | Edit | Order | 32 |
Field | CII_VURFCP | Type | Numeric | Size | 16 | Decimal | 6 | Format | @E 999999999,999999 | Title | F.Pr.Pd.Un.V | Description | FECP previously paid unit value | Used | Yes | Required | No | Browser | Yes | Context | Real | Ownership | Edit | Order | 33 |
Field | CII_NUMDA | Type | Character | Size | 20 | Decimal | 0 | Format | @!! | Title | Doc Number | Description | Number of Collection | Used | Yes | Required | No | Browser | Yes | Context | Real | Ownership | Edit | Order | 34 |
Field | CII_CODDA | Type | Character | Size | 1 | Decimal | 0 | Format | @! | Title | Coll. Model | Description | Collection Model | Used | Yes | Required | No | Browser | Yes | Context | Real | Ownership | Edit | Order | 35 |
Field | CII_MUCRED | Type | Numeric | Size | 16 | Decimal | 6 | Format | @E 999999999,999999 | Title | Cred. Avg. V. | Description | ICM Credit Average Value | Used | Yes | Required | No | Browser | Yes | Context | Real | Ownership | Edit | Order | 36 |
Field | CII_QTDSLD | Type | Numeric | Size | 16 | Decimal | 6 | Format | @E 999999999,999999 | Title | Balance Qty | Description | Stock Balance Quantity | Used | Yes | Required | No | Browser | Yes | Context | Real | Ownership | Edit | Order | 37 |
Field | CII_VCREDI | Type | Numeric | Size | 16 | Decimal | 6 | Format | @E 999999999,999999 | Title | ICM Cred Val | Description | Own ICMS Cred Val | Used | Yes | Required | No | Browser | Yes | Context | Real | Ownership | Edit | Order | 38 |
Field | CII_VRESSA | Type | Numeric | Size | 16 | Decimal | 6 | Format | @E 999999999,999999 | Title | Reimb. Val. | Description | Reimbursement Value | Used | Yes | Required | No | Browser | Yes | Context | Real | Ownership | Edit | Order | 39 |
Field | CII_VREFCP | Type | Numeric | Size | 16 | Decimal | 6 | Format | @E 999999999,999999 | Title | FCP Reimb.V. | Description | FECP Reimbursement Val. | Used | Yes | Required | No | Browser | Yes | Context | Real | Ownership | Edit | Order | 40 |
Field | CII_VCMPL | Type | Numeric | Size | 16 | Decimal | 6 | Format | @E 999999999,999999 | Title | Compl. Val. | Description | Complement Value | Used | Yes | Required | No | Browser | Yes | Context | Real | Ownership | Edit | Order | 41 |
Field | CII_VCMFCP | Type | Numeric | Size | 16 | Decimal | 6 | Format | @E 999999999,999999 | Title | FCP Comp. V. | Description | FECP Complement Value | Used | Yes | Required | No | Browser | Yes | Context | Real | Ownership | Edit | Order | 42 |
Field | CII_TPREG | Type | Character | Size | 1 | Decimal | 0 | Format | @! | Title | Record Type | Description | Type of Record | Used | Yes | Required | No | Browser | No | Val. System | Belong("1") | Context | Real | Ownership | View | Order | 43 |
Field | CII_PDV | Type | Character | Size | 10 | Decimal | 0 | Format | @! | Title | PDV Number | Description | PDV Number | Used | Yes | Required | No | Browser | No | Context | Real | Ownership | Edit | Order | 44 |
Field | CII_REGRA | Type | Character | Size | 2 | Decimal | 0 | Format | @! | Title | Code | Description | Code of table 5.7 | Used | Yes | Required | No | Browser | Yes | Context | Real | Ownership | Edit | Order | 45 |
Field | CII_ORDEM | Type | Character | Size | 9 | Decimal | 0 | Format | @! | Title | Order | Description | Order | Used | Yes | Required | No | Browser | Yes | Context | Real | Ownership | Edit | Order | 46 |
Field | CII_TIPO | Type | Character | Size | 1 | Decimal | 0 | Format | @! | Title | Invoice Type | Description | Invoice Type | Used | Yes | Required | No | Browser | No | Context | Real | Ownership | Edit | Order | 47 |
Field | CII_SPED | Type | Character | Size | 1 | Decimal | 0 | Format | @! | Title | Generate SPED | Description | Define whether to Generate in SPED | Used | Yes | Required | No | Browser | No | Context | Real | Ownership | Edit | Order | 48 |
Field | CII_VUNCON | Type | Numeric | Size | 16 | Decimal | 6 | Format | @E 999999999,999999 | Title | C. Unit Val. | Description | Convention Unit Value | Used | Yes | Required | No | Browser | Yes | Context | Real | Ownership | Edit | Order | 49 |
Indexes Index | CII | Order | 1 | Key | CII_FILIAL + CII_PERIOD + CII_LIVRO + CII_TPMOV + CII_SERIE + CII_NFISCA + CII_PARTIC + CII_LOJA + CII_ITEM + CII_PRODUT | Description | Year/Month + Record + Trans Type + Series + Invoice+ Participant + Store | Display Search | Yes |
Index | CII | Order | 2 | Key | CII_FILIAL + CII_TPMOV + CII_SERIE + CII_NFISCA + CII_PARTIC + CII_LOJA + CII_ITEM + CII_PRODUT | Description | Trans Type + Series + Invoice + Participant + Store + Inv Item + Prod | Display Search | Yes |
Index | CII | Order | 3 | Key | CII_FILIAL + CII_IDAPUR | Description | Calculation ID | Display Search | Yes |
Index | CII | Order | 4 | Key | CII_FILIAL + CII_PERIOD + CII_PRODUT | Description | Year/Month + Product | Display Search | Yes |
Index | CII | Order | 5 | Key | CII_FILIAL + CII_PERIOD + CII_ENQLEG + CII_REGRA | Description | Year/Month + Legal Fram. + Code | Display Search | Yes |
Table CIJ - Framework Header Key | Name | Mode | Pyme | CIJ | Framework Header | Exclusive | Yes |
Fields Field | CIJ_FILIAL | Type | Character | Size | 2 | Decimal | 0 | Title | Branch | Description | System Branch | Used | No | Required | No | Browser | No | Context | Real | Ownership | Edit | Field Group | 033 - Branch Size | Order | 01 |
Field | CIJ_IDTAB | Type | Character | Size | 36 | Decimal | 0 | Format | @! | Title | Table ID | Description | Unique Identifier | Used | Yes | Required | No | Browser | No | Context | Real | Ownership | View | Order | 02 |
Field | CIJ_CFOP | Type | Character | Size | 5 | Decimal | 0 | Format | @! | Title | CFOP | Description | Operation Tax Code | Used | Yes | Required | No | Browser | Yes | System Val. | ExistCpo("SX5", "13" + FWFLDGET("CIJ_CFOP")) .AND. ExistChav("CIJ", FWFLDGET("CIJ_CFOP"), 2) | Context | Real | Ownership | Edit | Stand. Query | 13 | Order | 03 |
Field | CIJ_DECFOP | Type | Character | Size | 60 | Decimal | 0 | Format | @! | Title | Description | Description | CFOP Description | Used | Yes | Required | No | Browser | No | Default Init. | IIF(!INCLUI, POSICIONE("SX5", 1, XFILIAL("SX5") + "13" + CIJ->CIJ_CFOP, "X5DESCRI()"), "") | Context | Virtual | Ownership | View | Order | 04 |
Field | CIJ_FATGER | Type | Character | Size | 1 | Decimal | 0 | Format | @! | Title | Taxable Event | Description | Taxable Event Indicator | Used | Yes | Required | No | Browser | Yes | Options | 1=Yes, 2=No | Default Init. | '2' | System Val. | Belong("12") | Context | Real | Ownership | Edit | Order | 05 |
Field | CIJ_RESSAR | Type | Character | Size | 1 | Decimal | 0 | Format | @! | Title | Reimbursement | Description | Consider f/ Reimbursement | Used | Yes | Required | No | Browser | Yes | Options | 1=Yes, 2=No | Default Init. | '1' | System Val. | Belong("12") | Context | Real | Ownership | Edit | Order | 06 |
Indexes Index | CIJ | Order | 1 | Key | CIJ_FILIAL + CIJ_IDTAB | Description | Table ID | Display Search | Yes |
Index | CIJ | Order | 2 | Key | CIJ_FILIAL + CIJ_CFOP | Description | CFOP | Display Search | Yes |
Table CIK - Item Framework Key | Name | Mode | Pyme | CIK | Item Framework | Exclusive | Yes |
Fields Field | CIK_FILIAL | Type | Character | Size | 2 | Decimal | 0 | Title | Branch | Description | System Branch | Used | No | Required | No | Browser | Yes | Context | Real | Ownership | View | Field Group | 033 - Branch Size | Order | 01 |
Field | CIK_CSTICM | Type | Character | Size | 2 | Decimal | 0 | Format | @! | Title | ICMS CST | Description | CST of ICMS | Used | Yes | Required | No | Browser | Yes | Val. System | ExistCpo("SX5", "S2" + M->CIK_CSTICM) | Context | Real | Ownership | Edit | Cons. Default | S2 | Order | 02 |
Field | CIK_DESCST | Type | Character | Size | 60 | Decimal | 0 | Format | @! | Title | Description | Description | ICMS CST Description | Used | Yes | Required | No | Browser | Yes | Default Init. | IIF(!INCLUI, POSICIONE("SX5", 1, XFILIAL("SX5") + "S2" + CIK->CIK_CSTICM, "X5DESCRI()"), "") | Context | Virtual | Ownership | View | Order | 03 |
Field | CIK_IDTAB | Type | Character | Size | 36 | Decimal | 0 | Format | @! | Title | Table ID | Description | CIJ Table Identifier | Used | Yes | Required | No | Browser | No | Context | Real | Ownership | View | Order | 04 |
Indexes Index | CIK | Order | 1 | Key | CIK_FILIAL + CIK_IDTAB + CIK_CSTICM | Description | Table ID + ICMS CST | Display Search | Yes |
Table CIL - ICMSST Re. Periodic Balance Key | Name | Mode | Pyme | CIL | ICMSST Re. Periodic Balance | Exclusive | Yes |
Fields Field | CIL_FILIAL | Type | Character | Size | 2 | Decimal | 0 | Title | Branch | Description | System Branch | Used | No | Required | No | Browser | Yes | Context | Real | Ownership | Edit | Field Group | 033 - Branch Size | Order | 01 |
Field | CIL_PERIOD | Type | Character | Size | 6 | Decimal | 0 | Format | @R 9999/99 | Title | Year/Month | Description | Year/Month of Processing | Used | Yes | Required | No | Browser | Yes | Context | Real | Ownership | Edit | Order | 02 |
Field | CIL_IDAPUR | Type | Character | Size | 36 | Decimal | 0 | Format | @! | Title | Calculation ID | Description | Calculation identifier | Used | Yes | Required | No | Browser | No | Context | Real | Ownership | Edit | Order | 03 |
Field | CIL_PRODUT | Type | Character | Size | 15 | Decimal | 0 | Format | @! | Title | Product | Description | Product Code | Used | Yes | Required | Yes | Browser | Yes | Val. System | ExistCpo("SB1") | Context | Real | Ownership | Edit | Cons. Default | SB1 | Field Group | 030 - Product Size | Order | 04 |
Field | CIL_DESPRO | Type | Character | Size | 30 | Decimal | 0 | Format | @! | Title | Product Desc. | Description | Product Description | Used | Yes | Required | No | Browser | No | Default Init. | IIF(!INCLUI, POSICIONE("SB1", 1, xFilial("SB1") + CIL->CIL_PRODUT, "B1_DESC"), "") | Context | Virtual | Ownership | View | Order | 05 |
Field | CIL_QTDSLD | Type | Numeric | Size | 16 | Decimal | 2 | Format | @E 9,999,999,999,999.99 | Title | Initial Qty | Description | Initial Balance Qty | Used | Yes | Required | No | Browser | Yes | Context | Real | Ownership | Edit | Order | 06 |
Field | CIL_QTDFIM | Type | Numeric | Size | 16 | Decimal | 2 | Format | @E 9,999,999,999,999.99 | Title | Final Qty | Description | Final Balance Qty | Used | Yes | Required | No | Browser | Yes | Context | Real | Ownership | View | Order | 07 |
Field | CIL_TPREG | Type | Character | Size | 1 | Decimal | 0 | Format | @! | Title | Record Type | Description | Type of Record | Used | Yes | Required | No | Browser | No | Options | 1=Initial Balance - Automatic;
2=Initial Balance - Manual;
3=Calculation Balance | Val. System | Belong("123") | Context | Real | Ownership | View | Order | 08 |
Field | CIL_TICM | Type | Numeric | Size | 16 | Decimal | 6 | Format | @E 999999999,999999 | Title | Ini.Tot.Val | Description | OP ICMS Initial Total Val | Used | Yes | Required | No | Browser | Yes | Context | Real | Ownership | Edit | Order | 09 |
Field | CIL_TFICM | Type | Numeric | Size | 16 | Decimal | 6 | Format | @E 999999999,999999 | Title | Fin.Tot.Val | Description | OP ICMS Final Total Val | Used | Yes | Required | No | Browser | Yes | Context | Real | Ownership | View | Order | 10 |
Field | CIL_MICM | Type | Numeric | Size | 16 | Decimal | 6 | Format | @E 999999999,999999 | Title | Ini.Avg.Val | Description | ICMS Initial Unit Avg. Val | Used | Yes | Required | No | Browser | Yes | Context | Real | Ownership | Edit | Order | 11 |
Field | CIL_MFICM | Type | Numeric | Size | 16 | Decimal | 6 | Format | @E 999999999,999999 | Title | Final Avg.Val | Description | ICMS Final Unit Avg. Val | Used | Yes | Required | No | Browser | Yes | Context | Real | Ownership | View | Order | 12 |
Field | CIL_TUST | Type | Numeric | Size | 16 | Decimal | 6 | Format | @E 999999999,999999 | Title | ST Ini.Tot. V. | Description | ST ICMS Initial Total Val | Used | Yes | Required | No | Browser | Yes | Context | Real | Ownership | Edit | Order | 13 |
Field | CIL_TFST | Type | Numeric | Size | 16 | Decimal | 6 | Format | @E 999999999,999999 | Title | ST Fin.Tot. V. | Description | ST ICMS Final Total Val | Used | Yes | Required | No | Browser | Yes | Context | Real | Ownership | View | Order | 14 |
Field | CIL_MUST | Type | Numeric | Size | 16 | Decimal | 6 | Format | @E 999999999,999999 | Title | ST Ini.Avg. V. | Description | ICMS ST Ini. Unit Avg. V. | Used | Yes | Required | No | Browser | Yes | Context | Real | Ownership | Edit | Order | 15 |
Field | CIL_MFST | Type | Numeric | Size | 16 | Decimal | 6 | Format | @E 999999999,999999 | Title | ST Fin.Avg. V. | Description | ICMS ST Fin. Unit Avg. V. | Used | Yes | Required | No | Browser | Yes | Context | Real | Ownership | View | Order | 16 |
Field | CIL_TIFC | Type | Numeric | Size | 16 | Decimal | 6 | Format | @E 999999999,999999 | Title | FC Ini.Tot. V. | Description | FECP Initial Total Val | Used | Yes | Required | No | Browser | Yes | Context | Real | Ownership | Edit | Order | 17 |
Field | CIL_TFFC | Type | Numeric | Size | 16 | Decimal | 6 | Format | @E 999999999,999999 | Title | FC Fin.Tot. V. | Description | FECP Final Total Val | Used | Yes | Required | No | Browser | Yes | Context | Real | Ownership | View | Order | 18 |
Field | CIL_MIFC | Type | Numeric | Size | 16 | Decimal | 6 | Format | @E 999999999,999999 | Title | FCP In.Avg. V | Description | FECP Initial Unit Avg. V. | Used | Yes | Required | No | Browser | Yes | Context | Real | Ownership | Edit | Order | 19 |
Field | CIL_MFFC | Type | Numeric | Size | 16 | Decimal | 6 | Format | @E 999999999,999999 | Title | FCP Fi.Avg. V | Description | FECP Final Unit Avg. V. | Used | Yes | Required | No | Browser | Yes | Context | Real | Ownership | View | Order | 20 |
Field | CIL_TIBCST | Type | Numeric | Size | 16 | Decimal | 6 | Format | @E 999999999,999999 | Title | ST CB I T V | Description | ST CB Initial Total V. | Used | Yes | Required | No | Browser | No | Context | Real | Ownership | Edit | Order | 21 |
Field | CIL_TFBCST | Type | Numeric | Size | 16 | Decimal | 6 | Format | @E 999999999,999999 | Title | ST CB F T V | Description | ICMS ST CB Final Total Val. | Used | Yes | Required | No | Browser | No | Context | Real | Ownership | View | Order | 22 |
Field | CIL_MUBCST | Type | Numeric | Size | 16 | Decimal | 6 | Format | @E 999999999,999999 | Title | ST CB I U V | Description | ST CB Initial Unit V. | Used | Yes | Required | No | Browser | No | Context | Real | Ownership | Edit | Order | 23 |
Field | CIL_MFBCST | Type | Numeric | Size | 16 | Decimal | 6 | Format | @E 999999999,999999 | Title | ST CB F U V | Description | ICMS ST CB Final Unit Val. | Used | Yes | Required | No | Browser | No | Context | Real | Ownership | View | Order | 24 |
Field | CIL_SPED | Type | Character | Size | 1 | Decimal | 0 | Format | @! | Title | SPED | Description | Define whether to generate SPED | Used | Yes | Required | No | Browser | No | Options | 1=Generate SPED; 2=Do Not Generate SPED | Context | Real | Ownership | Edit | Order | 25 |
CIL Indexes Index | CIL | Order | 1 | Key | CIL_FILIAL + CIL_PERIOD + CIL_PRODUT | Description | Year/Month + Product | Display Search | Yes |
Index | CIL | Order | 2 | Key | CIL_FILIAL + CIL_IDAPUR | Description | Calculation ID | Display Search | Yes |
Table CIM - Rules Register Key | Name | Mode | Pyme | CIM | Rules Register | Exclusive | Yes |
Fields Field | CIM_FILIAL | Type | Character | Size | 2 | Decimal | 0 | Title | Branch | Description | System Branch | Used | No | Required | No | Browser | Yes | Context | Real | Ownership | View | Field Group | 033 - Branch Size | Order | 01 |
Field | CIM_CODIGO | Type | Character | Size | 5 | Decimal | 0 | Format | @! | Title | Code | Description | Code of table 5.7 | Used | Yes | Required | Yes | Browser | Yes | Val. System | ExistCPO("CIF") | Context | Real | Ownership | Edit | Cons. Default | CIF | Order | 02 |
Field | CIM_REGRA | Type | Character | Size | 2 | Decimal | 0 | Format | @! | Title | Calc. Rule | Description | Calculation Rule | Used | Yes | Required | No | Browser | Yes | Context | Real | Ownership | Edit | Order | 03 |
Field | CIM_DESCRI | Type | Character | Size | 150 | Decimal | 0 | Format | @! | Title | Rule Descr. | Description | Rule Description | Used | Yes | Required | No | Browser | Yes | Context | Real | Ownership | Edit | Order | 04 |
Indexes Index | CIM | Order | 1 | Key | CIM_FILIAL + CIM_REGRA | Description | Calc. Rule | Display Search | Yes |
Important: The size of fields that have group may vary depending on the environment used. |
