|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
AbsorbedCreditNVatGroup_ID
|
Tax Group Code
|
|
9999999999
|
|
|
|
AbsorbedInvoiceVatGroup_ID
|
Tax Group Code
|
|
9999999999
|
|
|
|
CreditNoteGLProfile_ID
|
CN GL Profile
|
|
9999999999
|
|
|
|
CreditNoteVatGroup_ID
|
Credit Note Tax Group
|
|
9999999999
|
|
|
|
CreditVoucherVatGroup_ID
|
Tax Group Code
|
|
9999999999
|
|
|
|
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)
|
|
|
|
DelayedGLProfile_ID
|
Delayed GL Profile
|
|
9999999999
|
|
|
|
InvoiceGLProfile_ID
|
Invoice GL Profile
|
|
9999999999
|
|
|
|
InvoiceVatGroup_ID
|
Invoice Tax Group
|
|
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)
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
RetainCVoucherVatGroup_ID
|
Tax Group Code
|
|
9999999999
|
|
|
|
RetainVoucherVatGroup_ID
|
Tax Group Code
|
|
9999999999
|
|
|
|
Vat_ID
|
Link to Vat
|
|
9999999999
|
|
|
|
VatPercent_ID
|
Tax Percentage
|
|
9999999999
|
|
|
|
VatRule_ID
|
Record ID
|
|
9999999999
|
|
|
|
VatRuleBaseFull
|
Base/Full
|
|
x(20)
|
|
|
|
VatRuleDelayCorrection
|
Delay Correction
|
|
9
|
|
|
|
VatRuleDescription
|
Description
|
|
x(40)
|
|
|
|
VatRuleIsDelayed
|
Delayed
|
|
yes/no
|
|
|
|
VatRuleIsPassBaseValue
|
Base Value
|
|
yes/no
|
|
|
|
VatRuleIsPosting
|
Posting
|
|
yes/no
|
|
|
|
VatRuleMovementType
|
Activity Type
|
|
x(20)
|
|
|
|
VatRuleOperator
|
Operator
|
Opr
|
x(1)
|
|
|
|
VatRuleRef1
|
Reference 1
|
Ref 1
|
x(20)
|
|
|
|
VatRuleRef2
|
Reference 2
|
Ref 2
|
x(20)
|
|
|
|
VatRuleRounding
|
Rounding
|
|
x(20)
|
|
|
|
VatRuleSequence
|
Sequence
|
Seq
|
->,>>>,>>9
|
|
|
|
VatRuleUsage
|
Usage
|
|
x(20)
|
|
|
|
VatRuleValue
|
Value
|
|
->>,>>>,>>>,>>9.9999
|
4
|
|
|
VoucherVatGroup_ID
|
Tax Group Code
|
|
9999999999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
AbsCNVatGrpIdx
|
no
|
AbsorbedCreditNVatGroup_ID
|
yes
|
no
|
|
|
AbsInvVatGrpIdx
|
no
|
AbsorbedInvoiceVatGroup_ID
|
yes
|
no
|
|
|
BaseFull
|
no
|
VatRuleBaseFull
|
yes
|
no
|
|
|
CreditNoteGLProfile
|
no
|
CreditNoteGLProfile_ID
|
yes
|
no
|
|
|
CreditNoteVatGroup
|
no
|
CreditNoteVatGroup_ID
|
yes
|
no
|
|
|
CredVatGrpIdx
|
no
|
CreditVoucherVatGroup_ID
|
yes
|
no
|
|
|
DiscountGLProfile
|
no
|
DelayedGLProfile_ID
|
yes
|
no
|
|
|
InvoiceGLProfileIdx
|
no
|
InvoiceGLProfile_ID
|
yes
|
no
|
|
|
InvoiceVatGroup
|
no
|
InvoiceVatGroup_ID
|
yes
|
no
|
|
|
LogicalKeyUniqueIdx
|
yes
|
VatRuleBaseFull
|
yes
|
no
|
|
|
|
|
VatRuleSequence
|
yes
|
no
|
|
|
|
|
Vat_ID
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
VatRule_ID
|
yes
|
no
|
|
|
RetCNVatGrpIdx
|
no
|
RetainCVoucherVatGroup_ID
|
yes
|
no
|
|
|
RetInvVatGrpIdx
|
no
|
RetainVoucherVatGroup_ID
|
yes
|
no
|
|
|
Vat
|
no
|
Vat_ID
|
yes
|
no
|
|
|
VatPercIdx
|
no
|
VatPercent_ID
|
yes
|
no
|
|
|
VoucherVatGrpIdx
|
no
|
VoucherVatGroup_ID
|
yes
|
no
|