Table |
3
|
New_field |
8
|
Last Modified Date Time |
DateTime |
|
|
|
|
Table |
3
|
New_field |
8000
|
Id |
GUID |
|
|
|
|
Table |
4
|
New_field |
57
|
Last Modified Date Time |
DateTime |
|
|
|
|
Table |
4
|
New_field |
8000
|
Id |
GUID |
|
|
|
|
Table |
6
|
Changed_length |
6
|
VAT Bus. Posting Gr. (Price) |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
9
|
New_field |
11
|
Last Modified Date Time |
DateTime |
|
|
|
|
Table |
9
|
New_field |
8000
|
Id |
GUID |
|
|
|
|
Table |
10
|
New_field |
8
|
Last Modified Date Time |
DateTime |
|
|
|
|
Table |
10
|
New_field |
8000
|
Id |
GUID |
|
|
|
|
Table |
11
|
New_field |
1
|
Country/Region Code |
Code |
|
10
|
|
|
Table |
11
|
New_field |
2
|
Language Code |
Code |
|
10
|
|
|
Table |
11
|
New_field |
3
|
Name |
Text |
|
50
|
|
|
Table |
13
|
Changed_length |
1
|
Code |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
13
|
Renamed_field |
5054
|
Next Task Date |
Date |
FlowField
|
|
FROM: Next To-do Date TO: Next Task Date |
|
Table |
13
|
Renamed_field |
5076
|
Task Status Filter |
Option |
FlowFilter
|
|
FROM: To-do Status Filter TO: Task Status Filter |
Not Started,In Progress,Completed,Waiting,Postponed |
Table |
13
|
Renamed_field |
5077
|
Closed Task Filter |
Boolean |
FlowFilter
|
|
FROM: Closed To-do Filter TO: Closed Task Filter |
|
Table |
13
|
Renamed_field |
5083
|
Task Entry Exists |
Boolean |
FlowField
|
|
FROM: To-do Entry Exists TO: Task Entry Exists |
|
Table |
15
|
New_field |
25
|
Last Modified Date Time |
DateTime |
|
|
|
|
Table |
15
|
Changed_length |
42
|
Business Unit Filter |
Code |
FlowFilter
|
20
|
FROM: 10 TO: 20 |
|
Table |
15
|
Changed_length |
44
|
Gen. Bus. Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
15
|
Changed_length |
45
|
Gen. Prod. Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
15
|
Changed_length |
56
|
Tax Group Code |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
15
|
Changed_length |
57
|
VAT Bus. Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
15
|
Changed_length |
58
|
VAT Prod. Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
15
|
New_field |
400
|
Dimension Set ID Filter |
Integer |
FlowFilter
|
|
|
|
Table |
15
|
New_field |
8000
|
Id |
GUID |
|
|
|
|
Table |
17
|
Changed_length |
45
|
Business Unit Code |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
17
|
Changed_length |
49
|
Gen. Bus. Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
17
|
Changed_length |
50
|
Gen. Prod. Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
17
|
Changed_option |
51
|
Bal. Account Type |
Option |
|
|
FROM: G/L Account,Customer,Vendor,Bank Account,Fixed Asset,IC Partner TO: G/L Account,Customer,Vendor,Bank Account,Fixed Asset,IC Partner,Employee |
G/L Account,Customer,Vendor,Bank Account,Fixed Asset,IC Partner,Employee |
Table |
17
|
Changed_option |
57
|
Source Type |
Option |
|
|
FROM: ,Customer,Vendor,Bank Account,Fixed Asset TO: ,Customer,Vendor,Bank Account,Fixed Asset,Employee |
,Customer,Vendor,Bank Account,Fixed Asset,Employee |
Table |
17
|
Changed_length |
59
|
No. Series |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
17
|
Changed_length |
62
|
Tax Group Code |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
17
|
Changed_length |
64
|
VAT Bus. Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
17
|
Changed_length |
65
|
VAT Prod. Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
17
|
New_field |
8001
|
Account Id |
GUID |
FlowField
|
|
|
|
Table |
17
|
New_field |
8005
|
Last Modified DateTime |
DateTime |
|
|
|
|
Table |
18
|
Changed_length |
21
|
Customer Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
18
|
Changed_length |
29
|
Salesperson Code |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
18
|
Changed_length |
39
|
Blocked |
Option |
|
7
|
FROM: 0 TO: 7 |
,Ship,Invoice,All |
Table |
18
|
New_field |
53
|
Last Modified Date Time |
DateTime |
|
|
|
|
Table |
18
|
Changed_length |
88
|
Gen. Bus. Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
18
|
Changed_length |
107
|
No. Series |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
18
|
Changed_length |
110
|
VAT Bus. Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
18
|
Changed_length |
288
|
Preferred Bank Account Code |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
18
|
New_field |
5050
|
Contact Type |
Option |
|
|
|
Company,Person |
Table |
18
|
New_field |
7602
|
Validate EU Vat Reg. No. |
Boolean |
|
|
|
|
Table |
18
|
New_field |
8000
|
Id |
GUID |
|
|
|
|
Table |
18
|
New_field |
8001
|
Currency Id |
GUID |
|
|
|
|
Table |
18
|
New_field |
8002
|
Payment Terms Id |
GUID |
|
|
|
|
Table |
18
|
New_field |
8003
|
Shipment Method Id |
GUID |
|
|
|
|
Table |
18
|
New_field |
8004
|
Payment Method Id |
GUID |
|
|
|
|
Table |
18
|
New_field |
9003
|
Tax Area ID |
GUID |
|
|
|
|
Table |
18
|
New_field |
9004
|
Tax Area Display Name |
Text |
FlowField
|
50
|
|
|
Table |
18
|
New_field |
9005
|
Contact ID |
GUID |
|
|
|
|
Table |
18
|
New_field |
9006
|
Contact Graph Id |
Text |
|
250
|
|
|
Table |
21
|
Changed_length |
22
|
Customer Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
21
|
Changed_length |
25
|
Salesperson Code |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
21
|
Changed_length |
66
|
No. Series |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
21
|
Changed_length |
288
|
Recipient Bank Account |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
23
|
Changed_length |
21
|
Vendor Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
23
|
Changed_length |
29
|
Purchaser Code |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
23
|
New_field |
53
|
Last Modified Date Time |
DateTime |
|
|
|
|
Table |
23
|
Changed_length |
88
|
Gen. Bus. Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
23
|
Changed_length |
107
|
No. Series |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
23
|
Changed_length |
110
|
VAT Bus. Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
23
|
Changed_length |
288
|
Preferred Bank Account Code |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
23
|
New_field |
7198
|
No. of Incoming Documents |
Integer |
FlowField
|
|
|
|
Table |
23
|
New_field |
7602
|
Validate EU Vat Reg. No. |
Boolean |
|
|
|
|
Table |
23
|
New_field |
8000
|
Id |
GUID |
|
|
|
|
Table |
23
|
New_field |
8001
|
Currency Id |
GUID |
|
|
|
|
Table |
23
|
New_field |
8002
|
Payment Terms Id |
GUID |
|
|
|
|
Table |
23
|
New_field |
8003
|
Payment Method Id |
GUID |
|
|
|
|
Table |
25
|
Changed_length |
22
|
Vendor Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
25
|
Changed_length |
25
|
Purchaser Code |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
25
|
Changed_length |
64
|
No. Series |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
25
|
Changed_length |
288
|
Recipient Bank Account |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
27
|
Changed_length |
11
|
Inventory Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
27
|
New_field |
56
|
Block Reason |
Text |
|
250
|
|
|
Table |
27
|
New_field |
61
|
Last DateTime Modified |
DateTime |
|
|
|
|
Table |
27
|
Changed_length |
90
|
VAT Bus. Posting Gr. (Price) |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
27
|
Changed_length |
91
|
Gen. Prod. Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
27
|
Changed_length |
97
|
No. Series |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
27
|
Changed_length |
98
|
Tax Group Code |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
27
|
Changed_length |
99
|
VAT Prod. Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
27
|
Changed_length |
5402
|
Serial Nos. |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
27
|
Changed_length |
6501
|
Lot Nos. |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
27
|
New_field |
8000
|
Id |
GUID |
|
|
|
|
Table |
27
|
New_field |
8001
|
Unit of Measure Id |
GUID |
|
|
|
|
Table |
27
|
New_field |
8002
|
Tax Group Id |
GUID |
|
|
|
|
Table |
32
|
Changed_length |
64
|
No. Series |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
36
|
Changed_length |
31
|
Customer Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
36
|
Changed_length |
43
|
Salesperson Code |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
36
|
Changed_length |
74
|
Gen. Bus. Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
36
|
Changed_length |
107
|
No. Series |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
36
|
Changed_length |
108
|
Posting No. Series |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
36
|
Changed_length |
109
|
Shipping No. Series |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
36
|
Changed_length |
116
|
VAT Bus. Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
36
|
Changed_length |
131
|
Prepayment No. Series |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
36
|
Changed_length |
134
|
Prepmt. Cr. Memo No. Series |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
36
|
New_field |
152
|
Quote Valid Until Date |
Date |
|
|
|
|
Table |
36
|
New_field |
153
|
Quote Sent to Customer |
DateTime |
|
|
|
|
Table |
36
|
New_field |
154
|
Quote Accepted |
Boolean |
|
|
|
|
Table |
36
|
New_field |
155
|
Quote Accepted Date |
Date |
|
|
|
|
Table |
36
|
New_field |
166
|
Last Email Sent Time |
DateTime |
FlowField
|
|
|
|
Table |
36
|
New_field |
167
|
Last Email Sent Status |
Option |
FlowField
|
|
|
Not Sent,In Process,Finished,Error |
Table |
36
|
New_field |
168
|
Sent as Email |
Boolean |
FlowField
|
|
|
|
Table |
36
|
New_field |
169
|
Last Email Notif Cleared |
Boolean |
FlowField
|
|
|
|
Table |
36
|
New_field |
300
|
Amt. Ship. Not Inv. (LCY) |
Decimal |
FlowField
|
|
|
|
Table |
36
|
New_field |
301
|
Amt. Ship. Not Inv. (LCY) Base |
Decimal |
FlowField
|
|
|
|
Table |
36
|
Changed_length |
5802
|
Return Receipt No. Series |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
36
|
New_field |
8000
|
Id |
GUID |
|
|
|
|
Table |
37
|
Changed_length |
8
|
Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
37
|
Changed_length |
74
|
Gen. Bus. Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
37
|
Changed_length |
75
|
Gen. Prod. Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
37
|
Changed_length |
87
|
Tax Group Code |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
37
|
Changed_length |
88
|
VAT Clause Code |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
37
|
Changed_length |
89
|
VAT Bus. Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
37
|
Changed_length |
90
|
VAT Prod. Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
37
|
New_field |
94
|
Shipped Not Inv. (LCY) No VAT |
Decimal |
|
|
|
|
Table |
37
|
Changed_length |
106
|
VAT Identifier |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
37
|
Changed_length |
117
|
Prepayment VAT Identifier |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
37
|
Changed_length |
120
|
Prepayment Tax Group Code |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
37
|
New_field |
180
|
Line Discount Calculation |
Option |
|
|
|
None,%,Amount |
Table |
37
|
New_field |
7003
|
Subtype |
Option |
|
|
|
,Item - Inventory,Item - Service,Comment |
Table |
37
|
New_field |
7004
|
Price description |
Text |
|
80
|
|
|
Table |
38
|
Changed_length |
31
|
Vendor Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
38
|
Changed_length |
43
|
Purchaser Code |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
38
|
Changed_length |
74
|
Gen. Bus. Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
38
|
Changed_length |
107
|
No. Series |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
38
|
Changed_length |
108
|
Posting No. Series |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
38
|
Changed_length |
109
|
Receiving No. Series |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
38
|
Changed_length |
116
|
VAT Bus. Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
38
|
Changed_length |
135
|
Prepayment No. Series |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
38
|
Changed_length |
138
|
Prepmt. Cr. Memo No. Series |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
38
|
New_field |
300
|
A. Rcd. Not Inv. Ex. VAT (LCY) |
Decimal |
FlowField
|
|
|
|
Table |
38
|
New_field |
301
|
Amt. Rcd. Not Invoiced (LCY) |
Decimal |
FlowField
|
|
|
|
Table |
38
|
Changed_length |
5802
|
Return Shipment No. Series |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
38
|
New_field |
8000
|
Id |
GUID |
|
|
|
|
Table |
39
|
Changed_length |
8
|
Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
39
|
Changed_length |
74
|
Gen. Bus. Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
39
|
Changed_length |
75
|
Gen. Prod. Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
39
|
Changed_length |
87
|
Tax Group Code |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
39
|
Changed_length |
89
|
VAT Bus. Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
39
|
Changed_length |
90
|
VAT Prod. Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
39
|
Changed_length |
106
|
VAT Identifier |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
39
|
Changed_length |
117
|
Prepayment VAT Identifier |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
39
|
Changed_length |
120
|
Prepayment Tax Group Code |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
39
|
New_field |
6609
|
Subtype |
Option |
|
|
|
,Item - Inventory,Item - Service,Comment |
Table |
48
|
Changed_length |
3
|
Inventory Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
48
|
Changed_length |
10
|
Gen. Bus. Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
48
|
Changed_length |
11
|
Gen. Prod. Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
49
|
Changed_length |
10
|
Gen. Bus. Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
49
|
Changed_length |
11
|
Gen. Prod. Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
49
|
Changed_length |
20
|
Tax Group Code |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
49
|
Changed_length |
23
|
VAT Bus. Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
49
|
Changed_length |
24
|
VAT Prod. Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
52
|
New_field |
1
|
Batch ID |
GUID |
|
|
|
|
Table |
52
|
New_field |
2
|
Parameter Id |
Integer |
|
|
|
|
Table |
52
|
New_field |
3
|
Parameter Value |
Text |
|
250
|
|
|
Table |
53
|
New_field |
1
|
Record ID |
RecordID |
|
|
|
|
Table |
53
|
New_field |
2
|
Batch ID |
GUID |
|
|
|
|
Table |
61
|
New_field |
7
|
Delivery Codeunit ID |
Integer |
|
|
|
|
Table |
61
|
New_field |
8
|
Delivery Codeunit Caption |
Text |
FlowField
|
250
|
|
|
Table |
63
|
New_field |
1
|
Account No. |
Code |
|
20
|
|
|
Table |
63
|
New_field |
2
|
No. of Use |
Integer |
|
|
|
|
Table |
77
|
Changed_option |
1
|
Usage |
Option |
|
|
FROM: S.Quote,S.Order,S.Invoice,S.Cr.Memo,S.Test,P.Quote,P.Order,P.Invoice,P.Cr.Memo,P.Receipt,P.Ret.Shpt.,P.Test,B.Stmt,B.Recon.Test,B.Check,Reminder,Fin.Charge,Rem.Test,F.C.Test,Prod. Order,S.Blanket,P.Blanket,M1,M2,M3,M4,Inv1,Inv2,Inv3,SM.Quote,SM.Order,SM.Invoice,SM.Credit Memo,SM.Contract Quote,SM.Contract,SM.Test,S.Return,P.Return,S.Shipment,S.Ret.Rcpt.,S.Work Order,Invt. Period Test,SM.Shipment,S.Test Prepmt.,P.Test Prepmt.,S.Arch. Quote,S.Arch. Order,P.Arch. Quote,P.Arch. Order,S. Arch. Return Order,P. Arch. Return Order,Asm. Order,P.Assembly Order,S.Order Pick Instruction,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,C.Statement,V.Remittance,JQ,S.Invoice Draft TO: S.Quote,S.Order,S.Invoice,S.Cr.Memo,S.Test,P.Quote,P.Order,P.Invoice,P.Cr.Memo,P.Receipt,P.Ret.Shpt.,P.Test,B.Stmt,B.Recon.Test,B.Check,Reminder,Fin.Charge,Rem.Test,F.C.Test,Prod. Order,S.Blanket,P.Blanket,M1,M2,M3,M4,Inv1,Inv2,Inv3,SM.Quote,SM.Order,SM.Invoice,SM.Credit Memo,SM.Contract Quote,SM.Contract,SM.Test,S.Return,P.Return,S.Shipment,S.Ret.Rcpt.,S.Work Order,Invt. Period Test,SM.Shipment,S.Test Prepmt.,P.Test Prepmt.,S.Arch. Quote,S.Arch. Order,P.Arch. Quote,P.Arch. Order,S. Arch. Return Order,P. Arch. Return Order,Asm. Order,P.Assembly Order,S.Order Pick Instruction,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,C.Statement,V.Remittance,JQ,S.Invoice Draft,Pro Forma S. Invoice |
S.Quote,S.Order,S.Invoice,S.Cr.Memo,S.Test,P.Quote,P.Order,P.Invoice,P.Cr.Memo,P.Receipt,P.Ret.Shpt.,P.Test,B.Stmt,B.Recon.Test,B.Check,Reminder,Fin.Charge,Rem.Test,F.C.Test,Prod. Order,S.Blanket,P.Blanket,M1,M2,M3,M4,Inv1,Inv2,Inv3,SM.Quote,SM.Order,SM.Invoice,SM.Credit Memo,SM.Contract Quote,SM.Contract,SM.Test,S.Return,P.Return,S.Shipment,S.Ret.Rcpt.,S.Work Order,Invt. Period Test,SM.Shipment,S.Test Prepmt.,P.Test Prepmt.,S.Arch. Quote,S.Arch. Order,P.Arch. Quote,P.Arch. Order,S. Arch. Return Order,P. Arch. Return Order,Asm. Order,P.Assembly Order,S.Order Pick Instruction,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,C.Statement,V.Remittance,JQ,S.Invoice Draft,Pro Forma S. Invoice |
Table |
77
|
New_field |
25
|
Email Body Layout Type |
Option |
|
|
|
Custom Report Layout,HTML Layout |
Table |
79
|
Changed_length |
42
|
IC Inbox Type |
Option |
|
|
FROM: 13 TO: 0 |
|
Table |
79
|
Changed_option |
42
|
IC Inbox Type |
Option |
|
|
FROM: File Location,Database TO: |
|
Table |
79
|
New_field |
44
|
Auto. Send Transactions |
Boolean |
|
|
|
|
Table |
79
|
New_field |
51
|
Contact Person |
Text |
|
50
|
|
|
Table |
79
|
New_field |
96
|
Picture - Last Mod. Date Time |
DateTime |
|
|
|
|
Table |
79
|
New_field |
98
|
Last Modified Date Time |
DateTime |
|
|
|
|
Table |
79
|
New_field |
200
|
Alternative Language Code |
Code |
|
10
|
|
|
Table |
79
|
New_field |
300
|
Brand Color Value |
Code |
|
10
|
|
|
Table |
79
|
New_field |
301
|
Brand Color Code |
Code |
|
20
|
|
|
Table |
79
|
New_field |
7603
|
Sync with O365 Bus. profile |
Boolean |
|
|
|
|
Table |
79
|
New_field |
8000
|
Id |
GUID |
|
|
|
|
Table |
80
|
Changed_length |
21
|
No. Series |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
80
|
Changed_length |
22
|
Posting No. Series |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
81
|
Changed_option |
3
|
Account Type |
Option |
|
12
|
FROM: G/L Account,Customer,Vendor,Bank Account,Fixed Asset,IC Partner TO: G/L Account,Customer,Vendor,Bank Account,Fixed Asset,IC Partner,Employee |
G/L Account,Customer,Vendor,Bank Account,Fixed Asset,IC Partner,Employee |
Table |
81
|
Changed_length |
23
|
Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
81
|
Changed_length |
26
|
Salespers./Purch. Code |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
81
|
Changed_length |
50
|
Business Unit Code |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
81
|
Changed_length |
58
|
Gen. Bus. Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
81
|
Changed_length |
59
|
Gen. Prod. Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
81
|
Changed_option |
63
|
Bal. Account Type |
Option |
|
12
|
FROM: G/L Account,Customer,Vendor,Bank Account,Fixed Asset,IC Partner TO: G/L Account,Customer,Vendor,Bank Account,Fixed Asset,IC Partner,Employee |
G/L Account,Customer,Vendor,Bank Account,Fixed Asset,IC Partner,Employee |
Table |
81
|
Changed_length |
65
|
Bal. Gen. Bus. Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
81
|
Changed_length |
66
|
Bal. Gen. Prod. Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
81
|
Changed_length |
70
|
Bank Payment Type |
Option |
|
22
|
FROM: 14 TO: 22 |
,Computer Check,Manual Check,Electronic Payment,Electronic Payment-IAT |
Table |
81
|
Changed_option |
70
|
Bank Payment Type |
Option |
|
22
|
FROM: ,Computer Check,Manual Check TO: ,Computer Check,Manual Check,Electronic Payment,Electronic Payment-IAT |
,Computer Check,Manual Check,Electronic Payment,Electronic Payment-IAT |
Table |
81
|
Changed_option |
78
|
Source Type |
Option |
|
12
|
FROM: ,Customer,Vendor,Bank Account,Fixed Asset TO: ,Customer,Vendor,Bank Account,Fixed Asset,IC Partner,Employee |
,Customer,Vendor,Bank Account,Fixed Asset,IC Partner,Employee |
Table |
81
|
Changed_length |
80
|
Posting No. Series |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
81
|
Changed_length |
84
|
Tax Group Code |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
81
|
Changed_length |
88
|
Bal. Tax Group Code |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
81
|
Changed_length |
90
|
VAT Bus. Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
81
|
Changed_length |
91
|
VAT Prod. Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
81
|
Changed_length |
92
|
Bal. VAT Bus. Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
81
|
Changed_length |
93
|
Bal. VAT Prod. Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
81
|
New_field |
123
|
Copy VAT Setup to Jnl. Lines |
Boolean |
|
|
|
|
Table |
81
|
Changed_length |
288
|
Recipient Bank Account |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
81
|
New_field |
5701
|
Check Exported |
Boolean |
|
|
|
|
Table |
81
|
New_field |
5702
|
Check Transmitted |
Boolean |
|
|
|
|
Table |
81
|
New_field |
8000
|
Id |
GUID |
|
|
|
|
Table |
81
|
New_field |
8001
|
Account Id |
GUID |
|
|
|
|
Table |
81
|
New_field |
8002
|
Customer Id |
GUID |
|
|
|
|
Table |
81
|
New_field |
8003
|
Applies-to Invoice Id |
GUID |
|
|
|
|
Table |
81
|
New_field |
8004
|
Contact Graph Id |
Text |
|
250
|
|
|
Table |
81
|
New_field |
8005
|
Last Modified DateTime |
DateTime |
|
|
|
|
Table |
81
|
New_field |
8006
|
Journal Batch Id |
GUID |
|
|
|
|
Table |
81
|
New_field |
8007
|
Payment Method Id |
GUID |
|
|
|
|
Table |
82
|
Changed_length |
19
|
No. Series |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
82
|
Changed_length |
20
|
Posting No. Series |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
83
|
Changed_length |
10
|
Inventory Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
83
|
Changed_length |
11
|
Source Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
83
|
Changed_length |
23
|
Salespers./Purch. Code |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
83
|
Changed_length |
57
|
Gen. Bus. Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
83
|
Changed_length |
58
|
Gen. Prod. Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
83
|
Changed_length |
65
|
Posting No. Series |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
85
|
Changed_length |
15
|
Business Unit Filter |
Code |
FlowFilter
|
20
|
FROM: 10 TO: 20 |
|
Table |
86
|
Changed_length |
4
|
Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
91
|
Changed_length |
10
|
Salespers./Purch. Code |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
92
|
Changed_length |
1
|
Code |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
92
|
New_field |
20
|
Description |
Text |
|
50
|
|
|
Table |
92
|
New_field |
40
|
Used in Customers |
Integer |
FlowField
|
|
|
|
Table |
92
|
New_field |
41
|
Used in Ledger Entries |
Integer |
FlowField
|
|
|
|
Table |
93
|
Changed_length |
1
|
Code |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
93
|
New_field |
20
|
Description |
Text |
|
50
|
|
|
Table |
93
|
New_field |
40
|
Used in Vendors |
Integer |
FlowField
|
|
|
|
Table |
93
|
New_field |
41
|
Used in Ledger Entries |
Integer |
FlowField
|
|
|
|
Table |
94
|
Changed_length |
1
|
Code |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
94
|
New_field |
3
|
Used in Items |
Integer |
FlowField
|
|
|
|
Table |
94
|
New_field |
4
|
Used in Value Entries |
Integer |
FlowField
|
|
|
|
Table |
96
|
Changed_length |
10
|
Business Unit Code |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
98
|
Changed_length |
63
|
Bank Account Nos. |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
98
|
New_field |
163
|
Local Currency Description |
Text |
|
60
|
|
|
Table |
98
|
New_field |
164
|
Show Amounts |
Option |
|
|
|
Amount Only,Debit/Credit Only,All Amounts |
Table |
110
|
Changed_length |
31
|
Customer Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
110
|
Changed_length |
43
|
Salesperson Code |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
110
|
Changed_length |
74
|
Gen. Bus. Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
110
|
Changed_length |
109
|
No. Series |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
110
|
Changed_length |
110
|
Order No. Series |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
110
|
Changed_length |
116
|
VAT Bus. Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
111
|
Changed_length |
8
|
Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
111
|
Changed_length |
74
|
Gen. Bus. Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
111
|
Changed_length |
75
|
Gen. Prod. Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
111
|
Changed_length |
87
|
Tax Group Code |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
111
|
Changed_length |
89
|
VAT Bus. Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
111
|
Changed_length |
90
|
VAT Prod. Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
112
|
Changed_length |
31
|
Customer Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
112
|
Changed_length |
43
|
Salesperson Code |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
112
|
Changed_length |
74
|
Gen. Bus. Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
112
|
Changed_length |
107
|
Pre-Assigned No. Series |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
112
|
Changed_length |
108
|
No. Series |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
112
|
Changed_length |
110
|
Order No. Series |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
112
|
Changed_length |
116
|
VAT Bus. Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
112
|
New_field |
121
|
Invoice Discount Calculation |
Option |
|
|
|
None,%,Amount |
Table |
112
|
New_field |
122
|
Invoice Discount Value |
Decimal |
|
|
|
|
Table |
112
|
Changed_length |
131
|
Prepayment No. Series |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
112
|
New_field |
166
|
Last Email Sent Time |
DateTime |
FlowField
|
|
|
|
Table |
112
|
New_field |
167
|
Last Email Sent Status |
Option |
FlowField
|
|
|
Not Sent,In Process,Finished,Error |
Table |
112
|
New_field |
168
|
Sent as Email |
Boolean |
FlowField
|
|
|
|
Table |
112
|
New_field |
169
|
Last Email Notif Cleared |
Boolean |
FlowField
|
|
|
|
Table |
112
|
New_field |
8000
|
Id |
GUID |
|
|
|
|
Table |
113
|
Changed_length |
8
|
Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
113
|
Changed_length |
74
|
Gen. Bus. Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
113
|
Changed_length |
75
|
Gen. Prod. Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
113
|
Changed_length |
87
|
Tax Group Code |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
113
|
Changed_length |
88
|
VAT Clause Code |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
113
|
Changed_length |
89
|
VAT Bus. Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
113
|
Changed_length |
90
|
VAT Prod. Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
113
|
Changed_length |
106
|
VAT Identifier |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
113
|
New_field |
180
|
Line Discount Calculation |
Option |
|
|
|
None,%,Amount |
Table |
113
|
New_field |
7004
|
Price description |
Text |
|
80
|
|
|
Table |
114
|
Changed_length |
31
|
Customer Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
114
|
Changed_length |
43
|
Salesperson Code |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
114
|
Changed_length |
74
|
Gen. Bus. Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
114
|
Changed_length |
107
|
Pre-Assigned No. Series |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
114
|
Changed_length |
108
|
No. Series |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
114
|
Changed_length |
116
|
VAT Bus. Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
114
|
Changed_length |
134
|
Prepmt. Cr. Memo No. Series |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
114
|
Changed_length |
6602
|
Return Order No. Series |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
114
|
New_field |
8000
|
Id |
GUID |
|
|
|
|
Table |
115
|
Changed_length |
8
|
Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
115
|
Changed_length |
74
|
Gen. Bus. Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
115
|
Changed_length |
75
|
Gen. Prod. Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
115
|
Changed_length |
87
|
Tax Group Code |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
115
|
Changed_length |
88
|
VAT Clause Code |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
115
|
Changed_length |
89
|
VAT Bus. Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
115
|
Changed_length |
90
|
VAT Prod. Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
115
|
Changed_length |
106
|
VAT Identifier |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
115
|
New_field |
180
|
Line Discount Calculation |
Option |
|
|
|
None,%,Amount |
Table |
120
|
Changed_length |
31
|
Vendor Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
120
|
Changed_length |
43
|
Purchaser Code |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
120
|
Changed_length |
74
|
Gen. Bus. Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
120
|
Changed_length |
109
|
No. Series |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
120
|
Changed_length |
110
|
Order No. Series |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
120
|
Changed_length |
116
|
VAT Bus. Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
121
|
Changed_length |
8
|
Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
121
|
Changed_length |
74
|
Gen. Bus. Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
121
|
Changed_length |
75
|
Gen. Prod. Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
121
|
Changed_length |
87
|
Tax Group Code |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
121
|
Changed_length |
89
|
VAT Bus. Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
121
|
Changed_length |
90
|
VAT Prod. Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
122
|
Changed_length |
31
|
Vendor Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
122
|
Changed_length |
43
|
Purchaser Code |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
122
|
Changed_length |
74
|
Gen. Bus. Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
122
|
Changed_length |
107
|
Pre-Assigned No. Series |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
122
|
Changed_length |
108
|
No. Series |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
122
|
Changed_length |
110
|
Order No. Series |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
122
|
Changed_length |
116
|
VAT Bus. Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
122
|
Changed_length |
135
|
Prepayment No. Series |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
122
|
New_field |
8000
|
Id |
GUID |
|
|
|
|
Table |
123
|
Changed_length |
8
|
Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
123
|
Changed_length |
74
|
Gen. Bus. Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
123
|
Changed_length |
75
|
Gen. Prod. Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
123
|
Changed_length |
87
|
Tax Group Code |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
123
|
Changed_length |
89
|
VAT Bus. Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
123
|
Changed_length |
90
|
VAT Prod. Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
123
|
Changed_length |
106
|
VAT Identifier |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
124
|
Changed_length |
31
|
Vendor Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
124
|
Changed_length |
43
|
Purchaser Code |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
124
|
Changed_length |
74
|
Gen. Bus. Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
124
|
Changed_length |
107
|
Pre-Assigned No. Series |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
124
|
Changed_length |
108
|
No. Series |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
124
|
Changed_length |
116
|
VAT Bus. Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
124
|
Changed_length |
138
|
Prepmt. Cr. Memo No. Series |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
124
|
Changed_length |
6602
|
Return Order No. Series |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
125
|
Changed_length |
8
|
Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
125
|
Changed_length |
74
|
Gen. Bus. Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
125
|
Changed_length |
75
|
Gen. Prod. Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
125
|
Changed_length |
87
|
Tax Group Code |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
125
|
Changed_length |
89
|
VAT Bus. Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
125
|
Changed_length |
90
|
VAT Prod. Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
125
|
Changed_length |
106
|
VAT Identifier |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
130
|
New_field |
42
|
Vendor Id |
GUID |
|
|
|
|
Table |
130
|
Changed_length |
55
|
Vendor Invoice No. |
Code |
|
35
|
FROM: 20 TO: 35 |
|
Table |
133
|
Changed_length |
5
|
Name |
Text |
|
250
|
FROM: 50 TO: 250 |
|
Table |
133
|
New_field |
8000
|
Id |
GUID |
|
|
|
|
Table |
137
|
Changed_length |
5
|
Name |
Text |
|
250
|
FROM: 50 TO: 250 |
|
Table |
138
|
New_field |
3
|
Created Date-Time |
DateTime |
|
|
|
|
Table |
138
|
New_field |
5
|
File Name |
Text |
|
250
|
|
|
Table |
138
|
New_field |
6
|
Type |
Option |
|
|
|
,Image,PDF,Word,Excel,PowerPoint,Email,XML,Other |
Table |
138
|
New_field |
8
|
Content |
BLOB |
|
|
|
|
Table |
138
|
New_field |
8000
|
Id |
GUID |
|
|
|
|
Table |
143
|
New_field |
1
|
VAT Entry No. |
Integer |
|
|
|
|
Table |
143
|
New_field |
2
|
ECSL Line No. |
Integer |
|
|
|
|
Table |
143
|
New_field |
3
|
ECSL Report No. |
Code |
|
20
|
|
|
Table |
156
|
Changed_length |
51
|
Gen. Prod. Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
156
|
Changed_length |
56
|
No. Series |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
156
|
Changed_length |
57
|
Tax Group Code |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
156
|
Changed_length |
58
|
VAT Prod. Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
167
|
Changed_length |
23
|
Job Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
167
|
Changed_length |
66
|
No. Series |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
169
|
Changed_length |
29
|
Job Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
169
|
Changed_length |
80
|
Gen. Bus. Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
169
|
Changed_length |
81
|
Gen. Prod. Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
169
|
Changed_length |
87
|
No. Series |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
203
|
Changed_length |
25
|
Gen. Bus. Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
203
|
Changed_length |
26
|
Gen. Prod. Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
203
|
Changed_length |
29
|
No. Series |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
204
|
New_field |
4
|
Symbol |
Text |
|
10
|
|
|
Table |
204
|
New_field |
5
|
Last Modified Date Time |
DateTime |
|
|
|
|
Table |
204
|
New_field |
8000
|
Id |
GUID |
|
|
|
|
Table |
206
|
Changed_length |
16
|
No. Series |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
206
|
Changed_length |
17
|
Posting No. Series |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
207
|
Changed_length |
28
|
Gen. Bus. Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
207
|
Changed_length |
29
|
Gen. Prod. Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
207
|
Changed_length |
32
|
Posting No. Series |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
208
|
Changed_length |
1
|
Code |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
208
|
New_field |
20
|
Description |
Text |
|
50
|
|
|
Table |
208
|
New_field |
21
|
Used in Jobs |
Integer |
FlowField
|
|
|
|
Table |
208
|
New_field |
22
|
Used in Ledger Entries |
Integer |
FlowField
|
|
|
|
Table |
209
|
Changed_length |
16
|
No. Series |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
209
|
Changed_length |
17
|
Posting No. Series |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
210
|
Changed_length |
30
|
Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
210
|
Changed_length |
79
|
Gen. Bus. Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
210
|
Changed_length |
80
|
Gen. Prod. Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
210
|
Changed_length |
92
|
Posting No. Series |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
212
|
Changed_length |
5
|
Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
212
|
Changed_length |
25
|
Gen. Bus. Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
212
|
Changed_length |
26
|
Gen. Prod. Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
220
|
Changed_length |
1
|
Code |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
220
|
New_field |
24
|
Last Run |
Date |
|
|
|
|
Table |
221
|
Changed_length |
12
|
Gen. Bus. Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
221
|
Changed_length |
13
|
Gen. Prod. Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
221
|
Changed_length |
20
|
Tax Group Code |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
221
|
Changed_length |
22
|
VAT Bus. Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
221
|
Changed_length |
23
|
VAT Prod. Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
232
|
Changed_length |
7
|
No. Series |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
232
|
Changed_length |
8
|
Posting No. Series |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
232
|
New_field |
8000
|
Id |
GUID |
|
|
|
|
Table |
232
|
New_field |
8001
|
Last Modified DateTime |
DateTime |
|
|
|
|
Table |
233
|
Changed_length |
5
|
No. Series |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
233
|
Changed_length |
6
|
Posting No. Series |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
236
|
Changed_length |
5
|
No. Series |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
236
|
Changed_length |
6
|
Posting No. Series |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
237
|
Changed_length |
5
|
No. Series |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
237
|
Changed_length |
6
|
Posting No. Series |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
242
|
New_field |
44
|
Unapplied Empl. Entry Appln. |
Code |
|
10
|
|
|
Table |
242
|
New_field |
48
|
Employee Entry Application |
Code |
|
10
|
|
|
Table |
246
|
Changed_length |
99000882
|
Gen. Prod. Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
246
|
Changed_length |
99000883
|
Gen. Business Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
246
|
Changed_length |
99000908
|
No. Series |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
247
|
New_field |
1
|
Code |
Code |
|
10
|
|
|
Table |
247
|
New_field |
2
|
Report Receipts |
Boolean |
|
|
|
|
Table |
247
|
New_field |
3
|
Report Shipments |
Boolean |
|
|
|
|
Table |
247
|
New_field |
4
|
Default Trans. - Purchase |
Code |
|
10
|
|
|
Table |
247
|
New_field |
5
|
Default Trans. - Return |
Code |
|
10
|
|
|
Table |
248
|
New_field |
1
|
Entry No. |
Integer |
|
|
|
|
Table |
248
|
New_field |
2
|
Enabled |
Boolean |
|
|
|
|
Table |
248
|
New_field |
3
|
Service Endpoint |
Text |
|
250
|
|
|
Table |
249
|
Changed_option |
3
|
Account Type |
Option |
|
|
FROM: Customer,Vendor,Contact TO: Customer,Vendor,Contact,Company Information |
Customer,Vendor,Contact,Company Information |
Table |
249
|
New_field |
14
|
Request Identifier |
Text |
|
200
|
|
|
Table |
249
|
New_field |
15
|
Verified Street |
Text |
|
50
|
|
|
Table |
249
|
New_field |
16
|
Verified Postcode |
Text |
|
20
|
|
|
Table |
249
|
New_field |
17
|
Verified City |
Text |
|
30
|
|
|
Table |
250
|
Changed_length |
1
|
Code |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
250
|
Changed_length |
3
|
Def. VAT Bus. Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
251
|
Changed_length |
1
|
Code |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
251
|
Changed_length |
3
|
Def. VAT Prod. Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
252
|
Changed_length |
1
|
Gen. Bus. Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
252
|
Changed_length |
2
|
Gen. Prod. Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
252
|
New_field |
40
|
Used in Ledger Entries |
Integer |
FlowField
|
|
|
|
Table |
252
|
New_field |
50
|
Description |
Text |
|
50
|
|
|
Table |
254
|
Changed_length |
2
|
Gen. Bus. Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
254
|
Changed_length |
3
|
Gen. Prod. Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
254
|
Changed_length |
28
|
No. Series |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
254
|
Changed_length |
31
|
Tax Group Code |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
254
|
Changed_length |
34
|
Tax Group Used |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
254
|
Changed_length |
39
|
VAT Bus. Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
254
|
Changed_length |
40
|
VAT Prod. Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
256
|
Changed_length |
9
|
VAT Bus. Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
256
|
Changed_length |
10
|
VAT Prod. Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
256
|
New_field |
20
|
Box No. |
Text |
|
30
|
|
|
Table |
270
|
Changed_length |
21
|
Bank Acc. Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
270
|
Changed_length |
29
|
Our Contact Code |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
270
|
Changed_length |
107
|
No. Series |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
270
|
Changed_length |
115
|
Credit Transfer Msg. Nos. |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
270
|
Changed_length |
116
|
Direct Debit Msg. Nos. |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
271
|
Changed_length |
22
|
Bank Acc. Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
271
|
Changed_length |
25
|
Our Contact Code |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
272
|
Changed_option |
12
|
Bank Payment Type |
Option |
|
|
FROM: ,Computer Check,Manual Check TO: ,Computer Check,Manual Check,Electronic Payment |
,Computer Check,Manual Check,Electronic Payment |
Table |
272
|
Changed_option |
13
|
Entry Status |
Option |
|
|
FROM: ,Printed,Voided,Posted,Financially Voided,Test Print TO: ,Printed,Voided,Posted,Financially Voided,Test Print,Exported,Transmitted |
,Printed,Voided,Posted,Financially Voided,Test Print,Exported,Transmitted |
Table |
273
|
New_field |
33
|
Copy VAT Setup to Jnl. Line |
Boolean |
|
|
|
|
Table |
274
|
Changed_option |
21
|
Account Type |
Option |
|
12
|
FROM: G/L Account,Customer,Vendor,Bank Account,Fixed Asset,IC Partner TO: G/L Account,Customer,Vendor,Bank Account,Fixed Asset,IC Partner,Employee |
G/L Account,Customer,Vendor,Bank Account,Fixed Asset,IC Partner,Employee |
Table |
277
|
Changed_length |
1
|
Code |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
281
|
Changed_length |
9
|
Inventory Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
281
|
Changed_length |
22
|
Salespers./Purch. Code |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
281
|
Changed_length |
64
|
No. Series |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
287
|
Changed_length |
2
|
Code |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
288
|
Changed_length |
2
|
Code |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
289
|
New_field |
10
|
Use for Invoicing |
Boolean |
|
|
|
|
Table |
289
|
New_field |
11
|
Last Modified Date Time |
DateTime |
|
|
|
|
Table |
289
|
New_field |
8000
|
Id |
GUID |
|
|
|
|
Table |
290
|
Changed_length |
5
|
VAT Identifier |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
290
|
Changed_length |
10
|
Tax Group Code |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
290
|
Changed_length |
18
|
VAT Clause Code |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
295
|
Changed_length |
17
|
Customer Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
295
|
Changed_length |
18
|
Gen. Bus. Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
295
|
Changed_length |
37
|
No. Series |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
295
|
Changed_length |
38
|
Issuing No. Series |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
295
|
Changed_length |
43
|
VAT Bus. Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
296
|
Changed_length |
18
|
Gen. Prod. Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
296
|
Changed_length |
22
|
Tax Group Code |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
296
|
Changed_length |
23
|
VAT Prod. Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
296
|
Changed_length |
24
|
VAT Identifier |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
296
|
Changed_length |
26
|
VAT Clause Code |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
297
|
Changed_length |
17
|
Customer Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
297
|
Changed_length |
18
|
Gen. Bus. Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
297
|
Changed_length |
37
|
No. Series |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
297
|
Changed_length |
38
|
Pre-Assigned No. Series |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
297
|
Changed_length |
43
|
VAT Bus. Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
298
|
Changed_length |
18
|
Gen. Prod. Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
298
|
Changed_length |
22
|
Tax Group Code |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
298
|
Changed_length |
23
|
VAT Prod. Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
298
|
Changed_length |
24
|
VAT Identifier |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
298
|
Changed_length |
26
|
VAT Clause Code |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
302
|
Changed_length |
17
|
Customer Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
302
|
Changed_length |
18
|
Gen. Bus. Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
302
|
Changed_length |
37
|
No. Series |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
302
|
Changed_length |
38
|
Issuing No. Series |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
302
|
Changed_length |
43
|
VAT Bus. Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
303
|
Changed_length |
18
|
Gen. Prod. Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
303
|
Changed_length |
22
|
Tax Group Code |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
303
|
Changed_length |
23
|
VAT Prod. Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
303
|
Changed_length |
24
|
VAT Identifier |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
303
|
Changed_length |
26
|
VAT Clause Code |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
304
|
Changed_length |
17
|
Customer Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
304
|
Changed_length |
18
|
Gen. Bus. Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
304
|
Changed_length |
37
|
No. Series |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
304
|
Changed_length |
38
|
Pre-Assigned No. Series |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
304
|
Changed_length |
43
|
VAT Bus. Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
305
|
Changed_length |
18
|
Gen. Prod. Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
305
|
Changed_length |
22
|
Tax Group Code |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
305
|
Changed_length |
23
|
VAT Prod. Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
305
|
Changed_length |
24
|
VAT Identifier |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
305
|
Changed_length |
26
|
VAT Clause Code |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
308
|
Changed_length |
1
|
Code |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
309
|
Changed_length |
1
|
Series Code |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
310
|
Changed_length |
1
|
Code |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
310
|
Changed_length |
2
|
Series Code |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
311
|
Changed_length |
9
|
Customer Nos. |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
311
|
Changed_length |
10
|
Quote Nos. |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
311
|
Changed_length |
11
|
Order Nos. |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
311
|
Changed_length |
12
|
Invoice Nos. |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
311
|
Changed_length |
13
|
Posted Invoice Nos. |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
311
|
Changed_length |
14
|
Credit Memo Nos. |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
311
|
Changed_length |
15
|
Posted Credit Memo Nos. |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
311
|
Changed_length |
16
|
Posted Shipment Nos. |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
311
|
Changed_length |
17
|
Reminder Nos. |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
311
|
Changed_length |
18
|
Issued Reminder Nos. |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
311
|
Changed_length |
19
|
Fin. Chrg. Memo Nos. |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
311
|
Changed_length |
20
|
Issued Fin. Chrg. M. Nos. |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
311
|
Changed_length |
21
|
Posted Prepmt. Inv. Nos. |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
311
|
Changed_length |
22
|
Posted Prepmt. Cr. Memo Nos. |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
311
|
Changed_length |
23
|
Blanket Order Nos. |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
311
|
Changed_length |
44
|
VAT Bus. Posting Gr. (Price) |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
311
|
Changed_length |
45
|
Direct Debit Mandate Nos. |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
311
|
New_field |
5329
|
Write-in Product Type |
Option |
|
|
|
Item,Resource |
Table |
311
|
New_field |
5330
|
Write-in Product No. |
Code |
|
20
|
|
|
Table |
311
|
Changed_length |
5800
|
Posted Return Receipt Nos. |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
311
|
Changed_length |
6600
|
Return Order Nos. |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
312
|
Changed_length |
9
|
Vendor Nos. |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
312
|
Changed_length |
10
|
Quote Nos. |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
312
|
Changed_length |
11
|
Order Nos. |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
312
|
Changed_length |
12
|
Invoice Nos. |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
312
|
Changed_length |
13
|
Posted Invoice Nos. |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
312
|
Changed_length |
14
|
Credit Memo Nos. |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
312
|
Changed_length |
15
|
Posted Credit Memo Nos. |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
312
|
Changed_length |
16
|
Posted Receipt Nos. |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
312
|
Changed_length |
19
|
Blanket Order Nos. |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
312
|
Changed_length |
27
|
Posted Prepmt. Inv. Nos. |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
312
|
Changed_length |
28
|
Posted Prepmt. Cr. Memo Nos. |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
312
|
Changed_length |
5800
|
Posted Return Shpt. Nos. |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
312
|
Changed_length |
6600
|
Return Order Nos. |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
313
|
Changed_length |
4
|
Item Nos. |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
313
|
Changed_length |
5700
|
Transfer Order Nos. |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
313
|
Changed_length |
5701
|
Posted Transfer Shpt. Nos. |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
313
|
Changed_length |
5702
|
Posted Transfer Rcpt. Nos. |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
313
|
Changed_length |
5718
|
Nonstock Item Nos. |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
313
|
New_field |
5801
|
Default Costing Method |
Option |
|
|
|
FIFO,LIFO,Specific,Average,Standard |
Table |
313
|
Changed_length |
7300
|
Inventory Put-away Nos. |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
313
|
Changed_length |
7301
|
Inventory Pick Nos. |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
313
|
Changed_length |
7302
|
Posted Invt. Put-away Nos. |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
313
|
Changed_length |
7303
|
Posted Invt. Pick Nos. |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
313
|
Changed_length |
7304
|
Inventory Movement Nos. |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
313
|
Changed_length |
7305
|
Registered Invt. Movement Nos. |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
313
|
Changed_length |
7306
|
Internal Movement Nos. |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
314
|
Changed_length |
2
|
Resource Nos. |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
314
|
Changed_length |
950
|
Time Sheet Nos. |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
315
|
Changed_length |
2
|
Job Nos. |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
315
|
Changed_length |
5
|
Default Job Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
315
|
Changed_length |
40
|
Job WIP Nos. |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
316
|
New_field |
1
|
Tax Area Code |
Code |
|
20
|
|
|
Table |
316
|
New_field |
2
|
Language Code |
Code |
|
10
|
|
|
Table |
316
|
New_field |
3
|
Description |
Text |
|
50
|
|
|
Table |
318
|
New_field |
10
|
Last Modified Date Time |
DateTime |
|
|
|
|
Table |
318
|
New_field |
8000
|
Id |
GUID |
|
|
|
|
Table |
320
|
Changed_length |
7
|
Tax Group Filter |
Code |
FlowFilter
|
20
|
FROM: 10 TO: 20 |
|
Table |
321
|
Changed_length |
1
|
Code |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
321
|
Changed_length |
2
|
Description |
Text |
|
50
|
FROM: 30 TO: 50 |
|
Table |
321
|
New_field |
8000
|
Id |
GUID |
|
|
|
|
Table |
321
|
New_field |
8005
|
Last Modified DateTime |
DateTime |
|
|
|
|
Table |
322
|
Changed_length |
2
|
Tax Group Code |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
323
|
Changed_length |
1
|
Code |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
323
|
New_field |
10
|
Last Modified Date Time |
DateTime |
|
|
|
|
Table |
323
|
New_field |
8000
|
Id |
GUID |
|
|
|
|
Table |
324
|
Changed_length |
1
|
Code |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
324
|
New_field |
8000
|
Id |
GUID |
|
|
|
|
Table |
324
|
New_field |
8005
|
Last Modified DateTime |
DateTime |
|
|
|
|
Table |
325
|
Changed_length |
1
|
VAT Bus. Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
325
|
Changed_length |
2
|
VAT Prod. Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
325
|
Changed_length |
13
|
VAT Identifier |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
325
|
Changed_length |
15
|
VAT Clause Code |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
325
|
New_field |
20
|
Description |
Text |
|
50
|
|
|
Table |
325
|
New_field |
40
|
Used in Ledger Entries |
Integer |
FlowField
|
|
|
|
Table |
326
|
Changed_length |
3
|
Non-Taxable Tax Group Code |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
327
|
New_field |
1
|
Tax Jurisdiction Code |
Code |
|
10
|
|
|
Table |
327
|
New_field |
2
|
Language Code |
Code |
|
10
|
|
|
Table |
327
|
New_field |
3
|
Description |
Text |
|
50
|
|
|
Table |
331
|
Changed_length |
2
|
Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
334
|
New_field |
30
|
Comparison Period Formula LCID |
Integer |
|
|
|
|
Table |
348
|
New_field |
8000
|
Id |
GUID |
|
|
|
|
Table |
348
|
New_field |
8001
|
Last Modified Date Time |
DateTime |
|
|
|
|
Table |
349
|
New_field |
8000
|
Id |
GUID |
|
|
|
|
Table |
349
|
New_field |
8001
|
Last Modified Date Time |
DateTime |
|
|
|
|
Table |
355
|
New_field |
1
|
Code |
Code |
|
20
|
|
|
Table |
355
|
New_field |
2
|
Dimension Code |
Code |
|
20
|
|
|
Table |
355
|
New_field |
3
|
Line No. |
Integer |
|
|
|
|
Table |
355
|
New_field |
4
|
Dimension Value Filter Part |
Text |
|
250
|
|
|
Table |
362
|
New_field |
1
|
Line No. |
Integer |
|
|
|
|
Table |
362
|
New_field |
2
|
Report No. |
Code |
|
20
|
|
|
Table |
362
|
New_field |
3
|
Country Code |
Code |
|
10
|
|
|
Table |
362
|
New_field |
4
|
Customer VAT Reg. No. |
Text |
|
20
|
|
|
Table |
362
|
New_field |
5
|
Total Value Of Supplies |
Decimal |
|
|
|
|
Table |
362
|
New_field |
6
|
Transaction Indicator |
Option |
|
|
|
B2B Goods,,Triangulated Goods,B2B Services |
Table |
365
|
Changed_length |
2
|
Business Unit Code |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
366
|
Changed_length |
3
|
Business Unit Code |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
374
|
Changed_length |
5
|
Business Unit Filter |
Code |
FlowFilter
|
20
|
FROM: 10 TO: 20 |
|
Table |
374
|
New_field |
14
|
Income/Balance |
Option |
|
|
|
,Income Statement,Balance Sheet |
Table |
374
|
New_field |
15
|
Account Category |
Option |
|
|
|
,Assets,Liabilities,Equity,Income,Cost of Goods Sold,Expense |
Table |
376
|
Changed_length |
42
|
Business Unit Filter |
Code |
FlowFilter
|
20
|
FROM: 10 TO: 20 |
|
Table |
376
|
Changed_length |
44
|
Gen. Bus. Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
376
|
Changed_length |
45
|
Gen. Prod. Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
376
|
Changed_length |
56
|
Tax Group Code |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
376
|
Changed_length |
57
|
VAT Bus. Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
376
|
Changed_length |
58
|
VAT Prod. Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
379
|
Changed_length |
24
|
Gen. Bus. Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
379
|
Changed_length |
25
|
Gen. Prod. Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
379
|
Changed_length |
30
|
VAT Bus. Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
379
|
Changed_length |
31
|
VAT Prod. Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
380
|
Changed_length |
24
|
Gen. Bus. Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
380
|
Changed_length |
25
|
Gen. Prod. Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
380
|
Changed_length |
30
|
VAT Bus. Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
380
|
Changed_length |
31
|
VAT Prod. Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
382
|
Changed_length |
22
|
CV Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
382
|
Changed_length |
25
|
Salesperson Code |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
382
|
Changed_length |
66
|
No. Series |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
383
|
Changed_length |
24
|
Gen. Bus. Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
383
|
Changed_length |
25
|
Gen. Prod. Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
383
|
Changed_length |
28
|
Tax Group Code |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
383
|
Changed_length |
30
|
VAT Bus. Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
383
|
Changed_length |
31
|
VAT Prod. Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
384
|
Changed_length |
3
|
Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
386
|
Changed_length |
4
|
Business Unit Code |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
395
|
Changed_length |
15
|
Business Unit Filter |
Code |
FlowFilter
|
20
|
FROM: 10 TO: 20 |
|
Table |
413
|
Changed_length |
4
|
Inbox Type |
Option |
|
|
FROM: 15 TO: 0 |
|
Table |
413
|
Changed_option |
4
|
Inbox Type |
Option |
|
|
FROM: File Location,Database,Email,No IC Transfer TO: |
|
Table |
413
|
New_field |
17
|
Auto. Accept Transactions |
Boolean |
|
|
|
|
Table |
454
|
Changed_length |
7
|
Salespers./Purch. Code |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
456
|
Changed_length |
7
|
Salespers./Purch. Code |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
461
|
Changed_length |
5
|
Gen. Bus. Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
461
|
Changed_length |
6
|
Gen. Prod. Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
461
|
Changed_length |
7
|
VAT Bus. Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
461
|
Changed_length |
8
|
VAT Prod. Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
461
|
Changed_length |
17
|
VAT Identifier |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
461
|
Changed_length |
26
|
Tax Group Code |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
466
|
New_field |
1
|
Payment Method Code |
Code |
|
10
|
|
|
Table |
466
|
New_field |
2
|
Language Code |
Code |
|
10
|
|
|
Table |
466
|
New_field |
3
|
Description |
Text |
|
100
|
|
|
Table |
467
|
New_field |
1
|
Entry No. |
Integer |
|
|
|
|
Table |
467
|
New_field |
3
|
Workflow Step Instance ID |
GUID |
|
|
|
|
Table |
467
|
New_field |
5
|
Initiated By User ID |
Code |
|
50
|
|
|
Table |
467
|
New_field |
7
|
Response |
Option |
|
|
|
NotExpected,Pending,Cancel,Continue,Reject |
Table |
467
|
New_field |
8
|
Response Argument |
GUID |
|
|
|
|
Table |
467
|
New_field |
9
|
Date-Time Initiated |
DateTime |
|
|
|
|
Table |
467
|
New_field |
11
|
Last Date-Time Modified |
DateTime |
|
|
|
|
Table |
467
|
New_field |
13
|
Last Modified By User ID |
Code |
|
50
|
|
|
Table |
467
|
New_field |
15
|
Data ID |
GUID |
|
|
|
|
Table |
467
|
New_field |
17
|
Record ID |
RecordID |
|
|
|
|
Table |
468
|
New_field |
1
|
Notification No. |
Integer |
|
|
|
|
Table |
468
|
New_field |
2
|
Workflow Step Instance ID |
GUID |
|
|
|
|
Table |
468
|
New_field |
3
|
Date-Time Created |
DateTime |
|
|
|
|
Table |
468
|
New_field |
4
|
Created By User ID |
Code |
|
50
|
|
|
Table |
468
|
New_field |
5
|
Status |
Option |
|
|
|
Pending,Sent,Failed |
Table |
468
|
New_field |
6
|
Error Message |
Text |
|
250
|
|
|
Table |
468
|
New_field |
7
|
Error Details |
BLOB |
|
|
|
|
Table |
469
|
New_field |
1
|
Id |
GUID |
|
|
|
|
Table |
469
|
New_field |
2
|
WF Definition Id |
Code |
|
20
|
|
|
Table |
469
|
New_field |
3
|
Conditions |
BLOB |
|
|
|
|
Table |
469
|
New_field |
4
|
Notification Url |
BLOB |
|
|
|
|
Table |
469
|
New_field |
5
|
Enabled |
Boolean |
|
|
|
|
Table |
469
|
New_field |
6
|
User Id |
Code |
|
50
|
|
|
Table |
469
|
New_field |
7
|
Client Id |
GUID |
|
|
|
|
Table |
469
|
New_field |
8
|
Client Type |
Text |
|
50
|
|
|
Table |
469
|
New_field |
9
|
Event Code |
Code |
|
128
|
|
|
Table |
469
|
New_field |
10
|
Created Date |
DateTime |
|
|
|
|
Table |
472
|
Changed_length |
30
|
Description |
Text |
|
250
|
FROM: 50 TO: 250 |
|
Table |
472
|
New_field |
50
|
Manual Recurrence |
Boolean |
|
|
|
|
Table |
472
|
New_field |
51
|
On Hold Due to Inactivity |
Boolean |
|
|
|
|
Table |
474
|
Changed_length |
10
|
Description |
Text |
|
250
|
FROM: 50 TO: 250 |
|
Table |
483
|
New_field |
1
|
Table ID |
Integer |
|
|
|
|
Table |
483
|
New_field |
2
|
Table Name |
Text |
|
30
|
|
|
Table |
483
|
New_field |
3
|
Total Records |
Integer |
|
|
|
|
Table |
483
|
New_field |
4
|
Completed Records |
Integer |
|
|
|
|
Table |
483
|
New_field |
5
|
Progress |
Decimal |
|
|
|
|
Table |
483
|
New_field |
6
|
Status |
Option |
|
|
|
,Scheduled,In Progress,Completed,Incomplete |
Table |
483
|
New_field |
7
|
Task ID |
GUID |
|
|
|
|
Table |
483
|
New_field |
8
|
Session ID |
Integer |
|
|
|
|
Table |
483
|
New_field |
9
|
Change Type 1 |
Option |
|
|
|
None,Blank,Replace,New |
Table |
483
|
New_field |
10
|
Change Type 2 |
Option |
|
|
|
None,Blank,Replace,New |
Table |
483
|
New_field |
11
|
Global Dim.1 Field No. |
Integer |
|
|
|
|
Table |
483
|
New_field |
12
|
Global Dim.2 Field No. |
Integer |
|
|
|
|
Table |
483
|
New_field |
13
|
Dim. Set ID Field No. |
Integer |
|
|
|
|
Table |
483
|
New_field |
14
|
Primary Key Field No. |
Integer |
|
|
|
|
Table |
483
|
New_field |
15
|
Parent Table ID |
Integer |
|
|
|
|
Table |
483
|
New_field |
16
|
Is Parent Table |
Boolean |
|
|
|
|
Table |
483
|
New_field |
17
|
Earliest Start Date/Time |
DateTime |
|
|
|
|
Table |
483
|
New_field |
18
|
Remaining Duration |
Duration |
|
|
|
|
Table |
551
|
Changed_length |
2
|
From Code |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
551
|
Changed_length |
3
|
To Code |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
552
|
Changed_length |
30
|
Old Gen. Prod. Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
552
|
Changed_length |
31
|
New Gen. Prod. Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
552
|
Changed_length |
32
|
Old VAT Prod. Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
552
|
Changed_length |
33
|
New VAT Prod. Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
560
|
Changed_length |
1
|
Code |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
560
|
New_field |
10
|
Last Modified DateTime |
DateTime |
|
|
|
|
Table |
560
|
New_field |
8000
|
Id |
GUID |
|
|
|
|
Table |
561
|
Changed_length |
1
|
VAT Clause Code |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
730
|
New_field |
1
|
Related RecordID |
RecordID |
|
|
|
|
Table |
730
|
New_field |
2
|
Address Type |
Option |
|
|
|
,Sell-to,Bill-to |
Table |
730
|
New_field |
3
|
Address |
Text |
|
50
|
|
|
Table |
730
|
New_field |
4
|
Address 2 |
Text |
|
50
|
|
|
Table |
730
|
New_field |
5
|
City |
Text |
|
30
|
|
|
Table |
730
|
New_field |
6
|
Country/Region Code |
Code |
|
10
|
|
|
Table |
730
|
New_field |
7
|
Post Code |
Code |
|
20
|
|
|
Table |
730
|
New_field |
8
|
County |
Text |
|
30
|
|
|
Table |
740
|
Changed_length |
2
|
VAT Report Config. Code |
Option |
|
|
FROM: 7 TO: 0 |
|
Table |
740
|
Changed_option |
2
|
VAT Report Config. Code |
Option |
|
|
FROM: ,Option1 TO: |
|
Table |
740
|
Changed_option |
6
|
Status |
Option |
|
|
FROM: Open,Released,Submitted TO: Open,Released,Submitted,Accepted,Closed,Rejected,Canceled |
Open,Released,Submitted,Accepted,Closed,Rejected,Canceled |
Table |
740
|
Changed_length |
8
|
No. Series |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
740
|
New_field |
10
|
Period Type |
Option |
|
7
|
|
,,Month,Quarter,Year |
Table |
740
|
New_field |
11
|
Period No. |
Integer |
|
|
|
|
Table |
740
|
New_field |
12
|
Period Year |
Integer |
|
|
|
|
Table |
740
|
New_field |
13
|
Message Id |
Text |
|
250
|
|
|
Table |
740
|
New_field |
14
|
Statement Template Name |
Code |
|
10
|
|
|
Table |
740
|
New_field |
15
|
Statement Name |
Code |
|
10
|
|
|
Table |
740
|
New_field |
16
|
VAT Report Version |
Code |
|
10
|
|
|
Table |
740
|
New_field |
17
|
Submitted By |
GUID |
|
|
|
|
Table |
740
|
New_field |
18
|
Submitted Date |
Date |
|
|
|
|
Table |
741
|
Changed_length |
3
|
Gen. Prod. Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
741
|
Changed_length |
39
|
VAT Bus. Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
741
|
Changed_length |
40
|
VAT Prod. Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
741
|
Changed_length |
56
|
Gen. Bus. Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
742
|
New_field |
1
|
VAT Report No. |
Code |
|
20
|
|
|
Table |
742
|
New_field |
2
|
VAT Report Config. Code |
Option |
|
|
|
EC Sales List,VAT Report |
Table |
742
|
New_field |
3
|
Line No. |
Integer |
|
|
|
|
Table |
742
|
New_field |
4
|
Row No. |
Code |
|
10
|
|
|
Table |
742
|
New_field |
5
|
Description |
Text |
|
50
|
|
|
Table |
742
|
New_field |
6
|
Box No. |
Text |
|
30
|
|
|
Table |
742
|
New_field |
7
|
Base |
Decimal |
|
|
|
|
Table |
742
|
New_field |
8
|
Amount |
Decimal |
|
|
|
|
Table |
743
|
Changed_length |
2
|
No. Series |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
743
|
New_field |
4
|
VAT Return No. Series |
Code |
|
20
|
|
|
Table |
746
|
New_field |
1
|
VAT Report Type |
Option |
|
|
|
EC Sales List,VAT Return,Intrastat Report |
Table |
746
|
New_field |
2
|
VAT Report Version |
Code |
|
10
|
|
|
Table |
746
|
New_field |
3
|
Suggest Lines Codeunit ID |
Integer |
|
|
|
|
Table |
746
|
New_field |
4
|
Suggest Lines Codeunit Caption |
Text |
FlowField
|
250
|
|
|
Table |
746
|
New_field |
5
|
Content Codeunit ID |
Integer |
|
|
|
|
Table |
746
|
New_field |
6
|
Content Codeunit Caption |
Text |
FlowField
|
250
|
|
|
Table |
746
|
New_field |
7
|
Submission Codeunit ID |
Integer |
|
|
|
|
Table |
746
|
New_field |
8
|
Submission Codeunit Caption |
Text |
FlowField
|
250
|
|
|
Table |
746
|
New_field |
9
|
Response Handler Codeunit ID |
Integer |
|
|
|
|
Table |
746
|
New_field |
10
|
Resp. Handler Codeunit Caption |
Text |
FlowField
|
250
|
|
|
Table |
746
|
New_field |
11
|
Validate Codeunit ID |
Integer |
|
|
|
|
Table |
746
|
New_field |
12
|
Validate Codeunit Caption |
Text |
FlowField
|
250
|
|
|
Table |
746
|
New_field |
13
|
VAT Statement Template |
Code |
|
10
|
|
|
Table |
746
|
New_field |
14
|
VAT Statement Name |
Code |
|
10
|
|
|
Table |
747
|
New_field |
1
|
VAT Report Type |
Option |
|
|
|
EC Sales List,VAT Return |
Table |
747
|
New_field |
2
|
VAT Report No. |
Code |
|
20
|
|
|
Table |
747
|
New_field |
4
|
Submitted By |
Code |
|
50
|
|
|
Table |
747
|
New_field |
5
|
Submission Message BLOB |
BLOB |
|
|
|
|
Table |
747
|
New_field |
6
|
Submittion Date |
Date |
|
|
|
|
Table |
747
|
New_field |
7
|
Response Message BLOB |
BLOB |
|
|
|
|
Table |
747
|
New_field |
8
|
Response Received Date |
DateTime |
|
|
|
|
Table |
749
|
New_field |
1
|
Period Type |
Option |
|
|
|
Day,Week,Month,Quarter,Year |
Table |
749
|
New_field |
2
|
Period Start |
Date |
|
|
|
|
Table |
749
|
New_field |
3
|
Period End |
Date |
|
|
|
|
Table |
749
|
New_field |
4
|
Period No. |
Integer |
|
|
|
|
Table |
749
|
New_field |
5
|
Period Name |
Text |
|
30
|
|
|
Table |
751
|
Changed_option |
3
|
Account Type |
Option |
|
12
|
FROM: G/L Account,Customer,Vendor,Bank Account,Fixed Asset,IC Partner TO: G/L Account,Customer,Vendor,Bank Account,Fixed Asset,IC Partner,Employee |
G/L Account,Customer,Vendor,Bank Account,Fixed Asset,IC Partner,Employee |
Table |
751
|
Changed_length |
23
|
Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
751
|
Changed_length |
26
|
Salespers./Purch. Code |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
751
|
Changed_length |
50
|
Business Unit Code |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
751
|
Changed_length |
58
|
Gen. Bus. Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
751
|
Changed_length |
59
|
Gen. Prod. Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
751
|
Changed_option |
63
|
Bal. Account Type |
Option |
|
12
|
FROM: G/L Account,Customer,Vendor,Bank Account,Fixed Asset,IC Partner TO: G/L Account,Customer,Vendor,Bank Account,Fixed Asset,IC Partner,Employee |
G/L Account,Customer,Vendor,Bank Account,Fixed Asset,IC Partner,Employee |
Table |
751
|
Changed_length |
65
|
Bal. Gen. Bus. Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
751
|
Changed_length |
66
|
Bal. Gen. Prod. Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
751
|
Changed_length |
80
|
Posting No. Series |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
751
|
Changed_length |
84
|
Tax Group Code |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
751
|
Changed_length |
88
|
Bal. Tax Group Code |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
751
|
Changed_length |
90
|
VAT Bus. Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
751
|
Changed_length |
91
|
VAT Prod. Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
751
|
Changed_length |
92
|
Bal. VAT Bus. Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
751
|
Changed_length |
93
|
Bal. VAT Prod. Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
753
|
Changed_length |
10
|
Inventory Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
753
|
Changed_length |
23
|
Salespers./Purch. Code |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
753
|
Changed_length |
57
|
Gen. Bus. Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
753
|
Changed_length |
58
|
Gen. Prod. Posting Group |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
753
|
Changed_length |
65
|
Posting No. Series |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
832
|
New_field |
1
|
Created by Application |
Option |
|
|
|
Microsoft Flow,Dynamics 365,Dynamics NAV |
Table |
832
|
New_field |
2
|
Entry No. |
Integer |
|
|
|
|
Table |
832
|
New_field |
3
|
Workflow Step Instance ID |
GUID |
|
|
|
|
Table |
832
|
New_field |
4
|
Record ID |
RecordID |
|
|
|
|
Table |
832
|
New_field |
5
|
Initiated By User ID |
Code |
|
50
|
|
|
Table |
832
|
New_field |
6
|
To Be Approved By User ID |
Code |
|
50
|
|
|
Table |
832
|
New_field |
7
|
Date-Time Initiated |
DateTime |
|
|
|
|
Table |
832
|
New_field |
8
|
Last Date-Time Modified |
DateTime |
|
|
|
|
Table |
832
|
New_field |
9
|
Last Modified By User ID |
Code |
|
50
|
|
|
Table |
832
|
New_field |
10
|
Status |
Option |
|
|
|
Created,Open,Canceled,Rejected,Approved, |
Table |
832
|
New_field |
11
|
Response |
Option |
|
|
|
NotExpected,Pending,Cancel,Continue,Reject, |
Table |
832
|
New_field |
12
|
Amount |
Integer |
|
|
|
|
Table |
832
|
New_field |
13
|
Due Date |
Date |
|
|
|
|
Table |
840
|
Changed_length |
10
|
No. Series |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
840
|
New_field |
23
|
Default G/L Budget Name |
Code |
|
10
|
|
|
Table |
843
|
Changed_length |
2
|
Cash Flow Forecast No. Series |
Code |
|
20
|
FROM: 10 TO: 20 |
|
Table |
843
|
New_field |
33
|
Time Series Model |
Option |
|
|
|
ARIMA,ETS,STL,ETS+ARIMA,ETS+STL,ALL |
Table |
847
|
New_field |
17
|
Document Date |
Date |
|
|
|
|
Table |
880
|
New_field |
1
|
TemplateName |
Text |
|
250
|
|
|
Table |
880
|
New_field |
2
|
TemplateFile |
BLOB |
|
|
|
|
Table |
880
|
New_field< |