tbl1_ImportedDataReformatted_PU_ff¶
- Description
temp table used by used by form fit program for reformatted data in the payment upload function
- Footnote
nobody is using this program now, so debatable whether to maintain this
Columns¶
supplier_inv_no tinytext DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
vendor_add1 tinytext DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
vendor_add2 tinytext DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
vendor_add3 tinytext DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
CITY tinytext DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
state tinytext DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
ZIP tinytext DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
Country tinytext DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
vendor_id tinytext DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
vendor_name tinytext DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
acct_desc tinytext DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
priority tinytext DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
inv_desc tinytext DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
amt tinytext DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
string_ind tinytext DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
unit tinytext DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
division tinytext DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
organization tinytext DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
location tinytext DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
fund_type tinytext DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
business_line tinytext DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
natural_account tinytext DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
activity tinytext DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
intra_unit tinytext DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
future tinytext DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
ru_initiative tinytext DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
project_id tinytext DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
task tinytext DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
expenditure_type tinytext DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
expenditure_org tinytext DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
location2 tinytext DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
business_line2 tinytext DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
activity2 tinytext DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
ru_initiative2 tinytext DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
s_s tinytext DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
id int(11) NOT NULL AUTO_INCREMENT
- Options
display="true", null="true", search="false", type=""
last_change timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
- Options
display="true", null="true", search="false", type=""