| A | B | C | D | E | |
|---|---|---|---|---|---|
1 | Field Name | Description | Data type | Action | Mandatory |
2 | Organization_ID | Legal entity (company id) or an subsidiary where this activity will be used | Numeric | Read/Write | Yes for Organization_ID or OrganizationValue or Organization |
3 | OrganizationValue | Legal entity (company value) or an subsidiary where this activity will be used | Alphanumeric (40) | Read/Write | Yes/No |
4 | Organization | Legal entity (company name) or an subsidiary where this activity will be used | Alphanumeric (60) | Read/Write | Yes/No |
5 | Created | Date when this record was created | (yyyy-MM-dd HH:mm:ss) | ReadOnly | |
6 | CreatedBy | User who created this record | Alphanumeric (60) | ReadOnly | |
7 | Updated | Date when this record was updated | (yyyy-MM-dd HH:mm:ss) | ReadOnly | |
8 | UpdatedBy | User who updated this record | Alphanumeric (60) | ReadOnly | |
9 | BankAccount_ID | Id of the Bank Account | Numeric | Read/Write | Yes for BankAccount_ID or IBAN or AccountNo |
10 | IBAN | IBAN for Bank Account | Alphanumeric (40) | Read/Write | Yes/No |
11 | AccountNo | Account Number for Bank Account | Alphanumeric (20) | Read/Write | Yes/No |
12 | BankName | Bank Name | Alphanumeric (60) | ReadOnly | |
13 | StatementDate | Statement Date. Default when creating a new Bank Statement is Current Date. | (yyyy-MM-dd HH:mm:ss) | Read/Write | Yes, when Updating |
14 | BankStatement_ID | Bank Statement ID | Numeric | ReadOnly | |
15 | Name | Bank Statement Name. Default when creating a new Bank Statement is Current Date. | Alphanumeric (60) | Read/Write | Yes, when Updating |
16 | Description | Bank Statement Description | Alphanumeric (255) | Read/Write | |
17 | IsManual | Is Manual (default False) | True/False | ReadOnly | |
18 | BeginningBalance | Beginning Balance | Numeric | Read/Write | |
19 | StatementDifference | Statement Difference | Numeric | ReadOnly | |
20 | EndingBalance | Ending Balance | Numeric | ReadOnly | |
21 | DocStatus | The status of a document at this time. A new Bank Statement will be inserted automatically in 'Draft' ('DR') status. | Alphanumeric (2) | ReadOnly | |
22 | |||||
23 | |||||
24 | |||||
25 | |||||
26 | |||||
27 | |||||
28 | |||||
29 | |||||
30 | |||||
31 | |||||
32 | |||||
33 | |||||
34 | |||||
35 | |||||
36 | |||||
37 | |||||
38 | |||||
39 | |||||
40 | |||||
41 | |||||
42 | |||||
43 | |||||
44 | |||||
45 | |||||
46 | |||||
47 | |||||
48 | |||||
49 | |||||
50 | |||||
51 | |||||
52 | |||||
53 | |||||
54 | |||||
55 | |||||
56 | |||||
57 | |||||
58 | |||||
59 | |||||
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 |