|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
attrvh__qadc01
|
|
|
x(24)
|
|
|
|
attrvh__qadc02
|
|
|
x(24)
|
|
|
|
attrvh__qadc03
|
|
|
x(24)
|
|
|
|
attrvh_attr_name
|
Attribute ID
|
|
x(32)
|
|
|
|
attrvh_domain
|
Domain
|
|
x(8)
|
|
|
|
attrvh_eff_spec_desc
|
Effective Specification
|
|
x(48)
|
|
|
|
attrvh_eff_spec_detail
|
Specification Detail
|
|
x(80)
|
|
|
|
attrvh_mod_date
|
Modified Date
|
|
99/99/99
|
|
|
|
attrvh_mod_time
|
Modified Time
|
|
->,>>>,>>9
|
|
|
|
attrvh_mod_userid
|
User ID
|
|
x(8)
|
|
|
|
attrvh_part
|
Item Number
|
|
x(18)
|
|
|
|
attrvh_remarks
|
Remark
|
|
x(40)
|
|
|
|
attrvh_spec_source
|
Source
|
|
x(8)
|
|
|
|
attrvh_test_spec_desc
|
Test Specification
|
|
x(48)
|
|
|
|
attrvh_timestamp
|
Date Time
|
|
99/99/9999 HH:MM:SS.SSS
|
|
|
|
attrvh_trnbr
|
Trans
|
|
>>>>>>>>>>
|
|
|
|
attrvh_user1
|
User Field Character 1
|
|
x(24)
|
|
|
|
attrvh_user2
|
User Field Character 2
|
|
x(24)
|
|
|
|
attrvh_validate_to_spec
|
Validation
|
|
yes/no
|
|
|
|
attrvh_validation_result
|
Validation Result
|
|
x(20)
|
|
|
|
oid_attrdh_hist
|
Attribute History OID
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
oid_attrvh_hist
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
attrvh_oid_attrdh
|
no
|
oid_attrdh_hist
|
yes
|
no
|
|
|
attrvh_part_attr
|
no
|
attrvh_domain
|
yes
|
no
|
|
|
|
|
attrvh_part
|
yes
|
no
|
|
|
|
|
attrvh_attr_name
|
yes
|
no
|
|
|
attrvh_part_trnbr
|
no
|
attrvh_domain
|
yes
|
no
|
|
|
|
|
attrvh_part
|
yes
|
no
|
|
|
|
|
attrvh_trnbr
|
yes
|
no
|
|
∗
|
attrvh_trnbr_attr
|
yes
|
attrvh_domain
|
yes
|
no
|
|
|
|
|
attrvh_trnbr
|
yes
|
no
|
|
|
|
|
attrvh_attr_name
|
yes
|
no
|
|
|
oid_attrvh_hist
|
yes
|
oid_attrvh_hist
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
attrv__qadc01
|
|
|
x(24)
|
|
|
|
attrv__qadc02
|
|
|
x(24)
|
|
|
|
attrv_active
|
Active
|
|
yes/no
|
|
|
|
attrv_cmmt
|
Comments
|
|
x(40)
|
|
|
|
attrv_domain
|
Domain
|
|
x(8)
|
|
|
|
attrv_fnc
|
Function Name
|
Function
|
x(20)
|
|
|
|
attrv_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
attrv_mod_userid
|
User ID
|
|
x(8)
|
|
|
|
attrv_name
|
Attribute Name
|
|
x(32)
|
|
|
|
attrv_user1
|
User Field Character 1
|
|
x(24)
|
|
|
|
attrv_user2
|
User Field Character 2
|
|
x(24)
|
|
|
|
attrv_value
|
Value
|
|
x(50)
|
|
|
|
oid_attrv_det
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
attrv_fnc
|
no
|
attrv_fnc
|
yes
|
no
|
|
|
|
|
attrv_domain
|
yes
|
no
|
|
∗
|
attrv_name
|
yes
|
attrv_name
|
yes
|
no
|
|
|
|
|
attrv_fnc
|
yes
|
no
|
|
|
|
|
attrv_domain
|
yes
|
no
|
|
|
|
|
attrv_value
|
yes
|
no
|
|
|
oid_attrv_det
|
yes
|
oid_attrv_det
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
attr__qadc01
|
|
|
x(24)
|
|
|
|
attr__qadc02
|
|
|
x(24)
|
|
|
|
attr__qadc03
|
|
|
x(24)
|
|
|
|
attr__qadc04
|
|
|
x(24)
|
|
|
|
attr__qadl01
|
|
|
yes/no
|
|
|
|
attr__qadl02
|
|
|
yes/no
|
|
|
|
attr_active
|
Active
|
|
yes/no
|
|
|
|
attr_datatype
|
Data Type
|
|
x(11)
|
|
|
|
attr_default
|
Default Value
|
|
x(50)
|
|
|
|
attr_default_pgm
|
Default Pgm
|
|
x(40)
|
|
|
|
attr_desc
|
Description
|
|
x(24)
|
|
|
|
attr_field
|
Field
|
|
x(32)
|
|
|
|
attr_format
|
Format
|
|
x(26)
|
|
|
|
attr_label_term
|
Label Term
|
|
x(35)
|
|
|
|
attr_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
attr_mod_userid
|
User ID
|
|
x(8)
|
|
|
|
attr_name
|
Attribute Name
|
Name
|
x(32)
|
|
|
|
attr_order
|
Order
|
|
->,>>>,>>9
|
|
|
|
attr_printable
|
Printable
|
|
yes/no
|
|
|
|
attr_qualifier
|
Qualifier
|
|
x(8)
|
|
|
|
attr_qualifier_type
|
Qualifier Type
|
|
x(20)
|
|
|
|
attr_req
|
Required
|
|
yes/no
|
|
|
|
attr_system
|
System
|
|
yes/no
|
|
|
|
attr_table
|
DB Table
|
|
x(14)
|
|
|
|
attr_user1
|
User Field Character 1
|
|
x(24)
|
|
|
|
attr_user2
|
User Field Character 2
|
|
x(24)
|
|
|
|
attr_userc03
|
User Field Character 3
|
|
x(24)
|
|
|
|
attr_userc04
|
User Field Character 4
|
|
x(24)
|
|
|
|
attr_userl01
|
User Field Logical 1
|
|
yes/no
|
|
|
|
attr_userl02
|
User Field Logical 2
|
|
yes/no
|
|
|
|
attr_valid_pgm
|
Validation Pgm
|
|
x(40)
|
|
|
|
attr_validation
|
Validation
|
|
x(8)
|
|
|
|
oid_attr_mstr
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
attr_active
|
yes
|
attr_name
|
yes
|
no
|
|
|
|
|
attr_active
|
yes
|
no
|
|
∗
|
attr_name
|
yes
|
attr_name
|
yes
|
no
|
|
|
attr_type_label
|
no
|
attr_datatype
|
yes
|
no
|
|
|
|
|
attr_label_term
|
yes
|
no
|
|
|
oid_attr_mstr
|
yes
|
oid_attr_mstr
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
att__qadc01
|
|
|
x(24)
|
|
|
|
att__qadc02
|
|
|
x(24)
|
|
|
|
att_audit_enabled
|
Audit Trail Enabled
|
Enabled
|
yes/no
|
|
|
|
att_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
att_mod_userid
|
User ID
|
|
x(8)
|
|
|
|
att_table_name
|
Table Name
|
|
X(32)
|
|
|
|
att_user1
|
User Field Character 1
|
|
x(24)
|
|
|
|
att_user2
|
User Field Character 2
|
|
x(24)
|
|
|
|
oid_att_mstr
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
att_audit_enabled
|
yes
|
att_audit_enabled
|
yes
|
no
|
|
|
|
|
att_table_name
|
yes
|
no
|
|
∗
|
att_table_name
|
yes
|
att_table_name
|
yes
|
no
|
|
|
oid_att_mstr
|
yes
|
oid_att_mstr
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
aud__qadc01
|
|
|
x(8)
|
|
|
|
aud_dataset
|
File
|
|
x(16)
|
|
|
|
aud_date
|
Date
|
|
99/99/99
|
|
|
|
aud_domain
|
Domain
|
|
x(8)
|
|
|
|
aud_entry
|
Entry
|
|
>>>>>>>>>>>9
|
|
|
|
aud_field
|
Field Name
|
|
x(32)
|
|
|
|
aud_key1
|
Key Field 1
|
|
x(18)
|
|
|
|
aud_key2
|
Key Field 2
|
|
x(18)
|
|
|
|
aud_key3
|
Key Field 3
|
|
x(18)
|
|
|
|
aud_key4
|
Key Field 4
|
|
x(18)
|
|
|
|
aud_key5
|
Key Field 5
|
|
x(18)
|
|
|
|
aud_key6
|
Key Field 6
|
|
x(18)
|
|
|
|
aud_key7
|
Key Field 7
|
|
x(18)
|
|
|
|
aud_new_data[15]
|
Data
|
New data
|
x(76)
|
|
|
|
aud_old_data[15]
|
Data
|
Old data
|
x(76)
|
|
|
|
aud_time
|
Time
|
|
x(8)
|
|
|
|
aud_user1
|
Ufld1
|
|
x(8)
|
|
|
|
aud_user2
|
Ufld2
|
|
x(8)
|
|
|
|
aud_userid
|
User ID
|
|
x(8)
|
|
|
|
oid_aud_det
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
aud_dataset
|
yes
|
aud_domain
|
yes
|
no
|
|
|
|
|
aud_dataset
|
yes
|
no
|
|
|
|
|
aud_key1
|
yes
|
no
|
|
|
|
|
aud_key2
|
yes
|
no
|
|
|
|
|
aud_key3
|
yes
|
no
|
|
|
|
|
aud_key4
|
yes
|
no
|
|
|
|
|
aud_key5
|
yes
|
no
|
|
|
|
|
aud_key6
|
yes
|
no
|
|
|
|
|
aud_key7
|
yes
|
no
|
|
|
|
|
aud_date
|
yes
|
no
|
|
|
|
|
aud_entry
|
yes
|
no
|
|
∗
|
aud_entry
|
yes
|
aud_domain
|
yes
|
no
|
|
|
|
|
aud_entry
|
yes
|
no
|
|
|
aud_user
|
no
|
aud_domain
|
yes
|
no
|
|
|
|
|
aud_userid
|
yes
|
no
|
|
|
|
|
aud_dataset
|
yes
|
no
|
|
|
|
|
aud_date
|
yes
|
no
|
|
|
oid_aud_det
|
yes
|
oid_aud_det
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
AutoNumber_ID
|
Record ID
|
|
-99999999999
|
|
|
|
AutoNumberIsActive
|
Active
|
|
yes/no
|
|
|
|
AutoNumberIsNoLeadingZero
|
Suppress Leading Zeros
|
Supp Zero
|
yes/no
|
|
|
|
AutoNumberLength
|
Length
|
|
9
|
|
|
|
AutoNumberNextNumber
|
Next Number
|
|
>>>>>>>9
|
|
|
|
AutoNumberType
|
Type
|
|
x(20)
|
|
|
|
Domain_ID
|
Domain
|
|
-99999999999
|
|
|
|
LastModifiedDate
|
Last Modified Date
|
Mod Date
|
99/99/9999
|
|
|
|
LastModifiedTime
|
Last Modified Time
|
Mod Time
|
99999
|
|
|
|
LastModifiedUser
|
Last Modified User
|
Mod User
|
x(20)
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
SharedSet_ID
|
Shared Set
|
|
-99999999999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
DomainIdx
|
no
|
Domain_ID
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
AutoNumber_ID
|
yes
|
no
|
|
|
SharedSet
|
no
|
SharedSet_ID
|
yes
|
no
|
|
|
UniqueIdx
|
yes
|
Domain_ID
|
yes
|
no
|
|
|
|
|
SharedSet_ID
|
yes
|
no
|
|
|
|
|
AutoNumberType
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
avatax__qadc01
|
|
|
x(24)
|
|
|
|
avatax__qadc02
|
|
|
x(24)
|
|
|
|
avatax__qadi01
|
|
|
->,>>>,>>9
|
|
|
|
avatax__qadi02
|
|
|
->,>>>,>>9
|
|
|
|
avatax__qadl01
|
|
|
yes/no
|
|
|
|
avatax__qadt01
|
|
|
99/99/99
|
|
|
|
avatax_active
|
Active
|
|
yes/no
|
|
|
|
avatax_cacurrid
|
Canadian Currency
|
|
9999999999
|
2
|
|
|
avatax_debug
|
Debug
|
|
yes/no
|
|
|
|
avatax_debuglevel
|
Debug level
|
|
x(10)
|
|
|
|
avatax_domainbyreport
|
Report on Domain
|
|
yes/no
|
|
|
|
avatax_exemption
|
Exemption On
|
|
x(8)
|
|
|
|
avatax_license
|
Avatax License Key
|
|
x(50)
|
|
|
|
avatax_logsdest
|
Logs location
|
|
x(200)
|
|
|
|
avatax_mod_date
|
Modification Date
|
|
99/99/99
|
|
|
|
avatax_mod_userid
|
Last modified User ID
|
|
x(8)
|
|
|
|
avatax_password
|
Avatax Password
|
|
x(50)
|
|
|
|
avatax_production
|
Production
|
|
yes/no
|
|
|
|
avatax_profile
|
Profile
|
|
x(50)
|
|
|
|
avatax_urladdr
|
Address URL
|
|
x(200)
|
|
|
|
avatax_urltax
|
Tax URL
|
|
x(200)
|
|
|
|
avatax_usacurrid
|
US Currency
|
|
9999999999
|
2
|
|
|
avatax_user1
|
|
|
x(8)
|
|
|
|
avatax_user2
|
|
|
x(8)
|
|
|
|
avatax_userid
|
User Id
|
|
x(50)
|
|
|
|
avatax_version
|
Version
|
|
x(50)
|
|
|
|
oid_avatax_ctrl
|
|
|
>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
2
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
avatax_index1
|
yes
|
avatax_active
|
yes
|
no
|
|
|
oid_avatax_ctrl
|
yes
|
oid_avatax_ctrl
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
BankAccFormat_ID
|
Record ID
|
|
-99999999999
|
|
|
|
BankAccFormatCode
|
Bank Account Format
|
|
x(20)
|
|
|
|
BankAccFormatDescription
|
Description
|
|
x(40)
|
|
|
|
BankAccFormatIsSystDefined
|
System Defined
|
|
yes/no
|
|
|
|
LastModifiedDate
|
Last Modified Date
|
Mod Date
|
99/99/9999
|
|
|
|
LastModifiedTime
|
Last Modified Time
|
Mod Time
|
99999
|
|
|
|
LastModifiedUser
|
Last Modified User
|
Mod User
|
x(20)
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
Prim
|
yes
|
BankAccFormat_ID
|
yes
|
no
|
|
|
UniqueIdx
|
yes
|
BankAccFormatCode
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
BankAccFormat_ID
|
Link to BankAccFormat
|
|
-99999999999
|
|
|
|
BankAccFormatSect_ID
|
Record ID
|
|
-99999999999
|
|
|
|
BankAccFormatSectDelimiter
|
Delimiter
|
|
x(1)
|
|
|
|
BankAccFormatSectIsLdZero
|
Leading Zeros
|
|
yes/no
|
|
|
|
BankAccFormatSectIsMandat
|
Mandatory
|
|
yes/no
|
|
|
|
BankAccFormatSectLabel
|
Label
|
|
x(40)
|
|
|
|
BankAccFormatSectLength
|
Length
|
|
->,>>>,>>9
|
|
|
|
BankAccFormatSectSequence
|
Sequence
|
|
->,>>>,>>9
|
|
|
|
LastModifiedDate
|
Last Modified Date
|
Mod Date
|
99/99/9999
|
|
|
|
LastModifiedTime
|
Last Modified Time
|
Mod Time
|
99999
|
|
|
|
LastModifiedUser
|
Last Modified User
|
Mod User
|
x(20)
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
Prim
|
yes
|
BankAccFormatSect_ID
|
yes
|
no
|
|
|
UniqueIdx
|
yes
|
BankAccFormat_ID
|
yes
|
no
|
|
|
|
|
BankAccFormatSectSequence
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
BankBranch_ID
|
Record ID
|
|
-99999999999
|
|
|
|
BankBranchCode
|
Bank Branch Code
|
|
x(8)
|
|
|
|
BankBranchName1
|
Name
|
|
x(60)
|
|
|
|
BankBranchName2
|
Second Name
|
|
x(60)
|
|
|
|
BusinessRelation_ID
|
Link to BusinessRelation
|
|
-99999999999
|
|
|
|
CustomCombo0
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo1
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo10
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo11
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo12
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo13
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo14
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo2
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo3
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo4
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo5
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo6
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo7
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo8
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo9
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomDate0
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate1
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate2
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate3
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate4
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDecimal0
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal1
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal2
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal3
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal4
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomInteger0
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger1
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger2
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger3
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger4
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomLong0
|
Custom Long Field
|
|
x(255)
|
|
|
|
CustomLong1
|
Custom Long Field
|
|
x(255)
|
|
|
|
CustomNote
|
Custom Note Field
|
|
x(2000)
|
|
|
|
CustomShort0
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort1
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort10
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort11
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort12
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort13
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort14
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort2
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort3
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort4
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort5
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort6
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort7
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort8
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort9
|
Custom Short Field
|
|
x(20)
|
|
|
|
LastModifiedDate
|
Last Modified Date
|
Mod Date
|
99/99/9999
|
|
|
|
LastModifiedTime
|
Last Modified Time
|
Mod Time
|
99999
|
|
|
|
LastModifiedUser
|
Last Modified User
|
Mod User
|
x(20)
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
BusRelIdx
|
no
|
BusinessRelation_ID
|
yes
|
no
|
|
|
LastModIdx
|
no
|
LastModifiedDate
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
BankBranch_ID
|
yes
|
no
|
|
|
UnqIdx
|
yes
|
BankBranchCode
|
yes
|
no
|
|
|
|
|
BusinessRelation_ID
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
BankCharge_ID
|
Record ID
|
|
-99999999999
|
|
|
|
BankChargeIsTaxable
|
Taxable
|
|
yes/no
|
|
|
|
BankChargeIsTaxIncluded
|
Tax Included
|
|
yes/no
|
|
|
|
BankChargeTaxClass
|
Tax Class
|
|
x(8)
|
|
|
|
BankChargeValidDateFrom
|
Valid From
|
|
99/99/9999
|
|
|
|
BusinessRelation_ID
|
Link to BusinessRelation
|
|
-99999999999
|
|
|
|
Currency_ID
|
Link to Currency
|
|
-99999999999
|
|
|
|
CustomCombo0
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo1
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo10
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo11
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo12
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo13
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo14
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo2
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo3
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo4
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo5
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo6
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo7
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo8
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo9
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomDate0
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate1
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate2
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate3
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate4
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDecimal0
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal1
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal2
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal3
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal4
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomInteger0
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger1
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger2
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger3
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger4
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomLong0
|
Custom Long Field
|
|
x(255)
|
|
|
|
CustomLong1
|
Custom Long Field
|
|
x(255)
|
|
|
|
CustomNote
|
Custom Note Field
|
|
x(2000)
|
|
|
|
CustomShort0
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort1
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort10
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort11
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort12
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort13
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort14
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort2
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort3
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort4
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort5
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort6
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort7
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort8
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort9
|
Custom Short Field
|
|
x(20)
|
|
|
|
LastModifiedDate
|
Last Modified Date
|
Mod Date
|
99/99/9999
|
|
|
|
LastModifiedTime
|
Last Modified Time
|
Mod Time
|
99999
|
|
|
|
LastModifiedUser
|
Last Modified User
|
Mod User
|
x(20)
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
BusRelIdx
|
no
|
BusinessRelation_ID
|
yes
|
no
|
|
|
CurrIdx
|
no
|
Currency_ID
|
yes
|
no
|
|
|
LastModIdx
|
no
|
LastModifiedDate
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
BankCharge_ID
|
yes
|
no
|
|
|
UnqIdx
|
yes
|
BusinessRelation_ID
|
yes
|
no
|
|
|
|
|
BankChargeValidDateFrom
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
BankCharge_ID
|
Link to BankCharge
|
|
-99999999999
|
|
|
|
BankChargeRate_ID
|
Record ID
|
|
-99999999999
|
|
|
|
BankChargeRateChargeTC
|
Bank Charge
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
BankChargeRateLineSeq
|
Line
|
|
->,>>>,>>9
|
|
|
|
BankChargeRatePayFromTC
|
Payment Amount From (>)
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
BankChargeRatePayToTC
|
Payment Amount To
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
BankChargeRateType
|
Type
|
|
x(20)
|
|
|
|
CustomCombo0
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo1
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo10
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo11
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo12
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo13
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo14
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo2
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo3
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo4
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo5
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo6
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo7
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo8
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo9
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomDate0
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate1
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate2
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate3
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate4
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDecimal0
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal1
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal2
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal3
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal4
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomInteger0
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger1
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger2
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger3
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger4
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomLong0
|
Custom Long Field
|
|
x(255)
|
|
|
|
CustomLong1
|
Custom Long Field
|
|
x(255)
|
|
|
|
CustomNote
|
Custom Note Field
|
|
x(2000)
|
|
|
|
CustomShort0
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort1
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort10
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort11
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort12
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort13
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort14
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort2
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort3
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort4
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort5
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort6
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort7
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort8
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort9
|
Custom Short Field
|
|
x(20)
|
|
|
|
LastModifiedDate
|
Last Modified Date
|
Mod Date
|
99/99/9999
|
|
|
|
LastModifiedTime
|
Last Modified Time
|
Mod Time
|
99999
|
|
|
|
LastModifiedUser
|
Last Modified User
|
Mod User
|
x(20)
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
ChargeIdx
|
no
|
BankCharge_ID
|
yes
|
no
|
|
|
LastModIdx
|
no
|
LastModifiedDate
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
BankChargeRate_ID
|
yes
|
no
|
|
|
TypeIdx
|
no
|
BankChargeRateType
|
yes
|
no
|
|
|
UnqIdx
|
yes
|
BankCharge_ID
|
yes
|
no
|
|
|
|
|
BankChargeRateType
|
yes
|
no
|
|
|
|
|
BankChargeRateLineSeq
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
BankFileFormat_ID
|
Record ID
|
|
-99999999999
|
|
|
|
BankFileFormatCode
|
Format Code
|
|
x(20)
|
|
|
|
BankFileFormatDescript
|
Description
|
|
x(40)
|
|
|
|
LastModifiedDate
|
Last Modified Date
|
Mod Date
|
99/99/9999
|
|
|
|
LastModifiedTime
|
Last Modified Time
|
Mod Time
|
99999
|
|
|
|
LastModifiedUser
|
Last Modified User
|
Mod User
|
x(20)
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
Prim
|
yes
|
BankFileFormat_ID
|
yes
|
no
|
|
|
UniqueIdx
|
yes
|
BankFileFormatCode
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
BankFileFormat_ID
|
Link to BankFileFormat
|
|
-99999999999
|
|
|
|
BankFileFormatTransType_ID
|
Record ID
|
|
-99999999999
|
|
|
|
BankFileFormatTransTypeAct
|
Trans Type Activity
|
Activity
|
x(20)
|
|
|
|
BankFileFormatTransTypeCod
|
Transaction Type Code
|
Trans Type
|
x(20)
|
|
|
|
BankFileFormatTransTypeTSt
|
Trans Type Status
|
|
x(20)
|
|
|
|
LastModifiedDate
|
Last Modified Date
|
Mod Date
|
99/99/9999
|
|
|
|
LastModifiedTime
|
Last Modified Time
|
Mod Time
|
99999
|
|
|
|
LastModifiedUser
|
Last Modified User
|
Mod User
|
x(20)
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
Prim
|
yes
|
BankFileFormatTransType_ID
|
yes
|
no
|
|
|
Uniq
|
yes
|
BankFileFormat_ID
|
yes
|
no
|
|
|
|
|
BankFileFormatTransTypeCod
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
BankImp_ID
|
Record ID
|
|
-99999999999
|
|
|
|
BankImpCurrencyCode
|
Bank Currency Code
|
|
x(3)
|
|
|
|
BankImpFileName
|
Bank File Name
|
|
x(255)
|
|
|
|
BankImpFileType
|
File Type
|
|
x(20)
|
|
|
|
BankImpLinesCount
|
Numbers of Detail Lines
|
|
->,>>>,>>9
|
|
|
|
BankImpLoadedDate
|
Upload Date
|
|
99/99/9999
|
|
|
|
BankImpLoadedTime
|
Time Loaded
|
|
99999
|
|
|
|
BankImpTotalAmountInTC
|
Total Amount In
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
BankImpTotalAmountOutTC
|
Total Amount Out
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
CustomCombo0
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo1
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo2
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo3
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo4
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo5
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo6
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo7
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo8
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo9
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomDate0
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate1
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate2
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate3
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate4
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDecimal0
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal1
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal2
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal3
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal4
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomInteger0
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger1
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger2
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger3
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger4
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomLong0
|
Custom Long Field
|
|
x(255)
|
|
|
|
CustomLong1
|
Custom Long Field
|
|
x(255)
|
|
|
|
CustomNote
|
Custom Note Field
|
|
x(2000)
|
|
|
|
CustomShort0
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort1
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort2
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort3
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort4
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort5
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort6
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort7
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort8
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort9
|
Custom Short Field
|
|
x(20)
|
|
|
|
LastModifiedDate
|
Last Modified Date
|
Mod Date
|
99/99/9999
|
|
|
|
LastModifiedTime
|
Last Modified Time
|
Mod Time
|
99999
|
|
|
|
LastModifiedUser
|
Last Modified User
|
Mod User
|
x(20)
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
FileNameIdx
|
no
|
BankImpFileName
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
BankImp_ID
|
yes
|
no
|
|
|
UniqueIdx
|
yes
|
BankImpLoadedDate
|
yes
|
no
|
|
|
|
|
BankImpLoadedTime
|
yes
|
no
|
|
|
|
|
BankImpFileName
|
yes
|
no
|
|
|
|
|
BankImpCurrencyCode
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
BankImp_ID
|
Link to BankImp
|
|
-99999999999
|
|
|
|
BankImpLine_ID
|
Record ID
|
|
-99999999999
|
|
|
|
BankImpLineAction
|
Action
|
|
x(20)
|
|
|
|
BankImpLineAddressCity
|
Address City
|
|
x(20)
|
|
|
|
BankImpLineAddressCountry
|
Address Country
|
|
x(3)
|
|
|
|
BankImpLineAddressLine
|
Address Line
|
|
x(40)
|
|
|
|
BankImpLineAddressZip
|
Address Zip
|
|
x(10)
|
|
|
|
BankImpLineAmountTC
|
Amount TC
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
BankImpLineBankNumber
|
Bank Number
|
|
x(40)
|
|
|
|
BankImpLineBatchNbr
|
Batch Number
|
|
->,>>>,>>9
|
|
|
|
BankImpLineBusRelType
|
Business Relation Type
|
|
x(20)
|
|
|
|
BankImpLineCost
|
Cost
|
|
x(20)
|
|
|
|
BankImpLineCreditorCode
|
Supplier Code
|
|
x(20)
|
|
|
|
BankImpLineCreditorName
|
Supplier Name
|
|
x(40)
|
|
|
|
BankImpLineCurrencyCode
|
Currency
|
|
x(3)
|
|
|
|
BankImpLineDebtorCode
|
Customer Code
|
|
x(20)
|
|
|
|
BankImpLineDebtorName
|
Customer Name
|
|
x(40)
|
|
|
|
BankImpLineDeductionCatAmtTC
|
TC Deduction Amount
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
BankImpLineDeductionCatCode
|
Deduction Category Code
|
|
x(20)
|
|
|
|
BankImpLineDeductionCatDesc
|
Deduction Description
|
|
x(40)
|
|
|
|
BankImpLineDescription
|
Description
|
|
x(255)
|
|
|
|
BankImpLineDiscAmtTC
|
TC Discount Amount
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
BankImpLineExchangeRate
|
Exchange Rate
|
|
->,>>>,>>9.9999999999
|
10
|
|
|
BankImpLineFileFormatCode
|
Format Code
|
|
x(20)
|
|
|
|
BankImpLineInfo
|
Info
|
|
x(2000)
|
|
|
|
BankImpLineInOut
|
Direction
|
|
x(3)
|
|
|
|
BankImpLineIntAmtTC
|
TC Interest Amount
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
BankImpLineInvRefList
|
Invoices
|
|
x(2000)
|
|
|
|
BankImpLineIsCreateBE
|
Create Banking Entry
|
|
yes/no
|
|
|
|
BankImpLineIsPayDDoc
|
New Payments as Paid
|
|
yes/no
|
|
|
|
BankImpLineOrigAmountTC
|
Original Amount TC
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
BankImpLineOrigCurrCode
|
Original Currency
|
|
x(3)
|
|
|
|
BankImpLineOrigTransDate
|
Original Transaction Date
|
|
99/99/9999
|
|
|
|
BankImpLineOwnBankNumber
|
Account Number
|
|
x(40)
|
|
|
|
BankImpLinePaymentNbr
|
Payment Number
|
|
x(20)
|
|
|
|
BankImpLinePaymentRef
|
Payment Reference
|
|
x(40)
|
|
|
|
BankImpLineProcessDate
|
Process Date
|
|
99/99/9999
|
|
|
|
BankImpLineProcessedStatus
|
Process Status
|
|
x(20)
|
|
|
|
BankImpLineRateScale
|
Exchange Scale
|
|
->,>>>,>>9.9999999999
|
10
|
|
|
BankImpLineReference
|
Reference
|
|
x(50)
|
|
|
|
BankImpLineResultAction
|
Result Action
|
|
x(20)
|
|
|
|
BankImpLineSeq
|
Sequence
|
Seq
|
->,>>>,>>9
|
|
|
|
BankImpLineStatNumber
|
Statement Number
|
|
x(20)
|
|
|
|
BankImpLineTransType
|
Transaction Type
|
|
x(20)
|
|
|
|
BankImpLineValueDate
|
Value Date
|
|
99/99/9999
|
|
|
|
BankState_ID
|
Link to BankState
|
|
-99999999999
|
|
|
|
CDocument_ID
|
Link to CDocument
|
|
-99999999999
|
|
|
|
Creditor_ID
|
Link to Creditor
|
|
-99999999999
|
|
|
|
CustomCombo0
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo1
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo2
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo3
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo4
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo5
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo6
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo7
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo8
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo9
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomDate0
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate1
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate2
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate3
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate4
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDecimal0
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal1
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal2
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal3
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal4
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomInteger0
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger1
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger2
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger3
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger4
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomLong0
|
Custom Long Field
|
|
x(255)
|
|
|
|
CustomLong1
|
Custom Long Field
|
|
x(255)
|
|
|
|
CustomNote
|
Custom Note Field
|
|
x(2000)
|
|
|
|
CustomShort0
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort1
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort2
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort3
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort4
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort5
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort6
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort7
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort8
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort9
|
Custom Short Field
|
|
x(20)
|
|
|
|
DDocument_ID
|
Link to DDocument
|
|
-99999999999
|
|
|
|
Debtor_ID
|
Link to Debtor
|
|
-99999999999
|
|
|
|
LastModifiedDate
|
Last Modified Date
|
Mod Date
|
99/99/9999
|
|
|
|
LastModifiedTime
|
Last Modified Time
|
Mod Time
|
99999
|
|
|
|
LastModifiedUser
|
Last Modified User
|
Mod User
|
x(20)
|
|
|
|
PayFormatCode_ID
|
Link to PayFormatCode
|
|
-99999999999
|
|
|
|
PaySel_ID
|
Link to PaySel
|
|
-99999999999
|
|
|
|
ProcessByUsr_ID
|
Link to Usr
|
|
-99999999999
|
|
|
|
ProcessInCompany_ID
|
Link to Company
|
|
-99999999999
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
BankImp
|
no
|
BankImp_ID
|
yes
|
no
|
|
|
BankState
|
no
|
BankState_ID
|
yes
|
no
|
|
|
BatchNbr
|
no
|
BankImpLineBatchNbr
|
yes
|
no
|
|
|
CDoc
|
no
|
CDocument_ID
|
yes
|
no
|
|
|
Creditor
|
no
|
Creditor_ID
|
yes
|
no
|
|
|
DDoc
|
no
|
DDocument_ID
|
yes
|
no
|
|
|
Debtor
|
no
|
Debtor_ID
|
yes
|
no
|
|
|
PayFormat
|
no
|
PayFormatCode_ID
|
yes
|
no
|
|
|
PaySelIdx
|
no
|
PaySel_ID
|
yes
|
no
|
|
|
PrcCyIdx
|
no
|
ProcessInCompany_ID
|
yes
|
no
|
|
|
PrcUsrIdx
|
no
|
ProcessByUsr_ID
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
BankImpLine_ID
|
yes
|
no
|
|
|
ProcessedStatIdx
|
no
|
BankImpLineProcessedStatus
|
yes
|
no
|
|
|
UniqueIdx
|
yes
|
BankImpLineSeq
|
yes
|
no
|
|
|
|
|
BankImp_ID
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
BankImpLine_ID
|
Link to BankImpLine
|
|
-99999999999
|
|
|
|
BankImpLineLog_ID
|
Record ID
|
|
-99999999999
|
|
|
|
BankImpLineLogFieldLabel
|
Field Label
|
|
x(80)
|
|
|
|
BankImpLineLogFieldName
|
Field Name
|
|
x(80)
|
|
|
|
BankImpLineLogFieldValue
|
Field Value
|
|
x(2000)
|
|
|
|
BankImpLineLogLog
|
Log
|
|
x(4000)
|
|
|
|
BankImpLineLogMessage
|
Message
|
|
x(2000)
|
|
|
|
BankImpLineLogRowid
|
Row ID
|
|
x(20)
|
|
|
|
BankImpLineLogSeverity
|
Severity
|
|
->,>>>,>>9
|
|
|
|
BankImpLineLogType
|
Type
|
|
x(20)
|
|
|
|
LastModifiedDate
|
Last Modified Date
|
Mod Date
|
99/99/9999
|
|
|
|
LastModifiedTime
|
Last Modified Time
|
Mod Time
|
99999
|
|
|
|
LastModifiedUser
|
Last Modified User
|
Mod User
|
x(20)
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
Line
|
no
|
BankImpLine_ID
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
BankImpLineLog_ID
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
BankImp_ID
|
Link to BankImp
|
|
-99999999999
|
|
|
|
BankImpLine_ID
|
Link to BankImpLine
|
|
-99999999999
|
|
|
|
BankImpLinePrc_ID
|
Record ID
|
|
-99999999999
|
|
|
|
BankImpLinePrcCode
|
Process Name
|
|
x(40)
|
|
|
|
BankImpLinePrcDesc
|
Description
|
|
x(255)
|
|
|
|
BankImpLinePrcLevel
|
Process Level
|
|
>>>>9
|
|
|
|
BankImpLinePrcParam
|
Process Parameters
|
|
x(2000)
|
|
|
|
BankImpLinePrcResult
|
Process Result
|
|
x(2000)
|
|
|
|
BankImpLinePrcStatus
|
Process Status
|
|
x(20)
|
|
|
|
CustomCombo0
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo1
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo10
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo11
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo12
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo13
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo14
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo2
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo3
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo4
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo5
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo6
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo7
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo8
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo9
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomDate0
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate1
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate2
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate3
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate4
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDecimal0
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal1
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal2
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal3
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal4
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomInteger0
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger1
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger2
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger3
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger4
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomLong0
|
Custom Long Field
|
|
x(255)
|
|
|
|
CustomLong1
|
Custom Long Field
|
|
x(255)
|
|
|
|
CustomNote
|
Custom Note Field
|
|
x(2000)
|
|
|
|
CustomShort0
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort1
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort10
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort11
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort12
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort13
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort14
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort2
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort3
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort4
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort5
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort6
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort7
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort8
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort9
|
Custom Short Field
|
|
x(20)
|
|
|
|
LastModifiedDate
|
Last Modified Date
|
Mod Date
|
99/99/9999
|
|
|
|
LastModifiedTime
|
Last Modified Time
|
Mod Time
|
99999
|
|
|
|
LastModifiedUser
|
Last Modified User
|
Mod User
|
x(20)
|
|
|
|
ParentBankImpLinePrc_ID
|
Link to BankImpLinePrc - Parent
|
|
-99999999999
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
BankImpIdx
|
no
|
BankImp_ID
|
yes
|
no
|
|
|
BankImpLineIdx
|
no
|
BankImpLine_ID
|
yes
|
no
|
|
|
ParentPrcIdx
|
no
|
ParentBankImpLinePrc_ID
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
BankImpLinePrc_ID
|
yes
|
no
|
|
|
UniqIdx
|
yes
|
BankImpLine_ID
|
yes
|
no
|
|
|
|
|
BankImpLinePrcCode
|
yes
|
no
|
|
|
|
|
ParentBankImpLinePrc_ID
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
BankAccFormat_ID
|
Bank Account Format
|
|
-99999999999
|
|
|
|
BankBusinessRelation_ID
|
Business Relation
|
|
-99999999999
|
|
|
|
BankNumber
|
Bank Number
|
|
x(40)
|
|
|
|
BankNumber_ID
|
Record ID
|
|
-99999999999
|
|
|
|
BankNumberBankAccountType
|
Bank Account Type
|
|
x(40)
|
|
|
|
BankNumberBankChargeGL_ID
|
Link to GL for Bank Charges
|
|
-99999999999
|
|
|
|
BankNumberBranch
|
Branch
|
|
x(8)
|
|
|
|
BankNumberExtension
|
Bank Extension
|
Extension
|
x(20)
|
|
|
|
BankNumberFormatted
|
Formatted Bank Account No
|
Formatted Number
|
x(40)
|
|
|
|
BankNumberIsActive
|
Active
|
|
yes/no
|
|
|
|
BankNumberIsBankCharge
|
Bank Charge
|
|
yes/no
|
|
|
|
BankNumberIsDefault
|
Default
|
|
yes/no
|
|
|
|
BankNumberIsSBDef
|
Self-Bill Default
|
|
yes/no
|
|
|
|
BankNumberParentType
|
Type
|
|
x(20)
|
|
|
|
BankNumberSwiftCode
|
SWIFT Code
|
|
x(40)
|
|
|
|
BankNumberValidation
|
Validation
|
|
x(20)
|
|
|
|
BankPayFormat_ID
|
Link to BankPayFormat
|
|
-99999999999
|
|
|
|
CompanySharedSet_ID
|
Link to CompanySharedSet
|
|
-99999999999
|
|
|
|
Currency_ID
|
Currency Code
|
Curr
|
-99999999999
|
|
|
|
CustomCombo0
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo1
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo2
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo3
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo4
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo5
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo6
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo7
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo8
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo9
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomDate0
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate1
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate2
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate3
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate4
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDecimal0
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal1
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal2
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal3
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal4
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomInteger0
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger1
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger2
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger3
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger4
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomLong0
|
Custom Long Field
|
|
x(255)
|
|
|
|
CustomLong1
|
Custom Long Field
|
|
x(255)
|
|
|
|
CustomNote
|
Custom Note Field
|
|
x(2000)
|
|
|
|
CustomShort0
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort1
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort2
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort3
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort4
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort5
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort6
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort7
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort8
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort9
|
Custom Short Field
|
|
x(20)
|
|
|
|
DDocumentStatus_ID
|
Payment Status
|
|
-99999999999
|
|
|
|
LastModifiedDate
|
Last Modified Date
|
Mod Date
|
99/99/9999
|
|
|
|
LastModifiedTime
|
Last Modified Time
|
Mod Time
|
99999
|
|
|
|
LastModifiedUser
|
Last Modified User
|
Mod User
|
x(20)
|
|
|
|
ParentObject_ID
|
Parent Object
|
|
-99999999999
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
ActIdx
|
no
|
BankNumberIsActive
|
yes
|
no
|
|
|
BankAccForIdx
|
no
|
BankAccFormat_ID
|
yes
|
no
|
|
|
BankChargeIdx
|
no
|
BankNumberIsBankCharge
|
yes
|
no
|
|
|
BankChGLIdx
|
no
|
BankNumberBankChargeGL_ID
|
yes
|
no
|
|
|
BankNumberBranch
|
no
|
BankNumberBranch
|
yes
|
no
|
|
|
BankNumberFormat
|
no
|
BankNumberFormatted
|
yes
|
no
|
|
|
BankNumberIdx
|
no
|
BankNumber
|
yes
|
no
|
|
|
BankPayFormat
|
no
|
BankPayFormat_ID
|
yes
|
no
|
|
|
BusinessRelation
|
no
|
BankBusinessRelation_ID
|
yes
|
no
|
|
|
CurrencyIdx
|
no
|
Currency_ID
|
yes
|
no
|
|
|
DDocStatIdx
|
no
|
DDocumentStatus_ID
|
yes
|
no
|
|
|
DefIdx
|
no
|
BankNumberIsDefault
|
yes
|
no
|
|
|
KeyParentObject_id
|
no
|
ParentObject_ID
|
yes
|
no
|
|
|
KeyParentType
|
no
|
BankNumberParentType
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
BankNumber_ID
|
yes
|
no
|
|
|
UniqueLogicalKey
|
yes
|
BankNumber
|
yes
|
no
|
|
|
|
|
BankNumberExtension
|
yes
|
no
|
|
|
|
|
BankNumberValidation
|
yes
|
no
|
|
|
|
|
ParentObject_ID
|
yes
|
no
|
|
|
|
|
BankPayFormat_ID
|
yes
|
no
|
|
|
|
|
CompanySharedSet_ID
|
yes
|
no
|
|
|
ViewIndex
|
no
|
BankNumberIsActive
|
yes
|
no
|
|
|
|
|
BankNumber
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
BankNumber_ID
|
Link to BankNumber
|
|
-99999999999
|
|
|
|
BankNumberPayCode_ID
|
Record ID
|
|
-99999999999
|
|
|
|
BankNumberPayCodeSequence
|
Sequence
|
Seq
|
->,>>>,>>9
|
|
|
|
BankNumberPayCodeValue
|
Attribute Value
|
|
x(40)
|
|
|
|
LastModifiedDate
|
Last Modified Date
|
Mod Date
|
99/99/9999
|
|
|
|
LastModifiedTime
|
Last Modified Time
|
Mod Time
|
99999
|
|
|
|
LastModifiedUser
|
Last Modified User
|
Mod User
|
x(20)
|
|
|
|
PayFormatCode_ID
|
Description
|
|
-99999999999
|
|
|
|
PayFormatGroup_ID
|
Link to PayFormatGroup
|
|
-99999999999
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
BankNumber
|
no
|
BankNumber_ID
|
yes
|
no
|
|
|
FormGrpIdx
|
no
|
PayFormatGroup_ID
|
yes
|
no
|
|
|
FormIdx
|
no
|
PayFormatCode_ID
|
yes
|
no
|
|
|
KeySequence
|
no
|
BankNumberPayCodeSequence
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
BankNumberPayCode_ID
|
yes
|
no
|
|
|
UniqueIdx
|
yes
|
BankNumber_ID
|
yes
|
no
|
|
|
|
|
PayFormatGroup_ID
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
BankFileFormat_ID
|
Bank File Format Code
|
Bank File Format
|
-99999999999
|
|
|
|
BankNumber_ID
|
Bank Number
|
Bank Account No
|
-99999999999
|
|
|
|
BankPayFormat_ID
|
Record ID
|
|
-99999999999
|
|
|
|
BankPayFormatIsActive
|
Active
|
|
yes/no
|
|
|
|
BankPayFormatIsBankCharge
|
Bank Charge Applies
|
|
yes/no
|
|
|
|
BankPayFormatNextCheckNbr
|
Next Pre-Printed Number
|
Next Pre-Printed No
|
9999999999
|
|
|
|
LastModifiedDate
|
Last Modified Date
|
Mod Date
|
99/99/9999
|
|
|
|
LastModifiedTime
|
Last Modified Time
|
Mod Time
|
99999
|
|
|
|
LastModifiedUser
|
Last Modified User
|
Mod User
|
x(20)
|
|
|
|
PayFormatTypeCode
|
Payment Format
|
|
x(20)
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
BankNumber
|
no
|
BankNumber_ID
|
yes
|
no
|
|
|
FileFormat
|
no
|
BankFileFormat_ID
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
BankPayFormat_ID
|
yes
|
no
|
|
|
Type
|
no
|
PayFormatTypeCode
|
yes
|
no
|
|
|
UniqueIdx
|
yes
|
BankNumber_ID
|
yes
|
no
|
|
|
|
|
PayFormatTypeCode
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
BankState_ID
|
Record ID
|
|
-99999999999
|
|
|
|
BankStateBankImpRef
|
Bank Importing Reference
|
|
x(255)
|
|
|
|
BankStateClosingBalance
|
Closing Balance
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
BankStateInfo
|
Information
|
Info
|
x(2000)
|
|
|
|
BankStateMovement
|
Activity
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
BankStateNumber
|
Bank Statement No
|
|
x(20)
|
|
|
|
BankStateOpeningBalance
|
Opening Balance
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
BankStatePostingDate
|
Posting Date
|
|
99/99/9999
|
|
|
|
BankStateStatus
|
Status
|
|
x(20)
|
|
|
|
BankStateTransactionType
|
Transaction Type
|
|
x(20)
|
|
|
|
BankStateYear
|
Bank Statement Year
|
|
9999
|
|
|
|
Company_ID
|
Link to Company
|
|
-99999999999
|
|
|
|
Currency_ID
|
Currency Code
|
Curr
|
-99999999999
|
|
|
|
CustomCombo0
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo1
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo2
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo3
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo4
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo5
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo6
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo7
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo8
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo9
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomDate0
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate1
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate2
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate3
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate4
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDecimal0
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal1
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal2
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal3
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal4
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomInteger0
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger1
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger2
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger3
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger4
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomLong0
|
Custom Long Field
|
|
x(255)
|
|
|
|
CustomLong1
|
Custom Long Field
|
|
x(255)
|
|
|
|
CustomNote
|
Custom Note Field
|
|
x(2000)
|
|
|
|
CustomShort0
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort1
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort2
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort3
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort4
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort5
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort6
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort7
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort8
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort9
|
Custom Short Field
|
|
x(20)
|
|
|
|
GL_ID
|
GL Account
|
|
-99999999999
|
|
|
|
LastModifiedDate
|
Last Modified Date
|
Mod Date
|
99/99/9999
|
|
|
|
LastModifiedTime
|
Last Modified Time
|
Mod Time
|
99999
|
|
|
|
LastModifiedUser
|
Last Modified User
|
Mod User
|
x(20)
|
|
|
|
Period_ID
|
GL Calendar Year
|
GL Cal Year
|
-99999999999
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
BankStateNum
|
no
|
BankStateNumber
|
yes
|
no
|
|
|
BankStateStatus
|
no
|
BankStateStatus
|
yes
|
no
|
|
|
BankStateTransType
|
no
|
BankStateTransactionType
|
yes
|
no
|
|
|
BankStateYr
|
no
|
BankStateYear
|
yes
|
no
|
|
|
Company
|
no
|
Company_ID
|
yes
|
no
|
|
|
Currency
|
no
|
Currency_ID
|
yes
|
no
|
|
|
GL
|
no
|
GL_ID
|
yes
|
no
|
|
|
GLStatementNumYear
|
yes
|
Company_ID
|
yes
|
no
|
|
|
|
|
GL_ID
|
yes
|
no
|
|
|
|
|
BankStateYear
|
yes
|
no
|
|
|
|
|
BankStateNumber
|
yes
|
no
|
|
|
Period
|
no
|
Period_ID
|
yes
|
no
|
|
|
PostDateIdx
|
no
|
BankStatePostingDate
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
BankState_ID
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
BankState_ID
|
Link to BankState
|
|
-99999999999
|
|
|
|
BankStateAlloc_ID
|
Record ID
|
|
-99999999999
|
|
|
|
BankStateAllocAmountLC
|
BC Amount
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
BankStateAllocAmountTC
|
TC Allocated
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
BankStateAllocBankAmountLC
|
BC Bank Amount
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
BankStateAllocBankAmountTC
|
TC Bank Amt
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
BankStateAllocBankDiscLC
|
BC Bank Discount
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
BankStateAllocBankDiscTC
|
TC Bank Discount
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
BankStateAllocBankImpRef
|
Bank Importing Reference
|
|
x(255)
|
|
|
|
BankStateAllocBankRate
|
Accounting Rate
|
|
->,>>>,>>9.9999999999
|
10
|
|
|
BankStateAllocBankRteScale
|
Scale Factor
|
|
->,>>>,>>9.9999999999
|
10
|
|
|
BankStateAllocBankValDate
|
Rate Date
|
|
99/99/9999
|
|
|
|
BankStateAllocCCRate
|
SC Rate
|
|
->,>>>,>>9.9999999999
|
10
|
|
|
BankStateAllocCCScale
|
SC Rate Scale
|
|
->,>>>,>>9.9999999999
|
10
|
|
|
BankStateAllocDifferenceCC
|
SC Exch Rate Variance
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
BankStateAllocDifferenceLC
|
BC Difference
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
BankStateAllocDifferenceTC
|
TC Difference
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
BankStateAllocDiscountTC
|
TC Discount
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
BankStateAllocOpenBalTC
|
Open Balance TC
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
BankStateAllocPaidAmtTC
|
TC Paid Amount
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
BankStateAllocType
|
Allocation Type
|
|
x(20)
|
|
|
|
BankStateAllocWHTAmtCC
|
SC WHT Amount
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
BankStateAllocWHTAmtLC
|
BC WHT Amount
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
BankStateAllocWHTAmtTC
|
TC WHT Amount
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
BankStateAllocWHTCCRate
|
WHT SC Rate
|
|
->,>>>,>>9.9999999999
|
10
|
|
|
BankStateAllocWHTCCScale
|
WHT SC Scale
|
|
->,>>>,>>9.9999999999
|
10
|
|
|
BankStateAllocWHTLCRate
|
WHT BC Rate
|
|
->,>>>,>>9.9999999999
|
10
|
|
|
BankStateAllocWHTLCScale
|
WHT BC Scale
|
|
->,>>>,>>9.9999999999
|
10
|
|
|
BankStateAllocWHTPerc
|
WHT Percentage
|
|
->>9.99
|
2
|
|
|
BankStateAllocWHTTxFeeTC
|
TC WHT Taxable Fee
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
BankStateLine_ID
|
Link to BankStateLine
|
|
-99999999999
|
|
|
|
CCollection_ID
|
Link to CCollection
|
|
-99999999999
|
|
|
|
CInvoice_ID
|
Link to CInvoice
|
|
-99999999999
|
|
|
|
Company_ID
|
Link to Company
|
|
-99999999999
|
|
|
|
Currency_ID
|
Currency Code
|
Curr
|
-99999999999
|
|
|
|
DCollection_ID
|
Link to DCollection
|
|
-99999999999
|
|
|
|
DInvoice_ID
|
Link to DInvoice
|
|
-99999999999
|
|
|
|
LastModifiedDate
|
Last Modified Date
|
Mod Date
|
99/99/9999
|
|
|
|
LastModifiedTime
|
Last Modified Time
|
Mod Time
|
99999
|
|
|
|
LastModifiedUser
|
Last Modified User
|
Mod User
|
x(20)
|
|
|
|
Posting_ID
|
Link to Posting
|
|
-99999999999
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
AllocType
|
no
|
BankStateAllocType
|
yes
|
no
|
|
|
BankStateLine
|
no
|
BankStateLine_ID
|
yes
|
no
|
|
|
BankStIdx
|
no
|
BankState_ID
|
yes
|
no
|
|
|
CCollection
|
no
|
CCollection_ID
|
yes
|
no
|
|
|
CInvoice
|
no
|
CInvoice_ID
|
yes
|
no
|
|
|
CompanyIdx
|
no
|
Company_ID
|
yes
|
no
|
|
|
Currency
|
no
|
Currency_ID
|
yes
|
no
|
|
|
DCollection
|
no
|
DCollection_ID
|
yes
|
no
|
|
|
DInvoice
|
no
|
DInvoice_ID
|
yes
|
no
|
|
|
Posting
|
no
|
Posting_ID
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
BankStateAlloc_ID
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
BankState_ID
|
Link to BankState
|
|
-99999999999
|
|
|
|
BankStateAlloc_ID
|
Link to BankStateAlloc
|
|
-99999999999
|
|
|
|
BankStateAllocColl_ID
|
Record ID
|
|
-99999999999
|
|
|
|
BankStateAllocCollBankAmLC
|
BC Bank Amount
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
BankStateAllocCollBankAmTC
|
TC Bank Amt
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
BankStateAllocCollBankDate
|
Value Date
|
|
99/99/9999
|
|
|
|
BankStateAllocCollBankRate
|
Accounting Rate
|
|
->,>>>,>>9.9999999999
|
10
|
|
|
BankStateAllocCollCCRate
|
SC Rate
|
|
->,>>>,>>9.9999999999
|
10
|
|
|
BankStateAllocCollCCScale
|
SC Rate Scale
|
|
->,>>>,>>9.9999999999
|
10
|
|
|
BankStateAllocCollDiffCC
|
SC Exch Rate Difference
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
BankStateAllocCollDiffLC
|
BC Difference
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
BankStateAllocCollDiffTC
|
TC Difference
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
BankStateAllocCollIsAlloc
|
Allocated
|
|
yes/no
|
|
|
|
BankStateAllocCollRteScale
|
Scale Factor
|
|
->,>>>,>>9.9999999999
|
10
|
|
|
CDocument_ID
|
Supplier Payment Type
|
Supplier Pay Type
|
-99999999999
|
|
|
|
Company_ID
|
Link to Company
|
|
-99999999999
|
|
|
|
DDocument_ID
|
Supplier Payment Type
|
Supplier Pay Type
|
-99999999999
|
|
|
|
LastModifiedDate
|
Last Modified Date
|
Mod Date
|
99/99/9999
|
|
|
|
LastModifiedTime
|
Last Modified Time
|
Mod Time
|
99999
|
|
|
|
LastModifiedUser
|
Last Modified User
|
Mod User
|
x(20)
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
Alloc
|
no
|
BankStateAlloc_ID
|
yes
|
no
|
|
|
BankStdx
|
no
|
BankState_ID
|
yes
|
no
|
|
|
CDocument
|
no
|
CDocument_ID
|
yes
|
no
|
|
|
CompanyIdx
|
no
|
Company_ID
|
yes
|
no
|
|
|
DDocument
|
no
|
DDocument_ID
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
BankStateAllocColl_ID
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
BankStateImport_ID
|
Record ID
|
|
-99999999999
|
|
|
|
BankStateImportDate
|
Date
|
|
99/99/9999
|
|
|
|
BankStateImportFile
|
Source File Name
|
|
x(255)
|
|
|
|
BankStateImportFolder
|
Source Folder Path
|
|
x(255)
|
|
|
|
BankStateImportTime
|
Time
|
|
->,>>>,>>9
|
|
|
|
BankStateImportType
|
Import File Format
|
Format
|
x(20)
|
|
|
|
Company_ID
|
Link to Company
|
|
-99999999999
|
|
|
|
LastModifiedDate
|
Last Modified Date
|
Mod Date
|
99/99/9999
|
|
|
|
LastModifiedTime
|
Last Modified Time
|
Mod Time
|
99999
|
|
|
|
LastModifiedUser
|
Last Modified User
|
Mod User
|
x(20)
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
Usr_ID
|
User
|
|
-99999999999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
Company
|
yes
|
Company_ID
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
BankStateImport_ID
|
yes
|
no
|
|
|
Usr
|
no
|
Usr_ID
|
yes
|
no
|