ABCDE
1
Field NameDescriptionData typeActionMandatory
2
Organization_IDLegal entity (company id) or an subsidiary where this activity will be usedNumericRead/WriteYes for Organization_ID
or OrganizationValue
or Organization
3
OrganizationValueLegal entity (company value) or an subsidiary where this activity will be usedAlphanumeric (40)Read/WriteYes/No
4
OrganizationLegal entity (company name) or an subsidiary where this activity will be usedAlphanumeric (60)Read/WriteYes/No
5
CreatedDate when this record was created(yyyy-MM-dd HH:mm:ss)ReadOnly
6
CreatedBy_IDId of user who created this recordNumericReadOnly
7
CreatedByUser who created this recordAlphanumeric (60)ReadOnly
8
UpdatedDate when this record was updated(yyyy-MM-dd HH:mm:ss)ReadOnly
9
UpdatedBy_IDId of user who updated this recordNumericReadOnly
10
UpdatedByUser who updated this recordAlphanumeric (60)ReadOnly
11
LineBank Statement Line NumberNumericReadOnly
12
DescriptionBank Statement Line Description Alphanumeric (2.000)Read/Write
13
StatementLineDateBank Statement Date Line. Default when creating a new Bank Statement Line
is StatementDate from Master.		(yyyy-MM-dd HH:mm:ss)Read/WriteYes, when Updating
14
DateAcctAccount Date. Default when creating a new Bank Statement Line
is StatementDate from Master.		(yyyy-MM-dd HH:mm:ss)Read/WriteYes, when Updating
15
ValutaDateEffective date. Default when creating a new Bank Statement Line
is StatementDate from Master.		(yyyy-MM-dd HH:mm:ss)Read/WriteYes, when Updating
16
StmtAmtStatement amount. Default is the sum from: TrxAmt, InterestAmt, ChargeAmt, or 0.NumericReadOnly
17
TrxAmtTransaction Amount. Default when creating a new Bank Statement Line is 0.NumericRead/WriteYes, when Updating
18
InterestAmtInterest Amount. Default when creating a new Bank Statement Line is 0.NumericRead/WriteYes, when Updating
19
BPartner_IDId of Business PartnerNumericRead/Write
20
BPartnerValueValue of Business PartnerAlphanumeric (40)Read/Write
21
BPartnerNameName of Business PartnerAlphanumeric (200)Read/Write
22
Currency_IDCurrency of the Bank Statement Line. Default is the Currency from Master
when creating a new BankStatementLine.		NumericRead/WriteYes, when Updating
23
ConversionType_IDId of Conversion Type. Can only be set if is set a different Currency
other than the Currency on the Client.		NumericRead/Write
24
ConversionTypeValueValue of Conversion Type. Can only be set if is set a different Currency
other than the Currency on the Client.		Alphanumeric (40)Read/Write
25
ConversionTypeNameName of Conversion Type. Can only be set if is set a different Currency
other than the Currency on the Client.		Alphanumeric (60)Read/Write
26
Invoice_IDId of Invoice. Can only be set if Payment is set.NumericRead/Write
27
InvoiceNoInvoice NumberAlphanumeric (30)Read/Write
28
Order_IDId of Order. Can only be set if Payment is set.NumericRead/Write
29
OrderNoOrder NumberAlphanumeric (30)Read/Write
30
Payment_IDId of PaymentNumericRead/Write
31
PaymentNoPayment NumberRead/Write
32
ChargeAmtCharge amount. Default when creating a new Bank Statement Line is 0.NumericRead/WriteYes, when Updating
33
Charge_IDId of the ChargeNumericRead/WriteYes, if the value of ChargeAmt
is different from 0 then
Charge_ID or ChargeName
is mandatory
34
ChargeNameName of the ChargeAlphanumeric (60)Read/WriteYes/No
35
SAFT_TaxType_IDId of SAFT Tax Type (use only in SFRO component).
Can only be set if Charge is set. Default value is from Charge.		NumericRead/Write
36
SAFT_TaxType_ValueValue of SAFT Tax Type (use only in SFRO component).
Can only be set if Charge is set. Default value is from Charge.		Alphanumeric (3)Read/Write
37
SAFT_TaxType_NameName of SAFT Tax Type (use only in SFRO component).
Can only be set if Charge is set. Default value is from Charge.		Alphanumeric (2.000)Read/Write
38
SAFT_Tax_IDId of SAF-T Tax (use only in SFRO component).
Can only be set if Charge is set. Default value is from Charge.		NumericRead/Write
39
SAFT_Tax_ValueValue of SAF-T Tax (use only in SFRO component).
Can only be set if Charge is set. Default value is from Charge.		Alphanumeric (90)Read/Write
40
SAFT_Tax_NameName of SAF-T Tax (use only in SFRO component).
Can only be set if Charge is set. Default value is from Charge.		Alphanumeric (600)Read/Write
41
SAFT_TaxPercentageSAFT Tax Percentage (use only in SFRO component).
Can only be set if Charge is set. Default value is from Charge.		NumericRead/Write
42
SAFT_TaxBaseAmtSAFT Tax Base Amount (use only in SFRO component).
Can only be set if Charge is set. Default value is from Charge.		NumericRead/Write
43
TrxOrganization_IDId of Trx OrganizationNumericRead/Write
44
TrxOrganizationValueValue of Trx OrganizationAlphanumeric (40)Read/Write
45
TrxOrganizationName of Trx OrganizationAlphanumeric (60)Read/Write
46
Project_IDId of ProjectNumericRead/Write
47
ProjectValueValue of ProjectAlphanumeric (40)Read/Write
48
ProjectNameName of ProjectAlphanumeric (60)Read/Write
49
ProjectPhase_IDId of Project PhaseNumericRead/Write
50
ProjectPhaseName of Project PhaseAlphanumeric (60)Read/Write
51
ProjectTask_IDId of Project TaskNumericRead/Write
52
ProjectTaskName of Project TaskAlphanumeric (60)Read/Write
53
Activity_IDId of ActivityNumericRead/Write
54
ActivityValueValue of ActivityAlphanumeric (40)Read/Write
55
ActivityName of ActivityAlphanumeric (60)Read/Write
56
Campaign_IDId of CampaignNumericRead/Write
57
CampaignValueValue of CampaignAlphanumeric (40)Read/Write
58
CampaignNameName of CampaignAlphanumeric (60)Read/Write
59
Asset_IDId of AssetNumericRead/Write
60
AssetValueValue of AssetAlphanumeric (40)Read/Write
61
AssetName of AssetAlphanumeric (60)Read/Write
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