TABLE DETAIL REFERENCE: Form1099CategoryAccountMapping
(USA VERSION)
FIELD NAME TYPE TYPENAME LENGTH QUERYABLE UPDATEABLE INSERTABLE REQUIRED
ON INSERT
VALIDATE RELATES TO
ID4 INTEGER 4TrueFalseFalseFalseSeqNo
IsFiling1099Misc-7 BIT 1TrueTrueFalseFalse
1
0
true
false
FormType12 VARCHAR 159TrueTrueFalseFalse%s
Form1099CategoryAccountMappingCategory12 VARCHAR 23TrueTrueFalseFalse
BOX1
BOX2
BOX3
BOX4
BOX5
BOX6
BOX7
BOX8
BOX9
BOX10
BOX13
BOX14
BOX15
Form1099CategoryAccountMappingAccountRefListID12 VARCHAR 36TrueTrueFalseFalse%s Yes
Form1099CategoryAccountMappingAccountRefFullName12 VARCHAR 159TrueTrueFalseFalse%s Yes
Form1099CategoryAccountMappingForceMapping-7 BIT 1TrueTrueFalseFalse
1
0
true
false
Form1099CategoryAccountMappingThreshold3 DECIMAL 17TrueTrueFalseFalse%10.2f
FQPrimaryKey12 VARCHAR 256TrueFalseFalseFalseFQPrimaryKey