76C: Colombia |
| Schema | Table | Prefix | Columns | Indexes | Description | Type | Report | Category |
---|
1 | 920 | F76C0003 | CR | 18 | 1 | VAT Certificates Retention - COL - 76C | Files | 76: Latin American Localization | |
2 | 920 | F76C0005 | TX | 8 | 1 | Tax Areas Relationship Setup - CO - 76C | Files | 76C: Colombia | |
3 | 920 | F76C001 | PG | 16 | 1 | General Parameters - COL - 04 | Constants Files | 76C: Colombia | |
4 | 920 | F76C0101 | V0 | 20 | 2 | A/B Tag File - COL - 76C | Transaction Files | 76: Latin American Localization | Business Data |
5 | 920 | F76C020 | PC | 12 | 1 | Person Codes Setup - COL - 00 | Files | 76C: Colombia | |
6 | 920 | F76C031A | RP | 80 | 1 | A/R Customer ledger As Of - F76C031A - COL - 04 | Balance Files | 76: Latin American Localization | |
7 | 920 | F76C034A | RZ | 115 | 2 | A/R Check Detail file As Of - COL - 03B | Balance Files | 76C: Colombia | |
8 | 920 | F76C0411 | RP | 24 | 1 | A/P Tag File - COL - 76C | Files | 76: Latin American Localization | |
9 | 920 | F76C0902 | GB | 22 | 2 | Debits and Credits T/B by object account - COL - 76C | Files | 76: Latin American Localization | |
10 | 920 | F76C0F00 | ST | 19 | 1 | DIAN Magnetic Media Setup - COL - 00 | Files | 76C: Colombia | |
11 | 920 | F76C0F01 | FH | 13 | 2 | DIAN Output Format Header - COL - 00 | Files | 76C: Colombia | |
12 | 920 | F76C0F05 | DS | 14 | 1 | DIAN MM Minor and Foreign Setup - COL - 00 | Files | 76C: Colombia | |
13 | 920 | F76C0F10 | FS | 9 | 1 | DIAN Magnetic Media Format Setup - COL - 00 | Files | 76C: Colombia | |
14 | 920 | F76C0F11 | FD | 4 | 1 | DIAN Output Format Detail - COL - 00 | Files | 76C: Colombia | |
15 | 920 | F76C1201 | AC | 10 | 1 | Adjustment By Inflation to the Cost / Deferred Charge - 76C | Master Files | 76: Latin American Localization | |
16 | 920 | F76C1202 | AD | 10 | 1 | Adjustment By Inflation Depreciation/Amortization - C - 76C | Master Files | 76: Latin American Localization | |
17 | 920 | F76C311T | RP | 6 | 2 | A/R Tag File - Recycle Recurring - COL - 03B - 76C | Files | 76: Latin American Localization | |
18 | 920 | F76C31T2 | AW | 10 | 1 | Auto-Withholding Calculated - COL - 03B | Files | 76C: Colombia | |
19 | 920 | F76C4008 | TA | 9 | 1 | Additionals Tax Areas - COL - 04 | Files | 76C: Colombia | |
20 | 920 | F76C4011 | VC | 12 | 1 | A/P Ledger Tag Table - COL - 04 | Files | 76C: Colombia | |
21 | 920 | F76C4F01 | FP | 17 | 3 | DIAN Formats File by Payment - COL - 04 | Files | 76C: Colombia | |
22 | 920 | F76C4F02 | FI | 21 | 3 | DIAN Formats File by Invoice - COL - 04 | Files | 76C: Colombia | |
23 | 920 | F76C571 | R1 | 13 | 1 | DIAN File Type 1 - COL - 04 | Transaction Files | 76C: Colombia | |
24 | 920 | F76C572 | R2 | 13 | 1 | DIAN File Type 2 (a) - COL - 04 | Transaction Files | 76C: Colombia | |
25 | 920 | F76C573 | R2 | 11 | 1 | DIAN File Type 2 (b) - COL - 04 | Transaction Files | 76C: Colombia | |
26 | 920 | F76C574 | R2 | 16 | 1 | DIAN File Type 2 (C) - COL - 04 | Transaction Files | 76C: Colombia | |
27 | 920 | F76C575 | Q1 | 50 | 8 | Work File Magnetic Media - COL - 04 | Transaction Files | 76C: Colombia | |
28 | 920 | F76C576 | PL | 2 | 1 | DIAN Flat File - COL - 04 | Transaction Files | 76C: Colombia | |
29 | 920 | F76C577 | CM | 9 | 1 | File to report - DIAN - Nit Max Minimal - COL - 04 | Master Files | 76C: Colombia | |
30 | 920 | F76C9415 | LD | 24 | 3 | Workfile for Dialy Book - COL - 09 | Files | 76C: Colombia | |
31 | 920 | F76C9F01 | SC | 18 | 4 | DIAN Setup Concept Code by Format and Account - 09 - COL | Files | 76C: Colombia | |
32 | 920 | F76C9F02 | DF | 44 | 4 | DIAN Formats by AccountID - COL - 09 | Files | 76C: Colombia | |
33 | 920 | F76C9F11 | DF | 21 | 3 | DIAN Formats File by Account Id - COL - 09 | Files | 76C: Colombia | |
34 | 920 | F76CI01 | AC | 9 | 1 | Activate Colombian Localizations - COL - 76C | Files | 76: Latin American Localization | |
35 | 920 | F76CI1 | PI | 20 | 1 | Tax Parameters - COL - 76C | Work Files | 76: Latin American Localization | |
36 | 920 | F76CI2 | AE | 13 | 1 | Economic Activity - COL - 76C | Work Files | 76: Latin American Localization | |
37 | 920 | F76CI3 | TA | 27 | 1 | Tax Areas Tag File - COL - 76C | Work Files | 76: Latin American Localization | |
38 | 920 | F76CT1 | TI | 33 | 2 | Tributary Information - COL - 76C | Work Files | 76: Latin American Localization | |
39 | 920 | F76CT2 | CT | 38 | 2 | Sales/Use/V.A.T. Tax File - COL - 76C | Work Files | 76: Latin American Localization | |
40 | 920 | F76CT3 | T3 | 3 | 1 | VAT Certificates Retention - Work File - COL - 76C | Files | 76: Latin American Localization | |
41 | 920 | F76CUI01 | GM | 16 | 2 | Account Master - Work File - COL - 76C | Work Files | 76: Latin American Localization | |
42 | 920 | F76CUI02 | TD | 63 | 1 | Tax Detail - Work File - COL - 76C | Work Files | 76C: Colombia | |
43 | 920 | F76CUI03 | GM | 16 | 1 | Account Cat. Code - Work File - COL - 76C | Work Files | 76: Latin American Localization | |
44 | 920 | F76CUI04 | TD | 66 | 3 | Tax Detail for Distribution - Work File - COL - 76C | Work Files | 76: Latin American Localization | |