Specification for RECOUNT_AND_NP_DISBURSEMENTS

FIELD DESCRIPTION	TYPE	REQUIRED	SAMPLE DATA	VALUE REFERENCE	RULE REFERENCE	FIELD FORM ASSOCIATION	VALIDATION RULES
REPORT TYPE	A/N-100						type: string max length: 5
FORM TYPE	A/N-8	X (error)	SB29	SB29	If Transaction Type is RECOUNT_ACCOUNT_DISBURSEMENT or NATIONAL_PARTY_RECOUNT_ACCOUNT_DISBURSEMENT, then Form Type is SB29 If Transaction Type is NATIONAL_PARTY_HEADQUARTERS_ACCOUNT_DISBURSEMENT or NATIONAL_PARTY_CONVENTION_ACCOUNT_DISBURSEMENT, then Form Type is SB21B		FORM_TYPE = 'SB29' if TRANSACTION_TYPE_IDENTIFIER one of ['RECOUNT_ACCOUNT_DISBURSEMENT', 'NATIONAL_PARTY_RECOUNT_ACCOUNT_DISBURSEMENT'] FORM_TYPE = 'SB21B' if TRANSACTION_TYPE_IDENTIFIER one of ['NATIONAL_PARTY_HEADQUARTERS_ACCOUNT_DISBURSEMENT', 'NATIONAL_PARTY_CONVENTION_ACCOUNT_DISBURSEMENT'] REQUIRED must be one of: ['SB29', 'SB21B']
FILER COMMITTEE ID NUMBER	A/N-9	X (error)	C00123456				REQUIRED type: string min length: 9 max length: 9 regex: ^(?:[PC][0-9]{8}|[HS][0-9]{1}[A-Z]{2}[0-9]{5})$
TRANSACTION TYPE IDENTIFIER	A/N-12	X (error)	SB29	SB29	RECOUNT_ACCOUNT_DISBURSEMENT NATIONAL_PARTY_RECOUNT_ACCOUNT_DISBURSEMENT NATIONAL_PARTY_HEADQUARTERS_ACCOUNT_DISBURSEMENT NATIONAL_PARTY_CONVENTION_ACCOUNT_DISBURSEMENT		REQUIRED must be one of: ['RECOUNT_ACCOUNT_DISBURSEMENT', 'NATIONAL_PARTY_RECOUNT_ACCOUNT_DISBURSEMENT', 'NATIONAL_PARTY_HEADQUARTERS_ACCOUNT_DISBURSEMENT', 'NATIONAL_PARTY_CONVENTION_ACCOUNT_DISBURSEMENT']
TRANSACTION ID	A/N-20	X (error)	B56123456789-1234		must be unique for the life of the report (original + all amendments)		REQUIRED type: string min length: 1 max length: 20 regex: ^[ -~]{0,20}$
BACK REFERENCE TRAN ID NUMBER	A/N-20		B123456789-1234		Reference to the Tran ID of a Related Record		type: ['string', 'null'] min length: 0 max length: 20 regex: ^[ -~]{0,20}$
BACK REFERENCE SCHED NAME	A/N-8		SB21	SB[line# ref]	Ref to the Schedule that has the Related Record. SB3L must be used with the F3L		type: ['string', 'null'] min length: 0 max length: 8 regex: ^[ -~]{0,8}$
ENTITY TYPE	A/N-3	X (error)	IND	[IND|ORG|COM]	[IND|ORG|COM]		REQUIRED must be one of: ['IND', 'ORG', 'COM']
PAYEE ORGANIZATION NAME	A/N-200	X (conditional error)	John Smith & Co.		Required if [ORG|COM]		REQUIRED if ENTITY_TYPE one of ['ORG', 'COM'] type: ['string', 'null'] min length: 0 max length: 200 regex: ^[ -~]{0,200}$
PAYEE LAST NAME	A/N-30	X (conditional error)	Smith		Required if [IND]		REQUIRED if ENTITY_TYPE equals IND type: ['string', 'null'] min length: 0 max length: 30 regex: ^[ -~]{0,30}$
PAYEE FIRST NAME	A/N-20	X (conditional error)	John		Required if [IND]		REQUIRED if ENTITY_TYPE equals IND type: ['string', 'null'] min length: 0 max length: 20 regex: ^[ -~]{0,20}$
PAYEE MIDDLE NAME	A/N-20		W				type: ['string', 'null'] min length: 0 max length: 20 regex: ^[ -~]{0,20}$
PAYEE PREFIX	A/N-10		Dr				type: ['string', 'null'] min length: 0 max length: 10 regex: ^[ -~]{0,10}$
PAYEE SUFFIX	A/N-10		Jr				type: ['string', 'null'] min length: 0 max length: 10 regex: ^[ -~]{0,10}$
PAYEE STREET 1	A/N-34	X (error)	Suite 16				REQUIRED type: string min length: 1 max length: 34 regex: ^[ -~]{0,34}$
PAYEE STREET 2	A/N-34		30 Oak Street				type: ['string', 'null'] min length: 0 max length: 34 regex: ^[ -~]{0,34}$
PAYEE CITY	A/N-30	X (error)	Springfield				REQUIRED type: string min length: 1 max length: 30 regex: ^[ -~]{0,30}$
PAYEE STATE	A/N-2	X (error)	MA				REQUIRED type: string min length: 1 max length: 2 regex: ^[ -~]{0,2}$
PAYEE ZIP	A/N-9	X (error)	1012				REQUIRED type: string min length: 1 max length: 9 regex: ^[ -~]{0,9}$
EXPENDITURE DATE	NUM-8	X (error)	20120720	YYYYMMDD			REQUIRED type: string min length: 10 regex: ^[0-9]{4}-[0-9]{2}-[0-9]{2}$
EXPENDITURE AMOUNT	AMT-12	X (error)	1500				REQUIRED type: number minimum: -99999999.99 maximum: 999999999.99
AGGREGATE AMOUNT	AMT-12	X (error)	1000				REQUIRED type: number minimum: -99999999.99 maximum: 999999999.99
AGGREGATION GROUP	A/N-100	X (error)	GENERAL_DISBURSEMENT		GENERAL_DISBURSEMENT		REQUIRED must equal: GENERAL_DISBURSEMENT
EXPENDITURE PURPOSE DESCRIP	A/N-100	X (error)			If Transaction Type is RECOUNT_ACCOUNT_DISBURSEMENT then EPD is ‘Recount Account: XX, where XX is user entered text If Transaction Type is NATIONAL_PARTY_RECOUNT_ACCOUNT_DISBURSEMENT then EPD is ‘Recount/Legal Proceedings Account: XX, where XX is user entered text If Transaction Type is NATIONAL_PARTY_HEADQUARTERS_ACCOUNT_DISBURSEMENT then this is ‘Headquarters Buildings Account: XX’, where XX is user entered text If Transaction Type is NATIONAL_PARTY_CONVENTION_ACCOUNT_DISBURSEMENT then this is ‘Pres. Nominating Convention Account: XX’, where XX is user entered text		EXPENDITURE_PURPOSE_DESCRIP must match ^Recount Account: [ -~]{0,83}$ if TRANSACTION_TYPE_IDENTIFIER equals RECOUNT_ACCOUNT_DISBURSEMENT EXPENDITURE_PURPOSE_DESCRIP must match ^Recount/Legal Proceedings Account: [ -~]{0,65}$ if TRANSACTION_TYPE_IDENTIFIER equals NATIONAL_PARTY_RECOUNT_ACCOUNT_DISBURSEMENT EXPENDITURE_PURPOSE_DESCRIP must match ^Headquarters Buildings Account: [ -~]{0,68}$ if TRANSACTION_TYPE_IDENTIFIER equals NATIONAL_PARTY_HEADQUARTERS_ACCOUNT_DISBURSEMENT EXPENDITURE_PURPOSE_DESCRIP must match ^Pres. Nominating Convention Account: [ -~]{0,63}$ if TRANSACTION_TYPE_IDENTIFIER equals NATIONAL_PARTY_CONVENTION_ACCOUNT_DISBURSEMENT REQUIRED type: string min length: 1 max length: 100
CATEGORY CODE	A/N-3		1	001, 002, ... 012	Only codes 001-012		type: ['string', 'null'] must be one of: ['001', '002', '003', '004', '005', '006', '007', '008', '009', '010', '011', '012', None]
MEMO CODE	A/N-1			X	X = True		type: ['boolean', 'null']
MEMO TEXT/DESCRIPTION	A/N-100						type: ['string', 'null'] min length: 0 max length: 100 regex: ^[ -~]{0,100}$
REATTRIBUTION REDESIGNATION TAG	A/N-20		REATTRIBUTED				must be one of: ['REATTRIBUTED', 'REDESIGNATED', 'REATTRIBUTION_FROM', 'REATTRIBUTION_TO', 'REDESIGNATION_FROM', 'REDESIGNATION_TO', None]