Histórico da Página
...
Lançamentos - General Ledger Detail
Campo | Nome interno | Tipo Registro | Obrigatoriedade |
---|---|---|---|
1 | GL_Business_Unit_Code | C | X |
2 | GL_Cost_Centre | C |
3 | GL_Profit_Centre | C |
4 | GL_Account_Number | C | X |
5 | GL_Journal_ID | C | X |
6 | GL_Journal_Header_Description | C |
7 | GL_Journal_ID_Line_Number | C |
8 | GL_Journal_Line_Description | C |
9 | GL_Entry_Date | D |
10 | GL_Entry_Time | T |
11 | GL_Effective_Date | D | X |
12 | GL_Last_Modified_Date | D |
13 | GL_Last_Modified_By | C |
14 | GL_Fiscal_Year | C | X |
15 | GL_Period | C | X |
16 | GL_User_ID | C |
17 | GL_Status_Indicator | C |
18 | GL_Source | C |
19 | GL_Source_Description | C |
20 | GL_Manual_Indicator | C | X |
21 | GL_Approver_ID | C |
22 | GL_Approved_Date | D |
23 | GL_Reversal_Indicator | C |
24 | GL_Reversal_Journal_ID | C |
25 | GL_Segment01 | C |
26 | GL_Segment02 | C |
27 | GL_Segment03 | C |
28 | GL_Segment04 | C |
29 | GL_Segment05 | C |
30 | GL_Amount_Cr_Dr_Indicator | C | X |
31 | GL_Foreign_Amount_Currency | C |
32 | GL_Foreign_Amount | N |
33 | GL_Local_Amount_Currency | C |
34 | GL_Local_Amount | N |
35 | GL_Reporting_Amount_Currency | C | X |
36 | GL_Reporting_Amount | N | X |
Saldos - Trial Balance
Campo | Nome Interno | Tipo Registro | Obrigatoriedade |
---|---|---|---|
1 | TB_Business_Unit_Code | C | X |
2 | TB_Account_Number | C | X |
3 | TB_Amount_Opening_Balance | N | X |
4 | TB_Amount_Ending_Balance | N | X |
5 | TB_Balance_As_Of_Date | D | X |
Plano de Contas - Chart of Accounts
Campo | Nome Interno | Tipo Registro | Obrigatoriedade |
---|---|---|---|
1 | CA_Account_Number | C | X |
2 | CA_Account_Name | C | X |
3 | CA_PL_Indicator | C | X |
4 | CA_Account_Type | C | X |
5 | CA_FS_Caption | C | X |
6 | CA_ Business_Unit_Code | C | X |
Usuários - User Table
Campo | Nome Interno | Tipo Registro | Obrigatoriedade |
---|---|---|---|
1 | UT_User_ID | X | C |
2 | UT_User_Active_Status | | C |
3 | UT_User_Active_Status_Mod_Date | | D |
4 | UT_First_Name | | C |
5 | UT_Last_Name | | C |
6 | UT_Title | | C |
7 | UT_Department | | C |
8 | UT_Role_Responsibility | | C |
9 | UT_Approval_Limit | | C |
DE-PARA - Mapping
Campo | Nome Interno | Tipo Registro | Obrigatoriedade |
---|---|---|---|
1 | File_Name | C | X |
2 | Field_Name | C | X |
3 | System_Table | C | X |
4 | System_Field | C | X |