Árvore de páginas

Versões comparadas

Chave

  • Esta linha foi adicionada.
  • Esta linha foi removida.
  • A formatação mudou.

...

Lançamentos - General Ledger Detail

CampoNome internoTipo RegistroObrigatoriedade

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

CampoNome InternoTipo RegistroObrigatoriedade

1

TB_Business_Unit_Code

CX

2

TB_Account_Number

CX

3

TB_Amount_Opening_Balance

NX

4

TB_Amount_Ending_Balance

NX

5

TB_Balance_As_Of_Date

DX

Plano de Contas - Chart of Accounts

CampoNome InternoTipo RegistroObrigatoriedade

1

CA_Account_Number

CX

2

CA_Account_Name

CX

3

CA_PL_Indicator

CX

4

CA_Account_Type

CX

5

CA_FS_Caption

CX

6

CA_ Business_Unit_Code

CX

Usuários - User Table

CampoNome InternoTipo RegistroObrigatoriedade

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

CampoNome InternoTipo RegistroObrigatoriedade
1File_NameCX
2Field_NameCX
3System_TableCX
4System_FieldCX