Specification for DISBURSEMENT_MEMOS

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)	SB21B	SB[line# ref]	If Transaction Type is 'OPERATING_EXPENDITURE_CREDIT_CARD_PAYMENT_MEMO' or 'OPERATING_EXPENDITURE_STAFF_REIMBURSEMENT_MEMO' or 'OPERATING_EXPENDITURE_PAYMENT_TO_PAYROLL_MEMO' then Form type is SB21B; If Transaction Type is 'OTHER_DISBURSEMENT_CREDIT_CARD_PAYMENT_MEMO' or 'OTHER_DISBURSEMENT_STAFF_REIMBURSEMENT_MEMO' or 'OTHER_DISBURSEMENT_PAYMENT_TO_PAYROLL_MEMO' then Form Type is SB29.	F3 | F3X | F3P | F3L	FORM_TYPE = 'SB21B' if TRANSACTION_TYPE_IDENTIFIER one of ['OPERATING_EXPENDITURE_CREDIT_CARD_PAYMENT_MEMO', 'OPERATING_EXPENDITURE_STAFF_REIMBURSEMENT_MEMO', 'OPERATING_EXPENDITURE_PAYMENT_TO_PAYROLL_MEMO'] FORM_TYPE = 'SB29' if TRANSACTION_TYPE_IDENTIFIER one of ['OTHER_DISBURSEMENT_CREDIT_CARD_PAYMENT_MEMO', 'OTHER_DISBURSEMENT_STAFF_REIMBURSEMENT_MEMO', 'OTHER_DISBURSEMENT_PAYMENT_TO_PAYROLL_MEMO'] REQUIRED must be one of: ['SB21B', 'SB29']
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)	OPERATING_EXPENDITURE_CREDIT_CARD_PAYMENT_MEMO		OPERATING_EXPENDITURE_CREDIT_CARD_PAYMENT_MEMO, OTHER_DISBURSEMENT_CREDIT_CARD_PAYMENT_MEMO, OPERATING_EXPENDITURE_STAFF_REIMBURSEMENT_MEMO, OTHER_DISBURSEMENT_STAFF_REIMBURSEMENT_MEMO, OPERATING_EXPENDITURE_PAYMENT_TO_PAYROLL_MEMO, OTHER_DISBURSEMENT_PAYMENT_TO_PAYROLL_MEMO		REQUIRED must be one of: ['OPERATING_EXPENDITURE_CREDIT_CARD_PAYMENT_MEMO', 'OTHER_DISBURSEMENT_CREDIT_CARD_PAYMENT_MEMO', 'OPERATING_EXPENDITURE_STAFF_REIMBURSEMENT_MEMO', 'OTHER_DISBURSEMENT_STAFF_REIMBURSEMENT_MEMO', 'OPERATING_EXPENDITURE_PAYMENT_TO_PAYROLL_MEMO', 'OTHER_DISBURSEMENT_PAYMENT_TO_PAYROLL_MEMO']
TRANSACTION ID	A/N-20	X (error)	B56123456789-1234		must be unique for the life of the report (original + all amendments)	F3 | F3X | F3P | F3L	REQUIRED type: string min length: 1 max length: 20 regex: ^[ -~]{0,20}$
BACK REFERENCE TRAN ID NUMBER	A/N-20	X (error)	B123456789-1234		Reference to the Tran ID of a Related Record	F3 | F3X | F3P | F3L	REQUIRED type: string min length: 1 max length: 20 regex: ^[ -~]{0,20}$
BACK REFERENCE SCHED NAME	A/N-8	X (error)	SB21	SB[line# ref]	Ref to the Schedule that has the Related Record. SB3L must be used with the F3L	F3 | F3X | F3P | F3L	REQUIRED type: string min length: 1 max length: 8 regex: ^[ -~]{0,8}$
ENTITY TYPE	A/N-3	X (error)	IND	ORG, IND, COM	[ORG|IND|COM]		REQUIRED must be one of: ['ORG', 'IND', 'COM']
PAYEE ORGANIZATION NAME	A/N-200	X (conditional error)	John Smith & Co.		Required if [ORG|COM]	F3 | F3X | F3P | F3L	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]	F3 | F3X | F3P | F3L	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]	F3 | F3X | F3P | F3L	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		Optional if [IND]	F3 | F3X | F3P | F3L	type: ['string', 'null'] min length: 0 max length: 20 regex: ^[ -~]{0,20}$
PAYEE PREFIX	A/N-10		Dr		Optional if [IND]	F3 | F3X | F3P | F3L	type: ['string', 'null'] min length: 0 max length: 10 regex: ^[ -~]{0,10}$
PAYEE SUFFIX	A/N-10		Jr		Optional if [IND]	F3 | F3X | F3P | F3L	type: ['string', 'null'] min length: 0 max length: 10 regex: ^[ -~]{0,10}$
PAYEE STREET 1	A/N-34	X (error)	Suite 16			F3 | F3X | F3P | F3L	REQUIRED type: string min length: 1 max length: 34 regex: ^[ -~]{0,34}$
PAYEE STREET 2	A/N-34		30 Oak Street			F3 | F3X | F3P | F3L	type: ['string', 'null'] min length: 0 max length: 34 regex: ^[ -~]{0,34}$
PAYEE CITY	A/N-30	X (error)	Springfield			F3 | F3X | F3P | F3L	REQUIRED type: string min length: 1 max length: 30 regex: ^[ -~]{0,30}$
PAYEE STATE	A/N-2	X (error)	MA			F3 | F3X | F3P | F3L	REQUIRED type: string min length: 1 max length: 2 regex: ^[ -~]{0,2}$
PAYEE ZIP	A/N-9	X (error)	1012			F3 | F3X | F3P | F3L	REQUIRED type: string min length: 1 max length: 9 regex: ^[ -~]{0,9}$
EXPENDITURE DATE	NUM-8	X (error)	20120720	YYYYMMDD		F3 | F3X | F3P	REQUIRED type: string min length: 10 regex: ^[0-9]{4}-[0-9]{2}-[0-9]{2}$
EXPENDITURE AMOUNT	AMT-12	X (error)	1500		If Transaction Type is OPERATING_EXPENDITURE_VOID or OTHER_DISBURSEMENT_VOID, amount must be negative.	F3 | F3X | F3P | F3L	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)				F3 | F3X | F3P	REQUIRED type: string min length: 1 max length: 100 regex: ^[ -~]{0,100}$
CATEGORY CODE	A/N-3		1	001, 002, ... 012	Only codes 001-012	F3 | F3X | F3P	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 (error)		X	X = True	F3 | F3X | F3P | F3L	REQUIRED type: boolean must equal: True
MEMO TEXT/DESCRIPTION	A/N-100					F3 | F3X | F3P | F3L	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]