| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
---|
TOP00: Foundation Environment |
1 | F0002 | Next Numbers - Automatic | 12 | NN | N001 | Next Number Range 1 | Numeric | Generic Edit | 8 | 0 |
2 | F00021 | Next Numbers by Company/Fiscal Year - Automatic | 6 | NL | N001 | Next Number Range 1 | Numeric | Generic Edit | 8 | 0 |
3 | F00023 | Distributed Next Number Table | 12 | DN | N001 | Next Number Range 1 | Numeric | Generic Edit | 8 | 0 |
TOP04: Accounts Payable |
4 | F0411X | CM Voucher Cross Reference | 1 | CM | N001 | Next Number Range 1 | Numeric | Generic Edit | 8 | 0 |
TOP09: General Accounting |
5 | F09218 | Online Consolidations Set-up File | 16 | LS | N001 | Next Number Range 1 | Numeric | Generic Edit | 8 | 0 |
6 | F092181 | Online Consolidation Detail File | 1 | LR | N001 | Next Number Range 1 | Numeric | Generic Edit | 8 | 0 |
TOP43: Procurement |
7 | F4310X | CM Purchase Order Cross Reference | 1 | CM | N001 | Next Number Range 1 | Numeric | Generic Edit | 8 | 0 |
TOP49: Transportation Management |
8 | F49160 | Document Next Number | 7 | NN | N001 | Next Number Range 1 | Numeric | Generic Edit | 8 | 0 |
9 | F49170 | Load Next Numbers | 2 | NN | N001 | Next Number Range 1 | Numeric | Generic Edit | 8 | 0 |
TOP51: Job Costing |
10 | F51002 | Job Cost Draws Next Number | 2 | GK | N001 | Next Number Range 1 | Numeric | Generic Edit | 8 | 0 |
TOP53: Change Management |
11 | F5311X | CM Change Order Cross Reference | 5 | CM | N001 | Next Number Range 1 | Numeric | Generic Edit | 8 | 0 |
TOP70: Multi-National Products |
12 | F704001 | Payment WH Info TEMP - COMM - 04 | 45 | PT | N001 | Next Number Range 1 | Numeric | Generic Edit | 8 | 0 |
13 | F704002 | Payment WH Info - COMM - 04 | 44 | PF | N001 | Next Number Range 1 | Numeric | Generic Edit | 8 | 0 |
14 | F704002P | Payment WH Info Purge - COMM - 04 | 44 | PF | N001 | Next Number Range 1 | Numeric | Generic Edit | 8 | 0 |
TOP74: EMEA Localization |
15 | F7400007 | Business Unit / Doc Type Next Number - COMM - 00 | 4 | BD | N001 | Next Number Range 1 | Numeric | Generic Edit | 8 | 0 |
TOP74R: Russia |
16 | F74R0100 | Petty Cash Transactions - RUS - 00 - 74R | 32 | PC | N001 | Next Number Range 1 | Numeric | Generic Edit | 8 | 0 |
17 | F74R012 | Cash Documents Next Number Setup - RUS - 00 | 8 | CD | N001 | Next Number Range 1 | Numeric | Generic Edit | 8 | 0 |
TOP74W: Sweden |
18 | F74W200 | A/P Payment Processing Sequence Numbers File - 74W | 9 | K0 | N001 | Next Number Range 1 | Numeric | Generic Edit | 8 | 0 |
19 | F74W203 | Debit Advice Invoice File - 74W | 10 | K3 | N001 | Next Number Range 1 | Numeric | Generic Edit | 8 | 0 |
TOP74Y: Italy |
20 | F74YUI10 | Italy Customer Detail WF - ITA - 74Y | 2 | CD | N001 | Next Number Range 1 | Numeric | Generic Edit | 8 | 0 |
21 | F74YUI11 | Italy SupplierDetail WF - ITA - 74Y | 2 | SD | N001 | Next Number Range 1 | Numeric | Generic Edit | 8 | 0 |
TOP75I: India |
22 | F75I100Q | TDS Form 26Q - WorkFile (Quarterly) | 9 | EF | N001 | Next Number Range 1 | Numeric | Generic Edit | 8 | 0 |
23 | F75I100W | TDS Form 26 - WorkFile | 9 | EF | N001 | Next Number Range 1 | Numeric | Generic Edit | 8 | 0 |
TOP76A: Argentina |
24 | F76001A | Next Number File - ARG - 03B - 76A | 6 | NC | N001 | Next Number Range 1 | Numeric | Generic Edit | 8 | 0 |
25 | F760407A | Gross Income - State Set Up - ARG - 04 - 76A | 5 | K4 | N001 | Next Number Range 1 | Numeric | Generic Edit | 8 | 0 |
26 | F76A8080 | Certificate Next Number RG 738/99- ARG - 04 - 76A | 4 | NN | N001 | Next Number Range 1 | Numeric | Generic Edit | 8 | 0 |
TOP76B: Brazil |
27 | F7601B | Nota Fiscal Header - BRA - 42 | 3 | FH | N001 | Next Number Range 1 | Numeric | Generic Edit | 8 | 0 |
28 | F76101B | Nota Fiscal - Header (Fiscal Books) - 42 | 5 | QX | N001 | Next Number Range 1 | Numeric | Generic Edit | 8 | 0 |
29 | F7611B | Nota Fiscal Detail - BRA - 42 | 3 | FD | N001 | Next Number Range 1 | Numeric | Generic Edit | 8 | 0 |
30 | F76121B | Nota Fiscal Print Message Header - Brazil - 42 | 3 | FZ | N001 | Next Number Range 1 | Numeric | Generic Edit | 8 | 0 |
31 | F7612B | Nota Fiscal Print Message - BRA - 42 | 4 | FY | N001 | Next Number Range 1 | Numeric | Generic Edit | 8 | 0 |
32 | F761BA | AS Fiscal file book - 09 | 3 | FB | N001 | Next Number Range 1 | Numeric | Generic Edit | 8 | 0 |
33 | F76B001 | Nota Fiscal Taxes Header - Brazil - 42 | 3 | TH | N001 | Next Number Range 1 | Numeric | Generic Edit | 8 | 0 |
34 | F76B011 | Nota Fiscal Taxes Detail - Brazil - 42 | 3 | TD | N001 | Next Number Range 1 | Numeric | Generic Edit | 8 | 0 |
35 | F76B012 | Nota Fiscal Detail - Tributary Situations - BRA | 3 | TS | N001 | Next Number Range 1 | Numeric | Generic Edit | 8 | 0 |
36 | F76B014 | Nota Fiscal Detail -Import - BRA - 76B | 3 | IM | N001 | Next Number Range 1 | Numeric | Generic Edit | 8 | 0 |
37 | F76B018 | Nota Fiscal Import Relationship - BRA - 76B | 3 | IR | N001 | Next Number Range 1 | Numeric | Generic Edit | 8 | 0 |
38 | F76B019 | Nota Fiscal Header -Exports - BRA - 76B | 3 | EX | N001 | Next Number Range 1 | Numeric | Generic Edit | 8 | 0 |
39 | F76B01T1 | NFe Header Tag File - 76B | 3 | FH | N001 | Next Number Range 1 | Numeric | Generic Edit | 8 | 0 |
40 | F76B01TE | NFe Header - 76B | 3 | FH | N001 | Next Number Range 1 | Numeric | Generic Edit | 8 | 0 |
41 | F76B02TE | NFe Header History - 76B | 3 | FH | N001 | Next Number Range 1 | Numeric | Generic Edit | 8 | 0 |
42 | F76B030 | NF Header PIS/COFINS Tag File - BRA - 76B | 3 | MT | N001 | Next Number Range 1 | Numeric | Generic Edit | 8 | 0 |
43 | F76B031 | NF Detail PIS/COFINS Tag File - BRA - 76B | 3 | PC | N001 | Next Number Range 1 | Numeric | Generic Edit | 8 | 0 |
44 | F76B036 | Fiscal Notes and Judicial Process Relationship - BRA - 76B | 3 | JR | N001 | Next Number Range 1 | Numeric | Generic Edit | 8 | 0 |
45 | F76B038 | Fiscal Notes and Administrative Process Relat. - BRA - 76B | 3 | AR | N001 | Next Number Range 1 | Numeric | Generic Edit | 8 | 0 |
46 | F76B0540 | Brazil Electronic Reporting Block B Worktable | 4 | BW | N001 | Next Number Range 1 | Numeric | Generic Edit | 8 | 0 |
47 | F76B0550 | Workfile Block C - BRA - 76B | 7 | BC | N001 | Next Number Range 1 | Numeric | Generic Edit | 8 | 0 |
48 | F76B0570 | Brazil Elect Rpt Block E Work table - BRA - 00 | 7 | WF | N001 | Next Number Range 1 | Numeric | Generic Edit | 8 | 0 |
49 | F76B060 | ePIS COFINS NF Worktable - BRA - 76B | 4 | NW | N001 | Next Number Range 1 | Numeric | Generic Edit | 8 | 0 |
50 | F76B0735 | Ato - Cotepe11 - Block E - Work File | 8 | WF | N001 | Next Number Range 1 | Numeric | Generic Edit | 8 | 0 |
51 | F76B1001 | Tag File F7601B Nota Fiscal Header - BRA - 76B | 3 | TH | N001 | Next Number Range 1 | Numeric | Generic Edit | 8 | 0 |
52 | F76B1010 | Tag File F7611B Nota Fiscal Detail - BRA - 76B | 3 | TD | N001 | Next Number Range 1 | Numeric | Generic Edit | 8 | 0 |
53 | F76B1020 | NFe Access Authorized Person Setup by Nota Fiscal - BRA - 76 | 3 | AP | N001 | Next Number Range 1 | Numeric | Generic Edit | 8 | 0 |
54 | F76B11TE | NFe Detail - 76B | 3 | FD | N001 | Next Number Range 1 | Numeric | Generic Edit | 8 | 0 |
55 | F76B12TE | NF-e Status Log - BRA - 76B | 4 | SL | N001 | Next Number Range 1 | Numeric | Generic Edit | 8 | 0 |
56 | F76B410C | IN86-Work Table for Services Outbound Nota Fiscal Hea - 42 | 3 | SH | N001 | Next Number Range 1 | Numeric | Generic Edit | 8 | 0 |
57 | F76B410D | IN86-Work Table for Merchandise Nota Fiscal Issued by - 42 | 3 | CH | N001 | Next Number Range 1 | Numeric | Generic Edit | 8 | 0 |
58 | F76B410E | IN86-Work Table for Merchandise NF Issued by Supplier - 41 | 3 | SH | N001 | Next Number Range 1 | Numeric | Generic Edit | 8 | 0 |
59 | F76B410H | INSS-Work Table for Services Third Party Inbound NF H - 42 | 3 | SI | N001 | Next Number Range 1 | Numeric | Generic Edit | 8 | 0 |
60 | F76B411C | IN86-Work Table for Services Outbound Nota Fiscal Det - 42 | 3 | SD | N001 | Next Number Range 1 | Numeric | Generic Edit | 8 | 0 |
61 | F76B411D | IN86-Work Table for Merchandise Nota Fiscal Issued by - 42 | 3 | CD | N001 | Next Number Range 1 | Numeric | Generic Edit | 8 | 0 |
62 | F76B411E | IN86-Work Table for Merchandise NF Issued by Supplier - 41 | 3 | SD | N001 | Next Number Range 1 | Numeric | Generic Edit | 8 | 0 |
63 | F76B427 | Service Nota Fiscal Witholdings by Formula - BRA - 76B | 3 | SN | N001 | Next Number Range 1 | Numeric | Generic Edit | 8 | 0 |
64 | F76B428 | Service Nota Fiscal Witholdings by Service - BRA - 76B | 3 | SS | N001 | Next Number Range 1 | Numeric | Generic Edit | 8 | 0 |
65 | F76B429 | Service Nota Fiscal Wh by Formula Installment - BRA - 76B | 3 | SN | N001 | Next Number Range 1 | Numeric | Generic Edit | 8 | 0 |
66 | F76B561 | Selected NFe by Lot Work File - BRA - 76B | 5 | WF | N001 | Next Number Range 1 | Numeric | Generic Edit | 8 | 0 |