ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
DATA INGESTION
3
Each report type below represents a different Data Source to Target river for the corresponding source.
4
ENTITY TYPE
5
Transactions
6
Transaction Lines
7
Accounts
8
Subsidiaries
9
Companies
10
Departments
11
Employees
12
Accounting Periods
13
Entity
14
Vendors
15
16
Netsuite_Income_Statement Table Output
17
ColumnDatatype
18
COMPANYVARCHAR(16777216)
19
ENTITY_IDFLOAT
20
ENTITY_TYPEVARCHAR(16777216)
21
PARENT_ENTITYVARCHAR(16777216)
22
ENTITYVARCHAR(16777216)
23
IS_INACTIVE_ENTITYVARCHAR(16777216)
24
VENDOR_IDFLOAT
25
VENDORVARCHAR(16777216)
26
EMPLOYEE_IDFLOAT
27
EMPLOYEE_NAMEVARCHAR(16777216)
28
SF_ACCOUNT_NUMBERVARCHAR(16777216)
29
SUBSIDIARY_IDFLOAT
30
SUBSIDIARYVARCHAR(16777216)
31
TRANSACTION_IDFLOAT
32
DOCUMENT_NUMBERVARCHAR(16777216)
33
ACCOUNTING_BOOK_IDFLOAT
34
TRANSACTION_DATETIMESTAMP_NTZ(9)
35
ACCOUNTING_PERIOD_IDFLOAT
36
TRANSACTION_POSTING_PERIOD
TIMESTAMP_NTZ(9)
37
TRANSACTION_STATUSVARCHAR(16777216)
38
TRANSACTION_TYPEVARCHAR(16777216)
39
IS_NON_POSTINGVARCHAR(16777216)
40
TRANSACTION_LINE_IDFLOAT
41
MEMOVARCHAR(16777216)
42
IS_ALLOCATIONVARCHAR(16777216)
43
IS_AMORTIZATION_REV_RECVARCHAR(16777216)
44
NON_POSTING_LINEVARCHAR(16777216)
45
ACCOUNT_TYPEVARCHAR(16777216)
46
ACCOUNT_IDFLOAT
47
ACCOUNT_NUMBERVARCHAR(16777216)
48
ACCOUNT_NAMEVARCHAR(16777216)
49
PARENT_ACCOUNT_NUMBERVARCHAR(16777216)
50
PARENT_ACCOUNT_NAMEVARCHAR(16777216)
51
GRAND_PARENT_ACCOUNT_NUMBER
VARCHAR(16777216)
52
GRAND_PARENT_ACCOUNT_NAME
VARCHAR(16777216)
53
TOP_ACCOUNT_NUMBERVARCHAR(16777216)
54
TOP_ACCOUNT_NAMEVARCHAR(16777216)
55
DEPARTMENT_IDFLOAT
56
DEPARTMENTVARCHAR(16777216)
57
PARENT_DEPARTMENTVARCHAR(16777216)
58
DUE_DATETIMESTAMP_NTZ(9)
59
AMOUNTFLOAT
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100