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