-- Insert into the TAXRETURNDIR Table
-- Taxpayer


INSERT INTO TAXRETURNDIR
(FILEID,DATE_CREATED,DATE_LAST_UPDATED,DATE_LAST_ACCESSED,USER_CREATED,USER_OWNER,TAXPAYER_ID,sTAXPAYER_NAME,DOC_TYPE,TAX_YEAR)
VALUES
('RETURN00001','5/17/2011','5/17/2011','5/17/2011','PRSOFT','PRSOFT','123-45-6789','DAVID TEST','1040EZ','2010');


/* COLUMNS
FILEID Unique descriptor that you create
DATE_CREATED Date the return was created
DATE_LAST_UPDATED Date the return was last modified
DATE_LAST_ACCESSED Date the return was last accessed
USER_CREATED The database user created the return
USER_OWNER The database user that owns the return
TAXPAYER_ID The Taxpayer ID (SSN)
sTAXPAYER_NAME The Taxpayer Name
DOC_TYPE The type of Return
TAX_YEAR The tax year
*/



/**********************************************
F1040 TABLE
1. This is the 1040 table the
2. THere must be an entry in the TAXRETURNDIR table
3. Match on the FILEID field

************************************************/

INSERT INTO F1040
(
TKEY,FILEID,m1250,m0750,state0087,ssn0010,r0060A,m0820,
zip0087,s0083,r0060,m0915,m0375,s1465B,s0080,rb1263,
m1160,m1256,r9000,r9020,rb0110,s1322,m0815 )

VALUES
(
'0','RETURN00100','. 1200','. 35000','.VA',
'.123-45-6789','.David Test','. 26050','.TEST',
'.12345','.Test City','. 3493','. 35000',
'.NO Bank Product','.1234 Test RD','.X','. 1200',
'. 3493','.David','.Test','.X','.Professional Tester',
'. 8950'
);


/*
IMPORTANT COLUMNS
TKEY This is used for
FILEID This must match the FILEID in the TAXRETURNDIR Table
rbFS1
m0789A
m0167
m0130
mTEI
m0355
r0060B
m1250 Line 10 of 1040EZ
m0789
m0810
m0750 Line 4 of 1040EZ
state0087 Residence state
ssn0010 Primary Social Security Number
r0060A Primary Full Name
m0820 Line 6 of 1040EZ
mEI
s0050
zip0087 Primary Zipcode
s0083 Primary Street Address
r0060 Primary Full Name
m0915
m0375 Line 1 of 1040EZ
m0770
s1465B
s0080 Primary City
rb1263 Line 13 of 1040EZ
m1290
rbXML
m1150
m1160 Line 7 of 1040EZ
m1256 Line 11 of 1040EZ
r9000 Tax payer first name
r9020 Tax payer last name
rb0110 Primary Campaign Election Box
s1322 Primary Tax payer Occupation
rb9908
rb0160
m0815 Line 5 of 1040EZ

*/



/****************************************************

FW2 TABLE
1. This table contains the W2 information
2. This columns correspond to fields on the W2 Form

*****************************************************/



INSERT INTO FW2
(
TKEY,FILEID,m0120,rbT,s0085,m0160,m0130,m0170,state0113,r0070,ch0590,r9998,r9997,rb0269,r0060,state0073,zip0073,m0140
,ein0040,r0050,m0150,s0045,ssn0035,r0090,r0100,r0110,zip0113
)
VALUES
(
'0','RETURN0100','. 35000','.X','.123456','. 35000','. 1200','. 508','.TN',
'.SOME CITY','.S standard W-2', '.Testing Corp','.https://www.taxsoftware.com/btax2010/dw-2/fw_2.html', '.1',
'.1211 Test that Software Street','.TN','.12344','. 35000','.12-345673339','.Tony Tiger Software',
'. 2170', '.CORP','.123-45-6789', '.DAVID TEST','.1234 Test Lane','.Testville','.12345'
);


/*
IMPORTANT COLUMNS

TKEY, Sequential code (0...N) representing the number of W2s
FILEID, This must match the FILEID in the TAXRETURNDIR Table
m0120,
rbT,
s0085,
m0160,
m0130,
m0170,
state0113,
r0070,
ch0590,
r9998,
r9997,
rb0269,
r0060,
state0073, State
zip0073, Zipcode
m0140
ein0040, Employer EIN
r0050,
m0150,
s0045,
ssn0035, Taxpayer SSN
r0090,
r0100,
r0110,
zip0113 ZIPCODE













--This is the Taxpayer basic information table


INSERT INTO BTAXPROPS(FILEID,VALUE,TKEY) VALUES('RETURN00001','2010','chTaxYear');
INSERT INTO BTAXPROPS(FILEID,VALUE,TKEY) VALUES('RETURN00001','.123-45-6789','einCOID');
INSERT INTO BTAXPROPS(FILEID,VALUE,TKEY) VALUES('RETURN00001','.10101 Stanford LN','rCOADD1');
INSERT INTO BTAXPROPS(FILEID,VALUE,TKEY) VALUES('RETURN00001','.Rockland','rCOCITY');
INSERT INTO BTAXPROPS(FILEID,VALUE,TKEY) VALUES('RETURN00001','.JEFF TEST','rCONAME');
INSERT INTO BTAXPROPS(FILEID,VALUE,TKEY) VALUES('RETURN00001','.irsefile@prsoft.com','rEMAIL');
INSERT INTO BTAXPROPS(FILEID,VALUE,TKEY) VALUES('RETURN00001','.TN','stateCOSTZ');
INSERT INTO BTAXPROPS(FILEID,VALUE,TKEY) VALUES('RETURN00001','.12121','zipCOSTZ');